API tools faq
paste
Advertisement
Fuzzysteve

Untitled

Fuzzysteve
Apr 17th, 2017
731
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 38.73 KB | None | 0 0
raw download clone embed print report
  1. +--------+-----------------------------------+-----------+-----------+------------+--------------+------------+-----------+
  2. | typeid | typename | Low Slots | Med Slots | High Slots | power Output | CPU Output | Rig Slots |
  3. +--------+-----------------------------------+-----------+-----------+------------+--------------+------------+-----------+
  4. | 582 | Bantam | 2 | 4 | 3 | 39 | 200 | 3 |
  5. | 583 | Condor | 2 | 4 | 4 | 35 | 185 | NULL |
  6. | 584 | Griffin | 2 | 5 | 2 | 24 | 240 | NULL |
  7. | 585 | Slasher | 2 | 4 | 4 | 36 | 140 | NULL |
  8. | 586 | Probe | 3 | 4 | 3 | 25 | 240 | NULL |
  9. | 587 | Rifter | 3 | 3 | 4 | 41 | 130 | 3 |
  10. | 589 | Executioner | 3 | 3 | 4 | 45 | 140 | 3 |
  11. | 590 | Inquisitor | 4 | 2 | 3 | 51 | 135 | 3 |
  12. | 591 | Tormentor | 4 | 3 | 3 | 50 | 130 | 3 |
  13. | 592 | Navitas | 3 | 3 | 3 | 49 | 145 | 3 |
  14. | 593 | Tristan | 3 | 3 | 3 | 35 | 130 | 3 |
  15. | 594 | Incursus | 4 | 3 | 3 | 45 | 135 | 3 |
  16. | 597 | Punisher | 5 | 2 | 4 | 67 | 140 | 3 |
  17. | 598 | Breacher | 3 | 4 | 3 | 37 | 180 | 3 |
  18. | 599 | Burst | 3 | 3 | 3 | 40 | 190 | 3 |
  19. | 602 | Kestrel | 2 | 4 | 4 | 45 | 180 | 3 |
  20. | 603 | Merlin | 3 | 4 | 3 | 40 | 180 | 3 |
  21. | 605 | Heron | 2 | 5 | 3 | 24 | 260 | NULL |
  22. | 607 | Imicus | 3 | 4 | 3 | 21 | 250 | NULL |
  23. | 608 | Atron | 3 | 3 | 4 | 37 | 147 | NULL |
  24. | 609 | Maulus | 3 | 4 | 2 | 28 | 230 | NULL |
  25. | 620 | Osprey | 3 | 5 | 5 | 470 | 380 | 3 |
  26. | 621 | Caracal | 4 | 5 | 5 | 630 | 430 | 3 |
  27. | 622 | Stabber | 4 | 4 | 6 | 715 | 340 | 3 |
  28. | 623 | Moa | 4 | 5 | 5 | 850 | 380 | 3 |
  29. | 624 | Maller | 6 | 3 | 5 | 1150 | 300 | 3 |
  30. | 625 | Augoror | 5 | 3 | 5 | 650 | 275 | 3 |
  31. | 626 | Vexor | 5 | 4 | 4 | 800 | 300 | 3 |
  32. | 627 | Thorax | 5 | 4 | 5 | 820 | 330 | 3 |
  33. | 628 | Arbitrator | 5 | 4 | 4 | 575 | 325 | 3 |
  34. | 629 | Rupture | 5 | 4 | 5 | 860 | 350 | 3 |
  35. | 630 | Bellicose | 4 | 5 | 4 | 575 | 360 | 3 |
  36. | 631 | Scythe | 5 | 5 | 3 | 345 | 285 | 3 |
  37. | 632 | Blackbird | 3 | 6 | 4 | 525 | 425 | 3 |
  38. | 633 | Celestis | 5 | 5 | 3 | 575 | 375 | 3 |
  39. | 634 | Exequror | 6 | 4 | 3 | 610 | 275 | 3 |
  40. | 635 | Opux Luxury Yacht | 6 | 6 | 6 | 6 | 6 | 6 |
  41. | 638 | Raven | 5 | 7 | 7 | 11000 | 750 | 3 |
  42. | 639 | Tempest | 6 | 5 | 8 | 16000 | 550 | 3 |
  43. | 640 | Scorpion | 5 | 8 | 5 | 9000 | 750 | 3 |
  44. | 641 | Megathron | 8 | 4 | 7 | 15500 | 600 | 3 |
  45. | 642 | Apocalypse | 7 | 4 | 8 | 21000 | 540 | 3 |
  46. | 643 | Armageddon | 7 | 4 | 7 | 13500 | 550 | 3 |
  47. | 644 | Typhoon | 7 | 5 | 7 | 12500 | 640 | 3 |
  48. | 645 | Dominix | 7 | 5 | 6 | 10000 | 600 | 3 |
  49. | 648 | Badger | 4 | 6 | 2 | 185 | 380 | NULL |
  50. | 649 | Tayra | 4 | 5 | 2 | 80 | 320 | NULL |
  51. | 650 | Nereus | 5 | 5 | 2 | 215 | 350 | NULL |
  52. | 651 | Hoarder | 3 | 4 | 3 | 180 | 300 | NULL |
  53. | 652 | Mammoth | 5 | 4 | 2 | 80 | 250 | NULL |
  54. | 653 | Wreathe | 5 | 5 | 2 | 200 | 320 | NULL |
  55. | 654 | Kryos | 4 | 4 | 2 | 110 | 250 | NULL |
  56. | 655 | Epithal | 4 | 4 | 2 | 130 | 270 | NULL |
  57. | 656 | Miasmos | 4 | 4 | 2 | 120 | 260 | NULL |
  58. | 657 | Iteron Mark V | 5 | 4 | 2 | 85 | 270 | NULL |
  59. | 671 | Erebus | 7 | 7 | 7 | 7 | 7 | 7 |
  60. | 1944 | Bestower | 6 | 3 | 2 | 90 | 230 | NULL |
  61. | 2006 | Omen | 6 | 3 | 5 | 925 | 315 | 3 |
  62. | 2161 | Crucifier | 3 | 4 | 2 | 27 | 235 | NULL |
  63. | 2834 | Utu | 4 | 4 | 3 | 47 | 225 | 2 |
  64. | 2836 | Adrestia | 6 | 4 | 5 | 1284 | 370 | 2 |
  65. | 2998 | Noctis | 3 | 2 | 8 | 250 | 300 | 3 |
  66. | 3514 | Revenant | 6 | 7 | 6 | 625000 | 950 | 3 |
  67. | 3516 | Malice | 3 | 3 | 5 | 77 | 178 | 2 |
  68. | 3518 | Vangel | 5 | 4 | 6 | 1176 | 374 | 2 |
  69. | 3532 | Echelon | 0 | 1 | 0 | 0 | 0 | 0 |
  70. | 3756 | Gnosis | 6 | 6 | 6 | 1200 | 444 | 3 |
  71. | 3764 | Leviathan | 5 | 5 | 5 | 5 | 5 | 5 |
  72. | 3766 | Vigil | 2 | 5 | 2 | 26 | 225 | NULL |
  73. | 4302 | Oracle | 6 | 3 | 8 | 1375 | 345 | 3 |
  74. | 4306 | Naga | 3 | 6 | 8 | 875 | 425 | 3 |
  75. | 4308 | Talos | 5 | 4 | 8 | 1100 | 360 | 3 |
  76. | 4310 | Tornado | 4 | 5 | 8 | 1000 | 342 | 3 |
  77. | 4363 | Miasmos Quafe Ultra Edition | 3 | 4 | 1 | 70 | 750 | 3 |
  78. | 4388 | Miasmos Quafe Ultramarine Edition | 3 | 4 | 1 | 70 | 750 | 3 |
  79. | 11011 | Guardian-Vexor | 5 | 5 | 5 | 5 | 5 | 5 |
  80. | 11172 | Helios | 3 | 3 | 3 | 3 | 3 | 3 |
  81. | 11174 | Keres | 3 | 5 | 2 | 33 | 205 | 2 |
  82. | 11176 | Crow | 2 | 4 | 4 | 35 | 165 | 2 |
  83. | 11178 | Raptor | 3 | 4 | 3 | 38 | 160 | 2 |
  84. | 11182 | Cheetah | 3 | 3 | 3 | 3 | 3 | 3 |
  85. | 11184 | Crusader | 4 | 2 | 4 | 48 | 120 | 2 |
  86. | 11186 | Malediction | 4 | 3 | 3 | 36 | 150 | 2 |
  87. | 11188 | Anathema | 3 | 3 | 3 | 3 | 3 | 3 |
  88. | 11190 | Sentinel | 3 | 4 | 3 | 40 | 195 | 2 |
  89. | 11192 | Buzzard | 2 | 2 | 2 | 2 | 2 | 2 |
  90. | 11194 | Kitsune | 2 | 5 | 3 | 26 | 270 | 2 |
  91. | 11196 | Claw | 4 | 2 | 4 | 45 | 125 | 2 |
  92. | 11198 | Stiletto | 3 | 4 | 3 | 30 | 150 | 2 |
  93. | 11200 | Taranis | 3 | 3 | 4 | 35 | 150 | 2 |
  94. | 11202 | Ares | 4 | 3 | 3 | 33 | 145 | 2 |
  95. | 11365 | Vengeance | 4 | 4 | 4 | 4 | 4 | 4 |
  96. | 11371 | Wolf | 5 | NULL | NULL | NULL | 135 | NULL |
  97. | 11377 | Nemesis | 2 | 4 | 5 | 38 | 315 | 2 |
  98. | 11379 | Hawk | 2 | 2 | 2 | 2 | 2 | 2 |
  99. | 11381 | Harpy | 3 | NULL | NULL | NULL | 185 | NULL |
  100. | 11387 | Hyena | 3 | 4 | 3 | 36 | 145 | 2 |
  101. | 11393 | Retribution | 5 | 5 | 5 | 5 | 5 | 5 |
  102. | 11400 | Jaguar | 4 | NULL | NULL | NULL | 170 | NULL |
  103. | 11567 | Avatar | 8 | 8 | 8 | 8 | 8 | 8 |
  104. | 11936 | Apocalypse Imperial Issue | 8 | 8 | 8 | 8 | 8 | 8 |
  105. | 11938 | Armageddon Imperial Issue | 8 | 8 | 8 | 8 | 8 | 8 |
  106. | 11940 | Gold Magnate | 6 | NULL | 3 | NULL | NULL | NULL |
  107. | 11942 | Silver Magnate | 5 | NULL | 3 | NULL | NULL | NULL |
  108. | 11957 | Falcon | 3 | 3 | 3 | 3 | 3 | 3 |
  109. | 11959 | Rook | 3 | 3 | 3 | 3 | 3 | 3 |
  110. | 11961 | Huginn | 4 | NULL | 5 | NULL | NULL | NULL |
  111. | 11963 | Rapier | 4 | 4 | 4 | 4 | 4 | 4 |
  112. | 11965 | Pilgrim | 5 | 5 | 5 | 5 | 5 | 5 |
  113. | 11969 | Arazu | 4 | 4 | 4 | 4 | 4 | 4 |
  114. | 11971 | Lachesis | 4 | NULL | 4 | 850 | NULL | NULL |
  115. | 11978 | Scimitar | 4 | 4 | 4 | 4 | 4 | 4 |
  116. | 11985 | Basilisk | 2 | 2 | 2 | 2 | 2 | 2 |
  117. | 11987 | Guardian | 5 | 5 | 5 | 5 | 5 | 5 |
  118. | 11989 | Oneiros | 5 | 4 | NULL | 1050 | NULL | NULL |
  119. | 11993 | Cerberus | 4 | 5 | 6 | 800 | 520 | NULL |
  120. | 11995 | Onyx | 4 | 6 | 6 | 900 | 560 | 2 |
  121. | 11999 | Vagabond | 5 | 4 | 6 | 900 | 400 | NULL |
  122. | 12003 | Zealot | 7 | 3 | 5 | 1180 | 340 | NULL |
  123. | 12005 | Ishtar | 6 | 4 | 4 | 740 | 340 | NULL |
  124. | 12011 | Eagle | 4 | 6 | 5 | 990 | 440 | NULL |
  125. | 12013 | Broadsword | 4 | 6 | 6 | 1010 | 392 | 2 |
  126. | 12015 | Muninn | 6 | 3 | 6 | 1160 | 355 | NULL |
  127. | 12017 | Devoter | 7 | 3 | 6 | 1265 | 368 | 2 |
  128. | 12019 | Sacrilege | 5 | 4 | 6 | 1100 | 420 | NULL |
  129. | 12021 | Phobos | 6 | 4 | 6 | 1165 | 375 | 2 |
  130. | 12023 | Deimos | 6 | 4 | 5 | 1050 | 360 | NULL |
  131. | 12032 | Manticore | 2 | 4 | 5 | 38 | 330 | 2 |
  132. | 12034 | Hound | 3 | 3 | 5 | 40 | 310 | 2 |
  133. | 12038 | Purifier | 3 | 3 | 5 | 45 | 305 | 2 |
  134. | 12042 | Ishkur | 4 | NULL | NULL | NULL | NULL | NULL |
  135. | 12044 | Enyo | 4 | 4 | 4 | 4 | 4 | 4 |
  136. | 12729 | Crane | 2 | 4 | 2 | 125 | 285 | 2 |
  137. | 12731 | Bustard | 3 | 6 | 2 | 200 | 290 | 2 |
  138. | 12733 | Prorator | 4 | 2 | 2 | 150 | 200 | 2 |
  139. | 12735 | Prowler | 3 | 3 | 2 | 130 | 230 | 2 |
  140. | 12743 | Viator | 3 | 3 | 2 | 135 | 250 | 2 |
  141. | 12745 | Occator | 6 | 3 | 2 | 290 | 260 | 2 |
  142. | 12747 | Mastodon | 4 | 5 | 2 | 230 | 270 | 2 |
  143. | 12753 | Impel | 7 | 2 | 2 | 330 | 240 | 2 |
  144. | 13202 | Megathron Federate Issue | 8 | 8 | 8 | 8 | 8 | 8 |
  145. | 16227 | Ferox | 4 | 6 | 7 | 1250 | 530 | 3 |
  146. | 16229 | Brutix | 6 | 4 | 7 | 1125 | 435 | 3 |
  147. | 16231 | Cyclone | 5 | 5 | 7 | 1100 | 525 | 3 |
  148. | 16233 | Prophecy | 7 | 4 | 5 | 1100 | 415 | 3 |
  149. | 16236 | Coercer | 3 | 2 | 8 | 85 | 168 | 3 |
  150. | 16238 | Cormorant | 2 | 3 | 8 | 68 | 200 | 3 |
  151. | 16240 | Catalyst | 3 | 2 | 8 | 70 | 178 | 3 |
  152. | 16242 | Thrasher | 2 | 3 | 8 | 70 | 170 | 3 |
  153. | 17476 | Covetor | 3 | 1 | 2 | 30 | 240 | 3 |
  154. | 17478 | Retriever | 3 | 1 | 2 | 35 | 235 | 3 |
  155. | 17480 | Procurer | 2 | 4 | 2 | 52 | 310 | 3 |
  156. | 17619 | Caldari Navy Hookbill | 2 | 5 | 3 | 37 | 165 | 3 |
  157. | 17634 | Caracal Navy Issue | 4 | 5 | 6 | 715 | 465 | 3 |
  158. | 17636 | Raven Navy Issue | 5 | 7 | 8 | 12000 | 780 | 3 |
  159. | 17703 | Imperial Navy Slicer | 5 | 2 | 3 | 50 | 125 | 3 |
  160. | 17709 | Omen Navy Issue | 7 | 3 | 5 | 960 | 335 | 3 |
  161. | 17713 | Stabber Fleet Issue | 6 | 4 | 5 | 950 | 310 | 3 |
  162. | 17715 | Gila | 3 | 6 | 5 | 670 | 380 | 3 |
  163. | 17718 | Phantasm | 5 | 6 | 4 | 890 | 380 | 3 |
  164. | 17720 | Cynabal | 5 | 5 | 5 | 980 | 335 | 3 |
  165. | 17722 | Vigilant | 6 | 4 | 5 | 1050 | 360 | 3 |
  166. | 17726 | Apocalypse Navy Issue | 8 | 4 | 8 | 22000 | 580 | 3 |
  167. | 17728 | Megathron Navy Issue | 8 | 4 | 8 | 16275 | 630 | 3 |
  168. | 17732 | Tempest Fleet Issue | 7 | 5 | 8 | 17500 | 580 | 3 |
  169. | 17736 | Nightmare | 6 | 7 | 6 | 14500 | 710 | 3 |
  170. | 17738 | Machariel | 7 | 5 | 8 | 17950 | 600 | 3 |
  171. | 17740 | Vindicator | 7 | 5 | 8 | 17500 | 630 | 3 |
  172. | 17812 | Republic Fleet Firetail | 3 | 4 | 3 | 40 | 150 | 3 |
  173. | 17841 | Federation Navy Comet | 4 | 3 | 3 | 40 | 160 | 3 |
  174. | 17843 | Vexor Navy Issue | 6 | 4 | 4 | 800 | 310 | 3 |
  175. | 17918 | Rattlesnake | 6 | 7 | 6 | 10000 | 710 | 3 |
  176. | 17920 | Bhaalgorn | 7 | 5 | 7 | 18400 | 588 | 3 |
  177. | 17922 | Ashimmu | 6 | 4 | 5 | 1300 | 350 | 3 |
  178. | 17924 | Succubus | 3 | 4 | 3 | 44 | 170 | 3 |
  179. | 17926 | Cruor | 4 | 3 | 4 | 57 | 150 | 3 |
  180. | 17928 | Daredevil | 4 | 3 | 3 | 35 | 145 | 3 |
  181. | 17930 | Worm | 2 | 4 | 3 | 40 | 160 | 3 |
  182. | 17932 | Dramiel | 3 | 4 | 3 | 37 | 133 | 3 |
  183. | 19720 | Revelation | 8 | 8 | 8 | 8 | 8 | 8 |
  184. | 19722 | Naglfar | 6 | 6 | 6 | 6 | 6 | 6 |
  185. | 19724 | Moros | 7 | 7 | 7 | 7 | 7 | 7 |
  186. | 19726 | Phoenix | 5 | 5 | 5 | 5 | 5 | 5 |
  187. | 19744 | Sigil | 6 | 4 | 2 | 250 | 300 | NULL |
  188. | 20125 | Curse | 4 | 4 | 4 | 4 | 4 | 4 |
  189. | 20183 | Providence | 3 | 0 | 0 | 3 | 1 | 0 |
  190. | 20185 | Charon | 3 | 0 | 0 | 3 | 1 | 0 |
  191. | 20187 | Obelisk | 3 | 0 | 0 | 3 | 1 | 0 |
  192. | 20189 | Fenrir | 3 | 0 | 0 | 3 | 1 | 0 |
  193. | 22428 | Redeemer | 7 | 7 | 7 | 7 | 7 | 7 |
  194. | 22430 | Sin | 6 | 6 | 6 | 6 | 6 | 6 |
  195. | 22436 | Widow | 4 | 4 | 4 | 4 | 4 | 4 |
  196. | 22440 | Panther | 6 | 6 | 6 | 6 | 6 | 6 |
  197. | 22442 | Eos | 6 | 4 | 6 | 1200 | 425 | 2 |
  198. | 22444 | Sleipnir | 5 | 5 | 7 | 1300 | 475 | 2 |
  199. | 22446 | Vulture | 4 | 6 | 7 | 1275 | 545 | 2 |
  200. | 22448 | Absolution | 7 | 3 | 7 | 1500 | 400 | 2 |
  201. | 22452 | Heretic | 3 | 3 | 8 | 60 | 240 | 2 |
  202. | 22456 | Sabre | 2 | 4 | 8 | 58 | 230 | 2 |
  203. | 22460 | Eris | 4 | 2 | 8 | 64 | 210 | 2 |
  204. | 22464 | Flycatcher | 1 | 5 | 8 | 63 | 280 | 2 |
  205. | 22466 | Astarte | 6 | 4 | 7 | 1350 | 440 | 2 |
  206. | 22468 | Claymore | 4 | 6 | 7 | 1100 | 525 | 2 |
  207. | 22470 | Nighthawk | 5 | 5 | 7 | 1000 | 560 | 2 |
  208. | 22474 | Damnation | 6 | 4 | 7 | 1300 | 500 | 2 |
  209. | 22544 | Hulk | 3 | 4 | 2 | 35 | 270 | 2 |
  210. | 22546 | Skiff | 3 | 5 | 2 | 58 | 360 | 2 |
  211. | 22548 | Mackinaw | 3 | 4 | 2 | 35 | 270 | 2 |
  212. | 22852 | Hel | 5 | 5 | 5 | 5 | 5 | 5 |
  213. | 23757 | Archon | 7 | 7 | 7 | 7 | 7 | 7 |
  214. | 23773 | Ragnarok | 6 | 6 | 6 | 6 | 6 | 6 |
  215. | 23911 | Thanatos | 6 | 6 | 6 | 6 | 6 | 6 |
  216. | 23913 | Nyx | 7 | 7 | 7 | 7 | 7 | 7 |
  217. | 23915 | Chimera | 4 | 4 | 4 | 4 | 4 | 4 |
  218. | 23917 | Wyvern | 4 | 4 | 4 | 4 | 4 | 4 |
  219. | 23919 | Aeon | 8 | 8 | 8 | 8 | 8 | 8 |
  220. | 24483 | Nidhoggur | 5 | 6 | NULL | 500000 | 775 | NULL |
  221. | 24688 | Rokh | 5 | 6 | 8 | 15000 | 780 | 3 |
  222. | 24690 | Hyperion | 7 | 5 | 7 | 16000 | 600 | 3 |
  223. | 24692 | Abaddon | 7 | 4 | 8 | 21000 | 560 | 3 |
  224. | 24694 | Maelstrom | 5 | 6 | 8 | 21000 | 640 | 3 |
  225. | 24696 | Harbinger | 6 | 4 | 7 | 1425 | 375 | 3 |
  226. | 24698 | Drake | 4 | 6 | 7 | 830 | 500 | 3 |
  227. | 24700 | Myrmidon | 6 | 5 | 5 | 1050 | 400 | 3 |
  228. | 24702 | Hurricane | 6 | 4 | 7 | 1140 | 400 | 3 |
  229. | 26840 | Raven State Issue | 6 | 6 | 6 | 6 | 6 | 6 |
  230. | 26842 | Tempest Tribal Issue | 7 | 7 | 7 | 7 | 7 | 7 |
  231. | 28352 | Rorqual | 3 | 3 | 3 | 3 | 3 | 3 |
  232. | 28606 | Orca | 2 | 2 | 2 | 2 | 2 | 2 |
  233. | 28659 | Paladin | 7 | 4 | 8 | 16000 | 530 | 2 |
  234. | 28661 | Kronos | 7 | 4 | 8 | 14000 | 580 | 2 |
  235. | 28665 | Vargur | 5 | 6 | 8 | 12900 | 625 | 2 |
  236. | 28710 | Golem | 4 | 7 | 8 | 8500 | 715 | 2 |
  237. | 28844 | Rhea | 3 | 0 | 0 | 3 | 5 | 0 |
  238. | 28846 | Nomad | 3 | 0 | 0 | 3 | 5 | 0 |
  239. | 28848 | Anshar | 3 | 0 | 0 | 3 | 5 | 0 |
  240. | 28850 | Ark | 3 | 0 | 0 | 3 | 5 | 0 |
  241. | 29248 | Magnate | 4 | 3 | 3 | 26 | 230 | 3 |
  242. | 29336 | Scythe Fleet Issue | 5 | 5 | 5 | 745 | 400 | 3 |
  243. | 29337 | Augoror Navy Issue | 7 | 3 | 5 | 1150 | 320 | 3 |
  244. | 29340 | Osprey Navy Issue | 4 | 6 | 5 | 730 | 450 | 3 |
  245. | 29344 | Exequror Navy Issue | 6 | 4 | 5 | 830 | 340 | 3 |
  246. | 32207 | Freki | 4 | 4 | 3 | 54 | 187 | 2 |
  247. | 32209 | Mimir | 6 | 3 | 6 | 1172 | 340 | 2 |
  248. | 32305 | Armageddon Navy Issue | 8 | 4 | 8 | 17500 | 560 | 3 |
  249. | 32307 | Dominix Navy Issue | 7 | 6 | 6 | 11000 | 660 | 3 |
  250. | 32309 | Scorpion Navy Issue | 5 | 8 | 7 | 11000 | 780 | 3 |
  251. | 32311 | Typhoon Fleet Issue | 7 | 5 | 8 | 13000 | 660 | 3 |
  252. | 32788 | Cambion | 3 | 5 | 4 | 63 | 225 | 2 |
  253. | 32790 | Etana | 3 | 6 | 6 | 1150 | 520 | 2 |
  254. | 32811 | Miasmos Amastris Edition | 3 | 4 | 1 | 70 | 750 | 3 |
  255. | 32872 | Algos | 3 | 3 | 6 | 55 | 160 | 3 |
  256. | 32874 | Dragoon | 4 | 2 | 6 | 58 | 150 | 3 |
  257. | 32876 | Corax | 2 | 4 | 7 | 48 | 210 | 3 |
  258. | 32878 | Talwar | 3 | 3 | 7 | 51 | 200 | 3 |
  259. | 32880 | Venture | 1 | 3 | 3 | 45 | 240 | 3 |
  260. | 33151 | Brutix Navy Issue | 7 | 4 | 7 | 1235 | 455 | 3 |
  261. | 33153 | Drake Navy Issue | 4 | 6 | 8 | 950 | 550 | 3 |
  262. | 33155 | Harbinger Navy Issue | 6 | 5 | 7 | 1495 | 410 | 3 |
  263. | 33157 | Hurricane Fleet Issue | 6 | 4 | 8 | 1380 | 420 | 3 |
  264. | 33395 | Moracha | 5 | 6 | 4 | 850 | 400 | 2 |
  265. | 33397 | Chremoas | 3 | 5 | 3 | 45 | 275 | 2 |
  266. | 33468 | Astero | 4 | 4 | 2 | 32 | 170 | 3 |
  267. | 33470 | Stratios | 5 | 5 | 5 | 920 | 400 | 3 |
  268. | 33472 | Nestor | 6 | 6 | 7 | 11250 | 680 | 3 |
  269. | 33553 | Stratios Emergency Responder | 5 | 5 | 5 | 950 | 430 | 3 |
  270. | 33673 | Whiptail | 4 | 4 | 3 | 35 | 160 | 2 |
  271. | 33675 | Chameleon | 4 | 7 | 4 | 475 | 600 | 2 |
  272. | 33697 | Prospect | 4 | 3 | 3 | 45 | 290 | 2 |
  273. | 33816 | Garmur | 3 | 4 | 3 | 38 | 178 | 3 |
  274. | 33818 | Orthrus | 4 | 5 | 6 | 900 | 460 | 3 |
  275. | 33820 | Barghest | 6 | 6 | 8 | 11600 | 730 | 3 |
  276. | 34151 | Rattlesnake Victory Edition | 6 | 7 | 6 | 10000 | 710 | 3 |
  277. | 34317 | Confessor | 5 | 3 | 6 | 62 | 180 | 3 |
  278. | 34328 | Bowhead | 3 | 3 | 0 | 1350 | 215 | 3 |
  279. | 34562 | Svipul | 4 | 4 | 6 | 54 | 205 | 3 |
  280. | 34590 | Victorieux Luxury Yacht | 4 | 1 | 1 | 300 | 130 | 3 |
  281. | 34828 | Jackdaw | 3 | 5 | 6 | 57 | 270 | 3 |
  282. | 35683 | Hecate | 4 | 4 | 6 | 54 | 230 | 3 |
  283. | 35779 | Imp | 4 | 4 | 3 | 50 | 180 | 2 |
  284. | 35781 | Fiend | 5 | 7 | 5 | 900 | 450 | 2 |
  285. | 37135 | Endurance | 3 | 4 | 3 | 40 | 280 | 2 |
  286. | 37453 | Crucifier Navy Issue | 3 | 4 | 3 | 42 | 160 | 3 |
  287. | 37454 | Vigil Fleet Issue | 3 | 4 | 3 | 38 | 190 | 3 |
  288. | 37455 | Griffin Navy Issue | 2 | 5 | 3 | 40 | 180 | 3 |
  289. | 37456 | Maulus Navy Issue | 4 | 3 | 2 | 35 | 150 | 3 |
  290. | 37457 | Deacon | 5 | 2 | 3 | 57 | 145 | 2 |
  291. | 37458 | Kirin | 2 | 5 | 3 | 42 | 215 | 2 |
  292. | 37459 | Thalia | 4 | 3 | 3 | 55 | 155 | 2 |
  293. | 37460 | Scalpel | 3 | 4 | 3 | 42 | 200 | 2 |
  294. | 37480 | Bifrost | 3 | 5 | 6 | 58 | 250 | 2 |
  295. | 37481 | Pontifex | 5 | 3 | 5 | 55 | 220 | 2 |
  296. | 37482 | Stork | 2 | 6 | 6 | 63 | 280 | 2 |
  297. | 37483 | Magus | 4 | 4 | 5 | 59 | 210 | 2 |
  298. | 37604 | Apostle | 7 | 4 | 6 | 825000 | 675 | 3 |
  299. | 37605 | Minokawa | 4 | 7 | 6 | 475000 | 925 | 3 |
  300. | 37606 | Lif | 5 | 6 | 6 | 630000 | 800 | 3 |
  301. | 37607 | Ninazu | 6 | 5 | 6 | 760000 | 775 | 3 |
  302. | 42124 | Vehement | 7 | 6 | 5 | 725000 | 825 | 3 |
  303. | 42125 | Vendetta | 7 | 5 | 7 | 907500 | 880 | 3 |
  304. | 42126 | Vanquisher | 8 | 6 | 8 | 1155000 | 1045 | 3 |
  305. | 42244 | Porpoise | 2 | 4 | 4 | 420 | 350 | 3 |
  306. | 42245 | Rabisu | 6 | 3 | 6 | 1025 | 330 | 2 |
  307. | 42246 | Caedes | 5 | 3 | 4 | 60 | 190 | 2 |
  308. | 42685 | Sunesis | 4 | 4 | 4 | 63 | 175 | 3 |
  309. +--------+-----------------------------------+-----------+-----------+------------+--------------+------------+-----------+
  310. 305 rows in set (0.01 sec)
  311.  
  312.  
  313.  
  314.  
  315. select invTypes.typeid,typename,
  316. coalesce(dta1.valueInt,dta1.valueFloat) "Low Slots",
  317. coalesce(dta1.valueInt,dta2.valueFloat) "Med Slots",
  318. coalesce(dta1.valueInt,dta3.valueFloat) "High Slots",
  319. coalesce(dta1.valueInt,dta4.valueFloat) "power Output",
  320. coalesce(dta1.valueInt,dta5.valueFloat) "CPU Output",
  321. coalesce(dta1.valueInt,dta6.valueFloat) "Rig Slots"
  322. from invTypes
  323. join invGroups on (invTypes.groupid=invGroups.groupid and categoryid=6)
  324. join dgmTypeAttributes dta1 on (dta1.typeid=invTypes.typeid and dta1.attributeid=12)
  325. join dgmTypeAttributes dta2 on (dta2.typeid=invTypes.typeid and dta2.attributeid=13)
  326. join dgmTypeAttributes dta3 on (dta3.typeid=invTypes.typeid and dta3.attributeid=14)
  327. join dgmTypeAttributes dta4 on (dta4.typeid=invTypes.typeid and dta4.attributeid=11)
  328. join dgmTypeAttributes dta5 on (dta5.typeid=invTypes.typeid and dta5.attributeid=48)
  329. join dgmTypeAttributes dta6 on (dta6.typeid=invTypes.typeid and dta6.attributeid=1137)
  330. where invTypes.published=1;
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!