الموقع العربي الاول للعبة Silkroad Online

- قسم المواضيع المكررة و المخالفة (https://silkroad4arab.com/vb/forumdisplay.php?f=58)

- - طلب plus + (https://silkroad4arab.com/vb/showthread.php?t=541618)

اقتباس:

المشاركة الأصلية كتبت بواسطة che_9299 (المشاركة 4969032)

كود:

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

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

كود:

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 (المشاركة 4969355)

كود:

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

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

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

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

و شكرا
:cold2: