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.
getting a sql error on this. anyone have an idea how to fix?
Code:
Database error in vBulletin 3.5.3:
Invalid SQL:
SELECT userid, count(*) AS total
FROM moderatorlog AS moderatorlog
WHERE dateline >= 1135705843 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 @ 11:50:43 AM
Script : http://xxxxxx/board/misc.php?do=moderator_stats
Referrer :
IP Address : xxxxx
Username : xxxxx
Classname : vB_Database_MySQLi
also getting
Warning: array_unique() [function.array-unique]: The argument should be an array in /misc.php(86) : eval()'d code on line 161
a bunch of
Warning: Invalid argument supplied for foreach() in /misc.php(86) : eval()'d code on line 168
and a
Warning: implode() [function.implode]: Bad arguments. in /misc.php(86) : eval()'d code on line 181
I installed, but it just hangs when I try to access it. How does it retrieve the data? If it's searching for raw info in the database, this may not be suitable for large forums like mine.
This is what I get when I run it:
Server Load Averages 20.74 7.92 5.21 | 737 Users Online
getting a sql error on this. anyone have an idea how to fix?
Code:
Database error in vBulletin 3.5.3:
Invalid SQL:
SELECT userid, count(*) AS total
FROM moderatorlog AS moderatorlog
WHERE dateline >= 1135705843 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 @ 11:50:43 AM
Script : http://xxxxxx/board/misc.php?do=moderator_stats
Referrer :
IP Address : xxxxx
Username : xxxxx
Classname : vB_Database_MySQLi
also getting
Warning: array_unique() [function.array-unique]: The argument should be an array in /misc.php(86) : eval()'d code on line 161
a bunch of
Warning: Invalid argument supplied for foreach() in /misc.php(86) : eval()'d code on line 168
and a
Warning: implode() [function.implode]: Bad arguments. in /misc.php(86) : eval()'d code on line 181
I see you are using MySQLi, I didn't do any test on it. I will look at the code tonight to see what I can come up with.
I installed, but it just hangs when I try to access it. How does it retrieve the data? If it's searching for raw info in the database, this may not be suitable for large forums like mine.
This is what I get when I run it:
Server Load Averages 20.74 7.92 5.21 | 737 Users Online
It only uses about 4 queries besides the standard queries that run on every click. No queries just pull all info. They all have limits as far as I remember.
When we talk about God, we refer to 'him' as 'him'. 'Him' is normal for languge when it can be either or. If you dont like it, you can edit the phrase. The hack is fully phrased.
Moderator Statistics Details »»
About Developer
Uses Plugins 
No support by the author.
01-26-2006, 03:53 PM
