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
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
[HELP]HELP HELP HELP[HELP] 09/23/2013 - Facebook - 3 Replies GUYS ^^ THIS IS A HELP THREAD NOT REQUEST THREAD BUT YOU CAN CONSIDER IT AS REQUEST THREAD
DOES ANYONE OF YOU KNOW THE AUTO SUBMIT PHP CODE? THANKS!
help help help help help help 06/28/2009 - Say Hello - 0 Replies how i can dowmload Mangos 6385 ???????????????????????????????????
please give me the limk i can't see that
i know it is in www.elitepvpers.com/.../153716-release-mangos-relea ses-blackscorpian-win32-2-4-3-a.html -
but give me link sent it to my email plz