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.

Sorry - wrong thread

[zarkov]

Sorry for not replying sooner but our host lost all our files and database in a server crash or somming, spent the last 2 weeks trying to get a new reliable host and rebuild the board and the last ofline backup we had and add all the hacks back and add a few more.

I cant remember off hand what the mods where but just upload the new Modlog.php file and follow instructions included to update the other php file.

it worked OK for us as i was only a super mod on our site and i showed up in the modlogs along with admins and normal mods.

Why would you want a MODLOG script that didnt log the actions of some moderators ( even if they are called Admins ).

But i spose you could add a
if not adminusergroupid then {
too only run the script if not an admin.

Im too tired and too involved elsewhere at the moment to work it out anymore thatn that for you at the moment, But shouldnt bee too hard.

I installed this hack but it caused a problem for me. I had a friend upgrade my vB to 2.0.1 or what ever the latest version is.

When I installed the hack it changed my vB version to vB2 beta 4? WTF? how the hell did it do that?

the install went great.

but when lookin at the log theres nothing there...
yet i have closed a couple of threads.

anyone know what can cause this?

thanks.

[Dakota]

did you create the table in your database?

Edit: Oh yeah, I am having trouble with clearing the logs.

yes i did - but its all empty.

[ShadowTech]

Just curious if this script is going to have any further updates?

I have noticed a few bugs in it:

Moderators with custom titles do not list in the log, however their actions do.

Closed threads do not log which forum they were closed in.

Moved threads do not show the destination forum.

Deleted Threads do not show the forum they were deleted from.

I believe I am running vB 2.0.0 on a 2k machine with mySQL 3.23.32 and PHP4.0.5 .

If someone could help me with a fix for these bugs I would greatly appreciate it.

yeah I have the same problems as ShadowTech.. I tracked down the problem with nothing being filled in under the 'from' and 'to' columns... when a post is moved/deleted/copied, there are no values being filled in to the database under 'toforumid' and 'fromforumid'... I decided to fill these values in manually for a couple of database records, and whalla the correct forum names appear.... but how can I make the necessary changes in postings.php so that these values get filled in correctly? I just d/l'ed and installed the latest version today (overgrow's version - no other mods added)..

[JoshFink]

Here is what I did to fix this, hope I can explain it well. I haven't done the issue with the moderator with custom titles yet, but I'll work on it later.

Remeber : I'm by no means good at PHP

This is all in postings.php

Find (in the open /close thread block):

PHP Code:

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


Replace with:

PHP Code:

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


Find (in the delete thread block):

PHP Code:

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


Replace With:

PHP Code:

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


FIND (in the move thread block):

PHP Code:

updateforumcount($threadinfo[forumid]); 


Directly BELOW it ADD:

PHP Code:

$movefrom=$threadinfo[forumid]; 


FIND (right below the last step):

PHP Code:

updateforumcount($forumid); 


Directly BELOW it ADD:

PHP Code:

$moveto=$forumid; 


FIND (Later on in the thread MOVE block):

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()."')"); 


Replace with:

PHP Code:

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


Josh

hey!!! works perfect now!! thanx JoshFink!