Jump to content
  • 0

How to add Cinder Blocks and Mortar to traders


JohnyMST

Question

13 answers to this question

Recommended Posts

  • 0

Execute this sql.
 

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CinderBlocks",1]', 15, '[3,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CinderBlocks",1]', 15, '[3,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CinderBlocks",1]', 15, '[3,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 508, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["MortarBucket",1]', 15, '[2,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["MortarBucket",1]', 15, '[2,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["MortarBucket",1]', 15, '[2,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 508, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlywoodPack",1]', 15, '[3,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 555, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlywoodPack",1]', 15, '[3,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 636, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlankPack",1]', 15, '[3,"ItemSilverBar10oz",1]', '[15,"ItemSilverBar",1]', 555, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlankPack",1]', 15, '[3,"ItemSilverBar10oz",1]', '[15,"ItemSilverBar",1]', 636, 'trade_items')

I also added Plywood packs and Lumber packs, delete if you want.
If you dont delete them, the packs will appear at wholesellers, while the other stuff appears at every normal trader(building items)

Link to comment
Share on other sites

  • 0

Sorry but I'm a noob at this.

 

 

What does that mean? Or how do I execute this sql? :P

I had trouble with this too. My host has a datbase setup for my server using phpMyAdmin, next to structure there should be an sql tab, put it in there and hit go.

Link to comment
Share on other sites

  • 0

OK I see the "Traders_Data" file but the format of the file is: "FRM"
 
How do I open FRM files? I tried with notepad ++ but it doesnt look good.
 

þ
    0  ÂQ         @ 	              Â  ]Å  !        //                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       €    (    €   @ÿ €
 @ ÿPRIMARYÿitemÿ                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   trade_items                                                        InnoDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  ç                                                                                                                                                                                                                                                               m W  Q'         P    «   m 	)                                          id  item  qty  buy  sell 	 order 
 tid  afile         Jÿ    @   8   @     Kÿ 	  @    Jÿ 	  @    	 	      
 
 @    @@         ÿidÿitemÿqtyÿbuyÿsellÿorderÿtidÿafileÿ [Class Name,1 = CfgMagazines | 2 = Vehicle | 3 = Weapon]amount in stock available to buy[[Qty,Class,Type],][[Qty,Class,Type],]# sort order for addAction menuTrader Menu ID

............. ?

Link to comment
Share on other sites

  • 0

dayz.st you need to add the item to the traders items just make sure you use the correct id for example mine is 

777 CinderBlocks 1 Building Supplies trade_items

starting from the item id (make sure you use one that's not in use) then its the class name, item type, groupd and finally alfie 

and then you need to add it to the traders data table for example mine;

7376 ["CinderBlocks",1] 200 [2,"ItemGoldBar",1] [1,"ItemGoldBar",1] 0 508

trade_items

 

this means item id, class name must be placed in that format (1 being defining that its an item not a car or gun etc) 200 is what i have my quantity set to then its buy price [amount,"currency",1 (defining it as an item)] sell price is the same set up as buy price, leave the 0 as it is 508 is the trader id of the traders you want to sell it too you can find this by checking for other building supplies in your trader data (just look for another building item i.e vault and check the ids that sell it (ctrl+f to search) and finally the alfie again

 

this is how mine is set up and it works mine just change the item id as you cant have the same id twice so if you want these at 3 traders you would need 3 separate id's and change the trader id to whichever one you want, you can simply change the cinder blocks for mortar buckets by using the above method and just changing the id and  classname or you can add almost everything just make sure you use the correct class name 

 

first attempt at helping so hope it helps 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Discord

×
×
  • Create New...