diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2019-09-26 11:27:41 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-09-26 11:27:41 +0200 |
| commit | df0b0c2494603d8821f73d30178fe0efafb2df1e (patch) | |
| tree | eb631732fd9d3dd69789f4524e87bfe82428fa57 | |
| parent | 746a1d89b34984f31ab66ef00e93a648dc42af5d (diff) | |
DB/World: Wrong characters in item_template_locale
By Jildor, closes #23821
| -rw-r--r-- | sql/updates/world/3.3.5/2019_09_26_00_world.sql | 20 |
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'); |