These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
 

Systems and Security

First post
Author
Previous Topic Next Topic
Myfanwy Heimdal
Heimdal Freight and Manufacture Inc
#1 - 2014-09-08 15:38:27 UTC
Is there anywhere where I can download a spreadsheet friendly list of the systems and the security levels.?

Yes, I know there's the static dump thing but the problem is that my SQL Express on this machine was borked in a previous Windows Update and I can't repair it, uninstall it or even install a new version of SQL Express.

So I am stuffed unless some kind soul points me to somewhere where there's an xml dump, a CSV or whatever.

Can someone help please?

Pam:  I wonder what my name means in Welsh?Nessa: Why?
Myfanwy Heimdal
Heimdal Freight and Manufacture Inc
#2 - 2014-09-09 07:00:22 UTC
I have been given a working copy of the database dump (thanks to the kind person who passed it on) and, as ever, I have more questions than answers.

The only place where I can see the Security value for a system is in the table [staStations] but every field is set to zero. So clearly the security setting for a system isn't being stored there.

So where can I find the Security setting of a system or even a station if need be?

Pam:  I wonder what my name means in Welsh?Nessa: Why?
suid0
Pandemic Horde Inc.
Pandemic Horde
#3 - 2014-09-09 09:00:48 UTC  |  Edited by: suid0
Does this help at all?

Quote:

select solarSystemName, security
from mapSolarSystems


Also this probably belongs here

the entire enemy support fleet is dead except for one interdictor a titan could easily finish off with drones  - Commander Ted
Myfanwy Heimdal
Heimdal Freight and Manufacture Inc
#4 - 2014-09-09 09:23:56 UTC
Thanks for the reply. I have just received a CSV file of this missing table. Right, I am going to try to kill this SQL Server and start yet another installation as its really got itself totally borked with the latest updates.

Diolch yn fawr
- Myfanwy

Pam:  I wonder what my name means in Welsh?Nessa: Why?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2014-09-09 11:36:58 UTC