API tools faq
paste
Guest User

Untitled

a guest
Jun 18th, 2018
113
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 8.38 KB | None | 0 0
raw download clone embed print report
  1. /*NOTE! Included Cyrillic Fonts - open it in UTF8 coding*/
  2.  
  3. SET NAMES 'utf8';
  4.  
  5. DELETE FROM `trinity_string` WHERE entry IN (756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,780,781,782,783);
  6. INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES
  7. ('756', 'Battle begins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '????? ????????'),
  8. ('757', '%s has successfully defended the fortress!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '%s ??????? ???????(?) ????????!'),
  9. ('758', '%s has taken over the fortress!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '%s ????????(?) ????????'),
  10. ('759', 'The %s siege workshop has been damaged by the %s!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  11. ('760', 'The %s siege workshop has been destroyed by the %s!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  12. ('761', 'The %s tower has been damaged!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '%s ????? ??????????'),
  13. ('762', 'The %s tower has been destroyed!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '%s ????? ??????????!'),
  14. ('763', 'Wintergrasp fortress is under attack!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  15. ('764', 'Wintergrasp is now under the control of the %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  16. ('765', 'Wintergrasp timer set to %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  17. ('766', 'Wintergrasp battle started.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  18. ('767', 'Wintergrasp battle finished.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  19. ('768', 'Wintergrasp info: %s controlled. Timer: %s. Wartime: %s. Number of Players: (Horde: %u, Alliance: %u)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  20. ('769', 'Wintergrasp outdoorPvP is disabled.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  21. ('770', 'Wintergrasp outdoorPvP is enabled.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  22. ('771', 'You have reached Rank 1: Corporal', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '?? ???????? ????? 1: ??????'),
  23. ('772', 'You have reached Rank 2: First Lieutenant', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '?? ???????? ????? 2: ?????????'),
  24. ('780', '30 minutes left before the  Battle of Wintergrasp begins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '?? ????? ??  ????? ??????? ???? ???????? 30 ?????!'),
  25. ('781', '10 minutes left before the  Battle of Wintergrasp begins! Portal from Dalaran will work in 5 minutes.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '?? ????? ??  ????? ??????? ???? ???????? 10 ?????! ?????? ? ???????? ?????? ?????? ????? 5 ?????.'),
  26. ('782', 'The battle for Wintergrasp  has stopped! Not enough defenders. Wintergrasp Fortress remains  Attackers.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '????? ?? ????? ??????? ???? ???????????. ?? ??????? ??????????. ???????? ????????? ?????????  ???????.'),
  27. ('783', 'The battle for Wintergrasp  has stopped! Not enough attackers. Wintergrasp Fortress remains  Defenders.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '????? ?? ????? ??????? ???? ???????????. ?? ??????? ??????????. ???????? ???????? ??????????.');
  28.  
  29. DELETE FROM `command` WHERE name IN ('wg','wg enable','wg start','wg status','wg stop','wg switch','wg timer');
  30. INSERT INTO `command` (`name`, `security`, `help`) VALUES
  31. ('wg', '3', 'Syntax: .wg $subcommand.'),
  32. ('wg enable', '3', 'Syntax: .wg enable [on/off] Enable/Disable Wintergrasp outdoorPvP.'),
  33. ('wg start', '3', 'Syntax: .wg start\r\nForce Wintergrasp battle start.'),
  34. ('wg status', '3', 'Syntax: .wg status\r\nWintergrasp info, defender, timer, wartime.'),
  35. ('wg stop', '3', 'Syntax: .wg stop\r\nForce Wintergrasp battle stop (No rewards).'),
  36. ('wg switch', '3', 'Syntax: .wg switch\r\nSwitchs Wintergrasp defender team.'),
  37. ('wg timer', '3', 'Syntax: .wg timer $minutes\r\nChange the current timer. Min value = 1, Max value 60 (Wartime), 1440 (Not Wartime)');
  38.  
  39. /* WG scriptname */
  40. DELETE FROM `outdoorpvp_template` WHERE TypeId=7;
  41. INSERT INTO `outdoorpvp_template` (`TypeId`, `ScriptName`, `comment`) VALUES
  42. ('7', 'outdoorpvp_wg', 'Wintergrasp');
  43.  
  44. UPDATE `creature_template` SET `ScriptName` = 'npc_demolisher_engineerer' WHERE `entry` IN (30400,30499);
  45.  
  46. /* Teleport WG SPELLs*/
  47. DELETE FROM `spell_target_position` WHERE id IN ('59096', '58632', '58633');
  48. INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
  49. ('59096', '571', '5325.06', '2843.36', '409.285', '3.20278'),
  50. ('58632', '571', '5097.79', '2180.29', '365.61', '2.41'),
  51. ('58633', '571', '5026.80', '3676.69', '362.58', '3.94');
  52.  
  53. /* Defender's Portal Activate Proper Spell */
  54. DELETE FROM `spell_linked_spell` WHERE spell_trigger=54640;
  55. INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
  56. ('54640','54643','0','Defender\'s Portal Activate Proper Spell');
  57.  
  58. /* Temp removed gameobject stopping you getting to the relic
  59. * 194323 - [Wintergrasp Keep Collision Wall X:5396.209961 Y:2840.010010 Z:432.268005 MapId:571
  60. * 194162 - [Doodad_WG_Keep_Door01_collision01 X:5397.109863 Y:2841.540039 Z:425.901001 MapId:571]*/
  61. DELETE FROM gameobject WHERE id IN ('194323', '194162');
  62. UPDATE `gameobject_template` SET `type` = 6, `faction` = 0, `data2` = 10, `data3` = 54643, `ScriptName` = 'go_wg_veh_teleporter' WHERE `entry` = 192951;
  63.  
  64. /* Titan Relic remove */
  65. DELETE FROM `gameobject` WHERE `id`=192829;
  66.  
  67. /* Towers */
  68. UPDATE `gameobject_template` SET `faction` = 0, `flags` = 6553632 WHERE `entry` IN (190356,190357,190358);
  69.  
  70. /*Spirit healer FIX */
  71. UPDATE creature_template SET npcflag=npcflag|32768 WHERE entry IN (31841,31842);
  72.  
  73. /* Creature template */
  74. UPDATE creature_template SET faction_A = '1802', faction_H = '1802' WHERE entry IN (30499,28312,28319);
  75. UPDATE creature_template SET faction_A = '1801', faction_H = '1801' WHERE entry IN (30400,32629,32627);
  76. UPDATE creature_template SET npcflag=npcflag|32768 WHERE entry   IN (31841,31842);
  77.  
  78. /* spell target for build vehicles */
  79. DELETE FROM `conditions` WHERE ConditionValue2=27852;
  80. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  81. (13, 0, 49899, 0, 18, 1, 27852, 0, 0, '', NULL),
  82. (13, 0, 56575, 0, 18, 1, 27852, 0, 0, '', NULL),
  83. (13, 0, 56661, 0, 18, 1, 27852, 0, 0, '', NULL),
  84. (13, 0, 56663, 0, 18, 1, 27852, 0, 0, '', NULL),
  85. (13, 0, 56665, 0, 18, 1, 27852, 0, 0, '', NULL),
  86. (13, 0, 56667, 0, 18, 1, 27852, 0, 0, '', NULL),
  87. (13, 0, 56669, 0, 18, 1, 27852, 0, 0, '', NULL),
  88. (13, 0, 61408, 0, 18, 1, 27852, 0, 0, '', NULL);
  89.  
  90. /* Workshop */
  91. UPDATE `gameobject_template` SET `faction` = 35 WHERE `entry` IN (192028,192029,192030,192031,192032,192033);
  92.  
  93.  
  94. /*WG Spell area Data */
  95. /*For wg antifly */
  96. DELETE FROM `spell_area` WHERE spell IN (58730, 57940, 58045);
  97. INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`) VALUES
  98. (58730, 4197, 0, 0, 0, 0, 0, 2, 1),
  99. (58730, 4584, 0, 0, 0, 0, 0, 2, 1),
  100. (58730, 4581, 0, 0, 0, 0, 0, 2, 1),
  101. (58730, 4585, 0, 0, 0, 0, 0, 2, 1),
  102. (58730, 4612, 0, 0, 0, 0, 0, 2, 1),
  103. (58730, 4582, 0, 0, 0, 0, 0, 2, 1),
  104. (58730, 4611, 0, 0, 0, 0, 0, 2, 1),
  105. (58730, 4578, 0, 0, 0, 0, 0, 2, 1),
  106. (58730, 4576, 0, 0, 0, 0, 0, 2, 1),
  107. (58730, 4538, 0, 0, 0, 0, 0, 2, 1),
  108. (57940, 65, 0, 0, 0, 0, 0, 2, 1),
  109. (57940, 66, 0, 0, 0, 0, 0, 2, 1),
  110. (57940, 67, 0, 0, 0, 0, 0, 2, 1),
  111. (57940, 206, 0, 0, 0, 0, 0, 2, 1),
  112. (57940, 210, 0, 0, 0, 0, 0, 2, 1),
  113. (57940, 394, 0, 0, 0, 0, 0, 2, 1),
  114. (57940, 395, 0, 0, 0, 0, 0, 2, 1),
  115. (57940, 1196, 0, 0, 0, 0, 0, 2, 1),
  116. (57940, 2817, 0, 0, 0, 0, 0, 2, 1),
  117. (57940, 3456, 0, 0, 0, 0, 0, 2, 1),
  118. (57940, 3477, 0, 0, 0, 0, 0, 2, 1),
  119. (57940, 3537, 0, 0, 0, 0, 0, 2, 1),
  120. (57940, 3711, 0, 0, 0, 0, 0, 2, 1),
  121. (57940, 4100, 0, 0, 0, 0, 0, 2, 1),
  122. (57940, 4196, 0, 0, 0, 0, 0, 2, 1),
  123. (57940, 4228, 0, 0, 0, 0, 0, 2, 1),
  124. (57940, 4264, 0, 0, 0, 0, 0, 2, 1),
  125. (57940, 4265, 0, 0, 0, 0, 0, 2, 1),
  126. (57940, 4272, 0, 0, 0, 0, 0, 2, 1),
  127. (57940, 4273, 0, 0, 0, 0, 0, 2, 1),
  128. (57940, 4395, 0, 0, 0, 0, 0, 2, 1),
  129. (57940, 4415, 0, 0, 0, 0, 0, 2, 1),
  130. (57940, 4416, 0, 0, 0, 0, 0, 2, 1),
  131. (57940, 4493, 0, 0, 0, 0, 0, 2, 1),
  132. (57940, 4494, 0, 0, 0, 0, 0, 2, 1),
  133. (57940, 4603, 0, 0, 0, 0, 0, 2, 1),
  134. (58045, 4197, 0, 0, 0, 0, 0, 2, 1);
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!