Thanks but its still not working, same error.
Its on a local computer btw and local SQL with all privileges.
-- edit
changed the SQL
Code:
dbi_query(dbc,"CREATE TABLE IF NOT EXISTS `arctic_bans` (`bid` INT( 11 ) NOT NULL AUTO_INCREMENT, `steamid` VARCHAR( 50 ), `nick` VARCHAR( 100 ), `ip` VARCHAR( 100 ), `reason` VARCHAR( 255 ), `cur_time` INT( 11 ) NOT NULL, `length` VARCHAR( 100 ) DEFAULT '0' NOT NULL, `admin` VARCHAR( 50 ), `server` VARCHAR( 100 ), PRIMARY KEY ( `bid` ))")
-- edit2
Ok figured out the problem, when i restarted the server i had a client that joined the server right away and the SQL username, password etc. dint get the time to load..
What i need help with now
Now i have to write either arctic_ban [steamid] or [nickname], how can i do it with #[userid]? (like all the other amx commands: amx_slay #[userid])
If the player is banned it checks the length and compares it with the current time, and kicks him if he is still banned.