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

[P0kemonMast]

nope im getting this

Msg 8115, Level 16, State 2, Procedure _ADD_GM_GEAR, Line 29
Arithmetic overflow error converting expression to data type int.
Validating Character...
Validating Account ID...
Validating GM Level...
Validating race and gender...
Race code is: CH, gender code is: W.
Validating equipped weapon...
Checking if character is using shield...
Setting up item codenames...
Getting item reference ID and link...
Invalid item reference ID, check item codename (degree parameter or item suffix setting). Sequence canceled!
Msg 50000, Level 1, State 16

 

[CoderWaxy]

Not Work i Tested it

y+1 pokemon i get this error too

 

[Witchy Moo]

nope im getting this

"Invalid item reference ID, check item codename (degree parameter or item suffix setting). Sequence canceled!"

There, it's not SP error, but one of items there doesn't exist in your DB or Media, seems you didn't read the first post about "SETTINGS":

Stuff that NEEDED TO BE CHANGED in that NEW SP ("SETTINGS" section):

    -- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
    -- @@@ BEGIN: SETTINGS
    
    -- CHANGE THIS! -- CHANGE THIS! -- CHANGE THIS! (if needed)

    -- (Represent ITEM_CH_BOW_11_SET_B_RARE), change as you need it
    DECLARE @GearSuffix VARCHAR(16) = 'SET_B_RARE'

    -- (Represent ITEM_ETC_AVATAR_W_GM_UNIFORM), change as you need it
    DECLARE @uniSuffix VARCHAR(16) = 'GM_UNIFORM'

    -- (Represent ITEM_MALL_AVATAR_W_NASRUN_S_BLUE), change as you need it
    DECLARE @DSSuffix VARCHAR(16) = 'NASRUN_S_BLUE'

    -- Represent custom title, change as you need it
    DECLARE @HwanLevel TINYINT = 9

    -- Change these if you want
    DECLARE @Strength INT = 10000
    DECLARE @Intellect INT = 10000
    DECLARE @RemainGold INT = 1000000000
    DECLARE @RemainSkillPoint INT = 15000000
    DECLARE @InventorySize INT = 93

    -- Gift Silk
    DECLARE @GiftSilk INT = 1000

    -- @@@ END: SETTINGS
    -- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

BE SURE you change those settings to match your DB or Media, I think i put enough understandable comments about it.

Let me break it down, for example, if you set:

DECLARE @GearSuffix VARCHAR(16) = 'C_RARE'
Means it will represent: "ITEM_<race>_<item>_<degree>_C_RARE" (For example: ITEM_CH_BOW_11_C_RARE) <-- is this item exist?

Goes the same for other settings. Verify if your item exist.

Not Work i Tested it

y+1 pokemon i get this error too

Yep, it won't work for you (same invalid item reference code error) if you only copy-paste it without verifying if the ITEM EXIST in your db or Media

Weapon/gear/accessory, Devil Spirit, GM avatar represented by each codes must exist in your DB or Media

 

[P0kemonMast]

Oh wow thanks. Found the problem , never knew i did not have the "NASRUN_S_BLUE" or any of the 'S' versions.

 

[Witchy Moo]

Oh wow thanks. Found the problem , never knew i did not have the "NASRUN_S_BLUE" or any of the 'S' versions.

Excellent, nice work. sorry about that, since I have custom devil spirit code in my db

 

[Blacksheep25]

Excellent, nice work. sorry about that, since I have custom devil spirit code in my db

I would change that to the original Devil S itemcode in your code on the first post so more people don't post the same errors consistently.

 

[Witchy Moo]

I would change that to the original Devil S itemcode in your code on the first post so more people don't post the same errors consistently.

I would, but still, whoever gonna use it must check either any of those items exist in their DB, not only about the devil spirit. Say we put general devil spirit in the example then they have problem with other items, it's just the same problem

Anyway, thank you

 

[B1QB0SS]

atleast fixed the query let's fix the scroll

This Scroll working for

witchymoo only!

 

[Blacksheep25]

If you do it correctly the scroll works fine.

 

[B1QB0SS]

If you do it correctly the scroll works fine.

so i'll try to do it again !

how to make sure AddLogItem Working ?!

Still Not Working!!


Any Solution ?


or Give Us your Scroll !

 

[Blacksheep25]

I'm not personally using the scroll myself, I have only looked at the code for it and everything looks fine.

I'll import it into my files now and see if i experience the same issues you guys are facing.

 

[Witchy Moo]

atleast fixed the query let's fix the scroll

This Scroll working for

witchymoo only!

Well,

This Scroll is NOT working for

B1QB0SS only

so i'll try to do it again !

how to make sure AddLogItem Working ?!

Still Not Working!!


Any Solution ?


or Give Us your Scroll !

To make sure "_AddLogItem" working?.. simply query the _LogEventItem table

If your server didn't log anything, means the scroll will never work, goes the same with other scrolls made by other people that use same "return scroll" type method. see if _LogEventItem has records. You can test if it works or not by just using normal return scroll. If it's empty, means your server didn't log anything... that's entirely another matter.

If you do it correctly the scroll works fine.

+1

 

[Blacksheep25]

Yeah, im getting the same issue they are having

I'm guessing since my _LogEventItem tables are empty that it needs additional work in the new 110 BR database.

Validating Character...
Validating Account ID...
Validating race and gender...

Validating equipped weapon...
Checking if character is using shield...
Setting up item codenames...
Getting item reference ID and link...
Invalid item reference ID, check item codename (degree parameter or item suffix setting). Sequence canceled!
Msg 50000, Level 1, State 16

All the items exist in my SETTINGS values, so yeah its something to do with the Log database.

 

[Witchy Moo]

Hey there

"Invalid item reference ID, check item codename (degree parameter or item suffix setting). Sequence canceled!"

If that error you got, means one of the item doesn't exist, either the gear item code, nasrun code, or gm avatar.

And about the _AddLogItem SP, if your server is VSRO 1.88 and the server didn't log anything, check if you use "Evangelion" SR_GameServer, if you're using it... as I wrote in first post, you have to set the server so it logs everything, simply by editing the "misc.ini" file and set "disableLog = 0", and restart game server

My misc.ini file:

[misc]
disableMsg = 0
disableLog = 0

 

[Blacksheep25]

Yeah its weird tho, because my items defiently exist in both the DB and media, I can even spawn and use them ingame. And I'm not running Evangelion, don't think there's one for the latest 110 cap BR files.

Upon further inspection, after creating a chinese character and trying the scroll it worked. It seems its not working for female euro characters.

 

[Witchy Moo]

Yeah its weird tho, because my items defiently exist in both the DB and media, I can even spawn and use them ingame. And I'm not running Evangelion, don't think there's one for the latest 110 cap BR files.

Upon further inspection, after creating a chinese character and trying the scroll it worked. It seems its not working for female euro characters.

Or one of the female euro item don't exist , as you can see in my video, I definitely use euro character.

Perhaps you can inform me what female euro char, what type of gear and weapon you failed to make? So i can make simulation of it

 

[Blacksheep25]

I tried a female euro wizard with robe. Figure: Rhena.

 

[Witchy Moo]

I tried a female euro wizard with robe. Figure: Rhena.

Alright let me prepare video for you

 

[B1QB0SS]

Okay in LogEventitem

Nothing!

can you give me Chernobyl SRGAMESERVER?

okay iam using evangelion Gameserver and disabelog=0

and restarted gameserver

and used the scroll

in LogEventItem Found Nothing!

 

[Blacksheep25]

Well it works in your video witchymoo, might be a problem with blackrogue 110 DB.