Jump to content
Sandbird

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

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 :/

Share this post


Link to post
Share on other sites

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'""

Share this post


Link to post
Share on other sites

 

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 :/

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

 

 

 

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.

 

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 ?

Share this post


Link to post
Share on other sites

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,

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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?)

Share this post


Link to post
Share on other sites

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;
};

Share this post


Link to post
Share on other sites

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)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

  • Advertisement
  • Supporters
  • Discord

×
×
  • Create New...