-- unused spells removal (thx to mangos.sql smile.gif
delete from character_action where action in (114,637,646,648,1028,1034,
1048,1707,2095,2852,4051,4161,4512,5575,5580,6134,6135,6592,6593,7601,7614,
7615,7616,7618,9205,9793,9797,9801,9808,10095,10400,10727,10868,11830,11838,
11961,12002,12038,12094,12546,12552,13078,13260,13320,13767,13987,14095,14150,
14152,14154,15364,15365,15567,15568,15569,15644,15650,16140,16241,16242,16311,
16312,16313,16423,16563,16925,16926,16955,16956,16957,16962,16963,16964,17000,
17001,17079,17082,19195,19234,19235,19389,19390,19396,19640,20163,20169,20183,
20204,20411,20412,20413,20414,20419,20421,20422,20423,20563,20809,20896,21387,
21789,22283,22285,22286,22287,22288,22697,22716,23255,23301,23303,23305,23306,
25592,25715,25727,25728,25729,25730,25731,25732,25733,25734,25745,25751,25752,
25757,25926,25942,25945,26341,28130,28881,29526);
delete from character_spell where spell in (114,637,646,648,1028,1034,
1048,1707,2095,2852,4051,4161,4512,5575,5580,6134,6135,6592,6593,7601,7614,
7615,7616,7618,9205,9793,9797,9801,9808,10095,10400,10727,10868,11830,11838,
11961,12002,12038,12094,12546,12552,13078,13260,13320,13767,13987,14095,14150,
14152,14154,15364,15365,15567,15568,15569,15644,15650,16140,16241,16242,16311,
16312,16313,16423,16563,16925,16926,16955,16956,16957,16962,16963,16964,17000,
17001,17079,17082,19195,19234,19235,19389,19390,19396,19640,20163,20169,20183,
20204,20411,20412,20413,20414,20419,20421,20422,20423,20563,20809,20896,21387,
21789,22283,22285,22286,22287,22288,22697,22716,23255,23301,23303,23305,23306,
25592,25715,25727,25728,25729,25730,25731,25732,25733,25734,25745,25751,25752,
25757,25926,25942,25945,26341,28130,28881,29526);
delete from character_spell_cooldown where spell in (114,637,646,648,1028,1034,
1048,1707,2095,2852,4051,4161,4512,5575,5580,6134,6135,6592,6593,7601,7614,
7615,7616,7618,9205,9793,9797,9801,9808,10095,10400,10727,10868,11830,11838,
11961,12002,12038,12094,12546,12552,13078,13260,13320,13767,13987,14095,14150,
14152,14154,15364,15365,15567,15568,15569,15644,15650,16140,16241,16242,16311,
16312,16313,16423,16563,16925,16926,16955,16956,16957,16962,16963,16964,17000,
17001,17079,17082,19195,19234,19235,19389,19390,19396,19640,20163,20169,20183,
20204,20411,20412,20413,20414,20419,20421,20422,20423,20563,20809,20896,21387,
21789,22283,22285,22286,22287,22288,22697,22716,23255,23301,23303,23305,23306,
25592,25715,25727,25728,25729,25730,25731,25732,25733,25734,25745,25751,25752,
25757,25926,25942,25945,26341,28130,28881,29526);

-- Ranged weapons (thx to sinaka@mangosproject.org,
-- Adept@mangos.ru, Harbringer@mangos.ru)
update ignore character_spell set spell=3018 where spell=2480;
update ignore character_spell set spell=3018 where spell=7918;
update ignore character_spell set spell=3018 where spell=7919;

-- Shoot fix who applied previous revs (safe to re-apply)
update ignore character_spell set spell=3018 where spell=30493;

-- Remove duplicates
delete from character_spell where spell = 2480;
delete from character_spell where spell = 7918;
delete from character_spell where spell = 7919;
delete from character_spell where spell = 30493;

-- Remove unexistent spell cooldowns because they can cause crashes
delete from character_spell_cooldown where spell = 2480;
delete from character_spell_cooldown where spell = 7918;
delete from character_spell_cooldown where spell = 7919;
delete from character_spell_cooldown where spell = 30493;

-- Spell learn fix (thx to Psychosis@SDB)
delete from spell_learn_spell where entry IN (264,266,5011);
insert into spell_learn_spell values (264,3018,75),(266,3018,75),(5011,3018,75);