MySQL Login problem - Printable Version

MySQL Login problem - 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)
+--- Thread: MySQL Login problem (/showthread.php?tid=495155)

MySQL Login problem - .EnjatsRed. - 16.02.2014

Hi there, I'm having some problem while I'm trying to log in .. I just simply type my password and nothing happens.

Here's my OnPlayerLogin:

PHP код:



public OnPlayerLogin(playerid,password[])

{

    new loginstring[256],playername2[MAX_PLAYER_NAME];

    GetPlayerName(playerid, playername2, sizeof(playername2));

    new string[ 400 ] ;

    new tmp2[256];

    new string2[64];

    format(string,400,"SELECT * FROM `players` WHERE `username` = '%s' AND `password` = '%s'",ReturnName(playerid),password);

    mysql_query(string);

    mysql_store_result();

    if(mysql_num_rows() >= 0)

    {

        new row[128];

        new field[116][64];

        mysql_fetch_row_format(row, "|");

        explode(row, field, "|");

        mysql_free_result();

        PlayerInfo[playerid][pLevel] = strval(field[4]);

        PlayerInfo[playerid][pAdmin] = strval(field[5]);

        PlayerInfo[playerid][pHelper] = strval(field[110]);

        PlayerInfo[playerid][pDonateRank] = strval(field[6]);

        PlayerInfo[playerid][gPupgrade] = strval(field[7]);

        PlayerInfo[playerid][pConnectTime] = strval(field[8]);

        PlayerInfo[playerid][pReg] = strval(field[9]);

        PlayerInfo[playerid][pSex] = strval(field[10]);

        PlayerInfo[playerid][pAge] = strval(field[11]);

        PlayerInfo[playerid][pOrigin] = strval(field[12]);

        PlayerInfo[playerid][pCK] = strval(field[13]);

        PlayerInfo[playerid][pMuted] = strval(field[14]);

        PlayerInfo[playerid][pExp] = strval(field[15]);

        PlayerInfo[playerid][pCash] = strval(field[16]);

        PlayerInfo[playerid][pAccount] = strval(field[17]);

        PlayerInfo[playerid][pCrimes] = strval(field[18]);

        PlayerInfo[playerid][pKills] = strval(field[19]);

        PlayerInfo[playerid][pDeaths] = strval(field[20]);

        PlayerInfo[playerid][pArrested] = strval(field[21]);

        PlayerInfo[playerid][pWantedDeaths] = strval(field[22]);

        PlayerInfo[playerid][pPhoneBook] = strval(field[23]);

        PlayerInfo[playerid][pLottoNr] = strval(field[24]);

        PlayerInfo[playerid][pFishes] = strval(field[25]);

        PlayerInfo[playerid][pBiggestFish] = strval(field[26]);

        PlayerInfo[playerid][pJob] = strval(field[27]);

        PlayerInfo[playerid][pPayCheck] = strval(field[28]);

        PlayerInfo[playerid][pHeadValue] = strval(field[29]);

        PlayerInfo[playerid][pJailed] = strval(field[30]);

        PlayerInfo[playerid][pJailTime] = strval(field[31]);

        PlayerInfo[playerid][pMats] = strval(field[32]);

        PlayerInfo[playerid][pDrugs] = strval(field[33]);

        PlayerInfo[playerid][pBoxMats] = strval(field[105]);

        PlayerInfo[playerid][pBoxDrugs] = strval(field[106]);

        PlayerInfo[playerid][pCompMission] = strval(field[87]);

        PlayerInfo[playerid][pLeader] = strval(field[34]);

        PlayerInfo[playerid][pMember] = strval(field[35]);

        PlayerInfo[playerid][pFMember] = strval(field[36]);

        PlayerInfo[playerid][pRank] = strval(field[37]);

        PlayerInfo[playerid][pChar] = strval(field[38]);

        PlayerInfo[playerid][pCRank] = strval(field[89]);

        PlayerInfo[playerid][pContractTime] = strval(field[39]);

        WantedLevel[playerid] = strval(field[98]);

        WantedPoints[playerid] = strval(field[99]);

        PlayerInfo[playerid][pDetSkill] = strval(field[40]);

        PlayerInfo[playerid][pSexSkill] = strval(field[41]);

        PlayerInfo[playerid][pBoxSkill] = strval(field[42]);

        PlayerInfo[playerid][pDMH] = strval(field[90]);

        PlayerInfo[playerid][pDMHTK] = strval(field[91]);

        PlayerInfo[playerid][pLawSkill] = strval(field[43]);

        PlayerInfo[playerid][pMechSkill] = strval(field[44]);

        PlayerInfo[playerid][pJackSkill] = strval(field[45]);

        PlayerInfo[playerid][pCarSkill] = strval(field[46]);

        PlayerInfo[playerid][pNewsSkill] = strval(field[47]);

        PlayerInfo[playerid][pDrugsSkill] = strval(field[48]);

        PlayerInfo[playerid][pCookSkill] = strval(field[39]);

        PlayerInfo[playerid][pFishSkill] = strval(field[50]);

        PlayerInfo[playerid][pSHealth] = floatstr(field[97]);

        PlayerInfo[playerid][pHealth] = floatstr(field[96]);

        PlayerInfo[playerid][pInt] = strval(field[107]);

        PlayerInfo[playerid][pLocal] = strval(field[51]);

        PlayerInfo[playerid][pTeam] = strval(field[52]);

        PlayerInfo[playerid][pModel] = strval(field[53]);

        PlayerInfo[playerid][pSpawnLoc] = strval(field[111]);

        PlayerInfo[playerid][pPnumber] = strval(field[92]);

        PlayerInfo[playerid][pPhousekey] = strval(field[93]);

        PlayerInfo[playerid][pPbiskey] = strval(field[112]);

        PlayerInfo[playerid][pCarLic] = strval(field[55]);

        PlayerInfo[playerid][pFlyLic] = strval(field[56]);

        PlayerInfo[playerid][pBoatLic] = strval(field[57]);

        PlayerInfo[playerid][pFishLic] = strval(field[58]);

        PlayerInfo[playerid][pGunLic] = strval(field[59]);

        PlayerInfo[playerid][pGun1] = strval(field[60]);

        PlayerInfo[playerid][pGun2] = strval(field[61]);

        PlayerInfo[playerid][pGun3] = strval(field[62]);

        PlayerInfo[playerid][pGun4] = strval(field[63]);

        PlayerInfo[playerid][pAmmo1] = strval(field[64]);

        PlayerInfo[playerid][pAmmo2] = strval(field[65]);

        PlayerInfo[playerid][pAmmo3] = strval(field[66]);

        PlayerInfo[playerid][pAmmo4] = strval(field[67]);

        PlayerInfo[playerid][pCarTime] = strval(field[68]);

        PlayerInfo[playerid][pPayDay] = strval(field[69]);

        PlayerInfo[playerid][pPayDayHad] = strval(field[70]);

        PlayerInfo[playerid][pCDPlayer] = strval(field[71]);

        PlayerInfo[playerid][pWins] = strval(field[72]);

        PlayerInfo[playerid][pKit] = strval(field[113]);

        PlayerInfo[playerid][pLoses] = strval(field[73]);

        PlayerInfo[playerid][pAlcoholPerk] = strval(field[74]);

        PlayerInfo[playerid][pDrugPerk] = strval(field[75]);

        PlayerInfo[playerid][pMiserPerk] = strval(field[76]);

        PlayerInfo[playerid][pPainPerk] = strval(field[77]);

        PlayerInfo[playerid][pTraderPerk] = strval(field[78]);

        PlayerInfo[playerid][pWarns] = strval(field[81]);

        PlayerInfo[playerid][pTut] = strval(field[79]);

        PlayerInfo[playerid][pMissionNr] = strval(field[114]);

        PlayerInfo[playerid][pAD] = strval(field[94]);

        PlayerInfo[playerid][pWarns] = strval(field[81]);

        PlayerInfo[playerid][pAdjustable] = strval(field[82]);

        PlayerInfo[playerid][pFuel] = strval(field[83]);

        PlayerInfo[playerid][pFACWarns] = strval(field[88]);

        PlayerInfo[playerid][pAWarns] = strval(field[109]);

        PlayerInfo[playerid][pMarried] = strval(field[84]);

        PlayerInfo[playerid][pRob] = strval(field[95]);

        PlayerInfo[playerid][pBG] = strval(field[103]);

        PlayerInfo[playerid][pCLUB] = strval(field[108]);

        PlayerInfo[playerid][pLocked] = strval(field[85]);

        PlayerInfo[playerid][pSec] = strval(field[115]);

        PlayerInfo[playerid][pFstyles] = strval(field[101]);

        PlayerInfo[playerid][pWstyles] = strval(field[100]);

        PlayerInfo[playerid][pBounty] = strval(field[102]);

     }

     else

     {

        new loginname[64];

        GetPlayerName(playerid,loginname,sizeof(loginname));

        format(loginstring,sizeof(loginstring),"PAROLA GRESITA\nTe rog baga parola corecta:",loginname);

        ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,"Login",loginstring,"Login","Exit");

          gPlayerLogTries[playerid] += 1;

          if(gPlayerLogTries[playerid] == 4) { Ban(playerid); }

        return 1;

      }

      PlayerInfo[playerid][pAdjustable] = 0;

      ResetPlayerMoney(playerid);

      ConsumingMoney[playerid] = 1;

      GivePlayerMoney(playerid,PlayerInfo[playerid][pCash]);

      CurrentMoney[playerid] = PlayerInfo[playerid][pCash];

          gPlayerLogged[playerid] = 1;

      SpawnPlayer(playerid);

      format(tmp2, sizeof(tmp2), "~w~Welcome ~n~~g~~h~ %s", playername2);

      DateProp(playerid);

      GameTextForPlayer(playerid, tmp2, 300, 1);

          return 1;

}

Re: MySQL Login problem - CuervO - 16.02.2014

What version of the SQL plugin are you using?

Re: MySQL Login problem - .EnjatsRed. - 16.02.2014

Quote:

Originally Posted by CuervO

What version of the SQL plugin are you using?

I'm using the R6 version.

Re: MySQL Login problem - .EnjatsRed. - 16.02.2014

Anyone, pls?

//It seems like there's no connection between MySQL DB and the server .. I'm just getting in game, set some money and /q.And there's no change in MySQL DB.
///I'm using WampServer for testing.
////Here's my SavePlayerData which is supposed to save the stats:

PHP код:



public SavePlayerData(playerid)

{

    new query[700];

    new Float:x, Float:y, Float:z;

    GetPlayerPos(playerid, x, y, z);

    format(query, 700, "UPDATE `players` SET `Level` = '%d', `AdminLevel` = '%d', `HelperLevel` = '%d', `DonateRank` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pHelper], PlayerInfo[playerid][pDonateRank], ReturnName(playerid));

    mysql_query(query);

    format(query, 700, "UPDATE `players` SET `Upgrade Points` = '%d', `ConnectedTime` = '%f', `Registered` = '%d', `Sex` = '%f', `Age` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][gPupgrade], PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pReg], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pAge], ReturnName(playerid));

    mysql_query(query);

    format(query, 700, "UPDATE `players` SET `Origin` = '%d', `CK` = '%d', `Muted` = '%d', `Exp` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pOrigin], PlayerInfo[playerid][pCK], PlayerInfo[playerid][pMuted], PlayerInfo[playerid][pExp], ReturnName(playerid));

    mysql_query(query);

       format(query, 700, "UPDATE `players` SET `Money` = '%d', `Bank` = '%d', `Crimes` = '%d', `Kills` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pCash], PlayerInfo[playerid][pAccount], PlayerInfo[playerid][pCrimes], PlayerInfo[playerid][pKills], ReturnName(playerid));

    mysql_query(query);

       format(query, 700, "UPDATE `players` SET `Deaths` = '%d', `Arrested` = '%d', `WantedDeaths` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pDeaths], PlayerInfo[playerid][pArrested], PlayerInfo[playerid][pWantedDeaths], ReturnName(playerid));

    mysql_query(query);

    format(query, 700, "UPDATE `players` SET `Phone Book` = '%d', `LotoNR` = '%d', `Fishes` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pPhoneBook], PlayerInfo[playerid][pLottoNr], PlayerInfo[playerid][pFishes], PlayerInfo[playerid][pBiggestFish], ReturnName(playerid));

    mysql_query(query);

    format(query, 700, "UPDATE `players` SET `Job` = '%d', `Paycheck` = '%d', `HeadValue` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pJob], PlayerInfo[playerid][pPayCheck], PlayerInfo[playerid][pHeadValue], ReturnName(playerid));

    mysql_query(query);

    format(query, 700, "UPDATE `players` SET `Jailed` = '%d', `JailTime` = '%d', `Mats` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pMats], ReturnName(playerid));

    mysql_query(query);

    format(query, 700, "UPDATE `players` SET `Drugs` = '%d', `BoxMats` = '%d', `BoxDrugs` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pDrugs], PlayerInfo[playerid][pBoxMats], PlayerInfo[playerid][pBoxDrugs], ReturnName(playerid));

    mysql_query(query);

       format(query, 700, "UPDATE `players` SET `CompMission` = '%d', `Leader` = '%d', `Member` = '%d', `FMember` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pCompMission], PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pMember], PlayerInfo[playerid][pFMember], ReturnName(playerid));

    mysql_query(query);

       format(query, 700, "UPDATE `players` SET `Rank` = '%d', `Char` = '%d', `CRank` = '%d', `ConnectedTime` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pRank], PlayerInfo[playerid][pChar], PlayerInfo[playerid][pCRank], PlayerInfo[playerid][pContractTime], ReturnName(playerid));

    mysql_query(query);

       format(query, 700, "UPDATE `players` SET `WantedLevel` = '%d', `WantedPoints` = '%d', `DetSkill` = '%d', `SexSkill` = '%d' WHERE `username` ='%s' ", WantedLevel[playerid], WantedPoints[playerid], PlayerInfo[playerid][pDetSkill], PlayerInfo[playerid][pSexSkill], ReturnName(playerid));

    mysql_query(query);

       format(query, 700, "UPDATE `players` SET `BoxSkill` = '%d', `DMH` = '%d', `DMHTK` = '%d', `LawSkill` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pBoxSkill], PlayerInfo[playerid][pDMH], PlayerInfo[playerid][pDMHTK], PlayerInfo[playerid][pLawSkill], ReturnName(playerid));

    mysql_query(query);

       format(query, 700, "UPDATE `players` SET `MechSkill` = '%d', `JackSkill` = '%d', `CarSkill` = '%d', `NewsSkill` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pMechSkill], PlayerInfo[playerid][pJackSkill], PlayerInfo[playerid][pCarSkill], PlayerInfo[playerid][pNewsSkill], ReturnName(playerid));

    mysql_query(query);

       format(query, 700, "UPDATE `players` SET `DrugsSkill` = '%d', `CookSkill` = '%d', `FishSkill` = '%d', `SHPS` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pDrugsSkill], PlayerInfo[playerid][pCookSkill], PlayerInfo[playerid][pFishSkill], PlayerInfo[playerid][pSHealth], ReturnName(playerid));

    mysql_query(query);

       format(query, 700, "UPDATE `players` SET `HP` = '%d', `Interior` = '%d', `Local` = '%d', `Team` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pHealth], PlayerInfo[playerid][pInt], PlayerInfo[playerid][pLocal], PlayerInfo[playerid][pTeam], ReturnName(playerid));

    mysql_query(query);

       format(query, 700, "UPDATE `players` SET `Model` = '%d', `SpawnLoc` = '%d', `Pnumber` = '%d', `PHouseKey` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pModel], PlayerInfo[playerid][pSpawnLoc], PlayerInfo[playerid][pPnumber], PlayerInfo[playerid][pPhousekey], ReturnName(playerid));

    mysql_query(query);

       format(query, 700, "UPDATE `players` SET `BizKey` = '%d', `CarLic` = '%d', `FlyLic` = '%d', `BoatLic` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pPbiskey], PlayerInfo[playerid][pCarLic], PlayerInfo[playerid][pFlyLic], PlayerInfo[playerid][pBoatLic], ReturnName(playerid));

    mysql_query(query);

       format(query, 700, "UPDATE `players` SET `FishLic` = '%d', `GunLic` = '%d', `Gun1` = '%d', `Gun2` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pFishLic], PlayerInfo[playerid][pGunLic], PlayerInfo[playerid][pGun1], PlayerInfo[playerid][pGun2], ReturnName(playerid));

    mysql_query(query);

    format(query, 700, "UPDATE `players` SET `FishLic` = '%d', `GunLic` = '%d', `Gun1` = '%d', `Gun2` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pFishLic], PlayerInfo[playerid][pGunLic], PlayerInfo[playerid][pGun1], PlayerInfo[playerid][pGun2], ReturnName(playerid));

    mysql_query(query);

    format(query, 700, "UPDATE `players` SET `Gun4` = '%d', `Ammo1` = '%d', `Ammo2` = '%d', `Ammo3` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pGun4], PlayerInfo[playerid][pAmmo1], PlayerInfo[playerid][pAmmo3], ReturnName(playerid));

    mysql_query(query);

    format(query, 700, "UPDATE `players` SET `Ammo4` = '%d', `CarTime` = '%d', `PayDay` = '%d', `PayDayHad` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pAmmo4], PlayerInfo[playerid][pCarTime], PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pPayDayHad], ReturnName(playerid));

    mysql_query(query);

    format(query, 700, "UPDATE `players` SET `CDPlayer` = '%d', `Wins` = '%d', `Kit` = '%d', `Loses` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pCDPlayer], PlayerInfo[playerid][pWins], PlayerInfo[playerid][pKit], PlayerInfo[playerid][pLoses], ReturnName(playerid));

    mysql_query(query);

    format(query, 700, "UPDATE `players` SET `AlcoholPerk` = '%d', `DrugPerk` = '%d', `MiserPerk` = '%d', `PainPerk` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pAlcoholPerk], PlayerInfo[playerid][pDrugPerk], PlayerInfo[playerid][pMiserPerk], PlayerInfo[playerid][pPainPerk],  ReturnName(playerid));

    mysql_query(query);

    format(query, 700, "UPDATE `players` SET `TraderPerk` = '%d', `Warns` = '%d', `Tut` = '%d', `MissionNr` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pTraderPerk], PlayerInfo[playerid][pWarns], PlayerInfo[playerid][pTut], PlayerInfo[playerid][pMissionNr], ReturnName(playerid));

    mysql_query(query);

    format(query, 700, "UPDATE `players` SET `AD` = '%d', `Adjustable` = '%d', `Fuel` = '%d', `FACWarns` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pAD], PlayerInfo[playerid][pAdjustable], PlayerInfo[playerid][pFuel], PlayerInfo[playerid][pFACWarns], ReturnName(playerid));

    mysql_query(query);

    format(query, 700, "UPDATE `players` SET `AWarns` = '%d', `Married` = '%d', `Rob` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pAWarns], PlayerInfo[playerid][pMarried], PlayerInfo[playerid][pRob], ReturnName(playerid));

    mysql_query(query);

    format(query, 700, "UPDATE `players` SET `BG` = '%d', `Club` = '%d', `Locked` = '%d', `Sec` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pBG], PlayerInfo[playerid][pCLUB], PlayerInfo[playerid][pLocked], PlayerInfo[playerid][pSec], ReturnName(playerid));

    mysql_query(query);

    format(query, 700, "UPDATE `players` SET `FStyles` = '%d', `WStyles` = '%d', `Bounty` = '%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pFstyles], PlayerInfo[playerid][pWstyles], PlayerInfo[playerid][pBounty], ReturnName(playerid));

    mysql_query(query);

    mysql_free_result();

    return 1;

}

Re: MySQL Login problem - .EnjatsRed. - 17.02.2014

Can any1 help me pls?