Moderator Activity Logging

Moderator Logs for vBulletin






Design Spec:

Track moderator and admin activites including: closing, opening,
moving, and deleting threads. You are able to set the number of
logs you view at one time and you can focus down to just one
moderator by clicking on their name.


Steps for installation:

-add one database table 'modlog'
-edit one file 'postings.php'
-upload one file 'modlog.php'


!!! DISCLAIMER !!! Hack at your own risk. I do not run v2, I will never run v2, I apologize if things are not exactly how they seem. May cause staining, test on hidden piece of fabric first. No this does not install itself. Learn to use phpmyadmin.

[etones]

how difficult would it be to keep track of when a user was placed into the 'Banned By Moderators' User group?

I've got lots a mods who like to ban (for good reasons)... however i'd like to keep a track of whos banning who... any ideas?

Cheers all. GREAT HACK..

once agaon Overgrow.. your da maaan!!

[Overgrow]

I guess being able to be banned by a Mod is a 2.0 feature? Dunno anything about that, sorry. Someone else could easily expand this to catch the other 2.0 features like stick/unstick, merge, split, etc.

Sisko-- thanks for tracking that down. That was indeed the difference between the first version and the current release. All users who use the current file should have no problems.

ps. thanks for the good comments! I love this hack too, now I know who is slacking in the mod duties and who needs a promotion.

[the_sisko]

@Overgrow:
With your permission I'll try to add those features to it!

[etones]

thanks to both Overgrow and Sisko for helping out.

Cheers all.

[chrispadfield]

p.s. to get the forum to show up under closed and deleted threads you also need to change the variable to $forumid

[Blue2000]

what a great hack its nice to see what my mods r up to

it works fine for me apart from the "CLEAR ALL LOGS" there all still there even after a refresh. no error message or anything but it just doesnt remove them, i have had to do it in phpmyadmin

It also doesnt show where from, and i have made all the chnges that have been put in my the replys

[BluSmurf]

Originally posted by The_Sisko
Found the bug:

If you allready installed the hack open posting.php and search for:

PHP Code:

$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,toforumid,timestamp) 
        VALUES ('3','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$curforumid','$movetoforumid','".time()."')"); 


and replace it with:

PHP Code:

$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,toforumid,timestamp) 
        VALUES ('3','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$threadinfo[forumid],'$forumid','".time()."')"); 


What was the bug?
You need to change the variables:
$curforumid
$movetoforumid
to
$threadinfo[forumid]
$forumid'

Now it work for me!

Does this apply for v2.0 Gold too?

[Overgrow]

re: vb2 gold and all other versions

I believe if you install from the latest zip on the front page of this thread you should have no problems. Those who were having problems most likely:

-Installed one of the old versions of the hacks
-Then used W.Luke's fixed queries but his queries were from a later version of the hack where I changed variable names to use VB2's new scheme

Sooo they had part old hack and part new hack = non working hack. If you use the latest version there should be no problems.


re: Not clearing the logs??

Anyone else with this problem? It couldn't be a simpler action:

PHP Code:

// CLEAR LOGS?

if($clearLogs=="yes")
    $DB_site->query("DELETE FROM modlog"); 


That's it. Dunno how that can malfunction for ya.

[Overgrow]

Question for everyone:

1) What's your normal peak # of users online and how many moderators do you have?

2) Have you told your mods that you are watching what they do?

By my logs I can see that one of my overall mods is doing a great job.. but I'm not sure I want to mention this-- I don't want them to feel pressured as if their actions are being watched.

[the_sisko]

1) ~20-30 , and 10 mods
2) no