Cruiser
Ученик
Столкнулся с проблемой сохранения аккаунтов, надо сохранить чуть больше 100 пунктов, сохраняю при помощи: mysql_query, при комплиировании ошибок 0, но когда включается функция сохранения, то мод слетает, и это из за того что слишком много надо сделать сохранений(при уменьшении количества пунктов все ок), есть ли способы сократить ниже приведенный код, или может есть способы решения проблемы?
PHP:
new string[3072];
new zam1[512], zam2[512], zam3[512], zam4[512], zam5[512], zam6[512];
format(zam1, sizeof(zam1), "UPDATE `Accounts` `Level` = '%d', `AdminLevel` = '%d', `HelperLevel` = '%d', `DonateRank` = '%d', `DonateRankTime` = '%d'\
, `UpgradePoints` = '%d', `ConnectedTime` = '%d', `Registered` = '%d', `Sex` = '%d', `Age` = '%d', `Origin` = '%d', `Muted` = '%d', `MuteTime` = '%d', `FMuted` = '%d'",
PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pHelper], PlayerInfo[playerid][pDonateRank], PlayerInfo[playerid][pDonateRankTime],
PlayerInfo[playerid][gPupgrade],PlayerInfo[playerid][pConnectTime],PlayerInfo[playerid][pReg],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pAge],
PlayerInfo[playerid][pOrigin],PlayerInfo[playerid][pMute],PlayerInfo[playerid][pMuteTime],PlayerInfo[playerid][pFMute]);
format(zam2, sizeof(zam2), ", `FMuteTime` = '%d', `Respect` = '%d', `Money` = '%d', `Bank` = '%d', `Crimes` = '%d', `Deaths` = '%d', `Arresteed` = '%d', `WantedDeaths` = '%d', `Phonebook` = '%d'\
, `LottoNr` = '%d', `Fishes` = '%d', `BiggestFish` = '%d', `Job` = '%d', `Paycheck` = '%d', `HeadValue` = '%d', `Jailed` = '%d', `JailTime` = '%d', `Materials` = '%d'",
PlayerInfo[playerid][pFMuteTime],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pMoney],PlayerInfo[playerid][pAccount],PlayerInfo[playerid][pCrimes],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][pMats]);
format(zam3, sizeof(zam3), ", `Drugs` = '%d', `Leader` = '%d', `Member` = '%d', `Rank` = '%d', `Char` = '%d', `DetSkill` = '%d', `SexSkill` = '%d', `BoxSkill` = '%d', `LawSkill` = '%d', `MechSkill` = '%d'\
, `JackSkill` = '%d', `CarSkill` = '%d', `NewsSkill` = '%d', `DrugsSkill` = '%d', `CookSkill` = '%d', `FishSkill` = '%d', `CourierSkill` = '%d', `RDrugsSkill` = '%d', `pSHealth` = '%d'",
PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember],PlayerInfo[playerid][pRank],PlayerInfo[playerid][pChar],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][pCourierSkill],PlayerInfo[playerid][pCourierSkill],PlayerInfo[playerid][pSHealth]);
format(zam4, sizeof(zam4), ", `pHealth` = '%d', `Int` = '%d', `Local` = '%d', `Team` = '%d', `PhoneNr` = '%d', `House` = '%d', `VipHouse` = '%d', `Bizz` = '%d', `CarLic` = '%d', `FlyLic` = '%d'\
, `BoatLic` = '%d', `FishLic` = '%d', `GunLic` = '%d', `MotoLic` = '%d', `CarTime` = '%d', `PayDay` = '%d', `PayDayHad` = '%d', `CDPlayer` = '%d', `Wins` = '%d', `Loses` = '%d'",
PlayerInfo[playerid][pHealth],PlayerInfo[playerid][pInt],PlayerInfo[playerid][pLocal],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pPnumber],PlayerInfo[playerid][pPhousekey],PlayerInfo[playerid][pVipHousekey],
PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pCarLic],PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pFishLic],PlayerInfo[playerid][pGunLic],PlayerInfo[playerid][pMotoLic],
PlayerInfo[playerid][pCarTime],PlayerInfo[playerid][pPayDay],PlayerInfo[playerid][pPayDayHad],PlayerInfo[playerid][pCDPlayer],PlayerInfo[playerid][pWins],PlayerInfo[playerid][pLoses]);
format(zam5, sizeof(zam5), ", `AlcoholPerk` = '%d', `DrugPerk` = '%d', `MiserPerk` = '%d', `PainPerk` = '%d', `TraderPerk` = '%d', `Tutorial` = '%d', `Rent` = '%d', `RentVip` = '%d', `Warnings` = '%d'\
, `TanikMoney` = '%d', `TanikDrugs` = '%d', `TanikMats` = '%d', `Adjustable` = '%d', `Fuel` = '%d', `Married` = '%d', `MarriedTo` = '%s', `Wanted` = '%d', `Plant` = '%d'",
PlayerInfo[playerid][pAlcoholPerk],PlayerInfo[playerid][pDrugPerk],PlayerInfo[playerid][pMiserPerk],PlayerInfo[playerid][pPainPerk],PlayerInfo[playerid][pTraderPerk],PlayerInfo[playerid][pTut],PlayerInfo[playerid][pRent],PlayerInfo[playerid][pRentVip],
PlayerInfo[playerid][pWarns],PlayerInfo[playerid][ptMoney],PlayerInfo[playerid][ptDrugs],PlayerInfo[playerid][ptMats],PlayerInfo[playerid][pAdjustable],PlayerInfo[playerid][pFuel],PlayerInfo[playerid][pMarried],PlayerInfo[playerid][pMarriedTo],
PlayerInfo[playerid][pWanted],PlayerInfo[playerid][pPlant]);
format(zam6, sizeof(zam6), ", `Trava` = '%d', `Chest` = '%d', `FWarn` = '%d', `Medicaments` = '%d', `Flatkey` = '%d', `RadioSet` = '%d', `TexOsmotr` = '%d', `TexOsmotrTime` = '%d', `AdminVig` = '%d'\
, `Nounban` = '%d', `Kolban` = '%d', `Donate` = '%d', `Reputathion` = '%d', `VoenBilet` = '%d', `VoenBiletStage` = '%d', `VisaLS` = '%d', `Skin1` = '%d', `Skin2` = '%d', `Skin3` = '%d'\
, `SummaKredita` = '%d', `OplataKredita` = '%d', `Shapka` = '%d', `Passport` = '%d', `MedCarta` = '%d'",
PlayerInfo[playerid][pTrava],PlayerInfo[playerid][pChest],PlayerInfo[playerid][pFWarns],PlayerInfo[playerid][pMedicaments],PlayerInfo[playerid][pFlatKey],PlayerInfo[playerid][pRadio],PlayerInfo[playerid][pTexOsmotr],
PlayerInfo[playerid][pTexOsmotrTime],PlayerInfo[playerid][pAdminVig],PlayerInfo[playerid][pNounban],PlayerInfo[playerid][pKolban],PlayerInfo[playerid][pDonate],PlayerInfo[playerid][pReputathion],
PlayerInfo[playerid][pVoenBilet],PlayerInfo[playerid][pObyzanVoen],PlayerInfo[playerid][pVisaLS],PlayerInfo[playerid][pSkin1],PlayerInfo[playerid][pSkin2],PlayerInfo[playerid][pSkin3],
PlayerInfo[playerid][pSumKredit],PlayerInfo[playerid][pOplataKredit],PlayerInfo[playerid][pShapka],PlayerInfo[playerid][pPassport],PlayerInfo[playerid][pMedCarta]);
format(string,sizeof(string),"%s%s%s%s%s%s", zam1,zam2,zam3,zam4,zam5,zam6);
new tudakuda[3584];
format(tudakuda, sizeof(tudakuda),"%s WHERE `Name` = '%s'", string, Name(playerid));
mysql_query(tudakuda, -1, 0, connectionHandle);