Некорректно работает система личных автомобилей

[DmitriyVasilev]

Здравствуйте, когда выхожу из сервера и перезахожу все купленные авто сохраняются и остаюится, но когда я перезапускаю сервер - все авто становятся стандартными ( Фаггио , те не сохраняются ) хотя в дисконеекте все прописалось что автомобили сохранены, вот само сохранение при дисконекте, через паблик сохраняю
case 37:
{
if(!r)
{
return print(!"[Error] Информация о машинах игрока в бд не найдена");
}
new temp[0x9e];
for(x = 0; x < r; x++)
{
mysql_format(DATABASE, QUERY, sizeof(QUERY), "UPDATE `"TABLE_CARS"` SET ");
format(temp,sizeof(temp),"`model`= '%i',",CarInfo[playerid][carModel][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`color_one`= '%i',",CarInfo[playerid][carColor_one][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`color_two`= '%i',",CarInfo[playerid][carColor_two][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`percent`= '%i',",CarInfo[playerid][carPercent][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`fuel`= '%f',",CarInfo[playerid][carFuel][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_1`= '%i',",CarInfo[playerid][carVehcom_1][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_2`= '%i',",CarInfo[playerid][carVehcom_2][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_3`= '%i',",CarInfo[playerid][carVehcom_3][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_4`= '%i',",CarInfo[playerid][carVehcom_4][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_5`= '%i',",CarInfo[playerid][carVehcom_5][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_6`= '%i',",CarInfo[playerid][carVehcom_6][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_7`= '%i',",CarInfo[playerid][carVehcom_7][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_8`= '%i',",CarInfo[playerid][carVehcom_8][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_9`= '%i',",CarInfo[playerid][carVehcom_9][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_10`= '%i',",CarInfo[playerid][carVehcom_10][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_11`= '%i',",CarInfo[playerid][carVehcom_11][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_12`= '%i',",CarInfo[playerid][carVehcom_12][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_13`= '%i',",CarInfo[playerid][carVehcom_13][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_14`= '%i'",CarInfo[playerid][carVehcom_14][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"WHERE id = '%i' AND owner = '%s'",x,User[playerid][pName]), strcat(QUERY,temp,sizeof(QUERY));
mysql_function_query(DATABASE, QUERY, true, "", "");
}
printf("[Сохранение] Автомобили %s | %i,%i,%i,%i,%i сохранены",User[playerid][pName],CarInfo[playerid][carModel][0],CarInfo[playerid][carModel][1],CarInfo[playerid][carModel][2],CarInfo[playerid][carModel][3],CarInfo[playerid][carModel][4]);
}
}

[DeimoS]

Удали файл с логами, вставь этот код, удостоверься, что у тебя есть нормальный транспорт (не стандартный) и перезагрузи сервер (или когда там у тебя слетают авто), а после скинь логи

case 37:
{
if(!r)
{
return print(!"[Error] Информация о машинах игрока в бд не найдена");
}
QUERY = "UPDATE `"TABLE_CARS"` SET ";
for(x = 0; x < r; x++)
{
format(QUERY,sizeof(QUERY),"%s`model`= '%i',", QUERY, CarInfo[playerid][carModel][x]);
format(QUERY,sizeof(QUERY),"%s`color_one`= '%i',", QUERY, CarInfo[playerid][carColor_one][x]);
format(QUERY,sizeof(QUERY),"%s`color_two`= '%i',", QUERY, CarInfo[playerid][carColor_two][x]);
format(QUERY,sizeof(QUERY),"%s`percent`= '%i',", QUERY, CarInfo[playerid][carPercent][x]);
format(QUERY,sizeof(QUERY),"%s`fuel`= '%f',", QUERY, CarInfo[playerid][carFuel][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_1`= '%i',", QUERY, CarInfo[playerid][carVehcom_1][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_2`= '%i',", QUERY, CarInfo[playerid][carVehcom_2][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_3`= '%i',", QUERY, CarInfo[playerid][carVehcom_3][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_4`= '%i',", QUERY, CarInfo[playerid][carVehcom_4][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_5`= '%i',", QUERY, CarInfo[playerid][carVehcom_5][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_6`= '%i',", QUERY, CarInfo[playerid][carVehcom_6][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_7`= '%i',", QUERY, CarInfo[playerid][carVehcom_7][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_8`= '%i',", QUERY, CarInfo[playerid][carVehcom_8][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_9`= '%i',", QUERY, CarInfo[playerid][carVehcom_9][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_10`= '%i',", QUERY, CarInfo[playerid][carVehcom_10][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_11`= '%i',", QUERY, CarInfo[playerid][carVehcom_11][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_12`= '%i',", QUERY, CarInfo[playerid][carVehcom_12][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_13`= '%i',", QUERY, CarInfo[playerid][carVehcom_13][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_14`= '%i'", QUERY, CarInfo[playerid][carVehcom_14][x]);
format(QUERY,sizeof(QUERY),"%s WHERE id = '%i' AND owner = '%s'", QUERY, x,User[playerid][pName]);
mysql_function_query(DATABASE, QUERY, true, "", "");
printf("\n\n%s\n\n", QUERY);
}
printf("[Сохранение] Автомобили %s | %i,%i,%i,%i,%i сохранены", User[playerid][pName],CarInfo[playerid][carModel][0],CarInfo[playerid][carModel][1],CarInfo[playerid][carModel][2],CarInfo[playerid][carModel][3],CarInfo[playerid][carModel][4]);
}
}

[DmitriyVasilev]

15:07:07]

UPDATE `cars` SET `model`= '461',`color_one`= '6',`color_two`= '6',`percent`= '100',`fuel`= '200.000000',`vehcom_1`= '0',`vehcom_2`= '0',`vehcom_3`= '0',`vehcom_4`= '0',`vehcom_5`= '0',`vehcom_6`= '0',`vehcom_7`= '0',`vehcom_8`= '0',`vehcom_9`= '0',`vehcom_10`= '0',`vehcom_11`= '0',`vehcom_12`= '0',`vehcom_13`= '0',`vehcom_14`= '0' WHERE id = '0' AND owner = 'El_Capone'


[15:07:07] [Сохранение] Автомобили El_Capone | 461,462,462,462,462 сохранены
потом сервер выключил и включил и снова
[Загрузка ...] Автомобили игрока El_Capone были загружены: 462, 462, 462, 462, 462 а не 461

[DeimoS]

Дай полный лог перед слётом и после слёта. И покажи структуру таблицы cars.
Кажется, проблема вот тут:

format(QUERY,sizeof(QUERY),"%s WHERE id = '%i' AND owner = '%s'", QUERY, x,User[playerid][pName]);
А именно в определении значения для "WHERE id = %i". Сейчас у тебя для всех игроков ID будут от 0 до 4. Так и задумано?

[DmitriyVasilev]

вот весь лог

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

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

[15:01:59] filterscripts = "" (string)
[15:01:59]
[15:01:59] Server Plugins
[15:01:59] --------------
[15:01:59] Loading plugin: crashdetect
[15:01:59] CrashDetect plugin 4.19.4
[15:01:59] Loaded.
[15:01:59] Loading plugin: streamer
[15:01:59]

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

[15:01:59] Loaded.
[15:01:59] Loading plugin: sscanf
[15:01:59]

[15:01:59] ===============================

[15:01:59] sscanf plugin loaded.

[15:01:59] Version: 2.8.1

[15:01:59] (c) 2012 Alex "Y_Less" Cole

[15:01:59] ===============================

[15:01:59] Loaded.
[15:01:59] Loading plugin: mysql
[15:02:00] >> plugin.mysql: R39-2 successfully loaded.
[15:02:00] Loaded.
[15:02:00] Loading plugin: pawncmd
[15:02:00] Pawn.CMD plugin v3.1.4 by urShadow loaded
[15:02:00] Loaded.
[15:02:00] Loading plugin: regex
[15:02:00]


[15:02:00] ______________________________________


[15:02:00] Regular Expression Plugin v0.2.1 loaded
[15:02:00] ______________________________________


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


[15:02:00] Loaded.
[15:02:00] Loaded 6 plugins.

[15:02:00]
[15:02:00] Filterscripts
[15:02:00] ---------------
[15:02:00] Loaded 0 filterscripts.

[15:02:00] [Load] Меню сервера загружено!
[15:02:00] Подождите, пожалуйста, идёт загрузка . . .
[15:02:00] Загрузка завершена!
[15:02:00] Number of vehicle models: 61
[15:02:01] [Load] Данные из House получены! (782 шт.)
[15:02:01] [Load] Данные из Bizz получены! (48 шт.)
[15:02:01] [Load] Данные из Workshop получены! (3 шт.)
[15:02:01] [Load] Данные из Kvart получены! (70 шт.)
[15:02:01] [Load] Данные из Podeezd получены! (2 шт.)
[15:02:01] [Load] Данные из Others получены!
[15:02:01] [Load] Данные из Atm получены! (21 шт.)
[15:02:01] [Load] Данные из Gangzone получены! (130 шт.)
[15:02:01] [Load] Забаненых аккаунтов 0. Разбанено 0 аккаунтов

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

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

[15:02:03] filterscripts = "" (string)
[15:02:03]
[15:02:03] Server Plugins
[15:02:03] --------------
[15:02:03] Loading plugin: crashdetect
[15:02:03] CrashDetect plugin 4.19.4
[15:02:03] Loaded.
[15:02:03] Loading plugin: streamer
[15:02:03]

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

[15:02:03] Loaded.
[15:02:03] Loading plugin: sscanf
[15:02:03]

[15:02:03] ===============================

[15:02:03] sscanf plugin loaded.

[15:02:03] Version: 2.8.1

[15:02:03] (c) 2012 Alex "Y_Less" Cole

[15:02:03] ===============================

[15:02:03] Loaded.
[15:02:03] Loading plugin: mysql
[15:02:03] >> plugin.mysql: R39-2 successfully loaded.
[15:02:03] Loaded.
[15:02:03] Loading plugin: pawncmd
[15:02:03] Pawn.CMD plugin v3.1.4 by urShadow loaded
[15:02:03] Loaded.
[15:02:03] Loading plugin: regex
[15:02:03]


[15:02:03] ______________________________________


[15:02:03] Regular Expression Plugin v0.2.1 loaded
[15:02:03] ______________________________________


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


[15:02:03] Loaded.
[15:02:03] Loaded 6 plugins.

[15:02:03]
[15:02:03] Filterscripts
[15:02:03] ---------------
[15:02:03] Loaded 0 filterscripts.

[15:02:03] [Load] Меню сервера загружено!
[15:02:03] Подождите, пожалуйста, идёт загрузка . . .
[15:02:03] Загрузка завершена!
[15:02:03] Number of vehicle models: 61
[15:02:03] [Load] Данные из House получены! (782 шт.)
[15:02:03] [Load] Данные из Bizz получены! (48 шт.)
[15:02:03] [Load] Данные из Workshop получены! (3 шт.)
[15:02:03] [Load] Данные из Kvart получены! (70 шт.)
[15:02:03] [Load] Данные из Podeezd получены! (2 шт.)
[15:02:03] [Load] Данные из Others получены!
[15:02:03] [Load] Данные из Atm получены! (21 шт.)
[15:02:03] [Load] Данные из Gangzone получены! (130 шт.)
[15:02:03] [Load] Забаненых аккаунтов 0. Разбанено 0 аккаунтов
[15:02:38] Incoming connection: 127.0.0.1:58455
[15:02:38] [join] Mike_Jordan has joined the server (0:127.0.0.1)
[15:02:46] [Загрузка ...] Автомобили игрока Mike_Jordan были загружены: 462, 462, 462, 462, 462
[15:02:52] Command: alogin | Mike_Jordan
[15:03:00] Command: testimoney | Mike_Jordan
[15:03:00] Файл-Аккаунт Mike_Jordan успешно сохранён
[15:03:00] [part] Mike_Jordan has left the server (0:1)
[15:03:00]

UPDATE `cars` SET `model`= '462',`color_one`= '1',`color_two`= '1',`percent`= '100',`fuel`= '100.000000',`vehcom_1`= '0',`vehcom_2`= '0',`vehcom_3`= '0',`vehcom_4`= '0',`vehcom_5`= '0',`vehcom_6`= '0',`vehcom_7`= '0',`vehcom_8`= '0',`vehcom_9`= '0',`vehcom_10`= '0',`vehcom_11`= '0',`vehcom_12`= '0',`vehcom_13`= '0',`vehcom_14`= '0' WHERE id = '0' AND owner = 'Mike_Jordan'


[15:03:00] [Сохранение] Автомобили Mike_Jordan | 462,462,462,462,462 сохранены
[15:03:38] Incoming connection: 127.0.0.1:52946
[15:03:38] [join] El_Capone has joined the server (0:127.0.0.1)
[15:03:46] [Загрузка ...] Автомобили игрока El_Capone были загружены: 462, 462, 462, 462, 462
[15:03:51] Command: alogin | El_Capone
[15:03:52] Command: tp | El_Capone
[15:03:56] Command: v | El_Capone
[15:04:00] Command: tp | El_Capone
[15:04:12] Command: tp | El_Capone
[15:04:25] Command: tp | El_Capone
[15:04:31] Command: tp | El_Capone
[15:04:38] Command: v | El_Capone
[15:04:43] Command: v | El_Capone
[15:05:18] Игрок El_Capone купил дом 388
[15:05:18] [Загрузка ...] Автомобили игрока El_Capone были загружены: 462, 462, 462, 462, 462
[15:05:21] Command: sp | El_Capone
[15:05:26] Command: spawnhange | El_Capone
[15:05:28] Command: spawnchange | El_Capone
[15:05:30] Command: sp | El_Capone
[15:05:33] Command: spawnchange | El_Capone
[15:05:35] Command: sp | El_Capone
[15:05:36] Command: spawnchange | El_Capone
[15:05:37] Command: sp | El_Capone
[15:05:46] Command: lokc | El_Capone
[15:05:47] Command: lock | El_Capone
[15:05:48] Command: lock | El_Capone
[15:05:55] Command: tp | El_Capone
[15:05:59] Command: tp | El_Capone
[15:06:47] Игрок El_Capone купил автомобиль [ID: 461]
[15:06:50] Command: sp | El_Capone
[15:06:51] Command: payday | El_Capone
[15:06:55] Command: fixcar | El_Capone
[15:06:57] Command: lock | El_Capone
[15:06:58] Command: lock | El_Capone
[15:07:01] Command: fixcar | El_Capone
[15:07:01] [debug] Run time error 4: "Array index out of bounds"
[15:07:01] [debug] Attempted to read/write array element at negative index -1
[15:07:01] [debug] AMX backtrace:
[15:07:01] [debug] #0 002d56bc in public OnVehicleSpawn (vehicleid=419) at C:\Users\А321\Desktop\SAMP03E BONUS\gamemodes\srp.pwn:34182
[15:07:01] [debug] #1 native SetVehicleToRespawn () in samp-server.exe
[15:07:01] [debug] #2 0029f978 in public pc_cmd_fixcar (playerid=0, 2893240) at C:\Users\А321\Desktop\SAMP03E BONUS\gamemodes\srp.pwn:30977
[15:07:02] Command: sp | El_Capone
[15:07:07] Файл-Аккаунт El_Capone успешно сохранён
[15:07:07] [part] El_Capone has left the server (0:1)
[15:07:07]

UPDATE `cars` SET `model`= '461',`color_one`= '6',`color_two`= '6',`percent`= '100',`fuel`= '200.000000',`vehcom_1`= '0',`vehcom_2`= '0',`vehcom_3`= '0',`vehcom_4`= '0',`vehcom_5`= '0',`vehcom_6`= '0',`vehcom_7`= '0',`vehcom_8`= '0',`vehcom_9`= '0',`vehcom_10`= '0',`vehcom_11`= '0',`vehcom_12`= '0',`vehcom_13`= '0',`vehcom_14`= '0' WHERE id = '0' AND owner = 'El_Capone'


[15:07:07] [Сохранение] Автомобили El_Capone | 461,462,462,462,462 сохранены

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

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

[15:07:36] filterscripts = "" (string)
[15:07:36]
[15:07:36] Server Plugins
[15:07:36] --------------
[15:07:36] Loading plugin: crashdetect
[15:07:36] CrashDetect plugin 4.19.4
[15:07:36] Loaded.
[15:07:36] Loading plugin: streamer
[15:07:36]

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

[15:07:36] Loaded.
[15:07:36] Loading plugin: sscanf
[15:07:36]

[15:07:36] ===============================

[15:07:36] sscanf plugin loaded.

[15:07:36] Version: 2.8.1

[15:07:36] (c) 2012 Alex "Y_Less" Cole

[15:07:36] ===============================

[15:07:36] Loaded.
[15:07:36] Loading plugin: mysql
[15:07:36] >> plugin.mysql: R39-2 successfully loaded.
[15:07:36] Loaded.
[15:07:36] Loading plugin: pawncmd
[15:07:36] Pawn.CMD plugin v3.1.4 by urShadow loaded
[15:07:36] Loaded.
[15:07:36] Loading plugin: regex
[15:07:36]


[15:07:36] ______________________________________


[15:07:36] Regular Expression Plugin v0.2.1 loaded
[15:07:36] ______________________________________


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


[15:07:36] Loaded.
[15:07:36] Loaded 6 plugins.

[15:07:36]
[15:07:36] Filterscripts
[15:07:36] ---------------
[15:07:36] Loaded 0 filterscripts.

[15:07:36] [Load] Меню сервера загружено!
[15:07:36] Подождите, пожалуйста, идёт загрузка . . .
[15:07:36] Загрузка завершена!
[15:07:36] Number of vehicle models: 61
[15:07:36] [Load] Данные из House получены! (782 шт.)
[15:07:36] [Load] Данные из Bizz получены! (48 шт.)
[15:07:36] [Load] Данные из Workshop получены! (3 шт.)
[15:07:36] [Load] Данные из Kvart получены! (70 шт.)
[15:07:36] [Load] Данные из Podeezd получены! (2 шт.)
[15:07:36] [Load] Данные из Others получены!
[15:07:36] [Load] Данные из Atm получены! (21 шт.)
[15:07:36] [Load] Данные из Gangzone получены! (130 шт.)
[15:07:36] [Load] Забаненых аккаунтов 0. Разбанено 0 аккаунтов
[15:08:00] Incoming connection: 127.0.0.1:51173
[15:08:00] [join] El_Capone has joined the server (0:127.0.0.1)
[15:08:11] [Загрузка ...] Автомобили игрока El_Capone были загружены: 462, 462, 462, 462, 462
[15:11:21] Файл-Аккаунт El_Capone успешно сохранён
[15:11:21] [part] El_Capone has left the server (0:1)
[15:11:21]

UPDATE `cars` SET `model`= '462',`color_one`= '1',`color_two`= '1',`percent`= '100',`fuel`= '100.000000',`vehcom_1`= '0',`vehcom_2`= '0',`vehcom_3`= '0',`vehcom_4`= '0',`vehcom_5`= '0',`vehcom_6`= '0',`vehcom_7`= '0',`vehcom_8`= '0',`vehcom_9`= '0',`vehcom_10`= '0',`vehcom_11`= '0',`vehcom_12`= '0',`vehcom_13`= '0',`vehcom_14`= '0' WHERE id = '0' AND owner = 'El_Capone'


[15:11:21] [Сохранение] Автомобили El_Capone | 462,462,462,462,462 сохранены

а вот структура
--
-- Структура таблицы `cars`
--

CREATE TABLE IF NOT EXISTS `cars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`owner` varchar(32) NOT NULL,
`model` int(11) NOT NULL DEFAULT '462',
`color_one` int(11) NOT NULL DEFAULT '203',
`color_two` int(11) NOT NULL DEFAULT '203',
`percent` int(11) NOT NULL DEFAULT '0',
`fuel` float NOT NULL DEFAULT '100',
`vehcom_1` int(11) NOT NULL DEFAULT '0',
`vehcom_2` int(11) NOT NULL DEFAULT '0',
`vehcom_3` int(11) NOT NULL DEFAULT '0',
`vehcom_4` int(11) NOT NULL DEFAULT '0',
`vehcom_5` int(11) NOT NULL DEFAULT '0',
`vehcom_6` int(11) NOT NULL DEFAULT '0',
`vehcom_7` int(11) NOT NULL DEFAULT '0',
`vehcom_8` int(11) NOT NULL DEFAULT '0',
`vehcom_9` int(11) NOT NULL DEFAULT '0',
`vehcom_10` int(11) NOT NULL DEFAULT '0',
`vehcom_11` int(11) NOT NULL DEFAULT '0',
`vehcom_12` int(11) NOT NULL DEFAULT '0',
`vehcom_13` int(11) NOT NULL DEFAULT '0',
`vehcom_14` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=132 ;
и на всякий случай скину Загрузку авто
case 33:
{
if(!r)
{
for(new i=0;i<5;i++)
{
mysql_format(DATABASE, QUERY, sizeof(QUERY), "INSERT INTO `"TABLE_CARS"` (`owner`,`id`,`model`,`fuel`,`color_one`,`color_two`) VALUES ('%s','%i','462','100','1','1')" ,User[playerid][pName],i);
mysql_function_query(DATABASE,QUERY,false,"","");
}

return SCM(playerid,COLOR_GREY, !"Информация о ваших автомобилях не была найдена. Перезайдите на сервер!");
}
for(x = 0; x < r; x++)
{
CarInfo[playerid][carID][x] = cache_get_row_int(x,0, DATABASE);
cache_get_row(x, 1, string, DATABASE, MAX_PLAYER_NAME+1);
CarInfo[playerid][carModel][x] = cache_get_row_int(x,2, DATABASE);
CarInfo[playerid][carColor_one][x] = cache_get_row_int(x,3, DATABASE);
CarInfo[playerid][carColor_two][x] = cache_get_row_int(x,4, DATABASE);
CarInfo[playerid][carPercent][x] = cache_get_row_int(x,5, DATABASE);
CarInfo[playerid][carFuel][x] = cache_get_row_float(x,6, DATABASE);
CarInfo[playerid][carVehcom_1][x] = cache_get_row_int(x,7, DATABASE);
CarInfo[playerid][carVehcom_2][x] = cache_get_row_int(x,8, DATABASE);
CarInfo[playerid][carVehcom_3][x] = cache_get_row_int(x,9, DATABASE);
CarInfo[playerid][carVehcom_4][x] = cache_get_row_int(x,10, DATABASE);
CarInfo[playerid][carVehcom_5][x] = cache_get_row_int(x,11, DATABASE);
CarInfo[playerid][carVehcom_6][x] = cache_get_row_int(x,12, DATABASE);
CarInfo[playerid][carVehcom_7][x] = cache_get_row_int(x,13, DATABASE);
CarInfo[playerid][carVehcom_8][x] = cache_get_row_int(x,14, DATABASE);
CarInfo[playerid][carVehcom_9][x] = cache_get_row_int(x,15, DATABASE);
CarInfo[playerid][carVehcom_10][x] = cache_get_row_int(x,16, DATABASE);
CarInfo[playerid][carVehcom_11][x] = cache_get_row_int(x,17, DATABASE);
CarInfo[playerid][carVehcom_12][x] = cache_get_row_int(x,18, DATABASE);
CarInfo[playerid][carVehcom_13][x] = cache_get_row_int(x,19, DATABASE);
CarInfo[playerid][carVehcom_14][x] = cache_get_row_int(x,20, DATABASE);
}
if(CarInfo[playerid][carModel][0] == 0 || CarInfo[playerid][carModel][1] == 0 || CarInfo[playerid][carModel][2] == 0
|| CarInfo[playerid][carModel][3] == 0 || CarInfo[playerid][carModel][4] == 0)
{
for(new i = 0; i < 5; i++)
{
CarInfo[playerid][carModel][i] = 462;
CarInfo[playerid][carColor_one][i] = 1;
CarInfo[playerid][carColor_two][i] = 1;
CarInfo[playerid][carPercent][i] = 100;
}
}
printf("[Загрузка ...] Автомобили игрока %s были загружены: %i, %i, %i, %i, %i",Name(playerid), CarInfo[playerid][carModel][0],CarInfo[playerid][carModel][1],CarInfo[playerid][carModel][2],CarInfo[playerid][carModel][3],CarInfo[playerid][carModel][4]);
if(HGet(playerid))
{
new house = User[playerid][pPHouseKey];
switch(HouseInfo[house][hKlass])
{
case 0..1:
{
garage_car[playerid][0] = CreateVehicle(CarInfo[playerid][carModel][0], HouseInfo[house][hCarx], HouseInfo[house][hCary], HouseInfo[house][hCarz], HouseInfo[house][hCarc] , CarInfo[playerid][carColor_one][0] ,CarInfo[playerid][carColor_two][0], 86400);
SetVehicleParamsEx(garage_car[playerid][0],false,false,false,true,false,false,false);
//CarHealth[garage_car[playerid][0]] = float(1000);
createdcar ++;
Fuell[garage_car[playerid][0]] = CarInfo[playerid][carFuel][0];
LoadTuning(playerid,garage_car[playerid][0],0);
house_car[playerid] = garage_car[playerid][0];
}
case 2: // house C Class
{
SpawnCarOne(playerid, 248.1234,-110.5993,1003.6578,90.6935); // Load car #2
LinkVehicleToInterior(garage_car[playerid][0], 19);
SetVehicleVirtualWorld(garage_car[playerid][0], house+100);
//----------------------
SpawnCarTwo(playerid, 248.3368,-104.4114,1003.6582,86.1593); // Load car #1
LinkVehicleToInterior(garage_car[playerid][1], 19);
SetVehicleVirtualWorld(garage_car[playerid][1], house+100);
}
case 3: // house B Class
{
SpawnCarOne(playerid, 435.5904,468.6050,1002.6595,358.6705); // Load car #1
LinkVehicleToInterior(garage_car[playerid][0], 19);
SetVehicleVirtualWorld(garage_car[playerid][0], house+100);
//----------------------
SpawnCarTwo(playerid, 441.7249,468.3962,1002.6600,360.0000); // Load car #2
LinkVehicleToInterior(garage_car[playerid][1], 19);
SetVehicleVirtualWorld(garage_car[playerid][1], house+100);
//----------------------
SpawnCarThree(playerid, 447.4809,468.1860,1002.6586,358.1951); // Load car #3
LinkVehicleToInterior(garage_car[playerid][2], 19);
SetVehicleVirtualWorld(garage_car[playerid][2], house+100);
}
case 4: // house A Class
{
SpawnCarOne(playerid, 893.5298,31.7400,1004.1795,333.8575); // Load car #1
LinkVehicleToInterior(garage_car[playerid][0], 19);
SetVehicleVirtualWorld(garage_car[playerid][0], house+100);
//----------------------
SpawnCarTwo(playerid, 897.6765,31.8136,1004.1783,0.9835); // Load car #2
LinkVehicleToInterior(garage_car[playerid][1], 19);
SetVehicleVirtualWorld(garage_car[playerid][1], house+100);
//----------------------
SpawnCarThree(playerid, 902.9612,31.9576,1004.1783,1.5516); // Load car #3
LinkVehicleToInterior(garage_car[playerid][2], 19);
SetVehicleVirtualWorld(garage_car[playerid][2], house+100);
//----------------------
SpawnCarFour(playerid, 907.1154,32.3961,1004.1783,30.6716); // Load car #4
LinkVehicleToInterior(garage_car[playerid][3], 19);
SetVehicleVirtualWorld(garage_car[playerid][3], house+100);
}
case 5: // house S Class
{
SpawnCarOne(playerid, 511.2867,505.0032,1002.3588,47.6021); // Load car #1
LinkVehicleToInterior(garage_car[playerid][0], 19);
SetVehicleVirtualWorld(garage_car[playerid][0], house+100);
//----------------------
SpawnCarTwo(playerid, 504.8487,503.1697,1002.3583,90.2742); // Load car #3
LinkVehicleToInterior(garage_car[playerid][1], 19);
SetVehicleVirtualWorld(garage_car[playerid][1], house+100);
//----------------------
SpawnCarThree(playerid, 504.5507,512.3398,1002.3583,91.0430); // Load car #4
LinkVehicleToInterior(garage_car[playerid][2], 19);
SetVehicleVirtualWorld(garage_car[playerid][2], house+100);
//----------------------
SpawnCarFour(playerid, 504.7199,521.3282,1002.3588,90.3364); // Load car #5
LinkVehicleToInterior(garage_car[playerid][3], 19);
SetVehicleVirtualWorld(garage_car[playerid][3], house+100);
//----------------------
SpawnCarFive(playerid, 511.4334,518.2543,1002.3597,126.6747); // Load car #2
LinkVehicleToInterior(garage_car[playerid][4], 19);
SetVehicleVirtualWorld(garage_car[playerid][4], house+100);
}
}
// SetPVarInt(playerid,"chosencar",0);
}
}

[DeimoS]

Скорее всего, проблема в загрузке.
Покажи запрос на загрузку данных.

Вставь этот код, купи транспорт, выйди с сервера, зайди и после этого скинь логи

case 33:
{
if(!r)
{
for(new i=0;i<5;i++)
{
mysql_format(DATABASE, QUERY, sizeof(QUERY), "INSERT INTO `"TABLE_CARS"` (`owner`,`id`,`model`,`fuel`,`color_one`,`color_tw o`) VALUES ('%s','%i','462','100','1','1')" ,User[playerid][pName],i);
mysql_function_query(DATABASE,QUERY,false,"","");
}

return SCM(playerid,COLOR_GREY, !"Информация о ваших автомобилях не была найдена. Перезайдите на сервер!");
}
print("\n\n\n");
for(x = 0; x < r; x++)
{
CarInfo[playerid][carID][x] = cache_get_row_int(x,0, DATABASE);
cache_get_row(x, 1, string, DATABASE, MAX_PLAYER_NAME+1);
CarInfo[playerid][carModel][x] = cache_get_row_int(x,2, DATABASE);
printf("CarInfo[%d][carModel][%d] = %d", playerid, x, CarInfo[playerid][carModel][x]);
CarInfo[playerid][carColor_one][x] = cache_get_row_int(x,3, DATABASE);
CarInfo[playerid][carColor_two][x] = cache_get_row_int(x,4, DATABASE);
CarInfo[playerid][carPercent][x] = cache_get_row_int(x,5, DATABASE);
CarInfo[playerid][carFuel][x] = cache_get_row_float(x,6, DATABASE);
CarInfo[playerid][carVehcom_1][x] = cache_get_row_int(x,7, DATABASE);
CarInfo[playerid][carVehcom_2][x] = cache_get_row_int(x,8, DATABASE);
CarInfo[playerid][carVehcom_3][x] = cache_get_row_int(x,9, DATABASE);
CarInfo[playerid][carVehcom_4][x] = cache_get_row_int(x,10, DATABASE);
CarInfo[playerid][carVehcom_5][x] = cache_get_row_int(x,11, DATABASE);
CarInfo[playerid][carVehcom_6][x] = cache_get_row_int(x,12, DATABASE);
CarInfo[playerid][carVehcom_7][x] = cache_get_row_int(x,13, DATABASE);
CarInfo[playerid][carVehcom_8][x] = cache_get_row_int(x,14, DATABASE);
CarInfo[playerid][carVehcom_9][x] = cache_get_row_int(x,15, DATABASE);
CarInfo[playerid][carVehcom_10][x] = cache_get_row_int(x,16, DATABASE);
CarInfo[playerid][carVehcom_11][x] = cache_get_row_int(x,17, DATABASE);
CarInfo[playerid][carVehcom_12][x] = cache_get_row_int(x,18, DATABASE);
CarInfo[playerid][carVehcom_13][x] = cache_get_row_int(x,19, DATABASE);
CarInfo[playerid][carVehcom_14][x] = cache_get_row_int(x,20, DATABASE);
}
print("\n\n\n");
if(CarInfo[playerid][carModel][0] == 0 || CarInfo[playerid][carModel][1] == 0 || CarInfo[playerid][carModel][2] == 0
|| CarInfo[playerid][carModel][3] == 0 || CarInfo[playerid][carModel][4] == 0)
{
for(new i = 0; i < 5; i++)
{
CarInfo[playerid][carModel][i] = 462;
CarInfo[playerid][carColor_one][i] = 1;
CarInfo[playerid][carColor_two][i] = 1;
CarInfo[playerid][carPercent][i] = 100;
}
}
printf("[Загрузка ...] Автомобили игрока %s были загружены: %i, %i, %i, %i, %i",Name(playerid), CarInfo[playerid][carModel][0],CarInfo[playerid][carModel][1],CarInfo[playerid][carModel][2],CarInfo[playerid][carModel][3],CarInfo[playerid][carModel][4]);
if(HGet(playerid))
{
new house = User[playerid][pPHouseKey];
switch(HouseInfo[house][hKlass])
{
case 0..1:
{
garage_car[playerid][0] = CreateVehicle(CarInfo[playerid][carModel][0], HouseInfo[house][hCarx], HouseInfo[house][hCary], HouseInfo[house][hCarz], HouseInfo[house][hCarc] , CarInfo[playerid][carColor_one][0] ,CarInfo[playerid][carColor_two][0], 86400);
SetVehicleParamsEx(garage_car[playerid][0],false,false,false,true,false,false,false);
//CarHealth[garage_car[playerid][0]] = float(1000);
createdcar ++;
Fuell[garage_car[playerid][0]] = CarInfo[playerid][carFuel][0];
LoadTuning(playerid,garage_car[playerid][0],0);
house_car[playerid] = garage_car[playerid][0];
}
case 2: // house C Class
{
SpawnCarOne(playerid, 248.1234,-110.5993,1003.6578,90.6935); // Load car #2
LinkVehicleToInterior(garage_car[playerid][0], 19);
SetVehicleVirtualWorld(garage_car[playerid][0], house+100);
//----------------------
SpawnCarTwo(playerid, 248.3368,-104.4114,1003.6582,86.1593); // Load car #1
LinkVehicleToInterior(garage_car[playerid][1], 19);
SetVehicleVirtualWorld(garage_car[playerid][1], house+100);
}
case 3: // house B Class
{
SpawnCarOne(playerid, 435.5904,468.6050,1002.6595,358.6705); // Load car #1
LinkVehicleToInterior(garage_car[playerid][0], 19);
SetVehicleVirtualWorld(garage_car[playerid][0], house+100);
//----------------------
SpawnCarTwo(playerid, 441.7249,468.3962,1002.6600,360.0000); // Load car #2
LinkVehicleToInterior(garage_car[playerid][1], 19);
SetVehicleVirtualWorld(garage_car[playerid][1], house+100);
//----------------------
SpawnCarThree(playerid, 447.4809,468.1860,1002.6586,358.1951); // Load car #3
LinkVehicleToInterior(garage_car[playerid][2], 19);
SetVehicleVirtualWorld(garage_car[playerid][2], house+100);
}
case 4: // house A Class
{
SpawnCarOne(playerid, 893.5298,31.7400,1004.1795,333.8575); // Load car #1
LinkVehicleToInterior(garage_car[playerid][0], 19);
SetVehicleVirtualWorld(garage_car[playerid][0], house+100);
//----------------------
SpawnCarTwo(playerid, 897.6765,31.8136,1004.1783,0.9835); // Load car #2
LinkVehicleToInterior(garage_car[playerid][1], 19);
SetVehicleVirtualWorld(garage_car[playerid][1], house+100);
//----------------------
SpawnCarThree(playerid, 902.9612,31.9576,1004.1783,1.5516); // Load car #3
LinkVehicleToInterior(garage_car[playerid][2], 19);
SetVehicleVirtualWorld(garage_car[playerid][2], house+100);
//----------------------
SpawnCarFour(playerid, 907.1154,32.3961,1004.1783,30.6716); // Load car #4
LinkVehicleToInterior(garage_car[playerid][3], 19);
SetVehicleVirtualWorld(garage_car[playerid][3], house+100);
}
case 5: // house S Class
{
SpawnCarOne(playerid, 511.2867,505.0032,1002.3588,47.6021); // Load car #1
LinkVehicleToInterior(garage_car[playerid][0], 19);
SetVehicleVirtualWorld(garage_car[playerid][0], house+100);
//----------------------
SpawnCarTwo(playerid, 504.8487,503.1697,1002.3583,90.2742); // Load car #3
LinkVehicleToInterior(garage_car[playerid][1], 19);
SetVehicleVirtualWorld(garage_car[playerid][1], house+100);
//----------------------
SpawnCarThree(playerid, 504.5507,512.3398,1002.3583,91.0430); // Load car #4
LinkVehicleToInterior(garage_car[playerid][2], 19);
SetVehicleVirtualWorld(garage_car[playerid][2], house+100);
//----------------------
SpawnCarFour(playerid, 504.7199,521.3282,1002.3588,90.3364); // Load car #5
LinkVehicleToInterior(garage_car[playerid][3], 19);
SetVehicleVirtualWorld(garage_car[playerid][3], house+100);
//----------------------
SpawnCarFive(playerid, 511.4334,518.2543,1002.3597,126.6747); // Load car #2
LinkVehicleToInterior(garage_car[playerid][4], 19);
SetVehicleVirtualWorld(garage_car[playerid][4], house+100);
}
}
// SetPVarInt(playerid,"chosencar",0);
}
}

[DmitriyVasilev]

18:14:02] [join] El_Capone has joined the server (0:127.0.0.1)
[18:14:17]



[18:14:17] CarInfo[0][carModel][0] = 462
[18:14:17]



[18:14:17] [Загрузка ...] Автомобили игрока El_Capone были загружены: 462, 462, 462, 462, 462
[18:16:07] Игрок El_Capone купил дом 421
[18:16:07]



[18:16:07] CarInfo[0][carModel][0] = 462
[18:16:07]



[18:16:07] [Загрузка ...] Автомобили игрока El_Capone были загружены: 462, 462, 462, 462, 462
[18:17:05] Игрок El_Capone купил автомобиль [ID: 581]
[18:17:15] Игрок El_Capone купил автомобиль [ID: 412]
[18:19:38] Файл-Аккаунт El_Capone успешно сохранён
[18:19:38] [part] El_Capone has left the server (0:1)
[18:19:38]

UPDATE `cars` SET `model`= '581',`color_one`= '5',`color_two`= '3',`percent`= '100',`fuel`= '196.000000',`vehcom_1`= '0',`vehcom_2`= '0',`vehcom_3`= '0',`vehcom_4`= '0',`vehcom_5`= '0',`vehcom_6`= '0',`vehcom_7`= '0',`vehcom_8`= '0',`vehcom_9`= '0',`vehcom_10`= '0',`vehcom_11`= '0',`vehcom_12`= '0',`vehcom_13`= '0',`vehcom_14`= '0' WHERE id = '0' AND owner = 'El_Capone'


[18:19:38] [Сохранение] Автомобили El_Capone | 581,412,462,462,462 сохранены
[18:20:11] Incoming connection: 127.0.0.1:62390
[18:20:11] [join] El_Capone has joined the server (0:127.0.0.1)
[18:20:19]



[18:20:19] CarInfo[0][carModel][0] = 462
[18:20:19]



[18:20:19] [Загрузка ...] Автомобили игрока El_Capone были загружены: 462, 412, 462, 462, 462
[18:20:51] Файл-Аккаунт El_Capone успешно сохранён
[18:20:51] [part] El_Capone has left the server (0:1)
[18:20:51]

UPDATE `cars` SET `model`= '462',`color_one`= '1',`color_two`= '1',`percent`= '0',`fuel`= '100.000000',`vehcom_1`= '0',`vehcom_2`= '0',`vehcom_3`= '0',`vehcom_4`= '0',`vehcom_5`= '0',`vehcom_6`= '0',`vehcom_7`= '0',`vehcom_8`= '0',`vehcom_9`= '0',`vehcom_10`= '0',`vehcom_11`= '0',`vehcom_12`= '0',`vehcom_13`= '0',`vehcom_14`= '0' WHERE id = '0' AND owner = 'El_Capone'


[18:20:51] [Сохранение] Автомобили El_Capone | 462,412,462,462,462 сохранены

[DeimoS]

Попробуй так:
case 37:
{
if(!r)
{
return print(!"[Error] Информация о машинах игрока в бд не найдена");
}
for(x = 0; x < r; x++)
{
QUERY = "UPDATE `"TABLE_CARS"` SET ";
format(QUERY,sizeof(QUERY),"%s`model`= '%i',", QUERY, CarInfo[playerid][carModel][x]);
format(QUERY,sizeof(QUERY),"%s`color_one`= '%i',", QUERY, CarInfo[playerid][carColor_one][x]);
format(QUERY,sizeof(QUERY),"%s`color_two`= '%i',", QUERY, CarInfo[playerid][carColor_two][x]);
format(QUERY,sizeof(QUERY),"%s`percent`= '%i',", QUERY, CarInfo[playerid][carPercent][x]);
format(QUERY,sizeof(QUERY),"%s`fuel`= '%f',", QUERY, CarInfo[playerid][carFuel][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_1`= '%i',", QUERY, CarInfo[playerid][carVehcom_1][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_2`= '%i',", QUERY, CarInfo[playerid][carVehcom_2][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_3`= '%i',", QUERY, CarInfo[playerid][carVehcom_3][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_4`= '%i',", QUERY, CarInfo[playerid][carVehcom_4][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_5`= '%i',", QUERY, CarInfo[playerid][carVehcom_5][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_6`= '%i',", QUERY, CarInfo[playerid][carVehcom_6][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_7`= '%i',", QUERY, CarInfo[playerid][carVehcom_7][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_8`= '%i',", QUERY, CarInfo[playerid][carVehcom_8][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_9`= '%i',", QUERY, CarInfo[playerid][carVehcom_9][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_10`= '%i',", QUERY, CarInfo[playerid][carVehcom_10][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_11`= '%i',", QUERY, CarInfo[playerid][carVehcom_11][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_12`= '%i',", QUERY, CarInfo[playerid][carVehcom_12][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_13`= '%i',", QUERY, CarInfo[playerid][carVehcom_13][x]);
format(QUERY,sizeof(QUERY),"%s`vehcom_14`= '%i'", QUERY, CarInfo[playerid][carVehcom_14][x]);
format(QUERY,sizeof(QUERY),"%s WHERE id = '%i' AND owner = '%s'", QUERY, CarInfo[playerid][carID][x], User[playerid][pName]);
mysql_function_query(DATABASE, QUERY, true, "", "");
printf("\n\n%s\n\n", QUERY);
}
printf("[Сохранение] Автомобили %s | %i,%i,%i,%i,%i сохранены", User[playerid][pName],CarInfo[playerid][carModel][0],CarInfo[playerid][carModel][1],CarInfo[playerid][carModel][2],CarInfo[playerid][carModel][3],CarInfo[playerid][carModel][4]);
}
}

[DmitriyVasilev]

все так же слетают:(:sorry:

[DeimoS]

Ну тебе нужно переписывать систему сохранения и систему загрузки. Сейчас у тебя просто не срабатывают запросы с загрузкой, так как ты, как минимум, неправильно определяешь ID авто.

[DmitriyVasilev]

А как правильно определять его ид?
Вообще все нормально если просто перезаходить на сервер, а если сервер перезапустить и зайти то слетают.:sorry:

[DeimoS]

По разному можно. Всё зависит от общей реализации системы. Это в двух словах не объяснить.

[DmitriyVasilev]

UPD: printf выводил не все данные, так как в бд не та таблица была, вот теперь показывает. может здесь что-то не так?
[17:27:36] Игрок El_Capone купил дом 8
[17:27:37]



[17:27:37] CarInfo[0][carModel][0] = 462
[17:27:37] CarInfo[0][carModel][1] = 462
[17:27:37] CarInfo[0][carModel][2] = 462
[17:27:37] CarInfo[0][carModel][3] = 462
[17:27:37] CarInfo[0][carModel][4] = 462
[17:27:37]



[17:27:37] [Загрузка ...] Автомобили игрока El_Capone были загружены: 462, 462, 462, 462, 462
[17:29:08] Игрок El_Capone купил автомобиль [ID: 586]
[17:29:17] Игрок El_Capone купил автомобиль [ID: 576]
[17:29:26] Игрок El_Capone купил автомобиль [ID: 445]

[17:30:24] Файл-Аккаунт El_Capone успешно сохранён
[17:30:24] [part] El_Capone has left the server (0:1)
[17:30:24]

UPDATE `cars` SET `model`= '586',`color_one`= '6',`color_two`= '0',`percent`= '100',`fuel`= '200.000000',`vehcom_1`= '0',`vehcom_2`= '0',`vehcom_3`= '0',`vehcom_4`= '0',`vehcom_5`= '0',`vehcom_6`= '0',`vehcom_7`= '0',`vehcom_8`= '0',`vehcom_9`= '0',`vehcom_10`= '0',`vehcom_11`= '0',`vehcom_12`= '0',`vehcom_13`= '0',`vehcom_14`= '0' WHERE id = '418' AND owner = 'El_Capone'


[17:30:24]

UPDATE `cars` SET `model`= '576',`color_one`= '2',`color_two`= '5',`percent`= '95',`fuel`= '200.000000',`vehcom_1`= '0',`vehcom_2`= '0',`vehcom_3`= '0',`vehcom_4`= '0',`vehcom_5`= '0',`vehcom_6`= '0',`vehcom_7`= '0',`vehcom_8`= '0',`vehcom_9`= '0',`vehcom_10`= '0',`vehcom_11`= '0',`vehcom_12`= '0',`vehcom_13`= '0',`vehcom_14`= '0' WHERE id = '419' AND owner = 'El_Capone'


[17:30:24]

UPDATE `cars` SET `model`= '445',`color_one`= '2',`color_two`= '6',`percent`= '100',`fuel`= '200.000000',`vehcom_1`= '0',`vehcom_2`= '0',`vehcom_3`= '0',`vehcom_4`= '0',`vehcom_5`= '0',`vehcom_6`= '0',`vehcom_7`= '0',`vehcom_8`= '0',`vehcom_9`= '0',`vehcom_10`= '0',`vehcom_11`= '0',`vehcom_12`= '0',`vehcom_13`= '0',`vehcom_14`= '0' WHERE id = '3' AND owner = 'El_Capone'


[17:30:24]

UPDATE `cars` SET `model`= '462',`color_one`= '1',`color_two`= '1',`percent`= '0',`fuel`= '100.000000',`vehcom_1`= '0',`vehcom_2`= '0',`vehcom_3`= '0',`vehcom_4`= '0',`vehcom_5`= '0',`vehcom_6`= '0',`vehcom_7`= '0',`vehcom_8`= '0',`vehcom_9`= '0',`vehcom_10`= '0',`vehcom_11`= '0',`vehcom_12`= '0',`vehcom_13`= '0',`vehcom_14`= '0' WHERE id = '4' AND owner = 'El_Capone'


[17:30:24]

UPDATE `cars` SET `model`= '462',`color_one`= '1',`color_two`= '1',`percent`= '0',`fuel`= '100.000000',`vehcom_1`= '0',`vehcom_2`= '0',`vehcom_3`= '0',`vehcom_4`= '0',`vehcom_5`= '0',`vehcom_6`= '0',`vehcom_7`= '0',`vehcom_8`= '0',`vehcom_9`= '0',`vehcom_10`= '0',`vehcom_11`= '0',`vehcom_12`= '0',`vehcom_13`= '0',`vehcom_14`= '0' WHERE id = '143' AND owner = 'El_Capone'


[17:30:24] [Сохранение] Автомобили El_Capone | 586,576,445,462,462 сохранены

[DeimoS]

Ну смотри. Если после покупки и выхода с сервера данные в таблице будут записаны верные, но после входа на сервер автомобилей не будет, то проблема с загрузкой. А если после выхода данные будут неверные, то проблема с сохранением.

[DmitriyVasilev]

тут получается сохранение нормально идет, но загрузка...
UPD. зашел после этого же сохранения: В БАЗУ ДАННЫХ

[17:30:24] Файл-Аккаунт El_Capone успешно сохранён
[17:30:24] [part] El_Capone has left the server (0:1)
[17:30:24]

UPDATE `cars` SET `model`= '586',`color_one`= '6',`color_two`= '0',`percent`= '100',`fuel`= '200.000000',`vehcom_1`= '0',`vehcom_2`= '0',`vehcom_3`= '0',`vehcom_4`= '0',`vehcom_5`= '0',`vehcom_6`= '0',`vehcom_7`= '0',`vehcom_8`= '0',`vehcom_9`= '0',`vehcom_10`= '0',`vehcom_11`= '0',`vehcom_12`= '0',`vehcom_13`= '0',`vehcom_14`= '0' WHERE id = '418' AND owner = 'El_Capone'


[17:30:24]

UPDATE `cars` SET `model`= '576',`color_one`= '2',`color_two`= '5',`percent`= '95',`fuel`= '200.000000',`vehcom_1`= '0',`vehcom_2`= '0',`vehcom_3`= '0',`vehcom_4`= '0',`vehcom_5`= '0',`vehcom_6`= '0',`vehcom_7`= '0',`vehcom_8`= '0',`vehcom_9`= '0',`vehcom_10`= '0',`vehcom_11`= '0',`vehcom_12`= '0',`vehcom_13`= '0',`vehcom_14`= '0' WHERE id = '419' AND owner = 'El_Capone'


[17:30:24]

UPDATE `cars` SET `model`= '445',`color_one`= '2',`color_two`= '6',`percent`= '100',`fuel`= '200.000000',`vehcom_1`= '0',`vehcom_2`= '0',`vehcom_3`= '0',`vehcom_4`= '0',`vehcom_5`= '0',`vehcom_6`= '0',`vehcom_7`= '0',`vehcom_8`= '0',`vehcom_9`= '0',`vehcom_10`= '0',`vehcom_11`= '0',`vehcom_12`= '0',`vehcom_13`= '0',`vehcom_14`= '0' WHERE id = '3' AND owner = 'El_Capone'


[17:30:24]

UPDATE `cars` SET `model`= '462',`color_one`= '1',`color_two`= '1',`percent`= '0',`fuel`= '100.000000',`vehcom_1`= '0',`vehcom_2`= '0',`vehcom_3`= '0',`vehcom_4`= '0',`vehcom_5`= '0',`vehcom_6`= '0',`vehcom_7`= '0',`vehcom_8`= '0',`vehcom_9`= '0',`vehcom_10`= '0',`vehcom_11`= '0',`vehcom_12`= '0',`vehcom_13`= '0',`vehcom_14`= '0' WHERE id = '4' AND owner = 'El_Capone'


[17:30:24]

UPDATE `cars` SET `model`= '462',`color_one`= '1',`color_two`= '1',`percent`= '0',`fuel`= '100.000000',`vehcom_1`= '0',`vehcom_2`= '0',`vehcom_3`= '0',`vehcom_4`= '0',`vehcom_5`= '0',`vehcom_6`= '0',`vehcom_7`= '0',`vehcom_8`= '0',`vehcom_9`= '0',`vehcom_10`= '0',`vehcom_11`= '0',`vehcom_12`= '0',`vehcom_13`= '0',`vehcom_14`= '0' WHERE id = '143' AND owner = 'El_Capone'


[17:30:24] [Сохранение] Автомобили El_Capone | 586,576,445,462,462 сохранены

И вот что увидел.
http://images.vfl.ru/ii/1553840397/99c5bf4c/25966427.png
сохраняется почему то только 3 ид а всем остальным снова сбивает до мопеда

[DeimoS]

Я же тебе уже выше писал причину - в коде проблемы с определением ID автомобилей.

У тебя поле "id" - AUTO_INCREMENT, а запрос на сохранение будет всегда передавать с 0 по 4 ID:

format(temp,sizeof(temp),"WHERE id = '%i' AND owner = '%s'",x,User[playerid][pName])
От этого и все проблемы. Ты в логах уже ничего не увидишь. Тут нужно переписывать систему загрузки/сохранения, а не какую-то одну единственную строку исправлять.

[DmitriyVasilev]

Хмм, вроде сохраняет машины теперь, просто изменил в таблице AUTO_INCREMENT на NOT NULL.

[DeimoS]

Ну а теперь создай ещё один аккаунт и посмотри что будет =\
Спойлер: ты только всё сломал. И в таблице обязательно должно быть поле со столбцом AUTO_INCREMENT.

[DmitriyVasilev]

а лол ты прав, у меня все авто приравнялись к 0
в стол заказов ток идти если не знаю ккак?