From bd6a3fc95396f01c342ee1fc4bfd813ff5866f26 Mon Sep 17 00:00:00 2001 From: Alastro-Kraken Date: Sun, 13 Feb 2022 19:59:17 +0200 Subject: DB/Quest: fix emotes for quest Easy Strider Living Closes #27761 (cherry picked from commit f33d692d366dc203539dbbcb054de79f14c5d4f6) --- .../world/master/2022_03_26_06_world_2022_02_13_02_world.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/master/2022_03_26_06_world_2022_02_13_02_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2022_03_26_06_world_2022_02_13_02_world.sql b/sql/updates/world/master/2022_03_26_06_world_2022_02_13_02_world.sql new file mode 100644 index 00000000000..347c67eb48e --- /dev/null +++ b/sql/updates/world/master/2022_03_26_06_world_2022_02_13_02_world.sql @@ -0,0 +1,8 @@ +-- +-- ALTER TABLE `quest_request_items` CHANGE `VerifiedBuild` `VerifiedBuild` INT(11) DEFAULT 0 NOT NULL; +-- ALTER TABLE `quest_details` CHANGE `VerifiedBuild` `VerifiedBuild` INT(11) DEFAULT 0 NOT NULL; +-- ALTER TABLE `quest_offer_reward` CHANGE `VerifiedBuild` `VerifiedBuild` INT(11) DEFAULT 0 NOT NULL; + +UPDATE `quest_request_items` SET `EmoteOnComplete`=0, `EmoteOnIncomplete`=0, `VerifiedBuild`=42083 WHERE `ID`=2178; +UPDATE `quest_details` SET `Emote1`=1, `VerifiedBuild`=42083 WHERE `ID`=2178; +UPDATE `quest_offer_reward` SET `Emote1`=5, `VerifiedBuild`=42083 WHERE `ID`=2178; -- cgit v1.2.3