SHARE
TWEET

Untitled

a guest Jul 11th, 2017 135 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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);
RAW Paste Data
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!
 
Top