DROP TABLE IF EXISTS `#__guild_master_conf`; DROP TABLE IF EXISTS `#__guild_master_heri_quests`; DROP TABLE IF EXISTS `#__guild_master_heri_steps`; DROP TABLE IF EXISTS `#__guild_master_toons`; DROP TABLE IF EXISTS `#__guild_master_guild`; CREATE TABLE `#__guild_master_toons` ( `Name` VARCHAR( 255 ) NOT NULL , `Last_name` VARCHAR( 255 ), `PrefixTitle` VARCHAR( 255 ), `Rank` VARCHAR( 20 ) NOT NULL default 'Initiate', `Race` VARCHAR( 255 ), `Rank_Value` INT NOT NULL , `Adv_Level` INT NOT NULL , `Art_Level` INT NOT NULL , `Art2_Level` INT NOT NULL , `Adv_Class` ENUM( 'Assassin', 'Bard', 'Berserker', 'Brawler', 'Brigand', 'Bruiser', 'Cleric', 'Coercer', 'Conjuror', 'Crusader', 'Defiler', 'Dirge', 'Druid', 'Enchanter', 'Fighter', 'Fury', 'Guardian', 'Illusionist', 'Inquisitor', 'Mage', 'Monk', 'Mystic', 'Necromancer', 'Paladin', 'Predator', 'Priest', 'Ranger', 'Rogue', 'Scout', 'Shadow Knight', 'Shaman', 'Sorceror ', 'Summoner', 'Swashbuckler', 'Templar', 'Troubador ', 'Warden', 'Warlock ', 'Warrior', 'Wizard ' ) NOT NULL , `Art_Class` ENUM( 'Alchemist', 'Armorer', 'Artisan', 'Carpenter', 'Craftsman', 'Jeweler', 'Outfitter', 'Provisioner', 'Sage', 'Scholar', 'Tailor', 'Weaponsmith', 'Woodworker' ) NOT NULL , `Art2_Class` ENUM( 'Transmuter', 'Tinkerer' ) , `Joined` DATETIME NOT NULL , `Points` INT NOT NULL , `Points_time` FLOAT, `toon_id` INT NOT NULL , `Quests` INT NOT NULL , `KvD` FLOAT NOT NULL , `lastonline` DATETIME, `highestmeleehit` INT, `highestmagichit` INT, `memberNumber` INT, `Last_Updated` TIMESTAMP , PRIMARY KEY ( `toon_id` )); CREATE TABLE `#__guild_master_conf` ( `id` INT NOT NULL AUTO_INCREMENT, `guild_name` VARCHAR( 255 ) NOT NULL , `guild_id` INT NOT NULL , `guild_rank_1` VARCHAR( 255 ) , `guild_rank_2` VARCHAR( 255 ) , `guild_rank_3` VARCHAR( 255 ) , `guild_rank_4` VARCHAR( 255 ) , `guild_rank_5` VARCHAR( 255 ) , `guild_rank_6` VARCHAR( 255 ) , `guild_rank_7` VARCHAR( 255 ) , `guild_rank_8` VARCHAR( 255 ) , `show_updated` BOOL NOT NULL , `guild_info` BOOL NOT NULL , `popup` BOOL NOT NULL , `use_images` BOOL NOT NULL , `show_lastnames` BOOL NOT NULL , `show_prefixtitles` BOOL NOT NULL , `roster_url` VARCHAR( 255 ), `roster_url_xml` VARCHAR( 255 ), `guild_url` VARCHAR( 255 ), `toon_url` VARCHAR( 255 ), `cache_time` INT NOT NULL , `hide_time` INT NOT NULL , PRIMARY KEY ( `id` )); CREATE TABLE `#__guild_master_guild` ( `guild_id` INT NOT NULL , `guild_name` VARCHAR( 255 ), `server_name` VARCHAR( 255 ), `server_id` INT, `created` DATETIME NOT NULL , `avg_level` INT NOT NULL , `avg_quests` INT NOT NULL , `members` INT NOT NULL , `unique_members` INT NOT NULL , `most_recent_item` VARCHAR( 255 ), `level` TINYINT NOT NULL , `points` INT NOT NULL , `item_disc_world` INT NOT NULL , `item_disc_server` INT NOT NULL , `rares` INT NOT NULL , `pvp_kills` INT NOT NULL , `npc_kills` INT NOT NULL , `arena_kills` INT NOT NULL , `avg_pvp_kills` INT NOT NULL , `avg_npc_kills` INT NOT NULL , `avg_arena_kills` INT NOT NULL , `items_crafted` INT NOT NULL , `deaths` INT, `deaths_per_member` FLOAT , `kvd` FLOAT NOT NULL , `kvd_rank` INT NOT NULL , `most_disc_server` VARCHAR( 255 ), `most_disc_world` VARCHAR( 255 ), `most_killed_npcs` VARCHAR( 255 ), `best_kvd` VARCHAR( 255 ), `most_quests` VARCHAR( 255 ), `most_points` VARCHAR( 255 ), `last_lvlup` VARCHAR( 255 ), `last_die` VARCHAR( 255 ), `fighters` INT , `priests` INT , `mages` INT , `scouts` INT , `Last_Updated` TIMESTAMP , PRIMARY KEY ( `guild_id` )); CREATE TABLE IF NOT EXISTS `#__guild_master_user` ( `toon_id` INT NOT NULL, `user_id` INT NOT NULL, PRIMARY KEY ( `toon_id` )); CREATE TABLE `#__guild_master_heri_quests` ( `heri_id` INT NOT NULL, `name_short` VARCHAR( 255 ) NOT NULL, `name` VARCHAR( 255 ), `url` VARCHAR( 255 ), `reward` VARCHAR( 255 ), `reward_url` VARCHAR( 255 ), `level` INT, `need_starter` BOOL, PRIMARY KEY ( `heri_id` )); CREATE TABLE `#__guild_master_heri_steps` ( `step_id` INT NOT NULL, `heri_id` INT NOT NULL, `name` VARCHAR( 255 ), PRIMARY KEY ( `step_id` )); CREATE TABLE IF NOT EXISTS `#__guild_master_heri_map` ( `step_id` INT NOT NULL, `toon_id` INT NOT NULL, PRIMARY KEY ( `step_id` , `toon_id` )); INSERT INTO `#__guild_master_conf` (guild_name, guild_id, guild_rank_1, guild_rank_2, guild_rank_3, guild_rank_4, guild_rank_5, guild_rank_6, guild_rank_7, guild_rank_8, show_updated, popup, use_images, show_lastnames, roster_url, roster_url_xml, guild_url, cache_time,guild_info) values ('Atrocitas', 1699210, 'Gruender', 'Botschafter', 'Sekraeter', 'Berater', 'Veteran', 'Mitglied', 'Anwaerter', 'Frischling', 1, 1, 1, 1,'http://eq2players.station.sony.com/en/guild_profile.vm','http://eq2players.station.sony.com/guilds/guild_roster_xml.vm','http://eq2players.station.sony.com/guilds/guild_profile.vm',86400,0); INSERT INTO #__guild_master_heri_quests (`heri_id`, `name_short`, `name`, `url`, `reward`, `reward_url`, `level`, `need_starter`) VALUES (1, 'GLS', 'The Return of the Light', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=433', 'Greater Lightstone', 'http://eq2.allakhazam.com/db/item.html?eq2item=2672', 20, 0), (2, 'LJB', 'The Journey is Half the Fun', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=480', 'Legendary Journeyman''s Boots', 'http://eq2.allakhazam.com/db/item.html?eq2item=2977', 50, 0), (3, 'DWB', 'These Boots Were Made for Walking', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=696', 'Dwarven Work Boots', 'http://eq2.allakhazam.com/db/item.html?eq2item=2730', 25, 0), (4, 'SBH', 'Dragoon K''Naae of the Thexians', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=799', 'Shiny Brass Halberd', 'http://eq2.allakhazam.com/db/item.html?eq2item=3013', 24, 0), (5, 'PGT', 'An Axe from the Past', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=884', 'Polished Granite Tomhawk', 'http://eq2.allakhazam.com/db/item.html?eq2item=3425', 30, 0), (6, 'FBE', 'Hadden''s Earring', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=689', 'Fishbone Earring', 'http://eq2.allakhazam.com/db/item.html?eq2item=3141', 25, 0), (7, 'GBS', 'A Strange Black Rock', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=872', 'Glowing Black Stone', 'http://eq2.allakhazam.com/db/item.html?eq2item=3468', 25, 0), (8, 'MS', 'Stilletto''s Orders Intercepted', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=957', 'Manastone', 'http://eq2.allakhazam.com/db/item.html?eq2item=3473', 28, 0), (9, 'GB', 'Restoring Ghoulbane', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=1046', 'Ghoulbane', 'http://eq2.allakhazam.com/db/item.html?eq2item=3010', 30, 0), (10, 'SBS', 'Training is a Shield', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=705', 'Shiny Brass Shield', 'http://eq2.allakhazam.com/db/item.html?eq2item=8567', 40, 0), (11, 'GoTD', 'A Missing Mask', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=1042', 'Guise of the Deceiver', 'http://eq2.allakhazam.com/db/item.html?eq2item=8536', 35, 0), (12, 'EEB', 'Foomby''s Stolen Goods', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=870', 'Bag of Sewn Evil Eye', 'http://eq2.allakhazam.com/db/item.html?eq2item=3404', 32, 0), (13, 'SSY', 'Rescue of the Greenhoods', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=953', 'Short Sword of the Ykesha', 'http://eq2.allakhazam.com/db/item.html?eq2item=3472', 32, 0), (14, 'SoM', 'The Stein of Moggok - It Can Be Rebuilt', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=858', 'Stein of Moggok', 'http://eq2.allakhazam.com/db/item.html?eq2item=3458', 35, 0), (15, 'SBD', 'The Reaching Blade of the Assassin', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=767', 'Serrated Bone Dirk', 'http://eq2.allakhazam.com/db/item.html?eq2item=3106', 35, 0), (16, 'CKT', 'The Lost Legend of Lavastorm', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=1124', 'Crown of King Tranix', 'http://eq2.allakhazam.com/db/item.html?eq2item=9121', 45, 0), (17, 'SM', 'Screaming Mace', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=1268', 'Screaming Mace', 'http://eq2.allakhazam.com/db/item.html?eq2item=8884', 50, 0), (18, 'GEB', 'Saving Soles', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=1129', 'Golden Efreeti Boots', 'http://eq2.allakhazam.com/db/item.html?eq2item=8963', 40, 0), (19, 'BBC', 'The Bone Bladed Claymore', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=1107', 'Bone Bladed Claymore', 'http://eq2.allakhazam.com/db/item.html?eq2item=10345', 40, 0), (20, 'TME', 'An Eye for Power', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=890', 'Tobrin''s Mystical Eyepatch', 'http://eq2.allakhazam.com/db/item.html?eq2item=3519', 45, 0), (21, 'FBSS', 'The Teachings of Yoru', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=864', 'Flowing Black Silk Sash', 'http://eq2.allakhazam.com/db/item.html?eq2item=3206', 45, 0), (22, 'HC', 'By Hook of By...', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=834', 'Heirophant''s Crook', 'http://eq2.allakhazam.com/db/item.html?eq2item=3140', 40, 0), (23, 'SoR', 'An Ancient Desert Power', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=2301', 'Scepter of Rahotep', 'http://eq2.allakhazam.com/db/item.html?eq2item=13165', 50, 0), (24, 'BCG', 'Draco Mortuus Vos Liberatio', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=2747', 'Bone-Clasped Girdle', 'http://eq2.allakhazam.com/db/item.html?eq2item=18846', 60, 0), (25, 'TB', 'The Wonderous Inventions Crazed Gnome', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=2729', 'Bag of the Tinkerers', 'http://eq2.allakhazam.com/db/item.html?eq2item=18488', 65, 0), (26, 'WS', 'A Thorn of Old', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=2731', 'WurmSlayer', 'http://eq2.allakhazam.com/db/item.html?eq2item=19048', 60, 0), (27, 'DRT', 'In Honor and Service', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=3142', 'Dwarven Ringmail Tunic', 'http://eq2.allakhazam.com/db/item.html?eq2item=22882', 15, 0), (28, 'RotO', 'War and Wardrobe', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=3129', 'Robe of the Oracle', 'http://eq2.allakhazam.com/db/item.html?eq2item=22867', 35, 0), (29, 'SotO', 'The Staff of the Observers', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=3121', 'Staff of the Observers', 'http://eq2.allakhazam.com/db/item.html?eq2item=22883', 50, 0), (30, 'RC', 'Casualties of the War of the Fay', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=3118', 'Rain Caller', 'http://eq2.allakhazam.com/db/item.html?eq2item=22896', 60, 0), (31, 'CMS', 'The Symbol in the Flesh', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=3458', 'Crested Mistmoore Shield', 'http://eq2.allakhazam.com/db/item.html?eq2item=27028', 70, 0), (32, 'CoF', 'Cloak of Flames (Series)', 'http://eq2.allakhazam.com/db/quest.html?eq2quest=3352', 'Cloak of Flames', 'http://eq2.allakhazam.com/db/item.html?eq2item=27014', 65, 0); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('1','1','Talk to Cannix'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('2','1','Touch Forgotten'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('3','1','Touch Mourned'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('4','1','Kill Rama\'nai'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('5','1','Kill Gaer'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('6','1','Kill Ogof'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('7','1','Ogof/Gaer'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('8','1','High Priest'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('9','1','BSV-General Drull'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('10','1','BSV SubQuest'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('11','1','Kill Cannix'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('12','1','Quest Turn-In'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('13','1','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('14','2','Antonica'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('15','2','Commonlands'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('16','2','Thundering Steppes'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('17','2','Nek Forest'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('18','2','Zek'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('19','2','Enchanted Lands'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('20','2','Feerrott'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('21','2','Quest Turn-In'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('22','2','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('23','3','100 Wood/100 Ore'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('24','3','Miners/Excavaters'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('25','3','Caveroot'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('26','3','Bloodtalon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('27','3','Caveroot/Bloodtalon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('28','3','Caveroot/Miners'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('29','3','Bloodtalon/Miners'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('30','3','BB Beer Run'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('31','3','Kill Grandfather'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('32','3','Antelope/Firerock Giant'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('33','3','Antelop'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('34','3','Firerock Giant'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('35','3','Minty Turn-in'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('36','3','Waiting on Minty'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('37','3','Quest Turn-In'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('38','3','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('39','4','60 Owlbear Meats'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('40','4','60 Undead Skin'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('41','4','Pond Run'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('42','4','Captain T\'Sanne'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('43','4','Kill Assassins'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('44','4','Quest Turn-In'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('45','4','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('46','5','Lost Tarby'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('47','5','Mining Granite'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('48','5','Forge Axe'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('49','5','100 Skellies'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('50','5','Skindancers'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('51','5','Octogorgon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('52','5','CoD Access'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('53','5','Quest Turn-In'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('54','5','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('55','6','Get Journal'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('56','6','Nek Power Source'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('57','6','CL Power Source'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('58','6','NEK/CL Power Source'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('59','6','TS Power Source'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('60','6','TS/NEK Power Source'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('61','6','TS/CL Power Source'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('62','6','Kill Everling'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('63','6','Castle Subquest'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('64','6','Hrath V\'Tol'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('65','6','Captain Krieger'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('66','6','Quest Turn-In'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('67','6','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('68','7','TS Power Source'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('69','7','NEK Power Source'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('70','7','Both Power Sources'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('71','7','Brown Research Tome'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('72','7','Black Research Tome'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('73','7','Black/Brown Tomes'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('74','7','Need Palladium Torque'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('75','7','Tome of Life'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('76','7','Tome of Death'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('77','7','Tome of Life/Death'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('78','7','Kill Varsoon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('79','7','CoI Access Quest'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('80','7','Kill Al\'Quylar'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('81','7','Quest Turn-In'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('82','7','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('83','8','Examine Orders'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('84','8','CoD Access Quest'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('85','8','Octogorgon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('86','8','Examine Hand'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('87','8','Captain Ulssissaris'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('88','8','Examine RoV Book'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('89','8','Weavemaster Esh\'Rax'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('90','8','Create Shroud of Manastone'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('91','8','CoI Access Quest'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('92','8','Kill Varsoon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('93','8','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('94','9','Dusty Blue Stone Quest'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('95','9','ToV Access'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('96','9','Retrieve Weakened'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('97','9','Torig'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('98','9','Spectre of Ire'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('99','9','The Creator'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('100','9','Torig/Ire'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('101','9','Torig/Creator'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('102','9','Torig/Creator/Ire'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('103','9','Creator/Ire'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('104','9','Cauldron Access Quest'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('105','9','Kill Everling'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('106','9','Castle Access Quest'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('107','9','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('108','10','Trial 1'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('109','10','Trial 2'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('110','10','Trial 3'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('111','10','Trial 4'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('112','10','Trial 5'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('113','10','Trial 6'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('114','10','Turn-in Grozmag'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('115','10','Kill Fyst'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('116','10','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('117','11','Basement Billy'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('118','11','Gameroom Billy'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('119','11','Chapel Billy'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('120','11','Gameroom/Chapel Billy'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('121','11','Library Book'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('122','11','Courtyard Billy'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('123','11','Froglok Assassin'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('124','11','Library Scroll'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('125','11','Nyth Dolls'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('126','11','Fiendish Blood'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('127','11','Swine Lord'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('128','11','Nyth/Fiendish/Swine'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('129','11','Nyth/Fiendish'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('130','11','Nyth/Swine'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('131','11','Fiendish/Swine'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('132','11','Kill Everling'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('133','11','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('134','12','Darkflight Faeries'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('135','12','Foomby Turn-in'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('136','12','Chomper'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('137','12','Bellendis Tempestcall'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('138','12','Lamias'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('139','12','Baz\'Tarog'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('140','12','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('141','13','Operation Greenhood Quest'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('142','13','Inspect Mine'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('143','13','Sullon Centurians'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('144','13','Tallon Raiders'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('145','13','Vallon Grunts'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('146','13','Sullon/Tallon/Vallon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('147','13','Sullon/Tallon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('148','13','Sullon/Vallon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('149','13','Tallon/Vallon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('150','13','Sentry Goorlux'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('151','13','Infiltrator Stryjin'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('152','13','Rescue Green Hood Women'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('153','13','Kill Fyst'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('154','13','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('155','14','Flerb'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('156','14','Fug'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('157','14','Hurd'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('158','14','Prud'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('159','14','Flerb/Fug/Hurd/Prud'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('160','14','Flerb/Fug/Hurd'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('161','14','Flerb/fug'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('162','14','Fug/Hurd/Prud'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('163','14','Fug/Hurd'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('164','14','Hurd/Prud'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('165','14','Fug/Prud'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('166','14','Fug/Hurd/Prud'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('167','14','Fug/Hurd'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('168','14','Bartender Clurg'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('169','14','RumDum Turn-In'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('170','14','Craft the Stein'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('171','14','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('172','15','Leelav Yekl Turn-In'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('173','15','Kreglebop Yekl'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('174','15','Lodo Bightn'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('175','15','COB Assassins'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('176','15','Windstalker Village Note'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('177','15','TS Verishu'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('178','15','Ethruia Aidora'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('179','15','Logo Bigthn'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('180','15','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('181','16','Tablet Shards'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('182','16','Banners'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('183','16','Words of Pure Magic Subquest'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('184','16','Examine Banners'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('185','16','Poem Pieces/Stanzas'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('186','16','Bunglegreeder'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('187','16','Rare Rocks'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('188','16','Tomekeeper Sunto'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('189','16','Dead Knight Bones'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('190','16','Censor of Souls'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('191','16','Speaker'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('192','16','The Castigator'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('193','16','Lord Crana'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('194','16','Onyxlam'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('195','16','Speaker/Castigator/Crana/Onyxlam'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('196','16','Speaker/Castigator/Crana'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('197','16','Speaker/Castigator'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('198','16','Castigator/Crana/Onyxlam'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('199','16','Castigator/Crana'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('200','16','Crana/Onyxlam'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('201','16','Castigator/Onyxlam'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('202','16','Turn-In'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('203','16','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('204','17','Lizardmen'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('205','17','Kaxor/Hukulan/Tzugaax/Xilarga'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('206','17','Kaxor/Hukulan/Tzugaax'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('207','17','Kaxor/Hukulan'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('208','17','Kaxor'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('209','17','Hukulan/Tzugaax/Xilarga'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('210','17','Hukulan/Tzugaax'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('211','17','Hukulan'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('212','17','Tzugaax/Xilarga'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('213','17','Tzugaax'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('214','17','Tzugaax/Kaxor'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('215','17','Basin of Ba\'Kur'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('216','17','Thulian Terrorfiends'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('217','17','Keeper'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('218','17','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('219','18','Crawlers/Drakes'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('220','18','Crawlers'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('221','18','Drakes'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('222','18','Find smelly bait'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('223','18','The Big Squiggly'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('224','18','Tazgar the Efreeti'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('225','18','Fire Giants'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('226','18','Disable the Spires'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('227','18','The Magolemus'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('228','18','Reactivate Spires'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('229','18','Efreeti Lord Djarn'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('230','18','Tazgar Turn-In'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('231','18','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('232','19','Opalla'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('233','19','Redak'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('234','19','Re-forge Hilt'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('235','19','Slay 1000 Beings'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('236','19','Gynok Moltar'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('237','19','Berik\'s Revenge Subquest'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('238','19','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('239','20','Acquire Shards'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('240','20','Bloodrage/Webclaw/Iceburn'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('241','20','Bloodrage/Webclaw'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('242','20','Bloodrage'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('243','20','Webclaw/Iceburn'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('244','20','Bloodrage/Iceburn'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('245','20','Miragul\'s Meagerie'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('246','20','Shade of Tobrin'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('247','20','Examine Chest'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('248','20','Webclaw'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('249','20','Iceburn'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('250','20','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('251','21','Harvest Wood'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('252','21','Basil Grilled Deer'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('253','21','Beer Run'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('254','21','Highwaymen'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('255','21','Cythan'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('256','21','Cythan Ring Event'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('257','21','Sartar/Oodan/Borbin/Raster'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('258','21','Sartar/Oodan/Borbin'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('259','21','Sartar/Oodan'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('260','21','Sartar the Unrivaled'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('261','21','Oodan/Borbin/Raster'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('262','21','Oodan/Borbin'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('263','21','Oodan/Raster'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('264','21','Oodan the Tranquil'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('265','21','Borbin/Raster'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('266','21','Sartar/Borbin'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('267','21','Borbin the Prevailer'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('268','21','Brother Raster'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('269','21','Rastar/Sartar'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('270','21','Kill Cythan'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('271','21','Sartar/Borbin/Rastar'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('272','21','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('273','22','100 Nightbloods'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('274','22','Mysterious Drafling Subquest'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('275','22','JumJum Juice'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('276','22','Queens Chamber'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('277','22','Asajj An\'Duuth'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('278','22','Deliver Vegetables'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('279','22','Kill Rukir'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('280','22','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('281','23','Desert Expert'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('282','23','Harshaa'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('283','23','Prophet of the Desert'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('284','23','Planetologist'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('285','23','Dry Wind Island Pirates'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('286','23','Home City Library Run'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('287','23','Rahotep Raid'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('288','23','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('289','24','Speak to Sinephobis'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('290','24','Learn Thulian'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('291','24','Strengthened/draconic/bones'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('292','24','Sheet/Lumber/Geode/Leather'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('293','24','Sheet/Lumber/Geode'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('294','24','Sheet/Lumber'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('295','24','Sheet/Geode'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('296','24','Sheet/Leather'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('297','24','Geode/Lumber'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('298','24','Geode/Lumber/Leather'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('299','24','Geode/Leather'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('300','24','Lumber/Leather'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('301','24','Blue-Silver/Sheet'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('302','24','Perfect/Osseus/Lumber'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('303','24','Perfectly Cut/Purple Geode'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('304','24','Strip of/Supple/Leather'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('305','24','Forge Combine'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('306','24','DoEllin'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('307','24','Sinephobis Turn-In'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('308','24','Spirit of DoEllin'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('309','24','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('310','25','Rescue Gnome'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('311','25','Learn Gnomish'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('312','25','Piles of Goo'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('313','25','Gimdimble Fizzwoddle Turn-In'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('314','25','Core ground samples'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('315','25','Soil Samples'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('316','25','Dizzwangle'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('317','25','Carapaces/Padding'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('318','25','Vornerus drone'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('319','25','Fetidthorn briar'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('320','25','Retrieve/gnomes/tools'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('321','25','Young dragon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('322','25','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('323','26','Kill Azdalin'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('324','26','Kill Glyton'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('325','26','Kill Lord Xyfl'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('326','26','Fuzzmin Turn-In'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('327','26','Old Weaponsmith'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('328','26','Rare oak-shaft'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('329','26','Metal bar'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('330','26','Harla Dar'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('331','26','Lord Vyemm'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('332','26','Sothis'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('333','26','Harla/Vyemm/Sothis'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('334','26','Harla/Vyemm'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('335','26','Harla/Sothis'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('336','26','Vyemm/Sothis'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('337','26','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('338','27','War Memorial'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('339','27','Dwarven/War/Artifacts'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('340','27','Captain Irontoe'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('341','27','Echo Echo Canyon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('342','27','Orc Hill'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('343','27','Three Crushbone/Orc Spies'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('344','27','Tuning Discs'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('345','27','Gong'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('346','27','3 Spys'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('347','27','Shrool Dust'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('348','27','20 Fayflies'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('349','27','Brook Patch/Toadstools'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('350','27','Mushroom King'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('351','27','Sprinkle Dust'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('352','27','Kill WarSmiths'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('353','27','sullon/vallon/derris/tallon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('354','27','sullon/vallon/derris'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('355','27','sullon/vallon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('356','27','sullon/derris'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('357','27','sullon/gullon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('358','27','sullon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('359','27','vallon/derris/tallon/gullon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('360','27','vallon/derris/tallon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('361','27','vallon/derris'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('362','27','vallon/tallon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('363','27','vallon/gullon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('364','27','vallon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('365','27','derris/tallon/gullon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('366','27','derris/tallon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('367','27','derris/gullon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('368','27','derris'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('369','27','tallon/gullon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('370','27','gullon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('371','27','Kill Expedition Leaders'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('372','27','Expedition Leader'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('373','27','Expedition Chef'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('374','27','Expedition Weaponsmith'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('375','27','Expedition Planner'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('376','27','Leader/Chef/Weaponsmith'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('377','27','Leader/Weaponsmith'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('378','27','Leader/Planner'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('379','27','Leader/weaponsmith/Planner'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('380','27','Chef/Weaponsmith/Planner'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('381','27','Chef/Planner'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('382','27','Chef/Weaponsmith'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('383','27','Planner/Weaponsmith'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('384','27','Planner/Chef'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('385','27','Dwarven ringmail plans'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('386','27','Captain R.K. Irontoe'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('387','27','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('388','28','Brooch'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('389','28','Glavarius Marud'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('390','28','fippy darkpaw'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('391','28','Empty Crate Note'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('392','28','Tessas Contingency plan'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('393','28','Tessas Hidden Notes'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('394','28','aquagoblins'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('395','28','cleric hate helms'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('396','28','Oracle NMare'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('397','28','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('398','29','Vhizz Frugrin'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('399','29','Lord Rulgax'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('400','29','mana infused crystals'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('401','29','oxidized mineral water'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('402','29','mana infused stone'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('403','29','Grikbar outcast'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('404','29','Learn Serilian'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('405','29','Pechpooka'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('406','29','Pechmooka'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('407','29','Pechyooka'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('408','29','Pechpooka/Pechmooka/Pechyooka'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('409','29','Pechpooka/Pechmooka'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('410','29','Pechpooka/Pechyooka'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('411','29','Pechmooka/Pechyooka'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('412','29','King Grikbar'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('413','29','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('414','30','Master Bowyer Mossberge'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('415','30','wounded werewolf'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('416','30','Captain Trueshot'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('417','30','dwarven wire'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('418','30','mirco servos'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('419','30','Moonlight Wood'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('420','30','Gold Fairy Dust'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('421','30','King Klak Anon'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('422','30','Sir Gearheart'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('423','30','Master Bowyer Mossberge'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('424','30','Fethinal'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('425','30','Dragoon V Riv'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('426','30','Dragoon K Get'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('427','30','Dragoon Cpt. K Venx'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('428','30','kill Captian Trueshot'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('429','30','Huntmaster Viswin'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('430','30','COMPLETED!'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('431','31','Glyph Tatooed Flesh'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('432','31','Tavish Dracinov'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('433','31','Amares D Venhz'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('434','31','20 Chunks/Raw Meat'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('435','31','20 Congealed/Blood Drops'); INSERT INTO #__guild_master_heri_steps (step_id,heri_id,name) VALUES ('436','31','COMPLETED!');