Blackwing Lair, some fixes.

[geoburn]

Some fixes for Blackwing Lair:
* Razorgore the Untamed, need to have Spell Fireball Volley 22425 when is controlled by player (ytdb has the same spell1 and spell2).
* Vaelastrasz the Corrupt: The boss does not start the event because has a wrong gossip_menu_id, core is calling gossip_menu_id 21334 like you can see in: https://github.com/TrinityCore/Trini...aelastrasz.cpp line 36.

-- Razorgore the Untamed - added Spell Fireball Volley
UPDATE `creature_template` SET `spell1` = 22425 WHERE `entry` = 12435;

-- Vaelastrasz the Corrupt
UPDATE `creature_template` SET `gossip_menu_id` = 21333 WHERE `entry` = 13020;
-- Gossip fix
UPDATE `gossip_menu_option` SET `menu_id` = 21333, `action_menu_id` = 21334 WHERE `menu_id` = 6021;
UPDATE `gossip_menu_option` SET `menu_id` = 21334 WHERE `menu_id` = 6101;
-- Stop movement
UPDATE `creature` SET `MovementType` = 0 WHERE `id` = 13020;

-- Portcullis need to be clicked to open
UPDATE `gameobject_template` SET `faction` = 0 WHERE `entry` = 179364;

[YuruY]

-- Vaelastrasz the Corrupt
UPDATE `creature_template` SET `gossip_menu_id` = 21333 WHERE `entry` = 13020;
-- Gossip fix
UPDATE `gossip_menu_option` SET `menu_id` = 21333, `action_menu_id` = 21334 WHERE `menu_id` = 6021;
UPDATE `gossip_menu_option` SET `menu_id` = 21334 WHERE `menu_id` = 6101;

This hack TDB, Offe number 6021.

UPDATE `gameobject_template` SET `faction` = 0 WHERE `entry` = 17936

????

[geoburn]

Hi YuruY, I correct the query bellow. Gossip is correct, if you SELECT `entry`, `gossip_menu_id` FROM `creature_template` WHERE `entry` = 13020; in TDB you can see `gossip_menu_id` = 21333 and if you SELECT * FROM `gossip_menu_option` WHERE `menu_id` = 21333; you can see `action_menu_id` = 21334 that is called by .../scripts/EasternKingdoms/BlackrockMountain/BlackwingLair/boss_vaelastrasz.cpp line 36:
enum Gossip
{
GOSSIP_ID = 21334,
};
and event start.

Apply the query, start server and then .go creature 48456 and try.

[NeatElves]

And why put a hack in the database easier than to write to developers that they have corrected the script with the correct numbers?

[geoburn]

Ups, sorry in this case, I just try to give a solution. I just check the code then I apply this solution. Any way, thanks for your answer.