did u update the attachment with the add-ons?

great hack, saves me 7 queries nice

Very nice hack, man. Here's updated instrucs with the add-ons.

Awesome idea Tigga :)!

- miSt

[high]* Prankster too
[/high]

great idea
thanks

greets Prankster

OK, what should we do if we have some or all of the old hacks your new hack is based on so we can truly save queries instead of adding 9 new to the 8 old ones? ;)

If you have all (or some) of these stats installed already, you would pretty much just replace the coding for those stats with the new code for the stats cache. It shouldn't be too hard to figure out what to replace, but if you have problems with it let me know.

Database error in vBulletin 2.3.0:

Invalid SQL: UPDATE statscache SET members='1617',threads='2145',posts='39246',topthr ead='Mijae',topthreadid='1',to pthreadnumber='186',topposter='Jim',topposterid='1 53',toppostnumber='2496',newes tmember='umar'newestmemberid='1617',threadtoday='0 ',posttoday='7',lastupdate='10 50682471', threadviews='259042',memberstoday='2'
mysql error: You have an error in your SQL syntax near 'newestmemberid='1617',threadtoday='0',posttoday=' 7',lastupdate='1050682471', thr' at line 1

mysql error number: 1064

It looks like a comma is somehow missing in that query. Make sure you have a comma right before 'newestmemberid' in the query that updates the cache.

Up and running in v2.2.0!!!