SQL Methods on the dump

From EVEDev

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

[edit] Agents

• Agents with Location Service

[edit] Datacores

• RP per Datacore

[edit] Manufacturing

• Published Blueprints
• Bill of Materials
• Highest Megacyte Percentage

[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
• Loci and Wormhole Name to Class Conversion
• Create Table with Planet Type Counts in Each System

[edit] Modules

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

[edit] Ships

• Ships by Race and class
• Ships and slots
• Ship Stats Viewer by ID

[edit] Skills

• Skills for a career
• All skills with rank
• Primary and Secondary Attributes per rank
• All published skills ordered by skill-group
• All Skills published and displayed in their own groups such as Corporation Management etc...

[edit] Stations

• Services provided by station
• List of stations with service