View Full Version : [RELEASE:all] Moderator Activity Logging
Overgrow
Fri 18th May '01, 1:26pm
Moderator Logs for vBulletin
http://www.overgrow.com/archive/modlog1.gif
http://www.overgrow.com/archive/modlog2.gif
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.
Steps for installation:
-add one database table 'modlog'
-edit one file 'postings.php'
-upload one file 'modlog.php'
!!! DISCLAIMER !!! Hack at your own risk. I do not run v2, I will never run v2, I apologize if things are not exactly how they seem. May cause staining, test on hidden piece of fabric first. No this does not install itself. Learn to use phpmyadmin.
Overgrow
Fri 18th May '01, 1:28pm
FILE UPDATED: May 18, 2001 3:30 pm PST
See the bottom of the page....................>>
amykhar
Fri 18th May '01, 2:06pm
I can't find them in rc3 either.
Amy
RobAC
Fri 18th May '01, 2:40pm
Overgrow,
First of all, cool site!
I noticed your forums are version 1.1.3, but you're releasing hacks to be used for 2.0. Are you testing these hacks on the latest RC3 before releasing them?
tubedogg
Fri 18th May '01, 2:41pm
Looks good :)
Couple suggestions
Make a file that will automatically create the table necessary to run this.
Use global.php. And then look at adminfunctions.php (from vB2 RC3) and use the functions like maketableheader and stuff. It'll simplify the creation of the layout. Also maybe include instructions on how to add a link to this in the Admin CP.
smelialichu
Fri 18th May '01, 3:31pm
Basically make it easy to install like kiers. Makes the needed tables, and then shows install instructions. Very useful hack.
Limey
Fri 18th May '01, 3:46pm
I'm not trying this hack out yet, but damnit man you are coming out with some seriously impressive and USEFUL! hacks Shabang.
My hat is off to you!
ztsky
Fri 18th May '01, 3:56pm
It can't work in rc2 and rc3.
The postings.php isn't like your said in the zipfile.
Overgrow
Fri 18th May '01, 4:52pm
Argh ok hold off on installing it until I download the latest RC3. I have an older version of V2, I didn't expect that the variables would change so much from RC to RC.
>>Basically make it easy to install like kiers.
Sorry, I write hacks for myself. I think people will find them useful so I release the code. I don't have the time or willingness to write fancy install scripts. If you can't paste in the create table code to phpmyadmin, maybe you shouldn't be hackin..
I'm not trying to win a VB developer spot here, just releasing some code.
New version in a little while.............
Overgrow
Fri 18th May '01, 4:53pm
p.s. check out the code that it is! I'm very proud of myself.. hacking VB is seriously improving my PHP skill. I now use multi-dimensional arrays in this one instead of my old explode the pipes perl method.
Limey
Fri 18th May '01, 4:59pm
Hey I'm proud of you :) and your website :)
Me2Be
Fri 18th May '01, 5:06pm
Originally posted by Overgrow
[B]Argh ok hold off on installing it until I download the latest RC3. I have an older version of V2, I didn't expect that the variables would change so much from RC to RC.
Thanks for this! Can you let me know when you have the RC3 ready?
Originally posted by Overgrow
I'm not trying to win a VB developer spot here, just releasing some code.Yeah, that's what Kier thought too! ;)
Overgrow
Fri 18th May '01, 6:25pm
FILE UPDATED: May 21, 2001 6:50 am PST
FIXES -
-addslashes bug detected and resovled by wluke, this was causing some data to be ignored.
Included are two versions of install.txt, for V1 and V2. The V2 installation is much simpler. I like the structure, I may convert yet.
TimberLand
Fri 18th May '01, 7:09pm
Nice, That's really nice. http://www.vbulletin.com/forum/images/icons/icon14.gif
Overgrow
Fri 18th May '01, 7:49pm
No complaints, so I assume it's working for V2 now?
ps. thanks for all the nice comments on the hack & site
Me2Be
Fri 18th May '01, 7:51pm
Originally posted by Overgrow
No complaints, so I assume it's working for V2 now?
ps. thanks for all the nice comments on the hack & site I Love it!! I sent you a PM :)
Freddie Bingham
Fri 18th May '01, 7:56pm
Basically make it easy to install like kiers. Makes the needed tables, and then shows install instructions. Very useful hack. You should reserve that sort of constructive criticism for your own hacks. Be appreciative of any hack you receive in any form that it comes in.
ztsky
Fri 18th May '01, 11:38pm
It worked ,:)
what a good a work you did!
Me2Be
Sat 19th May '01, 2:26am
I seem to be getting some VB errors for this -- can you take a look at what could be wrong? They seem to be only on those threads that are MOVED and those that have an apostrophe in the subject.
Database error in vBulletin: Invalid SQL: INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp) VALUES ('3','3864','53151','Lee and Colin's Journal','','','990238526')
mysql error: You have an error in your SQL syntax near 's Journal','','','990238526')' at line 2
Database error in vBulletin: Invalid SQL: INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('3','3864','57894','how i'm saving money','','','990241258')
mysql error: You have an error in your SQL syntax near 'm saving money','','','990241258')' at line 2
mysql error number: 1064
Wayne Luke
Sat 19th May '01, 2:57am
In postings.php
Find:
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('$threadinfo[open]','$bbuserid','$threadid','$threadinfo[title]','$forumid','','".time()."')");
Replace with:
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('$threadinfo[open]','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$forumid','','".time()."')");
Find:
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('2','$bbuserid','$threadid','$threadinfo[title]','$forumid','','".time()."')");
Replace with:
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('2','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$forumid','','".time()."')");
Find:
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('3','$bbuserid','$threadid','$threadinfo[title]','$curforumid','$movetoforumid','".time()."')");
Replace with:
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('3','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$curforumid','$movetoforumid','".time()."')");
smelialichu
Sat 19th May '01, 4:12am
Originally posted by freddie
You should reserve that sort of constructive criticism for your own hacks. Be appreciative of any hack you receive in any form that it comes in.
It wasn't criticism, just a suggeestion. i respect the hacik. I could never do anything like that and it's a really good hack. I'm sorry if I offended anyone. I'm thankful overgrow released his work for everyone else to use.
bokhalifa
Sat 19th May '01, 4:25am
good hack min:)
VirtueTech
Sat 19th May '01, 9:46am
Brilliant.
I've been waiting for something like this.
I'd actually like to show these kinds of things on the threads themselves to the users.
Such as:
Who close the thread - Mod or Thread Owner.
Text Reason for why the thread was closed
etc.
Great Job Overgrow...I'm impressed.
Thank you :)
VirtueTech
Sat 19th May '01, 11:04am
One question - Does this hack check permissions of the user viewing the logs?
Reason being the file allows the user to "Clear the Logs" and I would like to make sure that it can only be performed by an Admin.
I want to give access to my moderators but I don't want them to be able to clear the logs. So I added this...but it didn't work because the script is not defining $bbuserinfo['usergroupid']
<?
if ($bbuserinfo['usergroupid']==6) {
echo "<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> -";
} else {
echo "";
}
?>
I tried adding: require("./config.php");
but that produced errors. Any ideas?
VirtueTech
Sat 19th May '01, 1:30pm
I think I found a bug....One of my "Super Moderators" closed a thread and the script did not enter the "Super Moderators" name in the Moderator Name field.
Check the image out or click this link for a demo (http://forums.paintballdojo.com/admin/modlog.php):
http://www.paintballdojo.com/mod_logging.gif
Me2Be
Sun 20th May '01, 11:08pm
I only have super mods and it seems to be working for me for both super mods and admins
Wayne Luke
Sun 20th May '01, 11:35pm
It works fine for me after making the three changes that I listed above.
VirtueTech
Mon 21st May '01, 1:58am
wluke: your right...I did not make those changes you losted above.
I will try and post back.
Overgrow
Mon 21st May '01, 9:46am
/me slaps himself around with slashes.
^^^^^^^^^^ Zip file fixed way above.
ocps
Tue 22nd May '01, 10:58am
hi, im new to this but i got it all done except i dont kno how or where to create a table, anyone able to help me?
Overgrow
Tue 22nd May '01, 11:58am
Before you start hacking up vBulletin, you should know your way around phpMyAdmin:
http://www.phpwizard.net/projects/phpMyAdmin/
Under the listing of your tables it has a textarea box where you can paste in the CREATE TABLE code. That is the easiest way without having to learn telnet.
ocps
Tue 22nd May '01, 2:07pm
i looked for phpmyadmin.php and didnt find it....or do i not even have that...im just learning this, im a web/graphic designer, not programmer...
jojo85
Tue 22nd May '01, 2:19pm
Who i love it
now i can install it cause the vb2.0 is out
thx very much guy :)
ocps
Tue 22nd May '01, 2:44pm
i finished all the rest....if setting up a table is too confusing maybe can someone do that part for me..i already did all the rest
Overgrow
Tue 22nd May '01, 3:12pm
Setting up a table is not that confusing. Trying to give you the steps to telnet and run mysql instead might be confusing. Downloading phpmyadmin is easy:
http://www.phpwizard.net/projects/phpMyAdmin/
Go there, download the zip, unzip, upload to a new phpmyadmin directory. Password this directory with .htaccess. There must be posts around here somewhere teaching you how to install phpmyadmin.
Once you have done this it will be your window into all of the database, you will wonder how you got along without it. Sorry my hacks do not install themselves, I believe you should be able to run phpmyadmin before hacking up vBulletin.
I was a designer first too, now I'm a hack programmer.. I'm sure you can learn it. Good luck.
ps. welcome, jojo
ocps
Tue 22nd May '01, 3:20pm
THNX MAN..I APPRECIATE IT ALOT..umm i actually dled it while i was waiting and uploaded it, but the config file is kinda confusing..like the one for the bulletin is easy, iot asks your database name password..like 3 things..but the phpadmin config has like 30 different things i dont kno what to put where.. i keep getting an error everytime
Maverick1236
Tue 22nd May '01, 9:23pm
Moderator Logs REFRESH - CLEAR ALL LOGS - Max: 10 25 100 all
There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.
An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
We apologise for any inconvenience.
any ideas?
tubedogg
Wed 23rd May '01, 7:32am
You must post the actual message, not just vB's stock error message. View the source of that page or the email and copy and paste one of those here.
Zarkov
Wed 23rd May '01, 10:12pm
I'm having a problem with the forumid variable.
Like it aint storing it in the table so when i look at the logs there is no forum names.
I am not the only one suffering this as there is a picture on another post where the forum names are missing.
I am new to all this so i am playing to see what i can learn but everything looks OK.
G0D
Fri 25th May '01, 5:37am
Thnx for the hack dude :)
The_Sisko
Fri 25th May '01, 8:01am
Originally posted by Zarkov
I'm having a problem with the forumid variable.
Like it aint storing it in the table so when i look at the logs there is no forum names.
I am not the only one suffering this as there is a picture on another post where the forum names are missing.
I am new to all this so i am playing to see what i can learn but everything looks OK.
Same prob for me!
ocps
Fri 25th May '01, 8:58am
well..this seems like the right area to post this, dont need to start a new thread..im having a prob when any admin or mod tries to chnage a post at all..this is the error thats in the tech support emial it sends me
Database error in vBulletin: Invalid SQL: INSERT INTO modlog
(type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('2','2','31','board colors in beta stage','','','990795085')
mysql error: Table 'ocps.modlog' doesn't exist
mysql error number: 1146
Date: Friday 25th of May 2001 05:51:25 AM
Script: /bb/postings.php
am i supposed to have a modlog.php file??..cause i dont
ocps
Fri 25th May '01, 9:09am
actually..there is a modlogs.php file, but if i try to access it in my browser i get this error,
There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.
An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
We apologise for any inconvenience.
Overgrow
Fri 25th May '01, 12:25pm
ocps: You need to create the modlog table. That is the first step in the instructions-- without it, no data can be entered. If you do not have phpMyAdmin installed then install this hack from wluke:
http://www.vbulletin.com/forum/showthread.php?threadid=3981
And paste the table create code into the query box that hack creates. Then the moderator hack should work.
To those with forumID problems, I'm sorry-- I can't see why this would be happening. Can you show me a screenshot? or the online example?
The_Sisko
Fri 25th May '01, 1:28pm
@Overgrow: I've send you an PM!
ocps
Fri 25th May '01, 11:14pm
o..was this part of your hack..i copied the files from one server to the other but i thought i got rid of your hack casue i installed it 1/2 way and stoped cause i didnt kno what to do with phpmyadmin..i had no idea this prob on the new board was cause of that
ocps
Fri 25th May '01, 11:26pm
k..i did everything except paste the table create code into the query box that hack creates..
im not sure what u mean..
ps..thx for helping me..im new to php
Psycho
Tue 29th May '01, 10:37am
Great hack Overgrow. Fairly easy to install, only took 15 min from start to finish.
My question is, have you thought about or are you planning to add more stats to it? As someone else I know, had a mod go on a ban trip. Even somehow banned the admin from his own board. So I was wondering if you planned on or could possible come up with something to add to this great hack with more mod stats such as the banning?
Thanks again for the great hack
BluSmurf
Tue 29th May '01, 12:20pm
great hack, installed with ease, two thumbs up!
chrispadfield
Wed 30th May '01, 6:21am
Originally posted by Zarkov
I'm having a problem with the forumid variable.
Like it aint storing it in the table so when i look at the logs there is no forum names.
I am not the only one suffering this as there is a picture on another post where the forum names are missing.
I am new to all this so i am playing to see what i can learn but everything looks OK.
I also have this problem.
The_Sisko
Wed 30th May '01, 9:39am
I've send Overgrow a PM about it. I found the 2 variables he uses for puting from and to forum ids, are wrong! But he didn't give me an answer now....
chrispadfield
Wed 30th May '01, 10:43am
do you know what the variables are? i guessed that was the problem cos i couldn't find them anywhere else either. The cryptic queries were confusing me so couldn't work out which was which to solve it.
Overgrow
Wed 30th May '01, 1:32pm
How can the variables be correct for me and for 90% of the people but not for a few?
Obviously we have versions mixed up and the variable names are screwy. It shouldn't be hard to find them and I don't think the queries are that cryptic-- they are simple inserts, right?
The postings.php I used was from RC3 I haven't changed it since gold was released. Did they change those variable names again?
Look above the queries you inserted into postings and see where else it mentions "forumid" or maybe "curforumid" or something like that...
chrispadfield
Wed 30th May '01, 1:58pm
your hack has the variables $fromforumid and $toforumid
when i meant cryptic i meant the vb stuff trying to work out which forumid to use :)
Me2Be
Wed 30th May '01, 2:00pm
Originally posted by Overgrow
Obviously we have versions mixed up and the variable names are screwy. It shouldn't be hard to find them and I don't think the queries are that cryptic-- they are simple inserts, right?
LOL, call me observant but I just noticed that it that the forum to/from doesn't work on mine either (RC2) :)
Typhon
Wed 30th May '01, 4:32pm
We just got it up and running on our site... works like a charm. :) Thanks!
Overgrow
Wed 30th May '01, 4:53pm
OK! It's a simple VB2 version problem I'm sure. When I first wrote this hack I based it on VB2 beta code. I don't run VB2 so I was just using the last version I had.
People noted that the variables had changed for RC3 so I updated the file. For all those missing forum ID's, please download the zip at the bottom of the first page of this thread. It hasn't changed lately, I just think you're still using the old version of the queries.
Any luck?
The_Sisko
Wed 30th May '01, 5:04pm
This is what you find in modlog02.zip:
// HACK
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('3','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$curforumid','$movetoforumid','".time()."')");
And:
$curforumid
$movetoforumid
are not the right variables. I'll try a look over it, to find the right ones...!
The_Sisko
Wed 30th May '01, 5:16pm
Found the bug:
If you allready installed the hack open posting.php and search for:
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('3','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$curforumid','$movetoforumid','".time()."')");and replace it with:
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('3','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$threadinfo[forumid],'$forumid','".time()."')");
What was the bug?
You need to change the variables:
$curforumid
$movetoforumid
to
$threadinfo[forumid]
$forumid'
Now it work for me!
chrispadfield
Wed 30th May '01, 5:31pm
cool, thanks for that and thanks to Overgrow for such a wicked hack.
etones
Wed 30th May '01, 5:52pm
how difficult would it be to keep track of when a user was placed into the 'Banned By Moderators' User group?
I've got lots a mods who like to ban (for good reasons)... however i'd like to keep a track of whos banning who... any ideas?
Cheers all. GREAT HACK..
once agaon Overgrow.. your da maaan!! :D
Overgrow
Wed 30th May '01, 6:30pm
I guess being able to be banned by a Mod is a 2.0 feature? Dunno anything about that, sorry. Someone else could easily expand this to catch the other 2.0 features like stick/unstick, merge, split, etc.
Sisko-- thanks for tracking that down. That was indeed the difference between the first version and the current release. All users who use the current file should have no problems.
ps. thanks for the good comments! I love this hack too, now I know who is slacking in the mod duties and who needs a promotion.
The_Sisko
Wed 30th May '01, 6:34pm
@Overgrow:
With your permission I'll try to add those features to it!
etones
Thu 31st May '01, 4:33am
thanks to both Overgrow and Sisko for helping out.
Cheers all.
chrispadfield
Thu 31st May '01, 5:31am
p.s. to get the forum to show up under closed and deleted threads you also need to change the variable to $forumid
Blue2000
Thu 31st May '01, 7:08am
what a great hack its nice to see what my mods r up to :p
it works fine for me apart from the "CLEAR ALL LOGS" there all still there even after a refresh. no error message or anything but it just doesnt remove them, i have had to do it in phpmyadmin
It also doesnt show where from, and i have made all the chnges that have been put in my the replys
BluSmurf
Thu 31st May '01, 6:57pm
Originally posted by The_Sisko
Found the bug:
If you allready installed the hack open posting.php and search for:
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('3','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$curforumid','$movetoforumid','".time()."')");and replace it with:
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('3','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$threadinfo[forumid],'$forumid','".time()."')");
What was the bug?
You need to change the variables:
$curforumid
$movetoforumid
to
$threadinfo[forumid]
$forumid'
Now it work for me!
Does this apply for v2.0 Gold too?
Overgrow
Thu 31st May '01, 8:28pm
re: vb2 gold and all other versions
I believe if you install from the latest zip on the front page of this thread you should have no problems. Those who were having problems most likely:
-Installed one of the old versions of the hacks
-Then used W.Luke's fixed queries but his queries were from a later version of the hack where I changed variable names to use VB2's new scheme
Sooo they had part old hack and part new hack = non working hack. If you use the latest version there should be no problems.
re: Not clearing the logs??
Anyone else with this problem? It couldn't be a simpler action:
// CLEAR LOGS?
if($clearLogs=="yes")
$DB_site->query("DELETE FROM modlog");
That's it. Dunno how that can malfunction for ya.
Overgrow
Thu 31st May '01, 8:32pm
Question for everyone:
1) What's your normal peak # of users online and how many moderators do you have?
2) Have you told your mods that you are watching what they do?
By my logs I can see that one of my overall mods is doing a great job.. but I'm not sure I want to mention this-- I don't want them to feel pressured as if their actions are being watched.
The_Sisko
Fri 1st Jun '01, 5:19am
1) ~20-30 , and 10 mods
2) no
etones
Fri 1st Jun '01, 5:32am
Usually about 50 constantly..
4 Mods... and they know... boy do they know :)
hehe
Zarkov
Fri 1st Jun '01, 7:01am
I have already worked out the problem with the forum names anyways so thats ok but i have also added the code to log
Edit,sticky,merge and split, Im not sure if i can post a complete modified postings.php so i wont. but if its OK then i will add that later.
All it is is a modification of the code supplied by Overgrow and a mod to modlog.php which i have added.
thanks for the great hack Overgrow.
The new mod in postings.php are
find
eval("standardredirect(\"".gettemplate("redirect_editthread")."\",\"showthread.php?s=$session[sessionhash]&threadid=$threadid\");");
}
above it add
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('4','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$threadinfo[forumid]','','".time()."')");
find
eval("standardredirect(\"".gettemplate("redirect_mergethread")."\",\"showthread.php?s=$session[sessionhash]&threadid=$threadid\");");
}
above it add
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('5','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$threadinfo[forumid]','','".time()."')");
find
eval("standardredirect(\"".gettemplate("redirect_splitthread")."\",\"showthread.php?s=$session[sessionhash]&threadid=$newthreadid\");");
}
above it add
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('6','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$threadinfo[forumid]','','".time()."')");
find
eval("standardredirect(\"".gettemplate("redirect_sticky")."\",\"showthread.php?s=$session[sessionhash]&threadid=$threadid\");");
above it add
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('7','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$threadinfo[forumid]','','".time()."')");
NORRITT
Fri 1st Jun '01, 9:22am
Zarkov, you have forgot to add in modlog.php:
case("4"):
echo "<span class=\"toplinks\">EDIT: </span>";
break;
case("5"):
echo "<span class=\"toplinks\">MER: </span>";
break;
case("6"):
echo "<span class=\"toplinks\">SPL: </span>";
break;
case("7"):
echo "<span class=\"toplinks\">STI: </span>";
break;
below switch($subArray[type]) {
case("0"):
echo "<span class=\"toplinks\">CLS: </span>";
break;
case("1"):
echo "<span class=\"toplinks\">OPN: </span>";
break;
case("2"):
echo "<span class=\"toplinks\">DEL: </span>";
break;
case("3"):
echo "<span class=\"toplinks\">MOV: </span>";
break;
great hack, i really like it! :)
NORRITT
Fri 1st Jun '01, 10:08am
Hmm, working really good, but if a moderator moves a thead, there is no item under the From and To column (its just blank).
is there still a litte bug? (I have the latest version, that was released, so there is no mixture of old and new version)
Zarkov
Fri 1st Jun '01, 10:30am
No i didnt DL the attachment. Its the updated modlog.php file.
You got me going then i had to load up the php file and check it again :)
also find this in the postings .php
eval("standardredirect(\"".gettemplate("redirect_movethread")."\",\"showthread.php?s=$session[sessionhash]&threadid=$threadid\");");
}
add above it instead of the almost identicle lines you have there(or just look at the differences after the VALUES blah de blah and alter yours to match
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('3','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$threadinfo[forumid]','$foruminfo[forumid]','".time()."')");
Overgrow,
I too suffered the same not clearing the logs problem,I tracked it down to be something to do withe the javascript used.
What i found was that if you clicked the clear logs file then clicked OK on the confirmation screen too quick it didnt clear it. Maybe cause the script was still loading ????
If you click clear logs then wait 10 secs or so then click OK it clears it first time every time.
Sorry i cant do anything to help sort that as i know absolutly nothing about javascript.
NORRITT
Fri 1st Jun '01, 10:53am
great - works :)
Thomas P
Mon 4th Jun '01, 11:08am
Hi there,
great idea, the hack
But it got kind of confusing by now, is Norrit's DL the latest and greatest?
Also doing all changes in Overgrow's notes and adding Zarkov's most recent changes... is this the only thing to do?
:rolleyes: :confused:
Sorry,
please enlighten me :)
-Tom
Overgrow
Mon 4th Jun '01, 12:09pm
My zip on the first page of the thread is the latest "real" version.
If you want the additional features of tracking splits, merges, and other things then you need to follow Z's and Norrit's instructions in order.
I invite them to re do the install.txt instructions and upload a new version in this thread so there is one file for people to d/l...
furious
Tue 5th Jun '01, 4:51pm
nice hack :)
just a little problem
i install modlog_v02
but i cant delete the logs :(
BluSmurf
Tue 5th Jun '01, 6:25pm
I'll wait for the new version with the added features.. hope it will be available for download soon soon, it's too confusing at the moment :D
Dakota
Thu 7th Jun '01, 3:20am
I am having the same problem with mine. It won't clear the logs. I have tryed waiting for acouple minutes, but it still doesn't work.:confused:
SSJ4 Saiya-jin
Fri 8th Jun '01, 12:51pm
What does this mean?
1) Add one database table - 'modlog'
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
How do I create a database table?
Dakota
Fri 8th Jun '01, 1:54pm
SSJ4: install this (http://www.vbulletin.com/forum/showthread.php?threadid=3981) hack first. it is very simple. Then in the CP it will create a link called query. Just copy and paste the text to create the table into it and press submit. I found that is much easier than trying to install phpmyadmin.
SSJ4 Saiya-jin
Fri 8th Jun '01, 2:08pm
Thanks again dak
Thomas P
Sat 9th Jun '01, 2:34pm
Hi there,
I managed to crawl through Overgrow's instructions plus Norrit's and Zarkov's additions ;)
Now I get an error message stating:
Fatal error: Call to unsupported or undefined function htmlheader() in /home/usr/(...)/forum/admin/modlog.php on line 71
Errrm, I'm using PHP3, guess the hack is only for PHP4, right?
Any chance to fix that? :confused:
Thanks,
-Tom :(
SSJ4 Saiya-jin
Sat 9th Jun '01, 4:43pm
Try viewing and editing the source.
Thomas P
Sat 9th Jun '01, 5:21pm
Sorry, I'm quite PHP-illiterate... :(
-Tom
SSJ4 Saiya-jin
Sat 9th Jun '01, 5:42pm
Then how do you even know how to set up a PHP board? You have to know atleast some.
Thomas P
Sat 9th Jun '01, 6:55pm
Well, basically I know quite a bit about HTML in all flavors and JS, Perl etc. - but nearly nothing about PHP.
Setting up the board and customizing it, i.e. colors and logos, was very easy - I didn't need to know anything about PHP...
Now to the hack:
Okay, actually I did a search on php.net to find a function called htmlheader(),
which was lame because I later found the function further down in modlog.php
(can I reference a function in php, which is below the call? - Interesting).
Good, I see that the error tells me htmlheader() is undefined, in lower
case... in modlog.php it is called HTMLHeader(), so I renamed it to
whatever() like Overgrow mentioned in a post with a problem similar to
mine - no effect, same error :(
http://161.58.84.213/forum/showthread.php?s=&threadid=15628&pagenumber=2#post99877
What brought me to the assumption that it might be PHP3 is the following
post of Overgrow in the same thread (vbSpiderFriend-hack by Overgrow)
http://161.58.84.213/forum/showthread.php?s=&threadid=15628&pagenumber=3#post100965
The option to upgrade to PHP4 is okay, BUT it will take a couple of weeks
for my ISP - don't ask ;)
So, if it would be (hopefully) fairly easy for a pro to make this hack working
on a PHP3 based server, this would be a perfect option for me.
If not - at least I asked :)
cu,
-Tom
SSJ4 Saiya-jin
Sat 9th Jun '01, 7:34pm
Hmm... Maby overgrow would take the time to edit it to function properly with PHP3. Is there any way possible for you to get your server to upgrade to php4?
Thomas P
Sat 9th Jun '01, 8:13pm
Yes, that would be gr8 :D
I already talked to my ISP and after some blabla he said okay, but it will take a couple of weeks since he didn't gave it prio 1 on his list (my impression)...
Zarkov
Sun 10th Jun '01, 5:22am
Ive updated the install_v2.txt file with the new hacks and included the new modlog.php file.
I dont have V1 so cant test or even play with the code, so if someone else can do the new instructions for V1 that would be cool.
Ill add the new Zip file here so people can still get overgrows original files if they want to.
Thomas P
Sun 10th Jun '01, 10:08am
awesome Zarkov,
Thanks a lot!
-Tom
Zarkov
Fri 15th Jun '01, 6:21am
dont use beta SW :)
Dakota
Fri 15th Jun '01, 3:43pm
umm could you please tell me how you got it working with ie6?
dxb
Thu 21st Jun '01, 6:34am
thanks zorkov and overgrew everything works like a charm for me except one thing which i hope one of you guys can solve it
any move of the super moderator dose show up
the admins are fine the moderators are fine only the super moderator
I hope somebody will help me with this
Joshs
Thu 21st Jun '01, 9:20am
Originally posted by Zarkov
Ive updated the install_v2.txt file with the new hacks and included the new modlog.php file.
I dont have V1 so cant test or even play with the code, so if someone else can do the new instructions for V1 that would be cool.
Ill add the new Zip file here so people can still get overgrows original files if they want to.
What was changed, and how do I upgrade? Do I just update the modlog.php file?
J_PC
Thu 21st Jun '01, 9:21am
now that is a cool hack thanks guys
Rogue
Thu 28th Jun '01, 5:40pm
Great hack! Works like a charm.
Is there a possibility to exclude admins from showing up in the logs?
xRugx
Sun 1st Jul '01, 3:12am
works fine
chilliboy
Mon 2nd Jul '01, 5:32am
Sorry - wrong thread
Zarkov
Sat 7th Jul '01, 9:05pm
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.
GB
Sun 8th Jul '01, 3:53pm
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?
J Wahl
Mon 9th Jul '01, 8:57pm
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.
Dakota
Tue 10th Jul '01, 4:15am
did you create the table in your database?
Edit: Oh yeah, I am having trouble with clearing the logs.
J Wahl
Tue 10th Jul '01, 4:20am
yes i did - but its all empty.
ShadowTech
Tue 10th Jul '01, 7:59pm
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.
debsync
Sat 21st Jul '01, 10:22pm
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)..
JoshFink
Sat 21st Jul '01, 11:13pm
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):
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('$threadinfo[open]','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$forumid','','".time()."')");
Replace with:
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('$threadinfo[open]','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$threadinfo[forumid]','','".time()."')");
Find (in the delete thread block):
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('2','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$forumid','','".time()."')");
Replace With:
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('2','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$threadinfo[forumid]','','".time()."')");
FIND (in the move thread block):
updateforumcount($threadinfo[forumid]);
Directly BELOW it ADD:
$movefrom=$threadinfo[forumid];
FIND (right below the last step):
updateforumcount($forumid);
Directly BELOW it ADD:
$moveto=$forumid;
FIND (Later on in the thread MOVE block):
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('3','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$curforumid','$movetoforumid','".time()."')");
Replace with:
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('3','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$movefrom','$moveto','".time()."')");
Josh
debsync
Sat 21st Jul '01, 11:39pm
hey!!! works perfect now!! thanx JoshFink!:)
JoshFink
Sun 22nd Jul '01, 12:37am
Glad to help.. This is actually the first PHP coding for vBulletin I've done.
Josh
GB
Mon 23rd Jul '01, 11:32pm
josh i edited my postings.php with what you put in your above post but my mod log still does not show where threads were deleted from and what forum threads are closed in
JoshFink
Tue 24th Jul '01, 3:38pm
GB, try it again and make sure the code is all correct.. Or , send me your file and I'll take a loot at it.
Josh
GB
Tue 24th Jul '01, 11:06pm
i got it josh...sorry to take up your time man
Dakota
Wed 25th Jul '01, 3:31pm
How would I make it so that you must be at least a moderator to access the log?
GB
Wed 25th Jul '01, 3:49pm
good idea dakota.....thats the only problem i see with this hack is that anyone who knows the URL to the mod log page can access it......
debsync
Wed 25th Jul '01, 6:23pm
I got around this problem by just making another directory inside the admin directory.. then I copied config.php, modlog.php, and db_mysql.php into it.. Now you can use htaxx to lock the modlog directory...
then once you lock the directory, you can save a bookmark to get to it.. like this: http://username:password@www.yoursite.com/board/admin/modlog/modlog.php
There a a few changes that needed to be made to modlog.php if you are going to use a separate directory for it.... On lines 197, 204, and 211 you will need to make a change to the echo statements to show the locations of forumdisplay.php and showthread.php
(ie so instead of using href=\"../showthread.php?etc" you would change it to href=\"/board/showthread.php?etc" or whatever your board's root dir is)
anyway that's how I did it... if anyone has a better way let me know ;)
UPDATE: I forgot.. you can make it so that only modlog.php is needed inside your modlog dir (and not config.php and db_mysql.php).. open up your modlog.php, and towards the begining of the file make these changes:
find:require("./config.php");
change to:require("../config.php");
Then find:$dbclassname="./db_$dbservertype.php";
change it to:$dbclassname="../db_$dbservertype.php";
*but those changes will only work if your modlog directory is a subdirectory of the admin directory*
Thomas P
Sat 28th Jul '01, 3:29am
Hi,
sorry for being late on this, but I just got PHP4 installed (slow provider... :( )
I installed the hack from Zarkov's additions, added JoshFink extras and it seems to work fine.
I noticed to things though:
1) The Moderator table is empty if I access modlog.php making this hack quite senseless on my site
2) I deleted a thread and it showed up under "Moved threads"
Checked postings.php
deletethread($threadid,0);
// modlog hack
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('2','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$threadinfo[forumid]','','".time()."')");
// /modlog hack
eval("standardredirect(\"".gettemplate("redirect_deletethread")."\",\"forumdisplay.php?s=$session[sessionhash]&forumid=$threadinfo[forumid]\");");
}
Seems correct to me (case 2 = delete)
And the modlog.php
case("2"):
$deleted[$log[timestamp]] = array("type"=>"2", "userid"=>"$log[userid]", "threadid"=>"$log[threadid]", "title"=>"$log[title]", "username"=>"$log[username]",
Funny, what did I do wrong?
Thanks in advance,
-Tom
Mark Hewitt
Sat 28th Jul '01, 11:01am
Is there going to be a new version of this released with all the fixes included?
dxb
Tue 31st Jul '01, 8:52pm
anybody can tell me how to apply this to VB 2.0.3 I mean with the new function split+move added to it
Thomas P
Wed 1st Aug '01, 12:43pm
does the rest work for you?
Can you see the moderators by username?
thx,
-Tom
dxb
Wed 1st Aug '01, 5:43pm
No it dose not work the moderator or the supermoderator name dose not show up only what ever the adminstrator name shows up
and
the new function split+move the moved thread title shows up but the source forum dose not show up
only the destination forum name which mean I wont know from where it's splited and moved
I thought this hack will be included in VB2.0.2 or VB2.0.3 but it seems like the pm status is more important than this .... I wonder are new features are added on demand base ??? :(
and now who can help us with this hack...:confused: ...:confused: ...:confused:
because I think it's one of the most important hacks ...:confused:
Me2Be
Wed 1st Aug '01, 7:46pm
Originally posted by dxb
I thought this hack will be included in VB2.0.2 or VB2.0.3 but it seems like the pm status is more important than this .... I wonder are new features are added on demand base ??? :(
because I think it's one of the most important hacks ...:confused: Well, to some people it obviously is more important than this hack. And there is a difference. The PM stats hack just utilizes the data already there. This modlog feature is obviously much more complex and requires more work than a simple statistics hack. We should really appreciate what we've been given :)
JoshFink
Wed 1st Aug '01, 10:54pm
Me2Be is absolutely right.
But... I will try and work on it tonight or tomorrow and see if I can get it fixed up for ya..
Josh
Thomas P
Thu 2nd Aug '01, 4:07am
Thanks Josh,
really appreciate your help on this,
-Tom
dxb
Thu 2nd Aug '01, 6:50am
I'm sorry Me2be but I was really disappointed when the hack didn't work because I had some big problems on my board because of one of the moderators and I don't wont to have that again
anyway thanks josh and I will be waiting for your fix :)
Itay
Thu 2nd Aug '01, 7:44am
It seems to have stopped logging for me after my upgrade to 2.0.3
Also - I was wondering if there is any way to add posts deletion to it as well, because that would make this hack perfect...
JoshFink
Thu 2nd Aug '01, 5:26pm
To Make Split + Move Show Properly (sort of)
Here is what I did.
The row under "Split Threads" will have :
ORIGINAL thread title, Mod, Forum From, Forum To and Date.
MODLOG.PHP
Find
case("6"):
$split[$log[timestamp]] = array("type"=>"6", "userid"=>"$log[userid]", "threadid"=>"$log[threadid]", "title"=>"$log[title]", "username"=>"$log[username]",
"fromforumid"=>"$log[fromforumid]", "threadtitle"=>"$log[threadtitle]", "userid"=>"$log[userid]", "toforumid"=>"$log[toforumid]");
break;
Change To :
case("6"):
$split[$log[timestamp]] = array("type"=>"6", "userid"=>"$log[userid]", "threadid"=>"$log[threadid]", "title"=>"$log[title]", "username"=>"$log[username]",
"toforumid"=>"$log[fromforumid]", "threadtitle"=>"$log[threadtitle]", "userid"=>"$log[userid]", "toforumid"=>"$log[fromforumid]");
break;
Find
if ($title=="Moved Threads")
echo "To";
Change to :
if (($title=="Moved Threads") OR ($title=="Split Threads")){
echo "</td><td class=\"label\">To";}
FIND
Find
[PHP]
case("3"):
echo "<span class=\"toplinks\">MOV: </span>";
break;
After That Add
case("6"):
echo "<span class=\"toplinks\">SPL: </span>";
break;
Now in POSTINGS.PHP
Find in ### start do split thread ###
// Move post info to new thread...
$posts=$DB_site->query("SELECT postid,attachmentid,userid FROM post WHERE threadid='$threadid'");
while ($post=$DB_site->fetch_array($posts)) {
if ($splitpost[$post[postid]]=="yes") {
$DB_site->query("UPDATE post SET threadid=$newthreadid WHERE postid=$post[postid]");
}
}
After That Add :
$splitto=$DB_site->query("SELECT forumid FROM thread where threadid='$threadid'");
list($split_to) = mysql_fetch_row($splitto);
Find
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('6','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$threadinfo[forumid]','','".time()."')");
Change to:
$DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('6','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$threadinfo[forumid]','$split_to','".time()."')");
I believe that is all I did.. I was in a rush, so I might have missed documenting something on here. I'm sure if I did, someone will point it out. :D
Unfortunately the thing I don't like is that I can't see what the thread name was that I moved it to. This is because there is not enough rows in the table. i.e. a Thread From and a Thread To.
It could be done, but you would have to create two rows for a Split + Move , one for the split and one for the move. I might try that.. We'll have to see.
JoshFink
Thu 2nd Aug '01, 5:35pm
Itay, I thought about showing deleted posts, but most of the time a user can delete their own post. Then it would wind up clogging up the logs and the logs would be unreadable IMHO.
Josh
dxb
Thu 2nd Aug '01, 7:17pm
thanks josh for this
and about the hack
now the moderator name is showing up
the supermoderator with custom title still not showing up
the main this
the moved threads
the source forum is not showing up only you can see the destination forum
the same thing with split+move only the destination forum is showing up
dxb
Thu 2nd Aug '01, 7:50pm
funny discovry solved the supermoderator problem hahahah
I noticed all the supermoderators the ones with custom titles had the Remember Username and password disabled
and the moment I enabled that feature there names started showing up :)
the only problem I have now is the source forum name in move and split+move function
JoshFink
Thu 2nd Aug '01, 8:54pm
That is definately strange.. Mine works fine.. Send me your postings.php and modlog.php file and I'll look at it.
Josh
jfink@mindspring.com
dxb
Sat 4th Aug '01, 3:23am
I've sent you an email thanks alot Josh :) :)
JoshFink
Tue 7th Aug '01, 10:03am
Did this work for everyone?
Josh
Thomas P
Tue 7th Aug '01, 2:39pm
Still didn't had time to look at it, but surely appreciate your help,
will have a (positive I hope) answer tomorrow or so,
Thanks for the moment!
-Tom
DarkReaper
Tue 7th Aug '01, 10:24pm
Everything on mine is blank except for the thread that was acted upon, and the date...Using vB 2.0.3. Could this be the problem?
Thomas P
Wed 8th Aug '01, 3:18pm
Hi,
I still have the same problem, doesn't see any user in the moderator field :(
Administrator is okay, but neither Moderators nor Super Moderators are shown - useless...
What's wrong here?
Thanks,
-Tom
JoshFink
Wed 8th Aug '01, 3:28pm
That is odd. I just went through the close/open, delete and move process with a moderator and it shows up on my modlog no problem.
What I might suggest is to get a clean version of the modlog and postings, then mod it using the different updates through the threads in here and try again.
One thing on the split+move update is the notice that the FROM is in the TO field ("toforumid"=>"$log[fromforumid]")
case("6"):
$split[$log[timestamp]] = array("type"=>"6", "userid"=>"$log[userid]", "threadid"=>"$log[threadid]", "title"=>"$log[title]", "username"=>"$log[username]",
"toforumid"=>"$log[fromforumid]", "threadtitle"=>"$log[threadtitle]", "userid"=>"$log[userid]", "toforumid"=>"$log[fromforumid]");
break;
Josh
JoshFink
Wed 8th Aug '01, 3:29pm
Dark Reaper, it has nothing to do with 2.0.3 as that is what I'm running fine.
Josh
Joshs
Mon 13th Aug '01, 1:04pm
When moving a thread it doesnt show where it was moved from and where it was moved to... I am running 2.0.3, and i dont think it was even working on earlier versions....
JoshFink
Mon 13th Aug '01, 1:24pm
You need to go back and look through the code updates.. It's all been fixed.. Well most of it.
Josh
snyx
Mon 13th Aug '01, 4:02pm
Back on page 3-4 you were talking about phpmyadmin, NEVER install myphpadmin! Arg, I got confused one day and mucked a bunch of stuff up with this script :D
But anyways, Im going to try this hack now, I will see what happens! :)
JoshFink
Mon 13th Aug '01, 4:06pm
I love PHPMyAdmin.. Works great for me..
Josh
Me2Be
Mon 13th Aug '01, 4:18pm
Originally posted by JoshFink
I love PHPMyAdmin.. Works great for me..
Me too!
Lordmusic
Mon 13th Aug '01, 6:46pm
PhPMyAdmin is the most useful script ever made. Don't knock it just because you don't know how to use it. That's what the manual link is for :)
snyx
Mon 13th Aug '01, 9:18pm
Im not knocking it, im telling the story about when I messed up and installed somthing weird, read my post befor making snap judgments on it. :rolleyes:
Goddess Washu
Thu 16th Aug '01, 11:37pm
Is there a "bug free" version out there, or do I have to go through all 10 pages... -_-;; Thanks for any help in advance, this seems to be a VERY nice hack, will come useful with my,not so responsible, staff... -_-;;;;;;;
inetd
Fri 17th Aug '01, 5:59am
I need last version (bug free) of this hack. Help me pls.
inetd
Sun 19th Aug '01, 8:25am
Reply me plz!
Thomas P
Sun 19th Aug '01, 2:09pm
Hi,
I emailed with Josh recently, he would be the right person to
do an intermediate release of the hack since he has in depth
knowledge of php.
So, lets give him some time, he may consider this (I dunno).
I hope Overgrow, Zarkov, Sisko and Norritt don't bother, but the hack really needs a re-release for 2.0.3...
cu,
-Tom
Deacon Frost
Mon 20th Aug '01, 3:46pm
Well, I made a ModLog Version which works great on vB 2.0.3. I will post soon, but, at the moment every text is in german:) So let mit Transalte it, and write a readme :)
Deacon Frost
Wed 22nd Aug '01, 12:23pm
Okay, I finished right in this minutes :) Hope, I translated everything right (*g*, you have a 50:50 chance :D)
Just post suggestions and bug reports in this thread, do not email me.
Using on your own risk :)
In attach, you'll find the install introductories, next post the file (in english), and in the post after the next post, you'll find the file in german.
Deacon Frost
Wed 22nd Aug '01, 12:24pm
The english file. Rename to "modlog.php"
Deacon Frost
Wed 22nd Aug '01, 12:25pm
the file in german. Rename to "modlog.php"
dxb
Wed 22nd Aug '01, 12:51pm
hey I was just going to write I will be waiting for your version ....and you already posted hahaha
Thanks alot Deacon
Thomas P
Wed 22nd Aug '01, 5:54pm
Thanks Deacon Frost,
I tried a fresh start and edited postings.php and index.php as described. Before that I dropped the modlog table and created it from scratch by copying the sql code into phpmyadmin (worked).
Copied modlog into /forum/admin directory and tried to have a look - works fine for the Administrator, but not for Moderators. :o
Everything seems fine, except that the "Moderator" row is blank.
When viewing the db I see that the userid = 0 there :( :(
I don't understand anymore: I tried it now a bunch of times, same error everytime.
Any hints on what can keep me getting always the same effect.
Code seems fine...
thx,
-Tom
Deacon Frost
Thu 23rd Aug '01, 2:23am
Hi Thomas, denke mit dir kann man deutsch sprechen:)
Probier mal in den $DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('$threadinfo[open]','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$threadinfo[forumid]','','".time()."')");
strings $bbuserid durch $bbuserinfo[userid] zu ersetzen. Bei mir funktioniert es mit beiden variabeln.
For everybody else who's this problem, try replacing $bbuserid with $bbuserinfo[userid] in the seven $DB_site->query("INSERT INTO modlog (type,userid,threadid,threadtitle,fromforumid,tofo rumid,timestamp)
VALUES ('$threadinfo[open]','$bbuserid','$threadid','".addslashes($threadinfo[title])."','$threadinfo[forumid]','','".time()."')"); string's (string above is just an example, there are 7 different strings, but they look similar)
Thomas P
Thu 23rd Aug '01, 3:12am
Hallo,
For everybody else who's this problem, try replacing $bbuserid with $bbuserinfo[userid] in the seven
That works!!
Very impressive and absolutely correct!
What a dumb little glitch :rolleyes:
Thanks for your help, finally after 11 pages the hack works for me, too... :D
Wondering why it works for everybody else, but for me the original way, whatever,
Thanks for helping,
-Tom
---
Yep, deutsch is gut! ;)
Danke, jetzt funzt's!
Meine Güte, so ein einfacher Fehler. Ist ja schon fast peinlich...
Haben die cracks hier auch übersehen - so ca. 11 Seiten lang.
Also: Respekt und tausend Dank! :)
-Tom
DoST
Thu 23rd Aug '01, 9:45am
Everything seems to be OK but I delete, open/close or move a thread but it doesn't show in the modlog. Is it because I'm the admin of the forum? What shall I do? I tried both of the versions (the original and Deacon Frost's)
Deacon Frost
Thu 23rd Aug '01, 11:46am
@ DoST: Watch my last post :)
I updated the install instructions, 'cause it seems like some boards are having problems with $bbuserid :D It doesn't matter that you are admin, all moderatoricaly activities will be logged.
@ Thomas P: *gg* Kein Problem. Musste mich fast zwangsläufig mit dem Script vertraut machen, da ich auf zwei grossen Boards das Teil unbedingt brauche :)
DoST
Thu 23rd Aug '01, 12:08pm
Thanks for the reply Deacon Frost. I did that change but the moderator activity still isn't recorded. I see that the modlog table is empty when I look at it with phpMyAdmin. But I'm not getting any errors. Any idea?
inetd
Sun 26th Aug '01, 3:22am
If the moderator will delete or will change the post, it will be mirrored in logs or not?
Deacon Frost
Sun 26th Aug '01, 11:09am
Change on Postings will not be logged, only changes on Threads.
@ DoST: Sorry, I have no idea what the matter is. BTW; Turkey is a great Country for Holidays :) (specially arround Öludeniz, Fethiey)
DarkReaper
Sun 26th Aug '01, 1:03pm
Yay! Great job on the new version, it works great and looks a whole lot better!
DoST
Sun 26th Aug '01, 2:38pm
Originally posted by Deacon Frost
Change on Postings will not be logged, only changes on Threads.
@ DoST: Sorry, I have no idea what the matter is. BTW; Turkey is a great Country for Holidays :) (specially arround Öludeniz, Fethiey)
I looked at it again and now it works perfect! Thanks a lot! BTW; I recommend you seeing also Bodrum, Marmaris and Antalya which are very near to each other and to Fethiye.
:)
Steve_C
Thu 20th Sep '01, 2:12am
Originally posted by Deacon Frost
The english file. Rename to "modlog.php"
I had to make a change in here from php4? to php? to get mine to work.
magistr
Sat 22nd Sep '01, 5:30am
yhis is cool hack
great man
tanx
it work with 2.0.3
but please edit links in admin/index.php
original:
Now, open admin/index.php
and search for this (or something like this):
________________________________________
<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">
<?php maketableheader("Stats & Logs"); ?>
</table>
<a href="stats.php?s=<?php echo $session[sessionhash]; ?>"> View Statistics </a><br>
<a href="adminlog.php?s=<?php echo $session[sessionhash]; ?>"> View Admin Logs </a>
</td></tr>
________________________________________
and replace it to
________________________________________
<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">
<?php maketableheader("Stats & Logs"); ?>
</table>
<a href="stats.php?s=<?php echo $session[sessionhash]; ?>"> View Statistics </a><br>
<a href="modlog.php4?showLimit=25"> View Moderator Logs </a><br>
<a href="adminlog.php?s=<?php echo $session[sessionhash]; ?>"> View Admin Logs </a>
</td></tr>
________________________________________
FINISH. Just upload "modlog.php" into /admin
Please DO NOT send any mails dependig on this script to me.
I will not answer. Using is on your own risk !
edit here:
<a href="modlog.php4?showLimit=25"> View Moderator Logs </a><br>
replace:
<a href="modlog.php?showLimit=25"> View Moderator Logs </a><br>
YourHostSucks
Fri 28th Sep '01, 11:33pm
I installed the hack.. but it is not working..
--
FILE UPDATED: May 21, 2001 6:50 am PST
--
was what I downloaded, it shows no moderator activity,
I hit refresh alot to! hehe -=/
Plus if I goto /adminmodlog.php , I do not have to enter my password to access this? wierd...
DarkReaper
Fri 28th Sep '01, 11:52pm
Make sure its in /forums/admin/ and not /forums/.
YourHostSucks
Sat 29th Sep '01, 6:32am
huh? .. o guess i made a typo in my post.. ;)
/adminmodlog.php = /admin/modlog.php
hehe
fxs158
Thu 11th Oct '01, 1:02am
Hi all,
I did this hack and it works great wit exeption of one feature. It seems that wheather i move delete or copy a topic as an admin. The mod hack reports it as a move. Any ideas how yo fix this? Also are there any hacks to monitor suspensions or banning?
YourHostSucks
Thu 11th Oct '01, 2:03am
Anyone have a answer to my problem? :)
It is not logging anything..
Thanks.
fxs158
Sun 14th Oct '01, 1:44pm
Up!
YourHostSucks
Sun 14th Oct '01, 2:12pm
Agreed.. .*bump* (lol)
Come on someone has to have a answer.. ;)
Thanks,
MW[MWGN]
Tue 23rd Oct '01, 10:17am
I am not sure if someone has done this already, but you can add a link to the Moderator Logs in the Control Panel :).
In /admin/index.php
Find:
<a href="stats.php?s=<?php echo $session[sessionhash]; ?>"> View Statistics </a><br>
Add before that:
<a href="modlog.php"> View Moderator Logs</a><br>
Done =)
Edit: Oh damn, I knew someone did it already =), sorry, I didn't have the time to read the whole thread, hehe.
Cyrus
Tue 23rd Oct '01, 10:34am
what browser do yo use overgrow ?? Is that your browser in the screen captures you put on the first page ?? Looks very neat indeed !!
DarkReaper
Tue 23rd Oct '01, 12:37pm
That's Opera (htp://www.opera.com) - The Fastest Browser on Earth :p
vBulletin® v3.8.0 Beta 1, Copyright ©2000-2008, Jelsoft Enterprises Ltd.