01.09.2010, 20:56
Okay, here is my bigger query, and it has some kinda overflow...Code was okay to me..but still there is error.
pawn Код:
#define PLAYER PlayerInfo[playerid]
new query[2048];
format(query, sizeof(query), "UPDATE `mybb_userfields` SET `pAdmin` = '%d', pLevel = '%d', pDonateRank = %d, gPupgrade = %d, pConnectTime = %d, pReg = %d, fid10 = %d, pSex = %d, pAge = %d, pOrigin = %d, pCK = %d, pMuted =%d, pExp = %d, pCash = %d, pAccount = %d, pArrested = %d, pTrahvid = %d, pHaigekassa = %d, pPhoneBook = %d, pLottoNr = %d, pFishes = %d, pBiggestFish = %d,\n\
pJob = %d, pHoiatused = %d, pKiitused = %d, pProtsendid = %d, pMuukvoti = %d, pTaring = %d, pRekkapunkt1 = %d, pPayCheck = %d, pPalk = %d, pAbiraha = %d, pHeadValue = %d, pJailed, %d, pMats = %d, pPeidetudmats = %d, pDrugs = %d, pPeidetudkanep = %d, pLeader = %d, pMemger = %d, pMuted = %d, pJkeel = %d, pSoiduluba = %d, pRank = %d, pChar = %d, pContractTime = %d, pDetSkill = %d,\
pSexSkill = %d, pBoxSkill = %d, pLawSkill = %d, pMechSkill = %d, pJackSkill = %d, pCarSkill =%d, pNewsSkill = %d, pDrugsSkill = %d, pCookSkill = %d, pFishSkill = %d, pHealth = %f, pSHealth = %f, pInt = %d, pLocal = %d, pModel = %d, pPnumber = %d, pPhousekey = %d, pPcarkey = %d, pPcarkey2 = %d, pPcarkey3 = %d, pPcarkey4 = %d, pGangKey = %d, pPbiskey = %d, pPos_x = %f, pPos_y = %f, \
pPos_z = %f, pCarLic = %d, pFlyLic = %d, pBoatLic = %d, pFishLic = %d, pGunLic = %d, pGun1 = %d, pGun2 = %d, pGun3 = %d, pGun4 = %d, pAmmo1 = %d, pAmmo2 = %d, pAmmo3 = %d, pAmmo4 = %d, pCarTime = %d, pMatsiTime = %d, pKuivatusTime = %d, pRekkaTime = %d, pMahaTime = %d, pPayDay = %d, pPayDayhad = %d, pWatch = %d, pCrashed = %d, pWins = %d, pLoses = %d, pAlcoholPerk = %d, pDrugPerk = %d, \
pMiserPerk = %d, pPainPerk = %d, pTraderPerk = %d, pTut = %d, pMissionNr = %d, pWarns = %d, pVirWorld = %d, pFuel = %d, pMarried = %d, pMarriedTo = %s, pSuitsud = %d, pMokatubakas = %d, pTikud = %d, pNote1 = %s, pNote1s = %d, pNote2 = %s, pNote2s = %d, pNote3 = %s, pNote3s = %d,pNote4 = %s, pNote4s = %d, pNote5 = %s, pNote5s = %d, plnvWeapon = %d, plnvAmmo = %d, pLighter = %d, \
pCigarettes = %d, pRequestingBackup = %d, pRoadblock = %d, pMask = %d, pMaskuse = %d, pHideNumber = %d, pSpeaker = %d, pLocked = %d, pRobTime = %d WHERE fid = %d",
PLAYER[pLeader],
PLAYER[pMember],
PLAYER[pMuted],
PLAYER[pJkeel],
PLAYER[pSoiduluba],
PLAYER[pRank],
PLAYER[pChar],
PLAYER[pContractTime],
PLAYER[pDetSkill],
PLAYER[pSexSkill],
PLAYER[pBoxSkill],
PLAYER[pLawSkill],
PLAYER[pMechSkill],
PLAYER[pJackSkill],
PLAYER[pCarSkill],
PLAYER[pNewsSkill],
PLAYER[pDrugsSkill],
PLAYER[pCookSkill],
PLAYER[pFishSkill],
PLAYER[pHealth],
PLAYER[pSHealth],
PLAYER[pInt],
PLAYER[pLocal],
PLAYER[pModel],
PLAYER[pPnumber],
PLAYER[pPhousekey],
PLAYER[pPcarkey],
PLAYER[pPcarkey2],
PLAYER[pPcarkey3],
PLAYER[pPcarkey4],
PLAYER[pGangKey],
PLAYER[pPbiskey],
PLAYER[pPos_x],
PLAYER[pPos_y],
PLAYER[pPos_z],
PLAYER[pCarLic],
PLAYER[pFlyLic],
PLAYER[pBoatLic],
PLAYER[pFishLic],
PLAYER[pGunLic],
PLAYER[pGun1],
PLAYER[pGun2],
PLAYER[pGun3],
PLAYER[pGun4],
PLAYER[pAmmo1],
PLAYER[pAmmo2],
PLAYER[pAmmo3],
PLAYER[pAmmo4],
PLAYER[pCarTime],
PLAYER[pMatsiTime],
PLAYER[pKuivatusTime],
PLAYER[pRekkaTime],
PLAYER[pMahaTime],
PLAYER[pPayDay],
PLAYER[pPayDayHad],
PLAYER[pWatch],
PLAYER[pCrashed],
PLAYER[pWins],
PLAYER[pLoses],
PLAYER[pAlcoholPerk],
PLAYER[pDrugPerk],
PLAYER[pMiserPerk],
PLAYER[pPainPerk],
PLAYER[pTraderPerk],
PLAYER[pTut],
PLAYER[pMissionNr],
PLAYER[pWarns],
PLAYER[pVirWorld],
PLAYER[pFuel],
PLAYER[pMarried],
PLAYER[pMarriedTo],
PLAYER[pSuitsud],
PLAYER[pMokatubakas],
PLAYER[pTikud],
PLAYER[pNote1],
PLAYER[pNote1s],
PLAYER[pNote2],
PLAYER[pNote2s],
PLAYER[pNote3],
PLAYER[pNote3s],
PLAYER[pNote4],
PLAYER[pNote4s],
PLAYER[pNote5],
PLAYER[pNote5s],
PLAYER[pInvWeapon],
PLAYER[pInvAmmo],
PLAYER[pLighter],
PLAYER[pCigarettes],
PLAYER[pRequestingBackup],
PLAYER[pRoadblock],
PLAYER[pMask],
PLAYER[pMaskuse],
PLAYER[pHideNumber],
PLAYER[pSpeaker],
PLAYER[pLocked],
PLAYER[pRobTime],
PLAYER[pSQLID]);
#undef PLAYER
mysql_query(query);
}