16 files changed, 20 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');
diff --git a/sql/updates/world/2014_01_23_14_world_creature_template.sql b/sql/updates/world/2014_01_23_14_world_creature_template.sql
new file mode 100644
index 00000000000..05ce8f568fc
--- /dev/null
+++ b/sql/updates/world/2014_01_23_14_world_creature_template.sql
@@ -0,0 +1,4 @@
+--
+UPDATE `creature_template` SET `faction_A`=64, `faction_H`=64 WHERE `entry` IN (39675, 39368, 39386, 39678, 39396, 39275, 39349);
+UPDATE `creature_template` SET `faction_A`=875, `faction_H`=875 WHERE `entry` IN (39717, 39716, 39715);
+UPDATE `creature_template` SET `faction_A`=59, `faction_H`=59 WHERE `entry`=1117;
diff --git a/sql/updates/world/2014_01_23_15_world_spell_script_names.sql b/sql/updates/world/2014_01_23_15_world_spell_script_names.sql
new file mode 100644
index 00000000000..f3812f60e2c
--- /dev/null
+++ b/sql/updates/world/2014_01_23_15_world_spell_script_names.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_script_names` WHERE `spell_id`=51690;
+INSERT INTO `spell_script_names` (`spell_id` ,`ScriptName`) VALUES
+(51690, 'spell_rog_killing_spree');