Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
when i set
DECLARE @aemethod INT = 1
it doesn`t work
- - - Updated - - -
maybe the problem here ?
The module '_AddLogChar' depends on the missing object 'SRO_VT_SHARD.dbo._AUTOEQUIP_DEPI'. The module will still be created; however, it cannot run successfully until the object exists.
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
My question has done himself
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
Quote:
Originally Posted by
Witchy Moo
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)
Thanks for the nice Auto Equipment
maybe you can help me with this ? i don't know what you mean by "<" or ">"
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
Tested with blackrogue files, removed the parts about scrolls and left only the automatic.. works like charm thanks :)
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
i think this auto equipment have a problem.. for example I'm lvl 69 after teleport i'm again lvl68 -.- or lvl49 to lvl 33 or its from my db ? and how i can fix it ?
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
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: 111, degree: 09. (Level are current +1)
Validating equipped weapon...
Weapon is: BLADE.
Checking if character is using shield...
- 1H weapon is used, new shield will be added.
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.
- Shield equipped.
Updating gear attributes to +7 FB (Str/Int 7, Parry 60%, Durability 200%)
Msg 512, Level 16, State 1, Procedure OptLevel_Tri, Line 5
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
whats wrong with me :S
scroll work .. characters return to town and noting get any item.
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
Hey! Thx you for sharing this with us! Can you tell me what to do with those to lines codes how do I insert them into db _RefObjCommon_RefObjItem
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
I found a problem. When a character reach certain lv (for example 13) then that character got item. But when I down that character lvl back to 12 then up it lvl again to 13 -> The Shard_Manager will crash!. So how to fix this problem?
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
Quote:
Originally Posted by
silkroadgamer
I found a problem. When a character reach certain lv (for example 13) then that character got item. But when I down that character lvl back to 12 then up it lvl again to 13 -> The Shard_Manager will crash!. So how to fix this problem?
Fixed. But I have another problem from it. When my character back to certain lvl (example 13) it will get another coupon at lvl 13 again :|
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
WitchyMoo is no longer in the SRO Scene or active on RZ or EPVP so you won't get any support from her anymore however the issues you guys have been having can be easily fixed.
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
hey dude thnx for your gr8 work but i faced this hope you can help me ^^
[IMG]http://s23.postimg.org/5hkwbwfl7/SRO...1_44_53_86.jpg[/IMG]
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
hello every thing working fine
but when i reach lvl 14 for example
i didn`t get any thing
but when i get the scroll from Consol /makeitem
and use it i get the item !! what can i do about that ?
sorry for my english
Re: Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)
Thx Worked fine
i was testing it on GM Char :D
but it Working fine at Normal char thx <3