From bb7233baa3b1b43584146e7883d32e53919f8502 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Thu, 10 Jul 2014 21:45:11 +0200 Subject: Core/LFG: Added support for display of required item level. for player / group member --- ...014_07_10_01_world_lfg_dungeon_template_434.sql | 55 ++++++++++++++++++++++ 1 file changed, 55 insertions(+) create mode 100644 sql/updates/world/2014_07_10_01_world_lfg_dungeon_template_434.sql (limited to 'sql') diff --git a/sql/updates/world/2014_07_10_01_world_lfg_dungeon_template_434.sql b/sql/updates/world/2014_07_10_01_world_lfg_dungeon_template_434.sql new file mode 100644 index 00000000000..1e2b7449337 --- /dev/null +++ b/sql/updates/world/2014_07_10_01_world_lfg_dungeon_template_434.sql @@ -0,0 +1,55 @@ +DROP TABLE IF EXISTS `lfg_entrances`; +ALTER TABLE `access_requirement` DROP `item_level`; + +DROP TABLE IF EXISTS `lfg_dungeon_template`; +CREATE TABLE IF NOT EXISTS `lfg_dungeon_template` ( + `dungeonId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Unique id from LFGDungeons.dbc', + `name` varchar(255) CHARACTER SET latin1 DEFAULT NULL, + `position_x` float NOT NULL DEFAULT '0', + `position_y` float NOT NULL DEFAULT '0', + `position_z` float NOT NULL DEFAULT '0', + `orientation` float NOT NULL DEFAULT '0', + `requiredItemLevel` smallint(5) NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) DEFAULT '0' +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +ALTER TABLE `lfg_dungeon_template` + ADD PRIMARY KEY (`dungeonId`); + +INSERT INTO `lfg_dungeon_template` (`dungeonId`, `name`, `position_x`, `position_y`, `position_z`, `orientation`, `requiredItemLevel`, `VerifiedBuild`) VALUES +(18, 'Scarlet Monastery - Graveyard', 1688.99, 1053.48, 18.6775, 0.00117, 0, 0), +(26, 'Maraudon - Orange Crystals', 1019.69, -458.31, -43.43, 0.31, 0, 0), +(34, 'Dire Maul - East', 44.4499, -154.822, -2.71201, 0, 0, 0), +(36, 'Dire Maul - West', -62.9658, 159.867, -3.46206, 3.14788, 0, 0), +(38, 'Dire Maul - North', 255.249, -16.0561, -2.58737, 4.7, 0, 0), +(40, 'Stratholme - Main Gate', 3395.09, -3380.25, 142.702, 0.1, 0, 0), +(163, 'Scarlet Monastery - Armory', 1610.83, -323.433, 18.6738, 6.28022, 0, 0), +(164, 'Scarlet Monastery - Cathedral', 855.683, 1321.5, 18.6709, 0.001747, 0, 0), +(165, 'Scarlet Monastery - Library', 255.346, -209.09, 18.6773, 6.26656, 0, 0), +(272, 'Maraudon - Purple Crystals', 752.91, -616.53, -33.11, 1.37, 0, 0), +(273, 'Maraudon - Pristine Waters', 495.702, 17.3372, -96.3128, 3.11854, 0, 0), +(274, 'Stratholme - Service Entrance', 3593.15, -3646.56, 138.5, 5.33, 0, 0), +(285, 'The Headless Horseman', 1797.52, 1347.38, 18.8876, 3.142, 0, 0), +(286, 'The Frost Lord Ahune', -100.396, -95.9996, -4.28423, 4.71239, 0, 0), +(287, 'Coren Direbrew', 897.495, -141.976, -49.7563, 2.1255, 0, 0), +(288, 'The Crown Chemical Co.', -238.075, 2166.43, 88.853, 1.13446, 0, 0), +(210, 'Culling of Stratholme Heroic', 0, 0, 0, 0, 180, 0), +(205, 'Utgarde Pinnacle Heroic', 0, 0, 0, 0, 180, 0), +(211, 'Oculus Heroic', 0, 0, 0, 0, 180, 0), +(212, 'Halls of Lightning Heroic', 0, 0, 0, 0, 180, 0), +(213, 'Halls of Stone Heroic', 0, 0, 0, 0, 180, 0), +(215, 'Drak''Tharon Keep Heroic', 0, 0, 0, 0, 180, 0), +(217, 'Gundrak Heroic', 0, 0, 0, 0, 180, 0), +(219, 'Ahn''kahet: The Old Kingdom Heroic', 0, 0, 0, 0, 180, 0), +(221, 'Violet Hold Heroic', 0, 0, 0, 0, 180, 0), +(226, 'The Nexus Heroic', 0, 0, 0, 0, 180, 0), +(241, 'Azjol-Nerub Heroic', 0, 0, 0, 0, 180, 0), +(242, 'Utgarde Keep Heroic', 0, 0, 0, 0, 180, 0), +(245, 'Trial of the Champion', 0, 0, 0, 0, 200, 0), +(249, 'Trial of the Champion Heroic', 0, 0, 0, 0, 200, 0), +(251, 'Forge of Souls', 0, 0, 0, 0, 200, 0), +(252, 'Forge of Souls Heroic', 0, 0, 0, 0, 200, 0), +(253, 'Pit of Saron', 0, 0, 0, 0, 200, 0), +(254, 'Pit of Saron Heroic', 0, 0, 0, 0, 200, 0), +(255, 'Halls of Reflection (Normal)', 5239.01, 1932.64, 707.695, 0.800565, 219, 0), +(256, 'Halls of Reflection (Heroic)', 5239.01, 1932.64, 707.695, 0.800565, 219, 0); -- cgit v1.2.3