[Kmaster]

Originally Posted by sv1cec

OK, the paged layout for the Warning Logs is done.

You have to add a new column in your warning_options table, using the following SQL Query (remember to use the TABLE_PREFIX if you are using one):

alter table `warning_options` add warnings_per_page int(3)

After you've done this, use the attached admin_warn.php file. Sorry I can't provide a detailed step-by-step mods write-up, too many changes to make it viable.

Let me know if it works.

Rgds
------------
John

I found this error, when use the new admin_warn.php

Database error in vBulletin 3.0.3:

Invalid SQL: select w.*,u.username as wusername,u.userid as wuserid,wt.*,wuser.username as warned_username_v,wuser.userid as warned_userid_v from
warnings w
left join user wuser on(wuser.userid=w.warned_user)
left join user u on(u.userid=w.warned_by)
left join warning_types wt on(wt.tid=w.warned_warning_id) ORDER BY w.warned_time DESC LIMIT 0,
mysql error: You have an error in your SQL syntax near '' at line 5

mysql error number: 1064

Date: Saturday 13th of November 2004 05:47:18 PM
Script: http://xxxxxxxx.xx/forums/admincp/ad...p?act=viewlogs
Referer: http://xxx.xx/forums/admincp/index.php?do=nav
Username: xxx
IP Address: xxx.x.xx.xxx