[Hamza FiGo]

المشاركة الأصلية كتبت بواسطة Jaffa عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

متدينى البروسيدور بتاعك يا Hamzafigo بتاعك اللى انت شغال بيه

  IF (@Operation = 41) 
BEGIN 
	IF (@ItemRefID = 70023) 
	BEGIN 
			declare @RefCharID int 
			DECLARE @OldItemCodeName varchar(128) 
			DECLARE @SS varchar(128) 
			DECLARE @OldItemPlus int 
			DECLARE @NewItemPlus int 
			DECLARE @NewItemCodeName varchar(128) 
			Declare @RefMail INT = (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=@CharID AND Slot ='13') 
Declare @RefMailID INT = (Select RefItemID From SRO_VT_SHARD.dbo._Items Where ID64 = @RefMail) 
select @OldItemCodeName = CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @RefMailID 
 if(@OldItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN' or @OldItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN_BLUE' or @OldItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN_YELLOW') 
 begin 
		 set @NewItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN_UNIQUE' 
 end 
  if(@OldItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN' or @OldItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN_BLUE' or @OldItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN_YELLOW') 
 begin 
		 set @NewItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN_UNIQUE' 
 end 
			declare @CharName16 varchar(64) 
				set @OldItemPlus = 7 
				set @NewItemPlus = 3 
				DECLARE @ReplaceID int 
				SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.dbo._Inventory as inv inner join SRO_VT_SHARD.dbo._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.dbo._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @OldItemCodeName and itm.OptLevel >= @OldItemPlus) 
				if (@ReplaceID > 0) 
				begin 
					Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID 
					select @CharName16 =CharName16  from SRO_VT_SHARD.dbo._Char where CharID=@CharID 
					exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName16,@NewItemCodeName,1,@NewItemPlus  
				end 
				end 
				END