Core/Spells: Fix some db startup error and add new

3 files changed, 91 insertions, 1 deletions

diff --git a/sql/updates/world/2013_07_22_08_worldl_spell_script_names_434.sql b/sql/updates/world/2013_07_22_08_world_spell_script_names_434.sql
index 20583473b26..20583473b26 100644
--- a/sql/updates/world/2013_07_22_08_worldl_spell_script_names_434.sql
+++ b/sql/updates/world/2013_07_22_08_world_spell_script_names_434.sql
diff --git a/sql/updates/world/2013_07_23_06_world_spell_script_names_434.sql b/sql/updates/world/2013_07_23_06_world_spell_script_names_434.sql
index 6fc936c1a71..355037c8dc0 100644
--- a/sql/updates/world/2013_07_23_06_world_spell_script_names_434.sql
+++ b/sql/updates/world/2013_07_23_06_world_spell_script_names_434.sql
@@ -1,4 +1,4 @@
-DELETE FROM `spell_script_names` WHERE `spell_id`IN (82925,82926);
+DELETE FROM `spell_script_names` WHERE `spell_id`IN (687,28176);
 INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES
 (687,'spell_warl_nether_ward_overrride'),
 (28176,'spell_warl_nether_ward_overrride');
diff --git a/sql/updates/world/2013_07_25_04_world_spell_script_names_434.sql b/sql/updates/world/2013_07_25_04_world_spell_script_names_434.sql
new file mode 100644
index 00000000000..0ede39cd552
--- /dev/null
+++ b/sql/updates/world/2013_07_25_04_world_spell_script_names_434.sql
@@ -0,0 +1,90 @@
+DELETE FROM `spell_script_names` WHERE `ScriptName` IN (
+'spell_dk_icebound_fortitude',
+'spell_dk_rune_tap_party',
+'spell_dk_vampiric_blood',
+'spell_dru_dash',
+'spell_dru_idol_lifebloom',
+'spell_dru_innervate',
+'spell_dru_owlkin_frenzy',
+'spell_dru_rip',
+'spell_dru_typhoon',
+'spell_gen_create_lance',
+'spell_gen_gift_of_naaru',
+'spell_gen_netherbloom',
+'spell_mage_fire_frost_ward',
+'spell_mage_ring_of_frost',
+'spell_mage_ring_of_frost_freeze',
+'spell_pal_hand_of_salvation',
+'spell_pri_lightwell_renew',
+'spell_pri_reflective_shield_trigger',
+'spell_rog_rupture',
+'spell_sha_mana_tide_totem',
+'spell_sha_thunderstorm',
+'spell_sha_tidal_waves',
+'spell_warl_ritual_of_doom_effect',
+'spell_warl_shadow_ward',
+'spell_warr_improved_spell_reflection',
+'spell_warr_intimidating_shout',
+'spell_warr_overpower',
+'spell_warr_rend',
+'spell_warr_shattering_throw',
+'spell_warr_vigilance',
+'spell_warr_vigilance_trigger',
+'spell_item_arcane_shroud',
+'spell_item_goblin_jumper_cables',
+'spell_item_goblin_jumper_cables_xl',
+'spell_item_gnomish_army_knife',
+'spell_item_piccolo_of_the_flaming_fire',
+'spell_item_scroll_of_recall',
+'spell_item_the_eye_of_diminution',
+'spell_winter_veil_px_238_winter_wondervolt');
+
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(61391, 'spell_dru_typhoon'),
+(51490, 'spell_sha_thunderstorm'),
+(-7235, 'spell_warl_shadow_ward'),
+(7001, 'spell_pri_lightwell_renew'),
+(1943, 'spell_rog_rupture'),
+(1850, 'spell_dru_dash'),
+(1079, 'spell_dru_rip'),
+(772, 'spell_warr_rend'),
+(543, 'spell_mage_fire_frost_ward'),
+(1038, 'spell_pal_hand_of_salvation'),
+(5246, 'spell_warr_intimidating_shout'),
+(7384, 'spell_warr_overpower'),
+(8342, 'spell_item_goblin_jumper_cables'),
+(17512, 'spell_item_piccolo_of_the_flaming_fire'),
+(18541, 'spell_warl_ritual_of_doom_effect'),
+(22999, 'spell_item_goblin_jumper_cables_xl'),
+(26275, 'spell_winter_veil_px_238_winter_wondervolt'),
+(26400, 'spell_item_arcane_shroud'),
+(28702, 'spell_gen_netherbloom'),
+(28862, 'spell_item_the_eye_of_diminution'),
+(28880, 'spell_gen_gift_of_naaru'),
+(29166, 'spell_dru_innervate'),
+(34246, 'spell_dru_idol_lifebloom'),
+(39610, 'spell_sha_mana_tide_totem'),
+(48129, 'spell_item_scroll_of_recall'),
+(48391, 'spell_dru_owlkin_frenzy'),
+(48792, 'spell_dk_icebound_fortitude'),
+(50720, 'spell_warr_vigilance'),
+(50725, 'spell_warr_vigilance_trigger'),
+(54732, 'spell_item_gnomish_army_knife'),
+(55233, 'spell_dk_vampiric_blood'),
+(59542, 'spell_gen_gift_of_naaru'),
+(59543, 'spell_gen_gift_of_naaru'),
+(59544, 'spell_gen_gift_of_naaru'),
+(59545, 'spell_gen_gift_of_naaru'),
+(59547, 'spell_gen_gift_of_naaru'),
+(59548, 'spell_gen_gift_of_naaru'),
+(59725, 'spell_warr_improved_spell_reflection'),
+(59754, 'spell_dk_rune_tap_party'),
+(60320, 'spell_item_scroll_of_recall'),
+(60321, 'spell_item_scroll_of_recall'),
+(60779, 'spell_dru_idol_lifebloom'),
+(63845, 'spell_gen_create_lance'),
+(64380, 'spell_warr_shattering_throw'),
+(65941, 'spell_warr_shattering_throw'),
+(82676, 'spell_mage_ring_of_frost'),
+(82691, 'spell_mage_ring_of_frost_freeze'),
+(51562,'spell_sha_tidal_waves');