Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
vB3 Forumhome Stats Cache Serialize hack v2.2 Details »
vB3 Forumhome Stats Cache Serialize hack v2.2
Mod Version: 1.00, by Boofo (R.I.P.) Boofo is offline
Developer Last Online: Jun 2012 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.0.0 Rating: (1 vote - 5.00 average) Installs: 108
Released: 11 Feb 2004 Last Update: Never Downloads: 33
Not Supported  

vB3 Forumhome Stats Cache Serialize hack
Version 2.2
(By Boofo)

What does this hack do?
This hack will add some forum statistics to your forumhome that will be cached (to reduce the query load) for a certain amount of time that can be set to whatever you want. This covers most of the stats any forum Admin would use on his site.

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 index.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:
I want to thank Tigga for the original Forumhome Statistics Cache hack for vB2, partly on what this hack is based. I also want to thank EvilLS1 for his time and patience in helping put this hack together. Another thank you goes out to Mike Gaidin for testing this thoroughly while I was putting together this install file. And, finally, thank you goes out to NTLDR, for helping me track down a very stupid mistake on my part which I had overlooked.

Version 2.0 credits go out to g-force2k2 for getting me started on the datastore version of this hack and guiding me through some of the rough parts in the beginning. And also to KirbyDE for answering all of my dummy questions while writing this version and verifying the code when I figured out all of my mistakes. This is my first attempt at using the datastore function but it seems to work better and be easier to code than the older way of doing things.

Version Information:
Version 1.0
--Initial release
Version 2.0 --Completely rewritten using the datastore function for vB3. It now uses "serialize" to store the data and "unserialize" to retrieve the data. There is also now 1 less query when reading from the cache.
Version 2.1 --Combined the "new threads since last visit" and "new posts since last visit" queries into 1 query, thus eliminating another query on cache hits. Thanks goes out to g_force2k2 for this one. Also added Admin CP setting code so you can change the time interval between cache updates via the Forum Display Option setting in the vBulletin Option in the Admin CP. That code to add is at the end of this file.
Version 2.2 --Added "Top Reputation" statistic (requested by rinkrat ) and totally re-did the template. It looks cleaner now.

New Installation:
Do all of the steps in this file.

To Update Version 1.0 to Version 2.0:
To update this hack you will need to do everything in this file over again except the second query (Query #2). After you have this hack up and running again and you have made sure it is running to your satisfaction, you can drop the statscache table (from version one of this hack) completely. It is no longer needed.

To Update Version 2.0 to Version 2.1:
You will need to re-add the code for the index.php and go to the end of this file and add the setting for the Admin CP.

To Update Version 2.1 to Version 2.2:
You will need to re-add the code for the index.php and replace the code for the forumhome template.

Installation overview:
Queries to run:
(2)
Files to edit: (2)
--index.php
--member.php
Templates to edit: (1)
--forumhome
Settings to add: (1)
--forumhomecachetime

vB3 Arcade hack stats addon:
http://www.vbulletin.org/forum/showp...&postcount=262

The first attachment shows the Guest loggedin and the second attachment show the Registered Member and above loggedin.

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	guest.jpg
Views:	2056
Size:	24.3 KB
ID:	17522   Click image for larger version

Name:	registered.jpg
Views:	2698
Size:	32.2 KB
ID:	17523  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Forum Display Enhancements vB3.5 Forum Display Stats Cache Serialized Boofo Modification Graveyard 42 03 Nov 2007 11:02
vB3 Forum Quick Stats Cache Serialize Hack v1.1 Boofo vBulletin 3.0 Full Releases 117 21 Aug 2005 01:10

Comments
  #2  
Old 11 Feb 2004, 06:45
Scrub's Avatar
Scrub Scrub is offline
 
Join Date: Oct 2001
Awsome.
Reply With Quote
  #3  
Old 11 Feb 2004, 11:50
Allan's Avatar
Allan Allan is offline
 
Join Date: Jun 2003
Real name: allan
Good bad ..

Thank Boofo
__________________
-------------------------------------------------------------------------------------------
Administrator vBulletin-Ressources.com, French vBulletin Resources.
Reply With Quote
  #4  
Old 11 Feb 2004, 12:01
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
What does Good Bad mean?

You forgot the install button here, too.
Reply With Quote
  #5  
Old 11 Feb 2004, 12:07
Allan's Avatar
Allan Allan is offline
 
Join Date: Jun 2003
Real name: allan
oupss, I wanted to say, pretty work, you it is to it well

yes, I click ILLIKO
__________________
-------------------------------------------------------------------------------------------
Administrator vBulletin-Ressources.com, French vBulletin Resources.
Reply With Quote
  #6  
Old 11 Feb 2004, 12:30
Dan's Avatar
Dan Dan is offline
 
Join Date: Dec 2002
Real name: Daniel
nice hack Boofo
__________________
Former vBulletin.org Staff Member

Guildhead | Torhead | Wowhead
Please do not Private Message, Email or Instant Message me for Support with vBulletin or help with any Modifications to vBulletin.
Reply With Quote
  #7  
Old 11 Feb 2004, 12:34
Natch's Avatar
Natch Natch is offline
 
Join Date: Nov 2002
Sweet work Boofo - clean and simple
__________________
Natcher00
... is the Admin @ MobileForces.org - Official Community for a cult Vehicle based FPS - the only place for support!
... also he's Penfold to Dark_Wizard's Danger Mouse in development of vBWar
http://www.mobileforces.org/sig.jpg
{DaniWeb: Learn HOW-TO mod_rewrite your vB board}
Reply With Quote
  #8  
Old 11 Feb 2004, 14:05
NyCwill NyCwill is offline
 
Join Date: Feb 2002
Real name: William
sweet hack
__________________
http://www.a-oneforums.com
Reply With Quote
  #9  
Old 11 Feb 2004, 14:19
g-force2k2 g-force2k2 is offline
 
Join Date: Mar 2002
Nice work Boofo, just some ideas for future vb3 stats hack, I would personally have used a datastore column instead of a new table ( special template ) and also would have used a cron job, but these are just some ideas. Nonetheless good work Boofo.

Cheers,
g-force2k2
__________________
Custom vBulletin Hacker => Making Ideas Into Working Programs => No Idea Can Ever Be A Bad Idea
--
My vb3 Hacks
--
[ Posting Required Before Poll Voting ] | [ vb3 Font Color Hack ] | [ vb3 User Forum Activeness Hack ] | [ vb3 Postbit Style Option ] | [ vb3 User Ratings Hack ]
Reply With Quote
  #10  
Old 11 Feb 2004, 14:21
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
Originally Posted by g-force2k2
Nice work Boofo, just some ideas for future vb3 stats hack, I would personally have used a datastore column instead of a new table ( special template ) and also would have used a cron job, but these are just some ideas. Nonetheless good work Boofo.

Cheers,
g-force2k2
Maybe we can get together and you can show me what you mean. The datastore is new to me. The cron job, I thought about but I wasn't sure I really needed to go that route. That is new to me in vB3, also.
Reply With Quote
  #11  
Old 11 Feb 2004, 20:18
gmarik's Avatar
gmarik gmarik is offline
 
Join Date: May 2002
Real name: Marco
Why this looks nice. Could add latest attachment as an option as well ...
Reply With Quote
  #12  
Old 11 Feb 2004, 21:08
Gio Takahashi's Avatar
Gio Takahashi Gio Takahashi is offline
 
Join Date: Jul 2003
Location: Cape Coral
Real name: Don K
Will install! Good job.
Reply With Quote
  #13  
Old 11 Feb 2004, 22:19
Mike Gaidin's Avatar
Mike Gaidin Mike Gaidin is offline
 
Join Date: Oct 2001
Real name: Mike
Nice one Bob. Glad to see you finally released it.

/me clicks install.

Last edited by Mike Gaidin; 11 Feb 2004 at 22:22.
Reply With Quote
  #14  
Old 11 Feb 2004, 22:57
rinkrat's Avatar
rinkrat rinkrat is offline
 
Join Date: Jan 2002
Can it say Top Reputation?
Reply With Quote
  #15  
Old 12 Feb 2004, 02:10
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
You can add whatever you want to it. The possibilities are endless.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 17:52.

Layout Options | Width: Wide Color: