[jeffery30162]

I am currently switching to mysql. The server has a connection to the Mysql database but, when the player connects to the server and his account is checked to see if it is reqistered or not it acts like he is not registered even though he is.

Here is the code portion that has the issue:

Код:

new query[200], rows, fields, string[128];
		mysql_format(MySQLCon, query, sizeof(query),"SELECT * FROM 'accounts' WHERE `Username` = '%s'", RPNU(playerid));
  		mysql_query(MySQLCon, query);
    	        cache_get_data(rows, fields, MySQLCon);
		if(rows > 0)
		{
		    SSSShowDialog(playerid, 2); // Account exists foward to login screen
		}
		else
		{
			SSSShowDialog(playerid, 1); // Account does not exists foward to register screen
		}

Even though the account is registered, it always gows to SSSShowDialog(playerid, 1);