Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Cyb - Advanced Forum Statistics Details »
Cyb - Advanced Forum Statistics
Mod Version: 5.7, by Valter (Coder) Valter is offline
Developer Last Online: May 2014 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.6.8 Rating: (251 votes - 4.79 average) Installs: 3185
Released: 04 Aug 2006 Last Update: 22 Oct 2007 Downloads: 16488
Not Supported DB Changes Uses Plugins Template Edits  

PLEASE CHECK OUT THIS THREAD FOR FEATURE SUPPORT:
http://www.vbulletin.org/forum/showthread.php?t=177778



=====


Info:
Forum Statistics for:
-Latest Forum News
-Newest Members
-Top Posters
-Top Thread Starters
-Top Referrers
-Most Viewed Threads
-Hottest Threads
-Top Reputations
-Top Thanked
-Most Popular Forums
-Top Infractions
-Latest Classified Ads
-Latest Posts


This product is very flexible. You are able to choose which stats to show, disable some details to save page space, optionally show data from last X days only, make several other functionality/make-up customizations... See screenshots.


You can have Main Stats box shown on several pages...
It's shown by default on forumhome (to disable it set "Main Top Stats box on ForumHome" to "Disable")
To activate another location:
a) put location-name in "Stats on Custom Pages" field in hack settings
Explanation: When you open some vBulletin php file you'll see this at the top - "define('THIS_SCRIPT', 'XXX');"
XXX is location-name we need. It's usually the same as php filename (without extension, of course)
Note: When setting several locations then separate location-names by commas
b) add "$cybtopstats" to the template called on page where you wish to have stats shown


Notes:
-To set options go to: vBulletin Options > Cyb - Advanced Forum Statistics
-"Top Thanked" works only with Abe1's "Post Thank You" hack. Don't enable if you have not this hack installed.
-To move Top Stats box somewhere else on forumhome: 1.-Set placement setting to "None" 2.-Add "index" to "Stats on Custom Pages" setting 3.-Add "$cybtopstats" wherever you wish in FORUMHOME template.
-If Top Stats box is too big because of long usernames or thread/forum titles be noted that you can trim them in ACP options.
-When forum/thread titles or usernames are trimmed, mouse-over will show you full version.


Installation:
1. Required:
Import XML file (as product) through AdminCP: Plugin System > Manage Products > [Add/Import Product]

2. Optional - if you use custom styles and stats are not shown:
Open FORUMHOME template and add "$cybtopstats" where you wish Stats box to appear

3. Optional - if you use custom styles and link to re-enable stats is not shown:
Open desired template and add "$cybts_enablelink" where you wish "Enable Top Statistics" link to appear


Versions:
v1.0 - Jun 12. 2006.
-First release
v1.5 - Jun 12. 2006.
-Added - option to enable/disable whole hack
-Added - option to Enable/Disable "Newest Members"
-Added - option to switch "Newest Members" column background color (alt1/alt2)
-Added - option to Enable/Disable "Top Posters"
-Added - option to switch "Top Posters" column background color (alt1/alt2)
-Added - option to Enable/Disable "Top Reputations"
-Added - option to switch "Top Reputations" column background color (alt1/alt2)
-Added - option to Enable/Disable "Latest Posts"
-Added - option to switch "Latest Posts" column background color (alt1/alt2)
v1.6 - Jun 12. 2006.
-Small bug fixed (thanks evss)
v1.7 - Jun 13. 2006.
-Added - "Newest members" option to show/hide member ID
-Added - "Newest members" option to show/hide member post count
-Added - "Top Reputations" option to show/hide member post count
-Added - "Latest Posts" option to show/hide post date/time
-Added - "Latest Posts" option to show/hide post replies #
-Added - "Latest Posts" option to show/hide post views #
v1.8 - Jun 13. 2006.
-Added - Top Thanked Stats - for those who use "Post Thank You Hack" by Abe1
-Added - "Latest Posts" option to show/hide last poster
-Improved tables
v2.0 - Jun 14. 2006.
-Added - View more results on separate page (requires one file upload)
-Option to allow/dissallow members to view more results on CybTopStats.php
-Option to set default number of results shown on CybTopStats.php
-Option to set max number of results user can choose to show on CybTopStats.php
v2.5 - Jun 15. 2006.
-Added - "Latest Forum News"
-Added - "Most Viewed Threads"
-Added - Ability to show/hide any detail in stats
-Hack name changed to "Advanced Forumhome Statistics"
v2.6 - Jul 03. 2006.
-Added "Forum" to "Latest Posts", as requested. This shows forum name where post is created. Can be enabled/disabled.
-Added an option to trim forum titles.
-Fixed bug where thread date/time was shown. Now date/time of the latest post is shown.
-Few improvements in codes.
v2.7 - Jul 04. 2006.
-Fixed bug where private forums are not automatically excluded. This works fine now.
v2.8 - Jul 08. 2006.
-Security bug fixed where some codes can be executed on site if entered as thread title. Upgrade Recommended!
v2.9 - Jul 09. 2006.
-Fixed issue with special characters used in some languages (Turkish, Bosnian, etc)
v3.0 - Aug 04. 2006.
-Release of this hack for vB v3.6
v3.1 - Aug 21. 2006.
-New: no more file uploads (separate page still exist, don't worry)
-New: full username/title on mouseover when you trim forum/thread titles or usernames
-New: in "Latest Posts" - thread title is linked to start of thread now and little arrow is linked to first unread post in thread
-Fixed/changed some phrases
-Other fixes
-To upgrade: Import XML as product, allow overwrite, then delete CybTopStats.php from your server
v3.2 - Aug 22. 2006.
-Bug fixed in "Latest Posts" (when you click on little arrow you get "post doesn't exist" error)
v3.3 - Aug 23. 2006.
-Bug fixed in "Latest Posts" (blank "User" field when guest posted)
-Bug fixed in "Latest Posts" (if default browser font is not Arial then go-to-first-unread-post-arrow is shown as little blank square box)
-If your forum's index.php file was renamed for any reason, now you can enter new filename in ACP hack options to have working separate page
v3.4 - Aug 30. 2006.
-Bug fixed in "Latest Posts" (Moderated threads not hidden)
-Added "Product Version Checking"
v3.5 - Aug 30. 2006.
-Small security bug fixed
v3.6 - Sep 09. 2006.
-Added: "Top Thread Starters" (NOTE: Requires MySQL version 4.0.4 or higher)
-Added: You can choose in Settings where Stats box will be shown on forumhome (4 options + disable)
-Added: You can have Stats shown anywhere on your forum/external page (must include global.php). Just put "$cybtopstats" where you wish to have stats shown.
-No more need to set filename for "index.php" if it was changed. Now misc.php is used, which nobody has need to rename.
-Tables improved (some space saved)
-Small bug fixed (no full thread title on mouseover in "Latest Forum News" when thread titles are trimmed)
-Thanks to Paul M for help with db query for "Top Thread Starters"
v3.7 - v3.9 (Sep 16. 2006.)
-Trying to fix very weird bug
v4.0 - Sep 18. 2006.
-To completely solve several problems experienced with versions 3.7 - 3.9 I'v changed some things here:
1. You can have stats shown on maximum 2 pages (who needs more?)
2. Stats are shown by default on forumhome (to disable it set "Top Stats Box Position" to "None").
3. To activate second location:
a) type location-name in "Additional Location" field
Explanation: When you open some vBulletin php file you'll see this at the top - "define('THIS_SCRIPT', 'XXX');".
XXX is location-name we need. It's usually the same as php filename (without extension, of course).
b) add "$cybtopstats" to the template called on page where you wish to have stats shown.
v4.1 - Sep 25. 2006.
-Added "Top Referrers"
-Added option to exclude usergroups from viewing top stats
-Few code improvements (zeros excluded from stats, few table parameters adjusted)
v4.2 - Oct 29. 2006.
-Whole code is now valid XHTML 1.0 Transitional
-Added option to exclude usergroups from showing up in top stats
-Fixed bug (deleted threads still listed in stats)
v4.3 - Nov 29. 2006.
-Added option to set time/date formats (defaults: day-month, hours:minutes) - this can save some space
-Removed some 'width' attributes to improve columns alignment
-Table width changed to stylevar outertablewidth to fix problems with some styles
v4.4 - Nov 29. 2006.
-Main table width is 100% again because $stylevar[ourtertablewidth] breakes some styles for some reason
-Updated templates version/dateline info
v4.5 - Nov 30. 2006.
-Fixed bug (queries executed in background for users who are not allowed to see stats)
v4.6 - Feb 26. 2007.
-New general option: Choose to show stats from the beginning, for current month, or from custom date
-New in "Latest Posts": Choose where titles and arrows are linked to
-New in "Top Reputations": Added number of members who gaved positive reputation points to user
-Several small code improvements for better compatibility with different styles and SEO
-Setings page little re-organized...
v4.7 - Feb 27. 2007.
-Removed options from 4.6 which requires complex queries and makes forums run slow ("show stats for a custom time period" and "show number of members who gaved positive reputation points to user"). Sorry, I know this was useful but it's more important to keep this product fast/stable.
-New in "Latest Forum News": Now you can set several forums to show latest threads/news from
-Fixed bug (stats can not be used in forumdisplay)
-Fixed bug (user see no-permissions-to-view threads in "Latest Forum News")
-ACP settings page re-organized and shortened for better view
v4.8 - Mar 09. 2007.
-New: "Hottest Threads" - list popular threads sorted by reply count
-Fixed bug (more results page blank or get "URL file-access is disabled" error)
-Fixed bug (new replies signalization in "Most Viewed Threads" and "Latest Forum News" not working)
-Number of results on separate page is now chosen by user via drop-down menu (in hack settings you can set available values)
-Main Top Stats box now can be shown on unlimited number of locations (list locations you want, separate with commas)
-Added sessionurl to links where missed
v4.9 - Mar 23. 2007.
-Fixed bug where cell spacing/padding for individual stats tables are not defined - this saves a lot of space and looks much better imo
-Colspan for the main table now calculated automatically, depending on number of enabled stats (this fixes problem with tiny blank column in Opera)
-Fixed bug where some special characters are not shown properly in stats when titles/usernames are trimmed
-Trimming is now done in standard vBulletin style - trims a string to the specified length while keeping whole words
-New: Option to remove bold style from usernames in stats
-Hack compatible with vBadvanced CMPS (location: adv_index, variable to globalize: cybtopstats)
-Improved compatibility with right-to-left direction styles
-BIG general code clean-up
v5.0 - Apr 10. 2007.
-To save page space Stats are now arranged into two rows and up to four columns (adjustable in Options)
-For every column you can choose which statistic to show in, except "Latest Posts" which always uses one full column
-New: "Most Popular Forums"
-New: User can completely disable Top Stats (and enable it later easily if wanted)
-If stats disabled then "Enable Top Statistics" appears in "Quick Links"
-New: Drop-down menu in Stats table header with options to view more stats and disable them
-New: Exclude usergroups from viewing more results [guests(1) and banned(8) blocked by default]
-Fixed bug where queries are executed on index even you disable Stats on Forumhome
-Settings page much easier to understand and set now
-Several other fixes and improvements, including queries, indexes for thanked posts and user threads, better js codes, better tables etc...
v5.1 - Apr 16. 2007.
-Fixed bug where "Latest News" are not sorted by date but ID
-Fixed javascript error in IE
-Fixed bug where "Top Thread Starters" counts are not updated
-Layout changeable (single or two rows)
-Two more columns added
-Any column can be disabled
-Added ability to show post counts in "Newest Members"
-"Stats Management" easier to understand and use
-"Turn on/off Stats" user function improved, including forum message with notes on how to re-enable
-Added variable for "Turn on/off Stats" link to use on custom places ($cybts_enablelink)
-New: "Top Infractions"
-Codes valid XHTML 1.0 Transitional
v5.2 - Apr 29. 2007.
-Fixed bug where thread counts in "Top Thread Starters" are not updated
-Fixed bug with strange underlines on some forums
-Fixed bug where you can not put stats on custom place on forumhome
-Updated instructions on how to put Stats on custom place on forumhome
-Improved exclusion of no-permissions-to-view and private forums from stats
-Added option to move "Latest Posts" to the left in Stats box
v5.3 - May 03. 2007.
-Added option to exclude styles from new/old colorizing
v5.4 - May 06. 2007.
-New: "Latest Classified Ads"
-Fixed bug where thread redirects are shown in "Latest Posts"
-Improved tables and background color switching
v5.5 - Sep 06. 2007.
-Group membership checking improved (works now for supplementary usergroups)
-Optimized (including: one less query, some unneeded lines removed,...)
-Several minor bugs fixed
v5.6 - Oct 08. 2007.
-Fixed bug where users are not displayed using tags from their "display usergroup"
-New: Timecut (count data from last x days only)
-Individual stats can be excluded from Timecut
-Removed New/Old-Color settings, used "time" CSS settings to mark old data
-New: "Top Reputations" now shows Reputations+Reputation Level
-New: "Top Infractions" now shows Infractions+Infraction Points
-"Top Thread Starters" does not require MySQL version 4.0.4 or higher to work anymore
-Several minor bug fixes and improvements in code...
v5.7 - Oct 22. 2007.
-New option: "Show actual reputations instead of reputations given by members"
-Minor bug fixes


Click INSTALL if you like this plug-in.


LIVE DEMO: http://www.bihforum.com

Download Now

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

Screenshots

Click image for larger version

Name:	st1.jpg
Views:	6882
Size:	25.5 KB
ID:	63210   Click image for larger version

Name:	st2.jpg
Views:	7413
Size:	42.0 KB
ID:	63211   Click image for larger version

Name:	stats_more.jpg
Views:	7817
Size:	46.9 KB
ID:	63212   Click image for larger version

Name:	disabled_note.jpg
Views:	3621
Size:	51.7 KB
ID:	63213  

Click image for larger version

Name:	ql_enable.jpg
Views:	4967
Size:	46.1 KB
ID:	63214   Click image for larger version

Name:	options1.jpg
Views:	2482
Size:	130.3 KB
ID:	70777   Click image for larger version

Name:	options2.jpg
Views:	1678
Size:	136.7 KB
ID:	70778  

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
Statistics Modifications Cyb - Advanced Forum Statistics Valter vBulletin 3.7 Add-ons 651 02 Sep 2013 12:25
Cyb - Advanced Forum Statistics Valter vBulletin 3.5 Add-ons 116 16 May 2010 02:57

  #1351  
Old 20 Dec 2007, 19:24
zenkaizen zenkaizen is offline
 
Join Date: Jan 2007
This is a really useful mod, however I found that it slows down my forum index a lot. Normal load time without the mod installed is around 0.2 to 0.3s, and with the mod installed its around 1.6 to 2.3s. Currently using the Top 5 Hottest Threads, Most Viewed Threads, and Latest Posts.

After playing around with the queries, I found that removing AND `visible` = '1' and AND `open`!='10' from the WHERE clause speeds up the mod a lot. I'm wondering if there's any bad effects by doing this? Or do you have another suggestion to further optimize the queries.

The ideal way will be to cache them every x minutes or every hour. Pulling the stats dynamically all the time really slows down the forum index.

FYI: We're on a dedicated server with 200-300 online users during peak hours. The database is stored on an external server. Using vBMicroStats, with the mod enabled the load time is around 10% on PHP and 90% on MySQL. Without the mod, it's almost 50-50.
Reply With Quote
  #1352  
Old 22 Dec 2007, 13:02
jaskel jaskel is offline
 
Join Date: Nov 2007
Location: Australia
Thumbs up

great job, wrks great on my forum, see for urself;

www.dodge-downunder.com
Reply With Quote
  #1353  
Old 24 Dec 2007, 10:02
baghdad4ever baghdad4ever is offline
 
Join Date: May 2007
Real name: husam
Originally Posted by baghdad4ever View Post
hi


can you tell me how to add

the most active member today in forum???????


thanks

any idea please???
Reply With Quote
  #1354  
Old 24 Dec 2007, 13:32
Ultimate Killer Ultimate Killer is offline
 
Join Date: Sep 2007
Can you adjust the width of it?. I love the hack, thanks a lot
Reply With Quote
  #1355  
Old 25 Dec 2007, 12:51
DDIG DDIG is offline
 
Join Date: Nov 2007
Thumbs up

To anyone facing time display problems in their stats view: insert %H:%I (Capital H, capital I)

That worked for me!

I've installed it, now I am translating it to Dutch! All phrases can be found with prefix "Cyb", which is great.

Thanks a lot for this plugin/hack.

I am a bit concerned however, having read about increased load times. Does anyone know if it's possible to display page load times in vBulletin forum? SMF is able to display page load times and #queries used at the bottom of each page, but I have not discovered this in vBulletin's options.
Reply With Quote
  #1356  
Old 26 Dec 2007, 13:30
iulianh iulianh is offline
 
Join Date: Dec 2007
Real name: Iulian Horatiu
Thanks , i was looking for this one !
Reply With Quote
  #1357  
Old 29 Dec 2007, 04:15
4number8 4number8 is offline
 
Join Date: Nov 2004
Thanks for this, my favorite hack and it works with 3.7 perfectly
Reply With Quote
  #1358  
Old 29 Dec 2007, 05:29
jarosciak jarosciak is offline
 
Join Date: Apr 2005
Originally Posted by zenkaizen View Post
This is a really useful mod, however I found that it slows down my forum index a lot. Normal load time without the mod installed is around 0.2 to 0.3s, and with the mod installed its around 1.6 to 2.3s. Currently using the Top 5 Hottest Threads, Most Viewed Threads, and Latest Posts.

After playing around with the queries, I found that removing AND `visible` = '1' and AND `open`!='10' from the WHERE clause speeds up the mod a lot. I'm wondering if there's any bad effects by doing this? Or do you have another suggestion to further optimize the queries.

The ideal way will be to cache them every x minutes or every hour. Pulling the stats dynamically all the time really slows down the forum index.

FYI: We're on a dedicated server with 200-300 online users during peak hours. The database is stored on an external server. Using vBMicroStats, with the mod enabled the load time is around 10% on PHP and 90% on MySQL. Without the mod, it's almost 50-50.


Same problem on my forum. I am running these stats on a forum with just little over 300k posts and it's basically killing it. It adds up good 3-5 additional seconds to display the main page.

And consider, that this forum is the only website on a very strong dedicated server.
It shouldn't take a more than split of a second to get these stats, so why doesn't it work properly?

Whenever someone hits the main page, this script would use almost 100% of 3gh dual pentium cpu power.

As soon as I disable it, the whole forum is flying like usually.

I don't want to get rid of these stats as me and all my members got used to it, and it's a truly awesome script, but someone should look at this issue and let us know what is happening.

Anyhow, to give you little more details...I am only showing Top Posters, Newest Members and Latest Posts.

I have also removed AND `visible` = '1' and AND `open`!='10' from the WHERE clause and it helped a little bit. But still taking crazy lot of time to generate the front page stats.
Reply With Quote
  #1359  
Old 30 Dec 2007, 07:02
DDIG DDIG is offline
 
Join Date: Nov 2007
Originally Posted by finereader View Post
...
I have a probleme with DATE and TIME FORMAT (I use vB 3.6.5 but problem still since old versions)

date appears like "h:i" in forum home statistics

Whatever the term entered in this field, i can see the exact term copied in forum home statistics..

All the forum is in good date..
I have the same problem. See below:


Times are not displayed correctly.

When I switch to 'Dutch' the '%' characters takes care of correct displaying of Times (kind of).

But when I switch to english the % markup is beeing displayed.

Dutch:

Discussie Datum, Tijd Geplaatst door Forum Daar waar je de... ? 28-12-07, 08:08 HansNijenhuis Landschappen
De eerste... ? 28-12-07, 08:08 DDIG Showcase-overl...
High Key ? 28-12-07, 07:07 Arjen Fotografie
Kort maakt lang ? 28-12-07, 06:06 Provorm Natuur overig
lokatie foto... ? 28-12-07, 00:12 HansNijenhuis Service balie
Pimpelmees/roodb... ? 27-12-07, 23:11 HansNijenhuis Showcase...
overgang... ? 27-12-07, 23:11 HansNijenhuis Diggers...
nog een koude ? 27-12-07, 23:11 HansNijenhuis Landschappen
De Showcase ? 27-12-07, 23:11 robert Moderator-over...
Wintersfeer ? 27-12-07, 23:11 HansNijenhuis Flora &...

English:

Thread Date, Time Posted By Forum Daar waar je de... ? %28-%12-%07, %08:%0 HansNijenhuis Landschappen
De eerste... ? %28-%12-%07, %08:%0 DDIG Showcase-overl...
High Key ? %28-%12-%07, %07:%0 Arjen Fotografie
Kort maakt lang ? %28-%12-%07, %06:%0 Provorm Natuur overig
lokatie foto... ? %28-%12-%07, %00:%0 HansNijenhuis Service balie
Pimpelmees/roodb... ? %27-%12-%07, %23:%0 HansNijenhuis Showcase...
overgang... ? %27-%12-%07, %23:%0 HansNijenhuis Diggers...
nog een koude ? %27-%12-%07, %23:%0 HansNijenhuis Landschappen
De Showcase ? %27-%12-%07, %23:%0 robert Moderator-over...
Wintersfeer ? %27-%12-%07, %23:%0 HansNijenhuis Flora &...
Reply With Quote
  #1360  
Old 30 Dec 2007, 20:28
Jase2 Jase2 is offline
 
Join Date: Dec 2007
Great, works with 3.7.0 BETA 3.

Thanks a lot.

Regards Jason
Reply With Quote
  #1361  
Old 30 Dec 2007, 20:30
Jase2 Jase2 is offline
 
Join Date: Dec 2007
How would you hide this from guests?

What code and where would I add it?

Thanks

Regards Jason
Reply With Quote
  #1362  
Old 30 Dec 2007, 20:34
Jase2 Jase2 is offline
 
Join Date: Dec 2007
Never mind, I've done it hehe.

Regards Jason
Reply With Quote
  #1363  
Old 30 Dec 2007, 21:51
Fungsten Fungsten is offline
 
Join Date: Jul 2006
Originally Posted by zenkaizen View Post
This is a really useful mod, however I found that it slows down my forum index a lot. Normal load time without the mod installed is around 0.2 to 0.3s, and with the mod installed its around 1.6 to 2.3s. Currently using the Top 5 Hottest Threads, Most Viewed Threads, and Latest Posts.

After playing around with the queries, I found that removing AND `visible` = '1' and AND `open`!='10' from the WHERE clause speeds up the mod a lot. I'm wondering if there's any bad effects by doing this? Or do you have another suggestion to further optimize the queries.

The ideal way will be to cache them every x minutes or every hour. Pulling the stats dynamically all the time really slows down the forum index.

FYI: We're on a dedicated server with 200-300 online users during peak hours. The database is stored on an external server. Using vBMicroStats, with the mod enabled the load time is around 10% on PHP and 90% on MySQL. Without the mod, it's almost 50-50.
I'm not that familiar with queries. Could you tell me the exact command to use please?
Thank you.
Reply With Quote
  #1364  
Old 30 Dec 2007, 23:00
R1lover's Avatar
R1lover R1lover is offline
 
Join Date: Apr 2006
Location: Northern Ca
Originally Posted by Fungsten View Post
I'm not that familiar with queries. Could you tell me the exact command to use please?
Thank you.
That may be true on shared hosting server with slow performance... I notice no change in my sites, but they are running on my own servers too.
Reply With Quote
  #1365  
Old 03 Jan 2008, 01:17
skiseiju skiseiju is offline
 
Join Date: Mar 2007
Moderated thread's title not hidden in "Latest threads"(Not Latest post)
it's any setting wrong?
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 16:31.

Layout Options | Width: Wide Color: