Miscellaneous Hacks - e-steki User ModLog v1.1.3 - An alternative to moderation AutoPM

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?

1. 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.
2. Its not in the Modification Graveyard, so there is a much higher chance of updates and support ;-P
3. It allows more types of actions to show (unfortunately exept hard deletes).
4. Its more visually appealing ;-)
5. Users have to make more clicks to discuss an issue with the moderator, which makes it a little harder for them to protest ;-)
6. Most forums have some "moderation routines" that involve many moderator actions. Especially in this case MAP can be REALLY annoying.
7. 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. Features

Admin Features

1. Absolutely NO template modifications and you even get to control where the table will be placed in the UserCP with a simple setting!
2. Ability to hide who the moderator that performed the action was.
3. Fully phrased.
4. Your moderators will not see their own actions, but the actions performed by other moderators on their posts/threads (customizable).
5. You get to control which action types will be shown and how many of them.
6. Ability to set a cutoff limit, so that actions that are performed before X days will not show.
7. Ability to specify which mod/admin usergroups' actions will display.
8. Displays actions from the moment you install it, even old ones, it doesn't display only the actions that are performed afterwards.
9. Supports e-steki Featured threads.
10. A nice, usable and extensive manual instead of an ugly readme.txt ;-)

End user Features

1. Easy spotting of the action type by the nice colorful small icons (provided by famfamfam.com. Thanks!)
2. 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.
3. 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.
4. The table is collapsible, and if it has nothing to display it doesn't show, just like the other tables in the UserCP.
5. 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)
6. 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:

[Konstantinos]

Originally Posted by Junkie

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]

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.

[JD45]

Originally Posted by Konstantinos

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]

Originally Posted by JD45

BTW: Nominated for MOTM.

Thank you so much!!!!

@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]

Originally Posted by stone0075

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

This hack is amazing! Uninstalled Moderation Auto-PM and installed this one, and it's working perfectly.

Very quick install and so easy, too.

[Wulfnoth]

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]

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]

Originally Posted by Wulfnoth

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.

Originally Posted by winduff

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]

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.