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.

does the rest work for you?
Can you see the moderators by username?
thx,
-Tom

[dxb]

No it dose not work the moderator or the supermoderator name dose not show up only what ever the adminstrator name shows up

and

the new function split+move the moved thread title shows up but the source forum dose not show up

only the destination forum name which mean I wont know from where it's splited and moved

I thought this hack will be included in VB2.0.2 or VB2.0.3 but it seems like the pm status is more important than this .... I wonder are new features are added on demand base ???

and now who can help us with this hack... ... ...

because I think it's one of the most important hacks ...

[Me2Be]

Originally posted by dxb
I thought this hack will be included in VB2.0.2 or VB2.0.3 but it seems like the pm status is more important than this .... I wonder are new features are added on demand base ???

because I think it's one of the most important hacks ...

Well, to some people it obviously is more important than this hack. And there is a difference. The PM stats hack just utilizes the data already there. This modlog feature is obviously much more complex and requires more work than a simple statistics hack. We should really appreciate what we've been given

[JoshFink]

Me2Be is absolutely right.

But... I will try and work on it tonight or tomorrow and see if I can get it fixed up for ya..

Josh

Thanks Josh,
really appreciate your help on this,
-Tom

[dxb]

I'm sorry Me2be but I was really disappointed when the hack didn't work because I had some big problems on my board because of one of the moderators and I don't wont to have that again

anyway thanks josh and I will be waiting for your fix

[Itay]

It seems to have stopped logging for me after my upgrade to 2.0.3

Also - I was wondering if there is any way to add posts deletion to it as well, because that would make this hack perfect...

[JoshFink]

To Make Split + Move Show Properly (sort of)

Here is what I did.

The row under "Split Threads" will have :

ORIGINAL thread title, Mod, Forum From, Forum To and Date.

MODLOG.PHP

Find

PHP Code:

            case("6"):
                $split[$log[timestamp]] = array("type"=>"6", "userid"=>"$log[userid]", "threadid"=>"$log[threadid]", "title"=>"$log[title]", "username"=>"$log[username]",
                                                    "fromforumid"=>"$log[fromforumid]", "threadtitle"=>"$log[threadtitle]", "userid"=>"$log[userid]", "toforumid"=>"$log[toforumid]");
            break; 


Change To :

PHP Code:

            case("6"):
                $split[$log[timestamp]] = array("type"=>"6", "userid"=>"$log[userid]", "threadid"=>"$log[threadid]", "title"=>"$log[title]", "username"=>"$log[username]",
                                                    "toforumid"=>"$log[fromforumid]", "threadtitle"=>"$log[threadtitle]", "userid"=>"$log[userid]", "toforumid"=>"$log[fromforumid]");
            break; 


Find

PHP Code:

    if ($title=="Moved Threads")
        echo "To"; 


Change to :

PHP Code:

    if (($title=="Moved Threads") OR ($title=="Split Threads")){
        echo "</td><td class="label">To";} 


FIND
[PHP]

Find

PHP Code:

                case("3"):
                    echo "<span class="toplinks">MOV: </span>";
                break; 


After That Add

PHP Code:

                case("6"):
                    echo "<span class="toplinks">SPL: </span>";
                break; 


Now in POSTINGS.PHP

Find in ### start do split thread ###

PHP Code:

  // Move post info to new thread...
  $posts=$DB_site->query("SELECT postid,attachmentid,userid FROM post WHERE threadid='$threadid'");
  while ($post=$DB_site->fetch_array($posts)) {
    if ($splitpost[$post[postid]]=="yes") {
      $DB_site->query("UPDATE post SET threadid=$newthreadid WHERE postid=$post[postid]");
    }
  } 


After That Add :

PHP Code:

$splitto=$DB_site->query("SELECT forumid FROM thread where threadid='$threadid'");
list($split_to) = mysql_fetch_row($splitto); 


Find

PHP Code:

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


Change to:

PHP Code:

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


I believe that is all I did.. I was in a rush, so I might have missed documenting something on here. I'm sure if I did, someone will point it out.

Unfortunately the thing I don't like is that I can't see what the thread name was that I moved it to. This is because there is not enough rows in the table. i.e. a Thread From and a Thread To.

It could be done, but you would have to create two rows for a Split + Move , one for the split and one for the move. I might try that.. We'll have to see.

[JoshFink]

Itay, I thought about showing deleted posts, but most of the time a user can delete their own post. Then it would wind up clogging up the logs and the logs would be unreadable IMHO.

Josh

[dxb]

thanks josh for this

and about the hack

now the moderator name is showing up

the supermoderator with custom title still not showing up

the main this

the moved threads

the source forum is not showing up only you can see the destination forum

the same thing with split+move only the destination forum is showing up