YTDB - Показать сообщение отдельно

Ulduar · 29.01.2014, 22:32

Попробовал я его реализовать на EAI. Кое-что получилось, но:
1)EVENT_T_HP как-то странно работает с этим боссом(например при реализации Аркуриона он нормально переходил на 2 фазу при диапазоне хп), а здесь отказывается. И так и сяк пробовал(документацию разумеется всю прочитал). Что же в итоге было сделано.
а)Тексты, 4 фаза реализована(анимация вылезания из лавы подкачала что-то, за это отвечает EmoteState и AnimKit). Суммон Кенария, Малфуриона и Хамуула.
б)Деспавн и resummon Рагнароса(создан нпц с номером 209209 и заспавнен уже).
в)Эпилог(диалог Малфуриона, Хамуула и Кенария между собой и их деспавн)
г)Некоторые нпц.

Код:

Код:

INSERT IGNORE INTO `spell_script_target` (`entry`, `type`, `targetEntry`, `inverseEffectMask`) values('100472','1','52409','0');
INSERT IGNORE INTO `spell_script_target` (`entry`, `type`, `targetEntry`, `inverseEffectMask`) values('100567','1','53500','0');
-- Creature id: 53872 Cenarious Firelands.
UPDATE creature_template SET AIName='EventAI' WHERE entry=53872;
DELETE FROM creature_ai_scripts WHERE creature_id=53872;
INSERT INTO creature_ai_scripts VALUES 
('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.'),
('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.');

DELETE FROM `creature_template_addon` WHERE (`entry`=52409);
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, '');

-- Creature id: 53086 Magma Trap.
UPDATE creature_template SET AIName='EventAI' WHERE entry=53086;
DELETE FROM creature_ai_scripts WHERE creature_id=53086;
INSERT INTO creature_ai_scripts VALUES 
('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.'),
('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.'),
('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.'),
('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.');

 -- Text id: -542107
 DELETE FROM creature_ai_texts WHERE entry=-542107;
 INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES 
 ('-542107','Sulfuras will be your end.','24525','6','0','YTDB Yell Sulfuras.','0');
 -- Text id: -542106
 DELETE FROM creature_ai_texts WHERE entry=-542106;
 INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES 
 ('-542106','Die, insect!','24531','6','0','YTDB Ragnaros Slay 3','0');
 -- Text id: -542105
 DELETE FROM creature_ai_texts WHERE entry=-542105;
 INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES 
 ('-542105','Pathetic.','24530','6','0','YTDB Ragnaros Slay 2','0');
 -- Text id: -542104
 DELETE FROM creature_ai_texts WHERE entry=-542104;
 INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES 
 ('-542104','This is MY realm!','24529','6','0','YTDB Ragnaros Slay 1','0');
 -- Text id: -542103
 DELETE FROM creature_ai_texts WHERE entry=-542103;
 INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES 
 ('-542103','Enough! I will finish this.','24523','6','0','YTDB Ragnaros Yell in Phase 2','0');
 -- Text id: -542102
 DELETE FROM creature_ai_texts WHERE entry=-542102;
 INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES 
 ('-542102','Arrggh, outsiders - this is not your realm!','24527','6','0','YTDB Ragnaros Yell in Phase 4','0');
 -- Text id: -542101
 DELETE FROM creature_ai_texts WHERE entry=-542101;
 INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES 
 ('-542101','When I finish this, your pathetic mortal world will burn with my vengeance!','24526','6','0','YTDB Ragnaros Yell in Phase 4','0');
 -- Text id: -542100
 DELETE FROM creature_ai_texts WHERE entry=-542100;
 INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES 
 ('-542100','No, noooo- This was to be my hour of triumph...','24518','6','0','YTDB Ragnaros Yell just death(heroic only)','0');
 -- Text id: -542099
 DELETE FROM creature_ai_texts WHERE entry=-542099;
 INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES 
 ('-542099','Be consumed by flame!','24535','6','0','YTDB Ragnaros Yell Agrro 2','0');
 -- Text id: -542098
 DELETE FROM creature_ai_texts WHERE entry=-542098;
 INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES 
 ('-542098','I will see you all burn.','24534','6','0','YTDB Ragnaros Aggro 1','0');
 -- Text id: -542097
 DELETE FROM creature_ai_texts WHERE entry=-542097;
 INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES 
 ('-542097','No, fiend. Your time is NOW.','25159','6','0','YTDB Cenarius Yell in Phase 4','0');
 -- Text id: -542096
 DELETE FROM creature_ai_texts WHERE entry=-542096;
 INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES 
 ('-542096','Heroes! He is bound. Finish him!','25169','6','0','YTDB Malfurion Yell in Set Phase 4','0');
 -- Text id: -542095
 DELETE FROM creature_ai_texts WHERE entry=-542095;
 INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES 
 ('-542095','Too soon...','24528','6','0','YTDB Ragnaros Set Phase 4','0');
 -- Text id: -542094
 DELETE FROM creature_ai_texts WHERE entry=-542094;
 INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES 
 ('-542094','Too soon! ... You have come too soon...','24519','6','0','YTDB Ragnaros combat stop in normal','0');
 -- Text id: -542093
 DELETE FROM creature_ai_texts WHERE entry=-542093;
 INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES 
 ('-542093','BY FIRE BE PURGED!!!!','24532','6','0','YTDB Ragnaros Yell in combat.','0');
 -- Text id: -542092
 DELETE FROM creature_ai_texts WHERE entry=-542092;
 INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES 
 ('-542092','Arise, servants of fire, consume their flesh!','24516','6','0','Ragnaros Yell summon Lava Scion.'YTDB Ragnaros'0');
 -- Text id: -542091
 DELETE FROM creature_ai_texts WHERE entry=-542091;
 INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES 
 ('-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');
 
 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');
 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');
 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');
 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');
 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');
 
 -- Creature id: 53473 Blazing Heat.
UPDATE creature_template SET AIName='EventAI' WHERE entry=53473;
DELETE FROM creature_ai_scripts WHERE creature_id=53473;
INSERT INTO creature_ai_scripts VALUES 
('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.'),
('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.');

-- Script id: 99125
DELETE FROM dbscripts_on_spell WHERE id=99125;
INSERT INTO dbscripts_on_spell VALUES 
(99125,0,15,99129,0,0,0,0,0,0,0,0,0,0,0,0,'Cast Summon Blazing Heat.');

DELETE FROM `creature_template` WHERE (`entry`=209209);
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, '');

-- Creature id: 209209 Ragnaros Spawn Visual Stalker.
UPDATE creature_template SET AIName='EventAI' WHERE entry=209209;
DELETE FROM creature_ai_scripts WHERE creature_id=209209;
INSERT INTO creature_ai_scripts VALUES 
('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.'),
('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.'),
('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'),
('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.'),
('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.'),
('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.');

-- 19.09.2013 3:10:55
 DELETE FROM `creature_template` WHERE (`entry`=209209);
 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, '');
 
 -- Summon id: 209
 DELETE FROM creature_ai_summons WHERE id=209;
 INSERT INTO creature_ai_summons VALUES 
 ('209','1026.29','3.88575','55.3648','5.0289','86400000','YTDB Summon Lava Scion 1');
 
 DELETE FROM creature_ai_summons WHERE id=210;
 INSERT INTO creature_ai_summons VALUES 
 ('210','1029.35','-116.686','55.365','1.73709','86400000','YTDB Summon Lava Scion 2');
 
 DELETE FROM creature_ai_summons WHERE id=211;
 INSERT INTO creature_ai_summons VALUES 
 ('211','985.985','-59.3361','55.3615','6.19019','86400000','YTDB Summon Cenarius');
 
 DELETE FROM creature_ai_summons WHERE id=212;
 INSERT INTO creature_ai_summons VALUES 
 ('212','984.317','-70.1411','55.3427','0.229883','86400000','YTDB Summon Malfurion');
 
 DELETE FROM creature_ai_summons WHERE id=213;
 INSERT INTO creature_ai_summons VALUES 
 ('213','980.755','-48.2416','55.3555','0.258008','86400000','YTDB Summon Hamuul');
 
 DELETE FROM creature_ai_summons WHERE id=214;
 INSERT INTO creature_ai_summons VALUES 
 ('214','1075.2','-57.849','55.4243','3.15905','86400000','YTDB Summon Ragnaros in Firelands');
 
 DELETE FROM `creature` WHERE `id`=209209;
 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
 (400027, 209209, 720, 15, 1, 0, 0, 992.763, -57.2345, 55.3543, 0.0275335, 604800, 0, 0, 85892, 0, 0, 0);
 
 -- Creature id: 53231 Lava Scion.
UPDATE creature_template SET AIName='EventAI' WHERE entry=53231;
DELETE FROM creature_ai_scripts WHERE creature_id=53231;
INSERT INTO creature_ai_scripts VALUES 
('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.'),
('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.'),
('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.'),
('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.');

-- Script id: 52409 Ragnaros Death Heroic Outro Event.
 DELETE FROM dbscripts_on_creature_death WHERE id=52409;
 INSERT INTO dbscripts_on_creature_death VALUES 
 (52409,8,0,6,0,53875,50000,4,2000009989,0,0,0,0,0,0,0,'Malfurion say 1'),
 (52409,10,0,6,0,53875,50000,4,2000009990,0,0,0,0,0,0,0,'Malfurion say 2'),
 (52409,15,0,0,0,53872,50000,4,2000009991,0,0,0,0,0,0,0,'Say Cenarius 1'),
 (52409,27,0,0,0,53876,50000,4,2000009992,0,0,0,0,0,0,0,'Say Hamuul'),
 (52409,39,0,0,0,53872,50000,4,2000009993,0,0,0,0,0,0,0,'Say Cenarius 1'),
 (52409,60,18,0,0,53872,50000,0,0,0,0,0,0,0,0,0,'Despawn Cenarious'),
 (52409,60,18,0,0,53875,50000,0,0,0,0,0,0,0,0,0,'Despawn Malfurion'),
 (52409,60,18,0,0,53876,50000,0,0,0,0,0,0,0,0,0,'Despawn Hamuul');
 
 INSERT IGNORE INTO `creature_linking_template` (`entry`, `map`, `master_entry`, `flag`, `search_range`) values
('52409','720','209209','4099','0'),
('53872','720','209209','4099','0'),
('53875','720','209209','4099','0'),
('53876','720','209209','4099','0'),
 
 UPDATE creature_template SET AIName='EventAI' WHERE entry IN (52409,53231,209209,53473,53086,53872,53875,53953,53876);
 UPDATE `creature_template` SET `ScriptName` = '' WHERE entry IN (52409,53231,209209,53473,53086,53872,53875,53953,53876);
 
 -- Creature id: 53875 Malfurion in Firelands.

DELETE FROM creature_ai_scripts WHERE creature_id=53875;
INSERT INTO creature_ai_scripts VALUES 
('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.'),
('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'),
('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.');

-- Script id: 100472
DELETE FROM dbscripts_on_spell WHERE id=100472;
INSERT INTO dbscripts_on_spell VALUES 
(100472,0,15,100476,0,0,0,0,0,0,0,0,0,0,0,0,'Cast Summon Breadth of Frost.'),
(100472,2,15,100479,0,53953,200,1,0,0,0,0,0,0,0,0,'Cast Trigger Missile on Summoned Breadth of Frost.'),
(100472,0,15,100478,0,53953,200,2,0,0,0,0,0,0,0,0,'Cast Breadth of Frost Trigger.');

-- Script id: 100503
DELETE FROM dbscripts_on_spell WHERE id=100503;
INSERT INTO dbscripts_on_spell VALUES 
(100503,0,14,100594,0,0,0,2,0,0,0,0,0,0,0,0,'Remove Super heated Aura.');





-- Creature id: 53953 Breadth of Frost Trigger
DELETE FROM creature_ai_scripts WHERE creature_id=53953;
INSERT INTO creature_ai_scripts VALUES 
('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.');

-- Creature id: 53876  Hamuul Rune Totem
DELETE FROM creature_ai_scripts WHERE creature_id=53876;
INSERT INTO creature_ai_scripts VALUES 
('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.'),
('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.'),
('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'),
('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.');

-- Creature id: 52409 Ragnaros in Firelands.
-- Creature id: 52409
UPDATE creature_template SET AIName='EventAI' WHERE entry=52409;
DELETE FROM creature_ai_scripts WHERE creature_id=52409;
INSERT INTO creature_ai_scripts VALUES 
('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.'),
('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.'),
('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.'),
('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.'),
('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)'),
('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.'),
('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.'),
('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.'),
('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.'),
('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.');

Ссылочка на Paste2. На всякий случай. http://paste2.org/1VhXMJZg
Писать иссуи ядерщикам бесполезно, они там Классикой занимаются(Ваниллой всмысле ну и БК)
Вообще его надо конечно же реализовывать на стороне SD2 side. Спеллы чинить в ядре нужно(чинить там достаточно) Если кто реализует лучше, будет отлично!