Page 1 of 1

PHPBB topic sql

Posted: Sun Jan 15, 2006 10:13 pm
by scts102
I would like some help from somebody who knows how phpbb works....
I am not looking to create a forum...that is way beyond me :P

I would just like the sql code that would be needed to create a new topic. I would not be going through phpbb itself, it would be a seperate script on my site.

Posted: Sun Jan 15, 2006 10:20 pm
by m3mn0n
Look at the database in phpMyAdmin for the topics db. From there you can see what columns are required.

But I'm fairly sure more than 1 table is updated during the post creation process. I believe you need to also update the posts, post_text, search_wordlist, search_wordmatch and also the users table to increment the post count.

That should be it, if I'm not mistaken.

Posted: Sun Jan 15, 2006 10:30 pm
by feyd
Yes multiple tables are involved; Sami's memory seems accurate on the tables needed.