Moderator Statistics

[Abe1]

Moderator Statistics 1.3

vb3.6 version released here: https://vborg.vbsupport.ru/showthread.php?t=139248


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.

Features:

Uses vBulletin easy Product installer/updater/uninstaller
Full set of options
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 maxUpdates:

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 (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=106329)!
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.
https://vborg.vbsupport.ru/external/2010/02/12.gif (https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=bigware%40gmail%2ecom&item_name=Donation%20for%20Moderator%20Statistics% 20Hack&no_shipping=0&tax=0&currency_code=USD&bn=PP%2dDonationsBF&charset=UTF%2d8)

[Daniel]

Yayyy - thank you!

[Guest210212002]

/me clicks install

[GetGamer.com]

Nice work! I've been waiting for this for a while.

[Boofo]

Can the periodic email be added back to this and with a setting for how often you want to receive it?

[Snake]

Niiiice! Thanks! :)

[The Chief]

thanks this is great :)

* The Chief clicks install

[agiacosa]

Thank you!!!

[nexialys]

this is really good to know if the mods are doing a real job...

great hack!!!

[Guest210212002]

Yeah, fantastic addition. Now I can see when my team is slackin'.

Can you add a little christmas music to the background?

"He knows when you've been slackin'... He knows when you don't close posts... He knows who's a tot-tal for-um-nazi so close those posts for good-ness-sakes.."

/me dances

[Abe1]

Can the periodic email be added back to this and with a setting for how often you want to receive it?

I was very close to adding it, but for some reason when the cron would run by it self, it would not send the PM. Only when I would click 'run now' would the email get sent. I have to do some more research into it. I do plan on adding the PM feature just when I figure it out the problem.

[Kihon Kata]

Installed!!! This is an admin's dream! I have 10 moderators

[VBUsers]

installed and working great

[SoftWareRevue]

/me clicks Install

Thanks!

[uae]

Great Job, I like it :)
Installed

[evenmonkeys]

Thank you. I really like this hack.

[Azhrialilu]

sweet, thank you!

[PHPGeek2k3]

nice thank you

/me clicks install

another thing i was looking for

Thanks
- James

[tmcyouth]

my first install - thanks! it looks great, it'll be really useful.

just one (real picky) thing: is there any way to change 'posts in his forums' to 'posts in his/her forums' easily?

[pipin]

my first install - thanks! it looks great, it'll be really useful.

just one (real picky) thing: is there any way to change 'posts in his forums' to 'posts in his/her forums' easily?

Change that Phrase: $vbphrase[posts_his_forums]

[darksoulz]

getting a sql error on this. anyone have an idea how to fix?


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

[Martin]

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

[kall]

Posts in "His" forum?

What about people who have female moderators?

[Abe1]

getting a sql error on this. anyone have an idea how to fix?


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.

[Abe1]

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.

[Abe1]

Posts in "His" forum?

What about people who have female moderators?

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.

[Martin]

Here are my loads without it running:

2.95 2.55 3.30 | 799 Users Online

I have 94 forums, 44 mods, 4.6mil posts, ~274,000 threads.

I think it's the size of my forum that's causing problems. Pity, because this is a great hack idea.

[Abe1]

Here are my loads without it running:

2.95 2.55 3.30 | 799 Users Online

I have 94 forums, 44 mods, 4.6mil posts, ~274,000 threads.

I think it's the size of my forum that's causing problems. Pity, because this is a great hack idea.

That's alot of mods. I'll have to look into it.

[JsnakeJ]

/me installs.

Very useful hack.

[antialiasis]

What statistics does this hack show exactly?

[Martin]

That's alot of mods.

It's a big and somewhat active forum :)

[Abe1]

What statistics does this hack show exactly?

Look at the screenshot.

[Abe1]

It's a big and somewhat active forum :)

I just checked, my forum has 27 admin/smod/mod that show on stats. I have no problems. I will look into this though.

[Daniel]

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.php?do=moderator_stats
Referrer :
IP Address : xxxxxxxx
Username : xxxxxxxx
Classname : vb_database
Any ideas? Could it be another hack causing this?

[Abe1]

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.php?do=moderator_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.

[Daniel]

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.

[Abe1]

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.

That would have nothing to do with it.

[Abe1]

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.)

[Daniel]

Yes, I still get the same error.

[bashy]

Great m8 thanks, Clicked install

[S@NL - BlackBik]

Clean install, no errors: great :)

Clicked Install

[darksoulz]

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.)

That worked for me. We're not a real huge forum, and all we have are a couple of super-mods, no regular moderators. I added myself as a regular mod for one of the forums and it works perfectly now.

[Abe1]

That worked for me. We're not a real huge forum, and all we have are a couple of super-mods, no regular moderators. I added myself as a regular mod for one of the forums and it works perfectly now.

Good to know.

[vampireus]

Here are my loads without it running:

2.95 2.55 3.30 | 799 Users Online

I have 94 forums, 44 mods, 4.6mil posts, ~274,000 threads.

I think it's the size of my forum that's causing problems. Pity, because this is a great hack idea.

I feel pity too :disappointed: Can't use this great hack on my forum : 400+ forums, 300+ mods, 3mil posts, ~ 200k threads

[Abe1]

I feel pity too :disappointed: Can't use this great hack on my forum : 400+ forums, 300+ mods, 3mil posts, ~ 200k threads

i will try to figure out where the problem is. if u can give me access to your acp please pm me. i would want to put some breaks into the plugin and test where it takes long.

[WNxWakko]

works. Slow loading though, takes about 10 seconds and then the page appears. I have about 1.4 million posts and it pulled 140 moderators.

So is the load addition only when you pull this page? or is it adding load on your forum in general? I would assume only when you access this page.

[KingPooky]

Installed. I am also getting the same Mysql error.

[Abe1]

Installed. I am also getting the same Mysql error.

1) Do you have any regular mods?

2) If you do have regular mods and are getting this error, I need access to your acp so I can test some things with the forum.

[Abe1]

works. Slow loading though, takes about 10 seconds and then the page appears. I have about 1.4 million posts and it pulled 140 moderators.

So is the load addition only when you pull this page? or is it adding load on your forum in general? I would assume only when you access this page.

This hack does not add hooks functions to any other place on your forum.

[KingPooky]

1) Do you have any regular mods?

2) If you do have regular mods and are getting this error, I need access to your acp so I can test some things with the forum.

I have v3 Arcade 1.0.2 and some mods for it installed. That's it as far as I can remember.

I might also point out that I am still using vB 3.5.1. However, it does not seem to be any different.

[Abe1]

I have v3 Arcade 1.0.2 and some mods for it installed. That's it as far as I can remember.

I might also point out that I am still using vB 3.5.1. However, it does not seem to be any different.

They should not cause any problems. If you give me access to your acp, please PM me so I can find out where the bug is.

[Daniel]

I downloaded the "Add usergroup as a moderator" and added the regular moderator to a forum via that modification. Works now :) Thank you!

[GamerJunk.net]

Awesome, the old one was annoying with all the PMS

[WNxWakko]

I realize this mod pulls all members who are set as moderator of any given forum. Then you have the option to add usergroups in addition, however is their a way to turn off moderators data and only go by usergroups I specify?

By the way, sweet mod from you as always.

[Abe1]

I realize this mod pulls all members who are set as moderator of any given forum. Then you have the option to add usergroups in addition, however is their a way to turn off moderators data and only go by usergroups I specify?

By the way, sweet mod from you as always.

Well this is MOD stats.

Thanks for the commet :)

[Abe1]

Awesome, the old one was annoying with all the PMS

I do plan on trying to get the PMs back, but not one for each missing action. I have made the template for one PM stating all info.

[Killahbyte]

I'm also getting a sql error.

[agiacosa]

Abe1,

Suggestion for a future release. It would be great to set a parameter like minimum posts per 30 days in their own forum. Then, if a moderator is below that, the system would send him/her a pm warning.

That would save me the trouble of having to do it manually.

[Abe1]

I'm also getting a sql error.

I found the cause of 2 errors. I know how to correct one and am working on the other. When I finish, I will release it.

[Abe1]

Abe1,

Suggestion for a future release. It would be great to set a parameter like minimum posts per 30 days in their own forum. Then, if a moderator is below that, the system would send him/her a pm warning.

That would save me the trouble of having to do it manually.

PMs will be hopefully implemented in the future. I was just having a drop of trubble with them.

[Abe1]

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.

BTW, I see you guys realy like this hack. 74 installs in a day and a half!

[Omega Prime]

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.

BTW, I see you guys realy like this hack. 74 installs in a day and a half!

I was #70. Good work, abe1! :)

[Yorixz]

Wonderfull addon, I've been looking for such a 'tool' already, easy way to keep an eye on your mods!

[IrPr]

I was #70. Good work, abe1! :)

and im #77 :)
really nice work;)

[KingPooky]

Thanks Abe, appreciate the speed of the bug fixes.

[SnickersTK]

I was wondering :)

Could you add the colum "Total Moderations Done:" for each moderator, as you've done for all the other stats ("Edit/Del/Move/Close", etcetera).

and even more importantly: "Average moderations done a week" :D

So... You take total number of moderations done by the person, diveded by the number of days you've been a moderator and then you times that with 7 :)

https://vborg.vbsupport.ru/

X = Total Amount Of Moderations One Has Made.
Y = Total Amount Of Days One Has Been A Moderator.
7 = 1 Week.

The system aint perfect, but whatever :P

I would LOVE that!!!

I'm sure others would like it too :)
Those of us, who is fixated on numbers ;)

[vampireus]

Great, it works for me now

[Killahbyte]

This update did fix the error. Thank you very much

*Clicks install*

KB

[Abe1]

I was wondering :)

Could you add the colum "Total Moderations Done:" for each moderator, as you've done for all the other stats ("Edit/Del/Move/Close", etcetera).

and even more importantly: "Average moderations done a week" :D

So... You take total number of moderations done by the person, diveded by the number of days you've been a moderator and then you times that with 7 :)

http://img63.imageshack.us/img63/4706/math6ln.jpg

X = Total Amount Of Moderations One Has Made.
Y = Total Amount Of Days One Has Been A Moderator.
7 = 1 Week.

The system aint perfect, but whatever :P

I would LOVE that!!!

I'm sure others would like it too :)
Those of us, who is fixated on numbers ;)

the edit/delete/... is the total moderation.

please elaborate more on your percentage question.

[lazytown]

Would it be possible for this to track actions through the admincp as well? Such as approving new registrations?

-vissa

[lazytown]

Wow, when I view the stats page it basically brings my server to a halt (45 sec to generate). 25 secs on immediate 2nd run, 3.5 secs on 3rd immediate run (cached some tables I assume). Only 6 mods, but 1M posts. I'll probably have to set it so only I can view it for now.

There are quite a few things I don't need tracked.. Basically all my mods are "supermods" so I don't need to track things in "their forums." Usually a mod starts out with a forum but ends up a supermod. Is there any way to turn off some of those options to speed it up?


-vissa

[lazytown]

Bug Found:

If I enter "7" for posts in "his" forum within the ACP, when viewing the table it actually shows last 7 days of posts in all forums. Same for all other day entries (they appear to be reversed from what they should be ).

By the way, when it shows posts "edited" is it including the editing of your own posts? I would actually prefer to see moves/edits/closings listed separately rather than one total. Especially if edits include their own threads.

Thanks for the mod!!!
-vissa

[SnickersTK]

the edit/delete/... is the total moderation.

please elaborate more on your percentage question.

I mustn't have explained myself enough.

I want to keep the "Edit/Delete..." and let it show X numbers of moderation done in Y days.

But I also want a total.

https://vborg.vbsupport.ru/ (http://img78.imageshack.us/my.php?image=screenshot6jf.jpg)

Take a look at this, wrote it quickly :)
(And yes, I made tons of typo's because I randomly typed, but you should be able to spot my point, just look at Moderator 1-3)

And lets take a look shall we?

Moderator 1 has done 100 moderation's in total and lets assume he has been a moderator for 200 days.
We want to know how many he does in average a week.

SO.... [(100*7)/200] = 3.5 moderation's a week!

(On the table I've assumed all has been a moderator for 200 days, exactly)

Are you following me? It would be awesome if you could make it :rolleyes:

[Abe1]

I mustn't have explained myself enough.

I want to keep the "Edit/Delete..." and let it show X numbers of moderation done in Y days.

But I also want a total.

http://img78.imageshack.us/img78/1484/screenshot6jf.th.jpg (http://img78.imageshack.us/my.php?image=screenshot6jf.jpg)

Take a look at this, wrote it quickly :)
(And yes, I made tons of typo's because I randomly typed, but you should be able to spot my point, just look at Moderator 1-3)

And lets take a look shall we?

Moderator 1 has done 100 moderation's in total and lets assume he has been a moderator for 200 days.
We want to know how many he does in average a week.

SO.... [(100*7)/200] = 3.5 moderation's a week!

(On the table I've assumed all has been a moderator for 200 days, exactly)

Are you following me? It would be awesome if you could make it :rolleyes:

I would be able make some sort of thing like this. I would add some things like what the post above your's wants.

First, the total moderations is the same as edit/delete/move/close. Also, I there is no record on when a user becomes a Mod. If I would use from the first action, it would also mess up if a user was a mod then was downgraded and now, back a mod.

I will try to figure something out though that comprimises all ideas.

[Spiffware]

clicked install its a great progrma installed clean on 2 boards with no problem. love to see more features in the future like maybe howmany times a mod or admin accessed the cp and did a change or how manytimes a usergroup fixed a user status. would be kool too.

[caliman]

/me installs

Thanks this is a great mod!

[vtx1800]

Looks great, clicks INSTALL!

[lionslair]

I love this just want out committee needs to deal with moderators who do not pull there weight. Thank you.

[SnickersTK]

I would be able make some sort of thing like this. I would add some things like what the post above your's wants.

First, the total moderations is the same as edit/delete/move/close. Also, I there is no record on when a user becomes a Mod. If I would use from the first action, it would also mess up if a user was a mod then was downgraded and now, back a mod.

I will try to figure something out though that comprimises all ideas.

Glad to hear, and what a great mod :)

[asianboi]

is it possible to modify the admin cpanel to add the http://www.yourforum/misc.php?do=moderator_stats ?

[S@NL - BlackBik]

I have no idea. I can't find the templates for the admincp...

[Abe1]

is it possible to modify the admin cpanel to add the http://www.yourforum/misc.php?do=moderator_stats ?

I can. I would recommend you add the link to the navbar using the templates.

[Abe1]

I have no idea. I can't find the templates for the admincp...

You have to use an xml file.

[Abe1]

Version 1.2 (01/31/06):

ADD Average Moderator Actions Per Day
ADD Advanced moderator action stats.

Are there any oter stats that you guys would like added?

[caliman]

Thanks for the update!

I believe that there is a mod out there that shows total time spent in the forums. That would be a nice touch here - total time over the last X days.

[Abe1]

Thanks for the update!

I believe that there is a mod out there that shows total time spent in the forums. That would be a nice touch here - total time over the last X days.

There is no vBulletin tracking of time spent. I will not make this hack add tables or columns to your database nor will I add plug-ins around our forum.

[caliman]

Ok. How about this.. make the columns that display selectable in the admincp so we can turn some off. Version 1.2 goes across 3 widths of my monitor!

[Abe1]

Ok. How about this.. make the columns that display selectable in the admincp so we can turn some off. Version 1.2 goes across 3 widths of my monitor!

Sorry, though of it before you. There is a setting for it! Check your settings. Bottom one.

[caliman]

Ahhh.. that helps. It still busts my template a bit but I suppose I can adjust the table width. THanks!

[fluentdesigns]

Where do you access this mod, I cant find any links?

[caliman]

the link is in the install instructions.

[SnickersTK]

Version 1.2 (01/31/06):

ADD Average Moderator Actions Per Day
ADD Advanced moderator action stats.

Are there any oter stats that you guys would like added?

I love you, going to update right now!!!

[Yorixz]

Very nice upgrade <strike>but please; add back an option to group all the moderation actions into one row, this is making it unnecessarely big and chaotic imho.</strike>
Didn't notice the option :X

Keep up the great work though!

[IrPr]

Version 1.2 (01/31/06):

ADD Average Moderator Actions Per Day
ADD Advanced moderator action stats.

Are there any oter stats that you guys would like added?

Thanks! :)
would this be and extention such az modstats.php ?

[lazytown]

THANK YOU! I love the fact that it shows the actions separately now!

-vissa

[Abe1]

Very nice upgrade <strike>but please; add back an option to group all the moderation actions into one row, this is making it unnecessarely big and chaotic imho.</strike>
Didn't notice the option :X

Keep up the great work though!

There is a row called "Total Moderator Actions" It's the same as the edit/delete/...

[Abe1]

Thanks! :)
would this be and extention such az modstats.php ?

misc.php?do=moderator_stats

[agiacosa]

Abe1,

Another request.

I have my mods looking at this to see if they are meeting the minimum requirements. It would be great if I could set those minimum requirements via admincp. If any stat is under those requirements for a particular mod, then the stat would show up in red. If over, it would show up in green. This way it is easy for them to see what they need to do to get up to minimum standards.

Thanks.

[Abe1]

Abe1,

Another request.

I have my mods looking at this to see if they are meeting the minimum requirements. It would be great if I could set those minimum requirements via admincp. If any stat is under those requirements for a particular mod, then the stat would show up in red. If over, it would show up in green. This way it is easy for them to see what they need to do to get up to minimum standards.

Thanks.

This would require some coding that most other user would not like.

You can do this by your self using the templates. In 'moderator_stats_bit', you can add an 'if condition' to each output.

Eg.
Find:
<td class="$bgclass">$moderatorstats[1]</td>
and replace with:
<if condition="$moderatorstats[1] < 10">
<td class="$bgclass"><font color="red">$moderatorstats[1]</font></td>
<else />
<td class="$bgclass"><font color="green">$moderatorstats[1]</font></td>
</if>

[lionslair]

Great update thank you.

[agiacosa]

Abe1,

No problem doing it myself. Thanks for the conditional. Are the stats listed somewhere so that I know what condition to use?

[agiacosa]

Never mind, figured it out. Thanks.

[vampireus]

Hi Abe1, is it possible to show "Post in His Forum" and "Thread is His Forum" per forum which the mod belongs to, it might be a drop-down menu from the total #. And where can I turn off some stats of the advanced mod actions, since 30 row is way overkill, too details :)

Thanks

[Abe1]

Hi Abe1, is it possible to show "Post in His Forum" and "Thread is His Forum" per forum which the mod belongs to, it might be a drop-down menu from the total #. And where can I turn off some stats of the advanced mod actions, since 30 row is way overkill, too details :)

Thanks

I dont think I will do any. It would be oo uch to show where he has his posts. Also, I have one setting that totaly remove view of the advanced mod actions. I dont want 30 separate settings for each group.

[vampireus]

I meant posts & threads in forums which he is a moderator, not all forums he is posting. One can be mod of several forums, max 3 in my board.

For the advanced mod actions, where can I remove stats or table of the actions I don't want to show <edit a template?>

[Abe1]

I meant posts & threads in forums which he is a moderator, not all forums he is posting. One can be mod of several forums, max 3 in my board.

For the advanced mod actions, where can I remove stats or table of the actions I don't want to show <edit a template?>

I know what you ment. On your forums it's max 3, on mine they can have 10, on anther one they can have 20.

[JsnakeJ]

Its too stretched out for my liking in the newer version. Maybe you can make it so that you only look at one user at a time and have it use multiple rows for that one user you chose. I think that would make it much better. :)

[Abe1]

Its too stretched out for my liking in the newer version. Maybe you can make it so that you only look at one user at a time and have it use multiple rows for that one user you chose. I think that would make it much better. :)

Maybe I'll add that in the future. For now, you can disable it.

[S@NL - BlackBik]

Thanks abe1, nice additions :)

[IrPr]

Maybe I'll add that in the future. For now, you can disable it.

Waiting for next update!
i think just template modifications needed

[Sarver]

Where do you access this mod, I cant find any links?

http://(your forum name here)/forums/misc.php?do=moderator_stats

Here ya go. :) Enjoy

[vtx1800]

The update is great. The columns are a bit much. Maybe a dropdown to pick the mod you want, with the page loading with less columns and more rows.

But still a kick ass feature. Very well done.

[WNxWakko]

nice addition, but damn that is a major scroll off to the right. hard to read it all at once.

[S@NL - BlackBik]

I've removed all the nowrap="nowrap" options from the td tags.
That way it becomes a lot smaller.

[lazytown]

Bug Found:

The totals for "Total Moderator Actions" in the last 30 days appears to be correct.

However, if you change all the settings to 90 days, for example, the "Total Moderator Actions" numbers appear to change, but all the rest of the advanced mod action counts stay exactly the same (and don't add up).

Love the mod!
-vissa

[Abe1]

Bug Found:

The totals for "Total Moderator Actions" in the last 30 days appears to be correct.

However, if you change all the settings to 90 days, for example, the "Total Moderator Actions" numbers appear to change, but all the rest of the advanced mod action counts stay exactly the same (and don't add up).

Love the mod!
-vissa

I just looked at the code, there is nothing I can find that would make this happen. Do you have a screen shot or numbers you added up?

[lazytown]

A screenshot is difficult (how do you screenshot something that goes way off screen? :)). The "advanced" numbers don't change the longer I go back (the total does). They also don't add up. I did upgrade from 3.06 to 3.53 a couple of weeks ago. Could that have removed/changed something in the moderator log? When I look at the log it still goes back at least a year.

-vissa

[Abe1]

A screenshot is difficult (how do you screenshot something that goes way off screen? :)). The "advanced" numbers don't change the longer I go back (the total does). They also don't add up. I did upgrade from 3.06 to 3.53 a couple of weeks ago. Could that have removed/changed something in the moderator log? When I look at the log it still goes back at least a year.

-vissa

Yes, I can have done something. vb 3.0 may not have had taken down exactly what each acton was in the way vb3.5 does. I'm not 100% sure though. But vb3.0 can be the reason.

[CupraSi]

Thanks this is my first ever hack that I have done and it seems to have gone well ...

Only bad thing is it disappearing off the screen

I have added some other user groups as well like my committee membes as you can see what activity they have ....

One dumb question here ...

Do you have to type in the URL that you gave all the time to view the stats or can you not view it within the forum?

Many thanks

[Abe1]

Thanks this is my first ever hack that I have done and it seems to have gone well ...

Only bad thing is it disappearing off the screen

I have added some other user groups as well like my committee membes as you can see what activity they have ....

One dumb question here ...

Do you have to type in the URL that you gave all the time to view the stats or can you not view it within the forum?

Many thanks

You can put the link where ever you want.

[CupraSi]

I am not a webmaster so I wouldnt know how

What I do know is that my forum has just ground to a halt :(

[Abe1]

I am not a webmaster so I wouldnt know how

What I do know is that my forum has just ground to a halt :(

What happened?

[CupraSi]

I installed and then added a couple of user groups and then its just not loading pages .. I cant even get into the plugin manager :(

[Abe1]

I installed and then added a couple of user groups and then its just not loading pages .. I cant even get into the plugin manager :(

This hack does not add hooks around your site. It can't be affecting getting elsewhere.

[CupraSi]

When I first loaded the stats via the URL you gave it loaded fine but now its just almost died so have been trying to load the forum for 3 mins

[TTG]

When I first loaded the stats via the URL you gave it loaded fine but now its just almost died so have been trying to load the forum for 3 mins

Upload this unplug (http://www.vbulletin.com/forum/showthread.php?t=148082&highlight=unplug) to your server, run it to disable all the plugins ... you should then be able to acces your forum :)

[CupraSi]

I have just been told that the load on the server went from 0.48 to 5.0

[CupraSi]

It appears that the server was set to only accept 150 simultanious connections and I was serving about 500!

[tendo]

That was very easy to install and extremely helpful. Thank you very much.

[Abe1]

That was very easy to install and extremely helpful. Thank you very much.

Now how about vote for it :)
https://vborg.vbsupport.ru/showthread.php?t=108020

[CupraSi]

I am all sorted now and its working well

Many thanks

[XanTrax]

Um...I installed it and enabled it and fixed the settings but where do you go to view the stats?

[XanTrax]

Nevermind I got it :).

[The Realist]

Ummmmmmmm!

Installed but this path http://www.tech-tronix.com/misc.php?do=moderator_stats takes me to my FAQ> Smiles and not the mods stats?

Any ideas?

[Abe1]

Ummmmmmmm!

Installed but this path http://www.tech-tronix.com/misc.php?do=moderator_stats takes me to my FAQ> Smiles and not the mods stats?

Any ideas?

Make sure it's installed.

[The Realist]

It is

[Abe1]

It is

No clue then. I would have to look at your acp.

[Robbed]

Is it possible to have options in the admin cp for the colums you want, alot of the approve and deny columns i won't need.

Thanks

[Sidewindr]

Is it possible to just request stats for say only Smods or only regular mods for particular forums?

[Abe1]

Is it possible to just request stats for say only Smods or only regular mods for particular forums?

Sorry, It can't do any of that.

[Pcparts]

been waiting for this :-)

<installs>

[Chadi]

I didn't scan all 5 pages but is there a way to add the misc.php?do=moderator_stats link inside admincp?

[Abe1]

I didn't scan all 5 pages but is there a way to add the misc.php?do=moderator_stats link inside admincp?

Sure theirs a wayb ut I didn't create one. Maybe eventualy.

[Gripemaster]

Very nice addition to the ACP...thank you!

*Clicks Install*

[Arngrim]

Works for me. Thanks.

'Installs'.

[lazytown]

This is truly one of my favorite mods.

The only thing that could be improved would be the super wide display. Perhaps instead it could repeat the mod names on the left and create a few separate tables instead of one super wide table.

Thank You!
-vissa

[unknownkind]

How do I fix this so it fits? or is centered? Picture is Attached

[Abe1]

How do I fix this so it fits? or is centered? Picture is Attached

I'm working on a new view.

[unknownkind]

okay cool

[unknownkind]

You can post it by today? ^_^

[Abe1]

You can post it by today? ^_^

Nope. And it wont be coming out for at least 2 weeks.

[Breathex]

thnx alot

[Freak0204]

I get a blank page when I run the link. Yes, it's installed.

[BoYagoob]

installed.

[lazytown]

Another Idea for Improvement: It would be nice if we could select the items that count as moderator actions with the control panel. I don't consider uploading attachments (which are just pictures on my forum) to be a moderator action. Also, is there any way to discount them editing their own posts/titles,etc.

Thank you!
-vissa

[P.Jackson]

would be a great mod for forum home something like

Like

Busiest moderators (Feb/Mar)
1. S|inkz 275
2. ?iego 194
3. Bub 156
4. Akirah? 154
5. MuTe^ 143

In a little box on forum home :)

[Abe1]

Version 1.3 (03/20/06):

CHANGED Changed how the Advanced moderator action stats show.


I hope you guys like the way it is set up now.

[Kurisu]

I hope you guys like the way it is set up now.

Yeah, looks nice :)
Thanks

[MorrisMcD]

Version 1.3 (03/20/06):

CHANGED Changed how the Advanced moderator action stats show.


I hope you guys like the way it is set up now.

MUCH better

Thanks for the update

[Kihon Kata]

My 8 moderators LOVE it!

[RMS-Chef]

Version 1.3 (03/20/06):

CHANGED Changed how the Advanced moderator action stats show.


I hope you guys like the way it is set up now.
Awesome Abe, thank you.
I would say "anything is better than streaching the page out to 6 feet" but that would sound like this new way was not good. It's great.

[lazytown]

Thank you! I can't wait to install the new version. As a side note, I modified the plugin on my end a bit to exclude certain things such as uploading an attachment (which is not a mod action IMO). I'm still not certain if edits to their own posts count as mod actions, but I'm going to try to remove those as well if possible.

-vissa


Version 1.3 (03/20/06):

CHANGED Changed how the Advanced moderator action stats show.

I hope you guys like the way it is set up now.

[Abe1]

Uploading an attachment means uploading to som-one ELSES post an attachment. Everything i a MOD action, not just a standard thing.

[lazytown]

Uploading an attachment means uploading to som-one ELSES post an attachment. Everything i a MOD action, not just a standard thing.
I'm 99% sure this isn't correct (at least not on 3.5.3). Uploading an attachment to your own post is getting counted -- perhaps it is a bug or just something that gets tracked because the person is a mod. Or perhaps it only happens if they add an attachment to their own post after the fact. Either way, on my forum it is including uploaded attachments to mod's own posts. It's not really a problem with your mod, but with the way VB tracks things.

Thanks
-vissa

[Robbed]

Could you add banned users?

How many each admin has banned.

[Abe1]

That is an admin action not a mod action. I'm not pulling any data from the admin log. Maybe I'll add it some day.

[Sidewindr]

How can I modify this to view say Only Super Mods or Only Moderators who are not Super Mods??

[vampireus]

Some mods and super moderators are not on the list. What can be the reason?

[Abe1]

Some mods and super moderators are not on the list. What can be the reason?
Make sure they are in the settings.

[Sidewindr]

How can I modify this to view say Only Super Mods or Only Moderators who are not Super Mods??

Any clues ??

I am only really interested in the Super Mods stats and not the regular moderators .. :D

[Abe1]

Look at the settings.

[Sidewindr]

I have .. there is no setting to EXCLUDE Moderators and only show Super Moderators.

[Abe1]

I have .. there is no setting to EXCLUDE Moderators and only show Super Moderators.
Ok. I'll try to add that option for my next release.

[richard4339]

Abe1,

Suggestion for a future release. It would be great to set a parameter like minimum posts per 30 days in their own forum. Then, if a moderator is below that, the system would send him/her a pm warning.

That would save me the trouble of having to do it manually.

Hear hear! Though I would simply say "minumum posts per 30 days, ANYWHERE!" I'd also recommend adding a link to the stats in the Admin Control Panel.

[Sidewindr]

Ok. I'll try to add that option for my next release.

Excellent .. Thanks ! :)

[rareclownfish]

Is there anyway to link this to the statistic page or somthing other than to type this misc.php?do=moderator_stats in the url everytime I need to see it?

[Abe1]

Is there anyway to link this to the statistic page or somthing other than to type this misc.php?do=moderator_stats in the url everytime I need to see it?
You can edit your templates somewhere.

[rareclownfish]

You can edit your templates somewhere.

Where???

[Roms]

Looks good, I'll try it out. :)

[Abe1]

Where???
Anywhere. Where ever you want the link. eg. navbar.

[rareclownfish]

Sorry about all the questions I'm a noob, could you give an example for the code to put it the navbar?
Thanks

[ShadowOne]

the only thingi would ask is for the table to fit correctly...is it possible to make it where it has a simplified version? so it wont stretch tables?

[Abe1]

the only thingi would ask is for the table to fit correctly...is it possible to make it where it has a simplified version? so it wont stretch tables?
Your tables get stretched now?

[Abe1]

Sorry about all the questions I'm a noob, could you give an example for the code to put it the navbar?
Thanks
Open template navbar
find:
<td class="vbmenu_control"><a href="usercp.php$session[sessionurl_q]">$vbphrase[user_cp]</a></td>
add after:
<td class="vbmenu_control"><a href="misc.php?do=moderator_stats">Mod Stats</a></td>

[ShadowOne]

yah when you go to the actual page... the table is stretched off to the right...

[rareclownfish]

Open template navbar
find:
<td class="vbmenu_control"><a href="usercp.php$session[sessionurl_q]">$vbphrase[user_cp]</a></td>
add after:
<td class="vbmenu_control"><a href="misc.php?do=moderator_stats">Mod Stats</a></td>

Thanks it showed up in the navbar,:banana: is there away to get it in the mini stats box?

[ShadowOne]

Open template navbar
find:
<td class="vbmenu_control"><a href="usercp.php$session[sessionurl_q]">$vbphrase[user_cp]</a></td>
add after:
<td class="vbmenu_control"><a href="misc.php?do=moderator_stats">Mod Stats</a></td>

wouldnt you need a condition for that to work properly? because like that eveyrone will see the link...

[rareclownfish]

wouldnt you need a condition for that to work properly? because like that eveyrone will see the link...

Everyone see's the link but when you click on it, it says you don't have permission for it. If you have the code I'll use it.

[Abe1]

Everyone see's the link but when you click on it, it says you don't have permission for it. If you have the code I'll use it.
add to the beg.
<if condition="$bbuserinfo[usergroupid] == 6">

add after
</if>

[Abe1]

Thanks it showed up in the navbar,:banana: is there away to get it in the mini stats box?
You can add the link any where.

[Billspaintball]

Version 1.2 (01/31/06):

ADD Average Moderator Actions Per Day
ADD Advanced moderator action stats.

Are there any oter stats that you guys would like added?

User Banning / Unbaning are the only extra ones I would like :)

[ShadowOne]

User Banning / Unbaning are the only extra ones I would like :)


it should also be setup as its own page because it stretches tables...unless there is an alternative :(

[Abe1]

it should also be setup as its own page because it stretches tables...unless there is an alternative :(
Can you post a screenshot of how your page looks?

[Abe1]

User Banning / Unbaning are the only extra ones I would like :)
I'll add it to my list.

[rareclownfish]

add to the beg.
<if condition="$bbuserinfo[usergroupid] == 6">

add after
</if>

Where am I putting this?

[Abe1]

Where am I putting this?
Before and after the code I first gave you.

[ShadowOne]

Can you post a screenshot of how your page looks?

Here Is my Screenshot...

[dilbert]

Here Is my Screenshot...
Abe,
Very nice addition, thank you.
I have the same width problem.
Maybe we can have the option of which columns to show? Or have the Advanced Log Stats be a pop up, instead of a mouse over?

Either way, I like it.

[ShadowOne]

Abe,
Very nice addition, thank you.
I have the same width problem.
Maybe we can have the option of which columns to show? Or have the Advanced Log Stats be a pop up, instead of a mouse over?

Either way, I like it.

yah thats a good idea... and yes a VERY nice hack indeed...

[MustangLisa]

Nice job! The update with Advanced stats is great! Thank you!!

[rareclownfish]

Before and after the code I first gave you.

This is the error I get


The following error occurred when attempting to evaluate this template:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/admin/public_html/forums/includes/adminfunctions_template.php(3537) : eval()'d code on line 192

This is likely caused by a malformed conditional statement. It is highly recommended that you fix this error before continuing, but you may continue as-is if you wish.

[Abe1]

This is the error I get


The following error occurred when attempting to evaluate this template:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/admin/public_html/forums/includes/adminfunctions_template.php(3537) : eval()'d code on line 192

This is likely caused by a malformed conditional statement. It is highly recommended that you fix this error before continuing, but you may continue as-is if you wish.
Can yu PM you code around that spot?

[rareclownfish]

PM sent

[SHalliday]

Installed and works perfect right out of the box! Absolutely awesome hack.

[John Smiley]

add to the beg.
<if condition="$bbuserinfo[usergroupid] == 6">

add after
</if>

I Want my mods to see this as well.
I tried Adding their usergroups usergroupid] == 6,5,7">
I got errors.
Can you give me the proper code to add them.

Great Script!
Thanks
John ;^)

[Abe1]

I Want my mods to see this as well.
I tried Adding their usergroups usergroupid] == 6,5,7">
I got errors.
Can you give me the proper code to add them.

Great Script!
Thanks
John ;^)
<if condition="$bbuserinfo['usergroupid'] == 5 OR $bbuserinfo['usergroupid'] == 6 OR $bbuserinfo['usergroupid'] == 7">

[ShadowOne]

hey abe, no fix for the stretching of tables?

[Abe1]

hey abe, no fix for the stretching of tables?
You can removed the nowrap="nowrap" from the templates if you want for now.

[John Smiley]

<if condition="$bbuserinfo['usergroupid'] == 5 OR $bbuserinfo['usergroupid'] == 6 OR $bbuserinfo['usergroupid'] == 7">


You Rock! :banana:

[rareclownfish]

thanks

[Mr Chad]

HAH... Holy shit, I installed this when it first came out on my other site. And i needed it for my current site, Your updated one kicks ass!

[plateau]

cool man!

install clicked!!!

[plateau]

one suggestion:

can u pls provide the Sort function, so the list can be sorted by Post, Active Time and so on, thanks!

[Abe1]

one suggestion:

can u pls provide the Sort function, so the list can be sorted by Post, Active Time and so on, thanks!
It's threre already. Just click on the title of the column.

[plateau]

It's threre already. Just click on the title of the column.

u r great mate!

thanks a lot and it is really a cool hack, tested around on 354 and no problems found at all.:bandit:

[Eagle Creek]

Great! Installed it!

[FLMom]

Just installed it but when I click on the link you gave in the instructions it isn't working. I just get the page not found error page. What am I doing wrong? I uploaded it as a product through the product manager, clicked yes for overwrite, editing the settings and clicked on install here ;)

What else do I need to do?

[Abe1]

Just installed it but when I click on the link you gave in the instructions it isn't working. I just get the page not found error page. What am I doing wrong? I uploaded it as a product through the product manager, clicked yes for overwrite, editing the settings and clicked on install here ;)

What else do I need to do?
Should be working on your site: http://www.myparentconnection.com/forums/misc.php?do=moderator_stats

[FLMom]

That is weird, I guess I just typed it in wrong. Thanks for your help :D

[phpdevrus]

wow thanks. going to install now.

[rareclownfish]

Hotm

[Stop]

couldn't be simpler
Installed.

[m52]

excellent, installed!

[Hoffi]

Nice Work. It just helps me to show my Mod-Activity. With more than 30 Mods its a long list. ;)

Is it possible die build a filter?

I have many Mods, that are not in the Moderator Group. Sometimes I wanna see them, sometimes not.

[Abe1]

Nice Work. It just helps me to show my Mod-Activity. With more than 30 Mods its a long list. ;)

Is it possible die build a filter?

I have many Mods, that are not in the Moderator Group. Sometimes I wanna see them, sometimes not.
There is the setting in the ACP. You would have to edit that to change what you see when.

[L-Mane]

Great product.

[Sidewindr]

Any idea how to limit the stats to only say super moderators??? I have Super Moderators who have full control and Moderators who don't have that much control and it's just a designation of who's responsible for monitoring an area.

[Abe1]

Any idea how to limit the stats to only say super moderators??? I have Super Moderators who have full control and Moderators who don't have that much control and it's just a designation of who's responsible for monitoring an area.
I hope to add an option to exclude moderators.

[Sidewindr]

I hope to add an option to exclude moderators.

Nice :D I'll wait then ;)

[havefun]

like it, thx abe :)

[rmxs]

How can i add button somewere that be visible from group have permission to view the stats?

[Eagle Creek]

How can i add button somewere that be visible from group have permission to view the stats?

<if condition="$show['admincplink']"><a href="misc.php?do=moderator_stats"><input type="button" value="Mod. Stat." name="B1"></a> -</if>
For persons who have access to adminCP.

And for custom usergroups:
<if condition="is_member_of($bbuserinfo, X,X,X,X)"><a href="misc.php?do=moderator_stats"><input type="button" value="Mod. Stat." name="B1"></a> -</if>

Where you should replace X by the usergroups.

[ultrAtolga]

great thank you it works.

[rmxs]

I make small change and i put it to nav bar..

:) </if>
<td class="vbmenu_control"><if condition="is_member_of($bbuserinfo, 5,6,7)"><a href="misc.php?do=moderator_stats">Mod Stats</a></if></td>
</tr>

[Nathan2006]

Thank you Abe

I like being nosey lol

Install;)

[redlabour]

Will it work in the Future with vBulletin 3.6 (http://www.vbulletin.com/forum/showthread.php?t=187654) ?

[Abe1]

Will it work in the Future with vBulletin 3.6 (http://www.vbulletin.com/forum/showthread.php?t=187654) ?
Not 100% sure. The structure may have changed. I have a new version planed with more features.

[Abe1]

I am releasing a beta version of this hack. I made the advanced stats AJAX and added a ton of new stats regarding the moderator actions. I only did the moderator actions right now, I will work on adding the admin actions soon.

The beta will work on BOTH vb3.5 AND vb3.6.

To install, you have to upload moderator_stats.php to your main forum dir. Then import the product. It will overwrite your current version. You will also need to go to moderator_stats.php to view the stats.

I’m posting this here now so I can get feedback now already with ideas!

ENJOY!

[John Smiley]

Works Great!!

[bashy]

Cheers Abe1
Looks to be working ok...Anyway of getting the threads to be clickable and goto to said action, i.e. if the thread was soft deleted, will goto the thread?
All my mods can only soft delete ;)


I am releasing a beta version of this hack. I made the advanced stats AJAX and added a ton of new stats regarding the moderator actions. I only did the moderator actions right now, I will work on adding the admin actions soon.

The beta will work on BOTH vb3.5 AND vb3.6.

To install, you have to upload moderator_stats.php to your main forum dir. Then import the product. It will overwrite your current version. You will also need to go to moderator_stats.php to view the stats.

I?m posting this here now so I can get feedback now already with ideas!

ENJOY!

[Abe1]

Cheers Abe1
Looks to be working ok...Anyway of getting the threads to be clickable and goto to said action, i.e. if the thread was soft deleted, will goto the thread?
All my mods can only soft delete ;)
I guess I can make the ForumID, ThreadID, ... live links but I can't make the type a live link since it's a count.

[Abe1]

Cheers Abe1
Looks to be working ok...Anyway of getting the threads to be clickable and goto to said action, i.e. if the thread was soft deleted, will goto the thread?
All my mods can only soft delete ;)
I just came up with an idea of how to do it. If a make an AJAX drop down from it. I'll see what I can do.

[bashy]

Ok abe...look forward to the outcome :)
Thanks for looking into it :)

[Hornstar]

Yeah i would like that as well, also I cant wait til 3.6 comes out then my smods cant hard delete.

Will this work for 3.6? sorry if that was answered already.

[bashy]

I use a hak that stops them from hard deleteting ;)

Yeah i would like that as well, also I cant wait til 3.6 comes out then my smods cant hard delete.

Will this work for 3.6? sorry if that was answered already.

[Abe1]

Yeah i would like that as well, also I cant wait til 3.6 comes out then my smods cant hard delete.

Will this work for 3.6? sorry if that was answered already.
I didn't test it on vb3.6 but It should work. I released a beta a few posts back that works on vb3.6.

[sam anders]

installed thank you :)

[mtha]

Great hack Abe/

Feature request: It'd be great if we can "EXPORT" the activity log to cvs, for moderator evaluation.

[Abe1]

Great hack Abe/

Feature request: It'd be great if we can "EXPORT" the activity log to cvs, for moderator evaluation.
Interesting request. I added it to my todo list. No garranty though.

[sduckie2k5]

Loving this one, great work! :up: