From e41df9f84b4879134fbbd9ccb171dec9a689087e Mon Sep 17 00:00:00 2001 From: offl Date: Thu, 22 Jul 2021 17:48:53 +0300 Subject: DB/Locales: Add gameobject_template_locale.castBarCaption --- .../world/3.3.5/2021_07_22_00_world_335.sql | 34 ++++++++++++++++++++++ 1 file changed, 34 insertions(+) create mode 100644 sql/updates/world/3.3.5/2021_07_22_00_world_335.sql diff --git a/sql/updates/world/3.3.5/2021_07_22_00_world_335.sql b/sql/updates/world/3.3.5/2021_07_22_00_world_335.sql new file mode 100644 index 00000000000..c15c506af9f --- /dev/null +++ b/sql/updates/world/3.3.5/2021_07_22_00_world_335.sql @@ -0,0 +1,34 @@ +-- +UPDATE `gameobject_template_locale` a LEFT JOIN `gameobject_template` b ON a.`entry` = b.`entry` LEFT JOIN `broadcast_text_locale` c ON b.`Data4` = c.`ID` AND a.`locale` = c.`locale` SET a.`castBarCaption` = c.`Text` WHERE b.`castBarCaption` != '' AND b.`type` = 0 AND c.`Text` != ''; +UPDATE `gameobject_template_locale` a LEFT JOIN `gameobject_template` b ON a.`entry` = b.`entry` LEFT JOIN `broadcast_text_locale` c ON b.`Data6` = c.`ID` AND a.`locale` = c.`locale` SET a.`castBarCaption` = c.`Text` WHERE b.`castBarCaption` != '' AND b.`type` = 1 AND c.`Text` != ''; +UPDATE `gameobject_template_locale` a LEFT JOIN `gameobject_template` b ON a.`entry` = b.`entry` LEFT JOIN `broadcast_text_locale` c ON b.`Data6` = c.`ID` AND a.`locale` = c.`locale` SET a.`castBarCaption` = c.`Text` WHERE b.`castBarCaption` != '' AND b.`type` = 2 AND c.`Text` != ''; +UPDATE `gameobject_template_locale` a LEFT JOIN `gameobject_template` b ON a.`entry` = b.`entry` LEFT JOIN `broadcast_text_locale` c ON b.`Data14` = c.`ID` AND a.`locale` = c.`locale` SET a.`castBarCaption` = c.`Text` WHERE b.`castBarCaption` != '' AND b.`type` = 3 AND c.`Text` != ''; +UPDATE `gameobject_template_locale` a LEFT JOIN `gameobject_template` b ON a.`entry` = b.`entry` LEFT JOIN `broadcast_text_locale` c ON b.`Data12` = c.`ID` AND a.`locale` = c.`locale` SET a.`castBarCaption` = c.`Text` WHERE b.`castBarCaption` != '' AND b.`type` = 6 AND c.`Text` != ''; +UPDATE `gameobject_template_locale` a LEFT JOIN `gameobject_template` b ON a.`entry` = b.`entry` LEFT JOIN `broadcast_text_locale` c ON b.`Data14` = c.`ID` AND a.`locale` = c.`locale` SET a.`castBarCaption` = c.`Text` WHERE b.`castBarCaption` != '' AND b.`type` = 10 AND c.`Text` != ''; + +DELETE FROM `gameobject_template_locale` WHERE `entry` IN (176361,176393,177289); +INSERT INTO `gameobject_template_locale` (`entry`, `locale`, `name`, `castBarCaption`, `VerifiedBuild`) VALUES +(176361,'deDE','Geißelkessel','Einsammeln',0), +(176361,'esES','Caldera de la Plaga','Recoger',0), +(176361,'esMX','Caldera de la Plaga','Recoger',0), +(176361,'frFR','Chaudron du Fléau','Collecte',0), +(176361,'koKR','스컬지 가마솥','수집 중',0), +(176361,'ruRU','Котел Плети','Сбор',0), +(176361,'zhCN','天灾之锅','收集中',0), +(176361,'zhTW','天譴大鍋','收集中',0), +(176393,'deDE','Geißelkessel','Einsammeln',0), +(176393,'esES','Caldera de la Plaga','Recoger',0), +(176393,'esMX','Caldera de la Plaga','Recoger',0), +(176393,'frFR','Chaudron du Fléau','Collecte',0), +(176393,'koKR','스컬지 가마솥','수집 중',0), +(176393,'ruRU','Котел Плети','Сбор',0), +(176393,'zhCN','天灾之锅','收集中',0), +(176393,'zhTW','天譴大鍋','收集中',0), +(177289,'deDE','Geißelkessel','Einsammeln',0), +(177289,'esES','Caldera de la Plaga','Recoger',0), +(177289,'esMX','Caldera de la Plaga','Recoger',0), +(177289,'frFR','Chaudron du Fléau','Collecte',0), +(177289,'koKR','스컬지 가마솥','수집 중',0), +(177289,'ruRU','Котел Плети','Сбор',0), +(177289,'zhCN','天灾之锅','收集中',0), +(177289,'zhTW','天譴大鍋','收集中',0); -- cgit v1.2.3