API tools faq
paste
Pelf

bastion of twilight sql

Pelf
Feb 21st, 2012
231
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 11.06 KB | None | 0 0
raw download clone embed print report
  1. #база
  2. DELETE FROM `gameobject` WHERE `id` IN (205087, 205088) AND `map` = 671;
  3. DELETE FROM `creature` WHERE `id` IN (46374, 46448, 46364, 46588) AND `map` = 671;
  4.  
  5. UPDATE `gameobject_template` SET `flags`=4 WHERE `entry`=205087;
  6. UPDATE `gameobject_template` SET `flags`=4 WHERE `entry`=205088;
  7. UPDATE `gameobject_template` SET `flags`=4 WHERE `entry`=205222;
  8. UPDATE `gameobject_template` SET `flags`=4 WHERE `entry`=205223;
  9. UPDATE `gameobject_template` SET `flags`=4 WHERE `entry`=205224;
  10. UPDATE `gameobject_template` SET `flags`=4 WHERE `entry`=205225;
  11. UPDATE `gameobject_template` SET `flags`=4 WHERE `entry`=205226;
  12. UPDATE `gameobject_template` SET `flags`=4 WHERE `entry`=205227;
  13.  
  14. UPDATE `gameobject` SET `state` = 0 WHERE `id` IN (205222, 205223, 205224, 205225, 205226, 205227);
  15.  
  16. UPDATE `creature_template` SET `flags_extra` = 128 WHERE `entry`=46374;
  17. UPDATE `creature_template` SET `flags_extra` = 128 WHERE `entry`=46448;
  18. UPDATE `creature_template` SET `faction_A`=16, `faction_H`=16 WHERE `entry`=44687;
  19.  
  20. UPDATE `creature` SET `position_x`=-289.01, `position_y`=-711.88, `orientation`=5.45 WHERE `id`=44600;
  21.  
  22. #скрипты
  23. UPDATE `instance_template` SET `script`='instance_bastion_of_twilight' WHERE `map`=671;
  24. UPDATE `creature_template` SET `ScriptName`='npc_halfus_dragon' WHERE `entry`=44645;
  25. UPDATE `creature_template` SET `ScriptName`='npc_halfus_dragon' WHERE `entry`=44650;
  26. UPDATE `creature_template` SET `ScriptName`='npc_halfus_dragon' WHERE `entry`=44652;
  27. UPDATE `creature_template` SET `ScriptName`='npc_halfus_dragon' WHERE `entry`=44797;
  28. UPDATE `creature_template` SET `ScriptName`='npc_orphaned_whelp' WHERE `entry`=44641;
  29. UPDATE `creature_template` SET `ScriptName`='npc_proto_behemoth' WHERE `entry`=44687;
  30. UPDATE `gameobject_template` SET `ScriptName`='go_whelp_cage' WHERE `entry`=205087;
  31.  
  32. UPDATE `creature_template` SET `ScriptName`='npc_dazzling_destruction_stalker' WHERE `entry`=46374;
  33. UPDATE `creature_template` SET `ScriptName`='npc_fabolous_flames' WHERE `entry`=46448;
  34. UPDATE `creature_template` SET `ScriptName`='npc_twilight_flames' WHERE `entry`=40718;
  35.  
  36. #спеллы
  37. DELETE FROM `conditions` WHERE `SourceEntry` = 83609;
  38. DELETE FROM `conditions` WHERE `SourceEntry` = 87683;
  39. DELETE FROM `conditions` WHERE `SourceEntry` = 84092;
  40. DELETE FROM `conditions` WHERE `SourceEntry` = 83601;
  41. DELETE FROM `conditions` WHERE `SourceEntry` = 83603;
  42. DELETE FROM `conditions` WHERE `SourceEntry` = 83611;
  43. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  44. VALUES ('13', '0', '83609', '0', '18', '1', '44687', '0', '0', '', 'Atrophic poison');
  45. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  46. VALUES ('13', '0', '87683', '0', '18', '1', '44600', '0', '0', '', 'Dragon vengeance');
  47. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`)
  48. VALUES ('13', '0', '84092', '0', '18', '1', '44600', '0', '0', '', 'Cyclone winds');
  49. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`)
  50. VALUES ('13', '0', '83601', '0', '18', '1', '44687', '0', '0', '', 'Time dilaton');
  51. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`)
  52. VALUES ('13', '0', '83603', '0', '18', '1', '44600', '0', '0', '', 'Stone grip');
  53. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`)
  54. VALUES ('13', '0', '83611', '0', '18', '1', '44600', '0', '0', '', 'Nether blindness');
  55. DELETE FROM `spell_script_names` WHERE `spell_id` = 83719;
  56. DELETE FROM `spell_script_names` WHERE `spell_id` = 83603;
  57. DELETE FROM `spell_script_names` WHERE `spell_id` = 86788;
  58. DELETE FROM `spell_script_names` WHERE `spell_id` = 92876;
  59. DELETE FROM `spell_script_names` WHERE `spell_id` = 92877;
  60. DELETE FROM `spell_script_names` WHERE `spell_id` = 92878;
  61. DELETE FROM `spell_script_names` WHERE `spell_id` = 86408;
  62. DELETE FROM `spell_script_names` WHERE `spell_id` = 88518;
  63. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (83603, 'spell_halfus_stone_grip');
  64. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (83719, 'spell_halfus_fireball_barrage');
  65. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (86788, 'spell_valiona_blackout');
  66. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (92876, 'spell_valiona_blackout');
  67. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (92877, 'spell_valiona_blackout');
  68. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (92878, 'spell_valiona_blackout');
  69. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (88518, 'spell_valiona_twilight_meteorite');
  70. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (86408, 'spell_theralion_dazzling_destruction');
  71.  
  72. #тексты
  73.  
  74. DELETE FROM `creature_text` WHERE `entry` = 44600;
  75. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  76. VALUES (44600, 0, 0, 'Cho\'gall will have your heads! ALL OF THEM!', 1, 0, 0, 0, 0, 20186, 'VO_BT_Halfus_Event01');
  77. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  78. VALUES (44600, 1, 0, 'The wyrms will eat well tonight!', 1, 0, 0, 0, 0, 20187, 'VO_BT_Halfus_Event03');
  79. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  80. VALUES (44600, 2, 0, 'The burden of the damned falls upon you!', 1, 0, 0, 0, 0, 20188, 'VO_BT_Halfus_Event02');
  81.  
  82. #чогалл
  83. DELETE FROM `creature_text` WHERE `entry` = 43324;
  84. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  85. VALUES (43324, 1, 0, 'Halfus! Hear me! (The Master calls, the Master wants) Protect our secrets, Halfus. Destroy the intruders. (Murder for His glory. Murder for His hunger.)', 1, 0, 0, 0, 0, 22055, 'vo_bt_chogall_botevent02');
  86. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  87. VALUES (43324, 2, 0, 'Flesh and sinew, weak but proud. Dare they part the Master''s shroud? They stumble fumble groping blind, Finding fate and chaos intertwined.', 1, 0, 0, 0, 0, 22056, 'vo_bt_chogall_botevent03');
  88. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  89. VALUES (43324, 9, 0, 'Valiona, Theralion, put them in their place.', 1, 0, 0, 0, 0, 22063, 'vo_bt_chogall_botevent10');
  90.  
  91. #тералион
  92. DELETE FROM `creature_text` WHERE `entry` = 45993;
  93. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  94. VALUES (45993, 0, 0, 'The master was clearly speaking to you, Valiona. I am far too busy to attack ANYONE.', 1, 0, 0, 0, 0, 20300, 'VO_BT_Theralion_Event01');
  95. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  96. VALUES (45993, 1, 0, 'How dare you call me worthless! You will see why I am Mothers favored child!', 1, 0, 0, 0, 0, 20301, 'VO_BT_Theralion_Event02');
  97. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  98. VALUES (45993, 2, 0, 'Bare your soul to me, mortal.', 1, 0, 0, 0, 0, 20302, 'VO_BT_Theralion_Event03');
  99. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  100. VALUES (45993, 3, 0, 'I knew I should have stayed out of this...', 1, 0, 0, 0, 0, 20303, 'VO_BT_Theralion_Event04');
  101. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  102. VALUES (45993, 4, 0, 'You are not the boss of me Valiona! I will engulf as I please!', 1, 0, 0, 0, 0, 20304, 'VO_BT_Theralion_Event05');
  103. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  104. VALUES (45993, 5, 0, 'There is no escape from the fury of the Twilight Flight!', 1, 0, 0, 0, 0, 20305, 'VO_BT_Theralion_Event06');
  105. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  106. VALUES (45993, 6, 0, 'Writhe in AGONY!', 1, 0, 0, 0, 0, 20306, 'VO_BT_Theralion_Event07');
  107. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  108. VALUES (45993, 7, 0, 'Theralion cackles maniacally.', 2, 0, 0, 0, 0, 20307, 'VO_BT_Theralion_Laugh1');
  109.  
  110.  
  111. #валиона
  112. DELETE FROM `creature_text` WHERE `entry` = 45992;
  113. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  114. VALUES (45992, 0, 0, 'Do as the master commands, Theralion! Kill them!', 1, 0, 0, 0, 0, 21894, 'VO_BT_Valiona_Event01');
  115. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  116. VALUES (45992, 1, 0, 'You are worthless, Theralion!', 1, 0, 0, 0, 0, 21895, 'VO_BT_Valiona_Event02');
  117. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  118. VALUES (45992, 2, 0, 'Breathe your dying breath!', 1, 0, 0, 0, 0, 21896, 'VO_BT_Valiona_Event03');
  119. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  120. VALUES (45992, 3, 0, 'At least Theralion dies with me...', 1, 0, 0, 0, 0, 21897, 'VO_BT_Valiona_Event04');
  121. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  122. VALUES (45992, 4, 0, 'Theralion! I will engulf the Hallway! Cover their escape!', 1, 0, 0, 0, 0, 21898, 'VO_BT_Valiona_Event05');
  123. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`)
  124. VALUES (45992, 5, 0, 'Enter Twilight!', 1, 0, 0, 0, 0, 21899, 'VO_BT_Valiona_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!