/* SQLyog Professional v13.1.7 (64 bit) MySQL - 8.0.21 : Database - asc_world_new ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; /*Table structure for table `points_of_interest` */ CREATE TABLE `points_of_interest` ( `entry` int unsigned NOT NULL DEFAULT '0', `x` float NOT NULL DEFAULT '0', `y` float NOT NULL DEFAULT '0', `icon` mediumint unsigned NOT NULL DEFAULT '0', `flags` mediumint unsigned NOT NULL DEFAULT '0', `data` mediumint unsigned NOT NULL DEFAULT '0', `icon_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Points of interest'; /*Data for the table `points_of_interest` */ insert into `points_of_interest`(`entry`,`x`,`y`,`icon`,`flags`,`data`,`icon_name`) values (1,-8811.46,667.46,7,6,0,'Stormwind Auction House'),(2,-8916.87,622.87,7,6,0,'Stormwind Bank'),(3,-8634.77,949.64,7,6,0,'Stormwind Harbor'),(4,-8378.88,554.23,7,6,0,'The Deeprun Tram'),(5,-8869,675.4,7,6,0,'The Gilded Rose'),(6,-8837,493.5,7,6,0,'Stormwind Gryphon Master'),(7,-8894,611.2,7,6,0,'Stormwind Vistor`s Center'),(8,-8876.48,649.18,7,6,0,'Stormwind Mailbox'),(9,-8433,554.7,7,6,0,'Jenova Stoneshield'),(10,-8797,612.8,7,6,0,'Woo Ping'),(11,-8759.92,399.69,7,6,0,'Champions` Hall'),(12,-8393.62,274.21,7,6,0,'Battlemasters Stormwind'),(13,-8743.15,660.36,7,6,0,'Stormwind Barber'),(14,-8751,1124.5,7,6,0,'The Park'),(15,-8413,541.5,7,6,0,'Hunter Lodge'),(16,-9012,867.6,7,6,0,'Wizard`s Sanctum'),(17,-8577,881.7,7,6,0,'Cathedral Of Light'),(18,-8512,862.4,7,6,0,'Cathedral Of Light'),(19,-8753,367.8,7,6,0,'Stormwind - Rogue House'),(20,-9031.54,549.87,7,6,0,'Farseer Umbrua'),(21,-8948.91,998.35,7,6,0,'The Slaughtered Lamb'),(22,-8714.14,334.96,7,6,0,'Stormwind Barracks'),(23,-8988,759.6,7,6,0,'Alchemy Needs'),(24,-8424,616.9,7,6,0,'Therum Deepforge'),(25,-8611,364.6,7,6,0,'Pig and Whistle Tavern'),(26,-8858,803.7,7,6,0,'Lucan Cordell'),(27,-8347,644.1,7,6,0,'Lilliam Sparkspindle'),(28,-8513,801.8,7,6,0,'Shaina Fuller'),(29,-8803,767.5,7,6,0,'Arnold Leland'),(30,-8967,779.5,7,6,0,'Alchemy Needs'),(31,-8853.33,857.66,7,6,0,'Stormwind Inscription'),(32,-8726,477.4,7,6,0,'The Protective Hide'),(33,-8434,692.8,7,6,0,'Gelman Stonehand'),(34,-8716,469.4,7,6,0,'The Protective Hide'),(35,-8938,800.7,7,6,0,'Duncan`s Textiles'),(36,9861.23,2334.55,7,6,0,'Darnassus Auction House'),(37,9938.45,2512.35,7,6,0,'Darnassus Bank'),(38,9945.65,2618.94,7,6,0,'Rut\'theran Village'),(39,10076.4,2199.59,7,6,0,'Darnassus Guild Master'),(40,10133.3,2222.52,7,6,0,'Darnassus Inn'),(41,9942.17,2495.48,7,6,0,'Darnassus Mailbox'),(42,10167.2,2522.66,7,6,0,'Alassin'),(43,9907.11,2329.7,7,6,0,'Ilyenia Moonfire'),(44,9981.9,2325.9,7,6,0,'Battlemasters Darnassus'),(45,10186,2570.46,7,6,0,'Darnassus Druid Trainer'),(46,10177.3,2511.1,7,6,0,'Darnassus Hunter Trainer'),(47,9659.12,2524.88,7,6,0,'Temple of the Moon'),(48,10122,2599.12,7,6,0,'Darnassus Rogue Trainer'),(49,9951.91,2280.38,7,6,0,'Warrior\'s Terrace'),(50,10075.9,2356.76,7,6,0,'Darnassus Alchemy Trainer'),(51,10088.6,2419.21,7,6,0,'Darnassus Cooking Trainer'),(52,10146.1,2313.42,7,6,0,'Darnassus Enchanting Trainer'),(53,10150.1,2390.43,7,6,0,'Darnassus First Aid Trainer'),(54,9836.2,2432.17,7,6,0,'Darnassus Fishing Trainer'),(55,9757.17,2430.16,7,6,0,'Darnassus Herbalism Trainer'),(56,10146.1,2313.42,7,6,0,'Darnassus Inscription Trainer'),(57,10086.6,2255.77,7,6,0,'Darnassus Leatherworking Trainer'),(58,10081.4,2257.18,7,6,0,'Darnassus Skinning Trainer'),(59,10079.7,2268.19,7,6,0,'Darnassus Tailor'),(60,10146.1,2313.42,7,6,0,'Darnassus Inscription Trainer'),(61,-9459.34,42.08,99,6,0,'Lion\'s Pride Inn'),(62,-9466.62,45.87,99,6,0,'Erma'),(63,-9471.12,33.44,7,6,0,'Zaldimar Wefhellt'),(64,-9469,108.05,7,6,0,'Brother Wilhelm'),(65,-9461.07,32.6,7,6,0,'Priestess Josetta'),(66,-9465.13,13.29,7,6,0,'Keryn Sylvius'),(67,-9473.21,-4.08,7,6,0,'Maximillian Crowe'),(68,-9461.82,109.5,7,6,0,'Lyria DuLac'),(69,-9057.04,153.63,7,6,0,'Alchemist Mallory'),(70,-9456.58,87.9,7,6,0,'Smith Argus'),(71,-9467.54,-3.16,7,6,0,'Tomas'),(72,-9456.82,30.49,7,6,0,'Michelle Belle'),(73,-9386.54,-118.73,7,6,0,'Lee Brown'),(74,-9060.7,149.23,7,6,0,'Herbalist Pomeroy'),(75,-8853.33,857.66,7,6,0,'Stormwind Inscription'),(76,-9376.12,-75.23,7,6,0,'Adele Fielder'),(77,-9536.91,-1212.76,7,6,0,'Helene Peltskinner'),(78,-9376.12,-75.23,7,6,0,'Eldrin'),(79,1595.64,232.45,7,6,0,'Undercity Bank'),(80,1565.9,271.43,7,6,0,'Undercity Bat Handler'),(81,1594.17,205.57,7,6,0,'Undercity Guild Master'),(82,1639.43,220.99,7,6,0,'Undercity Inn'),(83,1632.68,219.4,7,6,0,'Undercity Mailbox'),(84,1647.9,258.49,7,6,0,'Undercity Auction House'),(85,2059,274.86,7,6,0,'Undercity Zeppelin'),(86,1670.31,324.66,7,6,0,'Archibald'),(87,1634.18,226.76,7,6,0,'Anya Maulray'),(88,1300.33,350.92,7,6,0,'Battlemasters Undercity'),(89,1781,53,7,6,0,'Undercity Mage Trainers'),(90,1298.98,316.51,7,6,0,'Champion Cyssa Downrose'),(91,1758.33,401.5,7,6,0,'Undercity Priest Trainers'),(92,1418.56,65,7,6,0,'Undercity Rogue Trainers'),(93,1780.92,53.16,7,6,0,'Undercity Warlock Trainers'),(94,1775.59,418.19,7,6,0,'Undercity Warrior Trainers'),(95,1419.82,417.19,7,6,0,'The Apothecarium'),(96,1696,285,7,6,0,'Undercity Blacksmithing Trainer'),(97,1596.34,274.68,7,6,0,'Undercity Cooking Trainer'),(98,1488.54,280.19,7,6,0,'Undercity Enchanting Trainer'),(99,1408.58,143.43,7,6,0,'Undercity Engineering Trainer'),(100,1519.65,167.19,7,6,0,'Undercity First Aid Trainer'),(101,1679.9,89,7,6,0,'Undercity Fishing Trainer'),(102,1558,349.36,7,6,0,'Undercity Herbalism Trainer'),(103,1498.76,196.43,7,6,0,'Undercity Leatherworking Trainer'),(104,1642.88,335.58,7,6,0,'Undercity Mining Trainer'),(105,1498.6,196.46,7,6,0,'Undercity Skinning Trainer'),(106,1689.55,193,7,6,0,'Undercity Tailoring Trainer'),(107,1632.68,219.4,7,99,0,'Undercity Locksmith'),(108,1647.9,258.49,7,99,0,'Undercity Auction House'),(109,1595.64,232.45,7,99,0,'Undercity Bank'),(110,1576.2,193.14,7,99,0,'Undercity Barber'),(111,1565.9,271.43,7,99,0,'Undercity Bat Handler'),(112,1300.33,350.92,7,99,0,'Battlemasters Undercity'),(113,1594.17,205.57,7,99,0,'Undercity Guild Master'),(114,1639.43,220.99,7,99,0,'Undercity Inn'),(115,1499.68,53.28,7,99,0,'Undercity Locksmith'),(116,1632.68,219.4,7,99,0,'Undercity Mailbox'),(117,1634.18,226.76,7,99,0,'Anya Maulray'),(118,1670.31,324.66,7,99,0,'Archibald'),(119,2059,274.86,7,99,0,'Undercity Zeppelin'),(120,1781,53,7,99,0,'Undercity Mage Trainers'),(121,1298.98,316.51,7,99,0,'Champion Cyssa Downrose'),(122,1758.33,401.5,7,99,0,'Undercity Priest Trainers'),(123,1418.56,65,7,99,0,'Undercity Rogue Trainers'),(124,1780.92,53.16,7,99,0,'Undercity Warlock Trainers'),(125,1775.59,418.19,7,99,0,'Undercity Warrior Trainers'),(126,1419.82,417.19,7,99,0,'The Apothecarium'),(127,1696,285,7,99,0,'Undercity Blacksmithing Trainer'),(128,1596.34,274.68,7,99,0,'Undercity Cooking Trainer'),(129,1488.54,280.19,7,99,0,'Undercity Enchanting Trainer'),(130,1408.58,143.43,7,99,0,'Undercity Engineering Trainer'),(131,1519.65,167.19,7,99,0,'Undercity First Aid Trainer'),(132,1679.9,89,7,99,0,'Undercity Fishing Trainer'),(133,1558,349.36,7,99,0,'Undercity Herbalism Trainer'),(134,1558,349.36,7,99,0,'Undercity Inscription'),(135,1498.76,196.43,7,99,0,'Undercity Leatherworking Trainer'),(136,1642.88,335.58,7,99,0,'Undercity Mining Trainer'),(137,1498.6,196.46,7,99,0,'Undercity Skinning Trainer'),(138,1689.55,193,7,99,0,'Undercity Tailoring Trainer'),(139,9821.49,960.13,7,6,0,'Dolanaar Inn'),(140,9808.37,931.1,7,6,0,'Seriadne'),(141,9741.58,963.7,7,6,0,'Kal'),(142,9815.12,926.28,7,6,0,'Dazalar'),(143,9906.16,986.63,7,6,0,'Laurna Morning light'),(144,9789,942.86,7,6,0,'Jannok Breezesong'),(145,9821.96,950.61,7,6,0,'Kyra Windblade'),(146,9767.59,878.81,7,6,0,'Cyndra Kindwhisper'),(147,9751.19,906.13,7,6,0,'Zarrin'),(148,10677.6,1946.56,7,6,0,'Alanna Raveneye'),(149,9903.12,999,7,6,0,'Byancie'),(150,9773.78,875.88,7,6,0,'Malorne Bladeleaf'),(151,10146.1,2313.42,7,6,0,'Darnassus Inscription Trainer'),(152,10152.6,1681.46,7,6,0,'Nadyia Maneweaver'),(153,10135.6,1673.18,7,6,0,'Radnaal Maneweaver'),(154,9378.45,-7163.94,7,6,0,'Silvermoon City, Flight Master'),(155,9480.75,-7345.59,7,6,0,'Silvermoon City, GuildMaster'),(156,9743.08,-7466.4,7,6,0,'Silvermoon City, Mailbox'),(157,9904.95,-7404.31,7,6,0,'Silvermoon City, Stable Master'),(158,9841.17,-7505.13,7,6,0,'Silvermoon City, Weapon Master'),(159,9850.74,-7563.84,7,6,0,'Silvermoon City, Battlemasters'),(160,9751.01,-7074.85,7,6,0,'Silvermoon City, Mana Loom'),(161,9649.43,-7134.03,7,6,0,'Silvermoon City, Auction House'),(162,9682.86,-7515.79,7,6,0,'Silvermoon City, Auction House'),(163,9522.1,-7208.88,7,6,0,'Silvermoon City, Bank'),(164,9791.07,-7488.04,7,6,0,'Silvermoon City, Bank'),(165,9677.11,-7367.58,7,6,0,'Silvermoon City, Inn'),(166,9562.81,-7218.63,7,6,0,'Silvermoon City, Inn'),(167,9700.55,-7262.57,7,6,0,'Silvermoon City, Druid Trainer'),(168,9930.57,-7412.12,7,6,0,'Silvermoon City, Hunter Trainer'),(169,9996.91,-7104.8,7,6,0,'Silvermoon City, Mage Trainer'),(170,9850.22,-7516.93,7,6,0,'Silvermoon City, Paladin Trainer'),(171,9935.37,-7131.14,7,6,0,'Silvermoon City, Priest Trainer'),(172,9739.88,-7374.33,7,6,0,'Silvermoon City, Rogue Trainer'),(173,9803.05,-7316.97,7,6,0,'Silvermoon City, Warlock Trainer'),(174,10000.9,-7216.63,7,6,0,'Silvermoon City, Alchemy'),(175,9841.43,-7361.53,7,6,0,'Silvermoon City, Blacksmithing'),(176,9577.26,-7243.6,7,6,0,'Silvermoon City, Cooking'),(177,9962.57,-7246.18,7,6,0,'Silvermoon City, Enchanting'),(178,9808.85,-7287.31,7,6,0,'Silvermoon City, Engineering'),(179,9588.61,-7337.53,7,6,0,'Silvermoon City, First Aid'),(180,9601.97,-7332.34,7,6,0,'Silvermoon City, Fishing'),(181,9996.96,-7208.39,7,6,0,'Silvermoon City, Herbalism'),(182,9957.12,-7242.85,7,6,0,'Silvermoon City, Inscription'),(183,9552.8,-7502.12,7,6,0,'Silvermoon City, Jewelcrafting'),(184,9502.49,-7425.51,7,6,0,'Silvermoon City, Leatherworking'),(185,9813.73,-7360.19,7,6,0,'Silvermoon City, Mining'),(186,9513.37,-7429.4,7,6,0,'Silvermoon City, Skinning'),(187,9727.56,-7086.65,7,6,0,'Silvermoon City, Tailoring'),(188,9957.12,-7242.85,7,6,0,'Silvermoon City, Inscription'),(189,-4013.82,-11729.6,7,6,0,'Exodar, Auctioneer'),(190,-3923.89,-11544.5,7,6,0,'Exodar, bank'),(191,-4058.45,-11789.7,7,6,0,'Exodar, Hippogryph Master'),(192,-4093.38,-11630.4,7,6,0,'Exodar, Guild Master'),(193,-3765.34,-11695.8,7,6,0,'Exodar, Inn'),(194,-3913.75,-11606.8,7,6,0,'Exodar, Mailbox'),(195,-3787.01,-11702.7,7,6,0,'Exodar, Stable Master'),(196,-4215.68,-11628.9,7,6,0,'Exodar, Weapon Master'),(197,-3999.82,-11368.3,7,6,0,'Exodar, Battlemasters'),(198,-3725.25,-11688.3,7,6,0,'Arena Battlemaster Exodar'),(199,-4274.81,-11495.3,7,6,0,'Exodar, Druid Trainer'),(200,-4229.36,-11563.4,7,6,0,'Exodar, Hunter Trainers'),(201,-4048.8,-11559,7,6,0,'Exodar, Mage Trainers'),(202,-4176.57,-11476.5,7,6,0,'Exodar, Paladin Trainers'),(203,-3972.38,-11483.2,7,6,0,'Exodar, Priest Trainers'),(204,-3843.8,-11390.8,7,6,0,'Exodar, Shaman Trainer'),(205,-4191.11,-11650.5,7,6,0,'Exodar, Warrior Trainers'),(206,-4042.37,-11366.3,7,6,0,'Exodar, Alchemist Trainers'),(207,-4232.4,-11705.2,7,6,0,'Exodar, Blacksmithing Trainers'),(208,-3889.3,-11495,7,6,0,'Exodar, Enchanters'),(209,-4257.93,-11636.5,7,6,0,'Exodar, Engineering'),(210,-3766.05,-11481.8,7,6,0,'Exodar, First Aid Trainer'),(211,-3726.64,-11384.4,7,6,0,'Exodar, Fishing Trainer'),(212,-4052.5,-11356.6,7,6,0,'Exodar, Herbalism Trainer'),(213,-3889.3,-11495,7,6,0,'Exodar, Inscription'),(214,-3786.27,-11541.3,7,6,0,'Exodar, Jewelcrafters'),(215,-4134.42,-11772.9,7,6,0,'Exodar, Leatherworking'),(216,-4220.31,-11694.3,7,6,0,'Exodar, Mining Trainers'),(217,-4134.97,-11760.5,7,6,0,'Exodar, Skinning Trainer'),(218,-4095.78,-11746.9,7,6,0,'Exodar, Tailors'),(219,-3799.69,-11650.5,7,6,0,'Exodar, Cook'),(220,-3889.3,-11495,7,6,0,'Exodar, Inscription'),(221,1631.51,-4375.33,7,6,0,'Bank of Orgrimmar'),(222,1676.6,-4332.72,7,6,0,'TheSky Tower'),(223,1576.93,-4294.75,7,6,0,'Horde Embassy'),(224,1644.51,-4447.27,7,6,0,'Orgrimmar Inn'),(225,1622.53,-4388.79,7,6,0,'Orgrimmar Mailbox'),(226,1679.21,-4450.1,7,6,0,'Orgrimmar Auction House'),(227,1337.36,-4632.7,7,6,0,'Orgrimmar Zeppelin Tower'),(228,2092.56,-4823.95,7,6,0,'Sayoc & Hanashi'),(229,2133.12,-4663.93,7,6,0,'Xon\'cha'),(230,1633.56,-4249.37,7,6,0,'Hall of Legends'),(231,1990.41,-4794.15,7,6,0,'Battlemasters Orgrimmar'),(232,2114.84,-4625.31,7,6,0,'Orgrimmar Hunter\'s Hall'),(233,1451.26,-4223.33,7,6,0,'Darkbriar Lodge'),(234,1442.21,-4183.24,7,6,0,'Spirit Lodge'),(235,1925.34,-4181.89,7,6,0,'Thrall\'s Fortress'),(236,1773.39,-4278.97,7,6,0,'Shadowswift Brotherhood'),(237,1849.57,-4359.68,7,6,0,'Darkfire Enclave'),(238,1983.92,-4794.2,7,6,0,'Hall of the Brave'),(239,1937.53,-4141,7,6,0,'Thrall\'s Fortress'),(240,1955.17,-4475.79,7,6,0,'Yelmak\'s Alchemy and Potions'),(241,2054.34,-4831.85,7,6,0,'TheBurning Anvil'),(242,1780.96,-4481.31,7,6,0,'Borstan\'s Firepit'),(243,1917.5,-4434.95,7,6,0,'Godan\'s Runeworks'),(244,2038.45,-4744.75,7,6,0,'Nogg\'s Machine Shop'),(245,1485.21,-4160.91,7,6,0,'Survival of the Fittest'),(246,1994.15,-4655.7,7,6,0,'Lumak\'s Fishing'),(247,1898.61,-4454.93,7,6,0,'Jandi\'s Arboretum'),(248,1852.82,-4562.31,7,6,0,'Kodohide Leatherworkers'),(249,2029.79,-4704,7,6,0,'RedCanyon Mining'),(250,1852.82,-4562.31,7,6,0,'Kodohide Leatherworkers'),(251,1802.66,-4560.66,7,6,0,'Magar\'s Cloth Goods'),(252,-1257.8,24.14,7,6,0,'Thunder Bluff Bank'),(253,-1196.43,28.26,7,6,0,'Wind Rider Roost'),(254,-1296.5,127.57,7,6,0,'Thunder Bluff Civic Information'),(255,-1296,39.7,7,6,0,'Thunder Bluff Inn'),(256,-1263.59,44.36,7,6,0,'Thunder Bluff Mailbox'),(257,-1205.51,105.74,7,6,0,'Thunder Bluff Auctionhouse'),(258,-1282.31,89.56,7,6,0,'Ansekhwa'),(259,-1270.19,48.84,7,6,0,'Bulrug'),(260,-1391.22,-81.33,7,6,0,'Battlemasters Thunder Bluff'),(261,-1054.47,-285,7,6,0,'Hall of Elders'),(262,-1416.32,-114.28,7,6,0,'Hunter\'s Hall'),(263,-1061.2,195.5,7,6,0,'Pools of Vision'),(264,-1061.2,195.5,7,6,0,'Pools of Vision'),(265,-989.54,278.25,7,6,0,'Hall of Spirits'),(266,-1416.32,-114.28,7,6,0,'Hunter\'s Hall'),(267,-1085.56,27.29,7,6,0,'Bena\'s Alchemy'),(268,-1239.75,104.88,7,6,0,'Karn\'s Smithy'),(269,-1214.5,-21.23,7,6,0,'Aska\'s Kitchen'),(270,-1112.65,48.26,7,6,0,'Dawnstrider Enchanters'),(271,-996.58,200.5,7,6,0,'Spiritual Healing'),(272,-1169.35,-68.87,7,6,0,'Mountaintop Bait & Tackle'),(273,-1137.7,-1.51,7,6,0,'Holistic Herbalism'),(274,-1156.22,66.86,7,6,0,'Thunder Bluff Armorers'),(275,-1249.17,155,7,6,0,'Stonehoof Geology'),(276,-1148.56,51.18,7,6,0,'Mooranta'),(277,-1156.22,66.86,7,6,0,'Thunder Bluff Armorers'),(278,-2361.38,-349.19,7,6,0,'Bloodhoof Village Inn'),(279,-2338.86,-357.56,7,6,0,'Seikwa'),(280,-2312.15,-443.69,7,6,0,'Gennia Runetotem'),(281,-2178.14,-406.14,7,6,0,'Yaw Sharpmane'),(282,-2301.5,-439.87,7,6,0,'Narm Skychaser'),(283,-2345.43,-494.11,7,6,0,'Krang Stonehoof'),(284,-2263.34,-287.91,7,6,0,'Pyall Silentstride'),(285,-2353.52,-355.82,7,6,0,'Vira Younghoof'),(286,-2349.21,-241.37,7,6,0,'Uthan Stillwater'),(287,-2257.12,-288.63,7,6,0,'Chaw Stronghide'),(288,-2252.94,-291.32,7,6,0,'Yonn Deepcut'),(289,338.7,-4688.87,7,6,0,'Razor Hill Inn'),(290,330.31,-4710.66,7,6,0,'Shoja\'my'),(291,276,-4706.72,7,6,0,'Thotar'),(292,-839.33,-4935.6,7,6,0,'Un\'Thuwa'),(293,296.22,-4828.1,7,6,0,'Tai\'jin'),(294,265.76,-4709,7,6,0,'Kaplak'),(295,307.79,-4836.97,7,6,0,'Swart'),(296,355.88,-4836.45,7,6,0,'Dhugru Gorelust'),(297,312.3,-4824.66,7,6,0,'Tarshaw Jaggedscar'),(298,-800.25,-4894.33,7,6,0,'Miao\'zan'),(299,373.24,-4716.45,7,6,0,'Dwukk'),(300,368.95,-4723.95,7,6,0,'Mukdrak'),(301,327.17,-4825.62,7,6,0,'Rawrk'),(302,-1065.48,-4777.43,7,6,0,'Lau\'Tiki'),(303,-836.25,-4896.89,7,6,0,'Mishiki'),(304,366.94,-4705,7,6,0,'Krunn'),(305,-2252.94,-291.32,7,6,0,'Yonn Deepcut'),(306,2246.68,241.89,7,6,0,'Gallows` End Tavern'),(307,2267.66,319.32,7,6,0,'Morganus'),(308,2259.18,240.93,7,6,0,'Cain Firesong'),(309,2259.18,240.93,7,6,0,'Dark Cleric Beryl'),(310,2259.18,240.93,7,6,0,'Marion Call'),(311,2259.18,240.93,7,6,0,'Rupert Boch'),(312,2256.48,240.32,7,6,0,'Austil de Mon'),(313,2263.25,344.23,7,6,0,'Carolai Anise'),(314,2250.35,249.12,7,6,0,'Vance Undergloom'),(315,2246.68,241.89,7,6,0,'Nurse Neela'),(316,2292.37,-10.72,7,6,0,'Clyde Kellen'),(317,2268.21,331.69,7,6,0,'Faruza'),(318,2027,78.72,7,6,0,'Shelene Rhobart'),(319,2027,78.72,7,6,0,'Rand Rhobart'),(320,2160.45,659.93,7,6,0,'Bowen Brisboise'),(321,-4957.39,-911.6,7,6,0,'Ironforge Auction House'),(322,-4891.91,-991.47,7,6,0,'The Vault'),(323,-4835.27,-1294.69,7,6,0,'Deeprun Tram'),(324,-4821.52,-1152.3,7,6,0,'Ironforge Gryphon Master'),(325,-5021,-996.45,7,6,0,'Ironforge Visitor\'s Center'),(326,-4850.47,-872.57,7,6,0,'Stonefire Tavern'),(327,-4845.7,-880.55,7,6,0,'Ironforge Mailbox'),(328,-5010.2,-1262,7,6,0,'Ulbrek Firehand'),(329,-5040,-1201.88,7,6,0,'Bixiand Buliwyf'),(330,-5038.54,-1266.44,7,6,0,'Battlemasters Ironforge'),(331,-4838.49,-919.18,7,6,0,'Ironforge Barber'),(332,-5023,-1253.68,7,6,0,'Hall of Arms'),(333,-4627,-926.45,7,6,0,'Hall of Mysteries'),(334,-4627.02,-926.45,7,6,0,'Hall of Mysteries'),(335,-4627,-926.45,7,6,0,'Hall of Mysteries'),(336,-4647.83,-1124,7,6,0,'Ironforge Rogue Trainer'),(337,-4605,-1110.45,7,6,0,'Ironforge Warlock Trainer'),(338,-5023.08,-1253.68,7,6,0,'Hall of Arms'),(339,-4722.02,-1150.66,7,6,0,'Ironforge Shaman Trainer'),(340,-4858.5,-1241.83,7,6,0,'Berryfizz\'s Potions and Mixed Drinks'),(341,-4796.97,-1110.17,7,6,0,'The Great Forge'),(342,-4767.83,-1184.59,7,6,0,'The Bronze Kettle'),(343,-4803.72,-1196.53,7,6,0,'Thistlefuzz Arcanery'),(344,-4799.56,-1250.23,7,6,0,'Springspindle\'s Gadgets'),(345,-4881.6,-1153.13,7,6,0,'Ironforge Physician'),(346,-4597.91,-1091.93,7,6,0,'Traveling Fisherman'),(347,-4876.9,-1151.92,7,6,0,'Ironforge Physician'),(348,-4801.72,-1189.41,7,6,0,'Ironforge Inscription'),(349,-4745,-1027.57,7,6,0,'Finespindle\'s Leather Goods'),(350,-4705.06,-1116.43,7,6,0,'Deepmountain Mining Guild'),(351,-4745,-1027.57,7,6,0,'Finespindle\'s Leather Goods'),(352,-4719.6,-1056.96,7,6,0,'Stonebrow\'s Clothier'),(353,-4801.72,-1189.41,7,6,0,'Ironforge Inscription'),(354,-5582.66,-525.89,7,6,0,'Thunderbrew Distillery'),(355,-5604,-509.58,7,6,0,'Shelby Stoneflint'),(356,-5618.29,-454.25,7,6,0,'Grif Wildheart'),(357,-5585.6,-539.99,7,6,0,'Magis Sparkmantle'),(358,-5585.6,-539.99,7,6,0,'Azar Stronghammer'),(359,-5591.74,-525.61,7,6,0,'Maxan Anvol'),(360,-5602.75,-542.4,7,6,0,'Hogral Bakkan'),(361,-5641.97,-523.76,7,6,0,'Gimrizz Shadowcog'),(362,-5604.79,-529.38,7,6,0,'Granis Swiftaxe'),(363,-5584.72,-428.41,7,6,0,'Tognus Flintfire'),(364,-5596.85,-541.43,7,6,0,'Gremlock Pilsnor'),(365,-5603.67,-523.57,7,6,0,'Thamner Pol'),(366,-5202.39,-51.36,7,6,0,'Paxton Ganter'),(367,-4801.72,-1189.41,7,6,0,'Ironforge Inscription'),(368,-5531,-666.53,7,6,0,'Yarr Hamerstone'),(369,9376.4,-7164.92,7,6,0,'Silvermoon City, Flight Master'),(370,9476.92,-6859.2,7,6,0,'Falconwing Square, Innkeeper'),(371,9487.6,-6830.59,7,6,0,'Falconwing Square, Stable Master'),(372,9529.2,-6864.58,7,6,0,'Falconwing Square, Hunter Trainer'),(373,9462.24,-6853.45,7,6,0,'Falconwing Square, Mage Trainer'),(374,9516.05,-6870.96,7,6,0,'Falconwing Square, Paladin Trainer'),(375,9466.62,-6844.23,7,6,0,'Falconwing Square, Priest Trainer'),(376,9534.15,-6876,7,6,0,'Falconwing Square, Rogue Trainer'),(377,9467.63,-6862.82,7,6,0,'Falconwing Square, Warlock Trainer'),(378,8661.36,-6367,7,6,0,'Saltheril\'s Haven, Alchemist'),(379,8986.43,-7419.07,7,6,0,'Farstrider Retreat, Blacksmith'),(380,9494.86,-6879.45,7,6,0,'Falconwing Square, Cook'),(381,8657.6,-6366.7,7,6,0,'Saltheril\'s Haven, Enchanter'),(382,9479.53,-6880.07,7,6,0,'Falconwing Square, FirstAid'),(383,8678.92,-6329.09,7,6,0,'Saltheril\'s Haven, Herbalist'),(384,9484.79,-6876.58,7,6,0,'Falconwing Square, Jewelcrafter'),(385,9363.75,-7130.75,7,6,0,'Eversong Woods, Leatherworker'),(386,9362.89,-7134.58,7,6,0,'Eversong Woods, Skinner'),(387,8680.36,-6327.51,7,6,0,'Saltheril\'s Haven, Tailor'),(388,-4127.81,-12467.7,7,6,0,'Azure Watch, Innkeeper'),(389,-4146.42,-12492.7,7,6,0,'Azure Watch, Stable Master'),(390,-4203.65,-12467.7,7,6,0,'Azure Watch, Hunter Trainer'),(391,-4149.62,-12530.1,7,6,0,'Azure Watch, Mage Trainer'),(392,-4138.98,-12468.5,7,6,0,'Azure Watch, Paladin Trainer'),(393,-4131.66,-12478.6,7,6,0,'Azure Watch, Priest Trainer'),(394,-4162.33,-12456.1,7,6,0,'Azure Watch, Shaman Trainer'),(395,-4165.05,-12536.4,7,6,0,'Azure Watch, Warrior Trainer'),(396,-4191.15,-12470,7,6,0,'Azure Watch, Alchemist'),(397,-4726.29,-12387,7,6,0,'Odesyus\' Landing, Blacksmith'),(398,-4708.59,-12400.3,7,6,0,'Odesyus\' Landing, Cook'),(399,-4157.57,-12470.2,7,6,0,'Azure Watch, Engineering Trainer'),(400,-4199.1,-12469.9,7,6,0,'Azure Watch, First Aid Trainer'),(401,-4266.34,-12985.4,7,6,0,'Ammen Ford, Fisherwoman'),(402,-4189.43,-12459.4,7,6,0,'Azure Watch, Herbalist'),(403,-3889.3,-11495,7,6,0,'Exodar, Inscription'),(404,-3442.68,-12322.2,7,6,0,'Stillpine Hold, Leatherworker'),(405,-4179.89,-12493.1,7,6,0,'Azure Watch, Mining Trainer'),(406,-3431.17,-12316.5,7,6,0,'Stillpine Hold, Skinner'),(407,-4711.54,-12386.7,7,6,0,'Odesyus\' Landing, Tailor'),(408,-1760.4,5166.9,7,6,0,'World\'s End Tavern'),(409,-1831.9,5298.2,7,6,0,'Gryphon Master'),(410,-2073.9,5265.7,7,6,0,'Mana Loom'),(411,-1648.1,5537.3,7,6,0,'Alchemy Lab'),(412,-1730.8,5496.2,7,6,0,'Aldor Bank'),(413,-1999.6,5362,7,6,0,'Scryers Bank'),(414,-1897.5,5767.6,7,6,0,'Aldor inn'),(415,-2180.6,5403.9,7,6,0,'Scryers inn'),(416,-1886.9,5761.5,7,6,0,'Aldor Inn'),(417,-2175,5411.7,7,6,0,'Scryers Bank'),(418,-1695.5,5521.8,7,6,0,'Aldor Bank'),(419,-2033,5336.1,7,6,0,'Scryers Inn'),(420,-1889.6,5761.5,7,6,0,'Aldor Stable'),(421,-2170,5404.6,7,6,0,'Scryers Stable'),(422,-1831.9,5298.2,7,6,0,'Alliance Battlemasters'),(423,-1968.7,5262.2,7,6,0,'Horde & Arena Battlemasters'),(424,-1661,5538,7,6,0,'Alchemy Trainer'),(425,-1847.7,5230.3,7,6,0,'Blacksmithing Trainer'),(426,-2067.4,5316.5,7,6,0,'Cooking Trainer'),(427,-2278.5,5567.7,7,6,0,'Enchanting Trainer'),(428,-1592,5263.7,7,6,0,'First Aid Trainer'),(429,-1653.3,5665.1,7,6,0,'Jewelcrafting Trainer'),(430,-2060.9,5256.6,7,6,0,'Leatherworking Trainer'),(431,-2047.9,5299.6,7,6,0,'Skinning Trainer'),(432,-1649.3,5668.6,7,6,0,'Aldorgemmerchant'),(433,-2193.9,5422.1,7,6,0,'Scryersgemmerchant'),(434,5889.67,621.21,7,99,0,'Barber'),(435,5815.91,453.64,7,99,0,'Flight Master'),(436,5762.21,622.84,7,99,0,'Guild Master'),(437,5859.68,557.57,7,99,0,'Stable Master'),(438,5801.77,551.07,7,99,0,'Eastern Sewer Entrance'),(439,5815.21,762.65,7,99,0,'Western Sewer Entrance'),(440,5791.6,561.82,7,99,0,'Well Entrance'),(441,5763.2,711.77,7,99,0,'The Alliance Quarter'),(442,5860.35,592.97,7,99,0,'The Horde Quarter'),(443,5979.58,608.16,7,99,0,'Northern Bank'),(444,5631.2,694.15,7,99,0,'Southern Bank'),(445,5766.31,731.66,7,99,0,'Sewers'),(446,5718.01,689.28,7,99,0,'Alliance Inn'),(447,5890.22,500.58,7,99,0,'Horde Inn'),(448,5761.06,714.45,7,99,0,'Sewers'),(449,5795.11,769.15,7,99,0,'The Violet Citadel'),(450,5720.4,537.46,7,99,0,'The Violet Hold'),(451,5900.88,726.65,7,99,0,'Trade District'),(452,5951.74,683.53,7,99,0,'Antonidas Memorial'),(453,5810.96,632.72,7,99,0,'Runeweaver Square'),(454,5694.66,650.82,7,99,0,'The Eventide'),(455,5853.35,769.06,7,99,0,'Cemetary'),(456,5860.99,707.23,7,99,0,'Lexicon of Power'),(457,5810.07,581,7,99,0,'Portal Trainer'),(458,5793.11,686.44,7,99,0,'Clothing'),(459,5772.27,576.61,7,99,0,'Flowers'),(460,5754.02,694.18,7,99,0,'Fruit'),(461,5681.22,616.57,7,99,0,'General Goods'),(462,5874.27,719.18,7,99,0,'Portal Trainer'),(463,5833.13,572.72,7,99,0,'Pet Supplies & Exotic Mounts'),(464,5905.86,629.29,7,99,0,'Pie, Pastry & Cakes'),(465,5758.7,737.24,7,99,0,'Reagents & Magical Goods'),(466,5813.48,688.49,7,99,0,'Toys'),(467,5755.53,642.03,7,99,0,'Trinkets, Relics & Off-hand items'),(468,5885.66,606.89,7,99,0,'Wine & Cheese'),(469,5888.05,702.44,7,99,0,'Alchemy'),(470,5904.86,680.12,7,99,0,'Blacksmithing'),(471,5840.01,726.53,7,99,0,'Enchanting'),(472,5922.55,727.05,7,99,0,'Engineering'),(473,5862.76,743.71,7,99,0,'FirstAid'),(474,5707.45,614.57,7,99,0,'Fishing'),(475,5873.99,689.44,7,99,0,'Herbalism'),(476,5861.8,704.3,7,99,0,'Inscription'),(477,5874.27,719.18,7,99,0,'Jewelcrafting'),(478,5903.9,751.97,7,99,0,'Leatherworking'),(479,5923.27,709.86,7,99,0,'Mining'),(480,5903.9,751.97,7,99,0,'Skinning'),(481,5881.78,746.64,7,99,0,'Tailoring'),(482,5793.11,686.44,7,99,0,'Cloth Armor'),(483,5667.76,627.16,7,99,0,'Leather Armor'),(484,5667.76,627.16,7,99,0,'Mail Armor'),(485,5914.85,667.22,7,99,0,'Plate Armor'),(486,5914.85,667.22,7,99,0,'Shields'),(487,5725.11,602.57,7,99,0,'Melee Weapons'),(488,5778.5,556.18,7,99,0,'Ranged & Thrown Weapons'),(489,5665.4,644.91,7,99,0,'Staves & Wands'),(490,5815.91,453.64,7,99,0,'Krasus\' Landing'),(491,5752,645.427,7,99,0,'Dalaran Trinkets'),(492,5815.91,453.64,7,99,0,'Flight Master'),(493,5934,575.626,7,99,0,'Dalaran Locksmith'); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;