AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   sql ban managment (https://forums.alliedmods.net/showthread.php?t=107273)

asd13 10-24-2009 18:49

sql ban managment
 
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.

fysiks 10-24-2009 21:48

Re: sql ban managment
 
Quote:

Originally Posted by asd13 (Post 971203)
Please dont recomend amxbans or advanced bans to me.

LOL. Because they already exist, as you obviously know, it's unlikely to happen.


All times are GMT -4. The time now is 17:39.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.