Statistics Modifications - Cyb - Top Posters In Month X

vB 3.7 VERSION HERE:
https://vborg.vbsupport.ru/showthread.php?t=177963

===

Info:
Top posters statistics for any single month


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


To set options go to:
vBulletin Options > Cyb - Top Posters In Month X


Versions:
v1.0 - Dec 09. 2006.
-Initial release
v1.1 - Mar 07. 2007.
-Text fields changed to menus
-Guests automatically excluded from stats
-Updated query for better compatibility with different servers
-Updated ACP settings to allow you to list available years and number of results in menus
v1.2 - May 01. 2007.
-Bug fix (post count in current month bigger than total post count for some users)
-Improved compatibility with right-to-left styles
-Some code optimizations
v1.3 - Aug 05. 2007.
-Added page navigation
-Added option to view top posters in whole year
-Added option to exclude users from stats
-Added option to exclude forums from counts
-Group membership checking works now for supplementary usergroups too
v1.4 - Aug 06. 2007.
-Fixed bug where guest posts are counted and shown as blank line in stats
-Page navigation also shown at the bottom of the page
v1.5 - Sep 15. 2007.
-Another "unknown poster" bug fix
-Fixed bug where month is switched to current one on page select
-Easier to set years (set starting year only, others are generated automatically)
-Several minor bug fixes...


Click INSTALL if you like this hack.

[Valter]

Live demo here:
http://www.bihforum.com/misc.php?do=cybtpimx

It's in Bosnian but you can see all you need.


Kihon,

Be sure you have put right usergroup IDs and separated them with ','.

[Quantnet]

very nice. Installed.

It would be nicer if the month and year box have drop down menu instead of typing in. Just a suggestion

[lovelypk]

cool. Installed.

[Kihon Kata]

of course. This was an easy hack to understand and I thought I understood it correctly.

http://www.makeuptalk.com/images/temp/test1.jpg

http://www.makeuptalk.com/images/temp/test2.jpg

Many of my my moderators and admins are on that page

Not working

Originally Posted by Cybernetec

Kihon,

Be sure you have put right usergroup IDs and separated them with ','.

[Valter]

Hi Kihon,

Screenshot 2 has nothing with my hack.
As I can see at the bottom of the table on screenshot it's some Paul M's hack.

To access top posters in month x page you need to point your browser to FORUMS/misc.php?do=cybtpimx

[Kihon Kata]

Originally Posted by Cybernetec

Hi Kihon,

Screenshot 2 has nothing with my hack.
As I can see at the bottom of the table on screenshot it's some Paul M's hack.

To access top posters in month x page you need to point your browser to FORUMS/misc.php?do=cybtpimx

LMAO! You're right. OMG. Sorry! Looking/working good now.

[zethon]

I changed the following query:

PHP Code:

            $cub_tpim_get = $vbulletin->db->query_read_slave("
                SELECT COUNT(post.dateline) AS cybpcount, post.userid, user.username, user.usergroupid, post.visible, user.posts, user.joindate
                FROM " . TABLE_PREFIX . "post AS post
                LEFT JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)
                WHERE post.visible = '1' AND post.dateline > $fromtime AND post.dateline < $totime $cybexclgroups
                GROUP BY userid
                ORDER BY cybpcount
                DESC LIMIT $nrofresults
            "); 


I changed it to:

WHERE post.visible = '1' AND post.dateline > $fromtime AND post.dateline < $totime $cybexclgroups AND post.userid != 0

I allow some Guest posts. These were being included in the original script with blank usernames. This took care of the problem.

[Quantnet]

Thanks Mike-D
Works great

[hoopsta]

what is the actual url to find this info? I have a custom template with no drop-down box

[Terminatoronly]

thanks for releasing this hack i need it much installed and nominated for mod of the month