API tools faq
paste
Pelf

deadmines sql

Pelf
Jan 18th, 2012
198
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 10.30 KB | None | 0 0
raw download clone embed print report
  1. UPDATE `creature_template_addon` SET `auras`='' WHERE `entry`=47242;
  2. UPDATE `creature_template_addon` SET `auras`='' WHERE `entry`=43778;
  3. UPDATE `creature_template_addon` SET `auras`='' WHERE `entry`=47296;
  4. UPDATE `creature_template_addon` SET `auras`='' WHERE `entry`=47626;
  5. UPDATE `gameobject_template` SET `ScriptName`='go_defias_cannon' WHERE `entry`=16398;
  6.  
  7. UPDATE `creature_template` SET `ScriptName`='boss_glubtok' WHERE `entry`=47162;
  8. DELETE FROM `creature_text` WHERE `entry` = 47162;
  9. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  10. VALUES (47162, 0, 0, 'TOO...MUCH...POWER!!!', 1, 0, 0, 0, 0, 21145, 'VO_DM_GlubtokBoth_Death01');
  11. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  12. VALUES (47162, 1, 0, 'ARCANE POWER!!!', 1, 0, 0, 0, 0, 21146, 'VO_DM_GlubtokBoth_Spell03');
  13. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  14. VALUES (47162, 2, 0, 'Glubtok show you da power of de arcane!', 1, 0, 0, 0, 0, 21151, 'VO_DM_GlubtokHead1_Aggro01');
  15. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  16. VALUES (47162, 3, 0, 'Ha ha ha ha!', 1, 0, 0, 0, 0, 21152, 'VO_DM_GlubtokHead1_Kill01');
  17. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  18. VALUES (47162, 4, 0, 'Fists of flame!', 1, 0, 0, 0, 0, 21153, 'VO_DM_GlubtokHead1_Spell01');
  19. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  20. VALUES (47162, 5, 0, 'Glubtok ready?', 1, 0, 0, 0, 0, 21154, 'VO_DM_GlubtokHead1_Spell02');
  21. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  22. VALUES (47162, 3, 1, '\'Sploded dat one!', 1, 0, 0, 0, 0, 21155, 'VO_DM_GlubtokHead2_Kill01');
  23. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  24. VALUES (47162, 6, 0, 'Fists of frost!', 1, 0, 0, 0, 0, 21156, 'VO_DM_GlubtokHead2_Spell01');
  25. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  26. VALUES (47162, 7, 0, 'Let\'s do it!', 1, 0, 0, 0, 0, 21157, 'VO_DM_GlubtokHead2_Spell02');
  27.  
  28.  
  29. UPDATE `creature_template` SET `ScriptName`='boss_helix_gearbreaker' WHERE `entry`=47296;
  30. UPDATE `creature_template` SET `ScriptName`='npc_lumbering_oaf' WHERE `entry`=47297;
  31. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (88278, 'spell_helix_force_player_to_ride_oaf');
  32. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (88352, 'spell_helix_chest_bomb');
  33. UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=87, `faction_A`=16, `faction_H`=16, `ScriptName`='npc_sticky_bomb' WHERE `entry`=47314;
  34. UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=87, `faction_A`=16, `faction_H`=16, `ScriptName`='npc_helix_crew' WHERE `entry`=49136;
  35. DELETE FROM `creature_text` WHERE `entry` IN (47296, 47297);
  36. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  37. VALUES (47296, 0, 0, 'The scales...have...tipped...', 1, 0, 0, 0, 0, 20844, 'VO_DM_Helix_HelixDies01');
  38. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  39. VALUES (47296, 1, 0, 'Only ten copper? You\'re not even worth killing!', 1, 0, 0, 0, 0, 20845, 'VO_DM_Helix_Kill01');
  40. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  41. VALUES (47296, 2, 0, 'I didn\'t need him! Not when I\'ve got YOU oafs!', 1, 0, 0, 0, 0, 20846, 'VO_DM_Helix_OafDies01');
  42. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  43. VALUES (47296, 3, 0, 'Bombs away!', 1, 0, 0, 0, 0, 20847, 'VO_DM_Helix_Spell01');
  44. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  45. VALUES (47296, 4, 0, 'Ready Oafie? Throw!', 1, 0, 0, 0, 0, 20848, 'VO_DM_Helix_Spell02');
  46. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  47. VALUES (47296, 5, 0, 'The mistress will pay me handsomely for your heads!', 1, 0, 0, 0, 0, 20849, 'VO_DM_Helix_Aggro01');
  48. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  49. VALUES (47297, 0, 0, 'No...NO! OAF SMASH!!', 1, 0, 0, 0, 0, 20854, 'VO_DM_LumberingOaf_HelixDies01');
  50. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  51. VALUES (47297, 1, 0, '', 1, 0, 0, 0, 0, 20855, 'VO_DM_LumberingOaf_OafDies01');
  52.  
  53. UPDATE `creature_template` SET `ScriptName`='boss_foereaper5000' WHERE `entry`=43778;
  54. UPDATE `creature_template` SET `flags_extra` = 128, `ScriptName`='npc_foereaper_targeting_bunny' WHERE `entry` = 47468;
  55. UPDATE `creature_template_addon` SET `auras`='0' WHERE `entry`=43778;
  56. DELETE FROM `creature_text` WHERE `entry` = 43778;
  57. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  58. VALUES (43778, 0, 0, 'Foe Reaper 5000 on-line. All systems nominal.', 1, 0, 0, 0, 0, 22137, 'VO_DM_FoeReaper_Aggro01');
  59. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  60. VALUES (43778, 1, 0, 'Overheat threshold exceeded. System failure. Wheat clog in port two. Shutting down.', 1, 0, 0, 0, 0, 22138, 'VO_DM_FoeReaper_Death01');
  61. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  62. VALUES (43778, 2, 0, 'Target destroyed.', 1, 0, 0, 0, 0, 22139, 'VO_DM_FoeReaper_Kill01');
  63. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  64. VALUES (43778, 3, 0, 'Acquiring target...', 1, 0, 0, 0, 0, 22140, 'VO_DM_FoeReaper_Spell01');
  65. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  66. VALUES (43778, 4, 0, 'Target acquired. Harvesting servos engaged.', 1, 0, 0, 0, 0, 22141, 'VO_DM_FoeReaper_Spell02');
  67. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  68. VALUES (43778, 5, 0, 'Overdrive engine activated.', 1, 0, 0, 0, 0, 22142, 'VO_DM_FoeReaper_Spell03');
  69. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  70. VALUES (43778, 6, 0, 'Safety restrictions off-line. Catastrophic system failure imminent.', 1, 0, 0, 0, 0, 22143, 'VO_DM_FoeReaper_Spell04');
  71.  
  72.  
  73. UPDATE `creature_template` SET `faction_A`=16, `faction_H`=16, `ScriptName`='npc_vapor' WHERE `entry`=47714;
  74. UPDATE `creature_template` SET `ScriptName`='boss_admiral_ripsnarl' WHERE `entry`=47626;
  75. DELETE FROM `creature_text` WHERE `entry` = 47626;
  76. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  77. VALUES (47626, 0, 0, 'You will...NOT find her...until it is too late...', 1, 0, 0, 0, 0, 19875, 'VO_DM_Ripsnarl_Death01');
  78. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  79. VALUES (47626, 1, 0, 'Your blood only increases my hunger!', 1, 0, 0, 0, 0, 19876, 'VO_DM_Ripsnarl_Kill01');
  80. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  81. VALUES (47626, 2, 0, 'Do you feel that chill running up your spine? The fog is rolling in...', 1, 0, 0, 0, 0, 19877, 'VO_DM_Ripsnarl_Spell01');
  82. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  83. VALUES (47626, 3, 0, '', 1, 0, 0, 0, 0, 19878, 'VO_DM_Ripsnarl_Spell02');
  84. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  85. VALUES (47626, 4, 0, 'I can smell your fear...', 1, 0, 0, 0, 0, 19879, 'VO_DM_Ripsnarl_Spell03');
  86. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  87. VALUES (47626, 5, 0, 'I will rip your heart from your chest!', 1, 0, 0, 0, 0, 19880, 'VO_DM_Ripsnarl_Spell04');
  88. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  89. VALUES (47626, 6, 0, '', 1, 0, 0, 0, 0, 19881, 'VO_DM_Ripsnarl_Spell05');
  90. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  91. VALUES (47626, 7, 0, 'Ah, fresh meat!', 1, 0, 0, 0, 0, 19882, 'VO_DM_Ripsnarl_Aggro01');
  92.  
  93. UPDATE `creature_template` SET `ScriptName`='boss_captain_cookie' WHERE `entry`=47739;
  94. UPDATE creature_template SET `npcflag` = 1, `scriptname` = 'npc_captain_cookie_good_food' WHERE entry IN (48301, 48297, 48300, 48296, 48006, 48294);
  95. UPDATE creature_template SET `npcflag` = 1, `scriptname` = 'npc_captain_cookie_bad_food' WHERE entry IN (48295, 48276, 48299, 48293, 48298, 48302);
  96. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (89267, 'spell_captain_cookie_setiated');
  97. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (92834, 'spell_captain_cookie_setiated');
  98. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (89732, 'spell_captain_cookie_nauseated');
  99. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (92066, 'spell_captain_cookie_nauseated');
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!