vB3 Forum Quick Stats Cache Serialize Hack v1.1

vB3 Forum Quick Stats Cache Serialize Hack
Version 1.1
(By Boofo)

What does this hack do?
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 vB2 "Last Post Minute Hack" (with his permission for the vB2 version, of course) optimized and redone for vB3. It now uses NO queries to get the last minute info. 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.) as well as the name and link to the last poster in the forum. The stats are cached and the cache is only updated at a time set by you. With an option in the Admin CP, you can reset the time between cache updates without having to edit any more files once this hack is installed. This hack will add 1 optimized query (for the user's threads and replies stats) on a cache read, but since this hack is serialized, the cache read itself will not pull a query. On a cache update, it will add 6 queries to update the datastore. And then drop back down to the one query until the next cache update. This hack will make a cache in the datastore for each forum you have, so you don't have to worry about forums getting cross-cached with this hack. It has been thorughly tested on my site, but as we all know too well, sites can, and often do, vary in the way a hack performs on it. I forsee no problems of any kind on any site in the way this hack functions. It's basically pretty simple and hard to mess up.

Note: This is the setting for the time interval (in minutes) that you want the cache to be updated on. The default value is 10 minutes. The following code is in the forumdisplay.php part of this hack.

$updatetime = 10;

Once you install the Admin CP setting (at the end of this file), you will be able to update this from the Admin CP vBulletin Options settings.

Credits:
A BIG thank you goes out to KirbyDE for all of his guidance and patience while this hack was being written and tested. This hack might never have gotten past the dreamed up state if it wasn't for him. And it definately wouldn't have been finished by now or turned out as optimized as it is. Thank you, my friend. I learned a lot from you on our little adventure here. It was definately worth the trip.

Version Information:
Version 1.0 --Initial release
Version 1.1 --Corrected a few minor potential bugs and re-did the template. Now it has a cleaner look.

Installation overview:
Files to edit: (1)
--forumdisplay.php
Templates to add: (1)
--forumdisplay_quickstats
Templates to edit: (1)
--forumdisplay
Settings to add: (1)
--forumcachetime

Note: The first image below will show the forum quick stats for a forum that has attachments. The second image will show the forum quick stats for a forum that has no attachments.

[pjdaley]

(install has been clicked).... boooofooooo i need this hackkkkk.... is it hard to do? count threads of alot of forums to one sum?

[pjdaley]

that one has all the forums into 1 sum right? i can just choose 5? forums to count? (good job by the way)

[Boofo]

Originally Posted by pjdaley

that one has all the forums into 1 sum right? i can just choose 5? forums to count? (good job by the way)

No, that hacks shows ALL of the threads that each user has started right next to how many posts they have made, in the postbit.

[Nj?rd Eriksson]

Originally Posted by Boofo

But after you deleted the users and updated the counters, it should have straightened itself out. Did you update the theread and forum counters as well as the postcount? You need to do that, too.

Yes, I have updated all these counters. I do so quite regularly, whenever I change someone's username. However, vBulletin keeps a number of user records that equals the total number of registrations; and not the active registrations. All those users that have been pruned seem to be assigned no user ID (or an ID of 0) -- that's what I assume at least.

I also have been mistaken about this user "Strapu", which allegedly is the "Top Thread Starter" in this forum:

Top Threads: Strapu (117 Threads = 12.39%)

He did indeed exist, and has been pruned at some stage (what explains his user ID 0). He, however, definitely didn't start 117 threads in this forum -- that's rather the number of threads started by all pruned users combined. He did create -- amongst others -- the first thread in this forum, however.

The

Top Posts: (1,117 Posts = 7.83%)

problem where no user is displayed is then probably related. That should again be the total number of posts made by all pruned users combined.

[Osterling]

These maybe two stupid qestiosn but..

1.) how do you debug
and
2.) how do you add a settings

[Osterling]

anyone?

[Elmer]

Originally Posted by exasko

anyone?

Edit your config.php and put this variable anywhere in the config.php file

$debug = "1";

next, go to your admincp and in your vBulletin Options select Forum Display Option (forumdisplay)
onece there, just click the link Add New Setting

that should work

[psico]

There is a problem with the queries, I found the solution:

In forumdisplay.php find this code:

PHP Code:

        $topthreads = $DB_site->query_first("
                SELECT COUNT(threadid) as threads, postusername, postuserid
                FROM " . TABLE_PREFIX . "thread
                WHERE forumid=$forumid
                GROUP BY postuserid
                ORDER BY threads DESC, dateline ASC
                LIMIT 1
        ");

        $topposter = $DB_site->query_first("
                SELECT user.userid, user.username, COUNT(post.postid) AS postcount
                FROM " . TABLE_PREFIX . "post
                LEFT JOIN " . TABLE_PREFIX . "thread ON (post.threadid = thread.threadid)
                LEFT JOIN " . TABLE_PREFIX . "user ON (post.userid = user.userid)
                WHERE thread.forumid=$forumid
                GROUP BY post.userid
                ORDER BY postcount DESC
                LIMIT 1
        "); 


Replace with this code:

PHP Code:

        $topthreads = $DB_site->query_first("
                SELECT COUNT(threadid) as threads, postusername, postuserid
                FROM " . TABLE_PREFIX . "thread
                WHERE forumid=$forumid  AND postuserid <> 0
                GROUP BY postuserid
                ORDER BY threads DESC, dateline ASC
                LIMIT 1
        ");

        $topposter = $DB_site->query_first("
                SELECT user.userid, user.username, COUNT(post.postid) AS postcount
                FROM " . TABLE_PREFIX . "post
                LEFT JOIN " . TABLE_PREFIX . "thread ON (post.threadid = thread.threadid)
                LEFT JOIN " . TABLE_PREFIX . "user ON (post.userid = user.userid)
                WHERE thread.forumid=$forumid AND user.userid IS NOT NULL AND user.username IS NOT NULL
                GROUP BY post.userid
                ORDER BY postcount DESC
                LIMIT 1
        "); 


That's all!

See ya.