halfus sql

UPDATE `instance_template` SET `script`='instance_bastion_of_twilight' WHERE `map`=671;
UPDATE `creature_template` SET `ScriptName`='boss_halfus_wyrmbreaker' WHERE `entry`=44600;
UPDATE `creature_template` SET `ScriptName`='npc_halfus_dragon' WHERE `entry`=44645;
UPDATE `creature_template` SET `ScriptName`='npc_halfus_dragon' WHERE `entry`=44650;
UPDATE `creature_template` SET `ScriptName`='npc_halfus_dragon' WHERE `entry`=44652;
UPDATE `creature_template` SET `ScriptName`='npc_halfus_dragon' WHERE `entry`=44797;
UPDATE `creature_template` SET `faction_A`=16, `faction_H`=16, `ScriptName`='npc_proto_behemoth' WHERE `entry`=44687;
DELETE FROM `spell_script_names` WHERE `spell_id` = 83603;
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (83603, 'spell_halfus_stone_grip');
DELETE FROM `spell_script_names` WHERE `spell_id` = 83719;
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (83719, 'spell_halfus_fireball_barrage');
DELETE FROM `creature_text` WHERE `entry` = 44600;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (44600, 0, 0, 'Cho\'gall will have your heads! ALL OF THEM!', 1, 0, 0, 0, 0, 20186, 'VO_BT_Halfus_Event01');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (44600, 1, 0, 'The wyrms will eat well tonight!', 1, 0, 0, 0, 0, 20187, 'VO_BT_Halfus_Event03');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (44600, 2, 0, 'The burden of the damned falls upon you!', 1, 0, 0, 0, 0, 20188, 'VO_BT_Halfus_Event02');