problems with /unbanip (SQL Lite)

problems with /unbanip (SQL Lite) - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: problems with /unbanip (SQL Lite) (/showthread.php?tid=304505)

problems with /unbanip (SQL Lite) - [WSF]ThA_Devil - 18.12.2011

hello... i've made Admin System with SQL Lite and i made /banip
command works fine but when i try unban ip... unban doesn't work
i tried this way:

pawn Код:

format(Query,sizeof(Query),"UPDATE `BANNEDIPS` WHERE `IP` = '%s' SET IP 'Unbanned'", DB_Escape(ip));

but it doesn't worked...
any help?

Re: problems with /unbanip (SQL Lite) - [WSF]ThA_Devil - 18.12.2011

fixed

pawn Код:

format(Query,sizeof(Query),"DELETE FROM `BANNEDIPS` WHERE `IP` = '%s'", DB_Escape(ip));