From b1ccc0e4cc26f9347757f81731816a0ad8de2c90 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Wed, 30 Jul 2014 23:01:46 +0200 Subject: SQL: Fix typo (thx @Wulfr) --- sql/updates/world/2014_07_30_02_world_sai.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/updates/world/2014_07_30_02_world_sai.sql b/sql/updates/world/2014_07_30_02_world_sai.sql index ef12a4236c5..9cc695e9d19 100644 --- a/sql/updates/world/2014_07_30_02_world_sai.sql +++ b/sql/updates/world/2014_07_30_02_world_sai.sql @@ -1 +1 @@ -UPDATE `smart_scripts` SET `event_phase_mask`=1 WHERE `entryorguid`=15402 AND `source_type`=0 AND `id`=6 +UPDATE `smart_scripts` SET `event_phase_mask`=1 WHERE `entryorguid`=15402 AND `source_type`=0 AND `id`=6; -- cgit v1.2.3 From 679b3d083c8c42369301f4f2b4427162c5a5b6d0 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Thu, 31 Jul 2014 00:06:01 +0100 Subject: DB/SAI: Powering Our Defenses Powering Our Defenses SAI version, finally gets this quest working Blizzlike, * Deletes the permament DB spawns of enraged wraith (these are not spawned randomly by script as they should be) * Correct faction for infused crystal so now the Enraged Wraiths will actually attack it * Fixes the despawning/text spamming issue --- sql/updates/world/2014_07_30_08_world_sai.sql | 45 +++++++++++++++++++++++++++ 1 file changed, 45 insertions(+) create mode 100644 sql/updates/world/2014_07_30_08_world_sai.sql diff --git a/sql/updates/world/2014_07_30_08_world_sai.sql b/sql/updates/world/2014_07_30_08_world_sai.sql new file mode 100644 index 00000000000..d13e2803b07 --- /dev/null +++ b/sql/updates/world/2014_07_30_08_world_sai.sql @@ -0,0 +1,45 @@ +UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`='',`faction`=775 WHERE `entry` IN(16364); + +DELETE FROM `smart_scripts` WHERE `entryorguid` =16364 and `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` =23837 and `source_type`=0 AND `id` IN(3,4); + +DELETE FROM `smart_scripts` WHERE `entryorguid` BETWEEN 1636400 AND 1636408 AND `source_type`=9; + +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(16364, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Infused Crystal - on spawn - Store Targetlist'), +(16364, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 12, 23837, 1, 60000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Infused Crystal - on spawn - Spawn ELM General Purpose Bunny'), +(16364, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Infused Crystal - on spawn - Disable auto attack'), +(16364, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Infused Crystal - on spawn - Disable combat movement'), +(16364, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 80, 1636400, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Infused Crystal - on spawn - run script'), +(16364, 0, 5, 0, 6, 0, 100, 0, 0, 0, 0, 0, 6, 8490, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Infused Crystal - On Death - Fail quest (Powering our defenses)'), +(1636400, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 31, 31, 0, 0, 0, 0, 19, 23837, 0, 0, 0, 0, 0, 0, 'Infused Crystal - Script - Set Data ELM General Purpose Bunny'), +(1636400, 9, 1, 0, 0, 0, 100, 0, 15000, 15000, 0, 0, 45, 30, 30, 0, 0, 0, 0, 19, 23837, 0, 0, 0, 0, 0, 0, 'Infused Crystal - Script - Set Data ELM General Purpose Bunny'), +(1636400, 9, 2, 0, 0, 0, 100, 0, 15000, 15000, 0, 0, 45, 31, 31, 0, 0, 0, 0, 19, 23837, 0, 0, 0, 0, 0, 0, 'Infused Crystal - Script - Set Data ELM General Purpose Bunny'), +(1636400, 9, 3, 0, 0, 0, 100, 0, 15000, 15000, 0, 0, 45, 30, 30, 0, 0, 0, 0, 19, 23837, 0, 0, 0, 0, 0, 0, 'Infused Crystal - Script - Set Data ELM General Purpose Bunny'), +(1636400, 9, 4, 0, 0, 0, 100, 0, 15000, 15000, 0, 0, 33, 16364, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Infused Crystal - Script - Complete quest (Powering our defenses)'), +(1636400, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Infused Crystal - Script - Say'), +(1636400, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Infused Crystal - Script - Despawn'), + +(1636401, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 17086, 6, 60000, 0, 0, 0, 8, 0, 0, 0, 8270.68, -7188.53, 139.619, 4.93306, 'Infused Crystal - Script - Spawn Enraged Wraith'), +(1636402, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 17086, 6, 60000, 0, 0, 0, 8, 0, 0, 0, 8284.27, -7187.78, 139.603, 4.43198, 'Infused Crystal - Script - Spawn Enraged Wraith'), +(1636403, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 17086, 6, 60000, 0, 0, 0, 8, 0, 0, 0, 8297.43, -7193.53, 139.603, 3.93325, 'Infused Crystal - Script - Spawn Enraged Wraith'), +(1636404, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 17086, 6, 60000, 0, 0, 0, 8, 0, 0, 0, 8303.5, -7201.96, 139.577, 3.60417, 'Infused Crystal - Script - Spawn Enraged Wraith'), +(1636405, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 17086, 6, 60000, 0, 0, 0, 8, 0, 0, 0, 8273.22, -7241.82, 139.382, 1.49851, 'Infused Crystal - Script - Spawn Enraged Wraith'), +(1636406, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 17086, 6, 60000, 0, 0, 0, 8, 0, 0, 0, 8254.89, -7222.12, 139.603, 0.635359, 'Infused Crystal - Script - Spawn Enraged Wraith'), +(1636407, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 17086, 6, 60000, 0, 0, 0, 8, 0, 0, 0, 8278.51, -7242.13, 139.162, 1.73178, 'Infused Crystal - Script - Spawn Enraged Wraith'), +(1636408, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 17086, 6, 60000, 0, 0, 0, 8, 0, 0, 0, 8278.51, -7242.13, 139.162, 1.73178, 'Infused Crystal - Script - Spawn Enraged Wraith'), + +(23837, 0, 3, 0, 38, 0, 100, 0, 31, 31, 0, 0, 87, 1636401, 1636403, 1636404, 1636406, 1636407, 1636408, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny - On Data Set - Run Random Script'), +(23837, 0, 4, 0, 38, 0, 100, 0, 30, 30, 0, 0, 87, 1636401, 1636402, 1636403, 1636405, 1636406, 1636408, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny - On Data Set - Run Random Script'); + +DELETE FROM `creature` WHERE `id`=17086; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=17086 AND `id`>1; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(17086, 0, 2, 0, 54, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 19, 16364, 0, 0, 0, 0, 0, 0, 'Enraged Wraith - On Just Summoned - Attack infused crystal'), +(17086, 0, 3, 0, 7, 0, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Enraged Wraith - On Evade Despawn'); + +DELETE FROM `creature_text` WHERE `entry`=16364; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES +(16364, 0, 0, '%s releases the last of its energies into the nearby runestone, successfully reactivating it.', 16, 0, 100, 0, 0, 0, 'Infused Crystal',12272); + -- cgit v1.2.3 From 5b311690d131ce3a242003d365fd0103f6bf033f Mon Sep 17 00:00:00 2001 From: Dr-J Date: Thu, 31 Jul 2014 00:12:33 +0100 Subject: Remove Script from zone_eversong_woods.cpp This cpp is now currently redundant --- .../EasternKingdoms/zone_eversong_woods.cpp | 121 +-------------------- 1 file changed, 1 insertion(+), 120 deletions(-) diff --git a/src/server/scripts/EasternKingdoms/zone_eversong_woods.cpp b/src/server/scripts/EasternKingdoms/zone_eversong_woods.cpp index 9e20f6c5cb1..01f7d932c42 100644 --- a/src/server/scripts/EasternKingdoms/zone_eversong_woods.cpp +++ b/src/server/scripts/EasternKingdoms/zone_eversong_woods.cpp @@ -19,12 +19,11 @@ /* ScriptData SDName: Eversong_Woods SD%Complete: 95 -SDComment: Quest support: 8490 +SDComment: Quest support: SDCategory: Eversong Woods EndScriptData */ /* ContentData -npc_infused_crystal EndContentData */ #include "ScriptMgr.h" @@ -33,124 +32,6 @@ EndContentData */ #include "ScriptedEscortAI.h" #include "Player.h" - -/*###### -## npc_infused_crystal -######*/ - -enum InfusedCrystal -{ - // Quest - QUEST_POWERING_OUR_DEFENSES = 8490, - - // Quest Credit - QUEST_POD_CREDIT = 16364, - - // Says - EMOTE = 0, - - // Creatures - NPC_ENRAGED_WRAITH = 17086 -}; - -struct Location -{ - float x, y, z; -}; - -static Location SpawnLocations[] = -{ - {8270.68f, -7188.53f, 139.619f}, - {8284.27f, -7187.78f, 139.603f}, - {8297.43f, -7193.53f, 139.603f}, - {8303.5f, -7201.96f, 139.577f}, - {8273.22f, -7241.82f, 139.382f}, - {8254.89f, -7222.12f, 139.603f}, - {8278.51f, -7242.13f, 139.162f}, - {8267.97f, -7239.17f, 139.517f} -}; - -class npc_infused_crystal : public CreatureScript -{ -public: - npc_infused_crystal() : CreatureScript("npc_infused_crystal") { } - - CreatureAI* GetAI(Creature* creature) const override - { - return new npc_infused_crystalAI(creature); - } - - struct npc_infused_crystalAI : public ScriptedAI - { - npc_infused_crystalAI(Creature* creature) : ScriptedAI(creature) - { - SetCombatMovement(false); - } - - uint32 EndTimer; - uint32 WaveTimer; - bool Completed; - bool Progress; - uint64 PlayerGUID; - - void Reset() override - { - EndTimer = 0; - Completed = false; - Progress = false; - PlayerGUID = 0; - WaveTimer = 0; - } - - void MoveInLineOfSight(Unit* who) override - - { - if (!Progress && who->GetTypeId() == TYPEID_PLAYER && me->IsWithinDistInMap(who, 10.0f)) - { - if (who->ToPlayer()->GetQuestStatus(QUEST_POWERING_OUR_DEFENSES) == QUEST_STATUS_INCOMPLETE) - { - PlayerGUID = who->GetGUID(); - WaveTimer = 1000; - EndTimer = 60000; - Progress = true; - } - } - } - - void JustSummoned(Creature* summoned) override - { - summoned->AI()->AttackStart(me); - } - - void UpdateAI(uint32 diff) override - { - if (EndTimer < diff && Progress) - { - Completed = true; - if (PlayerGUID) - if (Player* player = ObjectAccessor::GetPlayer(*me, PlayerGUID)) - { - Talk(EMOTE, player); - player->KilledMonsterCredit(QUEST_POD_CREDIT); - } - me->RemoveCorpse(); - } else EndTimer -= diff; - - if (WaveTimer < diff && !Completed && Progress) - { - uint32 ran1 = rand32() % 8; - uint32 ran2 = rand32() % 8; - uint32 ran3 = rand32() % 8; - me->SummonCreature(NPC_ENRAGED_WRAITH, SpawnLocations[ran1].x, SpawnLocations[ran1].y, SpawnLocations[ran1].z, 0, TEMPSUMMON_TIMED_OR_CORPSE_DESPAWN, 10000); - me->SummonCreature(NPC_ENRAGED_WRAITH, SpawnLocations[ran2].x, SpawnLocations[ran2].y, SpawnLocations[ran2].z, 0, TEMPSUMMON_TIMED_OR_CORPSE_DESPAWN, 10000); - me->SummonCreature(NPC_ENRAGED_WRAITH, SpawnLocations[ran3].x, SpawnLocations[ran3].y, SpawnLocations[ran3].z, 0, TEMPSUMMON_TIMED_OR_CORPSE_DESPAWN, 10000); - WaveTimer = 30000; - } else WaveTimer -= diff; - } - }; -}; - void AddSC_eversong_woods() { - new npc_infused_crystal(); } -- cgit v1.2.3 From 5418844f15d939d8fdab9402548509b676ed28c4 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Thu, 31 Jul 2014 00:24:08 +0100 Subject: Delete zone_eversong_woods.cpp --- .../EasternKingdoms/zone_eversong_woods.cpp | 37 ---------------------- 1 file changed, 37 deletions(-) delete mode 100644 src/server/scripts/EasternKingdoms/zone_eversong_woods.cpp diff --git a/src/server/scripts/EasternKingdoms/zone_eversong_woods.cpp b/src/server/scripts/EasternKingdoms/zone_eversong_woods.cpp deleted file mode 100644 index 01f7d932c42..00000000000 --- a/src/server/scripts/EasternKingdoms/zone_eversong_woods.cpp +++ /dev/null @@ -1,37 +0,0 @@ -/* - * Copyright (C) 2008-2014 TrinityCore - * Copyright (C) 2006-2009 ScriptDev2 - * - * This program is free software; you can redistribute it and/or modify it - * under the terms of the GNU General Public License as published by the - * Free Software Foundation; either version 2 of the License, or (at your - * option) any later version. - * - * This program is distributed in the hope that it will be useful, but WITHOUT - * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or - * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for - * more details. - * - * You should have received a copy of the GNU General Public License along - * with this program. If not, see . - */ - -/* ScriptData -SDName: Eversong_Woods -SD%Complete: 95 -SDComment: Quest support: -SDCategory: Eversong Woods -EndScriptData */ - -/* ContentData -EndContentData */ - -#include "ScriptMgr.h" -#include "ScriptedCreature.h" -#include "ScriptedGossip.h" -#include "ScriptedEscortAI.h" -#include "Player.h" - -void AddSC_eversong_woods() -{ -} -- cgit v1.2.3 From bfbfc1f08cc71721cf1a0e5cf4e8e9116de58c4e Mon Sep 17 00:00:00 2001 From: Dr-J Date: Thu, 31 Jul 2014 00:28:10 +0100 Subject: Update ScriptLoader.cpp --- src/server/game/Scripting/ScriptLoader.cpp | 1 - 1 file changed, 1 deletion(-) diff --git a/src/server/game/Scripting/ScriptLoader.cpp b/src/server/game/Scripting/ScriptLoader.cpp index 862b8dffddb..a0185bf7709 100644 --- a/src/server/game/Scripting/ScriptLoader.cpp +++ b/src/server/game/Scripting/ScriptLoader.cpp @@ -978,7 +978,6 @@ void AddEasternKingdomsScripts() AddSC_burning_steppes(); AddSC_duskwood(); AddSC_eastern_plaguelands(); - AddSC_eversong_woods(); AddSC_ghostlands(); AddSC_hinterlands(); AddSC_isle_of_queldanas(); -- cgit v1.2.3 From 9253ff7cb784f75caffe4b4e13d9cf2c73785a37 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Thu, 31 Jul 2014 00:29:54 +0100 Subject: Update CMakeLists.txt --- src/server/scripts/EasternKingdoms/CMakeLists.txt | 1 - 1 file changed, 1 deletion(-) diff --git a/src/server/scripts/EasternKingdoms/CMakeLists.txt b/src/server/scripts/EasternKingdoms/CMakeLists.txt index 61a5037fa00..d9ab6fa18ce 100644 --- a/src/server/scripts/EasternKingdoms/CMakeLists.txt +++ b/src/server/scripts/EasternKingdoms/CMakeLists.txt @@ -11,7 +11,6 @@ set(scripts_STAT_SRCS ${scripts_STAT_SRCS} EasternKingdoms/zone_ghostlands.cpp - EasternKingdoms/zone_eversong_woods.cpp EasternKingdoms/AlteracValley/boss_galvangar.cpp EasternKingdoms/AlteracValley/boss_balinda.cpp EasternKingdoms/AlteracValley/boss_drekthar.cpp -- cgit v1.2.3 From 4c9258d586931d73e0c54bbfbcf05a3a1776cabf Mon Sep 17 00:00:00 2001 From: Malcrom Date: Wed, 30 Jul 2014 21:10:18 -0230 Subject: DB/SAI: More SAI corrected to use CMC. All entries up to 7000 requiring caster movement control now using CMC --- sql/updates/world/2014_07_30_09_world_sai.sql | 177 ++++++++++++++++++++++++++ 1 file changed, 177 insertions(+) create mode 100644 sql/updates/world/2014_07_30_09_world_sai.sql diff --git a/sql/updates/world/2014_07_30_09_world_sai.sql b/sql/updates/world/2014_07_30_09_world_sai.sql new file mode 100644 index 00000000000..a1497dea582 --- /dev/null +++ b/sql/updates/world/2014_07_30_09_world_sai.sql @@ -0,0 +1,177 @@ +-- Summoned Voidwalker SAI +SET @ENTRY := 5676; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,11,0,100,1,0,0,0,0,11,7741,0,0,0,0,0,1,0,0,0,0,0,0,0,"Summoned Voidwalker - On Respawn - Cast 'Summoned Demon'"), +(@ENTRY,0,1,0,2,0,100,1,0,30,0,0,11,7750,1,0,0,0,0,1,0,0,0,0,0,0,0,"Summoned Voidwalker - Between 0-30% Health - Cast 'Consuming Rage'"); + +-- Dalin Forgewright SAI +SET @ENTRY := 5682; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,2,0,100,0,0,80,20000,20000,11,6075,1,0,0,0,0,1,0,0,0,0,0,0,0,"Dalin Forgewright - Between 0-80% Health - Cast 'Renew'"), +(@ENTRY,0,1,0,2,0,100,0,0,30,10000,10000,11,2054,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dalin Forgewright - Between 0-30% Health - Cast 'Heal'"); + +-- Spawn of Hakkar SAI +SET @ENTRY := 5708; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,1000,3500,1200,6200,11,12280,32,0,0,0,0,2,0,0,0,0,0,0,0,"Spawn of Hakkar - In Combat - Cast 'Acid of Hakkar' (Normal Dungeon)"); + +-- Felweaver Scornn SAI +SET @ENTRY := 5822; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4600,11,9613,64,0,0,0,0,2,0,0,0,0,0,0,0,"Felweaver Scornn - In Combat CMC - Cast 'Shadow Bolt'"), +(@ENTRY,0,1,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Felweaver Scornn - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Azzere the Skyblade SAI +SET @ENTRY := 5834; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2400,3800,11,13375,64,0,0,0,0,2,0,0,0,0,0,0,0,"Azzere the Skyblade - In Combat CMC - Cast 'Fireball'"), +(@ENTRY,0,1,0,0,0,80,0,4000,9000,22000,29000,11,6725,1,0,0,0,0,2,0,0,0,0,0,0,0,"Azzere the Skyblade - In Combat - Cast 'Flame Spike'"); + +-- Brokespear SAI +SET @ENTRY := 5838; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,10277,64,0,0,0,0,2,0,0,0,0,0,0,0,"Brokespear - In Combat CMC - Cast 'Throw'"), +(@ENTRY,0,1,0,0,0,100,0,6000,12000,9000,15000,11,7992,32,0,0,0,0,5,0,0,0,0,0,0,0,"Brokespear - In Combat - Cast 'Slowing Poison'"), +(@ENTRY,0,2,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Brokespear - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Dark Iron Geologist SAI +SET @ENTRY := 5839; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2800,3600,11,20823,64,0,0,0,0,2,0,0,0,0,0,0,0,"Dark Iron Geologist - In Combat CMC - Cast 'Fireball'"), +(@ENTRY,0,1,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Geologist - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Heggin Stonewhisker SAI +SET @ENTRY := 5847; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Heggin Stonewhisker - In Combat CMC - Cast 'Shoot'"), +(@ENTRY,0,1,0,0,0,100,0,6000,12000,9000,14000,11,6979,0,0,0,0,0,2,0,0,0,0,0,0,0,"Heggin Stonewhisker - In Combat - Cast 'Fire Shot'"), +(@ENTRY,0,2,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Heggin Stonewhisker - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Dreadmaul Ogre Mage SAI +SET @ENTRY := 5975; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4800,11,20823,64,0,0,0,0,2,0,0,0,0,0,0,0,"Dreadmaul Ogre Mage - In Combat CMC - Cast 'Fireball'"), +(@ENTRY,0,1,0,2,0,100,0,0,30,34000,38000,11,6742,1,0,0,0,0,1,0,0,0,0,0,0,0,"Dreadmaul Ogre Mage - Between 0-30% Health - Cast 'Bloodlust'"); + +-- Dreadmaul Warlock SAI +SET @ENTRY := 5978; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4800,11,20298,64,0,0,0,0,2,0,0,0,0,0,0,0,"Dreadmaul Warlock - In Combat CMC - Cast 'Shadow Bolt'"), +(@ENTRY,0,1,0,0,0,100,0,5000,7000,15000,25000,11,8282,33,0,0,0,0,2,0,0,0,0,0,0,0,"Dreadmaul Warlock - In Combat - Cast 'Curse of Blood'"); + +-- Nethergarde Engineer SAI +SET @ENTRY := 5997; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Nethergarde Engineer - In Combat CMC - Cast 'Shoot'"), +(@ENTRY,0,1,0,0,0,100,0,8000,11000,12000,16000,11,8858,1,0,0,0,0,2,0,0,0,0,0,0,0,"Nethergarde Engineer - In Combat - Cast 'Bomb'"), +(@ENTRY,0,2,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Nethergarde Engineer - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Nethergarde Riftwatcher SAI +SET @ENTRY := 6002; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4800,11,20823,64,0,0,0,0,2,0,0,0,0,0,0,0,"Nethergarde Riftwatcher - In Combat CMC - Cast 'Fireball'"), +(@ENTRY,0,1,0,0,0,100,0,9000,14000,14000,18000,11,11975,1,0,0,0,0,1,0,0,0,0,0,0,0,"Nethergarde Riftwatcher - In Combat - Cast 'Arcane Explosion'"), +(@ENTRY,0,2,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Nethergarde Riftwatcher - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Shadowsworn Cultist SAI +SET @ENTRY := 6004; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,10277,64,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowsworn Cultist - In Combat CMC - Cast 'Throw'"), +(@ENTRY,0,1,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowsworn Cultist - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Shadowsworn Warlock SAI +SET @ENTRY := 6008; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,1,1000,1000,0,0,11,5108,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowsworn Warlock - Out of Combat - Cast 'Voidwalker' (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,0,0,3400,4800,11,20825,64,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowsworn Warlock - In Combat CMC - Cast 'Shadow Bolt'"), +(@ENTRY,0,2,0,0,0,100,0,5000,8000,30000,45000,11,11980,33,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowsworn Warlock - In Combat - Cast 'Curse of Weakness'"), +(@ENTRY,0,3,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowsworn Warlock - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Shadowsworn Dreadweaver SAI +SET @ENTRY := 6009; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4800,11,20825,64,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowsworn Dreadweaver - In Combat CMC - Cast 'Shadow Bolt'"), +(@ENTRY,0,1,0,0,0,100,0,8000,11000,19000,24000,11,8994,1,0,0,0,0,6,0,0,0,0,0,0,0,"Shadowsworn Dreadweaver - In Combat - Cast 'Banish'"), +(@ENTRY,0,2,0,0,0,100,0,12000,16000,30000,45000,11,7098,33,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowsworn Dreadweaver - In Combat - Cast 'Curse of Mending'"); + +-- Addled Leper SAI +SET @ENTRY := 6221; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,1,1000,1000,0,0,11,7165,1,0,0,0,0,1,0,0,0,0,0,0,0,"Addled Leper - Out of Combat - Cast 'Battle Stance'"), +(@ENTRY,0,1,0,0,0,100,0,0,0,2300,3900,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Addled Leper - In Combat CMC - Cast 'Shoot'"), +(@ENTRY,0,2,0,9,0,100,0,0,5,17000,23000,11,9080,1,0,0,0,0,2,0,0,0,0,0,0,0,"Addled Leper - Within 0-5 Range - Cast 'Hamstring'"), +(@ENTRY,0,3,0,0,0,100,0,7000,9000,13000,16000,11,25712,1,0,0,0,0,2,0,0,0,0,0,0,0,"Addled Leper - In Combat - Cast 'Heroic Strike'"), +(@ENTRY,0,4,0,2,0,100,0,0,30,30000,45000,11,2055,1,0,0,0,0,1,0,0,0,0,0,0,0,"Addled Leper - Between 0-30% Health - Cast 'Heal'"), +(@ENTRY,0,5,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Addled Leper - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Dark Iron Ambassador SAI +SET @ENTRY := 6228; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,2,1000,1000,1800000,1800000,11,12544,33,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Ambassador - Out of Combat - Cast 'Frost Armor'"), +(@ENTRY,0,1,0,0,0,100,2,0,0,2400,3800,11,9053,64,0,0,0,0,2,0,0,0,0,0,0,0,"Dark Iron Ambassador - In Combat CMC - Cast 'Fireball'"), +(@ENTRY,0,2,0,0,0,100,2,1000,1000,60000,65000,11,184,1,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Ambassador - In Combat - Cast 'Fire Shield II'"), +(@ENTRY,0,3,0,0,0,100,3,2000,2000,0,0,11,10870,1,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Ambassador - In Combat - Cast 'Summon Burning Servant' (No Repeat)"), +(@ENTRY,0,4,0,0,0,100,3,3000,3000,0,0,11,10870,1,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Ambassador - In Combat - Cast 'Summon Burning Servant' (No Repeat)"), +(@ENTRY,0,5,0,0,0,100,3,4000,4000,0,0,11,10869,1,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Ambassador - In Combat - Cast 'Summon Embers' (No Repeat)"); + +-- Dark Iron Rifleman SAI +SET @ENTRY := 6523; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,4,0,15,1,0,0,0,0,1,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Dark Iron Rifleman - On Aggro - Say Line 0 (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,0,0,2300,5000,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Dark Iron Rifleman - In Combat CMC - Cast 'Shoot'"), +(@ENTRY,0,2,0,0,0,100,0,16100,16100,20100,32200,11,7891,3,0,0,0,0,5,0,0,0,0,0,0,0,"Dark Iron Rifleman - In Combat - Cast 'Gift of Ragnaros'"), +(@ENTRY,0,3,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Rifleman - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Baelog SAI +SET @ENTRY := 6906; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,0,0,2300,3900,11,15620,64,0,0,0,0,2,0,0,0,0,0,0,0,"Baelog - In Combat CMC - Cast 'Shoot' (Normal Dungeon)"), +(@ENTRY,0,1,0,0,0,100,2,4000,7000,9000,13000,11,14516,1,0,0,0,0,2,0,0,0,0,0,0,0,"Baelog - In Combat - Cast 'Strike' (Normal Dungeon)"), +(@ENTRY,0,2,0,2,0,100,3,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Baelog - Between 0-15% Health - Flee For Assist (No Repeat) (Normal Dungeon)"); + +-- Revelosh SAI +SET @ENTRY := 6910; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,0,0,2400,3800,11,15801,64,0,0,0,0,2,0,0,0,0,0,0,0,"Revelosh - In Combat CMC - Cast 'Lightning Bolt' (Normal Dungeon)"), +(@ENTRY,0,1,0,0,0,100,2,8000,13000,18000,25000,11,16006,1,0,0,0,0,2,0,0,0,0,0,0,0,"Revelosh - In Combat - Cast 'Chain Lightning' (Normal Dungeon)"), +(@ENTRY,0,2,0,2,0,100,3,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Revelosh - Between 0-15% Health - Flee For Assist (No Repeat) (Normal Dungeon)"); -- cgit v1.2.3 From ac02bad3fa87ed610709a0ce53a9aa1c9637b4cd Mon Sep 17 00:00:00 2001 From: Malcrom Date: Thu, 31 Jul 2014 00:37:58 -0230 Subject: DB/SAI: More SAI corrected to use CMC. All entries up to 7000 requiri… …ng caster movement control now using CMC MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- sql/updates/world/2014_07_31_00_world_sai.sql | 408 ++++++++++++++++++++++++++ 1 file changed, 408 insertions(+) create mode 100644 sql/updates/world/2014_07_31_00_world_sai.sql diff --git a/sql/updates/world/2014_07_31_00_world_sai.sql b/sql/updates/world/2014_07_31_00_world_sai.sql new file mode 100644 index 00000000000..d9bf9c4ab83 --- /dev/null +++ b/sql/updates/world/2014_07_31_00_world_sai.sql @@ -0,0 +1,408 @@ +-- Blackrock Sorcerer SAI +SET @ENTRY := 7026; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4500,11,20823,64,0,0,0,0,2,0,0,0,0,0,0,0,"Blackrock Sorcerer - In Combat CMC - Cast 'Fireball'"), +(@ENTRY,0,1,0,0,0,100,0,8500,19300,14700,19400,11,20827,1,0,0,0,0,2,0,0,0,0,0,0,0,"Blackrock Sorcerer - In Combat - Cast 'Flamestrike'"); + +-- Blackrock Warlock SAI +SET @ENTRY := 7028; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,3300,5200,11,20825,64,0,0,0,0,2,0,0,0,0,0,0,0,"Blackrock Warlock - In Combat CMC - Cast 'Shadow Bolt'"), +(@ENTRY,0,1,0,0,0,100,0,2600,7300,29100,31300,11,13338,33,0,0,0,0,5,0,0,0,0,0,0,0,"Blackrock Warlock - In Combat - Cast 'Curse of Tongues'"), +(@ENTRY,0,2,0,0,0,100,0,6200,8700,5100,11000,11,20826,33,0,0,0,0,2,0,0,0,0,0,0,0,"Blackrock Warlock - In Combat - Cast 'Immolate'"); + +-- Thaurissan Firewalker SAI +SET @ENTRY := 7037; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2400,4700,11,10452,64,0,0,0,0,2,0,0,0,0,0,0,0,"Thaurissan Firewalker - In Combat CMC - Cast 'Flame Buffet'"), +(@ENTRY,0,1,0,0,0,100,0,9100,12500,12300,15700,11,10733,1,0,0,0,0,2,0,0,0,0,0,0,0,"Thaurissan Firewalker - In Combat - Cast 'Flame Spray'"); + +-- Thaurissan Agent SAI +SET @ENTRY := 7038; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2200,3900,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Thaurissan Agent - In Combat CMC - Cast 'Shoot'"), +(@ENTRY,0,1,0,9,0,100,0,5,30,36300,50000,11,6685,0,0,0,0,0,2,0,0,0,0,0,0,0,"Thaurissan Agent - Within 5-30 Range - Cast 'Piercing Shot'"), +(@ENTRY,0,2,0,9,0,100,0,0,5,13300,24100,11,12540,0,0,0,0,0,2,0,0,0,0,0,0,0,"Thaurissan Agent - Within 0-5 Range - Cast 'Gouge'"); + +-- Black Wyrmkin SAI +SET @ENTRY := 7041; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4800,11,9053,64,0,0,0,0,2,0,0,0,0,0,0,0,"Black Wyrmkin - In Combat CMC - Cast 'Fireball'"), +(@ENTRY,0,1,0,2,0,100,0,0,50,30400,45900,11,11969,1,0,0,0,0,2,0,0,0,0,0,0,0,"Black Wyrmkin - Between 0-50% Health - Cast 'Fire Nova'"); + +-- Flamescale Wyrmkin SAI +SET @ENTRY := 7043; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2400,4700,11,9574,64,0,0,0,0,2,0,0,0,0,0,0,0,"Flamescale Wyrmkin - In Combat CMC - Cast 'Flame Buffet'"), +(@ENTRY,0,1,0,0,0,100,0,1000,5200,10800,15100,11,13341,1,0,0,0,0,2,0,0,0,0,0,0,0,"Flamescale Wyrmkin - In Combat - Cast 'Fire Blast'"); + +-- Black Broodling SAI +SET @ENTRY := 7047; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2800,3600,11,13375,64,0,0,0,0,2,0,0,0,0,0,0,0,"Black Broodling - In Combat CMC - Cast 'Fireball'"), +(@ENTRY,0,1,0,8,0,100,1,16007,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Black Broodling - On Spellhit 'Draco-Incarcinatrix 900' - Set Phase 1"), +(@ENTRY,0,2,0,6,1,100,1,0,0,0,0,11,16027,7,0,0,0,0,1,0,0,0,0,0,0,0,"Black Broodling - On Just Died - Cast 'Create Broodling Essence' (Phase 1)"); + +-- Scalding Broodling SAI +SET @ENTRY := 7048; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2800,3600,11,13375,64,0,0,0,0,2,0,0,0,0,0,0,0,"Scalding Broodling - In Combat CMC - Cast 'Fireball'"), +(@ENTRY,0,1,0,8,0,100,1,16007,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Scalding Broodling - On Spellhit 'Draco-Incarcinatrix 900' - Set Phase 1"), +(@ENTRY,0,2,0,6,1,100,1,0,0,0,0,11,16027,7,0,0,0,0,1,0,0,0,0,0,0,0,"Scalding Broodling - On Just Died - Cast 'Create Broodling Essence' (Phase 1)"); + +-- Flamescale Broodling SAI +SET @ENTRY := 7049; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2800,3600,11,13375,64,0,0,0,0,2,0,0,0,0,0,0,0,"Flamescale Broodling - In Combat CMC - Cast 'Fireball'"), +(@ENTRY,0,1,0,0,0,100,0,6700,12700,8200,13300,11,13342,1,0,0,0,0,2,0,0,0,0,0,0,0,"Flamescale Broodling - In Combat - Cast 'Fire Blast'"), +(@ENTRY,0,2,0,8,0,100,1,16007,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Flamescale Broodling - On Spellhit 'Draco-Incarcinatrix 900' - Set Phase 1"), +(@ENTRY,0,3,0,6,1,100,1,0,0,0,0,11,16027,7,0,0,0,0,1,0,0,0,0,0,0,0,"Flamescale Broodling - On Just Died - Cast 'Create Broodling Essence' (Phase 1)"); + +-- Condemned Cleric SAI +SET @ENTRY := 7070; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4800,11,25054,64,0,0,0,0,2,0,0,0,0,0,0,0,"Condemned Cleric - In Combat CMC - Cast 'Holy Smite'"), +(@ENTRY,0,1,0,74,0,100,0,0,40,18000,21000,11,15586,1,0,0,0,0,9,0,0,0,0,0,0,0,"Condemned Cleric - On Friendly Between 0-40% Health - Cast 'Heal'"); + +-- Writhing Mage SAI +SET @ENTRY := 7075; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,40,3400,4800,11,12675,64,0,0,0,0,2,0,0,0,0,0,0,0,"Writhing Mage - In Combat CMC - Cast 'Frostbolt'"), +(@ENTRY,0,1,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Writhing Mage - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Jaedenar Warlock SAI +SET @ENTRY := 7120; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,1,1000,1000,0,0,11,11939,0,0,0,0,0,1,0,0,0,0,0,0,0,"Jaedenar Warlock - Out of Combat - Cast 'Summon Imp' (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,0,0,2400,3800,11,9613,64,0,0,0,0,2,0,0,0,0,0,0,0,"Jaedenar Warlock - In Combat CMC - Cast 'Shadow Bolt'"), +(@ENTRY,0,2,0,2,0,100,1,0,30,0,0,11,8699,1,0,0,0,0,1,0,0,0,0,0,0,0,"Jaedenar Warlock - Between 0-30% Health - Cast 'Unholy Frenzy' (No Repeat)"), +(@ENTRY,0,3,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Jaedenar Warlock - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Deadwood Pathfinder SAI +SET @ENTRY := 7155; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2200,3800,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Deadwood Pathfinder - In Combat CMC - Cast 'Shoot'"), +(@ENTRY,0,1,0,9,0,100,0,5,30,6000,12000,11,6685,1,0,0,0,0,2,0,0,0,0,0,0,0,"Deadwood Pathfinder - Within 5-30 Range - Cast 'Piercing Shot'"), +(@ENTRY,0,2,0,0,0,100,0,5000,9000,125000,130000,11,13583,1,0,0,0,0,2,0,0,0,0,0,0,0,"Deadwood Pathfinder - In Combat - Cast 'Curse of the Deadwood'"); + +-- Sandfury Shadowhunter SAI +SET @ENTRY := 7246; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,0,0,2300,3900,11,15547,64,0,0,0,0,2,0,0,0,0,0,0,0,"Sandfury Shadowhunter - In Combat CMC - Cast 'Shoot' (Normal Dungeon)"), +(@ENTRY,0,1,0,0,0,100,2,7000,12000,18000,25000,11,11641,1,0,0,0,0,6,0,0,0,0,0,0,0,"Sandfury Shadowhunter - In Combat - Cast 'Hex' (Normal Dungeon)"), +(@ENTRY,0,2,0,2,0,100,3,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowforge Shadowhunter - Between 0-15% Health - Flee For Assist (No Repeat) (Normal Dungeon)"); + +-- Shadowforge Sharpshooter SAI +SET @ENTRY := 7290; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,0,0,2300,3900,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowforge Sharpshooter - In Combat CMC - Cast 'Shoot' (Normal Dungeon)"), +(@ENTRY,0,1,0,0,0,100,2,9000,13000,30000,36000,11,6685,1,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowforge Sharpshooter - In Combat - Cast 'Piercing Shot' (Normal Dungeon)"), +(@ENTRY,0,2,0,2,0,100,3,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowforge Sharpshooter - Between 0-15% Health - Flee For Assist (No Repeat) (Normal Dungeon)"); + +-- Withered Spearhide SAI +SET @ENTRY := 7332; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,0,0,2300,3900,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Withered Spearhide - In Combat CMC - Cast 'Shoot' (Phase 2) (Normal Dungeon)"), +(@ENTRY,0,1,2,2,0,100,2,0,30,120000,120000,11,8599,1,0,0,0,0,1,0,0,0,0,0,0,0,"Withered Spearhide - Between 0-30% Health - Cast 'Enrage' (Normal Dungeon)"), +(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Withered Spearhide - Between 0-30% Health - Say Line 0 (Normal Dungeon)"), +(@ENTRY,0,3,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Withered Spearhide - Between 0-15% Health - Flee For Assist (No Repeat) (Normal Dungeon)"); + +-- Death's Head Necromancer SAI +SET @ENTRY := 7337; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,3,1000,1000,0,0,11,12420,1,0,0,0,0,1,0,0,0,0,0,0,0,"Death's Head Necromancer - Out of Combat - Cast 'Summon Skeletal Servant' (Normal Dungeon)"), +(@ENTRY,0,1,0,4,0,100,3,0,0,0,0,11,11445,1,0,0,0,0,1,0,0,0,0,0,0,0,"Death's Head Necromancer - On Aggro - Cast 'Bone Armor' (No Repeat) (Normal Dungeon)"), +(@ENTRY,0,2,0,0,0,100,2,0,0,2400,3800,11,9613,64,0,0,0,0,2,0,0,0,0,0,0,0,"Death's Head Necromancer - In Combat CMC - Cast 'Shadow Bolt' (Normal Dungeon)"), +(@ENTRY,0,3,0,0,0,100,2,8000,15000,18000,25000,11,11443,1,0,0,0,0,2,0,0,0,0,0,0,0,"Death's Head Necromancer - In Combat - Cast 'Cripple' (Normal Dungeon)"), +(@ENTRY,0,4,0,2,0,100,3,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Death's Head Necromancer - Between 0-15% Health - Flee For Assist (No Repeat) (Normal Dungeon)"); + +-- Skeletal Shadowcaster SAI +SET @ENTRY := 7340; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,0,0,2400,3800,11,9613,64,0,0,0,0,2,0,0,0,0,0,0,0,"Skeletal Shadowcaster - In Combat CMC - Cast 'Shadow Bolt' (Normal Dungeon)"), +(@ENTRY,0,1,0,0,0,100,2,6000,10000,7000,14000,11,12248,33,0,0,0,0,5,0,0,0,0,0,0,0,"Skeletal Shadowcaster - In Combat - Cast 'Amplify Damage' (Normal Dungeon)"), +(@ENTRY,0,2,0,7,0,100,3,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Skeletal Shadowcaster - On Evade - Despawn Instant (No Repeat) (Normal Dungeon)"); + +-- Skeletal Frostweaver SAI +SET @ENTRY := 7341; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,0,0,2400,3800,11,9672,64,0,0,0,0,2,0,0,0,0,0,0,0,"Skeletal Frostweaver - In Combat CMC - Cast 'Frostbolt'"); + +-- Skeletal Summoner SAI +SET @ENTRY := 7342; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,0,0,2400,3800,11,9532,64,0,0,0,0,2,0,0,0,0,0,0,0,"Skeletal Summoner - In Combat CMC - Cast 'Lightning Bolt'"), +(@ENTRY,0,1,0,0,0,100,3,6000,10000,0,0,11,11980,1,0,0,0,0,2,0,0,0,0,0,0,0,"Skeletal Summoner - In Combat - Cast 'Curse of Weakness'"), +(@ENTRY,0,2,0,0,0,100,2,15000,20000,15000,20000,11,12258,1,0,0,0,0,1,0,0,0,0,0,0,0,"Skeletal Summoner - In Combat - Cast 'Summon Shadowcaster'"); + +-- Ragglesnout SAI +SET @ENTRY := 7354; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,0,0,2400,3800,11,12471,64,0,0,0,0,2,0,0,0,0,0,0,0,"Ragglesnout - In Combat CMC - Cast 'Shadow Bolt' (Normal Dungeon)"), +(@ENTRY,0,1,0,0,0,100,2,3000,5000,20000,25000,11,11639,1,0,0,0,0,5,0,0,0,0,0,0,0,"Ragglesnout - In Combat - Cast 'Shadow Word: Pain' (Normal Dungeon)"), +(@ENTRY,0,2,0,0,0,100,2,9000,13000,15000,20000,11,7645,1,0,0,0,0,6,0,0,0,0,0,0,0,"Ragglesnout - In Combat - Cast 'Dominate Mind' (Normal Dungeon)"), +(@ENTRY,0,3,0,74,0,100,2,0,40,12000,16000,11,12039,0,0,0,0,0,9,0,0,0,0,0,0,0,"Ragglesnout - On Friendly Between 0-40% Health - Cast 'Heal' (Normal Dungeon)"); + +-- Deadwind Warlock SAI +SET @ENTRY := 7372; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4800,11,20825,64,0,0,0,0,2,0,0,0,0,0,0,0,"Deadwind Warlock - In Combat CMC - Cast 'Shadow Bolt'"), +(@ENTRY,0,1,0,0,0,100,0,6000,8000,7000,15000,11,11980,33,0,0,0,0,2,0,0,0,0,0,0,0,"Deadwind Warlock - In Combat - Cast 'Curse of Weakness'"), +(@ENTRY,0,2,0,0,0,100,0,9000,11000,11000,18000,11,20787,33,0,0,0,0,5,0,0,0,0,0,0,0,"Deadwind Warlock - In Combat - Cast 'Immolate'"); + +-- Deadwind Ogre Mage SAI +SET @ENTRY := 7379; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,0,1000,1000,600000,600000,11,12550,33,0,0,0,0,1,0,0,0,0,0,0,0,"Deadwind Ogre Mage - Out of Combat - Cast 'Lightning Shield'"), +(@ENTRY,0,1,0,0,0,100,0,0,0,2800,4200,11,20824,64,0,0,0,0,2,0,0,0,0,0,0,0,"Deadwind Ogre Mage - In Combat CMC - Cast 'Lightning Bolt'"), +(@ENTRY,0,2,0,0,0,100,0,7000,9000,16000,20000,11,21049,1,0,0,0,0,2,0,0,0,0,0,0,0,"Deadwind Ogre Mage - In Combat - Cast 'Bloodlust'"), +(@ENTRY,0,3,0,2,0,100,0,0,30,30000,36000,11,6742,1,0,0,0,0,1,0,0,0,0,0,0,0,"Deadwind Ogre Mage - Between 0-30% Health - Cast 'Bloodlust'"); + +-- Oro Eyegouge SAI +SET @ENTRY := 7606; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,4,0,100,3,0,0,0,0,11,12741,0,0,0,0,0,2,0,0,0,0,0,0,0,"Oro Eyegouge - On Aggro - Cast 'Curse of Weakness' (No Repeat) (Normal Dungeon)"), +(@ENTRY,0,1,0,0,0,100,2,0,0,2400,3800,11,9613,64,0,0,0,0,2,0,0,0,0,0,0,0,"Oro Eyegouge - In Combat CMC - Cast 'Shadow Bolt' (Normal Dungeon)"), +(@ENTRY,0,2,0,0,0,80,2,5000,7000,23000,27000,11,11962,0,0,0,0,0,2,0,0,0,0,0,0,0,"Oro Eyegouge - In Combat - Cast 'Immolate' (Normal Dungeon)"), +(@ENTRY,0,3,0,0,0,80,2,8000,10000,15000,18250,11,11990,0,0,0,0,0,2,0,0,0,0,0,0,0,"Oro Eyegouge - In Combat - Cast 'Rain of Fire' (Normal Dungeon)"); + +-- Archmage Allistarj SAI +SET @ENTRY := 7666; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,0,1000,1000,1800000,1800000,11,12544,33,0,0,0,0,1,0,0,0,0,0,0,0,"Archmage Allistarj - Out of Combat - Cast 'Frost Armor'"), +(@ENTRY,0,1,0,0,0,100,0,0,0,3400,4800,11,12466,64,0,0,0,0,2,0,0,0,0,0,0,0,"Archmage Allistarj - In Combat CMC - Cast 'Fireball'"), +(@ENTRY,0,2,0,0,0,100,0,9000,12000,11000,14000,11,12737,1,0,0,0,0,2,0,0,0,0,0,0,0,"Archmage Allistarj - In Combat - Cast 'Frostbolt'"), +(@ENTRY,0,3,0,0,0,100,0,13000,16000,13000,16000,11,14145,1,0,0,0,0,5,0,0,0,0,0,0,0,"Archmage Allistarj - In Combat - Cast 'Fire Blast'"), +(@ENTRY,0,4,0,0,0,100,0,5000,7000,16000,20000,11,12738,1,0,0,0,0,2,0,0,0,0,0,0,0,"Archmage Allistarj - In Combat - Cast 'Amplify Damage'"), +(@ENTRY,0,5,0,0,0,100,0,7000,12000,20000,24000,11,13323,1,0,0,0,0,6,0,0,0,0,0,0,0,"Archmage Allistarj - In Combat - Cast 'Polymorph'"); + +-- Lady Sevine SAI +SET @ENTRY := 7667; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,0,1000,1000,1800000,1800000,11,12544,33,0,0,0,0,1,0,0,0,0,0,0,0,"Lady Sevine - Out of Combat - Cast 'Frost Armor'"), +(@ENTRY,0,1,0,0,0,100,0,0,0,3400,4800,11,12739,64,0,0,0,0,2,0,0,0,0,0,0,0,"Lady Sevine - In Combat CMC - Cast 'Shadow Bolt'"), +(@ENTRY,0,2,0,0,0,100,0,9000,12000,24000,27000,11,12742,1,0,0,0,0,5,0,0,0,0,0,0,0,"Lady Sevine - In Combat - Cast 'Immolate'"), +(@ENTRY,0,3,0,0,0,100,0,2000,5000,30000,45000,11,12741,1,0,0,0,0,2,0,0,0,0,0,0,0,"Lady Sevine - In Combat - Cast 'Curse of Weakness'"), +(@ENTRY,0,4,0,0,0,100,0,7000,9000,15000,25000,11,12740,1,0,0,0,0,1,0,0,0,0,0,0,0,"Lady Sevine - In Combat - Cast 'Summon Infernal Servant'"); + +-- Gnomeregan Evacuee SAI +SET @ENTRY := 7843; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,1,1000,1000,0,0,11,7165,1,0,0,0,0,1,0,0,0,0,0,0,0,"Gnomeregan Evacuee - Out of Combat - Cast 'Battle Stance'"), +(@ENTRY,0,1,0,0,0,100,0,0,0,2300,3900,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Gnomeregan Evacuee - In Combat CMC - Cast 'Shoot'"), +(@ENTRY,0,2,0,9,0,100,0,0,5,17000,23000,11,9080,1,0,0,0,0,2,0,0,0,0,0,0,0,"Gnomeregan Evacuee - Within 0-5 Range - Cast 'Hamstring'"), +(@ENTRY,0,3,0,0,0,100,0,7000,9000,13000,16000,11,25712,1,0,0,0,0,2,0,0,0,0,0,0,0,"Gnomeregan Evacuee - In Combat - Cast 'Heroic Strike'"), +(@ENTRY,0,4,0,2,0,100,0,0,30,30000,45000,11,2055,1,0,0,0,0,1,0,0,0,0,0,0,0,"Gnomeregan Evacuee - Between 0-30% Health - Cast 'Heal'"), +(@ENTRY,0,5,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gnomeregan Evacuee - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Southsea Freebooter SAI +SET @ENTRY := 7856; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2200,3800,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Southsea Freebooter - In Combat CMC - Cast 'Shoot' (Phase 1)"), +(@ENTRY,0,1,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Southsea Freebooter - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Death's Head Cultist SAI +SET @ENTRY := 7872; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2400,3800,11,9613,64,0,0,0,0,2,0,0,0,0,0,0,0,"Death's Head Cultist - In Combat CMC - Cast 'Shadow Bolt'"), +(@ENTRY,0,1,0,0,0,100,0,9000,12500,8000,13000,11,11433,0,0,0,0,0,2,0,0,0,0,0,0,0,"Death's Head Cultist - In Combat - Cast 'Death & Decay'"); + +-- Cyclok the Mad SAI +SET @ENTRY := 8202; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2400,3800,11,20829,64,0,0,0,0,2,0,0,0,0,0,0,0,"Cyclok the Mad - In Combat CMC - Cast 'Arcane Bolt'"), +(@ENTRY,0,1,0,0,0,100,0,7000,11000,15000,19000,11,11975,1,0,0,0,0,1,0,0,0,0,0,0,0,"Cyclok the Mad - In Combat - Cast 'Arcane Explosion'"), +(@ENTRY,0,2,0,2,0,100,1,0,30,0,0,11,6742,1,0,0,0,0,1,0,0,0,0,0,0,0,"Cyclok the Mad - Between 0-30% Health - Cast 'Bloodlust' (No Repeat)"); + +-- Mojo the Twisted SAI +SET @ENTRY := 8296; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4800,11,20825,64,0,0,0,0,2,0,0,0,0,0,0,0,"Mojo the Twisted - In Combat CMC - Cast 'Shadow Bolt'"), +(@ENTRY,0,1,0,9,0,100,0,0,30,9000,14000,11,17228,1,0,0,0,0,5,0,0,0,0,0,0,0,"Mojo the Twisted - Within 0-30 Range - Cast 'Shadow Bolt Volley'"); + +-- Akubar the Seer SAI +SET @ENTRY := 8298; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4800,11,20824,64,0,0,0,0,2,0,0,0,0,0,0,0,"Akubar the Seer - In Combat CMC - Cast 'Lightning Bolt'"), +(@ENTRY,0,1,0,9,0,100,0,0,30,13800,13800,11,20831,1,0,0,0,0,5,0,0,0,0,0,0,0,"Akubar the Seer - Within 0-30 Range - Cast 'Chain Lightning'"), +(@ENTRY,0,2,0,0,0,100,0,3000,5000,25700,31300,11,11436,1,0,0,0,0,5,0,0,0,0,0,0,0,"Akubar the Seer - In Combat - Cast 'Slow'"); + +-- Gibblewilt SAI +SET @ENTRY := 8503; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,4,0,80,1,0,0,0,0,1,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Gibblewilt - On Aggro - Say Line 0"), +(@ENTRY,0,1,0,0,0,100,0,0,0,0,1300,11,9532,64,0,0,0,0,2,0,0,0,0,0,0,0,"Gibblewilt - In Combat CMC - Cast 'Lightning Bolt'"), +(@ENTRY,0,2,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gibblewilt - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Blighted Surge SAI +SET @ENTRY := 8519; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2800,3800,11,16554,64,0,0,0,0,2,0,0,0,0,0,0,0,"Blighted Surge - In Combat CMC - Cast 'Toxic Bolt'"), +(@ENTRY,0,1,0,8,0,100,0,21332,0,0,0,36,13279,0,0,0,0,0,1,0,0,0,0,0,0,0,"Blighted Surge - On Spellhit 'Aspect of Neptulon' - Update Template To 'Discordant Surge'"); + +-- Cursed Mage SAI +SET @ENTRY := 8524; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4800,11,20829,64,0,0,0,0,2,0,0,0,0,0,0,0,"Cursed Mage - In Combat CMC - Cast 'Arcane Bolt'"), +(@ENTRY,0,1,0,6,0,100,1,0,0,0,0,11,16567,7,0,0,0,0,2,0,0,0,0,0,0,0,"Cursed Mage - On Just Died - Cast 'Tainted Mind'"); + +-- Dark Caster SAI +SET @ENTRY := 8526; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4800,11,20825,64,0,0,0,0,2,0,0,0,0,0,0,0,"Dark Caster - In Combat CMC - Cast 'Shadow Bolt'"), +(@ENTRY,0,1,0,0,0,100,0,11000,14000,22000,25000,11,20825,32,0,0,0,0,5,0,0,0,0,0,0,0,"Dark Caster - In Combat - Cast 'Shadow Bolt'"); + +-- Shadowmage SAI +SET @ENTRY := 8550; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,1,1000,1000,0,0,11,16592,33,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmage - Out of Combat - Cast 'Shadowform'"), +(@ENTRY,0,1,0,0,0,100,0,0,0,3400,4800,11,20825,64,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowmage - In Combat CMC - Cast 'Shadow Bolt'"), +(@ENTRY,0,2,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmage - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Dark Summoner SAI +SET @ENTRY := 8551; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4800,11,20829,64,0,0,0,0,2,0,0,0,0,0,0,0,"Dark Summoner - In Combat CMC - Cast 'Arcane Bolt'"), +(@ENTRY,0,1,0,0,0,100,0,4000,6000,15000,20000,11,16590,1,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Summoner - In Combat - Cast 'Summon Zombie'"), +(@ENTRY,0,2,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Summoner - Between 0-15% Health - Flee For Assist"); + +-- Mossflayer Shadowhunter SAI +SET @ENTRY := 8561; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Mossflayer Shadowhunter - In Combat CMC - Cast 'Shoot'"), +(@ENTRY,0,1,0,9,0,100,0,5,30,6000,9000,11,17171,0,0,0,0,0,2,0,0,0,0,0,0,0,"Mossflayer Shadowhunter - Within 5-30 Range - Cast 'Shadow Shot'"), +(@ENTRY,0,2,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mossflayer Shadowhunter - Between 0-15% Health - Flee For Assist"); + +-- Ranger SAI +SET @ENTRY := 8564; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Ranger - In Combat CMC - Cast 'Shoot'"), +(@ENTRY,0,1,0,9,0,100,0,5,30,7000,9000,11,14443,0,0,0,0,0,2,0,0,0,0,0,0,0,"Ranger - Within 5-30 Range - Cast 'Multi-Shot'"), +(@ENTRY,0,2,0,9,0,100,0,5,30,9000,11000,11,17174,0,0,0,0,0,2,0,0,0,0,0,0,0,"Ranger - Within 5-30 Range - Cast 'Concussive Shot'"), +(@ENTRY,0,3,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ranger - Between 0-15% Health - Flee For Assist"); + +-- Dark Iron Lookout SAI +SET @ENTRY := 8566; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,1200,2400,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Dark Iron Lookout - In Combat CMC - Cast 'Shoot'"), +(@ENTRY,0,1,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Lookout - Between 0-15% Health - Flee For Assist"); + +-- Hukku's Imp SAI +SET @ENTRY := 8658; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,0,0,180000,180000,11,11770,1,0,0,0,0,1,0,0,0,0,0,0,0,"Hukku's Imp - In Combat - Cast 'Fire Shield'"), +(@ENTRY,0,1,0,0,0,100,2,0,0,3100,4900,11,11762,64,0,0,0,0,2,0,0,0,0,0,0,0,"Hukku's Imp - In Combat CMC - Cast 'Firebolt' (Normal Dungeon)"); + +-- Sandfury Acolyte SAI +SET @ENTRY := 8876; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,0,0,2400,3800,11,9613,64,0,0,0,0,2,0,0,0,0,0,0,0,"Sandfury Acolyte - In Combat CMC - Cast 'Shadow Bolt' (Normal Dungeon)"), +(@ENTRY,0,1,0,0,0,100,2,8000,10000,25000,31000,11,11639,1,0,0,0,0,2,0,0,0,0,0,0,0,"Sandfury Acolyte - In Combat - Cast 'Shadow Word: Pain' (Normal Dungeon)"), +(@ENTRY,0,2,0,0,0,100,2,4000,6000,120000,135000,11,11980,1,0,0,0,0,2,0,0,0,0,0,0,0,"Sandfury Acolyte - In Combat - Cast 'Curse of Weakness' (Normal Dungeon)"), +(@ENTRY,0,3,0,0,0,100,2,5000,6000,15000,22000,11,11981,1,0,0,0,0,5,0,0,0,0,0,0,0,"Sandfury Acolyte - In Combat - Cast 'Mana Burn' (Normal Dungeon)"); + +-- Anvilrage Reservist SAI +SET @ENTRY := 8901; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,4,0,100,3,0,0,0,0,11,9128,1,0,0,0,0,1,0,0,0,0,0,0,0,"Anvilrage Reservist - On Aggro - Cast 'Battle Shout' (No Repeat) (Normal Dungeon)"), +(@ENTRY,0,1,0,0,0,100,2,0,0,2200,3800,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Anvilrage Reservist - In Combat CMC - Cast 'Shoot' (Normal Dungeon)"), +(@ENTRY,0,2,0,0,0,100,2,4000,6000,12000,15000,11,9080,1,0,0,0,0,2,0,0,0,0,0,0,0,"Anvilrage Reservist - In Combat - Cast 'Hamstring' (Normal Dungeon)"), +(@ENTRY,0,3,0,0,0,100,2,8000,11000,6000,9000,11,11976,0,0,0,0,0,2,0,0,0,0,0,0,0,"Anvilrage Reservist - In Combat - Cast 'Strike' (Normal Dungeon)"), +(@ENTRY,0,4,0,2,0,100,3,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anvilrage Reservist - Between 0-15% Health - Flee For Assist (No Repeat) (Normal Dungeon)"); + +-- Thauris Balgarr SAI +SET @ENTRY := 8978; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,5,9,0,100,0,0,0,21700,35200,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Thauris Balgarr - In Combat CMC - Cast 'Shoot'"), +(@ENTRY,0,1,0,0,0,100,0,7000,11000,21700,35200,11,6533,1,0,0,0,0,2,0,0,0,0,0,0,0,"Thauris Balgarr - In Combat - Cast 'Net'"), +(@ENTRY,0,2,0,0,0,100,0,1000,3000,19200,32700,11,11802,1,0,0,0,0,2,0,0,0,0,0,0,0,"Thauris Balgarr - In Combat - Cast 'Dark Iron Land Mine'"); -- cgit v1.2.3 From ba901590d678aee9a62f381d6e787f8d56232999 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Thu, 31 Jul 2014 09:38:55 +0100 Subject: DB/QUEST: Foolish Endeavors (Update) Update to my previous script for this, fixes a couple of things * Getry is less likely to bug out leaving him at bottom with no quest flags if player leaves grid after event started, can still happen but much rarer (This has had 7 months of testing) * And preventing event been started if varidus is currently dead as this will also cause event to bug out. --- sql/updates/world/2014_07_31_01_world_sai.sql | 126 ++++++++++++++++++++++++++ 1 file changed, 126 insertions(+) create mode 100644 sql/updates/world/2014_07_31_01_world_sai.sql diff --git a/sql/updates/world/2014_07_31_01_world_sai.sql b/sql/updates/world/2014_07_31_01_world_sai.sql new file mode 100644 index 00000000000..7e98b044548 --- /dev/null +++ b/sql/updates/world/2014_07_31_01_world_sai.sql @@ -0,0 +1,126 @@ + SET @QUEST := 11705; + SET @VARIDUS := 25618; + SET @PRISONER := 25624; + SET @ABERRATION := 25625; + SET @GETRY := 25729; + SET @NECROLORD := 25730; + SET @SAURFANG := 25751; + + DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@GETRY,@VARIDUS,@NECROLORD,@PRISONER,@ABERRATION) AND `source_type`=0; + DELETE FROM `smart_scripts` WHERE `entryorguid`=@VARIDUS*100 AND `source_type`=9; + INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES + (@VARIDUS,0,0,0,38,0,100,0,0,1,0,0,69,1,0,0,0,0,0,8,0,0,0,3119.973,6539.042,80.1591, 0, 'Varidus the Flenser - On data 0 1 set - Move to position'), + (@VARIDUS,0,1,2,34,0,100,0,0,1,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,4.031711, 'Varidus the Flenser - On movement inform - Set orientation'), + (@VARIDUS,0,2,3,61,0,100,0,0,0,0,0,1,11,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser - On movement inform - Say line'), + (@VARIDUS,0,3,0,61,0,100,0,0,0,0,0,89,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser - On movement inform - Stop Random movement'), + (@VARIDUS,0,4,0,38,0,100,0,0,2,0,0,1,0,3000,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser - On data 0 2 set - Say line'), + (@VARIDUS,0,5,0,52,0,100,0,0,@VARIDUS,0,0,66,0,0,0,0,0,0,12,1,0,0,0,0,0,0, 'Varidus the Flenser - On text 0 over - Turn to'), + (@VARIDUS,0,6,7,38,0,100,0,0,3,0,0,1,1,0,0,0,0,0,12,1,0,0,0,0,0,0, 'Varidus the Flenser - On data 0 3 set - Say line'), + (@VARIDUS,0,7,8,61,0,100,0,0,0,0,0,12,@NECROLORD,1,300000,0,0,0,8,0,0,0,3137.506,6532.551,80.40143,2.280419, 'Varidus the Flenser - On data 0 3 set - Summon En''kilah Necrolord'), + (@VARIDUS,0,8,0,61,0,100,0,0,0,0,0,100,1,0,0,0,0,0,19,@NECROLORD,50,0,0,0,0,0, 'Varidus the Flenser - On data 0 3 set - Send targetlist'), + (@VARIDUS,0,9,0,38,0,100,0,0,4,0,0,80,@VARIDUS*100,2,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser - On data 0 4 set - Run script'), + (@VARIDUS,0,10,11,52,0,100,0,10,@VARIDUS,0,0,19,768,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser - On text 10 over - Remove unit_flags IMMUNE_TO_PC, IMMUNE_TO_NPC'), + (@VARIDUS,0,11,0,61,0,100,0,0,0,0,0,28,45908,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser - On text 10 over - Remove aura Shield of Suffering'), + (@VARIDUS,0,12,0,9,0,100,0,0,10,5000,8000,11,32711,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser - On target within 10y - Spellcast Shadow Nova'), + (@VARIDUS,0,13,0,0,0,100,0,10000,12000,10000,15000,11,50329,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser - On update IC - Spellcast Shied of Suffering'), + (@VARIDUS,0,14,15,6,0,100,0,0,0,0,0,45,1,3,0,0,0,0,19,@GETRY,100,0,0,0,0,0, 'Varidus the Flenser - On death - Set data 1 3 Shadowstalker Getry'), + (@VARIDUS,0,15,0,61,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser - On death - Despawn'), + (@VARIDUS,0,16,17,11,0,100,0,0,0,0,0,89,10,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser - On spawn - Random movement'), + (@VARIDUS,0,17,0,61,0,100,0,0,0,0,0,18,768,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser - On spawn - Set Unit Flags'), + (@VARIDUS,0,18,19,38,0,100,0,2,2,0,0,18,768,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser - On data 2 2 set - Set unit flags'), + (@VARIDUS,0,19,20,61,0,100,0,0,0,0,0,78,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser - On data 2 2 set - Reset all scripts'), + (@VARIDUS,0,20,0,61,0,100,0,0,0,0,0,24,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser - On data 2 2 set - Evade'), + + (@PRISONER,0,0,1,6,0,100,0,0,0,0,0,11,45802,2,0,0,0,0,1,0,0,0,0,0,0,0, 'Infested Prisoner - On death - Spellcast Summoned Aberration'), + (@PRISONER,0,1,0,61,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Infested Prisoner - On death - Despawn'), + + (@ABERRATION,0,0,1,11,0,100,0,0,0,0,0,53,0,@ABERRATION,0,0,0,0,1,0,0,0,0,0,0,0, 'Warsong Aberration - On spawn - Start WP movement'), + (@ABERRATION,0,1,0,61,0,100,0,0,0,0,0,8,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Warsong Aberration - On spawn - Set reaction aggressive'), + (@ABERRATION,0,2,0,9,0,100,0,0,5,990,3000,11,50306,2,0,0,0,0,7,0,0,0,0,0,0,0, 'Warsong Aberration - On target within 5y - Spellcast Thrash Kick'), + + (@GETRY,0,0,1,19,0,100,0,@QUEST,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Shadowstalker Getry - On quest accept - Store targetlist'), + (@GETRY,0,1,2,61,0,100,0,0,0,0,0,81,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Shadowstalker Getry - On quest accept - Remove npcflag questgiver'), + (@GETRY,0,2,3,61,0,100,0,0,0,0,0,1,0,3000,0,0,0,0,1,0,0,0,0,0,0,0, 'Shadowstalker Getry - On quest accept - Say line'), + (@GETRY,0,3,4,61,0,100,0,0,0,0,0,11,45924,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Shadowstalker Getry - On quest accept - Spellcast On Getry''s Quest'), + (@GETRY,0,4,5,61,0,100,0,0,0,0,0,11,45924,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Shadowstalker Getry - On quest accept - Spellcast On Getry''s Quest'), + (@GETRY,0,5,0,61,0,100,0,0,0,0,0,45,0,1,0,0,0,0,19,@VARIDUS,50,0,0,0,0,0, 'Shadowstalker Getry - On quest accept - Set data 0 1 Varidus the Flenser'), + (@GETRY,0,6,7,52,0,100,0,0,@GETRY,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Shadowstalker Getry - On text 0 over - Say line'), + (@GETRY,0,7,0,61,0,100,0,0,0,0,0,53,0,@GETRY,0,0,0,0,1,0,0,0,0,0,0,0, 'Shadowstalker Getry - On text 0 over - Start WP'), + (@GETRY,0,8,0,11,0,100,0,0,0,0,0,81,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Shadowstalker Getry - On spawn - Set npcflag questgiver'), + (@GETRY,0,9,0,40,0,100,0,8,@GETRY,0,0,11,34189,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Shadowstalker Getry - On WP8 reached - Spellcast Stealth'), + (@GETRY,0,10,11,40,0,100,0,9,@GETRY,0,0,45,0,2,0,0,0,0,19,@VARIDUS,30,0,0,0,0,0, 'Shadowstalker Getry - On WP 9 reached - Set data 0 2 Varidus the Flenser'), + (@GETRY,0,11,0,61,0,100,0,0,0,0,0,100,1,0,0,0,0,0,19,@VARIDUS,30,0,0,0,0,0, 'Shadowstalker Getry - On WP10 reached - Send targetlist to Varidus the Flenser'), + (@GETRY,0,12,13,40,0,100,0,10,@GETRY,0,0,66,0,0,0,0,0,0,19,@VARIDUS,20,0,0,0,0,0, 'Shadowstalker Getry - On WP10 reached - Turn to'), + (@GETRY,0,13,14,61,0,100,0,0,0,0,0,101,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Shadowstalker Getry - On WP10 reached - Set home position'), + (@GETRY,0,14,15,61,0,100,0,0,0,0,0,28,34189,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Shadowstalker Getry - On WP10 reached - Remove aura Stealth'), + (@GETRY,0,15,16,61,0,100,0,0,0,0,0,11,45922,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Shadowstalker Getry - On WP10 reached - Spellcast Shadow Prison'), + (@GETRY,0,16,17,61,0,100,0,0,0,0,0,86,45922,0,12,1,0,0,12,1,0,0,0,0,0,0, 'Shadowstalker Getry - On WP10 reached - Crosscast Shadow Prison'), + (@GETRY,0,17,0,61,0,100,0,0,0,0,0,45,0,3,0,0,0,0,19,@VARIDUS,20,0,0,0,0,0, 'Shadowstalker Getry - On WP10 reached - Set Data 0 3 Varidus the Flenser'), + (@GETRY,0,18,19,38,0,100,0,1,1,0,0,19,768,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Shadowstalker Getry - On data 1 1 set - Remove unit_flags IMMUNE_TO_PC, IMMUNE_TO_NPC'), + (@GETRY,0,19,0,61,0,100,0,0,0,0,0,49,0,0,0,0,0,0,19,@VARIDUS,20,0,0,0,0,0, 'Shadowstalker Getry - On data 1 1 set - Start attack'), + (@GETRY,0,20,21,38,0,100,0,1,3,0,0,15,@QUEST,0,0,0,0,0,12,1,0,0,0,0,0,0, 'Shadowstalker Getry - On data 1 3 set - Quest credit'), + (@GETRY,0,21,0,61,0,100,0,0,0,0,0,1,2,5000,0,0,0,0,1,0,0,0,0,0,0,0, 'Shadowstalker Getry - On data 1 3 set - Say line'), + (@GETRY,0,22,0,52,0,100,0,2,@GETRY,0,0,1,3,5000,0,0,0,0,1,0,0,0,0,0,0,0, 'Shadowstalker Getry - On text 2 over - Say line'), + (@GETRY,0,23,0,52,0,100,0,3,@GETRY,0,0,45,1,2,0,0,0,0,19,@SAURFANG,20,0,0,0,0,0, 'Shadowstalker Getry - On text 3 over - Set data 1 2 High Overlord Saurfang'), + (@GETRY,0,24,0,38,0,100,0,1,4,0,0,53,0,@GETRY*100,0,0,0,0,1,0,0,0,0,0,0,0, 'Shadowstalker Getry - On data 1 4 set - Start WP movement'), + (@GETRY,0,26,27,40,0,100,0,10,@GETRY*100,0,0,81,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Shadowstalker Getry - On WP10 reached (Return) - Set npcflag questgiver'), + (@GETRY,0,27,28,61,0,100,0,0,0,0,0,18,768,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Shadowstalker Getry - On WP10 reached (Return) - Set unit_flags IMMUNE_TO_PC, IMMUNE_TO_NPC'), + (@GETRY,0,28,0,61,0,100,0,0,0,0,0,101,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Shadowstalker Getry - On WP10 reached (Return) - Set homeposition'), + (@GETRY,0,29,30,8,0,100,0,45950,0,0,0,28,45922,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Shadowstalker Getry - On spellhit Saurfangs Rage - Remove aura Shadow Prison'), + (@GETRY,0,30,0,61,0,100,0,0,0,0,0,28,45922,0,0,0,0,0,12,1,0,0,0,0,0,0, 'Shadowstalker Getry - On spellhit Saurfangs Rage - Remove aura Shadow Prison'), + (@GETRY,0,31,32,6,0,100,0,0,0,0,0,6,@QUEST,0,0,0,0,0,12,1,0,0,0,0,0,0, 'Shadowstalker Getry - On Death - Fail Quest'), + (@GETRY,0,32,33,61,0,100,0,0,0,0,0,45,2,2,0,0,0,0,19,@VARIDUS,0,0,0,0,0,0, 'Shadowstalker Getry - On Death - Set Data 2 2 Varidus'), + (@GETRY,0,33,34,61,0,100,0,0,0,0,0,45,2,2,0,0,0,0,19,@NECROLORD,0,0,0,0,0,0, 'Shadowstalker Getry - On Death - Set Data 2 2 Varidus'), + (@GETRY,0,34,0,61,0,100,0,0,0,0,0,45,2,2,0,0,0,0,19,@SAURFANG,0,0,0,0,0,0, 'Shadowstalker Getry - On Death - Set Data 2 2 Varidus'), + + (@NECROLORD,0,0,0,11,0,100,0,0,0,0,0,53,0,@NECROLORD,0,0,0,0,1,0,0,0,0,0,0,0, 'En''kilah Necrolord - On spawn - Start WP movement'), + (@NECROLORD,0,1,2,40,0,100,0,2,@NECROLORD,0,0,101,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'En''kilah Necrolord - On reached WP1 - Set home position'), + (@NECROLORD,0,2,0,61,0,100,0,0,0,0,0,45,0,4,0,0,0,0,19,@VARIDUS,10,0,0,0,0,0, 'En''kilah Necrolord - On reached WP1 - Set data 0 4 Varidus the Flenser'), + (@NECROLORD,0,3,4,38,0,100,0,0,1,0,0,66,0,0,0,0,0,0,19,@VARIDUS,10,0,0,0,0,0, 'En''kilah Necrolord - On data 0 1 set - Turn to'), + (@NECROLORD,0,4,0,61,0,100,0,0,0,0,0,36,@SAURFANG,0,0,0,0,0,1,0,0,0,0,0,0,0, 'En''kilah Necrolord - On data 0 1 set - Change entry to High Overlord Saurfang'), + (@NECROLORD,0,5,0,38,0,100,0,0,2,0,0,1,0,2500,0,0,0,0,12,1,0,0,0,0,0,0, 'High Overlord Saurfang - On data 0 2 set - Say line'), + (@NECROLORD,0,6,0,52,0,100,0,0,@SAURFANG,0,0,66,0,0,0,0,0,0,12,1,0,0,0,0,0,0, 'High Overlord Saurfang - On text 0 over - Turn to'), + (@NECROLORD,0,7,0,38,0,100,0,0,3,0,0,1,1,4000,0,0,0,0,12,1,0,0,0,0,0,0, 'High Overlord Saurfang - On data 0 3 set - Say line'), + (@NECROLORD,0,8,0,52,0,100,0,1,@SAURFANG,0,0,66,0,0,0,0,0,0,19,@VARIDUS,10,0,0,0,0,0, 'High Overlord Saurfang - On text 1 over - Turn to'), + (@NECROLORD,0,9,0,38,0,100,0,0,4,0,0,1,2,5000,0,0,0,0,1,0,0,0,0,0,0,0, 'High Overlord Saurfang - On data 0 4 set - Say line'), + (@NECROLORD,0,10,0,52,0,100,0,2,@SAURFANG,0,0,1,3,12000,0,0,0,0,1,0,0,0,0,0,0,0, 'High Overlord Saurfang - On text 2 over - Say line'), + (@NECROLORD,0,11,0,52,0,100,0,3,@SAURFANG,0,0,1,4,0,0,0,0,0,1,0,0,0,0,0,0,0, 'High Overlord Saurfang - On text 3 over - Say line'), + (@NECROLORD,0,13,14,38,0,100,0,1,1,0,0,19,256,0,0,0,0,0,1,0,0,0,0,0,0,0, 'High Overlord Saurfang - On data 1 1 set - Remove unit_flags IMMUNE_TO_NPC'), + (@NECROLORD,0,14,15,61,0,100,0,0,0,0,0,11,45950,0,0,0,0,0,1,0,0,0,0,0,0,0, 'High Overlord Saurfang - On data 1 1 set - Spellcast Saurfang''s Rage'), + (@NECROLORD,0,15,0,61,0,100,0,0,0,0,0,1,5,1000,0,0,0,0,1,0,0,0,0,0,0,0, 'High Overlord Saurfang - On data 1 1 set - Say line'), + (@NECROLORD,0,16,0,52,0,100,0,5,@SAURFANG,0,0,1,6,1000,0,0,0,0,1,0,0,0,0,0,0,0, 'High Overlord Saurfang - On text 5 over - Say line'), + (@NECROLORD,0,17,0,61,0,100,0,0,0,0,0,41,3000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'High Overlord Saurfang - On text 7 over - Despawn after 3 seconds'), + (@NECROLORD,0,18,0,9,0,100,0,0,5,20000,25000,11,41097,0,0,0,0,0,1,0,0,0,0,0,0,0, 'High Overlord Saurfang - On target within 5y - Spellcast Whirlwind'), + (@NECROLORD,0,19,0,0,0,100,0,3000,7000,3000,8000,11,16044,0,0,0,0,0,1,0,0,0,0,0,0,0, 'High Overlord Saurfang - On update IC - Spellcast Cleave'), + (@NECROLORD,0,20,0,0,0,100,0,2000,7000,5000,7000,11,24573,0,0,0,0,0,2,0,0,0,0,0,0,0, 'High Overlord Saurfang - On update IC - Spellcast Mortal Strike'), + (@NECROLORD,0,21,0,9,0,100,0,8,25,5000,5000,11,15749,0,0,0,0,0,2,0,0,0,0,0,0,0, 'High Overlord Saurfang - On target within 8-25y - Spellcast Shield Charge'), + (@NECROLORD,0,22,0,38,0,100,0,0,5,0,0,66,0,0,0,0,0,0,12,1,0,0,0,0,0,0, 'High Overlord Saurfang - On data 0 5 set - Turn to'), + (@NECROLORD,0,23,0,38,0,100,0,1,2,0,0,1,7,3000,0,0,0,0,1,0,0,0,0,0,0,0, 'High Overlord Saurfang - On data 1 2 set - Say line'), + (@NECROLORD,0,24,17,52,0,100,0,7,@SAURFANG,0,0,45,1,4,0,0,0,0,19,@GETRY,20,0,0,0,0,0, 'High Overlord Saurfang - On text 7 over - Set data 1 4 Shadowstalker Getry'), + (@NECROLORD,0,25,0,38,0,100,0,2,2,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'High Overlord Saurfang - On data 2 2 set - Despawn'), + + (@VARIDUS*100,9,0,0,0,0,100,0,0,0,0,0,45,0,5,0,0,0,0,19,@NECROLORD,10,0,0,0,0,0, 'Varidus the Flenser script - Set data 0 5 En''kilah Necrolord'), + (@VARIDUS*100,9,1,0,0,0,100,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser script - Say line'), + (@VARIDUS*100,9,2,0,0,0,100,0,5000,5000,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser script - Say line'), + (@VARIDUS*100,9,3,0,0,0,100,0,3000,3000,0,0,1,4,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser script - Say line'), + (@VARIDUS*100,9,4,0,0,0,100,0,4000,4000,0,0,1,5,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser script - Say line'), + (@VARIDUS*100,9,5,0,0,0,100,0,6000,6000,0,0,66,0,0,0,0,0,0,19,@NECROLORD,10,0,0,0,0,0, 'Varidus the Flenser script - Turn to'), + (@VARIDUS*100,9,6,0,0,0,100,0,1000,1000,0,0,1,6,0,0,0,0,0,12,1,0,0,0,0,0,0, 'Varidus the Flenser script - Say line'), + (@VARIDUS*100,9,7,0,0,0,100,0,6000,6000,0,0,45,0,1,0,0,0,0,19,@NECROLORD,10,0,0,0,0,0, 'Varidus the Flenser script - Set data 0 1 En''kilah Necrolord'), + (@VARIDUS*100,9,8,0,0,0,100,0,1000,1000,0,0,45,0,2,0,0,0,0,19,@SAURFANG,10,0,0,0,0,0, 'Varidus the Flenser script - Set data 0 2 High Overlord Saurfang'), + (@VARIDUS*100,9,9,0,0,0,100,0,1500,1500,0,0,1,7,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser script - Say line'), + (@VARIDUS*100,9,10,0,0,0,100,0,2000,2000,0,0,45,0,3,0,0,0,0,19,@SAURFANG,10,0,0,0,0,0, 'Varidus the Flenser script - Set data 0 3 High Overlord Saurfang'), + (@VARIDUS*100,9,11,0,0,0,100,0,5000,5000,0,0,45,0,4,0,0,0,0,19,@SAURFANG,10,0,0,0,0,0, 'Varidus the Flenser script - Set data 0 4 High Overlord Saurfang'), + (@VARIDUS*100,9,12,0,0,0,100,0,13000,13000,0,0,1,8,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser script - Say line'), + (@VARIDUS*100,9,13,0,0,0,100,0,10000,10000,0,0,1,9,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser script - Say line'), + (@VARIDUS*100,9,14,0,0,0,100,0,2000,2000,0,0,1,10,2000,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser - On text 9 over - Say line'), + (@VARIDUS*100,9,15,0,0,0,100,0,0,0,0,0,11,45949,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Varidus the Flenser script - Spellcast Release Aberration'), + (@VARIDUS*100,9,16,0,0,0,100,0,0,0,0,0,45,1,1,0,0,0,0,19,@GETRY,20,0,0,0,0,0, 'Varidus the Flenser script - Set data 1 1 Shadowstalker Getry'), + (@VARIDUS*100,9,17,0,0,0,100,0,0,0,0,0,45,1,1,0,0,0,0,19,@SAURFANG,20,0,0,0,0,0, 'Varidus the Flenser script - Set data 1 1 Saurfang'); + + DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN(19,20) AND `SourceEntry`=11705; + INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES + (19,0,11705,0,0,29,0,25618,200,0,0,0,0,'','Foolish Endeavors can only be taken if Varidus is near'), + (19,0,11705,0,0,36,0,0,0,0,0,0,0,'','Foolish Endeavors can only be taken if Varidus is alive'), + (20,0,11705,0,0,29,0,25618,200,0,0,0,0,'','Foolish Endeavors can only be taken if Varidus is near'), + (20,0,11705,0,0,36,0,0,0,0,0,0,0,'','Foolish Endeavors can only be taken if Varidus is alive'); -- cgit v1.2.3 From 3f8c1000c6044daa2cf1aae8bfe33634d0d2e5e4 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Thu, 31 Jul 2014 09:50:14 +0100 Subject: DB/SAI: Sholazar Guardians (Update) Update my previous scripts for Zepik, Dajik, Moodle, Jaloot, Lafoo and Goregek as the spells which that these must cast in order to ping treasure, chickens abd the sholazar guardian heartbeat aura which was needed to trigger some texts was failing when just casting on summon, changing so these spells are cast periodically. --- sql/updates/world/2014_07_31_02_world_sai.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2014_07_31_02_world_sai.sql diff --git a/sql/updates/world/2014_07_31_02_world_sai.sql b/sql/updates/world/2014_07_31_02_world_sai.sql new file mode 100644 index 00000000000..7decba90d28 --- /dev/null +++ b/sql/updates/world/2014_07_31_02_world_sai.sql @@ -0,0 +1,5 @@ +UPDATE `smart_scripts` SET `event_type`=1, `event_param1`=3000, `event_param2`=3000, `event_param3`=3000, `event_param4`=3000 WHERE `entryorguid` IN(28120,28121,28122) AND `source_type`=0 AND `id` IN(2,3); +UPDATE `smart_scripts` SET `event_type`=1, `event_param1`=3000, `event_param2`=3000, `event_param3`=3000, `event_param4`=3000 WHERE `entryorguid` IN(28216) AND `source_type`=0 AND `id` IN(11,12); +UPDATE `smart_scripts` SET `event_type`=1, `event_param1`=3000, `event_param2`=3000, `event_param3`=3000, `event_param4`=3000 WHERE `entryorguid` IN(28214) AND `source_type`=0 AND `id` IN(9,10); +UPDATE `smart_scripts` SET `event_type`=1, `event_param1`=3000, `event_param2`=3000, `event_param3`=3000, `event_param4`=3000 WHERE `entryorguid` IN(28215) AND `source_type`=0 AND `id` IN(10,11); +UPDATE `smart_scripts` SET `event_type`=1, `event_param1`=3000, `event_param2`=3000, `event_param3`=3000, `event_param4`=3000 WHERE `entryorguid` IN(28121) AND `source_type`=0 AND `id` IN(14); -- cgit v1.2.3 From 95dfbced0bf6065a01e3a833fa6c7b3330526a79 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Thu, 31 Jul 2014 11:22:13 +0100 Subject: DB/SAI: Plagued Lands 2118 Fix 2118 Plagued Lands http://www.wowhead.com/quest=2118/plagued-lands http://youtu.be/wj8CiZAaP8E, Script in SAI, Kill credit and way bear gets captured may need to be changed in the future but at this moment the server side spells have no effects in spell_dbc. Id Name 9372 Bear Enters Auberdine 9439 Bear Captured in Trap, --- sql/updates/world/2014_07_31_03_world_sai.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 sql/updates/world/2014_07_31_03_world_sai.sql diff --git a/sql/updates/world/2014_07_31_03_world_sai.sql b/sql/updates/world/2014_07_31_03_world_sai.sql new file mode 100644 index 00000000000..08efa81d98f --- /dev/null +++ b/sql/updates/world/2014_07_31_03_world_sai.sql @@ -0,0 +1,17 @@ +UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI',`ScriptName`='' WHERE `entry`=111148; +DELETE FROM `smart_scripts` WHERE `source_type`=1 AND `entryorguid`=111148; + +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(111148,1,1,0,1,0,100,0,0,0,1000,1000,45,1,1,0,0,0,0,19,2164,5,0,0,0,0,0, 'Night Elven Bear Trap - OOC - Set Data closest Rabid Thistle Bear '); + +DELETE FROM `smart_scripts` WHERE `entryorguid`=2164 AND `source_type`=0 AND `id`>0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=216400 AND `source_type`=9; + +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(2164, 0, 1, 0, 38, 0, 100, 1, 1, 1, 0, 0, 80, 216400, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rabid Thistle Bear - On Data Set - Run Script (No repeat)'), +(2164, 0, 2, 0, 4, 0, 100, 0, 0, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Rabid Thistle Bear - On Agro store targetlist'), +(216400, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rabid Thistle Bear - Script - Evade'), +(216400, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 33, 11836, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Rabid Thistle Bear - Script - Kill Credit'), +(216400, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 29, 0, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Rabid Thistle Bear - Script - Follow Target'), +(216400, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 36, 11836, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rabid Thistle Bear - Script - Change Entry to Captured Rabid Thistle Bear'), +(216400, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 41, 120000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rabid Thistle Bear - Script - Follow Target'); -- cgit v1.2.3 From 5e825ce9d48ff02a965919adc4f891defb579c19 Mon Sep 17 00:00:00 2001 From: Malcrom Date: Thu, 31 Jul 2014 11:12:12 -0230 Subject: DB/Waypoints: A few paths for Shadowmoon Valley --- .../world/2014_07_31_04_world_waypoints.sql | 135 +++++++++++++++++++++ 1 file changed, 135 insertions(+) create mode 100644 sql/updates/world/2014_07_31_04_world_waypoints.sql diff --git a/sql/updates/world/2014_07_31_04_world_waypoints.sql b/sql/updates/world/2014_07_31_04_world_waypoints.sql new file mode 100644 index 00000000000..fef69271978 --- /dev/null +++ b/sql/updates/world/2014_07_31_04_world_waypoints.sql @@ -0,0 +1,135 @@ +-- Misc fixes Shadowmoon Vally +UPDATE `waypoint_data` SET `move_type`=1 WHERE `id` BETWEEN 755410 AND 755580; +UPDATE `waypoint_data` SET `move_type`=1 WHERE `id` IN (861030,756540); +UPDATE `creature` SET `spawndist`=0,`MovementType`=0 WHERE `id`=20431; +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=20431; + +-- Pathing for Eclipsion Bloodwarder Entry: 19806 +SET @NPC := 70924; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4360.784,`position_y`=1629.075,`position_z`=155.2385 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,20937, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-4360.784,1629.075,155.2385,0,0,0,0,100,0), +(@PATH,2,-4353.151,1625.602,154.0825,0,0,0,0,100,0), +(@PATH,3,-4340.475,1615.389,150.8357,0,0,0,0,100,0), +(@PATH,4,-4325.918,1602.077,146.8105,0,0,0,0,100,0), +(@PATH,5,-4320.001,1595.513,145.2775,0,0,0,0,100,0), +(@PATH,6,-4294.648,1561.691,139.0124,0,0,0,0,100,0), +(@PATH,7,-4284.038,1547.906,136.9253,0,0,0,0,100,0), +(@PATH,8,-4279.678,1538.484,135.8952,0,0,0,0,100,0), +(@PATH,9,-4270.082,1526.787,133.6908,0,0,0,0,100,0), +(@PATH,10,-4279.678,1538.484,135.8952,0,0,0,0,100,0), +(@PATH,11,-4284.038,1547.906,136.9253,0,0,0,0,100,0), +(@PATH,12,-4294.648,1561.691,139.0124,0,0,0,0,100,0), +(@PATH,13,-4320.001,1595.513,145.2775,0,0,0,0,100,0), +(@PATH,14,-4325.918,1602.077,146.8105,0,0,0,0,100,0), +(@PATH,15,-4340.475,1615.389,150.8357,0,0,0,0,100,0), +(@PATH,16,-4353.151,1625.602,154.0825,0,0,0,0,100,0); + +-- Pathing for Eclipsion Bloodwarder Entry: 19806 +SET @NPC := 70923; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4217.18,`position_y`=1521.898,`position_z`=121.213 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,20937, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-4217.18,1521.898,121.213,0,0,0,0,100,0), +(@PATH,2,-4229.042,1525.221,124.0835,0,0,0,0,100,0), +(@PATH,3,-4240.368,1525.119,126.9637,0,0,0,0,100,0), +(@PATH,4,-4251.378,1522.142,129.3019,0,0,0,0,100,0), +(@PATH,5,-4259.183,1521.705,131.0701,0,0,0,0,100,0), +(@PATH,6,-4265.086,1523.241,132.4467,0,0,0,0,100,0), +(@PATH,7,-4259.285,1521.729,130.9489,0,0,0,0,100,0), +(@PATH,8,-4251.378,1522.142,129.3019,0,0,0,0,100,0), +(@PATH,9,-4240.368,1525.119,126.9637,0,0,0,0,100,0), +(@PATH,10,-4229.367,1525.216,124.1498,0,0,0,0,100,0), +(@PATH,11,-4217.18,1521.898,121.213,0,0,0,0,100,0), +(@PATH,12,-4208.12,1518.035,119.0382,0,0,0,0,100,0), +(@PATH,13,-4186.46,1515.448,114.3116,0,0,0,0,100,0), +(@PATH,14,-4179.203,1518.327,112.6954,0,0,0,0,100,0), +(@PATH,15,-4173.099,1522.57,111.3765,0,0,0,0,100,0), +(@PATH,16,-4163.668,1521.306,109.0289,0,0,0,0,100,0), +(@PATH,17,-4145.619,1515.821,104.8259,0,0,0,0,100,0), +(@PATH,18,-4133.985,1513.434,101.7857,0,0,0,0,100,0), +(@PATH,19,-4121.424,1515.415,99.44949,0,0,0,0,100,0), +(@PATH,20,-4113.421,1518.041,98.23904,0,0,0,0,100,0), +(@PATH,21,-4121.424,1515.415,99.44949,0,0,0,0,100,0), +(@PATH,22,-4133.985,1513.434,101.7857,0,0,0,0,100,0), +(@PATH,23,-4145.619,1515.821,104.8259,0,0,0,0,100,0), +(@PATH,24,-4163.668,1521.306,109.0289,0,0,0,0,100,0), +(@PATH,25,-4173.099,1522.57,111.3765,0,0,0,0,100,0), +(@PATH,26,-4179.203,1518.327,112.6954,0,0,0,0,100,0), +(@PATH,27,-4186.46,1515.448,114.3116,0,0,0,0,100,0), +(@PATH,28,-4208.12,1518.035,119.0382,0,0,0,0,100,0); + +-- Pathing for Eclipsion Centurion Entry: 19792 +SET @NPC := 70813; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4172.616,`position_y`=1491.763,`position_z`=115.0119 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-4172.616,1491.763,115.0119,0,0,0,0,100,0), +(@PATH,2,-4137.529,1488.114,107.3583,0,0,0,0,100,0), +(@PATH,3,-4101.359,1478.424,98.54732,0,0,0,0,100,0), +(@PATH,4,-4137.529,1488.114,107.3583,0,0,0,0,100,0), +(@PATH,5,-4172.616,1491.763,115.0119,0,0,0,0,100,0), +(@PATH,6,-4203.639,1494.258,121.3947,0,0,0,0,100,0); + +-- Pathing for Eclipsion Centurion Entry: 19792 +SET @NPC := 70819; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4215.104,`position_y`=1564.346,`position_z`=118.4787 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-4215.104,1564.346,118.4787,0,0,0,0,100,0), +(@PATH,2,-4180.447,1555.489,110.1809,0,0,0,0,100,0), +(@PATH,3,-4156.682,1546.285,106.5436,0,0,0,0,100,0), +(@PATH,4,-4126.055,1537.171,99.63662,0,0,0,0,100,0), +(@PATH,5,-4089.762,1532.374,93.84246,0,0,0,0,100,0), +(@PATH,6,-4126.055,1537.171,99.63662,0,0,0,0,100,0), +(@PATH,7,-4156.682,1546.285,106.5436,0,0,0,0,100,0), +(@PATH,8,-4180.447,1555.489,110.1809,0,0,0,0,100,0); + +-- Pathing for Eclipsion Centurion Entry: 19792 +SET @NPC := 70818; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4234.924,`position_y`=1547.492,`position_z`=126.5343 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-4234.924,1547.492,126.5343,0,0,0,0,100,0), +(@PATH,2,-4265.908,1569.376,133.2798,0,0,0,0,100,0), +(@PATH,3,-4281.013,1599.981,133.654,0,0,0,0,100,0), +(@PATH,4,-4302.111,1633.574,134.6775,0,0,0,0,100,0), +(@PATH,5,-4315.956,1670.131,135.9053,0,0,0,0,100,0), +(@PATH,6,-4302.111,1633.574,134.6775,0,0,0,0,100,0), +(@PATH,7,-4281.013,1599.981,133.654,0,0,0,0,100,0), +(@PATH,8,-4265.908,1569.376,133.2798,0,0,0,0,100,0); + +-- Pathing for Eclipsion Centurion Entry: 19792 +SET @NPC := 45146; +SET @PATH := @NPC * 10; +DELETE FROM `creature` WHERE `guid`=@NPC; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(@NPC,19792,530,1,1,-4300.741,1528.299,145.3227,6.021386,300,0,2); +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-4300.741,1528.299,145.3227,0,0,0,0,100,0), +(@PATH,2,-4267.303,1506.346,137.3165,0,0,0,0,100,0), +(@PATH,3,-4234.437,1486.09,127.7667,0,0,0,0,100,0), +(@PATH,4,-4266.797,1506.019,137.5665,0,0,0,0,100,0), +(@PATH,5,-4300.741,1528.299,145.3227,0,0,0,0,100,0), +(@PATH,6,-4333.723,1549.17,154.284,0,0,0,0,100,0), +(@PATH,7,-4365.854,1562.435,160.9441,0,0,0,0,100,0), +(@PATH,8,-4333.708,1549.164,154.1973,0,0,0,0,100,0); -- cgit v1.2.3