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.

[JoshFink]

Glad to help.. This is actually the first PHP coding for vBulletin I've done.

Josh

josh i edited my postings.php with what you put in your above post but my mod log still does not show where threads were deleted from and what forum threads are closed in

[JoshFink]

GB, try it again and make sure the code is all correct.. Or , send me your file and I'll take a loot at it.

Josh

i got it josh...sorry to take up your time man

[Dakota]

How would I make it so that you must be at least a moderator to access the log?

good idea dakota.....thats the only problem i see with this hack is that anyone who knows the URL to the mod log page can access it......

I got around this problem by just making another directory inside the admin directory.. then I copied config.php, modlog.php, and db_mysql.php into it.. Now you can use htaxx to lock the modlog directory...

then once you lock the directory, you can save a bookmark to get to it.. like this:

http://username:password@www.yoursite.com/board/admin/modlog/modlog.php

There a a few changes that needed to be made to modlog.php if you are going to use a separate directory for it.... On lines 197, 204, and 211 you will need to make a change to the echo statements to show the locations of forumdisplay.php and showthread.php

(ie so instead of using href=\"../showthread.php?etc" you would change it to href=\"/board/showthread.php?etc" or whatever your board's root dir is)

anyway that's how I did it... if anyone has a better way let me know

UPDATE: I forgot.. you can make it so that only modlog.php is needed inside your modlog dir (and not config.php and db_mysql.php).. open up your modlog.php, and towards the begining of the file make these changes:
find:

PHP Code:

require("./config.php"); 


change to:

PHP Code:

require("../config.php"); 


Then find:

PHP Code:

$dbclassname="./db_$dbservertype.php"; 


change it to:

PHP Code:

$dbclassname="../db_$dbservertype.php"; 


*but those changes will only work if your modlog directory is a subdirectory of the admin directory*

Hi,

sorry for being late on this, but I just got PHP4 installed (slow provider... )

I installed the hack from Zarkov's additions, added JoshFink extras and it seems to work fine.

I noticed to things though:

1) The Moderator table is empty if I access modlog.php making this hack quite senseless on my site

2) I deleted a thread and it showed up under "Moved threads"
Checked postings.php

PHP Code:

      deletethread($threadid,0);

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

      eval("standardredirect(\"".gettemplate("redirect_deletethread")."\",\"forumdisplay.php?s=$session[sessionhash]&forumid=$threadinfo[forumid]\");");
    } 


Seems correct to me (case 2 = delete)
And the modlog.php

PHP Code:

            case("2"):
                $deleted[$log[timestamp]] = array("type"=>"2", "userid"=>"$log[userid]", "threadid"=>"$log[threadid]", "title"=>"$log[title]", "username"=>"$log[username]", 


Funny, what did I do wrong?
Thanks in advance,
-Tom

[Mark Hewitt]

Is there going to be a new version of this released with all the fixes included?

[dxb]

anybody can tell me how to apply this to VB 2.0.3 I mean with the new function split+move added to it