vb.org Archive
Page 13 of 15 « First 31112 13 1415
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)
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.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?


All times are GMT. The time now is 02:49 AM.
Page 13 of 15 « First 31112 13 1415
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01166 seconds
  • Memory Usage 1,773KB
  • 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
  • (4)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