Moderator Activity Logging (updated)

<font size="3">Moderator Activity Log for 2.x</font>

Disclaimer:

-No support is offered for this hack. If you PM or email for support, it will be joyfully ignored. When I have time, I will answer questions in this thread.

** FREE LICENSE ** You must leave the header and footer intact.

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.

Installation (never had ModLog installed):

-upload install_modlog.php to your admin directory
-upload modlog.php to your admin directory
-run install_modlog.php, follow instructions
-delete install_modlog.php

Installation (have a previous version running successfully):

-upload modlog.php to your admin directory

Changes from the previous version:

-now has a fancy install routine instead of boring text instructions. Installing will now be easier and more fun!

-puts a link on the left side of your Admin CPanel under Admin Logs

Works on:

-vB 2.2.1
-untested on everything else but should work with the whole 2.x line and even 1.x if you figure out the postings.php modifications.

Screenshot attached, files attached in replies. Questions? Read the disclaimer at the top of this post. Thanks~

[350Chevy]

Originally posted by pgowder


I tried that, but the log only shows my activities???

Yes, those logs only show ADMIN activities.. not Moderators. Davey may have been a little confused.

[Cyberhouse]

Works perfect on 2.2.7

[mharmon]

Fantastic Mod. Thanks!

[mtha]

it work great! 2.3.0

04-30-02 at 07:28 PM hellsatan said this in Post #60
@CJi...

Yes it does...

We have it installed on our vB 2.2.5, and it works perfectly...

3 Things Overgrow - 2 have already been suggested, but either you missed them or dont know...

1.) Would it be possible to include an "edit" feature, to show posts that were edited by mods
2.) Would it be possible to exclude admins from the log
3.) Would it be possible to include a code for Posts that have been deleted, not just threads...

Satan

I added a tracking log for "edit" feature, for all member:
Also add IP tracking to the log.

execute

ALTER TABLE `modlog` ADD `postid`  int(10) DEFAULT '0' NOT NULL AFTER `threadid`;

// ------ ADD IP log ----------

ALTER TABLE `modlog` ADD `ipaddress`  varchar(20) NOT NULL;

in editpost.php
find

  eval("standardredirect(\"".gettemplate("redirect_editthanks")."\",\"showthread.php?s=$session[sessionhash]&postid=$postid#post$postid\");");

ADD BEFORE

// MOD LOG
  $DB_site->query("INSERT INTO modlog (type,userid,threadid,postid,threadtitle,fromforumid,toforumid,timestamp,ipaddress) 
		VALUES ('4','$bbuserinfo[userid]','$threadinfo[threadid]','$postid','".addslashes($threadinfo[title])."','$threadinfo[forumid]','','".time()."','".$HTTP_SERVER_VARS['REMOTE_ADDR']."')");

------- add IP LOG -------------

in posting.php,
find

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

REPLACED BY

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

FIND

  // MOD LOG
  $DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,toforumid,timestamp) 
		VALUES ('3','$bbuserinfo[userid]','$threadid','".addslashes($threadinfo[title])."','$checkforum[forumid]','$forumid','".time()."')");

REPLACED BY

  // MOD LOG
  $DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,toforumid,timestamp,ipaddress) 
		VALUES ('3','$bbuserinfo[userid]','$threadid','".addslashes($threadinfo[title])."','$checkforum[forumid]','$forumid','".time()."','".$HTTP_SERVER_VARS['REMOTE_ADDR']."')");

FIND

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

REPLACED BY

  // MOD LOG
  $DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,toforumid,timestamp,ipaddress) 
		VALUES ('$threadinfo[open]','$bbuserinfo[userid]','$threadid','".addslashes($threadinfo[title])."','$threadinfo[forumid]','','".time()."','".$HTTP_SERVER_VARS['REMOTE_ADDR']."')");

replace the modlog.php file by the attached file


If you want to limite the log to mod (1 group only), you may add something like
IF ($bbuserinfo[group]=(#groupID)) { .... }
around the logging part (DID NOT TEST)

have fun

[Ph0eniX]

I can't get it to work on 2.2.9. I did everything as directed in install_modlog.php. The modlog table got created and there is a link to modlog.php in the Admin CP but nothing ever gets logged

Nevermind. I was trying to edit a post and then realized that there is not edit logging. I added a few lines to editpost.php and modlog.php to include edits. Thanks Overgrow!

[SmartGnome]

Great it works perfectly on 2.3.0 at once

Install clicked


One silly question:

Why don't I see the 'from forum id' in the moved list ??


Cheers

[JeffyJoe]

Hi mtha,

03-20-03 at 11:04 PM mtha said this in Post #94
it work great! 2.3.0

execute

ALTER TABLE `modlog` ADD `postid"  int(10) DEFAULT '0' NOT NULL AFTER `threadid`;

// ------ ADD IP log ----------

ALTER TABLE `modlog` ADD `ipaddress`  varchar(20) NOT NULL;

I am gettin an error running this query:

ALTER TABLE `modlog` ADD `postid"  int(10) DEFAULT '0' NOT NULL AFTER `threadid`;

this is the error:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: ALTER TABLE `modlog` ADD `postid" int(10) DEFAULT '0' NOT NULL AFTER `threadid`;
mysql error: You have an error in your SQL syntax near 'threadid`' at line 1

mysql error number: 1064

[mtha]

Today at 08:16 AM JeffyJoe said this in Post #97
Hi mtha,



I am gettin an error running this query:

ALTER TABLE `modlog` ADD `postid"  int(10) DEFAULT '0' NOT NULL AFTER `threadid`;

this is the error:

The error should be because of the `postid"
please change that to `postid`

PHP Code:

ALTER TABLE `modlog` ADD `postid"  int(10) DEFAULT '0' NOT NULL AFTER `threadid`; 


Sorry I for the typo

let me know if it works

[mtha]

dah, the addon was for my board, which has mucho hacks already. I fixed the modlog.php above, you can redownload it now.

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: ALTER TABLE `modlog` ADD `postid` int(10) DEFAULT '0' NOT NULL AFTER `threadid`;
mysql error: Duplicate column name 'postid'

mysql error number: 1060

You already have the column 'postid' created somehow. Check the table modlog in your database, to make sure that you have it right. If so (and if your database isnt corupted), you dont have to do anything else. otherwise, just delete that column, and add it again.

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: SELECT type,modlog.userid as userid,modlog.threadid as threadid,modlog.postid as postid,fromforumid,toforumid,modlog.timestamp as timestamp,modlog.ipaddress as ipaddress,threadtitle, user.realname as username
FROM modlog
LEFT JOIN user ON modlog.userid = user.userid

ORDER BY modlog.timestamp DESC
LIMIT 0,25
mysql error: Unknown column 'user.realname' in 'field list'

mysql error number: 1054

dah, I have something called realname, instead of username, that's why.

please search for realname and change it to username, this problem should be fixed.


line 71 in modlog.php :

$logs=$DB_site->query("SELECT type,modlog.userid as userid,modlog.threadid as threadid,modlog.postid as postid,fromforumid,toforumid,modlog.timestamp as timestamp,modlog.ipaddress as ipaddress,threadtitle, user.username as username

[mtha]

Overgrow, it'd be cool if you can add some option to

- "download" the log file, before delete it. The file could be in txt or html format.
- view x logs in a page, so you can view next pages without having it too long
- delete logs older than x days, so you still can keep the recent logs.