Login

[Unknown] · 06-16-2003, 12:54 AM

I only mentioned it for creditabilities' sake. Maybe I shouldn't have.

I wasn't "pimping" anything.

Ninkazu, vBulletin themes aren't that hard to write... just lots of complicated variables. They're stored in the database though - so it's fun. PM me if you want me to give you a few words on them.

[edit - could be considered "pimping"]

Quote:Ya, I used to like phpBB, I still do somewhat because of its new message system. Invision board tends to show forums still have new items even when you've read them all o_O

That's what I like most about YaBB SE vs. other forums. It stores whether or not you have read a thread - seen a board. That way, even if I come back to a YaBB SE forum tommorow, I can read threads a I missed today.

And, seph, I looked on google for this "NeoForum" you speak of. I've never heard of it and neither has Google.... unless you mean the hacking group. At least a search for YaBB SE gets results Tongue

.
[/could be considered "pimping"]

Anyway, as to actual database design...

You want a users table, posts table, topics table, and boards table.
Have an id on each, like user_id, post_id, topic_id, board_id. That'll be what you need to link them together.

So, posts will have user_id (the poster), post_id (the post), topic_id (the topic), time (time of post), and post. (the message itself.)
Topics would then have a title, board_id (board it's in), post_id (first post), last_post_id (the last post in the topic), user_id (first poster), last_user_id (last posts' poster) and problem update_time (last time the thread was posted in/edited/etc.)
Boards would need a title, description, order, last_topic_id maybe, whatever.

Take a look at the schemas of some forums for more information.
[/edit]

-[Unknown]

L_O_J · 06-16-2003, 12:50 PM

Thanks to all of you who reply to my post Big Grin

anyway i have a few more question, so would you guys pls answer it again for me ? :lol:

1. I wanna create a simpla forum (I mean not asa big as this forum) so is Access .mdb will be enough ? :???:

2. about IIS can i installed it on win98 or it can only be installed on NT/XP/2000 or above ? :???:

3. I always hear people saying about PHP is good and ASP is bad or I dont like ASP and all other stuff that make ASP like a total crap. I wonder why most ppl dont like ASP ,is it because ASP is made by Microsoft who is a comercial and closed source software company and PHP is not. :???:

[Unknown] · 06-17-2003, 01:36 AM

Quote:Thanks to all of you who reply to my post

anyway i have a few more question, so would you guys pls answer it again for me ? :lol:

Always glad to help.

Quote:1. I wanna create a simpla forum (I mean not asa big as this forum) so is Access .mdb will be enough ? :???:

Access just doesn't cut it for me, at least. I would use MySQL. You'll find it's easier to manage than you think...

Quote:2. about IIS can i installed it on win98 or it can only be installed on NT/XP/2000 or above ? :???:

You can install a watered down version, called Personal Web Server, from your install disks. (maybe only 98 SE - it's available from microsoft.com though.)

Quote:3. I always hear people saying about PHP is good and ASP is bad or I dont like ASP and all other stuff that make ASP like a total crap. I wonder why most ppl dont like ASP ,is it because ASP is made by Microsoft who is a comercial and closed source software company and PHP is not. :???:

Have you actually used ASP? It's very basic, limiting, and really just sucks. Try PHP. It's like.... if you thought C++ was faster, better, and stronger than GW-BASIC.... you haven't seen anything.

Perl is also a good language, but it's too complicated for the beginner. I really recommend PHP over ASP, however, for a beginner.

Why not try PHP before you discount it as "only better because it's open source."

-[Unknown]

Zack · 06-17-2003, 01:44 AM

AH, IIS is available free on the MS website, and it sucks.
If you can figure out Apache, then take a bow...otherwise, Xitami is the only good server.

toonski84 · 06-17-2003, 01:55 AM

Every good server in the world has a copy of perl and a copy of PHP on it. This is because besides being free, they are easy, fast and reliable. I'd have to disagree with unknown though about perl being harder for beginners, being a perl user myself who struggles with php. i think it's one of those type-x type-y people kind of deals. They're so similar and widespread though, so it doesnt matter.

Zack · 06-17-2003, 03:39 AM

I'm in the same situation, Toonski. I'm just learning the basics of Perl, and it seems very easy...I tried PHP, and couldn't grasp it.

pr0gger · 06-17-2003, 04:52 AM

*grumbles about not having perl on his webspace*

[Unknown] · 06-17-2003, 09:52 AM

Well, PHP has better documentation. It's easier to learn because it's easier to get into. It also looks a LOT like Perl.

For example:

Code:
print "<html>

<head>

   <title>Hi</title>

</head>

<body>

   Hi!

</body>

</html>";

Iif you need any help there are tons of places to look...

-[Unknown]

oracle · 06-17-2003, 10:49 AM

*agrees with toonski* but I'm a PHPer. Everyone work out Apache.

toonski84 · 06-17-2003, 11:18 AM

Rebuttals! Yay!
Zack - PHP isnt as hard as you think. I've written a few scripts for it, and it gets better with practice. I'm just too hopelessly hooked on Perl to want to start over.

pr0gger - I said every good server Wink

[Unknown] - Perl has excellent documentation, with tutorials, individual function details and more included with it. Check it out at http://www.perldoc.com, or even i've got a copy at http://www.qb45.net/perl.

oracle - You're the man. Hey, you interested in partaking in writing a content manager for qb45?

Login
Username:
Password:	Lost Password?
	Remember me