Quote:
Originally Posted by mimos04
mysql server (on dedicated server) and the php file (i put on the webhosting) are not on the same server which is different ip. btw in mysql i already give webhosting ip access to the advanced_bans mysql database. i've no idea what is the problem. still no success yet.
|
So, your HLDS and Database is on
same server.
And, Website on a
different server. Right?
Then go to your ~/amxmodx/configs/sql.cfg and set
PHP Code:
amx_sql_host "127.0.0.1"
amx_sql_type "mysql"
Add your Webhost's IP Address to your Database server's Remote SQL/Whitelist.
Check your ~/amxmodx/logs folder for any possible SQLQuery errors, if not, try amx_ban or amx_addban a client and rush to check if the ban actually gets written in your advanced_bans table.
And else, set the php host to
PHP Code:
$sql_host = "mysql server-hostname/IP";
Hope this helps.
__________________