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%'
help