Enable Metal Floors in Traders?

[JohnyMST]

Hi,

How can I add Metal Floors to traders?

Does anyone has the SQL line for this?

 

Also while I'm at it, I'd like to add Combination locks aswell. Be nice if you could provide me with the two coders for these two items :)

 

 

Thanks

[karamell]

i dont have the sql for it but i do know the class names for it if it help anyhow.   metal_floor_kit and itemcombolock

[JohnyMST]

Ok what about Metal Panel class name? I will work out the code :)

[karamell]

its metal_panel_kit

[JohnyMST]

Is there any specific TID or afile number for this or can I use the template below and just change the item name:

 

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemComboLock",1]', 10, '[6,"ItemGoldBar",1]', '[3,"ItemGoldBar",1]', 662, 'trade_items'),('["ItemComboLock",1]', 10, '[6,"ItemGoldBar",1]', '[3,"ItemGoldBar",1]', 530, 'trade_items'),('["ItemComboLock",1]', 10, '[6,"ItemGoldBar",1]', '[3,"ItemGoldBar",1]', 508, 'trade_items');

?

Thanks :)

[karamell]

if u take a look at the epoch wiki i belive theres something about how to enter stuff to the traders and yes there are specifics

[JohnyMST]

It does not mention what TID / Afile should be used for specific items...

 

http://dayzepoch.com/wiki/index.php/Server_Configuration_Instructions#Adding_new_items_to_traders

[axeman]

tid This number must match the trader category id found in the mission file server_traders.sqf

[karamell]

tid This number must match the trader category id found in the mission file server_traders.sqf

afile Use the following types each of these represent a different .sqf file that performs the work:

• trade_items
• trade_weapons
• trade_any_vehicle
• trade_any_boat
• trade_backpacks

[axeman]

Have you seen: http://dayzepoch.com/forum/index.php?/topic/338-privatehivetools-php/?hl=%20trader%20%20menu

 

Demo here: http://privatehivetools.n8m4re.de/demo_for_epoch/

[JohnyMST]

Have you seen: http://dayzepoch.com/forum/index.php?/topic/338-privatehivetools-php/?hl=%20trader%20%20menu

 

Demo here: http://privatehivetools.n8m4re.de/demo_for_epoch/

 

I like this a lot however I will not be using this on my server. Too much control and I want to keep it to minimum to avoid abusive admins (including myself).

 

 

So I have found the server_traders.sqf and made the following SQL code for Metal Panel Kit.

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["Metal_Panel_Kit",1]', 50, '[4,"ItemGoldBar",1]', '[2,"ItemGoldBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["Metal_Panel_Kit",1]', 50, '[4,"ItemGoldBar",1]', '[2,"ItemGoldBar",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["Metal_Panel_Kit",1]', 50, '[4,"ItemGoldBar",1]', '[2,"ItemGoldBar",1]', 508, 'trade_items');

Any Errors?

Please let me know if that will work in all traders where Building Supplies are available.

 

[Axe Cop]

Looks good, but I am not sure maybe you should add the "new" items to the table "trader_items" as well, so it will display the icon and stuff.

[JohnyMST]

Thanks Cop.

Anyone could confirm the above?

[JohnyMST]

I have added the code above but didn't work yet.

Does this need a restart in order to show up in traders stock?

[Emmer]

I have added the code above but didn't work yet.

Does this need a restart in order to show up in traders stock?

 

 

Restarts are required for server to see your changes.

 

 

 

// metal_floor_kit

 

INSERT INTO `Traders_DATA` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["metal_floor_kit",1]',100,'[1,"ItemGoldBar",1]','[1,"ItemGoldBar",1]',0,530,'trade_items')

INSERT INTO `Traders_DATA` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["metal_floor_kit",1]',100,'[1,"ItemGoldBar",1]','[1,"ItemGoldBar",1]',0,662,'trade_items')

INSERT INTO `Traders_DATA` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["metal_floor_kit",1]',100,'[1,"ItemGoldBar",1]','[1,"ItemGoldBar",1]',0,508,'trade_items')

 

 

 

// wooden_shed_kit

 

INSERT INTO `Traders_DATA` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["wooden_shed_kit",1]',100,'[5,"ItemGoldBar",1]','[3,"ItemGoldBar",1]',0,530,'trade_items')

INSERT INTO `Traders_DATA` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["wooden_shed_kit",1]',100,'[5,"ItemGoldBar",1]','[3,"ItemGoldBar",1]',0,662,'trade_items')

INSERT INTO `Traders_DATA` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["wooden_shed_kit",1]',100,'[5,"ItemGoldBar",1]','[3,"ItemGoldBar",1]',0,508,'trade_items'

 

// ItemComboLock

 

 

INSERT INTO `Traders_DATA` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["ItemComboLock",1]',100,'[1,"ItemBriefcase100oz",1]','[9,"ItemGoldBar",1]',0,530,'trade_items')

INSERT INTO `Traders_DATA` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["ItemComboLock",1]',100,'[1,"ItemBriefcase100oz",1]','[9,"ItemGoldBar",1]',0,662,'trade_items')

INSERT INTO `Traders_DATA` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["ItemComboLock",1]',100,'[1,"ItemBriefcase100oz",1]','[9,"ItemGoldBar",1]',0,508,'trade_items')

[JohnyMST]

Isn't there supposed to be a " ; " on the end of the line? so  it's like:

INSERT INTO `Traders_DATA` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["ItemComboLock",1]',100,'[1,"ItemBriefcase100oz",1]','[9,"ItemGoldBar",1]',0,530,'trade_items');

[axeman]

If you are putting the query into mySQL administrator / Workbench / Navicat it will usually be ok without the finishing semi-colon. For multiple queries it is probably best to put them in.

 

Either way you will get an error back if there is a problem.

 

As always with these updates, take a backup first :)

[Emmer]

 

Isn't there supposed to be a " ; " on the end of the line? so  it's like:

INSERT INTO `Traders_DATA` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["ItemComboLock",1]',100,'[1,"ItemBriefcase100oz",1]','[9,"ItemGoldBar",1]',0,530,'trade_items');

 

i used heidiSQL to insert the lines i pasted.  i did a line at a time.      well the one line of wooden shed i didnt copy/paste the ")"   

[JohnyMST]

I used the Metal Panel kit and after restart I was able to purchase them from traders :)

Thanks all for your help!! :)