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

Try using the admin_warn.php attached here. It works in my 3.03.

Rgds

that's weird, I won't work for me. Still got same error.
enclosed found attached my current use version, hope this can help!!
thanks a lot.


rgds,

You are obviously using the new admin_warn.php with the page layout in the report. Did you remember to add the suggested column, in the warning_options table of your database? If not, you have to run the following query, and then go to your AdminCP/Warning System/Warning Options and fill in the number of rows per page, at the last field.

Let me know if it works.

The query is:

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

Yes, I'd added the query into database.
still get same error.

Great news... i'll be waiting 4 that mod... hope soon ;)

Good luck.

OK, you added the column, but have you defined the Lines Per Page you want to see, in the Warning Options? What I can see from the error, is that it can't find the upper limit, something missing after "ORDER BY w.warned_time DESC LIMIT 0, " that comma. That's where it uses the lines per page.

Let me know.

Rgds

Well, I have almost everything ready, even the installation program is done (copied that from Zero Tolerance).

What I am waiting for, before releasing the hack, is Zero Tolerance's permission. You see, a lot of this code comes from his original hack, and I do not want to use it in a new hack, without his permission.

Rgds

Any update on releasing this? :)

Anyone interested in acting as a guinea pig to test it out before releasing it?

My Sun run out of disk space, so I need to do some maintenance before I can test the whole installation thing. If someone is willing to try it out, it will speed things up significantly. All you need is a clean 3.0x installation (without Zero Tolerance's things).

I attach here the ... Features List, I think you will find it interesting:

- post- and non-post-related warnings
- hierarchical warning schema (mods can warn users, super mods can warn mods and users, admins can warn everyone, no same-level warnings)
- hidden or real warners
- customizable maximum warning points
- customizable ban days
- customizable ban user group and permanent ban user group
- supports incremental banning periods
- supports multiple warnings for the same post
- warned members are notified either by Private Message or e-mail
- maintains historical listings of issued warnings (even if deleted or expired)
- customizable warning types
- each warning type has predefined warning points associated with it
- each warning type has predefined maturity period, after which it is automatically removed
- reports for admin, and mods
- cron job included to automatically remove matured warnings
- uses vBulletin's cron job, to automatically unban banned users
- all options are setable in your AdminCP
- user warning points and number of bans viewable in your AdminCP user template.

rgds
--------------
John