1. -- DK Zone CHAPTER IV (UDB212)
  3. -- [Chapter IV] Chapter IV Dummy
  4. Delete from `creature_ai_scripts` where `creature_id`= 29192;
  5. Insert into `creature_ai_scripts` values
  6. ('2919201','29192','1','0','100','0','1000','1000','0','0','45','5','20','0','0','0','0','0','0','0','0','0','[Chapter IV] Chapter IV Dummy - Send AI Event on OOC Timer');
  7. UPDATE creature_template SET AIName='EventAI' WHERE `entry` = '29192';
  8. -- Acherus Necromancer
  9. Delete from `creature_ai_scripts` where `creature_id`= 29191;
  10. Insert into `creature_ai_scripts` values
  11. ('2919101','29191','30','0','100','0','5','29192','0','0','11','53466','10','0','0','0','0','0','0','0','0','0','Acherus Necromancer - Cast Cauldron Stir on Receive AI Event');
  12. UPDATE creature_template SET AIName='EventAI' WHERE `entry` = '29191';
  13. -- Scarlet Deserter
  14. Delete from `creature_ai_scripts` where `creature_id`= 29193;
  15. Insert into `creature_ai_scripts` values
  16. ('2919301','29193','1','0','75','33','1000','5000','11000','20000','10','14','20','18','10','20','15','14','0','0','0','0','Scarlet Deserter - Random Emote on OOC');
  17. UPDATE creature_template SET AIName='EventAI' WHERE `entry` = '29193';
  18. -- Defender of the Light <The Argent Dawn> - update (correct models will be taken randomly - this will prevent naked model to be set)
  19. Delete from `creature_ai_scripts` where `id`= 2917407;
  20. Insert into `creature_ai_scripts` values
  21. ('2917407','29174','11','0','100','32','0','0','0','0','3','0','26057','0','3','0','26058','0','0','0','0','0','Defender of the Light - randomized morph on spawn');
  23. -- Chapter III
  24. -- Scarlet Ballista
  25. Delete from `creature_ai_scripts` where `creature_id`= 29104;
  26. Insert into `creature_ai_scripts` values
  27. ('2910401','29104','1','0','100','0','0','0','0','0','21','0','0','0','22','0','0','0','0','0','0','0','Scarlet Ballista - Prevent Combat Movement and Set Phase to 0 on Spawn'),
  28. ('2910402','29104','9','0','100','1','0','145','3000','3500','11','53117','1','0','0','0','0','0','0','0','0','0','Scarlet Ballista - Cast Ballista Assault'),
  29. ('2910403','29104','9','0','100','1','150','200','0','0','24','0','0','0','0','0','0','0','0','0','0','0','Scarlet Ballista - evade over 150y');
  30. UPDATE creature_template SET AIName='EventAI' WHERE `entry` = '29104';
  31. -- Frostbrood Vanquisher
  32. Delete from `creature_ai_scripts` where `creature_id`= 28670;
  33. Insert into `creature_ai_scripts` values
  34. ('2867001','28670','11','0','100','0','0','0','0','0','1','-A','0','0','0','0','0','0','0','0','0','0','Frostbrood Vanquisher - say on spawn'),
  35. ('2867002','28670','3','0','100','0','2','0','0','0','1','-B','0','0','0','0','0','0','0','0','0','0','Frostbrood Vanquisher - say when Mana is at 2%');
  36. UPDATE creature_template SET AIName='EventAI' WHERE `entry` = '28670';
  37. DELETE FROM `creature_ai_texts` WHERE `entry` IN ('-A','-B');
  38. INSERT into `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  39. ('-A','Avoid incoming Scarlet Crusade arrows and javelins by moving out of their line of fire!','0','3','0','28670','0'),
  40. ('-B','Devour Scarlet Crusaders to replenish your energy!','0','3','0','28670','0');
  41. -- Hearthglen Crusader
  42. Delete from `creature_ai_scripts` where `creature_id`= 29102;
  43. Insert into `creature_ai_scripts` values
  44. ('2910201','29102','9','0','100','1','0','20','0','0','21','1','0','0','40','1','0','0','20','1','0','0','Hearthglen Crusader - Start Combat Movement and Set Melee Weapon Model and Start Melee Below 20 Yards'),
  45. ('2910202','29102','9','0','100','1','20','150','3000','4000','11','53348','1','0','0','0','0','0','0','0','0','0','Hearthglen Crusader - Cast Arrow Assault');
  46. UPDATE creature_template SET AIName='EventAI' WHERE `entry` = '29102';
  48. -- Chapter I
  49. -- Mine Car -- this will allow Scarlet Miner - to attack us
  50. DELETE FROM creature_ai_scripts WHERE creature_id = 28821;
  51. INSERT INTO creature_ai_scripts VALUES
  52. ('2882101','28821','4','0','100','0','0','0','0','0','41','0','0','0','0','0','0','0','0','0','0','0','Mine Car - On Aggro - Force Despawn.');
  53. UPDATE creature_template SET AIName='EventAI' WHERE entry = 28821;