/RubySanctum/#3793_the_Wyrmrest_Temple.sql

https://bitbucket.org/TCRC/patches/ · SQL · 74 lines · 70 code · 4 blank · 0 comment · 4 complexity · d218f9f5ee91883beee99e640d7cbcd1 MD5 · raw file

  1. DELETE FROM `script_texts` WHERE `entry` <= -1752008 AND `entry` >= -1752016;
  2. DELETE FROM `script_texts` WHERE `entry` <= -1752001 AND `entry` >= -1752006;
  3. DELETE FROM `script_texts` WHERE `entry` <= -1752017 AND `entry` >= -1752036;
  4. INSERT INTO `script_texts` (`entry`, `content_default`, `npc_entry`, `content_loc3`, `sound`, `type`, `language`) VALUES
  5. ('-1752008', 'Help! I am trapped within this tree! I require aid!', '0', '', '17490', '1', '0'),
  6. ('-1752009', 'Thank you! I could not have held out for much longer.... A terrible thing has happened here.', '0', '', '17491', '1', '0'),
  7. ('-1752010', 'We believed the Sanctum was well-fortified, but we were not prepared for the nature of this assault.', '0', '', '17492', '0', '0'),
  8. ('-1752011', 'The Black dragonkin materialized from thin air, and set upon us before we could react.', '0', '', '17493', '0', '0'),
  9. ('-1752012', 'We did not stand a chance. As my brethren perished around me, I managed to retreat here and bar the entrance.', '0', '', '17494', '0', '0'),
  10. ('-1752013', 'They slaughtered us with cold efficiency, but the true focus of their interest seemed to be the eggs kept here in the Sanctum.', '0', '', '17495', '0', '0'),
  11. ('-1752014', 'The commander of the forces on the ground here is a cruel brute named Zarithrian, but I fear there are greater powers at work.', '0', '', '17496', '0', '0'),
  12. ('-1752015', 'In their initial assault, I caught a glimpse of their true leader, a fearsome full-grown twilight dragon.', '0', '', '17497', '0', '0'),
  13. ('-1752016', 'I know not the extent of their plans, heroes, but I know this: They cannot be allowed to succeed!', '0', '', '17498', '0', '0'),
  14. ( -1752001, "Ah, the entertainment has arrived.", 0, "", 17520, 1, 0),
  15. ( -1752002, "Baltharus leaves no survivors!", 0, "", 17521, 1, 0),
  16. ( -1752003, "This world has enough heroes.", 0, "", 17522, 1, 0),
  17. ( -1752004, "I..Didn''t saw...that coming...", 0, "", 17523, 1, 0),
  18. ( -1752005, "Twice the pain and half the fun.", 0, "", 17524, 1, 0),
  19. ( -1752006, "Your power wanes, ancient one.... Soon you will join your friends.", 0, "", 17525, 1, 0),
  20. ( -1752017, "Alexstrasza has chosen capable allies... A pity that I must END YOU!", 0, "", 17512, 1, 0),
  21. ( -1752018, "You thought you stood a chance?", 0, "", 17513, 1, 0),
  22. ( -1752019, "It''s for the best.", 0, "", 17514, 1, 0),
  23. ( -1752020, "HALION! I...", 0, "", 17515, 1, 0),
  24. ( -1752021, "Turn them to ashes, minions!", 0, "", 17516, 1, 0),
  25. ( -1752022, "You will sssuffer for this intrusion!", 0, "", 17528, 1, 0),
  26. ( -1752023, "As it should be...", 0, "", 17529, 1, 0),
  27. ( -1752024, "Halion will be pleased", 0, "", 17530, 1, 0),
  28. ( -1752025, "Hhrr...Grr..", 0, "", 17531, 1, 0),
  29. ( -1752026, "Burn in the master's flame!", 0, "", 17532, 1, 0),
  30. (-1752027, 'Insects! You''re too late. The Ruby Sanctum is lost.',NULL,NULL,17499,0,0),
  31. (-1752028, 'Your world teeters on the brink of annihilation. You will ALL bear witness to the coming of a new age of DESTRUCTION!',NULL,NULL,17500,0,0),
  32. (-1752029, 'Another hero falls.',NULL,NULL,17501,0,0),
  33. (-1752030, 'Hahahahaha.',NULL,NULL,17502,0,0),
  34. (-1752031, 'Relish this victory, mortals, for it will be your last! This world will burn with the master''s return!',NULL,NULL,17503,0,0),
  35. (-1752032, 'Not good enough.',NULL,NULL,17504,0,0),
  36. (-1752033, 'The heavens burn!',NULL,NULL,17505,0,0),
  37. (-1752034, 'Beware the shadow!',NULL,NULL,17506,0,0),
  38. (-1752035, 'You will find only suffering within the realm of twilight! Enter if you dare!',NULL,NULL,17507,0,0),
  39. (-1752036, 'I am the light and the darkness! Cower, mortals, before the herald of Deathwing!',NULL,NULL,17508,0,0);
  40. UPDATE `instance_template` SET `script`='instance_ruby_sanctum' WHERE (`map`='724');
  41. UPDATE `creature_template` SET `ScriptName` = 'boss_baltharus' WHERE `entry` = '39751';
  42. UPDATE `creature_template` SET `ScriptName` = 'boss_baltharus_summon' WHERE `entry` = '39899';
  43. UPDATE `creature_template` SET `ScriptName` = 'npc_xerestrasza' WHERE `entry` = '40429';
  44. UPDATE `creature_template` SET `ScriptName` = 'boss_zarithrian' WHERE `entry` = '39746';
  45. UPDATE `creature_template` SET `ScriptName` = 'boss_ragefire' WHERE `entry` = '39747';
  46. UPDATE `creature_template` SET `ScriptName` = 'boss_halion' WHERE `entry`= '39863';
  47. UPDATE `creature_template` SET `ScriptName` = 'boss_twilight_halion' WHERE `entry` = '40142';
  48. UPDATE `creature_template` SET `ScriptName` = 'npc_onyx_flamecaller' WHERE `entry` = '39814';
  49. UPDATE `creature_template` SET `ScriptName` = 'npc_meteor_strike', `flags_extra`=128 WHERE `entry` = '40041';
  50. UPDATE `creature_template` SET `ScriptName` = 'npc_meteor_flame', `flags_extra`=128 WHERE `entry` = '40042';
  51. UPDATE `creature_template` SET `ScriptName` = 'npc_spell_meteor_strike', `flags_extra`=128 WHERE `entry` = '40029';
  52. UPDATE `creature_template` SET `ScriptName` = 'npc_summon_halion', `flags_extra`=128 WHERE `entry` = '40044';
  53. DELETE FROM `spell_linked_spell` WHERE (`spell_trigger`='-74562') AND (`spell_effect`='74610');
  54. DELETE FROM `spell_linked_spell` WHERE (`spell_trigger`='-74792') AND (`spell_effect`='74800');
  55. INSERT INTO `spell_linked_spell` VALUES (-74562, 74610, 0, 'Fiery Combustion removed -> Combustion');
  56. INSERT INTO `spell_linked_spell` VALUES (-74792, 74800, 0, 'Soul Consumption removed -> Consumption');
  57. DELETE FROM `creature` WHERE `id`=39863 AND `map`=724;
  58. INSERT INTO `creature` VALUES (null,39863,724,15,65535,0,0,3144.93,527.233,72.8887,0.110395,604800,0,0,11156000,0,0,0,0,0,0);
  59. DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_halion_portal';
  60. INSERT INTO `spell_script_names` VALUES (74812,'spell_halion_portal');
  61. UPDATE `gameobject_template` SET `data10`=74807 WHERE `entry`=202794;
  62. UPDATE `gameobject_template` SET `data10`=74812 WHERE `entry`=202796;