Проблема с Базой Данных

July 30, 2017

Помогите исправить данную ошибку, если надо что-то еще пишите кину!

[07:25:33] [ERROR] cache_get_row_int - invalid datatype
[07:25:33] [ERROR] cache_get_row_int - invalid datatype
[07:25:33] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'online' in 'field list'
[07:25:33] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'online' in 'field list'
[07:31:24] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'online' in 'field list'
[07:31:24] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'online' in 'field list'
[07:31:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) 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 'WHERE `name` = 'Jaliba_Baron'' at line 1

July 30, 2017

Эту строку:

f(string, "%s `fwarn` = '%d', ",               string, PI[playerid][pfWarn]);

Замените на эту:

f(string, "%s `fwarn` = '%d' ",               string, PI[playerid][pfWarn]);

July 30, 2017

Здравствуйте. Данная проблема возникла вследствие неверного mySQL запроса. А точнее, не найдена колонка "online" в аккаунте игрока.

Если не знаете, в каком запросе ошибка, то:

Вставьте этот код в public OnQueryError (если такой есть):

printf("[DEBUG]: error: %d, errorname: %s, callback: %s, querystr: %s, connection id: %d", errorid, error, callback, query, connectionHandle);

Если паблика OnQueryError нет, то вставьте:

public OnQueryError(errorid, error[], callback[], query[], connectionHandle)
{
    printf("[DEBUG]: error: %d, errorname: %s, callback: %s, querystr: %s, connection id: %d", errorid, error, callback, query, connectionHandle);
    return true;
}

И скиньте логи сервера (файл server_log.txt) после очередного появления ошибки.

Edited July 30, 2017 by stibs

July 30, 2017

@stibs я каким та оброзам смог упривать ошибку 1054, а ошибка под номером 1064 осталось, и не нашол "public OnQueryError" и "OnQueryError"

Помоги что нужно?

July 30, 2017

@Daniil Roslyakov просто киньте данный код в любое место мода, главное не в сток и не в паблик:

public OnQueryError(errorid, error[], callback[], query[], connectionHandle)
{
    printf("[DEBUG]: error: %d, errorname: %s, callback: %s, querystr: %s, connection id: %d", errorid, error, callback, query, connectionHandle);
    return true;
}

Потом скомплируйте мод, вызовите эту ошибку и выложите логи (server_log.txt).

July 30, 2017

@stibs вот

Server_log


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

SA-MP Dedicated Server
----------------------
v0.3e, (C)2005-2012 SA-MP Team

[15:05:39] filterscripts = ""  (string)
[15:05:39] 
[15:05:39] Server Plugins
[15:05:39] --------------
[15:05:39]  Loading plugin: crashdetect.so
[15:05:39]   CrashDetect v4.15.1 is OK.
[15:05:39]   Loaded.
[15:05:39]  Loading plugin: streamer.so
[15:05:39] 

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

[15:05:39]   Loaded.
[15:05:39]  Loading plugin: sscanf.so
[15:05:39] 

[15:05:39]  ===============================

[15:05:39]       sscanf plugin loaded.     

[15:05:39]          Version:  2.8.1        

[15:05:39]    (c) 2012 Alex "Y_Less" Cole  

[15:05:39]  ===============================

[15:05:39]   Loaded.
[15:05:39]  Loading plugin: mysql_static.so
[15:05:39]  >> plugin.mysql: R39-5 successfully loaded.
[15:05:39]   Loaded.
[15:05:39]  Loading plugin: CRP.so
[15:05:39] 

[15:05:39] ______________________________________

[15:05:39]  Convert Rus To Pwn v0.1.1 loaded
[15:05:39] ______________________________________

[15:05:39]  By: Fro (c) Copyright <TBG> 2009-2011
[15:05:39] ______________________________________

[15:05:39]   Loaded.
[15:05:39]  Loading plugin: regex.so
[15:05:39] 


[15:05:39] ______________________________________


[15:05:39]  Regular Expression Plugin v0.2.1 loaded
[15:05:39] ______________________________________


[15:05:39]  By: Fro (c) Copyright <TBG> 2009-2011
[15:05:39] ______________________________________


[15:05:39]   Loaded.
[15:05:39]  Loading plugin: dc_cmd.so
[15:05:39]   Daniel's CMD plugin v2.8
[15:05:39]     (c) 2014 Daniel_Cortez
[15:05:39] 	www.pro-pawn.ru
[15:05:39]   Loaded.
[15:05:39]  Loaded 7 plugins.

[15:05:39] 
[15:05:39] Ban list
[15:05:39] --------
[15:05:39]  Loaded: samp.ban
[15:05:39] 
[15:05:39] 
[15:05:39] Filterscripts
[15:05:39] ---------------
[15:05:39]   Loaded 0 filterscripts.

[15:05:39] Incoming connection: 185.17.135.222:2077
[15:05:39]  
[15:05:39]  
[15:05:39]  
[15:05:39]  ======================================= 
[15:05:39]  |                                     | 
[15:05:39]  |        YSI version 3.09.0684        | 
[15:05:39]  |        By Alex "Y_Less" Cole        | 
[15:05:39]  |                                     | 
[15:05:39]  ======================================= 
[15:05:39]  
[15:05:39] [MySQL]: Подключение к базе данных прошло успешно
[15:05:39] Number of vehicle models: 10
[15:05:39] [Загружено орг/раб. автомобилей]: <135>. Потрачено: <3 ms>.
[15:05:39] [Загружено рангов для фракций]: <12>. Потрачено: <0 ms>.
[15:05:39] [Загружено бизнесов]: <0>. Потрачено: <0 ms>.
[15:05:39] [Загружено домов]: <0>. Потрачено: <0 ms>.
[15:05:39] [Загружены склады мафий]: Потрачено: <0 ms>.
[15:05:39] [Загружены склады ОПГ]: Потрачено: <0 ms>.
[15:05:39] [Загружено банкоматов]: <0>. Потрачено: <0 ms>.
[15:05:39] [Загружено остальное]: Потрачено: <0 ms>.
[15:05:39] [Загружено радаров]: <0>. Потрачено: <0 ms>.
[15:05:39] [System Hotels]: 50 hotels successfully loaded
[15:05:39] Incoming connection: 89.145.154.128:54387
[15:05:40] [join] Jaliba_Baron has joined the server (1:89.145.154.128)
[15:05:51] [join] Luka_Popov has joined the server (0:185.17.135.222)
[15:21:07] [chat] [Luka_Popov]: если что админку даш ок?
[15:33:13] [part] Luka_Popov has left the server (0:1)
[15:33:13] [DEBUG]: error: 1064, errorname: 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 'WHERE `name` = 'Luka_Popov'' at line 1, callback: , querystr: UPDATE `accounts` SET `name` = 'Luka_Popov',  `ip` = '185.17.135.222',  `admin` = '0',  `securitycode` = '0',  `level` = '1',  `cash` = '500',  `bank` = '0',  `exp` = '0',  `leader` = '0',  `templeader` = '0',  `member` = '0',  `rank` = '0',  `warn` = '0',  `sex` = '1',  `age` = '23',  `model` = '289',  `memberskin` = '0',  `lic` = '0, 0, 0, 0',  `mute` = '0',  `pick` = '0',  `checktime` = '256',  `news` = '0',  `phonenumber` = '0',  `jail` = '0',  `jailtime` = '0',  `wanted` = '0',  `wantedtime` = '0',  `wantedwho` = 'None',  `wantedreason` = 'None',  `heal` = '100.000000',  `drugs` = '0',  `patron` = '0',  `gunamount` = '0',  `crimes` = '0',  `job` = '0',  `married` = '0',  `whomarried` = 'None',  `paycheck` = '0',  `charity` = '0',  `vip` = '0',  `viptime` = '0',  `time` = '0',  `fstyle` = '0',  `credits` = '0',  `totalcredits` = '0',  `skin1` = '0',  `skin2` = '0',  `skin3` = 'Luka_Popov',  `spawnchange` = '0',  `sdpistol` = '0',  `deserteagle` = '0',  `shotgun` = '0',  `mp5` = '0',  `ak47` = '0',  `m4` = '0',  `pistol` = '0',  `microuzi` = '0',  `hunger` = '94',  `healths` = '100.000000',  `sportexp` = '0',  `zakon` = '0',  `city` = '0',  `repcar` = '0, 0',  `bed` = '0',  `watch` = '0',  `ciggare` = '0',  `sprunk` = '0',  `mask` = '0',  `phonebalance` = '100',  `truckskill` = '0',  `veh_number` = 'Транзит/Транзит',  `cModel` = '0/0',  `cClass` = '1/1',  `cFuel` = '0/0',  `cMilleage` = '0.000000/0.000000',  `cColor1` = '0/0',  `cColor2` = '0/0',  `cLock` = '0/0',  `cCost` = '0/0',  `cVehcom` = '0,0,0,0,0,0,0,0,0,0,0,0,0,0/0,0,0,0,0,0,0,0,0,0,0,0,0,0',  `cPaintjob` = '3/3',  `cVirtual` = '0/0',  `cX` = '0.000000/0.000000',  `cY` = '0.000000/0.000000',  `cZ` = '0.000000/0.000000',  `cA` = '0.000000/0.000000',  `vehiclekey` = '0',  `vehiclekey1` = '0',  `aptechka` = '0',  `Voennik` = '0',  `music` = '0',  `improves` = '0, 0, 0, 0',  `settings` = '1, 1, 1, 1, 1, 1, 1',  `phnumber1` = '0',  `phnumber2` = '0',  `phnumber3` = '0',  `phnumber4` = '0',  `phnumber5` = '0',  `phnumber6` = '0',  `phnumber7` = '0',  `fishki` = '0',  `thour` = '256',  `tday` = '256',  `tlastday` = '0',  `balon1` = '0',  `balon2` = '0',  `balon3` = '0',  `balon4` = '0',  `balon5` = '0',  `balon6` = '0',  `balon7` = '0',  `remont` = '0',  `sleep` = '94',  `fwarn` = '0',  WHERE `name` = 'Luka_Popov', connection id: 1
[15:33:13] [debug] Server crashed while executing stel.amx
[15:33:13] [debug] AMX backtrace:
[15:33:13] [debug] #0 native printf () from samp03svr-cr
[15:33:13] [debug] #1 005a8870 in public OnQueryError (errorid=1064, error[]=@00286be0 "You have an error in your SQL syntax; check the manual that corresponds to your ...", callback[]=@00286bdc "", query[]=@002847c0 "UPDATE `accounts` SET `name` = 'Luka_Popov',  `ip` = '185.17.135.222',  `admin` ...", connectionHandle=1) at C:\Users\Даниил\Desktop\STEL NEW\gamemodes\stel.pwn:2939

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

SA-MP Dedicated Server
----------------------
v0.3e, (C)2005-2012 SA-MP Team

[15:35:57] filterscripts = ""  (string)
[15:35:57] 
[15:35:57] Server Plugins
[15:35:57] --------------
[15:35:57]  Loading plugin: crashdetect.so
[15:35:57]   CrashDetect v4.15.1 is OK.
[15:35:57]   Loaded.
[15:35:57]  Loading plugin: streamer.so
[15:35:57] 

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

[15:35:57]   Loaded.
[15:35:57]  Loading plugin: sscanf.so
[15:35:57] 

[15:35:57]  ===============================

[15:35:57]       sscanf plugin loaded.     

[15:35:57]          Version:  2.8.1        

[15:35:57]    (c) 2012 Alex "Y_Less" Cole  

[15:35:57]  ===============================

[15:35:57]   Loaded.
[15:35:57]  Loading plugin: mysql_static.so
[15:35:57]  >> plugin.mysql: R39-5 successfully loaded.
[15:35:57]   Loaded.
[15:35:57]  Loading plugin: CRP.so
[15:35:57] 

[15:35:57] ______________________________________

[15:35:57]  Convert Rus To Pwn v0.1.1 loaded
[15:35:57] ______________________________________

[15:35:57]  By: Fro (c) Copyright <TBG> 2009-2011
[15:35:57] ______________________________________

[15:35:57]   Loaded.
[15:35:57]  Loading plugin: regex.so
[15:35:57] 


[15:35:57] ______________________________________


[15:35:57]  Regular Expression Plugin v0.2.1 loaded
[15:35:57] ______________________________________


[15:35:57]  By: Fro (c) Copyright <TBG> 2009-2011
[15:35:57] ______________________________________


[15:35:57]   Loaded.
[15:35:57]  Loading plugin: dc_cmd.so
[15:35:57]   Daniel's CMD plugin v2.8
[15:35:57]     (c) 2014 Daniel_Cortez
[15:35:57] 	www.pro-pawn.ru
[15:35:57]   Loaded.
[15:35:57]  Loaded 7 plugins.

[15:35:57] 
[15:35:57] Ban list
[15:35:57] --------
[15:35:57]  Loaded: samp.ban
[15:35:57] 
[15:35:57] 
[15:35:57] Filterscripts
[15:35:57] ---------------
[15:35:57]   Loaded 0 filterscripts.

[15:35:58]  
[15:35:58]  
[15:35:58]  
[15:35:58]  ======================================= 
[15:35:58]  |                                     | 
[15:35:58]  |        YSI version 3.09.0684        | 
[15:35:58]  |        By Alex "Y_Less" Cole        | 
[15:35:58]  |                                     | 
[15:35:58]  ======================================= 
[15:35:58]  
[15:35:58] [MySQL]: Подключение к базе данных прошло успешно
[15:35:58] Number of vehicle models: 10
[15:35:58] [Загружено орг/раб. автомобилей]: <135>. Потрачено: <2 ms>.
[15:35:58] [Загружено рангов для фракций]: <12>. Потрачено: <0 ms>.
[15:35:58] [Загружено бизнесов]: <0>. Потрачено: <0 ms>.
[15:35:58] [Загружено домов]: <0>. Потрачено: <0 ms>.
[15:35:58] [Загружены склады мафий]: Потрачено: <0 ms>.
[15:35:58] [Загружены склады ОПГ]: Потрачено: <0 ms>.
[15:35:58] [Загружено банкоматов]: <0>. Потрачено: <0 ms>.
[15:35:58] [Загружено остальное]: Потрачено: <0 ms>.
[15:35:58] [Загружено радаров]: <0>. Потрачено: <0 ms>.
[15:35:58] [System Hotels]: 50 hotels successfully loaded
[15:38:33] Incoming connection: 89.145.154.128:52794
[15:38:33] [join] Jaliba_Baron has joined the server (0:89.145.154.128)
[15:42:40] [part] Jaliba_Baron has left the server (0:1)
[15:42:40] [DEBUG]: error: 1064, errorname: 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 'WHERE `name` = 'Jaliba_Baron'' at line 1, callback: , querystr: UPDATE `accounts` SET `name` = 'Jaliba_Baron',  `ip` = '89.145.154.128',  `admin` = '0',  `securitycode` = '0',  `level` = '1',  `cash` = '780',  `bank` = '0',  `exp` = '0',  `leader` = '0',  `templeader` = '0',  `member` = '0',  `rank` = '0',  `warn` = '0',  `sex` = '1',  `age` = '18',  `model` = '161',  `memberskin` = '0',  `lic` = '0, 0, 0, 0',  `mute` = '0',  `pick` = '0',  `checktime` = '187',  `news` = '0',  `phonenumber` = '0',  `jail` = '0',  `jailtime` = '0',  `wanted` = '0',  `wantedtime` = '0',  `wantedwho` = 'None',  `wantedreason` = 'None',  `heal` = '95.000000',  `drugs` = '0',  `patron` = '0',  `gunamount` = '0',  `crimes` = '0',  `job` = '0',  `married` = '0',  `whomarried` = 'None',  `paycheck` = '0',  `charity` = '0',  `vip` = '0',  `viptime` = '0',  `time` = '0',  `fstyle` = '0',  `credits` = '0',  `totalcredits` = '0',  `skin1` = '0',  `skin2` = '0',  `skin3` = 'Jaliba_Baron',  `spawnchange` = '0',  `sdpistol` = '0',  `deserteagle` = '0',  `shotgun` = '0',  `mp5` = '0',  `ak47` = '0',  `m4` = '0',  `pistol` = '0',  `microuzi` = '0',  `hunger` = '99',  `healths` = '100.000000',  `sportexp` = '0',  `zakon` = '0',  `city` = '0',  `repcar` = '0, 0',  `bed` = '0',  `watch` = '0',  `ciggare` = '0',  `sprunk` = '0',  `mask` = '0',  `phonebalance` = '100',  `truckskill` = '0',  `veh_number` = 'Транзит/Транзит',  `cModel` = '0/0',  `cClass` = '1/1',  `cFuel` = '0/0',  `cMilleage` = '0.000000/0.000000',  `cColor1` = '0/0',  `cColor2` = '0/0',  `cLock` = '0/0',  `cCost` = '0/0',  `cVehcom` = '0,0,0,0,0,0,0,0,0,0,0,0,0,0/0,0,0,0,0,0,0,0,0,0,0,0,0,0',  `cPaintjob` = '3/3',  `cVirtual` = '0/0',  `cX` = '0.000000/0.000000',  `cY` = '0.000000/0.000000',  `cZ` = '0.000000/0.000000',  `cA` = '0.000000/0.000000',  `vehiclekey` = '0',  `vehiclekey1` = '0',  `aptechka` = '0',  `Voennik` = '0',  `music` = '0',  `improves` = '0, 0, 0, 0',  `settings` = '1, 1, 1, 1, 1, 1, 1',  `phnumber1` = '0',  `phnumber2` = '0',  `phnumber3` = '0',  `phnumber4` = '0',  `phnumber5` = '0',  `phnumber6` = '0',  `phnumber7` = '0',  `fishki` = '0',  `thour` = '187',  `tday` = '187',  `tlastday` = '0',  `balon1` = '0',  `balon2` = '0',  `balon3` = '0',  `balon4` = '0',  `balon5` = '0',  `balon6` = '0',  `balon7` = '0',  `remont` = '0',  `sleep` = '99',  `fwarn` = '0',  WHERE `name` = 'Jaliba_Baron', connection id: 1
[15:42:40] [debug] Server crashed while executing stel.amx
[15:42:40] [debug] AMX backtrace:
[15:42:40] [debug] #0 native printf () from samp03svr-cr
[15:42:40] [debug] #1 005a8870 in public OnQueryError (errorid=1064, error[]=@00286bf4 "You have an error in your SQL syntax; check the manual that corresponds to your ...", callback[]=@00286bf0 "", query[]=@002847c0 "UPDATE `accounts` SET `name` = 'Jaliba_Baron',  `ip` = '89.145.154.128',  `admin...", connectionHandle=1) at C:\Users\Даниил\Desktop\STEL NEW\gamemodes\stel.pwn:2939

[15:33:13] [ERROR] CMySQLQuery::Execute[] - (error #1064) 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 'WHERE `name` = 'Luka_Popov'' at line 1
[15:42:40] [ERROR] CMySQLQuery::Execute[] - (error #1064) 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 'WHERE `name` = 'Jaliba_Baron'' at line 1

mySQL_log

Edited July 30, 2017 by vlad
Причина: Взял логи под спойлер

July 30, 2017

@Daniil Roslyakov Удалите этот паблик, который я вам скинул, и сделайте вот что.

Найдите строку в моде такого рода, скорее всего она находится в сохранении игрока:

`remont` = '%d',  `sleep` = '%d',  `fwarn` = '%d',  WHERE `name` = '%s'

И в ней уберите запятую перед WHERE `name`

и получится вот так:

`remont` = '%d',  `sleep` = '%d',  `fwarn` = '%d'  WHERE `name` = '%s'

July 30, 2017

@stibs нету такого, что делать?

July 30, 2017

@Daniil Roslyakov Скиньте паблик / сток сохранения. Он должен называться по типу SaveAccount SavePlayer или что-то в этом роде.

July 30, 2017

@stibs

stock SaveAccount(playerid)
{
	if(PlayerLogged[playerid] == false || IsPlayerConnected(playerid) == 0) return 1;
	new zapros[128];
	
	format(PI[playerid][pSettings],64,"%i, %i, %i, %i, %i, %i, %i",PI[playerid][pSetting][0],PI[playerid][pSetting][1],PI[playerid][pSetting][2],PI[playerid][pSetting][3],PI[playerid][pSetting][4],PI[playerid][pSetting][5],PI[playerid][pSetting][6]);
	format(PI[playerid][pImproves],64,"%i, %i, %i, %i",PI[playerid][pImprove][0],PI[playerid][pImprove][1],PI[playerid][pImprove][2],PI[playerid][pImprove][3]);
	format(PI[playerid][pLics],64,"%i, %i, %i, %i",PI[playerid][pLic][0],PI[playerid][pLic][1],PI[playerid][pLic][2],PI[playerid][pLic][3]);
	format(PI[playerid][pRepcars],64,"%i, %i",PI[playerid][pRepcar][0],PI[playerid][pRepcar][1]);
	
	new string[3128] = "UPDATE "T_ACCOUNTS" SET";
	
	f(string, "%s `name` = '%s', ",                string, PI[playerid][pName]);
	f(string, "%s `ip` = '%s', ",                  string, PI[playerid][pIP]);
	f(string, "%s `admin` = '%d', ",               string, PI[playerid][pAdmin]);
	f(string, "%s `securitycode` = '%i', ",        string, PI[playerid][pSecurityCode]);
	f(string, "%s `level` = '%d', ",               string, PI[playerid][pLevel]);
	f(string, "%s `cash` = '%d', ",                string, PI[playerid][pCash]);
	f(string, "%s `bank` = '%d', ",                string, PI[playerid][pBank]);
	f(string, "%s `exp` = '%d', ",                 string, PI[playerid][pExp]);
	f(string, "%s `leader` = '%d', ",              string, PI[playerid][pLeader]);
	f(string, "%s `templeader` = '%d', ",          string, PI[playerid][pTempLeader]);
	f(string, "%s `member` = '%d', ",              string, PI[playerid][pMember]);
	f(string, "%s `rank` = '%d', ",                string, PI[playerid][pRank]);
	f(string, "%s `warn` = '%d', ",                string, PI[playerid][pWarn]);
	f(string, "%s `sex` = '%d', ",                 string, PI[playerid][pSex]);
	f(string, "%s `age` = '%d', ",                 string, PI[playerid][pAge]);
	f(string, "%s `model` = '%d', ",               string, PI[playerid][pModel]);
	f(string, "%s `memberskin` = '%d', ",          string, PI[playerid][pMemberSkin]);
    f(string, "%s `lic` = '%s', ",                 string, PI[playerid][pLics]);
	f(string, "%s `mute` = '%d', ",                string, PI[playerid][pMuted]);
	f(string, "%s `pick` = '%d', ",                string, PI[playerid][pPick]);
	f(string, "%s `checktime` = '%d', ",           string, PI[playerid][pCheckTime]);
	f(string, "%s `news` = '%d', ",                string, PI[playerid][pNews]);
	f(string, "%s `phonenumber` = '%d', ",         string, PI[playerid][pPhoneNumber]);
	f(string, "%s `jail` = '%d', ",                string, PI[playerid][pJail]);
	f(string, "%s `jailtime` = '%d', ",            string, PI[playerid][pJailTime]);
	f(string, "%s `wanted` = '%d', ",              string, PI[playerid][pWanted]);
	f(string, "%s `wantedtime` = '%d', ",          string, PI[playerid][pWantedTime]);
	f(string, "%s `wantedwho` = '%s', ",           string, PI[playerid][pWantedWho]);
	f(string, "%s `wantedreason` = '%s', ",        string, PI[playerid][pWantedReason]);
	f(string, "%s `heal` = '%f', ",                string, PI[playerid][pHeal]);
	f(string, "%s `drugs` = '%d', ",               string, PI[playerid][pDrugs]);
	f(string, "%s `patron` = '%d', ",              string, PI[playerid][pPatron]);
	f(string, "%s `gunamount` = '%d', ",           string, PI[playerid][pGunAmount]);
	f(string, "%s `crimes` = '%d', ",              string, PI[playerid][pCrimes]);
	f(string, "%s `job` = '%d', ",                 string, PI[playerid][pJob]);
	f(string, "%s `married` = '%d', ",             string, PI[playerid][pMarried]);
	f(string, "%s `whomarried` = '%s', ",          string, PI[playerid][pWhoMarried]);
	f(string, "%s `paycheck` = '%d', ",            string, PI[playerid][pPayCheck]);
	f(string, "%s `charity` = '%d', ",             string, PI[playerid][pCharity]);
	f(string, "%s `vip` = '%d', ",                 string, PI[playerid][pVip]);
	f(string, "%s `viptime` = '%d', ",             string, PI[playerid][pVipTime]);
	f(string, "%s `time` = '%d', ",                string, PI[playerid][pTime]);
	f(string, "%s `fstyle` = '%d', ",              string, PI[playerid][pFightStyle]);
	f(string, "%s `credits` = '%d', ",             string, PI[playerid][pCredits]);
	f(string, "%s `totalcredits` = '%d', ",        string, PI[playerid][pTotalCredits]);
	f(string, "%s `skin1` = '%d', ",               string, PI[playerid][pSkin][0]);
	f(string, "%s `skin2` = '%d', ",               string, PI[playerid][pSkin][1]);
	f(string, "%s `skin3` = '%s', ",               string, PI[playerid][pName]);
	f(string, "%s `spawnchange` = '%d', ",         string, PI[playerid][pSpawnChange]);
	f(string, "%s `sdpistol` = '%d', ",            string, PI[playerid][pGunSkill][0]);
	f(string, "%s `deserteagle` = '%d', ",         string, PI[playerid][pGunSkill][1]);
	f(string, "%s `shotgun` = '%d', ",             string, PI[playerid][pGunSkill][2]);
	f(string, "%s `mp5` = '%d', ",                 string, PI[playerid][pGunSkill][3]);
	f(string, "%s `ak47` = '%d', ",                string, PI[playerid][pGunSkill][4]);
	f(string, "%s `m4` = '%d', ",                  string, PI[playerid][pGunSkill][5]);
	f(string, "%s `pistol` = '%d', ",              string, PI[playerid][pGunSkill][6]);
	f(string, "%s `microuzi` = '%d', ",            string, PI[playerid][pGunSkill][7]);
	f(string, "%s `hunger` = '%d', ",              string, PI[playerid][pHunger]);
	f(string, "%s `healths` = '%f', ",             string, PI[playerid][pHealthS]);
	f(string, "%s `sportexp` = '%d', ",            string, PI[playerid][pSportExp]);
	f(string, "%s `zakon` = '%d', ",               string, PI[playerid][pZakon]);
	f(string, "%s `city` = '%d', ",                string, PI[playerid][pCity]);
	f(string, "%s `repcar` = '%s', ",              string, PI[playerid][pRepcars]);
	f(string, "%s `bed` = '%d', ",                 string, PI[playerid][pBed]);
	f(string, "%s `watch` = '%d', ",               string, PI[playerid][pWatch]);
	f(string, "%s `ciggare` = '%d', ",             string, PI[playerid][pCiggare]);
	f(string, "%s `sprunk` = '%d', ",              string, PI[playerid][pSprunk]);
	f(string, "%s `mask` = '%d', ",                string, PI[playerid][pMask]);
	f(string, "%s `phonebalance` = '%d', ",        string, PI[playerid][pPhoneBalance]);
	f(string, "%s `truckskill` = '%d', ",          string, PI[playerid][pTruckSkill]);
	//---Àâòîìîáèëè-------------------------------------------------------------
	format(zapros,sizeof(zapros),"%s/%s",cNumberVehicle[playerid][0],cNumberVehicle[playerid][1]);
	f(string, "%s `veh_number` = '%s', ",          string, zapros);
	
	format(zapros,sizeof(zapros),"%i/%i",cModel[playerid][0],cModel[playerid][1]);
	f(string, "%s `cModel` = '%s', ",              string, zapros);
	
	format(zapros,sizeof(zapros),"%i/%i",cClass[playerid][0],cClass[playerid][1]);
	f(string, "%s `cClass` = '%s', ",              string, zapros);
	
	format(zapros,sizeof(zapros),"%i/%i",cFuel[playerid][0],cFuel[playerid][1]);
	f(string, "%s `cFuel` = '%s', ",               string, zapros);
	
	format(zapros,sizeof(zapros),"%f/%f",cMilleage[playerid][0],cMilleage[playerid][1]);
	f(string, "%s `cMilleage` = '%s', ",           string, zapros);
	
	format(zapros,sizeof(zapros),"%i/%i",cColor0[playerid][0], cColor0[playerid][1]);
	f(string, "%s `cColor1` = '%s', ",             string, zapros);
	
	format(zapros,sizeof(zapros),"%i/%i",cColor1[playerid][0], cColor1[playerid][1]);
	f(string, "%s `cColor2` = '%s', ",             string, zapros);
	
	format(zapros,sizeof(zapros),"%i/%i",cLock[playerid][0],cLock[playerid][1]);
	f(string, "%s `cLock` = '%s', ",               string, zapros);
	
	format(zapros,sizeof(zapros),"%i/%i",cCost[playerid][0],cCost[playerid][1]);
	f(string, "%s `cCost` = '%s', ",               string, zapros);
	
	format(cVehcom3[playerid],128,"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d/%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
	cVehcoms1[playerid][0], cVehcoms1[playerid][1], cVehcoms1[playerid][2],
	cVehcoms1[playerid][3], cVehcoms1[playerid][4], cVehcoms1[playerid][5],
	cVehcoms1[playerid][6], cVehcoms1[playerid][7], cVehcoms1[playerid][8],
	cVehcoms1[playerid][9], cVehcoms1[playerid][10], cVehcoms1[playerid][11],
	cVehcoms1[playerid][12], cVehcoms1[playerid][13],
	cVehcoms2[playerid][0],cVehcoms2[playerid][1], cVehcoms2[playerid][2],
	cVehcoms2[playerid][3],cVehcoms2[playerid][4], cVehcoms2[playerid][5],
	cVehcoms2[playerid][6],cVehcoms2[playerid][7], cVehcoms2[playerid][8],
	cVehcoms2[playerid][9],cVehcoms2[playerid][10], cVehcoms2[playerid][11],
	cVehcoms2[playerid][12],cVehcoms2[playerid][13]);
	f(string, "%s `cVehcom` = '%s', ",             string, cVehcom3[playerid]);
	
	format(zapros,sizeof(zapros),"%i/%i",cPaintjob[playerid][0],cPaintjob[playerid][1]);
	f(string, "%s `cPaintjob` = '%s', ",           string, zapros);
	
	format(zapros,sizeof(zapros),"%i/%i",cVirtual[playerid][0],cVirtual[playerid][1]);
	f(string, "%s `cVirtual` = '%s', ",            string, zapros);
	
	format(zapros,sizeof(zapros),"%f/%f",CarParkX[playerid][0],CarParkX[playerid][1]);
	f(string, "%s `cX` = '%s', ",                  string, zapros);

	format(zapros,sizeof(zapros),"%f/%f",CarParkY[playerid][0],CarParkY[playerid][1]);
	f(string, "%s `cY` = '%s', ",                  string, zapros);
	
	format(zapros,sizeof(zapros),"%f/%f",CarParkZ[playerid][0],CarParkZ[playerid][1]);
	f(string, "%s `cZ` = '%s', ",                  string, zapros);
	
	format(zapros,sizeof(zapros),"%f/%f",CarParkA[playerid][0],CarParkA[playerid][1]);
	f(string, "%s `cA` = '%s', ",                  string, zapros);
	//--------------------------------------------------------------------------
	f(string, "%s `vehiclekey` = '%d', ",          string, PI[playerid][pVehicleKey][0]);
	f(string, "%s `vehiclekey1` = '%d', ",         string, PI[playerid][pVehicleKey][0]);
	f(string, "%s `aptechka` = '%d', ",            string, PI[playerid][pAptechka]);
	f(string, "%s `Voennik` = '%d', ",             string, PI[playerid][pVoennik]);
	f(string, "%s `music` = '%d', ",               string, PI[playerid][pMusic]);
	f(string, "%s `improves` = '%s', ",            string, PI[playerid][pImproves]);
	f(string, "%s `settings` = '%s', ",            string, PI[playerid][pSettings]);
	f(string, "%s `phnumber1` = '%i', ",           string, PhoneNumbers[playerid][0]);
	f(string, "%s `phnumber2` = '%i', ",           string, PhoneNumbers[playerid][1]);
	f(string, "%s `phnumber3` = '%i', ",           string, PhoneNumbers[playerid][2]);
	f(string, "%s `phnumber4` = '%i', ",           string, PhoneNumbers[playerid][3]);
	f(string, "%s `phnumber5` = '%i', ",           string, PhoneNumbers[playerid][4]);
	f(string, "%s `phnumber6` = '%i', ",           string, PhoneNumbers[playerid][5]);
	f(string, "%s `phnumber7` = '%i', ",           string, PhoneNumbers[playerid][6]);
	f(string, "%s `fishki` = '%i', ",              string, PI[playerid][pFishkis]);
	f(string, "%s `thour` = '%d', ",               string, PI[playerid][pTimeHour]);
	f(string, "%s `tday` = '%d', ",                string, PI[playerid][pTimeDay]);
	f(string, "%s `tlastday` = '%d', ",            string, PI[playerid][pTimeLastDay]);
	f(string, "%s `balon1` = '%d', ",              string, PI[playerid][pBalon][0]);
	f(string, "%s `balon2` = '%d', ",              string, PI[playerid][pBalon][1]);
	f(string, "%s `balon3` = '%d', ",              string, PI[playerid][pBalon][2]);
	f(string, "%s `balon4` = '%d', ",              string, PI[playerid][pBalon][3]);
	f(string, "%s `balon5` = '%d', ",              string, PI[playerid][pBalon][4]);
	f(string, "%s `balon6` = '%d', ",              string, PI[playerid][pBalon][5]);
	f(string, "%s `balon7` = '%d', ",              string, PI[playerid][pBalon][6]);
    f(string, "%s `remont` = '%d', ",              string, PI[playerid][pRemontNabor]);
	f(string, "%s `sleep` = '%d', ",               string, PI[playerid][pSleep]);
	f(string, "%s `fwarn` = '%d', ",               string, PI[playerid][pfWarn]);
	
	f(string, "%s WHERE `name` = '%s'", 		   string, PI[playerid][pName]);
	mysql_function_query(dbHandle, string, false, "", "");
	return 1;
}

Edited July 30, 2017 by vlad
Причина: взял код под спойлер

July 30, 2017

@stibs заменил

July 30, 2017

@Daniil Roslyakov Теперь пробуйте, если ошибка исчезла нажмите на галочку возле правильного ответа, если нет, то опять скиньте mysql_log.

July 30, 2017

СПАСИБО БОЛЬШОЕ МИЛЛИОН ПЛЮСОВ ТЕБЕ!!!!!!!!!!!!!!

Sign In

Проблема с Базой Данных

Question

Guest Новичок

Share this post

Link to post

12 answers to this question

Guest stibs Новичок

Share this post

Link to post

Guest stibs Новичок

Share this post

Link to post

Guest Новичок

Share this post

Link to post

Guest stibs Новичок

Share this post

Link to post

Guest Новичок

Share this post

Link to post

Guest stibs Новичок

Share this post

Link to post

Guest Новичок

Share this post

Link to post

Guest stibs Новичок

Share this post

Link to post

Guest Новичок

Share this post

Link to post

Guest Новичок

Share this post

Link to post

Guest stibs Новичок

Share this post

Link to post

Guest Новичок

Share this post

Link to post

Recently Browsing 0 members

Similar Content

Shop