fatal error 102: table overflow: "staging buffer" - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Русский/Russian (https://sampforum.blast.hk/forumdisplay.php?fid=32)
+---- Thread: fatal error 102: table overflow: "staging buffer" (/showthread.php?tid=360874)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Русский/Russian (https://sampforum.blast.hk/forumdisplay.php?fid=32)
+---- Thread: fatal error 102: table overflow: "staging buffer" (/showthread.php?tid=360874)
fatal error 102: table overflow: "staging buffer" - Anarius - 19.07.2012
Доброго времени суток, вчера взялся переводить свой мод на MySQL и при этом использовать загрузку через sscanf, у меня получился очень большой код из-за больших переменных в pInfo. Собственно, как можно это все сократить или разбить на несколько частей загрузки? Спасибо.
PHP Code:
sscanf(result, "p<|>is[24]s[128]iiiiiiiiiis[32]iiiiiiiiiiiiiiiiiiiiiiiiiis[32]iiiiiiiiiiiiiiffiiiiiiiiiifffiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiis[24]iiiiiiiiiiiiiiiiiiiiiiiiiiiiis[40]s[40]iiiiiiiiiiiiiiis[32]iis[32]iis[32]iiiiiiiiiiiiiiiiiiiiiiiii",
id, n,
PlayerInfo[playerid][pPassword],
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pUpgrade],
PlayerInfo[playerid][pDonateRank],
PlayerInfo[playerid][pConnectTime],
PlayerInfo[playerid][pRegister],
PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pAge],
PlayerInfo[playerid][pAgeTime],
PlayerInfo[playerid][pTimeAge],
PlayerInfo[playerid][pFishTime],
PlayerInfo[playerid][pWanted],
PlayerInfo[playerid][pOrigin],
PlayerInfo[playerid][pCK],
PlayerInfo[playerid][pMuteTime],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pCash],
PlayerInfo[playerid][pAccount],
PlayerInfo[playerid][pCrimes],
PlayerInfo[playerid][pKills],
PlayerInfo[playerid][pDeaths],
PlayerInfo[playerid][pArrested],
PlayerInfo[playerid][pWantedDeaths],
PlayerInfo[playerid][pPhoneBook],
PlayerInfo[playerid][pLottoNr],
PlayerInfo[playerid][pFishes],
PlayerInfo[playerid][pBiggestFish],
PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pPayCheck],
PlayerInfo[playerid][pHeadValue],
PlayerInfo[playerid][pJailed],
PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pMedicTime],
PlayerInfo[playerid][pNeedTime],
PlayerInfo[playerid][pMats],
PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pRank],
PlayerInfo[playerid][pRankName],
PlayerInfo[playerid][pChar],
PlayerInfo[playerid][pRace],
PlayerInfo[playerid][pContractTime],
PlayerInfo[playerid][pDetSkill],
PlayerInfo[playerid][pSexSkill],
PlayerInfo[playerid][pBoxSkill],
PlayerInfo[playerid][pLawSkill],
PlayerInfo[playerid][pMechSkill],
PlayerInfo[playerid][pJackSkill],
PlayerInfo[playerid][pCarSkill],
PlayerInfo[playerid][pNewsSkill],
PlayerInfo[playerid][pDrugsSkill],
PlayerInfo[playerid][pCookSkill],
PlayerInfo[playerid][pFishSkill],
PlayerInfo[playerid][pHealth],
PlayerInfo[playerid][pSHealth],
PlayerInfo[playerid][pInterior],
PlayerInfo[playerid][pVirtual],
PlayerInfo[playerid][pLocal],
PlayerInfo[playerid][pTeam],
PlayerInfo[playerid][pModel],
PlayerInfo[playerid][pModel2],
PlayerInfo[playerid][pModel3],
PlayerInfo[playerid][pNumber],
PlayerInfo[playerid][pHouseKey],
PlayerInfo[playerid][pBizzKey],
PlayerInfo[playerid][pPosX],
PlayerInfo[playerid][pPosY],
PlayerInfo[playerid][pPosZ],
PlayerInfo[playerid][pCarLic],
PlayerInfo[playerid][pMotoLic],
PlayerInfo[playerid][pTruckLic],
PlayerInfo[playerid][pBusLic],
PlayerInfo[playerid][pFlyLic],
PlayerInfo[playerid][pBoatLic],
PlayerInfo[playerid][pFishLic],
PlayerInfo[playerid][pGunLic],
PlayerInfo[playerid][pGunLicAllow],
PlayerInfo[playerid][pAllow],
PlayerInfo[playerid][pMelee],
PlayerInfo[playerid][pPistol],
PlayerInfo[playerid][pShotgun],
PlayerInfo[playerid][pSMG],
PlayerInfo[playerid][pRifle],
PlayerInfo[playerid][pAssault],
PlayerInfo[playerid][pGrenade],
PlayerInfo[playerid][pSpecial],
PlayerInfo[playerid][pOther],
PlayerInfo[playerid][pMeleeAmmo],
PlayerInfo[playerid][pPistolAmmo],
PlayerInfo[playerid][pShotgunAmmo],
PlayerInfo[playerid][pSMGAmmo],
PlayerInfo[playerid][pRifleAmmo],
PlayerInfo[playerid][pAssaultAmmo],
PlayerInfo[playerid][pGrenadeAmmo],
PlayerInfo[playerid][pSpecialAmmo],
PlayerInfo[playerid][pOtherAmmo],
PlayerInfo[playerid][pCarTime],
PlayerInfo[playerid][pPayDay],
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][pMissionNr],
PlayerInfo[playerid][pWarns],
PlayerInfo[playerid][pAdjustable],
PlayerInfo[playerid][pFuel],
PlayerInfo[playerid][pJerryCan],
PlayerInfo[playerid][pMarried],
PlayerInfo[playerid][pMarriedTo],
PlayerInfo[playerid][pTA],
PlayerInfo[playerid][pRope],
PlayerInfo[playerid][pSK],
PlayerInfo[playerid][pSD],
PlayerInfo[playerid][pSTD],
PlayerInfo[playerid][pSpawn],
PlayerInfo[playerid][pSQ],
PlayerInfo[playerid][pClock],
PlayerInfo[playerid][pSigs],
PlayerInfo[playerid][pBageNum],
PlayerInfo[playerid][pCarKey1],
PlayerInfo[playerid][pCarKey2],
PlayerInfo[playerid][pCarKey3],
PlayerInfo[playerid][pLang],
PlayerInfo[playerid][pItalian],
PlayerInfo[playerid][pJapanese],
PlayerInfo[playerid][pEspanol],
PlayerInfo[playerid][pFrance],
PlayerInfo[playerid][pRussian],
PlayerInfo[playerid][pGerman],
PlayerInfo[playerid][pRPG],
PlayerInfo[playerid][pHotelKey],
PlayerInfo[playerid][pAllowed],
PlayerInfo[playerid][pGranica],
PlayerInfo[playerid][pNameChange],
PlayerInfo[playerid][pRadio],
PlayerInfo[playerid][pMask],
PlayerInfo[playerid][pMasked],
PlayerInfo[playerid][pPension],
PlayerInfo[playerid][pLivingAt],
PlayerInfo[playerid][pBornAt],
PlayerInfo[playerid][pPasport],
PlayerInfo[playerid][pNeSdal],
PlayerInfo[playerid][pFishTool],
PlayerInfo[playerid][pMobile],
PlayerInfo[playerid][pDraka],
PlayerInfo[playerid][pKunfu],
PlayerInfo[playerid][pKneehead],
PlayerInfo[playerid][pGrabkick],
PlayerInfo[playerid][pPistolS],
PlayerInfo[playerid][pShotgunS],
PlayerInfo[playerid][pDesertS],
PlayerInfo[playerid][pUziS],
PlayerInfo[playerid][pCondom],
PlayerInfo[playerid][pBeremenna],
PlayerInfo[playerid][pBeremennaTime],
PlayerInfo[playerid][pKid1Name],
PlayerInfo[playerid][pKid1Sex],
PlayerInfo[playerid][pKid1Age],
PlayerInfo[playerid][pKid2Name],
PlayerInfo[playerid][pKid2Sex],
PlayerInfo[playerid][pKid2Age],
PlayerInfo[playerid][pKid3Name],
PlayerInfo[playerid][pKid3Sex],
PlayerInfo[playerid][pKid3Age],
PlayerInfo[playerid][pVodka],
PlayerInfo[playerid][pGin],
PlayerInfo[playerid][pCognak],
PlayerInfo[playerid][pVino],
PlayerInfo[playerid][pBear],
PlayerInfo[playerid][pTequilla],
PlayerInfo[playerid][pViski],
PlayerInfo[playerid][pCola],
PlayerInfo[playerid][pSprunk],
PlayerInfo[playerid][pDrugsBuy],
PlayerInfo[playerid][pSil],
PlayerInfo[playerid][pOpt],
PlayerInfo[playerid][pBanned],
PlayerInfo[playerid][pSeed],
PlayerInfo[playerid][pAFK],
PlayerInfo[playerid][pStripes],
PlayerInfo[playerid][pHunger],
PlayerInfo[playerid][pWater],
PlayerInfo[playerid][pWeaponWipe],
PlayerInfo[playerid][pMaxVeh],
PlayerInfo[playerid][pLighter],
PlayerInfo[playerid][pPBT],
PlayerInfo[playerid][pGPS]);
Re: fatal error 102: table overflow: "staging buffer" - Stepashka - 19.07.2012
А у тебя какие есть идеи?
Re: fatal error 102: table overflow: "staging buffer" - Anarius - 19.07.2012
Quote:
|
Originally Posted by Stepashka
 А у тебя какие есть идеи?
|
Re: fatal error 102: table overflow: "staging buffer" - Stepashka - 19.07.2012
Ну первое что наверно очевидно, попробовать все вынимать в несколько запросов.
Странно что вам в голову такая идея не пришла.
Re: fatal error 102: table overflow: "staging buffer" - Anarius - 19.07.2012
Quote:
|
Originally Posted by Stepashka
Ну первое что наверно очевидно, попробовать все вынимать в несколько запросов.
Странно что вам в голову такая идея не пришла. |