fatal error 102: table overflow: "staging buffer"
#1

Доброго времени суток, вчера взялся переводить свой мод на 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",
        
idn,
        
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]); 
Reply
#2

А у тебя какие есть идеи?
Reply
#3

Quote:
Originally Posted by Stepashka
View Post
А у тебя какие есть идеи?
В том то и дело, что никаких. Даже не знаю, что можно попробовать.
Reply
#4

Ну первое что наверно очевидно, попробовать все вынимать в несколько запросов.
Странно что вам в голову такая идея не пришла.
Reply
#5

Quote:
Originally Posted by Stepashka
View Post
Ну первое что наверно очевидно, попробовать все вынимать в несколько запросов.
Странно что вам в голову такая идея не пришла.
А ну этот вариант у меня был, просто мне охото было все в один запрос вынимать и я не стал с этим заморачиваться, но видимо придется в несколько запросов. Ладно, пойду делать, спасибо =)
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)