[Tool]Cusom Vehicle Spawns

System.InvalidCastException: Приведение строки "0.25765705" к типу "Integer" является недопустимым. ---> System.FormatException: Входная строка имела неверный формат.
в Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value, NumberFormatInfo NumberFormat)
в Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value)
--- Конец трассировки внутреннего стека исключений ---
в Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value)
в DayZ___Vehicle_Spawner.Form2.ReadSQF(String Path)
в DayZ___Vehicle_Spawner.Form2.OpenSQF()
в DayZ___Vehicle_Spawner.Form2.BcButton1_Click(Object sender, EventArgs e)
в System.Windows.Forms.Control.OnClick(EventArgs e)
в System.Windows.Forms.Button.OnClick(EventArgs e)
в DayZ___Vehicle_Spawner.BcButton.OnClick(EventArgs e)
в System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
в DayZ___Vehicle_Spawner.BcButton.OnMouseUp(MouseEventArgs e)
в System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
в System.Windows.Forms.Control.WndProc(Message& m)
в System.Windows.Forms.ButtonBase.WndProc(Message& m)
в System.Windows.Forms.Button.WndProc(Message& m)
в System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
в System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
в System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Загруженные сборки **************
mscorlib
Версия сборки: 2.0.0.0
Версия Win32: 2.0.50727.5466 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
DayZ - Vehicle Spawner
Версия сборки: 1.2.1.0
Версия Win32: 1.2.1.0
CodeBase: file:///C:/Users/CraftLourens/Desktop/Server/DayZ%20-%20Vehicle%20Spawner.exe
----------------------------------------
Microsoft.VisualBasic
Версия сборки: 8.0.0.0
Версия Win32: 8.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System.Windows.Forms
Версия сборки: 2.0.0.0
Версия Win32: 2.0.50727.5468 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Версия сборки: 2.0.0.0
Версия Win32: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Версия сборки: 2.0.0.0
Версия Win32: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
Версия сборки: 2.0.0.0
Версия Win32: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Configuration
Версия сборки: 2.0.0.0
Версия Win32: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Версия сборки: 2.0.0.0
Версия Win32: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
mscorlib.resources
Версия сборки: 2.0.0.0
Версия Win32: 2.0.50727.5466 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
INILib
Версия сборки: 1.0.0.0
Версия Win32: 1.0.0.0
CodeBase: file:///C:/Users/CraftLourens/Desktop/Server/INILib.DLL
----------------------------------------
Devart.Data.MySql
Версия сборки: 7.6.217.0
Версия Win32: 7.6.217.0
CodeBase: file:///C:/Users/CraftLourens/Desktop/Server/Devart.Data.MySql.DLL
----------------------------------------
System.Data
Версия сборки: 2.0.0.0
Версия Win32: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Версия сборки: 2.0.0.0
Версия Win32: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Devart.Data
Версия сборки: 5.0.676.0
Версия Win32: 5.0.676.0
CodeBase: file:///C:/Users/CraftLourens/Desktop/Server/Devart.Data.DLL
----------------------------------------
Accessibility
Версия сборки: 2.0.0.0
Версия Win32: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.EnterpriseServices
Версия сборки: 2.0.0.0
Версия Win32: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
System.Core
Версия сборки: 3.5.0.0
Версия Win32: 3.5.30729.5420 built by: Win7SP1
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
Microsoft.VisualBasic.resources
Версия сборки: 8.0.0.0
Версия Win32: 8.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualBasic.resources/8.0.0.0_ru_b03f5f7f11d50a3a/Microsoft.VisualBasic.resources.dll
----------------------------------------
System.Windows.Forms.resources
Версия сборки: 2.0.0.0
Версия Win32: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms.resources/2.0.0.0_ru_b77a5c561934e089/System.Windows.Forms.resources.dll
 

Raitaa

New Member
Hello guys... I want to ask here for help because i have that error when trying to connect to database : Host next.home is not allowed to connect to this MySQL server. BTW. Im using server files for dayz 1.7.1 from this site. Please help me someone because i badly need to spawn some vechicles
 

Gweincalar

New Member
Hello guys... I want to ask here for help because i have that error when trying to connect to database : Host next.home is not allowed to connect to this MySQL server. BTW. Im using server files for dayz 1.7.1 from this site. Please help me someone because i badly need to spawn some vechicles


Does your MySQL server allow external connections? Many servers are restricted to local access for security reasons.
 

jukki

New Member
Few problems i have been having. It canont use the setDir value since it is not Integer and i have to manuly delete the decimals from them in order to get it working. Also when importing vehicles that are not in database i get incorrect decimal value '0,1' for colum 'damage_min' at row 1. I basicaly have to manualy add every vehicle tovehicle tab wich is time consuming. (I am using custom vehicle pack so the cars are not in the vehicles tab by default).

Any possible fix for this?
 

justchil

Well-Known Member
Very useful. I have a few comments but need to post while using it lol. Also wish I could pull from db to map editor... I have about 400 I added that I'd like to edit in 3d :x
 

Gweincalar

New Member
Very useful. I have a few comments but need to post while using it lol. Also wish I could pull from db to map editor... I have about 400 I added that I'd like to edit in 3d :x


Never thought about pulling from db to map editor but it sounds like a great idea. I just made a little update to include this feature, however after you've edited your mission and saved it again, you first have to delete your current vehicles from the database, otherwise you will have 2 vehicles at the same spot, stuck in each other.

If you clear the tables "world_vehicle" and "instance_vehicle" you should be fine.
 

jukki

New Member
Nice that is quite usefull feature, however is there any fix for my 2 issues, quite frankly i dont feel like manuely fixing all car entries XD
 

Gweincalar

New Member
Nice that is quite usefull feature, however is there any fix for my 2 issues, quite frankly i dont feel like manuely fixing all car entries XD

Well theres a function build in, if you try to import vehicles that are not in your vehicles table by default.

During your import you should get a message saying:
"X vehicles have been removed from the list since they didn't exist in your vehicles table.\nDo you want to view a list of the vehicles that have been removed?"

If you press yes, you can see a list where you can also set the default values for not imported vehicles and then, add them to your vehicles table. After that you just have to restart the tool using the restart button and you should be able to import all vehicles.
 

vaevictis

New Member
The export from database isn't working for me (newest version).

I get an Unhandled Exception error and then a beidi file on my desktop with a size of 0 bytes.

I copied the error details onto pastebin. I'll pm you the link.
 

Gweincalar

New Member
The export from database isn't working for me (newest version).

I get an Unhandled Exception error and then a beidi file on my desktop with a size of 0 bytes.

I copied the error details onto pastebin. I'll pm you the link.

What did you do exactly to get this error. I've tried to replicate it on 5 different PCs and never got a error message.
 

jukki

New Member
Well theres a function build in, if you try to import vehicles that are not in your vehicles table by default.

During your import you should get a message saying:
"X vehicles have been removed from the list since they didn't exist in your vehicles table.\nDo you want to view a list of the vehicles that have been removed?"

If you press yes, you can see a list where you can also set the default values for not imported vehicles and then, add them to your vehicles table. After that you just have to restart the tool using the restart button and you should be able to import all vehicles.

Yes i am aware of this ;) But it doesnt work for me, first of all i get some wierd windows errro when i load the sqf file because the program doesnt seem to be able to load decimetric value of the setdir.

The second problem that i have is when the thing you just described is supose to happen. I do get to that part, but when i try to import the entries i get error "incorrect decimal value '0,1' for colum 'damage_min' at row 1."
 

vaevictis

New Member
It's when it asks me to save the file into a location. I hit save and bam up comes that error everytime.

I've tried running as admin and without same problem each time.
 

Gweincalar

New Member
Yes i am aware of this ;) But it doesnt work for me, first of all i get some wierd windows errro when i load the sqf file because the program doesnt seem to be able to load decimetric value of the setdir.

The second problem that i have is when the thing you just described is supose to happen. I do get to that part, but when i try to import the entries i get error "incorrect decimal value '0,1' for colum 'damage_min' at row 1."

Ok i could replicate your sql error. Try changing your decimal separator from a "," comma to a "." dot. You can do this under your regional settings in windows.



It's when it asks me to save the file into a location. I hit save and bam up comes that error everytime.

I've tried running as admin and without same problem each time.
I'm going to look for a solution. However i can't replicate your error atm. I will message you if i find a solution for it.
 

veX

Member
glad I checked if someone else already coded a tool like this, I was almost gonna do it myself ;)
works great thy!
 

Mucka

New Member
OMG i just found this program and i hope it still works?

Ive put a few vehicles down in the map editor and when i tried to add them to the server i got an error saying...

"Cannot add or update a child row: a foreign key constraint fails ('bliss_0000'.'instance_vehicle', CONSTRAINT 'instance_vehicle_ibfk_1' FOREIGN KEY ('instance_is') REFERENCES 'instance' ('is'))"

Do i run the map editor on by starting DayZ Beta, Arma 2 or Arma 2: OA? (I use steam)

Would love it if someone could help on the error above as i would like to add buildings to the map to :)

Thanks
 

Gweincalar

New Member
OMG i just found this program and i hope it still works?
Ive put a few vehicles down in the map editor and when i tried to add them to the server i got an error saying...
"Cannot add or update a child row: a foreign key constraint fails ('bliss_0000'.'instance_vehicle', CONSTRAINT 'instance_vehicle_ibfk_1' FOREIGN KEY ('instance_is') REFERENCES 'instance' ('is'))"
Do i run the map editor on by starting DayZ Beta, Arma 2 or Arma 2: OA? (I use steam)
Would love it if someone could help on the error above as i would like to add buildings to the map to :)
Thanks

It seems like you're using a Bliss Server / Database. Since I've never used a bliss package i don't know if it has the same database structure like reality. I think i will search for an Bliss Database so i can see if it's the database or my tool.

Also you can run the map editor if you run your DayZ or Arma2 and press ALT+E in the main menu.
 

indepth

Member
You guys having error with "decimal something" you need to set your PC location to usa to have "," and not "." for digit separator.
 

rosska85

Valued Member!
Great program, much easier than my old method of doing this. However, I'm running into a slight problem (probably something I'm doing wrong) some of the things I place are moving when added to the database. For instance, I have a bandit camp set up and have placed walls around it. When in the DB the game shows half of them overlapping each other and some of them not even remotely where they should be.

Could anybody please point me in the direction of my error so I can fix it? :)
 
Top