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.
hi Abe1
as i said before........they are even not active ...and i deleted all the logs older than 30 days.....and removed any mention to their modereation....their name remains there.........
i mean .they even sho zero zero in everything in the stats....and they are elite group now...
i read threw a few pages, anyone realize this shows past moderators who are no longer mods due to joinng for the users on the moderator table.
the poor man's way to do this is to change this:
Code:
SELECT user.*
FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN ".TABLE_PREFIX."moderator AS moderator USING (userid)
WHERE moderator.userid = user.userid $additional_usergroups
ORDER BY user.username
to
Code:
SELECT user.*
FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN ".TABLE_PREFIX."moderator AS moderator USING (userid)
WHERE moderator.userid = '' $additional_usergroups
ORDER BY user.username
Then change around a few lines of text for the options so that you now MUST SPECIFY which groups you want to show.
I realize this is a poor way to do it, however, it is a very simple way that 99% of people can understand. the right way would be to re-write the query not joining on the moderator table. i think the intentions were right w/ joining, however, right join by the way your query is setup would be the join you were after and even then the query is not right. i am out of time for looking at this.
This is what Im getting when I attempt to use the misc.php?do=moderator_stats
you do not have permission to access this page. This could be due to one of several reasons:
1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Im the SuperAdmin. What do I need to do to see the stats..
Moderator Statistics Details »»
About Developer
Uses Plugins 
No support by the author.
02-12-2007, 12:05 PM
