[xXxOpOpxXx]

yes but as I said i am using 1.8.1 it doesn't really matter if I enabled it in modules.ini... isn't it ? it is loading required modules allone any way it is enabled because I was using bf2 rank mod with mysql and it was working fine but with this plugin there is that error ...

[ 1] AMX Mod X RUN - amxmodx_mm.dll v1.8.1.3 ini Start ANY [ 2] WinHL-Booster RUN - booster_mm.dll v1.70 ini Chlvl Pause [ 3] dproto RUN - dproto.dll v0.3.2 ini Start Never [ 4] MySQL RUN - mysql_amxx.dll v1.8.1.3 pl1 ANY ANY [ 5] CSX RUN - csx_amxx.dll v1.8.1.3 pl1 ANY ANY [ 6] Engine RUN - engine_amxx.dll v1.8.1.3 pl1 ANY ANY [ 7] CStrike RUN - cstrike_amxx.dll v1.8.1.3 pl1 ANY ANY [ 8] FakeMeta RUN - fakemeta_amxx.dl v1.8.1.3 pl1 ANY ANY [ 9] Ham Sandwich RUN - hamsandwich_amxx v1.8.1.3 pl1 ANY ANY [10] Fun RUN - fun_amxx.dll v1.8.1.3 pl1 ANY ANY

[alexinno]

try this version http://forums.alliedmods.net/showpos...&postcount=393

[D-TOX]

When I ban someone is says in the banned.cfg STEAM_ID_PENDING why is that ?

PM you can answer me

[Exolent[jNr]]

Originally Posted by xXxOpOpxXx yes but as I said i am using 1.8.1 it doesn't really matter if I enabled it in modules.ini... isn't it ? it is loading required modules allone any way it is enabled because I was using bf2 rank mod with mysql and it was working fine but with this plugin there is that error ...

You are using 47/48 Protocol server.
You no longer will receive support.

[tomashaker4e]

Exolent Buddy , I added MacedonianTranslation
Nice Plugin

[xXxOpOpxXx]

good 90% of servers are using it why to reject non-steam clients ... off ..

[Exolent[jNr]]

Because Non-Steam may have bugs that Steam doesn't, and AMXX only supports Steam.

[xXxOpOpxXx]

ohh ok any way thanks to @alexinno
this works fine ...

[Duff-Girl]

Exolent plz read this :

I got 1 suggestion when you ban some one and it says check your console it would be good if it shows when the ban is over

i does show when its over it shows the time but not how long it is

ex. Timeleft : 3m 20 seconds something like that

and when i am useing your sql i cant make it work in the console i type amx_help then it shows amx_banreason and amx_banlist but it dosent show amx_ban and amx_addban and when i type into the console amx_ban it says unknown command

[z3rongod]

Hello I've been struggling the past two hours to make this work. The first 20 minutes was about an error with a function, it failed because i had 1.8.0 . Stupid host installs 1.8.0 by default.

In any case i now the plugin fails with:

L 09/02/2009 - 06:15:49: [AMXX] Plugin ("advanced_bans_sql.amxx") is setting itself as failed.
L 09/02/2009 - 06:15:49: [AMXX] Plugin says: Could not connect to database.
L 09/02/2009 - 06:15:49: [AMXX] Displaying debug trace (plugin "advanced_bans_sql.amxx")
L 09/02/2009 - 06:15:49: [AMXX] Run time error 1: forced exit 
L 09/02/2009 - 06:15:49: [AMXX]    [0] 42862.attach::QueryCreateTable (line 402)

Here are some configurations which may or not be relevant:

Amxmodx version is 1.8.1.

modules.ini:

;;;
; To enable a module, remove the semi-colon (;) in front of its name.
; If it's not here, simply add it its name, one per line.
; You don't need to write the _amxx part or the file extension.
;;;

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; SQL Modules usually need to be enabled manually ;;
;; You can have any number on at a time.  Use      ;;
;;  amx_sql_type in sql.cfg to specify the default ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

mysql
sqlite

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; Put third party modules below here.              ;;
;; You can just list their names, without the _amxx ;;
;;  or file extension.                              ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;



;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; These modules will be auto-detected and loaded   ;;
;;  as needed.  You do not need to enable them here ;;
;;  unless you have problems.                       ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

fun
engine
fakemeta
geoip
sockets
regex
nvault
cstrike
csx
hamsandwich
netdb

sql.cfg:

// SQL configuration file
// File location: $moddir/addons/amxmodx/configs/sql.cfg

// *NOTE* Linux users may encounter problems if they specify "localhost" instead of "127.0.0.1"
// We recommend using your server IP address instead of its name

// *NOTE* amx_sql_type specifies the DEFAULT database type which admin.sma will use.

//amx_sql_host "usn.ro"  - i tried the adress too
amx_sql_host    "89.44.246.250"
amx_sql_user    "usnro_servercs"
amx_sql_pass    "XXX"
amx_sql_db        "usnro_servercs"
amx_sql_table    ""
amx_sql_type    "mysql"

The sql user is valid
The password is valid
The database is valid

The website is located on usn.ro
I've pinged the usn.ro to get that IP, as i haven't found another source

I've added " % " to hosts in DirectAdmin for that database. It sets access to any host. I also previously attempted adding the server IP and FTP IP.

There are no tables created in the database.

Edit:

I've executed the following cvars
amx_cvar amx_sql_user
amx_cvar amx_sql_db
amx_cvar amx_sql_server
amx_cvar amx_sql_pass

and they've returned accordingly to the value in sql.cfg

It's 6:24 AM and haven't slept at all, for a quick response in the following hours I'll remain forever grateful, as I want to finish configuring the server before I go to sleep.

But another time is, of course, always better than never.

Thank you firstly for this plugin, secondly for having the time to read this reply.

Sergiu.