Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.6 > vBulletin 3.6 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
e-steki User ModLog v1.1.3 - An alternative to moderation AutoPM Details »»
e-steki User ModLog v1.1.3 - An alternative to moderation AutoPM
Version: 1.1.3, by Lea Verou Lea Verou is offline
Developer Last Online: Jul 2012 Show Printable Version Email this Page

Category: Miscellaneous Hacks - Version: 3.6.8 Rating:
Released: 08-10-2007 Last Update: 08-14-2007 Installs: 134
Uses Plugins Template Edits
Additional Files  
No support by the author.

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:

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #122  
Old 05-17-2008, 11:13 AM
djilou djilou is offline
 
Join Date: Dec 2006
Posts: 119
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by shadowevil View Post
Does this hack work with vB 3.7 GOLD ??
Same question here?
Reply With Quote
  #123  
Old 05-18-2008, 01:22 PM
Fraxter Fraxter is offline
 
Join Date: Jul 2007
Posts: 158
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Why is the feature "delete threads and posts" not available? I need this. Any other modification who can do this?

regards
Reply With Quote
  #124  
Old 05-25-2008, 07:24 AM
TaBsiCore TaBsiCore is offline
 
Join Date: Feb 2007
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by djilou View Post
Same question here?
I installed it on a fresh 3.7 installation => Works perfect!
Reply With Quote
  #125  
Old 06-05-2008, 04:49 PM
Elenna Elenna is offline
 
Join Date: Jan 2006
Location: St. Charles, MO
Posts: 422
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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!
Reply With Quote
  #126  
Old 06-08-2008, 02:27 PM
ANGEL OF FIRE ANGEL OF FIRE is offline
 
Join Date: Jun 2007
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

vBulletin 3.7.1

Does not work at addition ID 31

31 => 3 /*posts_copied_to_x */,

Code:
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
Reply With Quote
  #127  
Old 06-16-2008, 07:32 AM
GriZzm0 GriZzm0 is offline
 
Join Date: Apr 2006
Location: Sweden, Helsingborg
Posts: 42
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Spinball View Post
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.
Reply With Quote
  #128  
Old 06-25-2008, 01:48 AM
jawatkin jawatkin is offline
 
Join Date: Apr 2007
Posts: 61
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Spinball View Post
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!!!

PHP Code:
# 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.postidmodlog.threadid))
                        
WHERE 
                        
IF(modlog.postid,post.userid=15234,thread.postuserid=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

Reply With Quote
  #129  
Old 08-17-2008, 06:32 PM
Alphawolf83's Avatar
Alphawolf83 Alphawolf83 is offline
 
Join Date: Mar 2005
Location: Germany
Posts: 99
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Is there a known german translation for this hack?
Reply With Quote
  #130  
Old 10-21-2008, 08:04 AM
sheefeh sheefeh is offline
 
Join Date: Jan 2008
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Installed, Thanks a lot great work :up:
Reply With Quote
  #131  
Old 08-10-2009, 08:28 PM
stonner stonner is offline
 
Join Date: Jun 2006
Posts: 212
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

does this hack work with vB 3.8.3?
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:58 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.16586 seconds
  • Memory Usage 2,347KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (1)bbcode_php
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete