AdminCP Warnings Log add-on for Inferno Warning System v1.3

[EvilHawk]

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]

SWEET! First post! Nice hak ;)

[projectego]

Very nice add-on. Thanks for sharing. :)

[Bowromir]

Great! thank you!

[Robbed]

Thanks, was looking for this feature

[drumsy]

Installed, thanks. For those curious, this is located under the Statistics & Logs section.

[MentaL]

is it possible to make use of this software that each warning creates a new topic

[bada_bing]

Nice thank you

[Kmaster]

Expires 1969-12-31 13:00:00?? something wrong here

[q8-star]

Also thanks ...will install soon ... :)

[EvilHawk]

Expires 1969-12-31 13:00:00?? something wrong here
Could you, please, check the real expiration date?

[Kmaster]

Could you, please, check the real expiration date?

some in 30 day after, others in never. :banana:

[EvilHawk]

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]

Updated! Fixed "never expires" dates problem and now it shows also the warnings issued from the user profile!

[bada_bing]

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]

just copy the new php file over the older one!

[Snake]

Oh this is quite good, thanks!

[drumsy]

Might want to change the spelling in cpnav_inferno_warn to read "Inferno Warning Log"

[trigon]

installed, btw there is an written error in the cpnav_inferno_warn.xml file.
It must be Inferno, not Infreno ;)

[EvilHawk]

Oh this is quite good, thanks!
You may click installed then! ;)
Might want to change the spelling in cpnav_inferno_warn to read "Inferno Warning Log"
installed, btw there is an written error in the cpnav_inferno_warn.xml file. Thank you, fixed! ;)

[ShadowOne]

im getting this...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]

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]

im getting this...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...

$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]

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]

Thanks!!

[MentaL]

is it possible to make use of this software that each warning creates a new topicbump

[HuangA]

You might want to edit warnlog.php around Line 92
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
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]

Thank you sir!

Zip file updated.

[zell_11]

Thanks, i was looking for this!

[Smiry Kin's]

very nice, very usfull

[mod2000]

very nice !! INSTALLED!

[Onkel Pac]

ver very nice Mod thanks for it.