MySQL event for un-ban member does not work.

[budiony]

The reason is trivial: SQL error. The event unbanUsers should be:

BEGIN DELETE FROM member_jail WHERE (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(timestamp) - (banned_hours * 60*60)) > 0; UPDATE members m SET m.banned = 0 WHERE m.banned = 1 AND m.id NOT IN (SELECT v.user_id FROM member_jail v); END