well, the post count and thread count is WAY off for me.

optimize hack = 608,313 posts
original vbb = 559,113 (which is the # of rows in that table)

not to mention the thread count is off too.
Think i will keep the count(*) for now, but keep the rest of the optimize hack.

D

you should update your counters if there is really that difference....

also not moderated posts don't count towards the stats..

Ok, i have released version 2 of the hack.

I've nearly completely recoded it up from ground, so you do better in completly uninstall version1 and install version2

the new version doesn't use the table cache_forumhome anymore, so you could DROP it from your database.

at least, no single caching is used anymore (except from moderatorlist caching)
The hack is now just an optimization of the forumhome queries.
on more frequented boards this will help much better than the old version.
also the pm query section has been optimized, so it would work much faster on large DB's than the old one..

could you post the old instructions for v1 so that I can uninstall? I didn't keep them =(

Will the users browsing forums hack work now with this new version? :)

oops, sorry, have overwritten them, too.

maybe someon other has kept them :)

if you have no other hacks installed on index.php you can just use an unhacked index.php and start reinstalling.
just deltet the one table from the db.

yes :)

/me slam-dunks the install button!

Don't know why, but the mods column is now gone.

I have a ton of hacks on my index =(

Anyone have the old install txt lying around? Please! =)