From beb4a11b480f708f7faecf7f602168ba3e73afdf Mon Sep 17 00:00:00 2001 From: ZenoX92 Date: Sat, 8 Dec 2018 11:06:23 +0100 Subject: DB/Quest: The Grateful Dead Closes #22750 --- .../world/3.3.5/2018_12_08_37_world_335.sql | 48 ++++++++++++++++++++++ 1 file changed, 48 insertions(+) create mode 100644 sql/updates/world/3.3.5/2018_12_08_37_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2018_12_08_37_world_335.sql b/sql/updates/world/3.3.5/2018_12_08_37_world_335.sql new file mode 100644 index 00000000000..399aff4a8a1 --- /dev/null +++ b/sql/updates/world/3.3.5/2018_12_08_37_world_335.sql @@ -0,0 +1,48 @@ +-- Quest "The Grateful Dead" +DELETE FROM `quest_details` WHERE `ID` IN (13952,14166,14167,14168,14169,14170,14171,14172,14173,14174,14175,14176,14177); +INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES +(13952,1,0,0,0,0,0,0,0,0), +(14166,1,0,0,0,0,0,0,0,0), +(14167,1,0,0,0,0,0,0,0,0), +(14168,1,0,0,0,0,0,0,0,0), +(14169,1,0,0,0,0,0,0,0,0), +(14170,1,0,0,0,0,0,0,0,0), +(14171,1,0,0,0,0,0,0,0,0), +(14172,1,0,0,0,0,0,0,0,0), +(14173,1,0,0,0,0,0,0,0,0), +(14174,1,0,0,0,0,0,0,0,0), +(14175,1,0,0,0,0,0,0,0,0), +(14176,1,0,0,0,0,0,0,0,0), +(14177,1,0,0,0,0,0,0,0,0); + +DELETE FROM `quest_request_items` WHERE `ID` IN (13952,14166,14167,14168,14169,14170,14171,14172,14173,14174,14175,14176,14177); +INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `CompletionText`, `VerifiedBuild`) VALUES +(13952,6,6,"You don't have any Bread of the Dead, do you?",0), +(14166,6,6,"You don't have any Bread of the Dead, do you?",0), +(14167,6,6,"You don't have any Bread of the Dead, do you?",0), +(14168,6,6,"You don't have any Bread of the Dead, do you?",0), +(14169,6,6,"You don't have any Bread of the Dead, do you?",0), +(14170,6,6,"You don't have any Bread of the Dead, do you?",0), +(14171,6,6,"You don't have any Bread of the Dead, do you?",0), +(14172,6,6,"You don't have any Bread of the Dead, do you?",0), +(14173,6,6,"You don't have any Bread of the Dead, do you?",0), +(14174,6,6,"You don't have any Bread of the Dead, do you?",0), +(14175,6,6,"You don't have any Bread of the Dead, do you?",0), +(14176,6,6,"You don't have any Bread of the Dead, do you?",0), +(14177,6,6,"You don't have any Bread of the Dead, do you?",0); + +DELETE FROM `quest_offer_reward` WHERE `ID` IN (13952,14166,14167,14168,14169,14170,14171,14172,14173,14174,14175,14176,14177); +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(13952,2,0,0,0,0,0,0,0,"Ah, more delicious Bread of the Dead, thank you!$B$BPlease, take this in return... a little something fun for the holiday.",0), +(14166,2,0,0,0,0,0,0,0,"Ah, more delicious Bread of the Dead, thank you!$B$BPlease, take this in return... a little something fun for the holiday.",0), +(14167,2,0,0,0,0,0,0,0,"Ah, more delicious Bread of the Dead, thank you!$B$BPlease, take this in return... a little something fun for the holiday.",0), +(14168,2,0,0,0,0,0,0,0,"Ah, more delicious Bread of the Dead, thank you!$B$BPlease, take this in return... a little something fun for the holiday.",0), +(14169,2,0,0,0,0,0,0,0,"Ah, more delicious Bread of the Dead, thank you!$B$BPlease, take this in return... a little something fun for the holiday.",0), +(14170,2,0,0,0,0,0,0,0,"Ah, more delicious Bread of the Dead, thank you!$B$BPlease, take this in return... a little something fun for the holiday.",0), +(14171,2,0,0,0,0,0,0,0,"Ah, more delicious Bread of the Dead, thank you!$B$BPlease, take this in return... a little something fun for the holiday.",0), +(14172,2,0,0,0,0,0,0,0,"Ah, more delicious Bread of the Dead, thank you!$B$BPlease, take this in return... a little something fun for the holiday.",0), +(14173,2,0,0,0,0,0,0,0,"Ah, more delicious Bread of the Dead, thank you!$B$BPlease, take this in return... a little something fun for the holiday.",0), +(14174,2,0,0,0,0,0,0,0,"Ah, more delicious Bread of the Dead, thank you!$B$BPlease, take this in return... a little something fun for the holiday.",0), +(14175,2,0,0,0,0,0,0,0,"Ah, more delicious Bread of the Dead, thank you!$B$BPlease, take this in return... a little something fun for the holiday.",0), +(14176,2,0,0,0,0,0,0,0,"Ah, more delicious Bread of the Dead, thank you!$B$BPlease, take this in return... a little something fun for the holiday.",0), +(14177,2,0,0,0,0,0,0,0,"Ah, more delicious Bread of the Dead, thank you!$B$BPlease, take this in return... a little something fun for the holiday.",0); -- cgit v1.2.3