Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

Printable View

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

29-11-13
Witchy Moo

3 Attachment(s)

Alternative new [Auto Equipment] system (by coupon/scroll) :)
Hello

I'd like to share something that I made out of my previous release "GM gear coupon", it has no relation to other "auto-equipment system" released here, mine is simply an alternative, you may use it if you want or not. And do read my notes carefully.

I call this "Auto-Equipment Coupon"
- What it does? It will change your char equipment to next degree if the character level or mastery fits its requirement. (MAXIMUM 11D)
- What equipment does it add? Weapon (auto Shield for 1H), gear, and accessory
- Any requirements? Just one, your character must wear any weapon and 1 gear (no need full set)
- Usage Method? scroll
- How does it work? For chinese, the system will detect character level, for Euro, will detect mastery level, so be sure you have mastery level -1 level to next degree (for example, mastery level 56 to get 7 degree), especially if you set the usage method as "automatic equipment" and not coupon.
- 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,46030,'ITEM_EVENT_AUTOEQUIP_COUPON','???? ???? ??? (???)','xxx','SN_ITEM_EVENT_AUTOEQUIP_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_weapon.ddj','xxx','xxx',46030)

_RefObjItem

Code:

INSERT INTO _RefObjItem VALUES (46030,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 152899

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_A_RARE), change as you need it DECLARE @Gearsuffix VARCHAR(16) = 'A_RARE' -- @@@ END: SETTINGS -- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

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

_AddLogItem

Spoiler:

Code:

IF (@Operation = 41) -- scroll is used BEGIN IF (@ItemRefID = 46030) -- Auto-equipment Coupon BEGIN DECLARE @CharNameEQ VARCHAR(64) = (SELECT CharName16 from [SRO_VT_SHARD].[dbo].[_Char] WHERE CharID = @CharID) EXEC [SRO_VT_SHARD].[dbo].[_ADD_AUTOEQUIP_GEAR] @CharNameEQ, 7 END END

- Media:

itemdata_45000.txt: Attachment 141479

textdata_object.txt: Attachment 141478

DDJ: (put it in Media\icon\item\etc\coupon_weapon.ddj)
http://openclient.sroinfo.com/op/iSR...pon_weapon.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_ITEM_EXTERN] 'Charname', 'ITEM_EVENT_AUTOEQUIP_COUPON', 1, 0" (to deliver scroll to inventory)
  - "EXEC [SRO_VT_SHARD].[dbo].[_ADD_AUTOEQUIP_GEAR] 'Charname', <item_plus_here>" (to automatically equip the char)
Video (Method 1: Deliver the coupon to inventory method):

Spoiler:

https://www.youtube.com/watch?v=M-1ykjBZnHo

Video (Method 2: automatically equip the char):

Spoiler:

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

Good luck and have fun ;)
29-11-13
Witchy Moo

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
_AddLogChar
- Remember to change @AEMethod in _AddLogChar if you want. 1 means deliver to inventory, 2 means automatic equip
- Watch @RefItemID CAREFULLY, if you have other code in your _RefObjCommon, CHANGE THIS to your code, otherwise it won't work or your char will get multiple coupons (bad huh?). (Mine have "46030", yours could be different)
(_AddLogChar on first post updated)

cheers ;)
29-11-13
Nemo07Back

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

nice release keep on mate ..
29-11-13
gotsha

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

Good Job But I Don't UnderSand This System Work At CH And Eu And Work With All Set And Weapon Saff And Dager Etc

I Don't uderstand this -- (Represent ITEM_CH_BOW_11_A_RARE), change as you need it DECLARE @GearSuffix VARCHAR(16) = 'A_RARE'
29-11-13
CoderWaxy

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

if my mastery level 57 in cleric and Wizard ?
29-11-13
Blacksheep25

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

Works Perfect witchymoo, tho already found an issue ;)

When using a chinese bow or euro rogue you will get your arrows/bolt's deleted when it clears your inventory, so you need to stop it from clearing the arrow/bolt slot ^_^

Slot 7 = Shield/arrow/bolts

But you will need to make it check that if you don't use a shield do you use a bow or crossbow. If so then do not delete slot 7.
29-11-13
CoderWaxy

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

Witchy you Was Saw My Equip What is The Error in IT ? I think its No Error But Why its Not Work ?

witchy i dont need give characters set lv 101 Nova ?! what i can do ?
29-11-13
Witchy Moo

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

Quote:

Originally Posted by gotsha

Good Job But I Don't UnderSand This System Work At CH And Eu And Work With All Set And Weapon Saff And Dager Etc

I Don't uderstand this -- (Represent ITEM_CH_BOW_11_A_RARE), change as you need it DECLARE @GearSuffix VARCHAR(16) = 'A_RARE'

Doesn't matter, the SP will detect your equipment and weapon before putting new one, READ MY NOTES. "A_RARE" = means nova, B_RARE = moon, and so on so forth

Quote:

Originally Posted by CoderWaxy

if my mastery level 57 in cleric and Wizard ?

Doesn't matter, the SP will only detect what equipment you wear, if you wear robe you get robe, you wear light armor you get light armor, so on so forth...

Quote:

Originally Posted by blacksheep25

Works Perfect witchymoo, tho already found an issue ;)

When using a chinese bow or euro rogue you will get your arrows/bolt's deleted when it clears your inventory, so you need to stop it from clearing the arrow/bolt slot ^_^

Slot 7 = Shield/arrow/bolts

But you will need to make it check that if you don't use a shield do you use a bow or crossbow. If so then do not delete slot 7.

Nice idea, I'll see what i can do with it, I might add automatic premium arrow/bolt (10K to the slot instead), what do you think?

Quote:

Originally Posted by CoderWaxy

Witchy you Was Saw My Equip What is The Error in IT ? I think its No Error But Why its Not Work ?

witchy i dont need give characters set lv 101 Nova ?! what i can do ?

I don't understand the question.
29-11-13
Blacksheep25

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

Quote:

Originally Posted by witchymoo

Nice idea, I'll see what i can do with it, I might add automatic premium arrow/bolt (10K to the slot instead), what do you think?

Yeah, or add a spot to choose normal arrows/bolts or prem 10k ones in the SETTINGS section :)
29-11-13
CoderWaxy

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

blackSheep add me
Skype : Ma3lmkeber please i want help
29-11-13
Blacksheep25

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

Quote:

Originally Posted by CoderWaxy

blackSheep add me
Skype : Ma3lmkeber please i want help

witchymoo's procedures still arent working for me either when doing 11D or higher even tho its set for A_RARE which should be 11D nova. So I can't help you with getting that working at the moment but witchymoo might when he isn't busy
29-11-13
CoderWaxy

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

blacksheep i cant Set This Auto Equipment Working ! please Help me
29-11-13
Witchy Moo

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

Quote:

Originally Posted by blacksheep25

witchymoo's procedures still arent working for me either when doing 11D or higher even tho its set for A_RARE which should be 11D nova. So I can't help you with getting that working at the moment but witchymoo might when he isn't busy

If your char is above "101" and you still getting 9D equip, then you should add level condition in _AddLogChar, I put the max level to 81 (9D), you can change it if you want. This part:

Code:

-- Character reached certain level IF (@Data2 = 13 OR @Data2 = 21 OR @Data2 = 29 OR @Data2 = 37 OR @Data2 = 47 OR @Data2 = 57 OR @Data2 = 69 OR @Data2 = 81)

81 = 9D, add it for 10D etc. etc..

Also in the _ADD_AUTOEQUIP_GEAR SP:
Find this:

Code:

WHEN @CurLevel < 81 THEN '08' ELSE '09' END

Change to something like this:

Code:

WHEN @CurLevel < 81 THEN '08' WHEN @CurLevel < 92 THEN '09' WHEN @CurLevel < 101 THEN '10' ELSE '11' END

And so on so forth...

Oh btw, I'm done with arrow/bolt thing, add this in the SP ONLY if you wanna use it, if not, leave the SP as it was. (Arrows/bolts are not big deal anyway)

Find this:

Spoiler:

Code:

-- Shield IF (@useShield = 1) BEGIN EXEC @ShieldItemID64 = [_FN_ADD_INITIAL_EQUIP] @CharID, 7, @RefShieldID, @DuraShield IF (@ShieldItemID64 <= 0) BEGIN PRINT 'Problem when executing [_FN_ADD_INITIAL_EQUIP], canceling sequence and rolling back data...' ROLLBACK TRANSACTION RETURN -19 END PRINT '- Shield equipped.' END

Change to this:

Spoiler:

Code:

-- Shield IF (@useShield = 1) BEGIN EXEC @ShieldItemID64 = [_FN_ADD_INITIAL_EQUIP] @CharID, 7, @RefShieldID, @DuraShield IF (@ShieldItemID64 <= 0) BEGIN PRINT 'Problem when executing [_FN_ADD_INITIAL_EQUIP], canceling sequence and rolling back data...' ROLLBACK TRANSACTION RETURN -19 END PRINT '- Shield equipped.' END -- Arrow/Bolt IF (@WPClass = 'BOW' OR @WPClass = 'CROSSBOW') BEGIN DECLARE @ArrowItemID64 BIGINT DECLARE @RefArrowID INT = CASE WHEN @WPClass = 'BOW' THEN (SELECT ID FROM _RefObjCommon WHERE [Service] = 1 AND CodeName128 = 'ITEM_ETC_AMMO_ARROW_01') WHEN @WPClass = 'CROSSBOW' THEN (SELECT ID FROM _RefObjCommon WHERE [Service] = 1 AND CodeName128 = 'ITEM_ETC_AMMO_BOLT_01') END EXEC @ArrowItemID64 = [_FN_ADD_INITIAL_EQUIP] @CharID, 7, @RefArrowID, 250 IF (@ArrowItemID64 <= 0) BEGIN PRINT 'Problem when executing [_FN_ADD_INITIAL_EQUIP] (Arrow), canceling sequence and rolling back data...' ROLLBACK TRANSACTION RETURN -19 END PRINT '- Arrow/Bolt equipped.' END

You'll get automatic arrow :), it's rough code, I put my db Item Code there: ITEM_ETC_AMMO_BOLT_01 and ITEM_ETC_AMMO_ARROW_01, if your arrow/bolt has different code you have to change those.

good luck, have fun ;)
29-11-13
CoderWaxy

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

witchy help me i cant set this System Work
29-11-13
Witchy Moo

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

Post the error you got.
29-11-13
Blacksheep25

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

Quote:

Originally Posted by witchymoo

Oh btw, I'm done with arrow/bolt thing, add this in the SP ONLY if you wanna use it, if not, leave the SP as it was. (Arrows/bolts are not big deal anyway)

good luck, have fun ;)

Damn you work fast, thanks for the awesome work witchy!
29-11-13
Witchy Moo

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

Quote:

Originally Posted by blacksheep25

Damn you work fast, thanks for the awesome work witchy!

Well it's late, can't sleep, got nothing else to do, and it's Saturday, so I can focus on this for awhile :P
29-11-13
CoderWaxy

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

i try system Auto and when i kill medusa level up high level then return scroll my Clothes Not change
29-11-13
Witchy Moo

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

Quote:

Originally Posted by CoderWaxy

i try system Auto and when i kill medusa level up high level then return scroll my Clothes Not change

Try running the SP from SQL query window, see if there's any error, do this:

Code:

EXEC _ADD_AUTOEQUIP_GEAR 'yourchar', plus

plus = your item +
29-11-13
CoderWaxy

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

I Tried Auto System I Dont Get My Items when i Kill Medusa And level up High Level and after use return scroll
29-11-13
Witchy Moo

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

Quote:

Originally Posted by CoderWaxy

I Tried Auto System I Dont Get My Items when i Kill Medusa And level up High Level and after use return scroll

should I repeat the same answer?
29-11-13
CoderWaxy

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

Validating Character...
Validating Account ID...
Validating race and gender...
Race code is: CH, gender code is: M.
Character/Mastery Level: 2, degree: 01. (Level are current +1)
Validating equipped weapon...
Weapon is: BOW.
Checking if character is using shield...
Validating current gear...
Gear type is: CLOTHES.
Setting up item codenames...
Getting item reference ID and link...
Getting items durability information...
Removing equipped items...
Adding new items...
- Helm equipped.
- Chest equipped.
- Shoulder equipped.
- Gauntlet equipped.
- Pants equipped.
- Boots equipped.
- Earring equipped.
- Necklace equipped.
- Left Ring equipped.
- Right Ring equipped.
- Weapon equipped.
- Arrow/Bolt equipped.
Updating gear attributes to +6 FB (Str/Int 7, Parry 60%, Durability 200%)
- Adding extra blue attributes to Chest: HP recovery/MP recovery 210%
Updating accessory attributes to +6 FB (Str/Int 7, Freeze 20%, Electric Shock 20%, Burn 20%, Poison 20%, Zombie 20%)
- Adding extra blue attributes to Earring: CombustionProbability 50% Reduce, SleepProbability 50% Reduce
- Adding extra blue attributes to Necklace: StunProbability 50% Reduce
- Adding extra blue attributes to Rings: DiseaseProbability 25% Reduce, FearProbability 25% Reduce
Updating weapon attributes to +6 FB (Str/Int 7, Block 100, Attack Rate 60%, Durability 200%)
- Adding extra blue attributes to Weapon: Critical 3
Sequence complete.
29-11-13
Witchy Moo

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

Quote:

Originally Posted by CoderWaxy

I Tried Auto System I Dont Get My Items when i Kill Medusa And level up High Level and after use return scroll

Msg 8114, Level 16, State 5, Procedure _ADD_AUTOEQUIP_GEAR, Line 0
Error converting data type nvarchar to tinyint.

EXEC _ADD_AUTOEQUIP_GEAR 'yourchar', 7 <-- (7 = means items are +7.. DO NOT write the word "PLUS")

"Sequence complete"

it works, teleport your char, see if you get new items.
29-11-13
CoderWaxy

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

i was Turn off GameServer

work now @DATA = if i kill unique And level up from 56 to 58 = No Items

@Data2 = 81 If i level up from 80 to 82 by unique = No ITems
29-11-13
Witchy Moo

Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

Quote:

Originally Posted by CoderWaxy

i was Turn off GameServer

work now @DATA = if i kill unique And level up from 56 to 58 = No Items

You need to play with _AddLogChar SP, it's simply stated that level condition is "=":

Code:

IF (@Data2 = 13 OR @Data2 = 21 OR @Data2 = 29 OR @Data2 = 37 OR @Data2 = 47 OR @Data2 = 57 OR @Data2 = 69 OR @Data2 = 81)

I don't see something in between, 58? it's not there, so you have to play with that statement, but BE VERY CAREFUL, if you put something like "<" or ">" you might get auto-equiped at every level. (Though it will work fine, consider your server load, auto-equipping all chars at EVERY LEVEL up could make your SQL eats up more memory)

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