طلب plus +

[يارا محمد]

المشاركة الأصلية كتبت بواسطة che_9299 عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

UPDATE [dbo].[_RefObjItem] set Param2='1667457891',Param3='1666865754',Param4='1482181451' where ID='2033' 
UPDATE [dbo].[_RefObjItem] set Param2='1667457891',Param3='1666865754',Param4='1482181451' where ID='2034' 
UPDATE [dbo].[_RefObjItem] set Param2='1667457891',Param3='1666865754',Param4='1482181451' where ID='2035' 
UPDATE [dbo].[_RefObjItem] set Param2='1667457891',Param3='1666865754',Param4='1482181451' where ID='2036' 
UPDATE [dbo].[_RefObjItem] set Param2='1667457891',Param3='1666865754',Param4='1482181451' where ID='2037' 
UPDATE [dbo].[_RefObjItem] set Param2='1667457891',Param3='1666865754',Param4='1482181451' where ID='2038' 
UPDATE [dbo].[_RefObjItem] set Param2='1667457891',Param3='1666865754',Param4='1482181451' where ID='2039' 
UPDATE [dbo].[_RefObjItem] set Param2='1667457891',Param3='1666865754',Param4='1482181451' where ID='2040' 
UPDATE [dbo].[_RefObjItem] set Param2='1667457891',Param3='1666865754',Param4='1482181451' where ID='2041' 
UPDATE [dbo].[_RefObjItem] set Param2='1667457891',Param3='1666865754',Param4='1482181451' where ID='2042' 
UPDATE [dbo].[_RefObjItem] set Param2='1667457891',Param3='1666865754',Param4='1482181451' where ID='2043' 
UPDATE [dbo].[_RefObjItem] set Param2='1667457891',Param3='1666865754',Param4='1482181451' where ID='2044'

شكرا جدا بس يا ريت اخر حاجا عايزه اعدل alchmey sccuce

[Cursed_Devil]

عدلهم من الSever.cfg

[che_9299]

USE SRO_VT_SHARD
-- by Che
Declare @ARate Varchar (64)
Set @ARate = '2' -- x1 = 1 or x2 = 2 and and and ..... dont use "0"

UPDATE _RefObjItem
set Param2 = Param2 * @ARate , Param3 = Param3 * @ARate , Param4 = Param4 * @ARate
where ID between 2033 and 2044

select * from _RefObjItem
where ID between 2033 and 2044

[يارا محمد]

المشاركة الأصلية كتبت بواسطة che_9299 عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

USE SRO_VT_SHARD
-- by Che
Declare @ARate Varchar (64)
Set @ARate = '2' -- x1 = 1 or x2 = 2 and and and ..... dont use "0"

UPDATE _RefObjItem
set Param2 = Param2 * @ARate , Param3 = Param3 * @ARate , Param4 = Param4 * @ARate
where ID between 2033 and 2044

select * from _RefObjItem
where ID between 2033 and 2044

شكرا ليك بس الكويرى ده بيخلى النسبه الزاى ؟

[™Dev Microsoft™]

2X

[يارا محمد]

معلش ممكن كويرى يخلى نسب
من

1~8 100%
8~10 90%
10~12 80%

و شكرا