Статистика аккаунта обнуляется

Duka · 26 Июл 2015

После каждого перезахода статистика обнуляется .(дома пропадают, лидерки, деньги и т.д) и через 10-15 минут мод еще и отключается.
Точно не знаю в чем проблема, вроде этот строка для этого отвечает
OnPlayerUpdateAc

HTML:

publics: OnPlayerUpdateAc(playerid)
{
	new query[4500];
	new string[228];
	if(IsPlayerConnected(playerid))
	{
		if(p_info[playerid][pLogin] == 1)
		{
			query = "UPDATE `accounts` SET ";
			acc_int_strcat(query, sizeof(query), "pLevel", p_info[playerid][pLevel]);
			acc_int_strcat(query, sizeof(query), "pPhousekey", p_info[playerid][pPhousekey]);
			acc_int_strcat(query, sizeof(query), "pPbiskey", p_info[playerid][pPbiskey]);
			acc_int_strcat(query, sizeof(query), "pAdminxzk", p_info[playerid][pAdminxzk]);
			acc_int_strcat(query, sizeof(query), "pHelper", p_info[playerid][pHelper]);
			acc_int_strcat(query, sizeof(query), "pForma", p_info[playerid][pForma]);
			acc_int_strcat(query, sizeof(query), "pJobHeal", p_info[playerid][pJobHeal]);
			acc_int_strcat(query, sizeof(query), "pJobHealLeader", p_info[playerid][pJobHealLeader]);
			acc_float_strcat(query, sizeof(query), "pFuelcar", p_info[playerid][pFuelcar]);
			acc_int_strcat(query, sizeof(query), "pText", p_info[playerid][pText]);
			acc_int_strcat(query, sizeof(query), "pHP", p_info[playerid][pHP]);
			acc_int_strcat(query, sizeof(query), "pSatiety", p_info[playerid][pSatiety]);
			acc_int_strcat(query, sizeof(query), "pCheckip", p_info[playerid][pCheckip]);
			acc_int_strcat(query, sizeof(query), "pPhoneBook", p_info[playerid][pPhoneBook]);
			acc_int_strcat(query, sizeof(query), "pDirectory", p_info[playerid][pDirectory]);
			acc_int_strcat(query, sizeof(query), "pAlcoholPerk", p_info[playerid][pAlcoholPerk]);
			acc_int_strcat(query, sizeof(query), "pCar", p_info[playerid][pCar]);
			acc_int_strcat(query, sizeof(query), "pDonateMoney", p_info[playerid][pDonateMoney]);
			acc_int_strcat(query, sizeof(query), "pDonateRank", p_info[playerid][pDonateRank]);
			acc_int_strcat(query, sizeof(query), "pReg", p_info[playerid][pReg]);
			acc_int_strcat(query, sizeof(query), "pSex", p_info[playerid][pSex]);
			acc_int_strcat(query, sizeof(query), "pArrested", p_info[playerid][pArrested]);
			acc_int_strcat(query, sizeof(query), "pMuted", p_info[playerid][pMuted]);
			acc_int_strcat(query, sizeof(query), "pCrimes", p_info[playerid][pCrimes]);
			acc_int_strcat(query, sizeof(query), "pExp", p_info[playerid][pExp]);
			acc_int_strcat(query, sizeof(query), "pCash", p_info[playerid][pCash]);
			acc_int_strcat(query, sizeof(query), "pKills", p_info[playerid][pKills]);
			acc_int_strcat(query, sizeof(query), "pDeaths", p_info[playerid][pDeaths]);
			acc_int_strcat(query, sizeof(query), "pPayCheck", p_info[playerid][pPayCheck]);
			acc_int_strcat(query, sizeof(query), "pJailed", p_info[playerid][pJailed]);
			acc_int_strcat(query, sizeof(query), "pJailTime", p_info[playerid][pJailTime]);
			acc_int_strcat(query, sizeof(query), "pMats", p_info[playerid][pMats]);
			acc_int_strcat(query, sizeof(query), "pDrugs", p_info[playerid][pDrugs]);
			acc_int_strcat(query, sizeof(query), "pLeader", p_info[playerid][pLeader]);
			acc_int_strcat(query, sizeof(query), "pMember", p_info[playerid][pMember]);
			acc_int_strcat(query, sizeof(query), "pRank", p_info[playerid][pRank]);
			acc_int_strcat(query, sizeof(query), "pJob", p_info[playerid][pJob]);
			acc_int_strcat(query, sizeof(query), "pCarLic", p_info[playerid][pCarLic]);
			acc_int_strcat(query, sizeof(query), "pBizLic", p_info[playerid][pBizLic]);
			acc_int_strcat(query, sizeof(query), "pFlyLic", p_info[playerid][pFlyLic]);
			acc_int_strcat(query, sizeof(query), "pBoatLic", p_info[playerid][pBoatLic]);
			acc_int_strcat(query, sizeof(query), "pFishLic", p_info[playerid][pFishLic]);
			acc_int_strcat(query, sizeof(query), "pGunLic", p_info[playerid][pGunLic]);
			acc_int_strcat(query, sizeof(query), "pSlot1", p_info[playerid][pSlot1]);
			acc_int_strcat(query, sizeof(query), "pSlot2", p_info[playerid][pSlot2]);
			acc_int_strcat(query, sizeof(query), "pSlot3", p_info[playerid][pSlot3]);
			acc_int_strcat(query, sizeof(query), "pSlot4", p_info[playerid][pSlot4]);
			acc_int_strcat(query, sizeof(query), "pSlot5", p_info[playerid][pSlot5]);
			acc_int_strcat(query, sizeof(query), "pSlot6", p_info[playerid][pSlot6]);
			acc_int_strcat(query, sizeof(query), "pSlot7", p_info[playerid][pSlot7]);
			acc_int_strcat(query, sizeof(query), "pSlot8", p_info[playerid][pSlot8]);
			acc_int_strcat(query, sizeof(query), "pSlot9", p_info[playerid][pSlot9]);
			acc_int_strcat(query, sizeof(query), "pSlot10", p_info[playerid][pSlot10]);
			acc_int_strcat(query, sizeof(query), "pSlot11", p_info[playerid][pSlot11]);
			acc_int_strcat(query, sizeof(query), "pSlotammo1", p_info[playerid][pSlotammo1]);
			acc_int_strcat(query, sizeof(query), "pSlotammo2", p_info[playerid][pSlotammo2]);
			acc_int_strcat(query, sizeof(query), "pSlotammo3", p_info[playerid][pSlotammo3]);
			acc_int_strcat(query, sizeof(query), "pSlotammo4", p_info[playerid][pSlotammo4]);
			acc_int_strcat(query, sizeof(query), "pSlotammo5", p_info[playerid][pSlotammo5]);
			acc_int_strcat(query, sizeof(query), "pSlotammo6", p_info[playerid][pSlotammo6]);
			acc_int_strcat(query, sizeof(query), "pSlotammo7", p_info[playerid][pSlotammo7]);
			acc_int_strcat(query, sizeof(query), "pSlotammo8", p_info[playerid][pSlotammo8]);
			acc_int_strcat(query, sizeof(query), "pSlotammo9", p_info[playerid][pSlotammo9]);
			acc_int_strcat(query, sizeof(query), "pSlotammo10", p_info[playerid][pSlotammo10]);
			acc_int_strcat(query, sizeof(query), "pSlotammo11", p_info[playerid][pSlotammo11]);
			acc_int_strcat(query, sizeof(query), "pGunSkill1", p_info[playerid][pGunSkill][0]);
			acc_int_strcat(query, sizeof(query), "pGunSkill2", p_info[playerid][pGunSkill][1]);
			acc_int_strcat(query, sizeof(query), "pGunSkill3", p_info[playerid][pGunSkill][2]);
			acc_int_strcat(query, sizeof(query), "pGunSkill4", p_info[playerid][pGunSkill][3]);
			acc_int_strcat(query, sizeof(query), "pGunSkill5", p_info[playerid][pGunSkill][4]);
			acc_int_strcat(query, sizeof(query), "pGunSkill6", p_info[playerid][pGunSkill][5]);
			acc_int_strcat(query, sizeof(query), "ptaxiexp", p_info[playerid][ptaxiexp]);
			acc_int_strcat(query, sizeof(query), "ptaxilvl", p_info[playerid][ptaxilvl]);
			acc_int_strcat(query, sizeof(query), "pDLevel", p_info[playerid][pDLevel]);
			acc_int_strcat(query, sizeof(query), "pDExp", p_info[playerid][pDExp]);
			acc_int_strcat(query, sizeof(query), "pDMgruz", p_info[playerid][pDMgruz]);
			acc_int_strcat(query, sizeof(query), "pDgruz", p_info[playerid][pDgruz]);
			acc_int_strcat(query, sizeof(query), "pChar", p_info[playerid][pChar][0]);
			acc_int_strcat(query, sizeof(query), "pChar1", p_info[playerid][pChar][1]);
			acc_int_strcat(query, sizeof(query), "pChar2", p_info[playerid][pChar][2]);
			acc_int_strcat(query, sizeof(query), "pViborChar", p_info[playerid][pViborChar]);
			acc_float_strcat(query, sizeof(query), "pSHealth", p_info[playerid][pSHealth]);
			acc_float_strcat(query, sizeof(query), "pHealth", p_info[playerid][pHealth]);
			acc_int_strcat(query, sizeof(query), "pInt", p_info[playerid][pInt]);
			acc_int_strcat(query, sizeof(query), "pLocal", p_info[playerid][pLocal]);
			acc_int_strcat(query, sizeof(query), "pModel", p_info[playerid][pModel]);
			acc_int_strcat(query, sizeof(query), "pPnumber", p_info[playerid][pPnumber]);
			acc_int_strcat(query, sizeof(query), "pPayDay", p_info[playerid][pPayDay]);
			acc_int_strcat(query, sizeof(query), "pPayDayHad", p_info[playerid][pPayDayHad]);
			acc_int_strcat(query, sizeof(query), "pTut", p_info[playerid][pTut]);
			acc_int_strcat(query, sizeof(query), "pWarns", p_info[playerid][pWarns]);
			acc_int_strcat(query, sizeof(query), "punWarns", p_info[playerid][punWarns]);
			acc_int_strcat(query, sizeof(query), "punWarnstime", p_info[playerid][punWarnstime]);
			acc_int_strcat(query, sizeof(query), "pFuel", p_info[playerid][pFuel]);
			acc_int_strcat(query, sizeof(query), "pMarried", p_info[playerid][pMarried]);
			acc_str_strcat(query, sizeof(query), "pMarriedTo", p_info[playerid][pMarriedTo]);
			acc_int_strcat(query, sizeof(query), "pMushrooms", p_info[playerid][pMushrooms]);
			acc_float_strcat(query, sizeof(query), "pFishes", p_info[playerid][pFishes]);
			acc_int_strcat(query, sizeof(query), "pFishesPach",p_info[playerid][pFishesPach]);
			acc_int_strcat(query, sizeof(query), "pMuteTime", p_info[playerid][pMuteTime]);
			acc_int_strcat(query, sizeof(query), "pMobile", p_info[playerid][pMobile]);
			acc_int_strcat(query, sizeof(query), "pBank", p_info[playerid][pBank]);
			acc_int_strcat(query, sizeof(query), "pLocked", p_info[playerid][pLocked]);
			acc_int_strcat(query, sizeof(query), "pLockedban", p_info[playerid][pLockedban]);
			acc_int_strcat(query, sizeof(query), "pBanDay", p_info[playerid][pBanDay]);
			acc_int_strcat(query, sizeof(query), "pBanMounth", p_info[playerid][pBanMounth]);
			acc_int_strcat(query, sizeof(query), "pKrisha", p_info[playerid][pKrisha]);
			acc_int_strcat(query, sizeof(query), "pUseKrisha", p_info[playerid][pUseKrisha]);
			acc_int_strcat(query, sizeof(query), "pDolg", p_info[playerid][pDolg]);
			acc_int_strcat(query, sizeof(query), "pBoxSkill", p_info[playerid][pBoxSkill]);
			acc_int_strcat(query, sizeof(query), "pKongfuSkill", p_info[playerid][pKongfuSkill]);
			acc_int_strcat(query, sizeof(query), "pKickboxSkill", p_info[playerid][pKickboxSkill]);
			acc_str_strcat(query, sizeof(query), "pDostup", p_info[playerid][pDostup]);
			acc_int_strcat(query, sizeof(query), "pZakonp", p_info[playerid][pZakonp]);
			acc_int_strcat(query, sizeof(query), "pAddiction", p_info[playerid][pAddiction]);
			acc_int_strcat(query, sizeof(query), "pMats", p_info[playerid][pMats]);
			acc_int_strcat(query, sizeof(query), "pNarcoLomka", p_info[playerid][pNarcoLomka]);
			acc_int_strcat(query, sizeof(query), "pProcents", p_info[playerid][pProcents]);
            acc_int_strcat(query, sizeof(query), "pWheels", p_info[playerid][pWheels]);
            acc_int_strcat(query, sizeof(query), "pPaintJob", p_info[playerid][pPaintJob]);
			acc_int_strcat(query, sizeof(query), "pSpoiler", p_info[playerid][pSpoiler]);
			acc_int_strcat(query, sizeof(query), "pBumper1", p_info[playerid][pBumper1]);
			acc_int_strcat(query, sizeof(query), "pBumper2", p_info[playerid][pBumper2]);
			acc_int_strcat(query, sizeof(query), "pColor1", p_info[playerid][pColor][0]);
			acc_int_strcat(query, sizeof(query), "pColor2", p_info[playerid][pColor][1]);
			acc_int_strcat(query, sizeof(query), "pNitro", p_info[playerid][pNitro]);
			acc_int_strcat(query, sizeof(query), "pHydrawlic", p_info[playerid][pHydrawlic]);
			acc_int_strcat(query, sizeof(query), "pMestoJail", p_info[playerid][pMestoJail]);
			acc_int_strcat(query, sizeof(query), "pHousecash", p_info[playerid][pHousecash]);
			acc_int_strcat(query, sizeof(query), "pWantedLevel", p_info[playerid][pWantedLevel]);
			acc_int_strcat(query, sizeof(query), "pChas", p_info[playerid][pChas]);
			acc_int_strcat(query, sizeof(query), "pMin", p_info[playerid][pMin]);
			acc_int_strcat(query, sizeof(query), "pSkilla",p_info[playerid][pSkilla]);
			acc_int_strcat(query, sizeof(query), "pRecognition",p_info[playerid][pRecognition]);
			acc_int_strcat(query, sizeof(query), "pRobHouse",p_info[playerid][pRobHouse]);
			acc_str_strcat(query, sizeof(query), "pEmail", p_info[playerid][pEmail]);
			acc_float_strcat(query, sizeof(query), "pWarnes", p_info[playerid][pWarnes]);
			acc_int_strcat(query, sizeof(query), "pZavisemost", p_info[playerid][pZavisemost]);
			acc_int_strcat(query, sizeof(query), "pCigarettes",p_info[playerid][pCigarettes]);
			acc_int_strcat(query, sizeof(query), "pLighter",p_info[playerid][pLighter]);
   			acc_int_strcat(query, sizeof(query), "pKicka", p_info[playerid][pKicka]);
			acc_int_strcat(query, sizeof(query), "pMpa", p_info[playerid][pMpa]);
			acc_int_strcat(query, sizeof(query), "pWarna", p_info[playerid][pWarna]);
			acc_int_strcat(query, sizeof(query), "pBana", p_info[playerid][pBana]);
			acc_int_strcat(query, sizeof(query), "pSeans", p_info[playerid][pSeans]);
            acc_int_strcat(query, sizeof(query), "pCarSkill", p_info[playerid][pCarSkill]);
			acc_int_strcat(query, sizeof(query), "pZP",p_info[playerid][pZP]);
			acc_int_strcat(query, sizeof(query), "pFDays",p_info[playerid][pFDays]);
			acc_int_strcat(query, sizeof(query), "pFHour",p_info[playerid][pFHour]);
			acc_int_strcat(query, sizeof(query), "pFMinute",p_info[playerid][pFMinute]);
			acc_int_strcat(query, sizeof(query), "pKeys", p_info[playerid][pKeys]);
			acc_int_strcat(query, sizeof(query), "pGolos", p_info[playerid][pGolos]);
			acc_int_strcat(query, sizeof(query), "pMatsChas", p_info[playerid][pMatsChas]);
			acc_int_strcat(query, sizeof(query), "pHelpers", p_info[playerid][pHelpers]);
			acc_int_strcat(query, sizeof(query), "pKvartirakey", p_info[playerid][pKvartirakey]);
			acc_int_strcat(query, sizeof(query), "pVozdux", p_info[playerid][pVozdux]);
			acc_int_strcat(query, sizeof(query), "pVixlop", p_info[playerid][pVixlop]);
			acc_int_strcat(query, sizeof(query), "pGost", p_info[playerid][pGost]);
			acc_int_strcat(query, sizeof(query), "pMinexp", p_info[playerid][pMinexp]);
			new year, month, day;
			getdate(year, month, day);
			new strstre[50];
			new sendername[MAX_PLAYER_NAME];
			GetPlayerName(playerid,sendername,sizeof(sendername));
			format(strstre,sizeof(strstre), "%d/%d/%d",day,month,year);
			acc_str_strcat(query, sizeof(query), "pOnline", strstre);
			format(strstre,sizeof(strstre), "%d:%d",p_info[playerid][pChas],p_info[playerid][pMin]);
			acc_str_strcat(query, sizeof(query), "pOnlineLid", strstre);
			strdel(query, strlen(query)-1, strlen(query));
			format(string,sizeof(string)," WHERE `Name` = '%s'",sendername);
			strcat(query, string);
			mysql_function_query(mMysql,query,false,"","");
			if(strlen(query) >= 4500) printf("Âíèìàíèå! Àêêàóíò %s íå ñìîã ñîõðàíèòñÿ!",sendername);
		}
	}
	return true;
}

Вот еще serverlog

PHP:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7, (C)2005-2015 SA-MP Team

[19:55:52] 
[19:55:52] Server Plugins
[19:55:52] --------------
[19:55:52]  Loading plugin: streamer.so
[19:55:52] 

*** Streamer Plugin v2.7.4 by Incognito loaded ***

[19:55:52]   Loaded.
[19:55:52]  Loading plugin: sscanf.so
[19:55:52] 

[19:55:52]  ===============================

[19:55:52]       sscanf plugin loaded.     

[19:55:52]          Version:  2.8.1        

[19:55:52]    (c) 2012 Alex "Y_Less" Cole  

[19:55:52]  ===============================

[19:55:52]   Loaded.
[19:55:52]  Loading plugin: mysql_static.so
[19:55:52]  >> plugin.mysql: R39-2 successfully loaded.
[19:55:52]   Loaded.
[19:55:52]  Loading plugin: jit.so
[19:55:52]   JIT must be loaded before 'streamer.so'
[19:55:52]   Failed.
[19:55:52]  Loading plugin: fixes2.so
[19:55:52] 

[19:55:52]  ===============================

[19:55:52]        fixes plugin loaded.     

[19:55:52]    (c) 2012 Alex "Y_Less" Cole

[19:55:52]  ===============================

[19:55:52]   Loaded.
[19:55:52]  Loading plugin: dc_cmd.so
[19:55:52]   Daniel's CMD plugin v2.6
[19:55:52]     (c) 2012-2014 Daniel_Cortez
[19:55:52] 	www.*********.ru
[19:55:52]   Loaded.
[19:55:52]  Loading plugin: CVector.so
[19:55:52] -------------------------------------------------------
[19:55:52] -													 -
[19:55:52] -		Vectoral Pawn v1.0 Loaded					 -
[19:55:52] -				by Skyline.							 -
[19:55:52] -													 -
[19:55:52] -------------------------------------------------------
[19:55:52]   Loaded.
[19:55:52]  Loading plugin: crashdetect.so
[19:55:52]   AMX errors won't be tracked because 'streamer.so' has been loaded before CrashDetect.
[19:55:52]   CrashDetect v4.12 is OK.
[19:55:52]   Loaded.
[19:55:52]  Loaded 7 plugins.

[19:55:52] 
[19:55:52] Filterscripts
[19:55:52] ---------------
[19:55:52]   Loading filterscript 'base.amx'...
[19:55:52]   Unable to load filterscript 'base.amx'.
[19:55:52]   Loading filterscript 'gl_actions.amx'...
[19:55:52]   Unable to load filterscript 'gl_actions.amx'.
[19:55:52]   Loading filterscript 'gl_property.amx'...
[19:55:52]   Unable to load filterscript 'gl_property.amx'.
[19:55:52]   Loading filterscript 'gl_realtime.amx'...
[19:55:52]   Unable to load filterscript 'gl_realtime.amx'.
[19:55:52]   Loaded 0 filterscripts.

[19:55:52]  
[19:55:52]  
[19:55:52]  
[19:55:52]  ======================================= 
[19:55:52]  |                                     | 
[19:55:52]  |        YSI version 1.06.0002        | 
[19:55:52]  |        By Alex "Y_Less" Cole        | 
[19:55:52]  |                                     | 
[19:55:52]  ======================================= 
[19:55:52]  
[19:55:52] fixes.plugin: Could not find function AFKCheck.
[19:55:52] fixes.plugin: Could not find function Fly.
[19:55:52] fixes.plugin: Could not find function ACCheck.
[19:55:52] DC_CMD -> RegisterAlt: Couldn't find function cmd_live
[19:55:52] DC_CMD -> RegisterAlt: Couldn't find function cmd_conveyingarms
[19:55:52] Подключение к базе данных активно
[19:55:52] Number of vehicle models: 67
[19:55:52]  
[19:55:52]  ========================================== 
[19:55:52]  |                                        | 
[19:55:52]  |  A new version (v3.09.0684) of YSI is  | 
[19:55:52]  |            available from:             | 
[19:55:52]  |                                        | 
[19:55:52]  |     www.y-less.com/YSI/YSI_1.0.zip     | 
[19:55:52]  |                                        | 
[19:55:52]  | Changelog:                             | 
[19:55:52]  |                                        | 
[19:55:52]  |   3.00.0000:                           | 
[19:55:52]  |                                        | 
[19:55:52]  |   YSI 3.0 released!  Now includes the  | 
[19:55:52]  | "y_text" library for better messages,  | 
[19:55:52]  | and a reworked "y_classes" library.    | 
[19:55:52]  | Largely documented here                | 
[19:55:52]  | "http://forum.wiki.pawno-info.ru/showthread.php | 
[19:55:52]  | ?t=321092".                            | 
[19:55:52]  |                                        | 
[19:55:52]  |   3.01.0002:                           | 
[19:55:52]  |                                        | 
[19:55:52]  |   Small fixes to "y_text" and          | 
[19:55:52]  | "y_classes".                           | 
[19:55:52]  |                                        | 
[19:55:52]  |   3.09.0684:                           | 
[19:55:52]  |                                        | 
[19:55:52]  |   Reverted to old download location.   | 
[19:55:52]  | Improved (and fixed) version checks;   | 
[19:55:52]  | added y_bitmap, y_areas, y_races,      | 
[19:55:52]  | y_zonenames, better documentation;     | 
[19:55:52]  | MANY other bug fixes - see the github  | 
[19:55:52]  | repository for more details:           | 
[19:55:52]  |                                        | 
[19:55:52]  ========================================== 
[19:55:52]  
[19:56:12] [ Загрузка мода ... ] Материалы гос фракций/банд были успешно загружены!
[19:56:22] [ Загрузка мода ... ] Банки мафий были успешно загружены!
[19:56:22] [ Загрузка мода ... ] Банки гос фракций/банд были успешно загружены!
[19:58:34] [connection] 95.56.212.254:13153 requests connection cookie.
[19:58:35] Incoming connection: 95.56.212.254:13153 id: 0
[19:58:36] [join] Nick_Name has joined the server (0:95.56.212.254)
[19:59:15] 111, Nick_Name, 0
[19:59:47] 221, Nick_Name, 0
[19:59:53] 113, Nick_Name, 0
[19:59:56] 223, Nick_Name, 0
[20:00:16] 118, Nick_Name, 0
[20:00:18] 28, Nick_Name, 0
[20:00:29] 222, Nick_Name, 0
[20:00:38] 184, Nick_Name, 0
[20:01:25] 826, Nick_Name, 1
[20:02:03] [part] Nick_Name has left the server (0:1)

Mysqllog(Просили в прошлой теме)

PHP:

[19:58:55] [WARNING] CMySQLResult::GetRowDataByName - field not found ("lastIP")

Мод RLS Резновски, хотел взять под основу. Вот этот мод если не ленитесь качать http://pawno-info.ru/showthread.php?t=255353
Подскажите как исправить, буду очень рад.

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

Статистика аккаунта обнуляется

Duka

Ученик