Не загружаются данные о транспорте семьи из базы данных

Nikita_Rellex · 13 Апр 2022

У меня подключается семейный транспорт к базе данных. То есть даже в консоли не показывает подключился или нет.
Вот код и он не подключается к базе. Не могу понять почему. В базе данных я только учусь и немного в ней понимаю. Но не совсем. Помогите пожалуйста.

PHP:

}
publics: OnLoadFamilyCarData(family_id, type)
{
    new
        time = GetTickCount(),
        RESPAWN_CAR_TIME = -1,
        rows;
    cache_get_row_count(rows);
    //if (!rows) return print(!"[Загрузка ...] Данные из Vehicle Family не получены!");
    if (!rows) {
        new
            query_[156];
        mysql_format(dbHandle, query_, sizeof query_, "INSERT INTO `s_vehicle_family` (`vFamily`, `vRank`) VALUES ('%d','1'),('%d','1'),('%d','1'),('%d','1'),('%d','1')",
            FamilyInfo[  family_id - 1 ][fID], FamilyInfo[  family_id - 1 ][fID], FamilyInfo[  family_id - 1 ][fID], FamilyInfo[  family_id - 1 ][fID], FamilyInfo[  family_id - 1 ][fID]
        );
        mysql_tquery(dbHandle, query_), query_[0] = EOS;

        mysql_format(dbHandle, query_, sizeof query_, "SELECT * FROM `s_vehicle_family` WHERE `vFamily` = '%d' LIMIT 5", FamilyInfo[  family_id - 1 ][fID]);
        mysql_tquery(dbHandle, query_, "OnLoadFamilyCarData", "ii", family_id, 1), query_[0] = EOS;
        //return print(!"[Загрузка ...] Данные из Vehicle Family не получены!");
    }
    for(new i = 0, colors_mass[10], position_mass[128]; i < rows ; i++)
    {
        new V_IDX = GetVehicleID();
        VehicleInfo[ V_IDX - 1 ] [vType] = VEHICLE_TYPE_FAMILY;

        cache_get_value_name_int(i, "vID", VehicleInfo[ V_IDX - 1 ][vID]);//++
        cache_get_value_name_int(i, "vModel", VehicleInfo[ V_IDX - 1 ][vModel]); //++
        cache_get_value_name_int(i, "vFamily", VehicleInfo[ V_IDX - 1 ][vFraction]);//
        cache_get_value_name_int(i, "vRank", VehicleInfo[ V_IDX - 1 ][vRank]);//++
        cache_get_value_name(i, "vPos", position_mass, 128);//++
        sscanf(position_mass,"p<|>a<f>[4]", VehicleInfo[ V_IDX - 1 ][vPos]);//
//
        cache_get_value_name(i, "vColor", colors_mass, 10);//++
        sscanf(colors_mass, "p<,>a<d>[2]", VehicleInfo[ V_IDX - 1 ][vColor]);//
//
        cache_get_value_name(i, "vPT_Engine", position_mass, 16);//++
        sscanf(position_mass, "p<|>ddddd", VehicleInfo[ V_IDX - 1 ][vPT_Engine][0], VehicleInfo[ V_IDX - 1 ][vPT_Engine][1],//
        VehicleInfo[ V_IDX - 1][vPT_Engine][2], VehicleInfo[ V_IDX - 1 ][vPT_Engine][3], VehicleInfo[ V_IDX - 1 ][vPT_Engine][4]);//
//
        cache_get_value_name(i, "vPT_Brake", position_mass, 16);//++
        sscanf(position_mass, "p<|>ddddd", VehicleInfo[ V_IDX - 1 ][vPT_Brake][0], VehicleInfo[ V_IDX - 1 ][vPT_Brake][1],//
        VehicleInfo[ V_IDX - 1 ][vPT_Brake][2], VehicleInfo[ V_IDX - 1 ][vPT_Brake][3], VehicleInfo[ V_IDX - 1 ][vPT_Brake][4]);//
//
        cache_get_value_name(i, "vComponent", position_mass, 126);//++
        sscanf ( position_mass, "p<|>dddddddddd", VehicleInfo[ V_IDX - 1 ][vComponent][0], VehicleInfo[ V_IDX - 1 ][vComponent][1],//
        VehicleInfo[ V_IDX - 1 ][vComponent][2], VehicleInfo[ V_IDX - 1 ][vComponent][3], VehicleInfo[ V_IDX - 1 ][vComponent][4],
        VehicleInfo[ V_IDX - 1 ][vComponent][5], VehicleInfo[ V_IDX - 1 ][vComponent][6], VehicleInfo[ V_IDX - 1 ][vComponent][7],
        VehicleInfo[ V_IDX - 1 ][vComponent][8], VehicleInfo[ V_IDX - 1 ][vComponent][9]);

        cache_get_value_name_int(i, "vInt", VehicleInfo[ V_IDX - 1 ][vInt]);//++
        cache_get_value_name_int(i, "vWorld", VehicleInfo[ V_IDX - 1 ][vWorld]); //++
        cache_get_value_name(i, "vNumber", VehicleInfo[ V_IDX - 1 ][vNumber], 12);//++
        cache_get_value_name_float(i, "vFuel", VehicleInfo[ V_IDX - 1 ][vFuel]);//++
        if (VehicleInfo[ V_IDX - 1 ][vFuel] > GetModelMaxFuel(VehicleInfo[ V_IDX - 1 ][vModel])) {
            VehicleInfo[ V_IDX - 1 ][vFuel] = GetModelMaxFuel(VehicleInfo[ V_IDX - 1 ][vModel]);
        }
        cache_get_value_name_float(i, "vMillage", VehicleInfo[ V_IDX - 1 ][vMillage]);//++
        VehicleInfo[ V_IDX - 1 ][vSubFraction] = 0;
        VehicleInfo[ V_IDX - 1 ][vJacker] = 0;
        VehicleInfo[ V_IDX - 1 ][vJackerOff] = false;
        cache_get_value_name_int(i, "vRepair", VehicleInfo[ V_IDX - 1 ][vRepair]);//++
        cache_get_value_name_int(i, "vFillBag", VehicleInfo[ V_IDX - 1 ][vFillBag]);//++
        cache_get_value_name_int(i, "vMoney", VehicleInfo[ V_IDX - 1 ][vMoney]);//++
        cache_get_value_name_int(i, "vDrugs", VehicleInfo[ V_IDX - 1 ][vDrugs]);//++
        cache_get_value_name_int(i, "vMaterials", VehicleInfo[ V_IDX - 1 ][vMaterials]);//++
       
        new
            bootg_mass[32],
            boota_mass[32];
           
        cache_get_value_name(i, "vGun", bootg_mass, 32);
        sscanf(bootg_mass, "p<,>a<d>[6]", VehicleInfo[ V_IDX - 1 ][vBootGun]);
        cache_get_value_name(i, "vAmmo", boota_mass, 32);
        sscanf(boota_mass, "p<,>a<d>[6]", VehicleInfo[ V_IDX - 1 ][vBootAmmo]);
         
        VehicleInfo[ V_IDX - 1 ][vLocked] = false;
        if (type == 1) {
            VehicleInfo[ V_IDX - 1 ][vVehicle] = _CreateVehicle(VehicleInfo[ V_IDX - 1 ][vModel],
                VehicleInfo[ V_IDX - 1 ][vPos][0], VehicleInfo[ V_IDX - 1 ][vPos][1],
                VehicleInfo[ V_IDX - 1 ][vPos][2], VehicleInfo[ V_IDX - 1 ][vPos][3],
                VehicleInfo[ V_IDX - 1 ][vColor][0], VehicleInfo[ V_IDX - 1 ][vColor][1], RESPAWN_CAR_TIME, 0
            );
        }
        else if (type == 2) {
            VehicleInfo[ V_IDX - 1 ][vPos][0] = HouseInfo[ FamilyInfo[ family_id - 1 ][fDefHouse] ][hCar][0];
            VehicleInfo[ V_IDX - 1 ][vPos][1] = HouseInfo[ FamilyInfo[ family_id - 1 ][fDefHouse] ][hCar][1];
            VehicleInfo[ V_IDX - 1 ][vPos][2] = HouseInfo[ FamilyInfo[ family_id - 1 ][fDefHouse] ][hCar][2];
            VehicleInfo[ V_IDX - 1 ][vPos][3] = HouseInfo[ FamilyInfo[ family_id - 1 ][fDefHouse] ][hCar][3];
            VehicleInfo[ V_IDX - 1 ][vVehicle] = _CreateVehicle(VehicleInfo[ V_IDX - 1 ][vModel],
                HouseInfo[ FamilyInfo[ family_id - 1 ][fDefHouse] ][hCar][0],
                HouseInfo[ FamilyInfo[ family_id - 1 ][fDefHouse] ][hCar][1],
                HouseInfo[ FamilyInfo[ family_id - 1 ][fDefHouse] ][hCar][2],
                HouseInfo[ FamilyInfo[ family_id - 1 ][fDefHouse] ][hCar][3],
                VehicleInfo[ V_IDX - 1 ][vColor][0], VehicleInfo[ V_IDX - 1 ][vColor][1], -1
            );
        }
        _SetVehicleHealth(VehicleInfo[ V_IDX - 1 ][vVehicle], vehicleCountArmour[ VehicleInfo[ V_IDX - 1 ][vPT_Engine][1] ]);


        LinkVehicleToInterior(VehicleInfo[ V_IDX - 1 ][vVehicle], VehicleInfo[ V_IDX - 1 ][vInt]);
        SetVehicleVirtualWorld(VehicleInfo[ V_IDX - 1 ][vVehicle], VehicleInfo[ V_IDX - 1 ][vWorld]);
        SetVehicleNumberPlate(VehicleInfo[ V_IDX - 1 ][vVehicle], VehicleInfo[ V_IDX - 1 ][vNumber]);

        Iter_Add(FamilyListVehicle[family_id], V_IDX);
        printf("LOAD VEH FAMILY: ID: %d vRank: %d vModel %d", V_IDX, VehicleInfo[ V_IDX - 1 ][vRank], VehicleInfo[ V_IDX - 1 ][vModel]);
       
    }
    printf("[Загрузка ...] Данные из s_vehicle_family получены! (%d шт.) Время: %d", rows, GetTickCount() - time);
    return 1;

Не загружаются данные о транспорте семьи из базы данных

Nikita_Rellex

Умник