PDA

View Full Version : "Tricking" the data base [ Threads / Posts ]


mike01166
01-27-2009, 07:48 PM
Here is what I am trying to do. My club had a forum for 3+ Years on a free forum called proboards. There was no way of us obtaining a database from proboards that we could import into Vbulletin.

So we bought webhosting and vbulletin, and are setting up or new forum exactly the same as our old forum. One thing we have been doing is updating members post counts and join dates to reflect old post counts and join dates. Something I was trying to do was update the new vbulletins thread/post count that appears on the bottom of the forum.

What I tried doing was going into PHP Myadmin and went to the "forum" table and editing replycount and threadcount to match our old forums. It worked, after it all was done, we had our original thread/ post count from our old forum.

Whenever we started a new thread on the new forum, it would just add one more thread/post to the overall count, BUT , if ANY threads get deleted, it RE-tallies the overall posts and lowers it to reflect the actual number of threads/posts. Is there anyway we could make it so that this does not happen.

Thanks in advance. Mike.

Lynne
01-27-2009, 08:02 PM
It should no re-tally the post count - standard vbulletin will not do that unless you go and Update the Counters. Just removing a post or thread will not cause it to re-tally the post count.

mike01166
01-27-2009, 08:08 PM
here is a link to my forum

http://174.132.165.188/~siswill/forums/index.php

If you look at the for sale section, for instance. 1,081 threads, 8,648 posts. If you go into the for sale section, there is just one thread. If I post another thread and delete it, or even delete the one thread , the forum goes from 1,081 threads, and 8648 posts, and re-tallies its self.

This does not affect actual user post count, just the forums thread/post counter.

Lynne
01-27-2009, 08:28 PM
Oh, for some reason I thought you were talking about user post counts - my bad.

I am pretty sure you can't do what you want here with default vb software. The replycount and threadcount is all stored in the cache. I suppose you could write some plugin that acts between when it gets the count and when it spits it out and adds a certain amount of threads/replies to it then depending on the forumid. I'm really not sure what else you can do. I'm also not sure of all the places you would need to do this.

edit: There is some modification that is called something like "Fake Forum Statistics". Maybe that will do what you want.