thestonecore sql

UPDATE `instance_template` SET `script`='instance_the_stonecore' WHERE `map`=725;

UPDATE `creature_template` SET `ScriptName`='boss_corborus' WHERE `entry`=43438;
UPDATE `creature_template` SET `ScriptName`='npc_rock_borer' WHERE `entry`=43917;
UPDATE `creature_template` SET `ScriptName`='npc_crystal_shard' WHERE `entry`=49267;

UPDATE `creature_template` SET `ScriptName`='boss_slabhide' WHERE `entry`=43214;
UPDATE `creature_template` SET `minlevel`=84, `maxlevel`=85, `faction_A`=16, `faction_H`=16, `flags_extra`=128, `ScriptName`='npc_lava_fissure' WHERE `entry`=43242;

UPDATE `creature_template` SET `ScriptName`='boss_ozruk' WHERE `entry`=42188;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (42188, 0, 0, 'None may pass into the World\'s Heart!', 1, 0, 0, 0, 0, 21919, 'VO_SC_OZRUK aggro');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (42188, 1, 0, 'The cycle is complete.', 1, 0, 0, 0, 0, 21920, 'VO_SC_OZRUK kill');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (42188, 2, 0, 'Break yourselves upon my body. Feel the strength of the earth!', 1, 0, 0, 0, 0, 21921, 'VO_SC_OZRUK');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (42188, 3, 0, 'A protector has fallen. The World\'s Heart lies exposed!', 1, 0, 0, 0, 0, 21922, 'VO_SC_OZRUK death');

UPDATE `creature_template` SET `ScriptName`='boss_high_priestess_azil' WHERE `entry`=42333;
UPDATE `creature_template` SET `minlevel`=84, `maxlevel`=85, `faction_A`=16, `faction_H`=16, `flags_extra`=128, `ScriptName`='npc_gravity_well' WHERE `entry`=42499;
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (79251, 'high_priestess_azil_gravity_well_script');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (42333, 0, 0, '', 1, 0, 0, 0, 0, 21627, 'VO_SC_Azil_Event01');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (42333, 1, 0, 'Witness the power bestowed upon me by Deathwing! Feel the fury of earth!', 1, 0, 0, 0, 0, 21628, 'VO_SC_Azil spell01');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (42333, 2, 0, 'For my death, countless more will fall. The burden is now yours to bear.', 1, 0, 0, 0, 0, 21633, 'VO_SC_Azil death');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (42333, 3, 0, 'The world will be reborn in flames!', 1, 0, 0, 0, 0, 21634, 'VO_SC_Azil aggro1');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (42333, 3, 1, 'A sacrifice for you, master.', 1, 0, 0, 0, 0, 21635, 'VO_SC_Azil aggro2');