About this hack:
This idea and part of this hack are a port over from a hack made for vb3.0 called Moderator Management System. I have changed the name since I did not include the weekly PMs about your mods in this hack. This hack only gives you a page you can go to view stats on your mods. Although I did not include the weekly email, I have improved the hack in many ways. I have also added detailed columns of each type of action there is for a moderator to do. You can see what type off actions your moderators do.
Setting to add other usergroups to the stats (eg. smods and admin)
Setting for who can view the stats
Only a plug-in. No FTP file uploading required.
Can sort by any category
Many more ...
List of Stats:
Last Activity
Posts
Posts in His Forums
Threads Started
Threads Started in His Forums
Total Moderator Actions
Average Per Day of Total Moderator Actions
Advanced stats drop down for split moderator actions types.
Installation information on hack:
Files edited: 0
Templates edited: 0
Files to upload: 1
Time to install: 5 seconds max
Updates:
Version 1.0 (01/25/06):
Release
Version 1.1 (01/27/06):
FIX Normal error if no mods come up.
FIX Fixed sql error if you have no mods and were just using this hack to capture usergroups.
Version 1.2 (01/31/06):
ADD Average Moderator Actions Per Day
ADD Advanced moderator action stats.
Version 1.3 (03/20/06):
CHANGED Changed how the Advanced moderator action stats show.
Please post your comments or suggestions for this hack. I read ALL posts.
MAKE SURE YOU CLICK INSTALL! You will get an email when a new version is released.
This hack is created for your use free of charge. No payment is requested. However, if you would like to donate money for the work I put in to this hack, a donation would show your appreciation.
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
Database error in vBulletin 3.5.3:
Invalid SQL:
SELECT userid, count(*) AS total
FROM moderatorlog AS moderatorlog
WHERE dateline >= 1135710669 AND userid IN ()
GROUP BY userid;
MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
GROUP BY userid' at line 3
Error Number : 1064
Date : Thursday, January 26th 2006 @ 07:11:09 PM
Script : http://www.jabbatown.com/forum/misc....oderator_stats
Referrer :
IP Address : xxxxxxxx
Username : xxxxxxxx
Classname : vb_database
Database error in vBulletin 3.5.3:
Invalid SQL:
SELECT userid, count(*) AS total
FROM moderatorlog AS moderatorlog
WHERE dateline >= 1135710669 AND userid IN ()
GROUP BY userid;
MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
GROUP BY userid' at line 3
Error Number : 1064
Date : Thursday, January 26th 2006 @ 07:11:09 PM
Script : http://www.jabbatown.com/forum/misc....oderator_stats
Referrer :
IP Address : xxxxxxxx
Username : xxxxxxxx
Classname : vb_database
Any ideas? Could it be another hack causing this?
Some one else got this same error. I will look into it.
I wonder if it will be the same if you used the extension (I believe you just had to upload the file in the initial release), and not the plugin.
I just found something. Can you make sue you have moderators? Add in the settings that usergroup 6 should show in the stats. Do you still get the same error?
(This suggestion goes for the other user who also got the database error.)
Moderator Statistics Details »»
About Developer
Uses Plugins 
No support by the author.
01-26-2006, 04:41 PM
