Maxmium durability stats Procedure helps

DECLARE @[Only registered and activated users can see links. Click Here To Register...]1 BIGINT,
@[Only registered and activated users can see links. Click Here To Register...]2 BIGINT,
@[Only registered and activated users can see links. Click Here To Register...]3 BIGINT,
@[Only registered and activated users can see links. Click Here To Register...]4 BIGINT,
@[Only registered and activated users can see links. Click Here To Register...]5 BIGINT,
@[Only registered and activated users can see links. Click Here To Register...]6 BIGINT,
@[Only registered and activated users can see links. Click Here To Register...]7 BIGINT,
@[Only registered and activated users can see links. Click Here To Register...]8 BIGINT,
@[Only registered and activated users can see links. Click Here To Register...]9 BIGINT,
@[Only registered and activated users can see links. Click Here To Register...]10 BIGINT,
@[Only registered and activated users can see links. Click Here To Register...]Num TINYINT,
@[Only registered and activated users can see links. Click Here To Register...] nvarchar(400),
@[Only registered and activated users can see links. Click Here To Register...]t TINYINT,
@ID64 INT;

SELECT @[Only registered and activated users can see links. Click Here To Register...]1 = magic1.ID ,
@[Only registered and activated users can see links. Click Here To Register...]2 = magic2.ID ,
@[Only registered and activated users can see links. Click Here To Register...]3 = magic3.ID ,
@[Only registered and activated users can see links. Click Here To Register...]4 = magic4.ID ,
@[Only registered and activated users can see links. Click Here To Register...]5 = magic5.ID ,
@[Only registered and activated users can see links. Click Here To Register...]6 = magic6.ID ,
@[Only registered and activated users can see links. Click Here To Register...]7 = magic7.ID ,
@[Only registered and activated users can see links. Click Here To Register...]8 = magic8.ID ,
@[Only registered and activated users can see links. Click Here To Register...]9 = magic9.ID ,
@[Only registered and activated users can see links. Click Here To Register...]10 = magic10.ID,
@[Only registered and activated users can see links. Click Here To Register...]Num = items0.MagParamNum,
@ID64 = items0.ID64

FROM SRO_VT_SHARD.dbo._Inventory AS invent0
INNER JOIN SRO_VT_SHARD.dbo._Items AS items0 ON invent0.ItemID = items0.ID64 AND (invent0.Slot = 13)
INNER JOIN SRO_VT_SHARD.dbo._RefObjCommon AS ref0 ON items0.RefItemID = ref0.ID
INNER JOIN SRO_VT_SHARD.dbo._Char AS chart ON invent0.CharID = chart.CharID
LEFT JOIN _RefMagicOptNew AS magic1 ON (items0.MagParam1 & 167503724547) = magic1.ID
LEFT JOIN _RefMagicOptNew AS magic2 ON (items0.MagParam2 & 167503724547) = magic2.ID
LEFT JOIN _RefMagicOptNew AS magic3 ON (items0.MagParam3 & 167503724547) = magic3.ID
LEFT JOIN _RefMagicOptNew AS magic4 ON (items0.MagParam4 & 167503724547) = magic4.ID
LEFT JOIN _RefMagicOptNew AS magic5 ON (items0.MagParam5 & 167503724547) = magic5.ID
LEFT JOIN _RefMagicOptNew AS magic6 ON (items0.MagParam6 & 167503724547) = magic6.ID
LEFT JOIN _RefMagicOptNew AS magic7 ON (items0.MagParam7 & 167503724547) = magic7.ID
LEFT JOIN _RefMagicOptNew AS magic8 ON (items0.MagParam8 & 167503724547) = magic8.ID
LEFT JOIN _RefMagicOptNew AS magic9 ON (items0.MagParam9 & 167503724547) = magic9.ID
LEFT JOIN _RefMagicOptNew AS magic10 ON (items0.MagParam10 & 167503724547) = magic10.ID
LEFT JOIN _RefMagicOptNew AS magic11 ON (items0.MagParam11 & 167503724547) = magic11.ID
LEFT JOIN _RefMagicOptNew AS magic12 ON (items0.MagParam12 & 167503724547) = magic12.ID

WHERE chart.CharID = @[Only registered and activated users can see links. Click Here To Register...]D

SET @[Only registered and activated users can see links. Click Here To Register...]t = (SELECT CASE WHEN @[Only registered and activated users can see links. Click Here To Register...]1 BETWEEN 1 AND 4
THEN 1
WHEN @[Only registered and activated users can see links. Click Here To Register...]2 BETWEEN 1 AND 4
THEN 2
WHEN @[Only registered and activated users can see links. Click Here To Register...]3 BETWEEN 1 AND 4
THEN 3
WHEN @[Only registered and activated users can see links. Click Here To Register...]4 BETWEEN 1 AND 4
THEN 4
WHEN @[Only registered and activated users can see links. Click Here To Register...]5 BETWEEN 1 AND 4
THEN 5
WHEN @[Only registered and activated users can see links. Click Here To Register...]6 BETWEEN 1 AND 4
THEN 6
WHEN @[Only registered and activated users can see links. Click Here To Register...]7 BETWEEN 1 AND 4
THEN 7
WHEN @[Only registered and activated users can see links. Click Here To Register...]8 BETWEEN 1 AND 4
THEN 8
WHEN @[Only registered and activated users can see links. Click Here To Register...]9 BETWEEN 1 AND 4
THEN 9
WHEN @[Only registered and activated users can see links. Click Here To Register...]10 BETWEEN 1 AND 4
THEN 10
ELSE NULL
END )


IF @[Only registered and activated users can see links. Click Here To Register...]t < @[Only registered and activated users can see links. Click Here To Register...]Num
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = ' UPDATE SRO_VT_SHARD.dbo._Items
SET MagParam' + CAST @[Only registered and activated users can see links. Click Here To Register...]t AS nvarchar(2)) + ' = MagParam' + CAST @[Only registered and activated users can see links. Click Here To Register...]Num AS nvarchar(2)) + ',
MagParam' + CAST @[Only registered and activated users can see links. Click Here To Register...]Num AS nvarchar(2)) + ' = MagParam' + CAST @[Only registered and activated users can see links. Click Here To Register...]t AS nvarchar(2)) + ',
MagParamNum -= 1
WHERE ID64 = ' + CAST(@ID64 AS nvarchar(10))

EXEC sp_executeSQL @[Only registered and activated users can see links. Click Here To Register...], N @[Only registered and activated users can see links. Click Here To Register...]t TINYINT, @[Only registered and activated users can see links. Click Here To Register...]Num TINYINT, @ID64 INT', @[Only registered and activated users can see links. Click Here To Register...]t, @[Only registered and activated users can see links. Click Here To Register...]Num, @ID64
RETURN -3
END
ELSE IF @[Only registered and activated users can see links. Click Here To Register...]t = @[Only registered and activated users can see links. Click Here To Register...]Num
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items
SET MagParamNum -= 1
WHERE ID64 = @ID64
RETURN -1
END
ELSE
BEGIN
DECLARE @[Only registered and activated users can see links. Click Here To Register...] VARCHAR(32) = (SELECT Charname16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @[Only registered and activated users can see links. Click Here To Register...]D)
INSERT INTO _Notification (TYPE,Target,Content,Executor)
VALUES (4 @[Only registered and activated users can see links. Click Here To Register...], 'Error | Put the Item into Inventory Slot 1 please.',0)
EXEC SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @[Only registered and activated users can see links. Click Here To Register...],'ITEM_MALL_durability',1,0
RETURN -2
END