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

[Blacksheep25]

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!

[Witchy Moo]

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

[CoderWaxy]

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

[Witchy Moo]

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:

EXEC _ADD_AUTOEQUIP_GEAR 'yourchar', plus

plus = your item +

[CoderWaxy]

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

[Witchy Moo]

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?

[CoderWaxy]

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.

[Witchy Moo]

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.

[CoderWaxy]

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

[Witchy Moo]

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 "=":

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)

[Blacksheep25]

hey witchymoo, that procedure you did for arrows and bolts doesnt work, i tried it on a sword and shield chinese char and it freezes on the loading screen and SR_GameServer has "Stockable Item count is 0!! [StorageType: 0, Slot: 7, CodeName: ITEM_ETC_AMMO_ARROW_01]" so it's still trying to add it to characters its not suppose to.

Edit: Found another issue, in the code you put in for the itemdata_45000.txt, you mistyped the code wrong for the description. You have "SN_ITEM_GM_GEAR_COUPON_TT_DESC" instead of "SN_ITEM_EVENT_AUTOEQUIP_COUPON_TT_DESC"

[Witchy Moo]

hey witchymoo, that procedure you did for arrows and bolts doesnt work, i tried it on a sword and shield chinese char and it freezes on the loading screen and SR_GameServer has "Stockable Item count is 0!! [StorageType: 0, Slot: 7, CodeName: ITEM_ETC_AMMO_ARROW_01]" so it's still trying to add it to characters its not suppose to.

Edit: Found another issue, in the code you put in for the itemdata_45000.txt, you mistyped the code wrong for the description. You have "SN_ITEM_GM_GEAR_COUPON_TT_DESC" instead of "SN_ITEM_EVENT_AUTOEQUIP_COUPON_TT_DESC"

Hey there, about the arrows/bolt, change the stack of "250" to your maximum stack (try 50 or 100), perhaps it's different from mine, you can see the MaxStack from _RefObjItem: (Do check your Media as well for this MaxStack, your media must match the db otherwise the client will crash)

SELECT CodeName128, MaxStack FROM _RefObjItem INNER JOIN _RefObjCommon ON _RefObjCommon.Link = _RefObjItem.ID WHERE _RefObjCommon.CodeName128 LIKE '%ARROW%' OR _RefObjCommon.CodeName128 LIKE '%BOLT%'

This is mine:


About description, Yeah i put wrong "_TT_" description code in itemdata_45000, it's updated now, thanks for your info, guess slipped a lill bit since I was so sleepy :P

[Witchy Moo]

Attachment itemdata_45000 and textdata_object updated. (SN_ITEM_EVENT_AUTOEQUIP_COUPON_TT_DESC) added to itemdata_45000.

Thanks to blacksheep25 for info ;)

[CoderWaxy]

if DECLARE @AEMethod INT = 2 = Working
if DECLARE @AEMethod INT = 1 = Not Working

[longway]

hay witchymoo when i try to use COUPON my loading screen freezes , But if i use Auto Item,s Its Work Can Help me in it ?