1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
OnPlayerLogin that does not load
TomyZ
Little Clucker
**
Posts: 28
Threads: 4
Joined: Feb 2011
Reputation: 0
#1

29.05.2012, 08:40
Hi all,

Today in my coding OnPlayerLogin, I have a problem ..
When I login with my account, no data is loaded and I start the tutorial every time ..

Here's the code:

pawn Код:
public OnPlayerLogin(playerid,password[])
{
    printf("Prinft 4");
    MySQLCheckConnection();
    printf("Prinft 5");
    new tmp2[256],playername2[MAX_PLAYER_NAME],playerip[20];
    printf("Prinft 6");
    GetPlayerName(playerid,playername2,sizeof(playername2));
    printf("Prinft 7");
    MySQLFetchAcctSingle(PlayerInfo[playerid][pSQLID], "password", PlayerInfo[playerid][pKey]);
    printf("Prinft 8");
    if(strlen(password) > 1 && strcmp(PlayerInfo[playerid][pKey],password, false ) == 0 )
    {
        new Data[2048],Field[65],query[64];
        format(query, sizeof(query), "SELECT * FROM players_accounts WHERE id = %d LIMIT 1", PlayerInfo[playerid][pSQLID]);
        mysql_query(query);
        printf("Prinft 9");
        mysql_store_result();
        printf("Prinft 10");
        if(mysql_fetch_row(Data))
        {
            printf("Prinft 11");
            mysql_get_field("niveau",Field); PlayerInfo[playerid][pNiveau] = strval(Field);
            printf("Prinft 12");
            mysql_get_field("adminlevel",Field); PlayerInfo[playerid][pAdministrateur] = strval(Field);
            printf("Prinft 13");
            mysql_get_field("autoriser",Field); PlayerInfo[playerid][pAutoriser] = strval(Field);
            printf("Prinft 14");
            mysql_get_field("donaterank",Field); PlayerInfo[playerid][pDonateRank] = strval(Field);
            printf("Prinft 15");
            mysql_get_field("donateur",Field); PlayerInfo[playerid][pDonateur] = strval(Field);
            printf("Prinft 16");
            mysql_get_field("upgradepoints",Field); PlayerInfo[playerid][gPupgrade] = strval(Field);
            printf("Prinft 17");
            mysql_get_field("connectedtime",Field); PlayerInfo[playerid][pConnectTime] = strval(Field);
            mysql_get_field("registered",Field); PlayerInfo[playerid][pReg] = strval(Field);
            mysql_get_field("sex",Field); PlayerInfo[playerid][pSex] = strval(Field);
            mysql_get_field("age",Field); PlayerInfo[playerid][pAge] = strval(Field);
            mysql_get_field("poids",Field); PlayerInfo[playerid][pPoids] = strval(Field);
            mysql_get_field("taillea",Field); PlayerInfo[playerid][pTailleA] = strval(Field);
            mysql_get_field("tailleb",Field); PlayerInfo[playerid][pTailleB] = strval(Field);
            mysql_get_field("origin",Field); PlayerInfo[playerid][pOrigin] = strval(Field);
            mysql_get_field("ck",Field); PlayerInfo[playerid][pBiere] = strval(Field);
            mysql_get_field("muted",Field); PlayerInfo[playerid][pMuted] = strval(Field);
            mysql_get_field("mutedtemps",Field); PlayerInfo[playerid][pMutedTemps] = strval(Field);
            mysql_get_field("mutedcmd",Field); PlayerInfo[playerid][pMutedCmd] = strval(Field);
            mysql_get_field("mutedcmdtemps",Field); PlayerInfo[playerid][pMutedCmdTemps] = strval(Field);
            mysql_get_field("respect",Field); PlayerInfo[playerid][pExp] = strval(Field);
            mysql_get_field("money",Field); PlayerInfo[playerid][pCash] = strval(Field);
            mysql_get_field("banks",Field); PlayerInfo[playerid][pAccount] = strval(Field);
            mysql_get_field("crimes",Field); PlayerInfo[playerid][pCrimes] = strval(Field);
            mysql_get_field("kills",Field); PlayerInfo[playerid][pKills] = strval(Field);
            mysql_get_field("deaths",Field); PlayerInfo[playerid][pDeaths] = strval(Field);
            mysql_get_field("arrested",Field); PlayerInfo[playerid][pArrested] = strval(Field);
            mysql_get_field("wanteddeaths",Field); PlayerInfo[playerid][pWantedDeaths] = strval(Field);
            mysql_get_field("phonebook",Field); PlayerInfo[playerid][pPhoneBook] = strval(Field);
            mysql_get_field("lottonr",Field); PlayerInfo[playerid][pLottoNr] = strval(Field);
            mysql_get_field("fishes",Field); PlayerInfo[playerid][pFishes] = strval(Field);
            mysql_get_field("biggestfish",Field); PlayerInfo[playerid][pBiggestFish] = strval(Field);
            mysql_get_field("job",Field); PlayerInfo[playerid][pJob] = strval(Field);
            mysql_get_field("paycheck",Field); PlayerInfo[playerid][pPayCheck] = strval(Field);
            mysql_get_field("headvalue",Field); PlayerInfo[playerid][pHeadValue] = strval(Field);
            mysql_get_field("jailed",Field); PlayerInfo[playerid][pJailed] = strval(Field);
            mysql_get_field("jailtime",Field); PlayerInfo[playerid][pJailTime] = strval(Field);
            mysql_get_field("materials",Field); PlayerInfo[playerid][pMats] = strval(Field);
            mysql_get_field("drugs",Field); PlayerInfo[playerid][pDrugs] = strval(Field);
            mysql_get_field("leader",Field); PlayerInfo[playerid][pChefFaction] = strval(Field);
            mysql_get_field("member",Field); PlayerInfo[playerid][pMembreFaction] = strval(Field);
            mysql_get_field("fmember",Field); PlayerInfo[playerid][pFMember] = strval(Field);
            mysql_get_field("rank",Field); PlayerInfo[playerid][pRank] = strval(Field);
            mysql_get_field("chara",Field); PlayerInfo[playerid][pChar] = strval(Field);
            mysql_get_field("skin",Field); PlayerInfo[playerid][pSkin] = strval(Field);
            mysql_get_field("contracttime",Field); PlayerInfo[playerid][pContractTime] = strval(Field);
            mysql_get_field("wantedniveau",Field); PlayerInfo[playerid][pWantedPoint] = strval(Field);
            mysql_get_field("detskill",Field); PlayerInfo[playerid][pDetSkill] = strval(Field);
            mysql_get_field("sexskill",Field); PlayerInfo[playerid][pSexSkill] = strval(Field);
            mysql_get_field("boxskill",Field); PlayerInfo[playerid][pBoxSkill] = strval(Field);
            mysql_get_field("lawskill",Field); PlayerInfo[playerid][pLawSkill] = strval(Field);
            mysql_get_field("mechskill",Field); PlayerInfo[playerid][pMechSkill] = strval(Field);
            mysql_get_field("jackskill",Field); PlayerInfo[playerid][pJackSkill] = strval(Field); // On s'arrкte ici grigo
            mysql_get_field("carskill",Field); PlayerInfo[playerid][pCarSkill] = strval(Field);
            mysql_get_field("newsskill",Field); PlayerInfo[playerid][pNewsSkill] = strval(Field);
            mysql_get_field("drugsskill",Field); PlayerInfo[playerid][pDrugsSkill] = strval(Field);
            mysql_get_field("cookskill",Field); PlayerInfo[playerid][pCookSkill] = strval(Field);
            mysql_get_field("fishskill",Field); PlayerInfo[playerid][pFishSkill] = strval(Field);
            mysql_get_field("pshealth",Field); PlayerInfo[playerid][pSHealth] = strval(Field);
            mysql_get_field("phealth",Field); PlayerInfo[playerid][pHealth] = strval(Field);
            mysql_get_field("inta",Field); PlayerInfo[playerid][pInt] = strval(Field);
            mysql_get_field("local",Field); PlayerInfo[playerid][pLocal] = strval(Field);
            mysql_get_field("team",Field); PlayerInfo[playerid][pTeam] = strval(Field);
            mysql_get_field("model",Field); PlayerInfo[playerid][pModel] = strval(Field);
            mysql_get_field("phonenr",Field); PlayerInfo[playerid][pPnumber] = strval(Field);
            mysql_get_field("car",Field); PlayerInfo[playerid][pPcarkey] = strval(Field);
            mysql_get_field("changepass",Field); PlayerInfo[playerid][pChangePass] = strval(Field);
            mysql_get_field("plaque",Field); PlayerInfo[playerid][pPlaque] = strval(Field);
            mysql_get_field("house",Field); PlayerInfo[playerid][pPhousekey] = strval(Field);
            mysql_get_field("bizz",Field); PlayerInfo[playerid][pPbiskey] = strval(Field);
            mysql_get_field("pos_x",Field); PlayerInfo[playerid][pPos_x] = strval(Field);
            mysql_get_field("pos_y",Field); PlayerInfo[playerid][pPos_y] = strval(Field);
            mysql_get_field("pos_z",Field); PlayerInfo[playerid][pPos_z] = strval(Field);
            mysql_get_field("carlic",Field); PlayerInfo[playerid][pVoitureLic] = strval(Field);
            mysql_get_field("flylic",Field); PlayerInfo[playerid][pFlyLic] = strval(Field);
            mysql_get_field("boatlic",Field); PlayerInfo[playerid][pBoatLic] = strval(Field);
            mysql_get_field("fishlic",Field); PlayerInfo[playerid][pFishLic] = strval(Field);
            mysql_get_field("gunlic",Field); PlayerInfo[playerid][pGunLic] = strval(Field);
            mysql_get_field("gun1",Field); PlayerInfo[playerid][pGun1] = strval(Field);
            mysql_get_field("gun2",Field); PlayerInfo[playerid][pGun2] = strval(Field);
            mysql_get_field("gun3",Field); PlayerInfo[playerid][pGun3] = strval(Field);
            mysql_get_field("gun4",Field); PlayerInfo[playerid][pGun4] = strval(Field);
            mysql_get_field("ammo1",Field); PlayerInfo[playerid][pAmmo1] = strval(Field);
            mysql_get_field("ammo2",Field); PlayerInfo[playerid][pAmmo2] = strval(Field);
            mysql_get_field("ammo3",Field); PlayerInfo[playerid][pAmmo3] = strval(Field);
            mysql_get_field("ammo4",Field); PlayerInfo[playerid][pAmmo4] = strval(Field);
            mysql_get_field("cartime",Field); PlayerInfo[playerid][pCarTime] = strval(Field);
            mysql_get_field("payday",Field); PlayerInfo[playerid][pPayDay] = strval(Field);
            mysql_get_field("paydayhad",Field); PlayerInfo[playerid][pPayDayHad] = strval(Field);
            mysql_get_field("cdplayer",Field); PlayerInfo[playerid][pCDPlayer] = strval(Field);
            mysql_get_field("wins",Field); PlayerInfo[playerid][pWins] = strval(Field);
            mysql_get_field("loses",Field); PlayerInfo[playerid][pLoses] = strval(Field);
            mysql_get_field("alcoholperk",Field); PlayerInfo[playerid][pAlcoholPerk] = strval(Field);
            mysql_get_field("drugperk",Field); PlayerInfo[playerid][pDrugPerk] = strval(Field);
            mysql_get_field("miserperk",Field); PlayerInfo[playerid][pMiserPerk] = strval(Field);
            mysql_get_field("painperk",Field); PlayerInfo[playerid][pPainPerk] = strval(Field);
            mysql_get_field("radio",Field); PlayerInfo[playerid][pRadio] = strval(Field);
            mysql_get_field("posx",Field); PlayerInfo[playerid][pPosX] = strval(Field);
            mysql_get_field("posy",Field); PlayerInfo[playerid][pPosY] = strval(Field);
            mysql_get_field("posz",Field); PlayerInfo[playerid][pPosZ] = strval(Field);
            mysql_get_field("argent",Field); PlayerInfo[playerid][pArgent] = strval(Field);
            mysql_get_field("monde",Field); PlayerInfo[playerid][pMonde] = strval(Field);
            mysql_get_field("tarderperk",Field); PlayerInfo[playerid][pTraderPerk] = strval(Field);
            mysql_get_field("tutorial",Field); PlayerInfo[playerid][pTut] = strval(Field);
            mysql_get_field("mission",Field); PlayerInfo[playerid][pMissionNr] = strval(Field);
            mysql_get_field("warnings",Field); PlayerInfo[playerid][pWarns] = strval(Field);
            mysql_get_field("adjustable",Field); PlayerInfo[playerid][pAdjustable] = strval(Field);
            mysql_get_field("fuel",Field); PlayerInfo[playerid][pFuel] = strval(Field);
            mysql_get_field("married",Field); PlayerInfo[playerid][pMarried] = strval(Field);
            mysql_get_field("marriedto",Field); strmid(PlayerInfo[playerid][pMarriedTo], Field, 0, strlen(Field), 255);
            mysql_get_field("pointamelioration",Field); PlayerInfo[playerid][pPointAmelioration] = strval(Field);
            mysql_get_field("pointcourse",Field); PlayerInfo[playerid][pPointCourse] = strval(Field);
            mysql_get_field("pass",Field); strmid(PlayerInfo[playerid][pPass], Field, 0, strlen(Field), 255);
            mysql_get_field("cigarre",Field); PlayerInfo[playerid][pCigarre] = strval(Field);
            mysql_get_field("teteaprix",Field); PlayerInfo[playerid][pTeteAPrix] = strval(Field);
            mysql_get_field("bateaukey",Field); PlayerInfo[playerid][pBateauKey] = strval(Field);
            mysql_get_field("titrefamille",Field); strmid(PlayerInfo[playerid][pTitre], Field, 0, strlen(Field), 255);
            mysql_get_field("banmotif",Field); strmid(PlayerInfo[playerid][pBMotif], Field, 0, strlen(Field), 255);
            mysql_get_field("timestamp",Field); PlayerInfo[playerid][pTimeStamp] = strval(Field);
            mysql_get_field("motifjail",Field); strmid(PlayerInfo[playerid][pJMotif], Field, 0, strlen(Field), 255);
            mysql_get_field("reduchopital",Field); PlayerInfo[playerid][pHExpir] = strval(Field);
        }
        gPlayerLogged[playerid] = 1;
    }
For all that I help, I thank their advance.
Sorry for the mistakes, I'm french

Sincerely, TomyZ.
Find
Reply
TomyZ
Little Clucker
**
Posts: 28
Threads: 4
Joined: Feb 2011
Reputation: 0
#2

29.05.2012, 09:42
forward OnPlayerLogin(playerid,password[]);

OnPlayerLogin loading stops at 10 prinft. So what does the loop DATA not fire.
Find
Reply
TomyZ
Little Clucker
**
Posts: 28
Threads: 4
Joined: Feb 2011
Reputation: 0
#3

29.05.2012, 09:52
Oh, I just figured out the call here.

pawn Код:
if(strlen(inputtext) && strlen(inputtext) <= 20)
                    {
                        printf("Print 1");
                        Encrypt(inputtext);
                        printf("Prinft 2");
                        OnPlayerLogin(playerid, inputtext);
                        printf("Prinft 3");
                    }
Find
Reply
[HiC]TheKiller
High-roller
*****
Posts: 2,629
Threads: 40
Joined: Mar 2008
Reputation: 0
#4

29.05.2012, 10:08
Make sure PlayerInfo[playerid][pSQLID] is set to the right id, try printing that and print mysql_num_rows to see if it's actually getting any rows to fetch in the first place.

EDIT: Why do you use mysql_fetch_row then obtain the data with mysql_get_field anyway? It's pretty pointless having mysql_fetch_row in the first place, just use
pawn Код:
if(mysql_num_rows() != 0)
instead.
Find
Reply
TomyZ
Little Clucker
**
Posts: 28
Threads: 4
Joined: Feb 2011
Reputation: 0
#5

29.05.2012, 10:37
( Последний раз редактировалось JaTochNietDan; 29.05.2012 в 17:37. Причина: Use the edit button instead of double posting. )
This is the same, the account is responsible, but what sets it to 0 and then I pass the tutorial.

The Prinft 11 to 17 do not appear on the console, so the problem just the loop I think ..
Find
Reply
TomyZ
Little Clucker
**
Posts: 28
Threads: 4
Joined: Feb 2011
Reputation: 0
#6

29.05.2012, 17:39
Yes, but to know where the problem is, how can I do?
Since the end of the forward, is to return 1;. A bit more help please
Find
Reply
JaTochNietDan
High-roller
*****
Posts: 2,502
Threads: 26
Joined: Apr 2007
Reputation: 0
#7

29.05.2012, 17:39
What's the value PlayerInfo[playerid][pSQLID]?

Print it please, then check your table to see if the ID is the same as in the table.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help