[fysiks]

Originally Posted by Robotron Problem: how can i fix this?

Make sure that your database is accessible to the server. Often, if you have a database on a website that is not also your game server provider then you can't connect to it because it does not allow outside connections. I would check your credentials first then check to see if you are actually allowed to access the database from the server.

[Robotron]

Originally Posted by fysiks Make sure that your database is accessible to the server. Often, if you have a database on a website that is not also your game server provider then you can't connect to it because it does not allow outside connections. I would check your credentials first then check to see if you are actually allowed to access the database from the server.

I have enabled remote access to the database, my server is a dedicated server. Previously worked but this stopped working.

[Zoobb]

I have downloaded this plugin but when i do the command amxmodmenu and choose bans
When i choose the time and the person, it go ban without a reason but when i do
amx_ban <nick, #userid, authid> <time in minutes> <reason> it works but i need it in amxmodmenu
so anyone could help me?

[TheShark558]

Well done thanks for the post

[zkip]

Exolent, Is it possible to ban a offline player?
Because it wont work on my server when i use amx_addban "Steam_ID"
It just says there is no such steam id..

[neoRT]

Originally Posted by zkip Exolent, Is it possible to ban a offline player? Because it wont work on my server when i use amx_addban "Steam_ID" It just says there is no such steam id..

The correct way is: amx_addban name steamid bantime reason. All 4 fields are required.
----------------------------------1-----2-------3------4----

[zkip]

Originally Posted by neoRT The correct way is: amx_addban name steamid bantime reason. All 4 fields are required. ----------------------------------1-----2-------3------4----

Okey, Thank you! ;D

[bibu]

Still waiting for ban menu. Go ahead and do it exo.

[Balgaa]

i installed version 0.8.1...

L 04/01/2012 - 14:15:46: [advanced_bans_sql.amxx] SQL Error: Access denied for user 'root'@'localhost' (using password: NO)

amx_sql_host "127.0.0.1"
amx_sql_user "advancedbans"
amx_sql_pass "test"
amx_sql_db "advancedbans"
//amx_sql_table "admin"
amx_sql_type "mysql"

any suggestion?

i modified code to get more detail error message as below.

/* public QueryCreateTable(failstate, Handle:query, error[], errcode, data[], datasize, Float:queuetime) { if( failstate == TQUERY_CONNECT_FAILED ) { set_fail_state("Could not connect to database."); } else if( failstate == TQUERY_QUERY_FAILED ) { set_fail_state("Query failed."); } else if( errcode ) { log_amx("Error on query: %s", error); } else { LoadBans(); } } */

public QueryCreateTable(failstate, Handle:query, error[], errcode, data[], datasize, Float:queuetime) { if( failstate ) { log_amx("SQL Error: %s", error); } else { LoadBans(); } }

exolent, any threaded version for 0.8.1?

[Balgaa]

i found that 0.8.1 sql version doesnt work... installed 0.8 threaded version, no errors...

Exolent,

do you have plan to modify as below?

Originally Posted by Racoon These need to be fixed: 1) Not all plugin messages are in lang file. Some of them are inside the .sma 2) Make a limit for bans shown per page. Because when there are too many bans in .txt file and you try to look through the ban list you get kicked with "Reliable Channel Overflow" by alexinno: 3) add date when player was banned

__________________