Adding a DMR to the trader? / Vehicle max limit ?

[Infinity]

After having my server up for a few days I noticed that DMR's are pretty much .. non existent on Epoch,

so could anyone please assist/help me with adding a DMR at the Stary / NW AF ?

 

I'd like a buy price of 2 10oz gold and sell 1 10oz gold.

 

And one other question; if you sell vehicles to the trader; will those vehicles still count as a vehicle in the servers vehicle max limit?

 

Thanks in advanced, assistance is very much appreciated :D

[Codemanx]

Hey Infinity, Here is the SQL information you will need for the DMR and AMMO

 

Stary - Black Market Dealer / Weapons

Stary (DMR)

'["DMR",3]', 14, '[2,"ItemGoldBar10oz",1]', '[6,"ItemGoldBar",1]', 0, 526, 'trade_weapons');

 

 

Stary - Black Market Dealer / Ammo

Stary (DMR AMMO)

'["20Rnd_762x51_DMR",1]', 28, '[2,"ItemSilverBar10oz",1]', '[1,"ItemSilverBar10oz",1]', 0, 527, 'trade_items'),

 

The Same code for Bash but use 605 for the DMR and 614 for the ammo.

 

Also, the vehicles that get sold are reduced from the server max limit. If a vehicle is not in play it is not counted and selling a vehicle is removed from play.

[MatthewK]

Adds them to the black market trader, hero trader and bandit trader :)

INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["DMR",3]', '10', '[1,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', '0', '477', 'trade_weapons');
INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["DMR",3]', '10', '[1,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', '0', '627', 'trade_weapons');
INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["DMR",3]', '10', '[1,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', '0', '526', 'trade_weapons');

Selling any item to a trader increases the traders stock by 1 of that item.

[Infinity]

I tried adding them adding them in manually with @Codemanx lines but that didn't work, recieved an error upon buying the DMR, but used @hayward method and that worked just fine, thanks to the both of you for answering my

questions :)

[Codemanx]

Infinity, You are right. I sometimes forget that not everyone is super savy with SQL Databases. I should have given you this information like Infinity did. I am glad that you got this working.

 

Thanks

[FrenzyFire000]

I had DMR, and DMR_DZ in my blackmarket traders mainly so players could sell the ones they get from missions, but They won't work any longer.

Any Ideas.

 

Thanks

FrenzyFire000

[ZamboniBambino]

I had DMR, and DMR_DZ in my blackmarket traders mainly so players could sell the ones they get from missions, but They won't work any longer.

Any Ideas.

 

Thanks

FrenzyFire000

 

Has the stock ran out? Were they working before?

[FrenzyFire000]

No, stock is good, and yes they were working before the new patches.

They still work on my locked test server.

 

Whats really weird is I can put an Apache in at hero trader and you can buy and sell it, but no new guns or ammo.

I did add M240 nest and they worked fine. 

[ZamboniBambino]

No, stock is good, and yes they were working before the new patches.

They still work on my locked test server.

 

Whats really weird is I can put an Apache in at hero trader and you can buy and sell it, but no new guns or ammo.

I did add M240 nest and they worked fine. 

Do you get any RPT errors?

[FrenzyFire000]

I just watch the RPT as I bought a 20rnd_762x51_BSCAR clip and this is what it gave me. Took my money and no clip, but my database show 1 came out of inventory.

 

0:39:44 "EPOCH SERVERTRADE: Player: FrenzyFire000 bought a 20rnd_762x51_B_SCAR in/at Hero Vendor for 1x ItemGoldBar"

0:39:45 No owner
0:39:45 No owner

[FrenzyFire000]

I posted this on another forum and Vampire told me to change the mag number from 1 to 2 and it worked, but the photo icon is not there any longer.