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.

[Domenico]

Originally Posted by Schnee

Any idea why mine shows NO infractions at all?

Even when I just did some?

Do infractions need to be Warnings to show up?

Same here! I only see them when I set 'Show Mod log entries from last X days only' to NO.

Can you please fix this?

[proxx]

does anyone know how to make moderator stats count only stats of mod actions in certain forums and not all forums?

[Valter]

Released for vB4 here:
https://vborg.vbsupport.ru/showthread.php?t=236630

[adriatic21]

I try to install, but I have this message

XML Error: not well-formed (invalid token) at Line 0

what is problem?
thanks for the help.

[ORP]

Thanks, cool mod.

I've had good luck with other Cyb mods so I jumped on this one. I did use a different mod stat hack, which is currently quarentined here on vb.org. It had a few cool features that would be a big plus to this hack.
It showed the mods activity for the time period in question ...instead of total posts is showed the number of posts for the period and the number of threads started for the time period only.
If you needed columns freed up to add this new stuff I would suggest you delete total posts, date joined and date of last activity.
Any chance of getting this info added to this hack or is it wishful thinking?

[merk_aus]

Thanks for this I love all of your mods they are the first ones I come to get when setting up a forum.

[Samish]

Got a query, I have changed the original url for the /admincp and this is stopping the log for Moderating Actions from going anywhere, I just get a 404 page from where the page used to be. Where is the coding for this and how do I change it? Thanks

Brilliant plugin however.

[bulbasnore]

Originally Posted by Domenico

Same here! I only see them when I set 'Show Mod log entries from last X days only' to NO.

Can you please fix this?

The workaround for me is to turn off the 'time period'. When that is marked 'no' it works to show infractions and points.

I'm guessing this has to do with the evil php 5.3.1 I am running. I'm guessing it has broken this construct:

PHP Code:

if ($vbulletin->GPC['cybms_del']<1)
            {
                $cybmodstats_timeperiod = "";
                $cybmodstats_timeperiod_tot = "";
                [B]if ($vbulletin->options['cybmodstats_time_period'])
                {
                    $fromtime = TIMENOW - ($vbulletin->options['cybmodstats_period_days']*24*60*60);
                    $cybmodstats_timeperiod = "AND moderatorlog.dateline > $fromtime";
                    $cybmodstats_timeperiod_tot = "WHERE dateline > $fromtime";
                }[/B] 


Valter?

--- later ---

OK, comparing to his 4.0 product I came up with this fix. Sorry to go all Unix 'diff' utility on you folks, but I'm off to shop for my wife's birthday.

diff -c Cyb_MS.xml Cyb_MSfixed.xml
*** Cyb_MS.xml	2008-10-26 14:55:56.000000000 -0700
--- Cyb_MSfixed.xml	2010-10-18 20:20:44.000000000 -0700
***************
*** 84,94 ****
--- 84,96 ----
  			{
  				$cybmodstats_timeperiod = "";
  				$cybmodstats_timeperiod_tot = "";
+ 				$cybmodstats_timeperiod_inf = "";
  				if ($vbulletin->options['cybmodstats_time_period'])
  				{
  					$fromtime = TIMENOW - ($vbulletin->options['cybmodstats_period_days']*24*60*60);
  					$cybmodstats_timeperiod = "AND moderatorlog.dateline > $fromtime";
  					$cybmodstats_timeperiod_tot = "WHERE dateline > $fromtime";
+ 					$cybmodstats_timeperiod_inf = "AND dateline > $fromtime";
  				}			
  				$cybmodstats_exclgroups = "";
  				if ($vbulletin->options['cybmodstats_exclgroups'])
***************
*** 114,120 ****
  					if ($vbulletin->options['cybmodstats_enable_infractions'])
  					{
  						$cybmodstats_infpoints = 0;
! 						$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' $cybmodstats_timeperiod ");
  						$cybmodstats_infractions = $db->num_rows($cybmodstats_get_infr);
  						while ($cybmodinfractions = $db->fetch_array($cybmodstats_get_infr))
  						{
--- 116,122 ----
  					if ($vbulletin->options['cybmodstats_enable_infractions'])
  					{
  						$cybmodstats_infpoints = 0;
! 						$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' $cybmodstats_timeperiod_inf ");
  						$cybmodstats_infractions = $db->num_rows($cybmodstats_get_infr);
  						while ($cybmodinfractions = $db->fetch_array($cybmodstats_get_infr))
  						{

[besedka]

thank you

[jscieza]

Valter can you please also fix this vB 3.8.x version as you have done with the 4.x one?

v2.0.1 - Feb 25. 2010.
-Fixed bug with timecut in Infraction stats

Thank you,
Jonathan