18.08.2013, 10:29
PHP код:
public OnPlayerDataSave(playerid)
{
if(IsPlayerConnected(playerid))
{
if(gPlayerLogged[playerid])
{
new query[300], pname[24];
GetPlayerName(playerid, pname, 24);
format(query, sizeof(query), "UPDATE playerinfo SET Password=%s, Level=%d, Interior=%d, VirWorld=%d, Admin=%d, Jetpack=%d, Scripter=%d, Helper=%d, PAntidolorifica=%d, PAntidroga=%d, PRigenerazione=%d, DonateRank=%d, Registerd=%d, Sex=%d, City=%d, InvWeapon=%d, InvAmmo='%s', Age=%d, Exp=%d, Cash=%d, Cents=%d, Bank=%d, Skin=%d, Droga=%d, Assicuraz=%d, UsoMaschera=%d, Orologio=%d, \
Zaino=%d, Corde=%d, LottoNr=%d, Walkietalkie=%d, Benda=%d, TrafficoCell=%d, Sigarette=%d, RequestingBackup=%d, Accendino=%d, Maschera=%d, Dado=%d, Tomtom=%d, Calcolatrice=%d, Materiali=%d, Job=%d, PlayingHours=%d, AllowedPayday=%d, PayCheck=%d, Faction=%d, Clan=%d, HeadQuarter=%d, Rank=%d, HouseKey=%d, BizKey=%d, SpawnPoint=%d, Banned=%d, Warnings=%d, Arresti=%d, LicenzaA=%d, \
Pcarkey=%d, Pcarkey2=%d, Pcarkey3=%d, Pcarkey4=%d, Pcarkey5=%d, Pcarkey6=%d, Pcarkey7=%d, Pcarkey8=%d, Pcarkey9=%d, Pcarkey10=%d, ChiavePrestata=%d, LicenzaB=%d, LicenzaC=%d, LicenzaD=%d, LicenzaVolo=%d, LicenzaNautica=%d, LicenzaArmi=%d, PhoneNumber=%d, PhoneC=%d, PagineGialle=%d, ListNumber=%d, Donatore=%d, Jailed=%d, JailTime=%d, Products=%d, CrashX=%f, CrashY=%f, CrashZ=%f, \
CrashInt=%d, CrashW=%d, Crashed=%d, Casco=%d, Vip=%d, Occhiali=%d, Cappello=%d, Dinamite=%d, Bomba=%d, Punti=%d, Mp3=%d, Parcheggio=%d, Spacciatore=%d, MaterialiDroga=%d, Bloccato=%d, Vita=%d, Armour=%d, Laser=%d, Weapon1=%d, Weapon1a=%d, Weapon2=%d, Weapon2a=%d, Weapon3=%d, Weapon3a=%d, Weapon4=%d, Weapon4a=%d, Weapon5=%d, Weapon5a=%d, Weapon6=%d, Weapon6a=%d, Weapon7=%d, Weapon7a=%d, \
Weapon8=%d, Weapon8a=%d, Weapon9=%d, Weapon9a=%d, Weapon10=%d, Weapon10a=%d, Weapon11=%d, Weapon11a=%d, Weapon12=%d, Weapon12a=%d, Garage=%d, Lavorato1=%d, Lavorato2=%d, Lavorato3=%d, Stilelotta=%d, FedinaPenale=%d, LivelloRicercato=%d WHERE utente='%s'",
PlayerInfo[playerid][pKey],
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pInt],
PlayerInfo[playerid][pVirWorld],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pJetpack],
PlayerInfo[playerid][pScripter],
PlayerInfo[playerid][pHelper],
PlayerInfo[playerid][pPAntidolorifica],
PlayerInfo[playerid][pPAntidroga],
PlayerInfo[playerid][pPRigenerazione],
PlayerInfo[playerid][pDonateRank],
PlayerInfo[playerid][pRegistered],
PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pCity],
PlayerInfo[playerid][pInvWeapon],
PlayerInfo[playerid][pInvAmmo],
PlayerInfo[playerid][pAge],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pCash],
PlayerInfo[playerid][pCents],
PlayerInfo[playerid][pBank],
PlayerInfo[playerid][pSkin],
PlayerInfo[playerid][pDroga],
PlayerInfo[playerid][pAssicuraz],
PlayerInfo[playerid][pUsoMaschera],
PlayerInfo[playerid][pOrologio],
PlayerInfo[playerid][pZaino],
PlayerInfo[playerid][pCorde],
PlayerInfo[playerid][pLottoNr],
PlayerInfo[playerid][pWalkietalkie],
PlayerInfo[playerid][pBenda],
PlayerInfo[playerid][pTrafficoCell],
PlayerInfo[playerid][pSigarette],
PlayerInfo[playerid][pRequestingBackup],
PlayerInfo[playerid][pAccendino],
PlayerInfo[playerid][pMaschera],
PlayerInfo[playerid][pDado],
PlayerInfo[playerid][pTomtom],
PlayerInfo[playerid][pCalcolatrice],
PlayerInfo[playerid][pMateriali],
PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pPlayingHours],
PlayerInfo[playerid][pAllowedPayday],
PlayerInfo[playerid][pPayCheck],
PlayerInfo[playerid][pFaction],
PlayerInfo[playerid][pClan],
PlayerInfo[playerid][pHeadQuarter],
PlayerInfo[playerid][pRank],
PlayerInfo[playerid][pHouseKey],
PlayerInfo[playerid][pBizKey],
PlayerInfo[playerid][pSpawnPoint],
PlayerInfo[playerid][pBanned],
PlayerInfo[playerid][pWarnings],
PlayerInfo[playerid][pArresti],
PlayerInfo[playerid][pLicenzaA],
PlayerInfo[playerid][pPcarkey],
PlayerInfo[playerid][pPcarkey2],
PlayerInfo[playerid][pPcarkey3],
PlayerInfo[playerid][pPcarkey4],
PlayerInfo[playerid][pPcarkey5],
PlayerInfo[playerid][pPcarkey6],
PlayerInfo[playerid][pPcarkey7],
PlayerInfo[playerid][pPcarkey8],
PlayerInfo[playerid][pPcarkey9],
PlayerInfo[playerid][pPcarkey10],
PlayerInfo[playerid][ChiavePrestata],
PlayerInfo[playerid][pLicenzaB],
PlayerInfo[playerid][pLicenzaC],
PlayerInfo[playerid][pLicenzaD],
PlayerInfo[playerid][pLicenzaVolo],
PlayerInfo[playerid][pLicenzaNautica],
PlayerInfo[playerid][pLicenzaArmi],
PlayerInfo[playerid][pPhoneNumber],
PlayerInfo[playerid][pPhoneC],
PlayerInfo[playerid][pPagineGialle],
PlayerInfo[playerid][pListNumber],
PlayerInfo[playerid][pDonatore],
PlayerInfo[playerid][pJailed],
PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pProducts],
PlayerInfo[playerid][pCrashX],
PlayerInfo[playerid][pCrashY],
PlayerInfo[playerid][pCrashZ],
PlayerInfo[playerid][pCrashInt],
PlayerInfo[playerid][pCrashW],
PlayerInfo[playerid][pCrashed],
PlayerInfo[playerid][pCasco],
PlayerInfo[playerid][pVip],
PlayerInfo[playerid][pOcchiali],
PlayerInfo[playerid][pCappello],
PlayerInfo[playerid][pDinamite],
PlayerInfo[playerid][pBomba],
PlayerInfo[playerid][pPunti],
PlayerInfo[playerid][pMp3],
PlayerInfo[playerid][pParcheggio],
PlayerInfo[playerid][pSpacciatore],
PlayerInfo[playerid][pMaterialiDroga],
PlayerInfo[playerid][pBloccato],
PlayerInfo[playerid][pVita],
PlayerInfo[playerid][pArmour],
PlayerInfo[playerid][pLaser],
PlayerInfo[playerid][pWeapon1],
PlayerInfo[playerid][pWeapon1a],
PlayerInfo[playerid][pWeapon2],
PlayerInfo[playerid][pWeapon2a],
PlayerInfo[playerid][pWeapon3],
PlayerInfo[playerid][pWeapon3a],
PlayerInfo[playerid][pWeapon4],
PlayerInfo[playerid][pWeapon4a],
PlayerInfo[playerid][pWeapon5],
PlayerInfo[playerid][pWeapon5a],
PlayerInfo[playerid][pWeapon6],
PlayerInfo[playerid][pWeapon6a],
PlayerInfo[playerid][pWeapon7],
PlayerInfo[playerid][pWeapon7a],
PlayerInfo[playerid][pWeapon8],
PlayerInfo[playerid][pWeapon8a],
PlayerInfo[playerid][pWeapon9],
PlayerInfo[playerid][pWeapon9a],
PlayerInfo[playerid][pWeapon10],
PlayerInfo[playerid][pWeapon10a],
PlayerInfo[playerid][pWeapon11],
PlayerInfo[playerid][pWeapon11a],
PlayerInfo[playerid][pWeapon12],
PlayerInfo[playerid][pWeapon12a],
PlayerInfo[playerid][pGarage],
PlayerInfo[playerid][pLavorato1],
PlayerInfo[playerid][pLavorato2],
PlayerInfo[playerid][pLavorato3],
PlayerInfo[playerid][pStilelotta],
PlayerInfo[playerid][pFedinaPenale],
PlayerInfo[playerid][pLivelloRicercato],
pname);
mysql_query(query);
}
}
return 1;
}
PHP код:
(28505 -- 28631) : fatal error 102: table overflow: "staging buffer"
