Login with mysql ... why you dont like me? o.o
#2

This would be the correct way to do what 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();
        }
oh and I also added "LOWER()" tags within the mysql query so it will ignore case, you can take it out of you want.
Reply


Messages In This Thread
Login with mysql ... why you dont like me? o.o - by mirkoiz - 07.11.2009, 00:40
Re: Login with mysql ... why you dont like me? o.o - by StrickenKid - 07.11.2009, 01:48
Re: Login with mysql ... why you dont like me? o.o - by mirkoiz - 07.11.2009, 10:56
Re: Login with mysql ... why you dont like me? o.o - by StrickenKid - 07.11.2009, 15:48

Forum Jump:


Users browsing this thread: 1 Guest(s)