How to Edit MySQL Trader stock on Vilayer

[JohnyMST]

Hi again guys,

I asked a question about the Trader Stock as I want to add Cinder Blocks and Mortar to them.

I have received a response that I should look for file called "traders_data" file but I cannot find it anywhere.

Today I was told that I should add the stock in MySQL... I have no idea on who to do this and I have searched the forum for help but didnt find anything good.

Can you please let me know if you know, where and how to add these two Items. Screenshots, anything is helpful.

This is all I need to get my server completed and I would love to have it done soon. Anyone with this knowledge or Vilayer server willing to help out?

 

Thanks!!
 

[bFe]

Do you have the database info so you can use a program like Navicat?
If that is i can help you.

[JohnyMST]

OMG it suddenly came to me... I downloaded HeidiSQL and connected to MySQL...

 

I can see the file you were talking about "Trader_Items"

 

Now if I dont succeed with this on my own, I will give u the details  to login ( I want to learn how to do this :D )

Just tell me... How do I edit this Trader Items so I can input the lines that I want to stock into the traders

 

Can u send a screenshot on where I should enter the lines u gave me yesterday?

[LimpNoodle]

Hi Johny,

 

I use Navicat, but you can run this in your SQL console and it will be added into your traders_data:

(Obviously you can change the prices etc)

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

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

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgeHandle",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 508, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgeHandle",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgeHandle",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgeHandle",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 678, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgeHandle",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 680, 'trade_items');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgehead",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 508, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgehead",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgehead",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgehead",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 678, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgehead",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 680, 'trade_items');

I'm always adding new things in like vehicles & guns and usually do it all with console commands.

 

Anyway give me a shout if you need more help. I know Vilayer's system pretty well also.