SQL Methods on the dump

From EVEDev

Contents 1 Map 2 Ships 3 Modules 4 Skills 5 Manufacturing 6 Stations 7 Agents

[edit] Map

• Objects in a SolarSystem
  • Objects by groupID
• Count of Systems in Region
• Info on Asteroid Belts in Solar System
• Neighbours of a given Solar System
• Belt count and true security status for Solar Systems in the same constellation
• All lowsec dead-end systems
• Low sec dead-end systems bordering high sec

[edit] Ships

• Ships by Race and class
• Ships and slots

[edit] Modules

• CPU and Powergrid requirements for modules
• Slot requirement for modules

[edit] Skills

• Skills for a career
• All skills with rank
• Primary and Secondary Attributes per rank
• All published skills ordered by skill-group

[edit] Manufacturing

• Published Blueprints
• Bill of Materials

[edit] Stations

• Services provided by station
• List of stations with service

[edit] Agents

• Agents with Location Service