[Lczy]

Simple Temporary Ban

Today, i saw this thread and i decided to make an FS using event scheduler.

Requirement
Before using this filterscript, you must enable the event_scheduler by editing my.ini (Win) or my.cnf (Linux) or by a simple query :

Код:

SET GLOBAL `event_scheduler`= ON

What is the difference between another ban system?
- This FS is using event_scheduler, temporary banned players will be automatically unbanned by the MySQL server.
- You can easily ban a player with a certain time [Day/Hour/Minute/Week/Second/Year/Month]
Syntax :

Код:

/ban <id> <time> [Day/Hour/Minute/Week/Second/Year/Month] <reason>

How to use?
- You just need to redefine these MySQL information with yours.

Код:

#define MYSQL_HOST			"HOST" // e.g (localhost)
#define MYSQL_USER			""
#define MYSQL_PASSWORD		""
#define MYSQL_DATABASE		""

Code :
pastebin.com

Note : I just learn MySQL plugin, if you found any bugs, please let me know to improve my knowledge about this plugin.