H I T L E R
10-02-2020, 05:41 AM
طبعا انت هتعملو سكرول حاجه بسيطه مش محتاجه يعني انا قولت امسي عليكو ب ده بس عشان بقالي كتير منزلتش حاجه
Declare @Hitler int
SET @Hitler = (Select ID64 From SRO_VT_SHARD.._Items Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where Slot = '13' and CharID = @CharID))
Declare @Devil_Code nvarchar(100)
SET @Devil_Code = (Select CodeName128 From SRO_VT_SHARD.._RefObjCommon Where ID = @Weapon_ID)
IF (@Operation = 41 and @ItemRefID = 421610081) -- Devil To Female
Begin
IF (@Weapon_Code = 'ITEM_MALL_AVATAR_M_NASRUN_UNIQUE' )
BEGIN
UPDATE SRO_VT_SHARD.._Items SET RefItemID = (Select ID From SRO_VT_SHARD.._RefObjCommon Where CodeName128 ='ITEM_MALL_AVATAR_W_NASRUN_UNIQUE') Where ID64 = @Hitler
END
END
IF (@Operation = 41 and @ItemRefID = 421610081) -- Devil To Male
Begin
IF (@Weapon_Code = 'ITEM_MALL_AVATAR_W_NASRUN_UNIQUE' )
BEGIN
UPDATE SRO_VT_SHARD.._Items SET RefItemID = (Select ID From SRO_VT_SHARD.._RefObjCommon Where CodeName128 ='ITEM_MALL_AVATAR_M_NASRUN_UNIQUE') Where ID64 = @Hitler
END
END
Declare @Hitler int
SET @Hitler = (Select ID64 From SRO_VT_SHARD.._Items Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where Slot = '13' and CharID = @CharID))
Declare @Devil_Code nvarchar(100)
SET @Devil_Code = (Select CodeName128 From SRO_VT_SHARD.._RefObjCommon Where ID = @Weapon_ID)
IF (@Operation = 41 and @ItemRefID = 421610081) -- Devil To Female
Begin
IF (@Weapon_Code = 'ITEM_MALL_AVATAR_M_NASRUN_UNIQUE' )
BEGIN
UPDATE SRO_VT_SHARD.._Items SET RefItemID = (Select ID From SRO_VT_SHARD.._RefObjCommon Where CodeName128 ='ITEM_MALL_AVATAR_W_NASRUN_UNIQUE') Where ID64 = @Hitler
END
END
IF (@Operation = 41 and @ItemRefID = 421610081) -- Devil To Male
Begin
IF (@Weapon_Code = 'ITEM_MALL_AVATAR_W_NASRUN_UNIQUE' )
BEGIN
UPDATE SRO_VT_SHARD.._Items SET RefItemID = (Select ID From SRO_VT_SHARD.._RefObjCommon Where CodeName128 ='ITEM_MALL_AVATAR_M_NASRUN_UNIQUE') Where ID64 = @Hitler
END
END