From df0b0c2494603d8821f73d30178fe0efafb2df1e Mon Sep 17 00:00:00 2001 From: Aokromes Date: Thu, 26 Sep 2019 11:27:41 +0200 Subject: DB/World: Wrong characters in item_template_locale By Jildor, closes #23821 --- sql/updates/world/3.3.5/2019_09_26_00_world.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 sql/updates/world/3.3.5/2019_09_26_00_world.sql 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'); -- cgit v1.2.3