DB/Quest: Hallow's End quest ObjectiveText, BroadcastText deDE locales

Closes #22692

1 files changed, 60 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2018_10_20_19_world_335.sql b/sql/updates/world/3.3.5/2018_10_20_19_world_335.sql
new file mode 100644
index 00000000000..f55fb5cce2a
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_10_20_19_world_335.sql
@@ -0,0 +1,60 @@
+-- Hallow's End -- Schlotternächte
+-- ObjectiveText -- BroadcastText -- 3.3.5
+
+-- 1657 - Die Verpestung von Süderstade
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Werft die Stinkbombe in Süderstade ab", `VerifiedBuild`=18019 WHERE `ID` = 1657 AND `locale` = "deDE";
+
+-- 8353 - Hühnchengegacker für ein Pfefferminzbonbon
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Gackert für Gastwirt Feuerbräu wie ein Huhn", `VerifiedBuild`=18019 WHERE `ID` = 8353 AND `locale` = "deDE";
+
+-- 8354 - Hühnchengegacker für ein Pfefferminzbonbon
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Gackert für Gastwirt Feuerbräu wie ein Huhn", `VerifiedBuild`=18019 WHERE `ID` = 8354 AND `locale` = "deDE";
+
+-- 8355 - Kaugummikugelexpress
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Spielt einen \"Zug\" für Talvash", `VerifiedBuild`=18019 WHERE `ID` = 8355 AND `locale` = "deDE";
+
+-- 8356 - Muskelspiel für Nugat
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Gebt für Gastwirtin Gryshka mit Euren Muskeln an", `VerifiedBuild`=18019 WHERE `ID` = 8356 AND `locale` = "deDE";
+
+-- 8357 - Tanzen für Marzipan
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Tanzt für Gastwirtin Saelienne", `VerifiedBuild`=18019 WHERE `ID` = 8357 AND `locale` = "deDE";
+
+-- 8358 - Kaugummikugelexpress
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Spielt einen \"Zug\" für Talvash", `VerifiedBuild`=18019 WHERE `ID` = 8358 AND `locale` = "deDE";
+
+-- 8359 - Muskelspiel für Nugat
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Gebt für Gastwirtin Gryshka mit Euren Muskeln an", `VerifiedBuild`=18019 WHERE `ID` = 8359 AND `locale` = "deDE";
+
+-- 8360 - Tanzen für Marzipan
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Tanzt für Gastwirtin Pala", `VerifiedBuild`=18019 WHERE `ID` = 8360 AND `locale` = "deDE";
+
+-- 11360 - Übung bei der Brandwache
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Löscht das Feuer", `VerifiedBuild`=18019 WHERE `ID` = 11360 AND `locale` = "deDE";
+
+-- 11361 - Feuerübung
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Löscht das Feuer", `VerifiedBuild`=18019 WHERE `ID` = 11361 AND `locale` = "deDE";
+
+-- 11439 - Übung bei der Brandwache
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Löscht das Feuer", `VerifiedBuild`=18019 WHERE `ID` = 11439 AND `locale` = "deDE";
+
+-- 11440 - Übung bei der Brandwache
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Löscht das Feuer", `VerifiedBuild`=18019 WHERE `ID` = 11440 AND `locale` = "deDE";
+
+-- 11449 - Feuerübung
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Löscht das Feuer", `VerifiedBuild`=18019 WHERE `ID` = 11449 AND `locale` = "deDE";
+
+-- 11450 - Feuerübung
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Löscht das Feuer", `VerifiedBuild`=18019 WHERE `ID` = 11450 AND `locale` = "deDE";
+
+-- Ruft den kopflosen Reiter
+DELETE FROM `broadcast_text_locale` WHERE `ID` = 22695 AND `locale` = "deDE";
+INSERT INTO `broadcast_text_locale` (`ID`, `locale`, `MaleText`, `FemaleText`, `VerifiedBuild`) VALUES (22695, "deDE", "Erhebe dich, Reiter...", "Erhebe dich, Reiter...", 18019);
+
+DELETE FROM `broadcast_text_locale` WHERE `ID` = 22696 AND `locale` = "deDE";
+INSERT INTO `broadcast_text_locale` (`ID`, `locale`, `MaleText`, `FemaleText`, `VerifiedBuild`) VALUES (22696, "deDE", "Deine Zeit ist gekommen...", "Deine Zeit ist gekommen...", 18019);
+
+DELETE FROM `broadcast_text_locale` WHERE `ID` = 22720 AND `locale` = "deDE";
+INSERT INTO `broadcast_text_locale` (`ID`, `locale`, `MaleText`, `FemaleText`, `VerifiedBuild`) VALUES (22720, "deDE", "Heut' Nacht sei dein Leben...", "Heut' Nacht sei dein Leben...", 18019);
+
+DELETE FROM `broadcast_text_locale` WHERE `ID` = 22721 AND `locale` = "deDE";
+INSERT INTO `broadcast_text_locale` (`ID`, `locale`, `MaleText`, `FemaleText`, `VerifiedBuild`) VALUES (22721, "deDE", "Auf ewig genommen!", "Auf ewig genommen!", 18019);