SA-MP Forums Archive
Login with mysql ... why you dont like me? o.o - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Login with mysql ... why you dont like me? o.o (/showthread.php?tid=106936)



Login with mysql ... why you dont like me? o.o - mirkoiz - 07.11.2009

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


Re: Login with mysql ... why you dont like me? o.o - StrickenKid - 07.11.2009

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.



Re: Login with mysql ... why you dont like me? o.o - mirkoiz - 07.11.2009


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


Re: Login with mysql ... why you dont like me? o.o - StrickenKid - 07.11.2009

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.....