• 0
Если Вы нашли ответ на вопрос, пожалуйста, пометьте необходимый ответ лучшим (галочка сбоку от сообщения) и поблагодарите автора этого ответа поднятием репутации (плюс в нижней правой части сообщения). Спасибо.
Подробнее:
FAQ по форуму
Как пометить ответ лучшим

Вопросы

Гость

Гость Новичок

Новичок

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

[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

 

0

Поделиться сообщением

Ссылка на сообщение
Лучший ответ

Опубликовал Гость stibs ,Опубликовано

Эту строку: f(string, "%s `fwarn` = '%d', ", string, PI[playerid][pfWarn]); Замените на эту: f(string, "%s `fwarn` = '%d' ", string, PI[playerid][pfWarn]);  
1
рейтинг
Перейти к сообщению

12 ответов на этот вопрос

  • 0

Гость stibs

Гость stibs Новичок

Новичок

Эту строку: 

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

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

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

 

1

Поделиться сообщением

Ссылка на сообщение
  • 0

Гость stibs

Гость stibs Новичок

Новичок

Здравствуйте. Данная проблема возникла вследствие неверного 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) после очередного появления ошибки.

Отредактировано пользователем stibs

0

Поделиться сообщением

Ссылка на сообщение
  • 0

Гость

Гость Новичок

Новичок

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

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

0

Поделиться сообщением

Ссылка на сообщение
  • 0

Гость stibs

Гость stibs Новичок

Новичок

@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). 

0

Поделиться сообщением

Ссылка на сообщение
  • 0

Гость

Гость Новичок

Новичок

@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

Отредактировано пользователем vlad
Причина: Взял логи под спойлер

1

Поделиться сообщением

Ссылка на сообщение
  • 0

Гость stibs

Гость stibs Новичок

Новичок

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

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

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

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

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

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

 

0

Поделиться сообщением

Ссылка на сообщение
  • 0

Гость stibs

Гость stibs Новичок

Новичок

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

0

Поделиться сообщением

Ссылка на сообщение
  • 0

Гость

Гость Новичок

Новичок

@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;
}

Отредактировано пользователем vlad
Причина: взял код под спойлер

0

Поделиться сообщением

Ссылка на сообщение
  • 0

Гость stibs

Гость stibs Новичок

Новичок

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

0

Поделиться сообщением

Ссылка на сообщение
Гость
Эта тема закрыта для публикации ответов.
Перейти к списку вопросов Вопросы / проблемы, связанные со скриптингом

  • Последние посетители   0 пользователей онлайн

    Ни одного зарегистрированного пользователя не просматривает данную страницу

  • Похожий контент

    • patrickk
      Как на сервер DM SAMP сделать режим с rp run и cj run
      От patrickk
      Всем привет, решил написать dm сервер и довольно хорошим получился, даже на голову выше Goat dm. Оставил не решенную проблему тем что  у меня есть 4 локации с rp run и cj run ну а как добавить cj бег на те локации не знаю и как эта система работает. Надеюсь мне помогут знающие люди
    • Samolet
      Ошибка OMP
      От Samolet
      Здраствуйте, cоздаю копию Arizona на ОМП, опен мультиплеер, загрузил и подключил бд, но сервер не хочет вот лог :[2026-10-20T21:03:32+0300] [Info] Log file reloaded. Starting open.mp server (1.5.8.3079) from commit c6759bd8d265171ae3d86598895a23d5a8d92a3b Loading component $CAPI.so Successfully loaded component C-API (1.5.8.3079) with UID 10467dd8d4c56fc6 Loading component LegacyConfig.so Successfully loaded component LegacyConfig (1.5.8.3079) with UID 24ef6216838f9ffc Loading component NPCs.so Successfully loaded component NPCs (1.5.8.3079) with UID 3d0e59e87f4e90bc Loading component Recordings.so Successfully loaded component Recordings (1.5.8.3079) with UID 871144d399f5f613 Loading component Checkpoints.so Successfully loaded component Checkpoints (1.5.8.3079) with UID 44a937350d611dde Loading component TextDraws.so Successfully loaded component TextDraws (1.5.8.3079) with UID 9b5dc2b1d15c992a Loading component Pawn.so Successfully loaded component Pawn (1.5.8.3079) with UID 78906cd9f19c36a6 Loading component GangZones.so Successfully loaded component GangZones (1.5.8.3079) with UID b3351d11ee8d8056 Loading component Actors.so Successfully loaded component Actors (1.5.8.3079) with UID c81ca021eae2ad5c Loading component Pickups.so Successfully loaded component Pickups (1.5.8.3079) with UID cf304faa363dd971 Loading component Dialogs.so Successfully loaded component Dialogs (1.5.8.3079) with UID 44a111350d611dde Loading component Objects.so Successfully loaded component Objects (1.5.8.3079) with UID 59f8415f72da6160 Loading component Console.so Successfully loaded component Console (1.5.8.3079) with UID bfa24e49d0c95ee4 Loading component TextLabels.so Successfully loaded component TextLabels (1.5.8.3079) with UID a0c57ea80a009742 Loading component Variables.so Successfully loaded component Variables (1.5.8.3079) with UID 75e121848bc01fa2 Loading component Databases.so Successfully loaded component Databases (1.5.8.3079) with UID 80092e7eb5821a96 Loading component LegacyNetwork.so Successfully loaded component RakNetLegacyNetwork (1.5.8.3079) with UID ea9799fd79cf8442 Loading component CustomModels.so Successfully loaded component CustomModels (1.5.8.3079) with UID 15e3cb1e7c77ffff Loading component Menus.so Successfully loaded component Menus (1.5.8.3079) with UID 621e219eb97ee0b2 Loading component Vehicles.so Successfully loaded component Vehicles (1.5.8.3079) with UID 3f1f62ee9e22ab19 Loading component Classes.so Successfully loaded component Classes (1.5.8.3079) with UID 8cfb3183976da208 Loading component Timers.so Successfully loaded component Timers (1.5.8.3079) with UID 2ad8124c5ea257a3 Loaded 22 component(s) from /home/gs113492/components Executing Server Config... [2026-10-20T21:03:33+0300] [Info] Loading plugin: crashdetect.so [2026-10-20T21:03:33+0300] [Info] CrashDetect plugin 4.19 [2026-10-20T21:03:33+0300] [Info] Loading plugin: mapandreas.so [2026-10-20T21:03:33+0300] [Info] Loading plugin: streamer.so [2026-10-20T21:03:33+0300] [Info] *** Streamer Plugin v2.9.4 by Incognito loaded *** [2026-10-20T21:03:33+0300] [Info] Loading plugin: sscanf.so [2026-10-20T21:03:33+0300] [Info] [2026-10-20T21:03:33+0300] [Info] =============================== [2026-10-20T21:03:33+0300] [Info] sscanf plugin loaded. [2026-10-20T21:03:33+0300] [Info] Version: 2.8.3 [2026-10-20T21:03:33+0300] [Info] (c) 2018 Alex "Y_Less" Cole [2026-10-20T21:03:33+0300] [Info] =============================== [2026-10-20T21:03:33+0300] [Info] Loading plugin: TOTP.so [2026-10-20T21:03:33+0300] [Info] TOTP plugin v1.0.1 by Games loaded. [2026-10-20T21:03:33+0300] [Info] Loading plugin: mysql_static.so [2026-10-20T21:03:33+0300] [Info] >> plugin.mysql: R39-6 successfully loaded. [2026-10-20T21:03:33+0300] [Info] Loading plugin: libpawn_json.so [2026-10-20T21:03:34+0300] [Error] Function not registered: YSF_SetTickRate [2026-10-20T21:03:34+0300] [Error] Function not registered: PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] Run time error 19: "File or function is not found" [2026-10-20T21:03:34+0300] [Info] [debug] PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] YSF_SetTickRate [2026-10-20T21:03:34+0300] [Error] File or function is not found [2026-10-20T21:03:34+0300] [Error] Function not registered: PC_RegAlias [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_GetWriteOffset [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_Reset [2026-10-20T21:03:34+0300] [Error] Function not registered: PR_RegHandler [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_Delete [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_New [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_ResetReadPointer [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_SetWriteOffset [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_IgnoreBits [2026-10-20T21:03:34+0300] [Error] Function not registered: PR_Init [2026-10-20T21:03:34+0300] [Error] Function not registered: PR_SendRPC [2026-10-20T21:03:34+0300] [Error] Function not registered: PR_SendPacket [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_WriteValue [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_GetNumberOfBytesUsed [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_ReadValue [2026-10-20T21:03:34+0300] [Error] Function not registered: PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] Run time error 19: "File or function is not found" [2026-10-20T21:03:34+0300] [Info] [debug] PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] BS_ReadValue [2026-10-20T21:03:34+0300] [Info] [debug] BS_GetNumberOfBytesUsed [2026-10-20T21:03:34+0300] [Info] [debug] BS_WriteValue [2026-10-20T21:03:34+0300] [Info] [debug] PR_SendPacket [2026-10-20T21:03:34+0300] [Info] [debug] PR_SendRPC [2026-10-20T21:03:34+0300] [Info] [debug] PR_Init [2026-10-20T21:03:34+0300] [Info] [debug] BS_IgnoreBits [2026-10-20T21:03:34+0300] [Info] [debug] BS_SetWriteOffset [2026-10-20T21:03:34+0300] [Info] [debug] BS_ResetReadPointer [2026-10-20T21:03:34+0300] [Info] [debug] BS_New [2026-10-20T21:03:34+0300] [Info] [debug] BS_Delete [2026-10-20T21:03:34+0300] [Info] [debug] PR_RegHandler [2026-10-20T21:03:34+0300] [Info] [debug] BS_Reset [2026-10-20T21:03:34+0300] [Info] [debug] BS_GetWriteOffset [2026-10-20T21:03:34+0300] [Info] [debug] PC_RegAlias [2026-10-20T21:03:34+0300] [Error] File or function is not found [2026-10-20T21:03:34+0300] [Info] [debug] Run time error 19: "File or function is not found" [2026-10-20T21:03:34+0300] [Info] [debug] PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] YSF_SetTickRate [2026-10-20T21:03:34+0300] [Error] File or function is not found [2026-10-20T21:03:34+0300] [Info] [debug] Run time error 19: "File or function is not found" [2026-10-20T21:03:34+0300] [Info] [debug] PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] BS_ReadValue [2026-10-20T21:03:34+0300] [Info] [debug] BS_GetNumberOfBytesUsed [2026-10-20T21:03:34+0300] [Info] [debug] BS_WriteValue [2026-10-20T21:03:34+0300] [Info] [debug] PR_SendPacket [2026-10-20T21:03:34+0300] [Info] [debug] PR_SendRPC [2026-10-20T21:03:34+0300] [Info] [debug] PR_Init [2026-10-20T21:03:34+0300] [Info] [debug] BS_IgnoreBits [2026-10-20T21:03:34+0300] [Info] [debug] BS_SetWriteOffset [2026-10-20T21:03:34+0300] [Info] [debug] BS_ResetReadPointer [2026-10-20T21:03:34+0300] [Info] [debug] BS_New [2026-10-20T21:03:34+0300] [Info] [debug] BS_Delete [2026-10-20T21:03:34+0300] [Info] [debug] PR_RegHandler [2026-10-20T21:03:34+0300] [Info] [debug] BS_Reset [2026-10-20T21:03:34+0300] [Info] [debug] BS_GetWriteOffset [2026-10-20T21:03:34+0300] [Info] [debug] PC_RegAlias [2026-10-20T21:03:34+0300] [Info] Legacy Network started on ***.**.**.***:2717. Помогите пожалуйста