DB/Misc: Update access_requirement comments to map.dbc content

Closes #19810 by ForesterDev

1 files changed, 122 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2017_06_06_00_world.sql b/sql/updates/world/3.3.5/2017_06_06_00_world.sql
new file mode 100644
index 00000000000..02111639151
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_06_06_00_world.sql
@@ -0,0 +1,122 @@
+-- instance descriptions from 3.3.5a Map.dbc
+UPDATE `access_requirement` SET `comment` = 'Shadowfang Keep' WHERE `mapId` = 33 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Stormwind Stockade' WHERE `mapId` = 34 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Deadmines' WHERE `mapId` = 36 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Wailing Caverns' WHERE `mapId` = 43 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Razorfen Kraul' WHERE `mapId` = 47 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Blackfathom Deeps' WHERE `mapId` = 48 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Uldaman' WHERE `mapId` = 70 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Gnomeregan' WHERE `mapId` = 90 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Sunken Temple' WHERE `mapId` = 109 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Razorfen Downs' WHERE `mapId` = 129 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Scarlet Monastery' WHERE `mapId` = 189 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Zul\'Farrak' WHERE `mapId` = 209 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Blackrock Spire' WHERE `mapId` = 229 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Blackrock Depths' WHERE `mapId` = 230 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Onyxia\'s Lair (10 player)' WHERE `mapId` = 249 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Onyxia\'s Lair (25 player)' WHERE `mapId` = 249 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Opening of the Dark Portal (Normal)' WHERE `mapId` = 269 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Opening of the Dark Portal (Heroic)' WHERE `mapId` = 269 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Scholomance' WHERE `mapId` = 289 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Zul\'Gurub' WHERE `mapId` = 309 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Stratholme' WHERE `mapId` = 329 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Maraudon' WHERE `mapId` = 349 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Ragefire Chasm' WHERE `mapId` = 389 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Molten Core' WHERE `mapId` = 409 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Dire Maul' WHERE `mapId` = 429 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Blackwing Lair' WHERE `mapId` = 469 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Ruins of Ahn\'Qiraj' WHERE `mapId` = 509 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Ahn\'Qiraj Temple' WHERE `mapId` = 531 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Karazhan' WHERE `mapId` = 532 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Naxxramas (10 player)' WHERE `mapId` = 533 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Naxxramas (25 player)' WHERE `mapId` = 533 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'The Battle for Mount Hyjal' WHERE `mapId` = 534 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Hellfire Citadel: The Shattered Halls (Normal)' WHERE `mapId` = 540 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Hellfire Citadel: The Shattered Halls (Heroic)' WHERE `mapId` = 540 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Hellfire Citadel: The Blood Furnace (Normal)' WHERE `mapId` = 542 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Hellfire Citadel: The Blood Furnace (Heroic)' WHERE `mapId` = 542 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Hellfire Citadel: Ramparts (Normal)' WHERE `mapId` = 543 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Hellfire Citadel: Ramparts (Heroic)' WHERE `mapId` = 543 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Magtheridon\'s Lair' WHERE `mapId` = 544 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Coilfang: The Steamvault (Normal)' WHERE `mapId` = 545 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Coilfang: The Steamvault (Heroic)' WHERE `mapId` = 545 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Coilfang: The Underbog (Normal)' WHERE `mapId` = 546 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Coilfang: The Underbog (Heroic)' WHERE `mapId` = 546 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Coilfang: The Slave Pens (Normal)' WHERE `mapId` = 547 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Coilfang: The Slave Pens (Heroic)' WHERE `mapId` = 547 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Coilfang: Serpentshrine Cavern' WHERE `mapId` = 548 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Tempest Keep' WHERE `mapId` = 550 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Tempest Keep: The Arcatraz (Normal)' WHERE `mapId` = 552 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Tempest Keep: The Arcatraz (Heroic)' WHERE `mapId` = 552 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Tempest Keep: The Botanica (Normal)' WHERE `mapId` = 553 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Tempest Keep: The Botanica (Heroic)' WHERE `mapId` = 553 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Tempest Keep: The Mechanar (Normal)' WHERE `mapId` = 554 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Tempest Keep: The Mechanar (Heroic)' WHERE `mapId` = 554 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Auchindoun: Shadow Labyrinth (Normal)' WHERE `mapId` = 555 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Auchindoun: Shadow Labyrinth (Heroic)' WHERE `mapId` = 555 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Auchindoun: Sethekk Halls (Normal)' WHERE `mapId` = 556 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Auchindoun: Sethekk Halls (Heroic)' WHERE `mapId` = 556 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Auchindoun: Mana-Tombs (Normal)' WHERE `mapId` = 557 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Auchindoun: Mana-Tombs (Heroic)' WHERE `mapId` = 557 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Auchindoun: Auchenai Crypts (Normal)' WHERE `mapId` = 558 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Auchindoun: Auchenai Crypts (Heroic)' WHERE `mapId` = 558 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'The Escape From Durnholde (Normal)' WHERE `mapId` = 560 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'The Escape From Durnholde (Heroic)' WHERE `mapId` = 560 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Black Temple' WHERE `mapId` = 564 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Gruul\'s Lair' WHERE `mapId` = 565 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Zul\'Aman' WHERE `mapId` = 568 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Utgarde Keep (Normal)' WHERE `mapId` = 574 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Utgarde Keep (Heroic)' WHERE `mapId` = 574 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Utgarde Pinnacle (Normal)' WHERE `mapId` = 575 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Utgarde Pinnacle (Heroic)' WHERE `mapId` = 575 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'The Nexus (Normal)' WHERE `mapId` = 576 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'The Nexus (Heroic)' WHERE `mapId` = 576 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'The Oculus (Normal)' WHERE `mapId` = 578 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'The Oculus (Heroic)' WHERE `mapId` = 578 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'The Sunwell' WHERE `mapId` = 580 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Magister\'s Terrace (Normal)' WHERE `mapId` = 585 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Magister\'s Terrace (Heroic)' WHERE `mapId` = 585 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'The Culling of Stratholme (Normal)' WHERE `mapId` = 595 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'The Culling of Stratholme (Heroic)' WHERE `mapId` = 595 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Halls of Stone (Normal)' WHERE `mapId` = 599 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Halls of Stone (Heroic)' WHERE `mapId` = 599 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Drak\'Tharon Keep (Normal)' WHERE `mapId` = 600 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Drak\'Tharon Keep (Heroic)' WHERE `mapId` = 600 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Azjol-Nerub (Normal)' WHERE `mapId` = 601 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Azjol-Nerub (Heroic)' WHERE `mapId` = 601 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Halls of Lightning (Normal)' WHERE `mapId` = 602 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Halls of Lightning (Heroic)' WHERE `mapId` = 602 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Ulduar (10 player)' WHERE `mapId` = 603 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Ulduar (25 player)' WHERE `mapId` = 603 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Gundrak (Normal)' WHERE `mapId` = 604 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Gundrak (Heroic)' WHERE `mapId` = 604 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Violet Hold (Normal)' WHERE `mapId` = 608 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Violet Hold (Heroic)' WHERE `mapId` = 608 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'The Obsidian Sanctum (10 player)' WHERE `mapId` = 615 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'The Obsidian Sanctum (25 player)' WHERE `mapId` = 615 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'The Eye of Eternity (10 player)' WHERE `mapId` = 616 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'The Eye of Eternity (25 player)' WHERE `mapId` = 616 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Ahn\'kahet: The Old Kingdom (Normal)' WHERE `mapId` = 619 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Ahn\'kahet: The Old Kingdom (Heroic)' WHERE `mapId` = 619 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Vault of Archavon (10 player)' WHERE `mapId` = 624 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Vault of Archavon (25 player)' WHERE `mapId` = 624 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Icecrown Citadel (10 player, Normal)' WHERE `mapId` = 631 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Icecrown Citadel (25 player, Normal)' WHERE `mapId` = 631 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Icecrown Citadel (10 player, Heroic)' WHERE `mapId` = 631 AND `difficulty` = 2;
+UPDATE `access_requirement` SET `comment` = 'Icecrown Citadel (25 player, Heroic)' WHERE `mapId` = 631 AND `difficulty` = 3;
+UPDATE `access_requirement` SET `comment` = 'The Forge of Souls (Normal)' WHERE `mapId` = 632 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'The Forge of Souls (Heroic)' WHERE `mapId` = 632 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Trial of the Crusader (10 player, Normal)' WHERE `mapId` = 649 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Trial of the Crusader (25 player, Normal)' WHERE `mapId` = 649 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Trial of the Crusader (10 player, Heroic)' WHERE `mapId` = 649 AND `difficulty` = 2;
+UPDATE `access_requirement` SET `comment` = 'Trial of the Crusader (25 player, Heroic)' WHERE `mapId` = 649 AND `difficulty` = 3;
+UPDATE `access_requirement` SET `comment` = 'Trial of the Champion (Normal)' WHERE `mapId` = 650 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Trial of the Champion (Heroic)' WHERE `mapId` = 650 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Pit of Saron (Normal)' WHERE `mapId` = 658 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Pit of Saron (Heroic)' WHERE `mapId` = 658 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'Halls of Reflection (Normal)' WHERE `mapId` = 668 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'Halls of Reflection (Heroic)' WHERE `mapId` = 668 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'The Ruby Sanctum (10 player, Normal)' WHERE `mapId` = 724 AND `difficulty` = 0;
+UPDATE `access_requirement` SET `comment` = 'The Ruby Sanctum (25 player, Normal)' WHERE `mapId` = 724 AND `difficulty` = 1;
+UPDATE `access_requirement` SET `comment` = 'The Ruby Sanctum (10 player, Heroic)' WHERE `mapId` = 724 AND `difficulty` = 2;
+UPDATE `access_requirement` SET `comment` = 'The Ruby Sanctum (25 player, Heroic)' WHERE `mapId` = 724 AND `difficulty` = 3;