Hello.
Can anyone do a code that manages bans via sql.
amx_ban, amx_banip, amx_addban adds all info in sql and then user gets kicked.
amx_unban removes ban from sql.
When user tries to connect server and hes banned he gets kicked with message "banned".
sql table would look like this.
Code:
CREATE TABLE `sql_bans` (
`id` int(255) NOT NULL auto_increment,
`player` varchar(32) NOT NULL,
`steamid` varchar(32) NOT NULL,
`ip` varchar(32) NOT NULL,
`date` varchar(32) NOT NULL,
`reason` varchar(32) NOT NULL,
`duration` varchar(32) NOT NULL,
`admin` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
)
Please dont recomend amxbans or advanced bans to me.