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

[Jase2]

How would you hide this from guests?

What code and where would I add it?

Thanks

Regards Jason

[Jase2]

Never mind, I've done it hehe.

Regards Jason

[Fungsten]

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.

I'm not that familiar with queries. Could you tell me the exact command to use please?
Thank you.

[R1lover]

Originally Posted by Fungsten

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.

[skiseiju]

Moderated thread's title not hidden in "Latest threads"(Not Latest post)
it's any setting wrong?

[Valter]

Originally Posted by skiseiju

Moderated thread's title not hidden in "Latest threads"(Not Latest post)
it's any setting wrong?

Ensure that you have NOT applied query changes posted by some user above...

[newguy]

Is there a way to keep a members post not showing up in the latest post? (one particular member)

P.S. My rss bot is the one I do not want in there driving down the latest post from real members.

[mescalin]

I want to place stats between some forums, i edit "forumhome_forumbit_level1_nopost" template as in the codebox but it doesnt show up.. How can i enable it between forums in forumhome?

PHP Code:

<if condition="$forum[forumid] == 140">

    </table>

    <br />
    <div align="center">

$cybtopstats


    </div>
    <br />

    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
    <thead>
        <tr align="center">



          </if>
        </tr>
    </thead>

</if> 


[rbrashear68]

This mod is greatness! Thanks!

I would like to ask though if there's a possibility to add "Latest Blogs" to the options. (?)

Either way, still great!

[vietdjclub]

Please tell me this hack auto update or not auto. i installed but it seem not auto update. i must press F5 for showing update. how can i set it auto update.thansk