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~

[0zone]

So, this hack does log deleted posts? Not just threads, but posts as well?

[Roody]

I still have this hack installed, but when I upgraded to 2.3.0 I lost it in my admin panel. The only way I can access it now is by actually typing modlog.php in my address bar. How can I add it back to the statistics and logs section?

Also, for knowledge purposes how do you go about uninstalling this hack?

[mossyuk]

thanks, installed.

[Hobbes]

06-29-03 at 11:20 PM 0zone said this in Post #111
So, this hack does log deleted posts? Not just threads, but posts as well?

Yea, it logs deleted threads, not posts though.

To uninstall, I THINK ...

(1) drop the table "mod log" from your database.

(2) undo all edits done to postings.php

----

should work, if not...sowwie =P

[Set]

Hi all,

on vb 2.3.0, this is the error:

----------------------------

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.username as username
FROM modlog
LEFT JOIN user ON modlog.userid = user.userid

ORDER BY modlog.timestamp DESC
LIMIT 0,100
mysql error: Unknown column 'modlog.ipaddress' in 'field list'

mysql error number: 1054

--------------------

Can you help me?
Thanks to all

[Set]

up... please

[Set]

Nothing????

[DannyBoy8406]

Does this record the IP address that the moderator was on at the time the actions was recorded?

[chuckc]

Seems we have a new problem on our board. Don't know if it started before or after we installed this hack, but we think it started after.

Problem:

A member starts a thread in the proper forum, but the thread appears in a different forum.

For instance, if this thread was started in the Full Releases forum, it might have shown up in Site feedback or the General Hacking forum. It's random and unpredictable, plus we can't force it to happen.

[chuckc]

For all those who asked:

No, it does not show IPs.

The hack shows some activities of moderators and admins:

Deleted threads w/ titles, who did it, what forum it was deleted from, and the date/time.

Moved threads w/titles, who did it, from which forum to which forum, and date/time. It also shows COPIED threads as being MOVED, when in fact the thread was only copied.

The hack does not show individual post deletions by the poster or by admins or mods, but I think I saw a couple of pages back that you can add that feature for admins and mods only. You have to go rad all the posts - I'm going to bed.

All in all it's a good hack - solves the problem we had with the not-me we always got when a thread disappeared. Except for the mis-placed threads problem I mentioned in the previous post.