16.11.2014, 21:54
What the.. This is the first time I've seen this function
TIMESTAP or TIMESTAMP?
Anyways, good tutorial, can be used for many things, I know
pawn Code:
mysql_tquery(connectionHandler,
"CREATE EVENT `unbanall` ON SCHEDULE AT CURRENT_TIMESTAP() + INTERVAL 1 DAY \
DO \
UPDATE `mybans` SET `banSTATUS`=0", "", "");
//After 1 day, every bans will be expired from my table.
//Even if the server is shut down, this schedule will be running as long as MySQL server is up and if the event is enabled.
Anyways, good tutorial, can be used for many things, I know