[BritishBoy]

Hi,

Why isn't this working?

I turn my WAMP MySQL off to test it, but the text won't be printed and the server doesn't close.

Код:

stock MySQLConnect()
{
	mysql_debug(1);
	if(!mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS))
	{
		print("Server failed to connect to MySQL!");
		SendRconCommand("exit");
	}
	return 0;
}

[playbox12]

Because "mysql_connect" returns the connection handle instead of 'fail' or 'success'

Instead you could do:

pawn Код:

if(mysql_ping()==-1)
{
    print("Server failed to connect to MySQL!");
    SendRconCommand("exit");
}

[BritishBoy]

Thanks for answering!

Like this?

Код:

stock MySQLConnect()
{
	mysql_debug(1);
	if(!mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS))
	{
		if(mysql_ping()==-1)
		{
			print("Server failed to connect to MySQL!");
			SendRconCommand("exit");
		}
	}	
	return 0;
}

It doesn't work

[[NoV]LaZ]

pawn Код:

stock MySQLConnect()
{
    mysql_debug(1);
    mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);

    if (mysql_ping()) == -1)
    {
        print("Server failed to connect to MySQL!");
        SendRconCommand("exit");
    }
    else
    {
        print("Connection successful\nGood day");
    }
}

[BritishBoy]

It works, thanks man!