From c84354389e450a3d754e0a3fa20d35414cbaea6f Mon Sep 17 00:00:00 2001 From: Cerveciento Date: Wed, 23 Sep 2020 03:15:00 +0300 Subject: DB/Locales: Add missing esES & esMX POI locales Closes #25486 --- .../world/3.3.5/2020_09_23_03_world_335.sql | 42 ++++++++++++++++++++++ 1 file changed, 42 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_09_23_03_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2020_09_23_03_world_335.sql b/sql/updates/world/3.3.5/2020_09_23_03_world_335.sql new file mode 100644 index 00000000000..86abce288b9 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_09_23_03_world_335.sql @@ -0,0 +1,42 @@ +-- 447 Morganus +SET @ID := 447; +DELETE FROM `points_of_interest_locale` WHERE `ID` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES +(@ID, 'esES','Morganus', 0), +(@ID, 'esMX','Morganus', 0); +-- 448 Recuerdos de la Fiesta de la Cerveza +SET @ID := 448; +DELETE FROM `points_of_interest_locale` WHERE `ID` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES +(@ID, 'esES','Recuerdos de la Fiesta de la Cerveza', 0), +(@ID, 'esMX','Recuerdos de la Fiesta de la Cerveza', 0); +-- 449 Carrera de Carneros de la Fiesta de la Cerveza +SET @ID := 449; +DELETE FROM `points_of_interest_locale` WHERE `ID` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES +(@ID, 'esES','Carrera de Carneros de la Fiesta de la Cerveza', 0), +(@ID, 'esMX','Carrera de Carneros de la Fiesta de la Cerveza', 0); +-- 450 Club de la Cerveza del Mes, Forjaz +SET @ID := 450; +DELETE FROM `points_of_interest_locale` WHERE `ID` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES +(@ID, 'esES','Club de la Cerveza del Mes, Forjaz', 0), +(@ID, 'esMX','Club de la Cerveza del Mes, Forjaz', 0); +-- 451 Recuerdos de la Fiesta de la Cerveza Goblin +SET @ID := 451; +DELETE FROM `points_of_interest_locale` WHERE `ID` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES +(@ID, 'esES','Recuerdos de la Fiesta de la Cerveza Goblin', 0), +(@ID, 'esMX','Recuerdos de la Fiesta de la Cerveza Goblin', 0); +-- 452 Carrera de Carneros de la Fiesta de la Cerveza Goblin +SET @ID := 452; +DELETE FROM `points_of_interest_locale` WHERE `ID` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES +(@ID, 'esES','Carrera de Carneros de la Fiesta de la Cerveza Goblin', 0), +(@ID, 'esMX','Carrera de Carneros de la Fiesta de la Cerveza Goblin', 0); +-- 453 Club de la Cerveza del Mes, Orgrimmar +SET @ID := 453; +DELETE FROM `points_of_interest_locale` WHERE `ID` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES +(@ID, 'esES','Club de la Cerveza del Mes, Orgrimmar', 0), +(@ID, 'esMX','Club de la Cerveza del Mes, Orgrimmar', 0); -- cgit v1.2.3