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]

[Reverend]

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.

[Boofo]

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.

[Reverend]

That did it.
Thanks Boofo.

[Boofo]

No problem. Enjoy!

[Reverend]

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.

[squawell]

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

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

[Smoothie]

number of queries this adds?

[Boofo]

Today at 08:19 PM squawell said this in Post #16
Boofo if i want forum member just see their own stats....how

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

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.

[Boofo]

Today at 09:40 PM Smoothie said this in Post #17
number of queries this adds?

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?

[Boofo]

Today at 07:54 PM Reverend said this in Post #15
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.

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:

PHP Code:

if ($yourposts !="0") {
$yourstats = "<tr id=\"cat\">
        <td bgcolor=\"#1D6AA0\" align=\"center\" nowrap colspan=\"3\"><smallfont><b>$bbuserinfo[username], you have made a total of <i>$yourposts</i> in this forum. (<i>$yourthreads</i> and <i>$yourreplies</i>)</b></smallfont></td>
</tr>";
} else {
$yourstats = "<tr id=\"cat\">
        <td bgcolor=\"#1D6AA0\" align=\"center\" nowrap colspan=\"3\"><smallfont><b>$bbuserinfo[username], you have made a total of <i>$yourposts</i> posts in this forum.</b></smallfont></td>
</tr>";
} 


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

PHP Code:

$yourstats 


with this:

PHP Code:

<tr id="cat">
        <td bgcolor="#1D6AA0" align="center" nowrap colspan="3"><smallfont><b>$bbuserinfo[username], you have made a total of <i>$yourposts</i> in this forum. (<i>$yourthreads</i> and <i>$yourreplies</i>)</b></smallfont></td>
</tr> 


That should do it.