What happens (database-wise) on new thread creation?

[kkiely]

I am currently using Vbulletin as a commenting system for the non-VB section of my sites. The way I do this is I manually create a thread in a hidden forum with the first post saying "please post comments". Then I show all the posts from the thread as comments and installed a hack that allows a quick reply for that page to that partiular thread.

But I am starting up a new site where I want to have about 9,000 pages so I want to have 9,000 threads to be used as comments for each page. I can't create these manually so I did a test (with only 200 threads) to see if I could artificially create the threads. I created a spreadsheet with all of the columns in the 'thread' table (threadid, etc) and created another spreadsheet with all the columns of the 'post' table (postid, etc) and imported them both into their respective tables. The import went fine but when I went to view the forumhome page the information didn't appear in the forum correctly.

When you create a new thread I assumed VB just created a new row in the 'thread' and 'post' tables with the relevant information. Is there more that goes on thant that?

Originally Posted by kkiely

I am currently using Vbulletin as a commenting system for the non-VB section of my sites. The way I do this is I manually create a thread in a hidden forum with the first post saying "please post comments". Then I show all the posts from the thread as comments and installed a hack that allows a quick reply for that page to that partiular thread.

But I am starting up a new site where I want to have about 9,000 pages so I want to have 9,000 threads to be used as comments for each page. I can't create these manually so I did a test (with only 200 threads) to see if I could artificially create the threads. I created a spreadsheet with all of the columns in the 'thread' table (threadid, etc) and created another spreadsheet with all the columns of the 'post' table (postid, etc) and imported them both into their respective tables. The import went fine but when I went to view the forumhome page the information didn't appear in the forum correctly.

When you create a new thread I assumed VB just created a new row in the 'thread' and 'post' tables with the relevant information. Is there more that goes on thant that?

Have you been using vBulletin's data manager to handle processing new threads? If not, I suggest you do as it validates everything for you and also follows vBulletin coding standards.

More Info:

http://www.vbulletin.com/docs/html/data_managers

Also, I assume you mean the statistics for the forum (last post, thread count, post count) ?

You need to simple use build_forum_counters($forumid) function, where $forumid is the forum id of the forum you want to update.