clanhall_siege_guards.sql 38 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785
  1. DROP TABLE IF EXISTS `clanhall_siege_guards`;
  2. CREATE TABLE IF NOT EXISTS `clanhall_siege_guards` (
  3. `clanHallId` tinyint(2) unsigned NOT NULL DEFAULT '0',
  4. `npcId` smallint(5) unsigned NOT NULL DEFAULT '0',
  5. `x` mediumint(6) NOT NULL DEFAULT '0',
  6. `y` mediumint(6) NOT NULL DEFAULT '0',
  7. `z` mediumint(6) NOT NULL DEFAULT '0',
  8. `heading` mediumint(6) NOT NULL DEFAULT '0',
  9. `respawnDelay` mediumint(5) NOT NULL DEFAULT '0',
  10. `isSiegeBoss` enum('false','true') NOT NULL DEFAULT 'false',
  11. KEY `clanHallId` (`clanHallId`)
  12. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  13. INSERT INTO `clanhall_siege_guards` VALUES
  14. -- Devasted Castle
  15. -- Front Gate
  16. (34,35408,178306,-17535,-2200,32768,7200,'false'),
  17. (34,35409,178304,-17712,-2200,32768,7200,'false'),
  18. (34,35413,178222,-14944,-2200,16384,7200,'false'),
  19. (34,35413,178255,-14944,-2200,16384,7200,'false'),
  20. (34,35413,178288,-14944,-2200,16384,7200,'false'),
  21. (34,35413,178321,-14944,-2200,16384,7200,'false'),
  22. (34,35413,178354,-14944,-2200,16384,7200,'false'),
  23. (34,35413,178387,-14944,-2200,16384,7200,'false'),
  24. (34,35413,178420,-14944,-2200,16384,7200,'false'),
  25. (34,35413,178454,-14944,-2200,16384,7200,'false'),
  26. (34,35413,178222,-14924,-2200,16384,7200,'false'),
  27. (34,35413,178255,-14924,-2200,16384,7200,'false'),
  28. (34,35413,178288,-14924,-2200,16384,7200,'false'),
  29. (34,35413,178321,-14924,-2200,16384,7200,'false'),
  30. (34,35413,178354,-14924,-2200,16384,7200,'false'),
  31. (34,35413,178387,-14924,-2200,16384,7200,'false'),
  32. (34,35413,178420,-14924,-2200,16384,7200,'false'),
  33. (34,35413,178454,-14924,-2200,16384,7200,'false'),
  34. (34,35412,178222,-14904,-2200,16384,7200,'false'),
  35. (34,35412,178255,-14904,-2200,16384,7200,'false'),
  36. (34,35412,178288,-14904,-2200,16384,7200,'false'),
  37. (34,35412,178321,-14904,-2200,16384,7200,'false'),
  38. (34,35412,178354,-14904,-2200,16384,7200,'false'),
  39. (34,35412,178387,-14904,-2200,16384,7200,'false'),
  40. (34,35412,178420,-14904,-2200,16384,7200,'false'),
  41. (34,35412,178454,-14904,-2200,16384,7200,'false'),
  42. (34,35412,178222,-14884,-2200,16384,7200,'false'),
  43. (34,35412,178255,-14884,-2200,16384,7200,'false'),
  44. (34,35412,178288,-14884,-2200,16384,7200,'false'),
  45. (34,35412,178321,-14884,-2200,16384,7200,'false'),
  46. (34,35412,178354,-14884,-2200,16384,7200,'false'),
  47. (34,35412,178387,-14884,-2200,16384,7200,'false'),
  48. (34,35412,178420,-14884,-2200,16384,7200,'false'),
  49. (34,35412,178454,-14884,-2200,16384,7200,'false'),
  50. -- East Terrace
  51. (34,35413,178801,-14975,-2080,16384,7200,'false'),
  52. (34,35413,178822,-14936,-2080,16384,7200,'false'),
  53. (34,35413,178843,-14897,-2080,16384,7200,'false'),
  54. (34,35413,178865,-14857,-2080,16384,7200,'false'),
  55. (34,35413,178886,-14818,-2080,16384,7200,'false'),
  56. (34,35413,178908,-14778,-2080,16384,7200,'false'),
  57. (34,35413,178929,-14739,-2080,16384,7200,'false'),
  58. (34,35413,178951,-14699,-2080,16384,7200,'false'),
  59. -- West Terrace
  60. (34,35413,177834,-15015,-2210,16384,7200,'false'),
  61. (34,35413,177803,-14971,-2210,16384,7200,'false'),
  62. (34,35413,177772,-14927,-2210,16384,7200,'false'),
  63. (34,35413,177741,-14883,-2210,16384,7200,'false'),
  64. (34,35413,177711,-14838,-2210,16384,7200,'false'),
  65. (34,35413,177680,-14794,-2210,16384,7200,'false'),
  66. (34,35413,177649,-14750,-2210,16384,7200,'false'),
  67. (34,35413,177619,-14705,-2210,16384,7200,'false'),
  68. -- Area 2 (back wall of resistance)
  69. (34,35413,178640,-18216,-2200,-16384,7200,'false'),
  70. (34,35413,178661,-18218,-2200,-16384,7200,'false'),
  71. (34,35413,178682,-18220,-2200,-16384,7200,'false'),
  72. (34,35413,178703,-18222,-2200,-16384,7200,'false'),
  73. (34,35413,178724,-18224,-2200,-16384,7200,'false'),
  74. (34,35413,178745,-18226,-2200,-16384,7200,'false'),
  75. (34,35413,178766,-18228,-2200,-16384,7200,'false'),
  76. (34,35413,178788,-18229,-2200,-16384,7200,'false'),
  77. (34,35414,178640,-18196,-2200,-16384,7200,'false'),
  78. (34,35414,178661,-18198,-2200,-16384,7200,'false'),
  79. (34,35414,178682,-18200,-2200,-16384,7200,'false'),
  80. (34,35414,178703,-18202,-2200,-16384,7200,'false'),
  81. (34,35414,178724,-18204,-2200,-16384,7200,'false'),
  82. (34,35414,178745,-18206,-2200,-16384,7200,'false'),
  83. (34,35414,178766,-18208,-2200,-16384,7200,'false'),
  84. (34,35414,178788,-18209,-2200,-16384,7200,'false'),
  85. (34,35412,178640,-18176,-2200,-16384,7200,'false'),
  86. (34,35412,178661,-18178,-2200,-16384,7200,'false'),
  87. (34,35412,178682,-18180,-2200,-16384,7200,'false'),
  88. (34,35412,178703,-18182,-2200,-16384,7200,'false'),
  89. (34,35412,178724,-18184,-2200,-16384,7200,'false'),
  90. (34,35412,178745,-18186,-2200,-16384,7200,'false'),
  91. (34,35412,178766,-18188,-2200,-16384,7200,'false'),
  92. (34,35412,178788,-18189,-2200,-16384,7200,'false'),
  93. -- Area 3
  94. (34,35413,177335,-17128,-2200,16384,7200,'false'),
  95. (34,35413,177305,-17128,-2200,16384,7200,'false'),
  96. (34,35413,177276,-17128,-2200,16384,7200,'false'),
  97. (34,35413,177246,-17128,-2200,16384,7200,'false'),
  98. (34,35413,177217,-17128,-2200,16384,7200,'false'),
  99. (34,35413,177187,-17128,-2200,16384,7200,'false'),
  100. (34,35413,177158,-17128,-2200,16384,7200,'false'),
  101. (34,35413,177129,-17128,-2200,16384,7200,'false'),
  102. (34,35414,177335,-17148,-2200,16384,7200,'false'),
  103. (34,35414,177305,-17148,-2200,16384,7200,'false'),
  104. (34,35414,177276,-17148,-2200,16384,7200,'false'),
  105. (34,35414,177246,-17148,-2200,16384,7200,'false'),
  106. (34,35414,177217,-17148,-2200,16384,7200,'false'),
  107. (34,35414,177187,-17148,-2200,16384,7200,'false'),
  108. (34,35414,177158,-17148,-2200,16384,7200,'false'),
  109. (34,35414,177129,-17148,-2200,16384,7200,'false'),
  110. (34,35412,177335,-17168,-2200,16384,7200,'false'),
  111. (34,35412,177305,-17168,-2200,16384,7200,'false'),
  112. (34,35412,177276,-17168,-2200,16384,7200,'false'),
  113. (34,35412,177246,-17168,-2200,16384,7200,'false'),
  114. (34,35412,177217,-17168,-2200,16384,7200,'false'),
  115. (34,35412,177187,-17168,-2200,16384,7200,'false'),
  116. (34,35412,177158,-17168,-2200,16384,7200,'false'),
  117. (34,35412,177129,-17168,-2200,16384,7200,'false'),
  118. -- Region 1 (left)
  119. (34,35413,177707,-15427,-2226,3000,7200,'false'),
  120. (34,35413,177727,-15464,-2226,3000,7200,'false'),
  121. (34,35413,177680,-15485,-2226,3000,7200,'false'),
  122. (34,35413,177745,-15498,-2226,3000,7200,'false'),
  123. (34,35413,177769,-15540,-2226,3000,7200,'false'),
  124. (34,35413,177722,-15561,-2226,3000,7200,'false'),
  125. (34,35413,177788,-15578,-2226,3000,7200,'false'),
  126. (34,35413,177811,-15622,-2226,3000,7200,'false'),
  127. (34,35413,177765,-15643,-2226,3000,7200,'false'),
  128. (34,35413,177838,-15664,-2226,3000,7200,'false'),
  129. (34,35413,177859,-15704,-2226,3000,7200,'false'),
  130. (34,35413,177813,-15726,-2226,3000,7200,'false'),
  131. (34,35413,177880,-15744,-2226,3000,7200,'false'),
  132. (34,35413,177906,-15791,-2226,3000,7200,'false'),
  133. (34,35413,177859,-15812,-2226,3000,7200,'false'),
  134. (34,35411,177470,-15856,-2250,10000,7200,'false'),
  135. (34,35411,177506,-15887,-2250,10000,7200,'false'),
  136. (34,35411,177627,-15953,-2250,10000,7200,'false'),
  137. (34,35411,177703,-15999,-2250,10000,7200,'false'),
  138. (34,35411,177400,-15854,-2250,10000,7200,'false'),
  139. (34,35411,177517,-15930,-2250,10000,7200,'false'),
  140. (34,35411,177564,-15963,-2250,10000,7200,'false'),
  141. (34,35411,177608,-15985,-2250,10000,7200,'false'),
  142. (34,35411,177709,-16043,-2253,10000,7200,'false'),
  143. (34,35411,177387,-15955,-2250,10000,7200,'false'),
  144. (34,35411,177661,-16014,-2253,10000,7200,'false'),
  145. (34,35411,177308,-15861,-2253,10000,7200,'false'),
  146. (34,35411,177606,-16035,-2253,10000,7200,'false'),
  147. (34,35411,177861,-16164,-2253,10000,7200,'false'),
  148. (34,35411,177810,-16145,-2253,10000,7200,'false'),
  149. (34,35411,177719,-15951,-2253,10000,7200,'false'),
  150. (34,35411,177667,-15921,-2253,10000,7200,'false'),
  151. (34,35415,177428,-15981,-2250,10000,7200,'false'),
  152. (34,35415,177473,-16011,-2250,10000,7200,'false'),
  153. (34,35415,177612,-16090,-2250,10000,7200,'false'),
  154. (34,35415,177657,-16113,-2250,10000,7200,'false'),
  155. (34,35415,177387,-15996,-2250,10000,7200,'false'),
  156. (34,35415,177433,-16026,-2250,10000,7200,'false'),
  157. (34,35415,177530,-16079,-2250,10000,7200,'false'),
  158. (34,35415,177571,-16105,-2250,10000,7200,'false'),
  159. (34,35415,177663,-16154,-2250,10000,7200,'false'),
  160. -- Region 1 (right)
  161. (34,35413,179009,-15201,-2221,40000,7200,'false'),
  162. (34,35413,179052,-15226,-2221,40000,7200,'false'),
  163. (34,35413,179073,-15203,-2221,40000,7200,'false'),
  164. (34,35413,179101,-15253,-2221,40000,7200,'false'),
  165. (34,35413,179144,-15271,-2221,40000,7200,'false'),
  166. (34,35413,179164,-15247,-2221,40000,7200,'false'),
  167. (34,35413,179189,-15286,-2221,40000,7200,'false'),
  168. (34,35413,179226,-15309,-2221,40000,7200,'false'),
  169. (34,35413,179246,-15285,-2221,40000,7200,'false'),
  170. (34,35413,179260,-15341,-2221,40000,7200,'false'),
  171. (34,35413,179302,-15372,-2221,40000,7200,'false'),
  172. (34,35413,179322,-15349,-2221,40000,7200,'false'),
  173. (34,35413,179341,-15406,-2221,40000,7200,'false'),
  174. (34,35413,179391,-15439,-2221,40000,7200,'false'),
  175. (34,35411,179327,-16101,-2253,25000,7200,'false'),
  176. (34,35411,179426,-16009,-2253,25000,7200,'false'),
  177. (34,35415,179491,-15981,-2256,25000,7200,'false'),
  178. (34,35415,179503,-15925,-2256,25000,7200,'false'),
  179. (34,35415,179544,-15882,-2256,25000,7200,'false'),
  180. (34,35415,179570,-15901,-2256,25000,7200,'false'),
  181. (34,35415,179279,-16219,-2256,25000,7200,'false'),
  182. (34,35415,179370,-16196,-2256,25000,7200,'false'),
  183. (34,35415,179408,-16158,-2256,25000,7200,'false'),
  184. (34,35415,179562,-15984,-2256,25000,7200,'false'),
  185. (34,35415,179599,-15943,-2256,25000,7200,'false'),
  186. -- Region 2
  187. (34,35411,179433,-16991,-2246,16384,1200,'false'),
  188. (34,35411,179715,-17454,-2246,16384,1200,'false'),
  189. (34,35411,179438,-16875,-2246,16384,1200,'false'),
  190. (34,35411,179540,-16876,-2246,16384,1200,'false'),
  191. (34,35411,179593,-16876,-2246,16384,1200,'false'),
  192. (34,35411,179485,-17213,-2246,16384,1200,'false'),
  193. (34,35411,179537,-17214,-2246,16384,1200,'false'),
  194. (34,35411,179641,-17215,-2246,16384,1200,'false'),
  195. (34,35411,179542,-17453,-2246,16384,1200,'false'),
  196. (34,35411,179594,-17453,-2246,16384,1200,'false'),
  197. (34,35411,179444,-16937,-2256,16384,1200,'false'),
  198. (34,35411,179468,-17280,-2256,16384,1200,'false'),
  199. (34,35411,179514,-17281,-2256,16384,1200,'false'),
  200. (34,35411,179479,-17133,-2256,16384,1200,'false'),
  201. (34,35411,179525,-17135,-2256,16384,1200,'false'),
  202. (34,35415,179576,-17137,-2256,16384,1200,'false'),
  203. (34,35415,179633,-17137,-2256,16384,1200,'false'),
  204. (34,35415,179436,-17776,-2256,16384,1200,'false'),
  205. (34,35415,179636,-17780,-2256,16384,1200,'false'),
  206. (34,35415,179697,-17781,-2256,16384,1200,'false'),
  207. (34,35415,179446,-17391,-2252,16384,1200,'false'),
  208. (34,35415,179508,-17341,-2252,16384,1200,'false'),
  209. (34,35415,179432,-17719,-2252,16384,1200,'false'),
  210. (34,35415,179437,-17522,-2252,16384,1200,'false'),
  211. (34,35415,179557,-17524,-2252,16384,1200,'false'),
  212. (34,35415,179707,-17722,-2252,16384,1200,'false'),
  213. (34,35415,179604,-17525,-2252,16384,1200,'false'),
  214. (34,35415,179665,-17527,-2252,16384,1200,'false'),
  215. (34,35415,179534,-17892,-2252,16384,1200,'false'),
  216. (34,35415,179436,-17841,-2252,16384,1200,'false'),
  217. (34,35415,179482,-17841,-2252,16384,1200,'false'),
  218. (34,35415,179536,-17842,-2252,16384,1200,'false'),
  219. (34,35415,179694,-17897,-2252,16384,1200,'false'),
  220. (34,35415,179696,-17844,-2252,16384,1200,'false'),
  221. -- Region 3
  222. (34,35413,178578,-18383,-2250,0,7200,'false'),
  223. (34,35413,178577,-18422,-2250,0,7200,'false'),
  224. (34,35413,178576,-18461,-2250,0,7200,'false'),
  225. (34,35413,178575,-18500,-2250,0,7200,'false'),
  226. (34,35413,178574,-18539,-2250,0,7200,'false'),
  227. (34,35413,178573,-18577,-2250,0,7200,'false'),
  228. (34,35413,178571,-18618,-2250,0,7200,'false'),
  229. (34,35413,178571,-18657,-2250,0,7200,'false'),
  230. (34,35413,178571,-18697,-2250,0,7200,'false'),
  231. (34,35413,178570,-18736,-2250,0,7200,'false'),
  232. (34,35413,178530,-18382,-2250,0,7200,'false'),
  233. (34,35413,178530,-18421,-2250,0,7200,'false'),
  234. (34,35413,178528,-18461,-2250,0,7200,'false'),
  235. (34,35413,178528,-18499,-2250,0,7200,'false'),
  236. (34,35413,178526,-18538,-2250,0,7200,'false'),
  237. (34,35413,178526,-18576,-2250,0,7200,'false'),
  238. (34,35413,178524,-18618,-2250,0,7200,'false'),
  239. (34,35413,178523,-18656,-2250,0,7200,'false'),
  240. (34,35413,178523,-18696,-2250,0,7200,'false'),
  241. (34,35413,178523,-18735,-2250,0,7200,'false'),
  242. -- Region 4
  243. (34,35413,178437,-16548,-2217,0,7200,'false'),
  244. (34,35413,178437,-16587,-2217,0,7200,'false'),
  245. (34,35413,178435,-16627,-2217,0,7200,'false'),
  246. (34,35413,178435,-16665,-2217,0,7200,'false'),
  247. (34,35413,178433,-16704,-2217,0,7200,'false'),
  248. (34,35413,178433,-16742,-2217,0,7200,'false'),
  249. (34,35413,178431,-16784,-2217,0,7200,'false'),
  250. (34,35413,178431,-16822,-2217,0,7200,'false'),
  251. (34,35413,178430,-16862,-2217,0,7200,'false'),
  252. (34,35413,178430,-16901,-2217,0,7200,'false'),
  253. (34,35413,178161,-16562,-2217,0,7200,'false'),
  254. (34,35413,178160,-16600,-2217,0,7200,'false'),
  255. (34,35413,178158,-16640,-2217,0,7200,'false'),
  256. (34,35413,178158,-16679,-2217,0,7200,'false'),
  257. (34,35413,178156,-16718,-2217,0,7200,'false'),
  258. (34,35413,178156,-16756,-2217,0,7200,'false'),
  259. (34,35413,178154,-16797,-2217,0,7200,'false'),
  260. (34,35413,178154,-16836,-2217,0,7200,'false'),
  261. (34,35413,178153,-16876,-2217,0,7200,'false'),
  262. (34,35413,178153,-16914,-2217,0,7200,'false'),
  263. (34,35413,177876,-16558,-2217,0,7200,'false'),
  264. (34,35413,177876,-16597,-2217,0,7200,'false'),
  265. (34,35413,177874,-16637,-2217,0,7200,'false'),
  266. (34,35413,177873,-16675,-2217,0,7200,'false'),
  267. (34,35413,177872,-16714,-2217,0,7200,'false'),
  268. (34,35413,177871,-16752,-2217,0,7200,'false'),
  269. (34,35413,177870,-16794,-2217,0,7200,'false'),
  270. (34,35413,177869,-16832,-2217,0,7200,'false'),
  271. (34,35413,177869,-16873,-2217,0,7200,'false'),
  272. (34,35413,177868,-16911,-2217,0,7200,'false'),
  273. (34,35411,178403,-16566,-2218,0,7200,'false'),
  274. (34,35411,178398,-16781,-2218,0,7200,'false'),
  275. (34,35411,178397,-16824,-2218,0,7200,'false'),
  276. (34,35411,178395,-16865,-2218,0,7200,'false'),
  277. (34,35411,178326,-16720,-2218,0,7200,'false'),
  278. (34,35411,178324,-16762,-2218,0,7200,'false'),
  279. (34,35411,178324,-16804,-2218,0,7200,'false'),
  280. (34,35411,178122,-16672,-2218,0,7200,'false'),
  281. (34,35411,178120,-16714,-2218,0,7200,'false'),
  282. (34,35411,178122,-16759,-2218,0,7200,'false'),
  283. (34,35411,178117,-16885,-2218,0,7200,'false'),
  284. (34,35411,178061,-16738,-2218,0,7200,'false'),
  285. (34,35411,178063,-16784,-2218,0,7200,'false'),
  286. (34,35411,178060,-16826,-2218,0,7200,'false'),
  287. (34,35411,178060,-16868,-2218,0,7200,'false'),
  288. (34,35415,178366,-16582,-2217,0,7200,'false'),
  289. (34,35415,178366,-16674,-2217,0,7200,'false'),
  290. (34,35415,178366,-16721,-2217,0,7200,'false'),
  291. (34,35415,178363,-16768,-2217,0,7200,'false'),
  292. (34,35415,178290,-16550,-2217,0,7200,'false'),
  293. (34,35415,178290,-16690,-2217,0,7200,'false'),
  294. (34,35415,178288,-16783,-2217,0,7200,'false'),
  295. (34,35415,178285,-16832,-2217,0,7200,'false'),
  296. (34,35415,178095,-16736,-2217,0,7200,'false'),
  297. (34,35415,178092,-16782,-2217,0,7200,'false'),
  298. (34,35415,178090,-16878,-2217,0,7200,'false'),
  299. (34,35415,178029,-16587,-2217,0,7200,'false'),
  300. (34,35415,178029,-16727,-2217,0,7200,'false'),
  301. (34,35415,178027,-16773,-2217,0,7200,'false'),
  302. (34,35415,178027,-16820,-2217,0,7200,'false'),
  303. -- Region 5
  304. (34,35413,177466,-17397,-2207,32768,7200,'false'),
  305. (34,35415,177440,-17380,-2215,32768,7200,'false'),
  306. (34,35416,177501,-17384,-2219,32768,7200,'false'),
  307. (34,35415,177439,-17426,-2215,32768,7200,'false'),
  308. (34,35415,177438,-17472,-2215,32768,7200,'false'),
  309. (34,35415,177436,-17605,-2215,32768,7200,'false'),
  310. (34,35415,177432,-17791,-2215,32768,7200,'false'),
  311. (34,35415,177431,-17836,-2215,32768,7200,'false'),
  312. (34,35415,177559,-17708,-2215,32768,7200,'false'),
  313. (34,35415,177558,-17755,-2215,32768,7200,'false'),
  314. (34,35415,177564,-17425,-2215,32768,7200,'false'),
  315. (34,35415,177561,-17563,-2215,32768,7200,'false'),
  316. (34,35413,177466,-17445,-2207,32768,7200,'false'),
  317. (34,35413,177466,-17537,-2207,32768,7200,'false'),
  318. (34,35413,177466,-17627,-2207,32768,7200,'false'),
  319. (34,35413,177466,-17716,-2207,32768,7200,'false'),
  320. (34,35413,177467,-17809,-2207,32768,7200,'false'),
  321. (34,35413,177603,-17446,-2207,32768,7200,'false'),
  322. (34,35413,177603,-17539,-2207,32768,7200,'false'),
  323. (34,35413,177604,-17628,-2207,32768,7200,'false'),
  324. (34,35413,177604,-17718,-2207,32768,7200,'false'),
  325. (34,35413,177601,-17811,-2207,32768,7200,'false'),
  326. (34,35413,177693,-17447,-2207,32768,7200,'false'),
  327. (34,35413,177693,-17539,-2207,32768,7200,'false'),
  328. (34,35413,177693,-17629,-2207,32768,7200,'false'),
  329. (34,35413,177693,-17718,-2207,32768,7200,'false'),
  330. (34,35413,177694,-17811,-2207,32768,7200,'false'),
  331. (34,35413,177396,-17452,-2207,32768,7200,'false'),
  332. (34,35413,177396,-17545,-2207,32768,7200,'false'),
  333. (34,35413,177397,-17634,-2207,32768,7200,'false'),
  334. (34,35413,177397,-17723,-2207,32768,7200,'false'),
  335. (34,35413,177398,-17817,-2207,32768,7200,'false'),
  336. (34,35413,177749,-17446,-2207,32768,7200,'false'),
  337. (34,35413,177749,-17538,-2207,32768,7200,'false'),
  338. (34,35413,177750,-17628,-2207,32768,7200,'false'),
  339. (34,35413,177750,-17717,-2207,32768,7200,'false'),
  340. (34,35413,177751,-17810,-2207,32768,7200,'false'),
  341. (34,35415,177531,-17399,-2215,32768,7200,'false'),
  342. (34,35415,177527,-17537,-2215,32768,7200,'false'),
  343. (34,35415,177527,-17578,-2215,32768,7200,'false'),
  344. (34,35415,177524,-17763,-2215,32768,7200,'false'),
  345. (34,35415,177523,-17810,-2215,32768,7200,'false'),
  346. (34,35415,177636,-17516,-2215,32768,7200,'false'),
  347. (34,35415,177635,-17603,-2215,32768,7200,'false'),
  348. (34,35415,177633,-17740,-2215,32768,7200,'false'),
  349. (34,35415,177632,-17788,-2215,32768,7200,'false'),
  350. (34,35415,177631,-17835,-2215,32768,7200,'false'),
  351. (34,35416,177501,-17424,-2219,32768,7200,'false'),
  352. (34,35416,177500,-17469,-2219,32768,7200,'false'),
  353. (34,35416,177496,-17645,-2219,32768,7200,'false'),
  354. (34,35416,177496,-17686,-2219,32768,7200,'false'),
  355. (34,35416,177666,-17508,-2219,32768,7200,'false'),
  356. (34,35416,177664,-17559,-2219,32768,7200,'false'),
  357. (34,35416,177664,-17599,-2219,32768,7200,'false'),
  358. (34,35416,177662,-17644,-2219,32768,7200,'false'),
  359. (34,35416,177662,-17685,-2219,32768,7200,'false'),
  360. (34,35416,177661,-17818,-2219,32768,7200,'false'),
  361. (34,35416,177728,-17377,-2219,32768,7200,'false'),
  362. (34,35416,177725,-17503,-2219,32768,7200,'false'),
  363. (34,35416,177724,-17553,-2219,32768,7200,'false'),
  364. (34,35416,177724,-17594,-2219,32768,7200,'false'),
  365. (34,35416,177722,-17728,-2219,32768,7200,'false'),
  366. (34,35416,177722,-17768,-2219,32768,7200,'false'),
  367. (34,35416,177721,-17813,-2219,32768,7200,'false'),
  368. (34,35416,177567,-17376,-2219,32768,7200,'false'),
  369. (34,35416,177560,-17849,-2219,32768,7200,'false'),
  370. -- Region 6
  371. (34,35410,178298,-17624,-2194,32768,7200,'true');
  372. INSERT INTO `clanhall_siege_guards` VALUES
  373. -- Partisan's Hideaway (Fortress of Resistance)
  374. -- Mercury Monster
  375. (21,35369,44545,108867,-2020,0,60,'false'),
  376. (21,35369,44505,108867,-2020,0,60,'false'),
  377. (21,35371,44535,108884,-2020,0,60,'false'),
  378. (21,35371,44515,108884,-2020,0,60,'false'),
  379. (21,35371,44515,108850,-2020,0,60,'false'),
  380. (21,35371,44535,108850,-2020,0,60,'false'),
  381. (21,35370,44565,108867,-2020,0,60,'false'),
  382. (21,35370,44553,108895,-2020,0,60,'false'),
  383. (21,35370,44535,108895,-2020,0,60,'false'),
  384. (21,35370,44497,108895,-2020,0,60,'false'),
  385. (21,35370,44485,108867,-2020,0,60,'false'),
  386. (21,35370,44497,108839,-2020,0,60,'false'),
  387. (21,35370,44525,108827,-2020,0,60,'false'),
  388. (21,35370,44553,108839,-2020,0,60,'false'),
  389. (21,35374,44812,109492,-1705,0,60,'false'),
  390. (21,35373,44788,109492,-1705,0,60,'false'),
  391. (21,35374,45236,108980,-1705,0,60,'false'),
  392. (21,35373,45168,109020,-1705,0,60,'false'),
  393. -- (21,35372,anywhere - total 15,0,60,'false'), TODO: needs support for random spawn by zone.
  394. (21,35382,50343,111282,-1970,0,60,'false'),
  395. (21,35383,43129,108841,-1980,0,60,'false'),
  396. (21,35375,44525,108867,-2020,0,10800,'true');
  397. INSERT INTO `clanhall_siege_guards` VALUES
  398. -- Bandit Stronghold
  399. (35,35560,79745,-15472,-1792,0,1200,'false'),
  400. (35,35561,83348,-18267,-1248,14536,1200,'false'),
  401. (35,35562,81258,-17387,-1248,11144,1200,'false'),
  402. (35,35563,81832,-14223,-1248,-17664,1200,'false'),
  403. (35,35564,83687,-14532,-1248,-19008,1200,'false'),
  404. (35,35565,85263,-15447,-1248,-21328,1200,'false');
  405. INSERT INTO `clanhall_siege_guards` VALUES
  406. -- Beast Farm
  407. (63,35612,60606,-93984,-1344,0,1200,'false'),
  408. (63,35613,56098,-91770,-1360,0,1200,'false'),
  409. (63,35614,58276,-90672,-1360,0,1200,'false'),
  410. (63,35615,59970,-92422,-1360,0,1200,'false'),
  411. (63,35616,58783,-94540,-1360,0,1200,'false'),
  412. (63,35617,56415,-94126,-1360,0,1200,'false');
  413. INSERT INTO `clanhall_siege_guards` VALUES
  414. -- Fortress of the Dead
  415. (64,35630,59282,-26496,568,49000,7200,'false'),
  416. (64,35631,56619,-27866,568,49000,7200,'false'),
  417. (64,35634,57931,-29540,565,49152,7200,'false'),
  418. (64,35634,57888,-29540,565,49152,7200,'false'),
  419. (64,35634,57845,-29540,565,49152,7200,'false'),
  420. (64,35634,57801,-29540,565,49152,7200,'false'),
  421. (64,35634,57758,-29540,565,49152,7200,'false'),
  422. (64,35634,58150,-29540,565,49152,7200,'false'),
  423. (64,35634,58107,-29540,565,49152,7200,'false'),
  424. (64,35634,58063,-29540,565,49152,7200,'false'),
  425. (64,35634,58020,-29540,565,49152,7200,'false'),
  426. (64,35634,57977,-29540,565,49152,7200,'false'),
  427. (64,35634,57783,-29569,565,49152,7200,'false'),
  428. (64,35634,57740,-29569,565,49152,7200,'false'),
  429. (64,35634,58170,-29570,565,49152,7200,'false'),
  430. (64,35634,58128,-29570,565,49152,7200,'false'),
  431. (64,35633,57929,-29570,575,49152,7200,'false'),
  432. (64,35633,57885,-29570,575,49152,7200,'false'),
  433. (64,35633,57836,-29570,575,49152,7200,'false'),
  434. (64,35633,58072,-29570,575,49152,7200,'false'),
  435. (64,35633,58029,-29570,575,49152,7200,'false'),
  436. (64,35633,57980,-29570,575,49152,7200,'false'),
  437. (64,35633,57928,-29606,575,49152,7200,'false'),
  438. (64,35633,57885,-29606,575,49152,7200,'false'),
  439. (64,35633,57836,-29606,575,49152,7200,'false'),
  440. (64,35633,58072,-29607,575,49152,7200,'false'),
  441. (64,35633,58028,-29607,575,49152,7200,'false'),
  442. (64,35633,57979,-29607,575,49152,7200,'false'),
  443. (64,35633,57780,-29606,575,49152,7200,'false'),
  444. (64,35633,57731,-29606,575,49152,7200,'false'),
  445. (64,35633,58172,-29608,575,49152,7200,'false'),
  446. (64,35633,58123,-29608,575,49152,7200,'false'),
  447. (64,35634,58435,-29647,567,49152,7200,'false'),
  448. (64,35634,58450,-29681,567,49152,7200,'false'),
  449. (64,35634,58468,-29713,567,49152,7200,'false'),
  450. (64,35634,58484,-29745,567,49152,7200,'false'),
  451. (64,35634,58500,-29777,567,49152,7200,'false'),
  452. (64,35634,58520,-29815,587,49152,7200,'false'),
  453. (64,35634,58536,-29848,587,49152,7200,'false'),
  454. (64,35634,58556,-29886,567,49152,7200,'false'),
  455. (64,35634,57473,-29664,567,49152,7200,'false'),
  456. (64,35634,57452,-29695,567,49152,7200,'false'),
  457. (64,35634,57435,-29728,567,49152,7200,'false'),
  458. (64,35634,57420,-29760,567,49152,7200,'false'),
  459. (64,35634,57409,-29791,567,49152,7200,'false'),
  460. (64,35634,57394,-29824,580,49152,7200,'false'),
  461. (64,35634,57379,-29856,580,49152,7200,'false'),
  462. (64,35634,57363,-29888,567,49152,7200,'false'),
  463. (64,35634,57893,-26684,591,-88,7200,'false'),
  464. (64,35634,57893,-26722,591,-88,7200,'false'),
  465. (64,35634,57893,-26759,591,-88,7200,'false'),
  466. (64,35634,57893,-26646,591,-88,7200,'false'),
  467. (64,35634,57863,-26646,591,-88,7200,'false'),
  468. (64,35634,57863,-26684,591,-88,7200,'false'),
  469. (64,35634,57863,-26722,591,-88,7200,'false'),
  470. (64,35634,57863,-26758,591,-88,7200,'false'),
  471. (64,35635,57973,-26684,591,-88,7200,'false'),
  472. (64,35635,57973,-26722,591,-88,7200,'false'),
  473. (64,35635,57973,-26759,591,-88,7200,'false'),
  474. (64,35635,57973,-26646,591,-88,7200,'false'),
  475. (64,35635,57943,-26646,591,-88,7200,'false'),
  476. (64,35635,57943,-26684,591,-88,7200,'false'),
  477. (64,35635,57943,-26721,591,-88,7200,'false'),
  478. (64,35635,57943,-26758,591,-88,7200,'false'),
  479. (64,35633,58046,-26682,591,-88,7200,'false'),
  480. (64,35633,58046,-26720,591,-88,7200,'false'),
  481. (64,35633,58046,-26758,591,-88,7200,'false'),
  482. (64,35633,58046,-26644,591,-88,7200,'false'),
  483. (64,35633,58017,-26644,591,-88,7200,'false'),
  484. (64,35633,58017,-26682,591,-88,7200,'false'),
  485. (64,35633,58017,-26720,591,-88,7200,'false'),
  486. (64,35633,58017,-26757,591,-88,7200,'false'),
  487. (64,35634,58889,-26764,565,-88,7200,'false'),
  488. (64,35634,58889,-26802,565,-88,7200,'false'),
  489. (64,35634,58889,-26840,565,-88,7200,'false'),
  490. (64,35634,58889,-26876,565,-88,7200,'false'),
  491. (64,35634,58889,-26726,565,-88,7200,'false'),
  492. (64,35634,58889,-26570,565,-88,7200,'false'),
  493. (64,35634,58889,-26608,565,-88,7200,'false'),
  494. (64,35634,58889,-26645,565,-88,7200,'false'),
  495. (64,35634,58889,-26682,565,-88,7200,'false'),
  496. (64,35634,58889,-26532,565,-88,7200,'false'),
  497. (64,35634,58887,-26379,565,-88,7200,'false'),
  498. (64,35634,58887,-26417,565,-88,7200,'false'),
  499. (64,35634,58887,-26454,565,-88,7200,'false'),
  500. (64,35634,58887,-26491,565,-88,7200,'false'),
  501. (64,35634,58887,-26341,565,-88,7200,'false'),
  502. (64,35632,56669,-26839,592,16384,7200,'false'),
  503. (64,35634,56708,-26902,565,16448,7200,'false'),
  504. (64,35634,56746,-26902,565,16448,7200,'false'),
  505. (64,35634,56784,-26902,565,16448,7200,'false'),
  506. (64,35634,56820,-26902,565,16448,7200,'false'),
  507. (64,35634,56858,-26903,565,16448,7200,'false'),
  508. (64,35634,56894,-26903,565,16448,7200,'false'),
  509. (64,35634,56670,-26902,565,16448,7200,'false'),
  510. (64,35634,56935,-26903,565,16448,7200,'false'),
  511. (64,35634,57018,-26902,565,16448,7200,'false'),
  512. (64,35634,57056,-26902,565,16448,7200,'false'),
  513. (64,35634,57093,-26902,565,16448,7200,'false'),
  514. (64,35634,57130,-26902,565,16448,7200,'false'),
  515. (64,35634,57168,-26903,565,16448,7200,'false'),
  516. (64,35634,57204,-26903,565,16448,7200,'false'),
  517. (64,35634,56980,-26902,565,16448,7200,'false'),
  518. (64,35634,56708,-26874,565,16448,7200,'false'),
  519. (64,35634,56746,-26874,565,16448,7200,'false'),
  520. (64,35634,56783,-26874,565,16448,7200,'false'),
  521. (64,35634,56820,-26874,565,16448,7200,'false'),
  522. (64,35634,56857,-26875,565,16448,7200,'false'),
  523. (64,35634,56894,-26875,565,16448,7200,'false'),
  524. (64,35634,56670,-26874,565,16448,7200,'false'),
  525. (64,35634,56935,-26875,565,16448,7200,'false'),
  526. (64,35634,57018,-26875,565,16448,7200,'false'),
  527. (64,35634,57056,-26875,565,16448,7200,'false'),
  528. (64,35634,57094,-26875,565,16448,7200,'false'),
  529. (64,35634,57131,-26875,565,16448,7200,'false'),
  530. (64,35634,57168,-26876,565,16448,7200,'false'),
  531. (64,35634,57205,-26876,565,16448,7200,'false'),
  532. (64,35634,56980,-26875,565,16448,7200,'false'),
  533. (64,35632,56708,-26839,592,16384,7200,'false'),
  534. (64,35632,56748,-26839,592,16384,7200,'false'),
  535. (64,35632,56788,-26839,592,16384,7200,'false'),
  536. (64,35632,56829,-26839,592,16384,7200,'false'),
  537. (64,35632,56870,-26839,592,16384,7200,'false'),
  538. (64,35632,56910,-26839,592,16384,7200,'false'),
  539. (64,35632,56950,-26839,592,16384,7200,'false'),
  540. (64,35632,56989,-26839,592,16384,7200,'false'),
  541. (64,35632,57030,-26839,592,16384,7200,'false'),
  542. (64,35632,56667,-26799,592,16384,7200,'false'),
  543. (64,35632,56706,-26799,592,16384,7200,'false'),
  544. (64,35632,56747,-26799,592,16384,7200,'false'),
  545. (64,35632,56786,-26799,592,16384,7200,'false'),
  546. (64,35632,56827,-26799,592,16384,7200,'false'),
  547. (64,35636,56869,-26802,587,16384,7200,'false'),
  548. (64,35636,56908,-26802,587,16384,7200,'false'),
  549. (64,35636,56948,-26802,587,16384,7200,'false'),
  550. (64,35636,56989,-26802,587,16384,7200,'false'),
  551. (64,35636,57030,-26802,587,16384,7200,'false'),
  552. (64,35636,57071,-26804,587,16384,7200,'false'),
  553. (64,35636,57111,-26804,587,16384,7200,'false'),
  554. (64,35636,57151,-26804,587,16384,7200,'false'),
  555. (64,35636,57191,-26804,587,16384,7200,'false'),
  556. (64,35636,57233,-26804,587,16384,7200,'false'),
  557. (64,35636,57070,-26842,587,16384,7200,'false'),
  558. (64,35636,57110,-26842,587,16384,7200,'false'),
  559. (64,35636,57150,-26842,587,16384,7200,'false'),
  560. (64,35636,57190,-26842,587,16384,7200,'false'),
  561. (64,35636,57232,-26842,587,16384,7200,'false'),
  562. (64,35634,57461,-28550,565,0,7200,'false'),
  563. (64,35634,57461,-28503,565,0,7200,'false'),
  564. (64,35634,57461,-28455,565,0,7200,'false'),
  565. (64,35634,57461,-28408,565,0,7200,'false'),
  566. (64,35634,57461,-28360,565,0,7200,'false'),
  567. (64,35634,57461,-28791,565,0,7200,'false'),
  568. (64,35634,57461,-28744,565,0,7200,'false'),
  569. (64,35634,57461,-28696,565,0,7200,'false'),
  570. (64,35634,57461,-28649,565,0,7200,'false'),
  571. (64,35634,57461,-28601,565,0,7200,'false'),
  572. (64,35632,57543,-28587,592,0,7200,'false'),
  573. (64,35636,57605,-28901,587,0,7200,'false'),
  574. (64,35632,57543,-28632,592,0,7200,'false'),
  575. (64,35632,57543,-28678,592,0,7200,'false'),
  576. (64,35632,57543,-28727,592,0,7200,'false'),
  577. (64,35632,57543,-28775,592,0,7200,'false'),
  578. (64,35632,57606,-28399,592,0,7200,'false'),
  579. (64,35632,57543,-28398,592,0,7200,'false'),
  580. (64,35632,57543,-28444,592,0,7200,'false'),
  581. (64,35632,57543,-28494,592,0,7200,'false'),
  582. (64,35632,57543,-28541,592,0,7200,'false'),
  583. (64,35636,57605,-28856,587,0,7200,'false'),
  584. (64,35636,57605,-28807,587,0,7200,'false'),
  585. (64,35636,57605,-28761,587,0,7200,'false'),
  586. (64,35636,57605,-28716,587,0,7200,'false'),
  587. (64,35636,57605,-28668,587,0,7200,'false'),
  588. (64,35636,57605,-28624,587,0,7200,'false'),
  589. (64,35636,57605,-28575,587,0,7200,'false'),
  590. (64,35636,57605,-28529,587,0,7200,'false'),
  591. (64,35636,57605,-28483,587,0,7200,'false'),
  592. (64,35632,57543,-28826,592,0,7200,'false'),
  593. (64,35632,57545,-28882,592,0,7200,'false'),
  594. (64,35632,57545,-28933,592,0,7200,'false'),
  595. (64,35634,57462,-29031,565,0,7200,'false'),
  596. (64,35634,57462,-28984,565,0,7200,'false'),
  597. (64,35634,57462,-28937,565,0,7200,'false'),
  598. (64,35634,57462,-28889,565,0,7200,'false'),
  599. (64,35634,57462,-28841,565,0,7200,'false'),
  600. (64,35632,57546,-28986,592,0,7200,'false'),
  601. (64,35632,57606,-28984,592,0,7200,'false'),
  602. (64,35632,58972,-28365,592,-24512,7200,'false'),
  603. (64,35634,58879,-28217,565,-24440,7200,'false'),
  604. (64,35634,58913,-28250,565,-24440,7200,'false'),
  605. (64,35634,58948,-28284,565,-24440,7200,'false'),
  606. (64,35634,58980,-28316,565,-24440,7200,'false'),
  607. (64,35634,59015,-28349,565,-24440,7200,'false'),
  608. (64,35634,59050,-28384,565,-24440,7200,'false'),
  609. (64,35634,59084,-28417,565,-24440,7200,'false'),
  610. (64,35634,59119,-28450,565,-24440,7200,'false'),
  611. (64,35634,59151,-28481,565,-24440,7200,'false'),
  612. (64,35634,59187,-28518,565,-24440,7200,'false'),
  613. (64,35634,59222,-28552,565,-24440,7200,'false'),
  614. (64,35634,59256,-28585,565,-24440,7200,'false'),
  615. (64,35634,59291,-28619,565,-24440,7200,'false'),
  616. (64,35634,59322,-28650,565,-24440,7200,'false'),
  617. (64,35632,59166,-28557,592,-24512,7200,'false'),
  618. (64,35636,58894,-28289,587,41088,7200,'false'),
  619. (64,35636,58931,-28325,587,41088,7200,'false'),
  620. (64,35636,59007,-28399,587,41088,7200,'false'),
  621. (64,35636,59044,-28435,587,41088,7200,'false'),
  622. (64,35636,59090,-28484,587,41088,7200,'false'),
  623. (64,35636,59127,-28519,587,41088,7200,'false'),
  624. (64,35636,59207,-28597,587,41088,7200,'false'),
  625. (64,35636,59244,-28633,587,41088,7200,'false'),
  626. (64,35634,56938,-27347,576,32768,7200,'false'),
  627. (64,35634,56938,-27309,576,32768,7200,'false'),
  628. (64,35634,56938,-27271,576,32768,7200,'false'),
  629. (64,35634,56938,-27235,576,32768,7200,'false'),
  630. (64,35634,56940,-27197,576,32768,7200,'false'),
  631. (64,35634,56940,-27160,576,32768,7200,'false'),
  632. (64,35634,56938,-27385,576,32768,7200,'false'),
  633. (64,35634,56940,-27120,576,32768,7200,'false'),
  634. (64,35635,56910,-27347,576,32768,7200,'false'),
  635. (64,35635,56910,-27309,576,32768,7200,'false'),
  636. (64,35635,56910,-27271,576,32768,7200,'false'),
  637. (64,35635,56910,-27234,576,32768,7200,'false'),
  638. (64,35635,56912,-27197,576,32768,7200,'false'),
  639. (64,35635,56912,-27160,576,32768,7200,'false'),
  640. (64,35635,56910,-27385,576,32768,7200,'false'),
  641. (64,35635,56912,-27119,576,32768,7200,'false'),
  642. (64,35633,56880,-27346,576,32768,7200,'false'),
  643. (64,35633,56881,-27308,576,32768,7200,'false'),
  644. (64,35633,56881,-27271,576,32768,7200,'false'),
  645. (64,35633,56881,-27234,576,32768,7200,'false'),
  646. (64,35633,56882,-27197,576,32768,7200,'false'),
  647. (64,35633,56882,-27160,576,32768,7200,'false'),
  648. (64,35633,56880,-27384,576,32768,7200,'false'),
  649. (64,35633,56883,-27119,576,32768,7200,'false'),
  650. (64,35632,59015,-27459,575,49152,7200,'false'),
  651. (64,35632,59054,-27459,575,49152,7200,'false'),
  652. (64,35632,59094,-27459,575,49152,7200,'false'),
  653. (64,35632,59134,-27459,575,49152,7200,'false'),
  654. (64,35632,59175,-27459,575,49152,7200,'false'),
  655. (64,35632,59220,-27459,575,49152,7200,'false'),
  656. (64,35632,59259,-27459,575,49152,7200,'false'),
  657. (64,35632,59299,-27459,575,49152,7200,'false'),
  658. (64,35632,59015,-27409,575,49152,7200,'false'),
  659. (64,35632,59054,-27409,575,49152,7200,'false'),
  660. (64,35632,59094,-27409,575,49152,7200,'false'),
  661. (64,35632,59133,-27409,575,49152,7200,'false'),
  662. (64,35632,59174,-27409,575,49152,7200,'false'),
  663. (64,35632,59220,-27409,575,49152,7200,'false'),
  664. (64,35632,59259,-27409,575,49152,7200,'false'),
  665. (64,35632,59299,-27409,575,49152,7200,'false'),
  666. (64,35636,59015,-27352,575,49152,7200,'false'),
  667. (64,35636,59054,-27352,575,49152,7200,'false'),
  668. (64,35636,59094,-27352,575,49152,7200,'false'),
  669. (64,35636,59134,-27352,575,49152,7200,'false'),
  670. (64,35636,59175,-27352,575,49152,7200,'false'),
  671. (64,35636,59220,-27352,575,49152,7200,'false'),
  672. (64,35636,59259,-27352,575,49152,7200,'false'),
  673. (64,35636,59299,-27352,575,49152,7200,'false'),
  674. (64,35636,59016,-27299,575,49152,7200,'false'),
  675. (64,35636,59055,-27299,575,49152,7200,'false'),
  676. (64,35636,59095,-27299,575,49152,7200,'false'),
  677. (64,35636,59134,-27299,575,49152,7200,'false'),
  678. (64,35636,59175,-27299,575,49152,7200,'false'),
  679. (64,35636,59220,-27299,575,49152,7200,'false'),
  680. (64,35636,59260,-27299,575,49152,7200,'false'),
  681. (64,35636,59300,-27299,575,49152,7200,'false'),
  682. (64,35637,57288,-27776,587,32768,7200,'false'),
  683. (64,35636,57174,-27680,587,32768,7200,'false'),
  684. (64,35636,57175,-27643,587,32768,7200,'false'),
  685. (64,35636,57175,-27606,587,32768,7200,'false'),
  686. (64,35636,57175,-27755,587,32768,7200,'false'),
  687. (64,35636,57174,-27718,587,32768,7200,'false'),
  688. (64,35634,57237,-27608,576,32768,7200,'false'),
  689. (64,35634,57239,-27763,576,32768,7200,'false'),
  690. (64,35636,57209,-27701,587,32768,7200,'false'),
  691. (64,35636,57210,-27664,587,32768,7200,'false'),
  692. (64,35636,57209,-27627,587,32768,7200,'false'),
  693. (64,35636,57210,-27776,587,32768,7200,'false'),
  694. (64,35636,57209,-27739,587,32768,7200,'false'),
  695. (64,35634,57239,-27725,576,32768,7200,'false'),
  696. (64,35634,57238,-27687,576,32768,7200,'false'),
  697. (64,35634,57237,-27648,576,32768,7200,'false'),
  698. (64,35634,57260,-27625,576,32768,7200,'false'),
  699. (64,35634,57262,-27779,576,32768,7200,'false'),
  700. (64,35634,57262,-27742,576,32768,7200,'false'),
  701. (64,35634,57262,-27704,576,32768,7200,'false'),
  702. (64,35634,57261,-27665,576,32768,7200,'false'),
  703. (64,35637,57288,-27732,587,32768,7200,'false'),
  704. (64,35637,57288,-27687,587,32768,7200,'false'),
  705. (64,35637,57288,-27644,587,32768,7200,'false'),
  706. (64,35637,57288,-27599,587,32768,7200,'false'),
  707. (64,35637,57256,-27574,587,32768,7200,'false'),
  708. (64,35637,57543,-27786,587,32768,1200,'false'),
  709. (64,35636,57429,-27690,587,32768,1200,'false'),
  710. (64,35636,57430,-27653,587,32768,1200,'false'),
  711. (64,35636,57429,-27616,587,32768,1200,'false'),
  712. (64,35636,57430,-27765,587,32768,1200,'false'),
  713. (64,35636,57429,-27727,587,32768,1200,'false'),
  714. (64,35634,57492,-27618,576,32768,1200,'false'),
  715. (64,35634,57494,-27772,576,32768,1200,'false'),
  716. (64,35636,57464,-27711,587,32768,1200,'false'),
  717. (64,35636,57465,-27674,587,32768,1200,'false'),
  718. (64,35636,57464,-27637,587,32768,1200,'false'),
  719. (64,35636,57464,-27785,587,32768,1200,'false'),
  720. (64,35636,57463,-27748,587,32768,1200,'false'),
  721. (64,35634,57494,-27735,576,32768,1200,'false'),
  722. (64,35634,57493,-27697,576,32768,1200,'false'),
  723. (64,35634,57492,-27658,576,32768,1200,'false'),
  724. (64,35634,57515,-27634,576,32768,1200,'false'),
  725. (64,35634,57517,-27789,576,32768,1200,'false'),
  726. (64,35634,57517,-27752,576,32768,1200,'false'),
  727. (64,35634,57516,-27714,576,32768,1200,'false'),
  728. (64,35634,57515,-27675,576,32768,1200,'false'),
  729. (64,35637,57543,-27742,587,32768,1200,'false'),
  730. (64,35637,57543,-27697,587,32768,1200,'false'),
  731. (64,35637,57543,-27654,587,32768,1200,'false'),
  732. (64,35637,57543,-27609,587,32768,1200,'false'),
  733. (64,35637,57578,-27783,587,32768,1200,'false'),
  734. (64,35637,57578,-27739,587,32768,1200,'false'),
  735. (64,35637,57578,-27695,587,32768,1200,'false'),
  736. (64,35637,57578,-27651,587,32768,1200,'false'),
  737. (64,35637,57578,-27607,587,32768,1200,'false'),
  738. (64,35637,57476,-27575,587,32768,1200,'false'),
  739. (64,35637,57511,-27573,587,32768,1200,'false'),
  740. (64,35637,57473,-27837,587,32768,1200,'false'),
  741. (64,35637,57508,-27835,587,32768,1200,'false'),
  742. (64,35637,57905,-27648,576,32768,7200,'false'),
  743. (64,35637,57905,-27712,576,32768,7200,'false'),
  744. (64,35637,58233,-27182,576,32768,7200,'false'),
  745. (64,35637,58233,-27232,576,32768,7200,'false'),
  746. (64,35637,58233,-27282,576,32768,7200,'false'),
  747. (64,35637,58233,-27332,576,32768,7200,'false'),
  748. (64,35637,58233,-27382,576,32768,7200,'false'),
  749. (64,35637,58233,-27432,576,32768,7200,'false'),
  750. (64,35637,58233,-27482,576,32768,7200,'false'),
  751. (64,35637,58233,-27532,576,32768,7200,'false'),
  752. (64,35637,58233,-27582,576,32768,7200,'false'),
  753. (64,35637,58233,-27632,576,32768,7200,'false'),
  754. (64,35637,58233,-27682,576,32768,7200,'false'),
  755. (64,35637,58233,-27732,576,32768,7200,'false'),
  756. (64,35637,58233,-27782,576,32768,7200,'false'),
  757. (64,35629,58680,-27507,592,32768,7200,'true');
  758. INSERT INTO `clanhall_siege_guards` VALUES
  759. -- Rainbow Springs
  760. (62,35596,151552,-127075,-2208,5896,60,'false'),
  761. (62,35588,151557,-126987,-2224,0,7200,'false'),
  762. -- (62,35593,anywhere - total 1,0,60,'false'), TODO: needs support for random spawn by zone.
  763. -- (62,35594,anywhere - total 1,0,60,'false'), TODO: needs support for random spawn by zone.
  764. -- (62,35595,anywhere - total 10,0,60,'false'), TODO: needs support for random spawn by zone.
  765. (62,35597,153136,-125333,-2208,-16328,60,'false'),
  766. (62,35589,153135,-125425,-2224,0,7200,'false'),
  767. -- (62,35593,anywhere - total 1,0,60,'false'), TODO: needs support for random spawn by zone.
  768. -- (62,35594,anywhere - total 1,0,60,'false'), TODO: needs support for random spawn by zone.
  769. -- (62,35595,anywhere - total 10,0,60,'false'), TODO: needs support for random spawn by zone.
  770. (62,35598,155660,-125753,-2208,-16496,60,'false'),
  771. (62,35590,155661,-125844,-2224,0,7200,'false'),
  772. -- (62,35593,anywhere - total 1,0,60,'false'), TODO: needs support for random spawn by zone.
  773. -- (62,35594,anywhere - total 1,0,60,'false'), TODO: needs support for random spawn by zone.
  774. -- (62,35595,anywhere - total 10,0,60,'false'), TODO: needs support for random spawn by zone.
  775. (62,35599,153887,-127538,-2208,15992,60,'false'),
  776. (62,35591,153888,-127444,-2224,0,7200,'false');
  777. -- (62,35593,anywhere - total 1,0,60,'false'), TODO: needs support for random spawn by zone.
  778. -- (62,35594,anywhere - total 1,0,60,'false'), TODO: needs support for random spawn by zone.
  779. -- (62,35595,anywhere - total 10,0,60,'false'); TODO: needs support for random spawn by zone.