[RELEASE:all] Moderator Activity Logging

[J Wahl]

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.

[debsync]

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

$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:

$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):

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

Replace With:

$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):

updateforumcount($threadinfo[forumid]); 

Directly BELOW it ADD:

$movefrom=$threadinfo[forumid]; 

FIND (right below the last step):

updateforumcount($forumid); 

Directly BELOW it ADD:

$moveto=$forumid; 

FIND (Later on in the thread MOVE block):

$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:

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

Josh

[debsync]

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

[JoshFink]

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

Josh

[GB]

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

[GB]

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?

[GB]

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

[debsync]

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:[email protected]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:

require("./config.php"); 

change to:

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

Then find:

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

change it to:

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

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

[Thomas P]

Moderator table cell is empty?

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

      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

            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