Felar.Exe
Компетентный
Код:
[12:34:40] [ERROR] mysql_format - no value for specifier "%i" available
[12:34:40] [ERROR] mysql_format - no value for specifier "%i" available
[12:34:40] [ERROR] mysql_format - no value for specifier "%i" available
[12:34:40] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`Housecash` = '0',`Zvezdi` = '0',`BoxSkill` = '0',`Car` = '0' WHERE `Name` = 'An' at line 1
Код:
stock SavePlayer(playerid)
{
mysql_format(DATABASE, QUERY, sizeof(QUERY), "UPDATE `accounts` SET `Sex` = '%i',`Level` = '%i', `Exp` = '%i', `Age` = '%i', `Skin0` = '%i', `Skin1` = '%i', `Model` = '%i', `House` = '%i', `Bizz` = '%i'", PINFO[playerid][pSex], PINFO[playerid][pLVL], PINFO[playerid][pExp],PINFO[playerid][pAge],PINFO[playerid][pSkin][0],PINFO[playerid][pSkin][1],PINFO[playerid][pModel],PINFO[playerid][pHouse],PINFO[playerid][pBiznes]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s , `Adminlvl` = '%i', `Ochko` = '%i',`Mobile` = '%i', `Fuelcar` = '%i',`Text` = '%i',`SaveCuff` = '%i'", QUERY, PINFO[playerid][pAdminLVL],PINFO[playerid][pOchko],PINFO[playerid][pNomerMobile], PINFO[playerid][pFuelcar],PINFO[playerid][pText],PINFO[playerid][pSaveCuff], GN(playerid));
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s , `HP` = '%i', `EM_Proverka` = '%i',`Proverkaip` = '%i', `PhoneBook` = '%i',`Bolnica` = '%i'", QUERY, PINFO[playerid][pHP],PINFO[playerid][pEM_Proverka],PINFO[playerid][pIP_Proverka],PINFO[playerid][pPhoneBook],PINFO[playerid][pBolnica]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s , `Donateschet` = '%i', `LastDonate` = '%i',`Donatemoney` = '%i'", QUERY, PINFO[playerid][pDonatSchet], PINFO[playerid][pLastDonate], PINFO[playerid][pDonateMoney]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s , `Money` = '%i', `Bank` = '%i',`Kills` = '%i', `Deaths` = '%i',`JobZp` = '%i',`Jailed` = '%i',`JailTime` = '%i',`Mats` = '%i'", QUERY, PINFO[playerid][pCash],PINFO[playerid][pBank],PINFO[playerid][pKills],PINFO[playerid][pDeaths],PINFO[playerid][pJobZp],PINFO[playerid][pJailed],PINFO[playerid][pJailTime],PINFO[playerid][pMats]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s , `Drugs` = '%i', `Leader` = '%i',`Member` = '%i', `Rank` = '%i',`Job` = '%i',`VodPrava` = '%i',`BizLic` = '%i',`FlyLic` = '%i',`BoatLic` = '%i'", QUERY, PINFO[playerid][pDrugs],PINFO[playerid][pLeader],PINFO[playerid][pMember],PINFO[playerid][pRank],PINFO[playerid][pJob],PINFO[playerid][pVodPrava],PINFO[playerid][pBizLic],PINFO[playerid][pFlyLic],PINFO[playerid][pBoatLic]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s , `GunLic` = '%i', `SDPistol` = '%i',`Desert` = '%i', `Smg` = '%i',`AK47` = '%i',`M4` = '%i',`ShotGun` = '%i',`Number` = '%i',`Tutorial` = '%i'", QUERY, PINFO[playerid][pGunLic],PINFO[playerid][pGunSkill][0],PINFO[playerid][pGunSkill][1],PINFO[playerid][pGunSkill][2],PINFO[playerid][pGunSkill][3],PINFO[playerid][pGunSkill][4],PINFO[playerid][pGunSkill][5],PINFO[playerid][pPnumber],PINFO[playerid][pTut]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s , `Warns` = '%i', `unWarns` = '%i',`unWarnstime` = '%i', `Married` = '%i',`MuteTime` = '%i',`MobileC` = '%i'", QUERY, PINFO[playerid][pWarns],PINFO[playerid][punWarns],PINFO[playerid][punWarnstime],PINFO[playerid][pMarried],PINFO[playerid][pMuteTime],PINFO[playerid][pMobileBill]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s , `Zakonop` = '%i', `NarkoZavis` = '%i',`Proz` = '%i', `Avtomas` = '%i',`MestoJail` = '%i'", QUERY, PINFO[playerid][pZakonp],PINFO[playerid][pNZavism],PINFO[playerid][pCarProcents],PINFO[playerid][pAvtomas],PINFO[playerid][pMestoJail]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s , `Robbing` = '%i',`Hijack` = '%i',`Numbergame` = '%i',`DpExp` = '%i',`DpLvl` = '%i',`WantedDeaths` = '%i',`Golos` = '%i',`Fstyle` = '%i',`Polka` = '%i'", QUERY, PINFO[playerid][pRobbing],PINFO[playerid][pHijack],PINFO[playerid][pNumbergame],PINFO[playerid][DpExp],PINFO[playerid][DpLvl],PINFO[playerid][pWantedDeaths]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s , `TaxiSkill` = '%i',`TaxiExp` = '%i',`Sitost` = '%i',`Komnata` = '%i',`InFrac` = '%i',`bUgon` = '%i',`SpawnCH` = '%i',`Vigovor` = '%i'", QUERY, PINFO[playerid][pTaxiSkill],PINFO[playerid][pTaxiExp],PINFO[playerid][pSitost],PINFO[playerid][pKomnata],PINFO[playerid][pTimeInFrac],PINFO[playerid][pbUgon],PINFO[playerid][pSpawnCH],PINFO[playerid][pVigovor]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s , `Registered` = '%i',`Arrested` '%i',`Muted` = '%i',`Crimes` = '%i', `DonateRank` = '%i',`Directory` = '%i'", QUERY, PINFO[playerid][pReg],PINFO[playerid][pArrested],PINFO[playerid][pMuted],PINFO[playerid][pCrimes],PINFO[playerid][pVIP],PINFO[playerid][pDirectory]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s , `KongfuSkill` = '%i',`KickboxSkill` = '%i',`Keys` = '%i',`GameTime` = '%i',`Golos` = '%i',`Fstyle` = '%i',`Polka` = '%i'",QUERY, PINFO[playerid][pStyleSkill][1],PINFO[playerid][pStyleSkill][2],PINFO[playerid][pKeys],PINFO[playerid][pGameTime],PINFO[playerid][pGolos], PINFO[playerid][pFstyle], PINFO[playerid][pSkin][2]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s `Housecash` = '%i',`Zvezdi` = '%i',`BoxSkill` = '%i',`Car` = '%i' WHERE `Name` = '%e'",QUERY, PINFO[playerid][pHouseCash],PINFO[playerid][pZvezdi],PINFO[playerid][pStyleSkill][0],PINFO[playerid][pCar][0], GN(playerid));
mysql_function_query(DATABASE, QUERY, false, "", "");
}