diff options
| -rw-r--r-- | sql/updates/world/2014_12_26_07_world.sql | 57 |
1 files changed, 57 insertions, 0 deletions
diff --git a/sql/updates/world/2014_12_26_07_world.sql b/sql/updates/world/2014_12_26_07_world.sql new file mode 100644 index 00000000000..984b8b1f91f --- /dev/null +++ b/sql/updates/world/2014_12_26_07_world.sql @@ -0,0 +1,57 @@ +ALTER TABLE `quest_greeting` + DROP PRIMARY KEY, + ADD PRIMARY KEY (`ID`, `Type`); + +DELETE FROM `quest_greeting` WHERE `Id` IN (48360, 48358, 48363, 48361, 1500, 48069, 48071, 48070, 48062, 5767, 45315, 2080, 27337, 1515, 35094, 3337, 3567, 3519, 3391, 4791, 24139, 43738, 900, 344, 392, 40109, 75913, 81144, 233100, 75119, 75392, 76665, 75127, 79618, 87391, 83773, 80157, 82569, 82575, 34675, 85130, 80508, 232400, 80648, 79979, 81588, 77167, 82126, 75896, 86355, 81601); +INSERT INTO `quest_greeting` (`Id`, `Type`, `GreetEmoteType`, `GreetEmoteDelay`, `Greeting`, `VerifiedBuild`) VALUES +(48360, 0, 5, 0, 'For the Horde!', 15595), +(48358, 0, 66, 0, 'Lok''tar!', 15595), +(48363, 0, 0, 0, '', 15595), +(48361, 0, 25, 0, 'Hellscream''s eyes are upon you!', 15595), +(1500, 0, 0, 0, 'I hope you''re well, all things considered.$B$BSit for a spell, and hear my tale. It''s a tragedy, of course, but one I hope will end in revenge!', 15595), +(48069, 0, 6, 0, 'Yes?', 15595), +(48071, 0, 0, 0, '', 15595), +(48070, 0, 6, 0, 'What is it that you want?', 15595), +(48062, 0, 0, 0, '', 15595), +(5767, 0, 1, 0, 'Our only hope is to create something good from an already bad situation.', 15595), +(45315, 0, 66, 0, '<Onslaught salutes.>', 15595), +(2080, 0, 1, 0, 'The creation of Teldrassil was a grand achievement, but now the world must shift to regain its balance.', 15595), +(27337, 0, 0, 0, '', 15595), +(1515, 0, 0, 0, 'The Scarlet Crusade is encroaching on our homeland. The foolish zealots do not realize that the loyal servants of The Dark Lady shall see to their demise.', 15595), +(35094, 0, 0, 0, '', 15595), +(3337, 0, 0, 0, 'The heft of an axe, the battlecry of your allies, the spray of blood in your face. These are the things a warrior craves, $n. I will carve out the barrens with my sword in the name of the Horde.', 15595), +(3567, 0, 1, 0, 'Well met, $n. It is good to see that $cs like yourself are taking an active part in protecting the groves.', 15595), +(3519, 0, 0, 0, 'I, Arynia Cloudsbreak, have been tasked with protecting the sanctity of the Oracle Grove.', 15595), +(3391, 0, 1, 0, 'Thrall paid me and my boys well for helping out with the construction of Orgrimmar, so I decided to set up a port here. We do most of our business through Booty Bay and Baron Revilgaz.', 15595), +(4791, 0, 1, 0, 'We may not be in open war with the Alliance, but blood is still shed between us.', 15595), +(24139, 0, 0, 0, '', 15595), +(43738, 0, 0, 0, 'Lord Harris has sent me here to collect reagents. Our work cannot be delayed...', 15595), +(900, 0, 6, 0, 'What business brings you before the Court of Lakeshire and the Honorable Magistrate Solomon?', 15595), +(344, 0, 5, 0, 'Redridge is awash in chaos!', 15595), +(392, 0, 0, 0, 'Do not be alarmed, $r. I have long since passed from this land but I intend no harm to your kind. I have witnessed too much death in my time. My only wish now is for peace. Perhaps you can help my cause.', 15595), +(40109, 0, 0, 0, '', 15595), +(75913, 0, 0, 0, 'Thank you, we could not have escaped without your help.', 19342), +(81144, 0, 0, 0, 'It took some work getting up here...', 19342), +(233100, 1, 0, 0, 'This poster is a list of bounties put up by citizens of Southport.', 19342), +(75119, 0, 0, 0, 'The Light is screaming for aid.', 19342), +(75392, 0, 0, 0, 'The spirits within Auchindoun grow restless. Darkness is near.', 19342), +(76665, 0, 1, 0, 'I''ve been waiting for your arrival, adventurer.', 19342), +(75127, 0, 0, 0, 'The Iron Horde is a plague upon this land!', 19342), +(79618, 0, 0, 0, '', 19342), +(87391, 0, 0, 0, 'I can offer the twisting of time for a variety of prices. Three seals can be obtained this week, but four options I present. Choose wisely.', 19342), +(83773, 0, 0, 0, 'This is no land fer a dwarf.', 19342), +(80157, 0, 0, 0, 'Seeing is not, in fact, believing.', 19342), +(82569, 0, 0, 0, 'This dwarf didn''t make it out of Tangleheart alive, but her journal remains behind.', 19342), +(82575, 0, 3, 0, 'Lots o'' lumber to be had in Gorgrond. Always need more, though.', 19342), +(34675, 0, 0, 0, '', 19342), +(85130, 0, 11, 0, 'You stuck it to ''em didn''t ya, commander?', 19342), +(80508, 0, 0, 0, 'The shadows are restless.', 19342), +(232400, 1, 0, 0, 'Attention, Commander $n. The following notices require your attention.', 19342), +(80648, 0, 0, 0, 'Speak, mortal. The raven god is listening.', 19342), +(79979, 0, 0, 0, '', 19342), +(81588, 0, 1, 0, 'This is all my fault ya know. I gave them dwarves coordinates to where I thought we could get a good listenin'' post on the Blackrock orcs.$b$bI dinna realize just how much the locals could disrupt mole machine navigation.', 19342), +(77167, 0, 0, 0, 'Let''s do this.', 19342), +(82126, 0, 0, 0, 'My mind... everything is so fuzzy.', 19342), +(75896, 0, 0, 0, 'It is too late. Aruuna is lost.', 19342), +(86355, 0, 0, 0, 'Speak, mortal. The raven god is listening.', 19342), +(81601, 0, 0, 0, 'I canna'' believe them botani were fattening me up just to mulch me.$b$bI may not be a farmer but I gotta expect there are more optimal ways to feed a plant.', 19342); |