API tools faq
paste
Pelf

grim batol sql

Pelf
Jan 5th, 2012
122
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 8.58 KB | None | 0 0
raw download clone embed print report
  1. UPDATE `creature_template` SET `ScriptName`='boss_general_umbriss' WHERE `entry`=39625;
  2. UPDATE `creature_template` SET `ScriptName`='npc_malignant_trogg' WHERE `entry`=39984;
  3. UPDATE `creature_template` SET `ScriptName`='npc_trogg_dweller' WHERE `entry`=45467;
  4. DELETE FROM `creature_text` WHERE `entry` = 39625;
  5. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  6. VALUES (39625, 0, 0, 'A million more await my orders. What chance do you have?', 1, 0, 0, 0, 0, 18530, 'VO_GB_Umbriss_Event01');
  7. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  8. VALUES (39625, 1, 0, 'Vermin, your dinner awaits!', 1, 0, 0, 0, 0, 18531, 'VO_GB_Umbriss_Event02');
  9. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  10. VALUES (39625, 2, 0, 'Messy...', 1, 0, 0, 0, 0, 18532, 'VO_GB_Umbriss_Event03');
  11. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  12. VALUES (39625, 3, 0, '', 1, 0, 0, 0, 0, 18533, 'VO_GB_Umbriss_Event04');
  13. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  14. VALUES (39625, 4, 0, '', 1, 0, 0, 0, 0, 18534, 'VO_GB_Umbriss_Event05');
  15. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  16. VALUES (39625, 1, 1, 'Attack you cowardly vermin!', 1, 0, 0, 0, 0, 18535, 'VO_GB_Umbriss_Event06');
  17. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  18. VALUES (39625, 5, 0, 'Reinforce the front! We are being invaded!', 1, 0, 0, 0, 0, 18536, 'VO_GB_Umbriss_Event07');
  19. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  20. VALUES (39625, 6, 0, 'Cover the rear! Alexstrasza\'s brood decimate our ranks!', 1, 0, 0, 0, 0, 18537, 'VO_GB_Umbriss_Event08');
  21.  
  22. UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=87, `faction_A`=16, `faction_H`=16, `flags_extra`=128, `ScriptName`='npc_cave_in_stalker' WHERE `entry`=40228;
  23. UPDATE `creature_template` SET `ScriptName`='boss_forgemaster_throngus' WHERE `entry`=40177;
  24. DELETE FROM `spell_script_names` WHERE `spell_id` = 75000;
  25. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (75000, 'spell_throngus_pick_weapon');
  26. DELETE FROM `creature_text` WHERE `entry` = 40177;
  27. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  28. VALUES (40177, 0, 0, 'NO! Throngus get whipped again if he no finish!', 1, 0, 0, 0, 0, 18943, 'VO_GB_Throngus_Event01');
  29. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  30. VALUES (40177, 1, 0, 'Throngus use your corpse on body. Somewhere...', 1, 0, 0, 0, 0, 18944, 'VO_GB_Throngus_Event02');
  31. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  32. VALUES (40177, 1, 1, 'You break easy!', 1, 0, 0, 0, 0, 18945, 'VO_GB_Throngus_Event03');
  33. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  34. VALUES (40177, 2, 0, 'Death... Good choice. Not best choice maybe, but better than fail and live.', 1, 0, 0, 0, 0, 18946, 'VO_GB_Throngus_Event04');
  35. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  36. VALUES (40177, 3, 0, 'You not get through defenses!', 1, 0, 0, 0, 0, 18947, 'VO_GB_Throngus_Event05');
  37. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  38. VALUES (40177, 4, 0, 'Throngus SLICE you up!', 1, 0, 0, 0, 0, 18948, 'VO_GB_Throngus_Event06');
  39. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  40. VALUES (40177, 5, 0, 'Oh, this gonna HURT!', 1, 0, 0, 0, 0, 18949, 'VO_GB_Throngus_Event07');
  41.  
  42. DELETE FROM `creature` WHERE `id` = 40320 AND `map` = 670;
  43. UPDATE `creature_template` SET `ScriptName`='boss_drahga_shadowburner' WHERE `entry`=40319;
  44. UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=87, `faction_A`=16, `faction_H`=16, `ScriptName`='npc_invoked_flaming_spirit' WHERE `entry`=40357;
  45. UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=87, `faction_A`=16, `faction_H`=16, `flags_extra`=128, `ScriptName`='npc_invocation_of_flame_stalker' WHERE `entry`=40355;
  46. DELETE FROM `spell_script_names` WHERE `spell_id` IN (75238, 90972);
  47. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (75238, 'spell_drahga_supernova');
  48. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (90972, 'spell_drahga_supernova');
  49. DELETE FROM `creature_text` WHERE `entry` = 40319;
  50. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  51. VALUES (40319, 0, 0, 'I will burn you from the inside out!', 1, 0, 0, 0, 0, 18610, 'VO_GB_Drahga_Event01');
  52. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  53. VALUES (40319, 1, 0, '', 1, 0, 0, 0, 0, 18611, 'VO_GB_Drahga_Event02');
  54. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  55. VALUES (40319, 2, 0, 'You should have come better prepared!', 1, 0, 0, 0, 0, 18612, 'VO_GB_Drahga_Event03');
  56. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  57. VALUES (40319, 3, 0, 'Valiona, finish them! Avenge me!', 1, 0, 0, 0, 0, 18614, 'VO_GB_Drahga_Event04');
  58. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  59. VALUES (40319, 4, 0, 'INCINERATE THEM, MINIONS!', 1, 0, 0, 0, 0, 18616, 'VO_GB_Drahga_Event05');
  60. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  61. VALUES (40319, 4, 1, 'BY FIRE BE... BURNED!', 1, 0, 0, 0, 0, 18619, 'VO_GB_Drahga_Event06');
  62. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  63. VALUES (40319, 5, 0, 'Dragon, you will do as I command! Catch me!', 1, 0, 0, 0, 0, 18621, 'VO_GB_Drahga_Event07');
  64.  
  65. UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=87, `faction_A`=16, `faction_H`=16, `ScriptName`='npc_faceless_corruptor' WHERE `entry`=48844;
  66. UPDATE `creature_template` SET `ScriptName`='boss_erudax' WHERE `entry`=40484;
  67. DELETE FROM `creature_text` WHERE `entry` = 40484;
  68. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  69. VALUES (40484, 0, 0, 'The darkest days are still ahead!', 1, 0, 0, 0, 0, 18638, 'VO_GB_Erudax_Event01');
  70. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  71. VALUES (40484, 1, 0, '', 1, 0, 0, 0, 0, 18639, 'VO_GB_Erudax_Event02');
  72. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  73. VALUES (40484, 2, 0, 'Flesh for the offering.', 1, 0, 0, 0, 0, 18640, 'VO_GB_Erudax_Event03');
  74. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  75. VALUES (40484, 3, 0, 'Ywaq maq oou; ywaq maq ssaggh. Ywaq ma shg\'fhn.', 1, 0, 0, 0, 0, 18641, 'VO_GB_Erudax_Event04');
  76. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  77. VALUES (40484, 4, 0, 'F\'lakh ghet! The shadow\'s hunger cannot be sated!', 1, 0, 0, 0, 0, 18644, 'VO_GB_Erudax_Event05');
  78. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  79. VALUES (40484, 5, 0, 'Come, suffering... enter, chaos!', 1, 0, 0, 0, 0, 18646, 'VO_GB_Erudax_Event06');
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!