MySql SavePlayer Error Fehler

Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!

Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link
  • Hallo Community,


    ich habe alle meine Sachen eingetragen, aber ich kriege am schluss von der mysql log immer diesen Fehler:


    SQL
    [11:14:24] CMySQLHandler::FreeResult() - Result was successfully free'd.
    
    
    [11:14:24] >> mysql_fetch_row_format( Connection handle: 1 )
    
    
    [11:14:24] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)


    Meine Speicherung:


    stock SavePlayer(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    if(GetPVarInt(playerid,"Eingeloggt") == 1)
    {
    //#define pl PlayerInfo[playerid]
    new query[1024], stringzusammen[6000];
    GetPlayerName(playerid,pname,sizeof(pname));
    format(query,sizeof query,"UPDATE `accounts` SET `name`='%s', `pid`='%d', `pLevel`='%d', `pBanned`='%d', `pAdmin`='%d', `pSupporter`='%d', `pDonateRank`='%d', `gPupgrade`='%d', `pConnectTime`='%d', `pReg`='%d', `pSex`='%d', `pAge`='%d', `pOrigin`='%d', `pCK`='%d', `pMuted`='%d', `pExp`='%d', `pCash`='%d', `pAccount`='%d', `pPlayerKreditDauer`='%d', `pPlayerKredit`='%d', `pCrimes`='%d', `pKills`='%d', `pDeaths`='%d', `pArrested`='%d' ,`pWantedDeaths`='%d',`pPhoneBook`='%d',`pLottoNr`='%d',",
    pname,PlayerInfo[playerid][pid],PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pBanned],PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pSupporter],PlayerInfo[playerid][pDonateRank],PlayerInfo[playerid][gPupgrade],PlayerInfo[playerid][pConnectTime],PlayerInfo[playerid][pReg],
    PlayerInfo[playerid][pSex],PlayerInfo[playerid][pAge],PlayerInfo[playerid][pOrigin],PlayerInfo[playerid][pCK],PlayerInfo[playerid][pMuted],PlayerInfo[playerid][pExp],GetPlayerMoney(playerid),PlayerInfo[playerid][pAccount],PlayerInfo[playerid][pPlayerKreditDauer],
    PlayerInfo[playerid][pPlayerKredit],PlayerInfo[playerid][pCrimes],PlayerInfo[playerid][pKills],PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pArrested],PlayerInfo[playerid][pWantedDeaths],PlayerInfo[playerid][pPhoneBook],PlayerInfo[playerid][pLottoNr]);
    strcat(stringzusammen,query);
    strdel(query,0,sizeof(query));
    format(query,sizeof query,"`pFishes`='%d',`pBiggestFish`='%d',`pJob`='%d',`pPayCheck`='%d',`pHeadValue`='%d',`pJailed`='%d',`pRobTime`='%d',`pJailTime`='%d',`pDuty`='%d',`pGangJailed`='%d',`pwJailed`='%d',`pMauled`='%d',`pMats`='%d',`pRadio`='%d',`pNavi`='%d',`pDrugs`='%d',`pLeader`='%d',`pMember`='%d',`pFMember`='%d',`pRank`='%d',`pChar`='%d',`pContractTime`='%d',`pDetSkill`='%d',`pSexSkill`='%d',`pBoxSkill`='%d',`pLawSkill`='%d',`pMechSkill`='%d',`pJackSkill`='%d',",
    PlayerInfo[playerid][pFishes],PlayerInfo[playerid][pBiggestFish],PlayerInfo[playerid][pJob],PlayerInfo[playerid][pPayCheck],PlayerInfo[playerid][pHeadValue],PlayerInfo[playerid][pJailed],PlayerInfo[playerid][pRobTime],PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pDuty],
    PlayerInfo[playerid][pGangJailed],PlayerInfo[playerid][pwJailed],PlayerInfo[playerid][pMauled],PlayerInfo[playerid][pMats],PlayerInfo[playerid][pRadio],PlayerInfo[playerid][pNavi],PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember],PlayerInfo[playerid][pFMember],
    PlayerInfo[playerid][pRank],PlayerInfo[playerid][pChar],PlayerInfo[playerid][pContractTime],PlayerInfo[playerid][pDetSkill],PlayerInfo[playerid][pSexSkill],PlayerInfo[playerid][pBoxSkill],PlayerInfo[playerid][pLawSkill],PlayerInfo[playerid][pMechSkill],PlayerInfo[playerid][pJackSkill]);
    strcat(stringzusammen,query);
    strdel(query,0,sizeof(query));
    format(query,sizeof query,"`pCarSkill`='%d',`pNewsSkill`='%d',`pDrugsSkill`='%d',`pCookSkill`='%d',`pFishSkill`='%d',`pHealth`='%.2f',`pSHealth`='%.2f',`pInt`='%d',`pLocal`='%d',`pTeam`='%d',`pPnumber`='%d',`pPhousekey`='%d',`pPbiskey`='%d',`pPos_x`='%.2f',`pPos_y`='%.2f',`pPos_z`='%.2f',`pCarLic`='%d',`pNewLic`='%d',`pFlyLic`='%d',`pBoatLic`='%d',`pFishLic`='%d',`pGunLic`='%d',`pLKWLic`='%d',`pRollerLic`='%d',`pMotoLic`='%d',`pZollPass`='%d',`pZollPassTime`='%d',",
    PlayerInfo[playerid][pCarSkill],PlayerInfo[playerid][pNewsSkill],PlayerInfo[playerid][pDrugsSkill],PlayerInfo[playerid][pCookSkill],PlayerInfo[playerid][pFishSkill],PlayerInfo[playerid][pHealth],PlayerInfo[playerid][pSHealth],PlayerInfo[playerid][pInt],PlayerInfo[playerid][pLocal],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pPnumber],
    PlayerInfo[playerid][pPhousekey],PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pPos_x],PlayerInfo[playerid][pPos_y],PlayerInfo[playerid][pPos_z],PlayerInfo[playerid][pCarLic],PlayerInfo[playerid][pNewLic],PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pFishLic],PlayerInfo[playerid][pGunLic],PlayerInfo[playerid][pLKWLic],
    PlayerInfo[playerid][pRollerLic],PlayerInfo[playerid][pMotoLic],PlayerInfo[playerid][pZollPass],PlayerInfo[playerid][pZollPassTime],pname);
    strcat(stringzusammen,query);
    strdel(query,0,sizeof(query));
    format(query,sizeof query,"`pKrankenkasse`='%d',`pKrankenkasseTime`='%d',`pCarP`='%d',`pBikeP`='%d',`pZig`='%d',`pKekse`='%d',`pZigSucht`='%d',`pGun1`='%d',`pGun2`='%d',`pGun3`='%d',`pGun4`='%d',`pAmmo1`='%d',`pAmmo2`='%d',`pAmmo3`='%d',`pAmmo4`='%d',`pCarTime`='%d',`pMulltime`='%d',`pPayDay`='%d',`pPayDayHad`='%d',`pCDPlayer`='%d',`pWins`='%d',`pLoses`='%d',`pAlcoholPerk`='%d',`pDrugPerk`='%d',`pMiserPerk`='%d',`pPainPerk`='%d',`pTraderPerk`='%d',`pTut`='%d',",
    PlayerInfo[playerid][pKrankenkasse],PlayerInfo[playerid][pKrankenkasseTime],PlayerInfo[playerid][pCarP],PlayerInfo[playerid][pBikeP],PlayerInfo[playerid][pZig],PlayerInfo[playerid][pKekse],PlayerInfo[playerid][pZigSucht],PlayerInfo[playerid][pGun1],PlayerInfo[playerid][pGun2],PlayerInfo[playerid][pGun3],
    PlayerInfo[playerid][pGun4],PlayerInfo[playerid][pAmmo1],PlayerInfo[playerid][pAmmo2],PlayerInfo[playerid][pAmmo3],PlayerInfo[playerid][pAmmo4],PlayerInfo[playerid][pCarTime],PlayerInfo[playerid][pMulltime],PlayerInfo[playerid][pPayDay],PlayerInfo[playerid][pPayDayHad],PlayerInfo[playerid][pCDPlayer],PlayerInfo[playerid][pWins],PlayerInfo[playerid][pLoses],
    PlayerInfo[playerid][pAlcoholPerk],PlayerInfo[playerid][pDrugPerk],PlayerInfo[playerid][pMiserPerk],PlayerInfo[playerid][pPainPerk],PlayerInfo[playerid][pTraderPerk],PlayerInfo[playerid][pTut]);
    strcat(stringzusammen,query);
    strdel(query,0,sizeof(query));
    format(query,sizeof query,"`pWarns`='%d',`pAdjustable`='%d',`pFuel`='%d',`pMarried`='%d',`pInvWeapon`='%d',`pInvAmmo`='%d',`pInvWeapon2`='%d',`pInvAmmo2`='%d',`pInvDrugs`='%d',`pInvMats`='%d',`pFlugTime`='%d',`pRoadblock`='%d',`pPlayMinutes`='%d',`pGesamtMinutes`='%d',`pMinutesSinceLogin`='%d',`pMinutesSinceAn`='%d',`pSFPASS`='%d',`pLVPASS`='%d',`pHandyGeld`='%d',`pHandyVer`='%d',`pUhrID`='%d',`pHandyID`='%d',`pOwnPerso`='%d',`pOwnAntrag`='%d',`pPersoStop`='%d',`pGehalt`='%d',",
    PlayerInfo[playerid][pWarns],PlayerInfo[playerid][pAdjustable],PlayerInfo[playerid][pFuel],PlayerInfo[playerid][pMarried],PlayerInfo[playerid][pInvWeapon],PlayerInfo[playerid][pInvAmmo],PlayerInfo[playerid][pInvWeapon2],PlayerInfo[playerid][pInvAmmo2],PlayerInfo[playerid][pInvDrugs],PlayerInfo[playerid][pInvMats],
    PlayerInfo[playerid][pFlugTime],PlayerInfo[playerid][pRoadblock],PlayerInfo[playerid][pPlayMinutes],PlayerInfo[playerid][pGesamtMinutes],PlayerInfo[playerid][pMinutesSinceLogin],PlayerInfo[playerid][pMinutesSinceAn],PlayerInfo[playerid][pSFPASS],PlayerInfo[playerid][pLVPASS],PlayerInfo[playerid][pHandyGeld],
    PlayerInfo[playerid][pHandyVer],PlayerInfo[playerid][pUhrID],PlayerInfo[playerid][pHandyID],PlayerInfo[playerid][pOwnPerso],
    PlayerInfo[playerid][pOwnAntrag],PlayerInfo[playerid][pPersoStop],PlayerInfo[playerid][pGehalt]);
    strcat(stringzusammen,query);
    strdel(query,0,sizeof(query));
    format(query,sizeof query,"`pFrakSperre`='%d',`pBoxMats`='%d',`pBoxDrugs`='%d',`pban`='%d',`pTot`='%d',`pFarmTime`='%d',`pGDeaths`='%d',`pGKills`='%d',`pMeldung`='%d' WHERE `name`='%s'",
    PlayerInfo[playerid][pFrakSperre],PlayerInfo[playerid][pBoxMats],PlayerInfo[playerid][pBoxDrugs],PlayerInfo[playerid][pban],PlayerInfo[pTot][pFarmTime],PlayerInfo[playerid][pGDeaths],PlayerInfo[playerid][pGKills],PlayerInfo[playerid][pMeldung],pname);
    strcat(stringzusammen,query);
    strdel(query,0,sizeof(query));
    mysql_query(stringzusammen);
    strdel(stringzusammen,0,sizeof(stringzusammen));
    mysql_free_result();
    }
    }
    return 1;
    }


    Ich weiss einfach nicht woran es liegt...

  • An dem Code liegt es nicht, sondern an einem Code der
    mysql_fetch_row_format
    aufruft.


    Da:

    Zitat

    [11:14:24] >> mysql_fetch_row_format( Connection handle: 1 )
    [11:14:24] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)


    Du rufst irgendwo mysql_fetch_row_format auf, ohne ein mysql_query davor zu haben.

  • Moment, dann war das grade mein Fehler, der Error oben gehört dazu:


    stock LoadPlayer(playerid){
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    new var[256], string[256];
    GetPlayerName(playerid, pname, sizeof(pname));
    mysql_real_escape_string(pname, pname);
    format(string, sizeof(string),"SELECT * FROM `accounts` WHERE `name` = '%s'", pname);
    self_mysql_queryEx(string);
    mysql_store_result();
    while(mysql_fetch_row_format(string,"|"))
    {// wo haste dein ehm auto ID?


    mysql_get_field("id",var); PlayerInfo[playerid][pid] = strval(var);
    mysql_get_field("level",var); PlayerInfo[playerid][pLevel] = strval(var);
    mysql_get_field("pBanned",var); PlayerInfo[playerid][pBanned] = strval(var);
    mysql_get_field("pAdmin",var); PlayerInfo[playerid][pAdmin] = strval(var);
    mysql_get_field("pSupporter",var); PlayerInfo[playerid][pSupporter] = strval(var);
    mysql_get_field("pDonateRank",var); PlayerInfo[playerid][pDonateRank] = strval(var);
    mysql_get_field("gPupgrade",var); PlayerInfo[playerid][gPupgrade] = strval(var);
    mysql_get_field("pConnectTime",var); PlayerInfo[playerid][pConnectTime] = strval(var);
    mysql_get_field("pReg",var); PlayerInfo[playerid][pReg] = strval(var);
    mysql_get_field("pSex",var); PlayerInfo[playerid][pSex] = strval(var);
    mysql_get_field("pAge",var); PlayerInfo[playerid][pAge] = strval(var);
    mysql_get_field("pOrigin",var); PlayerInfo[playerid][pOrigin] = strval(var);
    mysql_get_field("pCK",var); PlayerInfo[playerid][pCK] = strval(var);
    mysql_get_field("pMuted",var); PlayerInfo[playerid][pMuted] = strval(var);
    mysql_get_field("pExp",var); PlayerInfo[playerid][pExp] = strval(var);
    mysql_get_field("pCash",var); PlayerInfo[playerid][pCash] = strval(var);
    mysql_get_field("pAccount",var); PlayerInfo[playerid][pAccount] = strval(var);
    mysql_get_field("pPlayerKreditDauer",var); PlayerInfo[playerid][pPlayerKreditDauer] = strval(var);
    mysql_get_field("pPlayerKredit",var); PlayerInfo[playerid][pPlayerKredit] = strval(var);
    mysql_get_field("pCrimes",var); PlayerInfo[playerid][pCrimes] = strval(var);
    mysql_get_field("pKills",var); PlayerInfo[playerid][pKills] = strval(var);
    mysql_get_field("pArrested",var); PlayerInfo[playerid][pArrested] = strval(var);
    mysql_get_field("pWantedDeaths",var); PlayerInfo[playerid][pWantedDeaths] = strval(var);
    mysql_get_field("pPhoneBook",var); PlayerInfo[playerid][pPhoneBook] = strval(var);
    mysql_get_field("pLottoNr",var); PlayerInfo[playerid][pLottoNr] = strval(var);
    mysql_get_field("pFishes",var); PlayerInfo[playerid][pFishes] = strval(var);
    mysql_get_field("pBiggestFish",var); PlayerInfo[playerid][pBiggestFish] = strval(var);
    mysql_get_field("pJob",var); PlayerInfo[playerid][pJob] = strval(var);
    mysql_get_field("pPayCheck",var); PlayerInfo[playerid][pPayCheck] = strval(var);
    mysql_get_field("pHeadValue",var); PlayerInfo[playerid][pHeadValue] = strval(var);
    mysql_get_field("pJailed",var); PlayerInfo[playerid][pJailed] = strval(var);
    mysql_get_field("pRobTime",var); PlayerInfo[playerid][pRobTime] = strval(var);
    mysql_get_field("pJailTime",var); PlayerInfo[playerid][pJailTime] = strval(var);
    mysql_get_field("pGangJailed",var); PlayerInfo[playerid][pGangJailed] = strval(var);
    mysql_get_field("pwJailed",var); PlayerInfo[playerid][pwJailed] = strval(var);
    mysql_get_field("pMauled",var); PlayerInfo[playerid][pMauled] = strval(var);
    mysql_get_field("pMats",var); PlayerInfo[playerid][pMats] = strval(var);
    mysql_get_field("pRadio",var); PlayerInfo[playerid][pRadio] = strval(var);
    mysql_get_field("pNavi",var); PlayerInfo[playerid][pNavi] = strval(var);
    mysql_get_field("pDrugs",var); PlayerInfo[playerid][pDrugs] = strval(var);
    mysql_get_field("pLeader",var); PlayerInfo[playerid][pLeader] = strval(var);
    mysql_get_field("pFMember",var); PlayerInfo[playerid][pFMember] = strval(var);
    mysql_get_field("pRank",var); PlayerInfo[playerid][pRank] = strval(var);
    mysql_get_field("pChar",var); PlayerInfo[playerid][pChar] = strval(var);
    mysql_get_field("pContractTime",var); PlayerInfo[playerid][pContractTime] = strval(var);
    mysql_get_field("pDetSkill",var); PlayerInfo[playerid][pDetSkill] = strval(var);
    mysql_get_field("pSexSkill",var); PlayerInfo[playerid][pSexSkill] = strval(var);
    mysql_get_field("pBoxSkill",var); PlayerInfo[playerid][pBoxSkill] = strval(var);
    mysql_get_field("pLawSkill",var); PlayerInfo[playerid][pLawSkill] = strval(var);
    mysql_get_field("pMechSkill",var); PlayerInfo[playerid][pMechSkill] = strval(var);
    mysql_get_field("pJackSkill",var); PlayerInfo[playerid][pJackSkill] = strval(var);
    mysql_get_field("pCarSkill",var); PlayerInfo[playerid][pCarSkill] = strval(var);
    mysql_get_field("pNewsSkill",var); PlayerInfo[playerid][pNewsSkill] = strval(var);
    mysql_get_field("pDrugsSkill",var); PlayerInfo[playerid][pDrugsSkill] = strval(var);
    mysql_get_field("pCookSkill",var); PlayerInfo[playerid][pCookSkill] = strval(var);
    mysql_get_field("pFishSkill",var); PlayerInfo[playerid][pFishSkill] = strval(var);
    mysql_get_field("pSHealth",var); PlayerInfo[playerid][pSHealth] = floatstr(var);
    mysql_get_field("pHealth",var); PlayerInfo[playerid][pHealth] = floatstr(var);
    mysql_get_field("pPos_x",var); PlayerInfo[playerid][pPos_x] = floatstr(var);
    mysql_get_field("pPos_y",var); PlayerInfo[playerid][pPos_y] = floatstr(var);
    mysql_get_field("pPos_z",var); PlayerInfo[playerid][pPos_z] = floatstr(var);
    mysql_get_field("pInt",var); PlayerInfo[playerid][pInt] = strval(var);
    mysql_get_field("pLocal",var); PlayerInfo[playerid][pLocal] = strval(var);
    mysql_get_field("pTeam",var); PlayerInfo[playerid][pTeam] = strval(var);
    mysql_get_field("pModel",var); PlayerInfo[playerid][pModel] = strval(var);
    mysql_get_field("pPnumber",var); PlayerInfo[playerid][pPnumber] = strval(var);
    mysql_get_field("pPhousekey",var); PlayerInfo[playerid][pPhousekey] = strval(var);
    mysql_get_field("pPbiskey",var); PlayerInfo[playerid][pPbiskey] = strval(var);
    mysql_get_field("pCarLic",var); PlayerInfo[playerid][pCarLic] = strval(var);
    mysql_get_field("pNewLic",var); PlayerInfo[playerid][pNewLic] = strval(var);
    mysql_get_field("pFlyLic",var); PlayerInfo[playerid][pFlyLic] = strval(var);
    mysql_get_field("pBoatLic",var); PlayerInfo[playerid][pBoatLic] = strval(var);
    mysql_get_field("pFishLic",var); PlayerInfo[playerid][pFishLic] = strval(var);
    mysql_get_field("pGunLic",var); PlayerInfo[playerid][pGunLic] = strval(var);
    mysql_get_field("pLKWLic",var); PlayerInfo[playerid][pLKWLic] = strval(var);
    mysql_get_field("pRollerLic",var); PlayerInfo[playerid][pRollerLic] = strval(var);
    mysql_get_field("pMotoLic",var); PlayerInfo[playerid][pMotoLic] = strval(var);
    mysql_get_field("pZollPass",var); PlayerInfo[playerid][pZollPass] = strval(var);
    mysql_get_field("pZollPassTime",var); PlayerInfo[playerid][pZollPassTime] = strval(var);
    mysql_get_field("pKrankenkasse",var); PlayerInfo[playerid][pKrankenkasse] = strval(var);
    mysql_get_field("pKrankenkasseTime",var); PlayerInfo[playerid][pKrankenkasseTime] = strval(var);
    mysql_get_field("pBikeP",var); PlayerInfo[playerid][pBikeP] = strval(var);
    mysql_get_field("pCarP",var); PlayerInfo[playerid][pCarP] = strval(var);
    mysql_get_field("pZig",var); PlayerInfo[playerid][pZig] = strval(var);
    mysql_get_field("pKekse",var); PlayerInfo[playerid][pKekse] = strval(var);
    mysql_get_field("pZigSucht",var); PlayerInfo[playerid][pZigSucht] = strval(var);
    mysql_get_field("pGun1",var); PlayerInfo[playerid][pGun1] = strval(var);
    mysql_get_field("pGun2",var); PlayerInfo[playerid][pGun2] = strval(var);
    mysql_get_field("pGun3",var); PlayerInfo[playerid][pGun3] = strval(var);
    mysql_get_field("pGun4",var); PlayerInfo[playerid][pGun4] = strval(var);
    mysql_get_field("pAmmo1",var); PlayerInfo[playerid][pAmmo1] = strval(var);
    mysql_get_field("pAmmo2",var); PlayerInfo[playerid][pAmmo2] = strval(var);
    mysql_get_field("pAmmo3",var); PlayerInfo[playerid][pAmmo3] = strval(var);
    mysql_get_field("pAmmo4",var); PlayerInfo[playerid][pAmmo4] = strval(var);
    mysql_get_field("pCarTime",var); PlayerInfo[playerid][pCarTime] = strval(var);
    mysql_get_field("pMulltime",var); PlayerInfo[playerid][pMulltime] = strval(var);
    mysql_get_field("pPayDay",var); PlayerInfo[playerid][pPayDay] = strval(var);
    mysql_get_field("pPayDayHad",var); PlayerInfo[playerid][pPayDayHad] = strval(var);
    mysql_get_field("pCDPlayer",var); PlayerInfo[playerid][pCDPlayer] = strval(var);
    mysql_get_field("pWins",var); PlayerInfo[playerid][pWins] = strval(var);
    mysql_get_field("pLoses",var); PlayerInfo[playerid][pLoses] = strval(var);
    mysql_get_field("pAlcoholPerk",var); PlayerInfo[playerid][pAlcoholPerk] = strval(var);
    mysql_get_field("pDrugPerk",var); PlayerInfo[playerid][pDrugPerk] = strval(var);
    mysql_get_field("pMiserPerk",var); PlayerInfo[playerid][pMiserPerk] = strval(var);
    mysql_get_field("pPainPerk",var); PlayerInfo[playerid][pPainPerk] = strval(var);
    mysql_get_field("pTraderPerk",var); PlayerInfo[playerid][pTraderPerk] = strval(var);
    mysql_get_field("pTut",var); PlayerInfo[playerid][pTut] = strval(var);
    mysql_get_field("pWarns",var); PlayerInfo[playerid][pWarns] = strval(var);
    mysql_get_field("pAdjustable",var); PlayerInfo[playerid][pAdjustable] = strval(var);
    mysql_get_field("pFuel",var); PlayerInfo[playerid][pFuel] = strval(var);
    mysql_get_field("pMarried",var); PlayerInfo[playerid][pMarried] = strval(var);
    mysql_get_field("pInvWeapon",var); PlayerInfo[playerid][pInvWeapon] = strval(var);
    mysql_get_field("pInvAmmo",var); PlayerInfo[playerid][pInvAmmo] = strval(var);
    mysql_get_field("pInvWeapon2",var); PlayerInfo[playerid][pInvWeapon2] = strval(var);
    mysql_get_field("pInvAmmo2",var); PlayerInfo[playerid][pInvDrugs] = strval(var);
    mysql_get_field("pInvMats",var); PlayerInfo[playerid][pInvMats] = strval(var);
    mysql_get_field("pFlugTime",var); PlayerInfo[playerid][pFlugTime] = strval(var);
    mysql_get_field("pRoadblock",var); PlayerInfo[playerid][pRoadblock] = strval(var);
    mysql_get_field("pPlayMinutes",var); PlayerInfo[playerid][pPlayMinutes] = strval(var);
    mysql_get_field("pGesamtMinutes",var); PlayerInfo[playerid][pGesamtMinutes] = strval(var);
    mysql_get_field("pMinutesSinceLogin",var); PlayerInfo[playerid][pMinutesSinceLogin] = strval(var);
    mysql_get_field("pMinutesSinceAn",var); PlayerInfo[playerid][pMinutesSinceAn] = strval(var);
    mysql_get_field("pSFPASS",var); PlayerInfo[playerid][pSFPASS] = strval(var);
    mysql_get_field("pLVPASS",var); PlayerInfo[playerid][pLVPASS] = strval(var);
    mysql_get_field("pHandyGeld",var); PlayerInfo[playerid][pHandyGeld] = strval(var);
    mysql_get_field("pHandyVer",var); PlayerInfo[playerid][pHandyVer] = strval(var);
    mysql_get_field("pUhrID",var); PlayerInfo[playerid][pUhrID] = strval(var);
    mysql_get_field("pHandyID",var); PlayerInfo[playerid][pHandyID] = strval(var);
    mysql_get_field("pOwnPerso",var); PlayerInfo[playerid][pOwnPerso] = strval(var);
    mysql_get_field("pPersoStop",var); PlayerInfo[playerid][pPersoStop] = strval(var);
    mysql_get_field("pGehalt",var); PlayerInfo[playerid][pGehalt] = strval(var);
    mysql_get_field("pFrakSperre",var); PlayerInfo[playerid][pFrakSperre] = strval(var);
    mysql_get_field("pBoxMats",var); PlayerInfo[playerid][pBoxMats] = strval(var);
    mysql_get_field("pBoxDrugs",var); PlayerInfo[playerid][pBoxDrugs] = strval(var);
    mysql_get_field("pban",var); PlayerInfo[playerid][pban] = strval(var);
    mysql_get_field("pTot",var); PlayerInfo[playerid][pTot] = strval(var);
    mysql_get_field("pFarmTime",var); PlayerInfo[playerid][pFarmTime] = strval(var);
    mysql_get_field("pGDeaths",var); PlayerInfo[playerid][pGDeaths] = strval(var);
    mysql_get_field("pGKills",var); PlayerInfo[playerid][pGKills] = strval(var);
    mysql_get_field("pMeldung",var); PlayerInfo[playerid][pMeldung] = strval(var);
    GivePlayerMoney(playerid,PlayerInfo[playerid][pCash]);
    SetPlayerScore(playerid,PlayerInfo[playerid][pLevel]);
    mysql_free_result();


    }
    }
    return 1;
    }


    Hier der Saveplayer Fehler:

    SQL
    [16:51:10] CMySQLHandler::Query(UPDATE `accounts` SET `name`='[DRC]McGarrett', `pid`='0', `pLevel`='0', `pBanned`='0', `pAdmin`='1998', `pSupporter`='0', `pDonateRank`='0', `gPupgrade`='0', `pConnectTime`='0', `pReg`='0', `pSex`='1', `pAge`='16', `pOrigin`='1', `pCK`='0', `pMuted`='0', `pExp`='0', `pCash`='78500', `pAccount`='0', `pPlayerKreditDauer`='0', `pPlayerKredit`='0', `pCrimes`='0', `pKills`='0', `pDeaths`='0', `pArrested`='0' ,`pWantedDeaths`='0',`pPhoneBook`='0',`pLottoNr`='0',`pFishes`='0',`pBiggestFish`='0',`pJob`='0',`pPayCheck`='0',`pHeadValue`='0',`pJailed`='0',`pRobTime`='0',`pJailTime`='0',`pDuty`='0',`pGangJailed`='0',`pwJailed`='0',`pMauled`='0',`pMats`='0',`pRadio`='0',`pNavi`='0',`pDrugs`='0',`pLeader`='0',`pMember`='0',`pFMember`='0',`pRank`='0',`pChar`='0',`pContractTime`='0',`pDetSkill`='0',`pSexSkill`='0',`pBoxSkill`='0',`pLawSkill`='0',`pMechSkill`='0',`pJackSkill`='0',`pCarSkill`='0',`pNewsSkill`='0',`pDrugsSkill`='0',`pCookSkill`='0',`pFishSkill`='0',`pHealth`='0.00',`pSHealth`='0.00',`pInt`='2',`pLocal`='0',`pTeam`='0',`pPnumber`='0',`pPhousekey`='0',`pPbiskey`='0',`pPos_x`='0.00',`pPos_y`='0.00',`pPos_z`='0.00',`pCarLic`='0',`pNewLic`='0',`pFlyLic`='0',`pBoatLic`='0',`pFishLic`='0',`pGunLic`='0',`pLKWLic`='0',`pRollerLic`='0',`pMotoLic`='0',`pZollPass`='0',`pZollPassTime`='0',`pKrankenkasse`='0',`pKrankenkasseTime`='0',`pCarP`='0',`pBikeP`='0',`pZig`='0',`pKekse`='0',`pZigSucht`='0',`pGun1`='0',`pGun2`='0',`pGun3`='0',`pGun4`='0',`pAmmo1`='0',`pAmmo2`='0',`pAmmo3`='0',`pAmmo4`='0',`pCarTime`='0',`pMulltime`='0',`pPayDay`='0',`pPayDayHad`='0',`pCDPlayer`='0',`pWins`='0',`pLoses`='0',`pAlcoholPerk`='0',`pDrugPerk`='0',`pMiserPerk`='0',`pPainPerk`='0',`pTraderPerk`='0',`pTut`='0',`pWarns`='0',`pAdjustable`='0',`pFuel`='0',`pMarried`='0',`pInvWeapon`='0',`pInvAmmo`='0',`pInvWeapon2`='0',`pInvAmmo2`='0',`pInvDrugs`='0',`pInvMats`='0',`pFlugTime`='0',`pRoadblock`='0',`pPlayMinutes`='1',`pGesamtMinutes`='1',`pMinutesSinceLogin`='1',`pMinutesSinceAn`='1',`pSFPASS`='0',`pLVPASS`='0',`pHandyGeld`='0',`pHandyVer`='0',`pUhrID`='0',`pHandyID`='0',`pOwnPerso`='0',`pOwnAntrag`='0',`pPersoStop`='0',`pGehalt`='0',`pFrakSperre`='0',`pBoxMats`='0',`pBoxDrugs`='0',`pban`='0',`pTot`='0',`pFarmTime`='0',`pGDeaths`='0',`pGKills`='0',`pMeldung`='91' WHERE `name`='') - Successfully executed.
    
    
    [16:51:10] >> mysql_free_result( Connection handle: 1 )
    
    
    [16:51:10] CMySQLHandler::FreeResult() - The result is already empty.


    So nun die zwei fehler...

  • Du hast ja nur eine Zeile pro Spieler, also ändere:
    while(mysql_fetch_row_format(string,"|"))
    zu:
    mysql_fetch_row_format(string,"|");


    oder füge nach mysql_free_result(); ein return 1; ein.



    Bei SavePlayer einfach das mysql_free_result(); weg machen, da du kein result gespeichert hast (mysql_store_result wird ja in SavePlayer nicht aufgerufen).

  • format(query,sizeof query,"`pFrakSperre`='%d',`pBoxMats`='%d',`pBoxDrugs`='%d',`pban`='%d',`pTot`='%d',`pFarmTime`='%d',`pGDeaths`='%d',`pGKills`='%d',`pMeldung`='%d' WHERE `name`='%s'",
    PlayerInfo[playerid][pFrakSperre],PlayerInfo[playerid][pBoxMats],PlayerInfo[playerid][pBoxDrugs],PlayerInfo[playerid][pban],PlayerInfo[pTot][pFarmTime],PlayerInfo[playerid][pGDeaths],PlayerInfo[playerid][pGKills],PlayerInfo[playerid][pMeldung],pname);
    strcat(stringzusammen,query);
    strdel(query,0,sizeof(query));


    Iwas ist da falsch... da hier die letzte speicher zeile anfängt und ab dort nichts mher geht.. hab mal fraksperre in die Tabelle eintragen, bin connectet und dann kam da immernoch null statt eins...
    ab da geht irgendwie nichts mehr...

  • Deshalb hast du ja nachzählen sollen...


    Schreibe es so:
    format(query,sizeof query,"`pFrakSperre`='%d',`pBoxMats`='%d',`pBoxDrugs`='%d',`pban`='%d',`pTot`='%d',`pFarmTime`='%d',`pGDeaths`='%d',`pGKills`='%d',`pMeldung`='%d' WHERE `name`='%s'",
    PlayerInfo[playerid][pFrakSperre],PlayerInfo[playerid][pBoxMats],PlayerInfo[playerid][pBoxDrugs],PlayerInfo[playerid][pban],PlayerInfo[playerid][pFarmTime],PlayerInfo[playerid][pTot],PlayerInfo[playerid][pGDeaths],PlayerInfo[playerid][pGKills],PlayerInfo[playerid][pMeldung],pname);
    strcat(stringzusammen,query);
    strdel(query,0,sizeof(query));




    PlayerInfo[pTot][pFarmTime]
    war nicht richtig.