[dai-kun]

I have trouble running kill_alerts cron
Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE vb3_user SER alerts='0' WHERE userid='39752';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'alerts='0' WHERE userid='39752'' at line 1
Error Number : 1064
Date : Wednesday, May 17th 2006 @ 04:12:29 PM
Script : http://domain.com/forum/admincp/cron...cron&cronid=40

I think

	$vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."user SER alerts='{$alerts}' WHERE userid='{$warn['userid']}'");

should be:

	$vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."user SET alerts='{$alerts}' WHERE userid='{$warn['userid']}'");

Also.. for some reason, when the warnings expire, they do not show up anymore in the view warnings, but i can still see a "Warnings: 1" in their postbit. This been happening for a really long time and I just never brought it up :/