diff options
| -rw-r--r-- | sql/updates/world/master/2021_01_16_08_world_2017_10_29_04_world_335.sql | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_01_16_08_world_2017_10_29_04_world_335.sql b/sql/updates/world/master/2021_01_16_08_world_2017_10_29_04_world_335.sql new file mode 100644 index 00000000000..753c2f5a1c5 --- /dev/null +++ b/sql/updates/world/master/2021_01_16_08_world_2017_10_29_04_world_335.sql @@ -0,0 +1,44 @@ +DELETE FROM `quest_greeting` WHERE `ID` IN (234, 235, 237, 238, 241, 253, 261, 342, 714, 786, 823, 1343, 1374, /*1495,*/ 1499, /*1500, 1515,*/ 1518, 2519, /*2546,*/ 2930, 3139, 3188, 3338, /*3391,*/ 3419, 3446, 3453, /*3567, 3616, 3649, 4077, 4453,*/ 5887, /*6171, 7407,*/ 7876/*, 27337*/); +INSERT INTO `quest_greeting` (`ID`, `Type`, `GreetEmoteType`, `GreetEmoteDelay`, `Greeting`, `VerifiedBuild`) VALUES +(234, 0, 1, 0, "A foul corruption has crept into Westfall. While I was upholding my duty on the battlefields of Lordaeron these honest farms were overrun and made into hide-outs for thugs and murderers. The People's Militia needs your help.", 0), +(235, 0, 0, 0, "Welcome to our humble abode! It's always nice to see a friendly face. And what strong arms you have. My husband and I are always looking for help around the farm. Now that most the good folk have left, it's hard to find an able body to help out.", 0), +(237, 0, 0, 0, "Nothing but trouble in these parts. I tried to tell that fool Saldean to get out while he still could but he won't hear of it. But I ain't no fool. Verna and I are gonna mosey on out as soon as we get this wagon fixed.", 0), +(238, 0, 0, 0, "Sometimes I think there's a big gray cloud in the sky, just raining down bad luck upon us. First, we're driven off our land, and now we can't even get out of Westfall. Everything's a mess. Something needs to be done.", 0), +(241, 0, 0, 0, "Hey there, friend. My name's Remy.$BI'm from Redridge to the east, and came here looking for business, looking for business. You got any...got any??", 0), +(253, 0, 0, 0, "Aha! Good day, good day, Master $C! Come, sit down and have a drink. You have an enterprising look in your eye, and I think you'll find speaking to me worth your time...", 0), +(261, 0, 0, 0, "Hello, citizen. You look like a $g man : woman; with a purpose - do you have business with the Stormwind Army?", 0), +(342, 0, 0, 0, "Hail, $n. Welcome to my humble garden. The weather has been perfect lately. Let us hope it holds steady for a ripe harvest.", 0), +(714, 0, 0, 0, "Greetings, $c! Fine day for hunting, wouldn't you say? I've been having more than a little luck with boars, myself. Perhaps you'd like a shot?", 0), +(786, 0, 0, 0, "Greetings, $G lad : lass;. I'm Grelin Whitebeard. I'm here to examine the threat posed by the growing numbers of trolls in Coldridge Valley. What have I found? It's a bit troubling...", 0), +(823, 0, 1, 0, "Hello there, $c. Normally I'd be out on the beat looking after the folk of Stormwind, but a lot of the Stormwind guards are fighting in the other lands. So here I am, deputized and offering bounties when I'd rather be on patrol...", 0), +(1343, 0, 0, 0, "Well, if it isn't a young, bristling $c, no doubt drawn here by talk of my exploits in fields of battle!$B$BNo time for stories now, for there are great, important deeds that need doing! So if you're looking for glory, then luck shines on you today...", 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!", 0), +-- (1495, 0, 0, 0, "Greetings, $C. Be wary as you travel east toward The Bulwark. Recent surveillance reports indicate increased Scourge activity in that area, so exercise caution.", 0), +(1499, 0, 0, 0, "Ah, you there! I have tasks to give, and I need not waste time explaining their crucial nature. Listen close.", 0), +-- (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!", 0), +-- (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.", 0), +(1518, 0, 0, 0, "The Dark Lady has put forth the challenge. It is up to us to meet it.", 0), +(2519, 0, 0, 0, "Hello! The spirits say you here to aid my chief. Say it loud, they do.", 0), +-- (2546, 0, 0, 0, "Yarrr... ye best not be trifling with my time, matey!", 0), +(2930, 0, 0, 0, "Corruption sneaks into nature's grove. The forest must be protected at all costs.", 0), +(3139, 0, 0, 0, "Throm'ka, $c. There is little time for talk and much work to be done.", 0), +(3188, 0, 0, 0, "There is something you wish to discuss, $c... come, sit by me.", 0), +(3338, 0, 0, 0, "The land, the water and the sky are all as one. It is your eyes that deceive you with such separation. The Earthmother is all those things and more.", 0), +-- (3391, 0, 0, 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), +(3419, 0, 1, 0, "For our people to survive, we must study the ways of nature and learn its secrets.", 0), +(3446, 0, 0, 0, "Yes yes yes! You're just the $r I'm looking for!$B$BSit! We have much to discuss!!", 0), +(3453, 0, 0, 0, "Something I can help you with, $n? There's a shipment I've got to see to otherwise.", 0), +-- (3567, 0, 0, 0, "Well met, $n. It is good to see that $cs like yourself are taking an active part in protecting the groves.", 0), +-- (3616, 0, 0, 0, "The wind whispers to those who listen...$B$BDo you hear it?", 0), +-- (3649, 0, 1, 0, "Dark forces encroach upon our borders, ancient taints resurface, and new evils emerge to topple the delicate balance of the land. In times of such darkness, we all must be vigilant.", 0), +-- (4077, 0, 0, 0, "If I can get the proper ingredients, we can create some explosives that will not only allow me to damage the Venture's Co.'s operations, but also cause a distraction.$B$BI know you're impressed, but it gets better... I'll tell you more soon enough.", 0), +-- (4453, 0, 0, 0, "Be careful where you put that foot of yours, $g sir : ma'am;. We're not all blessed with the lofty height of a gnome.", 0), +(5887, 0, 0, 0, "I welcome you back, $n.", 0), +-- (6171, 0, 1, 0, "You will be tested many times by the darkness that surrounds our lands, $N. But to ensure you are always prepared, we will often ask tasks of you so you are at the height of your own power.$B$BGo with the Light, and remain virtuous.", 0), +-- (7407, 0, 0, 0, "The name's Bilgewhizzle, and I am the chief engineer of the Gadgetzan Water Company. What can I assist you with?", 0), +(7876, 0, 0, 0, "Some people wonder what we're doing out here in the desert. Well... If I told you, then you'd stay and try to make our profits!", 0); +-- (27337, 0, 0, 0, "", 0); + +UPDATE `creature_template` SET `gossip_menu_id`=0, `npcflag`=2 WHERE `entry` IN (786, 1343); +DELETE FROM `gossip_menu` WHERE `MenuID` IN (694, 10893); +DELETE FROM `npc_text` WHERE `ID`=1244; |