07.11.2009, 01:48
This would be the correct way to do what you want:
oh and I also added "LOWER()" tags within the mysql query so it will ignore case, you can take it out of you want.
pawn Код:
new
pName1[MAX_PLAYER_NAME];
resultline[512],
player[35][32];
GetPlayerName(playerid,pName1,sizeof(pName1));
format(query,sizeof(query),"SELECT * FROM `***CENSORED***` WHERE LOWER(Username) = LOWER('%s') LIMIT 1", LoginplayerName);
mysql_query(query);
mysql_store_result();
if (mysql_fetch_row_format(resultline, "|"))
{
split(resultline, player, '|');
PlayerInfo[playerid][pKey] = strval(player[2]);
PlayerInfo[playerid][pAdmin] = strval(player[3]);
PlayerInfo[playerid][pcomportment] = strval(player[4]);
PlayerInfo[playerid][pgunlic] = strval(player[5]);
PlayerInfo[playerid][pCash] = strval(player[6]);
PlayerInfo[playerid][pHit] = strval(player[7]);
PlayerInfo[playerid][pJailed] = strval(player[8]);
PlayerInfo[playerid][pJailTime] = strval(player[9]);
PlayerInfo[playerid][pSkin] = strval(player[10]);
PlayerInfo[playerid][pTeam] = strval(player[11]);
PlayerInfo[playerid][pgivensigs] = strval(player[12]);
PlayerInfo[playerid][pgotecard] = strval(player[13]);
PlayerInfo[playerid][plastloginday] = strval(player[14]);
PlayerInfo[playerid][plastloginmonth] = strval(player[15]);
PlayerInfo[playerid][plastloginyear] = strval(player[16]);
PlayerInfo[playerid][vehlica] = strval(player[17]);
PlayerInfo[playerid][vehlicb] = strval(player[18]);
PlayerInfo[playerid][vehlicc] = strval(player[19]);
PlayerInfo[playerid][vehlicd] = strval(player[20]);
PlayerInfo[playerid][vehlice] = strval(player[21]);
PlayerInfo[playerid][vehlicf] = strval(player[22]);
PlayerInfo[playerid][pGun1] = strval(player[23]);
PlayerInfo[playerid][pGun2] = strval(player[24]);
PlayerInfo[playerid][pGun3] = strval(player[25]);
PlayerInfo[playerid][pGun4] = strval(player[26]);
PlayerInfo[playerid][pAmmo1] = strval(player[27]);
PlayerInfo[playerid][pAmmo2] = strval(player[28]);
PlayerInfo[playerid][pAmmo3] = strval(player[29]);
PlayerInfo[playerid][pAmmo4] = strval(player[30]);
PlayerInfo[playerid][pWanted] = strval(player[31]);
PlayerInfo[playerid][pEmail] = strval(player[32]);
mysql_free_result();
}