diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2015_03_26_02_world.sql | 121 |
1 files changed, 121 insertions, 0 deletions
diff --git a/sql/updates/world/2015_03_26_02_world.sql b/sql/updates/world/2015_03_26_02_world.sql new file mode 100644 index 00000000000..afd0d99691a --- /dev/null +++ b/sql/updates/world/2015_03_26_02_world.sql @@ -0,0 +1,121 @@ +-- +SET @ADMETIUS := 17658; +SET @LEGOSO := 17982; +SET @SIRONAS := 17678; +SET @TESLA := 17979; + +-- Sironas +-- Equips +DELETE FROM `creature_equip_template` WHERE `entry`=@SIRONAS; +INSERT INTO `creature_equip_template` (`entry`, `id`, `itemEntry1`) VALUES +(@SIRONAS, 1, 2244); + +-- Spells & scriptname +UPDATE `creature_template` SET `spell1`=10966, `spell2`=12742, `spell3`=8282, `spell4`=0, `ScriptName`='npc_sironas' WHERE `entry`=@SIRONAS; +-- Text +DELETE FROM `creature_text` WHERE `entry`=@SIRONAS; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `probability`, `comment`, `BroadcastTextId`) VALUES +(@SIRONAS, 0, 0, 'Petulant children, pray to your gods for you are about to meet them!', 14, 100, 'Sironas SAY_SIRONAS_1 (pre aggro)',14666); + +-- Tesla targets +-- Disable movement +UPDATE `creature` SET `spawndist`=0, `MovementType`=0 WHERE `Id`=@TESLA; +-- Position fix +UPDATE `creature` SET `position_x`=-1964.13, `position_y`=-10538.7, `position_z`=198.928 WHERE `Id`=@TESLA AND `guid`=63627; +UPDATE `creature` SET `position_x`=-1926.01, `position_y`=-10577.4, `position_z`=194.301 WHERE `Id`=@TESLA AND `guid`=63628; +UPDATE `creature` SET `position_x`=-1921.15, `position_y`=-10583.0, `position_z`=213.888 WHERE `Id`=@TESLA AND `guid`=63629; +UPDATE `creature` SET `position_x`=-1886.11, `position_y`=-10534.5, `position_z`=199.901 WHERE `Id`=@TESLA AND `guid`=63630; + +-- Bloodmyst Tesla target condition +DELETE FROM `conditions` WHERE `SourceEntry`=31611; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`) VALUES +(13, 1, 31611, 0, 0, 31, 0, 3, @SIRONAS, 0); + +-- Legoso +-- Scriptname +UPDATE `creature_template` SET `ScriptName`='npc_demolitionist_legoso' WHERE `entry`=@LEGOSO; +-- Respawn time (this npc respawns very quickly, http://www.wowhead.com/npc=@LEGOSO#comments:id=752881:reply=111200) +UPDATE `creature` SET `spawntimesecs`=30 WHERE `id`=@LEGOSO; + +-- Text +DELETE FROM `creature_text` WHERE `entry`=@LEGOSO; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `probability`, `emote`, `comment`, `BroadcastTextId`) VALUES +(@LEGOSO, 0, 0, 'There''s no turning back now. Stay close and watch my back.', 12, 100, 1, 'npc_demolitionist_legoso SAY_LEGOSO_1',14648), +(@LEGOSO, 1, 0, 'There it is! Do you see where the large red crystal is jutting out from the Vector Coil? That''s where I need to plant the first set of explosives.', 12, 100, 25, 'npc_demolitionist_legoso SAY_LEGOSO_2',14649), +(@LEGOSO, 2, 0, 'Cover me!', 12, 100, 5, 'npc_demolitionist_legoso SAY_LEGOSO_3',14650), +(@LEGOSO, 3, 0, 'It won''t be much longer. Just keep them off me while I work.', 12, 100, 69, 'npc_demolitionist_legoso SAY_LEGOSO_4',14651), +(@LEGOSO, 4, 0, 'That''ll do it! Quickly, take cover!', 12, 100, 5, 'npc_demolitionist_legoso SAY_LEGOSO_5',14652), +(@LEGOSO, 5, 0, '3...', 12, 100, 0, 'npc_demolitionist_legoso SAY_LEGOSO_6',14653), +(@LEGOSO, 6, 0, '2...', 12, 100, 0, 'npc_demolitionist_legoso SAY_LEGOSO_7',14654), +(@LEGOSO, 7, 0, '1...', 12, 100, 0, 'npc_demolitionist_legoso SAY_LEGOSO_8',14655), +(@LEGOSO, 8, 0, 'Don''t get too excited, hero, that was the easy part. The challenge lies ahead! Let''s go.', 12, 100, 1, 'npc_demolitionist_legoso SAY_LEGOSO_9',14656), +(@LEGOSO, 9, 0, 'What in the Nether is that?!?!', 12, 100, 5, 'npc_demolitionist_legoso SAY_LEGOSO_10',14657), +(@LEGOSO, 10, 0, 'Be ready for anything.', 12, 100, 1, 'npc_demolitionist_legoso SAY_LEGOSO_11',14658), +(@LEGOSO, 11, 0, 'Blessed Light! She''s siphoning energy right out of the Vector Coil!', 12, 100, 53, 'npc_demolitionist_legoso SAY_LEGOSO_12',14659), +(@LEGOSO, 12, 0, 'Cover me, we have to do this quickly. Once I blow the support on this side, it will disrupt the energy beams and she''ll break out! I doubt very much that she''ll be happy to see us.', 12, 100, 1, 'npc_demolitionist_legoso SAY_LEGOSO_13',14660), +(@LEGOSO, 13, 0, 'I''ve almost got it! Just a little more time...', 12, 100, 0, 'npc_demolitionist_legoso SAY_LEGOSO_14',14661), +(@LEGOSO, 14, 0, 'Take cover and be ready for the fight of your life!', 12, 100, 5, 'npc_demolitionist_legoso SAY_LEGOSO_15',14662), +(@LEGOSO, 15, 0, '3...', 12, 100, 0, 'npc_demolitionist_legoso SAY_LEGOSO_16',14653), +(@LEGOSO, 16, 0, '2...', 12, 100, 0, 'npc_demolitionist_legoso SAY_LEGOSO_17',14654), +(@LEGOSO, 17, 0, '1...', 12, 100, 0, 'npc_demolitionist_legoso SAY_LEGOSO_18',14655), +(@LEGOSO, 18, 0, 'Holy mother of O''ros!', 12, 100, 5, 'npc_demolitionist_legoso SAY_LEGOSO_19',14663), +(@LEGOSO, 19, 0, 'I... I can''t believe it''s over. You did it! You''ve destoyed the blood elves and their leader!', 12, 100, 1, 'npc_demolitionist_legoso SAY_LEGOSO_20',14664), +(@LEGOSO, 20, 0, 'Get back to Blood Watch. I''ll see you there...', 12, 100, 1, 'npc_demolitionist_legoso SAY_LEGOSO_21',14665); + +-- Waypoints +DELETE FROM `script_waypoint` WHERE `entry`=@LEGOSO; +INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES +(@LEGOSO, 1, -1773.64, -11073.9, 76.8923, 0, 'Legoso'), +(@LEGOSO, 2, -1784.13, -11051.1, 77.2078, 0, 'Legoso'), +(@LEGOSO, 3, -1793.02, -11047.5, 77.1118, 0, 'Legoso'), +(@LEGOSO, 4, -1792.87, -11036.8, 76.2142, 0, 'Legoso'), +(@LEGOSO, 5, -1804.07, -11023.6, 69.8951, 0, 'Legoso'), +(@LEGOSO, 6, -1826.2, -11003.5, 67.3465, 0, 'Legoso'), +(@LEGOSO, 7, -1855, -10992.3, 64.5101, 0, 'Legoso'), +(@LEGOSO, 8, -1888.95, -10966.4, 61.1596, 0, 'Legoso'), +(@LEGOSO, 9, -1913.87, -10935.6, 61.4501, 0, 'Legoso'), +(@LEGOSO, 10, -1927.65, -10907.8, 62.7226, 0, 'Legoso'), +(@LEGOSO, 11, -1932.9, -10868.6, 66.2437, 0, 'Legoso'), +(@LEGOSO, 12, -1940.75, -10853.8, 69.1475, 0, 'Legoso'), +(@LEGOSO, 13, -1934.66, -10821.3, 80.0018, 0, 'Legoso'), +(@LEGOSO, 14, -1940.5, -10807.7, 84.7886, 0, 'Legoso'), +(@LEGOSO, 15, -1966.12, -10791.9, 88.6942, 0, 'Legoso'), +(@LEGOSO, 16, -1977.82, -10778.2, 89.1746, 0, 'Legoso'), +(@LEGOSO, 17, -1980.04, -10757.3, 91.1206, 0, 'Legoso'), +(@LEGOSO, 18, -1959.13, -10739.6, 98.335, 0, 'Legoso'), +(@LEGOSO, 19, -1947.52, -10721.8, 108.46, 0, 'Legoso'), +(@LEGOSO, 20, -1947.04, -10711.1, 111.313, 0, 'Legoso'), +(@LEGOSO, 21, -1953.05, -10682.2, 110.582, 0, 'Legoso'), +(@LEGOSO, 22, -1955.6, -10669.8, 110.65, 0, 'Legoso'), +(@LEGOSO, 23, -1967.13, -10677.3, 111.37, 0, 'Legoso'), +(@LEGOSO, 24, -1987.29, -10701.7, 116.038, 0, 'Legoso'), +(@LEGOSO, 25, -2008.1, -10664.8, 120.99, 0, 'Legoso'), +(@LEGOSO, 26, -2021.77, -10648.8, 129.903, 0, 'Legoso'), +(@LEGOSO, 27, -2022.39, -10647.7, 130.624, 0, 'Legoso'), +(@LEGOSO, 28, -2039.34, -10632.7, 143, 0, 'Legoso'), +(@LEGOSO, 29, -2041.41, -10624.6, 145.187, 0, 'Legoso'), +(@LEGOSO, 30, -2036.49, -10617.1, 146.52, 0, 'Legoso'), +(@LEGOSO, 31, -2026.12, -10606.9, 150.263, 0, 'Legoso'), +(@LEGOSO, 32, -1993, -10613.7, 161.852, 0, 'Legoso'), +(@LEGOSO, 33, -1970.41, -10616.8, 163.838, 0, 'Legoso'), +(@LEGOSO, 34, -1953.78, -10590.9, 170.538, 0, 'Legoso'), +(@LEGOSO, 35, -1942.51, -10577.7, 175.276, 0, 'Legoso'), +(@LEGOSO, 36, -1937.517090, -10575.675781, 176.253082, 0, 'Legoso'), +(@LEGOSO, 37, -1926.401733, -10577.000977, 177.240952, 0, 'Legoso'), +(@LEGOSO, 38, -1920.892212, -10575.630859, 177.493637, 0, 'Legoso'), +(@LEGOSO, 39, -1913.378662, -10575, 178.044113, 0, 'Legoso'), +(@LEGOSO, 40, -1951.17, -10555, 177.33, 0, 'Legoso'), +(@LEGOSO, 41, -1946.9, -10557.8, 177.7, 0, 'Legoso'); + +-- Exarch Admetius +-- Text +DELETE FROM `creature_text` WHERE `entry`=@ADMETIUS; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `probability`, `emote`, `comment`, `BroadcastTextId`) VALUES +(@ADMETIUS, 0, 0, 'All hail $N, savior of Azuremyst and Bloodmyst. Hero of the Hand of Argus, champion of the draenei people!', 14, 100, 22, 'Exarch Admetius q9759 OnRewarded',14691); + +-- Exarch Admetius SAI +SET @ENTRY := 17658; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,20,0,100,1,9759,0,0,0,1,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Exarch Admetius - On Quest 'Ending Their World' Finished - Say Line 0 (No Repeat)"); |