BUG Traders 1.0.4

[Stranger]

You can buy a Crowbar and a Machete for 1 Silver - If you sell it you get 2 OZ Silver

 

The Prices are not right after update DB

[Stranger]

Also Heatpack, HuntingKnife, Flashlight, Glas and Painkillers...

[matrixmark]

God yeah they are a little messed up now.

[vbawol]

The prices are fine, make sure you run the epoch.sql.
 

Just checked and the crowbar is 2 silver buy and 1 silver sell.

[vbawol]

if you sell both a crowbar and a Machete you would get 2 x 1oz server and on the second trade it converts it to a 2oz stack.

[Stranger]

No, if you buy a Crowbar (you pay 2 Sliver - if you sell it you get 2 OZ silver...

 

I have overwritten everything with your SQL file. Some other Serveradmins have this problem too..

[GGDayZ]

confirmed, check also flashlights and knifes

[vbawol]

Just tested on our dev server and had no such pricing. Just run the epoch.sql that has the more correct pricing than we could provide with just the copper > silver 1.0.4_update sql. 

[cen]

These classnames need prices adjusted after running the 1.0.4 update sql:

 

["Crossbow_DZ",3]

["DZ_Assault_Pack_EP1",2]

["ItemCrowbar",3]

["ItemFlashlight",3]

["ItemHeatPack",1]

["ItemKnife",3]

["ItemMachete",3]

["ItemMap",3]

["PartGlass",1]

[adg]

Everything is fine in my db after the update. You guys are doing something wrong :D

[cen]

It's not us, it's the 1.0.4 sql update file:

 

Specifically this line:

 

UPDATE `Traders_DATA` SET `buy`= '[2,"ItemSilverBar",1]' WHERE `buy`='[1,"ItemCopperBar",1]';

 

-- ----------------------------
-- Set any buy value of copper to 2 silver
-- ----------------------------
UPDATE `Traders_DATA` SET `buy`= '[4,"ItemSilverBar10oz",1]' WHERE `buy`='[2,"ItemCopperBar10oz",1]';
UPDATE `Traders_DATA` SET `buy`= '[2,"ItemSilverBar10oz",1]' WHERE `buy`='[1,"ItemCopperBar10oz",1]';
UPDATE `Traders_DATA` SET `buy`= '[9,"ItemSilverBar",1]' WHERE `buy`='[9,"ItemCopperBar",1]';
UPDATE `Traders_DATA` SET `buy`= '[8,"ItemSilverBar",1]' WHERE `buy`='[8,"ItemCopperBar",1]';
UPDATE `Traders_DATA` SET `buy`= '[7,"ItemSilverBar",1]' WHERE `buy`='[7,"ItemCopperBar",1]';
UPDATE `Traders_DATA` SET `buy`= '[6,"ItemSilverBar",1]' WHERE `buy`='[6,"ItemCopperBar",1]';
UPDATE `Traders_DATA` SET `buy`= '[5,"ItemSilverBar",1]' WHERE `buy`='[5,"ItemCopperBar",1]';
UPDATE `Traders_DATA` SET `buy`= '[4,"ItemSilverBar",1]' WHERE `buy`='[4,"ItemCopperBar",1]';
UPDATE `Traders_DATA` SET `buy`= '[3,"ItemSilverBar",1]' WHERE `buy`='[3,"ItemCopperBar",1]';
UPDATE `Traders_DATA` SET `buy`= '[2,"ItemSilverBar",1]' WHERE `buy`='[2,"ItemCopperBar",1]';
UPDATE `Traders_DATA` SET `buy`= '[2,"ItemSilverBar",1]' WHERE `buy`='[1,"ItemCopperBar",1]';

-- ----------------------------
-- Set any sell value of copper to 1 silver only run if not updating
-- ----------------------------
UPDATE `Traders_DATA` SET `sell`= '[2,"ItemSilverBar10oz",1]' WHERE `sell`='[2,"ItemCopperBar10oz",1]';
UPDATE `Traders_DATA` SET `sell`= '[1,"ItemSilverBar10oz",1]' WHERE `sell`='[1,"ItemCopperBar10oz",1]';
UPDATE `Traders_DATA` SET `sell`= '[9,"ItemSilverBar",1]' WHERE `sell`='[9,"ItemCopperBar",1]';
UPDATE `Traders_DATA` SET `sell`= '[8,"ItemSilverBar",1]' WHERE `sell`='[8,"ItemCopperBar",1]';
UPDATE `Traders_DATA` SET `sell`= '[7,"ItemSilverBar",1]' WHERE `sell`='[7,"ItemCopperBar",1]';
UPDATE `Traders_DATA` SET `sell`= '[6,"ItemSilverBar",1]' WHERE `sell`='[6,"ItemCopperBar",1]';
UPDATE `Traders_DATA` SET `sell`= '[5,"ItemSilverBar",1]' WHERE `sell`='[5,"ItemCopperBar",1]';
UPDATE `Traders_DATA` SET `sell`= '[4,"ItemSilverBar",1]' WHERE `sell`='[4,"ItemCopperBar",1]';
UPDATE `Traders_DATA` SET `sell`= '[3,"ItemSilverBar",1]' WHERE `sell`='[3,"ItemCopperBar",1]';
UPDATE `Traders_DATA` SET `sell`= '[2,"ItemSilverBar",1]' WHERE `sell`='[2,"ItemCopperBar",1]';
UPDATE `Traders_DATA` SET `sell`= '[1,"ItemSilverBar",1]' WHERE `sell`='[1,"ItemCopperBar",1]';

-- ----------------------------
-- WEAPON UPDATE
-- ----------------------------
UPDATE `Traders_DATA` SET `item`= '["M249_EP1_DZ",3]' WHERE `item`='["M249_DZ",3]';
UPDATE `Character_DATA` SET `Inventory` = REPLACE(`Inventory`, '"M249_DZ"', '"M249_EP1_DZ"') WHERE `Inventory` LIKE '%"M249_DZ"%';
UPDATE `Character_DATA` SET `Backpack` = REPLACE(`Backpack`, '"M249_DZ"', '"M249_EP1_DZ"') WHERE `Backpack` LIKE '%"M249_DZ"%';
UPDATE `Character_DATA` SET `CurrentState` = '["","",42,[]]' WHERE `CurrentState` LIKE '%"M249_DZ"%';
UPDATE `Object_DATA` SET `Inventory` = REPLACE(`Inventory`, '"M249_DZ"', '"M249_EP1_DZ"') WHERE `Inventory` LIKE '%"M249_DZ"%';

[Radec59437]

*snip*

 

I'm stupid, ignore this.

[vbawol]

Just tested on our dev server and had no such pricing. Just run the epoch.sql that has the more correct pricing than we could provide with just the copper > silver 1.0.4_update sql. 

 

 

 

It's not us, it's the 1.0.4 sql update file:

 

Specifically this line:

 

UPDATE `Traders_DATA` SET `buy`= '[2,"ItemSilverBar",1]' WHERE `buy`='[1,"ItemCopperBar",1]';

 

SNIP CODE

The update does screw the pricing as it is too loose to actually fix all the prices. I made sure that the epoch.sql does have the proper balance and it should be used as a base instead of the update sql. 

 

To fix simply execute the epoch.sql from the 1.0.4 server files again.

[DavidL]

Something is wrong, people can't recieve money selling guns or vehicles.

[D9IDbKA]

remove this post, please.