[patch][8469] Incomplete SQL Queryes in [8416]

[The_Game_Master]

This should be added for 8416 as for the spells still remain in the character_spell table.

Author: me

Bug reports: None that i know of

[color=blue][b]DELETE[/b][/color] [color=green]FROM[/color] [color=orange]character_spell[/color] [color=green]WHERE[/color] spell [color=green]in[/color] (
1178,  /* Bear Form (Passive) */
3025,  /* Cat Form (Passive) */
5419,  /* Travel Form (Passive) */
5420,  /* Tree of Life _passive_ */
5421,  /* Aquatic Form (Passive) */
7376,  /* Defensive Stance Passive */
7381,  /* Berserker Stance Passive */
9635,  /* Dire Bear Form (Passive) */
21156, /* Battle Stance Passive */
21178, /* Bear Form (Passive2) */
24905, /* Moonk[color=green]in[/color] Form (Passive) */
34123, /* Tree of Life _pasive_ */
33948, /* Flight Form (Passive) */
34764, /* Flight Form (Passive) */
40121, /* Swift Flight Form (Passive) */
40122  /* Swift Flight Form (Passive) */
);

[VladimirMangos]

? Why it must be in character_spell ? This is dependent spells until it has been removed and then it don't must added to

character_spell in old code. Current spell system add to character_spell only non-dependent spells (not learned as leraning another spell or tlanet or skill level, or quest state result).

Do you really check that any from this spell listed in character_spell for character at list one time loggined in last weeks.

My checks show that none from its listed

[The_Game_Master]

I had this problem so i tough that others may encounter. I found spell 5419 in character_spell (not on all the druid class characters) and was causing speed problems for thouse ones.

[VladimirMangos]

Ok, add like query not harm anythinh infact, i also found _single_ spell example from list. Just additional cleanup.

[VladimirMangos]

In [8469]. Thank you