vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   AdminCP Warnings Log add-on for Inferno Warning System v1.3 (https://vborg.vbsupport.ru/showthread.php?t=111120)

EvilHawk 03-21-2006 10:00 PM
AdminCP Warnings Log add-on for Inferno Warning System v1.3
 
An AdminCP Warnings Log add-on for Inferno Warning System v1.3 by Zero Tolerance (https://vborg.vbsupport.ru/showthread.php?t=93669)

INSTALL:
1. Upload all files in UPLOAD folder to your server
2. Refresh menu panel to display Inferno Warning Log in Statistics & Logs section

I made this because I wanted to be able to see all the warnings issued by the moderators at our site.

Hopefully something like this will be in a future releases of Inferno Warning System ;)

Stone Cold 3:16 03-22-2006 07:57 PM
SWEET! First post! Nice hak ;)

projectego 03-22-2006 08:38 PM
Very nice add-on. Thanks for sharing. :)

Bowromir 03-22-2006 09:03 PM
Great! thank you!

Robbed 03-22-2006 09:07 PM
Thanks, was looking for this feature

drumsy 03-22-2006 09:07 PM
Installed, thanks. For those curious, this is located under the Statistics & Logs section.

MentaL 03-22-2006 09:25 PM
is it possible to make use of this software that each warning creates a new topic

bada_bing 03-23-2006 03:27 AM
Nice thank you

Kmaster 03-23-2006 03:45 AM
Expires 1969-12-31 13:00:00?? something wrong here

q8-star 03-23-2006 06:17 AM
Also thanks ...will install soon ... :)

EvilHawk 03-23-2006 07:29 AM
Quote:
Originally Posted by Kmaster
Expires 1969-12-31 13:00:00?? something wrong here
Could you, please, check the real expiration date?

Kmaster 03-23-2006 09:32 AM
Quote:
Originally Posted by EvilHawk
Could you, please, check the real expiration date?
some in 30 day after, others in never. :banana:

EvilHawk 03-23-2006 10:33 AM
Quote:
Originally Posted by Kmaster
some in 30 day after, others in never. :banana:
The wrong days are for warnings that never expires!
The current version doesn't also show warnings issued from user profiles, i will upload an new version today that will fix both!

EvilHawk 03-23-2006 04:42 PM
Updated! Fixed "never expires" dates problem and now it shows also the warnings issued from the user profile!

bada_bing 03-23-2006 04:55 PM
Quote:
Originally Posted by EvilHawk
Updated! Fixed "never expires" dates problem and now it shows also the warnings issued from the user profile!
So for the ones who installed this prior to your update how do we fix the never expires date problem?

EvilHawk 03-23-2006 07:06 PM
just copy the new php file over the older one!

Snake 03-23-2006 07:37 PM
Oh this is quite good, thanks!

drumsy 03-23-2006 09:41 PM
Might want to change the spelling in cpnav_inferno_warn to read "Inferno Warning Log"

trigon 03-23-2006 11:37 PM
installed, btw there is an written error in the cpnav_inferno_warn.xml file.
It must be Inferno, not Infreno ;)

EvilHawk 03-24-2006 08:33 AM
Quote:
Originally Posted by Aftermath
Oh this is quite good, thanks!
You may click installed then! ;)
Quote:
Originally Posted by drumsy
Might want to change the spelling in cpnav_inferno_warn to read "Inferno Warning Log"
Quote:
Originally Posted by trigon
installed, btw there is an written error in the cpnav_inferno_warn.xml file.
Thank you, fixed! ;)

ShadowOne 04-05-2006 04:24 PM
im getting this...
Code:
Database error in vBulletin 3.5.4:

Invalid SQL:

        SELECT
          warnlog.wid as ID,
          user1.username as Moderator,
          user.username as To_User,
          user.userid as To_Userid,
          warnlog.w_adjust as Adjust,
          warnlog.w_amount as Amount,
          warnlog.w_notes as Notes,
          warnlog.w_expire as Expires,
          warnlog.w_expired as Expired,
          warnlog.w_time as Time,
          thread.title as Thread_Title,
          warnlog.w_post as PostId
        FROM  warnlog
        INNER JOIN user ON (warnlog.w_user=user.userid)
        INNER JOIN user user1 ON (warnlog.w_by=user1.userid)
        LEFT JOIN post ON (warnlog.w_post=post.postid)
        LEFT JOIN thread ON (post.threadid=thread.threadid)
               
                ORDER BY Time DESC
                LIMIT 0, 15;

MySQL Error  : Table 'urban_HHB.warnlog' doesn't exist
Error Number : 1146
Date        : Wednesday, April 5th 2006 @ 12:23:07 PM
Script      : http://www.hiphopbloodlinez.com/forum/admincp/warnlog.php
Referrer    : http://www.hiphopbloodlinez.com/forum/admincp/warnlog.php
IP Address  :
Username    : Unorthodox
Classname    : vb_database

EvilHawk 04-08-2006 02:03 PM
This is an add-on for for Inferno Warning System v1.3 by Zero Tolerance which you can find here -> https://vborg.vbsupport.ru/showthread.php?t=93669, it doesn't create any tables! Follow the instructions (from the above link) of how to install the required hack properly!

vauge 04-08-2006 03:09 PM
Quote:
Originally Posted by ShadowOne
im getting this...
Code:
Database error in vBulletin 3.5.4:

Invalid SQL:

        SELECT
          warnlog.wid as ID,
          user1.username as Moderator,
          user.username as To_User,
          user.userid as To_Userid,
          warnlog.w_adjust as Adjust,
          warnlog.w_amount as Amount,
          warnlog.w_notes as Notes,
          warnlog.w_expire as Expires,
          warnlog.w_expired as Expired,
          warnlog.w_time as Time,
          thread.title as Thread_Title,
          warnlog.w_post as PostId
        FROM  warnlog
        INNER JOIN user ON (warnlog.w_user=user.userid)
        INNER JOIN user user1 ON (warnlog.w_by=user1.userid)
        LEFT JOIN post ON (warnlog.w_post=post.postid)
        LEFT JOIN thread ON (post.threadid=thread.threadid)
               
                ORDER BY Time DESC
                LIMIT 0, 15;

MySQL Error  : Table 'urban_HHB.warnlog' doesn't exist
Error Number : 1146
Date        : Wednesday, April 5th 2006 @ 12:23:07 PM
Script      : http://www.hiphopbloodlinez.com/forum/admincp/warnlog.php
Referrer    : http://www.hiphopbloodlinez.com/forum/admincp/warnlog.php
IP Address  :
Username    : Unorthodox
Classname    : vb_database
I changed the following to the SELECT statement in warnlog.php - and it started working...

Code:
$logs = $db->query_read("
        SELECT
          " . TABLE_PREFIX . "warnlog.wid as ID,
          user1.username as Moderator,
          " . TABLE_PREFIX . "user.username as To_User,
          " . TABLE_PREFIX . "user.userid as To_Userid,
          " . TABLE_PREFIX . "warnlog.w_adjust as Adjust,
          " . TABLE_PREFIX . "warnlog.w_amount as Amount,
          " . TABLE_PREFIX . "warnlog.w_notes as Notes,
          " . TABLE_PREFIX . "warnlog.w_expire as Expires,
          " . TABLE_PREFIX . "warnlog.w_expired as Expired,
          " . TABLE_PREFIX . "warnlog.w_time as Time,
          " . TABLE_PREFIX . "thread.title as Thread_Title,
          " . TABLE_PREFIX . "warnlog.w_post as PostId
        FROM " . TABLE_PREFIX . "warnlog
        INNER JOIN " . TABLE_PREFIX . "user ON (" . TABLE_PREFIX . "warnlog.w_user=" . TABLE_PREFIX . "user.userid)
        INNER JOIN " . TABLE_PREFIX . "user as user1 ON (" . TABLE_PREFIX . "warnlog.w_by=user1.userid)
        LEFT JOIN " . TABLE_PREFIX . "post ON (" . TABLE_PREFIX . "warnlog.w_post=" . TABLE_PREFIX . "post.postid)
        LEFT JOIN " . TABLE_PREFIX . "thread ON (" . TABLE_PREFIX . "post.threadid=" . TABLE_PREFIX . "thread.threadid)
                $sqlconds
                ORDER BY $order
                LIMIT $startat, " . $vbulletin->GPC['perpage'] . "
        ");

EvilHawk 04-08-2006 06:17 PM
Yes your are correct i had forget to add " . TABLE_PREFIX . " to the from reference and joins! (you don't need " . TABLE_PREFIX . " to the select statement ;) )

I have updated the zip file!


ps. please, click install if you use it ;)

Dennis B 04-10-2006 12:48 AM
Thanks!!

MentaL 04-22-2006 04:07 PM
Quote:
Originally Posted by mentalrz
is it possible to make use of this software that each warning creates a new topic
bump

HuangA 04-29-2006 10:31 AM
You might want to edit warnlog.php around Line 92
Code:
        FROM  " . TABLE_PREFIX . "warnlog
        INNER JOIN " . TABLE_PREFIX . "user ON (warnlog.w_user=user.userid)
        INNER JOIN " . TABLE_PREFIX . "user ON (warnlog.w_by=user1.userid)
        LEFT JOIN " . TABLE_PREFIX . "post ON (warnlog.w_post=post.postid)
        LEFT JOIN " . TABLE_PREFIX . "thread ON (post.threadid=thread.threadid)
and replace with
Code:
        FROM  " . TABLE_PREFIX . "warnlog AS warnlog
        INNER JOIN " . TABLE_PREFIX . "user AS user ON (warnlog.w_user=user.userid)
        INNER JOIN " . TABLE_PREFIX . "user AS user1 ON (warnlog.w_by=user1.userid)
        LEFT JOIN " . TABLE_PREFIX . "post AS post ON (warnlog.w_post=post.postid)
        LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid=thread.threadid)
Missing the AS clauses will cause errors for those that are using tableprefix ;)

EvilHawk 04-29-2006 12:06 PM
Thank you sir!

Zip file updated.

zell_11 05-02-2006 09:34 AM
Thanks, i was looking for this!

Smiry Kin's 05-19-2006 11:53 AM
very nice, very usfull

mod2000 05-27-2006 03:49 PM
very nice !! INSTALLED!

Onkel Pac 06-19-2006 10:29 AM
ver very nice Mod thanks for it.


All times are GMT. The time now is 04:54 PM.

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.01358 seconds
  • Memory Usage 1,788KB
  • 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
  • (5)bbcode_code_printable
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (32)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete