Trade don't Give Gold !

02/11/2017 20:47 Mr.Bedo#1
Hello
am use this query
Code:
DECLARE [MENTION=351728]new[/MENTION]Quot FLOAT -- @ SRO_VT_SHARD 
DECLARE [MENTION=1077328]newp[/MENTION]rice INT 
DECLARE [MENTION=5687268]newsta[/MENTION]ck INT 
DECLARE [MENTION=363717]news[/MENTION]ellPrice INT 
SET [MENTION=351728]new[/MENTION]Quot = 99.9 -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible) 
SET [MENTION=1077328]newp[/MENTION]rice = 9999 -- Goods Price @ the Shop 
SET [MENTION=5687268]newsta[/MENTION]ck = 9999 -- Increases/Decreases the maximum Stack, Default = 40 
SET [MENTION=363717]news[/MENTION]ellPrice = 999 -- Goods Price if you sell them directly again - without trading. 

-- Profit % 

UPDATE [dbo].[_ItemQuotation] 
SET BaseQuot = BaseQuot [MENTION=351728]new[/MENTION]Quot 
WHERE RefItemID BETWEEN 2147 AND 2158 

UPDATE [dbo].[_ItemQuotation] 
SET Quot_LB = Quot_LB [MENTION=351728]new[/MENTION]Quot 
WHERE RefItemID BETWEEN 2147 AND 2158 

UPDATE [dbo].[_ItemQuotation] 
SET Quot_UB = Quot_UB [MENTION=351728]new[/MENTION]Quot 
WHERE RefItemID BETWEEN 2147 AND 2158 

UPDATE [dbo].[_ItemQuotation] 
SET BaseQuot = BaseQuot [MENTION=351728]new[/MENTION]Quot 
WHERE RefItemID BETWEEN 10394 AND 10401 

UPDATE [dbo].[_ItemQuotation] 
SET Quot_LB = Quot_LB [MENTION=351728]new[/MENTION]Quot 
WHERE RefItemID BETWEEN 10394 AND 10401 

UPDATE [dbo].[_ItemQuotation] 
SET Quot_UB = Quot_UB [MENTION=351728]new[/MENTION]Quot 
WHERE RefItemID BETWEEN 10394 AND 10401 

UPDATE [dbo].[_ItemQuotation] 
SET BaseQuot = BaseQuot [MENTION=351728]new[/MENTION]Quot 
WHERE RefItemID BETWEEN 24671 AND 24672 

UPDATE [dbo].[_ItemQuotation] 
SET Quot_LB = Quot_LB [MENTION=351728]new[/MENTION]Quot 
WHERE RefItemID BETWEEN 24671 AND 24672 

UPDATE [dbo].[_ItemQuotation] 
SET Quot_UB = Quot_UB [MENTION=351728]new[/MENTION]Quot 
WHERE RefItemID BETWEEN 24671 AND 24672 

-- Price / SellPrice 

UPDATE [dbo].[_RefObjCommon] 
SET Price = [MENTION=1077328]newp[/MENTION]rice 
WHERE ID BETWEEN 2147 AND 2158 

UPDATE [dbo].[_RefObjCommon] 
SET SellPrice = [MENTION=363717]news[/MENTION]ellPrice 
WHERE ID BETWEEN 2147 AND 2158 

UPDATE [dbo].[_RefObjCommon] 
SET Price = [MENTION=1077328]newp[/MENTION]rice 
WHERE ID BETWEEN 10394 AND 10401 

UPDATE [dbo].[_RefObjCommon] 
SET SellPrice = [MENTION=363717]news[/MENTION]ellPrice 
WHERE ID BETWEEN 10394 AND 10401 

UPDATE [dbo].[_RefObjCommon] 
SET Price = [MENTION=1077328]newp[/MENTION]rice 
WHERE ID BETWEEN 24671 AND 24672 

UPDATE [dbo].[_RefObjCommon] 
SET SellPrice = [MENTION=363717]news[/MENTION]ellPrice 
WHERE ID BETWEEN 24671 AND 24672 

-- MaxStack 

UPDATE [dbo].[_RefObjItem] 
SET MaxStack = [MENTION=5687268]newsta[/MENTION]ck 
WHERE ID BETWEEN 1926 AND 1937 

UPDATE [dbo].[_RefObjItem] 
SET MaxStack = [MENTION=5687268]newsta[/MENTION]ck 
WHERE ID BETWEEN 5881 AND 5888 

UPDATE [dbo].[_RefObjItem] 
SET MaxStack = [MENTION=5687268]newsta[/MENTION]ck 
WHERE ID BETWEEN 11159 AND 11160 

-- Price 

UPDATE [dbo].[_RefPricePolicyOfItem] 
SET Cost = [MENTION=1077328]newp[/MENTION]rice 
Where RefPackageItemCodeName like '%ITEM_ETC_TRADE%'
and if am make trade don't give me gold ?
help
02/11/2017 21:20 Dracula Untold#2
maybe it will give u love :D
02/12/2017 01:31 DevilArrow#3
look in refobjcommon and refpricepolicyofitem
02/14/2017 12:37 kotsh#4
3'by
use google baby :D