vortex pinnacle sql

#база

#база

UPDATE `creature_template` SET `flags_extra`=128 WHERE `entry`=46007;

UPDATE `creature_template` SET `flags_extra`=128 WHERE `entry`=47305;

UPDATE `creature_template` SET `flags_extra`=128 WHERE `entry`=46492;

#скрипты

#треш
UPDATE `creature_template` SET `ScriptName`='npc_vortex_pinnacle_slipsteam' WHERE `entry`=45455;
UPDATE `creature_template` SET `ScriptName`='npc_skyfall_star' WHERE `entry`=45932;
UPDATE `creature_template` SET `ScriptName`='npc_skyfall_star' WHERE `entry`=52019;
UPDATE `creature_template` SET `ScriptName`='npc_cloud_prince' WHERE `entry`=45917;
UPDATE `creature_template` SET `ScriptName`='npc_whipping_wind' WHERE `entry`=47238;
UPDATE `creature_template` SET `ScriptName`='npc_young_storm_dragon' WHERE `entry`=45919;
UPDATE `creature_template` SET `ScriptName`='npc_armored_mistral' WHERE `entry`=45915;
UPDATE `creature_template` SET `ScriptName`='npc_empyrean_assassin' WHERE `entry`=45922;
UPDATE `creature_template` SET `ScriptName`='npc_executor_of_the_caliph' WHERE `entry`=45928;
UPDATE `creature_template` SET `ScriptName`='npc_gust_soldier' WHERE `entry`=45477;
UPDATE `creature_template` SET `ScriptName`='npc_howling_gale' WHERE `entry`=45572;
UPDATE `creature_template` SET `ScriptName`='npc_lurking_tempest' WHERE `entry=`45704;
UPDATE `creature_template` SET `ScriptName`='npc_minister_of_air' WHERE `entry`=45930;
UPDATE `creature_template` SET `ScriptName`='npc_servant_of_asaad' WHERE `entry`=45926;
UPDATE `creature_template` SET `ScriptName`='npc_temple_adept' WHERE `entry`=45935;
UPDATE `creature_template` SET `ScriptName`='npc_turbulent_squall' WHERE `entry`=45924;
UPDATE `creature_template` SET `ScriptName`='npc_wild_vortex' WHERE `entry`=45912;

#эртан
UPDATE `creature_template` SET `ScriptName`='boss_grand_vizier_ertan' WHERE `entry`=43878;
UPDATE `creature_template` SET `ScriptName`='npc_ertan_vortex' WHERE `entry`=46007;

#альтаирий
UPDATE `creature_template` SET `ScriptName`='boss_altairus' WHERE `entry`=43873;
UPDATE `creature_template` SET `ScriptName`='npc_air_current' WHERE `entry`=47305;

#асаад
UPDATE `creature_template` SET `ScriptName`='boss_asaad' WHERE `entry`=43875;
UPDATE `creature_template` SET `ScriptName`='npc_unstable_grounding_field' WHERE `entry`=46492;

#спеллы

#треш
DELETE FROM `spell_script_names` WHERE `spell_id`=87765;
DELETE FROM `spell_script_names` WHERE `spell_id`=85084;
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (87765, 'spell_minister_of_air_lightning_lash');
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (85084, '85084spell_howling_gale_howling_gale');

#асаад

DELETE FROM `conditions` WHERE `SourceEntry`=86911;
DELETE FROM `conditions` WHERE `SourceEntry`=87517;
INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
VALUES ('13', '0', '86911', '0', '18', '1', '46492', '0', '0', '', 'Unstable grounding field');
INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
VALUES ('13', '0', '87517', '0', '18', '1', '46492', '0', '0', '', 'Grounding field visual beams');
DELETE FROM `spell_script_names` WHERE `spell_id`=87553;
DELETE FROM `spell_script_names` WHERE `spell_id`=93994;
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (87553, 'spell_asaad_supremacy_of_the_storm');
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (93994, 'spell_asaad_supremacy_of_the_storm');


#тексты

#эртан
DELETE FROM `creature_text` WHERE `entry`=43878;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (43878, 0, 0, 'Filthy beasts! Your presence in Skywall will not be tolerated!', 1, 0, 0, 0, 0, 20876, 'VO_VP_Ertan_Event01');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (43878, 1, 0, 'Ravaged!', 1, 0, 0, 0, 0, 20877, 'VO_VP_Ertan_Event02');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (43878, 2, 0, 'AHHHHHHHHH!', 1, 0, 0, 0, 0, 20878, 'VO_VP_Ertan_Event03');

#асаад
DELETE FROM `creature_text` WHERE `entry`=43875;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (43875, 0, 0, 'YOU tread upon the sacrosanct! Mortals have no place amidst the clouds.', 1, 0, 0, 0, 0, 20867, 'VO_VP_AsimAlAkir_Event01');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (43875, 1, 0, 'BACK to the earth with you!', 1, 0, 0, 0, 0, 20868, 'VO_VP_AsimAlAkir_Event02');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (43875, 2, 0, 'Al\'Akir, your servant calls for aid!', 1, 0, 0, 0, 0, 20869, 'VO_VP_AsimAlAkir_Event03');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
VALUES (43875, 3, 0, 'The winds take me!', 1, 0, 0, 0, 0, 20870, 'VO_VP_AsimAlAkir_Event04');