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

[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]

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

[DeimoS]

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