DB/Quests: Added some data to quest_greeting

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);