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

[Blacksheep25]

where i can change Items plus ?!

In the AddLogItem procedure

IF (@Operation = 41) -- scroll is used
BEGIN
IF (@ItemRefID BETWEEN 46027 AND 46029) -- GM coupon
BEGIN
DECLARE @CharName VARCHAR(64) = (SELECT CharName16 from [SRO_VT_SHARD].[dbo].[_Char] WHERE CharID = @CharID)
DECLARE @GearType VARCHAR(16) =
CASE
WHEN @ItemRefID = 46027 THEN 'HEAVY'
WHEN @ItemRefID = 46028 THEN 'LIGHT'
WHEN @ItemRefID = 46029 THEN 'CLOTHES'
END
-- 11 = Degree, 16 = Plus
EXEC [SRO_VT_SHARD].[dbo].[_ADD_GM_GEAR] @CharName, @GearType, 11, 16
END
END

Green = Degree Item
Red = Item Plus

[B1QB0SS]

teleporting me only

and nothing happens !

So any Fix for teleport only ?!

Good item Return Scroll h3

[Blacksheep25]

If I didn't delete my vsro server files on my test server to put the new 110 cap BR files on it and had a client to use I would be fixing this issue for you while you wait for a reply from witchymoo. Can't help at the moment with no client :P

Edit: Almost forgot, if you have edited the DB table ID's make sure you edit them media side as well, that will be why you guys arent getting anything after it teleports you.

[B1QB0SS]

stop releasing not working things !

[OutOfMemory]

stop releasing not working things !

Everything is working fine.

if you get nothing just change this.

SELECT @GMLevel = sec_primary, @AccountName = StrUserID FROM [SRO_VT_ACCOUNT].[dbo].[TB_User] WHERE JID = @UserJID
IF (@GMLevel IS NULL OR (@GMLevel !=1 OR @GMLevel !=4 ))
BEGIN

[B1QB0SS]

great i'll try

Still getting Nothing !

[Witchy Moo]

i know i edit every Thing , and open the and USe The Scroll , But Nothing Happen

Hey there, when you use the scroll, did it teleports you back to town?, if it does, means the New SP didn't work for you, in which case it returns some errors due to condition placed in the SP, one of the way to check it is to run the SP directly from Query window, like this:

EXEC [_ADD_GM_GEAR] 'yourchar', 'LIGHT', <degree>, <plus>

(You can change the LIGHT to HEAVY, or CLOTHES)

The SP will spam your SQL output window, see if it stops somewhere. This is the example of successful output (see the red marks):



Good luck ;)

In the AddLogItem procedure

Green = Degree Item
Red = Item Plus

Thank you :)) +1

stop releasing not working things !

It works fine, you gotta understand how it works so you can trace if it doesn't work for you

return scroll trigger (client side, TypeID3 3 TypeID4 3) -> calls _AddLogItem SP -> calls _ADD_GM_GEAR SP

so, if your char scrolled back, scroll gone, (successful return scroll), and you didn't get any items, means the SP didn't work for you, like I mentioned in previous answer, check the SP output by running it manually from SQL query window, like this:

EXEC [_ADD_GM_GEAR] 'yourchar', 'LIGHT', <degree>, <plus>

(You can change the LIGHT to HEAVY, or CLOTHES) See if you got successful output. Then use teleport your char manually using /gotown or something, see if you got the item.

good luck ;)

teleporting me only

and nothing happens !

So any Fix for teleport only ?!

Good item Return Scroll h3

Well, teleports works, means the SP didn't. Run the SP manually from SQL query window (see previous answer), and post the output here.

PS: sorry for late answers, I slept early last night :P, blacksheep25, thank you for answering

[B1QB0SS]

i want scroll to work ! there's any waY?

Msg 201, Level 16, State 4, Procedure _ADD_GM_GEAR, Line 0
Procedure or function '_ADD_GM_GEAR' expects parameter '@EQPlus', which was not supplied.

[Witchy Moo]

i want scroll to work ! there's any waY?

Msg 201, Level 16, State 4, Procedure _ADD_GM_GEAR, Line 0
Procedure or function '_ADD_GM_GEAR' expects parameter '@EQPlus', which was not supplied.

EXEC [_ADD_GM_GEAR] 'yourchar', 'LIGHT', <degree>, <plus>

Did you miss anything? :) And don't forget to wear any weapon before executing.

[B1QB0SS]

EXEC [_ADD_GM_GEAR] 'yourchar', 'LIGHT', <degree>, <plus>

Did you miss anything? :) And don't forget to wear any weapon before executing.

Aha you forgot LIGHT Line!

Btw try to fix this scroll really need it !

[Witchy Moo]

Aha you forgot LIGHT Line!

Btw try to fix this scroll really need it !

Scroll works fine, in your case, the SP didn't, what's the output of your SP execution?

[B1QB0SS]

lol


Account ID associated with this char: theb0ss, does not have GM prvileges. Sequence canceled!
Msg 50000, Level 1, State 16


sec_Primary=1

Content = 1 !!

what's wrong ?

Give me The Lines Again!

[Witchy Moo]

lol


Account ID associated with this char: theb0ss, does not have GM prvileges. Sequence canceled!
Msg 50000, Level 1, State 16


sec_Primary=1

Content = 1 !!

what's wrong ?

Give me The Lines Again!

There you go, there's your error, like OutOfMemory mentioned above, seems your char didn't have GM privileges :)

Check by doing this in your SQL Query window:

DECLARE @GMLevel INT = (SELECT sec_primary FROM [SRO_VT_ACCOUNT].[dbo].[TB_User] WHERE JID = <YOUR_ACCOUNT_ID>)
PRINT @GMLevel

Make sure the output is "1"

[B1QB0SS]

it's already 1

if iwant to delete this primary check !

because i'll make it a scroll for normal players!

[Witchy Moo]

it's already 1

Then it should work. Unless your SQL got wrong value when doing "IF (@GMLevel IS NULL OR (@GMLevel > 6 AND @GMLevel < 10))" :)

Quick fix for you, simply remark the whole GM check sequence by adding /* and */, like this:

        /*
    PRINT 'Validating GM Level...'
    SELECT @GMLevel = sec_primary, @AccountName = StrUserID FROM [SRO_VT_ACCOUNT].[dbo].[TB_User] WHERE JID = @UserJID
    IF (@GMLevel IS NULL OR (@GMLevel > 6 AND @GMLevel < 10))
    BEGIN
        RAISERROR('Account ID associated with this char: %s, does not have GM prvileges. Sequence canceled!', 1, 16, @AccountName)
        RETURN -3
    END
    */

it's already 1

if iwant to delete this primary check !

because i'll make it a scroll for normal players!

Check previous answer