API tools faq
paste
Pelf

Pelf throne of the tides sql

Pelf
May 12th, 2012
237
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 11.35 KB | None | 0 0
raw download clone embed print report
  1. #скрипты
  2. UPDATE `instance_template` SET `script`='instance_throne_of_the_tides' WHERE `map`=643;
  3.  
  4. #треш
  5. UPDATE `gameobject_template` SET `scriptname`='go_totd_defense_system' WHERE `entry`=203199;
  6. UPDATE `creature_template` SET `ScriptName`='npc_lady_nazjar_event' WHERE `entry`=39959;
  7. UPDATE `creature_template` SET `ScriptName`='npc_throne_of_the_tides_teleporter' WHERE `entry`=51391;
  8. UPDATE `creature_template` SET `ScriptName`='npc_throne_of_the_tides_teleporter' WHERE `entry`=51395;
  9. DELETE FROM `areatrigger_scripts` WHERE `entry`=5834;
  10. DELETE FROM `areatrigger_scripts` WHERE `entry`=5873;
  11. DELETE FROM `areatrigger_scripts` WHERE `entry`=6646;
  12. INSERT INTO `areatrigger_scripts` VALUES (5834, 'at_tott_lady_nazjar_event');
  13. INSERT INTO `areatrigger_scripts` VALUES (5873, 'at_tott_commander_ulthok');
  14. INSERT INTO `areatrigger_scripts` VALUES (6646, 'at_tott_ozumat');
  15.  
  16. #назжар
  17. UPDATE `creature_template` SET `ScriptName`='boss_lady_nazjar' WHERE `entry`=40586;
  18. UPDATE `creature_template` SET `ScriptName`='npc_lady_nazjar_honnor_guard' WHERE `entry`=40633;
  19. UPDATE `creature_template` SET `ScriptName`='npc_lady_nazjar_tempest_witch' WHERE `entry`=44404;
  20. UPDATE `creature_template` SET `ScriptName`='npc_lady_nazjar_waterspout' WHERE `entry`=48571;
  21. UPDATE `creature_template` SET `ScriptName`='npc_lady_nazjar_waterspout' WHERE `entry`=49108;
  22. UPDATE `creature_template` SET `ScriptName`='npc_lady_nazjar_geyser' WHERE `entry`=40597;
  23.  
  24. #утлок
  25. UPDATE `creature_template` SET `ScriptName`='boss_commander_ulthok' WHERE `entry`=40765;
  26. UPDATE `creature_template` SET `ScriptName`='npc_ulthok_dark_fissure' WHERE `entry`=40784;
  27.  
  28. #гурша
  29. UPDATE `creature_template` SET `ScriptName`='boss_mindbender_ghursha' WHERE `entry`=40788;
  30. UPDATE `creature_template` SET `ScriptName`='boss_erunak_stonespeaker' WHERE `entry`=40825;
  31. UPDATE `creature_template` SET `ScriptName`='npc_erunak_earth_shards' WHERE `entry`=45469;
  32. UPDATE `creature_template` SET `ScriptName`='npc_ghursha_mind_fog' WHERE `entry`=40861;
  33.  
  34.  
  35. #озумат
  36. UPDATE `creature_template` SET `ScriptName`='npc_neptulon' WHERE `entry`=40792;
  37. UPDATE `creature_template` SET `ScriptName`='npc_vicious_mindslasher' WHERE `entry`=44715;
  38. UPDATE `creature_template` SET `ScriptName`='npc_unyielding_behemoth' WHERE `entry`=44648;
  39. UPDATE `creature_template` SET `ScriptName`='npc_faceless_sapper' WHERE `entry`=44752;
  40. UPDATE `creature_template` SET `ScriptName`='npc_blight_of_ozumat' WHERE `entry`=44801;
  41.  
  42. #спеллы
  43.  
  44. #озумат
  45. DELETE FROM `conditions` WHERE `SourceEntry`=83463;
  46. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  47. VALUES ('13', '0', '83463', '0', '18', '1', '40792', '0', '0', '', 'Entangling Grasp');
  48.  
  49. #тексты
  50. #евент назжар
  51. DELETE FROM `creature_text` WHERE `entry`=39959;
  52. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  53. VALUES (39959, 0, 0, 'Armies of the depths, wash over our enemies as a tide of death!', 1, 0, 0, 0, 0, 18890, 'VO_TT_Nazjar_Event05');
  54. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  55. VALUES (39959, 1, 0, 'Meddlesome gnats, you\'ve thought us defeated so easily.', 1, 0, 0, 0, 0, 18891, 'VO_TT_Nazjar_Event06');
  56.  
  57. #назжар
  58. DELETE FROM `creature_text` WHERE `entry`=40586;
  59. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  60. VALUES (40586, 0, 0, 'You have interfered with our plans for the last time, mortals!', 1, 0, 0, 0, 0, 18886, 'VO_TT_Nazjar_Event01');
  61. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  62. VALUES (40586, 1, 0, 'Depths take you!', 1, 0, 0, 0, 0, 18887, 'VO_TT_Nazjar_Event02');
  63. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  64. VALUES (40586, 1, 1, 'The abyss awaits!', 1, 0, 0, 0, 0, 18888, 'VO_TT_Nazjar_Event03');
  65. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  66. VALUES (40586, 2, 0, 'Ulthok... stop them...', 1, 0, 0, 0, 0, 18889, 'VO_TT_Nazjar_Event04');
  67. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  68. VALUES (40586, 3, 0, 'Take arms, minions! Rise from the icy depths!', 1, 0, 0, 0, 0, 18892, 'VO_TT_Nazjar_Event07');
  69. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  70. VALUES (40586, 4, 0, 'Destroy these intruders! Leave them for the great dark beyond!', 1, 0, 0, 0, 0, 18893, 'VO_TT_Nazjar_Event08');
  71.  
  72. #улток
  73. #эрунак
  74. DELETE FROM `creature_text` WHERE `entry`=40825;
  75. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  76. VALUES (40825, 0, 0, 'I thank you, my friends. Forgive me. I... I have grown too weak to be of any assistance.', 1, 0, 0, 0, 0, 18662, 'VO_TT_Erunak_Freed');
  77. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  78. VALUES (40825, 1, 0, 'I am... weary. You must carry on without me. I shall take my leave once my strength has returned.', 1, 0, 0, 0, 0, 18664, 'VO_TT_Erunak_PostFight');
  79.  
  80. #гурша
  81. DELETE FROM `creature_text` WHERE `entry`=40788;
  82. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  83. VALUES (40788, 0, 0, 'A new host must be found.', 1, 0, 0, 0, 0, 18860, 'VO_TT_Mindbender_Event01');
  84. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  85. VALUES (40788, 1, 0, 'Too weak to serve!', 1, 0, 0, 0, 0, 18861, 'VO_TT_Mindbender_Event02');
  86. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  87. VALUES (40788, 1, 1, 'Only your memory remains!', 1, 0, 0, 0, 0, 18862, 'VO_TT_Mindbender_Event03');
  88. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  89. VALUES (40788, 2, 0, 'They are outside the cycle...', 1, 0, 0, 0, 0, 18863, 'VO_TT_Mindbender_Event04');
  90. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  91. VALUES (40788, 3, 0, 'There is only Ghur\'sha.', 1, 0, 0, 0, 0, 18864, 'VO_TT_Mindbender_Event05');
  92. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  93. VALUES (40788, 3, 1, 'Give in.', 1, 0, 0, 0, 0, 18865, 'VO_TT_Mindbender_Event06');
  94. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  95. VALUES (40788, 3, 2, 'Who are your allies?', 1, 0, 0, 0, 0, 18866, 'VO_TT_Mindbender_Event07');
  96. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  97. VALUES (40788, 4, 0, 'Is. This. Reality.', 1, 0, 0, 0, 0, 18867, 'VO_TT_Mindbender_Event08');
  98.  
  99. #нептулон
  100. DELETE FROM `creature_text` WHERE `entry`=40792;
  101. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  102. VALUES (40792, 0, 0, 'Ahh - my fearless assistants, I assume.', 1, 0, 0, 0, 0, 19469, 'VO_TT_Neptulon_Event01');
  103. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  104. VALUES (40792, 1, 0, 'You may yet regret your presence here.', 1, 0, 0, 0, 0, 19470, 'VO_TT_Neptulon_Event02');
  105. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  106. VALUES (40792, 2, 0, 'As I purify these waters, the servants of filth will surely be stirred. Beware!', 1, 0, 0, 0, 0, 19471, 'VO_TT_Neptulon_Event03');
  107. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  108. VALUES (40792, 3, 0, 'Augh... Their filthiness stains me!', 1, 0, 0, 0, 0, 19472, 'VO_TT_Neptulon_Fight01');
  109. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  110. VALUES (40792, 4, 0, 'I grow weary!', 1, 0, 0, 0, 0, 19473, 'VO_TT_Neptulon_Fight02');
  111. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  112. VALUES (40792, 5, 0, 'Fools! Make yourselves useful!', 1, 0, 0, 0, 0, 19474, 'VO_TT_Neptulon_Fight03');
  113. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  114. VALUES (40792, 6, 0, 'Patience guests. The waters are nearly cleansed.', 1, 0, 0, 0, 0, 19475, 'VO_TT_Neptulon_Fight04');
  115. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  116. VALUES (40792, 7, 0, 'The beast has returned! It must not pollute my waters!', 1, 0, 0, 0, 0, 19476, 'VO_TT_Neptulon_Fight05');
  117. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  118. VALUES (40792, 8, 0, 'Behold the power of pure water!', 1, 0, 0, 0, 0, 19477, 'VO_TT_Neptulon_Fight06');
  119. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  120. VALUES (40792, 9, 0, 'My waters are cleansed! Drink in their power!', 1, 0, 0, 0, 0, 19478, 'VO_TT_Neptulon_Fight07');
  121. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  122. VALUES (40792, 10, 0, 'Your kind... cannot be... trusted...', 1, 0, 0, 0, 0, 19479, 'VO_TT_Neptulon_Fight08');
  123. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  124. VALUES (40792, 11, 0, 'You are unworthy of my domain!', 1, 0, 0, 0, 0, 19480, 'VO_TT_Neptulon_Fight09');
  125. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  126. VALUES (40792, 11, 1, 'My attention was wasted on you!', 1, 0, 0, 0, 0, 19481, 'VO_TT_Neptulon_Fight10');
  127. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  128. VALUES (40792, 12, 0, '', 1, 0, 0, 0, 0, 19482, 'VO_TT_Neptulon_Fight11');
  129. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  130. VALUES (40792, 13, 0, '', 1, 0, 0, 0, 0, 19483, 'VO_TT_Neptulon_Fight12');
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!