DB/QuestGreeting: More Quest Greeting

Closes #23340

1 files changed, 62 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_06_05_03_world_335.sql b/sql/updates/world/3.3.5/2019_06_05_03_world_335.sql
new file mode 100644
index 00000000000..32273819685
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_06_05_03_world_335.sql
@@ -0,0 +1,62 @@
+-- 
+UPDATE `creature_template` SET `gossip_menu_id`=0, `npcflag`=2 WHERE `entry` IN (2497, 2215, 2785, 2920, 9177, 10260, 1139);
+DELETE FROM `quest_greeting` WHERE `ID` IN (239, 267, 272, 278, 288, 289, 294, 313, 341, 381, 382, 415, 464, 469, 633, 656, 663, 715, 1105, 1139, 1141, 1239, 1254, 1267, 1344, 1356, 1440, 1646, 1719, 1748, 1977, 2092, 2094, 2215, 2497, 2785, 2786, 2860, 2910, 2920, 3663, 3666, 3848, 4078, 4456, 4792, 5396, 5638, 6031, 6179, 6569, 6579, 9081, 9177, 9562, 10260, 16361, 16478, 16786, 16788) AND `Type`=0;
+INSERT INTO `quest_greeting` (`ID`, `Type`, `GreetEmoteType`, `Greeting`, `VerifiedBuild`) VALUES
+(239, 0, 0, "Adventure from lands far and near $bMeeting with folks both odd and queer $bBut if of me a question you ask $bYou must first complete a simple task!", 0),
+(267, 0, 0, "Welcome to the town of Darkshire.  Clerk Daltry at your service.  Can I be of some assistance?", 0),
+(272, 0, 0, "Hello, hello!  Welcome to my kitchen, $g sir : m'lady;!  This is where all of the Scarlet Raven Tavern's finest delicacies are made.  Ah, just smell the wonderful aroma!", 0),
+(278, 0, 0, "Hello, good $gsir:lady;.  Have a seat, and a meal if you're hungry.  Don't fret if I look busy with my needlework - I'm listening to you...", 0),
+(288, 0, 0, "Huh?!?  Oh.  You don't look like a Defias thief...or a member of the Night Watch.  Take pity on a poor soul, will ya?", 0),
+(289, 0, 0, "Eh?  Greetings, young $C.  You're a brave one to find your way here with all those wandering creatures about!$B$BWell now that you are here, maybe you can help an old hermit...", 0),
+(294, 0, 0, "Hail, traveler.  My eyesight may be poor but I can sense the footsteps of a $c from a mile away.  For years I defended Stormwind with pride but once my eyes failed me, I was forced to retire.", 0),
+(313, 0, 0, "Welcome to the Tower of Azora, young $C.  I am Theocritus.$B$BDo you have business with me?  Or...do I have business with you, perhaps?", 0),
+(341, 0, 0, "I don't have much time for idle talk, $N.  I've got to get this bridge rebuilt before the rains come.  I've finished every project on-time and under budget and I'm not about to start slipping now.", 0),
+(381, 0, 0, "Well met, $C.  If you're here for business, then get yourself a brew and we'll have ourselves a talk.", 0),
+(382, 0, 0, "I don't have time to chat, citizen, but if you're willing to give us a hand against the orcs, then I'll find a use for you.", 0),
+(415, 0, 0, "Hey $Gbuddy:ma'am;, do you think you could give me a hand with something?  I'm really in dire straits here...", 0),
+(464, 0, 0, "Hail, $C.  Ill times these are, my friend, for our town is besieged!  The Blackrock Orcs attack from Stonewatch Keep, the Shadowhides loom over the Tower of Ilgalar, and the Redridge Gnoll Pack gathers strength.  I hope you're not here for a holiday...", 0),
+(469, 0, 0, "Greetings, $c.  If you're a friend of Colonel Kurzen then I'll have you cut down where you stand! but if you've come to aid us, then lend an ear...", 0),
+(633, 0, 0, "It's dark times that have come, $c... All too soon will we lose everything... When the Light will forsake all but those who truly walk under the Light.", 0),
+(656, 0, 0, "There were thieves everywhere! $b$bIt was horrible.  The cave came down on us.  I think the mining company is all dead, including my brother, the Foreman.", 0),
+(663, 0, 0, "The Carevin family fights for victory under the Light. My duty under the Light is to give my life in their battle against against the undead. Master Carevin has tasked me with the extermination of the vile worgen in Duskwood. Perhaps you would assit me?", 0),
+(1105, 0, 0, "You know, I always wanted to be a Prospector, but I was born with a head for numbers and the Guild decided I would be best suited to keep the books! Studying, studying, every day of my youth...", 0),
+(1139, 0, 0, "Well hello there, citizen. The name's Bluntnose, Magistrate Bluntnose, to be precise. I'm charged with overseeing the well-being of Thelsamar, and believe you me, we could always use another strong set of arms around here!", 0),
+(1141, 0, 0, "If you're here for the food, then welcome!  You won't find finer dining in all of Stormwind...or Azeroth!$B$BIf you're here on other matters, then please be brief.  I have a dozen dishes in preparation, and must care for each.", 0),
+(1239, 0, 1, "If you're willing to endure tales that will shiver your timbers and sog your skivvies, then get yourself a drink and sit for a spell...", 0),
+(1254, 0, 0, "Troggs! I swear the gods put them in this land only to torment me! Four inches deeper into the mines, then two feet back from the troggs!", 0),
+(1267, 0, 0, "Welcome to the Thunderbrew Distillery, founded by dear ol' pappy, Arkilus Thunderbrew.  I've been keeping the place running ever since my older brother, Grimbooze, disappeared in a drunken haze a few harvests ago.", 0),
+(1344, 0, 0, "Although we're trudging through a slow period at these ruins, I'm confident it won't last long.  But in the meantime, I could use someone like you.  Would you like to aid the Dwarven Explorers' Guild?", 0),
+(1356, 0, 0, "I'm in the middle of a very important task.  Prospector business.  Unless you have something equally important to say, which I doubt, then you'll have to excuse me.", 0),
+(1440, 0, 1, "You'll not find a greater cache of knowledge than in the Royal Library of Stormwind!", 0),
+(1646, 0, 0, "Greetings, I am Baros Alexston, City Architect of Stormwind.", 0),
+(1719, 0, 0, "Over here, you worthless...! If you want to do something useful, listen quick!", 0),
+(1748, 0, 66, "I am Bolvar Fordragon, Highlord of Stormwind.", 0),
+(1977, 0, 0, "I was bred and educated for public service. A representative of the people. My skill was not in arms or crafts, but in words and persuasion", 0),
+(2092, 0, 0, "Siege engines are the pride of every pilot!", 0),
+(2094, 0, 0, "Greetings, $c. I'm in a bit of a pinch right now, running very low on hides.", 0),
+(2215, 0, 0, "In order to serve the Dark Lady and Varimathras we need to advance the front on the Human Infestation.", 0),
+(2497, 0, 0, "Eh?  You have business with Nimboya?", 0),
+(2785, 0, 0, "Back away!  Stay back!  I have a pack full of blastpowder and I'm not afraid to use it!  I'll blow us all away!$B$BOh, never mind.  I thought you were someone else....", 0),
+(2786, 0, 0, "Welcome to Bonegrip's Runes and Dooms, $c.  You may look, but do not touch.$B$BSome of the knowledge here is not meant for the...uninitiated.", 0),
+(2860, 0, 0, "It was quite a departure, let me tell you, $c. We were grabbing whatever wasn't nailed down or could be removed quickly. We're a little spare on supplies because of it.", 0),
+(2910, 0, 1, "Bastards came right at us at night, after we'd gotten a few drinks in us. Otherwise, we could've taken 'em, count on it.$B$BEveryone's dead now... except a few of us.", 0),
+(2920, 0, 1, "Hey there, $N.$B$BLotwil's not the most perceptive boss I've had. He actually gets really involved with his work. So much so that sometimes his servants don't eat, or get paid.$B$B<Lucien frowns over at Lotwil.>$B$BBut that doesn't mean you should suffer.", 0),
+(3663, 0, 0, "Good day, $glad:lass;! Perhaps you could help me with some things that need to be taken care of.", 0),
+(3666, 0, 0, "Hmm... I can plug this wire in here and that will power the fizzletan gear, but then the hydrophlange will need an alternate power source... Maybe I can... Oh, hello! Hey, want to help me try a new invention?", 0),
+(4078, 0, 6, "Hello, friend. What can I do for you?", 0),
+(4456, 0, 0, "No, Longears isn't my real name.  And I'm not going to tell you what it is, so don't ask.", 0),
+(4792, 0, 0, "Some people think the swamp's no good... no good, they say.", 0),
+(5396, 0, 0, "The Alliance has many stakes in Desolace, and our hold here is unstable.$B$BWill you help us?", 0),
+(5638, 0, 1, "I've got a lot going on out here in Desolace, $N. Roetten wants us to pick up some reagents for one of our clients as well as fetch some of these lost items.$B$BSeein' as you're here to help out, why don't we get started?", 0),
+(6031, 0, 1, "Some can't stand the heat of the Great Forge, but I think the heat is just right.  And it's the best place to do some serious smithwork.", 0),
+(6179, 0, 1, "Many tests await a paladin of the Light, $N. Be assured, our paths will cross many times in the future if you remain passionate and hold to those virtues that we praise.", 0),
+(6569, 0, 0, "Where Troggs and Leper Gnomes roam stands our home - Gnomeregan.$B$BOur families lost, our homes displaced. Scattered.$B$BOh how I long for the days of carefree Gnomeregan life, but those days are no more. We must make our stand! We must save Gnomeregan!", 0),
+(6579, 0, 0, "For Gnomeregan!", 0),
+(9081, 0, 25, "I never miss...", 0),
+(9177, 0, 5, "Stand at attention, soldier!$B$BWINKY! SOUND OFF!", 0),
+(9562, 0, 2, "Greetings, $R.", 0),
+(10260, 0, 5, "Welcome to Kibler's Exotic Pets! How can you help me today??", 0),
+(16361, 0, 1, "The Lich King has brought war against us from the frozen north, and only we of the Argent Dawn stand in his way.", 0),
+(16478, 0, 1, "Good day to you, citizen. Have you come to aid us against the Scourge?", 0),
+(16786, 0, 66, "Greetings, $n. If you bring me necrotic stones from the undead invaders, I can give you access to the stores of the Argent Dawn.", 0),
+(16788, 0, 1, "Greetings, $c. I am the Flamekeeper. During the Midsummer Fire Festival, it is my duty to keep this fire beside me burning brightly. It is an honor to be selected for such a task; I fill it gladly.$b$b How can I help you?", 0);