PageRenderTime 32ms CodeModel.GetById 15ms app.highlight 14ms RepoModel.GetById 1ms app.codeStats 0ms

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