[Hamza FiGo]

مش المفروض البروسيدر تبقي كدا ؟ انت مش حاطط ID الاسكرول فيها

IF ((@Operation = 41 ) AND (@ItemRefID = 41887))
BEGIN
IF (@ItemRefID = Scroll ID FROM _RefObjCommon)
BEGIN
declare @RefCharID int
DECLARE @OldItemCodeName varchar(128)
DECLARE @SS varchar(128)
DECLARE @OldItemPlus 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 =OLD Devil Plus
set @NewItemPlus = 0
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