vb.org Archive - Moderator Activity Logging (updated)

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Moderator Activity Logging (updated) (https://vborg.vbsupport.ru/showthread.php?t=35585)

installation ok, but i have the same Problem on my Version 2.2.7 and i make yourself a link on the left cp side and sorry not logs :-( but i want this great Hack

Quote:

Originally posted by hellsatan
3.) Would it be possible to include a code for Posts that have been deleted, not just threads...

anyword on this feature? please.

Is there a way to track edited posts, deleted posts, moved threads/posts, split threads/posts, edited user profiles and deleted users? Now THAT would be an awesome logging system for Admin and Mods. :)

Also when I click clear logs it does nothing. ??

i can't seem to make this work on 2.2.8--

i had the old version installed before and it worked fine. when i upgraded, only the previous logs were there. no new logs. i closed, opened, deleted etc and still won't log my activities.

i uploaded modlog.php again.. all the old logs dissappeared but still won't update.
i edited the clear logs instructions above--- still nothing happens.

any help will be appreciated. thanks.

anyone know how I could add a dropdown to the top of the modlog page that fills with the names of the mods that have something logged so you can jump to just their logs? I know you can click on a name of a mod to go to just their logs, but if they arent on their till like a couple of pages I have to find a page that they are in before doing that. It would be nice if I could just jump straight to a person. How easy is this to do?

Working great on 2.2.9.

Quote:

Originally posted by SoloX

anyword on this feature? please.

Yes, this would be a great feature.:)

*edit

Nervermind. Works great on 2.2.9 :)

Thanks OG!

how would i go about getting it to log poll editing?

Quote:

Originally posted by camoboy
This addition would be very helpful

One of our mods has been going round deleting posts, not threads and they don't get logged, so I can't work out who.

Once I find out they're ganna be slapped back down to Registered Member, but this would help a lot.

You can check this already.
Just look at the admin log.
If you're not userid '1', ask the founder of the forum to add your userid to the 'can view admin log' config variable, then search the log for the mod who's been deleting the posts...

Dave.

Quote:

Originally posted by Davey

You can check this already.
Just look at the admin log.
If you're not userid '1', ask the founder of the forum to add your userid to the 'can view admin log' config variable, then search the log for the mod who's been deleting the posts...

Dave.

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

Quote:

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.

Works perfect on 2.2.7 :cool:

Fantastic Mod. Thanks! :)

it work great! 2.3.0

Quote:

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

Code:

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

Code:

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

ADD BEFORE

Code:

// 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

Code:

  // 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

Code:

  // 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

Code:

  // 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

Code:

  // 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

Code:

  // 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

Code:

  // 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

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!

Great it works perfectly on 2.3.0 at once :D

Install clicked :D

One silly question:

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

Cheers

Hi mtha,

Quote:

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

execute

Code:

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:

Code:

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

this is the error:

Quote:

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

Quote:

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

I am gettin an error running this query:

Code:

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 :p

let me know if it works

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

Quote:

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.

Quote:

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 :

Quote:

$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

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.

very cool hack!! :)

Thanks overgrow and mtha :) works liek a charm..

when i try to access modlog.php in my admin cp, i get this error:

PHP Code:


		
			
Fatal error: Call to undefined function: modlog() in /home/virtual/site31/fst/var/www/html/admin/modlog.php on line 185

any help would be greatly appreciated ! :banana: :p :p :p ! :eek:

i wonder if this also log super mod

I think it logs all entrys into the mod cp....althuogh I am thoroughly unsure..

btw, i find that im always unsure on vb.org since i never know if im right..:p

I have ver 2.3.0 and I have tried installing this but the only people it seems to want to log are the admins. Is this just not working on my ver or might I be doing something wrong.

Thanks for any help in advance.

Oh and I'm still getting everything set up before I open :laugh:

Does this thing log when a user is banned by a moderator?

Cuz recently, some of the members of mine got banned and they were by one of the supermods, can't figure out which one, they all say they didn't do it.

this hack has almost no support.....i had to figure how to fix it all by my lonesome self.....heh =\ =\ =\...

it log closed, moved, opened, deleted threads and posts...

...

how do i uninstall it?

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

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?

Quote:

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

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 :)

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

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.

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.

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01455 seconds Memory Usage 1,845KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (12)bbcode_code_printable (2)bbcode_php_printable (13)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: