vb.org Archive - Miscellaneous Hacks - e-steki User ModLog v1.1.3

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Miscellaneous Hacks - e-steki User ModLog v1.1.3 - An alternative to moderation AutoPM (https://vborg.vbsupport.ru/showthread.php?t=154982)

Quote:

Originally Posted by Junkie (Post 1315579)

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

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.

Quote:

Originally Posted by Konstantinos (Post 1315584)

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.

Quote:

Originally Posted by JD45 (Post 1315638)

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.

Quote:

Originally Posted by stone0075 (Post 1315512)

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.

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

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?

looks great, but I receive an mySQL Error when accessing the UserCP!

Quote:

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

Quote:

Originally Posted by Wulfnoth (Post 1315791)

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.

Quote:

Originally Posted by winduff (Post 1315906)

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.

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.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01960 seconds Memory Usage 1,745KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: