Scripts/AhnKahet: fix some issues on prince taldaram script

14 files changed, 13 insertions, 0 deletions

diff --git a/sql/updates/world/2014_01_17_00_trinity_string.sql b/sql/updates/world/2014_01_17_00_world_trinity_string.sql
index 698af0f56cb..698af0f56cb 100644
--- a/sql/updates/world/2014_01_17_00_trinity_string.sql
+++ b/sql/updates/world/2014_01_17_00_world_trinity_string.sql
diff --git a/sql/updates/world/2014_01_23_01_conditions.sql b/sql/updates/world/2014_01_23_01_world_conditions.sql
index 4afa30ee13d..4afa30ee13d 100644
--- a/sql/updates/world/2014_01_23_01_conditions.sql
+++ b/sql/updates/world/2014_01_23_01_world_conditions.sql
diff --git a/sql/updates/world/2014_01_23_02_sai.sql b/sql/updates/world/2014_01_23_02_world_sai.sql
index f55db997a4c..f55db997a4c 100644
--- a/sql/updates/world/2014_01_23_02_sai.sql
+++ b/sql/updates/world/2014_01_23_02_world_sai.sql
diff --git a/sql/updates/world/2014_01_23_03_conditions.sql b/sql/updates/world/2014_01_23_03_world_conditions.sql
index df83d50fd51..df83d50fd51 100644
--- a/sql/updates/world/2014_01_23_03_conditions.sql
+++ b/sql/updates/world/2014_01_23_03_world_conditions.sql
diff --git a/sql/updates/world/2014_01_23_04_game_event_creature.sql b/sql/updates/world/2014_01_23_04_world_game_event_creature.sql
index 5d350803f82..5d350803f82 100644
--- a/sql/updates/world/2014_01_23_04_game_event_creature.sql
+++ b/sql/updates/world/2014_01_23_04_world_game_event_creature.sql
diff --git a/sql/updates/world/2014_01_23_05_creature_template.sql b/sql/updates/world/2014_01_23_05_world_creature_template.sql
index a35a6191ea4..a35a6191ea4 100644
--- a/sql/updates/world/2014_01_23_05_creature_template.sql
+++ b/sql/updates/world/2014_01_23_05_world_creature_template.sql
diff --git a/sql/updates/world/2014_01_23_06_creature.sql b/sql/updates/world/2014_01_23_06_world_creature.sql
index 356db4fceb4..356db4fceb4 100644
--- a/sql/updates/world/2014_01_23_06_creature.sql
+++ b/sql/updates/world/2014_01_23_06_world_creature.sql
diff --git a/sql/updates/world/2014_01_23_07_spell_bonus_data.sql b/sql/updates/world/2014_01_23_07_world_spell_bonus_data.sql
index 1dfd35eac5a..1dfd35eac5a 100644
--- a/sql/updates/world/2014_01_23_07_spell_bonus_data.sql
+++ b/sql/updates/world/2014_01_23_07_world_spell_bonus_data.sql
diff --git a/sql/updates/world/2014_01_23_08_graveyard.sql b/sql/updates/world/2014_01_23_08_world_graveyard.sql
index 27cfc39647d..27cfc39647d 100644
--- a/sql/updates/world/2014_01_23_08_graveyard.sql
+++ b/sql/updates/world/2014_01_23_08_world_graveyard.sql
diff --git a/sql/updates/world/2014_01_23_09_npc_trainer.sql b/sql/updates/world/2014_01_23_09_world_npc_trainer.sql
index 3b44463b3da..3b44463b3da 100644
--- a/sql/updates/world/2014_01_23_09_npc_trainer.sql
+++ b/sql/updates/world/2014_01_23_09_world_npc_trainer.sql
diff --git a/sql/updates/world/2014_01_23_10_creature_loot_template.sql b/sql/updates/world/2014_01_23_10_world_creature_loot_template.sql
index f15bf25e5a8..f15bf25e5a8 100644
--- a/sql/updates/world/2014_01_23_10_creature_loot_template.sql
+++ b/sql/updates/world/2014_01_23_10_world_creature_loot_template.sql
diff --git a/sql/updates/world/2014_01_23_11_creature_template.sql b/sql/updates/world/2014_01_23_11_world_creature_template.sql
index efb5c7871af..efb5c7871af 100644
--- a/sql/updates/world/2014_01_23_11_creature_template.sql
+++ b/sql/updates/world/2014_01_23_11_world_creature_template.sql
diff --git a/sql/updates/world/2014_01_23_12_sai.sql b/sql/updates/world/2014_01_23_12_world_sai.sql
index a9935fd0c97..a9935fd0c97 100644
--- a/sql/updates/world/2014_01_23_12_sai.sql
+++ b/sql/updates/world/2014_01_23_12_world_sai.sql
diff --git a/sql/updates/world/2014_01_23_13_world_misc.sql b/sql/updates/world/2014_01_23_13_world_misc.sql
new file mode 100644
index 00000000000..627aa99d56b
--- /dev/null
+++ b/sql/updates/world/2014_01_23_13_world_misc.sql
@@ -0,0 +1,13 @@
+UPDATE `creature_template` SET `ScriptName`='boss_prince_taldaram' WHERE `entry`=29308;
+
+UPDATE `creature_template` SET `scale`=1, `speed_walk`=2, `InhabitType`=4, `flags_extra`=128 WHERE `entry` IN (30106,31458,31686,31687);
+UPDATE `creature_template` SET `ScriptName`='npc_prince_taldaram_flame_sphere' WHERE `entry` IN (30106,31686,31687);
+
+UPDATE `gameobject_template` SET `flags`=32, `ScriptName`='go_prince_taldaram_sphere' WHERE `entry` IN (193093,193094);
+
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (55931, 55895, 59511, 59512);
+INSERT INTO `spell_script_names` (`spell_id` ,`ScriptName`) VALUES
+(55931, 'spell_prince_taldaram_conjure_flame_sphere'),
+(55895, 'spell_prince_taldaram_flame_sphere_summon'),
+(59511, 'spell_prince_taldaram_flame_sphere_summon'),
+(59512, 'spell_prince_taldaram_flame_sphere_summon');