DB/Locales: Correct a few gameobject names

Closes #13049

1 files changed, 51 insertions, 0 deletions

diff --git a/sql/updates/world/2014_09_06_06_world_locales_gameobject.sql b/sql/updates/world/2014_09_06_06_world_locales_gameobject.sql
new file mode 100644
index 00000000000..b749c999434
--- /dev/null
+++ b/sql/updates/world/2014_09_06_06_world_locales_gameobject.sql
@@ -0,0 +1,51 @@
+SET NAMES 'UTF8';
+
+UPDATE `locales_gameobject` SET `name_loc2` = "Disparu : caporal Keeshan", `name_loc3` = "Vermisst: Korporal Keeshan ", `name_loc6` = "Desaparecido: Cabo Keeshan ", `name_loc8` = "Пропавший без вести: капрал Кеешан" WHERE `entry` = 1726; -- old - fr: Disparu !; de: Vermisst:; es: ¡Desaparecido!; ru: Пропали без вести!
+UPDATE `locales_gameobject` SET `name_loc2` = "Botte de plantes ", `name_loc3` = "Pflanzenbündel ", `name_loc6` = "Paquete de plantas ", `name_loc8` = "Пучок трав" WHERE `entry` = 17282; -- old - fr: Cheveux de Bathran ; de: Bathranshaar ; es: Cabello de Bathran; ru: Батранов волос
+UPDATE `locales_gameobject` SET `name_loc2` = "Hivernale", `name_loc3` = "Winterbiss ", `name_loc6` = "Invernalia ", `name_loc8` = "Морозник" WHERE `entry` = 2044; -- old - fr: Dents de dragon; de: Drachenzahn; es: Dientes de dragón ; ru: Драконьи зубы 
+UPDATE `locales_gameobject` SET `name_loc2` = "Avis de recherche : Lieutenant Tripecroc ", `name_loc3` = "GESUCHT: Leutnant Fangor ", `name_loc6` = "Se busca: Teniente Fangore ", `name_loc8` = "Разыскивается: лейтенант Фангор " WHERE `entry` = 47; -- old - fr: Avis de recherche !; de: GESUCHT: ; es: ¡Se busca!; ru: Розыск! 
+UPDATE `locales_gameobject` SET `name_loc2` = "Cartographie ", `name_loc3` = "Kartografie", `name_loc6` = "Cartografía", `name_loc8` = "Картография " WHERE `entry` = 58626; -- old - fr: Archéologie; de: Archäologie; es: Arqueología ; ru: Археология
+UPDATE `locales_gameobject` SET `name_loc2` = "Tastebière-cadeau de la fête des Brasseurs ", `name_loc3` = "Freibierkrug des Braufests ", `name_loc6` = "Jarra de degustación de la Fiesta de la cerveza de obsequio", `name_loc8` = "Бесплатное пиво Хмельного фестиваля " WHERE `entry` = 186189; -- old - fr: Tastebière sans alcool de la fête des Brasseurs; de: Krug alkoholfreies Braufestbier; es: Jarra de degustación de la Fiesta de la Cerveza sin alcohol ; ru: Безалкогольный пробный напиток Хмельного фестиваля
+UPDATE `locales_gameobject` SET `name_loc2` = "Cage de Kraz ", `name_loc3` = "Kraz' Käfig", `name_loc6` = "Jaula de Kraz", `name_loc8` = "Клетка Краза" WHERE `entry` = 187379; -- old - fr: Cage de Norkani; de: Norkanis Käfig ; es: Jaula de Norkani; ru: Клетка Норкани
+UPDATE `locales_gameobject` SET `name_loc2` = "Cage de Harkor ", `name_loc3` = "Harkors Käfig", `name_loc6` = "Jaula de Harkor", `name_loc8` = "Клетка Харкора" WHERE `entry` = 187378; -- old - fr: Cage de Bakkalzu ; de: Bakkalzus Käfig; es: Jaula de Bakkalzu ; ru: Клетка Баккальзу
+UPDATE `locales_gameobject` SET `name_loc2` = "Paquet de Kraz ", `name_loc3` = "Krazs Päckchen ", `name_loc6` = "Paquete de Kraz", `name_loc8` = "Тюк Краза " WHERE `entry` = 186667; -- old - fr: Paquet de Norkani; de: Norkanis Päckchen; es: Paquete de Norkani; ru: Тюк Норкани 
+UPDATE `locales_gameobject` SET `name_loc2` = "Coffre de Kraz ", `name_loc3` = "Krazs Truhe", `name_loc6` = "Cofre de Kraz", `name_loc8` = "Сундук Краза" WHERE `entry` = 186658; -- old - fr: Coffre de Norkani; de: Norkanis Truhe ; es: Cofre de Norkani; ru: Сундук Норкани
+UPDATE `locales_gameobject` SET `name_loc2` = "Guilde des mineurs de la montagne profonde ", `name_loc3` = "Tiefenbergbaugilde ", `name_loc6` = "Gremio de minería de Montañahonda", `name_loc8` = "Гильдия горняков Тайной Горы" WHERE `entry` = 143344; -- old - fr: Minage & joaillerie de la Montagne profonde; de: Tiefenberg Bergbau & Juwelierskunst; es: Minería y joyería de Montehondo ; ru: Гильдия рудокопов и ювелиров Темной Горы
+UPDATE `locales_gameobject` SET `name_loc2` = "Vase d'Ashli ", `name_loc3` = "Ashlis Vase", `name_loc6` = "Jarrón de Ashli", `name_loc8` = "Ваза Эшли " WHERE `entry` = 186671; -- old - fr: Vase de Kasha; de: Kashas Vase; es: Jarrón de Kasha ; ru: Ваза Кайши
+UPDATE `locales_gameobject` SET `name_loc2` = "Cage d'Ashli ", `name_loc3` = "Ashlis Käfig ", `name_loc6` = "Jaula de Ashli ", `name_loc8` = "Клетка Эшли " WHERE `entry` = 187380; -- old - fr: Cage de Kasha; de: Kashas Käfig ; es: Jaula de Kasha; ru: Клетка Кайши
+UPDATE `locales_gameobject` SET `name_loc2` = "Sac d'Ashli", `name_loc3` = "Ashlis Tasche", `name_loc6` = "Bolsa de Ashli ", `name_loc8` = "Сумка Эшли" WHERE `entry` = 186672; -- old - fr: Sac de Kasha ; de: Kashas Tasche; es: Bolsa de Kasha; ru: Сумка Кайши 
+UPDATE `locales_gameobject` SET `name_loc2` = "Sacoche de Harkor", `name_loc3` = "Harkors Ranzen ", `name_loc6` = "Cartera de Harkor", `name_loc8` = "Сумка Харкора " WHERE `entry` = 187021; -- old - fr: Sacoche de Bakkalzu; de: Bakkalzus Ranzen ; es: Cartera de Bakkalzu ; ru: Сумка Баккальзу 
+UPDATE `locales_gameobject` SET `name_loc2` = "Malle de Tanzar", `name_loc3` = "Tanzars Koffer ", `name_loc6` = "Baúl de Tanzar ", `name_loc8` = "Сундучок Танзара" WHERE `entry` = 186648; -- old - fr: Malle d'Hazlek ; de: Hazleks Koffer ; es: Baúl de Hazlek; ru: Сундучок Хазлека
+UPDATE `locales_gameobject` SET `name_loc2` = "Cage de Tanzar ", `name_loc3` = "Tanzars Käfig", `name_loc6` = "Jaula de Tanzar", `name_loc8` = "Клетка Танзара" WHERE `entry` = 187377; -- old - fr: Cage d'Hazlek; de: Hazleks Käfig; es: Jaula de Hazlek ; ru: Клетка Хазлека
+UPDATE `locales_gameobject` SET `name_loc2` = "Forgeron de Baie-du-Butin", `name_loc3` = "Schmiede von Beutebucht", `name_loc6` = "Herrero de Bahía del Botín ", `name_loc8` = "Кузнец Пиратской Бухты" WHERE `entry` = 169967; -- old - fr: Forge; de: Schmied; es: Herrería; ru: Кузница 
+UPDATE `locales_gameobject` SET `name_loc2` = "Tonneau de bière de Harkor ", `name_loc3` = "Harkors Braufässchen ", `name_loc6` = "Barril de cerveza de Harkor", `name_loc8` = "Бочонок пива Харкора" WHERE `entry` = 186748; -- old - fr: Tonneau de bière de Bakkalzu ; de: Bakkalzus Braufässchen ; es: Barril de cerveza de Bakkalzu ; ru: Бочонок пива Баккальзу
+UPDATE `locales_gameobject` SET `name_loc2` = "Caisses de ravitaillement de la Croisée", `name_loc3` = "Vorratskisten des Wegekreuzes", `name_loc6` = "Cajones de suministros de El Cruce ", `name_loc8` = "Ящики с припасами для Перекрестка " WHERE `entry` = 175708; -- old - fr: Caisse de ravitaillement de la Croisée ; de: Vorratskiste des Wegekreuzes ; es: Cajón de suministros de El Cruce; ru: Ящик с припасами Перекрестка
+UPDATE `locales_gameobject` SET `name_loc2` = "Bannière de Karang ", `name_loc3` = "Karangs Banner ", `name_loc6` = "Estandarte de Karang ", `name_loc8` = "Знамя Каранга " WHERE `entry` = 178205; -- old - fr: Bannière de Senani ; de: Senanis Banner ; es: Estandarte de Senani; ru: Знамя Сенани
+UPDATE `locales_gameobject` SET `name_loc2` = "Fusée de feu d'artifice, Promotion ", `name_loc3` = "Feuerwerksrakete, Aktion ", `name_loc6` = "Cohete de fuegos artificiales, promoción ", `name_loc8` = "Ракета фейерверка, продвижение" WHERE `entry` = 181886; -- old - fr: Fusée de feu d'artifice violet ; de: Lila Feuerwerksrakete; es: Cohete de fuegos artificiales morado; ru: Лиловая ракета фейерверка 
+UPDATE `locales_gameobject` SET `name_loc2` = "Bois contaminé ", `name_loc3` = "Besudeltes Holz", `name_loc6` = "Madera mácula", `name_loc8` = "Гнилое дерево " WHERE `entry` = 181916; -- old - fr: Bois gangrené de Satyrnaar ; de: Verdorbenes Satyrnaarholz; es: Madera vil de Satyrnaar ; ru: Связка оскверненной древесины Сатирнаара
+UPDATE `locales_gameobject` SET `name_loc2` = "Bateau vers Auberdine", `name_loc3` = "Schiff nach Auberdine", `name_loc6` = "Barco a Auberdine", `name_loc8` = "Корабль в Аубердин" WHERE `entry` = 181985; -- old - fr: Bateau vers Rut'Theran ; de: Schiff nach Rut'Theran ; es: Barco a la Aldea Rut'theran ; ru: Корабль в деревню Рут'Теран 
+UPDATE `locales_gameobject` SET `name_loc2` = "Enchantement ", `name_loc3` = "Verzauberkunst ", `name_loc6` = "Encantamiento", `name_loc8` = "Наложение чар " WHERE `entry` = 183875; -- old - fr: Enchantement & Calligraphie; de: Verzauberkunst & Inschriftenkunde; es: Encantamiento e inscripción ; ru: Наложение чар и начертание
+UPDATE `locales_gameobject` SET `name_loc2` = "Flèche givrante I", `name_loc3` = "Eiskältepfeil I", `name_loc6` = "Flecha helada I", `name_loc8` = "Замораживающая стрела I " WHERE `entry` = 193771; -- old - fr: Piège givrant; de: Eiskältefalle; es: Trampa congelante ; ru: Замораживающая ловушка
+UPDATE `locales_gameobject` SET `name_loc2` = "Canon de l'Alliance", `name_loc3` = "Allianz Kannone", `name_loc6` = "Cañón de la alianza", `name_loc8` = "Пушка Альянса " WHERE `entry` = 185122; -- old - fr: Ogres de la Masse-sanglante en grande conversation ; de: Sich unterhaltende Oger der Blutschläger ; es: Ogros de Machacasangre hablando ; ru: Беседующие огры из клана Кровавого Молота 
+UPDATE `locales_gameobject` SET `name_loc2` = "Tram ", `name_loc3` = "U-Bahn ", `name_loc6` = "Tranvía Subterráneo", `name_loc8` = "Подземка" WHERE `entry` = 176086; -- old - fr: Cuirasse couverte de runes inachevée ; de: Ungeschmiedete runenbedeckte Brustplatte ; es: Coraza cubierta de runas sin forjar ; ru: Заготовка рунической кирасы 
+UPDATE `locales_gameobject` SET `name_loc2` = "Fleur de peste ", `name_loc3` = "Pestblüte", `name_loc6` = "Flor de peste", `name_loc8` = "Чумоцвет" WHERE `entry` = 176641; -- old - fr: Chagrinelle; de: Trauermoos ; es: Musgopena ; ru: Печаль-трава
+ 
+UPDATE `locales_gameobject` SET `name_loc2` = "La Lune la Vallée", `name_loc3` = "Mond über dem Tal", `name_loc8` = "Луна над долиной" WHERE `entry` = 57; -- old - fr: Tablette de savoir scalp-rouge ; de: Schrifttafel der Blutskalpe; ru: Легенды и предания племени Кровавого Скальпа
+UPDATE `locales_gameobject` SET `name_loc2` = "Fleur de peste", `name_loc3` = "Pestblüte", `name_loc8` = "Чумоцвет" WHERE `entry` = 176587; -- old - fr: Chagrinelle; de: Trauermoos ; ru: Печаль-трава
+UPDATE `locales_gameobject` SET `name_loc2` = "Bannière elfe de sang", `name_loc6` = "Estandarte de los elfos de sangre", `name_loc8` = "Знамя эльфов крови" WHERE `entry` = 185106; -- old - fr: PVP HOLIDAY (H) EotS ; es: PVP HOLIDAY (H) EotS; ru: PVP HOLIDAY (H) EotS
+UPDATE `locales_gameobject` SET `name_loc2` = "Boulet et chaîne de Knot", `name_loc6` = "Bola y cadena de Knot", `name_loc8` = "Шар и цепь Уззла" WHERE `entry` = 179511; -- old - fr: Boulet et chaîne de Noué ; es: Knot's Ball and Chain ; ru: Ядро на цепи Уззла
+UPDATE `locales_gameobject` SET `name_loc2` = "Drapeau chanteguerre", `name_loc6` = "Bandera Grito de Guerra", `name_loc8` = "Флаг Песни Войны" WHERE `entry` = 179786; -- old - fr: Drapeau de la Horde; es: Bandera de la Horda ; ru: Флаг Орды 
+UPDATE `locales_gameobject` SET `name_loc2` = "Drapeau d'Aile-argent", `name_loc6` = "Bandera Ala de Plata", `name_loc8` = "Флаг Серебряных Крыльев" WHERE `entry` = 179785; -- old - fr: Drapeau de l'Alliance; es: Bandera de la Alianza ; ru: Флаг Альянса
+UPDATE `locales_gameobject` SET `name_loc2` = "Drapeau d'Aile-argent", `name_loc6` = "Bandera Ala de Plata", `name_loc8` = "Флаг Серебряных Крыльев" WHERE `entry` = 179830; -- old - fr: Drapeau de l’Alliance; es: Bandera de la Alianza ; ru: Флаг Альянса
+UPDATE `locales_gameobject` SET `name_loc2` = "Drapeau chanteguerre", `name_loc6` = "Bandera Grito de Guerra", `name_loc8` = "Флаг Песни Войны" WHERE `entry` = 179831; -- old - fr: Drapeau de la Horde; es: Bandera de la Horda ; ru: Флаг Орды 
+UPDATE `locales_gameobject` SET `name_loc2` = "Brasero antique", `name_loc6` = "Blandón antiguo", `name_loc8` = "Древняя жаровня" WHERE `entry` = 20807; -- old - fr: [PÉRIMÉ]Brasero antique; es: [Deprecated for 4.x]Blandón antiguo ; ru: [Deprecated for 4.x]Ancient Brazier 
+UPDATE `locales_gameobject` SET `name_loc2` = "Décombres de chariot explosif", `name_loc6` = "Restos del coche cohete", `name_loc8` = "Обломки болида" WHERE `entry` = 19868; -- old - fr: [INUTILISÉ pour 4.x] Décombres de chariot explosif ; es: [Deprecated for 4.x]Restos del coche cohete ; ru: [Deprecated for 4.x]Rocket Car Rubble 
+UPDATE `locales_gameobject` SET `name_loc2` = "Décombres de chariot explosif", `name_loc6` = "Restos del coche cohete", `name_loc8` = "Обломки болида" WHERE `entry` = 19869; -- old - fr: [INUTILISÉ pour 4.x] Décombres de chariot explosif ; es: [Deprecated for 4.x]Restos del coche cohete ; ru: [Deprecated for 4.x]Rocket Car Rubble 
+UPDATE `locales_gameobject` SET `name_loc2` = "Décombres de chariot explosif", `name_loc6` = "Restos del coche cohete", `name_loc8` = "Обломки болида" WHERE `entry` = 19870; -- old - fr: [INUTILISÉ pour 4.x] Décombres de chariot explosif ; es: [Deprecated for 4.x]Restos del coche cohete ; ru: [Deprecated for 4.x]Rocket Car Rubble 
+UPDATE `locales_gameobject` SET `name_loc2` = "Décombres de chariot explosif", `name_loc6` = "Restos del coche cohete", `name_loc8` = "Обломки болида" WHERE `entry` = 19871; -- old - fr: [INUTILISÉ pour 4.x] Décombres de chariot explosif ; es: [Deprecated for 4.x]Restos del coche cohete ; ru: [Deprecated for 4.x]Rocket Car Rubble 
+UPDATE `locales_gameobject` SET `name_loc2` = "Décombres de chariot explosif", `name_loc6` = "Restos del coche cohete", `name_loc8` = "Обломки болида" WHERE `entry` = 19872; -- old - fr: [INUTILISÉ pour 4.x] Décombres de chariot explosif ; es: [Deprecated for 4.x]Restos del coche cohete ; ru: [Deprecated for 4.x]Rocket Car Rubble 
+UPDATE `locales_gameobject` SET `name_loc2` = "Décombres de chariot explosif", `name_loc6` = "Restos del coche cohete", `name_loc8` = "Обломки болида" WHERE `entry` = 19873; -- old - fr: [INUTILISÉ pour 4.x] Décombres de chariot explosif ; es: [Deprecated for 4.x]Restos del coche cohete ; ru: [Deprecated for 4.x]Rocket Car Rubble 
+UPDATE `locales_gameobject` SET `name_loc3` = "Bergbau", `name_loc6` = "Minería", `name_loc8` = "Горное дело" WHERE `entry` = 58620; -- old - de: Bergbau & Juwelierskunst ; es: Minería y joyería ; ru: Горное и ювелирное дело 
+UPDATE `locales_gameobject` SET `name_loc3` = "Auberdine Mondbrunnen", `name_loc6` = "Poza de la Luna de Auberdine", `name_loc8` = "Аубердин Лунный колодец" WHERE `entry` = 174795; -- old - de: Wachposten der Mondfederfeste; es: Puesto de vigilancia de Plumaluna ; ru: Застава Оперенной Луны
+UPDATE `locales_gameobject` SET `name_loc3` = "Axtrad", `name_loc6` = "Engranajes ligeros", `name_loc8` = "Инструмент топора" WHERE `entry` = 194577; -- old - de: Tür 02 ; es: Door 02 ; ru: Дверь 2 
+UPDATE `locales_gameobject` SET `name_loc2` = "Bibliothèque étrange", `name_loc3` = "Seltsamer Bücherschrank", `name_loc6` = "Estantería extraña" WHERE `entry` = 184453; -- old - fr: Bibliothèque énigmatiquede: Verblüffendes Bücherregal; es: Estantería desconcertante