Mysql problem help me
#1

hello i have a problem with mysql

First : The script are very slow when i connect
Second : Many Information are not load correctly.

(PS : Sorry for my bad english, i'm not english)

Код:
stock LoadAccountVariables(playerid)
{
	new EscapedName[MAX_PLAYER_NAME];
	if(GetPVarInt(playerid, "Authentication") == 1)
    {
	    mysql_real_escape_string(GetName(playerid), EscapedName);
		format(query, sizeof(query), "SELECT * FROM `Accounts` WHERE `Username` = '%s'", EscapedName);
		mysql_query(query);
		mysql_store_result();

		mysql_fetch_row_format(query, "|");
		sscanf(query, "e<p<|>ds[255]s[255]dddddddddddddddddddddddddddddddddddddddddddddddffdddddddfffdddddddddddddddddddddddddddddddds[255]ds[255]ds[255]ds[255]ds[255]ds[255]ddddddddddddddddddddddddddfs[255]dds[255]dssdd>", PlayerInfo[playerid]);
		mysql_free_result();
	}
	else print("[MySQL ERROR] LoadAccountVariables() was called, but to a non-connected ID.");
}
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)