Printable View
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)
Try clearing your inventory first directly from SQL, perhaps some of the item in the code are in disabled state or something.Quote:
Originally Posted by Exelja
The fastest way to clear character inventory:
Put your char ID there and run it.Code: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
Run this, see if you got any error.Quote:
Originally Posted by xaviar
<degree> = item degreeCode:EXEC [SRO_VT_SHARD].[dbo].[_ADD_GM_GEAR] 'yourcharname', 'LIGHT', <degree>, <plus>
<plus> = item plus
NO WAY TO Disable Inventory Clean?
There is if you EVER READ AND LEARN the query code. Ah sorry, not EVEN the code, you didn't even read my comments, which I put there for clue. Since you're only doing copy-paste-and-use-then-complaint then there's nothing you can do about anything.Quote:
Originally Posted by B1QB0SS
iam reading all of your comments -.- nothing talking about inventory cleaning!
and when i teleported i found nothing and everything in my inventory deleted -.-
i mean when i teleport everything in my inventory deleted and i found nothing !
Perhaps you just CAN'T READ. or you just too lazy to read and you just tell that you read it, but you didn't.Quote:
Originally Posted by B1QB0SS
Somewhere inside the SP there's a line written like this:
Go Google translate and see what it means.Code:/* Update 2013/11/05 */
-- Clear inventory (Just equipped items) ;)
And yes, nobody wants to help LAZY people.
-.- iam not lazy i read all your comments !
and i dont want to translate it Operation = 41 maybe must change it ?
no.. if you read what it said after it then you would see it means that Operation 41 = Scroll used...Quote:
Originally Posted by B1QB0SS
Since you can infact NOT read i will let you know how to do this one.
All you need to do is comment out that whole section and it will not clear the inventory. Which i have done for you.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*/
you will let me ?!Quote:
Originally Posted by blacksheep25
i already did this and disabled Mestery Add ! And Scroll Cleaning My Inventory Only !
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'.
Some got same problem before, you might actually find the answer if you ever -read- through the thread replies.Quote:
Originally Posted by CandyQ
http://forum.ragezone.com/f722/fun-g...ml#post7878519
there.
if i use scroll i get this http://prntscr.com/3pr3yg
and nothing happens after and cant logg in my char anymore
when i clean up my inventory by --> Update _Inventory set ItemID = 0 where CharID = 6703
than logg in nacked again
but if i wear any weapon and use scroll he start to teleport but dont finish it
Great Jop :)
But is it work in VSRO Files 1.88 ?
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 558
Invalid object name 'dbo._ADD_GM_GEAR'.
help :(
Nice Job
Msg 134, Level 15, State 1, Procedure _AddLogItem, Line 96
The variable name '@CharName' has already been declared. Variable names must be unique within a query batch or stored procedure.
how to fix this ?
Msg 8101, Level 16, State 1, Line 1
An explicit value for the identity column in table '_RefObjCommon' can only be specified when a column list is used and IDENTITY_INSERT is ON.
any idea ?