diff options
| author | Alastro-Kraken <Alastro-Kraken@users.noreply.github.com> | 2022-02-13 19:59:17 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-26 14:18:23 +0100 |
| commit | bd6a3fc95396f01c342ee1fc4bfd813ff5866f26 (patch) | |
| tree | 5982b02b4b8053fab376fbc24d1c33c9f72f7162 | |
| parent | b4b84d6f320457f630dfe3cdb475814c3eabf942 (diff) | |
DB/Quest: fix emotes for quest Easy Strider Living
Closes #27761
(cherry picked from commit f33d692d366dc203539dbbcb054de79f14c5d4f6)
| -rw-r--r-- | sql/updates/world/master/2022_03_26_06_world_2022_02_13_02_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
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; |