aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/3.3.5/2019_09_26_00_world.sql20
1 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_09_26_00_world.sql b/sql/updates/world/3.3.5/2019_09_26_00_world.sql
new file mode 100644
index 00000000000..40f2fba904b
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_09_26_00_world.sql
@@ -0,0 +1,20 @@
+--
+UPDATE `item_template_locale` SET `Name` = REPLACE(`Name`,'├í','á') WHERE (locale='esES' OR locale='esMX');
+UPDATE `item_template_locale` SET `Name` = REPLACE(`Name`,'├║','ú') WHERE (locale='esES' OR locale='esMX');
+UPDATE `item_template_locale` SET `Name` = REPLACE(`Name`,'├¡','í') WHERE (locale='esES' OR locale='esMX');
+UPDATE `item_template_locale` SET `Name` = REPLACE(`Name`,'├│','ó') WHERE (locale='esES' OR locale='esMX');
+UPDATE `item_template_locale` SET `Name` = REPLACE(`Name`,'├®','é') WHERE (locale='esES' OR locale='esMX');
+UPDATE `item_template_locale` SET `Name` = REPLACE(`Name`,'├▒','ñ') WHERE (locale='esES' OR locale='esMX');
+UPDATE `item_template_locale` SET `Name` = REPLACE(`Name`,'├ô','Ó') WHERE (locale='esES' OR locale='esMX');
+UPDATE `item_template_locale` SET `Name` = REPLACE(`Name`,'├Ü','Ú') WHERE (locale='esES' OR locale='esMX');
+UPDATE `item_template_locale` SET `Name` = REPLACE(`Name`,'├ü','Á') WHERE (locale='esES' OR locale='esMX');
+
+UPDATE `item_template_locale` SET `Description` = REPLACE(`Description`,'├í','á') WHERE (locale='esES' OR locale='esMX');
+UPDATE `item_template_locale` SET `Description` = REPLACE(`Description`,'├║','ú') WHERE (locale='esES' OR locale='esMX');
+UPDATE `item_template_locale` SET `Description` = REPLACE(`Description`,'├¡','í') WHERE (locale='esES' OR locale='esMX');
+UPDATE `item_template_locale` SET `Description` = REPLACE(`Description`,'├│','ó') WHERE (locale='esES' OR locale='esMX');
+UPDATE `item_template_locale` SET `Description` = REPLACE(`Description`,'├®','é') WHERE (locale='esES' OR locale='esMX');
+UPDATE `item_template_locale` SET `Description` = REPLACE(`Description`,'├▒','ñ') WHERE (locale='esES' OR locale='esMX');
+UPDATE `item_template_locale` SET `Description` = REPLACE(`Description`,'├ô','Ó') WHERE (locale='esES' OR locale='esMX');
+UPDATE `item_template_locale` SET `Description` = REPLACE(`Description`,'├Ü','Ú') WHERE (locale='esES' OR locale='esMX');
+UPDATE `item_template_locale` SET `Description` = REPLACE(`Description`,'├ü','Á') WHERE (locale='esES' OR locale='esMX');