[Release] Virtual Garage [Updated for 1.0.7]

[Runewulv]

  On 10/24/2017 at 4:30 AM, salival said:

in your dayz_server\system\server_monitor.sqf find: 

_hiveLoaded = false;

add below:

PVDZE_EvacChopperFields = [];

find this line:

if (_isDZ_Buildable || {(_isSafeObject && !_isTrapItem)}) then {

Add this above:

			if ((typeOf _object) == "HeliHRescue") then {
				PVDZE_EvacChopperFields set [count PVDZE_EvacChopperFields, _object];
			};

Add at bottom of server_monitor.sqf:

if (isServer && (isNil "EvacServerPreload")) then {
    publicVariable "PVDZE_EvacChopperFields";
    
    ON_fnc_evacChopperFieldsUpdate = {
        private ["_action","_targetField"];
        _action = _this select 0;
        _targetField = _this select 1;
        
        if (_action == "add") then {
            PVDZE_EvacChopperFields = PVDZE_EvacChopperFields + [_targetField];
        };
        
        if (_action == "rem") then {
            PVDZE_EvacChopperFields = PVDZE_EvacChopperFields - [_targetField];
        };
        
        publicVariable "PVDZE_EvacChopperFields";
    };

    "PVDZE_EvacChopperFieldsUpdate" addPublicVariableEventHandler {(_this select 1) spawn ON_fnc_evacChopperFieldsUpdate};

    EvacServerPreload = true;
};

 

Expand  

OMG Salival. I'll be installing this ASAP to see if it works. Can't thank you enough for what you do for the community.

[motschler1]

Hallo,

bei mir kann ich die Fahrzeuge in der Garage abstellen, die Schlüssel werden auch aus dem Inventar genommen, aber ich kann kein Fahrzeug aus der Garage nehmen, da er keins findet.

Hello,

with me I can park the vehicles in the garage, the keys are also taken from the inventory, 
but I can not take any vehicle out of the garage, since he finds none.

[16:44:05 +02:00] [Thread 1833127214] extDB: Version: 35
[16:44:05 +02:00] [Thread 1833127214] extDB: Windows Version
[16:44:05 +02:00] [Thread 1833127214] Message: Arma Linux Servers are using Older Physic Library (than Windows Servers), due to Debian 7 using old version of Glibc
[16:44:05 +02:00] [Thread 1833127214] Message: If you like extDB consider donating or bug BIS to drop support for Debian 7 thanks, so Linux Servers get same Physic Library Version as Windows
[16:44:05 +02:00] [Thread 1833127214] Message: Note currently most/all development for extDB is done on a Linux Server
[16:44:05 +02:00] [Thread 1833127214] Message: Torndeco: 24/01/15
[16:44:05 +02:00] [Thread 1833127214] 
[16:44:05 +02:00] [Thread 1833127214] extDB: Found extdb-conf.ini
[16:44:05 +02:00] [Thread 1833127214] extDB: Detected 32 Cores, Setting up 6 Worker Threads
[16:44:05 +02:00] [Thread 1833127214] extDB: Database Type: MySQL
[16:44:07 +02:00] [Thread 1833127214] extDB: Database Exception Error: Connection attempt failed: Can't connect to MySQL server on 'localhost' (10061)
[16:44:07 +02:00] [Thread 1833127214] extDB: DB_RAW_V3: No Database Connection
[16:44:07 +02:00] [Thread 1833127214] extDB: Failed to Load Protocol
[16:47:27 +02:00] [Thread 1833127214] extDB: Unknown Protocol: 1
[16:47:27 +02:00] [Thread 1833127214] extDB: Error: Syntax error: Not a valid integer: Error Unknown Protocol
[16:47:39 +02:00] [Thread 1833127214] extDB: Unknown Protocol: 1
[16:47:40 +02:00] [Thread 1833127214] extDB: Error: Syntax error: Not a valid integer: Error Unknown Protocol

 

[Database]
Type = MySQL
; Name of the database you want to store the virtual garage data in, if you want to use your main database enter that here, or use extDB for an external database (if you are doing a hive of virtual garage basically)
Name = ni88xxxxxxxx
; mysql username
Username = ni889xxxxxx
; mysql password
Password = Hnixxxxxx

; ip for your mysql database, you can use localhost if it's on the local machine or an ip address if it's remote (i.e: 1.2.3.4)
IP = localhost
; mysql port
Port = 3306

Kann mir da jemand helfen?

Can someone help me?

 

Weitere Modifikationen:@extDB;@DayzOverwatch;@DayZ_Epoch;@DayZ_Epoch_Server;@ruegen;@a2_infiSTAR

 

[salival]

  On 10/24/2017 at 4:58 PM, motschler1 said:

Hallo,

bei mir kann ich die Fahrzeuge in der Garage abstellen, die Schlüssel werden auch aus dem Inventar genommen, aber ich kann kein Fahrzeug aus der Garage nehmen, da er keins findet.

Hello,

with me I can park the vehicles in the garage, the keys are also taken from the inventory, 
but I can not take any vehicle out of the garage, since he finds none.

[16:44:05 +02:00] [Thread 1833127214] extDB: Version: 35
[16:44:05 +02:00] [Thread 1833127214] extDB: Windows Version
[16:44:05 +02:00] [Thread 1833127214] Message: Arma Linux Servers are using Older Physic Library (than Windows Servers), due to Debian 7 using old version of Glibc
[16:44:05 +02:00] [Thread 1833127214] Message: If you like extDB consider donating or bug BIS to drop support for Debian 7 thanks, so Linux Servers get same Physic Library Version as Windows
[16:44:05 +02:00] [Thread 1833127214] Message: Note currently most/all development for extDB is done on a Linux Server
[16:44:05 +02:00] [Thread 1833127214] Message: Torndeco: 24/01/15
[16:44:05 +02:00] [Thread 1833127214] 
[16:44:05 +02:00] [Thread 1833127214] extDB: Found extdb-conf.ini
[16:44:05 +02:00] [Thread 1833127214] extDB: Detected 32 Cores, Setting up 6 Worker Threads
[16:44:05 +02:00] [Thread 1833127214] extDB: Database Type: MySQL
[16:44:07 +02:00] [Thread 1833127214] extDB: Database Exception Error: Connection attempt failed: Can't connect to MySQL server on 'localhost' (10061)
[16:44:07 +02:00] [Thread 1833127214] extDB: DB_RAW_V3: No Database Connection
[16:44:07 +02:00] [Thread 1833127214] extDB: Failed to Load Protocol
[16:47:27 +02:00] [Thread 1833127214] extDB: Unknown Protocol: 1
[16:47:27 +02:00] [Thread 1833127214] extDB: Error: Syntax error: Not a valid integer: Error Unknown Protocol
[16:47:39 +02:00] [Thread 1833127214] extDB: Unknown Protocol: 1
[16:47:40 +02:00] [Thread 1833127214] extDB: Error: Syntax error: Not a valid integer: Error Unknown Protocol

 

[Database]
Type = MySQL
; Name of the database you want to store the virtual garage data in, if you want to use your main database enter that here, or use extDB for an external database (if you are doing a hive of virtual garage basically)
Name = ni88xxxxxxxx
; mysql username
Username = ni889xxxxxx
; mysql password
Password = Hnixxxxxx

; ip for your mysql database, you can use localhost if it's on the local machine or an ip address if it's remote (i.e: 1.2.3.4)
IP = localhost
; mysql port
Port = 3306

Kann mir da jemand helfen?

Can someone help me?

 

Weitere Modifikationen:@extDB;@DayzOverwatch;@DayZ_Epoch;@DayZ_Epoch_Server;@ruegen;@a2_infiSTAR

 

Expand  

Hi there,

I would guess that somewhere there's a ":" either in the players name or the vehicle name.

Can you post your server RPT?

[ReDBaroN]

  On 10/24/2017 at 4:58 PM, motschler1 said:

Hallo,

bei mir kann ich die Fahrzeuge in der Garage abstellen, die Schlüssel werden auch aus dem Inventar genommen, aber ich kann kein Fahrzeug aus der Garage nehmen, da er keins findet.

Hello,

with me I can park the vehicles in the garage, the keys are also taken from the inventory, 
but I can not take any vehicle out of the garage, since he finds none.

[16:44:05 +02:00] [Thread 1833127214] extDB: Version: 35
[16:44:05 +02:00] [Thread 1833127214] extDB: Windows Version
[16:44:05 +02:00] [Thread 1833127214] Message: Arma Linux Servers are using Older Physic Library (than Windows Servers), due to Debian 7 using old version of Glibc
[16:44:05 +02:00] [Thread 1833127214] Message: If you like extDB consider donating or bug BIS to drop support for Debian 7 thanks, so Linux Servers get same Physic Library Version as Windows
[16:44:05 +02:00] [Thread 1833127214] Message: Note currently most/all development for extDB is done on a Linux Server
[16:44:05 +02:00] [Thread 1833127214] Message: Torndeco: 24/01/15
[16:44:05 +02:00] [Thread 1833127214] 
[16:44:05 +02:00] [Thread 1833127214] extDB: Found extdb-conf.ini
[16:44:05 +02:00] [Thread 1833127214] extDB: Detected 32 Cores, Setting up 6 Worker Threads
[16:44:05 +02:00] [Thread 1833127214] extDB: Database Type: MySQL
[16:44:07 +02:00] [Thread 1833127214] extDB: Database Exception Error: Connection attempt failed: Can't connect to MySQL server on 'localhost' (10061)
[16:44:07 +02:00] [Thread 1833127214] extDB: DB_RAW_V3: No Database Connection
[16:44:07 +02:00] [Thread 1833127214] extDB: Failed to Load Protocol
[16:47:27 +02:00] [Thread 1833127214] extDB: Unknown Protocol: 1
[16:47:27 +02:00] [Thread 1833127214] extDB: Error: Syntax error: Not a valid integer: Error Unknown Protocol
[16:47:39 +02:00] [Thread 1833127214] extDB: Unknown Protocol: 1
[16:47:40 +02:00] [Thread 1833127214] extDB: Error: Syntax error: Not a valid integer: Error Unknown Protocol

 

[Database]
Type = MySQL
; Name of the database you want to store the virtual garage data in, if you want to use your main database enter that here, or use extDB for an external database (if you are doing a hive of virtual garage basically)
Name = ni88xxxxxxxx
; mysql username
Username = ni889xxxxxx
; mysql password
Password = Hnixxxxxx

; ip for your mysql database, you can use localhost if it's on the local machine or an ip address if it's remote (i.e: 1.2.3.4)
IP = localhost
; mysql port
Port = 3306

Kann mir da jemand helfen?

Can someone help me?

 

Weitere Modifikationen:@extDB;@DayzOverwatch;@DayZ_Epoch;@DayZ_Epoch_Server;@ruegen;@a2_infiSTAR

 

Expand  

vg_removeKey = true; // Remove the key from the players inventory after storing vehicle?

Change this to false.

If like us, you are also using vehicle key changer and have merged your vehicles on to one key, you are better setting this to false anyway.

[SKS.Goliath]

ja musst deine datenbank richtig einstellen

[Relentless]

  On 10/24/2017 at 6:25 PM, SKS.Goliath said:

ja musst deine datenbank richtig einstellen

Expand  

Stop writing German

[motschler1]

I have everything set as in the description. how is it right?

  Error Undefined variable in expression: dze_safevehicle
File z\addons\dayz_server\system\scheduler\sched_safetyVehicle.sqf, line 4
Error in expression <ectMonitor) && !((typeOf vehicle _x) in DZE_safeVehicle)) then {
diag_log [ "z\a>
  Error position: <DZE_safeVehicle)) then {
diag_log [ "z\a>
  Error Undefined variable in expression: dze_safevehicle
File z\addons\dayz_server\system\scheduler\sched_safetyVehicle.sqf, line 4
Error in expression <ectMonitor) && !((typeOf vehicle _x) in DZE_safeVehicle)) then {
diag_log [ "z\a>
  Error position: <DZE_safeVehicle)) then {
diag_log [ "z\a>
  Error Undefined variable in expression: dze_safevehicle
File z\addons\dayz_server\system\scheduler\sched_safetyVehicle.sqf, line 4
Error in expression <ectMonitor) && !((typeOf vehicle _x) in DZE_safeVehicle)) then {
diag_log [ "z\a>
  Error position: <DZE_safeVehicle)) then {
diag_log [ "z\a>
  Error Undefined variable in expression: dze_safevehicle
File z\addons\dayz_server\system\scheduler\sched_safetyVehicle.sqf, line 4
Error in expression <ectMonitor) && !((typeOf vehicle _x) in DZE_safeVehicle)) then {
diag_log [ "z\a>
  Error position: <DZE_safeVehicle)) then {
diag_log [ "z\a>
  Error Undefined variable in expression: dze_safevehicle
File z\addons\dayz_server\system\scheduler\sched_safetyVehicle.sqf, line 4

 

[motschler1]

[motschler1]

[salival]

  On 10/24/2017 at 9:19 PM, motschler1 said:

I have everything set as in the description. how is it right?

  Error Undefined variable in expression: dze_safevehicle
File z\addons\dayz_server\system\scheduler\sched_safetyVehicle.sqf, line 4
Error in expression <ectMonitor) && !((typeOf vehicle _x) in DZE_safeVehicle)) then {
diag_log [ "z\a>
  Error position: <DZE_safeVehicle)) then {
diag_log [ "z\a>
  Error Undefined variable in expression: dze_safevehicle
File z\addons\dayz_server\system\scheduler\sched_safetyVehicle.sqf, line 4
Error in expression <ectMonitor) && !((typeOf vehicle _x) in DZE_safeVehicle)) then {
diag_log [ "z\a>
  Error position: <DZE_safeVehicle)) then {
diag_log [ "z\a>
  Error Undefined variable in expression: dze_safevehicle
File z\addons\dayz_server\system\scheduler\sched_safetyVehicle.sqf, line 4
Error in expression <ectMonitor) && !((typeOf vehicle _x) in DZE_safeVehicle)) then {
diag_log [ "z\a>
  Error position: <DZE_safeVehicle)) then {
diag_log [ "z\a>
  Error Undefined variable in expression: dze_safevehicle
File z\addons\dayz_server\system\scheduler\sched_safetyVehicle.sqf, line 4
Error in expression <ectMonitor) && !((typeOf vehicle _x) in DZE_safeVehicle)) then {
diag_log [ "z\a>
  Error position: <DZE_safeVehicle)) then {
diag_log [ "z\a>
  Error Undefined variable in expression: dze_safevehicle
File z\addons\dayz_server\system\scheduler\sched_safetyVehicle.sqf, line 4

 

Expand  

I would guess you are running old versions of stuff, this should never happen.

I will pm you my email address, please send me your dayz_server.pbo and your mission pbo

[motschler1]

OK

[_Lance_]

  On 10/24/2017 at 4:30 AM, salival said:

in your dayz_server\system\server_monitor.sqf find: 

_hiveLoaded = false;

add below:

PVDZE_EvacChopperFields = [];

find this line:

if (_isDZ_Buildable || {(_isSafeObject && !_isTrapItem)}) then {

Add this above:

			if ((typeOf _object) == "HeliHRescue") then {
				PVDZE_EvacChopperFields set [count PVDZE_EvacChopperFields, _object];
			};

Add at bottom of server_monitor.sqf:

if (isServer && (isNil "EvacServerPreload")) then {
    publicVariable "PVDZE_EvacChopperFields";
    
    ON_fnc_evacChopperFieldsUpdate = {
        private ["_action","_targetField"];
        _action = _this select 0;
        _targetField = _this select 1;
        
        if (_action == "add") then {
            PVDZE_EvacChopperFields = PVDZE_EvacChopperFields + [_targetField];
        };
        
        if (_action == "rem") then {
            PVDZE_EvacChopperFields = PVDZE_EvacChopperFields - [_targetField];
        };
        
        publicVariable "PVDZE_EvacChopperFields";
    };

    "PVDZE_EvacChopperFieldsUpdate" addPublicVariableEventHandler {(_this select 1) spawn ON_fnc_evacChopperFieldsUpdate};

    EvacServerPreload = true;
};

 

Expand  

Did you just casually fix evac chopper?! Holy crap dude. - To the test server!

[salival]

  On 10/26/2017 at 10:22 PM, _Lance_ said:

Did you just casually fix evac chopper?! Holy crap dude. - To the test server!

Expand  

Maybe, I didn't.test it but logically it should work.

If there's enough interest I can go back through that mod and update it and tidy it up.

I have your files you sent me, too. Work has been shit the last few weeks so I'll try and look at it this weekend

[_Lance_]

  On 10/26/2017 at 11:28 PM, salival said:

Maybe, I didn't.test it but logically it should work.

If there's enough interest I can go back through that mod and update it and tidy it up.

I have your files you sent me, too. Work has been shit the last few weeks so I'll try and look at it this weekend

Expand  

All good with me man, no rush. I've installed the chopper mod on the test server and going through the files now updating the variables, I'll let you know what I get! If it works you're gonna have to do a re-release everyone will want this fa-sho.

[salival]

Hi guys,

Pushed a commit today that many people have wanted since the start, it's a good starting place to get it dialed in to work better.

At the moment it's tied to a plot pole but this can be expanded on in the future (with ideas from you guys)

Basically how it works, if vg_tiedToPole = true then the script will use the PUID of the person who placed the pole for getting/storing vehicles instead of the players UID as it did when released.

If no plot pole is found or vg_tiedToPole = false, it will default back to the players UID

I've tested this but there could be issues, please test and let me know how it goes for you/your players.

https://github.com/oiad/virtualGarage/commit/d9ad17ef2e5d02bfb82e0921b58cc0a7db4fdd2e

[salival]

Also added an SQL cleanup event, default information is database `garage` 35 days / 5 weeks cleanup time: 

https://github.com/oiad/virtualGarage/commit/bb2d8198f8e9cad017ef53eb4a43713a5be9cabe

[_Lance_]

  On 10/28/2017 at 10:07 PM, salival said:

Hi guys,

Pushed a commit today that many people have wanted since the start, it's a good starting place to get it dialed in to work better.

At the moment it's tied to a plot pole but this can be expanded on in the future (with ideas from you guys)

Basically how it works, if vg_tiedToPole = true then the script will use the PUID of the person who placed the pole for getting/storing vehicles instead of the players UID as it did when released.

If no plot pole is found or vg_tiedToPole = false, it will default back to the players UID

I've tested this but there could be issues, please test and let me know how it goes for you/your players.

https://github.com/oiad/virtualGarage/commit/d9ad17ef2e5d02bfb82e0921b58cc0a7db4fdd2e

Expand  

Does anything need to be done with the db or just drop in the edits and go? Thanks!

[salival]

  On 10/29/2017 at 3:57 AM, _Lance_ said:

Does anything need to be done with the db or just drop in the edits and go? Thanks!

Expand  

Nothing needs doing with the database, just run with the updates.

Hopefully it doesn't make anything implode, it worked fine for me. My stored vehicles on my plot still showed, on another plot pole with a different PUID showed his stored vehicles.

[_Lance_]

  On 10/29/2017 at 5:06 AM, salival said:

Nothing needs doing with the database, just run with the updates.

Hopefully it doesn't make anything implode, it worked fine for me. My stored vehicles on my plot still showed, on another plot pole with a different PUID showed his stored vehicles.

Expand  

I gots backups, I'll let you know if anyone's lada disappears.

[salival]

  On 10/29/2017 at 5:10 AM, _Lance_ said:

I gots backups, I'll let you know if anyone's lada disappears.

Expand  

I have a motto: It can either fix it or fuck it.

Hopefully the former is what happens :)

[salival]

Just a note, if you're running older versions of virtual garage and you update, make sure you run the update SQL if it changes, you can run into database errors if you dont

[Cubitron]

Works Perfect Thanks for the script btw i try to run evac chopper but i cant get working. 

[motschler1]

Hello, I get the following error message:

Database Exception Error: Connection attempt failed: Access denied for user '<ni8xxxxxxx>'@'46.251.235.69' (using password: YES)

what can i do?

[Schalldampfer]

  On 11/11/2017 at 11:24 PM, motschler1 said:

Hello, I get the following error message:

Database Exception Error: Connection attempt failed: Access denied for user '<ni8xxxxxxx>'@'46.251.235.69' (using password: YES)

what can i do?

Expand  

As your log says "Access denied for user '<ni8xxxxxxx>'@'46.251.235.69' ", you need to check your mysql user and database permission. 
you need to grant permissions to "extdb" database. (you need to grant permissions per database)

[motschler1]

My server is at nitrado. I have data from hostname, port, username, password, database. 
everything correctly entered. I am despairing. I am not a database professional. 
Could anyone help me, please. Greetings from Germany

Hostname
 ms1xxx.nitrado.net

Port
 3306

Benutzername
 ni88xxxx_5_DB

Passwort
 ******** 

Datenbank
 ni88xxxx_5_DB

here my extdb-conf

[Database]
Type = MySql
; Name of the database you want to store the virtual garage data in, if you want to use your main database enter that here, or use extDB for an external database (if you are doing a hive of virtual garage basically)
Name = <ni88xxxx_5_DB>
; mysql username
Username = <ni88xxxx_5_DB>
; mysql password
Password = <xxxxxxxx>

; ip for your mysql database, you can use localhost if it's on the local machine or an ip address if it's remote (i.e: 1.2.3.4)
IP = ms15xx.nitrado.net
; mysql port
Port = 3306

minSessions = 1
maxSessions = 4
idleTime = 60