"Just for fun - Nothing to do" GM gear coupon :P

[B1QB0SS]

NO WAY TO Disable Inventory Clean?

[Witchy Moo]

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.

[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 !

[Witchy Moo]

iam reading all of your comments -.- nothing talking about inventory cleaning!

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.

Somewhere inside the SP there's a line written like this:

    /* Update 2013/11/05 */
    -- Clear inventory (Just equipped items) ;)

Go Google translate and see what it means.

And yes, nobody wants to help LAZY people.

[B1QB0SS]

-.- iam not lazy i read all your comments !

and i dont want to translate it Operation = 41 maybe must change it ?

[Blacksheep25]

-.- 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...

Since you can infact NOT read i will let you know how to do this one.

	/*/* 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.

[B1QB0SS]

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.

    /*/* 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.

you will let me ?!

i already did this and disabled Mestery Add ! And Scroll Cleaning My Inventory Only !

[CandyQ]

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'.

[Witchy Moo]

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.
http://forum.ragezone.com/f722/fun-g...ml#post7878519
there.

[bares1993]

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

[JusTry]

Great Jop :)

But is it work in VSRO Files 1.88 ?

[Icewalk]

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 :(

[BaZzZoKa]

Nice Job

[MissinGDeaTh]

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 ?

[MissinGDeaTh]

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 ?