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.

[limey]

Hey I'm proud of you and your website

[Me2Be]

Originally posted by Overgrow
[B]Argh ok hold off on installing it until I download the latest RC3. I have an older version of V2, I didn't expect that the variables would change so much from RC to RC.

Thanks for this! Can you let me know when you have the RC3 ready?

Originally posted by Overgrow
I'm not trying to win a VB developer spot here, just releasing some code.

Yeah, that's what Kier thought too!

[Overgrow]

FILE UPDATED: May 21, 2001 6:50 am PST

FIXES -

-addslashes bug detected and resovled by wluke, this was causing some data to be ignored.


Included are two versions of install.txt, for V1 and V2. The V2 installation is much simpler. I like the structure, I may convert yet.

Nice, That's really nice.

[Overgrow]

No complaints, so I assume it's working for V2 now?

ps. thanks for all the nice comments on the hack & site

[Me2Be]

Originally posted by Overgrow
No complaints, so I assume it's working for V2 now?


ps. thanks for all the nice comments on the hack & site

I Love it!! I sent you a PM

[Freddie Bingham]

Basically make it easy to install like kiers. Makes the needed tables, and then shows install instructions. Very useful hack.

You should reserve that sort of constructive criticism for your own hacks. Be appreciative of any hack you receive in any form that it comes in.

It worked ,
what a good a work you did!

[Me2Be]

I seem to be getting some VB errors for this -- can you take a look at what could be wrong? They seem to be only on those threads that are MOVED and those that have an apostrophe in the subject.

Database error in vBulletin: Invalid SQL: INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp) VALUES ('3','3864','53151','Lee and Colin's Journal','','','990238526')
mysql error: You have an error in your SQL syntax near 's Journal','','','990238526')' at line 2

Database error in vBulletin: Invalid SQL: INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('3','3864','57894','how i'm saving money','','','990241258')
mysql error: You have an error in your SQL syntax near 'm saving money','','','990241258')' at line 2
mysql error number: 1064

[Wayne Luke]

In postings.php
Find:

PHP Code:

$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,toforumid,timestamp) 
        VALUES ('$threadinfo[open]','$bbuserid','$threadid','$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])."','$forumid','','".time()."')"); 


Find:

PHP Code:

$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,toforumid,timestamp) 
        VALUES ('2','$bbuserid','$threadid','$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])."','$forumid','','".time()."')"); 


Find:

PHP Code:

$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,toforumid,timestamp) 
        VALUES ('3','$bbuserid','$threadid','$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])."','$curforumid','$movetoforumid','".time()."')");