Core/Script: update creature_text for the Paladin Trial Quests in Eversong from sniffs

closes #4699

1 files changed, 9 insertions, 0 deletions

diff --git a/sql/updates/world/2012_01_08_11_world_creature_text.sql b/sql/updates/world/2012_01_08_11_world_creature_text.sql
new file mode 100644
index 00000000000..bf34c1f541c
--- /dev/null
+++ b/sql/updates/world/2012_01_08_11_world_creature_text.sql
@@ -0,0 +1,9 @@
+-- Remove old script text for eversong_woods.cpp
+DELETE FROM `script_texts` WHERE `entry` BETWEEN -1000637 AND -1000640;
+-- Master Kelerun Bloodmourn <Blood Knight> say text
+DELETE FROM `creature_text` WHERE `entry`=17807;
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(17807,0,0, 'Let the trial begin, Bloodwrath, attack!',14,0,100,0,0,0, 'Master Kelerun Bloodmourn'),
+(17807,1,0, 'Champion Lightrend, make me proud!',14,0,100,0,0,0, 'Master Kelerun Bloodmourn'),
+(17807,2,0, 'Show this upstart how a real Blood Knight fights, Swiftblade!',14,0,100,0,0,0, 'Master Kelerun Bloodmourn'),
+(17807,3,0, 'Show $N the meaning of pain, Sunstriker!',14,0,100,0,0,0, 'Master Kelerun Bloodmourn');