1. INSERT IGNORE INTO `spell_script_target` (`entry`, `type`, `targetEntry`, `inverseEffectMask`) values('100472','1','52409','0');
  2. INSERT IGNORE INTO `spell_script_target` (`entry`, `type`, `targetEntry`, `inverseEffectMask`) values('100567','1','53500','0');
  3. -- Creature id: 53872 Cenarious Firelands.
  4. UPDATE creature_template SET AIName='EventAI' WHERE entry=53872;
  5. DELETE FROM creature_ai_scripts WHERE creature_id=53872;
  6. INSERT INTO creature_ai_scripts VALUES
  7. ('5387201','53872','11','0','100','24','0','0','0','0','1','-542097','0','0','0','0','0','0','0','0','0','0','YTDB Cenarious - Yell at Spawn.'),
  8. ('5387202','53872','1','0','100','25','3000','3000','30000','30000','11','100479','0','1','0','0','0','0','0','0','0','0','YTDB Cenarious - Cast Bread of Frost.');
  10. DELETE FROM `creature_template_addon` WHERE (`entry`=52409);
  11. INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `b2_0_sheath`, `b2_1_pvp_state`, `emote`, `moveflags`, `auras`) VALUES (52409, 0, 50331648, 1, 0, 0, 0, '');
  13. -- Creature id: 53086 Magma Trap.
  14. UPDATE creature_template SET AIName='EventAI' WHERE entry=53086;
  15. DELETE FROM creature_ai_scripts WHERE creature_id=53086;
  16. INSERT INTO creature_ai_scripts VALUES
  17. ('5308601','53086','1','0','100','30','1000','1000','10000','10000','11','98179','0','1','0','0','0','0','0','0','0','0','YTDB Magma Trap - Cast Magma Trap Visual.'),
  18. ('5308602','53086','11','0','100','30','0','0','0','0','11','98179','0','2','0','0','0','0','0','0','0','0','YTDB Magma Trap - Cast Magma Trap Visual.'),
  19. ('5308603','53086','10','0','100','6','0','8','5000','5000','11','98175','0','1','41','2000','0','0','0','0','0','0','YTDB Magma Trap - Cast Magma Trap Explosion on Normal at OOC LOS 8 yards.'),
  20. ('5308604','53086','10','0','100','24','0','8','5000','5000','11','100107','0','0','41','2000','0','0','0','0','0','0','YTDB Magma Trap - Cast Magma Trap Explosion on Heroic at OOC LOS 8 yards.');
  22. -- Text id: -542107
  23. DELETE FROM creature_ai_texts WHERE entry=-542107;
  24. INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  25. ('-542107','Sulfuras will be your end.','24525','6','0','YTDB Yell Sulfuras.','0');
  26. -- Text id: -542106
  27. DELETE FROM creature_ai_texts WHERE entry=-542106;
  28. INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  29. ('-542106','Die, insect!','24531','6','0','YTDB Ragnaros Slay 3','0');
  30. -- Text id: -542105
  31. DELETE FROM creature_ai_texts WHERE entry=-542105;
  32. INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  33. ('-542105','Pathetic.','24530','6','0','YTDB Ragnaros Slay 2','0');
  34. -- Text id: -542104
  35. DELETE FROM creature_ai_texts WHERE entry=-542104;
  36. INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  37. ('-542104','This is MY realm!','24529','6','0','YTDB Ragnaros Slay 1','0');
  38. -- Text id: -542103
  39. DELETE FROM creature_ai_texts WHERE entry=-542103;
  40. INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  41. ('-542103','Enough! I will finish this.','24523','6','0','YTDB Ragnaros Yell in Phase 2','0');
  42. -- Text id: -542102
  43. DELETE FROM creature_ai_texts WHERE entry=-542102;
  44. INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  45. ('-542102','Arrggh, outsiders - this is not your realm!','24527','6','0','YTDB Ragnaros Yell in Phase 4','0');
  46. -- Text id: -542101
  47. DELETE FROM creature_ai_texts WHERE entry=-542101;
  48. INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  49. ('-542101','When I finish this, your pathetic mortal world will burn with my vengeance!','24526','6','0','YTDB Ragnaros Yell in Phase 4','0');
  50. -- Text id: -542100
  51. DELETE FROM creature_ai_texts WHERE entry=-542100;
  52. INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  53. ('-542100','No, noooo- This was to be my hour of triumph...','24518','6','0','YTDB Ragnaros Yell just death(heroic only)','0');
  54. -- Text id: -542099
  55. DELETE FROM creature_ai_texts WHERE entry=-542099;
  56. INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  57. ('-542099','Be consumed by flame!','24535','6','0','YTDB Ragnaros Yell Agrro 2','0');
  58. -- Text id: -542098
  59. DELETE FROM creature_ai_texts WHERE entry=-542098;
  60. INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  61. ('-542098','I will see you all burn.','24534','6','0','YTDB Ragnaros Aggro 1','0');
  62. -- Text id: -542097
  63. DELETE FROM creature_ai_texts WHERE entry=-542097;
  64. INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  65. ('-542097','No, fiend. Your time is NOW.','25159','6','0','YTDB Cenarius Yell in Phase 4','0');
  66. -- Text id: -542096
  67. DELETE FROM creature_ai_texts WHERE entry=-542096;
  68. INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  69. ('-542096','Heroes! He is bound. Finish him!','25169','6','0','YTDB Malfurion Yell in Set Phase 4','0');
  70. -- Text id: -542095
  71. DELETE FROM creature_ai_texts WHERE entry=-542095;
  72. INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  73. ('-542095','Too soon...','24528','6','0','YTDB Ragnaros Set Phase 4','0');
  74. -- Text id: -542094
  75. DELETE FROM creature_ai_texts WHERE entry=-542094;
  76. INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  77. ('-542094','Too soon! ... You have come too soon...','24519','6','0','YTDB Ragnaros combat stop in normal','0');
  78. -- Text id: -542093
  79. DELETE FROM creature_ai_texts WHERE entry=-542093;
  80. INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  81. ('-542093','BY FIRE BE PURGED!!!!','24532','6','0','YTDB Ragnaros Yell in combat.','0');
  82. -- Text id: -542092
  83. DELETE FROM creature_ai_texts WHERE entry=-542092;
  84. INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  85. ('-542092','Arise, servants of fire, consume their flesh!','24516','6','0','Ragnaros Yell summon Lava Scion.'YTDB Ragnaros'0');
  86. -- Text id: -542091
  87. DELETE FROM creature_ai_texts WHERE entry=-542091;
  88. INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  89. ('-542091','Mortal Insects! You dare trespass into MY domain? Your arrogance will be purged in living flame.','24517','6','0','YTDB Yell Ragnaros Spawn.','1');
  91. INSERT INTO `db_script_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) values('2000009989','It is finished then!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25170','6','0','0','Malfurion say 1');
  92. INSERT INTO `db_script_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) values('2000009990','Heroes, the world owes you a great debt.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25171','6','0','0','Malfurion say 2');
  93. INSERT INTO `db_script_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) values('2000009991','Ragnaros has perished. But the primal powers he represents can never be vanquished. Another will rise to power, someday.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25158','6','0','0','Say Cenarius 1');
  94. INSERT INTO `db_script_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) values('2000009992','Yes Cenarius, we must maintain a constant vigil over this realm. But let us celebrate this day and the great victory we have earned here.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25168','6','0','0','Say Hamuul');
  95. INSERT INTO `db_script_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) values('2000009993','Indeed.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25161','6','0','0','Say Cenarius 2');
  97. -- Creature id: 53473 Blazing Heat.
  98. UPDATE creature_template SET AIName='EventAI' WHERE entry=53473;
  99. DELETE FROM creature_ai_scripts WHERE creature_id=53473;
  100. INSERT INTO creature_ai_scripts VALUES
  101. ('5347301','53473','11','0','100','30','0','0','0','0','2','14','0','0','20','0','0','0','21','0','0','0','YTDB Blazing Heat - Set Faction and Preevent Combat Movement and Auto Attack.'),
  102. ('5347302','53473','11','0','100','30','0','0','0','0','11','99128','0','0','41','45000','0','0','38','0','0','0','YTDB Blazing Heat - Cast Blazing Heat and Force Despawn and Set in Combat at Spawn.');
  104. -- Script id: 99125
  105. DELETE FROM dbscripts_on_spell WHERE id=99125;
  106. INSERT INTO dbscripts_on_spell VALUES
  107. (99125,0,15,99129,0,0,0,0,0,0,0,0,0,0,0,0,'Cast Summon Blazing Heat.');
  109. DELETE FROM `creature_template` WHERE (`entry`=209209);
  110. INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `vehicle_id`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (209209, 0, 0, 0, 0, 0, 1126, 11686, 0, 0, 'Ragnaros Spawn Visual Stalker', '', '', 0, 88, 88, 85892, 85892, 0, 0, 12122, 16, 16, 0, 1, 1.14286, 1, 1, 548, 822, 0, 205, 16.4, 2000, 2000, 1, 33555078, 2048, 0, 0, 0, 0, 0, 0, 438, 658, 164, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'EventAI', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '');
  112. -- Creature id: 209209 Ragnaros Spawn Visual Stalker.
  113. UPDATE creature_template SET AIName='EventAI' WHERE entry=209209;
  114. DELETE FROM creature_ai_scripts WHERE creature_id=209209;
  115. INSERT INTO creature_ai_scripts VALUES
  116. ('20920901','209209','11','0','100','30','0','0','0','0','32','52409','0','214','18','33587268','0','0','22','1','0','0','YTDB Ragnaros Spawn Visual Stalker - Summon Ragnaros and Set Unit Flag and Set Phase 1 at Spawn.'),
  117. ('20920902','209209','26','1','100','31','52409','2000','2000','0','22','2','0','0','0','0','0','0','0','0','0','0','YTDB Ragnaros Spawn Visual Stalker - Set Phase Just Summoned Despawn.'),
  118. ('20920903','209209','1','2','100','31','10000','10000','864000000','864000000','32','52409','0','214','22','1','0','0','0','0','0','0','YTDB Ragnaros Spawn Visual Stalker - Summon Ragnaros and Set Phase 1'),
  119. ('20920904','209209','4','0','100','30','0','0','0','0','20','0','0','0','21','0','0','0','0','0','0','0','YTDB Ragnaros Spawn Visual Stalker - Prevent Combat Movement and Auto Attack.'),
  120. ('20920905','209209','17','0','100','31','52409','2000','2000','0','13','100','6','0','0','0','0','0','0','0','0','0','YTDB Ragnaros Spawn Visual Stalker - Custom Code.'),
  121. ('20920906','209209','25','0','100','31','52409','1000','1000','0','41','0','0','0','0','0','0','0','0','0','0','0','YTDB Ragnaros Spawn Visual Stalker - Force Despawn Just Died Summoned.');
  123. -- 19.09.2013 3:10:55
  124. DELETE FROM `creature_template` WHERE (`entry`=209209);
  125. INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `vehicle_id`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (209209, 0, 0, 0, 0, 0, 1126, 11686, 0, 0, 'Ragnaros Spawn Visual Stalker', '', '', 0, 88, 88, 85892, 85892, 0, 0, 12122, 16, 16, 0, 1, 1.14286, 1, 1, 548, 822, 0, 205, 16.4, 2000, 2000, 1, 33555078, 2048, 0, 0, 0, 0, 0, 0, 438, 658, 164, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'EventAI', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '');
  127. -- Summon id: 209
  128. DELETE FROM creature_ai_summons WHERE id=209;
  129. INSERT INTO creature_ai_summons VALUES
  130. ('209','1026.29','3.88575','55.3648','5.0289','86400000','YTDB Summon Lava Scion 1');
  132. DELETE FROM creature_ai_summons WHERE id=210;
  133. INSERT INTO creature_ai_summons VALUES
  134. ('210','1029.35','-116.686','55.365','1.73709','86400000','YTDB Summon Lava Scion 2');
  136. DELETE FROM creature_ai_summons WHERE id=211;
  137. INSERT INTO creature_ai_summons VALUES
  138. ('211','985.985','-59.3361','55.3615','6.19019','86400000','YTDB Summon Cenarius');
  140. DELETE FROM creature_ai_summons WHERE id=212;
  141. INSERT INTO creature_ai_summons VALUES
  142. ('212','984.317','-70.1411','55.3427','0.229883','86400000','YTDB Summon Malfurion');
  144. DELETE FROM creature_ai_summons WHERE id=213;
  145. INSERT INTO creature_ai_summons VALUES
  146. ('213','980.755','-48.2416','55.3555','0.258008','86400000','YTDB Summon Hamuul');
  148. DELETE FROM creature_ai_summons WHERE id=214;
  149. INSERT INTO creature_ai_summons VALUES
  150. ('214','1075.2','-57.849','55.4243','3.15905','86400000','YTDB Summon Ragnaros in Firelands');
  152. DELETE FROM `creature` WHERE `id`=209209;
  153. INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES
  154. (400027, 209209, 720, 15, 1, 0, 0, 992.763, -57.2345, 55.3543, 0.0275335, 604800, 0, 0, 85892, 0, 0, 0);
  156. -- Creature id: 53231 Lava Scion.
  157. UPDATE creature_template SET AIName='EventAI' WHERE entry=53231;
  158. DELETE FROM creature_ai_scripts WHERE creature_id=53231;
  159. INSERT INTO creature_ai_scripts VALUES
  160. ('5323101','53231','7','0','100','30','0','0','0','0','41','0','0','0','0','0','0','0','0','0','0','0','YTDB Lava Scion - Despawn at Evade.'),
  161. ('5323102','53231','0','0','100','31','2000','2000','20000','20000','11','100460','5','42','0','0','0','0','0','0','0','0','YTDB Lava Scion - Cast Blazing Heat.'),
  162. ('5323103','53231','6','0','100','30','0','0','0','0','41','3000','0','0','0','0','0','0','0','0','0','0','YTDB Lava Scion - Force Despawn.'),
  163. ('5323104','53231','1','0','100','31','2000','2000','2000','2000','38','0','0','0','0','0','0','0','0','0','0','0','YTDB Lava Scion - Set In Combat.');
  165. -- Script id: 52409 Ragnaros Death Heroic Outro Event.
  166. DELETE FROM dbscripts_on_creature_death WHERE id=52409;
  167. INSERT INTO dbscripts_on_creature_death VALUES
  168. (52409,8,0,6,0,53875,50000,4,2000009989,0,0,0,0,0,0,0,'Malfurion say 1'),
  169. (52409,10,0,6,0,53875,50000,4,2000009990,0,0,0,0,0,0,0,'Malfurion say 2'),
  170. (52409,15,0,0,0,53872,50000,4,2000009991,0,0,0,0,0,0,0,'Say Cenarius 1'),
  171. (52409,27,0,0,0,53876,50000,4,2000009992,0,0,0,0,0,0,0,'Say Hamuul'),
  172. (52409,39,0,0,0,53872,50000,4,2000009993,0,0,0,0,0,0,0,'Say Cenarius 1'),
  173. (52409,60,18,0,0,53872,50000,0,0,0,0,0,0,0,0,0,'Despawn Cenarious'),
  174. (52409,60,18,0,0,53875,50000,0,0,0,0,0,0,0,0,0,'Despawn Malfurion'),
  175. (52409,60,18,0,0,53876,50000,0,0,0,0,0,0,0,0,0,'Despawn Hamuul');
  177. INSERT IGNORE INTO `creature_linking_template` (`entry`, `map`, `master_entry`, `flag`, `search_range`) values('52409','720','209209','4099','0');
  179. UPDATE creature_template SET AIName='EventAI' WHERE entry IN (52409,53231,209209,53473,53086,53872,53875,53953,53876);
  180. UPDATE `creature_template` SET `ScriptName` = '' WHERE entry IN (52409,53231,209209,53473,53086,53872,53875,53953,53876);
  182. -- Creature id: 53875 Malfurion in Firelands.
  184. DELETE FROM creature_ai_scripts WHERE creature_id=53875;
  185. INSERT INTO creature_ai_scripts VALUES
  186. ('5387501','53875','11','0','100','30','0','0','0','0','3','0','38533','0','0','0','0','0','0','0','0','0','YTDB Malfurion - Set Model at Spawn.'),
  187. ('5387502','53875','1','0','100','25','21000','21000','86400000','86400000','1','-542096','0','0','0','0','0','0','0','0','0','0','YTDB Malfurion - Say 1'),
  188. ('5387503','53875','10','0','100','25','0','200','25000','25000','11','100714','6','1','0','0','0','0','0','0','0','0','YTDB Malfurion - Cast CloudBurst.');
  190. -- Script id: 100472
  191. DELETE FROM dbscripts_on_spell WHERE id=100472;
  192. INSERT INTO dbscripts_on_spell VALUES
  193. (100472,0,15,100476,0,0,0,0,0,0,0,0,0,0,0,0,'Cast Summon Breadth of Frost.'),
  194. (100472,2,15,100479,0,53953,200,1,0,0,0,0,0,0,0,0,'Cast Trigger Missile on Summoned Breadth of Frost.'),
  195. (100472,0,15,100478,0,53953,200,2,0,0,0,0,0,0,0,0,'Cast Breadth of Frost Trigger.');
  197. -- Script id: 100503
  198. DELETE FROM dbscripts_on_spell WHERE id=100503;
  199. INSERT INTO dbscripts_on_spell VALUES
  200. (100503,0,14,100594,0,0,0,2,0,0,0,0,0,0,0,0,'Remove Super heated Aura.');
  206. -- Creature id: 53953 Breadth of Frost Trigger
  207. DELETE FROM creature_ai_scripts WHERE creature_id=53953;
  208. INSERT INTO creature_ai_scripts VALUES
  209. ('5395301','53953','8','0','100','0','100479','-1','0','0','11','100478','0','32','41','120000','0','0','0','0','0','0','Breadth of Frost Trigger - Cast Breadth of Frost Auras and Force Despawn 2 minutes.');
  211. -- Creature id: 53876 Hamuul Rune Totem
  212. DELETE FROM creature_ai_scripts WHERE creature_id=53876;
  213. INSERT INTO creature_ai_scripts VALUES
  214. ('5387601','53876','11','0','100','30','0','0','0','0','2','35','1','0','3','0','38534','0','21','0','0','0','YTDB Hamuul Rune Totem - Set Faction 35 and Set Display and Preevent Movement.'),
  215. ('5387602','53876','23','0','100','31','100593','1','5000','5000','13','100','7','0','0','0','0','0','0','0','0','0','YTDB Hamuul Rune Totem -Custom Code.'),
  216. ('5387603','53876','10','0','100','31','0','200','25000','25000','11','100646','6','1','0','0','0','0','0','0','0','0','YTDB Hamuul Rune Totem - Cast Entrapping Roots OOC LOS 200'),
  217. ('5387604','53876','11','0','100','30','0','0','0','0','13','100','6','0','18','32966','0','0','20','0','0','0','YTDB Hamuul Rune Totem - Custom Code.');
  219. -- Creature id: 52409 Ragnaros in Firelands.
  220. -- Creature id: 52409
  221. UPDATE creature_template SET AIName='EventAI' WHERE entry=52409;
  222. DELETE FROM creature_ai_scripts WHERE creature_id=52409;
  223. INSERT INTO creature_ai_scripts VALUES
  224. ('5240901','52409','4','0','100','30','0','0','0','0','21','0','0','0','20','0','0','0','1','-542095','0','0','YTDB Ragnaros - Heroic Start on Aggro.'),
  225. ('5240902','52409','4','0','100','30','0','0','0','0','32','53872','0','211','32','53875','0','212','32','53876','0','213','YTDB Ragnaros - Summon Cenarius, Malfurion and Hamuul.'),
  226. ('5240903','52409','4','0','100','30','0','0','0','0','11','100312','0','2','0','0','0','0','22','1','0','0','YTDB Ragnaros - Cast Emerge and Set Phase 1.'),
  227. ('5240904','52409','0','1','100','30','10000','10000','0','0','1','-542102','0','0','0','0','0','0','28','0','100312','0','YTDB Ragnaros - Say Emerge and Remove Aura Submerge legs.'),
  228. ('5240905','52409','0','1','100','30','15000','15000','0','0','1','-542101','0','0','17','78','402','0','17','68','0','0','YTDB Ragnaros - Say Outside and Unit Field Remove hover and Set Unit Field Play Emote State Custom Spell_02(See Shared Defines.h)'),
  229. ('5240906','52409','0','1','100','30','22000','22000','0','0','0','0','0','0','21','1','1','0','20','1','0','0','YTDB Ragnaros - Clear Emote State and Start Auto Attack and Combat Movement true.'),
  230. ('5240907','52409','0','0','100','30','23000','23000','0','0','11','100593','0','0','0','0','0','0','0','0','0','0','YTDB Ragnaros - Cast Superheated.'),
  231. ('5240908','52409','0','0','100','31','40000','40000','40000','40000','11','100675','0','0','0','0','0','0','0','0','0','0','YTDB Ragnaros - Cast DreadFlame.'),
  232. ('5240909','52409','0','0','100','31','56000','60000','56000','60000','11','100604','0','1','0','0','0','0','0','0','0','0','YTDB Ragnaros - Cast Empowered Sulfuras.'),
  233. ('5240910','52409','6','0','100','30','0','0','0','0','1','-542100','0','0','0','0','0','0','0','0','0','0','YTDB - Yell at Death.');

Рагнарос.