JohnyMST Posted October 14, 2013 Report Share Posted October 14, 2013 Hi guys, I have my trader up and running however I found that there are no Cinder Blocks and Mortar in it. Can you please tell me what file I should edit and what sort of code should I put in it? Thanks! steal45 1 Link to comment Share on other sites More sharing options...
0 bFe Posted October 14, 2013 Report Share Posted October 14, 2013 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) steal45 1 Link to comment Share on other sites More sharing options...
0 JohnyMST Posted October 14, 2013 Author Report Share Posted October 14, 2013 Sorry but I'm a noob at this. Execute this sql. What does that mean? Or how do I execute this sql? :P Link to comment Share on other sites More sharing options...
0 Ephox Posted October 14, 2013 Report Share Posted October 14, 2013 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 More sharing options...
0 JohnyMST Posted October 14, 2013 Author Report Share Posted October 14, 2013 I am using Vilayer host and I dont have an sql Tab. I can see mysql folder in the file manager but nothing specific in there... Link to comment Share on other sites More sharing options...
0 JohnyMST Posted October 14, 2013 Author Report Share Posted October 14, 2013 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 More sharing options...
0 bFe Posted October 14, 2013 Report Share Posted October 14, 2013 I dont know about that, but if you got the mysql info you can use Navicat to do it. Link to comment Share on other sites More sharing options...
0 Evermourne88 Posted November 20, 2013 Report Share Posted November 20, 2013 does this work also with Dayz.st cause i tried to insert it myself to the traders data and the server would not let any players in anymore could you please help me on that Link to comment Share on other sites More sharing options...
0 cen Posted November 21, 2013 Report Share Posted November 21, 2013 make sure your table names match. ST uses a different capitalization. Link to comment Share on other sites More sharing options...
0 havock Posted December 9, 2013 Report Share Posted December 9, 2013 make sure your table names match. ST uses a different capitalization. Examples? :) pretty please? Link to comment Share on other sites More sharing options...
0 cen Posted December 10, 2013 Report Share Posted December 10, 2013 traders_data, TRADERS_data Traders_data Traders_Data traders_DATA If could be anything :D Link to comment Share on other sites More sharing options...
0 Syrical Posted December 10, 2013 Report Share Posted December 10, 2013 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 More sharing options...
0 havock Posted December 11, 2013 Report Share Posted December 11, 2013 http://www.youtube.com/watch?v=hF27vj6yDE4 This will show you how to add what ever you want. All youll need to know is what the item you want to add is called. Im a dumby and this was PERFECT! Link to comment Share on other sites More sharing options...
0 vbawol Posted December 11, 2013 Report Share Posted December 11, 2013 Its in the update SQL for 1.0.3 https://github.com/vbawol/DayZ-Epoch/blob/master/Server%20Files/SQL/1_0_3_Updates.sql#L99-L113 Link to comment Share on other sites More sharing options...
Question
JohnyMST
Hi guys,
I have my trader up and running however I found that there are no Cinder Blocks and Mortar in it.
Can you please tell me what file I should edit and what sort of code should I put in it?
Thanks!
Link to comment
Share on other sites
13 answers to this question
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now