[MYSQL] Транспорт не записывается при покупке в БД.

Риктик · 16 Июн 2022

При покупке транспорта не записывается то что игрок купил транспорт, но сам транспорт в кол-ве доступных штук в продаже уменьшается при покупке.

MYSQL.LOG

PHP:

[06/16/22 17:48:38] [WARNING] mysql_connect: no password specified
[06/16/22 17:48:46] [ERROR] error #1146 while executing query "SELECT * FROM `cshops`": Table 'kurwa.cshops' doesn't exist
[06/16/22 17:48:46] [ERROR] cache_get_value_name_int: field 'fzsklad' not found
[06/16/22 17:48:46] [ERROR] cache_get_value_name_int: field 'farmsklad' not found
[06/16/22 17:48:46] [ERROR] cache_get_value_name_int: field 'payshop' not found
[06/16/22 17:48:46] [ERROR] cache_get_value_name_int: field 'fzsalary' not found
[06/16/22 17:48:46] [ERROR] cache_get_value_name_int: field 'fracorder' not found
[06/16/22 17:48:46] [ERROR] cache_get_value_name_int: field 'fracorder' not found
[06/16/22 17:48:46] [ERROR] cache_get_value_name_int: field 'fracorder' not found
[06/16/22 17:48:46] [ERROR] cache_get_value_name_int: field 'fracorder' not found
[06/16/22 17:48:46] [ERROR] cache_get_value_name_int: field 'fracorder' not found
[06/16/22 17:48:46] [ERROR] cache_get_value_name_int: field 'fracorder' not found
[06/16/22 17:48:46] [ERROR] cache_get_value_name_int: field 'fracorder' not found
[06/16/22 17:48:46] [ERROR] cache_get_value_name_int: field 'fracorder' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'waterneed' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'bizlic' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'shopholderid' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'cshopholderid' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'lighter' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'cigarettes' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'chips' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'sprunk' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'mask' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'battery' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'lticket' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'meds' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'leftBigBoxOne' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'leftBigBoxTwo' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'leftBigBoxThree' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'leftBigBoxFour' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'leftSmallBoxOne' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'leftSmallBoxTwo' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'leftSmallBoxThree' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'leftSmallBoxFour' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'rightBigBoxOne' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'rightBigBoxTwo' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'rightBigBoxThree' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'rightBigBoxFour' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'rightSmallBoxOne' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'rightSmallBoxTwo' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'rightSmallBoxThree' not found
[06/16/22 17:49:10] [ERROR] cache_get_value_name_int: field 'rightSmallBoxFour' not found

Диалог с покупкой транспорта:

C#:

        case SELL_VEHICLE:
        {
            new string[256];
            if(!response)return RemovePlayerFromVehicle(playerid);
            if(player_info[playerid][money] < Sell_Vehicle_Player_Cost[playerid])return SendClientMessage(playerid, 0xFF6347AA, "Ó Âàñ íå õâàòàåò äåíåã!");
            new carid = GetPlayerVehicleID(playerid);
            new model = GetVehicleModel(carid);
            new Float: p_x, Float: p_y, Float: p_z, Float: p_a; GetVehiclePos(carid, p_x, p_y, p_z);
            GetVehicleZAngle(carid, p_a);
            SetVehiclePos(carid, p_x, p_y+6, p_z);
            SendClientMessage(playerid, -1, "Ïîçäðàâëÿåì ñ ïîêóïêîé ñâîåãî òðàíñïîðòà! Íå çàáóäüòå ïðèïàðêîâàòü åãî ãäå-íèáóäü.");
            player_info[playerid][money] -= Sell_Vehicle_Player_Cost[playerid];
            Sell_Vehicles[carid] = false;
            Delete3DTextLabel(Text_Sell_Vehicles[carid]);

            car_info[OWNABLECAR][cID] = OWNABLECAR;
            car_info[OWNABLECAR][cModel] = model;
            car_info[OWNABLECAR][cColor1] = 1;
            car_info[OWNABLECAR][cColor2] = 1;

            SetString(car_info[OWNABLECAR][cOwner], player_info[playerid][name]);
            car_info[OWNABLECAR][cCost] = Sell_Vehicle_Player_Cost[playerid];
            Sell_Vehicle_Player_Cost[playerid] = 0;
            car_info[OWNABLECAR][cPosX] = p_x;
            car_info[OWNABLECAR][cPosY] = p_y;
            car_info[OWNABLECAR][cPosZ] = p_z;
            car_info[OWNABLECAR][cPosA] = p_a;

            format(string, sizeof(string), "insert into `cars` (`ID`, `Model`, `PosX`, `PosY`, `PosZ`, `PosA`, `Owner`, `Cost`) values (%d, %d, %.2f, %.2f, %.2f, %.2f, %s, %d)",
            OWNABLECAR, car_info[OWNABLECAR][cModel], car_info[OWNABLECAR][cPosX], car_info[OWNABLECAR][cPosY], car_info[OWNABLECAR][cPosZ], car_info[OWNABLECAR][cPosA], car_info[OWNABLECAR][cOwner], car_info[OWNABLECAR][cCost]);

            format(string, sizeof(string), "update `auto_show` set `Total_car` = `Total_car` - 1 where `Model_car` = %d", model);
            mysql_tquery(dbHandle, string);

            carid = AddStaticVehicleEx(model, p_x, p_y, p_z, p_a, 1, 1, -1);
            format(string, sizeof(string), "\
            ** Транспорт продается **\n\n\
            {ffffff}Модель: {FF9900}%s (%d)\n\
            {ffffff}Стоимость: {FF9900}%d$\n\
            {ffffff}Осталось моделей: {FF9900}%d штук\n\n\
            {afafaf}Чтобы купить сядьте в транспорт", VehicleName[model-400], model, Sell_Vehicle_Player_Cost[playerid], GetPVarInt(playerid, "total_car_for_selling_car")-1);
            Text_Sell_Vehicles[carid] = Create3DTextLabel(string, 0x9CABDDAA, p_x, p_y, p_z, 10.0, 0, 0);
            Sell_Vehicles[carid] = true;
            OWNABLECAR++;
        }

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

Купил две штуки, когда моделей осталось '0' машину можно было купить, но счет ушёл в -1 и далее.

[MYSQL] Транспорт не записывается при покупке в БД.

Риктик

Ученик