Hallo Community,
ich habe alle meine Sachen eingetragen, aber ich kriege am schluss von der mysql log immer diesen Fehler:
[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...