USE BROTHERSRO_SHARD_DB
GO --
DECLARE @NewQuot FLOAT
DECLARE @NewPrice INT
DECLARE @NewStack INT
DECLARE @NewSellPrice INT
SET @NewQuot = 2.0 -- Doubles the profit % trough '2.0' (e.g. 2.1 is also possible)
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB/@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
help how to change vsro rate(exp gold sp..) 01/16/2024 - SRO Private Server - 3 Replies hello just like i say my frined open server and he dosent know how to change it someone can help us
ty good day
Paying to Someone Can Change Gold Rate For Thief 05/03/2012 - SRO Private Server - 23 Replies like title say...
if you are the one
then pm me in private mesg
i will tell you how much money i can pay for this thing
[Question]How to change Exp rate and Drop rate? 01/30/2012 - Dragonica Private Server - 0 Replies Sorry i has a problem to use GM-Tool, CMTOOL, GMAdminTool.
and How to Setup GM-Tool, CMTOOL, GMAdminTool ?
help please.
gold rate change not working 09/18/2011 - Rappelz - 10 Replies ok so maybe im just tired or something lol
S game.gold_drop_rate 400
ive tried al diff rates, yet nothing changes, yes i did compress