Statistics Modifications - Cyb - Moderating Stats

Info:
Get Moderating Statistics on separate page with the following details included:
-Moderator listing with stats on moderating actions, infractions/infraction points given
-Last moderation action info for each Moderator
-Total number of active Moderators, moderating actions, given infractions/infraction points
-Oldest/Latest moderating actions info
-Some standard info about Moderators (join date, post count, last activity)

See screenshots...

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

To set options:
Go to: vBulletin Options > Cyb - Moderating Stats

Custom link position in "Quick Links":
-Disable automatic placement in hack options, then add "$cybmodstats_qllink" between desired TR cells in navbar template. Or simply create link anywhere you wish to "FORUM/misc.php?do=cybmodstats".

Versions:
v1.0 - Aug 22. 2007.
-Initial release
v1.1 - Aug 24. 2007.
-New: Infraction Stats:
*Infractions given by moderator
*Infraction points given by moderator
*Total infractions given
*Total infraction points given
-ACP option to disable infraction stats
-Options to remove entries logged by X from Moderator Log
v1.2 - Sep 25. 2007.
-Fixed bug where "Display Usergroup" user settings are not followed
-Minor bugs fixed
v1.3 - May 03. 2008.
-Compatible with vBulletin 3.7
-Minor bugs fixed
v1.4 - Jun 24. 2008.
-New: Option to exclude non-Admin/Mod entries from Moderator log
-New: Option to delete all non-Admin/Mod entries from Moderator log
-New: Option to exclude usergroups from stats
-New: View mod log entries generated by user
-Some code optimizations done, and some minor bugs fixed
v1.5 - Aug 02. 2008.
-Fixed bug where mods are not showing in the list, only global mods and admins
-Fixed bug where links to logs are not working if admincp dir name was changed
v1.6 - Oct 26. 2008.
-Fixed bug where not all mods are shown in stats
-Fixed bug where not all selected usergroups are excluded from stats
v1.6.1 - Oct 26. 2008.
-Fixed bug where forum mods are not included in stats

Mark as INSTALLED to get support and updates.

[Blind Guardian]

Indeed, my mistake. I didn't bother documenting exactly what I'd changed as I didn't perceive needing to explain it to anyone else, and didn't check what the original timeperiod variable included.

My explanation should have been replacing "$cybmodstats_timeperiod" alone with "AND dateline > $fromtime".

[Rideharder]

How can we fix it 'Under "Cyb - Moderating Stats - MN" in the Plugin Manager, I changed this'

Sorry to be a newbie..

Can you name how you fixed it step by step

Thasnk,
www.Speedaholic.net

[Blind Guardian]

In the Admin CP, under the Plugin Manager in Plugins & Products, edit the "Cyb - Moderating Stats - MN" plugin and find the line of code as follows:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' $cybmodstats_timeperiod ");

Simply replace that entire line with this:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' AND dateline > $fromtime");

[Rideharder]

Originally Posted by Blind Guardian

In the Admin CP, under the Plugin Manager in Plugins & Products, edit the "Cyb - Moderating Stats - MN" plugin and find the line of code as follows:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' $cybmodstats_timeperiod ");

Simply replace that entire line with this:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' AND dateline > $fromtime");

Thank you and all that worked on this Mod!

[mrcrx]

Thank you for the step by step. Works great!

[realmr]

For me it shows stats of only 1 admin . How can I make it to display for mods, admins and super mods as well.
I can give permission for other usergroups to view the content but I can't see any other option to add permission for remaining admins, super mods and mods to show up in stats
I have added this code:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' AND dateline > $fromtime");

as mentioned above so does this make this plugin to work so strange ?

[proxx]

I installed this. But I don't see what advantage it has over the old 'moderator stats' ?

As a matter of fact, I'm surprised that neither the old script nor this one has the option of excluding forums from being counted towards in moderator actions and posts.

If somebody could modify https://vborg.vbsupport.ru/showthread.php?t=139248 to allow me to forums from stats, I could pay for such a modification.

for example, i have off topic forum and support forum. I don't care the posts and moderation actions in off topic forum, but I would rather get stats of moderators in support forums.

Please PM me if you can do what I need.

[Nadeemjp]

awsome hack cyb installed

[Nadeemjp]

the moderation stat in the quick links menu doesnt display. instead it says "page not found"
what to do?

[KURTZ]

what about the usergroups trouble? i still haven't the global moderators onto this stats ... :S