DB/Locale: Add missing item_template_locale texts for zhCN/zhTW

Closes #27362

1 files changed, 47 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2021_12_06_03_world_335.sql b/sql/updates/world/3.3.5/2021_12_06_03_world_335.sql
new file mode 100644
index 00000000000..6d2b832f977
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_12_06_03_world_335.sql
@@ -0,0 +1,47 @@
+--
+DELETE FROM `item_template_locale` WHERE `locale` IN ('zhTW','zhCN') AND `ID` IN (886,2021,13065,15068,15069,15070,15071,15072,15074,15075,20819,20822,20953,20956,22095,22096,22097,22098,22099,22100,22101,22102);
+INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`, `Description`, `VerifiedBuild`) VALUES 
+(886, 'zhTW', '黑色金屬短劍', '', 0),
+(886, 'zhCN', '黑色金属短剑', '', 0),
+(2021, 'zhTW', '綠殼盾', '', 0),
+(2021, 'zhCN', '绿壳盾', '', 0),
+(13065, 'zhTW', '奧利斯塔的魔杖', '', 0),
+(13065, 'zhCN', '奥利斯塔的魔杖', '', 0),
+(15068, 'zhTW', '霜刃外套', '', 0),
+(15068, 'zhCN', '霜刃外套', '', 0),
+(15069, 'zhTW', '霜刃護腿', '', 0),
+(15069, 'zhCN', '霜刃护腿', '', 0),
+(15070, 'zhTW', '霜刃手套', '', 0),
+(15070, 'zhCN', '霜刃手套', '', 0),
+(15071, 'zhTW', '霜刃長靴', '', 0),
+(15071, 'zhCN', '霜刃长靴', '', 0),
+(15072, 'zhTW', '奇美拉護腿', '', 0),
+(15072, 'zhCN', '奇美拉护腿', '', 0),
+(15074, 'zhTW', '奇美拉手套', '', 0),
+(15074, 'zhCN', '奇美拉手套', '', 0),
+(15075, 'zhTW', '奇美拉外衣', '', 0),
+(15075, 'zhCN', '奇美拉外衣', '', 0),
+(20819, 'zhTW', '切割过的孔雀石', '', 0),
+(20819, 'zhCN', '切割過的孔雀石', '', 0),
+(20822, 'zhTW', '切割過的虎眼石', '', 0),
+(20822, 'zhCN', '切割过的虎眼石', '', 0),
+(20953, 'zhTW', '切割過的碧玉', '', 0),
+(20953, 'zhCN', '切割过的翡翠', '', 0),
+(20956, 'zhTW', '邪惡玫瑰墜飾', '', 0),
+(20956, 'zhCN', '银玫瑰坠饰', '', 0),
+(22095, 'zhTW', '五雷束腕', '', 0),
+(22095, 'zhCN', '五雷护腕', '', 0),
+(22096, 'zhTW', '五雷之靴', '', 0),
+(22096, 'zhCN', '五雷长靴', '', 0),
+(22097, 'zhTW', '五雷罩盔', '', 0),
+(22097, 'zhCN', '五雷罩帽', '', 0),
+(22098, 'zhTW', '五雷之索', '', 0),
+(22098, 'zhCN', '五雷腰带', '', 0),
+(22099, 'zhTW', '五雷護手', '', 0),
+(22099, 'zhCN', '五雷护手', '', 0),
+(22100, 'zhTW', '五雷褶裙', '', 0),
+(22100, 'zhCN', '五雷褶裙', '', 0),
+(22101, 'zhTW', '五雷肩鎧', '', 0),
+(22101, 'zhCN', '五雷肩甲', '', 0),
+(22102, 'zhTW', '五雷外衣', '', 0),
+(22102, 'zhCN', '五雷外套', '', 0);