Want to add radios to traders on a Vilayer server, please.

[Tricks]

Hey everyone, I am trying to add radios to my traders, can someone give me the exact SQL query for my database please? I want to charge 1 10oz gold to buy and sell. If possible I would like to sell at all building supply traders under tool belt items. Thanks!!!

[Brockie]

which map?

[Glenn]

Regardless of which map you are on, this will be the SQL code you need:
 

INSERT INTO traders_data ('item', 'qty', 'buy', 'sell', 'order', 'tid', 'afile') VALUES
('["ItemRadio",3]', 50, '[1,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 0, 510, 'trade_items'),
('["ItemRadio",3]', 50, '[1,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 0, 532, 'trade_items'),
('["ItemRadio",3]', 50, '[1,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 0, 663, 'trade_items');

which map?

 

Since 1.0.4 (I think?), the traders have unified the category codes. Unless you have changed it to something else, or want a special category for it, these are the Toolbelt Items category ID's.

[Tricks]

Epoch Chernarus

[Tricks]

Thank you I will try it tonight!

[Tricks]

Hey Glen, its not working. I am getting an error:

/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''["ItemRadio",1]', 50, '[1,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 0, ' at line 1 */

I am playing on Epoch Chernaurs on a Vilayer server.

[Glenn]

Hey Glen, its not working. I am getting an error:

/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''["ItemRadio",1]', 50, '[1,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 0, ' at line 1 */

I am playing on Epoch Chernaurs on a Vilayer server.

Sometime si hate MySQL Syntax soo much. :) 

Try this: 

 

INSERT INTO 'traders_data' ('item', 'qty', 'buy', 'sell', 'order', 'tid', 'afile') VALUES
('["ItemRadio",3]',50,'[1,"ItemGoldBar10oz",1]','[1,"ItemGoldBar10oz",1]',0,510,'trade_items'),
('["ItemRadio",3]',50,'[1,"ItemGoldBar10oz",1]','[1,"ItemGoldBar10oz",1]',0,532,'trade_items'),
('["ItemRadio",3]',50,'[1,"ItemGoldBar10oz",1]','[1,"ItemGoldBar10oz",1]',0,663,'trade_items');

[Tricks]

I used wiki and got them in, however when I buy one the trader takes my gold and I don't receive anything. Should I restore my database and try yours?

[Tricks]

Nope yours didn't work Glen, same error. Here is what I used before but am not receiving item in game:

INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["ItemRadio",1]',50,'[1,"ItemGoldBar10oz",1]','[1,"ItemGoldBar10oz",1]',0,663,'trade_items')

[fr1nk]

Try this:

INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["ItemRadio",3]',50,'[1,"ItemGoldBar10oz",1]','[1,"ItemGoldBar10oz",1]',0,663,'trade_weapons')

edit: just noticed you experienced a syntax error...I just tried this and it worked for me though.

[Glenn]

Single Quotes + Heidi = annoying. :) 

 

INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES 
(`["ItemRadio",3]`,50,`[1,"ItemGoldBar10oz",1]`,`[1,"ItemGoldBar10oz",1]`,0,510,`trade_items`),
(`["ItemRadio",3]`,50,`[1,"ItemGoldBar10oz",1]`,`[1,"ItemGoldBar10oz",1]`,0,532,`trade_items`),
(`["ItemRadio",3]`,50,`[1,"ItemGoldBar10oz",1]`,`[1,"ItemGoldBar10oz",1]`,0,663,`trade_items`);

[Tricks]

sweeeeet, thanks fr1nk! it works and even has a picture!

[Glenn]

Edited all examples so that no one gets the same issue if they try to use my code. 

 

Thanks for fixing it, fr1nk!  :)

[Tricks]

You guys are great! thanks so much!

[fr1nk]

Wooo party time!

[Tricks]

I know this is in the wrong post, but can any of you help me create base kits that players can see? I want to reward loyal players. I am using Infistar.

[Tricks]

hahaha ok here's one... I added MixOil for 2 stroke oil and its wrong. how can I remove it from my database? Also what is the correct item code, cant find it on google

[Brockie]

ItemMixOil