Moderator Activity Logging (updated)

[Overgrow]

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

[Overgrow]

install_modlog.php

[Overgrow]

modlog.php (updated to fix htmlheader problem 03-12)

[SWFans.net]

Thanks for the update to a great hack. :)

[nafae]

yes I am about to install this. I jump for joy!

[Psychdrone]

Originally posted by nafae
yes I am about to install this. I jump for joy!
ditto

[nafae]

I just wanted to say I installed it and it works PERFECTLY~THANK YOU!

But, how typical, I have a question: I have the "bump without post-moderator version" installed -Does anyone know how I could add to this hack to encompass this hack so it would say something like: "Bumped Threads W/O Post:"

Just another thanks to Overgrow for updating this hack for 2.2!!

[Twig Deez]

groovy. :)

[streamzone]

great work on this hack. i installed it flawlessly. i dont see an option for it in admin cp but i just did the http://www.xxxxxxxx.net/xxxxxx/admin/modlog.php to use it.

thanx

[Lucky]

This is just what I have been looking for!

Thank you Overgrow.

Just a quick question though?
I have the logs set to max logs at 10.
So by that does this mean that it will always store 10?
I have run a test and have tried to clear all logs, but it won't.
Am I right in assuming that the logs will always store the minimum amount of logs such as 10?
Or when deleting all should all logs be deleted?

That is all.

TIA

[Overgrow]

I think if you follow all directions (modifying admin/index.php) that you should have an entry for it in the Cpanel-- it will be below the Admin Logs.

>>I have run a test and have tried to clear all logs, but it won't.

Usually when people had problems with this it was because it uses a javascript onchange or something.. I forget..

>>So by that does this mean that it will always store 10?

No, it will store an infinite amount of records until you clear out the table. (You can do this manually with the empty command from phpMyAdmin or mySQLFront).

When you select 10, 25, or 100 that is the amount of records it will show you on the page, not how many it will store. Hope this helps~

[dxb]

waaaw I've been waiting for this hack

but I noticed It's still missing the stick/unstick merg/split edit functions

anyway thanks alot overgrow

[Overgrow]

I don't care enough about those to bother logging em.. if someone wants to write an extension of this hack, feel free, it would be easy.

[nafae]

yes and the bump w/o post moderator version :)

[Lucky]

Thanks, I know how to manually delete the logs, but it would be good if that feature worked as it fills up pretty fast. If you know how to remedy this please post as I would really appreciate it.
TIA

[Destee]

Thanks Overgrow, everything seems to be working fine. Just waiting for a mod to do something (my test mod name isn't logging any activity, but I think that's another issue).

I like my hacks nice and easy like this one! :)

Thanks Again.

Destee

[Tarion]

i had a problem on V 2.2.1:

Fatal error: Call to undefined function: htmlheader() in /kunden/fanwerk.com/webseiten/vbb2/admin/modlog.php on line 56

the header is still intact and all changes are made i don't know what happend???

[Tim Wheatley]

This doesn't work for me? I had the old version installed, but stopped using it (didn't delete the sql entries) so I just followed the upgrade instructions... but I just deleted a thread (I'm an admin) and it's not bringing it up...

[Tim Wheatley]

Weird. I assume changes were made to the table entries between the earlier version and this one?

I manually edited the mysql table and renamed modlog to modlogold, then ran the sql query from inside the install file. Then I've manaually copied the old modlogold data into the new modlog and it works fine. :)

[wbc]

to delete the logs don´t wotk, can you fix this please

[camoboy]

Originally posted by Tarion
i had a problem on V 2.2.1:

Fatal error: Call to undefined function: htmlheader() in /kunden/fanwerk.com/webseiten/vbb2/admin/modlog.php on line 56

the header is still intact and all changes are made i don't know what happend??? I get the same problem when viewing modlog.php

Any fix??

[Overgrow]

>>Call to undefined function: htmlheader()

Sure, upgrade your PHP.. sounds like you're using PHP3.

I'll work on delete logs and other stuff in a bit, thanks.

[achilles]

I also get the "Fatal error: Call to undefined function: htmlheader()"

Im running PHP 4.1.2


Great hack btw :)

[FWC]

Well done, Overgrow! :)

[Hellburn]

I have installed yesterday vB 2.2.4 and install this hack in to. It's working fine but i can not clear the Logs in the cp. At Version 2.2.2 i don't have this Problem. Hope you can help me.

mfg

Hellburn

[69-FLy-gUy]

it wortks for me.. the only thing i can't get to work is in the moved threads.. the To and From forum... anyone else hasve this problem????

[Overgrow]

If you cannot clear the logs, open modlog.php, find:

<a href=\"javascript:void(0);\" onClick=\"javascript:if(confirm('Click OK to clear all moderator logs.')) {document.location.href='$PHP_SELF?rt=".time()."&clearLogs=yes&showLimit=$showLimit';}\">CLEAR ALL LOGS</a>

Replace with:

<a href=\"$PHP_SELF?rt=".time()."&clearLogs=yes&showLimit=$showLimit';}\">CLEAR ALL LOGS</a>


If you have the htmlheader() problem, find two times:

HTMLHeader()

replace with

htmlheader()


hope that helps, but who knows :D

[Hellburn]

When i replace this code i have the follow error:

Parse error: parse error in /is/htdocs/12566/www.***********.com/vbb2/admin/modlog.php on line 232

mfg

Hellburn

[Overgrow]

That was probably VB's php code thingy messing with the slashes. Try it again with the above code, I removed it from the PHP block.

[Hellburn]

Now when i wont clear the logs comes this error:

Database error in vBulletin Control Panel 2.2.4:

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

[Overgrow]

I dont know, it works for me. Can you run that query in phpMyAdmin and see what the real error is?

[achilles]

Update for anyone having problems with:

"Fatal error: Call to undefined function: htmlheader()"


Open modlog.php

search for this line
//echo "<table border=0 cellspacing=0 cellpadding=4 width=95%>";

and remove it.


Thats it, that fixed it for me... I think for some reason even tho it was commented out php was parsing the semicolon. Not sure exactly, but removing that line fixed the problem for me.

Hope this helps anyone else having the same problem :)

[Overgrow]

Thanks! How bizarre it happens for 1% of the users.

[WhiteKnight]

How do I need to modify modlog.php to have an entry written into the adminlog whenever modlog.php is accessed?

Maybe one entry for just viewing the modlog, but more important: an entry whenever the modlog is pruned.

[69-FLy-gUy]

Hellburn,
Ok. I found the problem with why you were getting that SQL error...

Go to the line that you had to change so the clear logs would work..

When you put this :

<a href=\"$PHP_SELF?rt=".time()."&clearLogs=yes&showLimit=$showLimit';}\">CLEAR ALL LOGS</a>

Notice this part of the above code...

showLimit=$showLimit';}\">

It is missing a \"

It should look like this...

<a href=\"$PHP_SELF?rt=".time()."&clearLogs=yes&showLimit=\"$showLimit;}\">CLEAR ALL LOGS</a>

I highlighted what was missing..

Overgrow. you may want to update your post=))

Do you know why it won't show the to and from parts in the mod log? it doesn't record it??

[Hellburn]

Thank you this code does work.

mfg

Hellburn

[69-FLy-gUy]

no problem=)) wow.. i solved a problem.. my first one=) YAAAY! im happy=)

[WhiteKnight]

Fine, now what about my problem (https://vborg.vbsupport.ru/showthread.php?postid=228896#post228896)? :)

[69-FLy-gUy]

I don't know how it would look.. but i am guessing that you would have to look in the adminlog and look at how the settings are for how it views all the stuff. then add a similar thing to modlog.... thgat is my guess

[69-FLy-gUy]

I still dont' know how to fix my problem yet. .lol

[Tim Wheatley]

How can I have this viewable in the mods cp?

[JDD]

Hi...

this is a great Hack.. but one further question.. is it possible to log deletion of postings within a thread also?

Greetz
BitByter

[Tim Wheatley]

Nevermind about my question, I got it doing it, incase anyone else wants mods to be able to see this too:

Open modlog.php,

Search for 'Clear all logs'

delete that.

Upload modlog.php to root/mod

enter a link to modlog inside mod/index.php

This then removes the mods ability to delete their logs, and also means they can see it incase of argument.

[Hubsi]

big THX for this great hack, it´s wonderfull

greats

Hubsi

[kidney]

I would like to know why is there a 5 in this add on, it seems to create a problem....

in the third modification in the posting.php

[David Bott]

Installed on 2.2.4 Very nice and needed. Thanks!

Now if we only had a post recycle-bin for deleted posts and threads. :) Would be a nice addition.

[camoboy]

Originally posted by JDD
Hi...

this is a great Hack.. but one further question.. is it possible to log deletion of postings within a thread also?

Greetz
BitByter 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.

[c-pr0mpt]

Wonderful hack Overgrow.

When i ran the install I got a mysql error because of modlog table already existing in the vB database. MY vB version is 2.2.5. Does this hack not work with 2.2.5?

Here is the error exactly as it says,


Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: CREATE TABLE modlog (
type tinyint(1) DEFAULT '0' NOT NULL,
userid int(10) DEFAULT '0' NOT NULL,
threadid int(10) DEFAULT '0' NOT NULL,
threadtitle varchar(100) NOT NULL,
fromforumid smallint(5),
toforumid smallint(5),
timestamp int(11) DEFAULT '0' NOT NULL
)
mysql error: Table 'modlog' already exists

mysql error number: 1050

Date: Sunday 14th of April 2002 10:56:00 AM


Should I delete the current table in there and start over? Thanks for any help from anyone.

[Overgrow]

Did they add this feature with 2.2.5? Or maybe the forum you're working on already had the old version installed?

If you had a previous version installed, you don't need to do any table modifications-- it is the same table schema as the previous version.. just upload modlog.php to your admin directory and create an entry for it on the left hand side menu of your Cpanel.

hth~

[c-pr0mpt]

This is for yaxay. And I checked the modlog table in mysql and it has some threads in it. Looks like all the threads I have deleted in the past, and the userid of who deleted it.

Here is a sshot:

http://www.yaxay.com/linkto/modlogsshot.gif

So I guess this was added in 2.2.5? :confused:

[Silenced Soul]

Nice hack, very useful, now I can prove my mods aren't doing their jobs. =P

[ZiRu$]

um......can you update this or just give me the code so that it wont log admin activity????

[Chris M]

This is a great Hack...

I shall start right away and install it!

Satan

[Esorcista]

Does it work on Vb 2.2.5?
It didn't work 4 me :(

[mak]

i can't download the attachments at all.
is it a text file or zipped?

i get an attachment.php when i download it.

i'm using a mac and i'm not sure that's the reason why. is it?
i can download the other attachments here with no problem. can someone help me?

this is a real cool hack,

thanks. :)

[Ian]

They work fine for me and there in text.

[Sezmarone]

This is a great hack! It sure would be nice if it had edit in it too!

[Mental Stamina]

i can't d/l the files...can someone post a text link?

[CJi]

Does this work with 2.2.5? Don't want to risk trying it on a production board.

[Chris M]

@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

[Sinecure]

Thanks Overgrow, it worked flawlessly :)

[dogbomb]

For those people who wanted this hack to show up in their CP Panel. You will need to edit admin/index.php

FIND:
makenavoption("Permissions","forumpermission.php?action=modify");

REPLACE WITH:
makenavoption("Permissions","forumpermission.php?action=modify","<br>");

ADD UNDERNEATH:
makenavoption("Activity Log","modlog.php?showLimit=100");

And that hopefully should work for you :)

[mak]

can someone attach the install_modlog.php and modlog.php again?

i can't download them at all.

thanks.

[Ian]

Here you go!

[Ian]

Here you go!

[dreamhost]

this hack is worth more than the $ of the board...hehehehe

[Heineken77]

Hey Overgrow :)

Long time!!!

Thank you! :)
Heineken

[Mephisteus]

Works perfect :) I have had no need for deleting so far, so no probs :p

[santeematt]

sweet, i cant trust those damn moderators of mine :P

[Meirion]

one minor change to this class hack to make it work with the "Recycle Bin" hack.

This lets you click the titles of the deleted threads to view them.

in modlog.php find:


if ($subArray[type] != "2") // Deleted?
echo "<a href=\"../showthread.php?threadid=$subArray[threadid]\" target=\"_blank\">$subArray[threadtitle]</a>";
else
echo "$subArray[threadtitle]";

replace with
if ($subArray[type] != "2") // Deleted?
echo "<a href=\"../showthread.php?threadid=$subArray[threadid]\" target=\"_blank\">$subArray[threadtitle]</a>";
else
echo "<a href=\"../showthread.php?threadid=$subArray[threadid]\" target=\"_blank\">$subArray[threadtitle]</a>";

Don't forget you need the recycle bin hack for this to work.

[deano1]

when i install this hack
i get this error
when running the install

Warning: Failed opening '/home/deanosw/public_html/vbtest/admin/install_modlog.php' for inclusion (include_path='') in Unknown on line 0

[redd]

Does this work with 2.7 ?

[N9ne]

Yeah does it work with 2.2.8?

[Ian]

Originally posted by Tha Rock
Yeah does it work with 2.2.8? Yes.

[Exo]

hm it only logs complete Threads, how can i make it so that it logs posts too. If a Moderator delete a post in a Thread, its very important to know that! :(

[Gizmo99]

Sexy is not the word :banana:

Giz

[BigCheeze]

Installed and working perfectly in 2.2.8! w00t w00t!! Can't trust them dam mods! LOL

[neocorteqz]

It's not logging my test mods activity..

Nice install though. I will go over the file hacks again.. see if I missed something.

Nice Job:)

[Larry@IOG]

I installed it with no problems. So far my mods have done nothing for me too see

Larry

[Larry@IOG]

Ok I have it installed but it does not log any of the mods actions,

2.2.8

Larry

[subu1]

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

[SoloX]

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.

[350Chevy]

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. ??

[mak]

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.

[yzztik]

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?

[neocorteqz]

Working great on 2.2.9.

Originally posted by SoloX


anyword on this feature? please.

Yes, this would be a great feature.:)

[VAN]

*edit

Nervermind. Works great on 2.2.9 :)

Thanks OG!

[sabret00the]

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

[Davey]

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.

[pgowder]

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

[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 :cool:

[mharmon]

Fantastic Mod. Thanks! :)

[mtha]

it work great! 2.3.0



04-30-02 at 07:28 PM hellsatan said this in Post #60 (https://vborg.vbsupport.ru/showthread.php?postid=246177#post246177)
@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,fromforum id,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,tofo rumid,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,tofo rumid,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,tofo rumid,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,tofo rumid,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,tofo rumid,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,tofo rumid,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 :D

Install clicked :D


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 (https://vborg.vbsupport.ru/showthread.php?postid=370166#post370166)
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 (https://vborg.vbsupport.ru/showthread.php?postid=382824#post382824)
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`


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

[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.

[Jing]

very cool hack!! :)

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

[Hobbes]

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

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:

[Hobbes]

Buuump...!

[lioncool1589]

i wonder if this also log super mod

[Hobbes]

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

[Katryna]

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:

[Xyphen]

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.

[Hobbes]

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

...

[Malfunktion]

how do i uninstall it?

[Malfunktion]

n/m

[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 (https://vborg.vbsupport.ru/showthread.php?postid=414093#post414093)
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.

[chuckwk]

installed on 2.3.2 .. working perfectly

[chuckc]

Still waiting for a response to this question:

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.

[94supratt]

It did not log when a thread was closed for some reason. Logged moved threads.

[Oblivion Knight]

This is only logging admin activities..
I was under the impression that it should log moderator's and super moderator's as well as admin's actions.? :nervous:

[Elly]

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.


I would also like to know on this as well. I have the allow mods a temporary ban of users (https://vborg.vbsupport.ru/showthread.php?t=39584&highlight=mods+ban) by Hotte instaled and would like to know if this hack already tracks this as well or if i could be implimented by someone.

I would be very gratefull to whoever can help

thanks
- Elly

[Coolj]

Is there any way to check if a super mod banned a user?

[Elly]

I think there is another hack for that Coolj you just have to find it ....

[hurrican]

Is there a TEXT install for this? I'm running 2.3.4 and I can't get the install file to work. I like that it shows in detail what thread is closed, deleted, etc, rather than the admin log. Any help is appreciated!

[Keith]

Trying to use the buttons to clear the logs doesn't work either. Hack should still be in beta?

[nomic]

Installed it on 2.3.4, works perfectly - Thanks Overgrow! :)

[weirdpixels]

thanks, overgrow working great on vb 2.3.5

[animi12]

great hack. still needs delete post logging. haven't upgraded to vb 3 yet and am not really ready, but would appreciate some help writing the delete post add on for this mod.