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

Witchy Moo · Nov 24, 2013

Hello

I'd like to share something that I made just for fun, nothing useful about it I think, I had nothing to do at the time, so...

tt1:

I call this "GM special equipment coupon", you can give this to your GM using /makeitem or _ADD_ITEM_EXTERN Stored procedure

What it does? It remove everything from your GM inventory and adds all sorts of new power equipment (which you can change yourself in the SP)
What equipment does it add? Read the item description on the screenshot
Any requirements? Just one, your GM must wear any equipment set and weapon (level 1 or whatever)
How to use? just right click on it.
Anything else? BE SURE you change parameters in SETTINGS section part in the Stored procedure to match your database items. (Read about NEW SP below)

Now the boring part: :closedeyes:

- Database:

_RefObjCommon

Code:

INSERT INTO _RefObjCommon VALUES (1,46027,'ITEM_GM_GEAR_HA_COUPON','???? ???? ??? (???)','xxx','SN_ITEM_GM_GEAR_HA_COUPON','SN_ITEM_GM_GEAR_COUPON_TT_DESC',1,0,3,3,3,1,180000,3,0,1,1,1,3,0,1,0,0,129,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,0,0,0,0,0,0,0,100,0,0,0,'xxx','item\etc\drop_mall_scroll.bsr','item\etc\coupon_avatar.ddj','xxx','xxx',46027)
INSERT INTO _RefObjCommon VALUES (1,46028,'ITEM_GM_GEAR_LA_COUPON','???? ???? ??? (???)','xxx','SN_ITEM_GM_GEAR_LA_COUPON','SN_ITEM_GM_GEAR_COUPON_TT_DESC',1,0,3,3,3,1,180000,3,0,1,1,1,3,0,1,0,0,129,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,0,0,0,0,0,0,0,100,0,0,0,'xxx','item\etc\drop_mall_scroll.bsr','item\etc\coupon_avatar.ddj','xxx','xxx',46028)
INSERT INTO _RefObjCommon VALUES (1,46029,'ITEM_GM_GEAR_GA_COUPON','???? ???? ??? (???)','xxx','SN_ITEM_GM_GEAR_GA_COUPON','SN_ITEM_GM_GEAR_COUPON_TT_DESC',1,0,3,3,3,1,180000,3,0,1,1,1,3,0,1,0,0,129,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,0,0,0,0,0,0,0,100,0,0,0,'xxx','item\etc\drop_mall_scroll.bsr','item\etc\coupon_avatar.ddj','xxx','xxx',46029)

_RefObjItem

Code:

INSERT INTO _RefObjItem VALUES (46027,1,2,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5000,'????',1,'??????',-1,'RESURRECT',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',0,0,0)
INSERT INTO _RefObjItem VALUES (46028,1,2,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5000,'????',1,'??????',-1,'RESURRECT',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',0,0,0)
INSERT INTO _RefObjItem VALUES (46029,1,2,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5000,'????',1,'??????',-1,'RESURRECT',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',0,0,0)

- Stored procedure in [SRO_VT_SHARD] database (NEW): View attachment SRO_VT_SHARD - [SP] - _ADD_GM_GEAR.sql.txt

Updates:

Default value of gear type setting sets to "C_RARE" cause not all degree has "SET" attribute.
GM level check disabled (you can re-enable if you need it)
Now automatically adds leading "0" when SP called using single digit degree parameter. (Example: the parse of '7' becomes '07' automatically) (Thanks to P0kemonMast for testing)
Update to @RefCharID for Euro Char on BR110 db (Thanks to blacksheep25 for information)

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

Code:

    -- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
    -- @@@ 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) = 'C_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
    -- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

- Stored procedure in [SRO_VT_LOG] database: (ADD THIS IN YOUR EXISTING _AddLogItem procedure, you can put at the most bottom line if you want)

Code:

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 = Da PLUS
        EXEC [SRO_VT_SHARD].[dbo].[_ADD_GM_GEAR] @CharName, @GearType, 11, 16
    END
END

- Media:

itemdata_45000.txt: View attachment itemdata_45000.txt

textdata_object.txt: View attachment textdata_object.txt

DDJ: (put it in Media\icon\item\etc\coupon_avatar.ddj)

You must be registered to see links

NOTES:

You need to make sure that your "_AddLogItem" procedure is working. So If you use Evangelion SR_GameServer, you should set "disableLog = 0" in misc.ini and restart the gameserver.
And also, you can always utilize the new SP directly from SQL query window if you want, simply by doing: "EXEC [SRO_VT_SHARD].[dbo].[_ADD_GM_GEAR] 'Charnamehere', 'LIGHT', Degree, Plus" (change the LIGHT to HEAVY or CLOTHES)

This scroll supposed to be for GM, but if you want this for normal players, simply remark the GM level check in the SP, like this:

Code:

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

Video:

Screens:

- Before:

Witchy Moo - "Just for fun - Nothing to do" GM gear coupon :P - RaGEZONE Forums

- After:

Good luck and have fun

CoderWaxy · Nov 25, 2013

Good Job

ongamanext · Nov 25, 2013

Good Gzz

witchymoo said:
Hello

I'd like to share something that I made just for fun, nothing useful about it I think, I had nothing to do at the time, so... tt1:

I call this "GM special equipment coupon", you can give this to your GM using /makeitem or _ADD_ITEM_EXTERN Stored procedure

What it does? It remove everything from your GM inventory and adds all sorts of new power equipment (which you can change yourself in the SP)

What equipment does it add? Read the item description on the screenshot

Any requirements? Just one, your GM must wear any equipment set and weapon (level 1 or whatever)

How to use? just right click on it.

Anything else? BE SURE you change parameters in SETTINGS section part in the Stored procedure to match your database items. (Read about NEW SP below)

Now the boring part: :closedeyes:

- Database:

_RefObjCommon

Code:

INSERT INTO _RefObjCommon VALUES (1,46027,'ITEM_GM_GEAR_HA_COUPON','???? ???? ??? (???)','xxx','SN_ITEM_GM_GEAR_HA_COUPON','SN_ITEM_GM_GEAR_COUPON_TT_DESC',1,0,3,3,3,1,180000,3,0,1,1,1,3,0,1,0,0,129,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,0,0,0,0,0,0,0,100,0,0,0,'xxx','item\etc\drop_mall_scroll.bsr','item\etc\coupon_avatar.ddj','xxx','xxx',46027) INSERT INTO _RefObjCommon VALUES (1,46028,'ITEM_GM_GEAR_LA_COUPON','???? ???? ??? (???)','xxx','SN_ITEM_GM_GEAR_LA_COUPON','SN_ITEM_GM_GEAR_COUPON_TT_DESC',1,0,3,3,3,1,180000,3,0,1,1,1,3,0,1,0,0,129,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,0,0,0,0,0,0,0,100,0,0,0,'xxx','item\etc\drop_mall_scroll.bsr','item\etc\coupon_avatar.ddj','xxx','xxx',46028) INSERT INTO _RefObjCommon VALUES (1,46029,'ITEM_GM_GEAR_GA_COUPON','???? ???? ??? (???)','xxx','SN_ITEM_GM_GEAR_GA_COUPON','SN_ITEM_GM_GEAR_COUPON_TT_DESC',1,0,3,3,3,1,180000,3,0,1,1,1,3,0,1,0,0,129,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,0,0,0,0,0,0,0,100,0,0,0,'xxx','item\etc\drop_mall_scroll.bsr','item\etc\coupon_avatar.ddj','xxx','xxx',46029)

_RefObjItem

Code:

INSERT INTO _RefObjItem VALUES (46027,1,2,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5000,'????',1,'??????',-1,'RESURRECT',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',0,0,0) INSERT INTO _RefObjItem VALUES (46028,1,2,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5000,'????',1,'??????',-1,'RESURRECT',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',0,0,0) INSERT INTO _RefObjItem VALUES (46029,1,2,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5000,'????',1,'??????',-1,'RESURRECT',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',0,0,0)

- Stored procedure in [SRO_VT_SHARD] database (NEW):
View attachment 141086

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

Code:

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

- Stored procedure in [SRO_VT_LOG] database: (ADD THIS IN YOUR EXISTING _AddLogItem procedure, you can put at the most bottom line if you want)

Code:

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 = Da PLUS EXEC [SRO_VT_SHARD].[dbo].[_ADD_GM_GEAR] @CharName, @GearType, 11, 16 END END

- Media:

itemdata_45000.txt
View attachment 141084

textdata_object.txt
View attachment 141085

DDJ: (put it in Media\icon\item\etc\coupon_avatar.ddj)

You must be registered to see links

NOTES:

You need to make sure that your "_AddLogItem" procedure is working. So If you use Evangelion SR_GameServer, you should set "disableLog = 0" in misc.ini and restart the gameserver.

And also, you can always utilize the new SP directly from SQL query window if you want, simply by doing: "EXEC [SRO_VT_SHARD].[dbo].[_ADD_GM_GEAR] 'Charnamehere', Degree, Plus"

Screens:
- Before:

- After:

Good luck and have fun

Bro you have skype.?

hema2010 · Nov 25, 2013

Good Job bro
:thumbup:

karemsame · Nov 25, 2013

Good Bro

Keep it Up

#edit
when i use this Scroll no Thing Happen !!!

Blacksheep25 · Nov 25, 2013

karemsame said:
Good Bro
Keep it Up

#edit
when i use this Scroll no Thing Happen !!!

Anything else? BE SURE you change parameters in SETTINGS section part in the Stored procedure to match your database items. (Read about NEW SP below)

Make sure you do everything he posted. Also make sure that the ID's in the query arent conflicting with any ID's you may already have in the database

B1QB0SS · Nov 25, 2013

i'll Edit It To Be Donate item For PVP Server+20 Items / Premium / Set / Acc's / Weapons / Title / 5K HP / MP it will be great!

karemsame · Nov 25, 2013

blacksheep25 said:
Anything else? BE SURE you change parameters in SETTINGS section part in the Stored procedure to match your database items. (Read about NEW SP below)

Make sure you do everything he posted. Also make sure that the ID's in the query arent conflicting with any ID's you may already have in the database

i checked everything

only i edit the Id's to My RefobjCom Id's
and i see the ID's saved to _LogEventItem

IF (@Operation = 41) -- scroll is used
BEGIN
IF (@ItemRefID BETWEEN 50027 AND 50029) -- 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 = 50027 THEN 'HEAVY'
WHEN @ItemRefID = 50028 THEN 'LIGHT'
WHEN @ItemRefID = 50029 THEN 'CLOTHES'
END
-- 11 = Degree, 16 = Da PLUS
EXEC [SRO_VT_SHARD].[dbo].[_ADD_GM_GEAR] @CharName, @GearType, 11, 7
END
END

Blacksheep25 · Nov 25, 2013

If you have edited the ID's for the RefObjCommon you will also need to edit the ID's for the RefObjItem table.

karemsame · Nov 25, 2013

blacksheep25 said:
If you have edited the ID's for the RefObjCommon you will also need to edit the ID's for the RefObjItem table.

lol if iam not edit the id at RefObjItem game Server will not Work

Blacksheep25 · Nov 25, 2013

Because the ID you need to edit for RefObjItem has to be the ID at the end of RefObjCommon. If the ID's don't match up then the gameserver will crash.

karemsame · Nov 25, 2013

blacksheep25 said:
Because the ID you need to edit for RefObjItem has to be the ID at the end of RefObjCommon. If the ID's don't match up then the gameserver will crash.

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

Blacksheep25 · Nov 25, 2013

Then the items arent linked correctly, are you 100% sure you made linked the ID at the end of RefObjItem with the ID of RefObjCommon?

karemsame · Nov 25, 2013

blacksheep25 said:
Then the items arent linked correctly, are you 100% sure you made linked the ID at the end of RefObjItem with the ID of RefObjCommon?

iam Sure 10000% , iam Run The Game and Use This Scroll with out any Problem but no thing Happen no item

only Back to Town.

B1QB0SS · Nov 25, 2013

where i can change Items plus ?!

Blacksheep25 · Nov 25, 2013

B1QB0SS said:
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 · Nov 25, 2013

teleporting me only

and nothing happens !

So any Fix for teleport only ?!

Good item Return Scroll h3

Blacksheep25 · Nov 25, 2013

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

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 · Nov 25, 2013

stop releasing not working things !

OutOfMemory · Nov 25, 2013

B1QB0SS said:
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

Welcome!

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

Experienced Elementalist

Attachments

Skilled Illusionist

Newbie Spellweaver

Newbie Spellweaver

Experienced Elementalist

Moderator

very nice

Experienced Elementalist

Moderator

Experienced Elementalist

Moderator

Experienced Elementalist

Moderator

Experienced Elementalist

very nice

Moderator

very nice

Moderator

very nice

Experienced Elementalist

RaGEZONE Sponsor

About Us

Forum statistics

Partners