Maxmium durability stats Procedure helps

[modyuasty3]

Hello Guy's this Procedure Scroll Remove Maxmium Durability

i have question how this Procedure to scroll i try to work it but can't or have something wrong ithink .. i hope helps thanks!

 Spoiler

DECLARE @1 BIGINT,
@2 BIGINT,
@3 BIGINT,
@4 BIGINT,
@5 BIGINT,
@6 BIGINT,
@7 BIGINT,
@8 BIGINT,
@9 BIGINT,
@10 BIGINT,
@Num TINYINT,
@ nvarchar(400),
@t TINYINT,
@ID64 INT;

SELECT @1 = magic1.ID ,
@2 = magic2.ID ,
@3 = magic3.ID ,
@4 = magic4.ID ,
@5 = magic5.ID ,
@6 = magic6.ID ,
@7 = magic7.ID ,
@8 = magic8.ID ,
@9 = magic9.ID ,
@10 = magic10.ID,
@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 = @D

SET @t = (SELECT CASE WHEN @1 BETWEEN 1 AND 4
THEN 1
WHEN @2 BETWEEN 1 AND 4
THEN 2
WHEN @3 BETWEEN 1 AND 4
THEN 3
WHEN @4 BETWEEN 1 AND 4
THEN 4
WHEN @5 BETWEEN 1 AND 4
THEN 5
WHEN @6 BETWEEN 1 AND 4
THEN 6
WHEN @7 BETWEEN 1 AND 4
THEN 7
WHEN @8 BETWEEN 1 AND 4
THEN 8
WHEN @9 BETWEEN 1 AND 4
THEN 9
WHEN @10 BETWEEN 1 AND 4
THEN 10
ELSE NULL
END )


IF @t < @Num
BEGIN
SET @ = ' UPDATE SRO_VT_SHARD.dbo._Items
SET MagParam' + CAST @t AS nvarchar(2)) + ' = MagParam' + CAST @Num AS nvarchar(2)) + ',
MagParam' + CAST @Num AS nvarchar(2)) + ' = MagParam' + CAST @t AS nvarchar(2)) + ',
MagParamNum -= 1
WHERE ID64 = ' + CAST(@ID64 AS nvarchar(10))

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

[NorseGodTyr]

add this as procedure and let an item exec this procedure

[modyuasty3]

Originally Posted by NorseGodTyr

add this as procedure and let an item exec this procedure

how ? i not understand what do !

[NorseGodTyr]

Originally Posted by modyuasty3

how ? i not understand what do !

add this in _AddLogItem

IF (@Operation = 41 and @RefID = 42025) -- ScrollID from RefObjCommon
Begin
Execute [SRO_VT_SHARDLOG].[dbo].[_StatsProcedure] @D
End


The Procedure is added in attachment

[NorseGodTyr]

dont forget to change 42025 to your item ID

[modyuasty3]

Originally Posted by NorseGodTyr

dont forget to change 42025 to your item ID

i think my procedure not work yet! -.-