[mirkoiz]

Okay, my first problem is solved...

now i have another problem...
i have this:

pawn Код:

new Float:Pickups[][PickInfo] = {
{1,1726.9751,-1636.3334,20.2171,0,1726.9526,-1638.7334,20.2234,18},
{2,2351.9111,-1168.9744,27.9920,0,2350.7036,-1181.1886,1027.9766,5},
{3,1553.6572,-1675.6367,16.1953,0,288.745971,169.350997,1007.171875,3},
{4,1258.3425,-785.4657,92.0302,0,1262.1348,-785.3854,1091.9063,5},
{5,1298.6053,-798.9628,84.1406,0,1299.1544,-795.9728,1084.0078,5},
{6,1929.5431,-1776.2677,13.5469,0,-27.3968,-30.2565,1003.5573,},
{7,1832.5872,-1842.0410,13.5781,0,-31.0414,-90.7142,1003.5469,180},
{8,1835.8566,-1681.8176,13.3723,0,493.6534,-23.5046,1000.6797,17},
{9,1739.3409,-1582.5289,14.1552,0,384.808624,173.804992,1008.382812,3},
{10,1572.2260,-1334.8035,16.4844,0,1548.6030,-1365.5646,326.2109,0},
{11,1698.5256,-1667.8107,20.1945,0,1701.5145,-1667.8511,20.2188,18}
};

and this

pawn Код:

for(new i=0; i<PLAYERS; i++)
    {
        for(new buildingid = 0; buildingid<MAX_BUILD_PICKUPS;buildingid++)
        {
            if(PickupsActive[i] == 1)
            {
                if(PlayerToPoint(2, i, Pickups[buildingid][EnterX], Pickups[buildingid][EnterY], Pickups[buildingid][EnterZ]))
                {
                    SetPlayerPos(i, Pickups[buildingid][ExitX], Pickups[buildingid][ExitY], Pickups[buildingid][ExitZ]);
                    SetPlayerInterior(i, Pickups[buildingid][ExitInt]);
                PickupsActive[i] = 0;
                    SetTimerEx("EnablePickupsAgain",5000,0,"i",i);
                }
                else if(PlayerToPoint(2, i, Pickups[buildingid][ExitX], Pickups[buildingid][ExitY], Pickups[buildingid][ExitZ]))
                {
                    SetPlayerPos(i, Pickups[buildingid][EnterX], Pickups[buildingid][EnterY], Pickups[buildingid][EnterZ]);
                    SetPlayerInterior(i, Pickups[buildingid][EnterInt]);
                PickupsActive[i] = 0;
                    SetTimerEx("EnablePickupsAgain",5000,0,"i",i);
                }
            }
        }
    }

Problem: Sometimes i get teleported, sometimes not :P

[StrickenKid]

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.

[mirkoiz]

ahh, this is a question from me... will the lower let mysql ignore if the nickname is Lower or Highercase?

[StrickenKid]

Quote:

Originally Posted by ►☺◄©ookie►☺◄ ahh, this is a question from me... will the lower let mysql ignore if the nickname is Lower or Highercase?

Yes, like i said:

Quote:

oh and I also added "LOWER()" tags within the mysql query so it will ignore case, you can take it out of you want.

So, if you register an account with "cookie", you can login with "Cookie", "COOKIE", "CoOkIe", etc.....