diff options
| -rw-r--r-- | sql/updates/world/master/2022_08_09_08_world_dalaran.sql | 754 |
1 files changed, 754 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_08_09_08_world_dalaran.sql b/sql/updates/world/master/2022_08_09_08_world_dalaran.sql new file mode 100644 index 00000000000..ed07e1def1f --- /dev/null +++ b/sql/updates/world/master/2022_08_09_08_world_dalaran.sql @@ -0,0 +1,754 @@ +-- Guards (Dalaran) +UPDATE `creature_template` SET `gossip_menu_id`=10043 WHERE `entry` IN (32677, 32680, 32685, 32687, 32689, 32692); +UPDATE `creature_template` SET `gossip_menu_id`=10106 WHERE `entry` IN (32726, 32728, 32733); + +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32174, `ActionPoiID`=2169 WHERE `MenuID`=10043 AND `OptionID`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32167 WHERE `MenuID`=10043 AND `OptionID`=2; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=31340, `ActionPoiID`=2175 WHERE `MenuID`=10043 AND `OptionID`=3; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32197 WHERE `MenuID`=10043 AND `OptionID`=4; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45379, `ActionPoiID`=2294 WHERE `MenuID`=10043 AND `OptionID`=5; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32189, `ActionPoiID`=2180 WHERE `MenuID`=10043 AND `OptionID`=6; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32166, `ActionPoiID`=2187 WHERE `MenuID`=10043 AND `OptionID`=7; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2328 WHERE `MenuID`=10043 AND `OptionID`=8; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45381 WHERE `MenuID`=10043 AND `OptionID`=9; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45383, `ActionPoiID`=2296 WHERE `MenuID`=10043 AND `OptionID`=11; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32216 WHERE `MenuID`=10043 AND `OptionID`=13; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2191 WHERE `MenuID`=10057 AND `OptionID`=0; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2190 WHERE `MenuID`=10057 AND `OptionID`=1; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2287 WHERE `MenuID`=10057 AND `OptionID`=2; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2158 WHERE `MenuID`=10089 AND `OptionID`=0; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2159 WHERE `MenuID`=10089 AND `OptionID`=1; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2191 WHERE `MenuID`=10055 AND `OptionID`=0; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2190 WHERE `MenuID`=10055 AND `OptionID`=1; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2287 WHERE `MenuID`=10055 AND `OptionID`=2; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2195 WHERE `MenuID`=10058 AND `OptionID`=0; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2193 WHERE `MenuID`=10058 AND `OptionID`=1; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2196 WHERE `MenuID`=10084 AND `OptionID`=0; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2194 WHERE `MenuID`=10084 AND `OptionID`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32166, `ActionPoiID`=2187 WHERE `MenuID`=10090 AND `OptionID`=0; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2295 WHERE `MenuID`=10090 AND `OptionID`=2; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2195 WHERE `MenuID`=10056 AND `OptionID`=0; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2193 WHERE `MenuID`=10056 AND `OptionID`=1; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2161 WHERE `MenuID`=10056 AND `OptionID`=2; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2192 WHERE `MenuID`=10056 AND `OptionID`=3; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2293 WHERE `MenuID`=10056 AND `OptionID`=5; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2295 WHERE `MenuID`=10056 AND `OptionID`=6; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2174 WHERE `MenuID`=10056 AND `OptionID`=7; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2197 WHERE `MenuID`=10056 AND `OptionID`=8; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2288 WHERE `MenuID`=10056 AND `OptionID`=9; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2289 WHERE `MenuID`=10056 AND `OptionID`=10; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32202, `ActionPoiID`=2178 WHERE `MenuID`=10082 AND `OptionID`=0; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32202, `OptionType`=1, `OptionNpcFlag`=1, `ActionMenuID`=12654, `ActionPoiID`=2193 WHERE `MenuID`=10082 AND `OptionID`=2; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2295 WHERE `MenuID`=10082 AND `OptionID`=3; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2178 WHERE `MenuID`=10082 AND `OptionID`=4; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45382 WHERE `MenuID`=10082 AND `OptionID`=5; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45753, `ActionPoiID`=2172 WHERE `MenuID`=10078 AND `OptionID`=0; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2540 WHERE `MenuID`=10078 AND `OptionID`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45754, `ActionPoiID`=2171 WHERE `MenuID`=10078 AND `OptionID`=2; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45432, `ActionPoiID`=0 WHERE `MenuID`=10078 AND `OptionID`=3; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45755, `ActionPoiID`=2162 WHERE `MenuID`=10078 AND `OptionID`=4; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45756, `ActionPoiID`=2169 WHERE `MenuID`=10078 AND `OptionID`=5; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45765, `ActionPoiID`=2165 WHERE `MenuID`=10078 AND `OptionID`=6; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45436, `ActionPoiID`=2271 WHERE `MenuID`=10078 AND `OptionID`=7; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45434, `ActionPoiID`=2164 WHERE `MenuID`=10078 AND `OptionID`=8; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45757, `ActionPoiID`=2163 WHERE `MenuID`=10078 AND `OptionID`=9; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=44647, `ActionPoiID`=2173 WHERE `MenuID`=10078 AND `OptionID`=10; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45759, `ActionPoiID`=2168 WHERE `MenuID`=10078 AND `OptionID`=11; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45769, `ActionPoiID`=2170 WHERE `MenuID`=10078 AND `OptionID`=12; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45770, `ActionPoiID`=2167 WHERE `MenuID`=10078 AND `OptionID`=13; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45760, `ActionPoiID`=2166 WHERE `MenuID`=10078 AND `OptionID`=14; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2196 WHERE `MenuID`=10073 AND `OptionID`=0; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2194 WHERE `MenuID`=10073 AND `OptionID`=1; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2185 WHERE `MenuID`=10173 AND `OptionID`=1; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2198 WHERE `MenuID`=10173 AND `OptionID`=2; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2188 WHERE `MenuID`=10173 AND `OptionID`=3; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32712, `ActionPoiID`=2182 WHERE `MenuID`=10173 AND `OptionID`=4; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2173 WHERE `MenuID`=10173 AND `OptionID`=5; +UPDATE `gossip_menu_option` SET `ActionPoiID`=0 WHERE `MenuID`=10173 AND `OptionID`=6; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2177 WHERE `MenuID`=10173 AND `OptionID`=7; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2189 WHERE `MenuID`=10173 AND `OptionID`=8; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2291 WHERE `MenuID`=10173 AND `OptionID`=9; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2186 WHERE `MenuID`=10173 AND `OptionID`=10; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32719, `ActionPoiID`=2182 WHERE `MenuID`=10173 AND `OptionID`=11; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2297 WHERE `MenuID`=10173 AND `OptionID`=12; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2176 WHERE `MenuID`=10173 AND `OptionID`=14; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2185 WHERE `MenuID`=10170 AND `OptionID`=0; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2183 WHERE `MenuID`=10170 AND `OptionID`=1; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2183 WHERE `MenuID`=10170 AND `OptionID`=2; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2290 WHERE `MenuID`=10170 AND `OptionID`=3; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2290 WHERE `MenuID`=10170 AND `OptionID`=4; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2195 WHERE `MenuID`=10160 AND `OptionID`=0; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2193 WHERE `MenuID`=10160 AND `OptionID`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45382 WHERE `MenuID`=10153 AND `OptionID`=0; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2181 WHERE `MenuID`=10168 AND `OptionID`=0; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2179 WHERE `MenuID`=10168 AND `OptionID`=1; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2184 WHERE `MenuID`=10168 AND `OptionID`=2; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2285 WHERE `MenuID`=10106 AND `OptionID`=0; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32167, `ActionPoiID`=2282 WHERE `MenuID`=10106 AND `OptionID`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32166, `ActionPoiID`=2283 WHERE `MenuID`=10106 AND `OptionID`=2; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32216, `ActionPoiID`=2286 WHERE `MenuID`=10106 AND `OptionID`=4; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2191 WHERE `MenuID`=10105 AND `OptionID`=0; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2190 WHERE `MenuID`=10105 AND `OptionID`=1; +UPDATE `gossip_menu_option` SET `ActionPoiID`=2284 WHERE `MenuID`=10105 AND `OptionID`=2; +UPDATE `gossip_menu_option` SET `VerifiedBuild`=44908 WHERE `MenuID` IN (10043, 10057, 10089, 10055, 10058, 10084, 10090, 10056, 10082, 10078, 10073, 10173, 10170, 10160, 10153, 10168, 10106, 10105); +DELETE FROM `gossip_menu_option` WHERE `MenuID`=10043 AND `OptionID`=14; +DELETE FROM `gossip_menu_option` WHERE `MenuID`=10056 AND `OptionID`=11; + +DELETE FROM `gossip_menu_option` WHERE `MenuID`=10082 AND `OptionID`=1; +INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `OptionType`, `OptionNpcFlag`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(10082, 1, 0, 'Class Trainer', 32202, 1, 1, 0, 12654, 2195, 0, 0, NULL, 0, 44908); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10082; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15,10082,0,0,0,15,0,128,0,0,0,0,0,'','Show gossip option if the player is Mage'), +(15,10082,1,0,0,15,0,128,0,0,1,0,0,'','Show gossip option if the player is not Mage'), +(15,10082,1,0,0,6,0,469,0,0,0,0,0,'','Show gossip option if the player is Alliance'), +(15,10082,2,0,0,15,0,128,0,0,1,0,0,'','Show gossip option if the player is not Mage'), +(15,10082,2,0,0,6,0,67,0,0,0,0,0,'','Show gossip option if the player is Horde'), +(15,10082,4,0,0,15,0,128,0,0,0,0,0,'','Show gossip option if the player is Mage'); + +DELETE FROM `points_of_interest` WHERE `ID` IN (10238, 10239, 10270, 10271, 10272, 10273, 10274, 10454); +DELETE FROM `points_of_interest` WHERE `ID` BETWEEN 10615 AND 10663; +DELETE FROM `points_of_interest` WHERE `ID` IN (2158, 2159, 2161, 2162, 2163, 2164, 2165, 2166, 2167, 2168, 2169, 2170, 2171, 2172, 2173, 2174, 2175, 2176, 2177, 2178, 2179, 2180, 2181, 2182, 2183, 2184, 2185, 2186, 2187, 2188, 2189, 2190, 2191, 2192, 2193, 2194, 2195, 2196, 2197, 2198, 2271, 2282, 2283, 2284, 2285, 2286, 2287, 2288, 2289, 2290, 2291, 2293, 2294, 2295, 2296, 2297, 2328, 2540); +INSERT INTO `points_of_interest` (`ID`, `PositionX`, `PositionY`, `PositionZ`, `Icon`, `Flags`, `Importance`, `Name`, `Unknown905`, `VerifiedBuild`) VALUES +(2158, 5966.81982421875, 613.9169921875, 650.62701416015625, 7, 99, 0, 'Dalaran Northern Bank', 0, 44908), +(2159, 5640.990234375, 687.531982421875, 651.99298095703125, 7, 99, 0, 'Dalaran Southern Bank', 0, 44908), +(2161, 5797.47998046875, 794.906005859375, 661.86798095703125, 7, 99, 0, 'Dalaran Violet Citadel', 0, 44908), +(2162, 5837.259765625, 722.79998779296875, 641.99700927734375, 7, 99, 0, 'Dalaran Enchanting Trainer', 0, 44908), +(2163, 5860.68017578125, 702.51702880859375, 643.27398681640625, 7, 99, 0, 'Dalaran Inscription Trainer', 0, 44908), +(2164, 5875.56982421875, 691.280029296875, 644.8079833984375, 7, 99, 0, 'Dalaran Herbalism Trainer', 0, 44908), +(2165, 5862.83984375, 743.35101318359375, 640.5570068359375, 7, 99, 0, 'Dalaran First Aid Trainer', 0, 44908), +(2166, 5882.509765625, 745.84698486328125, 640.3709716796875, 7, 99, 0, 'Dalaran Tailoring Trainer', 0, 44908), +(2167, 5903.009765625, 750.31402587890625, 641.02801513671875, 7, 99, 0, 'Dalaran Skinning Trainer', 0, 44908), +(2168, 5903.02978515625, 750.20599365234375, 641.02801513671875, 7, 99, 0, 'Dalaran Leatherworking Trainer', 0, 44908), +(2169, 5920.669921875, 728.16802978515625, 642.135009765625, 7, 99, 0, 'Dalaran Engineering Trainer', 0, 44908), +(2170, 5919.47021484375, 709.66400146484375, 642.5150146484375, 7, 99, 0, 'Dalaran Mining Trainer', 0, 44908), +(2171, 5904.31005859375, 680.88897705078125, 643.4959716796875, 7, 99, 0, 'Dalaran Blacksmithing Trainer', 0, 44908), +(2172, 5890.97021484375, 704.07098388671875, 643.23699951171875, 7, 99, 0, 'Dalaran Alchemy Trainer', 0, 44908), +(2173, 5873.85986328125, 721.72900390625, 643.08697509765625, 7, 99, 0, 'Dalaran Jewelcrafting Trainer', 0, 44908), +(2174, 5952.14990234375, 674.61102294921875, 641.4539794921875, 7, 99, 0, 'Dalaran Antonidas Memorial', 0, 44908), +(2175, 5889.3701171875, 622.22698974609375, 649.38201904296875, 7, 99, 0, 'Dalaran Barber', 0, 44908), +(2176, 5884.7001953125, 608.281005859375, 650.29400634765625, 7, 99, 0, 'Dalaran Wine & Cheese', 0, 44908), +(2177, 5847.10986328125, 567.1500244140625, 652.656005859375, 7, 99, 0, 'Dalaran Pet Store', 0, 44908), +(2178, 5808.52978515625, 581.3079833984375, 652.72198486328125, 7, 99, 0, 'Dalaran Mage Trainer', 0, 44908), +(2179, 5780.39990234375, 558.3489990234375, 651.63897705078125, 7, 99, 0, 'Dalaran Ranged Weapons', 0, 44908), +(2180, 5756.8701171875, 620.78497314453125, 650.09197998046875, 7, 99, 0, 'Dalaran Visitor Center', 0, 44908), +(2181, 5727.330078125, 603.6939697265625, 648.530029296875, 7, 99, 0, 'Dalaran Melee Weapons', 0, 44908), +(2182, 5684.02978515625, 617.3189697265625, 648.23699951171875, 7, 99, 0, 'Dalaran General & Trade Store', 0, 44908), +(2183, 5671.759765625, 629.4580078125, 648.10498046875, 7, 99, 0, 'Dalaran Leather & Mail Armor', 0, 44908), +(2184, 5667.759765625, 645.3909912109375, 647.97998046875, 7, 99, 0, 'Dalaran Staves & Wands', 0, 44908), +(2185, 5790.16015625, 689.1240234375, 647.0980224609375, 7, 99, 0, 'Dalaran Cloth Armor & Clothing', 0, 44908), +(2186, 5814.419921875, 690.780029296875, 647.0479736328125, 7, 99, 0, 'Dalaran Toy Store', 0, 44908), +(2187, 5848.259765625, 636.67498779296875, 647.51202392578125, 7, 99, 0, 'Dalaran Inn', 0, 44908), +(2188, 5750.41015625, 695.40899658203125, 643.333984375, 7, 99, 0, 'Dalaran Fruit Vendor', 0, 44908), +(2189, 5906.35009765625, 628.1939697265625, 646.65399169921875, 7, 99, 0, 'Dalaran Pie, Pastry & Cake', 0, 44908), +(2190, 5816.39013671875, 760.08502197265625, 640.469970703125, 7, 99, 0, 'Dalaran Western Sewer Entrance', 0, 44908), +(2191, 5802.759765625, 552.280029296875, 649.6409912109375, 7, 99, 0, 'Dalaran Eastern Sewer Entrance', 0, 44908), +(2192, 5691.490234375, 500.55999755859375, 652.66497802734375, 7, 99, 0, 'Dalaran Violet Hold', 0, 44908), +(2193, 5857.259765625, 595.4210205078125, 650.844970703125, 7, 99, 0, 'Dalaran Sunreaver''s Sanctuary', 0, 44908), +(2194, 5885.6201171875, 521.7760009765625, 642.09698486328125, 7, 99, 0, 'Dalaran Horde Inn', 0, 44908), +(2195, 5758.10986328125, 715.6409912109375, 641.677001953125, 7, 99, 0, 'Dalaran Silver Enclave', 0, 44908), +(2196, 5731.4599609375, 678.198974609375, 646.14300537109375, 7, 99, 0, 'Dalaran Alliance Inn', 0, 44908), +(2197, 5804.60009765625, 639.55401611328125, 647.78997802734375, 7, 99, 0, 'Dalaran Runeweaver Square', 0, 44908), +(2198, 5773.10009765625, 576.27099609375, 650.447998046875, 7, 99, 0, 'Dalaran Flowers', 0, 44908), +(2271, 5704.83984375, 613.968994140625, 646.7039794921875, 7, 99, 0, 'Dalaran Fishing Fountain', 0, 44908), +(2282, 5765.75, 731.14697265625, 618.59002685546875, 7, 99, 0, 'Dalaran Sewer Bank', 0, 44908), +(2283, 5761.08984375, 714.63702392578125, 618.5479736328125, 7, 99, 0, 'Dalaran Sewer Inn', 0, 44908), +(2284, 5777.5400390625, 743.63201904296875, 620.46600341796875, 7, 99, 0, 'Dalaran Sewer Tunnel', 0, 44908), +(2285, 5777.990234375, 607.48101806640625, 609.885986328125, 7, 99, 0, 'Dalaran Sewer Arena', 0, 44908), +(2286, 5924.83984375, 565.2860107421875, 609.719970703125, 7, 99, 0, 'Dalaran Sewer Vendors', 0, 44908), +(2287, 5879.89990234375, 652.781982421875, 645.2080078125, 7, 99, 0, 'Dalaran Well', 0, 44908), +(2288, 5710.330078125, 645.39697265625, 648.65997314453125, 7, 99, 0, 'Dalaran Eventide', 0, 44908), +(2289, 5851.66015625, 766.2869873046875, 640.83599853515625, 7, 99, 0, 'Dalaran Cemetary', 0, 44908), +(2290, 5912.77978515625, 665.41900634765625, 643.4959716796875, 7, 99, 0, 'Dalaran Plate Armor & Shields', 0, 44908), +(2291, 5765.60009765625, 734.3289794921875, 641.67498779296875, 7, 99, 0, 'Dalaran Reagents', 0, 44908), +(2293, 5899.2099609375, 728.85101318359375, 639.6939697265625, 7, 99, 0, 'Dalaran Trade District', 0, 44908), +(2294, 5813.97021484375, 449.10699462890625, 658.7509765625, 7, 99, 0, 'Dalaran Flight Master', 0, 44908), +(2295, 5831.509765625, 508.61700439453125, 657.70001220703125, 7, 99, 0, 'Dalaran Krasus'' Landing', 0, 44908), +(2296, 5859.72998046875, 557.7449951171875, 652.656005859375, 7, 99, 0, 'Dalaran Stable Master', 0, 44908), +(2297, 5752.080078125, 645.427001953125, 650.1409912109375, 7, 99, 0, 'Dalaran Trinkets', 0, 44908), +(2328, 5934.0498046875, 575.6259765625, 609.78900146484375, 7, 99, 0, 'Dalaran Locksmith', 0, 44908), +(2540, 5855.2099609375, 650.97698974609375, 647.51202392578125, 7, 99, 0, 'Dalaran Archaeology Trainer', 0, 44908); + +DELETE FROM `points_of_interest_locale` WHERE `ID` IN (2158, 2159, 2161, 2162, 2163, 2164, 2165, 2166, 2167, 2168, 2169, 2170, 2171, 2172, 2173, 2174, 2175, 2176, 2177, 2178, 2179, 2180, 2181, 2182, 2183, 2184, 2185, 2186, 2187, 2188, 2189, 2190, 2191, 2192, 2193, 2194, 2195, 2196, 2197, 2198, 2271, 2282, 2283, 2284, 2285, 2286, 2287, 2288, 2289, 2290, 2291, 2293, 2294, 2295, 2296, 2297, 2328, 2540); +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES +(2158, 'deDE', 'Nördliche Bank von Dalaran', 44908), +(2158, 'esES', 'Banco del norte de Dalaran', 44908), +(2158, 'esMX', 'Banco del norte de Dalaran', 44908), +(2158, 'frFR', 'Banque du nord de Dalaran', 44908), +(2158, 'itIT', 'Banca Settentrionale di Dalaran', 44908), +(2158, 'koKR', '달라란 북쪽 은행', 44908), +(2158, 'ptBR', 'Banco Norte de Dalaran', 44908), +(2158, 'ruRU', 'Даларанский северный банк', 44908), +(2158, 'zhCN', '达拉然北部银行', 44908), +(2158, 'zhTW', '達拉然北區銀行', 44908), +(2159, 'deDE', 'Südliche Bank von Dalaran', 44908), +(2159, 'esES', 'Banco del sur de Dalaran', 44908), +(2159, 'esMX', 'Banco del sur de Dalaran', 44908), +(2159, 'frFR', 'Banque du sud de Dalaran', 44908), +(2159, 'itIT', 'Banca Meridionale di Dalaran', 44908), +(2159, 'koKR', '달라란 남쪽 은행', 44908), +(2159, 'ptBR', 'Banco Sul de Dalaran', 44908), +(2159, 'ruRU', 'Южный банк Даларана', 44908), +(2159, 'zhCN', '达拉然南部银行', 44908), +(2159, 'zhTW', '達拉然南區銀行', 44908), +(2161, 'deDE', 'Violette Zitadelle von Dalaran', 44908), +(2161, 'esES', 'La Ciudadela Violeta de Dalaran', 44908), +(2161, 'esMX', 'La Ciudadela Violeta de Dalaran', 44908), +(2161, 'frFR', 'Citadelle Pourpre de Dalaran', 44908), +(2161, 'itIT', 'Cittadella Violacea di Dalaran', 44908), +(2161, 'koKR', '달라란 보랏빛 성채', 44908), +(2161, 'ptBR', 'Cidadela Violeta de Dalaran', 44908), +(2161, 'ruRU', 'Даларанская Аметистовая цитадель', 44908), +(2161, 'zhCN', '达拉然紫罗兰城堡', 44908), +(2161, 'zhTW', '達拉然紫羅蘭城塞', 44908), +(2162, 'deDE', 'Verzauberkunstlehrer von Dalaran', 44908), +(2162, 'esES', 'Instructor de encantamiento de Dalaran', 44908), +(2162, 'esMX', 'Instructor de encantamiento de Dalaran', 44908), +(2162, 'frFR', 'Maître des enchanteurs de Dalaran', 44908), +(2162, 'itIT', 'Incantamento di Dalaran', 44908), +(2162, 'koKR', '달라란 전문 마법부여사', 44908), +(2162, 'ptBR', 'Treinamento de Encantamento de Dalaran', 44908), +(2162, 'ruRU', 'Даларанский учитель наложения чар', 44908), +(2162, 'zhCN', '达拉然附魔训练师', 44908), +(2162, 'zhTW', '達拉然附魔訓練師', 44908), +(2163, 'deDE', 'Inschriftenkundelehrer von Dalaran', 44908), +(2163, 'esES', 'Instructor de inscripción de Dalaran', 44908), +(2163, 'esMX', 'Instructor de inscripción de Dalaran', 44908), +(2163, 'frFR', 'Maître des calligraphes de Dalaran', 44908), +(2163, 'itIT', 'Runografia di Dalaran', 44908), +(2163, 'koKR', '달라란 전문 주문각인사', 44908), +(2163, 'ptBR', 'Treinamento de Escrivania de Dalaran', 44908), +(2163, 'ruRU', 'Даларанский учитель начертания', 44908), +(2163, 'zhCN', '达拉然铭文训练师', 44908), +(2163, 'zhTW', '達拉然銘文訓練師', 44908), +(2164, 'deDE', 'Kräuterkundelehrer von Dalaran', 44908), +(2164, 'esES', 'Instructor de herboristería de Dalaran', 44908), +(2164, 'esMX', 'Instructor de herboristería de Dalaran', 44908), +(2164, 'frFR', 'Maître des herboristes de Dalaran', 44908), +(2164, 'itIT', 'Erbalismo di Dalaran', 44908), +(2164, 'koKR', '달라란 전문 약초채집사', 44908), +(2164, 'ptBR', 'Treinamento de Herborismo de Dalaran', 44908), +(2164, 'ruRU', 'Даларанский учитель травничества', 44908), +(2164, 'zhCN', '达拉然草药学训练师', 44908), +(2164, 'zhTW', '達拉然草藥訓練師', 44908), +(2165, 'deDE', 'Lehrer für Erste Hilfe von Dalaran', 44908), +(2165, 'esES', 'Instructor de primeros auxilios de Dalaran', 44908), +(2165, 'esMX', 'Instructor de primeros auxilios de Dalaran', 44908), +(2165, 'frFR', 'Maître des secouristes de Dalaran', 44908), +(2165, 'itIT', 'Pronto Soccorso di Dalaran', 44908), +(2165, 'koKR', '달라란 응급치료사', 44908), +(2165, 'ptBR', 'Treinamento de Primeiros Socorros de Dalaran', 44908), +(2165, 'ruRU', 'Даларанский учитель первой помощи', 44908), +(2165, 'zhCN', '达拉然急救训练师', 44908), +(2165, 'zhTW', '達拉然急救訓練師', 44908), +(2166, 'deDE', 'Schneiderlehrer von Dalaran', 44908), +(2166, 'esES', 'Instructor de sastrería de Dalaran', 44908), +(2166, 'esMX', 'Instructor de sastrería de Dalaran', 44908), +(2166, 'frFR', 'Maître des tailleurs de Dalaran', 44908), +(2166, 'itIT', 'Sartoria di Dalaran', 44908), +(2166, 'koKR', '달라란 전문 재봉사', 44908), +(2166, 'ptBR', 'Treinamento de Alfaiataria de Dalaran', 44908), +(2166, 'ruRU', 'Даларанский портной', 44908), +(2166, 'zhCN', '达拉然裁缝训练师', 44908), +(2166, 'zhTW', '達拉然裁縫訓練師', 44908), +(2167, 'deDE', 'Kürschnerlehrer von Dalaran', 44908), +(2167, 'esES', 'Instructor de desuello de Dalaran', 44908), +(2167, 'esMX', 'Instructor de desuello de Dalaran', 44908), +(2167, 'frFR', 'Maître des dépeceurs de Dalaran', 44908), +(2167, 'itIT', 'Scuoiatura di Dalaran', 44908), +(2167, 'koKR', '달라란 전문 무두장이', 44908), +(2167, 'ptBR', 'Treinamento de Esfolamento de Dalaran', 44908), +(2167, 'ruRU', 'Даларанский учитель снятия шкур', 44908), +(2167, 'zhCN', '达拉然剥皮训练师', 44908), +(2167, 'zhTW', '達拉然剝皮訓練師', 44908), +(2168, 'deDE', 'Lederverarbeitungslehrer von Dalaran', 44908), +(2168, 'esES', 'Instructor de peletería de Dalaran', 44908), +(2168, 'esMX', 'Instructor de peletería de Dalaran', 44908), +(2168, 'frFR', 'Maître des travailleurs du cuir de Dalaran', 44908), +(2168, 'itIT', 'Conciatura di Dalaran', 44908), +(2168, 'koKR', '달라란 전문 가죽세공인', 44908), +(2168, 'ptBR', 'Treinamento de Couraria de Dalaran', 44908), +(2168, 'ruRU', 'Даларанский учитель кожевничеств', 44908), -- Даларанский учитель кожевничеств� (truncated) +(2168, 'zhCN', '达拉然制皮训练师', 44908), +(2168, 'zhTW', '達拉然製皮訓練師', 44908), +(2169, 'deDE', 'Ingenieurskunstlehrer von Dalaran', 44908), +(2169, 'esES', 'Instructor de ingeniería de Dalaran', 44908), +(2169, 'esMX', 'Instructor de ingeniería de Dalaran', 44908), +(2169, 'frFR', 'Maître des ingénieurs de Dalaran', 44908), +(2169, 'itIT', 'Ingegneria di Dalaran', 44908), +(2169, 'koKR', '달라란 전문 기계공학자', 44908), +(2169, 'ptBR', 'Treinamento de Engenharia de Dalaran', 44908), +(2169, 'ruRU', 'Даларанский учитель инженерного д', 44908), +(2169, 'zhCN', '达拉然工程学训练师', 44908), +(2169, 'zhTW', '達拉然工程學訓練師', 44908), +(2170, 'deDE', 'Bergbaulehrer von Dalaran', 44908), +(2170, 'esES', 'Instructor de minería de Dalaran', 44908), +(2170, 'esMX', 'Instructor de minería de Dalaran', 44908), +(2170, 'frFR', 'Maître des mineurs de Dalaran', 44908), +(2170, 'itIT', 'Estrazione di Dalaran', 44908), +(2170, 'koKR', '달라란 전문 광부', 44908), +(2170, 'ptBR', 'Treinamento de Mineração de Dalaran', 44908), +(2170, 'ruRU', 'Даларанский учитель горного дела', 44908), +(2170, 'zhCN', '达拉然采矿训练师', 44908), +(2170, 'zhTW', '達拉然採礦訓練師', 44908), +(2171, 'deDE', 'Schmiedekunstlehrer von Dalaran', 44908), +(2171, 'esES', 'Instructor de herrería de Dalaran', 44908), +(2171, 'esMX', 'Instructor de herrería de Dalaran', 44908), +(2171, 'frFR', 'Maître des forgerons de Dalaran', 44908), +(2171, 'itIT', 'Forgiatura di Dalaran', 44908), +(2171, 'koKR', '달라란 전문 대장장이', 44908), +(2171, 'ptBR', 'Treinamento de Ferraria de Dalaran', 44908), +(2171, 'ruRU', 'Даларанский учитель кузнечного де', 44908), +(2171, 'zhCN', '达拉然锻造训练师', 44908), +(2171, 'zhTW', '達拉然鍛造訓練師', 44908), +(2172, 'deDE', 'Alchemielehrer von Dalaran', 44908), +(2172, 'esES', 'Instructor de alquimia de Dalaran', 44908), +(2172, 'esMX', 'Instructor de alquimia de Dalaran', 44908), +(2172, 'frFR', 'Maître des alchimistes de Dalaran', 44908), +(2172, 'itIT', 'Alchimia di Dalaran', 44908), +(2172, 'koKR', '달라란 전문 연금술사', 44908), +(2172, 'ptBR', 'Treinamento de Alquimia de Dalaran', 44908), +(2172, 'ruRU', 'Даларанский учитель алхимии', 44908), +(2172, 'zhCN', '达拉然炼金术训练师', 44908), +(2172, 'zhTW', '達拉然鍊金訓練師', 44908), +(2173, 'deDE', 'Juwelierskunstlehrer von Dalaran', 44908), +(2173, 'esES', 'Instructor de joyería de Dalaran', 44908), +(2173, 'esMX', 'Instructor de joyería de Dalaran', 44908), +(2173, 'frFR', 'Maître des joailliers de Dalaran', 44908), +(2173, 'itIT', 'Oreficeria di Dalaran', 44908), +(2173, 'koKR', '달라란 전문 보석세공인', 44908), +(2173, 'ptBR', 'Treinamento de Joalheria de Dalaran', 44908), +(2173, 'ruRU', 'Даларанский учитель ювелирного де', 44908), +(2173, 'zhCN', '达拉然珠宝加工训练师', 44908), +(2173, 'zhTW', '達拉然珠寶設計訓練師', 44908), +(2174, 'deDE', 'Antonidas'' Denkmal von Dalaran', 44908), +(2174, 'esES', 'Monumento de Antonidas de Dalaran', 44908), +(2174, 'esMX', 'Monumento de Antonidas de Dalaran', 44908), +(2174, 'frFR', 'Monument à Antonidas de Dalaran', 44908), +(2174, 'itIT', 'Monumento ad Antonidas di Dalaran', 44908), +(2174, 'koKR', '달라란 안토니다스 기념지', 44908), +(2174, 'ptBR', 'Memorial a Antônidas de Dalaran', 44908), +(2174, 'ruRU', 'Даларанский памятник Антонидасу', 44908), +(2174, 'zhCN', '达拉然安东尼达斯纪念碑', 44908), +(2174, 'zhTW', '達拉然安東尼達斯紀念碑', 44908), +(2175, 'deDE', 'Barbier von Dalaran', 44908), +(2175, 'esES', 'Peluquería de Dalaran', 44908), +(2175, 'esMX', 'Peluquería de Dalaran', 44908), +(2175, 'frFR', 'Salon de coiffure de Dalaran', 44908), +(2175, 'itIT', 'Barbiere di Dalaran', 44908), +(2175, 'koKR', '달라란 미용실', 44908), +(2175, 'ptBR', 'Barbeiro de Dalaran', 44908), +(2175, 'ruRU', 'Даларанский парикмахер', 44908), +(2175, 'zhCN', '达拉然理发店', 44908), +(2175, 'zhTW', '達拉然美容師', 44908), +(2176, 'deDE', 'Wein & Käse von Dalaran', 44908), +(2176, 'esES', 'Vinos y quesos de Dalaran', 44908), +(2176, 'esMX', 'Vinos y quesos de Dalaran', 44908), +(2176, 'frFR', 'Vins et fromages de Dalaran', 44908), +(2176, 'itIT', 'Vino e Formaggio di Dalaran', 44908), +(2176, 'koKR', '달라란 식료품점', 44908), +(2176, 'ptBR', 'Queijos & Vinhos de Dalaran', 44908), +(2176, 'ruRU', 'Даларанский сыр и вина', 44908), +(2176, 'zhCN', '达拉然酒类和奶酪店', 44908), +(2176, 'zhTW', '達拉然起司與酒', 44908), +(2177, 'deDE', 'Haustierbedarf von Dalaran', 44908), +(2177, 'esES', 'Tienda de mascotas de Dalaran', 44908), +(2177, 'esMX', 'Tienda de mascotas de Dalaran', 44908), +(2177, 'frFR', 'Animalerie de Dalaran', 44908), +(2177, 'itIT', 'Negozio di Animali di Dalaran', 44908), +(2177, 'koKR', '달라란 야수 관리인', 44908), +(2177, 'ptBR', 'Loja de Mascotes de Dalaran', 44908), +(2177, 'ruRU', 'Даларанский магазин питомцев', 44908), +(2177, 'zhCN', '达拉然宠物店', 44908), +(2177, 'zhTW', '達拉然寵物商店', 44908), +(2178, 'deDE', 'Magierlehrer von Dalaran', 44908), +(2178, 'esES', 'Instructor de magos de Dalaran', 44908), +(2178, 'esMX', 'Instructor de magos de Dalaran', 44908), +(2178, 'frFR', 'Maître des mages de Dalaran', 44908), +(2178, 'itIT', 'Istruttore dei Maghi di Dalaran', 44908), +(2178, 'koKR', '달라란 상급 마법사', 44908), +(2178, 'ptBR', 'Treinamento de Magos de Dalaran', 44908), +(2178, 'ruRU', 'Даларанский наставник магов', 44908), +(2178, 'zhCN', '达拉然法师训练师', 44908), +(2178, 'zhTW', '達拉然法師訓練師', 44908), +(2179, 'deDE', 'Distanzwaffen von Dalaran', 44908), +(2179, 'esES', 'Armas de combate a distancia de Dalaran', 44908), +(2179, 'esMX', 'Armas de combate a distancia de Dalaran', 44908), +(2179, 'frFR', 'Armes de jet de Dalaran', 44908), +(2179, 'itIT', 'Armi a Distanza di Dalaran', 44908), +(2179, 'koKR', '달라란 원거리 무기 상인', 44908), +(2179, 'ptBR', 'Armas de Longo Alcance de Dalaran', 44908), +(2179, 'ruRU', 'Даларанское оружие дальнего боя', 44908), +(2179, 'zhCN', '达拉然远程武器店', 44908), +(2179, 'zhTW', '達拉然遠程武器', 44908), +(2180, 'deDE', 'Besucherzentrum von Dalaran', 44908), +(2180, 'esES', 'Centro de visitantes de Dalaran', 44908), +(2180, 'esMX', 'Centro de visitantes de Dalaran', 44908), +(2180, 'frFR', 'Accueil des visiteurs de Dalaran', 44908), +(2180, 'itIT', 'Centro d''Accoglienza di Dalaran', 44908), +(2180, 'koKR', '달라란 관광 안내소', 44908), +(2180, 'ptBR', 'Centro para Visitantes de Dalaran', 44908), +(2180, 'ruRU', 'Гостевые покои Даларана', 44908), +(2180, 'zhCN', '达拉然访客中心', 44908), +(2180, 'zhTW', '達拉然旅客中心', 44908), +(2181, 'deDE', 'Nahkampfwaffen von Dalaran', 44908), +(2181, 'esES', 'Armas de combate cuerpo a cuerpo de Dalaran', 44908), +(2181, 'esMX', 'Armas de combate cuerpo a cuerpo de Dalaran', 44908), +(2181, 'frFR', 'Armes de mêlée de Dalaran', 44908), +(2181, 'itIT', 'Armi da Mischia di Dalaran', 44908), +(2181, 'koKR', '달라란 근접 무기 상인', 44908), +(2181, 'ptBR', 'Armas Corpo a Corpo de Dalaran', 44908), +(2181, 'ruRU', 'Даларанское оружие ближнего боя', 44908), +(2181, 'zhCN', '达拉然近战武器店', 44908), +(2181, 'zhTW', '達拉然近戰武器', 44908), +(2182, 'deDE', 'Gemischt- & Handwerkswaren von Dalaran', 44908), +(2182, 'esES', 'Géneros y Trueques de Dalaran', 44908), +(2182, 'esMX', 'Géneros y Trueques de Dalaran', 44908), +(2182, 'frFR', 'Comptoir général de Dalaran', 44908), +(2182, 'itIT', 'Negozio di Beni Generici di Dalaran', 44908), +(2182, 'koKR', '달라란 일용품 상점', 44908), +(2182, 'ptBR', 'Loja de Artigos Gerais de Dalaran', 44908), +(2182, 'ruRU', 'Даларанские потребительские и хоз', 44908), +(2182, 'zhCN', '达拉然杂货店', 44908), +(2182, 'zhTW', '達拉然雜貨商店', 44908), +(2183, 'deDE', 'Leder- & Kettenrüstung von Dalaran', 44908), +(2183, 'esES', 'Armaduras de cuero y malla de Dalaran', 44908), +(2183, 'esMX', 'Armaduras de cuero y malla de Dalaran', 44908), +(2183, 'frFR', 'Armures de cuir et de mailles de Dalaran', 44908), +(2183, 'itIT', 'Armature di Cuoio e Maglia di Dalaran', 44908), +(2183, 'koKR', '달라란 가죽 및 사슬 방어구 상점', 44908), +(2183, 'ptBR', 'Armaduras de Couro & Malha de Dalaran', 44908), +(2183, 'ruRU', 'Даларанские кольчужные и кожаные ', 44908), -- Даларанские кольчужные и кожаные � (truncated) +(2183, 'zhCN', '达拉然皮甲和锁甲店', 44908), +(2183, 'zhTW', '達拉然皮甲與鎖甲', 44908), +(2184, 'deDE', 'Stäbe & Zauberstäbe von Dalaran', 44908), +(2184, 'esES', 'Bastones y varitas de Dalaran', 44908), +(2184, 'esMX', 'Bastones y varitas de Dalaran', 44908), +(2184, 'frFR', 'Bâtons et baguettes de Dalaran', 44908), +(2184, 'itIT', 'Bastoni e Bacchette di Dalaran', 44908), +(2184, 'koKR', '달라란 마법봉 및 지팡이 상점', 44908), +(2184, 'ptBR', 'Báculo & Varinhas de Dalaran', 44908), +(2184, 'ruRU', 'Даларанские посохи и жезлы', 44908), +(2184, 'zhCN', '达拉然法杖和魔杖店', 44908), +(2184, 'zhTW', '達拉然法杖與魔杖', 44908), +(2185, 'deDE', 'Stoffrüstung & Kleidung von Dalaran', 44908), +(2185, 'esES', 'Armaduras de tela y ropa de Dalaran', 44908), +(2185, 'esMX', 'Armaduras de tela y ropa de Dalaran', 44908), +(2185, 'frFR', 'Vêtements et armures légères de Dalaran', 44908), +(2185, 'itIT', 'Armature di Stoffa di Dalaran', 44908), +(2185, 'koKR', '달라란 천 방어구 및 의류 상점', 44908), +(2185, 'ptBR', 'Vestimentas & Armaduras de Tecido de Dalaran', 44908), +(2185, 'ruRU', 'Даларанские тканые одежды', 44908), +(2185, 'zhCN', '达拉然布衣店', 44908), +(2185, 'zhTW', '達拉然布甲與服裝', 44908), +(2186, 'deDE', 'Spielzeugladen von Dalaran', 44908), +(2186, 'esES', 'Tienda de juguetes de Dalaran', 44908), +(2186, 'esMX', 'Tienda de juguetes de Dalaran', 44908), +(2186, 'frFR', 'Magasin de jouets de Dalaran', 44908), +(2186, 'itIT', 'Negozio di Giocattoli di Dalaran', 44908), +(2186, 'koKR', '달라란 장난감 상점', 44908), +(2186, 'ptBR', 'Loja de Brinquedos de Dalaran', 44908), +(2186, 'ruRU', 'Даларанский магазин игрушек', 44908), +(2186, 'zhCN', '达拉然玩具店', 44908), +(2186, 'zhTW', '達拉然玩具商店', 44908), +(2187, 'deDE', 'Gasthaus von Dalaran', 44908), +(2187, 'esES', 'Posada de Dalaran', 44908), +(2187, 'esMX', 'Taberna de Dalaran', 44908), +(2187, 'frFR', 'Auberge de Dalaran', 44908), +(2187, 'itIT', 'Locanda di Dalaran', 44908), +(2187, 'koKR', '달라란 여관', 44908), +(2187, 'ptBR', 'Estalagem de Dalaran', 44908), +(2187, 'ruRU', 'Даларанская таверна', 44908), +(2187, 'zhCN', '达拉然旅店', 44908), +(2187, 'zhTW', '達拉然旅店', 44908), +(2188, 'deDE', 'Fruchthändler von Dalaran', 44908), +(2188, 'esES', 'Vendedor de frutas de Dalaran', 44908), +(2188, 'esMX', 'Vendedor de fruta de Dalaran', 44908), +(2188, 'frFR', 'Marchand de fruit de Dalaran', 44908), +(2188, 'itIT', 'Venditore di Frutta di Dalaran', 44908), +(2188, 'koKR', '달라란 과일 상인', 44908), +(2188, 'ptBR', 'Vendedor de Frutas de Dalaran', 44908), +(2188, 'ruRU', 'Даларанский торговец фруктами', 44908), +(2188, 'zhCN', '达拉然水果店', 44908), +(2188, 'zhTW', '達拉然水果商', 44908), +(2189, 'deDE', 'Kuchen, Gebäck & Torten aus Dalaran', 44908), +(2189, 'esES', 'Tartas, pasteles y bizochos de Dalaran', 44908), +(2189, 'esMX', 'Tartas, pasteles y bizochos de Dalaran', 44908), +(2189, 'frFR', 'Tartes, gâteaux et pâtisseries de Dalaran', 44908), +(2189, 'itIT', 'Dolci, Dolcetti e Dolciumi di Dalaran', 44908), +(2189, 'koKR', '달라란 제과점', 44908), +(2189, 'ptBR', 'Bolos, Massas e Tortas de Dalaran', 44908), +(2189, 'ruRU', 'Даларанские плюшки и ватрушки', 44908), +(2189, 'zhCN', '达拉然馅饼和蛋糕店', 44908), +(2189, 'zhTW', '達拉然派、餡餅與蛋糕', 44908), +(2190, 'deDE', 'Westlicher Kanalisationseingang von Dalaran', 44908), +(2190, 'esES', 'Entrada occidental de las cloacas de Dalaran', 44908), +(2190, 'esMX', 'Entrada occidental de las cloacas de Dalaran', 44908), +(2190, 'frFR', 'Entrée ouest des égouts de Dalaran', 44908), +(2190, 'itIT', 'Entrata Occidentale alle Fogne di Dalaran', 44908), +(2190, 'koKR', '달라란 서쪽 하수도 입구', 44908), +(2190, 'ptBR', 'Entrada Oeste dos Esgotos de Dalaran', 44908), +(2190, 'ruRU', 'Западный вход в даларанскую канал', 44908), -- Западный вход в даларанскую канал� (truncated) +(2190, 'zhCN', '达拉然西部下水道入口', 44908), +(2190, 'zhTW', '達拉然西下水道入口', 44908), +(2191, 'deDE', 'Östlicher Kanalisationseingang von Dalaran', 44908), +(2191, 'esES', 'Entrada oriental de las cloacas de Dalaran', 44908), +(2191, 'esMX', 'Entrada oriental de las cloacas de Dalaran', 44908), +(2191, 'frFR', 'Entrée est des égouts de Dalaran', 44908), +(2191, 'itIT', 'Entrata Orientale alle Fogne di Dalaran', 44908), +(2191, 'koKR', '달라란 동쪽 하수도 입구', 44908), +(2191, 'ptBR', 'Entrada Leste dos Esgotos de Dalaran', 44908), +(2191, 'ruRU', 'Восточный вход в даларанскую кана', 44908), -- Восточный вход в даларанскую кана� (truncated) +(2191, 'zhCN', '达拉然东部下水道入口', 44908), +(2191, 'zhTW', '達拉然東下水道入口', 44908), +(2192, 'deDE', 'Violette Festung von Dalaran', 44908), +(2192, 'esES', 'Bastión Violeta de Dalaran', 44908), +(2192, 'esMX', 'Bastión Violeta de Dalaran', 44908), +(2192, 'frFR', 'Le fort Pourpre de Dalaran', 44908), +(2192, 'itIT', 'Fortezza Violacea di Dalaran', 44908), +(2192, 'koKR', '달라란 보랏빛 요새', 44908), +(2192, 'ptBR', 'Castelo Violeta de Dalaran', 44908), +(2192, 'ruRU', 'Даларанская Аметистовая Крепость', 44908), +(2192, 'zhCN', '达拉然紫罗兰监狱', 44908), +(2192, 'zhTW', '達拉然紫羅蘭堡', 44908), +(2193, 'deDE', 'Sonnenhäschers Zuflucht von Dalaran', 44908), +(2193, 'esES', 'Santuario Atracasol de Dalaran', 44908), +(2193, 'esMX', 'Santuario Atracasol de Dalaran', 44908), +(2193, 'frFR', 'Sanctuaire de Saccage-Soleil de Dalaran', 44908), +(2193, 'itIT', 'Santuario dei Predatori del Sole di Dalaran', 44908), +(2193, 'koKR', '달라란 선리버 성소', 44908), +(2193, 'ptBR', 'Santuário Fendessol de Dalaran', 44908), +(2193, 'ruRU', 'Даларанское Прибежище Похитителя ', 44908), -- Даларанское Прибежище Похитителя (truncated) +(2193, 'zhCN', '达拉然夺日者圣殿', 44908), +(2193, 'zhTW', '達拉然奪日者聖堂', 44908), +(2194, 'deDE', 'Hordengasthaus von Dalaran', 44908), +(2194, 'esES', 'Posada de la Horda de Dalaran', 44908), +(2194, 'esMX', 'Taberna de la Horda de Dalaran', 44908), +(2194, 'frFR', 'Auberge de la Horde de Dalaran', 44908), +(2194, 'itIT', 'Locanda dell''Orda di Dalaran', 44908), +(2194, 'koKR', '달라란 호드 여관', 44908), +(2194, 'ptBR', 'Estalagem da Horda de Dalaran', 44908), +(2194, 'ruRU', 'Даларанская таверна Орды', 44908), +(2194, 'zhCN', '达拉然部落旅店', 44908), +(2194, 'zhTW', '達拉然部落旅店', 44908), +(2195, 'deDE', 'Silberne Enklave von Dalaran', 44908), +(2195, 'esES', 'El Enclave de Plata de Dalaran', 44908), +(2195, 'esMX', 'El Enclave de Plata de Dalaran', 44908), +(2195, 'frFR', 'L''enclave Argentée de Dalaran', 44908), +(2195, 'itIT', 'Enclave d''Argento di Dalaran', 44908), +(2195, 'koKR', '달라란 은빛 자치구', 44908), +(2195, 'ptBR', 'Enclave Prateado de Dalaran', 44908), +(2195, 'ruRU', 'Даларанский Серебряный Анклав', 44908), +(2195, 'zhCN', '达拉然银色领地', 44908), +(2195, 'zhTW', '達拉然白銀領區', 44908), +(2196, 'deDE', 'Allianzgasthaus von Dalaran', 44908), +(2196, 'esES', 'Posada de la Alianza de Dalaran', 44908), +(2196, 'esMX', 'Taberna de la Alianza de Dalaran', 44908), +(2196, 'frFR', 'Auberge de l''Alliance de Dalaran', 44908), +(2196, 'itIT', 'Locanda dell''Alleanza di Dalaran', 44908), +(2196, 'koKR', '달라란 얼라이언스 여관', 44908), +(2196, 'ptBR', 'Estalagem da Aliança de Dalaran', 44908), +(2196, 'ruRU', 'Даларанская таверна Альянса', 44908), +(2196, 'zhCN', '达拉然联盟旅店', 44908), +(2196, 'zhTW', '達拉然聯盟旅店', 44908), +(2197, 'deDE', 'Der Runenweberplatz von Dalaran', 44908), +(2197, 'esES', 'Plaza Tejerruna de Dalaran', 44908), +(2197, 'esMX', 'Plaza Tejerruna de Dalaran', 44908), +(2197, 'frFR', 'Place Tisserune de Dalaran', 44908), +(2197, 'itIT', 'Piazza di Tessiruna di Dalaran', 44908), +(2197, 'koKR', '달라란 룬위버 광장', 44908), +(2197, 'ptBR', 'Praça Fiarruna de Dalaran', 44908), +(2197, 'ruRU', 'Площадь Руноплета в Даларане', 44908), +(2197, 'zhCN', '达拉然鲁因广场', 44908), +(2197, 'zhTW', '達拉然織符者廣場', 44908), +(2198, 'deDE', 'Blumen von Dalaran', 44908), +(2198, 'esES', 'Flores de Dalaran', 44908), +(2198, 'esMX', 'Flores de Dalaran', 44908), +(2198, 'frFR', 'Fleurs de Dalaran', 44908), +(2198, 'itIT', 'Fiori di Dalaran', 44908), +(2198, 'koKR', '달라란 화원', 44908), +(2198, 'ptBR', 'Flores de Dalaran', 44908), +(2198, 'ruRU', 'Даларанские цветы', 44908), +(2198, 'zhCN', '达拉然花店', 44908), +(2198, 'zhTW', '達拉然花店', 44908), +(2271, 'deDE', 'Anglerbrunnen von Dalaran', 44908), +(2271, 'esES', 'Fuente para pescar de Dalaran', 44908), +(2271, 'esMX', 'Fuente para pescar de Dalaran', 44908), +(2271, 'frFR', 'Fontaine à poissons de Dalaran', 44908), +(2271, 'itIT', 'Fontana dei Pesci di Dalaran', 44908), +(2271, 'koKR', '달라란 분수대 낚시터', 44908), +(2271, 'ptBR', 'Fonte de Pesca de Dalaran', 44908), +(2271, 'ruRU', 'Даларанский фонтан с рыбками', 44908), +(2271, 'zhCN', '达拉然钓鱼喷泉', 44908), +(2271, 'zhTW', '達拉然釣魚噴泉', 44908), +(2282, 'deDE', 'Bank in der Kanalisation von Dalaran', 44908), +(2282, 'esES', 'Banco de las Cloacas de Dalaran', 44908), +(2282, 'esMX', 'Banco de las Cloacas de Dalaran', 44908), +(2282, 'frFR', 'Banque des égouts de Dalaran', 44908), +(2282, 'itIT', 'Banca delle Fogne di Dalaran', 44908), +(2282, 'koKR', '달라란 하수도 은행', 44908), +(2282, 'ptBR', 'Banco dos Esgotos de Dalaran', 44908), +(2282, 'ruRU', 'Банк в стоках Даларана', 44908), +(2282, 'zhCN', '达拉然下水道银行', 44908), +(2282, 'zhTW', '達拉然下水道銀行', 44908), +(2283, 'deDE', 'Gasthaus in der Kanalisation von Dalaran', 44908), +(2283, 'esES', 'Posada de las Cloacas de Dalaran', 44908), +(2283, 'esMX', 'Taberna de las Cloacas de Dalaran', 44908), +(2283, 'frFR', 'Auberge des égouts de Dalaran', 44908), +(2283, 'itIT', 'Locanda delle Fogne di Dalaran', 44908), +(2283, 'koKR', '달라란 하수도 여관', 44908), +(2283, 'ptBR', 'Estalagem dos Esgotos de Dalaran', 44908), +(2283, 'ruRU', 'Таверна в стоках Даларана', 44908), +(2283, 'zhCN', '达拉然下水道旅店', 44908), +(2283, 'zhTW', '達拉然下水道旅店', 44908), +(2284, 'deDE', 'Kanalisationstunnel von Dalaran', 44908), +(2284, 'esES', 'Túnel de las Cloacas de Dalaran', 44908), +(2284, 'esMX', 'Túnel de las Cloacas de Dalaran', 44908), +(2284, 'frFR', 'Tunnel des égouts de Dalaran', 44908), +(2284, 'itIT', 'Galleria delle Fogne di Dalaran', 44908), +(2284, 'koKR', '달라란 하수도 통로', 44908), +(2284, 'ptBR', 'Túnel dos Esgotos de Dalaran', 44908), +(2284, 'ruRU', 'Туннель в стоках Даларана', 44908), +(2284, 'zhCN', '达拉然下水道', 44908), +(2284, 'zhTW', '達拉然下水道隧道', 44908), +(2285, 'deDE', 'Arena in der Kanalisation von Dalaran', 44908), +(2285, 'esES', 'Arena de las Cloacas de Dalaran', 44908), +(2285, 'esMX', 'Arena de las Cloacas de Dalaran', 44908), +(2285, 'frFR', 'Arène des égouts de Dalaran', 44908), +(2285, 'itIT', 'Arena delle Fogne di Dalaran', 44908), +(2285, 'koKR', '달라란 하수도 투기장', 44908), +(2285, 'ptBR', 'Arena dos Esgotos de Dalaran', 44908), +(2285, 'ruRU', 'Арена в стоках Даларана', 44908), +(2285, 'zhCN', '达拉然下水道竞技场', 44908), +(2285, 'zhTW', '達拉然下水道競技場', 44908), +(2286, 'deDE', 'Händler in der Kanalisation von Dalaran', 44908), +(2286, 'esES', 'Vendedores de las Cloacas de Dalaran', 44908), +(2286, 'esMX', 'Vendedores de las Cloacas de Dalaran', 44908), +(2286, 'frFR', 'Vendeurs des égouts de Dalaran', 44908), +(2286, 'itIT', 'Venditori delle Fogne di Dalaran', 44908), +(2286, 'koKR', '달라란 하수도 상인', 44908), +(2286, 'ptBR', 'Comerciantes dos Esgotos de Dalaran', 44908), +(2286, 'ruRU', 'Торговцы в стоках Даларана', 44908), +(2286, 'zhCN', '达拉然下水道商人', 44908), +(2286, 'zhTW', '達拉然下水道商人', 44908), +(2287, 'deDE', 'Brunnen von Dalaran', 44908), +(2287, 'esES', 'Pozo de Dalaran', 44908), +(2287, 'esMX', 'Pozo de Dalaran', 44908), +(2287, 'frFR', 'Puits de Dalaran', 44908), +(2287, 'itIT', 'Pozzo di Dalaran', 44908), +(2287, 'koKR', '달라란 우물', 44908), +(2287, 'ptBR', 'Poço de Dalaran', 44908), +(2287, 'ruRU', 'Даларанский колодец', 44908), +(2287, 'zhCN', '达拉然水井', 44908), +(2287, 'zhTW', '達拉然水井', 44908), +(2288, 'deDE', 'Abendruh in Dalaran', 44908), +(2288, 'esES', 'Manto de la Noche de Dalaran', 44908), +(2288, 'esMX', 'Manto de la Noche de Dalaran', 44908), +(2288, 'frFR', 'Le Brunant de Dalaran', 44908), +(2288, 'itIT', 'Piazza del Vespro di Dalaran', 44908), +(2288, 'koKR', '달라란 어스름 거리', 44908), +(2288, 'ptBR', 'Anoitecer de Dalaran', 44908), +(2288, 'ruRU', 'Даларанский закат', 44908), +(2288, 'zhCN', '达拉然日暮广场', 44908), +(2288, 'zhTW', '達拉然日暮區', 44908), +(2289, 'deDE', 'Friedhof von Dalaran', 44908), +(2289, 'esES', 'Cementerio de Dalaran', 44908), +(2289, 'esMX', 'Cementerio de Dalaran', 44908), +(2289, 'frFR', 'Cimetière de Dalaran', 44908), +(2289, 'itIT', 'Cimitero di Dalaran', 44908), +(2289, 'koKR', '달라란 묘지', 44908), +(2289, 'ptBR', 'Cemitério de Dalaran', 44908), +(2289, 'ruRU', 'Даларанское кладбище', 44908), +(2289, 'zhCN', '达拉然公墓', 44908), +(2289, 'zhTW', '達拉然陵墓', 44908), +(2290, 'deDE', 'Plattenrüstung & Schilde von Dalaran', 44908), +(2290, 'esES', 'Armaduras y escudos de placas de Dalaran', 44908), +(2290, 'esMX', 'Armaduras y escudos de placas de Dalaran', 44908), +(2290, 'frFR', 'Armures de plaques et boucliers de Dalaran', 44908), +(2290, 'itIT', 'Armature a Piastre e Scudi di Dalaran', 44908), +(2290, 'koKR', '달라란 판금 방어구 및 방패', 44908), +(2290, 'ptBR', 'Escudos & Armaduras de Placa de Dalaran', 44908), +(2290, 'ruRU', 'Даларанские латы и щиты', 44908), +(2290, 'zhCN', '达拉然板甲和盾牌店', 44908), +(2290, 'zhTW', '達拉然鎧甲與盾牌', 44908), +(2291, 'deDE', 'Reagenzien von Dalaran', 44908), +(2291, 'esES', 'Componentes de Dalaran', 44908), +(2291, 'esMX', 'Componentes de Dalaran', 44908), +(2291, 'frFR', 'Composants de Dalaran', 44908), +(2291, 'itIT', 'Reagenti di Dalaran', 44908), +(2291, 'koKR', '달라란 마법 재료 상인', 44908), +(2291, 'ptBR', 'Reagente de Dalaran', 44908), +(2291, 'ruRU', 'Даларанские реагенты', 44908), +(2291, 'zhCN', '达拉然材料店', 44908), +(2291, 'zhTW', '達拉然材料商', 44908), +(2293, 'deDE', 'Handelsdistrikt von Dalaran', 44908), +(2293, 'esES', 'Distrito de Mercaderes de Dalaran', 44908), +(2293, 'esMX', 'Distrito de Mercaderes de Dalaran', 44908), +(2293, 'frFR', 'Quartier commerçant de Dalaran', 44908), +(2293, 'itIT', 'Distretto Commerciale di Dalaran', 44908), +(2293, 'koKR', '달라란 상업 지구', 44908), +(2293, 'ptBR', 'Distrito Comercial de Dalaran', 44908), +(2293, 'ruRU', 'Торговый квартал Даларана', 44908), +(2293, 'zhCN', '达拉然贸易区', 44908), +(2293, 'zhTW', '達拉然貿易區', 44908), +(2294, 'deDE', 'Flugmeister von Dalaran', 44908), +(2294, 'esES', 'Maestro de vuelo de Dalaran', 44908), +(2294, 'esMX', 'Maestro de vuelo de Dalaran', 44908), +(2294, 'frFR', 'Maître de vol, Dalaran', 44908), +(2294, 'itIT', 'Maestro di Volo di Dalaran', 44908), +(2294, 'koKR', '달라란 비행 조련사', 44908), +(2294, 'ptBR', 'Mestre de Voo de Dalaran', 44908), +(2294, 'ruRU', 'Даларанский распорядитель полето', 44908), -- Даларанский распорядитель полето� (truncated) +(2294, 'zhCN', '达拉然飞行管理员', 44908), +(2294, 'zhTW', '達拉然飛行管理員', 44908), +(2295, 'deDE', 'Krasus'' Landeplatz in Dalaran', 44908), +(2295, 'esES', 'Alto de Krasus de Dalaran', 44908), +(2295, 'esMX', 'Alto de Krasus de Dalaran', 44908), +(2295, 'frFR', 'Aire de Krasus, Dalaran', 44908), +(2295, 'itIT', 'Terrazza di Krasus di Dalaran', 44908), +(2295, 'koKR', '달라란 크라서스 착륙장', 44908), +(2295, 'ptBR', 'Plataforma de Krasus de Dalaran', 44908), +(2295, 'ruRU', 'Даларанская площадка Краса', 44908), +(2295, 'zhCN', '达拉然克拉苏斯平台', 44908), +(2295, 'zhTW', '達拉然卡薩斯平臺', 44908), +(2296, 'deDE', 'Stallmeister von Dalaran', 44908), +(2296, 'esES', 'Maestro de establos de Dalaran', 44908), +(2296, 'esMX', 'Maestro de establos de Dalaran', 44908), +(2296, 'frFR', 'Maître des écuries de Dalaran', 44908), +(2296, 'itIT', 'Stalliere di Dalaran', 44908), +(2296, 'koKR', '달라란 야수 관리인', 44908), +(2296, 'ptBR', 'Mestre de Estábulo de Dalaran', 44908), +(2296, 'ruRU', 'Даларанский смотритель стойл', 44908), +(2296, 'zhCN', '达拉然兽栏管理员', 44908), +(2296, 'zhTW', '達拉然獸欄管理員', 44908), +(2297, 'deDE', 'Schmuckstücke von Dalaran', 44908), +(2297, 'esES', 'Alhajas de Dalaran', 44908), +(2297, 'esMX', 'Alhajas de Dalaran', 44908), +(2297, 'frFR', 'Les diamants de Dalaran', 44908), +(2297, 'itIT', 'Monili di Dalaran', 44908), +(2297, 'koKR', '달라란 장신구', 44908), +(2297, 'ptBR', 'Berloques de Dalaran', 44908), +(2297, 'ruRU', 'Даларанские аксессуары', 44908), +(2297, 'zhCN', '达拉然饰品店', 44908), +(2297, 'zhTW', '達拉然飾品', 44908), +(2328, 'deDE', 'Schlosser von Dalaran', 44908), +(2328, 'esES', 'Cerrajería de Dalaran', 44908), +(2328, 'esMX', 'Cerrajería de Dalaran', 44908), +(2328, 'frFR', 'Serrurerie de Dalaran', 44908), +(2328, 'itIT', 'Mastro di Chiavi di Dalaran', 44908), +(2328, 'koKR', '달라란 자물쇠 상인', 44908), +(2328, 'ptBR', 'Arrombador de Dalaran', 44908), +(2328, 'ruRU', 'Даларанский замочник', 44908), +(2328, 'zhCN', '达拉然锁匠', 44908), +(2328, 'zhTW', '達拉然鎖匠', 44908), +(2540, 'deDE', 'Archäologielehrer von Dalaran', 44908), +(2540, 'esES', 'Instructor de arqueología de Dalaran', 44908), +(2540, 'esMX', 'Instructor de arqueología de Dalaran', 44908), +(2540, 'frFR', 'Maître des archéologues de Dalaran', 44908), +(2540, 'itIT', 'Archeologia di Dalaran', 44908), +(2540, 'koKR', '달라란 고고학자', 44908), +(2540, 'ptBR', 'Treinamento de Arqueologia de Dalaran', 44908), +(2540, 'ruRU', 'Даларанский учитель археологии', 44908), +(2540, 'zhCN', '达拉然考古学训练师', 44908), +(2540, 'zhTW', '達拉然考古學', 44908); |