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

[Exelja]

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)

 

[Witchy Moo]

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.

 

[Witchy Moo]

The fastest way to clear character inventory:

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

Put your char ID there and run it.

 

[xaviar]

i make all step but when i open scroll nothing happen and i'm not see any item in my char

 

[Witchy Moo]

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.

EXEC [SRO_VT_SHARD].[dbo].[_ADD_GM_GEAR] 'yourcharname', 'LIGHT', <degree>, <plus>

<degree> = item degree
<plus> = item plus

 

[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-gm-gear-coupon-971238/index3.html#post7878519
there.

 

[bares1993]

if i use scroll i get this

You must be registered to see links

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 ?