Доступ к архиву

Переход в группу "Пользователь"

300.00 ₽
Одноразовый платёж
Быстрый переход в группу "Пользователи", без надобности написания постов и ожидания.

Покупка дает возможность:
Быть полноправным участником форума
Нормальное копирование кода
Создавать темы
Скачивать файлы
Доступ к архиву Pawno-Info

Проблема с сохранением аккаунтов в mysql

Статус
В этой теме нельзя размещать новые ответы.
game-over16

game-over16

Умник
Добрый вечер, столкнулся с такой проблемой, назначаю игрока лидером, после рекконекта в игру у него слетает лидерка.

Вот код стока сохранения аккаунтов:
PHP: 
stock SaveAccount(playerid)
{
    new query[3100];
    if(!IsPlayerLogged[playerid])return false;
    query = "UPDATE `qelksekm` SET ";
    acc_int_strcat(query, sizeof(query), "Level", PI[playerid][pLevel]);
	acc_int_strcat(query, sizeof(query), "Exp", PI[playerid][pExp]);
	acc_int_strcat(query, sizeof(query), "PlayHours", PI[playerid][pPlayHours]);
	acc_int_strcat(query, sizeof(query), "Sex", PI[playerid][pSex]);
	acc_int_strcat(query, sizeof(query), "Age", PI[playerid][pAge]);
	acc_int_strcat(query, sizeof(query), "Race", PI[playerid][pRace]);
	acc_int_strcat(query, sizeof(query), "Admin", PI[playerid][pAdmin]);
	acc_int_strcat(query, sizeof(query), "Helper", PI[playerid][pHelper]);
	acc_int_strcat(query, sizeof(query), "Money", PI[playerid][pMoney]);
	acc_int_strcat(query, sizeof(query), "Bank", PI[playerid][pBank]);
	acc_int_strcat(query, sizeof(query), "Wanted", PI[playerid][pWanted]);
	acc_int_strcat(query, sizeof(query), "VIP", PI[playerid][pVIP]);
	acc_int_strcat(query, sizeof(query), "Leader", PI[playerid][pLeader]);
	acc_int_strcat(query, sizeof(query), "Member", PI[playerid][pMember]);
	acc_int_strcat(query, sizeof(query), "Rank", PI[playerid][pRank]);
	acc_int_strcat(query, sizeof(query), "GunLic", PI[playerid][pGunLic]);
	acc_int_strcat(query, sizeof(query), "BoatLic", PI[playerid][pBoatLic]);
	acc_int_strcat(query, sizeof(query), "FishLic", PI[playerid][pFishLic]);
	acc_int_strcat(query, sizeof(query), "FlyLic", PI[playerid][pFlyLic]);
	acc_int_strcat(query, sizeof(query), "CarLic", PI[playerid][pCarLic]);
	acc_int_strcat(query, sizeof(query), "BikeLic", PI[playerid][pBikeLic]);
	acc_int_strcat(query, sizeof(query), "D_Packets", PI[playerid][pD_Packets]);
	acc_int_strcat(query, sizeof(query), "Warns", PI[playerid][pWarns]);
	acc_int_strcat(query, sizeof(query), "PayDay", PI[playerid][pPayDay]);
	acc_int_strcat(query, sizeof(query), "HouseKey", PI[playerid][pHouseKey]);
	acc_int_strcat(query, sizeof(query), "BizKey", PI[playerid][pBizKey]);
	acc_int_strcat(query, sizeof(query), "FWarns", PI[playerid][pFWarns]);
	acc_int_strcat(query, sizeof(query), "Skin", PI[playerid][pSkin]);
	acc_int_strcat(query, sizeof(query), "TelNum", PI[playerid][pTelNum]);
	acc_int_strcat(query, sizeof(query), "Phone", PI[playerid][pPhone]);
	acc_int_strcat(query, sizeof(query), "Mats", PI[playerid][pMats]);
	acc_int_strcat(query, sizeof(query), "Packets", PI[playerid][pPackets]);
	acc_int_strcat(query, sizeof(query), "Drugs", PI[playerid][pDrugs]);
	acc_int_strcat(query, sizeof(query), "Job", PI[playerid][pJob]);
	acc_int_strcat(query, sizeof(query), "MuteTime", PI[playerid][pMuteTime]);
	acc_int_strcat(query, sizeof(query), "FMuteTime", PI[playerid][pFMuteTime]);
	acc_int_strcat(query, sizeof(query), "JailTime", PI[playerid][pJailTime]);
	acc_int_strcat(query, sizeof(query), "BailPrice", PI[playerid][pBailPrice]);
	acc_int_strcat(query, sizeof(query), "KungfuStyle", PI[playerid][pKungfu]);
	acc_int_strcat(query, sizeof(query), "KneeheadStyle", PI[playerid][pKneehead]);
	acc_int_strcat(query, sizeof(query), "BoxingStyle", PI[playerid][pBoxing]);
	acc_int_strcat(query, sizeof(query), "ElbowStyle", PI[playerid][pElbow]);
	acc_int_strcat(query, sizeof(query), "Style", GetPlayerFightingStyle(playerid));
	acc_int_strcat(query, sizeof(query), "Spawned", PI[playerid][pSpawned]);
	acc_int_strcat(query, sizeof(query), "NeSdal", NeSdal[playerid]);
	acc_int_strcat(query, sizeof(query), "DropCarTime", PI[playerid][pDCTime]);
	acc_int_strcat(query, sizeof(query), "Drunk", PlayerDrunkLevel[playerid]);
	acc_int_strcat(query, sizeof(query), "Spining", PI[playerid][pSpining]);
	acc_int_strcat(query, sizeof(query), "Worms", PI[playerid][pWorms]);
	acc_int_strcat(query, sizeof(query), "Lotto", PI[playerid][pLotto]);
	acc_int_strcat(query, sizeof(query), "Mask", PI[playerid][pMask]);
	acc_int_strcat(query, sizeof(query), "Roliki", PI[playerid][pRoliki]);
	acc_int_strcat(query, sizeof(query), "Fuel", PI[playerid][pFuel]);
	acc_int_strcat(query, sizeof(query), "PhoneBook", PI[playerid][pPhoneBook]);
	acc_int_strcat(query, sizeof(query), "Pistol_Skill", PI[playerid][pPistol_Skill]);
	acc_int_strcat(query, sizeof(query), "SDPistol_Skill", PI[playerid][pSDPistol_Skill]);
	acc_int_strcat(query, sizeof(query), "Eagle_Skill", PI[playerid][pEagle_Skill]);
 	acc_int_strcat(query, sizeof(query), "ShotGun_Skill", PI[playerid][pShotGun_Skill]);
 	acc_int_strcat(query, sizeof(query), "UZI_Skill", PI[playerid][pUZI_Skill]);
	acc_int_strcat(query, sizeof(query), "MP5_Skill", PI[playerid][pMP5_Skill]);
	acc_int_strcat(query, sizeof(query), "AK47_Skill", PI[playerid][pAK47_Skill]);
	acc_int_strcat(query, sizeof(query), "M4_Skill", PI[playerid][pM4_Skill]);
	acc_int_strcat(query, sizeof(query), "Sniper_Skill", PI[playerid][pSniper_Skill]);
	acc_int_strcat(query, sizeof(query), "Glasses", PI[playerid][pGlasses]);
	acc_int_strcat(query, sizeof(query), "Bandans", PI[playerid][pBandans]);
	acc_int_strcat(query, sizeof(query), "Hats", PI[playerid][pHats]);
	acc_int_strcat(query, sizeof(query), "IncReset", IncReset[playerid]);
	acc_int_strcat(query, sizeof(query), "Syringe", PI[playerid][pSyringe]);
	acc_int_strcat(query, sizeof(query), "Poison", PI[playerid][pPoison]);
	acc_int_strcat(query, sizeof(query), "Smokes", PI[playerid][pSigs]);
	acc_int_strcat(query, sizeof(query), "Lighter", PI[playerid][pLighter]);
	acc_int_strcat(query, sizeof(query), "From", PI[playerid][pFrom]);
	acc_int_strcat(query, sizeof(query), "BlackList", PI[playerid][pBL]);
	acc_int_strcat(query, sizeof(query), "OOC", PI[playerid][pOOC]);
	acc_int_strcat(query, sizeof(query), "ZKP", PI[playerid][pZKP]);
	acc_int_strcat(query, sizeof(query), "CarPoundTime", CarPoundTime[playerid]);
	acc_int_strcat(query, sizeof(query), "Heal", PI[playerid][pHeal]);
	acc_int_strcat(query, sizeof(query), "Fullness", Fullness[playerid]);
	acc_int_strcat(query, sizeof(query), "Pack", PI[playerid][pPack]);
	acc_int_strcat(query, sizeof(query), "Sprunks", PI[playerid][pSprunks]);
	acc_int_strcat(query, sizeof(query), "Cheeps", PI[playerid][pCheepses]);
	acc_int_strcat(query, sizeof(query), "Radio", PI[playerid][pRadio]);
	acc_int_strcat(query, sizeof(query), "TruckReset", TruckReset[playerid]);
	acc_int_strcat(query, sizeof(query), "Snow", PI[playerid][pSnow]);
	acc_int_strcat(query, sizeof(query), "VirMoney", PI[playerid][pVirMoney]);
	acc_int_strcat(query, sizeof(query), "OldRepl", PI[playerid][pOldRepl]);
	acc_int_strcat(query, sizeof(query), "AllRepl", PI[playerid][pAllRepl]);
	acc_int_strcat(query, sizeof(query), "GetBonus", PI[playerid][pGetBonus]);
	acc_int_strcat(query, sizeof(query), "Key", PI[playerid][pKey]);
	acc_int_strcat(query, sizeof(query), "KeyCheck", PI[playerid][pKeyCheck]);
	acc_int_strcat(query, sizeof(query), "StatsStyle", PI[playerid][pStatsStyle]);
	acc_int_strcat(query, sizeof(query), "Credit", PI[playerid][pCredit]);
	acc_int_strcat(query, sizeof(query), "EnterKey", PI[playerid][pEnterKey]);
	acc_int_strcat(query, sizeof(query), "View", PI[playerid][pView]);
	acc_int_strcat(query, sizeof(query), "FeFinder", PI[playerid][pFeFinder]);
	acc_int_strcat(query, sizeof(query), "Gold", PI[playerid][pGold]);
	acc_int_strcat(query, sizeof(query), "RepBan", PI[playerid][pRepBan]);
	acc_int_strcat(query, sizeof(query), "AskBan", PI[playerid][pArmours]);
	acc_int_strcat(query, sizeof(query), "Clip", PI[playerid][pClip]);
	acc_int_strcat(query, sizeof(query), "ContractTime", PI[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", PI[playerid][pRPTest]);
	acc_int_strcat(query, sizeof(query), "Energy", PI[playerid][pEnergy]);
	acc_int_strcat(query, sizeof(query), "RepPack", PI[playerid][pRepPack]);
	acc_int_strcat(query, sizeof(query), "F_Skill", PI[playerid][pF_Skill]);
	acc_int_strcat(query, sizeof(query), "P_Skill", PI[playerid][pP_Skill]);
	acc_int_strcat(query, sizeof(query), "Z_Skill", PI[playerid][pZ_Skill]);
	acc_int_strcat(query, sizeof(query), "Za_Skill", PI[playerid][pZa_Skill]);
	acc_int_strcat(query, sizeof(query), "In_Skill", PI[playerid][pIn_Skill]);
	acc_int_strcat(query, sizeof(query), "My_Skill", PI[playerid][pMy_Skill]);
	acc_int_strcat(query, sizeof(query), "By_Skill", PI[playerid][pBy_Skill]);
	acc_str_strcat(query, sizeof(query), "Merrit", PI[playerid][pMerrit]);
	acc_str_strcat(query, sizeof(query), "Mail", PlayerMail[playerid]);
	acc_float_strcat(query, sizeof(query), "HP", PI[playerid][pHealth]);
	acc_int_strcat(query, sizeof(query), "Walentin", PI[playerid][pWalentin]);
	acc_int_strcat(query, sizeof(query), "BuyWalent", PI[playerid][pBuyWalent]);
	acc_int_strcat(query, sizeof(query), "TimeToLastWarn", PI[playerid][pTimeToLastWarn]);
	acc_int_strcat(query, sizeof(query), "pSlotItem0", PI[playerid][pSlotItem][0]);
	acc_int_strcat(query, sizeof(query), "pSlotItem1", PI[playerid][pSlotItem][1]);
	acc_int_strcat(query, sizeof(query), "pSlotItem2", PI[playerid][pSlotItem][2]);
	acc_int_strcat(query, sizeof(query), "pSlotItem3", PI[playerid][pSlotItem][3]);
	acc_int_strcat(query, sizeof(query), "pSlotItem4", PI[playerid][pSlotItem][4]);
	acc_int_strcat(query, sizeof(query), "pSlotItem5", PI[playerid][pSlotItem][5]);
	acc_int_strcat(query, sizeof(query), "Redio", PI[playerid][pRedio]);
	acc_int_strcat(query, sizeof(query), "Hospital", PI[playerid][pHospital]);
	acc_int_strcat(query, sizeof(query), "HavePassword", PI[playerid][pHavePassword]);
	acc_int_strcat(query, sizeof(query), "More", PI[playerid][pMore]);
	acc_int_strcat(query, sizeof(query), "Cheepsq", PI[playerid][pCheeps]);
	acc_int_strcat(query, sizeof(query), "Sprunkq", PI[playerid][pSprunk]);
	acc_int_strcat(query, sizeof(query), "Beerq", PI[playerid][pBeer]);
	acc_str_strcat(query, sizeof(query), "LastIP", PI[playerid][pLastIP]);
	acc_str_strcat(query, sizeof(query), "LastLogin", PI[playerid][pLastLogin]);
	acc_int_strcat(query, sizeof(query), "ShowCase", PI[playerid][pShowCase]);
	acc_int_strcat(query, sizeof(query), "VipTime", PI[playerid][pVipTime]);
	acc_int_strcat(query, sizeof(query), "pAsker", PI[playerid][pAsker]); //Ðàíã õåëïåðà
	acc_int_strcat(query, sizeof(query), "pHellpers", PI[playerid][pHellpers]); // Äîëæíîñòü õåëïåðà
	acc_int_strcat(query, sizeof(query), "pMedo", PI[playerid][pMedo]); // Äèïëîì Ìåäà
    acc_int_strcat(query, sizeof(query), "pMedoPar", PI[playerid][pMedoPar]); // Âûïèñêà Ìåäà
 	acc_int_strcat(query, sizeof(query), "pPol", PI[playerid][pMedo]); // Âûïèñêà ìåíòà
    acc_int_strcat(query, sizeof(query), "pPolPar", PI[playerid][pMedoPar]); // àíêåòà ìåíòà

	new weaponstr[500];
	for(new x; x < 13; x ++)
	{
	    new gun, ammo; GetPlayerWeaponData(playerid, x, gun, ammo);
		format(weaponstr, sizeof(weaponstr), "%s%d %d ",weaponstr, (gun<PI[playerid][pGuns][x])?gun:PI[playerid][pGuns][x], (ammo<PI[playerid][pAmmos][x])?ammo:PI[playerid][pAmmos][x]);
	}
    acc_str_strcat(query, sizeof(query), "Weapons", weaponstr);
	strdel(query, strlen(query)-1, strlen(query));
	format(query,sizeof(query),"%s WHERE `ID`='%i'",query, PI[playerid][pID]);
	mysql_query(mysql, query, false);
	return true;
}

И лог mysql
PHP: 
[18:29:16] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('151')
[18:29:16] [ERROR] cache_get_row_int - invalid datatype
[18:29:41] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[18:33:59] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('151')
[18:33:59] [ERROR] cache_get_row_int - invalid datatype
[18:34:03] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[18:40:09] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('151')
[18:40:09] [ERROR] cache_get_row_int - invalid datatype
[18:41:33] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[18:50:05] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('151')
[18:50:05] [ERROR] cache_get_row_int - invalid datatype
[18:50:19] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[19:58:44] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('151')
[19:58:44] [ERROR] cache_get_row_int - invalid datatype
[20:00:32] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[20:10:25] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('151')
[20:10:25] [ERROR] cache_get_row_int - invalid datatype
[20:26:08] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('151')
[20:26:08] [ERROR] cache_get_row_int - invalid datatype
[20:27:08] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[20:47:10] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('151')
[20:47:10] [ERROR] cache_get_row_int - invalid datatype
[20:49:57] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[20:55:27] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('151')
[20:55:27] [ERROR] cache_get_row_int - invalid datatype
[21:37:23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('152')
[21:37:23] [ERROR] cache_get_row_int - invalid datatype
[21:38:26] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[21:41:01] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('152')
[21:41:01] [ERROR] cache_get_row_int - invalid datatype
[21:41:07] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[21:55:28] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[22:14:14] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('152')
[22:14:14] [ERROR] cache_get_row_int - invalid datatype
[22:29:06] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[22:31:56] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('152')
[22:31:56] [ERROR] cache_get_row_int - invalid datatype
[22:32:47] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[22:54:20] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('152')
[22:54:20] [ERROR] cache_get_row_int - invalid datatype
[22:57:11] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[22:57:15] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[23:07:02] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('152')
[23:07:02] [ERROR] cache_get_row_int - invalid datatype
[23:20:09] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[23:24:06] [ERROR] cache_get_row_int - invalid datatype
[23:24:06] [ERROR] cache_get_row_int - invalid datatype
[23:24:06] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('152')
[23:24:06] [ERROR] cache_get_row_int - invalid datatype
[23:24:25] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[23:33:13] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[23:37:08] [WARNING] cache_get_field_content_int - no active cache
[23:37:29] [WARNING] cache_get_field_content_int - no active cache
[23:38:02] [WARNING] cache_get_field_content_int - no active cache
[23:38:22] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[23:40:24] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[23:43:32] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[23:43:36] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[23:44:35] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[00:17:05] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[00:17:18] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'
[00:18:24] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pMedoPar' in 'field list'


---------- Сообщение добавлено в 00:46 ---------- Предыдущее сообщение добавлено в 00:34 ----------

Все решил
 
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу