1. -- Sql to create buff object pool for some BG
  3. -- Arathi bassin
  4. -- -------------
  6. -- Stable
  7. REPLACE INTO `gameobject` VALUES (150500, 179871, 529, 1, 1, 1185.71, 1185.24, -56.36, 2.56, 0, 0, 0.022338351, 0.999750467, 180, 100, 1);
  8. REPLACE INTO `gameobject` VALUES (150501, 179904, 529, 1, 1, 1185.71, 1185.24, -56.36, 2.56, 0, 0, 0.022338351, 0.999750467, 180, 100, 1);
  9. REPLACE INTO `gameobject` VALUES (150502, 179905, 529, 1, 1, 1185.71, 1185.24, -56.36, 2.56, 0, 0, 0.022338351, 0.999750467, 180, 100, 1);
  11. -- Blacksmith
  12. REPLACE INTO `gameobject` VALUES (150503, 179871, 529, 1, 1, 990.75, 1008.18, -42.60, 2.43, 0, 0, 0.021204161, 0.999775166, 180, 100, 1);
  13. REPLACE INTO `gameobject` VALUES (150504, 179904, 529, 1, 1, 990.75, 1008.18, -42.60, 2.43, 0, 0, 0.021204161, 0.999775166, 180, 100, 1);
  14. REPLACE INTO `gameobject` VALUES (150505, 179905, 529, 1, 1, 990.75, 1008.18, -42.60, 2.43, 0, 0, 0.021204161, 0.999775166, 180, 100, 1);
  16. -- Farm
  17. REPLACE INTO `gameobject` VALUES (150506, 179871, 529, 1, 1, 817.66, 843.34, -56.54, 3.01, 0, 0, 0.026264184, 0.999655036, 180, 100, 1);
  18. REPLACE INTO `gameobject` VALUES (150507, 179904, 529, 1, 1, 817.66, 843.34, -56.54, 3.01, 0, 0, 0.026264184, 0.999655036, 180, 100, 1);
  19. REPLACE INTO `gameobject` VALUES (150508, 179905, 529, 1, 1, 817.66, 843.34, -56.54, 3.01, 0, 0, 0.026264184, 0.999655036, 180, 100, 1);
  21. -- Lumber Mill
  22. REPLACE INTO `gameobject` VALUES (150509, 179871, 529, 1, 1, 807.46, 1189.16, 11.92, 5.44, 0, 0, 0.047455126, 0.998873370, 180, 100, 1);
  23. REPLACE INTO `gameobject` VALUES (150510, 179904, 529, 1, 1, 807.46, 1189.16, 11.92, 5.44, 0, 0, 0.047455126, 0.998873370, 180, 100, 1);
  24. REPLACE INTO `gameobject` VALUES (150511, 179905, 529, 1, 1, 807.46, 1189.16, 11.92, 5.44, 0, 0, 0.047455126, 0.998873370, 180, 100, 1);
  26. -- Gold Mine
  27. REPLACE INTO `gameobject` VALUES (150512, 179871, 529, 1, 1, 1146.62, 816.94, -98.49, 6.0, 0, 0, 0.053555973, 0.998564849, 180, 100, 1);
  28. REPLACE INTO `gameobject` VALUES (150513, 179904, 529, 1, 1, 1146.62, 816.94, -98.49, 6.0, 0, 0, 0.053555973, 0.998564849, 180, 100, 1);
  29. REPLACE INTO `gameobject` VALUES (150514, 179905, 529, 1, 1, 1146.62, 816.94, -98.49, 6.0, 0, 0, 0.053555973, 0.998564849, 180, 100, 1);
  31. -- Add pool id
  32. REPLACE INTO `pool_template` VALUES (15000, 1, "Stable power up buff");
  33. REPLACE INTO `pool_template` VALUES (15001, 1, "Blacksmith power up buff");
  34. REPLACE INTO `pool_template` VALUES (15002, 1, "Farm power up buff");
  35. REPLACE INTO `pool_template` VALUES (15003, 1, "Lumber Mill power up buff");
  36. REPLACE INTO `pool_template` VALUES (15004, 1, "Gold Mine power up buff");
  38. -- Add Stable pool
  39. REPLACE INTO `pool_gameobject` VALUES (150500, 15000, 0, "Stable : Speed buff");
  40. REPLACE INTO `pool_gameobject` VALUES (150501, 15000, 0, "Stable : Regen buff");
  41. REPLACE INTO `pool_gameobject` VALUES (150502, 15000, 0, "Stable : Berserker buff");
  43. -- Add Blacksmith pool
  44. REPLACE INTO `pool_gameobject` VALUES (150503, 15001, 0, "Blacksmith : Speed buff");
  45. REPLACE INTO `pool_gameobject` VALUES (150504, 15001, 0, "Blacksmith : Regen buff");
  46. REPLACE INTO `pool_gameobject` VALUES (150505, 15001, 0, "Blacksmith : Berserker buff");
  48. -- Add Farm pool
  49. REPLACE INTO `pool_gameobject` VALUES (150506, 15002, 0, "Farm : Speed buff");
  50. REPLACE INTO `pool_gameobject` VALUES (150507, 15002, 0, "Farm : Regen buff");
  51. REPLACE INTO `pool_gameobject` VALUES (150508, 15002, 0, "Farm : Berserker buff");
  53. -- Add Lumber Mill pool
  54. REPLACE INTO `pool_gameobject` VALUES (150509, 15003, 0, "Lumber Mill : Speed buff");
  55. REPLACE INTO `pool_gameobject` VALUES (150510, 15003, 0, "Lumber Mill : Regen buff");
  56. REPLACE INTO `pool_gameobject` VALUES (150511, 15003, 0, "Lumber Mill : Berserker buff");
  58. -- Add Gold Mine pool
  59. REPLACE INTO `pool_gameobject` VALUES (150512, 15004, 0, "Gold Mine : Speed buff");
  60. REPLACE INTO `pool_gameobject` VALUES (150513, 15004, 0, "Gold Mine : Regen buff");
  61. REPLACE INTO `pool_gameobject` VALUES (150514, 15004, 0, "Gold Mine : Berserker buff");
  63. -- Eye of Storm
  64. -- ------------
  66. -- Blood Elf Tower
  67. REPLACE INTO `gameobject` VALUES (150550, 179871, 566, 1, 1, 2050.4599609375, 1372.26000976563, 1194.56005859375, 0.907571, 0, 0, 0.438371, 0.898794, 180, 100, 1);
  68. REPLACE INTO `gameobject` VALUES (150551, 179904, 566, 1, 1, 2050.4599609375, 1372.26000976563, 1194.56005859375, 0.907571, 0, 0, 0.438371, 0.898794, 180, 100, 1);
  69. REPLACE INTO `gameobject` VALUES (150552, 179905, 566, 1, 1, 2050.4599609375, 1372.26000976563, 1194.56005859375, 0.907571, 0, 0, 0.438371, 0.898794, 180, 100, 1);
  71. -- Fel REaver Ruins Tower
  72. REPLACE INTO `gameobject` VALUES (150553, 179871, 566, 1, 1, 2046.32995605469, 1748.81005859375, 1190.03002929688, 0.907571, 0, 0, 0.438371, 0.898794, 180, 100, 1);
  73. REPLACE INTO `gameobject` VALUES (150554, 179904, 566, 1, 1, 2046.32995605469, 1748.81005859375, 1190.03002929688, 0.907571, 0, 0, 0.438371, 0.898794, 180, 100, 1);
  74. REPLACE INTO `gameobject` VALUES (150555, 179905, 566, 1, 1, 2046.32995605469, 1748.81005859375, 1190.03002929688, 0.907571, 0, 0, 0.438371, 0.898794, 180, 100, 1);
  76. -- Mage Tower
  77. REPLACE INTO `gameobject` VALUES (150556, 179871, 566, 1, 1, 2283.3798828125, 1748.81005859375, 1189.7099609375, 0.907571, 0, 0, 0.438371, 0.898794, 180, 100, 1);
  78. REPLACE INTO `gameobject` VALUES (150557, 179904, 566, 1, 1, 2283.3798828125, 1748.81005859375, 1189.7099609375, 0.907571, 0, 0, 0.438371, 0.898794, 180, 100, 1);
  79. REPLACE INTO `gameobject` VALUES (150558, 179905, 566, 1, 1, 2283.3798828125, 1748.81005859375, 1189.7099609375, 0.907571, 0, 0, 0.438371, 0.898794, 180, 100, 1);
  81. -- Draenei Ruins Tower
  82. REPLACE INTO `gameobject` VALUES (150559, 179871, 566, 1, 1, 2302.68994140625, 1391.27001953125, 1197.77001953125, 0.907571, 0, 0, 0.438371, 0.898794, 180, 100, 1);
  83. REPLACE INTO `gameobject` VALUES (150560, 179904, 566, 1, 1, 2302.68994140625, 1391.27001953125, 1197.77001953125, 0.907571, 0, 0, 0.438371, 0.898794, 180, 100, 1);
  84. REPLACE INTO `gameobject` VALUES (150561, 179905, 566, 1, 1, 2302.68994140625, 1391.27001953125, 1197.77001953125, 0.907571, 0, 0, 0.438371, 0.898794, 180, 100, 1);
  86. -- Add pool id
  87. REPLACE INTO `pool_template` VALUES (15010, 1, "Blood Elf Tower power up buff");
  88. REPLACE INTO `pool_template` VALUES (15011, 1, "Fel Reaver Ruins Tower power up buff");
  89. REPLACE INTO `pool_template` VALUES (15012, 1, "Mage Tower power up buff");
  90. REPLACE INTO `pool_template` VALUES (15013, 1, "Dreanei Ruins Tower power up buff");
  92. -- Add Blood Elf Tower pool
  93. REPLACE INTO `pool_gameobject` VALUES (150550, 15010, 0, "Blood Elf Tower : Speed buff");
  94. REPLACE INTO `pool_gameobject` VALUES (150551, 15010, 0, "Blood Elf Tower : Regen buff");
  95. REPLACE INTO `pool_gameobject` VALUES (150552, 15010, 0, "Blood Elf Tower : Berserker buff");
  97. -- Add Fel Reaver Ruins Tower pool
  98. REPLACE INTO `pool_gameobject` VALUES (150553, 15011, 0, "Fel Reaver Ruins Tower : Speed buff");
  99. REPLACE INTO `pool_gameobject` VALUES (150554, 15011, 0, "Fel Reaver Ruins Tower : Regen buff");
  100. REPLACE INTO `pool_gameobject` VALUES (150555, 15011, 0, "Fel Reaver Ruins Tower : Berserker buff");
  102. -- Add Mage Tower pool
  103. REPLACE INTO `pool_gameobject` VALUES (150556, 15012, 0, "Mage Tower : Speed buff");
  104. REPLACE INTO `pool_gameobject` VALUES (150557, 15012, 0, "Mage Tower : Regen buff");
  105. REPLACE INTO `pool_gameobject` VALUES (150558, 15012, 0, "Mage Tower : Berserker buff");
  107. -- Add Dreanei Ruins Tower pool
  108. REPLACE INTO `pool_gameobject` VALUES (150559, 15013, 0, "Dreanei Ruins Tower : Speed buff");
  109. REPLACE INTO `pool_gameobject` VALUES (150560, 15013, 0, "Dreanei Ruins Tower : Regen buff");
  110. REPLACE INTO `pool_gameobject` VALUES (150561, 15013, 0, "Dreanei Ruins Tower : Berserker buff");