[magent]

I gets no error when i compile it. But when i reconnect i have to register again ¤_¤
Here is the Code when the player register:

Код:

stock RegisterPlayer(playerid, regpass[])
{
	new query[126], EncryptedPass[130];
	
	WP_Hash(EncryptedPass, sizeof(EncryptedPass), regpass);
	format(query, sizeof(query), "INSERT INTO accounts (Name, Password, PosX, PosY, PosZ, Skin)  VALUES ('%s', '%s', '1.0 2.0 3.0', '1')", GetName(playerid), EncryptedPass);
	mysql_query(query);
	
	LoginPlayer(playerid);

	return 1;
}

This is the code where it loads the players information.

Код:

stock LoginPlayer(playerid)
{
	new query[126], pName[MAX_PLAYER_NAME];
	GetPlayerName(playerid, pName, sizeof(pName));
	format(query, sizeof(query), "SELECT * FROM players WHERE Name = '%s'", pName);
	mysql_query(query);
	mysql_store_result();

	while(mysql_fetch_row_format(query,"|"))
	{
	    mysql_fetch_field_row(query, "id"); PlayerInfo[playerid][ID] = strval(query);
	    mysql_fetch_field_row(PlayerInfo[playerid][Name], "Name");
	    mysql_fetch_field_row(PlayerInfo[playerid][Password], "Password");
	    mysql_fetch_field_row(query, "AdminLevel"); Player[playerid][AdminLevel] = strval(query);
	    mysql_fetch_field_row(query, "PlayerPos"); sscanf(query, "fff", Player[playerid][Position][0], Player[playerid][Position][1], Player[playerid][Position][2]);
	    mysql_fetch_field_row(query, "Skin"); Player[playerid][Skin] = strval(query);
	    mysql_fetch_field_row(query, "Money"); Player[playerid][Money] = strval(query);
	    mysql_fetch_field_row(query, "Deaths"); Player[playerid][pDeaths] = strval(query);
	    mysql_fetch_field_row(query, "Kills"); Player[playerid][pKills] = strval(query);
	    mysql_fetch_field_row(query, "Vip"); Player[playerid][vStatus] = strval(query);

	}
	GivePlayerMoney(playerid, Player[playerid][Money]);
	SetSpawnInfo(playerid, 0, 1, Player[playerid][Position][0], Player[playerid][Position][1], Player[playerid][Position][2], 0, 0, 0, 0, 0, 0, 0);
}

[Vince]

Your insert query is wrong. PosX/Y/Z are supposed to be separate parameters. Also don't enclose numbers in quotes.
Next time, enable MySQL logging and read it when something goes wrong.

[magent]

ok thanks m8 =)