[Solved] I need help

[nuker2151]

Hi guys , I would like to make a scroll however I do not know the procedure . I want when I press the scroll all the wearable items go to the inventory. Would someone help me with this issue.
Slot 0 to 13

[Devsome]

#moved

[nuker2151]

I m Sorry

[VeRo!]

Here it is

 Spoiler

DECLARE @I INT = 0

WHILE @I <= 12
BEGIN
DECLARE @ItemToMove BIGINT = (SELECT ItemID FROM SRO_VT_SHARD.._Inventory WHERE CharID = @CharID AND Slot = @I)
DECLARE @NewSlot BIGINT = (SELECT TOP 1 Slot FROM _Inventory WHERE CharID = @CharID AND (ItemID = 0 OR ItemID IS NULL) AND Slot >= 13)

IF @NewSlot IS NOT NULL AND @ItemToMove IS NOT NULL
BEGIN
UPDATE SRO_VT_SHARD.._Inventory SET ItemID = 0 WHERE CharID = @CharID AND Slot = @I
UPDATE SRO_VT_SHARD.._Inventory SET ItemID = @ItemToMove WHERE CharID = @CharID AND Slot = @NewSlot
END

ELSE
BEGIN
SELECT 'Slot Not Found'
RETURN;
END

SET @I+=1
END

[nuker2151]

This for additemlog

Originally Posted by VeRo!

Here it is

 Spoiler

This not working

[Over56]

Originally Posted by nuker2151

This for additemlog



This not working

use operation 41 + scroll id (refobjcommon id) to execute the query above

[nuker2151]

Sorting out thank you much
🔐