Trinitycore: [3.3.5] DB/Locale: Zul'jin has wrong locale name

[Jildor]

Description:

Boss: https://www.wowhead.com/npc=23863
On 3.3.5 should be Zul'jin

Maybe with >4.X sniff locale has wrong name on 3.3.5

SELECT * FROM `creature_template_locale` WHERE `entry`=23863;

```
entry locale Name Title VerifiedBuild

---

23863 deDE Daakara Der Unbesiegbare 18019
23863 esES Daakara El Invencible 18019
23863 esMX Daakara El Invencible 18019
23863 frFR Daakara L’Invincible 18019
23863 koKR 다카라 천하무적 18019
23863 ruRU Даакара Непобедимый 18019
23863 zhCN 达卡拉 战无不胜 18019
23863 zhTW 達卡拉 無敵 18019

Fix: (I'm sorry, I don't know how should be named on another languages)
```sql
UPDATE `creature_template_locale` SET `Name`='Zul\'jin',`Title`='' WHERE `entry`=23863 AND `locale` IN ('deDE','esES','esMX','frFR');

Branch(es):

3.3.5

TC rev. hash/commit:
9f3e6bfe9b76

TrinityCore rev. 9f3e6bfe9b76 2018-08-14 01:58:24 +0200 (3.3.5 branch) (Unix, Release, Static)
Using SSL version: OpenSSL 1.0.2l  25 May 2017 (library: OpenSSL 1.0.2l  25 May 2017)
Using Boost version: 1.62.0
Using MySQL version: 10.1.26-MariaDB
Using CMake version: 3.7.2
Compiled on: Linux 4.9.0-4-amd64
Automatic database updates are enabled for the following databases: Auth, Characters, World
Worldserver listening connections on port 8085
Realmlist (Realm Id: 1) configured in port 8085
VMAPs status: Enabled. LineOfSight: 1, getHeight: 1, indoorCheck: 1
MMAPs status: Enabled
maps directory located in /home/trinity/data/335/data/maps. Total size: 252191207 bytes
vmaps directory located in /home/trinity/data/335/data/vmaps. Total size: 588247501 bytes
mmaps directory located in /home/trinity/data/335/data/mmaps. Total size: 2152621156 bytes
Using esES DBC Locale as default. All available DBC locales: esES
Using World DB: TDB 335.64

[TrinityCoreBot]

This issue is not considered valid because of the following reasons:

• No proper commit hash (revision)

Please read http://bit.ly/tc-issuetracker-and-you and add the missing information to this issue. Thanks.

[offl]

``sql UPDATEcreature_template_localeSETTitle='' WHEREentry=23863; UPDATEcreature_template_localeSETName='Zul\'jin' WHEREentry=23863 ANDlocaleIN ('deDE','esES','esMX','frFR'); UPDATEcreature_template_localeSETName='줄진' WHEREentry=23863 ANDlocaleIN ('koKR'); UPDATEcreature_template_localeSETName='Зул\'джин' WHEREentry=23863 ANDlocaleIN ('ruRU'); UPDATEcreature_template_localeSETName='祖尔金' WHEREentry=23863 ANDlocaleIN ('zhCN'); UPDATEcreature_template_localeSETName='祖爾金' WHEREentry=23863 ANDlocale` IN ('zhTW');

[Shauren]

you should completely delete the rows if all fields are empty (chinese/korean)

[offl]

Only the title will be empty

[offl]

Only koKR + zhTW left

[Jildor]

I can't help there xD

[offl]

Ok, koKR + zhTW from

SELECT * FROM `broadcast_text_locale` WHERE `ID`=23587;

[illfated]

@offl : Thank you for providing the solution data! :-) 👍