HOW TO CREATE AN EVENT IN GROUP [MYSQL] - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: HOW TO CREATE AN EVENT IN GROUP [MYSQL] (/showthread.php?tid=661900)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: HOW TO CREATE AN EVENT IN GROUP [MYSQL] (/showthread.php?tid=661900)
HOW TO CREATE AN EVENT IN GROUP [MYSQL] - AlfaSufaIndo - 18.12.2018
I have several groups for different events. There are VIP and PlayerBans.
I know how to create events outside the group, but I don't know how to make them in groups.
Here are some screenshots and the code
Quote:
 |
PHP код:
mysql_format(g_SQL, query, sizeof(query), "CREATE EVENT `%e` ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL %s DO DELETE FROM `bans` WHERE `Username` = %e", GetName(playerid), time, GetName(playerid));
mysql_tquery(g_SQL, query);