API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 29th, 2014
248
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 20.96 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. Autor: Pitcrawler
  3. Ticket: #149
  4. Descr.: Fix quest: Springing the Trap (11969)
  5. */
  6.  
  7. SET @CGUID := 3107662; -- need 5
  8. SET @OGUID := 2033190; -- need 1
  9.  
  10. SET @SOLDIER := 24769;
  11. SET @KERISTRASZA := 26237;
  12. SET @SARAGOSA := 26299;
  13. SET @MALYGOS := 26310;
  14. SET @COLDARRA_INVISMAN := 26373;
  15. SET @MALYGOS2 := 29655;
  16. SET @INVISMAN := 33087;
  17. SET @SIGNALFIRE := 194151;
  18.  
  19. DELETE FROM `creature_template_addon` WHERE `entry`=26310;
  20. INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
  21. (26310,0,0,0x1000000|0x2000000,0x1,0, '43775');
  22.  
  23. UPDATE `creature` SET `spawntimesecs`=1 WHERE `guid`=3107665;
  24. UPDATE `creature_template` SET `inhabitType`=4 WHERE `entry`=@SOLDIER;
  25. UPDATE `creature_template` SET `speed_walk`=3.6, `speed_run`=2.857143, `faction_A`=1816 , `faction_H`=1816, `unit_flags`=832, `inhabitType`=5 WHERE `entry`=@KERISTRASZA;
  26. UPDATE `creature_template` SET `speed_walk`=2, `speed_run`=1.714286, `unit_flags`=768 WHERE `entry`=@SARAGOSA;
  27. UPDATE `creature_template` SET `speed_walk`=8, `speed_run`=4.714286, `unit_flags`=832, `inhabitType`=4 WHERE `entry`=@MALYGOS;
  28.  
  29. DELETE FROM `creature_template_addon` WHERE `entry` IN (@KERISTRASZA,@SARAGOSA,@MALYGOS);
  30. INSERT INTO `creature_template_addon` (`entry`,`bytes1`,`bytes2`,`auras`) VALUES
  31. (@KERISTRASZA,50331648,1,''),
  32. (@SARAGOSA,0,1,'29266'),
  33. (@MALYGOS,50331648,1,'65137');
  34.  
  35. DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+2;
  36. INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes1`,`bytes2`,`auras`) VALUES
  37. (@CGUID+0,(@CGUID+0)*10,50331648,1,'65185'),
  38. (@CGUID+1,(@CGUID+1)*10,50331648,1,'65185'),
  39. (@CGUID+2,(@CGUID+2)*10,50331648,1,'65185');
  40.  
  41. UPDATE `creature_template` SET `rank`=0 WHERE `entry`=26310;
  42. UPDATE `creature` SET `spawntimesecs`=60 WHERE `guid`=72773;
  43. DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+4;
  44. INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`MovementType`) VALUES
  45. (@CGUID+0, @SOLDIER, 571, 1, 1, 24737, 0, 3780.585, 6961.891, 615.3891, 0, 1, 0, 2),
  46. (@CGUID+1, @SOLDIER, 571, 1, 1, 24737, 0, 3694.591, 6905.624, 588.2004, 0, 1, 0, 2),
  47. (@CGUID+2, @SOLDIER, 571, 1, 1, 24737, 0, 3715.599, 6790.909, 576.1764, 0, 1, 0, 2),
  48. (@CGUID+3, @MALYGOS, 571, 1, 1, 27176, 0, 3767.673, 6843.96, 544.4875, 4.066617, 1, 0, 0),
  49. (@CGUID+4, @INVISMAN, 571, 1, 1, 15435, 0, 4062.013, 7108.927, 170.0696, 0, 1, 0, 0);
  50.  
  51. DELETE FROM `gameobject` WHERE `guid`=@OGUID;
  52. INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  53. (@OGUID, 194152, 571, 1, 1, 4061.978, 7109.135, 170.0001, 0, 0, 0, 0, 1, -60, 255, 1);
  54.  
  55. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (@KERISTRASZA,@SARAGOSA,@MALYGOS,@COLDARRA_INVISMAN,@MALYGOS2,@INVISMAN);
  56. UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry`=@SIGNALFIRE;
  57. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@KERISTRASZA,@SARAGOSA,@MALYGOS,@COLDARRA_INVISMAN,@MALYGOS2,@INVISMAN) AND `source_type`=0;
  58. DELETE FROM `smart_scripts` WHERE `entryorguid`=@SIGNALFIRE AND `source_type`=1;
  59. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@KERISTRASZA*100+0,@KERISTRASZA*100+1,@KERISTRASZA*100+2,@MALYGOS*100,@MALYGOS2*100,@SIGNALFIRE*100) AND `source_type`=9;
  60. 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
  61. (@KERISTRASZA,0,0,0,38,0,100,0,0,1,0,0,53,0,@KERISTRASZA,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza - On data 0 1 set - Start WP movement'),
  62. (@KERISTRASZA,0,1,2,40,0,100,0,4,@KERISTRASZA,0,0,54,16000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza - On WP 4 reached - Pause WP movement 16 seconds'),
  63. (@KERISTRASZA,0,2,0,61,0,100,0,0,0,0,0,80,@KERISTRASZA*100+0,2,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza - On WP 4 reached - Start script 0'),
  64. (@KERISTRASZA,0,3,4,40,0,100,0,6,0,0,0,12,@SARAGOSA,3,40000,0,0,0,8,0,0,0,4032.4,7086.208,166.6852,4.328416, 'Keristrasza - On WP 6 reached - Summon Corpse of Saragosa'),
  65. (@KERISTRASZA,0,4,5,61,0,100,0,0,0,0,0,55,40000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza - On WP 6 reached - Pause WP movement 40 seconds'),
  66. (@KERISTRASZA,0,5,0,61,0,100,0,0,0,0,0,80,@KERISTRASZA*100+1,2,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza - On WP 6 reached - Start script 1'),
  67. (@KERISTRASZA,0,6,0,38,0,100,0,0,2,0,0,69,7,0,0,0,0,0,8,0,0,0,3803.340576,6569.079590,168.872818,0, 'Keristrasza - On data 0 1 set - Move to position'),
  68. /* 3869.212,6573.451,168.671,0 -- old*/
  69. (@KERISTRASZA,0,7,0,34,0,100,0,0,7,0,0,80,@KERISTRASZA*100+2,2,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza - On movement inform - Run script'),
  70. (@KERISTRASZA,0,8,9,8,0,100,0,46886,0,0,0,1,6,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza - On spellhit Frost Breath - Say line'),
  71. (@KERISTRASZA,0,9,0,61,0,100,0,0,0,0,0,11,46882,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza - On spellhit Frost Breath - Spellcast Ice Block'),
  72. (@KERISTRASZA,0,10,11,8,0,100,0,46902,0,0,0,11,37712,2,0,0,0,0,17,0,200,0,0,0,0,0,"Keristrasza - On Spellhit 'Malygos Teleport' - Cast 'Keristrasza Kill Credit'"),
  73. (@KERISTRASZA,0,11,0,61,0,100,0,46902,0,0,0,41,2000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Keristrasza - On Spellhit 'Malygos Teleport' - Despawn In 2000 ms"),
  74. -- (@KERISTRASZA,0,10,0,11,0,100,0,0,0,0,0,28,46882,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza - On spawn - Remove aura Ice Block'),
  75.  
  76. (@SARAGOSA,0,0,0,38,0,100,0,0,1,0,0,11,42726,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Corpse of Saragosa - On data 0 1 set - Spellcast Cosmetic - Immolation (Whole Body)'),
  77. (@SARAGOSA,0,1,0,11,0,100,0,0,0,0,0,28,42726,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Corpse of Saragosa - On spawn - Remove aura Cosmetic - Immolation (Whole Body)'),
  78.  
  79. (@COLDARRA_INVISMAN,0,0,1,10,0,100,1,1,20,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Coldarra Spell FX InvisMan - On LOS OOC - Store targetlist'),
  80. (@COLDARRA_INVISMAN,0,1,2,61,0,100,0,0,0,0,0,12,@KERISTRASZA,8,0,0,0,0,8,0,0,0,3815.650635,6561.799805,169.547836,2.837165, 'Coldarra Spell FX InvisMan - On LOS OOC - Summon Keristrasza'),
  81. /*changed spawnposition due to taxi-wp-issues*/
  82. (@COLDARRA_INVISMAN,0,2,3,61,0,100,0,0,0,0,0,100,1,0,0,0,0,0,19,@KERISTRASZA,50,0,0,0,0,0, 'Coldarra Spell FX InvisMan - On LOS OOC - Send targetlist to Keristrasza'),
  83. (@COLDARRA_INVISMAN,0,3,4,61,0,100,0,0,0,0,0,45,0,2,0,0,0,0,19,@KERISTRASZA,50,0,0,0,0,0, 'Coldarra Spell FX InvisMan - On LOS OOC - Send data 0 2 Keristrasza'),
  84. (@COLDARRA_INVISMAN,0,4,0,61,0,100,0,0,0,0,0,11,37712,0,0,0,0,0,1,0,0,0,0,0,0,0,'Coldarra Spell FX InvisMan - On LOS OOC - Cast Spellcredit'),
  85.  
  86. (@MALYGOS2,0,0,0,38,0,100,0,0,1,0,0,80,@MALYGOS2*100,2,0,0,0,0,1,0,0,0,0,0,0,0, 'Maylgos - On data 0 1 set - Run script'),
  87.  
  88. (@INVISMAN,0,0,1,8,0,100,0,62272,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Signal Fire Invisman - On spellhit Raelorasz'' Spark - Store target'),
  89. (@INVISMAN,0,1,2,61,0,100,0,0,0,0,0,12,@KERISTRASZA,8,60000,0,0,0,8,0,0,0,4098.674,7064.292,198.7698,0, 'Signal Fire Invisman - On spellhit Raelorasz'' Spark - Summon Keristrasza'),
  90. (@INVISMAN,0,2,3,61,0,100,0,0,0,0,0,100,1,0,0,0,0,0,19,@KERISTRASZA,100,0,0,0,0,0, 'Signal Fire Invisman - On spellhit Raelorasz'' Spark - Send targetlist'),
  91. (@INVISMAN,0,3,4,61,0,100,0,0,0,0,0,45,0,1,0,0,0,0,20,@SIGNALFIRE,5,0,0,0,0,0, 'Signal Fire Invisman - On spellhit Raelorasz'' Spark - Set data 0 1 Signal Fire'),
  92. (@INVISMAN,0,4,0,61,0,100,0,0,0,0,0,45,0,1,0,0,0,0,19,@KERISTRASZA,100,0,0,0,0,0, 'Signal Fire Invisman - On spellhit Raelorasz'' Spark - Set data 0 1 Keristrasza'),
  93.  
  94. (@SIGNALFIRE,1,0,1,38,0,100,0,0,1,0,0,44,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Signal Fire - On data 0 1 set - Set phasemask 2'),
  95. (@SIGNALFIRE,1,1,0,61,0,100,0,0,0,0,0,80,@SIGNALFIRE*100,2,0,0,0,0,1,0,0,0,0,0,0,0, 'Signal Fire - On data 0 1 set - Run script'),
  96.  
  97. (@KERISTRASZA*100+0,9,0,0,0,0,100,0,0,0,0,0,90,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza script 0 - Remove unit_field_bytes1 (flying + hovering)'),
  98. (@KERISTRASZA*100+0,9,1,0,0,0,100,0,0,0,0,0,60,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza script 0 - Disable fly'),
  99. (@KERISTRASZA*100+0,9,2,0,0,0,100,0,4000,4000,0,0,66,0,0,0,0,0,0,12,1,0,0,0,0,0,0, 'Keristrasza script 0 - Turn to'),
  100. (@KERISTRASZA*100+0,9,3,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,12,1,0,0,0,0,0,0, 'Keristrasza script 0 - Say line'),
  101. (@KERISTRASZA*100+0,9,4,0,0,0,100,0,10000,10000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza script 0 - Say line'),
  102.  
  103. (@KERISTRASZA*100+1,9,0,0,0,0,100,0,6000,6000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza script 1 - Say line'),
  104. (@KERISTRASZA*100+1,9,1,0,0,0,100,0,4000,4000,0,0,11,45852,0,0,0,0,0,0,0,0,0,0,0,0,0, 'Keristrasza script 1 - Spellcast Cosmetic - Dragon''s Breath'),
  105. (@KERISTRASZA*100+1,9,2,0,0,0,100,0,3500,3500,0,0,45,0,1,0,0,0,0,19,@SARAGOSA,20,0,0,0,0,0, 'Keristrasza script 1 - Say line'),
  106. (@KERISTRASZA*100+1,9,3,0,0,0,100,0,1500,1500,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza script 1 - Say line'),
  107. (@KERISTRASZA*100+1,9,4,0,0,0,100,0,10000,10000,0,0,11,46853,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza script 1 - Spellcast Malygos in Coldarra'),
  108. (@KERISTRASZA*100+1,9,5,0,0,0,100,0,5000,5000,0,0,66,0,0,0,0,0,0,12,1,0,0,0,0,0,0, 'Keristrasza script 1 - Turn to'),
  109. (@KERISTRASZA*100+1,9,6,0,0,0,100,0,0,0,0,0,1,4,0,0,0,0,0,12,1,0,0,0,0,0,0, 'Keristrasza script 1 - Say line'),
  110. (@KERISTRASZA*100+1,9,7,0,0,0,100,0,4000,4000,0,0,11,46813,0,0,0,0,0,12,1,0,0,0,0,0,0, 'Keristrasza script 1 - Spellcast Taxi - Coldarra Ledge to Transitus Shield'),
  111. (@KERISTRASZA*100+1,9,8,0,0,0,100,0,1000,1000,0,0,45,0,1,0,0,0,0,19,@MALYGOS2,20,0,0,0,0,0, 'Keristrasza script 1 - Set data 0 1 Malygos'),
  112. (@KERISTRASZA*100+1,9,9,0,0,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza script 1 - Despawn'),
  113.  
  114. (@KERISTRASZA*100+2,9,0,0,0,0,100,0,0,0,0,0,91,50331648,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza script 2 - Remove unit_field_bytes1 (flying + hovering)'),
  115. (@KERISTRASZA*100+2,9,1,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,12,1,0,0,0,0,0,0, 'Keristrasza script 2 - Turn to'),
  116. (@KERISTRASZA*100+2,9,2,0,0,0,100,0,500,500,0,0,5,293,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza script 2 - Play emote'),
  117. (@KERISTRASZA*100+2,9,3,0,0,0,100,0,4000,4000,0,0,11,37712,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Keristrasza script 2 - Spellcast Keristrasza Kill Credit'),
  118. (@KERISTRASZA*100+2,9,4,0,0,0,100,0,0,0,0,0,1,5,0,0,0,0,0,12,1,0,0,0,0,0,0, 'Keristrasza script 2 - Say line'),
  119.  
  120. (@MALYGOS2*100,9,0,0,0,0,100,0,4000,4000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Malygos script - Say line'),
  121.  
  122. (@SIGNALFIRE*100,9,0,0,0,0,100,0,60000,60000,0,0,44,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Signal Fire script - Set phasemask 1');
  123.  
  124. -- Malygos SAI
  125. SET @ENTRY := 26310;
  126. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  127. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
  128. 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
  129. (@ENTRY,0,0,1,10,0,100,1,1,30,0,0,28,65137,0,0,0,0,0,1,0,0,0,0,0,0,0,"Malygos - Within 1-30 Range Out of Combat LoS - Remove Aura 'Malygos Periodic Aura' (No Repeat)"),
  130. (@ENTRY,0,1,0,61,0,100,0,1,30,0,0,53,0,26310,0,0,0,0,1,0,0,0,0,0,0,0,"Malygos - Within 1-30 Range Out of Combat LoS - Start Waypoint (No Repeat)"),
  131. (@ENTRY,0,2,0,40,0,100,0,10,26310,0,0,80,@ENTRY*100+00,2,0,0,0,0,1,0,0,0,0,0,0,0,"Malygos - On Waypoint 10 Reached - Run Script"),
  132. (@ENTRY,0,3,0,11,0,100,0,0,0,0,0,75,65137,0,0,0,0,0,1,0,0,0,0,0,0,0,"Malygos - On Respawn - Add Aura 'Malygos Periodic Aura'"),
  133. (@ENTRY,0,4,0,11,0,100,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Malygos - On Respawn - Set Active On"),
  134. (@ENTRY,0,5,0,25,0,100,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Malygos - On Reset - Set Active On");
  135.  
  136. -- Actionlist SAI
  137. SET @ENTRY := 2631000;
  138. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9;
  139. 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
  140. (@ENTRY,9,0,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Malygos - On Script - Say Line 0"),
  141. (@ENTRY,9,1,0,0,0,100,0,7000,7000,0,0,66,0,0,0,0,0,0,19,26237,50,0,0,0,0,0,"Malygos - On Script - Set Orientation Closest Creature 'Keristrasza'"),
  142. (@ENTRY,9,2,0,0,0,100,0,0,0,0,0,11,46886,0,0,0,0,0,19,26237,50,0,0,0,0,0,"Malygos - On Script - Cast 'Frost Breath'"),
  143. (@ENTRY,9,3,0,0,0,100,0,7000,7000,0,0,11,46902,0,0,0,0,0,1,0,0,0,0,0,0,0,"Malygos - On Script - Cast 'Malygos Teleport'"),
  144. (@ENTRY,9,4,0,0,0,100,0,1000,1000,0,0,37,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Malygos - On Script - Kill Self"),
  145. (@ENTRY,9,5,0,0,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Malygos - On Script - Despawn Instant");
  146.  
  147. DELETE FROM `event_scripts` WHERE `id`=17491;
  148. INSERT INTO `event_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES
  149. (17491,0,9,@OGUID,60,0,0,0,0,0); -- Spawn burning Signal Fire
  150.  
  151. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=-46813;
  152. INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES
  153. (-46813,46814,0,'On spellfade Taxi - Coldarra Ledge to Transitus Shield - Spellcast Coldarra to Transitus');
  154.  
  155. DELETE FROM `disables` WHERE `sourceType`=0 AND `entry`=62272;
  156. INSERT INTO `disables` (`sourceType`,`entry`,`flags`,`params_0`,`params_1`,`comment`) VALUES
  157. (0,62272,64,0,0,'Disable LOS for spell Raelorasz'' Spark');
  158.  
  159. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (46886,46900,46902,62272);
  160. INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
  161. (13,1,46886,0,0,31,0,3,@SOLDIER,0,0,'','Spell Frost Breath targets Red Dragon Soldier'),
  162. (13,1,46886,0,1,31,0,3,@KERISTRASZA,0,0,'','Spell Frost Breath targets Keristrasza'),
  163. (13,1,46900,0,0,31,0,3,@MALYGOS,0,0,'','Spell Dragon Fireball targets Malygos'),
  164. (13,1,46902,0,0,31,0,3,@KERISTRASZA,0,0,'','Spell Malygos Teleport effect0 targets Keristrasza'),
  165. (13,1,62272,0,0,31,0,3,@INVISMAN,0,0,'','Spell Raelorasz'' Spark targets Signal Fire Invisman');
  166.  
  167. DELETE FROM `creature_text` WHERE `entry` IN (@KERISTRASZA,@MALYGOS,@MALYGOS2,@INVISMAN);
  168. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  169. (@KERISTRASZA,0,0,'Stay close to me, $n. I could not bear for any harm to come to you.',12,0,100,1,0,0,'Keristrasza'),
  170. (@KERISTRASZA,1,0,'MALYGOS!!',14,0,100,15,0,7274,'Keristrasza'),
  171. (@KERISTRASZA,2,0,'Come, Lord of Magic, and recover your precious consort....',14,0,100,1,0,0,'Keristrasza'),
  172. (@KERISTRASZA,3,0,'...what remains of her!',14,0,100,0,0,0,'Keristrasza'),
  173. (@KERISTRASZA,4,0,'Come, $n. Let us see the fruits of our efforts.',12,0,100,0,0,0,'Keristrasza'),
  174. (@KERISTRASZA,5,0,'Hurry, $n! Flee! Live to finish what we''ve begun here....',12,0,100,0,0,0,'Keristrasza'),
  175. (@KERISTRASZA,6,0,'Never!',14,0,100,0,0,0,'Keristrasza'),
  176. (@MALYGOS,0,0,'Keristrasza! You''ve bested my consort... and now YOU shall take her place!',14,0,100,0,0,0,'Malygos'),
  177. (@MALYGOS2,0,0,'Saragosa! What has become of you?',14,0,100,0,0,0,'Malygos');
  178.  
  179. DELETE FROM `waypoints` WHERE `entry` IN (@KERISTRASZA,@MALYGOS);
  180. INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES
  181. (@KERISTRASZA, 1, 4098.674, 7064.292, 198.7698, 'Keristrasza'),
  182. (@KERISTRASZA, 2, 4092.762, 7067.315, 193.3262, 'Keristrasza'),
  183. (@KERISTRASZA, 3, 4079.077, 7074.162, 176.2149, 'Keristrasza'),
  184. (@KERISTRASZA, 4, 4063.685, 7083.67, 167.8817, 'Keristrasza'),
  185. (@KERISTRASZA, 5, 4045.307, 7083.389, 168.241, 'Keristrasza'),
  186. (@KERISTRASZA, 6, 4040.892, 7083.875, 168.116, 'Keristrasza'),
  187.  
  188. (@MALYGOS, 1, 3736.729, 6813.358, 533.4736, 'Malygos'),
  189. (@MALYGOS, 2, 3732.188, 6794.312, 487.0847, 'Malygos'),
  190. (@MALYGOS, 3, 3730.688, 6769.336, 444.0849, 'Malygos'),
  191. (@MALYGOS, 4, 3726.533, 6750.502, 398.3348, 'Malygos'),
  192. (@MALYGOS, 5, 3725.144, 6735.662, 351.0848, 'Malygos'),
  193. (@MALYGOS, 6, 3733.896, 6705.199, 312.0294, 'Malygos'),
  194. (@MALYGOS, 7, 3735.563, 6692.039, 264.474, 'Malygos'),
  195. (@MALYGOS, 8, 3739.076, 6675.249, 218.3628, 'Malygos'),
  196. (@MALYGOS, 9, 3746.836, 6657.269, 186.8073, 'Malygos'),
  197. (@MALYGOS,10, 3751.5, 6635.882, 186.8073, 'Malygos'),
  198. (@MALYGOS,11, 3766.236, 6622.118, 186.8073, 'Malygos'),
  199. (@MALYGOS,12, 3794.761, 6612.983, 186.8073, 'Malygos'),
  200. (@MALYGOS,13, 3826.566, 6605.694, 195.7795, 'Malygos'),
  201. (@MALYGOS,14, 3838.386, 6601.479, 199.7516, 'Malygos');
  202.  
  203. DELETE FROM `waypoint_data` WHERE `id` IN ((@CGUID+0)*10,(@CGUID+1)*10,(@CGUID+2)*10,(@CGUID+3)*10,(@CGUID+4)*10);
  204. INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
  205. ((@CGUID+0)*10, 1,3780.585,6961.891,615.3891),
  206. ((@CGUID+0)*10, 2,3781.443,6961.375,615.3891),
  207. ((@CGUID+0)*10, 3,3788.726,6952.882,619.7848),
  208. ((@CGUID+0)*10, 4,3809.698,6939.206,609.7292),
  209. ((@CGUID+0)*10, 5,3829.648,6917.982,597.0071),
  210. ((@CGUID+0)*10, 6,3845.798,6899.093,586.6738),
  211. ((@CGUID+0)*10, 7,3864.757,6857.222,572.757),
  212. ((@CGUID+0)*10, 8,3862.349,6824.601,561.4517),
  213. ((@CGUID+0)*10, 9,3850.486,6797.143,559.7294),
  214. ((@CGUID+0)*10,10,3828.732,6772.135,562.8682),
  215. ((@CGUID+0)*10,11,3795.058,6761.407,568.9792),
  216. ((@CGUID+0)*10,12,3760.513,6774.492,581.5349),
  217. ((@CGUID+0)*10,13,3720.332,6799.233,597.9792),
  218. ((@CGUID+0)*10,14,3697.16,6835.938,619.7848),
  219. ((@CGUID+0)*10,15,3681.756,6872.03,619.7848),
  220. ((@CGUID+0)*10,16,3672.802,6901.496,619.7848),
  221. ((@CGUID+0)*10,17,3672.081,6921.473,619.7848),
  222. ((@CGUID+0)*10,18,3675.869,6947.217,619.7848),
  223. ((@CGUID+0)*10,19,3696.144,6973.719,619.7848),
  224. ((@CGUID+0)*10,20,3723.596,6980.155,619.7848),
  225. ((@CGUID+0)*10,21,3761.115,6971.517,619.7848),
  226. ((@CGUID+0)*10,22,3788.726,6952.882,619.7848),
  227. ((@CGUID+0)*10,23,3809.698,6939.206,609.7292),
  228.  
  229. ((@CGUID+1)*10, 1,3694.591,6905.624,588.2004),
  230. ((@CGUID+1)*10, 2,3694.486,6904.629,588.2004),
  231. ((@CGUID+1)*10, 3,3687.71,6887.773,599.449),
  232. ((@CGUID+1)*10, 4,3681.292,6860.081,599.449),
  233. ((@CGUID+1)*10, 5,3684.588,6828.854,601.2267),
  234. ((@CGUID+1)*10, 6,3702.324,6800.028,602.0601),
  235. ((@CGUID+1)*10, 7,3742.879,6774.088,612.5878),
  236. ((@CGUID+1)*10, 8,3786.845,6777.308,626.338),
  237. ((@CGUID+1)*10, 9,3803.426,6793.12,641.338),
  238. ((@CGUID+1)*10,10,3818.26,6820.016,651.0602),
  239. ((@CGUID+1)*10,11,3824.966,6848.016,656.3936),
  240. ((@CGUID+1)*10,12,3813.837,6884.006,649.3936),
  241. ((@CGUID+1)*10,13,3787.394,6910.689,636.1436),
  242. ((@CGUID+1)*10,14,3762.704,6925.763,628.9214),
  243. ((@CGUID+1)*10,15,3741.792,6934.354,621.9214),
  244. ((@CGUID+1)*10,16,3720.52,6935.709,615.1437),
  245. ((@CGUID+1)*10,17,3702.77,6929.314,607.838),
  246. ((@CGUID+1)*10,18,3692.661,6917.933,604.2271),
  247. ((@CGUID+1)*10,19,3689.077,6901.22,601.1439),
  248. ((@CGUID+1)*10,20,3687.71,6887.773,599.449),
  249. ((@CGUID+1)*10,21,3681.292,6860.081,599.449),
  250.  
  251. ((@CGUID+2)*10, 1,3715.599,6790.909,576.1764),
  252. ((@CGUID+2)*10, 2,3733.311,6795.495,575.6484),
  253. ((@CGUID+2)*10, 3,3746.552,6797.681,571.1484),
  254. ((@CGUID+2)*10, 4,3758.14,6796.333,567.8428),
  255. ((@CGUID+2)*10, 5,3769.744,6788.941,566.5097),
  256. ((@CGUID+2)*10, 6,3774.698,6775.426,565.4541),
  257. ((@CGUID+2)*10, 7,3772.478,6758.345,564.0373),
  258. ((@CGUID+2)*10, 8,3761.064,6744.284,561.3151),
  259. ((@CGUID+2)*10, 9,3742.062,6734.352,558.0375),
  260. ((@CGUID+2)*10,10,3722.155,6732.545,558.4818),
  261. ((@CGUID+2)*10,11,3710.604,6738.485,558.4818),
  262. ((@CGUID+2)*10,12,3702.351,6755.943,553.5372),
  263. ((@CGUID+2)*10,13,3702.623,6781.31,558.315),
  264. ((@CGUID+2)*10,14,3710.322,6803.959,558.4818),
  265. ((@CGUID+2)*10,15,3707.133,6828.621,558.4818),
  266. ((@CGUID+2)*10,16,3694.577,6842.447,558.4818),
  267. ((@CGUID+2)*10,17,3677.345,6846.772,558.4818),
  268. ((@CGUID+2)*10,18,3658.489,6838.999,562.2039),
  269. ((@CGUID+2)*10,19,3643.681,6818.719,570.5095),
  270. ((@CGUID+2)*10,20,3640.345,6800.429,574.6765),
  271. ((@CGUID+2)*10,21,3649.234,6780.53,576.1764),
  272. ((@CGUID+2)*10,22,3662.512,6771.815,576.1764),
  273. ((@CGUID+2)*10,23,3689.853,6776.469,576.1764),
  274. ((@CGUID+2)*10,24,3715.599,6790.909,576.1764),
  275. ((@CGUID+2)*10,25,3733.311,6795.495,575.6484),
  276. ((@CGUID+2)*10,26,3746.552,6797.681,571.1484);
  277.  
  278. UPDATE `creature` SET `position_x`=3815.650635, `position_y`=6561.799805, `position_z`=169.547836, `orientation`=2.837165 WHERE `guid`=120952;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!