API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 11th, 2017
227
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
DIV 7.31 KB | None | 0 0
raw download clone embed print report
  1. diff --git a/addition/160_mangos_dalaran_arena.sql b/addition/160_mangos_dalaran_arena.sql
  2. index e12be23..e22a940 100644
  3. --- a/addition/160_mangos_dalaran_arena.sql
  4. +++ b/addition/160_mangos_dalaran_arena.sql
  5. @@ -1,17 +1,17 @@
  6.  delete FROM `gameobject` where `map` = 617;
  7.  insert into `gameobject` values
  8.  -- buffs
  9. -('200060','184663','617','1','1','1291.7','813.424','7.11472','4.64562','0','0','0.730314','-0.683111','-120','100','1'),
  10. -('200061','184664','617','1','1','1291.7','768.911','7.11472','1.55194','0','0','0.700409','0.713742','-120','100','1'),
  11. +('300060','184663','617','1','1','1291.7','813.424','7.11472','4.64562','0','0','0.730314','-0.683111','-120','100','1'),
  12. +('300061','184664','617','1','1','1291.7','768.911','7.11472','1.55194','0','0','0.700409','0.713742','-120','100','1'),
  13.  -- doors
  14. -('200062','192642','617','1','1','1350.95','817.2','21.4096','3.15','0','0','0.99627','0.0862864','86400','100','1'),
  15. -('200063','192643','617','1','1','1232.65','764.913','21.4729','6.3','0','0','0.0310211','-0.999519','86400','100','1');
  16. +('300062','192642','617','1','1','1350.95','817.2','21.4096','3.15','0','0','0.99627','0.0862864','86400','100','1'),
  17. +('300063','192643','617','1','1','1232.65','764.913','21.4729','6.3','0','0','0.0310211','-0.999519','86400','100','1');
  18.  
  19.  delete FROM `gameobject_battleground` where `guid` in (200060,200061,200062,200063);
  20.  insert into `gameobject_battleground` values
  21.  -- buffs
  22. -('200060','252','0'),
  23. -('200061','252','0'),
  24. +('300060','252','0'),
  25. +('300061','252','0'),
  26.  -- doors
  27.  ('200062','254','0'),
  28.  ('200063','254','0');
  29. diff --git a/addition/172_mangos_orgrimmar_arena.sql b/addition/172_mangos_orgrimmar_arena.sql
  30. index af53ac4..e2cc240 100644
  31. --- a/addition/172_mangos_orgrimmar_arena.sql
  32. +++ b/addition/172_mangos_orgrimmar_arena.sql
  33. @@ -1,24 +1,24 @@
  34.  delete FROM `gameobject` where `map` = 618;
  35.  insert into `gameobject` values
  36.  -- buffs
  37. -('200070','184663','618','1','1','735.551819','-284.794678','28.276682','0.034906','0','0','0','0','-120','100','1'),
  38. -('200071','184664','618','1','1','791.224487','-284.794464','28.276682','2.600535','0','0','0','0','-120','100','1'),
  39. +('300070','184663','618','1','1','735.551819','-284.794678','28.276682','0.034906','0','0','0','0','-120','100','1'),
  40. +('300071','184664','618','1','1','791.224487','-284.794464','28.276682','2.600535','0','0','0','0','-120','100','1'),
  41.  -- elevators
  42. -('200072','194582','618','1','1','763.536377','-294.535767','0.505383','3.141593','0','0','0','0','120','100','1'),
  43. -('200073','194586','618','1','1','763.506348','-273.873352','0.505383','0','0','0','0','0','120','100','1'),
  44. +('300072','194582','618','1','1','763.536377','-294.535767','0.505383','3.141593','0','0','0','0','120','100','1'),
  45. +('300073','194586','618','1','1','763.506348','-273.873352','0.505383','0','0','0','0','0','120','100','1'),
  46.  -- fire
  47. -('200074','192704','618','1','1','743.543457','-283.799469','28.286655','0','0','0','0','0','120','100','1'),
  48. -('200075','192705','618','1','1','782.971802','-283.799469','28.286655','0','0','0','0','0','120','100','1'),
  49. -('200076','192388','618','1','1','743.711060','-284.099609','27.542587','3.141593','0','0','0','0','120','100','1'),
  50. -('200077','192387','618','1','1','783.221252','-284.133362','27.535686','0','0','0','0','0','120','100','1'),
  51. +('300074','192704','618','1','1','743.543457','-283.799469','28.286655','0','0','0','0','0','120','100','1'),
  52. +('300075','192705','618','1','1','782.971802','-283.799469','28.286655','0','0','0','0','0','120','100','1'),
  53. +('300076','192388','618','1','1','743.711060','-284.099609','27.542587','3.141593','0','0','0','0','120','100','1'),
  54. +('300077','192387','618','1','1','783.221252','-284.133362','27.535686','0','0','0','0','0','120','100','1'),
  55.  -- gears
  56.  ('200078','192393','618','1','1','763.664551','-261.872986','26.686588','0','0','0','0','0','120','100','1'),
  57.  ('200079','192394','618','1','1','763.578979','-306.146149','26.665222','3.141593','0','0','0','0','120','100','1'),
  58.  -- pillars
  59. -('200080','194583','618','1','1','763.632385','-306.162384','25.909504','3.141593','0','0','0','0','120','100','1'),
  60. -('200081','194584','618','1','1','723.644287','-284.493256','24.648525','3.141593','0','0','0','0','120','100','1'),
  61. -('200082','194585','618','1','1','763.611145','-261.856750','25.909504','0','0','0','0','0','120','100','1'),
  62. -('200083','194587','618','1','1','802.211609','-284.493256','24.648525','0','0','0','0','0','120','100','1'),
  63. +('300080','194583','618','1','1','763.632385','-306.162384','25.909504','3.141593','0','0','0','0','120','100','1'),
  64. +('300081','194584','618','1','1','723.644287','-284.493256','24.648525','3.141593','0','0','0','0','120','100','1'),
  65. +('300082','194585','618','1','1','763.611145','-261.856750','25.909504','0','0','0','0','0','120','100','1'),
  66. +('300083','194587','618','1','1','802.211609','-284.493256','24.648525','0','0','0','0','0','120','100','1'),
  67.  /*
  68.  -- pillars collision (not work - should make you break LoS)
  69.  ('200084','194580','618','1','1','763.632385','-306.162384','30.639660','3.141593','0','0','0','0','120','100','1'),
  70. @@ -27,17 +27,17 @@ insert into `gameobject` values
  71.  ('200087','194578','618','1','1','802.211609','-284.493256','32.382710','3.141593','0','0','0','0','120','100','1');
  72.  */
  73.  -- pulley
  74. -('200088','192389','618','1','1','700.722290','-283.990662','39.517582','3.141593','0','0','0','0','120','100','1'),
  75. -('200089','192390','618','1','1','826.303833','-283.996429','39.517582','0','0','0','0','0','120','100','1');
  76. +('300088','192389','618','1','1','700.722290','-283.990662','39.517582','3.141593','0','0','0','0','120','100','1'),
  77. +('300089','192390','618','1','1','826.303833','-283.996429','39.517582','0','0','0','0','0','120','100','1');
  78.  
  79.  delete FROM `gameobject_battleground` where `guid` in (200070,200071,200072,200073);
  80.  insert into `gameobject_battleground` values
  81.  -- buffs
  82. -('200070','252','0'),
  83. -('200071','252','0'),
  84. +('300070','252','0'),
  85. +('300071','252','0'),
  86.  -- elevators
  87. -('200072','254','0'),
  88. -('200073','254','0');
  89. +('300072','254','0'),
  90. +('300073','254','0');
  91.  
  92.  delete FROM `battleground_events` where `map` = 618;
  93.  insert into `battleground_events` values
  94. diff --git a/addition/stcore_addition/S134_Strand_of_the_Ancients.sql b/addition/stcore_addition/S134_Strand_of_the_Ancients.sql
  95. index a2bc42d..a55f793 100644
  96. --- a/addition/stcore_addition/S134_Strand_of_the_Ancients.sql
  97. +++ b/addition/stcore_addition/S134_Strand_of_the_Ancients.sql
  98. @@ -18,8 +18,8 @@ DeleTe FROM `npc_spellclick_spells` WHERE npc_entry in (28781);
  99.  INSERT INTO `npc_spellclick_spells` VALUES ('28781', '60968', '0', '0', '0', '0');
  100.  
  101.  -- AP Cannon
  102. -UPDATE `creature_template` SET `npcflag` = '1', unit_flags = 8, minhealth = '60000', maxhealth = '60000', `faction_A` = '35', `faction_H` = '35', `ScriptName` = 'npc_sa_cannon' WHERE entry = '27894';
  103. -DeleTe FROM `npc_spellclick_spells` WHERE npc_entry in (27894);
  104. +UPDATE `creature_template` SET `npcflag` = '1', unit_flags = '4108', minhealth = '60000', maxhealth = '60000', `faction_A` = '35', `faction_H` = '35', `ScriptName` = 'npc_sa_cannon' WHERE entry = '27894';
  105. +DELETE FROM `npc_spellclick_spells` WHERE npc_entry in (27894);
  106.  INSERT INTO `npc_spellclick_spells` VALUES ('27894', '60968', '0', '0', '0', '0');
  107.  
  108.  DELETE FROM `gameobject` WHERE `guid` in (200001,200002,200003,200004,200005,200006,200007);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!