Raised This Month: $ Target: $400
 0% 

Help: A small bansync script (ala AMXBans) using SQL


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Skarbo
Junior Member
Join Date: Mar 2006
Old 03-26-2006 , 10:33  
Reply With Quote #3

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.
Skarbo is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 16:44.


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