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

Printable View

Show 100 post(s) from this thread on one page

25-11-13
Witchy Moo

3 Attachment(s)

"Just for fun - Nothing to do" GM gear coupon :P
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... :ott1:

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 :P
- 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): Attachment 141300

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: Attachment 141084

textdata_object.txt: Attachment 141085

DDJ: (put it in Media\icon\item\etc\coupon_avatar.ddj)
http://openclient.sroinfo.com/op/iSR...pon_avatar.ddj

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:

Spoiler:

https://www.youtube.com/watch?v=wFWaL4AM4m0

Screens:

Spoiler:

- Before:
http://img32.imageshack.us/img32/1196/eq9y.jpg

- After:
http://imageshack.us/a/img41/1596/9plq.jpg

http://img600.imageshack.us/img600/4076/8jvd.jpg

http://imageshack.us/a/img845/909/owep.jpg

Good luck and have fun ;)
25-11-13
CoderWaxy

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

Good Job
25-11-13
ongamanext

Re: "Just for fun - Nothing to do" GM gear coupon :P
Good Gzz
Quote:
Originally Posted by witchymoo

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

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 :P
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):
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
Attachment 141084

textdata_object.txt
Attachment 141085

DDJ: (put it in Media\icon\item\etc\coupon_avatar.ddj)
http://openclient.sroinfo.com/op/iSR...pon_avatar.ddj

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:
http://img32.imageshack.us/img32/1196/eq9y.jpg

- After:
http://imageshack.us/a/img41/1596/9plq.jpg

http://img600.imageshack.us/img600/4076/8jvd.jpg

http://imageshack.us/a/img845/909/owep.jpg

Good luck and have fun ;)
Bro you have skype.?
25-11-13
hema2010

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

Good Job bro
:thumbup:
25-11-13
karemsame

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

Good Bro :)
Keep it Up

#edit
when i use this Scroll no Thing Happen !!!
25-11-13
Blacksheep25

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

Quote:

Originally Posted by karemsame

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
25-11-13
B1QB0SS

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

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!
25-11-13
karemsame

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

Quote:

Originally Posted by blacksheep25

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

Quote:

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

http://im34.gulfup.com/VCB3o.png
25-11-13
Blacksheep25

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

If you have edited the ID's for the RefObjCommon you will also need to edit the ID's for the RefObjItem table.
25-11-13
karemsame

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

Quote:

Originally Posted by blacksheep25

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
25-11-13
Blacksheep25

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

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.
25-11-13
karemsame

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

Quote:

Originally Posted by blacksheep25

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
25-11-13
Blacksheep25

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

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?
25-11-13
karemsame

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

Quote:

Originally Posted by blacksheep25

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.
25-11-13
B1QB0SS

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

where i can change Items plus ?!
25-11-13
Blacksheep25

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

Quote:

Originally Posted by B1QB0SS

where i can change Items plus ?!

In the AddLogItem procedure

Quote:

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
25-11-13
B1QB0SS

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

teleporting me only

and nothing happens !

So any Fix for teleport only ?!

Good item Return Scroll h3
25-11-13
Blacksheep25

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

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.
25-11-13
B1QB0SS

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

stop releasing not working things !
25-11-13
OutOfMemory

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

Quote:

Originally Posted by B1QB0SS

stop releasing not working things !

Everything is working fine.

if you get nothing just change this.

Quote:

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
25-11-13
B1QB0SS

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

great i'll try

Still getting Nothing !
26-11-13
Witchy Moo

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

Quote:

Originally Posted by karemsame

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:

Code:

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

http://img845.imageshack.us/img845/1640/kp0k.jpg

Good luck ;)

Quote:

Originally Posted by blacksheep25

In the AddLogItem procedure

Green = Degree Item
Red = Item Plus

Thank you :)) +1

Quote:

Originally Posted by B1QB0SS

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:

Code:

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 ;)

Quote:

Originally Posted by B1QB0SS

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 :thumbup1:
26-11-13
B1QB0SS

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

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.
26-11-13
Witchy Moo

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

Quote:

Originally Posted by 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.

Code:

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

Did you miss anything? :) And don't forget to wear any weapon before executing.
26-11-13
B1QB0SS

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

Quote:

Originally Posted by witchymoo

Code:

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 !

Show 100 post(s) from this thread on one page