aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/3.3.5/2021_07_23_00_world_335.sql419
1 files changed, 419 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_07_23_00_world_335.sql b/sql/updates/world/3.3.5/2021_07_23_00_world_335.sql
new file mode 100644
index 00000000000..a6b81e6d296
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_07_23_00_world_335.sql
@@ -0,0 +1,419 @@
+--
+DELETE FROM `gameobject_template_locale` WHERE `entry` IN (175591,164702,164703,164705,61953,175666,175667,176113,176885,176886,176887,176888,176889,176890,176891,176892,177290,177291,179682,186052,195641,1632,26489,142693,18084,190400,171757,171758,171759,171760,171761,171762,171763,22205,22207,22208,1753,1755,1896,2573,2650,19902,21630,21631,138317,141841,175678,179924,20873,20874,20875,20876);
+INSERT INTO `gameobject_template_locale` (`entry`, `locale`, `name`, `castBarCaption`, `VerifiedBuild`) VALUES
+(175591,'deDE','Loderndes Feuer','',0),
+(175591,'esES','Fuego llameante','',0),
+(175591,'esMX','Fuego llameante','',0),
+(175591,'frFR','Feu ardent','',0),
+(175591,'koKR','활활타는 화롯불','',0),
+(175591,'ruRU','Яркий костер','',0),
+(175591,'zhCN','炽热的火焰','',0),
+(175591,'zhTW','熾熱的火焰','',0),
+(164702,'deDE','Loderndes Feuer','',0),
+(164702,'esES','Fuego llameante','',0),
+(164702,'esMX','Fuego llameante','',0),
+(164702,'frFR','Feu ardent','',0),
+(164702,'koKR','활활타는 화롯불','',0),
+(164702,'ruRU','Яркий костер','',0),
+(164702,'zhCN','炽热的火焰','',0),
+(164702,'zhTW','熾熱的火焰','',0),
+(164703,'deDE','Loderndes Feuer','',0),
+(164703,'esES','Fuego llameante','',0),
+(164703,'esMX','Fuego llameante','',0),
+(164703,'frFR','Feu ardent','',0),
+(164703,'koKR','활활타는 화롯불','',0),
+(164703,'ruRU','Яркий костер','',0),
+(164703,'zhCN','炽热的火焰','',0),
+(164703,'zhTW','熾熱的火焰','',0),
+(164705,'deDE','Loderndes Feuer','',0),
+(164705,'esES','Fuego llameante','',0),
+(164705,'esMX','Fuego llameante','',0),
+(164705,'frFR','Feu ardent','',0),
+(164705,'koKR','활활타는 화롯불','',0),
+(164705,'ruRU','Яркий костер','',0),
+(164705,'zhCN','炽热的火焰','',0),
+(164705,'zhTW','熾熱的火焰','',0),
+(61953,'deDE','Kohlenpfanne','',0),
+(175666,'deDE','Kohlenpfanne','',0),
+(175667,'deDE','Kohlenpfanne','',0),
+(176113,'deDE','Kohlenpfanne','',0),
+(176885,'deDE','Kohlenpfanne','',0),
+(176886,'deDE','Kohlenpfanne','',0),
+(176887,'deDE','Kohlenpfanne','',0),
+(176888,'deDE','Kohlenpfanne','',0),
+(176889,'deDE','Kohlenpfanne','',0),
+(176890,'deDE','Kohlenpfanne','',0),
+(176891,'deDE','Kohlenpfanne','',0),
+(176892,'deDE','Kohlenpfanne','',0),
+(177290,'deDE','Kohlenpfanne','',0),
+(177291,'deDE','Kohlenpfanne','',0),
+(179682,'deDE','Kohlenpfanne','',0),
+(186052,'deDE','Kohlenpfanne','',0),
+(195641,'deDE','Kohlenpfanne','',0),
+(61953,'esES','Blandón','',0),
+(175666,'esES','Blandón','',0),
+(175667,'esES','Blandón','',0),
+(176113,'esES','Blandón','',0),
+(176885,'esES','Blandón','',0),
+(176886,'esES','Blandón','',0),
+(176887,'esES','Blandón','',0),
+(176888,'esES','Blandón','',0),
+(176889,'esES','Blandón','',0),
+(176890,'esES','Blandón','',0),
+(176891,'esES','Blandón','',0),
+(176892,'esES','Blandón','',0),
+(177290,'esES','Blandón','',0),
+(177291,'esES','Blandón','',0),
+(179682,'esES','Blandón','',0),
+(186052,'esES','Blandón','',0),
+(195641,'esES','Blandón','',0),
+(61953,'esMX','Blandón','',0),
+(175666,'esMX','Blandón','',0),
+(175667,'esMX','Blandón','',0),
+(176113,'esMX','Blandón','',0),
+(176885,'esMX','Blandón','',0),
+(176886,'esMX','Blandón','',0),
+(176887,'esMX','Blandón','',0),
+(176888,'esMX','Blandón','',0),
+(176889,'esMX','Blandón','',0),
+(176890,'esMX','Blandón','',0),
+(176891,'esMX','Blandón','',0),
+(176892,'esMX','Blandón','',0),
+(177290,'esMX','Blandón','',0),
+(177291,'esMX','Blandón','',0),
+(179682,'esMX','Blandón','',0),
+(186052,'esMX','Blandón','',0),
+(195641,'esMX','Blandón','',0),
+(61953,'frFR','Brasero','',0),
+(175666,'frFR','Brasero','',0),
+(175667,'frFR','Brasero','',0),
+(176113,'frFR','Brasero','',0),
+(176885,'frFR','Brasero','',0),
+(176886,'frFR','Brasero','',0),
+(176887,'frFR','Brasero','',0),
+(176888,'frFR','Brasero','',0),
+(176889,'frFR','Brasero','',0),
+(176890,'frFR','Brasero','',0),
+(176891,'frFR','Brasero','',0),
+(176892,'frFR','Brasero','',0),
+(177290,'frFR','Brasero','',0),
+(177291,'frFR','Brasero','',0),
+(179682,'frFR','Brasero','',0),
+(186052,'frFR','Brasero','',0),
+(195641,'frFR','Brasero','',0),
+(61953,'koKR','화로','',0),
+(175666,'koKR','화로','',0),
+(175667,'koKR','화로','',0),
+(176113,'koKR','화로','',0),
+(176885,'koKR','화로','',0),
+(176886,'koKR','화로','',0),
+(176887,'koKR','화로','',0),
+(176888,'koKR','화로','',0),
+(176889,'koKR','화로','',0),
+(176890,'koKR','화로','',0),
+(176891,'koKR','화로','',0),
+(176892,'koKR','화로','',0),
+(177290,'koKR','화로','',0),
+(177291,'koKR','화로','',0),
+(179682,'koKR','화로','',0),
+(186052,'koKR','화로','',0),
+(195641,'koKR','화로','',0),
+(61953,'ruRU','Жаровня','',0),
+(175666,'ruRU','Жаровня','',0),
+(175667,'ruRU','Жаровня','',0),
+(176113,'ruRU','Жаровня','',0),
+(176885,'ruRU','Жаровня','',0),
+(176886,'ruRU','Жаровня','',0),
+(176887,'ruRU','Жаровня','',0),
+(176888,'ruRU','Жаровня','',0),
+(176889,'ruRU','Жаровня','',0),
+(176890,'ruRU','Жаровня','',0),
+(176891,'ruRU','Жаровня','',0),
+(176892,'ruRU','Жаровня','',0),
+(177290,'ruRU','Жаровня','',0),
+(177291,'ruRU','Жаровня','',0),
+(179682,'ruRU','Жаровня','',0),
+(186052,'ruRU','Жаровня','',0),
+(195641,'ruRU','Жаровня','',0),
+(61953,'zhCN','火盆','',0),
+(175666,'zhCN','火盆','',0),
+(175667,'zhCN','火盆','',0),
+(176113,'zhCN','火盆','',0),
+(176885,'zhCN','火盆','',0),
+(176886,'zhCN','火盆','',0),
+(176887,'zhCN','火盆','',0),
+(176888,'zhCN','火盆','',0),
+(176889,'zhCN','火盆','',0),
+(176890,'zhCN','火盆','',0),
+(176891,'zhCN','火盆','',0),
+(176892,'zhCN','火盆','',0),
+(177290,'zhCN','火盆','',0),
+(177291,'zhCN','火盆','',0),
+(179682,'zhCN','火盆','',0),
+(186052,'zhCN','火盆','',0),
+(195641,'zhCN','火盆','',0),
+(61953,'zhTW','火盆','',0),
+(175666,'zhTW','火盆','',0),
+(175667,'zhTW','火盆','',0),
+(176113,'zhTW','火盆','',0),
+(176885,'zhTW','火盆','',0),
+(176886,'zhTW','火盆','',0),
+(176887,'zhTW','火盆','',0),
+(176888,'zhTW','火盆','',0),
+(176889,'zhTW','火盆','',0),
+(176890,'zhTW','火盆','',0),
+(176891,'zhTW','火盆','',0),
+(176892,'zhTW','火盆','',0),
+(177290,'zhTW','火盆','',0),
+(177291,'zhTW','火盆','',0),
+(179682,'zhTW','火盆','',0),
+(186052,'zhTW','火盆','',0),
+(195641,'zhTW','火盆','',0),
+(1632,'deDE','Brill','',0),
+(1632,'esES','Rémol','',0),
+(1632,'esMX','Rémol','',0),
+(1632,'frFR','Brill','',0),
+(1632,'koKR','브릴','',0),
+(1632,'ruRU','Брилл','',0),
+(1632,'zhCN','布瑞尔','',0),
+(1632,'zhTW','布瑞爾','',0),
+(26489,'deDE','Bruuks Ecke','',0),
+(26489,'esES','Rincón de Bruuk','',0),
+(26489,'esMX','Rincón de Bruuk','',0),
+(26489,'frFR','Chez Bruuk','',0),
+(26489,'koKR','브루크의 모퉁이 선술집','',0),
+(26489,'ruRU','Закоулок Бруука','',0),
+(26489,'zhCN','布鲁克小店','',0),
+(26489,'zhTW','布魯克小店','',0),
+(142693,'deDE','Blubbernder Kessel','',0),
+(142693,'esES','Caldera burbujeante','',0),
+(142693,'esMX','Caldera burbujeante','',0),
+(142693,'frFR','Chaudron bouillonnant','',0),
+(142693,'koKR','끓고 있는 가마솥','',0),
+(142693,'ruRU','Бурлящий котел','',0),
+(142693,'zhCN','冒泡的大锅','',0),
+(142693,'zhTW','冒泡的大鍋','',0),
+(18084,'deDE','Blubbernder Kessel','',0),
+(18084,'esES','Caldera burbujeante','',0),
+(18084,'esMX','Caldera burbujeante','',0),
+(18084,'frFR','Chaudron bouillonnant','',0),
+(18084,'koKR','끓고 있는 가마솥','',0),
+(18084,'ruRU','Бурлящий котел','',0),
+(18084,'zhCN','冒泡的大锅','',0),
+(18084,'zhTW','冒泡的大鍋','',0),
+(190400,'deDE','Brennende Wrackteile','',0),
+(190400,'esES','Restos ardiendo','',0),
+(190400,'esMX','Restos ardiendo','',0),
+(190400,'frFR','Débris en feu','',0),
+(190400,'koKR','불타는 잔해','',0),
+(190400,'ruRU','Горящие обломки','',0),
+(190400,'zhCN','燃烧的残骸','',0),
+(190400,'zhTW','燃燒的殘骸','',0),
+(171757,'deDE','Zwergenkohlenpfanne','',0),
+(171758,'deDE','Zwergenkohlenpfanne','',0),
+(171759,'deDE','Zwergenkohlenpfanne','',0),
+(171760,'deDE','Zwergenkohlenpfanne','',0),
+(171761,'deDE','Zwergenkohlenpfanne','',0),
+(171762,'deDE','Zwergenkohlenpfanne','',0),
+(171763,'deDE','Zwergenkohlenpfanne','',0),
+(171757,'esES','Blandón enano','',0),
+(171758,'esES','Blandón enano','',0),
+(171759,'esES','Blandón enano','',0),
+(171760,'esES','Blandón enano','',0),
+(171761,'esES','Blandón enano','',0),
+(171762,'esES','Blandón enano','',0),
+(171763,'esES','Blandón enano','',0),
+(171757,'esMX','Blandón enano','',0),
+(171758,'esMX','Blandón enano','',0),
+(171759,'esMX','Blandón enano','',0),
+(171760,'esMX','Blandón enano','',0),
+(171761,'esMX','Blandón enano','',0),
+(171762,'esMX','Blandón enano','',0),
+(171763,'esMX','Blandón enano','',0),
+(171757,'frFR','Brasero nain','',0),
+(171758,'frFR','Brasero nain','',0),
+(171759,'frFR','Brasero nain','',0),
+(171760,'frFR','Brasero nain','',0),
+(171761,'frFR','Brasero nain','',0),
+(171762,'frFR','Brasero nain','',0),
+(171763,'frFR','Brasero nain','',0),
+(171757,'koKR','드워프 화로','',0),
+(171758,'koKR','드워프 화로','',0),
+(171759,'koKR','드워프 화로','',0),
+(171760,'koKR','드워프 화로','',0),
+(171761,'koKR','드워프 화로','',0),
+(171762,'koKR','드워프 화로','',0),
+(171763,'koKR','드워프 화로','',0),
+(171757,'ruRU','Дворфийская жаровня','',0),
+(171758,'ruRU','Дворфийская жаровня','',0),
+(171759,'ruRU','Дворфийская жаровня','',0),
+(171760,'ruRU','Дворфийская жаровня','',0),
+(171761,'ruRU','Дворфийская жаровня','',0),
+(171762,'ruRU','Дворфийская жаровня','',0),
+(171763,'ruRU','Дворфийская жаровня','',0),
+(171757,'zhCN','矮人火盆','',0),
+(171758,'zhCN','矮人火盆','',0),
+(171759,'zhCN','矮人火盆','',0),
+(171760,'zhCN','矮人火盆','',0),
+(171761,'zhCN','矮人火盆','',0),
+(171762,'zhCN','矮人火盆','',0),
+(171763,'zhCN','矮人火盆','',0),
+(171757,'zhTW','矮人火盆','',0),
+(171758,'zhTW','矮人火盆','',0),
+(171759,'zhTW','矮人火盆','',0),
+(171760,'zhTW','矮人火盆','',0),
+(171761,'zhTW','矮人火盆','',0),
+(171762,'zhTW','矮人火盆','',0),
+(171763,'zhTW','矮人火盆','',0),
+(22205,'deDE','Zwergenfeuer','',0),
+(22205,'esES','Fuego enano','',0),
+(22205,'esMX','Fuego enano','',0),
+(22205,'frFR','Feu des nains','',0),
+(22205,'koKR','드워프 장작불','',0),
+(22205,'ruRU','Дворфийский огонь','',0),
+(22205,'zhCN','矮人篝火','',0),
+(22205,'zhTW','矮人營火','',0),
+(22207,'deDE','Zwergenfeuer','',0),
+(22207,'esES','Fuego enano','',0),
+(22207,'esMX','Fuego enano','',0),
+(22207,'frFR','Feu des nains','',0),
+(22207,'koKR','드워프 장작불','',0),
+(22207,'ruRU','Дворфийский огонь','',0),
+(22207,'zhCN','矮人篝火','',0),
+(22207,'zhTW','矮人營火','',0),
+(22208,'deDE','Zwergenfeuer','',0),
+(22208,'esES','Fuego enano','',0),
+(22208,'esMX','Fuego enano','',0),
+(22208,'frFR','Feu des nains','',0),
+(22208,'koKR','드워프 장작불','',0),
+(22208,'ruRU','Дворфийский огонь','',0),
+(22208,'zhCN','矮人篝火','',0),
+(22208,'zhTW','矮人營火','',0),
+(1753,'deDE','Schmiede','',0),
+(1755,'deDE','Schmiede','',0),
+(1896,'deDE','Schmiede','',0),
+(2573,'deDE','Schmiede','',0),
+(2650,'deDE','Schmiede','',0),
+(19902,'deDE','Schmiede','',0),
+(21630,'deDE','Schmiede','',0),
+(21631,'deDE','Schmiede','',0),
+(138317,'deDE','Schmiede','',0),
+(141841,'deDE','Schmiede','',0),
+(175678,'deDE','Schmiede','',0),
+(179924,'deDE','Schmiede','',0),
+(1753,'esES','Forja','',0),
+(1755,'esES','Forja','',0),
+(1896,'esES','Forja','',0),
+(2573,'esES','Forja','',0),
+(2650,'esES','Forja','',0),
+(19902,'esES','Forja','',0),
+(21630,'esES','Forja','',0),
+(21631,'esES','Forja','',0),
+(138317,'esES','Forja','',0),
+(141841,'esES','Forja','',0),
+(175678,'esES','Forja','',0),
+(179924,'esES','Forja','',0),
+(1753,'esMX','Forja','',0),
+(1755,'esMX','Forja','',0),
+(1896,'esMX','Forja','',0),
+(2573,'esMX','Forja','',0),
+(2650,'esMX','Forja','',0),
+(19902,'esMX','Forja','',0),
+(21630,'esMX','Forja','',0),
+(21631,'esMX','Forja','',0),
+(138317,'esMX','Forja','',0),
+(141841,'esMX','Forja','',0),
+(175678,'esMX','Forja','',0),
+(179924,'esMX','Forja','',0),
+(1753,'frFR','Forge','',0),
+(1755,'frFR','Forge','',0),
+(1896,'frFR','Forge','',0),
+(2573,'frFR','Forge','',0),
+(2650,'frFR','Forge','',0),
+(19902,'frFR','Forge','',0),
+(21630,'frFR','Forge','',0),
+(21631,'frFR','Forge','',0),
+(138317,'frFR','Forge','',0),
+(141841,'frFR','Forge','',0),
+(175678,'frFR','Forge','',0),
+(179924,'frFR','Forge','',0),
+(1753,'koKR','가열로','',0),
+(1755,'koKR','가열로','',0),
+(1896,'koKR','가열로','',0),
+(2573,'koKR','가열로','',0),
+(2650,'koKR','가열로','',0),
+(19902,'koKR','가열로','',0),
+(21630,'koKR','가열로','',0),
+(21631,'koKR','가열로','',0),
+(138317,'koKR','가열로','',0),
+(141841,'koKR','가열로','',0),
+(175678,'koKR','가열로','',0),
+(179924,'koKR','가열로','',0),
+(1753,'ruRU','Горн','',0),
+(1755,'ruRU','Горн','',0),
+(1896,'ruRU','Горн','',0),
+(2573,'ruRU','Горн','',0),
+(2650,'ruRU','Горн','',0),
+(19902,'ruRU','Горн','',0),
+(21630,'ruRU','Горн','',0),
+(21631,'ruRU','Горн','',0),
+(138317,'ruRU','Горн','',0),
+(141841,'ruRU','Горн','',0),
+(175678,'ruRU','Горн','',0),
+(179924,'ruRU','Горн','',0),
+(1753,'zhCN','熔炉','',0),
+(1755,'zhCN','熔炉','',0),
+(1896,'zhCN','熔炉','',0),
+(2573,'zhCN','熔炉','',0),
+(2650,'zhCN','熔炉','',0),
+(19902,'zhCN','熔炉','',0),
+(21630,'zhCN','熔炉','',0),
+(21631,'zhCN','熔炉','',0),
+(138317,'zhCN','熔炉','',0),
+(141841,'zhCN','熔炉','',0),
+(175678,'zhCN','熔炉','',0),
+(179924,'zhCN','熔炉','',0),
+(1753,'zhTW','熔爐','',0),
+(1755,'zhTW','熔爐','',0),
+(1896,'zhTW','熔爐','',0),
+(2573,'zhTW','熔爐','',0),
+(2650,'zhTW','熔爐','',0),
+(19902,'zhTW','熔爐','',0),
+(21630,'zhTW','熔爐','',0),
+(21631,'zhTW','熔爐','',0),
+(138317,'zhTW','熔爐','',0),
+(141841,'zhTW','熔爐','',0),
+(175678,'zhTW','熔爐','',0),
+(179924,'zhTW','熔爐','',0),
+(20873,'deDE','Schwelende Kohlenpfanne','',0),
+(20873,'esES','Blandón humeante','',0),
+(20873,'esMX','Blandón humeante','',0),
+(20873,'frFR','Brasero fumant','',0),
+(20873,'koKR','이글거리는 화로','',0),
+(20873,'ruRU','Тлеющая жаровня','',0),
+(20873,'zhCN','冒烟的火盆','',0),
+(20873,'zhTW','悶燒的火盆','',0),
+(20874,'deDE','Schwelende Kohlenpfanne','',0),
+(20874,'esES','Blandón humeante','',0),
+(20874,'esMX','Blandón humeante','',0),
+(20874,'frFR','Brasero fumant','',0),
+(20874,'koKR','이글거리는 화로','',0),
+(20874,'ruRU','Тлеющая жаровня','',0),
+(20874,'zhCN','冒烟的火盆','',0),
+(20874,'zhTW','悶燒的火盆','',0),
+(20875,'deDE','Schwelende Kohlenpfanne','',0),
+(20875,'esES','Blandón humeante','',0),
+(20875,'esMX','Blandón humeante','',0),
+(20875,'frFR','Brasero fumant','',0),
+(20875,'koKR','이글거리는 화로','',0),
+(20875,'ruRU','Тлеющая жаровня','',0),
+(20875,'zhCN','冒烟的火盆','',0),
+(20875,'zhTW','悶燒的火盆','',0),
+(20876,'deDE','Schwelende Kohlenpfanne','',0),
+(20876,'esES','Blandón humeante','',0),
+(20876,'esMX','Blandón humeante','',0),
+(20876,'frFR','Brasero fumant','',0),
+(20876,'koKR','이글거리는 화로','',0),
+(20876,'ruRU','Тлеющая жаровня','',0),
+(20876,'zhCN','冒烟的火盆','',0),
+(20876,'zhTW','悶燒的火盆','',0);