افندينا ™Hamboka™
09-12-2016, 05:05 PM
بسم الله الرحمن الرحيم
فيه ناس بتبقا عوزه تعمل alecmey rata 2x او 3x الخ فا بتتعب عقبال متلقي query المناسب
USE SRO_VT_SHARD
-- by InPanic-Kev
Declare @ARate int
Set @ARate = '3' -- x1 = 1 or x2 = 2 and and and ..... dont use "0"
UPDATE _RefObjItem
set Param2 *= @ARate , Param3 *= @ARate , Param4 *= @ARate
select * from _RefObjItem as roi
join _RefObjCommon as roc on roc.Link = roi.ID
where CodeName128 like '%ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_%'
هتغير 2 لي الي انت عوزه
فيه ناس بتبقا عوزه تعمل alecmey rata 2x او 3x الخ فا بتتعب عقبال متلقي query المناسب
USE SRO_VT_SHARD
-- by InPanic-Kev
Declare @ARate int
Set @ARate = '3' -- x1 = 1 or x2 = 2 and and and ..... dont use "0"
UPDATE _RefObjItem
set Param2 *= @ARate , Param3 *= @ARate , Param4 *= @ARate
select * from _RefObjItem as roi
join _RefObjCommon as roc on roc.Link = roi.ID
where CodeName128 like '%ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_%'
هتغير 2 لي الي انت عوزه