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]

Screenshot?

Here is a screenshot [high]with[/high] the attachment info.

Here is a screenshot [high]without[/high] the attachment info.

Looks good Boofo.
Will replace grog's hack with this one.I'll install tomorrow on v2.3.0 ;)

Thanks. ;)

Don't forget to click install. I plan on updating it to cache the queries and you can be automatically notified when I do the update.

Hmm.... might install this once I'm finished playing around with my new half life cds

Looks good. I'll download it once it is updated.

*Installed for now.

Thx for the (big) release, good work Boofo ;)
And a big thanks too for all updates and support you brang in my thread whereas I couldn't do it by myself

I still have a lot of work for the university ... I'm working now on a PHP/SQL project, so I'll improve my PHP and so will come soon for big, usefull and "good coded hack" :D

;)

Thank you for the kind words. Your hack was very useful in putting this together. I learned some things along the way, plus I had some great help with this. ;)

I'll look forward to your next hack. ;)

Now installed on vb 2.3.0.
Works perfect.
One question,how do i change the font color for "$yourstats"

i tried editing the forumdisplay.php code from this:

<smallfont><b>$bbuserinfo[username], you have made a total of <i>$yourposts</i> posts in this forum.</b></smallfont>

to this:

<smallfontcolor="#FFFFFF"><b>$bbuserinfo[username], you have made a total of <i>$yourposts</i> posts in this forum.</b></smallfont>

but get parse errors.

Change this:

<smallfontcolor="#FFFFFF"><b>$bbuserinfo[username], you have made a total of <i>$yourposts</i> posts in this forum.</b></smallfont>

to this:

<smallfontcolor=\"#FFFFFF\"><b>$bbuserinfo[username], you have made a total of <i>$yourposts</i> posts in this forum.</b></smallfont>

You have to put backslashes before the quotes in php files. ;)

That did it.
Thanks Boofo. ;)

No problem. Enjoy! ;)

Just wondering if its possible to edit the font colour for $yourstats via the forumdisplay_quickstats template so that the colour can be set for different styles.

Boofo if i want forum member just see their own stats....how

should i do??(the attachment part)...thankz...

number of queries this adds?

That would require re-writing the whole hack. The only problem you might have in doing it that way would be if you get a user in a forum that they haven't done a whole lot in, the information would be very low.

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? ;)

Yes, you can, but it will show the thread and posts numbers in the your stats line at the bottom of the box even if they haven't posted in that thread. Here is how you can do it:

In forumdisplay.php, find:

and delete it. Then go into the forumdisplay_quickstats template and replace:

with this:

That should do it. ;)

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. ;)

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

coooooooooooooooool!
Looks good. thx Boofo!

and still waiting for the next stats cached version~

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

just waiting for next version

:D

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?

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.

That might work. :)

Ok, here is an update on my progress with the caching. I have it done except for 2 small problems. The main one being how to have it cache each forum. If you go from one forum to another, it won't update the stats until the pre-determined time, so you will be looking at the stats from the forum that was last cached. I will get it figured out and release it here just as soon as I can, hopefully later today. Hang in there, it's coming. ;)

for example

update the forum stats every 24 hours~

:)

24 hours? I'd much rather have it every 10 minutes.

It will be configurable in that sense to whatever you want.

come on

can not wait anymore

:D :D :D

I'm still trying to figure out the fix for each forum. I'll post it the moment I have it. ;)

Nice piece of work Boofo

Thank you. ;) Don't forget to hit install if you want to be notified when I post the caching update.

thx!

installed

Installed :)