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

Page 4 of 4

Show 40 post(s) from this thread on one page

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)

djilou

05-17-2008 11:13 AM

Quote:

Originally Posted by shadowevil (Post 1521698)

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

Quote:

Originally Posted by djilou (Post 1522485)

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 */,

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

GriZzm0

06-16-2008 07:32 AM

Quote:

Originally Posted by Spinball (Post 1497977)

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

Quote:

Originally Posted by Spinball (Post 1497977)

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.postid, modlog.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;

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

Quote:

Originally Posted by farsgsm (Post 1999966)

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?

MrD	08-15-2010 10:56 AM

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

MrD	01-31-2011 07:51 AM

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.

ka81	11-05-2013 06:29 AM

can anyone point me to the same hack for vB4 ??

Thanx!

All times are GMT. The time now is 05:53 PM.

Page 4 of 4

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01421 seconds Memory Usage 1,821KB 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 (1)bbcode_code_printable (1)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (22)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: