Scripts/Utgarde Pinnacle:

- Fix spamming of spell Ball of Flame (48246).
- Added missing text of Image of Arthas.
- Code cleanup and code style.
- Typo fix in sql naming in commit 6cb495048916a916804ebf8bde19e9619b12f897

3 files changed, 7 insertions, 0 deletions

diff --git a/sql/updates/world/2011_01_08_16_world_misc.sql b/sql/updates/world/2012_01_08_16_world_misc.sql
index 63cd81ff869..63cd81ff869 100644
--- a/sql/updates/world/2011_01_08_16_world_misc.sql
+++ b/sql/updates/world/2012_01_08_16_world_misc.sql
diff --git a/sql/updates/world/2012_01_09_01_world_creature_text.sql b/sql/updates/world/2012_01_09_01_world_creature_text.sql
new file mode 100644
index 00000000000..d1ec26bd7f4
--- /dev/null
+++ b/sql/updates/world/2012_01_09_01_world_creature_text.sql
@@ -0,0 +1,5 @@
+-- Missing Image of Arthas say text
+DELETE FROM `creature_text` WHERE `entry`=29280;
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(29280,0,0, 'Your sacrifice is a testament to your obedience. Indeed you are worthy of this charge. Arise, and forever be known as Svala Sorrowgrave!',14,0,0,0,0,14732, 'Image of Arthas SAY_DIALOG_OF_ARTHAS_1'),
+(29280,1,0, 'Your first test awaits you. Destroy our uninvited guests.',14,0,0,0,0,14733, 'Image of Arthas SAY_DIALOG_OF_ARTHAS_2');
diff --git a/sql/updates/world/2012_01_09_01_world_smart_scripts.sql b/sql/updates/world/2012_01_09_01_world_smart_scripts.sql
new file mode 100644
index 00000000000..a7304fa6e6a
--- /dev/null
+++ b/sql/updates/world/2012_01_09_01_world_smart_scripts.sql
@@ -0,0 +1,2 @@
+-- Fix spamming of spell Ball of Flame (48246)
+UPDATE `smart_scripts` SET `event_type`=54, `event_param1`=0, `event_param2`=0, `event_param3`=0, `event_param4`=0 WHERE `entryorguid`=27273;