1. -- Silvermoon City
  2. -- Instructor Cel -- UPDATE
  3. Delete from `creature_ai_scripts` where `id`= 1862902;
  4. Insert into `creature_ai_scripts` values
  5. ('1862902','18629','1','0','100','1','1000','3000','6000','8000','10','1','25','274','0','0','0','0','0','0','0','0','Instructor Cel - Random Emote on OOC');
  6. -- Trainee Alcor
  7. Delete from `creature_ai_scripts` where `creature_id`= 18626;
  8. Insert into `creature_ai_scripts` values
  9. ('1862601','18626','1','0','100','33','1000','1000','4000','4000','10','35','60','36','10','54','36','60','0','0','0','0','Trainee Alcor - Random Emote on OOC');
  10. UPDATE creature_template SET AIName='EventAI' WHERE `entry` = '18626';
  11. -- Trainee Firea
  12. Delete from `creature_ai_scripts` where `creature_id`= 18627;
  13. Insert into `creature_ai_scripts` values
  14. ('1862701','18627','1','0','100','33','1000','1000','4000','4000','10','35','60','36','10','54','36','60','0','0','0','0','Trainee Firea - Random Emote on OOC');
  15. UPDATE creature_template SET AIName='EventAI' WHERE `entry` = '18627';
  18. -- q. 10830 'Exorcising the Trees' -- update
  19. -- Koi-Koi Spirit
  20. DELETE FROM creature_ai_scripts WHERE creature_id = 22226;
  21. INSERT INTO creature_ai_scripts VALUES
  22. ('2222601','22226','0','0','100','1','1000','3000','15000','17000','11','36093','1','0','0','0','0','0','0','0','0','0','Koi-Koi Spirit - Cast Ghost Strike'),
  23. ('2222602','22226','6','0','100','0','0','0','0','0','45','5','50','0','0','0','0','0','0','0','0','0','Koi-Koi Spirit - Send AI Event on Death.');
  24. UPDATE creature_template SET AIName='EventAI' WHERE entry = 22226;
  25. -- Raven's Wood Leafbeard
  26. UPDATE creature_template SET AIName='EventAI' WHERE entry = 21326;
  27. DELETE FROM creature_ai_scripts WHERE creature_id = 21326;
  28. INSERT INTO creature_ai_scripts VALUES
  29. ('2132601','21326','0','0','50','1','9000','12000','35000','42000','11','37696','0','0','0','0','0','0','0','0','0','0','Raven\'s Wood Leafbeard - Cast Force of Nature'),
  30. ('2132602','21326','30','0','100','0','5','22226','0','0','2','35','1','0','24','0','0','0','1','-A','0','0','Raven\'s Wood Leafbeard - Becomes friendly on Receive AI Event.'),
  31. ('2132603','21326','30','0','100','0','5','22226','0','0','41','15000','0','0','0','0','0','0','0','0','0','0','Raven\'s Wood Leafbeard - Despawns on Receive AI Event.');
  32. DELETE FROM `creature_ai_texts` WHERE `entry` = '-A';
  33. INSERT into `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`,`emote`) VALUES
  34. ('-A','%s appears very grateful to be free of the koi-koi spirit\'s influence.','0','2','0','21326','34');