DB/Misc: More Quest Greetings

Closes #23183

(cherry picked from commit 273b1e77121ca4176e3a2b99bb144bbb85f3f511)

1 files changed, 27 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_11_27_07_world_2019_04_12_00_world_335.sql b/sql/updates/world/master/2021_11_27_07_world_2019_04_12_00_world_335.sql
new file mode 100644
index 00000000000..fe598419075
--- /dev/null
+++ b/sql/updates/world/master/2021_11_27_07_world_2019_04_12_00_world_335.sql
@@ -0,0 +1,27 @@
+-- 
+DELETE FROM `quest_greeting` WHERE `ID` IN (5770,273,1071,2700,2713,2276,2263,186420,265,4794,7884,10306,23572,737,773,2076,2121,2921,5394,5591,7900,9078,11039,1374);
+INSERT INTO `quest_greeting` (`ID`, `Type`, `GreetEmoteType`, `GreetEmoteDelay`, `Greeting`, `VerifiedBuild`) VALUES
+(5770,0,0,0,"If we are to protect nature, then we must embrace its strength.  And we must show this strength to those who would harm the land.",0), -- Nara Wildmane
+(273,0,0,0,"Keep the door closed, $c. Never know when the Dark Riders will be passing through again.",0), -- Tavernkeep Smitts
+(1071,0,0,0,"If there's one thing that Rhag taught me it's that no assignment is a dull one. Protecting the Thandol Span should have been an easy task. But with the brunt of the army fighting alongside the Alliance, we were overwhelmed here and Dun Modr has fallen.",0), -- Longbraid the Grim
+(2713,1,0,0,"This wooden board holds roughly made wanted posters.",0), -- Wanted Board
+(2700,0,0,0,"We at Refuge Pointe hold one of the few remaining patches of Stromgarde territory in the Arathi Highlands. And we're losing ground...$B$BIf you have words for me, then I hope they are good doings.",0), -- Captain Nials
+(2276,0,0,0,"When I was first offered the title of Southshore Magistrate I was exalted to have earned such a commission so early in my career.$B$BBut now that I'm here, I wonder if I'd have been better off shuffling papers in Stormwind.",0), -- Magistrate Henry Maleb
+(2263,0,0,0,"I hope you're here to work, $C. We have a lot to do and the Horde, the Syndicate and the Ogres aren't going to help us.",0), -- Marshal Redpath
+(186420,1,0,0,"This collection of scrolls contains various logistic and strategic information, as well as coded correspondences.",0), -- Syndicate Documents
+(265,0,0,0,"I have sensed your coming for quite some time, $n.  It was written in the pattern of the stars.",0), -- Madame Eva
+(4794,0,0,0,"Researching in Theramore is an interesting job, but it's sure hard to find a soft bed in this town!",0), -- Morgan Stern
+(7884,0,0,0,"",0), -- Fraggar Thundermantle
+(10306,0,0,0,"",0), -- Trull Failbane
+(23572,0,0,0,"",0), -- Drazzit Dripvalve
+(737,0,0,0,"Well, hello there. You seem like you wouldn't be opposed to making some coin, hm? I can tell from the look in your eyes. I am Mogul Kebok, overseer of operations in Azeroth, and if it is riches you seek, perhaps I can make arrangements.",0),
+(773,0,0,0,"$C, eh? I am Krazek, Baron Revilgaz's secretary. I know everything about the goings on in this jungle and beyond. Perhaps you'd be interested in knowing the going price on oil in Ratchet? No? Looking for work, maybe? I can help you there.",0),
+(2076,0,0,0,"This cauldron churns with thick, green bubbles.  Skulls, bones and organs of unknown creatures swim within its viscous broth...$B$BAnd rising lazily to the surface are the skulls of two, once mighty trolls:$B$BGan'zulah and Nezzliok.",0),
+(2121,0,0,0,"Information... With our scouts and agents, we control the flow of information in Lordaeron. Scourge movements, their holdings, all underneath our watchful eyes...",0),
+(2921,0,0,0,"How perfect of you to come by, $c.$B$BMy name is Lotwil Veriatus, founding member of the Enlightened Assembly of Arcanology, Alchemy, and Engineering Sciences: we seek to blend the intelligent sciences of Azeroth together into one comprehensive school.",0),
+(5394,0,0,0,"Don't let the heat bother you.  In the Badlands, heat is the least of your worries.",0),
+(5591,0,0,0,"This sty's a little shy of comfy, but it has history, so Stonard must be important to someone. I'd gamble that's why we stay here. It sure ain't for the view--it don't even look like home.",0),
+(7900,0,0,0,"Hello, $N. Perhaps you have some time to chat?",0),
+(9078,0,0,0,"Dear $g boy:girl;, you have arrived just in time to assist the Kargath Expeditionary Force.",0),
+(11039,0,0,0,"Greetings, $N. I am Duke Nicholas Zverenhoff of the Argent Dawn.",0),
+(1374,0,0,0,"Curse that Brewers' League! They have access to all the best ingredients, while we're stuck here grubbing for grain and hops!$B$BI really would like to give them some bitter tasting justice...",0); -- Rejold Barleybrew