PHPBB topic sql

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
scts102
Forum Newbie
Posts: 23
Joined: Thu Aug 25, 2005 2:15 pm

PHPBB topic sql

Post 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.
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post 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.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Yes multiple tables are involved; Sami's memory seems accurate on the tables needed.
Post Reply