1. -- Lady Anacondra text and script
  2. DELETE FROM `world`.`creature_text` WHERE `entry`='3671';
  3. INSERT INTO `world`.`creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`) VALUES ('3671', '0', '0', 'None can stand against the Serpent Lords!', '14', '0', '100', '0', '0', '0', '0', '0');
  4. UPDATE `world`.`creature_template` SET `ScriptName`='boss_lady_anacondra' WHERE `entry`='3671';
  6. -- Lord Serpentis text and script
  7. DELETE FROM `world`.`creature_text` WHERE `entry`='3673';
  8. INSERT INTO `world`.`creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`) VALUES ('3673', '0', '0', 'I am the serpent king! I can do anything', '14', '0', '100', '0', '0', '0', '0', '0');
  9. UPDATE `world`.`creature_template` SET `ScriptName`='boss_lord_serpentis' WHERE `entry`='3673';
  11. -- Lord Pythas text and script
  12. DELETE FROM `world`.`creature_text` WHERE `entry`='3670';
  13. INSERT INTO `world`.`creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`) VALUES ('3670', '0', '0', 'The coils of death will crush you', '14', '0', '100', '0', '0', '0', '0', '0');
  14. UPDATE `world`.`creature_template` SET `ScriptName`='boss_lord_pythas' WHERE `entry`='3670';
  16. -- Lord Cobrahn text and script
  17. DELETE FROM `world`.`creature_text` WHERE `entry`='3669';
  18. INSERT INTO `world`.`creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`) VALUES ('3669', '0', '0', 'You will never wake the dreamer!', '14', '0', '100', '0', '0', '0', '0', '0');
  19. UPDATE `world`.`creature_template` SET `ScriptName`='boss_lord_cobrahn' WHERE `entry`='3669';
  21. -- kresh spell
  22. UPDATE `world`.`creature_template` SET `AIName`='SmartAI' WHERE `entry`='3653';
  23. DELETE FROM `world`.`smart_scripts` WHERE `entryorguid`=3653;
  24. INSERT INTO `world`.`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 ('3653', '0', '0', '0', '0', '0', '100', '0', '10000', '10000', '10000', '10000', '11', '80362', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', 'Cast Crushing Bite - On Combat - every 10 seconds');
  26. -- Kresh fix respawn respawn point
  27. DELETE FROM `world`.`creature` WHERE `id`='3653';
  28. INSERT INTO `world`.`creature` (`guid`,`id`,`map`,`zoneId`,`areaId`,`spawnMask`,`PhaseId`,`PhaseGroup`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`VerifiedBuild`) VALUES
  29. ('27368', '3653', '43', '0', '0', '2', '0', '0', '0', '0', '-64.4082', '319.084', '-106.699', '5.7292', '36000', '0', '1', '1452', '0', '2', '0', '0', '0', '0');
  31. -- Kresh path
  32. INSERT INTO `world`.`waypoints` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
  33. ('273680', '1', '-64.4082', '319.084', '-106.699', '0', '0', '0', '0', '100', '452586'),
  34. ('273680', '2', '-33.3439', '299.292', '-106.417', '0', '0', '0', '0', '100', '452587'),
  35. ('273680', '3', '-3.64081', '229.268', '-106.189', '0', '0', '0', '0', '100', '452588'),
  36. ('273680', '4', '-16.9356', '143.141', '-106.162', '0', '0', '0', '0', '100', '452589'),
  37. ('273680', '5', '-55.7879', '93.6158', '-106.162', '0', '0', '0', '0', '100', '452590'),
  38. ('273680', '6', '-17.6203', '142.151', '-106.162', '0', '0', '0', '0', '100', '452591'),
  39. ('273680', '7', '-3.64081', '229.268', '-106.189', '0', '0', '0', '0', '100', '452592'),
  40. ('273680', '8', '-33.3439', '299.292', '-106.417', '0', '0', '0', '0', '100', '452593'),
  41. ('273680', '9', '-64.4082', '319.084', '-106.699', '0', '0', '0', '0', '100', '452594');
  43. -- Skum spell
  44. DELETE FROM `world`.`smart_scripts` WHERE `entryorguid`=3674;
  45. INSERT INTO `world`.`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
  46. ('3674', '0', '0', '0', '0', '0', '100', '2', '1000', '1000', '4000', '6000', '11', '6254', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', 'Skum - In Combat - Cast Chained Bolt (No Repeat) (Normal Dungeon)');
  48. -- Mutanus the devourer add script
  49. UPDATE `world`.`creature_template` SET `ScriptName`='boss_mutanus_the_devourer' WHERE `entry`='3654';
  51. -- Normal mobs spells
  52. DELETE FROM `world`.`smart_scripts` WHERE `entryorguid` IN(5048,5053,5056,5055,3636,5761,5755,3840);
  53. INSERT INTO `world`.`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
  54. ('5048', '0', '0', '0', '0', '0', '100', '2', '6000', '6000', '15000', '25000', '11', '744', '32', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', 'Deviate Adder - In Combat - Cast Poison'), -- http://www.wowhead.com/npc=5048/deviate-adder
  55. ('5053', '0', '0', '0', '0', '0', '100', '2', '6000', '6000', '10000', '12000', '11', '3604', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', 'Deviate Crocolisk - In Combat - Cast Tendon Rip'), -- http://www.wowhead.com/npc=5053/deviate-crocolisk#abilities
  56. ('5056', '0', '0', '1', '0', '0', '100', '0', '15000', '15000', '20000', '25000', '11', '7399', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', 'Deviate Dreadfang - In Combat - Cast Terrify'), -- http://www.wowhead.com/npc=5056/deviate-dreadfang
  57. ('5056', '0', '1', '0', '61', '0', '100', '0', '0', '0', '0', '0', '13', '0', '50', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', 'Deviate Dreadfang - In Combat - Set Single Threat 0-50'),
  58. ('5055', '0', '0', '0', '0', '0', '100', '2', '6000', '6000', '8000', '12000', '11', '7342', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', 'Deviate Lasher - In Combat - Cast Wide Slash'), -- http://www.wowhead.com/npc=5055/deviate-lasher
  59. ('3636', '0', '0', '0', '0', '0', '100', '3', '0', '0', '1000', '1000', '11', '12787', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'Deviate Ravager - Out of Combat - Cast Thrash'), -- http://www.wowhead.com/npc=3636/deviate-ravager
  60. ('5761', '0', '0', '0', '2', '0', '100', '2', '0', '70', '21000', '21000', '11', '7948', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'Deviate Shambler - Between 0-70% Health - Cast Wild Regeneration'), -- http://www.wowhead.com/npc=5761/deviate-shambler
  61. ('3633', '0', '0', '0', '2', '0', '100', '0', '0', '40', '10000', '10000', '11', '7938', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', 'Deviate Slayer - Between 0-40% Health - Cast Fatal Bite'), -- http://www.wowhead.com/npc=3633/deviate-slayer
  62. ('5756', '0', '0', '0', '0', '0', '100', '2', '10000', '10000', '8000', '10049', '11', '7951', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', 'Deviate Venomwing - In Combat - Cast Toxic Spit'), -- http://www.wowhead.com/npc=5756/deviate-venomwing
  63. ('5755', '0', '0', '0', '0', '0', '100', '2', '6000', '6000', '10000', '15000', '11', '7947', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', 'Deviate Viper - In Combat - Cast Localized Toxin') -- http://www.wowhead.com/npc=5755/deviate-viper
  64. ('3840', '0', '3', '0', '74', '1', '100', '2', '0', '40', '12000', '18000', '11', '5187', '1', '0', '0', '0', '0', '9', '0', '0', '0', '0', '0', '0', '0', 'Druid of the Fang - On Friendly Between 0-40% Health - Cast Healing Touch (Normal Dungeon)'), -- http://www.wowhead.com/npc=3840/druid-of-the-fang
  65. ('3840', '0', '4', '5', '2', '0', '100', '3', '0', '50', '20000', '25000', '11', '8041', '1', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'Druid of the Fang - Between 0-50% Health - Cast Serpent Form (Normal Dungeon)'),
  66. ('3840', '0', '5', '6', '61', '0', '100', '2', '0', '0', '0', '0', '21', '1', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'Druid of the Fang - Between 0-50% Health - Enable Combat Movement'),
  67. ('3840', '0', '6', '0', '61', '0', '100', '2', '0', '0', '0', '0', '22', '3', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'Druid of the Fang - Between 0-50% Health - Set Event Phase 3 (Normal Dungeon)'),
  68. ('3840', '0', '7', '0', '23', '0', '100', '2', '8041', '0', '0', '0', '22', '1', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'Druid of the Fang - On has aura Serpent Form stack 0 - Set Event Phase 1 (Normal Dungeon)');
  72. -- update smartAI normal mobs
  73. UPDATE `world`.`creature_template` SET `AIName`='SmartAI'
  74. WHERE `entry` IN(5048,5053,5056,5055,3636,5761,5755,3840);