yousher
Ученик
Здравствуйте ув.форумчане.
Сегодня одного мода перевел с mxINI на Mysql r39-6
Со всеми запросами всё ок, но когда Update сервер падает
Апдейт для сохранении аккаунта вот мой код:
А так-же мои стоки:
Сегодня одного мода перевел с mxINI на Mysql r39-6
Со всеми запросами всё ок, но когда Update сервер падает
Апдейт для сохранении аккаунта вот мой код:
PHP:
new query[5500],string[5500];
if(IsPlayerConnected(playerid) && IsPlayerLogged[playerid] == 1)
{
// new string[132];
new year, month, day, hour, minute, second;
getdate(year, month, day);
gettime(hour, minute, second);
new playername[MAX_PLAYER_NAME+4];
GetPlayerName(playerid, playername, sizeof(playername));
query = "UPDATE `"TABLE_ACCOUNT"` SET ";
PlayerInfo[playerid][pCash] = GetSRVMoney(playerid);
acc_int_strcat(query, sizeof(query), "satiety", PlayerInfo[playerid][pSitost]);
acc_int_strcat(query, sizeof(query), "pAlcoInvenxua", PlayerInfo[playerid][pAdmin]);
acc_int_strcat(query, sizeof(query), "pSigarets", PlayerInfo[playerid][pSiga]);
acc_int_strcat(query, sizeof(query), "pJajgalka", PlayerInfo[playerid][pJajgal]);
acc_int_strcat(query, sizeof(query), "pPolka1", PlayerInfo[playerid][pPolka1]);
acc_int_strcat(query, sizeof(query), "pPolka2", PlayerInfo[playerid][pPolka2]);
acc_int_strcat(query, sizeof(query), "pPolka3", PlayerInfo[playerid][pPolka3]);
acc_int_strcat(query, sizeof(query), "pPolka4", PlayerInfo[playerid][pPolka4]);
acc_int_strcat(query, sizeof(query), "pPolka5", PlayerInfo[playerid][pPolka5]);
acc_int_strcat(query, sizeof(query), "pSSd", PlayerInfo[playerid][pSSd]);
acc_int_strcat(query, sizeof(query), "pSDeag", PlayerInfo[playerid][pSDeag]);
acc_int_strcat(query, sizeof(query), "pSShot", PlayerInfo[playerid][pSShot]);
acc_int_strcat(query, sizeof(query), "pSSMG", PlayerInfo[playerid][pSSMG]);
acc_int_strcat(query, sizeof(query), "pSAK", PlayerInfo[playerid][pSAK]);
acc_int_strcat(query, sizeof(query), "pSM4", PlayerInfo[playerid][pSM4]);
acc_int_strcat(query, sizeof(query), "pSReaf", PlayerInfo[playerid][pSReaf]);
acc_int_strcat(query, sizeof(query), "pInvWeapon", PlayerInfo[playerid][pInvWeapon]);
acc_int_strcat(query, sizeof(query), "pInvWeapon1", PlayerInfo[playerid][pInvWeapon1]);
acc_int_strcat(query, sizeof(query), "pInvWeapon2", PlayerInfo[playerid][pInvWeapon2]);
acc_int_strcat(query, sizeof(query), "pInvAmmo", PlayerInfo[playerid][pInvAmmo]);
acc_int_strcat(query, sizeof(query), "pInvAmmo1", PlayerInfo[playerid][pInvAmmo1]);
acc_int_strcat(query, sizeof(query), "pInvAmmo2", PlayerInfo[playerid][pInvAmmo2]);
acc_int_strcat(query, sizeof(query), "pDrug", PlayerInfo[playerid][pDrug]);
acc_int_strcat(query, sizeof(query), "pAlarm", PlayerInfo[playerid][pAlarm]);
acc_int_strcat(query, sizeof(query), "pVisobr", PlayerInfo[playerid][pVisobr]);
acc_int_strcat(query, sizeof(query), "pSredobr", PlayerInfo[playerid][pSredobr]);
acc_int_strcat(query, sizeof(query), "pMehdip", PlayerInfo[playerid][pMehdip]);
acc_int_strcat(query, sizeof(query), "pChass", PlayerInfo[playerid][pChass]);
acc_int_strcat(query, sizeof(query), "pDrugmoney", PlayerInfo[playerid][pDrugmoney]);
acc_int_strcat(query, sizeof(query), "pElecdip", PlayerInfo[playerid][pElecdip]);
acc_int_strcat(query, sizeof(query), "pVrachdip", PlayerInfo[playerid][pVrachdip]);
acc_int_strcat(query, sizeof(query), "pCherniySpisok", PlayerInfo[playerid][pCherniySpisok]);
acc_int_strcat(query, sizeof(query), "pStaj", PlayerInfo[playerid][pStaj]);
acc_int_strcat(query, sizeof(query), "pQuest", PlayerInfo[playerid][pQuest]);
acc_int_strcat(query, sizeof(query), "pZad", PlayerInfo[playerid][pZad]);
acc_int_strcat(query, sizeof(query), "pZadd", PlayerInfo[playerid][pZadd]);
acc_int_strcat(query, sizeof(query), "pVipolnil", PlayerInfo[playerid][pVipolnil]);
acc_int_strcat(query, sizeof(query), "pQuestt", PlayerInfo[playerid][pQuestt]);
acc_int_strcat(query, sizeof(query), "pQuesttt", PlayerInfo[playerid][pQuesttt]);
acc_int_strcat(query, sizeof(query), "pQuestttt", PlayerInfo[playerid][pQuestttt]);
acc_int_strcat(query, sizeof(query), "pQuesttttt", PlayerInfo[playerid][pQuesttttt]);
acc_int_strcat(query, sizeof(query), "pQuestttttt", PlayerInfo[playerid][pQuestttttt]);
acc_int_strcat(query, sizeof(query), "pQuesttttttt", PlayerInfo[playerid][pQuesttttttt]);
acc_int_strcat(query, sizeof(query), "pQuestttttttt", PlayerInfo[playerid][pQuestttttttt]);
acc_int_strcat(query, sizeof(query), "pQuesttttttttt", PlayerInfo[playerid][pQuesttttttttt]);
acc_int_strcat(query, sizeof(query), "pQuestttttttttt", PlayerInfo[playerid][pQuestttttttttt]);
acc_int_strcat(query, sizeof(query), "pQuesttttttttttt", PlayerInfo[playerid][pQuesttttttttttt]);
acc_int_strcat(query, sizeof(query), "pDokkvart", PlayerInfo[playerid][pDokkvart]);
acc_int_strcat(query, sizeof(query), "pAlarm2", PlayerInfo[playerid][pAlarm2]);
acc_float_strcat(query, sizeof(query), "pArm", PlayerInfo[playerid][pArm]);
acc_int_strcat(query, sizeof(query), "pLocked", PlayerInfo[playerid][pLocked]);
acc_int_strcat(query, sizeof(query), "pBanTime", PlayerInfo[playerid][pBanTime]);
acc_int_strcat(query, sizeof(query), "pBandans", PlayerInfo[playerid][pBandans]);
acc_int_strcat(query, sizeof(query), "pBank", PlayerInfo[playerid][pBank]);
acc_int_strcat(query, sizeof(query), "pPbiskey", PlayerInfo[playerid][pPbiskey]);
acc_int_strcat(query, sizeof(query), "pBomba", PlayerInfo[playerid][pBomba]);
acc_int_strcat(query, sizeof(query), "pCarKey", PlayerInfo[playerid][pCarKey]);
acc_int_strcat(query, sizeof(query), "pCarKey2", PlayerInfo[playerid][pCarKey2]);
acc_int_strcat(query, sizeof(query), "pChar", PlayerInfo[playerid][pChar]);
acc_int_strcat(query, sizeof(query), "pCrimes", PlayerInfo[playerid][pCrimes]);
acc_int_strcat(query, sizeof(query), "pCaps", PlayerInfo[playerid][pCaps]);
acc_int_strcat(query, sizeof(query), "pCarTime", PlayerInfo[playerid][pCarTime]);
acc_int_strcat(query, sizeof(query), "pDeaths", PlayerInfo[playerid][pDeaths]);
acc_int_strcat(query, sizeof(query), "pDolg", PlayerInfo[playerid][pDolg]);
acc_int_strcat(query, sizeof(query), "pDonateMoney", PlayerInfo[playerid][pDonateMoney]);
acc_int_strcat(query, sizeof(query), "pDonateRank", PlayerInfo[playerid][pDonateRank]);
acc_int_strcat(query, sizeof(query), "pDonateRankTime", PlayerInfo[playerid][pDonateRankTime]);
acc_int_strcat(query, sizeof(query), "pDrugs", PlayerInfo[playerid][pDrugs]);
acc_int_strcat(query, sizeof(query), "pFuel", PlayerInfo[playerid][pFuel]);
acc_int_strcat(query, sizeof(query), "pJackSkill", PlayerInfo[playerid][pJackSkill]);
acc_int_strcat(query, sizeof(query), "pJobTime", PlayerInfo[playerid][pJobTime]);
acc_int_strcat(query, sizeof(query), "pJailed", PlayerInfo[playerid][pJailed]);
acc_int_strcat(query, sizeof(query), "pJailTime", PlayerInfo[playerid][pJailTime]);
acc_int_strcat(query, sizeof(query), "pJob", PlayerInfo[playerid][pJob]);
acc_int_strcat(query, sizeof(query), "pHelper", PlayerInfo[playerid][pHelper]);
acc_float_strcat(query, sizeof(query), "pHP", PlayerInfo[playerid][pHP]);
acc_int_strcat(query, sizeof(query), "pGlasses", PlayerInfo[playerid][pGlasses]);
acc_int_strcat(query, sizeof(query), "pGolos", PlayerInfo[playerid][pGolos]);
acc_int_strcat(query, sizeof(query), "pRoliki", PlayerInfo[playerid][pRoliki]);
acc_int_strcat(query, sizeof(query), "pHospital", PlayerInfo[playerid][pHospital]);
acc_int_strcat(query, sizeof(query), "pPhousekey", PlayerInfo[playerid][pPhousekey]);
acc_int_strcat(query, sizeof(query), "pHouseCash", PlayerInfo[playerid][pHouseCash]);
acc_int_strcat(query, sizeof(query), "pHats", PlayerInfo[playerid][pHats]);
acc_int_strcat(query, sizeof(query), "pInt", PlayerInfo[playerid][pInt]);
acc_int_strcat(query, sizeof(query), "pKills", PlayerInfo[playerid][pKills]);
acc_int_strcat(query, sizeof(query), "pKrisha", PlayerInfo[playerid][pKrisha]);
acc_int_strcat(query, sizeof(query), "pLevel", PlayerInfo[playerid][pLevel]);
acc_int_strcat(query, sizeof(query), "pLeader", PlayerInfo[playerid][pLeader]);
acc_int_strcat(query, sizeof(query), "pEntered", PlayerInfo[playerid][pEntered]);
acc_int_strcat(query, sizeof(query), "pLotto", PlayerInfo[playerid][pLotto]);
acc_int_strcat(query, sizeof(query), "pModel", PlayerInfo[playerid][pModel]);
acc_int_strcat(query, sizeof(query), "pMolitva", PlayerInfo[playerid][pMolitva]);
acc_int_strcat(query, sizeof(query), "pMarried", PlayerInfo[playerid][pMarried]);
acc_int_strcat(query, sizeof(query), "pMats", PlayerInfo[playerid][pMats]);
acc_int_strcat(query, sizeof(query), "pMember", PlayerInfo[playerid][pMember]);
acc_int_strcat(query, sizeof(query), "pMuted", PlayerInfo[playerid][pMuted]);
acc_int_strcat(query, sizeof(query), "pSIMBalance", PlayerInfo[playerid][pSIMBalance]);
acc_int_strcat(query, sizeof(query), "pCash", PlayerInfo[playerid][pCash]);
acc_int_strcat(query, sizeof(query), "pMuteTime", PlayerInfo[playerid][pMuteTime]);
acc_int_strcat(query, sizeof(query), "pNoTeam", PlayerInfo[playerid][pNoTeam]);
acc_int_strcat(query, sizeof(query), "pNarcoZavisimost", PlayerInfo[playerid][pNarcoZavisimost]);
acc_int_strcat(query, sizeof(query), "pNarcoLomka", PlayerInfo[playerid][pNarcoLomka]);
acc_int_strcat(query, sizeof(query), "pForma", PlayerInfo[playerid][pForma]);
acc_int_strcat(query, sizeof(query), "pPassport", PlayerInfo[playerid][pPassport]);
acc_int_strcat(query, sizeof(query), "pBuyCar", PlayerInfo[playerid][pBuyCar]);
acc_int_strcat(query, sizeof(query), "pDokuments", PlayerInfo[playerid][pDokuments]);
acc_int_strcat(query, sizeof(query), "pNumbdoks", PlayerInfo[playerid][pNumbdoks]);
acc_int_strcat(query, sizeof(query), "pArrested", PlayerInfo[playerid][pArrested]);
acc_int_strcat(query, sizeof(query), "pAvtomas", PlayerInfo[playerid][pAvtomas]);
acc_int_strcat(query, sizeof(query), "pKeys", PlayerInfo[playerid][pKeys]);
acc_int_strcat(query, sizeof(query), "pMestoJail", PlayerInfo[playerid][pMestoJail]);
acc_int_strcat(query, sizeof(query), "pPhoneBook", PlayerInfo[playerid][pPhoneBook]);
acc_int_strcat(query, sizeof(query), "pPhone", PlayerInfo[playerid][pPhone]);
acc_int_strcat(query, sizeof(query), "pDrugmoney", PlayerInfo[playerid][pDrugmoney]);
acc_int_strcat(query, sizeof(query), "pAKey", PlayerInfo[playerid][pAKey]);
acc_int_strcat(query, sizeof(query), "pPhoneDir", PlayerInfo[playerid][pPhoneDir]);
acc_int_strcat(query, sizeof(query), "pSIM", PlayerInfo[playerid][pSIM]);
acc_int_strcat(query, sizeof(query), "pPayDay", PlayerInfo[playerid][pPayDay]);
acc_int_strcat(query, sizeof(query), "pPayDayHad", PlayerInfo[playerid][pPayDayHad]);
acc_int_strcat(query, sizeof(query), "pPayCheck", PlayerInfo[playerid][pPayCheck]);
acc_int_strcat(query, sizeof(query), "pRank", PlayerInfo[playerid][pRank]);
acc_int_strcat(query, sizeof(query), "pReg", PlayerInfo[playerid][pReg]);
acc_int_strcat(query, sizeof(query), "pSeatBelt", PlayerInfo[playerid][pSeatBelt]);
acc_int_strcat(query, sizeof(query), "pExp", PlayerInfo[playerid][pExp]);
acc_int_strcat(query, sizeof(query), "pKeys", PlayerInfo[playerid][pKeys]);
acc_int_strcat(query, sizeof(query), "pRasiya", PlayerInfo[playerid][pRasiya]);
acc_int_strcat(query, sizeof(query), "pRP", PlayerInfo[playerid][pRp]);
acc_int_strcat(query, sizeof(query), "pSpawnChange", PlayerInfo[playerid][pSpawnChange]);
acc_int_strcat(query, sizeof(query), "pSex", PlayerInfo[playerid][pSex]);
acc_int_strcat(query, sizeof(query), "pText", PlayerInfo[playerid][pText]);
acc_int_strcat(query, sizeof(query), "pTut", 1);
acc_int_strcat(query, sizeof(query), "pUseKrisha", PlayerInfo[playerid][pUseKrisha]);
acc_int_strcat(query, sizeof(query), "pAVig", PlayerInfo[playerid][pAVig]);
acc_int_strcat(query, sizeof(query), "pSpawned", PlayerInfo[playerid][pSpawned]);
acc_int_strcat(query, sizeof(query), "pVig", PlayerInfo[playerid][pVig]);
acc_int_strcat(query, sizeof(query), "pVoennik", PlayerInfo[playerid][pVoennik]);
acc_int_strcat(query, sizeof(query), "pWarns", PlayerInfo[playerid][pWarns]);
acc_int_strcat(query, sizeof(query), "pWarnsTime", PlayerInfo[playerid][pWarnsTime]);
acc_int_strcat(query, sizeof(query), "pRingtone", PlayerInfo[playerid][pRingtone]);
acc_int_strcat(query, sizeof(query), "pZakonp", PlayerInfo[playerid][pZakonp]);
acc_int_strcat(query, sizeof(query), "pWanted", PlayerInfo[playerid][pWanted]);
acc_int_strcat(query, sizeof(query), "pVodPrava", PlayerInfo[playerid][pVodPrava]);
acc_int_strcat(query, sizeof(query), "pBizLic", PlayerInfo[playerid][pBizLic]);
acc_int_strcat(query, sizeof(query), "pFlyLic", PlayerInfo[playerid][pFlyLic]);
acc_int_strcat(query, sizeof(query), "pBoatLic", PlayerInfo[playerid][pBoatLic]);
acc_int_strcat(query, sizeof(query), "pFishLic", PlayerInfo[playerid][pFishLic]);
acc_int_strcat(query, sizeof(query), "pGunLic", PlayerInfo[playerid][pGunLic]);
acc_int_strcat(query, sizeof(query), "pSlot2", PlayerInfo[playerid][pSlot2]);
acc_int_strcat(query, sizeof(query), "pSlot3", PlayerInfo[playerid][pSlot3]);
acc_int_strcat(query, sizeof(query), "pSlot4", PlayerInfo[playerid][pSlot4]);
acc_int_strcat(query, sizeof(query), "pSlot5", PlayerInfo[playerid][pSlot5]);
acc_int_strcat(query, sizeof(query), "pSlot6", PlayerInfo[playerid][pSlot6]);
acc_int_strcat(query, sizeof(query), "pSlot7", PlayerInfo[playerid][pSlot7]);
acc_int_strcat(query, sizeof(query), "pSlotammo2", PlayerInfo[playerid][pSlotammo2]);
acc_int_strcat(query, sizeof(query), "pSlotammo3", PlayerInfo[playerid][pSlotammo3]);
acc_int_strcat(query, sizeof(query), "pSlotammo4", PlayerInfo[playerid][pSlotammo4]);
acc_int_strcat(query, sizeof(query), "pSlotammo5", PlayerInfo[playerid][pSlotammo5]);
acc_int_strcat(query, sizeof(query), "pSlotammo6", PlayerInfo[playerid][pSlotammo6]);
acc_int_strcat(query, sizeof(query), "pSlotammo7", PlayerInfo[playerid][pSlotammo7]);
acc_float_strcat(query, sizeof(query), "pSDPistol", PlayerInfo[playerid][pSDPistol]);
acc_float_strcat(query, sizeof(query), "pDesertEagle", PlayerInfo[playerid][pDesertEagle]);
acc_float_strcat(query, sizeof(query), "pShotGun", PlayerInfo[playerid][pShotGun]);
acc_float_strcat(query, sizeof(query), "pMP5", PlayerInfo[playerid][pMP5]);
acc_float_strcat(query, sizeof(query), "pAK47", PlayerInfo[playerid][pAK47]);
acc_float_strcat(query, sizeof(query), "pM4", PlayerInfo[playerid][pM4]);
acc_int_strcat(query, sizeof(query), "pBoxSkill", PlayerInfo[playerid][pBoxSkill]);
acc_int_strcat(query, sizeof(query), "pKongFuSkill", PlayerInfo[playerid][pKongFuSkill]);
acc_int_strcat(query, sizeof(query), "pKickBoxSkill", PlayerInfo[playerid][pKickBoxSkill]);
acc_int_strcat(query, sizeof(query), "pMuteReason", PlayerInfo[playerid][pMuteReason]);
acc_int_strcat(query, sizeof(query), "pPrisonReason", PlayerInfo[playerid][pPrisonReason]);
acc_int_strcat(query, sizeof(query), "pPrisonAvtor", PlayerInfo[playerid][pPrisonAvtor]);
acc_int_strcat(query, sizeof(query), "pWarnReason", PlayerInfo[playerid][pWarnReason]);
acc_int_strcat(query, sizeof(query), "pWarnAvtor1", PlayerInfo[playerid][pWarnAvtor1]);
acc_int_strcat(query, sizeof(query), "pWarnAvtor2", PlayerInfo[playerid][pWarnAvtor2]);
acc_int_strcat(query, sizeof(query), "pWarnAvtor3", PlayerInfo[playerid][pWarnAvtor3]);
acc_int_strcat(query, sizeof(query), "pBanAvtor", PlayerInfo[playerid][pBanAvtor]);
acc_int_strcat(query, sizeof(query), "Muzika", PlayerInfo[playerid][pMuzika]);
acc_int_strcat(query, sizeof(query), "pSila", PlayerInfo[playerid][pSila]);
//acc_int_strcat(query, sizeof(query), "pSeatBelt", PlayerInfo[playerid][pSeatBelt]);
GetPlayerIp(playerid,string,sizeof(string));
acc_float_strcat(query, sizeof(query), "pvIp", strval(string));
//------
acc_int_strcat(query, sizeof(query), "pKazino", PlayerInfo[playerid][pKazino]);
acc_int_strcat(query, sizeof(query), "pKRank", PlayerInfo[playerid][pKRank]);
acc_int_strcat(query, sizeof(query), "pKazpay", PlayerInfo[playerid][pKazpay]);
strdel(query, strlen(query)-1, strlen(query));//Удаляем запятую
format(string,sizeof(string)," WHERE `pID` = '%d'",PlayerInfo[playerid][pID]);
strcat(query, string);
mysql_tquery(connects, query, "", "");
printf("save 5");
}
PHP:
stock acc_int_strcat(query[], len, name[], number)
{
new string[100];
format(string, sizeof(string), "`%s` = '%d',",name, number);
strcat(query, string, len);
return true;
}
stock acc_float_strcat(query[], len, name[], Float:number)
{
new string[100];
format(string, sizeof(string), "`%s` = '%f',", name, number);
strcat(query, string, len);
return true;
}
stock acc_str_strcat(query[], len, name[], str[])
{
new string[100];
format(string, sizeof(string), "`%s` = '%s',",name, str);
strcat(query, string, len);
return true;
}