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.

[the_sisko]

I've send Overgrow a PM about it. I found the 2 variables he uses for puting from and to forum ids, are wrong! But he didn't give me an answer now....

[chrispadfield]

do you know what the variables are? i guessed that was the problem cos i couldn't find them anywhere else either. The cryptic queries were confusing me so couldn't work out which was which to solve it.

[Overgrow]

How can the variables be correct for me and for 90% of the people but not for a few?

Obviously we have versions mixed up and the variable names are screwy. It shouldn't be hard to find them and I don't think the queries are that cryptic-- they are simple inserts, right?

The postings.php I used was from RC3 I haven't changed it since gold was released. Did they change those variable names again?

Look above the queries you inserted into postings and see where else it mentions "forumid" or maybe "curforumid" or something like that...

[chrispadfield]

your hack has the variables $fromforumid and $toforumid

when i meant cryptic i meant the vb stuff trying to work out which forumid to use

[Me2Be]

Originally posted by Overgrow
Obviously we have versions mixed up and the variable names are screwy. It shouldn't be hard to find them and I don't think the queries are that cryptic-- they are simple inserts, right?

LOL, call me observant but I just noticed that it that the forum to/from doesn't work on mine either (RC2)

[Typhon]

We just got it up and running on our site... works like a charm. Thanks!

[Overgrow]

OK! It's a simple VB2 version problem I'm sure. When I first wrote this hack I based it on VB2 beta code. I don't run VB2 so I was just using the last version I had.

People noted that the variables had changed for RC3 so I updated the file. For all those missing forum ID's, please download the zip at the bottom of the first page of this thread. It hasn't changed lately, I just think you're still using the old version of the queries.

Any luck?

[the_sisko]

This is what you find in modlog02.zip:

PHP Code:

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


And:
$curforumid
$movetoforumid

are not the right variables. I'll try a look over it, to find the right ones...!

[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!

[chrispadfield]

cool, thanks for that and thanks to Overgrow for such a wicked hack.