PHPBuilder forum

christer

I am trying to make a forum, like the one here on PHPBuilder. The only thing I am getting out of this is a terrible headache! 😉 Anyone who can help? I am trying to make a recursive function to write a complete thread but I am getting nowhere!

terje-s

This depends entirely on how your database is built. I don't know if phpbuilders forum is open source (I would assume it is), but you can get the Sourceforge source off of http://sourceforge.net, its a pretty good one. You can get phpGroupWare from the same URL, also contains a good forum. Use these as an example.

Anon

Well even i'm facing a similar proble....I've been trying to construct the logic but failed...My Database structure stores the thread id which is a autoincremented field and the parent id which for a root node is zero.

A solution given by one person was to write a function showthreads wherein you pass the threadid. This function will query the corresponding forums table (having seperate tables for each forum created by the Admin) for the thread id passed and retrieve all the child threads (i.e parentid = threadid) and this function is going to be called recursively in a while-loop. This means there are going to be so many database queries and avoid so many queries.....

I shall take a look at sourceforge.net to get some ideas....

christer

I have a threadid, a messageid and a fatherid. New topics gets fatherid=0, and a threadid equal to the messageid, becuase the id is the auto_increment primary key value in my database. So I did it the easy way and made the threadid equal to the first message in a new thread.

I have also made my own recursive function that writes out threads.

mj_23

There is no need for recursive function at all. Search for the Starmate forum source code under the code library of this site and try to figure out it's logic for the forum site(similar to PHPBuilder's forum) from the database it created.

christer

I know there is no need for it, but I like recursive functions. hehe