Gang Container Problem

Frenzy

I added a container to the gang zone to store weapons and gear. And I made this container available only as a gang member. So far everything is working fine. However, when I put equipment in it, the equipment disappears and is deleted after restarting the server. Is there a solution for this?

Or what script should I check?

Thanks for help.

Abgaswert

The equipment is stored temporarly on the server. If you want the contents of any container to remain even after restarting the server, you have to save the inventory in a database. I'd recommend you to just create a new table and work with it in the "init" file of the @life_server server mod or the mission itself.

Another thing to call to mind: if you spawn the container with a script that is executed when a player is nearby or when the server starts, you can interact with the database from there with remoteExec. You can then add an EventHandler onto the container that's executed as soon as the inventory of the contrainer is closed. WIthin this EventHandler you can again interact with the database to store all the contents of the container.

I hope, I was able to help!

Frenzy

Zitat von Abgaswert

The equipment is stored temporarly on the server. If you want the contents of any container to remain even after restarting the server, you have to save the inventory in a database. I'd recommend you to just create a new table and work with it in the "init" file of the @life_server server mod or the mission itself.
Another thing to call to mind: if you spawn the container with a script that is executed when a player is nearby or when the server starts, you can interact with the database from there with remoteExec. You can then add an EventHandler onto the container that's executed as soon as the inventory of the contrainer is closed. WIthin this EventHandler you can again interact with the database to store all the contents of the container.
I hope, I was able to help!

Can you show as an example?

Frenzy

These are my scripts.

Code

#include "\life_server\script_macros.hpp"
/*
    File : fn_fetchPlayerGangCont.sqf
    Author: Bryan "Tonic" Boardwine
    Modified : NiiRoZz

    Description:
    1. Fetches all the players houses and sets them up.
    2. Fetches all the players containers and sets them up.

*/
private _containerss = [con_b,con_d,con_a,con_e,con_h];

{
    _query = format ["SELECT inventory, gear FROM gangcontainers WHERE id='%1'",_forEachIndex + 1];
    _containers = [_query,2,true] call DB_fnc_asyncCall;
    diag_log format ["gangs containers loded:: %1", _containers];
    diag_log format ["gangs containers loded:: %1", _x];
    
    _trunk = [(_containers select 0) select 0] call DB_fnc_mresToArray;
    if (_trunk isEqualType "") then {_trunk = call compile format ["%1", _trunk];};
    _gear = [(_containers select 0) select 1] call DB_fnc_mresToArray;
    if (_gear isEqualType "") then {_gear = call compile format ["%1", _gear];};
    
    _x setVariable ["Trunk",_trunk,true];
    
    clearWeaponCargoGlobal _x;
    clearItemCargoGlobal _x;
    clearMagazineCargoGlobal _x;
    clearBackpackCargoGlobal _x;
    
    if (count _gear > 0) then {
        _items = _gear select 0;
        _mags = _gear select 1;
        _weapons = _gear select 2;
        _backpacks = _gear select 3;
        for "_i" from 0 to ((count (_items select 0)) - 1) do {
            _x addItemCargoGlobal [((_items select 0) select _i), ((_items select 1) select _i)];
        };
        for "_i" from 0 to ((count (_mags select 0)) - 1) do{
            _x addMagazineCargoGlobal [((_mags select 0) select _i), ((_mags select 1) select _i)];
        };
        for "_i" from 0 to ((count (_weapons select 0)) - 1) do{
            _x addWeaponCargoGlobal [((_weapons select 0) select _i), ((_weapons select 1) select _i)];
        };
        for "_i" from 0 to ((count (_backpacks select 0)) - 1) do {
            _x addBackpackCargoGlobal [((_backpacks select 0) select _i), ((_backpacks select 1) select _i)];
        };
    };
} forEach _containerss;

Alles anzeigen

Code

/*
    File : fn_updateGangContainers.sqf
    Author: NiiRoZz

    Description:
    Update inventory "i" in container
*/
private _container = [_this,0,objNull,[objNull]] call BIS_fnc_param;
if (isNull _container) exitWith {};
private _containerID = switch (_container) do {
    case con_b: {1};
    case con_d: {2};
    case con_a: {3};
    case con_e: {4};
    case con_h: {5};
    default {-1};
};
if (_containerID isEqualTo -1) exitWith {};


private _vehItems = getItemCargo _container;
private _vehMags = getMagazineCargo _container;
private _vehWeapons = getWeaponCargo _container;
private _vehBackpacks = getBackpackCargo _container;
private _cargo = [_vehItems,_vehMags,_vehWeapons,_vehBackpacks];

_cargo = [_cargo] call DB_fnc_mresArray;

private _query = format ["UPDATE gangcontainers SET gear='%1' WHERE id='%2'",_cargo,_containerID];

[_query,1] call DB_fnc_asyncCall;

Alles anzeigen

Code

/*
    File : fn_updateGangTrunk.sqf
    Author: NiiRoZz

    Description:
    Update inventory "y" in container
*/
_container = [_this,0,objNull,[objNull]] call BIS_fnc_param;
if (isNull _container) exitWith {};

_trunkData = _container getVariable ["Trunk",[[],0]];
private _containerID = switch (_container) do {
    case con_b: {1};
    case con_d: {2};
    case con_a: {3};
    case con_e: {4};
    case con_h: {5};
    default {-1};
};

if (_containerID isEqualTo -1) exitWith {}; //Dafuq?

_trunkData = [_trunkData] call DB_fnc_mresArray;
_query = format ["UPDATE gangcontainers SET inventory='%1' WHERE id='%2'",_trunkData,_containerID];

[_query,1] call DB_fnc_asyncCall;

Alles anzeigen

Abgaswert

Sorry for my late response, but please ensure you have setup the database table as required. You MUST have a table called "gangcontainers" in order for those scripts to work. The rest of the files look fine to me.

Frenzy

Zitat von Abgaswert

Sorry for my late response, but please ensure you have setup the database table as required. You MUST have a table called "gangcontainers" in order for those scripts to work. The rest of the files look fine to me.

I have the following codes in my database.

Code

--
-- Tablo için tablo yapısı `gangcontainers`
--

CREATE TABLE `gangcontainers` (
  `id` int(6) NOT NULL,
  `classname` varchar(32) NOT NULL,
  `pos` varchar(64) DEFAULT NULL,
  `inventory` text NOT NULL,
  `gear` text NOT NULL,
  `dir` varchar(128) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 0,
  `owned` tinyint(1) DEFAULT 0,
  `insert_time` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


--
-- Tablo için indeksler `gangcontainers`
--
ALTER TABLE `gangcontainers`
  ADD PRIMARY KEY (`id`);
  
  
--
-- Tablo için AUTO_INCREMENT değeri `gangcontainers`
--
ALTER TABLE `gangcontainers`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT;

Alles anzeigen

Abgaswert

Have you got any errors in the log files? Especially extDB and .rpt logs

Frenzy

Zitat von Abgaswert

Have you got any errors in the log files? Especially extDB and .rpt logs

I am sharing my log files.

Code

extDB3: https://bitbucket.org/torndeco/extdb3/wiki/Home
extDB3: Version: 1.032
extDB3: Windows Version
Message: All development for extDB3 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB3 Development
Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Also leave a message if there is any particular feature you would like to see added.
Message: Thanks for all the people that have donated.
Message: Torndeco: 18/05/15


extDB3: Found extdb3-conf.ini
extDB3: Detected 8 Cores, Setting up 6 Worker Threads
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...


[02:57:08:139096 +03:00] [Thread 21252] extDB3: SQL: Initialized: Add Quotes around TEXT Datatypes mode: 2
[02:57:08:139438 +03:00] [Thread 21252] extDB3: SQL: Initialized: NULL = ""
[02:57:08:139517 +03:00] [Thread 21252] extDB3: Locked

Alles anzeigen

Abgaswert

Your extDB3 is working fine. The problem has to be found in your life_server mod. Looking through your .rpt log, I can read, that your containers (con_a, con_b, ...) cannot be found. Usually this means that there are no containers in your mission.sqm file. Please make sure you got a correct mission file loaded.

You could also try to change your startup parameters. You're running @life_server and @extDB3 as a -mod. Try to run them as a -servermod.

Since it can't find your containers, you could also try to give those containers as a parameter to the script. This would mean, that you'd have to change the line

private _containerss = [con_b,con_d,con_a,con_e,con_h];

ans instead use something like

private _containerss = _this;

Using the magic variable _this means you'd have to change the script that calls the fetchGangCont script. Instead of

call TON_fnc_fetchGangCont;

you would need

[con_b, con_d, con_a, con_e, con_h] call TON_fnc_fetchGangCont;

This should do the trick.

Frenzy

Zitat von Abgaswert

Your extDB3 is working fine. The problem has to be found in your life_server mod. Looking through your .rpt log, I can read, that your containers (con_a, con_b, ...) cannot be found. Usually this means that there are no containers in your mission.sqm file. Please make sure you got a correct mission file loaded.
You could also try to change your startup parameters. You're running @life_server and @extDB3 as a -mod. Try to run them as a -servermod.
Since it can't find your containers, you could also try to give those containers as a parameter to the script. This would mean, that you'd have to change the line
private _containerss = [con_b,con_d,con_a,con_e,con_h];
ans instead use something like
private _containerss = _this;
Using the magic variable _this means you'd have to change the script that calls the fetchGangCont script. Instead of
call TON_fnc_fetchGangCont;
you would need
[con_b, con_d, con_a, con_e, con_h] call TON_fnc_fetchGangCont;
This should do the trick.

Alles anzeigen

I am unhappy. No matter what I do I still can't fix the problem. Can you edit the file if I send it to you?

Frenzy

No matter what I did. When I put weapons or gear in the container it is deleted after the server restarts.

Although I have gang containers in my database, they are deleted when I put Weapons and Equipment in the containers. And it doesn't register in the database.

I would be glad if you help. I've been trying for weeks but it's not working.

Benutzer online in diesem Thema