overlap problem

04/18/2016 21:17 Maddona#1
[Only registered and activated users can see links. Click Here To Register...]

when i try to add new skills 125 to client ! i tried ! more than time and same problem any idea guys !
04/19/2016 19:58 blapanda#2
_RefSkill, those IDs of your Lv125 skills are NOT properly matching with their respective chaining skills. E.g.

Code:
BEGIN
	SELECT @ Basic_ChainCode = ID FROM _RefSkill WHERE Basic_Code = 'SKILL_CH_BOW_CHAIN_F2_01'
	UPDATE _RefSkill
	SET Basic_ChainCode = @ Basic_Chaincode
	WHERE Basic_Code = 'SKILL_CH_BOW_CHAIN_F_01'
END
If you understand that simple query, you will figure out what's actually mismatching and causing your overlapping.
Another little hint: Not only the [ID] has to be adjusted before adding those skills to your database.