[MohammedZ]

A person can login with another password, data doesnt get loaded i need help here is my code

Код:

stock SaveUserStats(playerid)
{
        if(!IsLoggedIn[playerid])
		return 0;
        new Query[500];
		CheckMySQL();
 	   format(Query, 500, "UPDATE PCNR_user SET Alevel = '%d',Vlevel = '%d',Cash = '%d',Score = '%d',Kills = '%d',Deaths = '%d',Holdups = '%d',Crimes = '%d',Fined = '%d',Arrests = '%d',Takedowns = '%d',Tickets = '%d',Rope = '%d',PaintCan = '%d',Scissors = '%d',Kits = '%d',vLock = '%d',Helper = '%d',hHelper = '%d',Warns = '%d',Kicks = '%d',Joins = '%d',Materials = '%d',Banned = '%d',jTime = '%d',Wanted = '%d',cTime = '%d',Drugs = '%d',PlayerBombs = '%d' WHERE Name = '%s'",
		 PlayerInfo[playerid][aLevel],
		PlayerInfo[playerid][vLevel], GetPlayerCash(playerid), GetPlayerScore(playerid), PlayerInfo[playerid][pKills],
	    PlayerInfo[playerid][pDeaths], PlayerInfo[playerid][pHoldups], PlayerInfo[playerid][pCrimes],
		 PlayerInfo[playerid][pFined], PlayerInfo[playerid][pArrests], PlayerInfo[playerid][pTakedowns],
		  PlayerInfo[playerid][pTickets], PlayerInfo[playerid][pRope],
		 PlayerInfo[playerid][pPaintCan], PlayerInfo[playerid][pScissors],
		  PlayerInfo[playerid][pKits], PlayerInfo[playerid][vLock],
		PlayerInfo[playerid][Helper], PlayerInfo[playerid][hHelper],
		 PlayerInfo[playerid][pWarns], PlayerInfo[playerid][pKicks],
		  PlayerInfo[playerid][pJoins], PlayerInfo[playerid][pMaterials],
		   PlayerInfo[playerid][Banned], PlayerInfo[playerid][jTime],
		   GetPlayerWantedLevel(playerid), PlayerInfo[playerid][cTime],
		  PlayerInfo[playerid][Drugs], PlayerInfo[playerid][PlayerBombs], GetName(playerid));
    	mysql_query(Query);
	return 1;
}

Код:

case LOGIN_MENU:
    {
        if(!strlen(inputtext)) return SendClientMessage(playerid, RED, "You MUST provide a password.") && Kick(playerid);
        if(!response)
        {
        SendClientMessage(playerid, RED, "You must login to play and so you have been kicked.");
        Kick(playerid);
        }
        if(response)
        {
            CheckMySQL();

    	new string[128];
	format(string, sizeof(string), "SELECT * FROM PCNR_user WHERE Name = '%s' AND Password = '%s'", PlayerInfo[playerid][Name], inputtext);
	mysql_query(string);
	mysql_store_result();

	if(!mysql_num_rows())
		return SendClientMessage(playerid, RED, "[ACCOUNT] Incorrect password!");

	new row[128]; // The length of 1 'row' total.
	new field[31][32]; // [4] = Amount of fields, [24] = Max length of the bigest field.

	mysql_fetch_row_format(row, "|");
	explode(row, field, "|");
	mysql_free_result();

	// The field starts here with 1, because the field 'Name' = 0, and we already have the name in a variable.
	format(PlayerInfo[playerid][pPass], 32, "%s", field[1]);
 	PlayerInfo[playerid][aLevel] = strval(field[2]);
 	PlayerInfo[playerid][vLevel] = strval(field[3]);
 	PlayerInfo[playerid][pCash] = strval(field[4]);
 	PlayerInfo[playerid][pScore] = strval(field[5]);
 	PlayerInfo[playerid][pKills] = strval(field[6]);
 	PlayerInfo[playerid][pDeaths] = strval(field[7]);
 	PlayerInfo[playerid][pHoldups] = strval(field[8]);
 	PlayerInfo[playerid][pCrimes] = strval(field[9]);
 	PlayerInfo[playerid][pFined] = strval(field[10]);
 	PlayerInfo[playerid][pArrests] = strval(field[11]);
 	PlayerInfo[playerid][pTakedowns] = strval(field[12]);
 	PlayerInfo[playerid][pTickets] = strval(field[13]);
 	PlayerInfo[playerid][pRope] = strval(field[14]);
 	PlayerInfo[playerid][pPaintCan] = strval(field[15]);
 	PlayerInfo[playerid][pScissors] = strval(field[16]);
 	PlayerInfo[playerid][pKits] = strval(field[17]);
 	PlayerInfo[playerid][vLock] = strval(field[18]);
 	PlayerInfo[playerid][Helper] = strval(field[19]);
 	PlayerInfo[playerid][hHelper] = strval(field[20]);
 	PlayerInfo[playerid][pWarns] = strval(field[21]);
 	PlayerInfo[playerid][pKicks] = strval(field[22]);
 	PlayerInfo[playerid][pJoins] = strval(field[23]);
 	PlayerInfo[playerid][pMaterials] = strval(field[24]);
 	PlayerInfo[playerid][Banned] = strval(field[25]);
 	PlayerInfo[playerid][jTime] = strval(field[26]);
 	PlayerInfo[playerid][pWanted] = strval(field[27]);
 	PlayerInfo[playerid][cTime] = strval(field[28]);
 	PlayerInfo[playerid][Drugs] = strval(field[29]);
 	PlayerInfo[playerid][PlayerBombs] = strval(field[30]);

 	SetPlayerCash(playerid, PlayerInfo[playerid][pCash]);
 	SetPlayerScore(playerid, PlayerInfo[playerid][pScore]);
 	SetPlayerWantedLevel(playerid, PlayerInfo[playerid][pWanted]);

        format(string, sizeof(string), "[ACCOUNT] Welcome back %s, you are now logged in!", PlayerInfo[playerid][Name]);
    	SendClientMessage(playerid, YELLOW, string);
    	IsLoggedIn{playerid} = 1;
}
return 1;
}

I use mysql r6 please help me

[OmegaKiller72]

why you do not use enum? like enum pData {}

[MohammedZ]

I do use enums

Quote:

enum PCNR_user { Name[MAX_PLAYER_NAME], pPass[32], aLevel, vLevel, pCash, pScore, pKills, pDeaths, pHoldups, pCrimes, pFined, pArrests, pTakedowns, pTickets, pRope, pPaintCan, pScissors, pKits, vLock, Helper, hHelper, pWarns, pKicks, pJoins, pMaterials, Banned, jTime, FloatArmour, FloatHealth, pWanted, cTime, Drugs, PlayerBombs } new PlayerInfo[MAX_PLAYERS][PCNR_user];