The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
AdminCP Warnings Log add-on for Inferno Warning System v1.3 Details »» | |||||||||||||||||||||||||||
AdminCP Warnings Log add-on for Inferno Warning System v1.3
Developer Last Online: Nov 2023
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 Show Your Support
|
Comments |
#22
|
|||
|
|||
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 |
#23
|
|||
|
|||
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!
|
#24
|
|||
|
|||
Quote:
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'] . " "); |
#25
|
|||
|
|||
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 |
#26
|
||||
|
||||
Thanks!!
|
#27
|
||||
|
||||
Quote:
|
#28
|
||||
|
||||
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) 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) |
#29
|
|||
|
|||
Thank you sir!
Zip file updated. |
#30
|
|||
|
|||
Thanks, i was looking for this!
|
#31
|
||||
|
||||
very nice, very usfull
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|