diff options
| author | Alastro-Kraken <Alastro-Kraken@users.noreply.github.com> | 2022-02-13 19:59:17 +0200 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2022-02-13 19:59:17 +0200 |
| commit | f33d692d366dc203539dbbcb054de79f14c5d4f6 (patch) | |
| tree | 5a7a63c606d6bd31b5cb191403d1ed94c39b0985 | |
| parent | 68920fabdf955bab043d95c7c181651ac9b192ad (diff) | |
DB/Quest: fix emotes for quest Easy Strider Living
Closes #27761
| -rw-r--r-- | sql/updates/world/3.3.5/2022_02_13_02_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2022_02_13_02_world.sql b/sql/updates/world/3.3.5/2022_02_13_02_world.sql new file mode 100644 index 00000000000..452eb014602 --- /dev/null +++ b/sql/updates/world/3.3.5/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; |