Cyb - Moderating Stats

[Valter]

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.

[meolangthang]

Thank you Cybernetec

[KURTZ]

INSTALLED! thx Cyb! you rocks!
PS. another nomination ;)

[avsunforum]

perfect cybernetec thank you very much

[Inferno Dragon]

Installed, I was badly looking for this kind of hack :) thanks cyb!

[bcmedia]

thank you!!! Installed! :D

is there any way to include number of threads and posts created in the last x days in the forums they moderate?

[MentaL]

Hi,
I have installed this hack but it does not display infractions given.

Thanks.

[smirkley]

thank you!!! Installed! :D

is there any way to include number of threads and posts created in the last x days in the forums they moderate?

Ditto.


(and thanks again ;) )

[athlon64bit]

What if you are upgrading from the 3.6.x version of this mod? Any special instructions? Do we just import product? Do we lose old logs?

[Valter]

Just import XML, allow overwrite.

Logs will NOT be lost during upgrade nor uninstall/re-install.

[tfw2005]

Any way to get it to not include actions done by non-staff on their groups and albums, etc?

[tfw2005]

And, infractions showing as 0 for everyone, yet have many for the last 30 days.

[si_reading]

Is there anyway to limit the stats to only show certain usergroups? For example just Admin or just Moderators?

Thanks!

[athlon64bit]

I almost banned a regular forum member when they showed up as performing a mod/admin action. I thought that they were a hacker LOL. They were only deleting a post on their blog which I gave permissions to do. I do think that it should be made to only log certain usergroups, such as only mods, super mods and admins etc.

[al3bed]

thanks alot Cybernetec.

Note: moderators actions include any one that do any action even he not in the moderator group .. like some olds moderators who quit.

I like all your hacks ..
please fix that in new version.. :)

[Sakai Ray]

Thanks for the hack ^^

[FROGGYJ]

good hack, but is there any way to build in tracking so I can review which mod made a change and when?

[Darkstarproject]

*Installed*

Only problem. When I am logged in, and go to 'Quick Links' > 'Moderating Stats' it will log me out, or show I am logged out and show me the smilies page. If I log in from that page (misc.php?do=cybmodstats), it will show me the stats.

This is in FF3 and IE8.

[Valter]

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

To upgrade:
-Import XML, allow overwrite
-Check hack settings and update if needed

[TrIn@dOr]

Thanks, i have only one problem, my admincp is not called in that way. I changed for security reasons. And when I click it to see the specific things I get the wrong link...

Where can i change admincp for XXX?

[KURTZ]

i got this when i try to get the logs ...
Not Found
The requested URL /admincp/modlog.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

http://www.xxxx.it/board/admincp/modlog.php is missing the folder of the board ...

[Valter]

You can change path to admincp in template "cyb_moderating_stats_bit".

Next version will detect admincp location automatically.

[TrIn@dOr]

Thanks, i have only one problem, my admincp is not called in that way. I changed for security reasons. And when I click it to see the specific things I get the wrong link...

Where can i change admincp for XXX?Fixed, edited template and changed name of the dir.

[KURTZ]

You can change path to admincp in template "cyb_moderating_stats_bit".

Next version will detect admincp location automatically.

cyb and the path of the board?

[BozzaJos]

thank you!!! Installed! :D

is there any way to include number of threads and posts created in the last x days in the forums they moderate?

If this could be added it would be a really amazing mod. At this moment, the mod is to keep track of what the mods have done and to see if a mod is actually doing some moddish things. It would be even better if you can see how the section has been with posts/threads created since the mod took over the section.

Do you think this could be a future idea Cyb?

[cnutter]

nice hack cant wait to get the updated hack with the admin link bug fix... ;)
FYI - Those who want a quick and easy way to fix this...

Open the Cyb_MS.xml in a txt editor and search for admincp. This replace /admincp with the proper path if you have renamed it got security reasons. . Then just update the plugin like is a new version.

How it is now....
<td class="smallfont" align="center"><a href="/admincp/modlog.php?do=view&userid=$cybmodlogstat[userid]" title="<phrase 1="$cybmodlogstat[username]">$vbphrase[cybmodstats_view_user_entries]</phrase>" target="_blank">$cybmodstats_actions</a></td>


How it should look to be fixxed...
<td class="smallfont" align="center"><a href="/WHATEVERYOUNAMEDIT/modlog.php?do=view&userid=$cybmodlogstat[userid]" title="<phrase 1="$cybmodlogstat[username]">$vbphrase[cybmodstats_view_user_entries]</phrase>" target="_blank">$cybmodstats_actions</a></td>


Cyb - Thanx for the mod and I hope this helps a few people. This will save them time editing the template "cyb_moderating_stats_bit".

[tekguru]

Updated.

[Hannan]

Thank you for good Hack! but I have a problem! it just showing me and my super moderators, the moderators not showing in the list!
thanks

[KURTZ]

Thank you for good Hack! but I have a problem! it just showing me and my super moderators, the moderators not showing in the list!
thanks

exactly it doesn't works correctly ... :( the UG 7 isn't showed ... it runs only with the UGs 6 and 5 ... :(

[Subah]

Cool, Thanks a lot :)

[BozzaJos]

It is showing the Moderators on my Forum. Even the Trial Moderators (new usergroup). Have you set the options correctly?

[Subah]

I got this error

404 Not Found
The requested URL /admincp/modlog.php?do=view&userid=1 does not exist.

[vitrag24]

Thanks. But can u add moderator usergroup also in admin/mod by default?
bcz if i set "show only moderator log creared by admin/mod" to "no" then it's showing all previous mod log too..

=====================================
i had this mod in 3.6..can u make like this (https://vborg.vbsupport.ru/showthread.php?t=139248&page=11&highlight=moderator+stats)for 3.7? it was supercool.

[KURTZ]

Vitrag i need the same thing ... and i dunno how we can fix this ...

however i've found the solution to see the UG 7 stats :)

it simply, select NO onto Show only Moderator log entries generated by Admins/Mods ... then exclude the UG 2 into the following field ...

but i think this isn't completely correct ... cause i wanna see only the stats that are generated by the mods/admins ... not ALL the stats of my mods ...

[mrahul]

doesn't show up moderator group stats ?
shows co-admin and super mods but doesn't display mods
mods id 7 how to make it visible for mods also ?

when I removed show only mods to no
mods are visible on list but no infraction or points given stats are visible :o

[Rogier21]

This mod uses the wrong path to the forum!

I have http://www.site.com/forum (also in the admin!)
But the plugin goes to http://www.site.com/admincp/modlog.php etc.

please fix.

[EvilJohn]

You can change path to admincp in template "cyb_moderating_stats_bit".

Next version will detect admincp location automatically.

After making template change. Nice mod. Thank you sir

[KURTZ]

doesn't show up moderator group stats ?
shows co-admin and super mods but doesn't display mods
mods id 7 how to make it visible for mods also ?

when I removed show only mods to no
mods are visible on list but no infraction or points given stats are visible :o

yes this is the trouble ... :(

[Makc666]

<u>Just a note</u>, that if you unpack the archive with WinRAR there is a extra folder "__MACOSX" there with file "._Cyb_MS.xml"

[SpanishHarlem]

excellent. One of my staff members just asked to see her log.. So I just did a search and Whalla.. It was here.. Thanks so much.

[athlon64bit]

This mod uses the wrong path to the forum!

I have http://www.site.com/forum (also in the admin!)
But the plugin goes to http://www.site.com/admincp/modlog.php etc.

please fix.

I have the same problem. I actually use customised named folders for my admin and mod folders. There is a vbulletin "command" text link (can't think how to describe it) which this author can use I think which would work for all forums regardless of their location like other add-ons make use of.

[hotwheels]

very nice........

[Valter]

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

To upgrade:
-Import XML, allow overwrite
-Revert hack templates if any modified

[Super Jinni]

thanks for update
:)

[KURTZ]

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

To upgrade:
-Import XML, allow overwrite
-Revert hack templates if any modified

Cyb, there is an issue into the latest update ... :(

now it shows only the Super Admin (User ID 1) and the Normal Mods (Group ID 7) ... :( the others Admins and the Global Mods (Group ID 5) aren't showed ... :(

i tested it onto my two boards with the same issue ... :( can you fix that?

[Subah]

Thanks for the update :) , now it is work for me ;)

[KURTZ]

Thanks for the update :) , now it is work for me ;)

have you checked the other admins and the global moderators? ;)

[PGAmerica]

Can somebody please tell me how to manually add this to my navbar template? I just need to know the exact code to add.

[MonkYZ]

Can this be done so that vBadvanced links to work without adding custom links into styles templates ? I mean, the link is working inside the forum, but not in vBadvanced homepage. Thx in advance.

[KURTZ]

any news about the new issues that i've found?

[PGAmerica]

Can somebody please tell me how to manually add this to my navbar template? I just need to know the exact code to add.
Is there any help to my problem?

[Xenofox]

Am i the only one who sees no infractions when limiting the time of the reports, instead of all time.?

[PGAmerica]

Is there any support for this mod at all?

[KURTZ]

Is there any support for this mod at all?

i think not mate ... this hack is still glitched ...

[smirkley]

Cyb, like this mod alot.

Hoping at your convenience, that it could be fixed where admins, smods, and mods, are all included by the selector to show stats.

I have played with the settings, but am unable to get the mods, currently appointed, and their stats, to show up yet.

Thanks in advance.

[Blind Guardian]

Am i the only one who sees no infractions when limiting the time of the reports, instead of all time.?

No, you're not. I have the same issue, and had come here to try and find a solution myself.

Glancing at the code, I'd think it's a problem with the query not specifying the dateline properly, but I haven't tried tweaking the query to see if I can fix it yet.

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' $cybmodstats_timeperiod ");

It might be that $cybmodstats_timeperiod is pulling from the mod log, and not the infaction log?

[Blind Guardian]

So no one has any input on why limiting the number of days shown breaks the infraction totals?

EDIT: Nevermind, I fixed the bad query myself.

[mrcrx]

So no one has any input on why limiting the number of days shown breaks the infraction totals?

EDIT: Nevermind, I fixed the bad query myself.


Can you share how you fixed it? I really dont know where to start.

[Blind Guardian]

Under "Cyb - Moderating Stats - MN" in the Plugin Manager, I changed this:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' $cybmodstats_timeperiod ");

To this:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' AND dateline > $fromtime");

The problem was that the "$cybmodstats_timeperiod" being called in the query for the infractions was appending a "moderatorlog." prefix onto the "dateline" row, meaning it wasn't there in the infactions table. Removing it just pulls the regular dateline from that table and it works.

This will probably break the option to disable the time limitation on the logs, but I don't need that so it was the quickest fix for me.

What I'm currently trying to work out is why all of a sudden the "moderator posts in their own forums" fields are gone. Those were useful.

[Valter]

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' AND $cybmodstats_timeperiod > $fromtime");
This is not part of my hack.

Here is original query:
$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' $cybmodstats_timeperiod ");

[Blind Guardian]

Indeed, my mistake. I didn't bother documenting exactly what I'd changed as I didn't perceive needing to explain it to anyone else, and didn't check what the original timeperiod variable included.

My explanation should have been replacing "$cybmodstats_timeperiod" alone with "AND dateline > $fromtime".

[Rideharder]

How can we fix it 'Under "Cyb - Moderating Stats - MN" in the Plugin Manager, I changed this'

Sorry to be a newbie..

Can you name how you fixed it step by step

Thasnk,
www.Speedaholic.net

[Blind Guardian]

In the Admin CP, under the Plugin Manager in Plugins & Products, edit the "Cyb - Moderating Stats - MN" plugin and find the line of code as follows:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' $cybmodstats_timeperiod ");

Simply replace that entire line with this:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' AND dateline > $fromtime");

[Rideharder]

In the Admin CP, under the Plugin Manager in Plugins & Products, edit the "Cyb - Moderating Stats - MN" plugin and find the line of code as follows:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' $cybmodstats_timeperiod ");

Simply replace that entire line with this:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' AND dateline > $fromtime");


Thank you and all that worked on this Mod!

[mrcrx]

Thank you for the step by step. Works great!

[realmr]

For me it shows stats of only 1 admin . How can I make it to display for mods, admins and super mods as well.
I can give permission for other usergroups to view the content but I can't see any other option to add permission for remaining admins, super mods and mods to show up in stats
I have added this code:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' AND dateline > $fromtime");
as mentioned above so does this make this plugin to work so strange ?

[proxx]

I installed this. But I don't see what advantage it has over the old 'moderator stats' ?

As a matter of fact, I'm surprised that neither the old script nor this one has the option of excluding forums from being counted towards in moderator actions and posts.

If somebody could modify https://vborg.vbsupport.ru/showthread.php?t=139248 to allow me to forums from stats, I could pay for such a modification.

for example, i have off topic forum and support forum. I don't care the posts and moderation actions in off topic forum, but I would rather get stats of moderators in support forums.

Please PM me if you can do what I need.

[Nadeemjp]

awsome hack cyb:) installed:)

[Nadeemjp]

the moderation stat in the quick links menu doesnt display. instead it says "page not found"
what to do?

[KURTZ]

what about the usergroups trouble? i still haven't the global moderators onto this stats ... :S

[-=Leb=-]

I love all your his plugins lol

[AtillaKral]

thanks, installed :)

[Audentio]

In the ACP, you can't exclude more than one usergroup. You can only exclude one (i.e ex staff that are now members. Usergroupid=2). Can you release a fix for this soon please?

Great mod otherwise!

[webuser99]

I have custom usergroups made that have admin capabilities, that arent "Moderator" etc etc.

I don't see these included.. is this not possible to log this usergroup?

[Valter]

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

To upgrade:
-Import XML, allow overwrite

[Subah]

thanks for the update

[KURTZ]

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

To upgrade:
-Import XML, allow overwrite

hi Cyb, unfortunately the UG with ID 7 (Moderators) aren't showed ... :( now it runs only with Admins & Super Moderators ...

[Dr.LoVe]

i want you add option for remove the Archive of log the Moderating Stats
because to not work space blank or load of server

Thank you,

[Valter]

v1.6.1 - Oct 26. 2008.
-Fixed bug where forum mods are not included in stats

Re-import product XML, allow overwrite.

[Kihon Kata]

updated mine to 1.6.1

[KURTZ]

v1.6.1 - Oct 26. 2008.
-Fixed bug where forum mods are not included in stats

Re-import product XML, allow overwrite.

perfect, now it seems that it's working correctly ... ;) thx Cyb :)

[-=Leb=-]

It seems like the supermods and administrators are not showing .

Hi Kurts, take a lok plz and see if you can view the supermod or administrators.

[Sunka]

Installed!
Working good...Thanks

[Sunka]

Is this MOD working on vBulletin v3.8.0?

[Voltar]

Is this MOD working on vBulletin v3.8.0?

Works great for me on 3.8.

[Sunka]

Can this be done so that vBadvanced links to work without adding custom links into styles templates ? I mean, the link is working inside the forum, but not in vBadvanced homepage.

Any FIX for that?

[petersweb]

In the Admin CP, under the Plugin Manager in Plugins & Products, edit the "Cyb - Moderating Stats - MN" plugin and find the line of code as follows:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' $cybmodstats_timeperiod ");Simply replace that entire line with this:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' AND dateline > $fromtime");
It didn't work for me - once it found someone who awarded infraction points, it copied those points to the rest of the list. See the attached screenshot.

[BlueNinjaGo]

Installed... 3.7.3... works perfectly so far... Great work like always! Thank you!

[Dan Clement]

Fab - now I can see what mods are worth their salt!

Thanks a lot. :)

[Keesa]

If I do not have QuickLinks on my navbar, where will I find the page showing moderator stats?

Got the answer
FORUM/misc.php?do=cybmodstats

thanks but I cannot figure out how to have it show the infractions and do not understand why that piece of code would not have been fixed, so I am going to uninstall.

Thanks again for making one though!

[SVTCobraLTD]

Posting in the 3.8 version of this.

[athlon64bit]

Does this work on vbulletin version 4?

[Valter]

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