Foror's Compendium of Dragon Slaying, partial fix.

[scotty0100]

Source(s) used: http://www.wowwiki.com/Quest:Foror's_Compendium

Currently after obtaining the book Foror's Compendium of Dragon Slaying and accepting and turning in the quest. Loremaster Lydros offers up no further quest making the The Forging of Quel'Serrar questline impossible to do.

I have done some initial work on it:

-- Sets the Foror's Compendium of Dragon Slaying to only be accepted by Warriors and Paladins
UPDATE `quest_template` SET `RequiredClasses`='3' WHERE (`entry`='7507');

-- Gives out item A Dull and Elven Blade (ID: 18513)
DELETE FROM `dbscripts_on_gossip` WHERE `id`='6562';
INSERT INTO `dbscripts_on_gossip` (`id`, `command`, `datalong`, `datalong2`, `comments`) VALUES ('6562', '17', '18513', '1', 'Create item A Dull and Flat Elven Blade for Quest Foror\'s Compendium ');

-- Add condition to make sure Foror Quest completed before showing any gossip menus.
DELETE FROM `conditions` WHERE `condition_entry`='4703';
INSERT INTO `conditions` (`condition_entry`,`type`,`value1`,`value2`) VALUES ('4703','8','7507','0');

DELETE FROM `gossip_menu_option` WHERE `menu_id`='5747';
DELETE FROM `gossip_menu_option` WHERE `menu_id`='12847';
DELETE FROM `gossip_menu_option` WHERE `menu_id`='12848';
DELETE FROM `gossip_menu_option` WHERE `menu_id`='12849';
DELETE FROM `gossip_menu_option` WHERE `menu_id`='12850';
DELETE FROM `gossip_menu_option` WHERE `menu_id`='12851';
DELETE FROM `gossip_menu_option` WHERE `menu_id`='12852';
INSERT INTO `gossip_menu_option` (`menu_id`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `condition_id`) VALUES ('5747' , '<Lydros reaches into his robe and presents you with a dull, flat elven blade.>', '1', '1', '12847', '4703');
INSERT INTO `gossip_menu_option` (`menu_id`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `condition_id`) VALUES ('12847', 'Fascinating, Lorekeeper. Continue please.', '1', '1', '12848', '4703');
INSERT INTO `gossip_menu_option` (`menu_id`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `condition_id`) VALUES ('12848', 'Continue.', '1', '1', '12849', '4703');
INSERT INTO `gossip_menu_option` (`menu_id`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `condition_id`) VALUES ('12849', 'Continue.', '1', '1', '12850', '4703');
INSERT INTO `gossip_menu_option` (`menu_id`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `condition_id`) VALUES ('12850', 'Continue.', '1', '1', '12851', '4703');
INSERT INTO `gossip_menu_option` (`menu_id`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `condition_id`) VALUES ('12851', 'Eh?', '1', '1', '12852', '4703');
INSERT INTO `gossip_menu_option` (`menu_id`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_script_id`, `condition_id`) VALUES ('12852', 'Maybe...What do I do now?', '1', '1', '-1', '6562', '4704');

DELETE FROM `npc_text` WHERE `ID`='18071';
DELETE FROM `npc_text` WHERE `ID`='18072';
DELETE FROM `npc_text` WHERE `ID`='18073';
DELETE FROM `npc_text` WHERE `ID`='18074';
DELETE FROM `npc_text` WHERE `ID`='18075';
DELETE FROM `npc_text` WHERE `ID`='18076';
INSERT INTO `npc_text` (`ID`, `text0_0`) VALUES ('18071', 'In ages past, well before even the War of the Ancients, there existed this blade.');
INSERT INTO `npc_text` (`ID`, `text0_0`) VALUES ('18072', 'The blade itself had to be crafted in ceremony with the children of the Aspects. A rare occurrence indeed... For not only would a dragon have to willingly heat and mold the enchanted metal with their breath, they would also need to contain the fury of their own enchantment by using their blood as temper.');
INSERT INTO `npc_text` (`ID`, `text0_0`) VALUES ('18073', 'Over the course of 8,000 years, only a handful of these blades were created - each blade unique in both power and appearance. The blades of Quel\'Serrar would take on the characteristics of their creator.');
INSERT INTO `npc_text` (`ID`, `text0_0`) VALUES ('18074', 'Rumors exist of a single legendary blade of Quel\'Serrar crafted for an unknown entity by the combined might of the five Aspects. Before the abominations of Nefarian and Deathwing were thrust into our world, such meetings of the Aspect were represented by the term \'Prismatic.\' I could only assume that the Prismatic Blade of Quel\'Serrar was a most glorious creation.');
INSERT INTO `npc_text` (`ID`, `text0_0`) VALUES ('18075', 'What I offer to you now is one such blade, unfired, unheated, untreated - the most raw and basic form.\r\nNow you merely need to find a dragon that will willingly enchant the blade.\r\nIf you had an eternity to live, this might be a possibility; but since you are mortal and could very likely cease to exist at any moment, might I recommend trying to persuade one of the lesser dragons to do your bidding.');
INSERT INTO `npc_text` (`ID`, `text0_0`) VALUES ('18076', 'Have you heard of the brood mother of the Black Flight? I believe she is called Onyxia...');

DELETE FROM `gossip_menu` WHERE `entry`='12847';
DELETE FROM `gossip_menu` WHERE `entry`='12848';
DELETE FROM `gossip_menu` WHERE `entry`='12849';
DELETE FROM `gossip_menu` WHERE `entry`='12850';
DELETE FROM `gossip_menu` WHERE `entry`='12851';
DELETE FROM `gossip_menu` WHERE `entry`='12852';
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES ('12847', '18071');
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES ('12848', '18072');
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES ('12849', '18073');
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES ('12850', '18074');
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES ('12851', '18075');
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES ('12852', '18076');

This makes it so that after you completed the Foror's Compendium quest, it goes through all the gossip menus and then gives out the item A Dull and Elven Blade (ID: 18513). Which then gives you the Forging of Quel'Serrar quest.

This is where it breaks again as to complete Quest: 7509 (http://www.wowhead.com/quest=7509) you need to drop the Unfired Ancient Blade in front of Onyxia which after she breathes a fiery breath on it turns it into a Heated Ancient Blade (ID: 18488), and then you are required to use the Heated Blade on her corpse.

Neither of those two work. Are they possible through DB?

[Zooke]

Any reason this was not implemented ?

[cala]

Lack of time, like many issues here and some data missing for the Onyxia part. This issue is part of the milestone for Dire Maul and I was intending to do it when I would focus on that dungeon which is not yet because we are missing some core feature for it atm. However, if someone comes with a more complete fix for this specific issue than the already nice fix here, I'd merge it.

[cala]

The first part of this is fixed in cmangos/classic-db@a039c0b

The second part probably needs an update of the Onyxia encounter. I'll do it later.

[Neotmiren]

@cala
What you mean by second part is probably this

MyOP("INSERT IGNORE spell_script_target SET entry=22904, type=0, targetEntry=179561, inverseEffectMask=0");
printf(" ■ Fix quest \"Forging of Quel'Serrar\", GO Onyxia Flame Breath => lootable GO Ancient Heated Blade: %d rows\n", mysql_affected_rows());

Works fine in my build. Found this way to fix because it is similar to another quest with controlling dragon Emberstrife. And also 20min duration might be required for item 18488 (Heated Ancient Blade).

[cala]

Thanks. I'll give it a look soon.