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.

[PGAmerica]

Originally Posted by PGAmerica

Can somebody please tell me how to manually add this to my navbar template? I just need to know the exact code to add.

Is there any help to my problem?

[Xenofox]

Am i the only one who sees no infractions when limiting the time of the reports, instead of all time.?

[PGAmerica]

Is there any support for this mod at all?

[KURTZ]

Originally Posted by PGAmerica

Is there any support for this mod at all?

i think not mate ... this hack is still glitched ...

[smirkley]

Cyb, like this mod alot.

Hoping at your convenience, that it could be fixed where admins, smods, and mods, are all included by the selector to show stats.

I have played with the settings, but am unable to get the mods, currently appointed, and their stats, to show up yet.

Thanks in advance.

[Blind Guardian]

Originally Posted by Xenofox

Am i the only one who sees no infractions when limiting the time of the reports, instead of all time.?

No, you're not. I have the same issue, and had come here to try and find a solution myself.

Glancing at the code, I'd think it's a problem with the query not specifying the dateline properly, but I haven't tried tweaking the query to see if I can fix it yet.

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

It might be that $cybmodstats_timeperiod is pulling from the mod log, and not the infaction log?

[Blind Guardian]

So no one has any input on why limiting the number of days shown breaks the infraction totals?

EDIT: Nevermind, I fixed the bad query myself.

[mrcrx]

Originally Posted by Blind Guardian

So no one has any input on why limiting the number of days shown breaks the infraction totals?

EDIT: Nevermind, I fixed the bad query myself.

Can you share how you fixed it? I really dont know where to start.

[Blind Guardian]

Under "Cyb - Moderating Stats - MN" in the Plugin Manager, I changed this:

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

To this:

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

The problem was that the "$cybmodstats_timeperiod" being called in the query for the infractions was appending a "moderatorlog." prefix onto the "dateline" row, meaning it wasn't there in the infactions table. Removing it just pulls the regular dateline from that table and it works.

This will probably break the option to disable the time limitation on the logs, but I don't need that so it was the quickest fix for me.

What I'm currently trying to work out is why all of a sudden the "moderator posts in their own forums" fields are gone. Those were useful.

[Valter]

Originally Posted by Blind Guardian

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

This is not part of my hack.

Here is original query:

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