ٍٍSenior Member Scroll #HB

[HB#]

وكان فيه غلطه بسيطه في ال procedure الفوق المشاركه بتاعت حضرتك وتم التعديل عليها وانشاء الله تشتغل ([procedure to remove [senior):

      	IF (@Operation = '41') and (@ItemRefID = '47295') --- This scroll is made by #HB
	Begin
   	declare @SeniorMemberOldName varchar(64) 
	set @SeniorMemberOldName = (select CharName from [SRO_VT_SHARD].dbo.Senior_Member)
	   	declare @SeniorMemberCharID int
	set @SeniorMemberCharID = (select CharID from [SRO_VT_SHARD].dbo.Senior_Member)
   	UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set CharName16 = @SeniorMemberOldName where CharID = @SeniorMemberCharID
	UPDATE [SRO_VT_SHARD].dbo._Friend Set FriendCharName = @SeniorMemberOldName where FriendCharID = @SeniorMemberCharID
	UPDATE [SRO_VT_SHARD].dbo._GuildMember Set CharName = @SeniorMemberOldName where CharID = @SeniorMemberCharID
	UPDATE [SRO_VT_SHARD].dbo._Inventory Set ItemID = '252793' where CharID = @CharID AND Slot = '108'
	DELETE FROM [SRO_VT_SHARD].dbo.Senior_Member
		END