[Blademaster680]

Everything works perfectly except the "while" is preventing the code from working... Could someone help me please?
Thanks

Here is the code:

Код:

stock LoginPlayer(playerid)
{
	new query[126], pName[MAX_PLAYER_NAME];
	GetPlayerName(playerid, pName, sizeof(pName));
	format(query, sizeof(query), "SELECT * FROM playerdata WHERE Name = '%s'", pName);
	mysql_query(query);
	mysql_store_result();
	
	SendClientMessage(playerid, -1, "You have logged in successfully 2");
	while(mysql_fetch_row_format(query, "|"))
	{
	    mysql_fetch_field_row(PlayerInfo[playerid][Name], "Name");
     	mysql_fetch_field_row(PlayerInfo[playerid][Password], "Password");
     	mysql_fetch_field_row(query, "PlayerX"); PlayerInfo[playerid][Position][0] = floatstr(query);
     	mysql_fetch_field_row(query, "PlayerY"); PlayerInfo[playerid][Position][1] = floatstr(query);
     	mysql_fetch_field_row(query, "PlayerZ"); PlayerInfo[playerid][Position][2] = floatstr(query);
     	SendClientMessage(playerid, -1, "You have logged in successfully 3");
	}
	return 1;
}

[DiGiTaL_AnGeL]

I think you forgot a brace.

[Blademaster680]

Код:

stock LoginPlayer(playerid)
{
	new query[126], pName[MAX_PLAYER_NAME];
	GetPlayerName(playerid, pName, sizeof(pName));
	format(query, sizeof(query), "SELECT * FROM playerdata WHERE Name = '%s'", pName);
	mysql_query(query);
	mysql_store_result();
	
	SendClientMessage(playerid, -1, "You have logged in successfully 2");
	while(mysql_fetch_row_format(query, "|"))
	{
	    SendClientMessage(playerid, -1, "You have logged in successfully 3");
	    mysql_fetch_field_row(PlayerInfo[playerid][Name], "Name");
	    SendClientMessage(playerid, -1, "You have logged in successfully 4");
     	mysql_fetch_field_row(PlayerInfo[playerid][Password], "Password");
     	SendClientMessage(playerid, -1, "You have logged in successfully 5");
     	mysql_fetch_field_row(query, "PlayerX"); PlayerInfo[playerid][Position][0] = floatstr(query);
     	mysql_fetch_field_row(query, "PlayerY"); PlayerInfo[playerid][Position][1] = floatstr(query);
     	mysql_fetch_field_row(query, "PlayerZ"); PlayerInfo[playerid][Position][2] = floatstr(query);
     	SendClientMessage(playerid, -1, "You have logged in successfully 4");
	}
	return 1;
}

Its something todo in these lines:

Код:

{
	    SendClientMessage(playerid, -1, "You have logged in successfully 3");
	    mysql_fetch_field_row(PlayerInfo[playerid][Name], "Name");
	    SendClientMessage(playerid, -1, "You have logged in successfully 4");
     	mysql_fetch_field_row(PlayerInfo[playerid][Password], "Password");
     	SendClientMessage(playerid, -1, "You have logged in successfully 5");
     	mysql_fetch_field_row(query, "PlayerX"); PlayerInfo[playerid][Position][0] = floatstr(query);
     	mysql_fetch_field_row(query, "PlayerY"); PlayerInfo[playerid][Position][1] = floatstr(query);
     	mysql_fetch_field_row(query, "PlayerZ"); PlayerInfo[playerid][Position][2] = floatstr(query);
     	SendClientMessage(playerid, -1, "You have logged in successfully 4");
	}

Its almost like the code gets stuck and cant carry on...