medvedev633
Новичок
День добрый. Проблема следующая: при сохранении аккаунта одна целая переменная, почему-то присваивает значение 85. Первая - это уровень. Если уровень уже равен 85, то следующая переменная присваивает значение 85. И так дальше по цепочке. Почему это происходит - понять не могу. MySQL log никаких ошибок не выдаёт.
Код, отвечающий за сохранение аккаунта:
Скриншот:
Код, отвечающий за сохранение аккаунта:
PHP:
mysql_format(DATABASE,QUERY,sizeof(QUERY),"UPDATE `"TABLE_ACCOUNTS"` SET `pLevel` = '%d',`pAdmin` = '%d',`pPlaceJail` = '%d',`pHousecash` = '%d',`pCheckip` = '%d',`pText` = '%d'",
QUERY, PlayerInfo[i][pLevel],PlayerInfo[i][pAdmin],PlayerInfo[i][pPlaceJail],PlayerInfo[i][pHousecash],PlayerInfo[i][pCheckip],PlayerInfo[i][pText]);
mysql_format(DATABASE,QUERY,sizeof(QUERY),"%s, `pSatiety` = '%d', `pMes` = '%d', `pGod` = '%d', `pCar` = '%d', `pFuelCar` = '%f', `pProcents` = '%d', `pDonateRank` = '%d', `pDonateMoney` = '%d', `pReg` = '%d'",
QUERY, PlayerInfo[i][pSatiety], PlayerInfo[i][pMes], PlayerInfo[i][pGod], PlayerInfo[i][pCar], PlayerInfo[i][pFuelCar], PlayerInfo[i][pProcents], PlayerInfo[i][pDonateRank], PlayerInfo[i][pDonateMoney], PlayerInfo[i][pReg]);
mysql_format(DATABASE,QUERY,sizeof(QUERY),"%s, `pMaterials` = '%d', `pSex` = '%d', `pArrested` = '%d', `pMuted` = '%d', `pCrimes` = '%d', `pExp` = '%d', `pCash` = '%d', `pKills` = '%d', `pDeaths` = '%d', `pWantedDeaths` = '%d'",
QUERY, PlayerInfo[i][pMaterials], PlayerInfo[i][pSex], PlayerInfo[i][pArrested], PlayerInfo[i][pMuted], PlayerInfo[i][pCrimes], PlayerInfo[i][pExp], PlayerInfo[i][pCash], PlayerInfo[i][pKills], PlayerInfo[i][pDeaths], PlayerInfo[i][pWantedDeaths]);
mysql_format(DATABASE,QUERY,sizeof(QUERY),"%s, `pPayCheck` = '%d', `pJailed` = '%d', `pJailTime` = '%d', `pWins` = '%d', `pLoses` = '%d', `pCDPlayer` = '%d', `pDrugs` = '%d', `pLeader` = '%d', `pMember` = '%d', `pRank` = '%d'",
QUERY, PlayerInfo[i][pPayCheck], PlayerInfo[i][pJailed], PlayerInfo[i][pJailTime], PlayerInfo[i][pWins], PlayerInfo[i][pLoses], PlayerInfo[i][pCDPlayer], PlayerInfo[i][pDrugs], PlayerInfo[i][pLeader], PlayerInfo[i][pMember], PlayerInfo[i][pRank]);
mysql_format(DATABASE,QUERY,sizeof(QUERY),"%s, `pChar` = '%d', `pJob` = '%d', `pInt` = '%d', `pLocal` = '%d', `pModel` = '%d', `pPnumber` = '%d', `pPhoneBook` = '%d', `pDirectory` = '%d'",
QUERY, PlayerInfo[i][pChar], PlayerInfo[i][pJob], PlayerInfo[i][pInt], PlayerInfo[i][pLocal], PlayerInfo[i][pModel], PlayerInfo[i][pPnumber], PlayerInfo[i][pPhoneBook], PlayerInfo[i][pDirectory]);
mysql_format(DATABASE,QUERY,sizeof(QUERY),"%s, `pVhoddata` = '%d', `pVhodMes` = '%d', `pVhodchas` = '%d', `pVhodminute` = '%d', `pCarLic` = '%d', `pFlyLic` = '%d', `pBoatLic` = '%d', `pFishLic` = '%d', `pGunLic` = '%d', `pBisLic` = '%d'",
QUERY, PlayerInfo[i][pVhoddata], PlayerInfo[i][pVhodMes], PlayerInfo[i][pVhodchas], PlayerInfo[i][pVhodminute], PlayerInfo[i][pCarLic], PlayerInfo[i][pFlyLic], PlayerInfo[i][pBoatLic], PlayerInfo[i][pFishLic], PlayerInfo[i][pGunLic], PlayerInfo[i][pBisLic]);
mysql_format(DATABASE,QUERY,sizeof(QUERY),"%s, `pNkeys` = '%d', `pPHousekey` = '%d', `pPBiskey` = '%d', `pAutoMast` = '%d', `pLabiding` = '%d', `pAddiction` = '%d', `pPayDay` = '%d', `pPayDayHad` = '%d', `pTut` = '%d', `pWarns` = '%d', `punWarns` = '%d', `punWarnstime` = '%d'",
QUERY, PlayerInfo[i][pNkeys], PlayerInfo[i][pPHousekey], PlayerInfo[i][pPBiskey], PlayerInfo[i][pAutoMast], PlayerInfo[i][pLabiding], PlayerInfo[i][pAddiction], PlayerInfo[i][pPayDay], PlayerInfo[i][pPayDayHad], PlayerInfo[i][pTut], PlayerInfo[i][pWarns], PlayerInfo[i][punWarns], PlayerInfo[i][punWarnstime]);
mysql_format(DATABASE,QUERY,sizeof(QUERY),"%s, `pFuel` = '%d', `pMarried` = '%d', `pMarriedTo` = '%s', `pMushrooms` = '%d', `pTicket` = '%d', `pTicketNr1` = '%d', `pTicketNr2` = '%d', `pTicketNr3` = '%d', `pTicketWin` = '%d', `pRadio` = '%d', `pFishes` = '%d', `pFriendMoney` = '%d'",
QUERY, PlayerInfo[i][pFuel], PlayerInfo[i][pMarried], PlayerInfo[i][pMarriedTo], PlayerInfo[i][pMushrooms], PlayerInfo[i][pTicket], PlayerInfo[i][pTicketNr][0], PlayerInfo[i][pTicketNr][1], PlayerInfo[i][pTicketNr][2], PlayerInfo[i][pTicketWin], PlayerInfo[i][pRadio], PlayerInfo[i][pFishes], PlayerInfo[i][pFriendMoney]);
mysql_format(DATABASE,QUERY,sizeof(QUERY),"%s, `pMuteTime` = '%d', `pBank` = '%d', `pKazpay` = '%d', `pDonateAccount` = '%d', `pDostup` = '%d', `pMobile` = '%d', `pLocked` = '%d', `pDebt` = '%d', `pMafiaRoof` = '%d', `pUseMafiaRoof` = '%d', `pWantedLevel` = '%d', `pAntiCheat` = '%d'",
QUERY, PlayerInfo[i][pMuteTime], PlayerInfo[i][pBank], PlayerInfo[i][pKazpay], PlayerInfo[i][pDonateAccount],PlayerInfo[i][pDostup], PlayerInfo[i][pMobile], PlayerInfo[i][pLocked], PlayerInfo[i][pDebt], PlayerInfo[i][pMafiaRoof], PlayerInfo[i][pUseMafiaRoof], PlayerInfo[i][pWantedLevel], PlayerInfo[i][pAntiCheat]);
mysql_format(DATABASE,QUERY,sizeof(QUERY),"%s, `pSlot0` = '%d', `pSlot1` = '%d', `pSlot2` = '%d', `pSlot3` = '%d', `pSlot4` = '%d', `pSlot5` = '%d', `pSlot6` = '%d', `pSlot7` = '%d', `pSlot8` = '%d', `pSlot9` = '%d', `pSlot10` = '%d', `pSlot11` = '%d', `pSlot12` = '%d'",
QUERY, PlayerInfo[i][pSlot][0], PlayerInfo[i][pSlot][1], PlayerInfo[i][pSlot][2], PlayerInfo[i][pSlot][3], PlayerInfo[i][pSlot][4], PlayerInfo[i][pSlot][5], PlayerInfo[i][pSlot][6], PlayerInfo[i][pSlot][7], PlayerInfo[i][pSlot][8], PlayerInfo[i][pSlot][9], PlayerInfo[i][pSlot][10], PlayerInfo[i][pSlot][11], PlayerInfo[i][pSlot][12]);
mysql_format(DATABASE,QUERY,sizeof(QUERY),"%s, `pSlotammo0` = '%d', `pSlotammo1` = '%d', `pSlotammo2` = '%d', `pSlotammo3` = '%d', `pSlotammo4` = '%d', `pSlotammo5` = '%d', `pSlotammo6` = '%d', `pSlotammo7` = '%d', `pSlotammo8` = '%d', `pSlotammo9` = '%d', `pSlotammo10` = '%d', `pSlotammo11` = '%d', `pSlotammo12` = '%d'",
QUERY, PlayerInfo[i][pSlotammo][0], PlayerInfo[i][pSlotammo][1], PlayerInfo[i][pSlotammo][2], PlayerInfo[i][pSlotammo][3], PlayerInfo[i][pSlotammo][4], PlayerInfo[i][pSlotammo][5], PlayerInfo[i][pSlotammo][6], PlayerInfo[i][pSlotammo][7], PlayerInfo[i][pSlotammo][8], PlayerInfo[i][pSlotammo][9], PlayerInfo[i][pSlotammo][10], PlayerInfo[i][pSlotammo][11], PlayerInfo[i][pSlotammo][12]);
mysql_format(DATABASE,QUERY,sizeof(QUERY),"%s, `pGunSkill0` = '%d', `pGunSkill1` = '%d', `pGunSkill2` = '%d', `pGunSkill3` = '%d', `pGunSkill4` = '%d', `pGunSkill5` = '%d'",
QUERY, PlayerInfo[i][pGunSkill][0], PlayerInfo[i][pGunSkill][1], PlayerInfo[i][pGunSkill][2], PlayerInfo[i][pGunSkill][3], PlayerInfo[i][pGunSkill][4], PlayerInfo[i][pGunSkill][5]);
mysql_format(DATABASE,QUERY,sizeof(QUERY),"%s, `pTaxiExp` = '%d', `pTaxiLvl` = '%d', `pCarRobbingExp` = '%d', `pBoxstyle` = '%d', `pKstyle` = '%d', `pKickstyle` = '%d', `pBoxSkill` = '%d', `pKongfuSkill` = '%d', `pKickboxSkill` = '%d', `pDLevel` = '%d', `pDExp` = '%d', `pDMgruz` = '%d', `pDgruz` = '%d'",
QUERY, PlayerInfo[i][pTaxiExp], PlayerInfo[i][pTaxiLvl], PlayerInfo[i][pCarRobbingExp], PlayerInfo[i][pBoxstyle], PlayerInfo[i][pKstyle], PlayerInfo[i][pKickstyle], PlayerInfo[i][pBoxSkill], PlayerInfo[i][pKongfuSkill], PlayerInfo[i][pKickboxSkill], PlayerInfo[i][pDLevel], PlayerInfo[i][pDExp], PlayerInfo[i][pDMgruz], PlayerInfo[i][pDgruz]);
mysql_format(DATABASE,QUERY,sizeof(QUERY),"%s, `pFerma` = '%d', `pFermazarobotok` = '%d', `pFermajob` = '%d', `pWheels` = '%d', `pPaintJob` = '%d', `pSpoiler` = '%d', `pBumper1` = '%d', `pBumper2` = '%d', `pColor` = '%d', `pColor1` = '%d', `pNitro` = '%d', `pHydrawlic` = '%d'",
QUERY, PlayerInfo[i][pFerma], PlayerInfo[i][pFermazarobotok], PlayerInfo[i][pFermajob], PlayerInfo[i][pWheels], PlayerInfo[i][pPaintJob], PlayerInfo[i][pSpoiler], PlayerInfo[i][pBumper1], PlayerInfo[i][pBumper2], PlayerInfo[i][pColor], PlayerInfo[i][pColor1], PlayerInfo[i][pNitro], PlayerInfo[i][pHydrawlic]);
mysql_format(DATABASE,QUERY,sizeof(QUERY),"%s, `pIsSpy` = '%d', `pTicketDebt` = '%d', `pArticle` = '%d', `pDeathHospital` = '%d', `pAvitaminoz` = '%d', `pAvitaminozHeal` = '%d', `pVSD` = '%d', `pVSDStat` = '%d', `pAddictionHeal` = '%d', `pVote` = '%d', `pBail` = '%d', `pMask` = '%d'",
QUERY, PlayerInfo[i][pIsSpy], PlayerInfo[i][pTicketDebt], PlayerInfo[i][pArticle], PlayerInfo[i][pDeathHospital], PlayerInfo[i][pAvitaminoz], PlayerInfo[i][pAvitaminozHeal], PlayerInfo[i][pVSD], PlayerInfo[i][pVSDStat], PlayerInfo[i][pAddictionHeal], PlayerInfo[i][pVote], PlayerInfo[i][pBail], PlayerInfo[i][pMask]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s WHERE `pNickName` = '%e'", QUERY, PlayerInfo[i][pNickName]);
mysql_function_query(DATABASE, QUERY, false, "", "");
SCM(i,COLOR_GREEN,"Аккаунт сохранён");
Последнее редактирование: