Показать сообщение отдельно
Старый 01.10.2014, 05:16   #15
Ulduar
Ученый
 
Регистрация: 23.11.2012
Сообщений: 196
Сказал(а) спасибо: 69
Поблагодарили 16 раз(а) в 16 сообщениях
Ulduar На верном пути
По умолчанию

Код:




DELETE FROM  `conditions` WHERE `condition_entry` = 8000;
INSERT INTO  `conditions` (`condition_entry`, `type`, `value1`, `value2`) VALUES('8000','9','25551','0');
DELETE FROM  `gossip_menu` WHERE `entry` = 11434;
INSERT INTO  `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES('11434','15931','0','8000');
DELETE FROM  `gossip_menu_option` WHERE `menu_id` = 11434;
INSERT INTO  `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `condition_id`) VALUES
('11434','0','0','I am ready to begin the battle against Ragnaros.','0','1','11434','0','0','0','0','','8000'),
('11434','1','0','I am ready to begin the battle against Ragnaros.','1','1','-1','0','11434','0','0','Start Event?','8000');

DELETE FROM `creature` WHERE `id`=40793;
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
(300787, 40793, 1, 1, 1, 31188, 0, 4027.45, -3054.09, 569.141, 1.97222, 300, 0, 0, 22339500, 0, 0, 0);

UPDATE `creature_template` SET `GossipMenuId`= 11434  WHERE `Entry`= 40803;
-- Script id: 40803
DELETE FROM dbscripts_on_creature_death WHERE id=40803;
INSERT INTO dbscripts_on_creature_death VALUES 
(40803,0,0,1,0,40793,50,4,2000006672,0,0,0,0,0,0,0,'Say Cenarius Defeat.'),
(40803,3,28,9,0,40793,50,4,0,0,0,0,0,0,0,0,'Submerge in Lava.'),
(40803,7,18,0,0,40793,500,4,0,0,0,0,0,0,0,0,'Force Despawn Ragnaros.'),
(40803,0,18,0,0,41630,500,1,0,0,0,0,0,0,0,0,'Despawn Hamuul.'),
(40803,0,18,0,0,41632,500,1,0,0,0,0,0,0,0,0,'Despawn Malfurion.'),
(40803,7,18,0,0,0,0,0,0,0,0,0,0,0,0,0,'Force Despawn Cenarius.');

DELETE FROM `db_script_string` WHERE `entry` IN (2000006660, 2000006661, 2000006662, 2000006663, 2000006664, 2000006665, 2000006666, 2000006667, 2000006668, 2000006669, 2000006670, 2000006671, 2000006672);
INSERT INTO `db_script_string` (`entry`, `content_default`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
('2000006660','Once Hamuul and Malfurion arrive, we shall begin...','Как только прибудут Малфурион и Хамуул, мы начнём.','0','0','0','0','Cenarius - Say Prepare.'),
('2000006661','We are ready, Cenarius.','Мы готовы, Кенарий.','20805','0','0','0','Malfurion - Say Arrive.'),
('2000006662','We shall face the Firelord and drive every ember of his being out of our realm!','Мы сразимся с Повелителем Огня и навсегда задуем его пламя!\r\n','21639','0','0','0','Cenarius - Say Prepare 2.'),
('2000006663','I shall call upon the chilling mountain wings to protect us from Ragnaros\' flame. Malfurion and Hamuul will shatter the Firelord\'s defenses, allowing us to force him back.','Я призову ледяные горные ветра, чтобы они защитили нас от пламени Рагнароса. Малфурион и Хамуул разобьют защиту Повелителя Огня и  позволят нам оттеснить его.','21641','0','0','0','Cenarius - Say Prepare 3.'),
('2000006664','Let us begin. It is only a matter of time before the Firelord becomes aware of our presence and comes to the spire\'s defense.','Начнём. Скоро Повелитель Огня поймёт, что мы здесь и выйдет на защиту шпиля.','21642','0','0','0','Cenarius - Start Event.'),
('2000006665','Quickly, everyone move into position! Force him back into the Firelands!','Быстро, занять позицию! Оттеснить его на Огненные Просторы!','21640','1','0','0','Cenarius - Say Prepare Fight Ragnaros.'),
('2000006666','WHO DARES TO DEFILE THE HALLS OF LIVING FLAME? I SHALL SEAR YOUR ESSENCE FROM YOUR FLESH!','Кто посмел осквернить залы живого жара? Я выжгу души из ваших тел!','22574','1','0','0','Ragnaros - Say Arrive.'),
('2000006667','FACE ME, INSECTS. I SHALL CRUSH YOU FIRSTHAND!','ВЗГЛЯНИТЕ НА МЕНЯ, МОКРИЦЫ! СЕЙЧАС Я РАЗДАВЛЮ ВАС!','22575','1','0','0','Ragnaros - Say Prefight.'),
('2000006668','It took all of our combined strength, but we have pushed Ragnaros back into the Firelands.','Пришлось собрать все силы, но мы отбросили Рагнароса назад на Огненные Просторы!','21643','1','0','0','Cenarius - Say Outro Event.'),
('2000006669','We must not let down our guard. It\'s only a matter of time before he regains his strength and returns to turn Nordrassil into ash.','Мы не должны терять бдительность. Через некоторое время он окрепнет и вернётся, чтобы обратить Нордрассил в пепел.','20807','1','0','0','Malfurion - Say Outro Event 1.'),
('2000006670','We must confer with the leaders of the Horde and the Alliance. Ragnaros must be defeated in his home realm. Only then will he forever be vanquished.','Нужно собрать для совета всех лидеров Орды и Альянса. Рагнароса надо уничтожить в его царстве. Лишь тогда он будет окончательно повержен.','20766','1','0','0','Hamuul - Say Outro Event.'),
('2000006671','Let us leave this place for now. We must return to the surface and restore the damage our enemies have caused.','Уйдём отсюда на время. Вернёмся на Хиджал и приведём в порядок то, что разрушил враг.','21644','1','0','0','Cenarius - Say Leave Spire.'),
('2000006672','YOUR DEFEAT TODAY HERALDS END OF THIS WORLD! MY CHILDREN WELCOME A NEW ERA, AN ERA OF FLAME!','ВАШЕ СЕГОДНЯШНЕЕ ПОРАЖЕНИЕ ВОЗВЕЩАЕТ КОНЕЦ ЭТОГО МИРА! МОИ ДЕТИ ПРИВЕТСТВУЮТ НАСТУПЛЕНИЕ НОВОЙ ЭРЫ, ЭРЫ ПЛАМЕНИ!','22580','1','0','0','Ragnaros - Say Defeat Cenarius and Fail Quest.');

UPDATE `creature_template` SET `AIName` = 'EventAI', `MovementType` = 0, `ScriptName` = '' WHERE `entry` = 41632;
UPDATE `creature_template` SET `AIName` = 'EventAI', `MovementType` = 0, `ScriptName` = '' WHERE `entry` = 41630;
UPDATE `creature_template` SET `AIName` = 'EventAI', `MovementType` = 0, `ScriptName` = '' WHERE `entry` = 40803;
UPDATE `creature_template` SET `AIName` = 'EventAI', `MovementType` = 0, `ScriptName` = '' WHERE `entry` = 40793;


DELETE FROM `creature` WHERE (`guid`=305566);
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 (305566, 41632, 1, 1, 1, 35095, 0, 3942.41, -2810.67, 618.83, 5.02655, 300, 0, 0, 7437400, 4081000, 0, 2);

DELETE FROM `creature` WHERE (`guid`=305567);
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 (305567, 41630, 1, 1, 1, 31605, 0, 3946.48, -2808.44, 618.83, 5.18363, 300, 0, 0, 7437400, 8162, 0, 2);

DELETE FROM `creature` WHERE (`guid`=300786);
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 (300786, 40803, 1, 1, 1, 0, 0, 3954.5, -2825.82, 618.83, 5.02655, 300, 0, 0, 12286725, 0, 0, 2);


DELETE FROM `creature_movement_template` WHERE `entry` IN (41630, 41632, 40803, 40793);
INSERT INTO `creature_movement_template` (`entry`,`point`,`position_x`,`position_y`,`position_z`,`waittime`,`script_id`,`textid1`,`textid2`,`textid3`,`textid4`,`textid5`,`emote`,`spell`,`wpguid`,`orientation`,`model1`,`model2`) VALUES
(40803, 1, 3955.85, -2834.27, 618.746, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.02973, 0, 0),
(40803, 2, 3959.32, -2843.48, 616.37, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.07293, 0, 0),
(40803, 3, 3963.63, -2854.92, 614.63, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.07293, 0, 0),
(40803, 4, 3968.98, -2869.09, 612.226, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.07293, 0, 0),
(40803, 5, 3972.82, -2879.55, 609.792, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.06507, 0, 0),
(40803, 6, 3978.33, -2891.4, 606.079, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.16325, 0, 0),
(40803, 7, 3982.87, -2900.41, 602.986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.17895, 0, 0),
(40803, 8, 3985.76, -2908.76, 600.611, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.05722, 0, 0),
(40803, 9, 3989.09, -2917.6, 599.206, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.05722, 0, 0),
(40803, 10, 3991.6, -2927.44, 595.904, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.02187, 0, 0),
(40803, 11, 3994.41, -2939.58, 591.177, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.92763, 0, 0),
(40803, 12, 3995.85, -2945.96, 588.074, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.93548, 0, 0),
(40803, 13, 3997.76, -2956.27, 582.992, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.93155, 0, 0),
(40803, 14, 4001.55, -2970.74, 579.227, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.03365, 0, 0),
(40803, 15, 4008.59, -2987.86, 575.384, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.13183, 0, 0),
(40803, 16, 4015.17, -3010.13, 575.388, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.9826, 0, 0),
(40803, 17, 4021.37, -3032.07, 575.19, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.99046, 0, 0),
(40803, 18, 4015.48, -3021.24, 575.391, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.02951, 0, 0),
(41630, 1, 3948.99, -2810.17, 618.748, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.9193, 0, 0),
(41630, 2, 3960.03, -2831.38, 618.748, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.14518, 0, 0),
(41630, 3, 3967.08, -2844.05, 615.557, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.225, 0, 0),
(41630, 4, 3974.81, -2864.06, 612.444, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.955, 0, 0),
(41630, 5, 3979.62, -2878.42, 610.1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.18112, 0, 0),
(41630, 6, 3989.99, -2886.55, 607.495, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.16762, 0, 0),
(41630, 7, 3995.22, -2897.24, 603.815, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.16762, 0, 0),
(41630, 8, 4001.65, -2920.59, 597.846, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.06804, 0, 0),
(41630, 9, 4005.86, -2933.73, 593.688, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.97133, 0, 0),
(41630, 10, 4010.18, -2948.32, 587.259, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.0106, 0, 0),
(41630, 11, 4015.19, -2960.56, 581.978, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.99422, 0, 0),
(41630, 12, 4023.07, -2990, 575.341, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.52136, 0, 0),
(41630, 13, 4043.6, -3001.81, 575.389, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.82511, 0, 0),
(41630, 14, 4057.68, -3005.16, 575.287, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.84198, 0, 0),
(41630, 15, 4070.44, -3015.17, 578.465, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.55961, 0, 0),
(41630, 16, 4084.14, -3027.78, 580.866, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.16923, 0, 0),
(41630, 17, 4093.99, -3049.47, 582.539, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3.4896, 0, 0),
(41630, 18, 4093.99, -3049.47, 582.539, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3.4896, 0, 0),
(41632, 1, 3939.96, -2815.03, 618.748, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.22161, 0, 0),
(41632, 2, 3946.06, -2836.88, 618.621, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.11481, 0, 0),
(41632, 3, 3949.12, -2846.36, 616.284, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.9386, 0, 0),
(41632, 4, 3951.41, -2856.29, 615.196, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.9386, 0, 0),
(41632, 5, 3953.03, -2863.35, 614.066, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.9386, 0, 0),
(41632, 6, 3956.02, -2871.72, 612.489, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.0556, 0, 0),
(41632, 7, 3957.86, -2876.86, 611.337, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.0556, 0, 0),
(41632, 8, 3960.31, -2883.72, 609.923, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.0556, 0, 0),
(41632, 9, 3962.55, -2890.31, 608.789, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.03877, 0, 0),
(41632, 10, 3970.17, -2906.9, 603.055, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.61548, 0, 0),
(41632, 11, 3978.54, -2919.69, 599.838, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.95398, 0, 0),
(41632, 12, 3981, -2927.07, 598.03, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.02859, 0, 0),
(41632, 13, 3981.99, -2933.21, 596.023, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.87151, 0, 0),
(41632, 14, 3984.08, -2941.25, 593.044, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.0011, 0, 0),
(41632, 15, 3985.44, -2949.28, 589.381, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.87936, 0, 0),
(41632, 16, 3986.66, -2956.04, 586.215, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.91471, 0, 0),
(41632, 17, 3987.67, -2964.84, 582.634, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.73407, 0, 0),
(41632, 18, 3989.17, -2974.28, 580.353, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.02074, 0, 0),
(41632, 19, 3995.25, -2993.88, 575.32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.01288, 0, 0),
(41632, 20, 3988.09, -3012.17, 575.35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.17251, 0, 0),
(41632, 21, 3976.29, -3030.89, 575.243, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.32566, 0, 0),
(41632, 22, 3972.41, -3042.8, 577.451, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.47095, 0, 0),
(41632, 23, 3970.49, -3055.26, 579.701, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.71442, 0, 0),
(41632, 24, 3970.52, -3068.41, 580.999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.82045, 0, 0),
(41632, 25, 3974.62, -3088.53, 582.539, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.622498, 0, 0),
(41632, 26, 3974.62, -3088.53, 582.539, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.622498, 0, 0),
(40793, 1,  4027.45, -3054.09, 569.141, 0, 0, 0, 0 ,0, 0, 0, 0, 0, 0, 1.97222, 0, 0);




-- Script id: 4163001
DELETE FROM dbscripts_on_creature_movement WHERE id=4163001;
INSERT INTO dbscripts_on_creature_movement VALUES 
(4163001,0,32,1,0,0,0,0,0,0,0,0,0,0,0,0,'Set Pause Waypoint Cenarius, Hamuul and Malfurion (Need, because all times waypoint reached)'),
(4163001,0,21,1,0,0,0,0,0,0,0,0,0,0,0,0,'Set Active Object State.');


-- Creature id: 41630
UPDATE creature_template SET AIName='EventAI' WHERE entry=41630;
DELETE FROM creature_ai_scripts WHERE creature_id=41630;
INSERT INTO creature_ai_scripts VALUES 
('4163001','41630','11','0','100','0','0','0','0','0','11','8203','0','2','21','0','0','0','0','0','0','0','Hamuul - Cast Visibility Off(No fact, what hack) and Combat Movement.'),
('4163002','41630','30','0','100','1','5','40793','0','0','11','76233','10','32','0','0','0','0','0','0','0','0','Hamuul - Cast Earth Rage on Receive AI Event.'),
('4163003','41630','30','0','100','1','6','40803','0','0','41','0','0','0','0','0','0','0','0','0','0','0','Hamuul - Force Despawn on Receive AI Event_B.');




-- Creature id: 41632
UPDATE creature_template SET AIName='EventAI' WHERE entry=41632;
DELETE FROM creature_ai_scripts WHERE creature_id=41632;
INSERT INTO creature_ai_scripts VALUES 
('4163201','41632','11','0','100','0','0','0','0','0','11','8203','0','2','21','0','0','0','0','0','0','0','Malfurion - Cast Visibility Off(No fact, what hack) and Preevent Combat Movement.'),
('4163202','41632','30','0','100','1','5','40793','0','0','11','76232','10','32','0','0','0','0','0','0','0','0','Malfurion - Cast Stormrage on Receive AI Event.'),
('4163203','41632','30','0','100','1','6','40803','0','0','41','0','0','0','0','0','0','0','0','0','0','0','Malfurion - Force Despawn on Receive_AI_Event_B.');




UPDATE `creature_template` SET `UnitFlags` = 33282, `AIName` = 'EventAI', `ScriptName` = '' WHERE `entry` = 40793;


-- Creature id: 40793
UPDATE creature_template SET AIName='EventAI' WHERE entry=40793;
DELETE FROM creature_ai_scripts WHERE creature_id=40793;
INSERT INTO creature_ai_scripts VALUES 
('4079301','40793','2','0','100','1','2','1','0','0','18','33555398','0','0','24','0','0','0','0','0','0','0','Ragnaros - Enter Evade Mode and Unit Flag on 2=1 health percent.'),
('4079302','40793','11','0','100','0','0','0','0','0','11','56512','0','0','21','0','0','0','42','1','1','0','Ragnaros - Cast Submerged on Spawn and Set No_Movement and Void Damage Taken = 0 at 1 Percent Health(No hack)'),
('4079303','40793','0','0','100','1','1000','1000','5000','5000','45','5','533','0','0','0','0','0','0','0','0','0','Ragnaros - Send AI Event Cenarius, Hamuul and Malfurion(from casts channeling spells)'),
('4079304','40793','0','0','100','1','60000','60000','120000','120000','1','-1709','-1710','0','0','0','0','0','0','0','0','0','Random Yell(path, need submerge and summon 2/3 lava waves and summoned lava should start movement different point)'),
('4079305','40793','2','0','100','0','2','1','500','500','48','2','0','0','1','-1713','0','0','47','9','0','0','Ragnaros - Change Movement(need, because EventAI not have ACTION_PAUSE_WAYPOINT) and Yell and Stand State.'),
('4079306','40793','2','0','100','1','2','1','500','500','33','40793','7','0','0','0','0','0','0','0','0','0','Ragnaros - kill credit.');





DELETE FROM `creature_template_addon` WHERE (`entry`=40793);
INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `b2_0_sheath`, `b2_1_pvp_state`, `emote`, `moveflags`, `auras`) VALUES (40793, 0, 0, 1, 0, 0, 0, '');

DELETE FROM `creature_addon` WHERE (`guid`=300787);

DELETE FROM `creature` WHERE `id`=40793;
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
(300787, 40793, 1, 1, 1, 31188, 0, 4027.45, -3054.09, 569.141, 1.97222, 300, 0, 0, 22339500, 0, 0, 0);

-- Script id: 11434
DELETE FROM dbscripts_on_gossip WHERE id=11434;
INSERT INTO dbscripts_on_gossip VALUES 
(11434,0,29,1,2,40803,100,0,0,0,0,0,0,0,0,0,'Cenarius - Remove gossip npc_flag'),
(11434,0,25,1,0,40803,100,0,0,0,0,0,0,0,0,0,'Cenarius - Set Run = true.'),
(11434,0,0,0,0,40803,100,0,2000006660,0,0,0,0,0,0,0,'Cenarius - Say Prepare 1.'),
(11434,8,14,8203,0,41630,100,4,0,0,0,0,0,0,0,0,'Cenarius - Visibility On from Hamuul'),
(11434,8,14,8203,0,41632,100,4,0,0,0,0,0,0,0,0,'Cenarius - Visibility On from Malfurion'),
(11434,14,0,0,0,41632,1000,4,2000006661,0,0,0,0,0,0,0,'Malfurion - Say Arrive.'),
(11434,16,0,1,0,40803,1000,4,2000006662,0,0,0,0,0,0,0,'Cenarius - Say Prepare 2.'),
(11434,25,0,1,0,40803,1000,4,2000006663,0,0,0,0,0,0,0,'Cenarius - Say Prepare 3.'),
(11434,42,0,1,0,40803,1000,4,2000006664,0,0,0,0,0,0,0,'Cenarius - Say Prepare 3.'),
(11434,53,25,1,0,40803,1000,0,0,0,0,0,0,0,0,0,'Cenarius - Set Run = true.'),
(11434,53,25,1,0,41630,1000,0,0,0,0,0,0,0,0,0,'Hamuul - Set Run = true.'),
(11434,53,25,1,0,41632,1000,0,0,0,0,0,0,0,0,0,'Malfurion - Set run = true.'),
(11434,53,32,0,0,40803,1000,4,0,0,0,0,0,0,0,0,'Cenarius - Set unpause waypoint.'),
(11434,53,32,0,0,41630,1000,4,0,0,0,0,0,0,0,0,'Malfurion - Set unpause waypoint.'),
(11434,53,32,0,0,41632,1000,4,0,0,0,0,0,0,0,0,'Hamuul - Set unpause waypoint.');

REPLACE INTO `spell_script_target` (`entry`, `type`, `targetEntry`, `inverseEffectMask`) VALUES('76253','1','40793','0');

-- Script id: 4163002
DELETE FROM dbscripts_on_creature_movement WHERE id=4163002;
INSERT INTO dbscripts_on_creature_movement VALUES 
(4163002,3,14,56512,0,40793,1000,4,0,0,0,0,0,0,0,0,'Ragnaros - Remove Submerge State Aura.'),
(4163002,3,0,1,0,40793,1000,4,2000006666,0,0,0,0,0,0,0,'Ragnaros - Say Arrive.'),
(4163002,0,32,1,0,0,0,0,0,0,0,0,0,0,0,0,'Cenarius - Pause Waypoint.'),
(4163002,15,0,1,0,0,0,0,2000006665,0,0,0,0,0,0,0,'Cenarius - Say Prefight Ragnaros.'),
(4163002,0,2,53,32836,0,0,0,0,0,0,0,0,0,0,0,'Cenarius - Set Unit_FIags.'),
(4163002,0,2,53,32836,41630,1000,4,0,0,0,0,0,0,0,0,'Hamuul - Set Unit_FIags.'),
(4163002,0,2,53,32836,41632,1000,4,0,0,0,0,0,0,0,0,'Malfurion - Set Unit_FIags.'),
(4163002,23,0,1,0,40793,1000,4,2000006667,0,0,0,0,0,0,0,'Ragnaros - Say Arrive 2.'),
(4163002,24,32,0,0,0,0,0,0,0,0,0,0,0,0,0,'Cenarius - Set Pause Movement = false.');


-- Script id: 4163003
DELETE FROM dbscripts_on_creature_movement WHERE id=4163003;
INSERT INTO dbscripts_on_creature_movement VALUES 
(4163003,3,2,53,32836,40793,50000,4,0,0,0,0,0,0,0,0,'Cenarius - Set Flags Ragnaros.'),
(4163003,0,32,1,0,0,0,0,0,0,0,0,0,0,0,0,'Cenarius - Set Pause Movement = true.'),
(4163003,5,26,0,0,40793,50000,1,0,0,0,0,0,0,0,0,'Cenarius - Attack Start Ragnaros.');

-- Creature id: 40803
UPDATE creature_template SET AIName='EventAI' WHERE entry=40803;
DELETE FROM creature_ai_scripts WHERE creature_id=40803;
INSERT INTO creature_ai_scripts VALUES 
('4080301','40803','11','0','100','0','0','0','0','0','21','0','0','0','0','0','0','0','0','0','0','0','Cenarius - Preevent Combat Movement.'),
('4080302','40803','0','0','100','1','1000','1000','1000','1000','11','76251','1','32','0','0','0','0','0','0','0','0','Cenarius - Cast Chilling Icecrown.');


UPDATE `creature_movement_template` SET `script_id`= 4079301 WHERE `entry`=40793 AND `point`=1;

UPDATE `creature_movement_template` SET `script_id`= 4163001 WHERE `entry` IN (40803, 41630, 41632) AND `point`=1;
UPDATE `creature_movement_template` SET `script_id`= 4163002 WHERE `entry`=40803 AND `point`=15;
UPDATE `creature_movement_template` SET `script_id`= 4163003 WHERE `entry`=40803 AND `point`=16;
UPDATE `creature_movement_template` SET `script_id`= 4163001 WHERE `entry`=41632 AND `point`=25;
UPDATE `creature_movement_template` SET `script_id`= 4163001 WHERE `entry`=41630 AND `point`=17;
UPDATE `creature_movement_template` SET `script_id`= 4163004 WHERE `entry`=40803 AND `point`=17;

DELETE FROM `creature_linking_template` WHERE `entry` IN (41630, 41632) AND `master_entry` = 40803;
INSERT INTO `creature_linking_template` (`entry`, `map`, `master_entry`, `flag`, `search_range`) VALUES
('41630','1','40803','3','0'),
('41632','1','40803','3','0');

DELETE FROM `creature_ai_texts` WHERE `entry` IN (-1709, -1710, -1711, -1712, -1713);
INSERT INTO `creature_ai_texts` (`entry`, `content_default`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
('-1709','BE BATHED IN FLAME!','ОКУНИТЕСЬ В ПЛАМЯ!','22576','1','0','0','Quest Firelord.'),
('-1710','BURN IN LIQUID FLAME!','ГОРИТЕ В ЖИДКОМ ОГНЕ!','22577','1','0','0','Quest Firelord.'),
('-1711','BURN THEIR FLESH AND SEAR THEIR BONES!','ИСПЕПЕЛИТЕ ИХ ПЛОТЬ И СОЖГИТЕ КОСТИ!','22579','1','0','0','Quest Firelord.'),
('-1712','ASSIST ME, MY CHILDREN!','ПОМОГИТЕ МНЕ ДЕТИ МОИ!','22578','1','0','0','Quest Firelord.'),
('-1713','YOU HAVE ONLY DELAYED THE INEVITABLE, CENARIUS. FROM THE FIRELANDS MY ARMIES WILL BE REBORN!','ТЫ ЛИШЬ ОТСРОЧИЛ НЕИЗБЕЖНОЕ КЕНАРИЙ! МОИ АРМИИ ВОЗРОДЯТСЯ НА ОГНЕННЫХ ПРОСТОРАХ!','22578','1','0','0','Quest Firelord.');

-- Script id: 4163004 Hacking Outro Event(need more support db_scripting engine and EventAI engine)
DELETE FROM dbscripts_on_creature_movement WHERE id=4163004;
INSERT INTO dbscripts_on_creature_movement VALUES 
(4163004,7,3,0,3000,41632,50000,4,0,0,0,0,4002.87,-3020.8,575.39,1.72741,'Malfurion Move Last Point. '),
(4163004,7,3,0,3000,41630,50000,4,0,0,0,0,4032.94,-3004.77,575.39,1.97491,'Hamuul Move Last Point.'),
(4163004,0,32,1,0,0,0,0,0,0,0,0,0,0,0,0,'Cenarius - Pause Movement.'),
(4163004,0,21,1,0,0,0,0,0,0,0,0,0,0,0,0,'Cenarius - Set Active Object State = True.'),
(4163004,15,0,1,0,0,0,0,2000006668,0,0,0,0,0,0,0,'Cenarius - Yell(Outro Event)'),
(4163004,22,0,1,0,41632,50000,4,2000006669,0,0,0,0,0,0,0,'Malfurion - Yell(Outro Event)'),
(4163004,31,0,0,0,41630,50000,4,2000006670,0,0,0,0,0,0,0,'Hamuul - Yell(Outro Event)'),
(4163004,49,0,0,0,0,0,0,2000006671,0,0,0,0,0,0,0,'Cenarius - Last Yell(Outro Event)'),
(4163004,63,18,0,0,0,0,0,0,0,0,0,0,0,0,0,'Despawn Self'),
(4163004,60,35,6,500,0,0,0,0,0,0,0,0,0,0,0,'Cenarius - Send AI Event B(from Malfurion and Hamuul for despawn)'),
(4163004,55,15,76597,0,41630,50000,2,0,0,0,0,0,0,0,0,'Cenarius - get closest Hamuul and force cast Portal(need more info, because spell has 46 target)');



-- Script id: 4079301
DELETE FROM dbscripts_on_creature_movement WHERE id=4079301;
INSERT INTO dbscripts_on_creature_movement VALUES 
(4079301,9,32,0,0,40803,50000,4,0,0,0,0,0,0,0,0,'Ragnaros - Pause Movement = false from Cenarius.'),
(4079301,0,8,40793,1,0,0,0,0,0,0,0,0,0,0,0,'Ragnaros - Kill Credit.'),
(4079301,9,18,0,0,0,0,0,0,0,0,0,0,0,0,0,'Ragnaros - Despawn Self'),
(4079301,0,21,1,0,0,0,0,0,0,0,0,0,0,0,0,'Ragnaros - Set Active Object State.');
Я закончил. Может в СД2 и лучше получится написать. Но всё равно для Катаклизма ещё куча функций нужна(особенно LoS, grid) Миока правильно всё тогда на Румангосе сказал.
Отсюда можно взять, тексты, звуки, русский перевод, что бы по 2 часа не искать.
__________________
Ты кто? Зёбра! Ктооооооо?!

Последний раз редактировалось Ulduar; 03.10.2014 в 20:14.
Ulduar вне форума   Ответить с цитированием