Jump to content

[Release] Virtual Garage [Updated for 1.0.7]


salival

Recommended Posts

1 hour ago, 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`;

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

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

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

Just now, 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?

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

2 minutes ago, 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?

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

18 hours ago, kingpapawawa said:

Maybe this?

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

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

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

Maybe this?

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

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

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

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

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

8 minutes ago, 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 :)

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

19 minutes ago, 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 :)

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...
20 minutes ago, 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!

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

2 hours ago, 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... 

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

 

[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

3 minutes ago, 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

 

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

 

[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.
×
×
  • Create New...