View Full Version : Miscellaneous Hacks - e-steki User ModLog v1.1.3 - An alternative to moderation AutoPM
Lea Verou
08-10-2007, 10:00 PM
A big thanks to everyone who nominated or voted this for MOTM September 2007!
e-steki User ModLog
What is this about?
This modification shows the user a table in his UserCP with the latest moderator actions that are performed in his posts/threads.
1. Why this and not Moderation Auto-PM (https://vborg.vbsupport.ru/showthread.php?t=115677)?
Its not intruding for the user. In fact, I decided to make this because the Moderation Auto-PMs I was receiving by tons were too annoying to bare.
Its not in the Modification Graveyard, so there is a much higher chance of updates and support ;-P
It allows more types of actions to show (unfortunately exept hard deletes).
Its more visually appealing ;-)
Users have to make more clicks to discuss an issue with the moderator, which makes it a little harder for them to protest ;-)
Most forums have some "moderation routines" that involve many moderator actions. Especially in this case MAP can be REALLY annoying.
You can select to hide the Moderator column, so no hatred will begin after the action as the user will not know who performed it.2. FeaturesAdmin Features
Absolutely NO template modifications and you even get to control where the table will be placed in the UserCP with a simple setting!
Ability to hide who the moderator that performed the action was.
Fully phrased.
Your moderators will not see their own actions, but the actions performed by other moderators on their posts/threads (customizable).
You get to control which action types will be shown and how many of them.
Ability to set a cutoff limit, so that actions that are performed before X days will not show.
Ability to specify which mod/admin usergroups' actions will display.
Displays actions from the moment you install it, even old ones, it doesn't display only the actions that are performed afterwards.
Supports e-steki Featured threads (https://vborg.vbsupport.ru/showthread.php?t=155299).
A nice, usable and extensive manual instead of an ugly readme.txt ;-)End user Features
Easy spotting of the action type by the nice colorful small icons (provided by famfamfam.com (http://www.famfamfam.com/). Thanks!)
Actions that were performed after the user's last visit will display in bold. Of course, they are sorted according to the date and time they were performed.
There is a link to the thread that the action is about. If the action is about a post, then the link takes the user to that specific post. There is also a link for the forum that contains that thread, in case the user does not remember what it is.
The table is collapsible, and if it has nothing to display it doesn't show, just like the other tables in the UserCP.
The username of the Moderator (if the admin has selected him to show) is formatted according to usergroup and links to his profile (so the member can send him a pm to talk about it, if he wishes to do so)
Full date and time displayed.Don't forget to Mark as Installed!
Support will be provided only for a few days after each release.
Thanks a lot to famfamfam.com for the icons and to SirAdrian for his answers to my questions.
As the admincp screenshot was resized by those stupid attachment limits that Paul M refuses to change, here is the original one:
http://www.e-steki.com/myfiles/Michelle/eum_admincp.gif
Lea Verou
08-11-2007, 08:26 PM
First post reserved.
Oooo..Oooo...2nd post..:p
Thanks for the hack, looks outstanding. I'll get it installed today and ditch the other one I'm using.
Jon_Simmonds
08-11-2007, 08:44 PM
Third post reserved :P
Looks good will give it a go on my test board :)
Lea Verou
08-11-2007, 08:46 PM
Tell me what happened please :)
(Btw I may not reply immediately, as I'm going to sleep shortly, its 1:00 AM here)
Zaiaku
08-11-2007, 08:55 PM
Looks interesting. I'll keep an eye on this for my new site.
Got it installed w/o any problems. I adjusted the settings in vboptions, went an moderated one of my own topics, checked the usercp but didn't see a listing of any sort. I did turn on that option in the main options. Also, checked to see if the hook was present and it was.
I check over things once more to be sure I did everything right.
Edit: Posted a new thread, close, stuck, soft deleted and nothing new in the usercp?
Lea Verou
08-11-2007, 09:01 PM
Have you got the setting "Show actions that the same user has performed?" to Yes? (default is no)
Otherwise your own actions will not show.
What moderation action did you perform?
Have you got the setting "Show actions that the same user has performed?" to Yes? (default is no)
Otherwise your own actions will not show.
What moderation action did you perform?
Yes, and I closed, pinned, soft deleted and finally hard deleted. Also, I have all those action id's put in the settings as well.
Lea Verou
08-11-2007, 09:13 PM
You are not supposed to put them there!
You put there only the ones you DON'T want to show! (I would be a sadist if the setting was the opposite way :p)
You are not supposed to put them there!
You put there only the ones you DON'T want to show!
DOH!!!
I went too fast...everything works fine! :D
Lea Verou
08-11-2007, 09:19 PM
DOH!!!
I went too fast...everything works fine! :D
:) :) :)
Finally, a mod I released with no bugs! :D
Now I can go sleep in peace :)
Lea Verou
08-11-2007, 09:20 PM
Why did you edit your post again? Is there any new problem?
edit: Phew, he re-edited :)
EnIgMa1234
08-11-2007, 10:18 PM
Nice job Michelle :D
FreshFroot
08-11-2007, 10:44 PM
pretty good hack Michelle, you have some nice new hacks out this week. Keep it up girl!!
johnrizz
08-11-2007, 10:48 PM
I have a dumb question as I hang my head in shame! Where can I find those action id's?
thanks...
I have a dumb question as I hang my head in shame! Where can I find those action id's?
thanks...
Look in the readme the hack came with....they're near the bottom. 1-31
Rickeo
08-11-2007, 11:55 PM
bloomin amazing loving this you have outdone yourself on this on thank you so much :D
NFLfbJunkie
08-12-2007, 01:32 AM
Very sweet addition to my forums. Great job.
NFLfbJunkie
08-12-2007, 01:46 AM
Action #18 "Post x by y removed" did not work for me. I removed a post on a test user account, and when I logged on as the test user, this action did not show up in the CP.
Konstantinos
08-12-2007, 01:52 AM
Action #18 "Post x by y removed" did not work for me. I removed a post on a test user account, and when I logged on as the test user, this action did not show up in the CP.
make sure u add the mod id in the settings of the hack
NFLfbJunkie
08-12-2007, 01:58 AM
I test Action #15 - "Thread removed", which is not listed in the "
Actions you do NOT want the user to be notified of" in the control panel, and it worked. So I don't think adding #18 fixes this.
make sure u add the mod id in the settings of the hack
No, you don't add anything. You only put in what actions you DON'T want to show. Same mistake I made.
BTW: Nominated for MOTM.
Lea Verou
08-12-2007, 05:25 AM
BTW: Nominated for MOTM.
Thank you so much!!!! :D
@Junkie: unfortunately it doesn't display hard deletes, only soft deletes, as I mentioned in the first post and the manual. This is caused due vBulletin's way of updating the moderator log (my hack fetches the actions from the moderator log filtered by the userid of the thread/post poster). This might be fixed in a future version, if I think of a way to do it.
Lea Verou
08-12-2007, 05:27 AM
I have a dumb question as I hang my head in shame! Where can I find those action id's?
thanks...
They are in the manual, in a pretty table :p
Note what JD45 said though, you should put there only the ones that you want to prevent from showing.
Perhaps in a future version I can make this setting more user friendly.
Gray Matter
08-12-2007, 05:50 AM
This hack is amazing! Uninstalled Moderation Auto-PM and installed this one, and it's working perfectly. ;)
Very quick install and so easy, too. :p
Wulfnoth
08-12-2007, 10:02 AM
There is no link in the usercp of my forum. maybe because i have customized the templates? can you please release the manual template-edits for this mod?
winduff
08-12-2007, 01:26 PM
looks great, but I receive an mySQL Error when accessing the UserCP!
Database error in vBulletin 3.6.7:
Invalid SQL:
SELECT
modlog.moderatorlogid as id,
modtable.username as moderator,
modtable.usergroupid as modgroup,
modlog.userid as modid,
modlog.action as action,
modlog.type as type,
modlog.dateline as dateline,
modlog.threadid as threadid,
modlog.postid as postid,
editlog.postid as editpostid,
forum.forumid as forumid,
thread.title as threadtitle,
forum.title as forumtitle,
deletionlog.reason as delreason,
editlog.reason as editreason
FROM moderatorlog AS modlog
LEFT JOIN user AS modtable ON (modtable.userid = modlog.userid)
LEFT JOIN thread AS thread ON (thread.threadid = modlog.threadid)
LEFT JOIN post AS post ON (post.postid = modlog.postid)
LEFT JOIN forum AS forum ON (IF(modlog.forumid,forum.forumid = modlog.forumid,forum.forumid = thread.forumid))
LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = IF(deletionlog.type = 'post', modlog.postid, modlog.threadid))
LEFT JOIN editlog AS editlog ON (IF(modlog.postid OR modlog.type!=20,editlog.postid = modlog.postid,editlog.dateline = modlog.dateline AND editlog.userid = modlog.userid))
WHERE
IF(modlog.postid>0,post.userid=1,thread.postuserid=1) AND modtable.userid != 1 AND modlog.type NOT IN (11,12)
ORDER BY modlog.dateline DESC
LIMIT 10;
MySQL Error : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error Number : 1104
Date : Sunday, August 12th 2007 @ 08:24:39 AM
Script : .../usercp.php
Referrer : .../index.php
IP Address : 82.113.106.16
Username : Chris
Classname : vb_database
Lea Verou
08-12-2007, 03:22 PM
There is no link in the usercp of my forum. maybe because i have customized the templates? can you please release the manual template-edits for this mod?
Probably. Tell me where you want it to appear and I'll tell you the template edit for it. Also ensure you are running vB 3.6.8.
looks great, but I receive an mySQL Error when accessing the UserCP!
This is a rather difficult issue. The product may be only adding one query, but that query is a rather heavy one. Your server either doesn't support such a large query, or you have a too large forum, so the limit is logical. I'm working on it, perhaps I'll make the product add 2 queries instead of one but much lighter ones. Keep your eyes open for an update (probably it will be released soon), and for the time being, disable the product.
Lea Verou
08-12-2007, 04:01 PM
Version 1.1
----------------
Added option for specifying a days limit for the display of actions.
You are strongly advised to upgrade, as this option makes the query much lighter for the server.
winduff try this version, and set the day limit to a relatively low number (equal or less to 30). Tell me if your problem was solved.
Wulfnoth
08-12-2007, 04:50 PM
Probably. Tell me where you want it to appear and I'll tell you the template edit for it. Also ensure you are running vB 3.6.8.
I want the link appear above the PM-section.
johnrizz
08-12-2007, 05:41 PM
Look in the readme the hack came with....they're near the bottom. 1-31
(DUH) my bad! lol....:D
AzzidReign
08-12-2007, 06:13 PM
Awesome mod!!!!! I love it!
Axel Foley
08-12-2007, 06:43 PM
Lea,
this is a really good hack...thank you for your work...:)
The only thing I can tell you is that the "edit post" action (#20) is not working for me.
I have emptied the relevant field in the options in order to log EVERY action. ;)
Have you tested all the actions?
Thanks again...hack of the month for me...;)
Lea Verou
08-12-2007, 06:50 PM
I discovered a bug with action #20, about an hour ago. It notifies the thread starter instead of the post poster.
Unfortunately, this means that I'll have to rewrite a great portion of the code, due to vB's crappy moderator logging on post edits :mad: (In fact I reported that as a bug to vbulletin.com, it does not store the postid in the moderatorlog on post edit).
I thought I had got over that bug in my code, but it seems I've missed something.
So, I'm currently rewritting the queries in order to overcome that problem.
Support will be temporarily not provided, so that I can focus on fixing the problem.
You'll have to wait a little bit.
I expect to release a fixed version later today or tomorrow at most.
Sorry and thanks for your patience and kind words :)
PS: Of course all the other actions are working fine, the problem is with post edits (action 20)
MrZeropage
08-12-2007, 07:47 PM
very nice and useful, thanks :)
COBRAws
08-12-2007, 07:59 PM
More screens please?
How does a user start a conversation with the staff member who moderated his/her post?
NFLfbJunkie
08-12-2007, 09:46 PM
After installing is there supposed to be a link to show the actions from within the USERCP, or do actions only show when they have been made? I don't see a link anywhere in my USERCP.
Lea Verou
08-12-2007, 10:00 PM
@COBRAws:
There is nothing else in the hack that can be displayed in a screenshot.
As for the conversation, he can go to his/her profile (if the moderator column is selected to be displayed) and start a PM one, the old fashioned way. :p
@Junkie:The table shows only if there are any actions for it to show, and it shows in the usercp home. Ensure there is something for it to show.
winduff
08-12-2007, 10:18 PM
Hey Michelle,
cheers for updating so fast. Unfortunatly, I still get the same error. I guess my server doesn't support such a large query - I even set it down to 5 days max, no positive results...
I'll wait and see, maybe you'll come up with something :)
Cheers
Lea Verou
08-13-2007, 09:04 AM
Version 1.1.1
------------------
Fixed the action 20 (edit post) bug
Also the manual now contains instructions for manual addition of the template hooks if you don't have them and a simple tutorial for changing the icons associated with each action type.
@Wulfnoth: The template edits that you requested are now included in the manual ;)
@winduff: Try this one, now the queries are two (one if you exclude action 20 from showing) but much lighter ones. If it doesn't work, answer the following (if its private info for you, answer in a pm):
1. How big is your forum? (users, posts, threads)
2. Are you on a shared server?
3. If you know how to navigate through phpmyadmin, how large is the moderatorlog table and the deletionlog table?
Wulfnoth
08-13-2007, 10:18 AM
@Wulfnoth: The template edits that you requested are now included in the manual ;)
Thanks!
Lea Verou
08-13-2007, 11:07 AM
Version 1.1.2
---------------------
Added setting to specify which mod/admin usergroups' actions will display
winduff
08-13-2007, 12:39 PM
Michelle, your a genious!
All works fine, great mod ;) Thanks again so much!
Lea Verou
08-13-2007, 01:03 PM
Thank you winduff :)
I'm glad it finally works for you. :)
A note to non-coders: Don't pay so much attention to the number of queries that a hack adds, but rather the type of them. I tried so hard to make this add only one query initially, and it turned out to be such a heavy one that it couldn't even be executed in winduff's installation! Now that there are 2 queries (if you want to display post edits, otherwise its still one) they are much lighter together than the previous one alone. ;)
Axel Foley
08-13-2007, 04:18 PM
Good job Lea...;)
While doing the tests I could "feel" the difference between this version and the old one...it's faster...you made a good job on the queries.
I would also suggest you to add an option: Show empty modlog table? (default: No)
I think this one deserves the nomination...;)
Lea Verou
08-13-2007, 04:21 PM
Good job Lea...;)
While doing the tests I could "feel" the difference between this version and the old one...it's faster...you made a good job on the queries.
I would also suggest you to add an option: Show empty modlog table? (default: No)
I think this one deserves the nomination...;)
Tell me one reason why someone would want to set that option to yes and I'll add it ;)
Thanks so much for the nomination!!! https://vborg.vbsupport.ru/https://vborg.vbsupport.ru/
Gray Matter
08-13-2007, 05:00 PM
Wow, I didn't even realize how heavy the old version was until I updated to the new one. It cut my page load from 4.71432 seconds to 0.46639 seconds. :eek:
Lea Verou
08-13-2007, 05:06 PM
Yeah, version 1.0 was quite heavy.
This could be a lesson to some that the number of queries that a hack adds by itself doesn't always reflect how heavy the hack is. In this case, as was proven, 2 queries were far better than one. ;)
Essam
08-13-2007, 08:18 PM
its working great for my forum thank you
can you make the same idea for ( reported posts ) ?
only moderators forum can view the complaints in the usercp
johnrizz
08-13-2007, 08:24 PM
That was quick and It works great! keep up the good work.....
MrZeropage
08-14-2007, 04:56 AM
good work on the update *thumbs up*
btw you should update your signature to v1.1.2 too ;)
cynthetiq
08-14-2007, 06:52 AM
It's late I thought I'd get one more mod in before bed, and I picked yours because Karma is so awesome. I think this looks awesome too.
For some reason, this isn't showing up in the CP.
I am now using the enlighten template and also did the GTUserCP - Enhanced USERCP Interface + USERCP Menu mod as well if that makes differences.
your FAQ is quite thorough, so I looked at the ""$template_hook[usercp_main_pos1]" (or pos2-6, depending on which position you have selected)" and I see that I'm already using all of them.
$template_hook[usercp_main_pos1]
<if condition="$show['privatemessages']">
<!-- ############## PRIVATE MESSAGES ############## -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<thead>
<tr>
<td class="tcat" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('usercp_pms')"><img id="collapseimg_usercp_pms" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_usercp_pms].gif" alt="" border="0" /></a>
<a href="private.php$session[sessionurl_q]">$vbphrase[new_private_messages]</a><span class="normal">: ($numpms)</span>
</td>
</tr>
</thead>
<tbody id="collapseobj_usercp_pms" style="$vbcollapse[collapseobj_usercp_pms]">
$messagelistbits
</tbody>
</table>
<br />
<!-- ############## END PRIVATE MESSAGES ############## -->
</if>
$template_hook[usercp_main_pos2]
<!-- ############## SUBSCRIBED THREADS ############## -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<thead>
<tr>
<td class="tcat" colspan="$subscribedthreadscolspan">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('usercp_subthreads')"><img id="collapseimg_usercp_subthreads" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_usercp_subthreads].gif" alt="" border="0" /></a>
$vbphrase[new_subscribed_threads]<span class="normal">: ($numthreads)</span>
</td>
</tr>
</thead>
<tbody id="collapseobj_usercp_subthreads" style="$vbcollapse[collapseobj_usercp_subthreads]">
<if condition="$show['threads']">
<tr class="thead">
<if condition="$show['threadicons']">
<td class="thead" colspan="2"> </td>
<else />
<td class="thead"> </td>
</if>
<td class="thead" width="100%">$vbphrase[thread] / $vbphrase[thread_starter]</td>
<td class="thead" width="150" align="center" nowrap="nowrap">$vbphrase[last_post]</td>
<td class="thead" align="center">$vbphrase[replies]</td>
<td class="thead" align="center">$vbphrase[views]</td>
</tr>
$threadbits
<else />
<tr>
<td class="alt1" align="center" colspan="$subscribedthreadscolspan"><strong>$vbphrase[no_subscribed_threads_to_display]</strong></td>
</tr>
</if>
<tr>
<td align="$stylevar[right]" colspan="$subscribedthreadscolspan" class="tfoot">
<span class="smallfont"><a href="subscription.php?$session[sessionurl]do=viewsubscription&folderid=all">$vbphrase[view_all_subscribed_threads]</a></span>
</td>
</tr>
</tbody>
</table>
<br />
<!-- ############## END SUBSCRIBED THREADS ############## -->
$template_hook[usercp_main_pos3]
<if condition="$show['forums']">
<!-- ############## SUBSCRIBED FORUMS ############## -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<thead>
<tr>
<td class="tcat" colspan="<if condition="$vboptions['showmoderatorcolumn']">6<else />5</if>">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('usercp_forums')"><img id="collapseimg_usercp_forums" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_usercp_forums].gif" alt="" border="0" /></a>
$vbphrase[subscribed_forums]
</td>
</tr>
</thead>
<tbody id="collapseobj_usercp_forums" style="$vbcollapse[collapseobj_usercp_forums]">
<tr align="center" valign="bottom">
<td class="thead" width="2%"> </td>
<td class="thead" align="$stylevar[left]" width="80%">$vbphrase[forum]</td>
<td class="thead">$vbphrase[last_post]</td>
<td class="thead">$vbphrase[threads]</td>
<td class="thead">$vbphrase[posts]</td>
<if condition="$vboptions['showmoderatorcolumn']">
<td class="thead" width="20%">$vbphrase[moderator]</td>
</if>
</tr>
$forumbits
</tbody>
</table>
<br />
<!-- ############## END SUBSCRIBED FORUMS ############## -->
</if>
$template_hook[usercp_main_pos4]
<if condition="$show['infractions']">
<!-- ############## NEW INFRACTIONS ############## -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<thead>
<tr>
<td class="tcat" colspan="7">
<span class="smallfont" style="float:$stylevar[right]">
<phrase 1="$bbuserinfo[ipoints]">$vbphrase[x_points_total]</phrase>
<a href="#top" onclick="return toggle_collapse('usercp_infraction')"><img id="collapseimg_usercp_infraction" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_usercp_infraction].gif" alt="" border="0" /></a>
</span>
$vbphrase[latest_infractions_received]
</td>
</tr>
</thead>
<tbody id="collapseobj_usercp_infraction" style="$vbcollapse[collapseobj_usercp_infraction]">
<tr>
<td class="thead"> </td>
<td class="thead">$vbphrase[post]</td>
<td class="thead">$vbphrase[date]</td>
<td class="thead">$vbphrase[expires]</td>
<td class="thead" nowrap="nowrap">$vbphrase[points]</td>
<td class="thead">$vbphrase[reason]</td>
<td class="thead" nowrap="nowrap">$vbphrase[posted_by]</td>
</tr>
$infractionbits
</tbody>
</table>
<br />
<!-- ############## END NEW INFRACTIONS ############## -->
</if>
$template_hook[usercp_main_pos5]
<if condition="$show['reputation']">
<!-- ############## NEW REPUTATION ############## -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<thead>
<tr>
<td class="tcat" colspan="$reputationcolspan">
<span class="smallfont" style="float:$stylevar[right]">
<phrase 1="$bbuserinfo[reputation]">$vbphrase[x_points_total]</phrase>
<a href="#top" onclick="return toggle_collapse('usercp_reputation')"><img id="collapseimg_usercp_reputation" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_usercp_reputation].gif" alt="" border="0" /></a>
</span>
$vbphrase[latest_reputation_received]
</td>
</tr>
</thead>
<tbody id="collapseobj_usercp_reputation" style="$vbcollapse[collapseobj_usercp_reputation]">
<tr>
<td class="thead"> </td>
<td class="thead">$vbphrase[thread]</td>
<td class="thead">$vbphrase[date]</td>
<if condition="$vboptions['showuserraters']">
<td class="thead" nowrap="nowrap">$vbphrase[posted_by]</td>
</if>
<td class="thead">$vbphrase[comment]</td>
</tr>
$reputationcommentbits
</tbody>
</table>
<br />
<!-- ############## END NEW REPUTATION ############## -->
</if>
$template_hook[usercp_main_pos6]
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
<td width="100%"> </td>
<td align="$stylevar[right]">$forumjump</td>
</tr>
</table>
FReeSTER
08-14-2007, 07:25 AM
Thank you Michelle. Works great with vb version 3.6.5 :)
**INSTALLED**
Lea Verou
08-14-2007, 08:05 AM
its working great for my forum thank you
can you make the same idea for ( reported posts ) ?
only moderators forum can view the complaints in the usercp
I didn't understand, can you explain your idea in more detail? :)
It's late I thought I'd get one more mod in before bed, and I picked yours because Karma is so awesome. I think this looks awesome too.
For some reason, this isn't showing up in the CP.
I am now using the enlighten template and also did the GTUserCP - Enhanced USERCP Interface + USERCP Menu mod as well if that makes differences.
your FAQ is quite thorough, so I looked at the ""$template_hook[usercp_main_pos1]" (or pos2-6, depending on which position you have selected)" and I see that I'm already using all of them.
Firstly ensure that there is something to be shown. Eg make a moderator of yours perform an edit on one of your posts, or turn the option "Show self actions" to yes and perform a moderating action on your posts yourself.
If none of this work, post a screenshot of your settings.
good work on the update *thumbs up*
btw you should update your signature to v1.1.2 too ;)
LOL thanks, I'm so forgetful all the time :o
Thanks to everyone else who installed or nominated as well :) :)
Axel Foley
08-14-2007, 09:10 AM
Tell me one reason why someone would want to set that option to yes and I'll add it ;)
Thanks so much for the nomination!!! https://vborg.vbsupport.ru/https://vborg.vbsupport.ru/
Because there are people like me who don't like dynamic sections on a page appearing. I like the structure of a page being always the same and the data to be dynamic, don't like a table appearing only when there's data...:)
It would also solve you lots of problems telling users of this hack that can't see the table to make sure there's data...if they enable the option to always display the table even with empty data and the table in usercp doesn't come up, the problem is in the template part, not the data collection part of the hack...useful for debugging...:)
I gave you 2 reasons...please provide us this other option...:)
Ciao!
Lea Verou
08-14-2007, 09:14 AM
Lol ok, you convinced me :D
I'll add it today ;)
cynthetiq
08-14-2007, 11:09 AM
Firstly ensure that there is something to be shown. Eg make a moderator of yours perform an edit on one of your posts, or turn the option "Show self actions" to yes and perform a moderating action on your posts yourself.
If none of this work, post a screenshot of your settings.
I dunno if it was because I was sleepy or what but it works as expected.
I was looking for it to appear as a menu option the left side as a selection and then a popup window.
Of course as I made more actions, it grew and I could see it plain as day.
Lesson: I shouldn't add mods and look at code when I'm sleepy.
Thanks this is AWESOME!
Lea Verou
08-14-2007, 11:22 AM
Its normal to be confused, as a 700x700 attachment limit doesn't allow much detail in the screenshots :mad:
Thanks cynthetiq :)
cynthetiq
08-14-2007, 12:26 PM
question: I moderated a thread by closing the thread. I then moved the thread to a moderators only forum.
The mod actions then are no longer visible as you described. Is there a simple way to at least show up to the point that the thread was moved to the moderators forum, and that's where the trail ends? Or is that impossible?
This way users will see that the thread was moved, otherwise, once it is moved to a moderator forum there is no way for them to see that it got moved there anylonger.
Am I making sense or am I still sleepy?
Lea Verou
08-14-2007, 01:00 PM
I didn't understand a thing :o
cynthetiq
08-14-2007, 01:25 PM
HAHAHAHa.... me either
okay if I have a forum that is restricted to registered users, the thread is moved to the restricted forum, the log is emptied since the query no longer allows the member to see the log for the thread.
is it possible to allow it to see the moderation until the move point in the arrow?
the edits I made in the Authorized Personnel Only Forum. then moved it back, once i moved it back I could see all modlog.
I was wondering if it was possible to see just up to the arrow.
Lea Verou
08-14-2007, 01:29 PM
I'll try to think of a way, but not now, later.
For the time being, you can select not to apply forum permissions if you wish.
Hi,
nice Hack :D
Thx.
But one Question:
Why the TMS system (http://https://vborg.vbsupport.ru/showthread.php?t=152931) is used by Andreas so rarely or not by the Codern. It brings nevertheless only advantages with installing, since the Template changes is omitted
Sorry for Translation, its from Babelfish :D
Lea Verou
08-14-2007, 06:40 PM
Hi,
nice Hack :D
Thx.
But one Question:
Why the TMS system (http://https://vborg.vbsupport.ru/showthread.php?t=152931) is used by Andreas so rarely or not by the Codern. It brings nevertheless only advantages with installing, since the Template changes is omitted
Sorry for Translation, its from Babelfish :D
Dunno, I prefer to write my own plugins for that in order to have more control over it, although from what I've seen I appreciate TMS a lot.
This hack does not require any manual template changes, so why are you asking this in this particular thread?
Hi,
Any Question:
I Edit a Thread from a Moderator, but he not become a Log of this Action.
To the TMS, which was one generally asks, which should not attack you . Separate it went around all Coder. You have also some Hacks, where one must change Templates, which degree is with updates vB depending upon number of installed Hacks much time-consuming.
Lea Verou
08-14-2007, 08:13 PM
If you edited his thread, he will see the action in his usercp, not you. ;)
I know I have some hacks that one should change templates, but not my new ones.
I just don't have time to update the old ones.
Btw I was not attacking you, just asking.
Hi,
that i see this not in Modlog is OK, but he don?t see it.
Only Users see a Log in his CP.
The Usergroup is correct in ACP Only 3 Groups are in the field.
5,6,80 (Supermods,Admins,Mods)
on my CP i see a log of all mod actions. but no oone of my mods/SM see anyone in here cp
Admin
68477
Mod with postings/threads how edited by me.
68478
User
68479
Lea Verou
08-14-2007, 09:20 PM
Can I have a screenshot of your settings?
Btw the usergroupid of mods is usually 7, not 80.
@Axel Foley, sorry, I didn't find the time to add the setting today, so you 'll have to wait at least till tomorrow :o
Axel Foley
08-14-2007, 09:33 PM
Can I have a screenshot of your settings?
Btw the usergroupid of mods is usually 7, not 80.
@Axel Foley, sorry, I didn't find the time to add the setting today, so you 'll have to wait at least till tomorrow :o
Lea, don't worry and take all the time you want, it's August and I'm in vacation so I'm very relaxed in this period...:D
Thank you again for adding my requested option. :)
Hi Michelle,
my Modgroupid is 80
If i had Vb 2.x we delete the original group, and make a new one.
this is now the 80
68482
70th post reserved..
NVM I Had to do that lol xD, GREAT mod, thanks michelle *clicks install*
Lea Verou
08-15-2007, 08:00 AM
Hi Michelle,
my Modgroupid is 80
If i had Vb 2.x we delete the original group, and make a new one.
this is now the 80
68482
Does this happen with all your mods?
Also, do these moderation actions appear normally in the moderator log (vBulletin's one) ?
Hello Michelle,
Yes, it´s by all my Mod´s.
the Log in the ACP is correct.
Threads/Post from a Mod, editing by another Mod oder admin where not displayed by the Mod who write the Post/thread.
Lea Verou
08-15-2007, 01:07 PM
Threads/Post from a Mod, editing by another Mod oder admin where not displayed by the Mod who write the Post/thread.
I didn't understand that.
Write it in german, I'll have my boyfriend translate it ;)
Hi,
ok in German.
Wenn ein Mod einen Beitrag schreibt und dieser von einem Admin oder Mod bearbeitet wird, erscheint er nicht im Modlog von dem Beitragsersteller.
Bei den Moderatoren ist kein Modlog zu sehen, wenn ihre Beitr?ge bearbeitet werden.
Die Logfiles aus dem ACP/Modlog sind hingegen da.
Thanks :D
Lea Verou
08-15-2007, 01:54 PM
Version 1.1.3
--------------------
-Added support for e-steki Featured threads (https://vborg.vbsupport.ru/showthread.php?t=155299)
-Fixed a bug with the number of the actions showed (it was greater than the one specified)
-Added option to show/hide the table when it has nothing to display (requested)
-Fixed bug: Link to forum did not work due to a typo.
Lea Verou
08-15-2007, 02:06 PM
Hi,
ok in German.
Wenn ein Mod einen Beitrag schreibt und dieser von einem Admin oder Mod bearbeitet wird, erscheint er nicht im Modlog von dem Beitragsersteller.
Bei den Moderatoren ist kein Modlog zu sehen, wenn ihre Beitr?ge bearbeitet werden.
Die Logfiles aus dem ACP/Modlog sind hingegen da.
Thanks :D
Hmm that's weird. If a mod becomes a user then he sees them normally again? If a user becomes a mod he stops seeing them?
If possible, try that with a test account and tell me what happened.
Hi,
so i installed the actually Version.
But the Same.
If a Posting or Thread from a Moderator, edit by Admin or Mod, the Moderator who write the Post/thread became no Log over this Action.
But new Problem,
i edit one of my Threads, but this Action are not displayed too.
Lea Verou
08-17-2007, 01:41 PM
Notice:
If for a usergroup, the "Show edited by note on edited messages?" setting is set to No, then the edits that this usergroup performs (given that its a moderator/admin usergroup) will not show in the User ModLog unless a reason is provided for the edit.
The reason that this behavior occurs is that vBulletin, in that case, does not store the edits in the editlog table unless they have a reason. My hack reads the post edits from the editlog table (because the moderatorlog table doesn't provide enough info in this case - which is a vB bug I reported and will be fixed in 3.6.9).
This is what caused MrD's problem.
Freki
08-23-2007, 06:34 PM
vB Version: 3.6.8
Looks very nice.:up:
Is it also possible to run it under 3.6.7?
Lea Verou
08-23-2007, 06:41 PM
Probably yes. You may have to add the template hooks manually though (there are instructions in the Manual for this).
Freki
08-23-2007, 06:43 PM
Oh yes, now I see. Works great!:)
Installed.
Hi,
thx to Michelle for the great Live Support :d
chatzworld
08-24-2007, 10:59 AM
hi, I am having problems with the right cods for the actions, by default it had 11,12 in it and it seems to only show closed threads in the list, I want it to show: Closed, Moved, Edited
Thanks
EDIT: Have managed to get this fixed my self :)
Ausaudriel
08-25-2007, 11:19 AM
I just gotta say, this is an excellent hack. It's by far one of the most useful I've ever used, you did a wonderful job with it.
eNforce
08-25-2007, 03:13 PM
This is indeed a great alternative to Mod Auto-PM and I like it much better, therefore installed!
I have a problem though, $template_hook[usercp_main_pos1] at the top of the template does nothing, but if I put $template_hook[usercp_main_pos6] at the very top it does.
No big problem as it does work this way... is there anything wrong with doing that?
Lea Verou
08-25-2007, 08:33 PM
hi, I am having problems with the right cods for the actions, by default it had 11,12 in it and it seems to only show closed threads in the list, I want it to show: Closed, Moved, Edited
Thanks
EDIT: Have managed to get this fixed my self :)
Phew, one less support issue :D
I just gotta say, this is an excellent hack. It's by far one of the most useful I've ever used, you did a wonderful job with it.
Thanks! :D
This is indeed a great alternative to Mod Auto-PM and I like it much better, therefore installed!
I have a problem though, $template_hook[usercp_main_pos1] at the top of the template does nothing, but if I put $template_hook[usercp_main_pos6] at the very top it does.
No big problem as it does work this way... is there anything wrong with doing that?
I am not sure I understood correctly.
What have you set for its position in the hack's settings? It chooses the template hook according to that setting.
under_takers
09-01-2007, 05:45 AM
this is really nice release, am gonna vote for this in MOTM :D
Lea Verou
09-01-2007, 07:16 AM
this is really nice release, am gonna vote for this in MOTM :D
Thanks!!!!!!!!!! https://vborg.vbsupport.ru/
Black Tiger
09-04-2007, 12:17 AM
Very nice hack. however I wait installing until there is a possibility to notify users about hard-deleted posts.
But compliments on this one, very nice!
Lea Verou
09-04-2007, 08:04 AM
Thanks, but unless vB changes the moderation log code, its quite impossible to inform users about hard deleted posts.
-------------
Btw guys, this hack has been in the MOTM poll for September, so if you like it, you can go vote for it here (https://vborg.vbsupport.ru/showthread.php?t=156761):) Thanks in advance. :)
COBRAws
09-10-2007, 06:57 AM
Congrats on the MOTM nomination, I gave my 2cents hehe
aiight, sorry to bring this subject back to discussion, but it would be really great if there was a new column called "Discuss Action" or "Contact Moderator" or something like that so if the user has any problems or doubts about the moderation task, with one simple click they could send a PM with the general details at User Modlog table and the option to add some comment as in a textarea form.
How many votes do I need for this wish to become real? lol
Thanks Michelle, really good MOD ;)
Lea Verou
09-10-2007, 08:20 AM
Congrats on the MOTM nomination, I gave my 2cents hehe
aiight, sorry to bring this subject back to discussion, but it would be really great if there was a new column called "Discuss Action" or "Contact Moderator" or something like that so if the user has any problems or doubts about the moderation task, with one simple click they could send a PM with the general details at User Modlog table and the option to add some comment as in a textarea form.
How many votes do I need for this wish to become real? lol
Thanks Michelle, really good MOD ;)
Lol good idea in theory, but in reality it would be sooo annoying. I remember when we had moderation auto-pm: So many members responded complaining about the move/lock/edit etc :(
Thanks a lot for the vote! (although I'm losing :(:(:( )
Delphiprogrammi
09-18-2007, 11:04 AM
hook template_groups
$only['eum_'] = 'your title here';
this will group templates
Lea Verou
09-18-2007, 11:08 AM
hook template_groups
$only['eum_'] = 'your title here';
this will group templates
Thanks! And I was wondering about template groups!
Snatch
09-20-2007, 07:26 AM
Is it possible to show the Modlog from another users?
If I delet a Thread from user X I would see this in his log. So i can after x day see what i done with this user.
Masiello
09-30-2007, 09:31 PM
Great Hack Michelle, I'm using Moderated Forum, I hope you keep this up for a future vBulletin releases.
Also, please do it possible to inform users about hard deleted posts.
Waiting a new release for the final installation ;)
*INSTALLED*
Lea Verou
09-30-2007, 09:52 PM
Great Hack Michelle, I'm using Moderated Forum, I hope you keep this up for a future vBulletin releases.
Also, please do it possible to inform users about hard deleted posts.
Waiting a new release for the final installation ;)
*INSTALLED*
Ι think that it already does inform users for hard deleted posts, if you provide a deletion reason.
Perhaps somebody else can confirm this.
PS: If you liked this mod, you can vote it for MOTM, although it will not win. The poll closes in a few hours. :)
shipfriends
10-03-2007, 07:16 AM
Polu kalo! Well done! I needed this one!
panta tetoia ;)
Lea Verou
10-03-2007, 07:22 AM
Polu kalo! Well done! I needed this one!
panta tetoia ;)
na sai kala ;)
shipfriends
10-08-2007, 06:24 AM
found a potetnial "flaw"
a reported post which goes automatically in my private reporting section/fora if edited on the title or anywhere else, it shows on this...which is not ideal.
Is there anyway to eliminate this?
Lea Verou
10-08-2007, 06:49 AM
found a potetnial "flaw"
a reported post which goes automatically in my private reporting section/fora if edited on the title or anywhere else, it shows on this...which is not ideal.
Is there anyway to eliminate this?
Have you enabled the "apply forum permissions" setting?
shipfriends
10-08-2007, 08:51 AM
yes I had.
when a post is reported, a post is appearing inside the mods forum (restricted)
When we were changing the title of this post and where the post was placed, this info was shown on the simple user panel.
Snake
11-16-2007, 11:06 AM
Thanks! Will install soon...
pipin
01-26-2008, 08:44 AM
Does this hack work with vB 3.7 ?
redlabour
01-29-2008, 04:50 PM
Does this hack work with vB 3.7 ?
Same Question from me ....
Za4a Tuner
02-17-2008, 07:10 AM
downloaded -> tested => CLICK INSTALL
Many thanks for this add-on -> i love it!
The only thing i don't like is a little stylingerror.
If there are no mod-actions to show, but the notifcation is shown,
the background is not defined and the text is only in the first col =>
http://img151.imageshack.us/img151/4317/estickyorios8.th.jpg (http://img151.imageshack.us/my.php?image=estickyorios8.jpg&s=1)
i fixed this, see the screenshot =>
http://img151.imageshack.us/img151/9095/estickyfixedzg4.th.jpg (http://img151.imageshack.us/my.php?image=estickyfixedzg4.jpg&s=1)
If anyone else want to to this, search for
<td>$vbphrase[eum_noactions]</td>
and replace it by
<if condition="$vboptions[eum_showmod]">
<td class="alt1" colspan="5">$vbphrase[eum_noactions]</td>
<else />
<td class="alt1" colspan="4">$vbphrase[eum_noactions]</td>
</if>with this little modifikation the text is displayed over the whole row and the background-color is set to "First Alternating Color" (alt1)
kr Chris
Fire112
02-18-2008, 09:40 AM
Must one change there templates? Has installed tms
Za4a Tuner
02-18-2008, 03:58 PM
no, the MOD uses Plug-Ins / templatehooks.
But you have ti use vB3.6.8 ... either the hooks will not be found.
Boothby
02-25-2008, 08:49 PM
maxXximum (http://www.vbulletin-germany.org/member.php?u=196) from vBGo reported this SQL-error-message (http://www.vbulletin-germany.org/showpost.php?p=12934&postcount=5).Database error in vBulletin 3.7.0 Beta 5:
Invalid SQL:
SELECT
modtable.usergroupid as modgroup,
modtable.username as moderator,
editlog.postid as postid,
editlog.reason as reason,
editlog.dateline as dateline,
editlog.userid as modid,
post.threadid as threadid,
forum.forumid as forumid,
thread.title as threadtitle,
forum.title as forumtitle,
post.title as action
FROM vb7editlog as editlog
LEFT JOIN vb7post as post ON (post.postid = editlog.postid)
LEFT JOIN vb7thread AS thread ON (thread.threadid = post.threadid)
LEFT JOIN vb7user AS modtable ON (modtable.userid = editlog.userid)
LEFT JOIN vb7forum AS forum ON (forum.forumid = thread.forumid)
WHERE
post.userid = 3 AND post.userid != editlog.userid AND 1203889380-editlog.dateline <86400 AND modtable.usergroupid IN ()
ORDER BY editlog.dateline DESC
LIMIT 10;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ORDER BY editlog.dateline DESC
LIMIT 10' at line 19
Error Number : 1064 I think that happens when $vbulletin->options['eum_groups'] is empty.
CNBAforo
02-26-2008, 10:38 PM
In the case of deleted messages/threads, the reason and the deleted content, could be shown in some way to the user, for him to associate the infraction with the content.
Spinball
04-24-2008, 08:17 AM
I know this mod is flagged as unsupported, but I want to report an issue with it which I hope Michelle will look in to.
We have a large forum and are experiencing serious SQL slow downs with this query:
# Query_time: 11 Lock_time: 0 Rows_sent: 10 Rows_examined: 23956866
SELECT
modtable.username as moderator,
modtable.usergroupid as modgroup,
modlog.userid as modid,
modlog.action as action,
modlog.type as type,
modlog.dateline as dateline,
modlog.threadid as threadid,
modlog.postid as postid,
forum.forumid as forumid,
thread.title as threadtitle,
forum.title as forumtitle,
deletionlog.reason as delreason
FROM moderatorlog AS modlog
LEFT JOIN user AS modtable ON (modtable.userid = modlog.userid)
LEFT JOIN thread AS thread ON (thread.threadid = modlog.threadid)
LEFT JOIN post AS post ON (post.postid = modlog.postid)
LEFT JOIN forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = IF(deletionlog.type = 'post', modlog.postid, modlog.threadid))
WHERE
IF(modlog.postid,post.userid=28735,thread.postuser id=28735) AND modlog.type !=20 AND modtable.userid != 28735 AND modlog.type NOT IN (11,12) AN$
ORDER BY dateline DESC
LIMIT 10;
23 million rows examined!!! This mod is grinding our forum to a halt.
Is there an alternative, more efficient way of doing this? I have had to disable the mod until a fix is found, and I would suggest that anyone with a big forum check their SQL performance when using this.
Lea Verou
04-24-2008, 08:50 AM
Unless somebody else thinks of a way to fix this, personally I am unable to think of a most efficient query.
Sorry. :/
Spinball
04-24-2008, 09:26 AM
Unless somebody else thinks of a way to fix this, personally I am unable to think of a most efficient query.
Sorry. :/
Thanks for the quick reply. Might splitting it into separate queries not be easier on the database?
[Edit : I have added an index on moderatorlog.userid and have re-enabled to see whether that has any effect. It should do, I'm guessing and hoping.]
[Edit 2: Nope, still having problems - disabling.]
J98680Bxxxxx
04-24-2008, 09:48 AM
Installed (also marked) on vB 3.7 CR2, works fine. :up: Thanks Michelle.
Spinball
04-24-2008, 10:13 AM
Michelle, does this mod only report on certain types of moderator actions?
I ask because it is, by the looks of it, reporting checked posts from this mod:
https://vborg.vbsupport.ru/showthread.php?t=173609
Konstantinos
05-16-2008, 01:01 PM
it doesnt work for posts moved to another thread
Lea Verou
05-16-2008, 01:17 PM
it doesnt work for posts moved to another thread
It does, but it incorrectly notifies the thread author instead of the post authors.
Its a known bug that I will fix sometime, but I don't know when...
shadowevil
05-16-2008, 03:16 PM
Does this hack work with vB 3.7 GOLD ??
djilou
05-17-2008, 11:13 AM
Does this hack work with vB 3.7 GOLD ??
Same question here?
Fraxter
05-18-2008, 01:22 PM
Why is the feature "delete threads and posts" not available? I need this. Any other modification who can do this?
regards
TaBsiCore
05-25-2008, 07:24 AM
Same question here?
I installed it on a fresh 3.7 installation => Works perfect!
Elenna
06-05-2008, 04:49 PM
Works great on 3.7.1. Thanks so much!! One thing that confused me when testing was the Use Forum Permissions... I was expecting to see something and didn't, because of that option... so I disabled it, and voila! :)
Great addition!
ANGEL OF FIRE
06-08-2008, 02:27 PM
vBulletin 3.7.1
Does not work at addition ID 31
31 => 3 /*posts_copied_to_x */,
Datenbankfehler in vBulletin 3.7.1:
Invalid SQL:
SELECT
modtable.username as moderator,
modtable.usergroupid as modgroup,
modlog.userid as modid,
modlog.action as action,
modlog.type as type,
modlog.dateline as dateline,
modlog.threadid as threadid,
modlog.postid as postid,
forum.forumid as forumid,
thread.title as threadtitle,
forum.title as forumtitle,
deletionlog.reason as delreason
FROM moderatorlog AS modlog
LEFT JOIN user AS modtable ON (modtable.userid = modlog.userid)
LEFT JOIN thread AS thread ON (thread.threadid = modlog.threadid)
LEFT JOIN post AS post ON (post.postid = modlog.postid)
LEFT JOIN forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = IF(deletionlog.type = 'post', modlog.postid, modlog.threadid))
WHERE
IF(modlog.postid,post.userid=1,thread.postuserid=1 ) AND modlog.type !=20 AND modlog.type NOT IN (5,) AND 1212884825-modlog.dateline <86400 AND modtable.usergroupid IN (5,6,7)
ORDER BY dateline DESC
LIMIT 4;
MySQL-Fehler : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND 1212884825-modlog.dateline <86400 AND modtable.usergroupid IN (5,6,7)
' at line 21
Fehler-Nr. : 1064
Fehler-Zeit : Sunday, 08.06.2008 @ 00:27:05
Datum : Sunday, 08.06.2008 @ 00:27:05
Skript : http://www.xxxxxx.com/usercp.php?
Referrer : http://www.xxxxx.com/forum.php
IP-Adresse : xxxxxxxxxxxx
Benutzername : ANGEL OF FIRE
Klassenname : vB_Database
MySQL-Version : 5.0.54-log
GriZzm0
06-16-2008, 07:32 AM
I know this mod is flagged as unsupported, but I want to report an issue with it which I hope Michelle will look in to.
We have a large forum and are experiencing serious SQL slow downs with this query:
23 million rows examined!!! This mod is grinding our forum to a halt.
Is there an alternative, more efficient way of doing this? I have had to disable the mod until a fix is found, and I would suggest that anyone with a big forum check their SQL performance when using this.
I noticed this aswell. The usercp takes ages to load while I got this mod enabled.
jawatkin
06-25-2008, 01:48 AM
I know this mod is flagged as unsupported, but I want to report an issue with it which I hope Michelle will look in to.
We have a large forum and are experiencing serious SQL slow downs with this query:
23 million rows examined!!! This mod is grinding our forum to a halt.
Is there an alternative, more efficient way of doing this? I have had to disable the mod until a fix is found, and I would suggest that anyone with a big forum check their SQL performance when using this.
Ditto here... Same query.. Here's mine and I'm disabling this pronto. Took me a few hours to figure it out... but I'm seeing horrible locking issues!!!
# Time: 080624 20:19:30
# Query_time: 22 Lock_time: 11 Rows_sent: 10 Rows_examined: 6977723
SELECT
modtable.username as moderator,
modtable.usergroupid as modgroup,
modlog.userid as modid,
modlog.action as action,
modlog.type as type,
modlog.dateline as dateline,
modlog.threadid as threadid,
modlog.postid as postid,
forum.forumid as forumid,
thread.title as threadtitle,
forum.title as forumtitle,
deletionlog.reason as delreason
FROM moderatorlog AS modlog
LEFT JOIN user AS modtable ON (modtable.userid = modlog.userid)
LEFT JOIN thread AS thread ON (thread.threadid = modlog.threadid)
LEFT JOIN post AS post ON (post.postid = modlog.postid)
LEFT JOIN forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = IF(deletionlog.type = 'post', modlog.postid, modlog.threadid))
WHERE
IF(modlog.postid,post.userid=15234,thread.postuser id=15234) AND modlog.type !=20 AND modtable.userid != 15234 AND modlog.type NOT IN (11,12,29) AND 1214353145-modlog.dateline <2592000 AND modtable.usergroupid IN (5,6,7)
ORDER BY dateline DESC
LIMIT 10;
Alphawolf83
08-17-2008, 06:32 PM
Is there a known german translation for this hack? :)
sheefeh
10-21-2008, 08:04 AM
Installed, Thanks a lot :) great work :up:
stonner
08-10-2009, 08:28 PM
does this hack work with vB 3.8.3?
Leo Brazil
01-06-2010, 09:38 AM
I've been using this mod since 3.6 and all over 3.7 and 3.8....
I really wish to see it ported to 4.0
It's a great piece of work.
redlabour
03-05-2010, 04:52 AM
Anyone working on a 4.0 Port?
Leo Brazil
03-05-2010, 06:25 PM
It doesn't work on 4.0, style, templates, hooks changed a lot from vB3 to 4.
Too bad as this mod is really great.
farsgsm
03-08-2010, 06:26 PM
i recently updated my vb to 3.8.4 but see some error while editing posts.
should i reinstall this hack? or it won't work on 3.8.4 at all.
error log:
Warning: include_once([path]/includes/class_autopm_checker.php) [function.include-once]: failed to open stream: No such file or directory in [path]/editpost.php(638) : eval()'d code on line 1
Warning: include_once() [function.include]: Failed opening '[path]/includes/class_autopm_checker.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/editpost.php(638) : eval()'d code on line 1
Warning: include_once([path]/includes/class_autopm_parser.php) [function.include-once]: failed to open stream: No such file or directory in [path]/editpost.php(638) : eval()'d code on line 2
Warning: include_once() [function.include]: Failed opening '[path]/includes/class_autopm_parser.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/editpost.php(638) : eval()'d code on line 2
Warning: include_once([path]/includes/functions_autopm.php) [function.include-once]: failed to open stream: No such file or directory in [path]/editpost.php(638) : eval()'d code on line 3
Warning: include_once() [function.include]: Failed opening '[path]/includes/functions_autopm.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/editpost.php(638) : eval()'d code on line 3
Fatal error: Call to undefined function mod_autopm() in /home/farsgsmc/public_html/editpost.php(638) : eval()'d code on line 5
farsgsm
03-08-2010, 06:31 PM
i also reinstalled the mod, but got same result
Lea Verou
03-08-2010, 06:42 PM
i recently updated my vb to 3.8.4 but see some error while editing posts.
should i reinstall this hack? or it won't work on 3.8.4 at all.
error log:
Warning: include_once([path]/includes/class_autopm_checker.php) [function.include-once]: failed to open stream: No such file or directory in [path]/editpost.php(638) : eval()'d code on line 1
Warning: include_once() [function.include]: Failed opening '[path]/includes/class_autopm_checker.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/editpost.php(638) : eval()'d code on line 1
Warning: include_once([path]/includes/class_autopm_parser.php) [function.include-once]: failed to open stream: No such file or directory in [path]/editpost.php(638) : eval()'d code on line 2
Warning: include_once() [function.include]: Failed opening '[path]/includes/class_autopm_parser.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/editpost.php(638) : eval()'d code on line 2
Warning: include_once([path]/includes/functions_autopm.php) [function.include-once]: failed to open stream: No such file or directory in [path]/editpost.php(638) : eval()'d code on line 3
Warning: include_once() [function.include]: Failed opening '[path]/includes/functions_autopm.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/editpost.php(638) : eval()'d code on line 3
Fatal error: Call to undefined function mod_autopm() in /home/farsgsmc/public_html/editpost.php(638) : eval()'d code on line 5
This has nothing to do with my hack. I don't use any mod_autopm() function nor do I include such a file.
MoRa GFX
03-12-2010, 06:06 PM
Is there one for vB4.0.1?
Well,
i used it in vb3.8.x and would like it, to see it for vb 4.x.x
yahooooh
11-06-2010, 06:34 AM
update version for vb4 plz
Hi,
i push it, and asked for an VB4 versin.
Leo Brazil
06-07-2011, 12:05 PM
Yeah, I really miss this one on my vB4.
can anyone point me to the same hack for vB4 ??
Thanx!
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.