Forum Display Enhancements - vB3.5 Forum Display Stats Cache Serialized

vB3.5 Forum Display Stats Cache Serialized
Version 1.0.0
(By Boofo)

What does this product 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 product is Logician's vB2 "Last Post Minute Hack" (with his permission for the vB2 version, of course) optimized and redone for vB3.5. It now uses NO queries to get the last minute info. This product 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 once this product is installed. This product will add 1 optimized query (for the user's threads and replies stats) on a cache read, but since this product is serialized, the cache read itself will not pull a query. On a cache update, it will add 6 queries to update the cache. And then drop back down to the one query until the next cache update. This product will make a cache in the datastore for each forum you have (with no extra queries), so you don't have to worry about forums getting cross-cached with this product. It has been thoroughly tested on my site, but as we all know too well, sites can, and often do, vary in the way a product performs on it. I forsee no problems of any kind on any site in the way this product functions. It's basically pretty simple and hard to mess up.

Forum Display Stats Update Frequency
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. You can change the setting in the Admin CP vBulletin Options settings under "Forum Listings Display Options > Forum Display Stats Update Frequency".

Credits:
A BIG thank you goes out to eXtremeTim for all of his expert guidance and patience while this product was being converted and tested. This product might never have gotten past the conversion if it wasn't for him. And it definitely wouldn't have been finished by now. Thank you, my friend.

Version Information:
Version 1.0.0 --Initial release

Installation overview:
---------------------------------
Files to edit: (1)
--forumdisplay.php (or config.php)
Products to install (1)

Installation Instructions:
---------------------------------
In forumdisplay.php:

Find:
---------------------------------

'iconcache',

---------------------------------
BELOW it add:
---------------------------------

'forumstatscache',

----------------------------------------------------------------------------------------
If you want to save a file edit on upgrades, do the following INSTEAD of the above file edit:
----------------------------------------------------------------------------------------
In includes/config.php:

Find:
---------------------------------

$config['Mysqli']['ini_file'] = '';

---------------------------------
BELOW it add:
---------------------------------

// ****** SPECIALTEMPLATES *****
// Add any specialtemplates here for any products or mods that use the datastore, to save
// from re-doing file edits on an upgrade or re-install of vBulletin (until they give us a better
// way to do it, anyway). Thanks to KirbyDE for the how-to on doing this.
if(THIS_SCRIPT == 'forumdisplay')
{
global $specialtemplates;
$specialtemplates = array_merge($specialtemplates, array('forumstatscache'));
}


NOTE: You can also add any other specialtemplates from other hacks in here to save those file edits also.

---------------------------------

Go to your AdminCP
Scroll down to 'Plugin System'
Click 'Manage Products'
Click 'Add/Import Product'
Click the 'Browse' button, and locate the product-forumdisplay_stats_bh.xml file on your computer

---------------------------------
Done!
Enjoy!

[Boofo]

Check out the first post.

I couldn't tell you what the overhead would be any more than the queries used. You would have to check it out but now it is easy to install and uninstall with no more major file edits.

If this hack brought your server to it's knees in 3.0, then you had more going on than just this messing that up. No way this hack can do that.

[FleaBag]

Well just installed this hack and get the following upon the page loading in a relatively tiny forum...
Page generated in 13.37798 seconds with 23 queries [Server Loads: 0.50 0.24 : 0.14].

Without the hack...
Page generated in 0.83826 seconds with 16 queries [Server Loads: 0.28 0.22 : 0.14].

No other hacks affect it in this way.

[Boofo]

Originally Posted by FleaBag

Well just installed this hack and get the following upon the page loading in a relatively tiny forum...
Page generated in 13.37798 seconds with 23 queries [Server Loads: 0.50 0.24 : 0.14].

Without the hack...
Page generated in 0.83826 seconds with 16 queries [Server Loads: 0.28 0.22 : 0.14].

No other hacks affect it in this way.

That will only be 23 queries on the cache update. The rest of the time it will only add one query. Read the first post!

Do the template edit and adjust the setting.

[haiboss]

Originally Posted by Gizmo5h1t3

cant see where this is supposed to show, followed the instructions, but nothing is displaying..???

I'm have install but it doesn't works, why....?

[Boofo]

Read this in the first post:

Installation Instructions:

And don't forget the install button.

[Gizmo5h1t3]

Originally Posted by Boofo

Read this in the first post:

Installation Instructions:

And don't forget the install button.

just followed your instructions to the letter, and im tellin u mate it isnt working!!!

[Andreas]

Working for me, so you must be doing smth. wrong.
Are you sure you imported the XML as Product and not as Plugin?

[Huijting]

Originally Posted by Boofo

Ok, I'll be waiting here then.

Click :-)

[Gizmo5h1t3]

Originally Posted by KirbyDE

Working for me, so you must be doing smth. wrong.
Are you sure you imported the XML as Product and not as Plugin?

if id have done that,it would have told me it was an invalid file..
as it is, ive followed to the LETTER, and i see nothing....

[Andreas]

No, RC2 doesn't tell that the File is invalid
Anyway, send me a PM with an ACP Login and i'll take a look.