Jump to content

[Release] Virtual Garage [Updated for 1.0.7]

salival

By salival
in A2: Epoch Mods

 Share

Recommended Posts

salival Newbie

salival

Posted
  • Author
Posted
  On 7/11/2017 at 5:36 AM, Snowman said:

Hi all, the script works fine, but I had to modify slightly the table in the database. The whole thing again in the russian language. When a variable _displayName enters the vehicle name in english(for example _displayName = GAZ (grey)), then it is processed normally and the transport is written to the database. If the variable _displayName will come the vehicle name with russian letters(for example _displayName = Внедорожник (белый)), then in the database it will not be recorded and will cause an error. 

[13:25:38 +00:-1] [Thread 456002976] extDB: Found extdb-conf.ini
[13:25:38 +00:-1] [Thread 456002976] extDB: Detected 4 Cores, Setting up 4 Worker Threads
[13:25:38 +00:-1] [Thread 456002976] extDB: Database Type: MySQL
[13:25:38 +00:-1] [Thread 456002976] extDB: Database Session Pool Started
[13:25:38 +00:-1] [Thread 456002976] extDB: DB_RAW_V3: Initialized: ADD_QUOTES True
[13:34:31 +00:-1] [Thread 544609928] extDB: DB_RAW_V3: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: Incorrect string value: '\xD0\x92\xD0\xBD\xD0\xB5...' for column 'DisplayName' at row 1	[mysql_stmt_errno]: 1366	[mysql_stmt_sqlstate]: HY000	[statemnt]: INSERT INTO garage (PlayerUID, Name, DisplayName, Classname, CharacterID, Inventory, Hitpoints, Fuel, Damage, Colour, Colour2) VALUES ('76561198225362352','Snow','Внедорожник (белый)','hilux1_civil_3_open_DZE','0','[[["G17_DZ"],[1]],[[],[]],[[],[]]]','[["motor",0.245],["sklo predni P",0.401]]','0.476596','0','0','0')
[13:34:31 +00:-1] [Thread 544609928] extDB: DB_RAW_V3: Error StatementException: SQL: INSERT INTO garage (PlayerUID, Name, DisplayName, Classname, CharacterID, Inventory, Hitpoints, Fuel, Damage, Colour, Colour2) VALUES ('76561198225362352','Snow','Внедорожник (белый)','hilux1_civil_3_open_DZE','0','[[["G17_DZ"],[1]],[[],[]],[[],[]]]','[["motor",0.245],["sklo predni P",0.401]]','0.476596','0','0','0')
[13:35:55 +00:-1] [Thread 456002976] extDB: Stopping ...

A solution to this problem is to change the encoding in the table from latin1_swedish_ci to utf8_general_ci. Here is an example SQL query to the database:

ALTER TABLE `garage` ADD `displayName` VARCHAR(50) CHARACTER SET utf8 NOT NULL DEFAULT '' AFTER `Name`;

Expand  

Hi @Snowman,

Thanks for your reply, It's difficult for me to foresee issues with languages since i'm english only but I appreciate your reply.

I've researched this a bit since your message and you are correct, utf8 is the way to go for multi language environments. 

I'll push a commit with changes to default the SQL to utf8 and convert the upgraded database to utf8

*edit* here's the commit: https://github.com/oiad/virtualGarage/commit/d62cf9ce7fc5557643e27a98a470d466a8733cec

Link to comment
Share on other sites
  • Replies 255
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

salival
salival

Virtual Garage is part of Epoch 1.0.7.1 now. Hi guys, Here's my version of Virtual Garage, it's not far off a full rewrite but includes some of the original code that the original author con

salival
salival

Hi guys, Just pushed an update for Virtual Garage to remove vehicle ammo on spawn, heres the blurb: This is quite a requested feature since players are abusing the garage to get free rearms.

salival
salival

Hi guys, I fixed the issues listed on gitHub / mentioned to me, thanks to @DieTanx @azzdayz and @BigEgg for the heads up. Fix traders not working as a garage: https://github.com/oiad/virtual

Posted Images

salival Newbie

salival

Posted
  • Author
Posted

For admins that have been running older Virtual Garage mods with the Heli pads, were you modifying the epoch SQL events etc for any particular reason? I added my HeliHCivil to the maintain variable so it gets maintained and I don't have to worry about it dissapearing.

I've also added it to the function for checking keys in object inventory for removing/unlocking vehicles with no keys

thoughts?

Link to comment
Share on other sites
azzdayz Newbie

azzdayz

Posted
Posted

Hey so i know in the instructions it says to add 2800 if you have infiSTAR and all that good stuff, but I am testing this on my account that I am not an Admin on and the scroll menu does not want to stay open. I walk up to it and it pops up fine the first time so far and then after that you have to try and find the exact sweet spot to get it.

I disable InfiSTAR and the menu comes up no problem and I can approach every time no issues. Is there possibility something else that needs added in the infiSTAR config?

I am thinking I need something in _cMenu =, but not sure what?

Link to comment
Share on other sites
salival Newbie

salival

Posted
  • Author
Posted
  On 7/13/2017 at 2:42 AM, azzdayz said:

Hey so i know in the instructions it says to add 2800 if you have infiSTAR and all that good stuff, but I am testing this on my account that I am not an Admin on and the scroll menu does not want to stay open. I walk up to it and it pops up fine the first time so far and then after that you have to try and find the exact sweet spot to get it.

I disable InfiSTAR and the menu comes up no problem and I can approach every time no issues. Is there possibility something else that needs added in the infiSTAR config?

I am thinking I need something in _cMenu =, but not sure what?

Expand  

I am at work for another few hours (2:42 pm Thursday) but from what I remember that's all you need to change, can you pastebin your ahconfig and message me it via.pm?

Link to comment
Share on other sites
azzdayz Newbie

azzdayz

Posted
Posted
  On 7/13/2017 at 2:44 AM, salival said:

I am at work for another few hours (2:42 pm Thursday) but from what I remember that's all you need to change, can you pastebin your ahconfig and message me it via.pm?

Expand  

Sure I can do that. No rush, I am a small server so I doubt I will have any players notice the issue any time soon :)

Link to comment
Share on other sites
azzdayz Newbie

azzdayz

Posted
Posted
  On 7/13/2017 at 4:34 AM, kingpapawawa said:

Maybe this?

/*  Check Actions ?       */ _CSA = false;    /* true or false */    /* this checks mousewheel actions */

Expand  

Good call, I should have thought of that. I have mine set to true and if it is set to true then every new self action you add you have to add to the list. So just for anyone else that this might have slipped their mind on.

If _CSA = true then and "s_garage_dialog" to _dayzActions = in InfiSTAR

That's a Duh moment on my part, thinks guys :)

Link to comment
Share on other sites
salival Newbie

salival

Posted
  • Author
Posted
  On 7/13/2017 at 4:34 AM, kingpapawawa said:

Maybe this?

/*  Check Actions ?       */ _CSA = false;    /* true or false */    /* this checks mousewheel actions */

Expand  

I've updated information in my install notes referencing this, cheers! https://github.com/oiad/virtualGarage/commit/d512ede551a6c07a6fe65ad55ebbb603ab1ad503

Link to comment
Share on other sites
azzdayz Newbie

azzdayz

Posted
Posted
  On 7/14/2017 at 5:39 AM, salival said:

I've updated information in my install notes referencing this, cheers! https://github.com/oiad/virtualGarage/commit/d512ede551a6c07a6fe65ad55ebbb603ab1ad503

Expand  

Hey Salival, when you get some time I am hoping you can verify something for me. When I go to put the 350z_Mod into the garage it doesn't write. It does it to select 350z's. I haven't had a chance to test them all or a lot of other vehicles, but I know for a fact the 350z_Mod is not writing. It does not save in the database and it does not show any errors in the RTP's, client or server side.

Would you or someone else try putting a 350z_Mod in their garage and let me know if it is just me or if maybe we have found a little bug? Thanks :)

Link to comment
Share on other sites
salival Newbie

salival

Posted
  • Author
Posted
  On 7/16/2017 at 4:22 AM, azzdayz said:

Hey Salival, when you get some time I am hoping you can verify something for me. When I go to put the 350z_Mod into the garage it doesn't write. It does it to select 350z's. I haven't had a chance to test them all or a lot of other vehicles, but I know for a fact the 350z_Mod is not writing. It does not save in the database and it does not show any errors in the RTP's, client or server side.

Would you or someone else try putting a 350z_Mod in their garage and let me know if it is just me or if maybe we have found a little bug? Thanks :)

Expand  

It is a little bug, it's the ' in the display name: "Nissan 350z (Emery's Car)" that's causing it.

I'll write a fix tonight and commit something.

 

Cheers for the headsup!

Link to comment
Share on other sites
kingpapawawa Newbie

kingpapawawa

Posted
Posted
  On 7/16/2017 at 4:22 AM, azzdayz said:

Hey Salival, when you get some time I am hoping you can verify something for me. When I go to put the 350z_Mod into the garage it doesn't write. It does it to select 350z's. I haven't had a chance to test them all or a lot of other vehicles, but I know for a fact the 350z_Mod is not writing. It does not save in the database and it does not show any errors in the RTP's, client or server side.

Would you or someone else try putting a 350z_Mod in their garage and let me know if it is just me or if maybe we have found a little bug? Thanks :)

Expand  

I tried all of them. _mod and _ruben do not work

 0:36:15 "GARAGE: kpw (*****) stored 350z_mod @062075 [6253.35,7831.5,0.00152588]"
 0:37:30 "GARAGE: kpw (*****) stored 350z_ruben @062075 [6274.04,7847.73,0.00143433]"

Link to comment
Share on other sites
  • 3 weeks later...
kingpapawawa Newbie

kingpapawawa

Posted
Posted
  On 7/31/2017 at 3:47 PM, JakeQue said:

Hi mate, this has completely broken my virtual garage. I removed like specified, added the new one and I just keep getting "searching for vehicle".

 

There's nothing in the client / server RPT.

 

Please help!

Expand  

did you readd the extdb? I replaced the extdb i had with the onefrom salivals github and it corrected this.  He told me he didnt edit the dll but for some reason my install didnt like the previous one...

Link to comment
Share on other sites
salival Newbie

salival

Posted
  • Author
Posted
  On 8/1/2017 at 4:16 PM, JakeQue said:

I changed everything as specified mate and it still won't work.. Can't get my old one working now either, searching for vehicle still... 

Expand  

As per what @kingpapawawa mentioned it has to be a problem with extdb.

Either you havent made the changes in server_functions.sqf

extDB config is wrong

you haven't added @extDB on the command line

in @extDB\extDB\logs\<year>\<month number>\<day number> there will be logs relating to the extDB connection, it may tell you what the problem is, like this post here: 

 

Link to comment
Share on other sites
JakeQue Newbie

JakeQue

Posted
Posted

  

[02:28:21 +00:-1] [Thread 2707224945] extDB: Found extdb-conf.ini
[02:28:21 +00:-1] [Thread 2707224945] extDB: Detected 8 Cores, Setting up 6 Worker Threads
[02:28:21 +00:-1] [Thread 2707224945] extDB: Database Type: SQLite
[02:28:21 +00:-1] [Thread 2707224945] extDB: Database Exception Error: Connection attempt failed: Unable to open the database file: Unable to open the database file
[02:28:22 +00:-1] [Thread 2707224945] extDB: DB_RAW_V3: No Database Connection
[02:28:22 +00:-1] [Thread 2707224945] extDB: Failed to Load Protocol

 

Link to comment
Share on other sites
salival Newbie

salival

Posted
  • Author
Posted
  On 8/1/2017 at 10:41 PM, JakeQue said:

  

[02:28:21 +00:-1] [Thread 2707224945] extDB: Found extdb-conf.ini
[02:28:21 +00:-1] [Thread 2707224945] extDB: Detected 8 Cores, Setting up 6 Worker Threads
[02:28:21 +00:-1] [Thread 2707224945] extDB: Database Type: SQLite
[02:28:21 +00:-1] [Thread 2707224945] extDB: Database Exception Error: Connection attempt failed: Unable to open the database file: Unable to open the database file
[02:28:22 +00:-1] [Thread 2707224945] extDB: DB_RAW_V3: No Database Connection
[02:28:22 +00:-1] [Thread 2707224945] extDB: Failed to Load Protocol

 

Expand  

I removed sqllite support from the extdb config so I'm guessing you have not updated your https://github.com/oiad/virtualGarage/blob/master/%40extDB/extdb-conf.ini

Also make sure this line: https://github.com/oiad/virtualGarage/blob/master/dayz_server/init/server_functions.sqf#L49 is correct in your server functions.

The original used database2 which pointed to the database2 field in extdb, database was the sqllite database which leads me to believe you have not updated the config file.

Link to comment
Share on other sites
JakeQue Newbie

JakeQue

Posted
Posted

  

[00:33:45 +00:-1] [Thread 4215961441] extDB: Found extdb-conf.ini
[00:33:45 +00:-1] [Thread 4215961441] extDB: Detected 8 Cores, Setting up 6 Worker Threads
[00:33:45 +00:-1] [Thread 4215961441] extDB: Database Type: MySQL
[00:33:45 +00:-1] [Thread 4215961441] extDB: Database Session Pool Started
[00:33:45 +00:-1] [Thread 4215961441] extDB: DB_RAW_V3: Initialized: ADD_QUOTES True

But still searching for vehicle...

Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to topic listing
  • Advertisement

  • Discord

×
×
  • Create New...