| Hamza FiGo |
01-07-2015 02:05 AM |
رد: طلبين مهمين اووى
اول طلب السيستم مش عندي. والموضوع اتحذف برغبة صاحب الموضوع للاسف لازم ناخد راي صاحب الموضوع قبل ما ناخد قرار في كدة
تاني طلب اتفضل الكيوري اهو
كود:
USE [SRO_VT_SHARD]
----------------------------Made By [Dev]LegendKnight----------------------------
DECLARE @LEGENDKNIGHT1 VARCHAR (129)
DECLARE @LEGENDKNIGHT2 VARCHAR (129)
DECLARE @LEGENDKNIGHT3 VARCHAR (129)
DECLARE @LEGENDKNIGHT4 VARCHAR (129)
DECLARE @LEGENDKNIGHT5 VARCHAR (129)
DECLARE @LEGENDKNIGHT6 VARCHAR (129)
SET @LEGENDKNIGHT1 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_B_13'
SET @LEGENDKNIGHT2 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_B_14'
SET @LEGENDKNIGHT3 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_B_15'
SET @LEGENDKNIGHT4 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_13'
SET @LEGENDKNIGHT5 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_14'
SET @LEGENDKNIGHT6 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_15'
Declare @D15x2 int SET @D15x2 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT6)
Declare @D13 int SET @D13 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT1)
Declare @D14 int SET @D14 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT2)
Declare @D15 int SET @D15 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT3)
Declare @D13x2 int SET @D13x2 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT4)
Declare @D14x2 int SET @D14x2 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT5)
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684300870',Param4='840172800' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684300870',Param4='840172800' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684300870',Param4='840172800' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684300870',Param4='840172800' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684300870',Param4='840172800' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684300870',Param4='840172800' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684300870',Param4='840172800' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684300870',Param4='840172800' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684300870',Param4='840172800' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684300870',Param4='840172800' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684300870',Param4='840172800' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684300870',Param4='840172800' where ID='2044'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684300870',Param4='840172800' where ID= @D13
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684300870',Param4='840172800' where ID= @D14
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684300870',Param4='840172800' where ID= @D15
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684300870',Param4='840172800' where ID= @D13x2
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684300870',Param4='840172800' where ID= @D14x2
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684300870',Param4='840172800' where ID= @D15x2
|
