[orve]

الموضوع باين من عنوانه طبعا يا شباب دى اسكرول بتغير الافتار من Male to Female و العكس نبدا و نقول

بسم الله الرحمن الرحيم

نبتدى بى SRO_VT_SHARD

RefObjCommon

1	41909	ITEM_ORVE_AVATAR_SWITCHER	?????	xxx	SN_ITEM_ORVE_AVATAR_SWITCHER	SN_ITEM_ORVE_AVATAR_SWITCHER_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	ORVE\avatar_switcher.ddj	xxx	xxx	21362

_RefObjItem

21362	1	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1000	????	1	??????                                                                                                                           	-1	RESURRECT	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0

ندخل دلوقتى على تانى نقطه هنضيف الجين دول فى SRO_VT_SHARDLOG

USE [SRO_VT_SHARDLOG]
GO
/****** Object:  Table [dbo].[_AvatarsGenders]    Script Date: 7/15/2018 2:53:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_AvatarsGenders](
	[1] [int] NULL,
	[2] [int] NULL
) ON [PRIMARY]

GO

IF (@Operation=41 AND @ItemRefID=41844) 
	BEGIN
	IF @ItemID IN (SELECT [1] FROM _AvatarsGenders)
	BEGIN
	UPDATE SRO_VT_SHARD.._Items SET RefItemID = (SELECT [2] FROM _AvatarsGenders WHERE [1]=@ItemID) WHERE [Serial64]=@ItemSerial
	END
	ELSE 
	BEGIN
	EXEC SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName,@ScrollCode,'1','0'
	END
	END

تم سهله كده كل الى باقى انك تضيف الاسكرول فى addlogchar وى تضيف اكواد الافترات فى التبل الى لسه عملينه و يبقى كلو تمام