diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2020_03_14_01_world.sql | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_03_14_01_world.sql b/sql/updates/world/3.3.5/2020_03_14_01_world.sql new file mode 100644 index 00000000000..ef0b0d48982 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_03_14_01_world.sql @@ -0,0 +1,37 @@ +-- +UPDATE `creature` SET `position_z`= -12.294614 WHERE `guid`=76746; +DELETE FROM `smart_scripts` WHERE `entryorguid`=2196700 AND `source_type`=9; +DELETE FROM `smart_scripts` WHERE `entryorguid`IN(-76742,-74468,-74467,-74466,-74465,21967,21242) AND `source_type`=0; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=21967; +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_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(-76742, 0, 0, 0, 1, 0, 100, 0, 0, 0, 12000, 12000, 0, 80, 2196700, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Spirit - Out of Combat - Run Script'), +(2196700, 9, 0, 0, 0, 0, 100, 0,2000, 2000, 0, 0, 0, 11, 38155, 0, 0, 0, 0, 0, 10, 76741, 21967, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Spirit - Script - Cast Strength of Death'), +(2196700, 9, 1, 0, 0, 0, 100, 0,2000, 2000, 0, 0, 0, 11, 38155, 0, 0, 0, 0, 0, 10, 76745, 21967, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Spirit - Script - Cast Strength of Death'), +(2196700, 9, 2, 0, 0, 0, 100, 0,2000, 2000, 0, 0, 0, 11, 38155, 0, 0, 0, 0, 0, 10, 76740, 21967, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Spirit - Script - Cast Strength of Death'), +(2196700, 9, 3, 0, 0, 0, 100, 0,2000, 2000, 0, 0, 0, 11, 38155, 0, 0, 0, 0, 0, 10, 76744, 21967, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Spirit - Script - Cast Strength of Death'), +(2196700, 9, 4, 0, 0, 0, 100, 0,2000, 2000, 0, 0, 0, 11, 38155, 0, 0, 0, 0, 0, 10, 76743, 21967, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Spirit - Script - Cast Strength of Death'), +(2196700, 9, 5, 0, 0, 0, 100, 0,2000, 2000, 0, 0, 0, 11, 38155, 0, 0, 0, 0, 0, 10, 76746, 21967, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Spirit - Script - Cast Strength of Death'), +(-74468, 0, 0, 0, 23, 0, 100, 0, 13787, 0, 1000, 1000, 0, 11, 13787, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - On missing aura - Cast \'Demon Armor\''), +(-74468, 0, 1, 0, 0, 0, 100, 0, 1000, 2400, 2400, 3800, 0, 11, 9613, 64, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - IC - Cast \'Shadow Bolt\''), +(-74468, 0, 2, 0, 0, 0, 100, 0, 3000, 5000, 35000, 40000, 0, 11, 18267, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - In Combat - Cast \'Curse of Weakness\''), +(-74468, 0, 3, 0, 2, 0, 100, 1, 0, 15, 0, 0, 0, 25, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - Between 0-15% Health - Flee For Assist (No Repeat)'), +(-74468, 0, 4, 0, 1, 0, 100, 0, 0, 0, 1000, 1000, 0, 11, 38159, 32, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - OOC - Cast Auchanei Channeling (no duration)'), +(-74467, 0, 0, 0, 23, 0, 100, 0, 13787, 0, 1000, 1000, 0, 11, 13787, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - On missing aura - Cast \'Demon Armor\''), +(-74467, 0, 1, 0, 0, 0, 100, 0, 1000, 2400, 2400, 3800, 0, 11, 9613, 64, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - IC - Cast \'Shadow Bolt\''), +(-74467, 0, 2, 0, 0, 0, 100, 0, 3000, 5000, 35000, 40000, 0, 11, 18267, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - In Combat - Cast \'Curse of Weakness\''), +(-74467, 0, 3, 0, 2, 0, 100, 1, 0, 15, 0, 0, 0, 25, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - Between 0-15% Health - Flee For Assist (No Repeat)'), +(-74467, 0, 4, 0, 1, 0, 100, 0, 0, 0, 1000, 1000, 0, 11, 38159, 32, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - OOC - Cast Auchanei Channeling (no duration)'), +(-74466, 0, 0, 0, 23, 0, 100, 0, 13787, 0, 1000, 1000, 0, 11, 13787, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - On missing aura - Cast \'Demon Armor\''), +(-74466, 0, 1, 0, 0, 0, 100, 0, 1000, 2400, 2400, 3800, 0, 11, 9613, 64, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - IC - Cast \'Shadow Bolt\''), +(-74466, 0, 2, 0, 0, 0, 100, 0, 3000, 5000, 35000, 40000, 0, 11, 18267, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - In Combat - Cast \'Curse of Weakness\''), +(-74466, 0, 3, 0, 2, 0, 100, 1, 0, 15, 0, 0, 0, 25, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - Between 0-15% Health - Flee For Assist (No Repeat)'), +(-74466, 0, 4, 0, 1, 0, 100, 0, 0, 0, 1000, 1000, 0, 11, 38159, 32, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - OOC - Cast Auchanei Channeling (no duration)'), +(-74465, 0, 0, 0, 23, 0, 100, 0, 13787, 0, 1000, 1000, 0, 11, 13787, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - On missing aura - Cast \'Demon Armor\''), +(-74465, 0, 1, 0, 0, 0, 100, 0, 1000, 2400, 2400, 3800, 0, 11, 9613, 64, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - IC - Cast \'Shadow Bolt\''), +(-74465, 0, 2, 0, 0, 0, 100, 0, 3000, 5000, 35000, 40000, 0, 11, 18267, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - In Combat - Cast \'Curse of Weakness\''), +(-74465, 0, 3, 0, 2, 0, 100, 1, 0, 15, 0, 0, 0, 25, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - Between 0-15% Health - Flee For Assist (No Repeat)'), +(-74465, 0, 4, 0, 1, 0, 100, 0, 0, 0, 1000, 1000, 0, 11, 38159, 32, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - OOC - Cast Auchanei Channeling (no duration)'), +(21242, 0, 0, 0, 23, 0, 100, 0, 13787, 0, 1000, 1000, 0, 11, 13787, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - On missing aura - Cast \'Demon Armor\''), +(21242, 0, 1, 0, 0, 0, 100, 0, 1000, 2400, 2400, 3800, 0, 11, 9613, 64, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - IC - Cast \'Shadow Bolt\''), +(21242, 0, 2, 0, 0, 0, 100, 0, 3000, 5000, 35000, 40000, 0, 11, 18267, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - In Combat - Cast \'Curse of Weakness\''), +(21242, 0, 3, 0, 2, 0, 100, 1, 0, 15, 0, 0, 0, 25, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Death-Speaker - Between 0-15% Health - Flee For Assist (No Repeat)'); |