Account wird nicht geladen..

  • Account wird nicht geladen..

    Hay habe das Problem das mein Account aufeinmal nicht mehr geladen wird gestern gings ja noch, hab da aber noch ein Tutorial eingebaut und nicht getestet.. davor gings noch :X (hab auch versucht ohne das Tutorial klappt nicht..)
    Ausschnitt aus OnPlayerLogin:
    [pwn]
    print("Fange an Spieler zu laden..");
    new line[1024]; //I know it's big D=
    if(mysql_fetch_row(line)) //Fetches the line
    {
    print("fetch_row");
    new data[3][128]; //The data strings
    new d2[97]; //The data variables
    new Float:data3[5];
    print"sccanf start"); sscanf(line,"p|dssddddddddddddddddddddddddddddddddddddddddddddddddddffdddddddddddddddfffdddddddddddddddddddddddddddddddds",d2[94],data[0],data[0],d2[0],d2[1],d2[2],d2[3],d2[4],d2[5],d2[6],d2[7],d2[8],d2[9],d2[10],d2[11],d2[12],d2[13],d2[14],d2[15],d2[16],d2[17],d2[18],d2[19],d2[20],d2[21],d2[22],d2[23],d2[24],d2[25],d2[26],d2[27],d2[28],
    d2[29],d2[30],d2[31],d2[32],d2[33],d2[34],d2[35],d2[36],d2[37],d2[38],d2[39],d2[40],d2[41],d2[42],d2[43],d2[44],d2[45],d2[46],d2[47],d2[48],d2[49],data3[0],data3[1],d2[50],
    d2[51],d2[52],d2[53],d2[54],d2[55],d2[56],d2[57],d2[58],d2[59],d2[60],d2[61],d2[62],d2[63],d2[64],data3[2],data3[3],data3[4],d2[65],d2[66],d2[67],d2[68],d2[69],d2[70],d2[71],d2[72],d2[73],d2[74],d2[75],d2[76],d2[77],d2[78],d2[79],d2[80],d2[81],d2[82],d2[83],d2[84],d2[85],d2[86],d2[87],d2[88],d2[89],d2[90],d2[91],d2[92],d2[93],d2[94],d2[95],d2[96],data[2]);
    printf("%s",line);
    print("sscanf ende - setzte variablen");
    PlayerInfo[playerid][pLevel] = d2[0];
    PlayerInfo[playerid][pAdmin] = d2[1];
    PlayerInfo[playerid][pDonateRank] = d2[2];
    PlayerInfo[playerid][gPupgrade] = d2[3];
    PlayerInfo[playerid][pConnectTime] = d2[4];
    PlayerInfo[playerid][pReg] = d2[5];
    PlayerInfo[playerid][pSex] = d2[6];
    PlayerInfo[playerid][pAge] = d2[7];
    PlayerInfo[playerid][pOrigin] = d2[8];
    PlayerInfo[playerid][pCK] = d2[9];
    PlayerInfo[playerid][pMuted] = d2[10];
    PlayerInfo[playerid][pExp] = d2[11];
    PlayerInfo[playerid][pCash] = d2[12];
    PlayerInfo[playerid][pAccount] = d2[13];
    PlayerInfo[playerid][pCrimes] = d2[14];
    PlayerInfo[playerid][pKills] = d2[15];
    PlayerInfo[playerid][pSKills] = d2[16];
    PlayerInfo[playerid][pDeaths] = d2[17];
    PlayerInfo[playerid][pArrested] = d2[18];
    PlayerInfo[playerid][pWantedDeaths] = d2[19];
    PlayerInfo[playerid][pPhoneBook] = d2[20];
    PlayerInfo[playerid][pLottoNr] = d2[21];
    PlayerInfo[playerid][pFishes] = d2[22];
    PlayerInfo[playerid][pBiggestFish] = d2[23];
    PlayerInfo[playerid][pJob] = d2[24];
    PlayerInfo[playerid][pPayCheck] = d2[25];
    PlayerInfo[playerid][pHeadValue] = d2[26];
    PlayerInfo[playerid][pJailed] = d2[27];
    PlayerInfo[playerid][pJailTime] = d2[28];
    PlayerInfo[playerid][pMats] = d2[29];
    PlayerInfo[playerid][pSafeMats] = d2[30];
    PlayerInfo[playerid][pDrugs] = d2[31];
    PlayerInfo[playerid][pSafeDrugs] = d2[32];
    PlayerInfo[playerid][pLeader] = d2[33];
    PlayerInfo[playerid][pMember] = d2[34];
    PlayerInfo[playerid][pFMember] = d2[35];
    PlayerInfo[playerid][pRank] = d2[36];
    PlayerInfo[playerid][pChar] = d2[37];
    PlayerInfo[playerid][pContractTime] = d2[38];
    PlayerInfo[playerid][pDetSkill] = d2[39];
    PlayerInfo[playerid][pSexSkill] = d2[40];
    PlayerInfo[playerid][pBoxSkill] = d2[41];
    PlayerInfo[playerid][pLawSkill] = d2[42];
    PlayerInfo[playerid][pMechSkill] = d2[43];
    PlayerInfo[playerid][pJackSkill] = d2[44];
    PlayerInfo[playerid][pCarSkill] = d2[45];
    PlayerInfo[playerid][pNewsSkill] = d2[46];
    PlayerInfo[playerid][pDrugsSkill] = d2[47];
    PlayerInfo[playerid][pCookSkill] = d2[48];
    PlayerInfo[playerid][pFishSkill] = d2[49];
    PlayerInfo[playerid][pSHealth] = data3[0];
    PlayerInfo[playerid][pHealth] = data3[1];
    PlayerInfo[playerid][pInt] = d2[50];
    PlayerInfo[playerid][pLocal] = d2[51];
    PlayerInfo[playerid][pTeam] = d2[52];
    PlayerInfo[playerid][pModel] = d2[53];
    PlayerInfo[playerid][pPnumber] = d2[54];
    PlayerInfo[playerid][pPhousekey] = d2[55];
    PlayerInfo[playerid][pPbiskey] = d2[56];
    PlayerInfo[playerid][pFightstyle] = d2[57];
    PlayerInfo[playerid][pWanteds] = d2[58];
    PlayerInfo[playerid][pGangjail] = d2[59];
    PlayerInfo[playerid][pKidnap] = d2[60];
    PlayerInfo[playerid][pGutschein] = d2[61];
    PlayerInfo[playerid][pBan] = d2[62];
    PlayerInfo[playerid][pSpawnChange] = d2[63];
    PlayerInfo[playerid][pInviteSperre] = d2[64];
    PlayerInfo[playerid][pPos_x] = data3[2];
    PlayerInfo[playerid][pPos_y] = data3[3];
    PlayerInfo[playerid][pPos_z] = data3[4];
    PlayerInfo[playerid][pCarLic] = d2[65];
    PlayerInfo[playerid][pMotoLic] = d2[66];
    PlayerInfo[playerid][pLkwLic] = d2[67];
    PlayerInfo[playerid][pFlyLic] = d2[68];
    PlayerInfo[playerid][pBoatLic] = d2[69];
    PlayerInfo[playerid][pFishLic] = d2[70];
    PlayerInfo[playerid][pGunLic] = d2[71];
    PlayerInfo[playerid][pGun1] = d2[72];
    PlayerInfo[playerid][pGun2] = d2[73];
    PlayerInfo[playerid][pGun3] = d2[74];
    PlayerInfo[playerid][pGun4] = d2[75];
    PlayerInfo[playerid][pAmmo1] = d2[76];
    PlayerInfo[playerid][pAmmo2] = d2[77];
    PlayerInfo[playerid][pAmmo3] = d2[78];
    PlayerInfo[playerid][pAmmo4] = d2[79];
    PlayerInfo[playerid][pCarTime] = d2[80];
    PlayerInfo[playerid][pPayDay] = d2[81];
    PlayerInfo[playerid][pPayDayHad] = d2[82];
    PlayerInfo[playerid][pCDPlayer] = d2[83];
    PlayerInfo[playerid][pWins] = d2[84];
    PlayerInfo[playerid][pLoses] = d2[85];
    PlayerInfo[playerid][pAlcoholPerk] = d2[86];
    PlayerInfo[playerid][pDrugPerk] = d2[87];
    PlayerInfo[playerid][pMiserPerk] = d2[88];
    PlayerInfo[playerid][pPainPerk] = d2[89];
    PlayerInfo[playerid][pTraderPerk] = d2[90];
    PlayerInfo[playerid][pTut] = d2[91];
    PlayerInfo[playerid][pMissionNr] = d2[92];
    PlayerInfo[playerid][pWarns] = d2[93];
    PlayerInfo[playerid][pAdjustable] = d2[94];
    PlayerInfo[playerid][pFuel] = d2[95];
    PlayerInfo[playerid][pMarried] = d2[96];
    strdel(PlayerInfo[playerid][pMarriedTo],0,128);
    strins(PlayerInfo[playerid][pMarriedTo], data[2], 0, 128);
    print("Ende mit setzen");
    mysql_free_result();
    print("free result");
    }
    print("Spieler wurde erfolgreich geladen");
    [/pwn]
    In der Console steht nur
    [pwn]
    [18:35:00] OPLogin Start
    [18:35:00] Fange an Spieler zu laden..
    [18:35:00] fetch_row
    [18:35:00] sscanf start[/pwn]

    Mysql Debug:

    Quellcode

    1. [18:23:11] CMySQLHandler::Query(SELECT * FROM `players` WHERE `Name` = 'heidi' AND `Password` = '123') - Successfully executed.
    2. [18:23:11] >> mysql_store_result( Connection handle: 1 )
    3. [18:23:11] CMySQLHandler::StoreResult() - Result was stored.
    4. [18:23:11] >> mysql_num_rows( Connection handle: 1 )
    5. [18:23:11] CMySQLHandler::NumRows() - Returned 1 row(s)
    6. [18:23:11] >> mysql_fetch_row_format( Connection handle: 1 )
    7. [18:23:11] CMySQLHandler::FetchRow() - Return: 6|heidi|123|1|0|0|0|0|0|1|0|255|0|0|0|500|1000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|255|0|0|0|0|0|0|0|0|0|0|0|0|0|0|50.0|50.0|0|255|3|264|0|255|255|0|0|0|0|0|0|0|0|1684.9|-2244.5|13.5|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|No-one
    Alles anzeigen
  • dead schrieb:

    [pwn] new data[3][128]; //The data strings
    new d2[97]; //The data variables
    new Float:data3[5];[/pwn]
    Würde 105 Datensätzen entsprechen, in sscanf verwertest du aber 107.

    Daran liegts nicht... (2x data[0] & 2x d2[94])
    ich versteh nicht wieso das aufeinmal nicht mehr klappt -.- (Bei ner älteren Version vom GM klappts ja.. aber da ist eig fast alles gleich..)

    //Hab gestern Tacho,Motorrad/LKwSchein eingebaut.. und noch paar dinge an die ich mich grad nicht erinnern kann..
    Wenn ich die sscanf line und den rest vom älteren GM Backup rein mache klappts auch nicht :/
    So siehts in der Mysql_log aus dem GM Backup (kann mich da einloggen buggt aber bisschen weils dort die Scheine nicht gibt..)

    Quellcode

    1. [19:01:20] CMySQLHandler::FetchRow() - Return: 3|Tommyx3|pass|28|2000|0|44|4|1|1|0|1|0|0|4|49999950|50098|12|0|0|12|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|12|0|255|12|46|0|0|0|0|0|0|0|0|0|0|0|0|50.000000|99.000000|0|255|11|280|1337|255|255|0|0|0|0|0|0|0|0|1684.900024|-2244.500000|13.500000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|39|0|0|0|0|0|0|0|0|0|1|0|0|0|0|No-one
    2. [19:01:20] >> mysql_free_result( Connection handle: 1 )
    3. [19:01:20] CMySQLHandler::FreeResult() - Result was successfully free'd.

    dann wird der rest geladen..
    aber bei mir hörst ab da auf:

    Quellcode

    1. 3|Tommyx3|pass|28|2000|0|44|4|1|1|0|1|0|0|4|49999950|50098|12|0|0|12|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|12|0|255|12|46|0|0|0|0|0|0|0|0|0|0|0|0|50.000000|99.000000|0|255|11|280|1337|255|255|0|0|0|0|0|0|0|0|1684.900024|-2244.500000|13.500000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|39|0|0|0|0|0|0|0|0|0|1|0|0|0|0|No-one

    Dieser Beitrag wurde bereits 1 mal editiert, zuletzt von Tommyx3 ()