[Release] Dayz.Epoch.3d.Editor.Live.Mission.With.Database.Interaction

Sandbird · May 18, 2014

Oy.
Do markers work in this?
I noticed that nothing shows on the map, I mean traders aren't marked.

I couldnt make markers work....They do show if you add them manually...but they dont when the missions starts.

I never figured out why.

Bambit · May 18, 2014

Okay :D

I'm trying to make an uber trader to spawn randomly around the map :D
Good luck for me finding him :D

Well actually it doesn't really matter :D
I'm gonna make a static one, see if he sells what I want and then copy paste what I need, and voilla

Sandbird · May 18, 2014

Okay :D
I'm trying to make an uber trader to spawn randomly around the map :D
Good luck for me finding him :D

You can do this:

Add this function where your trader script is:

_makeMarker = {
	private ["_pos","_type","_color","_size","_idx","_marker"];
	_pos = _this select 0;
	_type = _this select 1;
	_color = _this select 2;
	_size = _this select 3;
	_text = _this select 4;
	_idx = _this select 5;
	
	_marker = format["mrk_%1",_idx];
	_marker = createMarker [_marker,_pos];
	_marker setMarkerShape "ICON";
	_marker setMarkerType _type;
	_marker setMarkerColor _color;
	_marker setMarkerSize [_size,_size];	
	if (_text!="") then {
		_marker setMarkerText _text;
	};
	_idx = _idx + 1;
	_idx
};

And after you 'make the trader put this bellow:

_pos = getPos _trader;  // The trader object
_idx = [_pos,"START","ColorBlue",1,"",_idx] call _makeMarker;

This will create a blue marker on the map...all you have to do is press M to see it.

Now to go there....while the mission is running is a lol situation...you cant.ahaha. hmm, you'd have to install AdminTools or something to Teleport there...or just write a function that moves the player to the trader after X seconds

Bambit · May 19, 2014

You are a man with answers, and I am a man with problems.

I have created an uber trader. Available for players over 50k of humanity with everything there is on infistar database. I have created him according to tutorials, changed tids, added proper tables in my DB etc etc.

I remembered to change class of items accordingly (1-magazines, 2-vehicles, 3-weapons)
Added 'uber-hero' class to fn_selfActions etc etc.

I have mags and gemstones at this trader and I can buy them no problem.
But can;t somehow buy anything else.
I thought it was maybe due to the OP and possibly-banned objects, that's why I added med hmmvv, but it also gives my this cfg error.

But each time I try to buy a vehicle or weapon I get this:

Warning Message: No entry 'bin\config.bin/CfgMagazines.M1A1_US_DES_EP1'.

Warning Message: No entry '.picture'.

Warning Message: '/' is not a value

Warning Message: No entry '.scope'.

Warning Message: '/' is not a value

Warning Message: Error: creating magazine M1A1_US_DES_EP1 with scope=private

Warning Message: No entry '.displayName'.

Warning Message: '/' is not a value

Warning Message: No entry '.displayNameShort'.

Warning Message: '/' is not a value

Warning Message: No entry '.nameSound'.

Warning Message: '/' is not a value

Warning Message: No entry '.Library'.

Warning Message: No entry '.libTextDesc'.

Warning Message: '/' is not a value

Warning Message: No entry '.type'.

Warning Message: '/' is not a value

Warning Message: No entry '.count'.

Warning Message: '/' is not a value

Warning Message: No entry '.maxLeadSpeed'.

Warning Message: '/' is not a value

Warning Message: No entry '.initSpeed'.

Warning Message: '/' is not a value

Warning Message: No entry '.reloadAction'.

Warning Message: '/' is not a value

Warning Message: No entry '.modelSpecial'.

Warning Message: '/' is not a value

Warning Message: No entry '.ammo'.

Warning Message: '/' is not a value

No owner

No owner

Warning Message: No entry 'bin\config.bin/CfgMagazines.HMMWV_Ambulance'.

Warning Message: No entry '.picture'.

Warning Message: '/' is not a value

Warning Message: No entry '.scope'.

Warning Message: '/' is not a value

Warning Message: Error: creating magazine HMMWV_Ambulance with scope=private

Warning Message: No entry '.displayName'.

Warning Message: '/' is not a value

Warning Message: No entry '.displayNameShort'.

Warning Message: '/' is not a value

Warning Message: No entry '.nameSound'.

Warning Message: '/' is not a value

Warning Message: No entry '.Library'.

Warning Message: No entry '.libTextDesc'.

Warning Message: '/' is not a value

Warning Message: No entry '.type'.

Warning Message: '/' is not a value

Warning Message: No entry '.count'.

Warning Message: '/' is not a value

Warning Message: No entry '.maxLeadSpeed'.

Warning Message: '/' is not a value

Warning Message: No entry '.initSpeed'.

Warning Message: '/' is not a value

Warning Message: No entry '.reloadAction'.

Warning Message: '/' is not a value

Warning Message: No entry '.modelSpecial'.

Warning Message: '/' is not a value

Warning Message: No entry '.ammo'.

Warning Message: '/' is not a value

No owner

No owner

Warning Message: No entry 'bin\config.bin/CfgMagazines.M249_m145_EP1'.

Warning Message: No entry '.picture'.

Warning Message: '/' is not a value

Warning Message: No entry '.scope'.

Warning Message: '/' is not a value

Warning Message: Error: creating magazine M249_m145_EP1 with scope=private

Warning Message: No entry '.displayName'.

Warning Message: '/' is not a value

Warning Message: No entry '.displayNameShort'.

Warning Message: '/' is not a value

Warning Message: No entry '.nameSound'.

Warning Message: '/' is not a value

Warning Message: No entry '.Library'.

Warning Message: No entry '.libTextDesc'.

Warning Message: '/' is not a value

Warning Message: No entry '.type'.

Warning Message: '/' is not a value

Warning Message: No entry '.count'.

Warning Message: '/' is not a value

Warning Message: No entry '.maxLeadSpeed'.

Warning Message: '/' is not a value

Warning Message: No entry '.initSpeed'.

Warning Message: '/' is not a value

Warning Message: No entry '.reloadAction'.

Warning Message: '/' is not a value

Warning Message: No entry '.modelSpecial'.

Warning Message: '/' is not a value

Warning Message: No entry '.ammo'.

Warning Message: '/' is not a value

No owner

No owner

Sandbird · May 19, 2014

Hmmm from the looks of it, i think you are populating the list with wrong indexes, but i am not sure.. I havent really tweaked trader list before..only from the database. Just added the trader in the server_traders.sqf, then added tge trader based on his skin in traders_tid table and then finally the traders_data tables, i added the items. Not sure how to help here :/

Bambit · May 19, 2014

Thanks anyway :)
I thought that it might be caused by some tweaks you made in your live editor :D

Bambit · May 19, 2014

Ok.

I fixed my problem. Found out that I also needed to change afile row in my database *.sql file (none of the tutorials mentioned that)

But I don't think traders work as they're supposed to work :D
Whenever I buy a car I doesn't spawn :D

I guess I fckd something up, but I didn't mess with anything else, aside from changing to my UID.

RPT

"PUBLISH: Attempt [55b11600# 1058435: arrow_down_large_ep1.p3d,[250,[6389.76,7753.36,0.0118103]],"HMMWV_Ambulance",false,"ItemKeyBlue2048",B 1-1-B:1 (Christopher Taylor)]"

"HIVE: WRITE: "insert into object_data (ObjectUID, Instance, Classname, CharacterID, Worldspace, Inventory, Hitpoints, Fuel, Damage) values ('any','11','<null>','any','<null>','[]','[]','1','0')""

Error in expression <ace = _this select 1;

_class = _this select 2;

_donotusekey = _this select 3;>

Error position: <select 2;

_donotusekey = _this select 3;>

Error Zero divisor

File C:\Users\Drwal\Documents\ArmA 2 Other Profiles\RobRoy\missions\3d.live.DayzEpochTemplate.Chernarus\dayz_server\compile\server_publishVehicle2.sqf, line 5

"HIVE: WRITE: "SELECT ObjectID FROM object_data WHERE ObjectUID = 'any'""

"HIVE: WRITE: "SELECT ObjectID FROM object_data WHERE ObjectUID = 'any'""

"HIVE: WRITE: "SELECT ObjectID FROM object_data WHERE ObjectUID = 'any'""

"HIVE: WRITE: "SELECT ObjectID FROM object_data WHERE ObjectUID = 'any'""

Sandbird · May 20, 2014

Ok.
I fixed my problem. Found out that I also needed to change afile row in my database *.sql file (none of the tutorials mentioned that)
But I don't think traders work as they're supposed to work :D
Whenever I buy a car I doesn't spawn :D
I guess I fckd something up, but I didn't mess with anything else, aside from changing to my UID.
RPT

"PUBLISH: Attempt [55b11600# 1058435: arrow_down_large_ep1.p3d,[250,[6389.76,7753.36,0.0118103]],"HMMWV_Ambulance",false,"ItemKeyBlue2048",B 1-1-B:1 (Christopher Taylor)]"

"HIVE: WRITE: "insert into object_data (ObjectUID, Instance, Classname, CharacterID, Worldspace, Inventory, Hitpoints, Fuel, Damage) values ('any','11','<null>','any','<null>','[]','[]','1','0')""

Error in expression <ace = _this select 1;

_class = _this select 2;

_donotusekey = _this select 3;>

Error position: <select 2;

_donotusekey = _this select 3;>

Error Zero divisor

File C:\Users\Drwal\Documents\ArmA 2 Other Profiles\RobRoy\missions\3d.live.DayzEpochTemplate.Chernarus\dayz_server\compile\server_publishVehicle2.sqf, line 5

"HIVE: WRITE: "SELECT ObjectID FROM object_data WHERE ObjectUID = 'any'""

"HIVE: WRITE: "SELECT ObjectID FROM object_data WHERE ObjectUID = 'any'""

"HIVE: WRITE: "SELECT ObjectID FROM object_data WHERE ObjectUID = 'any'""

"HIVE: WRITE: "SELECT ObjectID FROM object_data WHERE ObjectUID = 'any'""

hmm i dont think its 'grabbing' the cursortarget or the object that you are making..as you can see the array it send to the datbase has lots of values missing...thats why it says <any>...those values are missing.

I guess you publishing the vehicle wrong

The publish command does something similar to this

PVDZE_veh_Publish2 = [_veh,[_dir,_location],_vehtospawn,false,_keySelected,_activatingPlayer, _vehdbID];
[PVDZE_veh_Publish2] spawn server_publishVeh2;

To make sure you are doing it correctly you have to make sure your 1st value there (_veh) is actually an object.

Change your 'spawn' vehicle script and do

diag_log format["MY OBJECT IS: %1",_veh];

until you actually see a vehicle object there...then you are getting the vehicle you want...

I dont know what type of code you are writing to help more :/

RimBlock · May 20, 2014

Run the Arma2NetExplorer.exe located here: \arma 2 operation arrowhead\@Arma2NET\

And in the query box bellow add this: and press Enter
Arma2NETMySQLCommand ['dayz_epoch',"SELECT ObjectUID from Object_DATA where ObjectID= '1'"]
where dayz_epoch is the name of your database

and ObjectUID is just an id of a row that exists in the db.

If you see something like: [[["72916056071"]]] then everything is working fine.

If you see something like: False then probably you are querying the wrong database

if you see something like: throw "System.Reflection.TargetInvocationException" then go to folder C:\Users\xxxxxxx\AppData\Local\Arma2NET and check the log.

You probably dont have the Database.txt where it should be or the file is not Read only, or you dont have privileges as a user to read the file or something weird like that.

The Arma2NetExplorer.exe does start up for me but without knowing the commands I was not able to go any further with it.

WIll give that a go tonight. Thanks.

Sandbird · May 20, 2014

Dude i gave the command. Just put your databse name instead of dayz_epoch...

Bambit · May 20, 2014

hmm i dont think its 'grabbing' the cursortarget or the object that you are making..as you can see the array it send to the datbase has lots of values missing...thats why it says <any>...those values are missing.

I guess you publishing the vehicle wrong

The publish command does something similar to this
PVDZE_veh_Publish2 = [_veh,[_dir,_location],_vehtospawn,false,_keySelected,_activatingPlayer, _vehdbID];
[PVDZE_veh_Publish2] spawn server_publishVeh2;
To make sure you are doing it correctly you have to make sure your 1st value there (_veh) is actually an object.

Change your 'spawn' vehicle script and do
diag_log format["MY OBJECT IS: %1",_veh];
until you actually see a vehicle object there...then you are getting the vehicle you want...

I dont know what type of code you are writing to help more :/

I'm not writing any code. Should I write something for epoch traders to spawn vehicles? I'm using your editor and traders that are in it.

I go to a vehicle trader in Stary. I try to buy any car. The animation is played, the money disappears, after that this red arrow appears and that's it. Nothing spawns on the arrow. And the RPT gives me what I posted above.

I'm not sure if I should write anything for default traders. I thought they have their own spawn script.

Sandbird · May 20, 2014

I'm not writing any code. Should I write something for epoch traders to spawn vehicles? I'm using your editor and traders that are in it.
I go to a vehicle trader in Stary. I try to buy any car. The animation is played, the money disappears, after that this red arrow appears and that's it. Nothing spawns on the arrow. And the RPT gives me what I posted above.
I'm not sure if I should write anything for default traders. I thought they have their own spawn script.

I just tried to buy a car in Stary as well...and it worked fine with me...the car spawned and i got the key...

Is it possible you messed up the database somehow?

Bambit · May 20, 2014

I might, but not sure how.

I'm gonna reinstall everything and see if it works out-of-the-box.
If it works then I'm gonna redo all steps and try to trace the fail :)

Sandbird · May 20, 2014

I might, but not sure how.
I'm gonna reinstall everything and see if it works out-of-the-box.
If it works then I'm gonna redo all steps and try to trace the fail :)

You dont have to re-install everything, just Truncate and re-install these tables:

traders_data

trader_tids

server_traders

trader_items <---not sure why i have this one...you probably dont....but i see that its not used anymore...so dont worry.

RimBlock · May 20, 2014

Dude i gave the command. Just put your databse name instead of dayz_epoch...

I said was not as in past tense. Now you have provided the command I will try tonight.

Thanks.

Bambit · May 20, 2014

Ok.

So I did a fresh install of everything. Fresh DB install, fresh editor and all files. Didn't change anything, just started a mission.
Spawning vehicles with traders doesn't work. I lose gold, I get the key, but the vehicle doesn't spawn.

I started a private server just to see if it's something with my DB, but it works on dedi, so I guess it's something inside the live mission (?). I have no idea

Sandbird · May 20, 2014

Ok.
So I did a fresh install of everything. Fresh DB install, fresh editor and all files. Didn't change anything, just started a mission.
Spawning vehicles with traders doesn't work. I lose gold, I get the key, but the vehicle doesn't spawn.
I started a private server just to see if it's something with my DB, but it works on dedi, so I guess it's something inside the live mission (?). I have no idea

hmm i'll have a look, see if i can replicated the bug.

You used the latest SQL from the latest files right ?

Bambit · May 20, 2014

Yup (plus I ran "add_recommended_mysql_events" and "1.0.4.2a_Updates")

Also added all the updates you posted in this thread.

All in all, if I buy a vehicle on my LAN server it spawns, if I buy it in your editor, it doesn't :P

It's not such a big deal, i'll do everything and check everything I can in your editor and then place it on my LAN server to double check,

Sandbird · May 20, 2014

Yup (plus I ran "add_recommended_mysql_events" and "1.0.4.2a_Updates")

Also added all the updates you posted in this thread.
All in all, if I buy a vehicle on my LAN server it spawns, if I buy it in your editor, it doesn't :P
It's not such a big deal, i'll do everything and check everything I can in your editor and then place it on my LAN server to double check,

You were right...There was a bug...I am uploading a fix now to the github.

Just redownload the files and when do replace the following in the editor mission :

\dayz_server\compile\server_publishVehicle2.sqf

\dayz_code\actions\trader\ <--- Delete the old trader folder replace with new one

Sandbird · May 20, 2014

Update 20-5-14:

Fixed traders not spawning vehicles.

- Redownload github master file

- Replace:

\dayz_server\compile\server_publishVehicle2.sqf
\dayz_code\actions\trader\   <--- Delete the old trader folder replace with new one

Bambit · May 20, 2014

Heh :D

Glad I could contribute somehow to this great addition :)

Sorry I was so pain-in-the-butt-ish with all the problems that I had :P

But that's the cruel side of developing something epic, you simply gotta help those, who just don't have a clue on how this works.

Bambit · May 20, 2014

Me again :P

Well... have you tried selling vehicles in your editor?

They don't despawn and you don't get any gold :D

RPT seems okay

"DEBUG vehicle sell count: 1"
"DEBUG vehicle sell objects: [43180100# 1056185: m997a2_ambulance.p3d]"
"EPOCH SERVERTRADE: Player: RobRoy (111111) sold a HMMWV_Ambulance in/at Unknown Trader City for 2x ItemGoldBar10oz"
"HIVE: WRITE: "UPDATE Traders_DATA SET qty = qty + 1 WHERE id= '6092'""

Sorry :P

Sandbird · May 20, 2014

Me again :P
Well... have you tried selling vehicles in your editor?
They don't despawn and you don't get any gold :D
RPT seems okay
Sorry :P

i just redownloaded the github file and tested this and i can sell the vehicle just fine...it deletes and give me the money as well.

Are you sure you replaced the /trader folder ?

Just be safe....also replace the /dayz_server/compile folder with the new one....if you havent edited any files there.

(ps you do get inside the driver's seat first also right?)

otto14 · May 22, 2014

Hi, sorry my english. I'm trying build a server with arma2net, the result is returned fine in Dazy epoch 3d Editor live mission, but on epoch server the result is aways <null>. You have any idea why this are happening?

Example of command:

"Arma2Net.Unmanaged" callExtension "Activate";
"Arma2Net.Unmanaged" callExtension "Activate Arma2NETMySQL";
"Arma2Net.Unmanaged" callExtension "Activate Arma2NETMySQLCommand";


_result = "Arma2Net.Unmanaged" callExtension "Arma2NETMySQLCommand ['dayz_epoch', 'SELECT InstanceID FROM character_data LIMIT 1']";
_result = call compile _result;


_coco = nil;
while {isNil("_coco")} do {
hintSilent format["%1",_result];
sleep 0.5;
};

Sandbird · May 22, 2014

Hi, sorry my english. I'm trying build a server with arma2net, the result is returned fine in Dazy epoch 3d Editor live mission, but on epoch server the result is aways <null>. You have any idea why this are happening?

Example of command:

You put @Arma2NET and Arma2NETMySQLPlugin folders in the server's root folder right?

And also the Databases.txt ? (In the Arma2NETMySQLPlugin folder and also in your C:\Users\xxxx\AppData\Local\Arma2NETMySQL folder in the server)

In the server go to : \arma 2 operation arrowhead\@Arma2NET and run the Arma2NetExplorer.exe

Then paste this inside: Arma2NETMySQLCommand ['dayz_epoch',"SELECT InstanceID FROM character_data LIMIT 1"]

If you see a result (like: [[["11"]]]) then everything is fine...your .sqf is wrongly written, we'll get to that after.

If you see an error there then go here: C:\Users\xxxx\AppData\Local\Arma2NET and check the latest log....what error does it say at the bottom ?

Report back :)

ps: you start the server with the parameters like the one i have in my .bat file right? (adding that extra ;@Arma2NET)

[Release] Dayz.Epoch.3d.Editor.Live.Mission.With.Database.Interaction

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

Sandbird

kaotix

Mugzy

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Please sign in to comment