Jump to content

[Release] Virtual Garage [Updated for 1.0.7]


salival

Recommended Posts

you have to set your database correctly

 

That was my mistake too. In the @extDB, set the extdb-conf correctly according to your SQL database data

Nitrado and of course feed your database with this SQL command:

Das war auch mein Fehler. In der @extDB , die extdb-conf richtig einstellen nach deinen Daten der SQL-Datenbank von

Nitrado und natürlich deine Datenbank mit diesem SQL-Befehl füttern:

CREATE TABLE IF NOT EXISTS `garage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `PlayerUID` varchar(20) NOT NULL DEFAULT '0',
  `Name` varchar(50) NOT NULL DEFAULT '',
  `DisplayName` varchar(50) NOT NULL DEFAULT '',
  `Classname` varchar(50) DEFAULT NULL,
  `Datestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `DateStored` varchar(10) NOT NULL DEFAULT 'old',
  `CharacterID` int(11) unsigned NOT NULL DEFAULT '0',
  `Inventory` mediumtext,
  `Hitpoints` mediumtext,
  `Fuel` double(13,5) NOT NULL DEFAULT '1.00000',
  `Damage` double(13,5) NOT NULL DEFAULT '0.00000',
  `Colour` varchar(50) NOT NULL,
  `Colour2` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

Link to comment
Share on other sites

  On 1/21/2018 at 11:11 AM, motschler1 said:
you have to set your database correctly

 

That was my mistake too. In the @extDB, set the extdb-conf correctly according to your SQL database data

Nitrado and of course feed your database with this SQL command:

Das war auch mein Fehler. In der @extDB , die extdb-conf richtig einstellen nach deinen Daten der SQL-Datenbank von

Nitrado und natürlich deine Datenbank mit diesem SQL-Befehl füttern:

CREATE TABLE IF NOT EXISTS `garage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `PlayerUID` varchar(20) NOT NULL DEFAULT '0',
  `Name` varchar(50) NOT NULL DEFAULT '',
  `DisplayName` varchar(50) NOT NULL DEFAULT '',
  `Classname` varchar(50) DEFAULT NULL,
  `Datestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `DateStored` varchar(10) NOT NULL DEFAULT 'old',
  `CharacterID` int(11) unsigned NOT NULL DEFAULT '0',
  `Inventory` mediumtext,
  `Hitpoints` mediumtext,
  `Fuel` double(13,5) NOT NULL DEFAULT '1.00000',
  `Damage` double(13,5) NOT NULL DEFAULT '0.00000',
  `Colour` varchar(50) NOT NULL,
  `Colour2` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

Expand  

hi, ja richtig, hab auch das gemacht in DB von nitrado aber funktioniert trotz dem nicht, hast du teamspeak oder discord?

 

Link to comment
Share on other sites

  On 1/21/2018 at 7:27 PM, gelo534 said:

RPT log:

"extDB: Connected to database."

I can park vehicles in the garage, but can not get them out there are no vehicles!

Expand  

in @extDB you have extdb-conf.ini

  Reveal hidden contents

 

Link to comment
Share on other sites

I have this issue that some vehicles and without any difference from other vehis are duplicating in the garage.

Issue happens when someone is storing the vehicle, it results in 2 vehicles. one in the garage and one outside.

Anyone is experiencing this or has a fix?

Link to comment
Share on other sites

  On 1/26/2018 at 3:29 PM, totis said:

I have this issue that some vehicles and without any difference from other vehis are duplicating in the garage.

Issue happens when someone is storing the vehicle, it results in 2 vehicles. one in the garage and one outside.

Anyone is experiencing this or has a fix?

Expand  

Epoch 1.0.6.2 ???

Last version of vgarage ???

Link to comment
Share on other sites

1.0.6.2

the version before salival put all in one package.

i think maybe my issue is at the vg working distance, i still have the old one..

This: Z_VehicleDistance = 40; // Max distance a vehicle can be sold or accessed from at a trader.

goes at custom variables right?

Link to comment
Share on other sites

Just in case im using an old vg i  updated to last one.

Now rpt says connected to db

No errors anywhere on both client and server sides

Says correctly deleted the vehicle when i store it  but theres nothing inside garage.

edit: works now. when creating a new garage table in db it works but if u update it it doesnt for some reason

 

Link to comment
Share on other sites

  On 1/26/2018 at 5:42 PM, totis said:

Just in case im using an old vg i  updated to last one.

Now rpt says connected to db

No errors anywhere on both client and server sides

Says correctly deleted the vehicle when i store it  but theres nothing inside garage.

edit: works now. when creating a new garage table in db it works but if u update it it doesnt for some reason

 

Expand  
/*
	Only use this sql file if you are updating from a previous version.
	Use SQL\virtualGarage.sql if you are starting fresh.
*/
/* Remove comments if you are upgrading from the previous authors version. (i.e TheDuke)
ALTER TABLE `garage` ADD `Name` VARCHAR(50) NOT NULL DEFAULT '' AFTER `PlayerUID`;
ALTER TABLE `garage` ADD `displayName` VARCHAR(50) NOT NULL DEFAULT '' AFTER `Name`;
*/

--UPDATE `garage` SET Inventory = '[[[],[]],[[],[]],[[],[]]]' WHERE Inventory = '[]';

--ALTER TABLE `garage` ADD `DateStored` varchar(10) NOT NULL DEFAULT 'old' AFTER `Datestamp`;

ALTER TABLE `garage` ADD `serverKey` varchar(10) NOT NULL DEFAULT 'old' AFTER `Colour2`;

Above is the updated SQL. NOTE the "remove comments" IF UPGRADING.

I did this mistake, not sure if its the same you might of had.

Link to comment
Share on other sites

It was salivals updated garage i had duke, the version before the ammo checks so those comments must be there as it says.

Without making a new garage table it was not working.

Anw i just did a new one, my players removed their vehis and really was a good chance to clean that up a bit :)

 

Link to comment
Share on other sites

  On 2/1/2018 at 3:59 PM, Schalldampfer said:

I saw some commits to use new HiveExt in Github.
what's going on, and can we install it?

Expand  

I will work on the install guide this weekend but it is actually pretty straight forward.

Basically have to uninstall extDB (if no other mods use it) and replace your current HiveExt.dll with the newest one from the repo.

Thanks to @icomrade for merging it in!

Link to comment
Share on other sites

Crashed server after open garage dialog:

Client RPT

  Reveal hidden contents

and server rpt

  Reveal hidden contents

Any idea?

Link to comment
Share on other sites

  On 2/5/2018 at 5:41 PM, Tanita-Corp said:

Crashed server after open garage dialog:

Client RPT

  Reveal hidden contents

and server rpt

  Reveal hidden contents

Any idea?

Expand  

I had this too after updating, I forget what the exact problem was.

Please make sure you do the following:

  1. Update the SQL database with the provided update file
  2. Update your HiveExt.dll with the provided update file
  3. Update your HiveExt.ini with the provided update file
Link to comment
Share on other sites

its work)))

erorr rpt:

Error in expression <R_VG_MAINTAIN_GARAGE", vg_maintainCost, _itemText];
};
};
vg_init = true;
};

pr>
  Error position: <_itemText];
};
};
vg_init = true;
};

pr>
  Error Undefined variable in expression: _itemtext
File mpmissions\__CUR_MP.Chernarus\custom\virtualGarage\virtualGarage.sqf, line 22

after open garage

And any problem: player can steal other vehicles

any idea?

Link to comment
Share on other sites

  On 2/6/2018 at 6:24 AM, Tanita-Corp said:

its work)))

erorr rpt:

Error in expression <R_VG_MAINTAIN_GARAGE", vg_maintainCost, _itemText];
};
};
vg_init = true;
};

pr>
  Error position: <_itemText];
};
};
vg_init = true;
};

pr>
  Error Undefined variable in expression: _itemtext
File mpmissions\__CUR_MP.Chernarus\custom\virtualGarage\virtualGarage.sqf, line 22

after open garage

And any problem: player can steal other vehicles

any idea?

Expand  

Hi,

about stealing other players vehicles, if i don't mistake, you have to set in custom variables:

vg_tiedToPole = false;

Regards.

Link to comment
Share on other sites

  On 2/6/2018 at 6:24 AM, Tanita-Corp said:

its work)))

erorr rpt:

Error in expression <R_VG_MAINTAIN_GARAGE", vg_maintainCost, _itemText];
};
};
vg_init = true;
};

pr>
  Error position: <_itemText];
};
};
vg_init = true;
};

pr>
  Error Undefined variable in expression: _itemtext
File mpmissions\__CUR_MP.Chernarus\custom\virtualGarage\virtualGarage.sqf, line 22

after open garage

And any problem: player can steal other vehicles

any idea?

Expand  

Oops that error is my fault

 

change line 22 from:

			_vgDisplCtl ctrlSetText format["%1 (free)", localize "STR_VG_MAINTAIN_GARAGE", vg_maintainCost, _itemText];

 

To:

			_vgDisplCtl ctrlSetText format["%1 (free)", localize "STR_VG_MAINTAIN_GARAGE"];

 

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...