diff options
| -rw-r--r-- | sql/updates/world/master/2024_01_26_03_world.sql | 51 |
1 files changed, 51 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_01_26_03_world.sql b/sql/updates/world/master/2024_01_26_03_world.sql new file mode 100644 index 00000000000..6b358e6a88e --- /dev/null +++ b/sql/updates/world/master/2024_01_26_03_world.sql @@ -0,0 +1,51 @@ +DELETE FROM `quest_request_items` WHERE `ID` IN (24489,25724,24471,24470,24469,25841,28868,25792,26094,25905,25932,26118,26085,26146,26078,25979,25978,26102,25667); +INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `EmoteOnCompleteDelay`, `EmoteOnIncompleteDelay`, `CompletionText`, `VerifiedBuild`) VALUES +(24489, 0, 0, 0, 0, 'I can\'t even begin to imagine what would make the trolls act like this.', 53007), +(25724, 0, 1, 0, 0, 'How is the situation on Shimmer Ridge?', 53007), +(24471, 0, 0, 0, 0, 'Thanks for yer help, $n.', 53007), +(24470, 0, 6, 0, 0, 'Well, what\'re ye waitin\' for, $c?', 53007), +(24469, 0, 6, 0, 0, 'How many of \'em did ya get?', 53007), +(25841, 0, 1, 0, 0, 'Did you signal the air wing to take out the troll buildings?', 53007), +(28868, 0, 1, 0, 0, 'Did you show them what it\'s like to be a gnome?', 53007), +(25792, 0, 0, 0, 0, 'Was the rune able to destroy the totems? Were we too late?', 53007), +(26094, 0, 1, 0, 0, 'At last, we finally have a chance to hurt the Dark Iron attackers.', 53007), +(25905, 0, 1, 0, 0, '', 53007), +(25932, 0, 1, 0, 0, 'We\'re glad to have your help, $n.', 53007), +(26118, 0, 1, 0, 0, 'We must stop the ambassador before he causes more harm.', 53007), +(26085, 0, 1, 0, 0, 'We must do what little we can to keep the defenders\' spirits high.', 53007), +(26146, 0, 6, 0, 0, 'Loch Modan is under siege, $n! We need every able-bodied member of the Alliance to aid our cause. Have you killed those troggs yet?', 53007), +(26078, 0, 1, 0, 0, 'We need to hurry and get those bombers airborne!', 53007), +(25979, 0, 1, 0, 0, 'Something has to be done. We can\'t leave the lake like this. ', 53007), +(25978, 0, 1, 0, 0, 'Were you able to help any of the mountaineers?', 53007), +(26102, 0, 6, 0, 0, 'If we can defeat General Grimaxe, the Dark Iron forces won\'t be able to regroup.', 53007), +(25667, 0, 1, 0, 0, 'How goes the fight against the wendigos?', 53007); + +DELETE FROM `quest_request_items` WHERE `ID` IN (24623,24774,24642,24780,24773,24771,24639,24777,24768,24765,24762,24761,24759,26276,26275,24786,24785,26273,24783,31161,31160,31158); +INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `EmoteOnCompleteDelay`, `EmoteOnIncompleteDelay`, `CompletionText`, `VerifiedBuild`) VALUES +(24623, 0, 1, 0, 0, 'Poor little tings.', 52983), -- 24623 +(24774, 0, 1, 0, 0, 'All trolls gotta prove demselves before we let them move past da training grounds.', 52983), -- 24774 +(24642, 0, 1, 0, 0, 'All trolls gotta prove demselves before we let them move past da training grounds.', 52983), -- 24642 +(24780, 0, 1, 0, 0, 'All trolls gotta prove demselves before we let them move past da training grounds.', 52983), -- 24780 +(24773, 0, 0, 0, 0, 'I doubt dey too much of a challenge, mon, but they\'ll still claw up ya ankles if ya don\'t stay quick footed.', 52983), -- 24773 +(24771, 0, 1, 0, 0, 'Strength isn\'t da end all of defeating ya enemy, and it most certainly isn\'t tha end all of stayin\' alive. Fightin\' is about balance. Everytin has its time and place.', 52983), -- 24771 +(24639, 0, 1, 0, 0, 'Strength isn\'t da end all of defeating ya enemy, and it most certainly isn\'t tha end all of stayin\' alive. Fightin\' is about balance. Everytin has its time and place.', 52983), -- 24639 +(24777, 0, 1, 0, 0, 'Aim isn\'t da end all of defeating ya enemy, and it most certainly isn\'t tha end all of stayin\' alive. Fightin\' is about balance. Everytin has its time and place.', 52983), -- 24777 +(24768, 0, 1, 0, 0, 'All trolls gotta prove demselves before we let them move past da training grounds.', 52983), -- 24768 +(24765, 0, 1, 0, 0, 'Strength isn\'t da end all of defeating ya enemy, and it most certainly isn\'t tha end all of stayin\' alive. Fightin\' is about balance. This\'ll become more apparent as ya learn animal forms, but it holds true even now. Everytin\' has its time and place.', 52983), -- 24765 +(24762, 0, 1, 0, 0, 'All trolls gotta prove demselves before we let them move past da training grounds.', 52983), -- 24762 +(24761, 0, 0, 0, 0, 'I doubt dey too much of a challenge, mon, but they\'ll still claw up ya ankles if ya don\'t stay quick footed.', 52983), -- 24761 +(24759, 0, 1, 0, 0, 'Power isn\'t da end all of defeating ya enemy, and it most certainly isn\'t tha end all of stayin\' alive. Fightin\' is about balance. Everytin has its time and place.', 52983), -- 24759 +(26276, 0, 1, 0, 0, 'All trolls gotta prove demselves before we let them move past da training grounds.', 52983), -- 26276 +(26275, 0, 0, 0, 0, 'I doubt dey too much of a challenge, mon, but they\'ll still claw up ya ankles if ya don\'t stay quick footed.', 52983), -- 26275 +(24786, 0, 1, 0, 0, 'All trolls gotta prove demselves before we let them move past da training grounds.', 52983), -- 24786 +(24785, 0, 0, 0, 0, 'I doubt dey too much of a challenge, mon, but they\'ll still claw up ya ankles if ya don\'t stay quick footed.', 52983), -- 24785 +(26273, 0, 1, 0, 0, 'Power stems from dis world and worlds you\'ve not yet seen. Masterin\' da power of one ain\'t gonna be enough ta make it outside of dese trainin\' grounds - you gonna need to be pullin ya power from all of dem.', 52983), -- 26273 +(24783, 0, 1, 0, 0, 'Power isn\'t da end all of defeating ya enemy, and it most certainly isn\'t tha end all of stayin\' alive. Fightin\' is about balance. Everytin has its time and place.', 52983), -- 24783 +(31161, 0, 1, 0, 0, 'All trolls gotta prove demselves before we let them move past da training grounds.', 52983), -- 31161 +(31160, 0, 0, 0, 0, 'I doubt dey too much of a challenge, mon, but they\'ll still claw up ya ankles if ya don\'t stay quick footed.', 52983), -- 31160 +(31158, 0, 1, 0, 0, 'Strength isn\'t da end all of defeating ya enemy, and it most certainly isn\'t tha end all of stayin\' alive. Fightin\' is about balance. Everytin has its time and place.', 52983); -- 31158 + +DELETE FROM `quest_request_items` WHERE `ID` IN (14001,14113); +INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `EmoteOnCompleteDelay`, `EmoteOnIncompleteDelay`, `CompletionText`, `VerifiedBuild`) VALUES +(14001, 0, 5, 0, 0, 'I still see some out there! Please, $n, go get them before they drown!', 52983), -- 14001 +(14113, 0, 6, 0, 0, 'How\'s the party going?$B$BYou look amazing! So dashing and handsome, sir!', 52983); -- 14113 |