as i said, yeah i thought the mysql db was blocking it which is yes on a external server as i said before but i have went to the cpanel and i have added the ip of the server in the 'allowed mysql hosts' list, and over that i have also tried making a simple php script that uses mysql_connect to test things out, if the host is not in the white list it will be blocked if it is it will connect fine.
here is my database.cfg
Code:
"Databases"
{
"driver_default" "mysql"
"default"
{
"driver" "default"
"host" "i tried the ip and the host name as 'name.com'"
"database" "db name"
"user" "user name"
"pass" "pass"
//"timeout" "0"
"port" "3306"
}
"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
}