[Exolent[jNr]]

Originally Posted by .Owyn. why is SQL better?

Because it will work like AMXBans, where if you ban a player in one server, then your other servers that use the same SQL database will have that player banned.

[Exolent[jNr]]

Updated to version 0.8!

Changelog:

• Version 0.8
  - Added SQL support.

[LaineN]

Good job Exolent!
You did it yourserf or you got help with SQL?

[alexinno]

the sql version doesn't have any connection to database function , or i can't see it

[LaineN]

Exloent, why you have two different plugins, advanced_bans and advanced_bans_sql, when that's the same plugin exept the comment for

PHP Code:

#define USING_SQL 


Just make a cvar.

[joaquimandrade]

Originally Posted by LaineN Exloent, why you have two different plugins, advanced_bans and advanced_bans_sql, when that's the same plugin exept the comment for PHP Code: #define USING_SQL  Just make a cvar.

lol

[prabalgarina]

[bg]
AB_BAN_INFORMATION = Ban informaciq
AB_NAME = Ime
AB_IP = IP
AB_STEAMID = SteamID
AB_REASON = Prichina
AB_BAN_LENGTH = Ban duljina
AB_UNBAN_TIME = Unban vreme
AB_ADMIN_NAME = Admin ime
AB_ADMIN_STEAMID = Admin SteamID
AB_WEBSITE = Ako mislite che ste bannati nespravedlivo,suobshtete v nashiq sait :: 
AB_NOT_AUTHORIZED = Celta ne e upulnomoshtena s survara!Ne uspeh pri bavnane!
AB_ALREADY_BANNED_STEAMID = SteamID to na igracha e veche bannato!
AB_ALREADY_BANNED_IP = IP to na igracha e veche bannato!
AB_PERMANENT_BAN = Permamenten bann!
AB_INVALID_STEAMID = NE validno SteamID!
AB_VALID_STEAMID_FORMAT = Pravilen format: STEAM_0:X:XXXXXXX
AB_INVALID_IP = Ne validno IP!
AB_NOT_IN_BAN_LIST = Ne moje da se nameri %s v ban listata!
AB_NO_BANS = Nqma nikoi bannat na tozi etap. 
AB_BAN_LIST_NUM = Listvane na bannatite igrachi  %i - %i.  
AB_BAN_LIST_NEXT = Izpolzvaite amx_banlist %i za sledvashtite hora v listata
AB_MAX_BAN_TIME = Maximalnoto vreme za banvane e  %i

good plugin

[Exolent[jNr]]

Originally Posted by LaineN Good job Exolent! You did it yourserf or you got help with SQL?

I had a few friends help me with learning SQL.

Originally Posted by alexinno the sql version doesn't have any connection to database function , or i can't see it

The tuple is handled in plugin_init() and then the table is created in PrepareTable() right after the plugin_init().
All the queries are threaded so it may look different.

Originally Posted by LaineN Exloent, why you have two different plugins, advanced_bans and advanced_bans_sql, when that's the same plugin exept the comment for PHP Code: #define USING_SQL  Just make a cvar.

Because it's easier for people who want SQL to just download that version, even if the only difference is that uncommented line.
Also, a cvar would be MUCH more difficult.

[alexinno]

Originally Posted by Exolent[jNr] I had a few friends help me with learning SQL. The tuple is handled in plugin_init() and then the table is created in PrepareTable() right after the plugin_init(). All the queries are threaded so it may look different.

it says "Can't connect to database" , but admin_sql it's working

L 05/29/2009 - 20:18:13: [AMXX] Plugin ("advanced_bans_sql.amxx") is setting itself as failed.
L 05/29/2009 - 20:18:13: [AMXX] Plugin says: Could not connect to database.
L 05/29/2009 - 20:18:13: [AMXX] Displaying debug trace (plugin "advanced_bans_sql.amxx")
L 05/29/2009 - 20:18:13: [AMXX] Run time error 1: forced exit
L 05/29/2009 - 20:18:13: [AMXX]    [0] 42862.attach::QueryCreateTable (line 402)
amx_sqladmins
[AMXX] Loaded 2 admins from database

[LaineN]

Originally Posted by Exolent[jNr] Because it's easier for people who want SQL to just download that version, even if the only difference is that uncommented line. Also, a cvar would be MUCH more difficult.

Okey, but then you don't need the difines.