Dimosha1337
Дебютант
Доброго времени суток. В общем, суть обстоит в следующем. Когда игрок выходит с сервера, аккаунт должен сохраниться, но, по каким-то причинам, это не происходит, а именно выделено красным в коде ниже:
Не могу понять откуда берётся ещё одна " ' ". Всё перерыл. Кстати, этим же кодом аккаунты раньше сохранялись, переделал пару частей и не работает. Они никак не связаны между собой, поэтому от них проблем быть не может.
Сток сохранения аккаунта:
---------- Post added at 22:49 ---------- Previous post was at 22:15 ----------
Исправил. Закрыто.
Код:
[MySQL] Error (0): Failed to exeute query. 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 [COLOR="#FF0000"]'WHERE `ID` = '1''[/COLOR] at line 1.Сток сохранения аккаунта:
Код:
stock SaveAccount(playerid)
{
new query[2100], string[30];
if(IsAFexistAccount(PN(playerid)))
{
query = "UPDATE `Accounts` SET ";
acc_int_strcat(query, sizeof(query), "Level", PlayerInfo[playerid][pLevel]);
acc_int_strcat(query, sizeof(query), "Exp", PlayerInfo[playerid][pExp]);
acc_int_strcat(query, sizeof(query), "PlayHours", PlayerInfo[playerid][pPlayHours]);
acc_int_strcat(query, sizeof(query), "Sex", PlayerInfo[playerid][pSex]);
acc_int_strcat(query, sizeof(query), "Age", PlayerInfo[playerid][pAge]);
acc_int_strcat(query, sizeof(query), "Race", PlayerInfo[playerid][pRace]);
acc_int_strcat(query, sizeof(query), "Admin", PlayerInfo[playerid][pAdmin]);
acc_int_strcat(query, sizeof(query), "Helper", PlayerInfo[playerid][pHelper]);
acc_int_strcat(query, sizeof(query), "Money", PlayerInfo[playerid][pMoney]);
acc_int_strcat(query, sizeof(query), "Bank", PlayerInfo[playerid][pBank]);
acc_int_strcat(query, sizeof(query), "Wanted", PlayerInfo[playerid][pWanted]);
acc_int_strcat(query, sizeof(query), "VIP", PlayerInfo[playerid][pVIP]);
acc_int_strcat(query, sizeof(query), "Leader", PlayerInfo[playerid][pLeader]);
acc_int_strcat(query, sizeof(query), "Member", PlayerInfo[playerid][pMember]);
acc_int_strcat(query, sizeof(query), "Rank", PlayerInfo[playerid][pRank]);
acc_int_strcat(query, sizeof(query), "GunLic", PlayerInfo[playerid][pGunLic]);
acc_int_strcat(query, sizeof(query), "BoatLic", PlayerInfo[playerid][pBoatLic]);
acc_int_strcat(query, sizeof(query), "FishLic", PlayerInfo[playerid][pFishLic]);
acc_int_strcat(query, sizeof(query), "FlyLic", PlayerInfo[playerid][pFlyLic]);
acc_int_strcat(query, sizeof(query), "CarLic", PlayerInfo[playerid][pCarLic]);
acc_int_strcat(query, sizeof(query), "BikeLic", PlayerInfo[playerid][pBikeLic]);
acc_int_strcat(query, sizeof(query), "D_Packets", PlayerInfo[playerid][pD_Packets]);
acc_int_strcat(query, sizeof(query), "Warns", PlayerInfo[playerid][pWarns]);
acc_int_strcat(query, sizeof(query), "PayDay", PlayerInfo[playerid][pPayDay]);
acc_int_strcat(query, sizeof(query), "HouseKey", PlayerInfo[playerid][pHouseKey]);
acc_int_strcat(query, sizeof(query), "BizKey", PlayerInfo[playerid][pBizKey]);
acc_int_strcat(query, sizeof(query), "FWarns", PlayerInfo[playerid][pFWarns]);
acc_int_strcat(query, sizeof(query), "Skin", PlayerInfo[playerid][pSkin]);
acc_int_strcat(query, sizeof(query), "TelNum", PlayerInfo[playerid][pTelNum]);
acc_int_strcat(query, sizeof(query), "Phone", PlayerInfo[playerid][pPhone]);
acc_int_strcat(query, sizeof(query), "Mats", PlayerInfo[playerid][pMats]);
acc_int_strcat(query, sizeof(query), "Packets", PlayerInfo[playerid][pPackets]);
acc_int_strcat(query, sizeof(query), "Drugs", PlayerInfo[playerid][pDrugs]);
acc_int_strcat(query, sizeof(query), "Job", PlayerInfo[playerid][pJob]);
acc_int_strcat(query, sizeof(query), "MuteTime", PlayerInfo[playerid][pMuteTime]);
acc_int_strcat(query, sizeof(query), "FMuteTime", PlayerInfo[playerid][pFMuteTime]);
acc_int_strcat(query, sizeof(query), "JailTime", PlayerInfo[playerid][pJailTime]);
acc_int_strcat(query, sizeof(query), "BailPrice", PlayerInfo[playerid][pBailPrice]);
acc_int_strcat(query, sizeof(query), "KungfuStyle", PlayerInfo[playerid][pKungfu]);
acc_int_strcat(query, sizeof(query), "KneeheadStyle", PlayerInfo[playerid][pKneehead]);
acc_int_strcat(query, sizeof(query), "BoxingStyle", PlayerInfo[playerid][pBoxing]);
acc_int_strcat(query, sizeof(query), "ElbowStyle", PlayerInfo[playerid][pElbow]);
acc_int_strcat(query, sizeof(query), "Style", GetPlayerFightingStyle(playerid));
acc_int_strcat(query, sizeof(query), "Spawned", PlayerInfo[playerid][pSpawned]);
acc_int_strcat(query, sizeof(query), "NeSdal", NeSdal[playerid]);
acc_int_strcat(query, sizeof(query), "DropCarTime", PlayerInfo[playerid][pDCTime]);
acc_int_strcat(query, sizeof(query), "Drunk", PlayerDrunkLevel[playerid]);
acc_int_strcat(query, sizeof(query), "Spining", PlayerInfo[playerid][pSpining]);
acc_int_strcat(query, sizeof(query), "Worms", PlayerInfo[playerid][pWorms]);
acc_int_strcat(query, sizeof(query), "Lotto", PlayerInfo[playerid][pLotto]);
acc_int_strcat(query, sizeof(query), "Mask", PlayerInfo[playerid][pMask]);
acc_int_strcat(query, sizeof(query), "Roliki", PlayerInfo[playerid][pRoliki]);
acc_int_strcat(query, sizeof(query), "Fuel", PlayerInfo[playerid][pFuel]);
acc_int_strcat(query, sizeof(query), "PhoneBook", PlayerInfo[playerid][pPhoneBook]);
acc_int_strcat(query, sizeof(query), "Pistol_Skill", PlayerInfo[playerid][pPistol_Skill]);
acc_int_strcat(query, sizeof(query), "SDPistol_Skill", PlayerInfo[playerid][pSDPistol_Skill]);
acc_int_strcat(query, sizeof(query), "Eagle_Skill", PlayerInfo[playerid][pEagle_Skill]);
acc_int_strcat(query, sizeof(query), "ShotGun_Skill", PlayerInfo[playerid][pShotGun_Skill]);
acc_int_strcat(query, sizeof(query), "UZI_Skill", PlayerInfo[playerid][pUZI_Skill]);
acc_int_strcat(query, sizeof(query), "MP5_Skill", PlayerInfo[playerid][pMP5_Skill]);
acc_int_strcat(query, sizeof(query), "AK47_Skill", PlayerInfo[playerid][pAK47_Skill]);
acc_int_strcat(query, sizeof(query), "M4_Skill", PlayerInfo[playerid][pM4_Skill]);
acc_int_strcat(query, sizeof(query), "Sniper_Skill", PlayerInfo[playerid][pSniper_Skill]);
acc_int_strcat(query, sizeof(query), "Glasses", PlayerInfo[playerid][pGlasses]);
acc_int_strcat(query, sizeof(query), "Bandans", PlayerInfo[playerid][pBandans]);
acc_int_strcat(query, sizeof(query), "Hats", PlayerInfo[playerid][pHats]);
acc_int_strcat(query, sizeof(query), "IncReset", IncReset[playerid]);
acc_int_strcat(query, sizeof(query), "Syringe", PlayerInfo[playerid][pSyringe]);
acc_int_strcat(query, sizeof(query), "Poison", PlayerInfo[playerid][pPoison]);
acc_int_strcat(query, sizeof(query), "Smokes", PlayerInfo[playerid][pSigs]);
acc_int_strcat(query, sizeof(query), "Lighter", PlayerInfo[playerid][pLighter]);
acc_int_strcat(query, sizeof(query), "From", PlayerInfo[playerid][pFrom]);
acc_int_strcat(query, sizeof(query), "BlackList", PlayerInfo[playerid][pBL]);
acc_int_strcat(query, sizeof(query), "OOC", PlayerInfo[playerid][pOOC]);
acc_int_strcat(query, sizeof(query), "ZKP", PlayerInfo[playerid][pZKP]);
acc_int_strcat(query, sizeof(query), "CarPoundTime", CarPoundTime[playerid]);
acc_int_strcat(query, sizeof(query), "Heal", PlayerInfo[playerid][pHeal]);
acc_int_strcat(query, sizeof(query), "Fullness", Fullness[playerid]);
acc_int_strcat(query, sizeof(query), "Pack", PlayerInfo[playerid][pPack]);
acc_int_strcat(query, sizeof(query), "Sprunks", PlayerInfo[playerid][pSprunks]);
acc_int_strcat(query, sizeof(query), "Cheeps", PlayerInfo[playerid][pCheepses]);
acc_int_strcat(query, sizeof(query), "Radio", PlayerInfo[playerid][pRadio]);
acc_int_strcat(query, sizeof(query), "TruckReset", TruckReset[playerid]);
acc_int_strcat(query, sizeof(query), "Snow", PlayerInfo[playerid][pSnow]);
acc_int_strcat(query, sizeof(query), "VirMoney", PlayerInfo[playerid][pVirMoney]);
acc_int_strcat(query, sizeof(query), "OldRepl", PlayerInfo[playerid][pOldRepl]);
acc_int_strcat(query, sizeof(query), "AllRepl", PlayerInfo[playerid][pAllRepl]);
acc_int_strcat(query, sizeof(query), "Key", PlayerInfo[playerid][pKey]);
acc_int_strcat(query, sizeof(query), "KeyCheck", PlayerInfo[playerid][pKeyCheck]);
acc_int_strcat(query, sizeof(query), "StatsStyle", PlayerInfo[playerid][pStatsStyle]);
acc_int_strcat(query, sizeof(query), "Credit", PlayerInfo[playerid][pCredit]);
acc_int_strcat(query, sizeof(query), "EnterKey", PlayerInfo[playerid][pEnterKey]);
acc_int_strcat(query, sizeof(query), "View", PlayerInfo[playerid][pView]);
acc_int_strcat(query, sizeof(query), "FeFinder", PlayerInfo[playerid][pFeFinder]);
acc_int_strcat(query, sizeof(query), "Gold", PlayerInfo[playerid][pGold]);
acc_int_strcat(query, sizeof(query), "RepBan", PlayerInfo[playerid][pRepBan]);
acc_int_strcat(query, sizeof(query), "AskBan", PlayerInfo[playerid][pAskBan]);
acc_int_strcat(query, sizeof(query), "Clip", PlayerInfo[playerid][pClip]);
acc_int_strcat(query, sizeof(query), "ContractTime", PlayerInfo[playerid][pContractTime]);
acc_int_strcat(query, sizeof(query), "GunsUP", ResetGunsUP[playerid]);
acc_int_strcat(query, sizeof(query), "BuyGuns", ResetBuyGuns[playerid]);
acc_int_strcat(query, sizeof(query), "RPTest", PlayerInfo[playerid][pRPTest]);
acc_float_strcat(query, sizeof(query), "Energy", PlayerInfo[playerid][pEnergy]);
acc_int_strcat(query, sizeof(query), "RepPack", PlayerInfo[playerid][pRepPack]);
strdel(query, strlen(query)-1, strlen(query));
format(string,sizeof(string)," WHERE `ID` = '%i'",PlayerInfo[playerid][pID]);
strcat(query, string);
mysql_query(query);
}
else
{
printf("Внимание: Аккаунт '%s' не найден", PN(playerid));
}
return true;
}---------- Post added at 22:49 ---------- Previous post was at 22:15 ----------
Исправил. Закрыто.
Последнее редактирование: