-
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
- 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):
Video (Method 2: automatically equip the char):
Good luck and have fun ;)
-
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 ;)
-
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
nice release keep on mate ..
-
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'
-
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
if my mastery level 57 in cleric and Wizard ?
-
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.
-
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 ?
-
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.
-
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 :)
-
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
blackSheep add me
Skype : Ma3lmkeber please i want help
-
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
-
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
blacksheep i cant Set This Auto Equipment Working ! please Help me
-
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:
Change to this:
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 ;)
-
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
witchy help me i cant set this System Work
-
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
-
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!
-
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
-
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
-
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 +
-
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
-
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?
-
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.
-
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.
-
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
-
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)