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

Почти закончил. Осталось совсем немного!
Скину то, что уже сделал.
Код:





REPLACE INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`) VALUES('8000','9','25551','0');
REPLACE INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES('11434','15931','0','8000');
REPLACE 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');
REPLACE 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','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);

-- 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.');


REPLACE 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.');
REPLACE INTO `db_script_string` (`entry`, `content_default`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES('2000006661','We are ready, Cenarius.','Мы готовы, Кенарий.','20805','0','0','0','Malfurion - Say Arrive.');
REPLACE INTO `db_script_string` (`entry`, `content_default`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES('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.');
REPLACE INTO `db_script_string` (`entry`, `content_default`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES('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.');
REPLACE INTO `db_script_string` (`entry`, `content_default`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES('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.');
REPLACE INTO `db_script_string` (`entry`, `content_default`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES('2000006665','Quickly, everyone move into position! Force him back into the Firelands!','Быстро, занять позицию! Оттеснить его на Огненные Просторы!','21640','1','0','0','Cenarius - Say Prepare Fight Ragnaros.');
REPLACE INTO `db_script_string` (`entry`, `content_default`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES('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.');
REPLACE INTO `db_script_string` (`entry`, `content_default`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES('2000006667','FACE ME, INSECTS. I SHALL CRUSH YOU FIRSTHAND!','ВЗГЛЯНИТЕ НА МЕНЯ, МОКРИЦЫ! СЕЙЧАС Я РАЗДАВЛЮ ВАС!','22575','1','0','0','Ragnaros - Say Prefight.');
REPLACE INTO `db_script_string` (`entry`, `content_default`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES('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.');
REPLACE INTO `db_script_string` (`entry`, `content_default`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES('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.');
REPLACE INTO `db_script_string` (`entry`, `content_default`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES('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.');
REPLACE INTO `db_script_string` (`entry`, `content_default`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES('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.');
REPLACE INTO `db_script_string` (`entry`, `content_default`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES('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),
(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),
(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)');

-- 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','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.'),
('4163002','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.');



-- 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','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.'),
('4163202','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.');



UPDATE `creature_template` SET `unit_flags` = 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','1','0','100','1','1000','1000','0','0','11','56512','0','32','0','0','0','0','0','0','0','0','Ragnaros - Cast Submerged on Spawn( double script)'),
('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','1','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.'),
(4163002,24,32,0,0,41630,1000,4,0,0,0,0,0,0,0,0,'Hamuul - Set Pause Movement = false.'),
(4163002,24,32,0,0,41632,1000,4,0,0,0,0,0,0,0,0,'Malfurion - 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,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;



REPLACE INTO `creature_linking_template` (`entry`, `map`, `master_entry`, `flag`, `search_range`) VALUES('41630','1','40803','3','0');
REPLACE INTO `creature_linking_template` (`entry`, `map`, `master_entry`, `flag`, `search_range`) VALUES('41632','1','40803','3','0');

-- Text id: -1709
DELETE FROM creature_ai_texts WHERE entry=-1709;
INSERT INTO creature_ai_texts VALUES 
('-1709','BE BATHED IN FLAME!','','','','','','','','ОКУНИТЕСЬ В ПЛАМЯ!','22576','1','0','0,');

-- Text id: -1710
DELETE FROM creature_ai_texts WHERE entry=-1710;
INSERT INTO creature_ai_texts VALUES 
('-1710','BURN IN LIQUID FLAME!','','','','','','','','ГОРИТЕ В ЖИДКОМ ОГНЕ!','22577','1','0','0,');

-- Text id: -1711
DELETE FROM creature_ai_texts WHERE entry=-1711;
INSERT INTO creature_ai_texts VALUES 
('-1711','BURN THEIR FLESH AND SEAR THEIR BONES!','','','','','','','','ИСПЕПЕЛИТЕ ИХ ПЛОТЬ И СОЖГИТЕ КОСТИ!','22579','1','0','0,');

-- Text id: -1712
DELETE FROM creature_ai_texts WHERE entry=-1712;
INSERT INTO creature_ai_texts VALUES 
('-1712','ASSIST ME, MY CHILDREN!','','','','','','','','ПОМОГИТЕ МНЕ ДЕТИ МОИ!','22578','1','0','0,');

-- Text id: -1713
DELETE FROM creature_ai_texts WHERE entry=-1713;
INSERT INTO creature_ai_texts VALUES 
('-1713','YOU HAVE ONLY DELAYED THE INEVITABLE, CENARIUS. FROM THE FIRELANDS MY ARMIES WILL BE REBORN!','','','','','','','','ТЫ ЛИШЬ ОТСРОЧИЛ НЕИЗБЕЖНОЕ КЕНАРИЙ! МОИ АРМИИ ВОЗРОДЯТСЯ НА ОГНЕННЫХ ПРОСТОРАХ!','22578','1','0','0,');
__________________
Ты кто? Зёбра! Ктооооооо?!

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