diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2018_12_08_37_world_335.sql | 48 |
1 files changed, 48 insertions, 0 deletions
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); |