Сохранение инвентаря в Virtual Garage

Нашел скрипт виртуального гаража. Он не сохраняет инвентарь машины. Мучался 2 дня, но в итоге теперь в таблицу виртуального гаража вписывается лут в транспорте, а вот при спавне его уже нет. Ниже выкладываю модифицированные файлики. Может есть у кого идеи почему нету лута в машине при спавне?

 

Сервер аддон Virtual Garage:

ExileServer_VirtualGarage_network_RetrieveVehicleRequest.sqf -

/*

 

    Name: ExileServer_VirtualGarage_network_RetrieveVehicleRequest.sqf

     Author(s): Shix

    Copyright © 2016 Shix

    This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

    To view a copy of this license, visit http://creativecommons.org/licenses/by-nc-nd/4.0/.

     Description: handles retrieve vehicle requests

*/

private ["_sessionID","_vehicleDBID","_player","_VehicleInfo","_vehClass","_vehFuel","_vehDamage","_vehHitPoints","_vehPinCode","_vehCargo_items","_vehCargo_magazines","_vehCargo_weapons","_vehCargo_container"];

_sessionID = _this select 0;

_vehicleDBID = (_this select 1) select 0;

try

{

  _player = _sessionID call ExileServer_system_session_getPlayerObject;

  if (isNull _player) then

  {

    throw "No player was found from the session ID";

  };

  _VehicleInfo = format ["RetrieveVehicle:%1", _vehicleDBID] call ExileServer_system_database_query_selectFull;

  _vehClass = (_VehicleInfo select 0) select 1;

  _vehFuel = (_VehicleInfo select 0) select 3;

  _vehDamage = (_VehicleInfo select 0) select 4;

  _vehHitPoints = (_VehicleInfo select 0) select 5;

  _vehPinCode = (_VehicleInfo select 0) select 6;

  _vehPosX = (_VehicleInfo select 0) select 7;

  _vehPosY = (_VehicleInfo select 0) select 8;

  _vehPosZ = (_VehicleInfo select 0) select 9;

  _vehVectorDirX = (_VehicleInfo select 0) select 10;

  _vehVectorDirY = (_VehicleInfo select 0) select 11;

  _vehVectorDirZ = (_VehicleInfo select 0) select 12;

  _vehVectorUpX = (_VehicleInfo select 0) select 13;

  _vehVectorUpY = (_VehicleInfo select 0) select 14;

  _vehVectorUpZ = (_VehicleInfo select 0) select 15;

  _vehCargo_items = (_VehicleInfo select 0) select 16;

  _vehCargo_magazines = (_VehicleInfo select 0) select 17;

  _vehCargo_weapons = (_VehicleInfo select 0) select 18;

  _vehCargo_container = (_VehicleInfo select 0) select 19;

  _texture = (_VehicleInfo select 0) select 20;

  [_sessionID,[_vehClass,_vehPinCode,_vehFuel,_vehDamage,_vehHitPoints,_vehicleDBID,_vehPosX,_vehPosY,_vehPosZ,_vehVectorDirX,_vehVectorDirY,_vehVectorDirZ,_vehVectorUpX,_vehVectorUpY,_vehVectorUpZ,_vehCargo_items,_vehCargo_magazines,_vehCargo_weapons,_vehCargo_container,_texture]] call ExileServer_VirtualGarage_network_SpawnRequestedVehicle;

} catch {

  [_exception,"Virtual Garage Retrieve Vehicle Error"] call ExileServer_VirtualGarage_utils_diagLog;

}

 

 

 

 

ExileServer_VirtualGarage_network_SpawnRequestedVehicle.sqf -

/*

 

     Name: ExileServer_VirtualGarage_network_SpawnRequestedVehicle.sqf

     Author(s): Shix

      Copyright © 2016 Shix

      This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

      To view a copy of this license, visit http://creativecommons.org/licenses/by-nc-nd/4.0/.

     Description: handles spawn Vehicle Requests

*/

private["_sessionID","_parameters","_vehicleClass","_pinCode","_vehicleFuel","_vehicleDamage","_vehicleHitPoints","_vehicleDatabaseID","_vehicleCargo_items","_vehicleCargo_magazines","_vehicleCargo_weapons","_vehicleCargo_container","_playerObject","_salesPrice","_playerMoney","_position","_vehicleObject","_responseCode"];

_sessionID = _this select 0;

_parameters = _this select 1;

_vehicleClass = _parameters select 0;

_pinCode = _parameters select 1;

_vehicleFuel = _parameters select 2;

_vehicleDamage = _parameters select 3;

_vehicleHitPoints = _parameters select 4;

_vehicleDatabaseID = _parameters select 5;

_vehiclePosX = _parameters select 6;

_vehiclePosY = _parameters select 7;

_vehiclePosZ = _parameters select 8;

_vehicleVectorDirX = _parameters select 9;

_vehicleVectorDirY = _parameters select 10;

_vehicleVectorDirZ = _parameters select 11;

_vehicleVectorUpX = _parameters select 12;

_vehicleVectorUpY = _parameters select 13;

_vehicleVectorUpZ = _parameters select 14;

_vehicleCargo_items = _parameters select 15;

_vehicleCargo_magazines = _parameters select 16;

_vehicleCargo_weapons = _parameters select 17;

_vehicleCargo_container = _parameters select 18;

_textures = _parameters select 19;

try

{

    _playerObject = _sessionID call ExileServer_system_session_getPlayerObject;

    if (isNull _playerObject) then

    {

        throw "The is no player";

    };

    if !(alive _playerObject) then

    {

        throw "The player is dead";

    };

    if !((count _pinCode) isEqualTo 4) then

    {

        throw "The pin code is does not equal 4 chars";

    };

    _position = (getPos _playerObject) findEmptyPosition [20, 175, _vehicleClass];

    _direction = (random 360);

    _SpawnPos = getNumber (missionconfigfile >> "VirtualGarageSettings" >> "VirtualGarage_VehicleSpawnPos");

    if (_SpawnPos == 1) then {

        _position = [_vehiclePosX,_vehiclePosY,_vehiclePosZ];

        _direction = [[_vehicleVectorDirX,_vehicleVectorDirY,_vehicleVectorDirZ],[_vehicleVectorUpX,_vehicleVectorUpY,_vehicleVectorUpZ]];

    };

    if (_position isEqualTo []) then

    {

            throw "Position is not defined";

    };

    _vehicleObject = [_vehicleClass, _position, _direction, true, _pinCode] call ExileServer_object_vehicle_createPersistentVehicle;

    _vehicleObject setVariable ["ExileOwnerUID", (getPlayerUID _playerObject)];

    for '_i' from 0 to (count _textures)-1 do {

        _tex = _textures select _i;

        _vehicleObject setObjectTextureGlobal [_i, _tex];

    };

    _vehSpawnState = getNumber (missionconfigfile >> "VirtualGarageSettings" >> "VirtualGarage_VehicleSpawnState");

    if (_vehSpawnState == 1) then

    {

        _vehicleObject setVariable ["ExileIsLocked",1,true];

        _vehicleObject lock 2;

    };

    _vehicleObject setFuel _vehicleFuel;

    _vehicleObject setDamage _vehicleDamage;

    _vehicleObject addItemCargoGlobal _vehicleCargo_items;

    _vehicleObject addMagazineCargoGlobal _vehicleCargo_magazines;

    _vehicleObject addWeaponCargoGlobal _vehicleCargo_weapons;

    _vehicleObject addBackpackCargoGlobal _vehicleCargo_container;

    _reapplyDamage = getNumber (missionconfigfile >> "VirtualGarageSettings" >> "VirtualGarage_ReapplyDamage");

    if (_reapplyDamage == 1) then

    {

        if ((typeName _vehicleHitPoints) isEqualTo "ARRAY") then

        {

            {

                _vehicleObject setHitPointDamage [_x select 0, _x select 1];

            }forEach _vehicleHitPoints;

        };

    };

    _GivePlayerPinCode = getNumber (missionconfigfile >> "VirtualGarageSettings" >> "VirtualGarage_GivePlayerPinCode");

    if (_GivePlayerPinCode == 1) then {

        _msg = Format["Vehicle Successfully Retrieved PIN Code:%1",_pinCode];

        [_sessionID, "notificationRequest", ["Success", [_msg]]] call ExileServer_system_network_send_to;

    }

    else

    {

        _msg = Format["Vehicle Successfully Retrieved"];

        [_sessionID, "notificationRequest", ["Success", [_msg]]] call ExileServer_system_network_send_to;

    };

    _vehicleObject call ExileServer_object_vehicle_database_insertGarage;

    _vehicleObject call ExileServer_object_vehicle_database_update;

    [_sessionID, "RetrieveVehicleResponse", ["true",netId _vehicleObject]] call ExileServer_system_network_send_to;

    format ["deleteVehicleFromVG:%1", _vehicleDatabaseID] call ExileServer_system_database_query_fireAndForget;

    _vehicleDBID = _vehicleObject getVariable ["ExileDatabaseID",0];

    _skinTextures = getObjectTextures _vehicleObject;

    format["updateVehicleSkin:%1:%2", _skinTextures, _vehicleDBID] call ExileServer_system_database_query_fireAndForget;

}

catch

{

    [_exception,"Virtual Garage Spawn Vehicle Error"] call ExileServer_VirtualGarage_utils_diagLog;

      [_sessionID, "RetrieveVehicleResponse", ["false",_vehicleObject]] call ExileServer_system_network_send_to;

};

 

 

 

 

Серверный аддон Exile Server:

ExileServer_object_vehicle_database_insertGarage.sqf -

/**

 * ExileServer_object_vehicle_database_insertGarage

 *

 * Exile Mod

 * www.exilemod.com

 * © 2015 Exile Mod Team

 *

 * This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License. 

 * To view a copy of this license, visit http://creativecommons.org/licenses/by-nc-nd/4.0/.

 */

 

private["_vehicleObject","_position","_vectorDirection","_vectorUp","_ItemCargo","_MagazinesCargo","_WeaponsCargo","_ContainerCargo","_data","_extDB2Message","_vehicleID"];

_vehicleObject = _this;

_position = getPosATL _vehicleObject;

_vectorDirection = vectorDir _vehicleObject;

_vectorUp = vectorUp _vehicleObject;

_ItemCargo = _vehicle call ExileServer_util_getItemCargo;

_MagazinesCargo = magazinesAmmoCargo _vehicle;

_WeaponsCargo = weaponsItemsCargo _vehicle;

_ContainerCargo = _vehicle call ExileServer_util_getObjectContainerCargo;

_data =

[

    typeOf _vehicleObject,

    _vehicleObject getVariable ["ExileOwnerUID", ""],

    locked _vehicleObject,

    _position select 0,

    _position select 1,

    _position select 2,

    _vectorDirection select 0, 

    _vectorDirection select 1,

    _vectorDirection select 2,

    _vectorUp select 0,

    _vectorUp select 1,

    _vectorUp select 2,

    _ItemCargo,

    _MagazinesCargo,

    _WeaponsCargo,

    _ContainerCargo,

    _vehicleObject getVariable ["ExileAccessCode",""]

];

_extDB2Message = ["insertVehicleFromGarage", _data] call ExileServer_util_extDB2_createMessage;

_vehicleID = _extDB2Message call ExileServer_system_database_query_insertSingle;

_vehicleObject setVariable["ExileDatabaseID", _vehicleID];

_vehicleObject setVariable["ExileIsPersistent", true];

_vehicleID

 

 

Изменённый код extDB:

exile.ini -

[insertVehicleFromGarage]

SQL1_1 = INSERT INTO vehicle SET 

SQL1_2 = class = ?, 

SQL1_3 = account_uid = ?,

SQL1_4 = is_locked = ?,

SQL1_5 = position_x = ?,

SQL1_6 = position_y = ?,

SQL1_7 = position_z = ?,

SQL1_8 = direction_x = ?,

SQL1_9 = direction_y = ?,

SQL1_10 = direction_z = ?,

SQL1_11 = up_x = ?,

SQL1_12 = up_y = ?,

SQL1_13 = up_z = ?,

SQL1_14 = cargo_items = ?,

SQL1_15 = cargo_magazines = ?,

SQL1_16 = cargo_weapons = ?,

SQL1_17 = cargo_container = ?,

SQL1_18 = pin_code = ?

Number of Inputs = 13

SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17

Return InsertID = true

 

 

 

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

;; VIRTUAL GARAGE

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

 

[getStoredVehicles]

SQL1_1 = SELECT id, class FROM virtual_garage WHERE account_uid = ?

Number Of Inputs = 1

SQL1_INPUTS = 1

OUTPUT = 1,2-STRING

 

[insertVehicleToVG]

SQL1_1 = INSERT INTO virtual_garage SET

SQL1_2 = class = ?,

SQL1_3 = account_uid = ?,

SQL1_4 = fuel = ?,

SQL1_5 = damage = ?,

SQL1_6 = hitpoints = ?,

SQL1_7 = pin_code = ?,

SQL1_8 = position_x = ?,

SQL1_9 = position_y = ?,

SQL1_10 = position_z = ?,

SQL1_11 = direction_x = ?,

SQL1_12 = direction_y = ?,

SQL1_13 = direction_z = ?,

SQL1_14 = up_x = ?,

SQL1_15 = up_y = ?,

SQL1_16 = up_z = ?,

SQL1_17 = cargo_items = ?,

SQL1_18 = cargo_magazines = ?,

SQL1_19 = cargo_weapons = ?,

SQL1_20 = cargo_container = ?,

SQL1_21 = vehicle_texture = ?

Number of Inputs = 20

SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20

Return InsertID = true

 

[RetrieveVehicle]

SQL1_1 = SELECT id,class,account_uid,fuel,damage,hitpoints,pin_code,position_x,position_y,position_z,direction_x,direction_y,direction_z,up_x,up_y,up_z,vehicle_texture FROM virtual_garage WHERE id = ?

Number Of Inputs = 1

SQL1_INPUTS = 1

OUTPUT = 1,2-STRING,3-STRING,4,5,6,7-STRING,8,9,10,11,12,13,14,15,16,17,18,19,20,21

 

[deleteVehicleFromVG]

SQL1_1 = DELETE FROM virtual_garage WHERE id = ?

Number Of Inputs = 1

SQL1_INPUTS = 1