Advertisement
Guest User

Untitled

a guest
Jul 17th, 2019
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 5.66 KB | None | 0 0
  1. UPDATE `pool_members` SET `poolSpawnId`=3310 WHERE `type`=1 AND `SpawnId` IN (69260,69261,69262,69263,69264,69265);
  2. UPDATE `pool_members` SET `poolSpawnId`=3410 WHERE `type`=1 AND `SpawnId` IN (69860,69861,69862,69863,69864,69865);
  3. UPDATE `pool_members` SET `poolSpawnId`=3210 WHERE `type`=1 AND `SpawnId` IN (68660,68661,68662,68663,68664,68665);
  4.  
  5. DELETE FROM `pool_members` WHERE `poolSpawnId` IN (9907) AND `spawnId` IN (11150, 11151, 11152,11153,11154,11155,11156,11157,11158,11159,11160, 11161, 11162,11163,11164,11165,11166,11167,11168,11169,11170, 11171, 11172,11173,11174,11175,11176,11177,11178,11179,11180, 11181, 11182,11183,11184,11185,11186,11187,11188,11189,11190, 11191, 11192,11193,11194,11195,11196,11197,11198,11199,11200, 11201, 11202,11203,11204,11205,11206,11207,11208,11209,11210, 11211, 11212,11213,11214,11215,11216,11217,11218,11219,11220, 11221, 11222,11223,11224,11225,11226,11227,11228,11229,11230, 11231, 11232,11233,11234,11235,11236,11237,11238,11239,11240, 11241, 11242,11243,11244,11245,11246,11247,11248,11249,11250, 11251, 11252,11253,11254,11255,11256,11257,11258,11259,11389) AND `type`=2;
  6. INSERT INTO `pool_members` (`type`, `spawnId`, `poolSpawnId`, `chance`, `description`) VALUES
  7. (2, 11150, 9907, 0, 'Storm Peaks Ore'),
  8. (2, 11151, 9907, 0, 'Storm Peaks Ore'),
  9. (2, 11152, 9907, 0, 'Storm Peaks Ore'),
  10. (2, 11153, 9907, 0, 'Storm Peaks Ore'),
  11. (2, 11154, 9907, 0, 'Storm Peaks Ore'),
  12. (2, 11155, 9907, 0, 'Storm Peaks Ore'),
  13. (2, 11156, 9907, 0, 'Storm Peaks Ore'),
  14. (2, 11157, 9907, 0, 'Storm Peaks Ore'),
  15. (2, 11158, 9907, 0, 'Storm Peaks Ore'),
  16. (2, 11159, 9907, 0, 'Storm Peaks Ore'),
  17. (2, 11160, 9907, 0, 'Storm Peaks Ore'),
  18. (2, 11161, 9907, 0, 'Storm Peaks Ore'),
  19. (2, 11162, 9907, 0, 'Storm Peaks Ore'),
  20. (2, 11163, 9907, 0, 'Storm Peaks Ore'),
  21. (2, 11164, 9907, 0, 'Storm Peaks Ore'),
  22. (2, 11165, 9907, 0, 'Storm Peaks Ore'),
  23. (2, 11166, 9907, 0, 'Storm Peaks Ore'),
  24. (2, 11167, 9907, 0, 'Storm Peaks Ore'),
  25. (2, 11168, 9907, 0, 'Storm Peaks Ore'),
  26. (2, 11169, 9907, 0, 'Storm Peaks Ore'),
  27. (2, 11170, 9907, 0, 'Storm Peaks Ore'),
  28. (2, 11171, 9907, 0, 'Storm Peaks Ore'),
  29. (2, 11172, 9907, 0, 'Storm Peaks Ore'),
  30. (2, 11173, 9907, 0, 'Storm Peaks Ore'),
  31. (2, 11174, 9907, 0, 'Storm Peaks Ore'),
  32. (2, 11175, 9907, 0, 'Storm Peaks Ore'),
  33. (2, 11176, 9907, 0, 'Storm Peaks Ore'),
  34. (2, 11177, 9907, 0, 'Storm Peaks Ore'),
  35. (2, 11178, 9907, 0, 'Storm Peaks Ore'),
  36. (2, 11179, 9907, 0, 'Storm Peaks Ore'),
  37. (2, 11180, 9907, 0, 'Storm Peaks Ore'),
  38. (2, 11181, 9907, 0, 'Storm Peaks Ore'),
  39. (2, 11182, 9907, 0, 'Storm Peaks Ore'),
  40. (2, 11183, 9907, 0, 'Storm Peaks Ore'),
  41. (2, 11184, 9907, 0, 'Storm Peaks Ore'),
  42. (2, 11185, 9907, 0, 'Storm Peaks Ore'),
  43. (2, 11186, 9907, 0, 'Storm Peaks Ore'),
  44. (2, 11187, 9907, 0, 'Storm Peaks Ore'),
  45. (2, 11188, 9907, 0, 'Storm Peaks Ore'),
  46. (2, 11189, 9907, 0, 'Storm Peaks Ore'),
  47. (2, 11190, 9907, 0, 'Storm Peaks Ore'),
  48. (2, 11191, 9907, 0, 'Storm Peaks Ore'),
  49. (2, 11192, 9907, 0, 'Storm Peaks Ore'),
  50. (2, 11193, 9907, 0, 'Storm Peaks Ore'),
  51. (2, 11194, 9907, 0, 'Storm Peaks Ore'),
  52. (2, 11195, 9907, 0, 'Storm Peaks Ore'),
  53. (2, 11196, 9907, 0, 'Storm Peaks Ore'),
  54. (2, 11197, 9907, 0, 'Storm Peaks Ore'),
  55. (2, 11198, 9907, 0, 'Storm Peaks Ore'),
  56. (2, 11199, 9907, 0, 'Storm Peaks Ore'),
  57. (2, 11200, 9907, 0, 'Storm Peaks Ore'),
  58. (2, 11201, 9907, 0, 'Storm Peaks Ore'),
  59. (2, 11202, 9907, 0, 'Storm Peaks Ore'),
  60. (2, 11203, 9907, 0, 'Storm Peaks Ore'),
  61. (2, 11204, 9907, 0, 'Storm Peaks Ore'),
  62. (2, 11205, 9907, 0, 'Storm Peaks Ore'),
  63. (2, 11206, 9907, 0, 'Storm Peaks Ore'),
  64. (2, 11207, 9907, 0, 'Storm Peaks Ore'),
  65. (2, 11208, 9907, 0, 'Storm Peaks Ore'),
  66. (2, 11209, 9907, 0, 'Storm Peaks Ore'),
  67. (2, 11210, 9907, 0, 'Storm Peaks Ore'),
  68. (2, 11211, 9907, 0, 'Storm Peaks Ore'),
  69. (2, 11212, 9907, 0, 'Storm Peaks Ore'),
  70. (2, 11213, 9907, 0, 'Storm Peaks Ore'),
  71. (2, 11214, 9907, 0, 'Storm Peaks Ore'),
  72. (2, 11215, 9907, 0, 'Storm Peaks Ore'),
  73. (2, 11216, 9907, 0, 'Storm Peaks Ore'),
  74. (2, 11217, 9907, 0, 'Storm Peaks Ore'),
  75. (2, 11218, 9907, 0, 'Storm Peaks Ore'),
  76. (2, 11219, 9907, 0, 'Storm Peaks Ore'),
  77. (2, 11220, 9907, 0, 'Storm Peaks Ore'),
  78. (2, 11221, 9907, 0, 'Storm Peaks Ore'),
  79. (2, 11222, 9907, 0, 'Storm Peaks Ore'),
  80. (2, 11223, 9907, 0, 'Storm Peaks Ore'),
  81. (2, 11224, 9907, 0, 'Storm Peaks Ore'),
  82. (2, 11225, 9907, 0, 'Storm Peaks Ore'),
  83. (2, 11226, 9907, 0, 'Storm Peaks Ore'),
  84. (2, 11227, 9907, 0, 'Storm Peaks Ore'),
  85. (2, 11228, 9907, 0, 'Storm Peaks Ore'),
  86. (2, 11229, 9907, 0, 'Storm Peaks Ore'),
  87. (2, 11230, 9907, 0, 'Storm Peaks Ore'),
  88. (2, 11231, 9907, 0, 'Storm Peaks Ore'),
  89. (2, 11232, 9907, 0, 'Storm Peaks Ore'),
  90. (2, 11233, 9907, 0, 'Storm Peaks Ore'),
  91. (2, 11234, 9907, 0, 'Storm Peaks Ore'),
  92. (2, 11235, 9907, 0, 'Storm Peaks Ore'),
  93. (2, 11236, 9907, 0, 'Storm Peaks Ore'),
  94. (2, 11237, 9907, 0, 'Storm Peaks Ore'),
  95. (2, 11238, 9907, 0, 'Storm Peaks Ore'),
  96. (2, 11239, 9907, 0, 'Storm Peaks Ore'),
  97. (2, 11240, 9907, 0, 'Storm Peaks Ore'),
  98. (2, 11241, 9907, 0, 'Storm Peaks Ore'),
  99. (2, 11242, 9907, 0, 'Storm Peaks Ore'),
  100. (2, 11243, 9907, 0, 'Storm Peaks Ore'),
  101. (2, 11244, 9907, 0, 'Storm Peaks Ore'),
  102. (2, 11245, 9907, 0, 'Storm Peaks Ore'),
  103. (2, 11246, 9907, 0, 'Storm Peaks Ore'),
  104. (2, 11247, 9907, 0, 'Storm Peaks Ore'),
  105. (2, 11248, 9907, 0, 'Storm Peaks Ore'),
  106. (2, 11249, 9907, 0, 'Storm Peaks Ore'),
  107. (2, 11250, 9907, 0, 'Storm Peaks Ore'),
  108. (2, 11251, 9907, 0, 'Storm Peaks Ore'),
  109. (2, 11252, 9907, 0, 'Storm Peaks Ore'),
  110. (2, 11253, 9907, 0, 'Storm Peaks Ore'),
  111. (2, 11254, 9907, 0, 'Storm Peaks Ore'),
  112. (2, 11255, 9907, 0, 'Storm Peaks Ore'),
  113. (2, 11256, 9907, 0, 'Storm Peaks Ore'),
  114. (2, 11257, 9907, 0, 'Storm Peaks Ore'),
  115. (2, 11258, 9907, 0, 'Storm Peaks Ore'),
  116. (2, 11259, 9907, 0, 'Storm Peaks Ore'),
  117. (2, 11389, 9907, 0, 'Storm Peaks Ore');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement