Forum Quick Stats v1.0

Forum Quick Stats v1.0
(By Boofo)

Thanks goes out to Mug and cirisme, for all of their indispensable help with the queries. Without them, this hack would still be on the drawing board. And thanks also goes out to Grog6 for the basis of this hack, which is his Forums Statistics hack. A special thanks goes out to Logician for his great Last Post Minute Hack. Thank you, my friend.

This hack has all new 100% working (and optimized) queries. I will be updating it to cache all of the queries so it will only update them at a pre-determined time (set by you).

What this hack does:
It will display stats about each forum at the top of that forum. (NOTE: The attachments info will NOT show in forums that have no attachments.) Also included in the hack is Logician's "Last Post Minute Hack" (with his permission, of course). This hack will display a link the last post and the time the last post was made (i.e. "1 minute" or "2 days", etc.).

Tested and installed on vBulletin v2.2.9 (but should work with all versions).

Files to edit: 1 (forumdisplay.php)
Template to edit: 1 (forumdisplay)
Templates to add: 2 (lastpostminute and forumdisplay_quickstats)
Settings to edit: 1 (in the Admin CP)
Install time: 5 minutes (if you are slow or a newbie )

[high]Please click the install button if you install this hack. (I have 3 kids to put through college.)[/high]

[Austin Dea]

I install when the stats are cached

[Boofo]

Today at 10:22 PM Austin Dea said this in Post #21
I install when the stats are cached

The queries that are in it right now are fairly fast queries. I have optimized them as much as I can and on my site it runs quick.

[Austin Dea]

Yes, but I don't need it right this second. I'll wait =P

[sleepbirdcyp]

coooooooooooooooool!
Looks good. thx Boofo!

and still waiting for the next stats cached version~

[Smoothie]

Yesterday at 10:54 PM Boofo said this in Post #19
Right now it adds 7 queries (8 with Logician's hack). The old Forum Statistics hack added 6 queries and didn't have the attachments info, Logician's Lastpostminute hack, "your stats" or the last poster. I am in the process of writing the code that will cache those queries and only run them every so many minutes (i.e. 10) in which case it will run 8 queries when it is updating the cache and only one query when it is not. How does that sound?

Sounds good Boofo, nice work, but thats too many queries for my site.

[sleepbirdcyp]

just waiting for next version

[Boofo]

Yesterday at 11:14 PM Smoothie said this in Post #25
Sounds good Boofo, nice work, but thats too many queries for my site.

I will be releasing the update (hopefully tomorrow) with the cache. It will only run 1 query when it is not updating the cache. Will that work better for you?

[MetroSports82]

great work Boofo! works great, and yea i noticed the queries are running fairly quick on my end as well. thanks!

[Boofo]

Today at 12:12 AM MetroSports82 said this in Post #28
great work Boofo! works great, and yea i noticed the queries are running fairly quick on my end as well. thanks!

Thank you for the kind words. Don't forget to click install so you can be notified when I get the cached version up here in the next day or so.

[Smoothie]

Today at 01:04 AM Boofo said this in Post #27
I will be releasing the update (hopefully tomorrow) with the cache. It will only run 1 query when it is not updating the cache. Will that work better for you?

That might work.