Jump to content

Recommended Posts

Well i made a forum that is a simple one, but i want to make one that is very simple.. Well i am learning php, i am willing for some one to help me as much as they want.. And i have read a tutorial.. Well this forum is more or less needed for my free hosting script (mojo-panel.com) so people can have a support forum for people to get help when people download my script and set it up..etc... You get me

This is what i ended up with (i found a tutorial) {http://punbber.com/Tutorials/mojopanel%20-%20simple%20forum%20script/}. all i need is for some one to help me make it into catogorys, so people are not having to go through loads of pages.

Well, you'll need separate forums, which can be achieved by having a forum column in your topics table.  Then, you'll show a list of the forums (stored in a separate table for normalization).  Once a user clicked on a category, it would show only posts of that category.  When creating a thread, the thread would be in the category under which it was created.

 

 

I don't know what your current table schema looks like, but I would do something pretty much like this:

 

 

CREATE TABLE users (

    user_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

    user_name varchar(64),

    user_password char(32) --md5'd

);

 

CREATE INDEX idx_user_name ON users(user_name);

 

CREATE TABLE forums (

    forum_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

    forum_name varchar(255),

    forum_description varchar(255)

    --You would probably want other columns

);

 

 

CREATE TABLE posts (

    post_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

    post_title varchar(255),

    post_content text

    user_id INT NOT NULL,

    forum_id INT NOT NULL

    --you would of course have other columns

);

 

 

 

See how it would all map together?

 

 

I'm assuming you can do the PHP part since you've managed to make a free hosting script.

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.