aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/3.3.5/2018_10_20_16_world_335.sql101
1 files changed, 101 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_10_20_16_world_335.sql b/sql/updates/world/3.3.5/2018_10_20_16_world_335.sql
new file mode 100644
index 00000000000..2c09fd0834a
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_10_20_16_world_335.sql
@@ -0,0 +1,101 @@
+-- Hellfire Peninsula -- Höllenfeuerhalbinsel
+-- ObjectiveText -- 3.3.5
+
+-- 9427 - Reinigung des Wassers
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Aggonars Verderbnis entfernt", `VerifiedBuild`=26972 WHERE `ID` = 9427 AND `locale` = "deDE";
+
+-- 9447 - Salbe verabreichen
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Entkräftete Grunzer geheilt", `VerifiedBuild`=26972 WHERE `ID` = 9447 AND `locale` = "deDE";
+
+-- 9472 - Arelions Geliebte
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Carindas Rolle der Vergeltung benutzen", `VerifiedBuild`=26972 WHERE `ID` = 9472 AND `locale` = "deDE";
+
+-- 9545 - Das Relikt des Sehers
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Vision erhalten", `VerifiedBuild`=26972 WHERE `ID` = 9545 AND `locale` = "deDE";
+
+-- 10047 - Der Pfad des Ruhms
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Zertrampeltes Skelett reinigen", `VerifiedBuild`=26972 WHERE `ID` = 10047 AND `locale` = "deDE";
+
+-- 10078 - Die Unerwünschten zerstören
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Östlicher Klingenwerfer angezündet", `ObjectiveText2`="Zentralöstlicher Klingenwerfer angezündet", `ObjectiveText3`="Zentralwestlicher Klingenwerfer angezündet", `ObjectiveText4`="Westlicher Klingenwerfer angezündet", `VerifiedBuild`=26972 WHERE `ID` = 10078 AND `locale` = "deDE";
+
+-- 10087 - Zündet es an... für die Horde!
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Östliche Kanone angezündet", `ObjectiveText2`="Westliche Kanone angezündet", `VerifiedBuild`=26972 WHERE `ID` = 10087 AND `locale` = "deDE";
+
+-- 10106 - Höllenfeuerbefestigungen
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Nehmt den Rundblick ein", `ObjectiveText2`="Nehmt das Stadion ein", `ObjectiveText3`=" Nehmt die Trümmerbastion ein", `VerifiedBuild`=26972 WHERE `ID` = 10106 AND `locale` = "deDE";
+
+-- 10110 - Höllenfeuerbefestigungen
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Nehmt den Rundblick ein", `ObjectiveText2`="Nehmt das Stadion ein", `ObjectiveText3`=" Nehmt die Trümmerbastion ein", `VerifiedBuild`=26972 WHERE `ID` = 10110 AND `locale` = "deDE";
+
+-- 10129 - Mission: Tore Murketh und Shaadraz
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Tor Murketh zerstört", `ObjectiveText2`="Tor Shaadraz zerstört", `VerifiedBuild`=26972 WHERE `ID` = 10129 AND `locale` = "deDE";
+
+-- 10144 - Die Verstärkung abschneiden
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Portal Grimh unterbrochen", `ObjectiveText2`="Portal Kaalez unterbrochen", `VerifiedBuild`=26972 WHERE `ID` = 10144 AND `locale` = "deDE";
+
+-- 10146 - Mission: Tor Murketh und Tor Shaadraz
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Tor Murketh zerstört", `ObjectiveText2`="Tor Shaadraz zerstört", `VerifiedBuild`=26972 WHERE `ID` = 10146 AND `locale` = "deDE";
+
+-- 10162 - Mission: Die Abyssische Untiefe
+UPDATE `quest_template_locale` SET `ObjectiveText3`="Teufelskanone zerstört", `VerifiedBuild`=26972 WHERE `ID` = 10162 AND `locale` = "deDE";
+
+-- 10163 - Mission: Die Abyssische Untiefe
+UPDATE `quest_template_locale` SET `ObjectiveText3`="Teufelskanone zerstört", `VerifiedBuild`=26972 WHERE `ID` = 10163 AND `locale` = "deDE";
+
+-- 10208 - Die Verstärkung abschneiden
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Unterbrecht Portal Xilus", `ObjectiveText2`="Unterbrecht Portal Kruul", `VerifiedBuild`=26972 WHERE `ID` = 10208 AND `locale` = "deDE";
+
+-- 10238 - Wie man Goblins zubereitet
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Manni gerettet", `ObjectiveText2`="Moh gerettet", `ObjectiveText3`="Jakk gerettet", `VerifiedBuild`=26972 WHERE `ID` = 10238 AND `locale` = "deDE";
+
+-- 10255 - Das Gegengift testen
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Gegengift verabreicht", `VerifiedBuild`=26972 WHERE `ID` = 10255 AND `locale` = "deDE";
+
+-- 10346 - Rückkehr zur Abyssischen Untiefe
+UPDATE `quest_template_locale` SET `ObjectiveText3`="Teufelskanone zerstört", `VerifiedBuild`=26972 WHERE `ID` = 10346 AND `locale` = "deDE";
+
+-- 10347 - Rückkehr zur Abyssischen Untiefe
+UPDATE `quest_template_locale` SET `ObjectiveText3`="Teufelskanone zerstört", `VerifiedBuild`=26972 WHERE `ID` = 10347 AND `locale` = "deDE";
+
+-- 10351 - Natürliche Heilmittel
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Himmelssturzgrat wiederbelebt", `VerifiedBuild`=26972 WHERE `ID` = 10351 AND `locale` = "deDE";
+
+-- 10368 - Die Ältesten des Lumpenpacks
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Morod befreit", `ObjectiveText2`="Akoru befreit", `ObjectiveText3`="Aylaan befreit", `VerifiedBuild`=26972 WHERE `ID` = 10368 AND `locale` = "deDE";
+
+-- 10392 - Die Schwelle zum Abgrund
+UPDATE `quest_template_locale` SET `ObjectiveText2`="Tor der Brennenden Legion geschlossen", `VerifiedBuild`=26972 WHERE `ID` = 10392 AND `locale` = "deDE";
+
+-- 10397 - Invasionspunkt: Vernichter
+UPDATE `quest_template_locale` SET `ObjectiveText2`="Tor der Brennenden Legion geschlossen", `VerifiedBuild`=26972 WHERE `ID` = 10397 AND `locale` = "deDE";
+
+-- 10792 - Zeth'Gor muss brennen!
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Kaserne verbrannt", `ObjectiveText2`="Östliche Hütte verbrannt", `ObjectiveText3`="Westliche Hütte verbrannt", `ObjectiveText4`="Stall verbrannt", `VerifiedBuild`=26972 WHERE `ID` = 10792 AND `locale` = "deDE";
+
+-- 10813 - Die Augen von Grillok
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Auge von Grillok zurückgebracht", `VerifiedBuild`=26972 WHERE `ID` = 10813 AND `locale` = "deDE";
+
+-- 10864 - Eine Last auf der Seele
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Seelen der Zerschmetterten Hand geerntet", `VerifiedBuild`=26972 WHERE `ID` = 10864 AND `locale` = "deDE";
+
+-- 10895 - Zeth'Gor muss brennen!
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Nördlicher Turm markiert", `ObjectiveText2`="Südlicher Turm markiert", `ObjectiveText3`="Schmiedenturm markiert", `ObjectiveText4`="Hügelturm markiert", `VerifiedBuild`=26972 WHERE `ID` = 10895 AND `locale` = "deDE";
+
+-- 10909 - Höllengeister
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Jules gerächt", `VerifiedBuild`=26972 WHERE `ID` = 10909 AND `locale` = "deDE";
+
+-- 10935 - Der Exorzismus des Oberst Jules
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Oberst Jules gerettet", `VerifiedBuild`=26972 WHERE `ID` = 10935 AND `locale` = "deDE";
+
+-- 13408 - Höllenfeuerbefestigungen
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Nehmt den Rundblick ein", `ObjectiveText2`="Nehmt das Stadion ein", `ObjectiveText3`="Nehmt die Trümmerbastion ein", `VerifiedBuild`=26972 WHERE `ID` = 13408 AND `locale` = "deDE";
+
+-- 13409 - Höllenfeuerbefestigungen
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Nehmt den Rundblick ein", `ObjectiveText2`="Nehmt das Stadion ein", `ObjectiveText3`="Nehmt die Trümmerbastion ein", `VerifiedBuild`=26972 WHERE `ID` = 13409 AND `locale` = "deDE";
+
+-- 13410 - Höllenfeuerbefestigungen
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Nehmt den Rundblick ein", `ObjectiveText2`="Nehmt das Stadion ein", `ObjectiveText3`="Nehmt die Trümmerbastion ein", `VerifiedBuild`=26972 WHERE `ID` = 13410 AND `locale` = "deDE";
+
+-- 13411 - Höllenfeuerbefestigungen
+UPDATE `quest_template_locale` SET `ObjectiveText1`="Nehmt den Rundblick ein", `ObjectiveText2`="Nehmt das Stadion ein", `ObjectiveText3`="Nehmt die Trümmerbastion ein", `VerifiedBuild`=26972 WHERE `ID` = 13411 AND `locale` = "deDE";