DB/SAI: Malykriss: The Vile Hold

1 files changed, 82 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_12_01_00_world.sql b/sql/updates/world/3.3.5/2019_12_01_00_world.sql
new file mode 100644
index 00000000000..1fd13ba94c4
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_12_01_00_world.sql
@@ -0,0 +1,82 @@
+-- 
+UPDATE `smart_scripts` SET `event_type`=2,`event_flags`=1,`event_param1`=50,`event_param2`=50 WHERE `entryorguid` IN (31161,30956) AND `source_type`=0 AND `id`=3; 
+UPDATE creature_template SET AIName='SmartAI', ScriptName='' WHERE entry IN (31780,31327,31325,31226,31326,31321,31320,31159,30953,31160,30954);
+DELETE FROM smart_scripts WHERE entryorguid IN (31780,31327,31325,31226,31326,31321,31320,31159,30953,31160,30954) 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`,`event_param5`,`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
+(31780, 0, 0, 0, 0, 0, 100, 0, 5000, 11000, 10000, 15000, 0, 11, 50284, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Fallen Spiderlord - In Combat - Cast Blinding Swarm'),
+(31327, 0, 0, 0, 0, 0, 100, 0, 2000, 8000, 13000, 16000, 0, 11, 60950, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Death Knight Initiate - In Combat - Cast Blood Plague'),
+(31327, 0, 1, 0, 0, 0, 100, 0, 4000, 7000, 7000, 10000, 0, 11, 60951, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Death Knight Initiate - In Combat - Cast Frost Strike'),
+(31327, 0, 2, 0, 0, 0, 100, 0, 2000, 8000, 9000, 12000, 0, 11, 60952, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Death Knight Initiate - In Combat - Cast Icy Touch'),
+(31327, 0, 3, 0, 0, 0, 100, 0, 3000, 8000, 11000, 13000, 0, 11, 60953, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Death Knight Initiate - In Combat - Cast Death and Decay'),
+(31325, 0, 0, 0, 0, 0, 100, 0, 2000, 8000, 13000, 16000, 0, 11, 60950, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Death Knight Adept - In Combat - Cast Blood Plague'),
+(31325, 0, 1, 0, 0, 0, 100, 0, 4000, 7000, 7000, 10000, 0, 11, 60951, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Death Knight Adept - In Combat - Cast Frost Strike'),
+(31325, 0, 2, 0, 0, 0, 100, 0, 2000, 8000, 9000, 12000, 0, 11, 60952, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Death Knight Adept - In Combat - Cast Icy Touch'),
+(31325, 0, 3, 0, 0, 0, 100, 0, 3000, 8000, 11000, 13000, 0, 11, 60953, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Death Knight Adept - In Combat - Cast Death and Decay'),
+(31226, 0, 0, 0, 0, 0, 100, 0, 1000, 2000, 3000, 4000, 0, 11, 40504, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Lumbering Atrocity - In Combat - Cast Cleave'),
+(31326, 0, 0, 0, 0, 0, 100, 0, 2000, 8000, 13000, 16000, 0, 11, 60950, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Death Knight Initiate - In Combat - Cast Blood Plague'),
+(31326, 0, 1, 0, 0, 0, 100, 0, 4000, 7000, 7000, 10000, 0, 11, 60951, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Death Knight Initiate - In Combat - Cast Frost Strike'),
+(31326, 0, 2, 0, 0, 0, 100, 0, 2000, 8000, 9000, 12000, 0, 11, 60952, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Death Knight Initiate - In Combat - Cast Icy Touch'),
+(31326, 0, 3, 0, 0, 0, 100, 0, 3000, 8000, 11000, 13000, 0, 11, 60953, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Death Knight Initiate - In Combat - Cast Death and Decay'),
+(31321, 0, 0, 0, 0, 0, 100, 0, 2000, 4000, 11000, 13000, 0, 11, 46202, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Skeletal Runesmith - IC - Cast Pierce Armor'),
+(31320, 0, 0, 0, 0, 0, 100, 0, 1000, 2000, 60000, 60000, 0, 11, 50420, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Umbral Brute - IC - Cast Enrage (Self)'),
+(31320, 0, 1, 0, 0, 0, 100, 0, 3000, 5000, 7000, 10000, 0, 11, 13446, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Umbral Brute - IC - Cast Strike'),
+(31320, 0, 2, 0, 0, 0, 100, 0, 4000, 5000, 9000, 12000, 0, 11, 34439, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Umbral Brute - IC - Cast Uppercut'),
+(31159, 0, 0, 0, 4, 0, 100, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Baelok - On Aggro - Say Line 0"),
+(31159, 0, 1, 0, 2, 0, 100, 1, 50, 50, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Baelok - At Health 50% - Say Line 1"),
+(31159, 0, 2, 0, 5, 0, 100, 1, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Baelok - On Killed Unit - Say Line 2"),
+(31159, 0, 3, 0, 6, 0, 100, 1, 0, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Baelok - On Just Died - Say Line 3"),
+(31159, 0, 4, 0, 0, 0, 100, 0, 4000, 7000, 9000, 13000, 0, 11, 61094, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Baelok - In Combat - Cast 'Death Grip'"),
+(31159, 0, 5, 0, 0, 0, 100, 0, 15000, 20000, 18000, 25000, 0, 11, 61090, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Baelok - In Combat - Cast 'Draw Soul'"),
+(31159, 0, 6, 0, 0, 0, 100, 0, 10000, 13000, 35000, 45000, 0, 11, 61086, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Baelok - In Combat - Cast 'Summon Dancing Runeblade'"),
+(30953, 0, 0, 0, 4, 0, 100, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Baelok - On Aggro - Say Line 0"),
+(30953, 0, 1, 0, 2, 0, 100, 1, 50, 50, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Baelok - At Health 50% - Say Line 1"),
+(30953, 0, 2, 0, 5, 0, 100, 1, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Baelok - On Killed Unit - Say Line 2"),
+(30953, 0, 3, 0, 6, 0, 100, 1, 0, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Baelok - On Just Died - Say Line 3"),
+(30953, 0, 4, 0, 0, 0, 100, 0, 4000, 7000, 9000, 13000, 0, 11, 61094, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Baelok - In Combat - Cast 'Death Grip'"),
+(30953, 0, 5, 0, 0, 0, 100, 0, 15000, 20000, 18000, 25000, 0, 11, 61090, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Baelok - In Combat - Cast 'Draw Soul'"),
+(30953, 0, 6, 0, 0, 0, 100, 0, 10000, 13000, 35000, 45000, 0, 11, 61086, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Baelok - In Combat - Cast 'Summon Dancing Runeblade'"),
+(31160, 0, 0, 0, 4, 0, 100, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Rokir - On Aggro - Say Line 0"),
+(31160, 0, 1, 0, 5, 0, 100, 1, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Rokir - On Killed Unit - Say Line 2"),
+(31160, 0, 2, 0, 6, 0, 100, 1, 0, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Rokir - On Just Died - Say Line 3"),
+(31160, 0, 3, 4, 2, 0, 100, 1, 50, 50, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Rokir - At Health 50% - Say Line 1"),
+(31160, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 11, 61088, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Rokir - At Health 50% - Cast 'Zombie Horde'"),
+(31160, 0, 5, 0, 9, 0, 100, 0, 0, 5, 15000, 19000, 0, 11, 61109, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Rokir - Within 0-5 Range - Cast 'Plague Strike'"),
+(31160, 0, 6, 0, 0, 0, 100, 0, 8000, 13000, 16000, 21000, 0, 11, 61112, 1, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, "Rokir - In Combat - Cast 'Death and Decay'"),
+(30954, 0, 0, 0, 4, 0, 100, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Rokir - On Aggro - Say Line 0"),
+(30954, 0, 1, 0, 5, 0, 100, 1, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Rokir - On Killed Unit - Say Line 2"),
+(30954, 0, 2, 0, 6, 0, 100, 1, 0, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Rokir - On Just Died - Say Line 3"),
+(30954, 0, 3, 4, 2, 0, 100, 1, 50, 50, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Rokir - At Health 50% - Say Line 1"),
+(30954, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 11, 61088, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Rokir - At Health 50% - Cast 'Zombie Horde'"),
+(30954, 0, 5, 0, 9, 0, 100, 0, 0, 5, 15000, 19000, 0, 11, 61109, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Rokir - Within 0-5 Range - Cast 'Plague Strike'"),
+(30954, 0, 6, 0, 0, 0, 100, 0, 8000, 13000, 16000, 21000, 0, 11, 61112, 1, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, "Rokir - In Combat - Cast 'Death and Decay'");
+
+DELETE FROM `creature_text` WHERE `CreatureID` IN (30953,31159,31160,30954);
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `comment`, `BroadcastTextId`) VALUES 
+(30953, 0, 0, "I've been waiting.", 14, 0, 100, 0, 0, 0, 'Baelok', 31855),
+(30953, 1, 0, "Don't stop now, I've almost broken a sweat.", 14, 0, 100, 0, 0, 0, 'Baelok', 31860),
+(30953, 2, 0, "I know no death. I will... be back... for you...", 14, 0, 100, 0, 0, 0, 'Baelok', 31861),
+(30953, 3, 0, "Your blood tastes sweet.", 14, 0, 100, 0, 0, 0, 'Baelok', 31862),
+(30953, 3, 1, "Another trophy for my collection.", 14, 0, 100, 0, 0, 0, 'Baelok', 31863),
+(30953, 3, 2, "Your blood is now mine.", 14, 0, 100, 0, 0, 0, 'Baelok', 31864),
+(30953, 3, 3, "Fragile thing.", 14, 0, 100, 0, 0, 0, 'Baelok', 31865),
+(31159, 0, 0, "I've been waiting.", 14, 0, 100, 0, 0, 0, 'Baelok', 31855),
+(31159, 1, 0, "Don't stop now, I've almost broken a sweat.", 14, 0, 100, 0, 0, 0, 'Baelok', 31860),
+(31159, 2, 0, "I know no death. I will... be back... for you...", 14, 0, 100, 0, 0, 0, 'Baelok', 31861),
+(31159, 3, 0, "Your blood tastes sweet.", 14, 0, 100, 0, 0, 0, 'Baelok', 31862),
+(31159, 3, 1, "Another trophy for my collection.", 14, 0, 100, 0, 0, 0, 'Baelok', 31863),
+(31159, 3, 2, "Your blood is now mine.", 14, 0, 100, 0, 0, 0, 'Baelok', 31864),
+(31159, 3, 3, "Fragile thing.", 14, 0, 100, 0, 0, 0, 'Baelok', 31865),
+(31160, 0, 0,"No shining army? No righteous words? It seems your 'honor' suits you no longer.", 14, 0, 100, 0, 0, 0, 'Rokir', 31866),
+(31160, 1, 0,"Such noble boasts, but in the end, we've brought you down to reality.", 14, 0, 100, 0, 0, 0, 'Rokir', 31867),
+(31160, 2, 0," You too shall serve the Lich King.... your time comes.", 14, 0, 100, 0, 0, 0, 'Rokir', 31868),
+(31160, 3, 0,"Your blood tastes sweet.", 14, 0, 100, 0, 0, 0, 'Rokir', 31862),
+(31160, 3, 1,"Another trophy for my collection.", 14, 0, 100, 0, 0, 0, 'Rokir', 31863),
+(31160, 3, 2,"Your blood is now mine.", 14, 0, 100, 0, 0, 0, 'Rokir', 31864),
+(31160, 3, 3,"Fragile thing.", 14, 0, 100, 0, 0, 0, 'Rokir', 31865),
+(30954, 0, 0,"No shining army? No righteous words? It seems your 'honor' suits you no longer.", 14, 0, 100, 0, 0, 0, 'Rokir', 31866),
+(30954, 1, 0,"Such noble boasts, but in the end, we've brought you down to reality.", 14, 0, 100, 0, 0, 0, 'Rokir', 31867),
+(30954, 2, 0," You too shall serve the Lich King.... your time comes.", 14, 0, 100, 0, 0, 0, 'Rokir', 31868),
+(30954, 3, 0,"Your blood tastes sweet.", 14, 0, 100, 0, 0, 0, 'Rokir', 31862),
+(30954, 3, 1,"Another trophy for my collection.", 14, 0, 100, 0, 0, 0, 'Rokir', 31863),
+(30954, 3, 2,"Your blood is now mine.", 14, 0, 100, 0, 0, 0, 'Rokir', 31864),
+(30954, 3, 3,"Fragile thing.", 14, 0, 100, 0, 0, 0, 'Rokir', 31865);