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

اولا لازم تعمل تيبل تضيف فيهم الاى دى بتاع الديفل

اعمل ده الاول و بعد ما تعمله ضيف فيه الاى دى بتاع الديفل

كود PHP:

USE [SRO_VT_SHARDLOG] GO /****** Object: Table [dbo].[_DevilsID] Script Date: 7/11/2021 10:39:59 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[_DevilsID]( [MaleItemID] [int] NULL, [FemaleItemID] [int] NULL ) ON [PRIMARY] GO

و ده هضيفه فى _AddLogItem

ملحوظه بس الرقم الى بى الاحم ده هو الى هتغيره بى رقم الاسكرول بتعتك و متعدلش على اى حاجه تانى

كود PHP:

if ( @ItemRefID=Here can Put Number your Scroll) ------------------------Devil Type Switcher Scroll ------------------- begin IF @Slot13_ItemID in (select ID from SRO_VT_SHARD.dbo._RefObjCommon where CodeName128 like 'ITEM_MALL_AVATAR_%_NASRUN%') begin If (@Slot13_ItemID In (Select MaleItemID from SRO_VT_SHARDLOG.dbo._DevilsID)) UPDATE SRO_VT_SHARD.dbo._Items set RefItemID=(select FemaleItemID from SRO_VT_SHARDLOG.dbo._DevilsID where MaleItemID=@Slot13_ItemID) where ID64=@Slot13_ID64 else if (@Slot13_ItemID In (Select FemaleItemID from SRO_VT_SHARDLOG.dbo._DevilsID)) UPDATE SRO_VT_SHARD.dbo._Items set RefItemID=(Select MaleItemId from SRO_VT_SHARDLOG.dbo._DevilsID where FemaleItemID=@Slot13_ItemID) where ID64=@Slot13_ID64 end else if @Slot13_ItemID not in (select ID from SRO_VT_SHARD.dbo._RefObjCommon where CodeName128 like 'ITEM_MALL_AVATAR_%_NASRUN%') begin DECLARE @ScrollCodeName10 Varchar (50) = (Select codename128 from SRO_VT_SHARD.dbo._RefObjCommon where ID=@ItemRefID) end end