more updates

2 files changed, 30 insertions, 5 deletions

diff --git a/sql/updates/world/2012_05_28_01_world_spell_script_names.sql b/sql/updates/world/2012_05_28_01_world_spell_script_names.sql
index 78054aa1555..e1db8fff869 100644
--- a/sql/updates/world/2012_05_28_01_world_spell_script_names.sql
+++ b/sql/updates/world/2012_05_28_01_world_spell_script_names.sql
@@ -1,9 +1,13 @@
-DELETE FROM `spell_script_names` WHERE `spell_id` IN (-633,781,-746,-8050,-34914,-44457,-48181,-30108,34438,34439,35183,43522,65812,68154,68155,68156,-33763,43421,52551,53608,57762,59990,66093,67957,67958,67959,7057,28832,28833,28834,28835,27831,55638,52942,59837,63322);
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (-633,781,-746,1515,6495,-8050,-16972,31789,-34914,-44457,-48181,-30108,34438,34439,35183,43522,65812,68154,68155,68156,52610,61336,-33763,40133,40132,43421,52551,53608,57762,59990,66093,67957,67958,67959,7057,28832,28833,28834,28835,27831,55638,31447,32960,33654,33671,50810,61546,50811,61547,52942,59837,63322,47977,48025,54729,71342,72286,74856,75614,75973);
 INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 (-633,  'spell_pal_lay_on_hands'),
 (781,   'spell_hun_disengage'),
 (-746,  'spell_gen_bandage'),
+(1515,  'spell_hun_tame_beast'),
+(6495,  'spell_sha_sentry_totem'),
 (-8050, 'spell_sha_flame_shock'),
+(-16972,'spell_dru_predatory_strikes'),
+(31789, 'spell_pal_righteous_defense'),
 (-34914,'spell_pri_vampiric_touch'),
 (-44457,'spell_mage_living_bomb'),
 (-48181,'spell_warl_haunt'),
@@ -16,7 +20,11 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 (68154, 'spell_faction_champion_warl_unstable_affliction'),
 (68155, 'spell_faction_champion_warl_unstable_affliction'),
 (68156, 'spell_faction_champion_warl_unstable_affliction'),
+(52610, 'spell_dru_savage_roar'),
+(61336, 'spell_dru_survival_instincts'),
 (-33763,'spell_dru_lifebloom'),
+(40133, 'spell_gen_summon_fire_elemental'),
+(40132, 'spell_gen_summon_earth_elemental'),
 (43421, 'spell_hexlord_lifebloom'),
 (52551, 'spell_tur_ragepaw_lifebloom'),
 (53608, 'spell_cenarion_scout_lifebloom'),
@@ -33,6 +41,22 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 (28835, 'spell_four_horsemen_mark'),
 (27831, 'spell_gothic_shadow_bolt_volley'),
 (55638, 'spell_gothic_shadow_bolt_volley'),
+(31447, 'spell_mark_of_kazrogal'),
+(32960, 'spell_mark_of_kazzak'),
+(33654, 'spell_gruul_shatter'),
+(33671, 'spell_gruul_shatter_effect'),
+(50810, 'spell_krystallus_shatter'),
+(61546, 'spell_krystallus_shatter'),
+(50811, 'spell_krystallus_shatter_effect'),
+(61547, 'spell_krystallus_shatter_effect'),
 (52942, 'spell_loken_pulsing_shockwave'),
 (59837, 'spell_loken_pulsing_shockwave'),
-(63322, 'spell_general_vezax_saronite_vapors');
+(63322, 'spell_general_vezax_saronite_vapors'),
+(47977, 'spell_magic_broom'),
+(48025, 'spell_headless_horseman_mount'),
+(54729, 'spell_winged_steed_of_the_ebon_blade'),
+(71342, 'spell_big_love_rocket'),
+(72286, 'spell_invincible'),
+(74856, 'spell_blazing_hippogryph'),
+(75614, 'spell_celestial_steed'),
+(75973, 'spell_x53_touring_rocket');
diff --git a/sql/updates/world/2012_05_28_02_world_spelldifficulty_dbc.sql b/sql/updates/world/2012_05_28_02_world_spelldifficulty_dbc.sql
index 93749c9c5cd..8caaf1a6fc7 100644
--- a/sql/updates/world/2012_05_28_02_world_spelldifficulty_dbc.sql
+++ b/sql/updates/world/2012_05_28_02_world_spelldifficulty_dbc.sql
@@ -1,5 +1,6 @@
 SET @DIFF := xxxx; -- set by TDB team
-DELETE FROM `spelldifficulty_dbc` WHERE `id` IN (@DIFF+0,@DIFF+1);
+DELETE FROM `spelldifficulty_dbc` WHERE `id` BETWEEN @DIFF+0 AND @DIFF+2;
 INSERT INTO `spelldifficulty_dbc` (`id`,`spelld0`,`spellid1`,`spelld2`,`spellid3`) VALUES
-(@DIFF+0,57762,57763,0,0),
-(@DIFF+1,59990,61489,0,0);
+(@DIFF+0,50811,61547,0,0),
+(@DIFF+1,57762,59990,0,0),
+(@DIFF+2,57763,61489,0,0);