Statistics Modifications - Cyb - Advanced Forum Statistics

PLEASE CHECK OUT THIS THREAD FOR FEATURE SUPPORT:
https://vborg.vbsupport.ru/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

[zenkaizen]

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.

[jaskel]

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

www.dodge-downunder.com

[baghdad4ever]

Originally Posted by baghdad4ever

hi


can you tell me how to add

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


thanks

any idea please???

[Ultimate Killer]

Can you adjust the width of it?. I love the hack, thanks a lot

[DDIG]

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.

[iulianh]

Thanks , i was looking for this one !

[4number8]

Thanks for this, my favorite hack and it works with 3.7 perfectly

[jarosciak]

Originally Posted by zenkaizen

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.

[DDIG]

Originally Posted by finereader

...
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 &...

[Jase2]

Great, works with 3.7.0 BETA 3.

Thanks a lot.

Regards Jason