vb.org Archive - Moderator Activity Logging

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 (https://vborg.vbsupport.ru/showthread.php?t=17206)

Sorry - wrong thread

Sorry for not replying sooner but our host lost all our files and database in a server crash or somming, spent the last 2 weeks trying to get a new reliable host and rebuild the board and the last ofline backup we had and add all the hacks back and add a few more.

I cant remember off hand what the mods where but just upload the new Modlog.php file and follow instructions included to update the other php file.

it worked OK for us as i was only a super mod on our site and i showed up in the modlogs along with admins and normal mods.

Why would you want a MODLOG script that didnt log the actions of some moderators ( even if they are called Admins ).

But i spose you could add a
if not adminusergroupid then {
too only run the script if not an admin.

Im too tired and too involved elsewhere at the moment to work it out anymore thatn that for you at the moment, But shouldnt bee too hard.

I installed this hack but it caused a problem for me. I had a friend upgrade my vB to 2.0.1 or what ever the latest version is.

When I installed the hack it changed my vB version to vB2 beta 4? WTF? how the hell did it do that?

the install went great.

but when lookin at the log theres nothing there...
yet i have closed a couple of threads.

anyone know what can cause this?

thanks.

did you create the table in your database?

Edit: Oh yeah, I am having trouble with clearing the logs.

yes i did - but its all empty.

Just curious if this script is going to have any further updates?

I have noticed a few bugs in it:

Moderators with custom titles do not list in the log, however their actions do.

Closed threads do not log which forum they were closed in.

Moved threads do not show the destination forum.

Deleted Threads do not show the forum they were deleted from.

I believe I am running vB 2.0.0 on a 2k machine with mySQL 3.23.32 and PHP4.0.5 .

If someone could help me with a fix for these bugs I would greatly appreciate it.

yeah I have the same problems as ShadowTech.. I tracked down the problem with nothing being filled in under the 'from' and 'to' columns... when a post is moved/deleted/copied, there are no values being filled in to the database under 'toforumid' and 'fromforumid'... I decided to fill these values in manually for a couple of database records, and whalla the correct forum names appear.... but how can I make the necessary changes in postings.php so that these values get filled in correctly? I just d/l'ed and installed the latest version today (overgrow's version - no other mods added)..

Here is what I did to fix this, hope I can explain it well. I haven't done the issue with the moderator with custom titles yet, but I'll work on it later.

Remeber : I'm by no means good at PHP :)

This is all in postings.php

Find (in the open /close thread block):

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()."')");

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])."','$threadinfo[forumid]','','".time()."')");

Find (in the delete thread block):

PHP Code:


		
			
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,toforumid,timestamp) 

        VALUES ('2','$bbuserid','$threadid','".addslashes($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])."','$threadinfo[forumid]','','".time()."')");

FIND (in the move thread block):

PHP Code:


		
			
updateforumcount($threadinfo[forumid]);

Directly BELOW it ADD:

PHP Code:


		
			
$movefrom=$threadinfo[forumid];

FIND (right below the last step):

PHP Code:


		
			
updateforumcount($forumid);

Directly BELOW it ADD:

PHP Code:


		
			
$moveto=$forumid;

FIND (Later on in the thread MOVE block):

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()."')");

Replace with:

PHP Code:


		
			
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,toforumid,timestamp) 

        VALUES ('3','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$movefrom','$moveto','".time()."')");

Josh

hey!!! works perfect now!! thanx JoshFink!:)

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (10)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01339 seconds Memory Usage 1,759KB 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 (10)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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: