API tools faq
paste
Pelf

blackrock caverns

Pelf
Dec 29th, 2011
164
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 5.16 KB | None | 0 0
raw download clone embed print report
  1. UPDATE `creature_template` SET `ScriptName`='boss_romogg_bonecrusher' WHERE `entry`=39665;
  2. DELETE FROM `creature_text` WHERE `entry` = 39665;
  3. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  4. VALUES (39665, 0, 0, 'Boss Cho\'gall not gonna be happy \'bout dis!', 1, 0, 0, 0, 0, 18925, 'VO_BC_Romogg_Event01');
  5. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  6. VALUES (39665, 1, 0, 'Dat\'s what you get! Noting!', 1, 0, 0, 0, 0, 18926, 'VO_BC_Romogg_Event02');
  7. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  8. VALUES (39665, 2, 0, 'Stand still! Rom\'ogg crack your skulls!', 1, 0, 0, 0, 0, 18927, 'VO_BC_Romogg_Event03');
  9. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  10. VALUES (39665, 3, 0, 'Rom\'ogg sorry...', 1, 0, 0, 0, 0, 18928, 'VO_BC_Romogg_Event04');
  11.  
  12. UPDATE `creature_template` SET `ScriptName`='boss_corla_herald_of_twilight' WHERE `entry`=39679;
  13. DELETE FROM `creature_text` WHERE `entry` = 39679;
  14. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  15. VALUES (39679, 0, 0, 'HERETICS! You will suffer for this interruption!', 1, 0, 0, 0, 0, 18589, 'VO_BC_Corla_Event01');
  16. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  17. VALUES (39679, 1, 0, 'There is only one true path of enlightenment! DEATH!', 1, 0, 0, 0, 0, 18590, 'VO_BC_Corla_Event02');
  18. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  19. VALUES (39679, 2, 0, 'Bask in his power! Rise as an agent of the master\'s rage!', 1, 0, 0, 0, 0, 18592, 'VO_BC_Corla_Event03');
  20. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  21. VALUES (39679, 3, 0, 'For the master I\'d die a thousand times... A thousan...', 1, 0, 0, 0, 0, 18594, 'VO_BC_Corla_Event04');
  22.  
  23. UPDATE `creature_template` SET `ScriptName`='boss_karsh_steelbender' WHERE `entry`=39698;
  24. DELETE FROM `creature_text` WHERE `entry` = 39698;
  25. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  26. VALUES (39698, 0, 0, 'Bodies to test my armaments upon!', 1, 0, 0, 0, 0, 18852, 'VO_BC_Karsh_Event01');
  27. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  28. VALUES (39698, 1, 0, 'Merely an impurity in the compound...', 1, 0, 0, 0, 0, 18853, 'VO_BC_Karsh_Event02');
  29. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  30. VALUES (39698, 2, 0, 'Feel the burn!', 1, 0, 0, 0, 0, 18854, 'VO_BC_Karsh_Event03');
  31. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  32. VALUES (39698, 3, 0, 'We number in the millions! Your efforts are wasted...', 1, 0, 0, 0, 0, 18855, 'VO_BC_Karsh_Event04');
  33.  
  34. UPDATE `creature_template` SET `ScriptName`='boss_beauty' WHERE `entry`=39700;
  35.  
  36. UPDATE `creature_template` SET `ScriptName`='boss_ascendant_lord_obsidius' WHERE `entry`=39705;
  37. UPDATE `creature_template` SET `ScriptName`='npc_shadow_of_obsidius' WHERE `entry`=40817;
  38. DELETE FROM `creature_text` WHERE `entry` = 39705;
  39. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  40. VALUES (39705, 0, 0, 'You come seeking answers? Then have them! Look upon your answer to living!', 1, 0, 0, 0, 0, 18899, 'VO_BC_Obsidius_Event01');
  41. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  42. VALUES (39705, 1, 0, 'Your kind has no place in the master\'s world.', 1, 0, 0, 0, 0, 18900, 'VO_BC_Obsidius_Event02');
  43. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  44. VALUES (39705, 2, 0, 'Earth can be shaped, molded... You cannot! You are useless!', 1, 0, 0, 0, 0, 18901, 'VO_BC_Obsidius_Event03');
  45. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  46. VALUES (39705, 3, 0, 'I cannot be destroyed... Only... de... layed...', 1, 0, 0, 0, 0, 18902, 'VO_BC_Obsidius_Event04');
  47.  
  48.  
  49. UPDATE `creature` SET `MovementType`=0 WHERE `id` = 40817;
  50. UPDATE `creature_template` SET `MovementType`=0 WHERE `entry` = 40817;
  51. UPDATE `creature` SET `MovementType`=0 WHERE `id` = 39705;
  52. UPDATE `creature_template` SET `MovementType`=0 WHERE `entry` = 39705;
  53. DELETE FROM `creature` WHERE `id` = 40008 AND `map` = 645;
  54. DELETE FROM `creature` WHERE `id` = 40817 AND `map` = 645;
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!