[9296][SQL patch] Black Arrow

[KAPATEJIb]

What bug does the patch fix? What features does the patch add?

It fixes dependence of ranks for spell http://www.wowhead.com/?spell=63668 (All ranks)

For which repository revision was the patch created?

Any

Who has been writing this patch? Please include either forum user names or email addresses.

Me

insert into spell_chain values (3674,0,3674,1,0);
insert into spell_chain values (63668,3674,3674,2,0);
insert into spell_chain values (63669,63668,3674,3,0);
insert into spell_chain values (63670,63669,3674,4,0);
insert into spell_chain values (63671,63670,3674,5,0);
insert into spell_chain values (63672,63671,3674,6,0);

[Morphau]

Thanks, i will test it

[vainey]

Tested on MANGOS rev. 8442 and UDB 382 and doesn't work. The trainer doesn't teach you the rest of the ranks.

[KAPATEJIb]

Tested on MANGOS rev. 8442 and UDB 382 and doesn't work. The trainer doesn't teach you the rest of the ranks.

Are you learned a talent for first rank? It works for me - you should have a talent to learn spell from trainer

[vainey]

Yes, I have learned the first rank with Black Arrow talent. But if I wasn't, I unless should see the rest of the ranks in red, and the problem is I don't see any ranks, it is like the trainer couldn't teach those ranks.

[Xlayer]

Then you have missing spell_trainer data on your DB.

[przemratajczak]

if this won't be accepted before next release of UDB updatepack it will create mess in character_spells because npc_triner will be filled with Black Arrow ranks at last.

[MrGhost]

Works great! Thanks for the great update.

[VladimirMangos]

in [9296]. Thank you