More missing script_texts by Tome

- Master Kelerun Bloodmourn
- fix typo in previous commit
- fix typo in script and apply some standards

--HG--
branch : trunk

3 files changed, 19 insertions, 8 deletions

diff --git a/sql/scripts/world_script_texts.sql b/sql/scripts/world_script_texts.sql
index 5e7fb2e9651..4fc024299f8 100644
--- a/sql/scripts/world_script_texts.sql
+++ b/sql/scripts/world_script_texts.sql
@@ -486,7 +486,11 @@ INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`
    (0,-1000634,'Our Bloodmyst scouts have located our contact. The fool, Velen, will soon leave himself open and defenseless -- long enough for us to strike! Now get out of my sight before I vaporize you...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'geezle - SPARK_SAY_6'),
    (0,-1000635,'Yes, sir. It won''t happen again...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'geezle - GEEZLE_SAY_7'),
    (0,-1000636,'picks up the naga flag.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0,0,'geezle - EMOTE_SPARK'),
-   
+   (17807,-1000637,'Let the trial begin, Bloodwrath, attack!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'npc_second_trial_controller TEXT_SECOND_TRIAL_1'),
+   (17807,-1000638,'Champion Lightrend, make me proud!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'npc_second_trial_controller TEXT_SECOND_TRIAL_2'),
+   (17807,-1000639,'Show this upstart how a real Blood Knight fights, Swiftblade!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'npc_second_trial_controller TEXT_SECOND_TRIAL_3'),
+   (17807,-1000640,'Show $n the meaning of pain, Sunstriker!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'npc_second_trial_controller TEXT_SECOND_TRIAL_4'),
+
    (26588,-1800001,'Um... I think one of those wolves is back...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'12027'),
    (26588,-1800002,'He''s going for Mr. Floppy! ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'12027'),
    (26588,-1800003,'Oh, no! Look, it''s another wolf, and it''s a biiiiiig one!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'12027'),
diff --git a/sql/updates/10258_world_script_texts.sql b/sql/updates/10258_world_script_texts.sql
deleted file mode 100644
index 6dbfae2a133..00000000000
--- a/sql/updates/10258_world_script_texts.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-UPDATE `script_texts` SET `language`=0 WHERE `entry`='-1000600';
-DELETE FROM `script_texts` WHERE `entry` IN (-1619006,-1575021,-1619015,1619016);
-INSERT INTO `script_texts` (`npc_entry`, `entry`, `content_default`, `comment`) VALUES
-(26668,-1575021,'Another soul for my master.','Svala Sorrowgrave SAY_SLAY_3'),
-(29310,-1619006,'You are unworthy!','Jedoga Shadowseeker SAY_SLAY_2'),
-(29309,-1619015,'Sleep now, in the cold dark.','Elder Nadox SAY_SLAY_1'),
-(29309,-1619016,'For the Lich King!','Elder Nadox SAY_SLAY_2');
diff --git a/sql/updates/10282_world_script_texts.sql b/sql/updates/10282_world_script_texts.sql
new file mode 100644
index 00000000000..b821dad26dc
--- /dev/null
+++ b/sql/updates/10282_world_script_texts.sql
@@ -0,0 +1,14 @@
+UPDATE `script_texts` SET `language`=0 WHERE `entry`='-1000600';
+DELETE FROM `script_texts` WHERE `entry` IN (-1619006,-1575021,-1619015,-1619016);
+INSERT INTO `script_texts` (`npc_entry`, `entry`, `content_default`, `comment`) VALUES
+(26668,-1575021,'Another soul for my master.','Svala Sorrowgrave SAY_SLAY_3'),
+(29310,-1619006,'You are unworthy!','Jedoga Shadowseeker SAY_SLAY_2'),
+(29309,-1619015,'Sleep now, in the cold dark.','Elder Nadox SAY_SLAY_1'),
+(29309,-1619016,'For the Lich King!','Elder Nadox SAY_SLAY_2');
+
+DELETE FROM `script_texts` WHERE `entry` IN (-1000637,-1000638,-1000639,-1000640);
+INSERT INTO `script_texts` (`npc_entry`, `entry`, `content_default`, `comment`) VALUES 
+('17807', '-1000637', 'Let the trial begin, Bloodwrath, attack!', 'npc_second_trial_controller TEXT_SECOND_TRIAL_1'),
+('17807', '-1000638', 'Champion Lightrend, make me proud!', 'npc_second_trial_controller TEXT_SECOND_TRIAL_2'),
+('17807', '-1000639', 'Show this upstart how a real Blood Knight fights, Swiftblade!', 'npc_second_trial_controller TEXT_SECOND_TRIAL_3'),
+('17807', '-1000640', 'Show $n the meaning of pain, Sunstriker!', 'npc_second_trial_controller TEXT_SECOND_TRIAL_4');