Hi again, i got another problem (yay) with the scroll now (didn't do anything special after i got it working)... When i use the scroll i get tped to town like any scroll would do, inventory is cleaned but i don't have any items and when i teleport again i get stuck in loading screen. And if i just close the client when i'm stuck @ the loading screen, i can't login again unless i restart sql server.
(add exelja @ skype if you want to talk there)
USE [SRO_VT_SHARD]
GO
DECLARE @CharID INT = <YourCharIDHere>
DECLARE @TSlots INT = 0
DECLARE @CharSlot INT = 0
SELECT @TSlots = COUNT(Slot) from _Inventory WHERE CharID = @CharID
WHILE @CharSlot <= @TSlots
BEGIN
EXEC [_STRG_DEL_ITEM_NoTX] 1, @CharID, @CharSlot
SET @CharSlot = @CharSlot + 1
END
i make all step but when i open scroll nothing happen and i'm not see any item in my char
EXEC [SRO_VT_SHARD].[dbo].[_ADD_GM_GEAR] 'yourcharname', 'LIGHT', <degree>, <plus>
NO WAY TO Disable Inventory Clean?
iam reading all of your comments -.- nothing talking about inventory cleaning!
/* Update 2013/11/05 */
-- Clear inventory (Just equipped items) ;)
-.- iam not lazy i read all your comments !
and i dont want to translate it Operation = 41 maybe must change it ?
/*/* Update 2013/11/05 */
-- Clear inventory (Just equipped items) ;)
PRINT 'Removing equipped items...'
DECLARE @TSlots INT
DECLARE @CharSlot INT
SET @CharSlot = 0
SELECT @TSlots = COUNT(Slot) from _Inventory WHERE CharID = @CharID
WHILE @CharSlot <= @TSlots
BEGIN
-- IF (@CharSlot < 6 OR (@CharSlot > 7 AND @CharSlot < 13))
-- IF (@CharSlot < 13)
-- BEGIN
EXEC [_STRG_DEL_ITEM_NoTX] 1, @CharID, @CharSlot
-- END
SET @CharSlot = @CharSlot + 1
END*/
no.. if you read what it said after it then you would see it means that Operation 41 = Scroll used...
Since you can infact NOT read i will let you know how to do this one.
Code:/*/* Update 2013/11/05 */ -- Clear inventory (Just equipped items) ;) PRINT 'Removing equipped items...' DECLARE @TSlots INT DECLARE @CharSlot INT SET @CharSlot = 0 SELECT @TSlots = COUNT(Slot) from _Inventory WHERE CharID = @CharID WHILE @CharSlot <= @TSlots BEGIN -- IF (@CharSlot < 6 OR (@CharSlot > 7 AND @CharSlot < 13)) -- IF (@CharSlot < 13) -- BEGIN EXEC [_STRG_DEL_ITEM_NoTX] 1, @CharID, @CharSlot -- END SET @CharSlot = @CharSlot + 1 END*/
All you need to do is comment out that whole section and it will not clear the inventory. Which i have done for you.
Msg 166, Level 15, State 1, Line 1
'CREATE/ALTER PROCEDURE' does not allow specifying the database name as a prefix to the object name.
Msg 208, Level 16, State 6, Procedure _ADD_GM_GEAR, Line 570
Invalid object name 'dbo._ADD_GM_GEAR'.