Problem loading accounts via MySQL
#1

Код:
stock LoadAccount(playerid)
{
	new Escape[2][MAX_PLAYER_NAME];

	mysql_real_escape_string(PlayerInfo[playerid][pName], Escape[0]);
	mysql_real_escape_string(mysql_account_table, Escape[1]);

	format(query, sizeof(query), "SELECT * FROM `%s` WHERE `username` = '%s'", Escape[1], Escape[0]);
	mysql_query(query);
	mysql_store_result();

	if(mysql_num_rows())
	{
		if(mysql_fetch_row(largestr))
		{
            if(!sscanf(largestr, mysql_user_string, PlayerInfo[playerid]))
			{
        		PlayerInfo[playerid][pLoggedIn] = 1;
        		PlayerInfo[playerid][pRegistered] = 1;
        		PlayerInfo[playerid][pIsNew] = 0;
                printf("[DEBUG]: Player %s(%d) Stats loaded!", PlayerInfo[playerid][pName], playerid);
				return 1;
			}
			format(str, sizeof(str), "Player %s(%d) - SSCANF loading error", PlayerInfo[playerid][pName], playerid);
			Error("MYSQL", str);
			AccountError(playerid);
			mysql_free_result();
			return 1;
		}
		format(str, sizeof(str), "Player %s(%d) - Cannot fetch player row", PlayerInfo[playerid][pName], playerid);
		Error("MYSQL", str);
		AccountError(playerid);
		mysql_free_result();
		return 1;
	}
	format(str, sizeof(str), "Player %s(%d) - Cannot find player in the mysql database", PlayerInfo[playerid][pName], playerid);
    Error("MYSQL", str);
    AccountError(playerid);
	mysql_free_result();
	return 1;
}
When I login and create a new account, it all saves to the database. When I log back in the server closes the connection with this error

Код:
		format(str, sizeof(str), "Player %s(%d) - SSCANF loading error", PlayerInfo[playerid][pName], playerid);
I'm obviously using a base MySQL script and do not understand what the issue at hand is, can someone please point me in the right direction here.
Reply


Messages In This Thread
Problem loading accounts via MySQL - by Jing_Chan - 06.09.2017, 16:30
Re: Problem loading accounts via MySQL - by 10MIN - 06.09.2017, 16:36
Re: Problem loading accounts via MySQL - by Jing_Chan - 06.09.2017, 16:39
Re: Problem loading accounts via MySQL - by 10MIN - 06.09.2017, 16:42
Re: Problem loading accounts via MySQL - by Jing_Chan - 06.09.2017, 16:57
Re: Problem loading accounts via MySQL - by BadJih - 06.09.2017, 16:59
Re: Problem loading accounts via MySQL - by Vince - 06.09.2017, 19:57

Forum Jump:


Users browsing this thread: 2 Guest(s)