Ошибка с загрузкой домов с базы данных.

UltimatePROfull · 23 Янв 2024

Доброе время суток форумчане P-I!
Проблема с сохранением домов с Б.Д.
Вообщем когда покупаешь дом и перезапускаешь сервер все слетает
В б.д. смотрел ничего не изменяется при покупке.
Логи:

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

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

[00:53:07]
[00:53:07] Server Plugins
[00:53:07] --------------
[00:53:07] Loading plugin: crashdetect
[00:53:07] CrashDetect v4.15.1 is OK.
[00:53:07] Loaded.
[00:53:07] Loading plugin: mysql
[00:53:08] >> plugin.mysql: R39-6 successfully loaded.
[00:53:08] Loaded.
[00:53:08] Loading plugin: pawncmd
[00:53:08] Pawn.CMD plugin v3.2.0 by urShadow has been loaded
[00:53:08] Loaded.
[00:53:08] Loading plugin: pawnraknet
[00:53:08] [Pawn.RakNet]

| Pawn.RakNet 1.4.1 | 2016 - 2020
|--------------------------------
| Author and maintainer: urShadow

| Compiled: Jun 18 2020 at 14:19:11

[00:53:08] Loaded.
[00:53:08] Loading plugin: sscanf
[00:53:08]

[00:53:08] ===============================

[00:53:08] sscanf plugin loaded.

[00:53:08] Version: 2.8.3

[00:53:08] (c) 2018 Alex "Y_Less" Cole

[00:53:08] ===============================

[00:53:08] Loaded.
[00:53:08] Loading plugin: streamer
[00:53:08]

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

[00:53:08] Loaded.
[00:53:08] Loading plugin: TOTP
[00:53:08] TOTP plugin v1.0.1 by Games loaded.
[00:53:08] Loaded.
[00:53:08] Loaded 7 plugins.

[00:53:08]
[00:53:08] Filterscripts
[00:53:08] ---------------
[00:53:08] Loading filterscript 'lift.amx'...
[00:53:09] Loaded 1 filterscripts.

[00:53:10]
[00:53:10] --------------------------------------
[00:53:10] Античит Nex-AC загружен!
[00:53:10] Версия античита: 1.9.51
[00:53:10] Автор: Nexius
[00:53:10] --------------------------------------

[00:53:10] Подключение к базе данных удалось
[00:53:10] [Server Log] OnGameModeInit Успешно загружен
[00:53:10] | Загружено исторей наказаний: 3 |
[00:53:10] [Server Log][Семейных квартир загружено: 10][Потраченое время на загрузку семейных квартир: 33]
[00:53:11] [Server Log] Загружено актеров: 1000
[00:53:11] [MySQL]: Настройки анти-чита успешно загружены (загружено: 53). Потрачено: 0мс.
[00:53:12] [Server Log] Всего было загружено antizz: 44
[00:53:12] ===========================================
[00:53:12] | Slivshik Moda - |
[00:53:12] | Pawn Coder - Maksim Rotar |
[00:53:12] | (ссылка на вк скрыта) |
[00:53:12] ===========================================
[00:53:12] [Server Log] Загружено домов: 0851
[00:53:12] [Server Log] Загружено бизнесов: 0149
[00:53:12] [Server Log] Загружено транспорта: 0027
[00:53:12] [Server Log] Создано объектов: 44056
[00:53:12] [Server Log] Создано гангзон: 0130
[00:53:12] [Server Log] Создано иконки: 1077
[00:53:12] [Server Log] Создано 3D текстов: 2907
[00:53:12] Number of vehicle models: 114
[00:53:13] [Server Log][Загружено семей]: <3>. Потрачено: <1 ms>.
[00:53:56] [connection] 127.0.0.1:58230 requests connection cookie.
[00:53:57] [connection] incoming connection: 127.0.0.1:58230 id: 0
[00:53:57] [join] Ruslan_Limonchyk has joined the server (0:127.0.0.1)
[00:54:47] [part] Ruslan_Limonchyk has left the server (0:1)
[00:54:47] [debug] Run time error 4: "Array index out of bounds"
[00:54:47] [debug] Accessing element at index 4095 past array upper bound 12
[00:54:47] [debug] AMX backtrace:
[00:54:47] [debug] #0 004246a4 in public SecondTimer () at C:\Users\LK\Desktop\Arizona Unite\gamemodes\arizona.pwn:58988

[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('11') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('12') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('12') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('13') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('13') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('14') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('14') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('15') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('15') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('16') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('16') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('17') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('17') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('18') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('18') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('19') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('19') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('20') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('20') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('21') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('21') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('22') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('22') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('23') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('23') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('24') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('24') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('25') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('25') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('26') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype
[01:37:01 01/23/24] [WARNING] CMySQLResult::GetRowData - invalid row ('26') or field index ('66') (Query: "SELECT * FROM `ownable`")
[01:37:01 01/23/24] [ERROR] cache_get_row_int - invalid datatype

Код сохранения в базу данных

C++:

stock SaveHouse(houseid)
{
    new string[1200], str[256];
    format(str, sizeof(str), "UPDATE `houses` SET");
    strcat(string, str);
    format(str, sizeof(str), "`Enter_X` = '%.4f',`Enter_Y` = '%.4f',`Enter_Z` = '%.4f', ",
        HouseInfo[houseid][hEnter_X],
        HouseInfo[houseid][hEnter_Y],
        HouseInfo[houseid][hEnter_Z]);
    strcat(string, str);

    format(str, sizeof(str), "`Exit_X` = '%.4f', `Exit_Y` = '%.4f', `Exit_Z` = '%.4f', ",
         HouseInfo[houseid][hExit_X],
        HouseInfo[houseid][hExit_Y],
        HouseInfo[houseid][hExit_Z]);
    strcat(string, str);

    format(str, sizeof(str), "`Owner` = '%s', `Room_Owner_0` = '%s',`Room_Owner_1` = '%s', ",
        HouseInfo[houseid][hOwner],
        HRoomOwner[houseid][0],
        HRoomOwner[houseid][1]);
    strcat(string, str);

    format(str, sizeof(str), "`Room_Owner_2` = '%s', `Room_Owner_3` = '%s', `Room_Owner_4` = '%s', ",
        HRoomOwner[houseid][2],
        HRoomOwner[houseid][3],
        HRoomOwner[houseid][4]);
    strcat(string, str);

    format(str, sizeof(str), "`Level` = '%d', `Cost` = '%d', `Lock` = '%d', `Rent` = '%d', ",
        HouseInfo[houseid][hLevel],
        HouseInfo[houseid][hCost],
        HouseInfo[houseid][hLock],
        HouseInfo[houseid][hRent]);
    strcat(string, str);

    format(str, sizeof(str), "`Interior` = '%d', `Money` = '%d', `Drugs` = '%d', `Mats` = '%d', ",
        HouseInfo[houseid][hInt],
        HouseInfo[houseid][hMoney],
        HouseInfo[houseid][hDrugs],
        HouseInfo[houseid][hMats]);
    strcat(string, str);

    format(str, sizeof(str), "`Bar` = '%d', `Podval` = '%d', `Skin_1` = '%d', `Skin_2` = '%d', ",
        HouseInfo[houseid][hBar],
        HouseInfo[houseid][hPodval],
        HouseInfo[houseid][hSkin][0],
        HouseInfo[houseid][hSkin][1]);
    strcat(string, str);

    format(str, sizeof(str), "`Skin_3` = '%d', `Skin_4` = '%d', `Skin_5` = '%d', `NoOwner` = '%d', `Nalog` = '%d', `Klass` = '%d', `Med` = '%d', ",
        HouseInfo[houseid][hSkin][2],
        HouseInfo[houseid][hSkin][3],
        HouseInfo[houseid][hSkin][4],
        HouseInfo[houseid][hNoOwner],
        HouseInfo[houseid][hNalog],
        HouseInfo[houseid][hKlass],
        HouseInfo[houseid][hMed]);
    strcat(string, str);

    format(str, sizeof(str), "`Garage`='%i', `Garage_X`='%.4f', `Garage_Y`='%.4f', `Garage_Z`='%.4f' WHERE `ID` = '%i'",
        HouseInfo[houseid][hGarage],
        HouseInfo[houseid][hGarage_X],
        HouseInfo[houseid][hGarage_Y],
        HouseInfo[houseid][hGarage_Z],
        HouseInfo[houseid][hOpis],
        houseid);
    strcat(string, str);
    mysql_query(mysql, string, false);
    return 1;
}

На всякий случай код загрузки с б.д.

C++:

stock LoadHouses()
{
    for(new i = -1; ++i < MAX_HOUSES;) SetString(HouseInfo[i][hOwner], "The State");
    new Cache:result = mysql_query(mysql, "SELECT * FROM `houses`");
    OWNABLEHOUSES = cache_get_row_count(mysql);
    for (new i = -1; ++i < OWNABLEHOUSES;)
    {
        HouseInfo[i+1][hID] = cache_get_row_int(i, 0, mysql);
        HouseInfo[i+1][hEnter_X] = cache_get_row_float(i, 1, mysql);
        HouseInfo[i+1][hEnter_Y] = cache_get_row_float(i, 2, mysql);
        HouseInfo[i+1][hEnter_Z] = cache_get_row_float(i, 3, mysql);
        HouseInfo[i+1][hExit_X] = cache_get_row_float(i, 4, mysql);
        HouseInfo[i+1][hExit_Y] = cache_get_row_float(i, 5, mysql);
        HouseInfo[i+1][hExit_Z] = cache_get_row_float(i, 6, mysql);
        cache_get_row(i, 7, HouseInfo[i+1][hOwner], mysql, 24);
        cache_get_row(i, 8, HRoomOwner[i+1][0], mysql, 24);
        cache_get_row(i, 9, HRoomOwner[i+1][1], mysql, 24);
        cache_get_row(i, 10, HRoomOwner[i+1][2], mysql, 24);
        cache_get_row(i, 11, HRoomOwner[i+1][3], mysql, 24);
        cache_get_row(i, 12, HRoomOwner[i+1][4], mysql, 24);
        HouseInfo[i+1][hLevel] = cache_get_row_int(i, 13, mysql);
        HouseInfo[i+1][hCost] = cache_get_row_int(i, 14, mysql);
        HouseInfo[i+1][hLock] = cache_get_row_int(i, 15, mysql);
        HouseInfo[i+1][hRent] = cache_get_row_int(i, 16, mysql);
        HouseInfo[i+1][hInt] = cache_get_row_int(i, 17, mysql);
        HouseInfo[i+1][hMoney] = cache_get_row_int(i, 18, mysql);
        HouseInfo[i+1][hDrugs] = cache_get_row_int(i, 19, mysql);
        HouseInfo[i+1][hMats] = cache_get_row_int(i, 20, mysql);
        HouseInfo[i+1][hBar] = cache_get_row_int(i, 21, mysql);
        HouseInfo[i+1][hPodval] = cache_get_row_int(i, 22, mysql);
        HouseInfo[i+1][hSkin][0] = cache_get_row_int(i, 23, mysql);
        HouseInfo[i+1][hSkin][1] = cache_get_row_int(i, 24, mysql);
        HouseInfo[i+1][hSkin][2] = cache_get_row_int(i, 25, mysql);
        HouseInfo[i+1][hSkin][3] = cache_get_row_int(i, 26, mysql);
        HouseInfo[i+1][hSkin][4] = cache_get_row_int(i, 27, mysql);
        HouseInfo[i+1][hNoOwner] = cache_get_row_int(i, 28, mysql);
        HouseInfo[i+1][hNalog] = cache_get_row_int(i, 29, mysql);
        HouseInfo[i+1][hKlass] = cache_get_row_int(i, 30, mysql);
        HouseInfo[i+1][hMed] = cache_get_row_int(i, 31, mysql);

        HouseInfo[i+1][hGarage] = cache_get_row_int(i, 32, mysql);
        HouseInfo[i+1][hGarage_X] = cache_get_row_float(i, 33, mysql);
        HouseInfo[i+1][hGarage_Y] = cache_get_row_float(i, 34, mysql);
        HouseInfo[i+1][hGarage_Z] = cache_get_row_float(i, 35, mysql);
        cache_get_row(0, 36, HouseInfo[i+1][hOpis],mysql, 32);
    }
    cache_delete(result, mysql);
    return 1;
}

Скрины Б.д.

Чтобы видеть скрытое содержание Зарегистрируйтесь на форуме!

C домами вообще никакие действия не сохраняются.
Пробовал через админ панель сохранять пишет мол всё сохранено но после перезапуска сервера все снова слетает
C Загрузкой всё в порядке т.к. когда я прописал в б.д. себе дом то он спокойно загрузился.
Просьба найти где ошибка

Ошибка с загрузкой домов с базы данных.

UltimatePROfull

Новичок