public EDDIStarSystem GetEDDIStarSystem(string name)
{
if (!File.Exists(DbFile))
{
return(null);
}
EDDIStarSystem result = null;
try
{
using (var con = SimpleDbConnection())
{
con.Open();
using (var cmd = new SQLiteCommand(con))
{
cmd.CommandText = SELECT_BY_NAME_SQL;
cmd.Prepare();
cmd.Parameters.AddWithValue("@name", name);
using (SQLiteDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
result = new EDDIStarSystem();
if (!rdr.IsDBNull(0))
{
result.EliteID = rdr.GetInt32(0);
}
if (!rdr.IsDBNull(1))
{
result.EDDBID = rdr.GetInt32(1);
}
result.Name = rdr.GetString(2);
result.TotalVisits = rdr.GetInt32(3);
result.LastVisit = rdr.GetDateTime(4);
if (!rdr.IsDBNull(5))
{
result.PreviousVisit = rdr.GetDateTime(5);
}
result.StarSystem = JsonConvert.DeserializeObject <StarSystem>(rdr.GetString(6));
result.StarSystemLastUpdated = rdr.GetDateTime(7);
}
}
}
con.Close();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(result);
}
public void SaveEDDIStarSystem(EDDIStarSystem eddiStarSystem)
{
if (!File.Exists(DbFile))
{
CreateDatabase();
}
using (var con = SimpleDbConnection())
{
con.Open();
if (GetEDDIStarSystem(eddiStarSystem.Name) == null)
{
using (var cmd = new SQLiteCommand(con))
{
cmd.CommandText = INSERT_SQL;
cmd.Prepare();
cmd.Parameters.AddWithValue("@eliteid", eddiStarSystem.EliteID);
cmd.Parameters.AddWithValue("@eddbid", eddiStarSystem.EDDBID);
cmd.Parameters.AddWithValue("@name", eddiStarSystem.Name);
cmd.Parameters.AddWithValue("@totalvisits", eddiStarSystem.TotalVisits);
cmd.Parameters.AddWithValue("@lastvisit", eddiStarSystem.LastVisit);
cmd.Parameters.AddWithValue("@previousvisit", eddiStarSystem.PreviousVisit);
cmd.Parameters.AddWithValue("@starsystem", JsonConvert.SerializeObject(eddiStarSystem.StarSystem));
cmd.Parameters.AddWithValue("@starsystemlastupdated", eddiStarSystem.StarSystemLastUpdated);
cmd.ExecuteNonQuery();
}
}
else
{
using (var cmd = new SQLiteCommand(con))
{
cmd.CommandText = UPDATE_SQL;
cmd.Prepare();
cmd.Parameters.AddWithValue("@eliteid", eddiStarSystem.EliteID);
cmd.Parameters.AddWithValue("@eddbid", eddiStarSystem.EDDBID);
cmd.Parameters.AddWithValue("@totalvisits", eddiStarSystem.TotalVisits);
cmd.Parameters.AddWithValue("@lastvisit", eddiStarSystem.LastVisit);
cmd.Parameters.AddWithValue("@previousvisit", eddiStarSystem.PreviousVisit);
cmd.Parameters.AddWithValue("@starsystem", JsonConvert.SerializeObject(eddiStarSystem.StarSystem));
cmd.Parameters.AddWithValue("@starsystemlastupdated", eddiStarSystem.StarSystemLastUpdated);
cmd.Parameters.AddWithValue("@name", eddiStarSystem.Name);
cmd.ExecuteNonQuery();
}
}
con.Close();
}
}
public EDDIStarSystem GetEDDIStarSystem(string name)
{
if (!File.Exists(DbFile)) return null;
EDDIStarSystem result = null;
try
{
using (var con = SimpleDbConnection())
{
con.Open();
using (var cmd = new SQLiteCommand(con))
{
cmd.CommandText = SELECT_BY_NAME_SQL;
cmd.Prepare();
cmd.Parameters.AddWithValue("@name", name);
using (SQLiteDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
result = new EDDIStarSystem();
if (!rdr.IsDBNull(0)) result.EliteID = rdr.GetInt32(0);
if (!rdr.IsDBNull(1)) result.EDDBID = rdr.GetInt32(1);
result.Name = rdr.GetString(2);
result.TotalVisits = rdr.GetInt32(3);
result.LastVisit = rdr.GetDateTime(4);
if (!rdr.IsDBNull(5)) result.PreviousVisit = rdr.GetDateTime(5);
result.StarSystem = JsonConvert.DeserializeObject<StarSystem>(rdr.GetString(6));
result.StarSystemLastUpdated = rdr.GetDateTime(7);
}
}
}
con.Close();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return result;
}
/// <summary>
/// Obtain the EDSM log and sync it with the local datastore
/// </summary>
private void edsmObtainLogClicked(object sender, RoutedEventArgs e)
{
IEDDIStarSystemRepository starSystemRepository = new EDDIStarSystemSqLiteRepository();
StarMapConfiguration starMapConfiguration = StarMapConfiguration.FromFile();
string commanderName;
if (String.IsNullOrEmpty(starMapConfiguration.commanderName))
{
// Fetch the commander name from the companion app
CompanionAppService companionAppService = new CompanionAppService(eddiConfiguration.Debug);
Commander cmdr = companionAppService.Profile();
if (cmdr != null && cmdr.Name != null)
{
commanderName = cmdr.Name;
}
else
{
edsmFetchLogsButton.IsEnabled = false;
edsmFetchLogsButton.Content = "Companion app not configured and no name supplied; cannot obtain logs";
return;
}
}
else
{
commanderName = starMapConfiguration.commanderName;
}
edsmFetchLogsButton.IsEnabled = false;
edsmFetchLogsButton.Content = "Obtaining log...";
StarMapService starMapService = new StarMapService(starMapConfiguration.apiKey, commanderName);
Dictionary<string, StarMapLogInfo> systems = starMapService.getStarMapLog();
foreach (string system in systems.Keys)
{
EDDIStarSystem CurrentStarSystemData = starSystemRepository.GetEDDIStarSystem(system);
if (CurrentStarSystemData == null)
{
// We have no record of this system; set it up
CurrentStarSystemData = new EDDIStarSystem();
CurrentStarSystemData.Name = system;
// Due to the potential large number of systems being imported we don't pull individual system data at this time
}
CurrentStarSystemData.TotalVisits = systems[system].visits;
CurrentStarSystemData.LastVisit = systems[system].lastVisit;
CurrentStarSystemData.PreviousVisit = systems[system].previousVisit;
starSystemRepository.SaveEDDIStarSystem(CurrentStarSystemData);
}
edsmFetchLogsButton.Content = "Log obtained";
}
public static void InvokeNewSystem(ref Dictionary<string, object> state, ref Dictionary<string, Int16?> shortIntValues, ref Dictionary<string, string> textValues, ref Dictionary<string, int?> intValues, ref Dictionary<string, decimal?> decimalValues, ref Dictionary<string, Boolean?> booleanValues, ref Dictionary<string, DateTime?> dateTimeValues, ref Dictionary<string, object> extendedValues)
{
try
{
if (Cmdr == null)
{
// Refetch the profile to set our system
InvokeUpdateProfile(ref state, ref shortIntValues, ref textValues, ref intValues, ref decimalValues, ref booleanValues, ref dateTimeValues, ref extendedValues);
if (Cmdr == null)
{
// Still no luck; assume an error of some sort has been logged by InvokeUpdateProfile()
return;
}
}
bool RecordUpdated = false;
if (CurrentStarSystem == null || Cmdr.StarSystem != CurrentStarSystem.Name)
{
// The star system has changed or we're in init; obtain the data ready for setting the VA values
EDDIStarSystem CurrentStarSystemData = starSystemRepository.GetEDDIStarSystem(Cmdr.StarSystem);
if (CurrentStarSystemData == null)
{
// We have no record of this system; set it up
CurrentStarSystemData = new EDDIStarSystem();
CurrentStarSystemData.Name = Cmdr.StarSystem;
CurrentStarSystemData.StarSystem = DataProviderService.GetSystemData(Cmdr.StarSystem);
CurrentStarSystemData.LastVisit = DateTime.Now;
CurrentStarSystemData.StarSystemLastUpdated = CurrentStarSystemData.LastVisit;
CurrentStarSystemData.TotalVisits = 1;
RecordUpdated = true;
}
else
{
if ((DateTime.Now - CurrentStarSystemData.StarSystemLastUpdated).TotalHours > 12)
{
// Data is stale; refresh it
CurrentStarSystemData.StarSystem = DataProviderService.GetSystemData(CurrentStarSystemData.Name);
CurrentStarSystemData.StarSystemLastUpdated = CurrentStarSystemData.LastVisit;
RecordUpdated = true;
}
// Only update if we have moved (as opposed to reinitialised here)
if (CurrentStarSystem != null)
{
CurrentStarSystemData.PreviousVisit = CurrentStarSystemData.LastVisit;
CurrentStarSystemData.LastVisit = DateTime.Now;
CurrentStarSystemData.TotalVisits++;
RecordUpdated = true;
}
}
if (RecordUpdated)
{
starSystemRepository.SaveEDDIStarSystem(CurrentStarSystemData);
}
StarSystem ThisStarSystem = CurrentStarSystemData.StarSystem;
LastStarSystem = CurrentStarSystem;
CurrentStarSystem = ThisStarSystem;
setString(ref textValues, "System name", CurrentStarSystem.Name);
setString(ref textValues, "System name (spoken)", VATranslations.StarSystem(CurrentStarSystem.Name));
setInt(ref intValues, "System visits", CurrentStarSystemData.TotalVisits);
setDateTime(ref dateTimeValues, "System previous visit", CurrentStarSystemData.PreviousVisit);
setInt(ref intValues, "System population", (int)(CurrentStarSystem.Population / 1000)); // TODO remove in next major release
setDecimal(ref decimalValues, "System population", (decimal)CurrentStarSystem.Population);
setString(ref textValues, "System population", humanize(CurrentStarSystem.Population)); // TODO remove in next major release
setString(ref textValues, "System population (spoken)", humanize(CurrentStarSystem.Population));
setString(ref textValues, "System allegiance", CurrentStarSystem.Allegiance);
setString(ref textValues, "System government", CurrentStarSystem.Government);
setString(ref textValues, "System faction", CurrentStarSystem.Faction);
setString(ref textValues, "System primary economy", CurrentStarSystem.PrimaryEconomy);
setString(ref textValues, "System state", CurrentStarSystem.State);
setString(ref textValues, "System security", CurrentStarSystem.Security);
setString(ref textValues, "System power", CurrentStarSystem.Power);
setString(ref textValues, "System power (spoken)", VATranslations.Power(CurrentStarSystem.Power));
setString(ref textValues, "System power state", CurrentStarSystem.PowerState);
setDecimal(ref decimalValues, "System X", CurrentStarSystem.X);
setDecimal(ref decimalValues, "System Y", CurrentStarSystem.Y);
setDecimal(ref decimalValues, "System Z", CurrentStarSystem.Z);
// Allegiance-specific rank
string systemRank = "Commander";
if (CurrentStarSystem.Allegiance == "Federation" && Cmdr.FederationRating >= minFederationRatingForTitle)
{
systemRank = Cmdr.FederationRank;
}
else if (CurrentStarSystem.Allegiance == "Empire" && Cmdr.EmpireRating >= minEmpireRatingForTitle)
{
systemRank = Cmdr.EmpireRank;
}
setString(ref textValues, "System rank", systemRank);
// Stations
foreach (Station Station in CurrentStarSystem.Stations)
{
setString(ref textValues, "System station name", Station.Name);
}
setInt(ref intValues, "System stations", CurrentStarSystem.Stations.Count);
setInt(ref intValues, "System starports", CurrentStarSystem.Stations.Count(s => s.IsStarport()));
setInt(ref intValues, "System outposts", CurrentStarSystem.Stations.Count(s => s.IsOutpost()));
setInt(ref intValues, "System planetary stations", CurrentStarSystem.Stations.Count(s => s.IsPlanetary()));
setInt(ref intValues, "System planetary outposts", CurrentStarSystem.Stations.Count(s => s.IsPlanetaryOutpost()));
setInt(ref intValues, "System planetary ports", CurrentStarSystem.Stations.Count(s => s.IsPlanetaryPort()));
if (LastStarSystem != null)
{
setString(ref textValues, "Last system name", LastStarSystem.Name);
setString(ref textValues, "Last system name (spoken)", VATranslations.StarSystem(LastStarSystem.Name));
setInt(ref intValues, "Last system population", (int)(LastStarSystem.Population / 1000)); // TODO remove in next major release
setDecimal(ref decimalValues, "Last system population", (decimal)LastStarSystem.Population);
setString(ref textValues, "Last system population", humanize(LastStarSystem.Population)); // TODO remove in next major release
setString(ref textValues, "Last system population (spoken)", humanize(LastStarSystem.Population));
setString(ref textValues, "Last system allegiance", LastStarSystem.Allegiance);
setString(ref textValues, "Last system government", LastStarSystem.Government);
setString(ref textValues, "Last system faction", LastStarSystem.Faction);
setString(ref textValues, "Last system primary economy", LastStarSystem.PrimaryEconomy);
setString(ref textValues, "Last system state", LastStarSystem.State);
setString(ref textValues, "Last system security", LastStarSystem.Security);
setString(ref textValues, "Last system power", LastStarSystem.Power);
setString(ref textValues, "Last system power (spoken)", VATranslations.Power(LastStarSystem.Power));
setString(ref textValues, "Last system power state", LastStarSystem.PowerState);
setDecimal(ref decimalValues, "Last system X", LastStarSystem.X);
setDecimal(ref decimalValues, "Last system Y", LastStarSystem.Y);
setDecimal(ref decimalValues, "Last system Z", LastStarSystem.Z);
if (LastStarSystem.X != null && CurrentStarSystem.X != null)
{
setDecimal(ref decimalValues, "Last jump", (decimal)Math.Round(Math.Sqrt(Math.Pow((double)(CurrentStarSystem.X - LastStarSystem.X), 2) + Math.Pow((double)(CurrentStarSystem.Y - LastStarSystem.Y), 2) + Math.Pow((double)(CurrentStarSystem.Z - LastStarSystem.Z), 2)), 2));
}
// Stations
foreach (Station Station in LastStarSystem.Stations)
{
setString(ref textValues, "Last system station name", Station.Name);
}
setInt(ref intValues, "Last system stations", LastStarSystem.Stations.Count);
setInt(ref intValues, "Last system starports", LastStarSystem.Stations.Count(s => s.IsStarport()));
setInt(ref intValues, "Last system outposts", LastStarSystem.Stations.Count(s => s.IsOutpost()));
setInt(ref intValues, "Last system planetary stations", LastStarSystem.Stations.Count(s => s.IsPlanetary()));
setInt(ref intValues, "Last system planetary outposts", LastStarSystem.Stations.Count(s => s.IsPlanetaryOutpost()));
setInt(ref intValues, "Last system planetary ports", LastStarSystem.Stations.Count(s => s.IsPlanetaryPort()));
}
}
setPluginStatus(ref textValues, "Operational", null, null);
}
catch (Exception e)
{
setPluginStatus(ref textValues, "Failed", "Failed to obtain system data", e);
}
}
public void SaveEDDIStarSystem(EDDIStarSystem eddiStarSystem)
{
if (!File.Exists(DbFile)) CreateDatabase();
using (var con = SimpleDbConnection())
{
con.Open();
if (GetEDDIStarSystem(eddiStarSystem.Name) == null)
{
using (var cmd = new SQLiteCommand(con))
{
cmd.CommandText = INSERT_SQL;
cmd.Prepare();
cmd.Parameters.AddWithValue("@eliteid", eddiStarSystem.EliteID);
cmd.Parameters.AddWithValue("@eddbid", eddiStarSystem.EDDBID);
cmd.Parameters.AddWithValue("@name",eddiStarSystem.Name);
cmd.Parameters.AddWithValue("@totalvisits", eddiStarSystem.TotalVisits);
cmd.Parameters.AddWithValue("@lastvisit", eddiStarSystem.LastVisit);
cmd.Parameters.AddWithValue("@previousvisit", eddiStarSystem.PreviousVisit);
cmd.Parameters.AddWithValue("@starsystem", JsonConvert.SerializeObject(eddiStarSystem.StarSystem));
cmd.Parameters.AddWithValue("@starsystemlastupdated", eddiStarSystem.StarSystemLastUpdated);
cmd.ExecuteNonQuery();
}
}
else
{
using (var cmd = new SQLiteCommand(con))
{
cmd.CommandText = UPDATE_SQL;
cmd.Prepare();
cmd.Parameters.AddWithValue("@eliteid", eddiStarSystem.EliteID);
cmd.Parameters.AddWithValue("@eddbid", eddiStarSystem.EDDBID);
cmd.Parameters.AddWithValue("@totalvisits", eddiStarSystem.TotalVisits);
cmd.Parameters.AddWithValue("@lastvisit", eddiStarSystem.LastVisit);
cmd.Parameters.AddWithValue("@previousvisit", eddiStarSystem.PreviousVisit);
cmd.Parameters.AddWithValue("@starsystem", JsonConvert.SerializeObject(eddiStarSystem.StarSystem));
cmd.Parameters.AddWithValue("@starsystemlastupdated", eddiStarSystem.StarSystemLastUpdated);
cmd.Parameters.AddWithValue("@name", eddiStarSystem.Name);
cmd.ExecuteNonQuery();
}
}
con.Close();
}
}
public static void VA_Init1(ref Dictionary<string, object> state, ref Dictionary<string, Int16?> shortIntValues, ref Dictionary<string, string> textValues, ref Dictionary<string, int?> intValues, ref Dictionary<string, decimal?> decimalValues, ref Dictionary<string, Boolean?> booleanValues, ref Dictionary<string, DateTime?> dateTimeValues, ref Dictionary<string, object> extendedValues)
{
if (!initialised)
{
lock (initLock)
{
if (!initialised)
{
try
{
logInfo("EDDI " + PLUGIN_VERSION + " starting");
// Set up and/or open our database
String dataDir = Environment.GetEnvironmentVariable("AppData") + "\\EDDI";
System.IO.Directory.CreateDirectory(dataDir);
// Set up our local star system repository
starSystemRepository = new EDDIStarSystemSqLiteRepository();
// Set up the EDDI configuration
EDDIConfiguration eddiConfiguration = EDDIConfiguration.FromFile();
setString(ref textValues, "Home system", eddiConfiguration.HomeSystem != null && eddiConfiguration.HomeSystem.Trim().Length > 0 ? eddiConfiguration.HomeSystem : null);
setString(ref textValues, "Home system (spoken)", eddiConfiguration.HomeSystem != null && eddiConfiguration.HomeSystem.Trim().Length > 0 ? Translations.StarSystem(eddiConfiguration.HomeSystem) : null);
setString(ref textValues, "Home station", eddiConfiguration.HomeStation != null && eddiConfiguration.HomeStation.Trim().Length > 0 ? eddiConfiguration.HomeStation : null);
setDecimal(ref decimalValues, "Insurance", eddiConfiguration.Insurance);
if (eddiConfiguration.HomeSystem != null && eddiConfiguration.HomeSystem.Trim().Length > 0)
{
EDDIStarSystem HomeStarSystemData = starSystemRepository.GetEDDIStarSystem(eddiConfiguration.HomeSystem.Trim());
if (HomeStarSystemData == null)
{
// We have no record of this system; set it up
HomeStarSystemData = new EDDIStarSystem();
HomeStarSystemData.Name = eddiConfiguration.HomeSystem.Trim();
HomeStarSystemData.StarSystem = DataProviderService.GetSystemData(eddiConfiguration.HomeSystem.Trim());
HomeStarSystemData.LastVisit = DateTime.Now;
HomeStarSystemData.StarSystemLastUpdated = HomeStarSystemData.LastVisit;
HomeStarSystemData.TotalVisits = 1;
starSystemRepository.SaveEDDIStarSystem(HomeStarSystemData);
}
HomeStarSystem = HomeStarSystemData.StarSystem;
}
enableDebugging = eddiConfiguration.Debug;
setBoolean(ref booleanValues, "EDDI debug", enableDebugging);
// Set up the app service
appService = new CompanionAppService(enableDebugging);
if (appService.CurrentState == CompanionAppService.State.READY)
{
// Carry out initial population of profile
InvokeUpdateProfile(ref state, ref shortIntValues, ref textValues, ref intValues, ref decimalValues, ref booleanValues, ref dateTimeValues, ref extendedValues);
}
if (Cmdr != null && Cmdr.Name != null)
{
setString(ref textValues, "EDDI plugin profile status", "Enabled");
logInfo("EDDI access to the companion app is enabled");
}
else
{
// If InvokeUpdatePlugin failed then it will have have left an error message, but this once we ignore it
setPluginStatus(ref textValues, "Operational", null, null);
setString(ref textValues, "EDDI plugin profile status", "Disabled");
logInfo("EDDI access to the companion app is disabled");
// We create a commander anyway, as data such as starsystem uses it
Cmdr = new Commander();
}
// Set up the star map service
StarMapConfiguration starMapCredentials = StarMapConfiguration.FromFile();
if (starMapCredentials != null && starMapCredentials.apiKey != null)
{
// Commander name might come from star map credentials or the companion app's profile
string commanderName = null;
if (starMapCredentials.commanderName != null)
{
commanderName = starMapCredentials.commanderName;
}
else if (Cmdr.Name != null)
{
commanderName = Cmdr.Name;
}
if (commanderName != null)
{
starMapService = new StarMapService(starMapCredentials.apiKey, commanderName);
setString(ref textValues, "EDDI plugin EDSM status", "Enabled");
logInfo("EDDI access to EDSM is enabled");
}
}
if (starMapService == null)
{
setString(ref textValues, "EDDI plugin EDSM status", "Disabled");
logInfo("EDDI access to EDSM is disabled");
}
setString(ref textValues, "EDDI version", PLUGIN_VERSION);
speechService = new SpeechService(SpeechServiceConfiguration.FromFile());
InvokeNewSystem(ref state, ref shortIntValues, ref textValues, ref intValues, ref decimalValues, ref booleanValues, ref dateTimeValues, ref extendedValues);
CurrentEnvironment = ENVIRONMENT_NORMAL_SPACE;
setString(ref textValues, "Environment", CurrentEnvironment);
// Set up log monitor
NetLogConfiguration netLogConfiguration = NetLogConfiguration.FromFile();
if (netLogConfiguration != null && netLogConfiguration.path != null)
{
logWatcherThread = new Thread(() => StartLogMonitor(netLogConfiguration));
logWatcherThread.IsBackground = true;
logWatcherThread.Name = "EDDI netlog watcher";
logWatcherThread.Start();
setString(ref textValues, "EDDI plugin NetLog status", "Enabled");
logInfo("EDDI netlog monitor is enabled for " + netLogConfiguration.path);
}
else
{
setString(ref textValues, "EDDI plugin NetLog status", "Disabled");
logInfo("EDDI netlog monitor is disabled");
}
setPluginStatus(ref textValues, "Operational", null, null);
initialised = true;
}
catch (Exception ex)
{
setPluginStatus(ref textValues, "Failed", "Failed to initialise", ex);
}
}
}
}
}
public static void InvokeUpdateProfile(ref Dictionary<string, object> state, ref Dictionary<string, Int16?> shortIntValues, ref Dictionary<string, string> textValues, ref Dictionary<string, int?> intValues, ref Dictionary<string, decimal?> decimalValues, ref Dictionary<string, Boolean?> booleanValues, ref Dictionary<string, DateTime?> dateTimeValues, ref Dictionary<string, object> extendedValues)
{
debug("InvokeUpdateProfile(): entered. App service is " + (appService == null ? "disabled" : "enabled"));
if (appService != null)
{
try
{
// Obtain the command profile
Cmdr = appService.Profile();
debug("InvokeUpdateProfile(): Commander is " + JsonConvert.SerializeObject(Cmdr));
//
// Commander data
//
setString(ref textValues, "Name", Cmdr.Name);
setInt(ref intValues, "Combat rating", Cmdr.CombatRating);
setString(ref textValues, "Combat rank", Cmdr.CombatRank);
setInt(ref intValues, "Trade rating", Cmdr.TradeRating);
setString(ref textValues, "Trade rank", Cmdr.TradeRank);
setInt(ref intValues, "Explore rating", Cmdr.ExploreRating);
setString(ref textValues, "Explore rank", Cmdr.ExploreRank);
setInt(ref intValues, "Empire rating", Cmdr.EmpireRating);
setString(ref textValues, "Empire rank", Cmdr.EmpireRank);
setInt(ref intValues, "Federation rating", Cmdr.FederationRating);
setString(ref textValues, "Federation rank", Cmdr.FederationRank);
setDecimal(ref decimalValues, "Credits", (decimal)Cmdr.Credits);
setString(ref textValues, "Credits (spoken)", humanize(Cmdr.Credits));
setDecimal(ref decimalValues, "Debt", (decimal)Cmdr.Debt);
setString(ref textValues, "Debt (spoken)", humanize(Cmdr.Debt));
//
// Ship data
//
setString(ref textValues, "Ship model", Cmdr.Ship.Model);
setString(ref textValues, "Ship model (spoken)", Translations.ShipModel(Cmdr.Ship.Model));
setString(ref textValues, "Ship callsign", Cmdr.Ship.CallSign);
setString(ref textValues, "Ship callsign (spoken)", Translations.CallSign(Cmdr.Ship.CallSign));
setString(ref textValues, "Ship name", Cmdr.Ship.Name);
setString(ref textValues, "Ship role", Cmdr.Ship.Role.ToString());
setString(ref textValues, "Ship size", Cmdr.Ship.Size.ToString());
setDecimal(ref decimalValues, "Ship value", (decimal)Cmdr.Ship.Value);
setString(ref textValues, "Ship value (spoken)", humanize(Cmdr.Ship.Value));
setDecimal(ref decimalValues, "Ship health", Cmdr.Ship.Health);
setInt(ref intValues, "Ship cargo capacity", Cmdr.Ship.CargoCapacity);
setInt(ref intValues, "Ship cargo carried", Cmdr.Ship.CargoCarried);
// Add number of limpets carried
int limpets = 0;
foreach (Cargo cargo in Cmdr.Ship.Cargo)
{
if (cargo.Commodity.Name == "Limpet")
{
limpets += cargo.Quantity;
}
}
setInt(ref intValues, "Ship limpets carried", limpets);
SetModuleDetails("Ship bulkheads", Cmdr.Ship.Bulkheads, ref textValues, ref intValues, ref decimalValues);
SetOutfittingCost("Ship bulkheads", Cmdr.Ship.Bulkheads, ref Cmdr.Outfitting, ref textValues, ref decimalValues);
SetModuleDetails("Ship power plant", Cmdr.Ship.PowerPlant, ref textValues, ref intValues, ref decimalValues);
SetOutfittingCost("Ship power plant", Cmdr.Ship.PowerPlant, ref Cmdr.Outfitting, ref textValues, ref decimalValues);
SetModuleDetails("Ship thrusters", Cmdr.Ship.Thrusters, ref textValues, ref intValues, ref decimalValues);
SetOutfittingCost("Ship thrusters", Cmdr.Ship.Thrusters, ref Cmdr.Outfitting, ref textValues, ref decimalValues);
SetModuleDetails("Ship frame shift drive", Cmdr.Ship.FrameShiftDrive, ref textValues, ref intValues, ref decimalValues);
SetOutfittingCost("Ship frame shift drive", Cmdr.Ship.FrameShiftDrive, ref Cmdr.Outfitting, ref textValues, ref decimalValues);
SetModuleDetails("Ship life support", Cmdr.Ship.LifeSupport, ref textValues, ref intValues, ref decimalValues);
SetOutfittingCost("Ship life support", Cmdr.Ship.LifeSupport, ref Cmdr.Outfitting, ref textValues, ref decimalValues);
SetModuleDetails("Ship power distributor", Cmdr.Ship.PowerDistributor, ref textValues, ref intValues, ref decimalValues);
SetOutfittingCost("Ship power distributor", Cmdr.Ship.PowerDistributor, ref Cmdr.Outfitting, ref textValues, ref decimalValues);
SetModuleDetails("Ship sensors", Cmdr.Ship.Sensors, ref textValues, ref intValues, ref decimalValues);
SetOutfittingCost("Ship sensors", Cmdr.Ship.Sensors, ref Cmdr.Outfitting, ref textValues, ref decimalValues);
SetModuleDetails("Ship fuel tank", Cmdr.Ship.FuelTank, ref textValues, ref intValues, ref decimalValues);
SetOutfittingCost("Ship fuel tank", Cmdr.Ship.FuelTank, ref Cmdr.Outfitting, ref textValues, ref decimalValues);
// Hardpoints
int numTinyHardpoints = 0;
int numSmallHardpoints = 0;
int numMediumHardpoints = 0;
int numLargeHardpoints = 0;
int numHugeHardpoints = 0;
foreach (Hardpoint Hardpoint in Cmdr.Ship.Hardpoints)
{
string baseHardpointName = "";
switch (Hardpoint.Size)
{
case 0:
baseHardpointName = "Ship tiny hardpoint " + ++numTinyHardpoints;
break;
case 1:
baseHardpointName = "Ship small hardpoint " + ++numSmallHardpoints;
break;
case 2:
baseHardpointName = "Ship medium hardpoint " + ++numMediumHardpoints;
break;
case 3:
baseHardpointName = "Ship large hardpoint " + ++numLargeHardpoints;
break;
case 4:
baseHardpointName = "Ship huge hardpoint " + ++numHugeHardpoints;
break;
}
setBoolean(ref booleanValues, baseHardpointName + " occupied", Hardpoint.Module != null);
SetModuleDetails(baseHardpointName + " module", Hardpoint.Module, ref textValues, ref intValues, ref decimalValues);
SetOutfittingCost(baseHardpointName + " module", Hardpoint.Module, ref Cmdr.Outfitting, ref textValues, ref decimalValues);
}
setInt(ref intValues, "Ship hardpoints", numSmallHardpoints + numMediumHardpoints + numLargeHardpoints + numHugeHardpoints);
setInt(ref intValues, "Ship utility slots", numTinyHardpoints);
// Compartments
int curCompartment = 0;
foreach (Compartment Compartment in Cmdr.Ship.Compartments)
{
string baseCompartmentName = "Ship compartment " + ++curCompartment;
setInt(ref intValues, baseCompartmentName + " size", Compartment.Size);
setBoolean(ref booleanValues, baseCompartmentName + " occupied", Compartment.Module != null);
SetModuleDetails(baseCompartmentName + " module", Compartment.Module, ref textValues, ref intValues, ref decimalValues);
SetOutfittingCost(baseCompartmentName + " module", Compartment.Module, ref Cmdr.Outfitting, ref textValues, ref decimalValues);
}
setInt(ref intValues, "Ship compartments", curCompartment);
//
// Stored ships data
//
int currentStoredShip = 1;
foreach (Ship StoredShip in Cmdr.StoredShips)
{
string varBase = "Stored ship " + currentStoredShip;
setString(ref textValues, varBase + " model", StoredShip.Model);
setString(ref textValues, varBase + " system", StoredShip.StarSystem);
setString(ref textValues, varBase + " station", StoredShip.Station);
setString(ref textValues, varBase + " callsign", StoredShip.CallSign);
setString(ref textValues, varBase + " callsign (spoken)", Translations.CallSign(StoredShip.CallSign));
setString(ref textValues, varBase + " name", StoredShip.Name);
setString(ref textValues, varBase + " role", StoredShip.Role.ToString());
// Fetch the star system in which the ship is stored
EDDIStarSystem StoredShipStarSystemData = starSystemRepository.GetEDDIStarSystem(StoredShip.StarSystem);
if (StoredShipStarSystemData == null)
{
// We have no record of this system; set it up
StoredShipStarSystemData = new EDDIStarSystem();
StoredShipStarSystemData.Name = StoredShip.StarSystem;
StoredShipStarSystemData.StarSystem = DataProviderService.GetSystemData(StoredShip.StarSystem);
StoredShipStarSystemData.LastVisit = DateTime.Now;
StoredShipStarSystemData.StarSystemLastUpdated = StoredShipStarSystemData.LastVisit;
StoredShipStarSystemData.TotalVisits = 1;
starSystemRepository.SaveEDDIStarSystem(StoredShipStarSystemData);
}
// Have to grab a local copy of our star system as CurrentStarSystem might not have been initialised yet
EDDIStarSystem ThisStarSystemData = starSystemRepository.GetEDDIStarSystem(Cmdr.StarSystem);
// Work out the distance to the system where the ship is stored if we can
if (ThisStarSystemData != null && ThisStarSystemData.StarSystem != null && ThisStarSystemData.StarSystem.X != null && StoredShipStarSystemData.StarSystem != null && StoredShipStarSystemData.StarSystem.X != null)
{
decimal distance = (decimal)Math.Round(Math.Sqrt(Math.Pow((double)(ThisStarSystemData.StarSystem.X - StoredShipStarSystemData.StarSystem.X), 2)
+ Math.Pow((double)(ThisStarSystemData.StarSystem.Y - StoredShipStarSystemData.StarSystem.Y), 2)
+ Math.Pow((double)(ThisStarSystemData.StarSystem.Z - StoredShipStarSystemData.StarSystem.Z), 2)), 2);
setDecimal(ref decimalValues, varBase + " distance", distance);
}
else
{
// We don't know how far away the ship is
setDecimal(ref decimalValues, varBase + " distance", (decimal?)null);
}
currentStoredShip++;
}
setInt(ref intValues, "Stored ships", Cmdr.StoredShips.Count);
// We also clear out any ships that have been sold since the last run. We don't know
// how many there are so just clear out the succeeding 10 slots and hope that the commander
// hasn't gone on a selling spree
for (int i = 0; i < 10; i++)
{
string varBase = "Stored ship " + (currentStoredShip + i);
setString(ref textValues, varBase + " model", null);
setString(ref textValues, varBase + " system", null);
setString(ref textValues, varBase + " station", null);
setString(ref textValues, varBase + " callsign", null);
setString(ref textValues, varBase + " callsign (spoken)", null);
setString(ref textValues, varBase + " name", null);
setString(ref textValues, varBase + " role", null);
setDecimal(ref decimalValues, varBase + " distance", null);
}
setString(ref textValues, "Last station name", Cmdr.LastStation);
if (enableDebugging)
{
debug("InvokeUpdateProfile(): Resultant shortint values " + JsonConvert.SerializeObject(shortIntValues));
debug("InvokeUpdateProfile(): Resultant text values " + JsonConvert.SerializeObject(textValues));
debug("InvokeUpdateProfile(): Resultant int values " + JsonConvert.SerializeObject(intValues));
debug("InvokeUpdateProfile(): Resultant decimal values " + JsonConvert.SerializeObject(decimalValues));
debug("InvokeUpdateProfile(): Resultant boolean values " + JsonConvert.SerializeObject(booleanValues));
debug("InvokeUpdateProfile(): Resultant datetime values " + JsonConvert.SerializeObject(dateTimeValues));
}
setPluginStatus(ref textValues, "Operational", null, null);
setString(ref textValues, "EDDI plugin profile status", "Enabled");
}
catch (Exception ex)
{
setPluginStatus(ref textValues, "Failed", "Failed to access profile", ex);
setString(ref textValues, "EDDI plugin profile status", "Disabled");
}
}
}
public static void InvokeNewSystem(ref Dictionary<string, object> state, ref Dictionary<string, Int16?> shortIntValues, ref Dictionary<string, string> textValues, ref Dictionary<string, int?> intValues, ref Dictionary<string, decimal?> decimalValues, ref Dictionary<string, Boolean?> booleanValues, ref Dictionary<string, DateTime?> dateTimeValues, ref Dictionary<string, object> extendedValues)
{
debug("InvokeNewSystem() entered");
try
{
if (Cmdr == null)
{
debug("InvokeNewSystem() Cmdr is NULL - attempting to refetch");
// Refetch the profile to set our system
InvokeUpdateProfile(ref state, ref shortIntValues, ref textValues, ref intValues, ref decimalValues, ref booleanValues, ref dateTimeValues, ref extendedValues);
if (Cmdr == null)
{
// Still no luck; assume an error of some sort has been logged by InvokeUpdateProfile()
debug("InvokeNewSystem() Cmdr remained NULL - giving up");
return;
}
}
debug("InvokeNewSystem() CurrentStarSystem is " + (CurrentStarSystem == null ? "<null>" : JsonConvert.SerializeObject(CurrentStarSystem)));
debug("InvokeNewSystem() Cmdr is " + (Cmdr == null ? "<null>" : JsonConvert.SerializeObject(Cmdr)));
if (Cmdr.StarSystem == null)
{
// No information available
debug("InvokeNewSystem() No starsystem data available");
return;
}
bool RecordUpdated = false;
if ((!initialised) || CurrentStarSystem == null || Cmdr.StarSystem != CurrentStarSystem.Name)
{
debug("InvokeNewSystem() In init or starsystem has changed");
// The star system has changed or we're in init; obtain the data ready for setting the VA values
EDDIStarSystem CurrentStarSystemData = starSystemRepository.GetEDDIStarSystem(Cmdr.StarSystem);
debug("InvokeNewSystem() CurrentStarSystemData is " + (CurrentStarSystemData == null ? "<null>" : JsonConvert.SerializeObject(CurrentStarSystemData)));
if (CurrentStarSystemData == null)
{
debug("InvokeNewSystem() Creating new starsystemdata");
// We have no record of this system; set it up
CurrentStarSystemData = new EDDIStarSystem();
CurrentStarSystemData.Name = Cmdr.StarSystem;
CurrentStarSystemData.StarSystem = DataProviderService.GetSystemData(Cmdr.StarSystem);
CurrentStarSystemData.LastVisit = DateTime.Now;
CurrentStarSystemData.StarSystemLastUpdated = CurrentStarSystemData.LastVisit;
CurrentStarSystemData.TotalVisits = 1;
RecordUpdated = true;
}
else
{
debug("InvokeNewSystem() Checking existing starsystemdata");
if (CurrentStarSystemData.StarSystem == null || (DateTime.Now - CurrentStarSystemData.StarSystemLastUpdated).TotalHours > 12)
{
debug("InvokeNewSystem() Refreshing stale or missing data");
// Data is stale; refresh it
CurrentStarSystemData.StarSystem = DataProviderService.GetSystemData(CurrentStarSystemData.Name);
CurrentStarSystemData.StarSystemLastUpdated = CurrentStarSystemData.LastVisit;
RecordUpdated = true;
}
// Only update if we have moved (as opposed to reinitialising here)
if (initialised)
{
debug("InvokeNewSystem() Updating visit information");
CurrentStarSystemData.PreviousVisit = CurrentStarSystemData.LastVisit;
CurrentStarSystemData.LastVisit = DateTime.Now;
CurrentStarSystemData.TotalVisits++;
RecordUpdated = true;
}
}
debug("InvokeNewSystem() CurrentStarSystemData is now " + (CurrentStarSystemData == null ? "<null>" : JsonConvert.SerializeObject(CurrentStarSystemData)));
if (RecordUpdated)
{
debug("InvokeNewSystem() Storing updated starsystemdata");
starSystemRepository.SaveEDDIStarSystem(CurrentStarSystemData);
}
StarSystem ThisStarSystem = CurrentStarSystemData.StarSystem;
LastStarSystem = CurrentStarSystem;
CurrentStarSystem = ThisStarSystem;
debug("InvokeNewSystem() CurrentStarSystem is now " + (CurrentStarSystem == null ? "<null>" : JsonConvert.SerializeObject(CurrentStarSystem)));
debug("InvokeNewSystem() LastStarSystem is now " + (LastStarSystem == null ? "<null>" : JsonConvert.SerializeObject(LastStarSystem)));
if (initialised && LastStarSystem != null && LastStarSystem.Name != CurrentStarSystem.Name)
{
// We have travelled; let EDSM know
if (starMapService != null)
{
debug("InvokeNewSystem() Sending update to EDSM");
starMapService.sendStarMapLog(CurrentStarSystem.Name);
debug("InvokeNewSystem() Update sent");
}
}
debug("InvokeNewSystem() Setting system information");
setString(ref textValues, "System name", CurrentStarSystem.Name);
setString(ref textValues, "System name (spoken)", Translations.StarSystem(CurrentStarSystem.Name));
setInt(ref intValues, "System visits", CurrentStarSystemData.TotalVisits);
setDateTime(ref dateTimeValues, "System previous visit", CurrentStarSystemData.PreviousVisit);
setInt(ref intValues, "System minutes since previous visit", CurrentStarSystemData.PreviousVisit == null ? (int?)null : (int)(DateTime.Now - (DateTime)CurrentStarSystemData.PreviousVisit).TotalMinutes);
setDecimal(ref decimalValues, "System population", (decimal?)CurrentStarSystem.Population);
setString(ref textValues, "System population (spoken)", humanize(CurrentStarSystem.Population));
setString(ref textValues, "System allegiance", CurrentStarSystem.Allegiance);
setString(ref textValues, "System government", CurrentStarSystem.Government);
setString(ref textValues, "System faction", CurrentStarSystem.Faction);
setString(ref textValues, "System primary economy", CurrentStarSystem.PrimaryEconomy);
setString(ref textValues, "System state", CurrentStarSystem.State);
setString(ref textValues, "System security", CurrentStarSystem.Security);
setString(ref textValues, "System power", CurrentStarSystem.Power);
setString(ref textValues, "System power (spoken)", Translations.Power(CurrentStarSystem.Power));
setString(ref textValues, "System power state", CurrentStarSystem.PowerState);
setDecimal(ref decimalValues, "System X", CurrentStarSystem.X);
setDecimal(ref decimalValues, "System Y", CurrentStarSystem.Y);
setDecimal(ref decimalValues, "System Z", CurrentStarSystem.Z);
debug("InvokeNewSystem() Set system information");
debug("InvokeNewSystem() Setting system rank");
// Allegiance-specific rank
string systemRank = "Commander";
if (Cmdr.Name != null) // using Name as a canary to see if the data is missing
{
if (CurrentStarSystem.Allegiance == "Federation" && Cmdr.FederationRating >= minFederationRatingForTitle)
{
systemRank = Cmdr.FederationRank;
}
else if (CurrentStarSystem.Allegiance == "Empire" && Cmdr.EmpireRating >= minEmpireRatingForTitle)
{
systemRank = Cmdr.EmpireRank;
}
}
setString(ref textValues, "System rank", systemRank);
debug("InvokeNewSystem() Set system rank");
// Stations
debug("InvokeNewSystem() Setting station information");
foreach (Station Station in CurrentStarSystem.Stations)
{
setString(ref textValues, "System station name", Station.Name);
}
setInt(ref intValues, "System stations", CurrentStarSystem.Stations.Count);
setInt(ref intValues, "System starports", CurrentStarSystem.Stations.Count(s => s.IsStarport()));
setInt(ref intValues, "System outposts", CurrentStarSystem.Stations.Count(s => s.IsOutpost()));
setInt(ref intValues, "System planetary stations", CurrentStarSystem.Stations.Count(s => s.IsPlanetary()));
setInt(ref intValues, "System planetary outposts", CurrentStarSystem.Stations.Count(s => s.IsPlanetaryOutpost()));
setInt(ref intValues, "System planetary ports", CurrentStarSystem.Stations.Count(s => s.IsPlanetaryPort()));
debug("InvokeNewSystem() Set station information");
debug("InvokeNewSystem() Setting distance from home");
if (HomeStarSystem != null && HomeStarSystem.X != null && CurrentStarSystem.X != null)
{
setDecimal(ref decimalValues, "System distance from home", (decimal)Math.Round(Math.Sqrt(Math.Pow((double)(CurrentStarSystem.X - HomeStarSystem.X), 2) + Math.Pow((double)(CurrentStarSystem.Y - HomeStarSystem.Y), 2) + Math.Pow((double)(CurrentStarSystem.Z - HomeStarSystem.Z), 2)), 2));
}
debug("InvokeNewSystem() Set distance from home");
debug("InvokeNewSystem() Setting EDSM comment");
if (starMapService != null)
{
StarMapInfo info = starMapService.getStarMapInfo(CurrentStarSystem.Name);
setString(ref textValues, "System comment", info == null || info.Comment == null || info.Comment.Trim() == "" ? null : info.Comment);
}
debug("InvokeNewSystem() Set EDSM comment");
if (LastStarSystem != null)
{
debug("InvokeNewSystem() Setting last system information");
setString(ref textValues, "Last system name", LastStarSystem.Name);
setString(ref textValues, "Last system name (spoken)", Translations.StarSystem(LastStarSystem.Name));
setDecimal(ref decimalValues, "Last system population", (decimal?)LastStarSystem.Population);
setString(ref textValues, "Last system population (spoken)", humanize(LastStarSystem.Population));
setString(ref textValues, "Last system allegiance", LastStarSystem.Allegiance);
setString(ref textValues, "Last system government", LastStarSystem.Government);
setString(ref textValues, "Last system faction", LastStarSystem.Faction);
setString(ref textValues, "Last system primary economy", LastStarSystem.PrimaryEconomy);
setString(ref textValues, "Last system state", LastStarSystem.State);
setString(ref textValues, "Last system security", LastStarSystem.Security);
setString(ref textValues, "Last system power", LastStarSystem.Power);
setString(ref textValues, "Last system power (spoken)", Translations.Power(LastStarSystem.Power));
setString(ref textValues, "Last system power state", LastStarSystem.PowerState);
setDecimal(ref decimalValues, "Last system X", LastStarSystem.X);
setDecimal(ref decimalValues, "Last system Y", LastStarSystem.Y);
setDecimal(ref decimalValues, "Last system Z", LastStarSystem.Z);
debug("InvokeNewSystem() Set last system information");
debug("InvokeNewSystem() Setting last jump");
if (LastStarSystem.X != null && CurrentStarSystem.X != null)
{
setDecimal(ref decimalValues, "Last jump", (decimal)Math.Round(Math.Sqrt(Math.Pow((double)(CurrentStarSystem.X - LastStarSystem.X), 2) + Math.Pow((double)(CurrentStarSystem.Y - LastStarSystem.Y), 2) + Math.Pow((double)(CurrentStarSystem.Z - LastStarSystem.Z), 2)), 2));
}
debug("InvokeNewSystem() Set last jump");
debug("InvokeNewSystem() Setting last system rank");
// Allegiance-specific rank
string lastSystemRank = "Commander";
if (Cmdr.Name != null) // using Name as a canary to see if the data is missing
{
if (LastStarSystem.Allegiance == "Federation" && Cmdr.FederationRating >= minFederationRatingForTitle)
{
lastSystemRank = Cmdr.FederationRank;
}
else if (LastStarSystem.Allegiance == "Empire" && Cmdr.EmpireRating >= minEmpireRatingForTitle)
{
lastSystemRank = Cmdr.EmpireRank;
}
}
setString(ref textValues, "Last system rank", systemRank);
debug("InvokeNewSystem() Set last system rank");
// Stations
debug("InvokeNewSystem() Setting last system station information");
foreach (Station Station in LastStarSystem.Stations)
{
setString(ref textValues, "Last system station name", Station.Name);
}
setInt(ref intValues, "Last system stations", LastStarSystem.Stations.Count);
setInt(ref intValues, "Last system starports", LastStarSystem.Stations.Count(s => s.IsStarport()));
setInt(ref intValues, "Last system outposts", LastStarSystem.Stations.Count(s => s.IsOutpost()));
setInt(ref intValues, "Last system planetary stations", LastStarSystem.Stations.Count(s => s.IsPlanetary()));
setInt(ref intValues, "Last system planetary outposts", LastStarSystem.Stations.Count(s => s.IsPlanetaryOutpost()));
setInt(ref intValues, "Last system planetary ports", LastStarSystem.Stations.Count(s => s.IsPlanetaryPort()));
debug("InvokeNewSystem() Set last system station information");
}
}
if (enableDebugging)
{
debug("InvokeNewSystem(): Resultant shortint values " + JsonConvert.SerializeObject(shortIntValues));
debug("InvokeNewSystem(): Resultant text values " + JsonConvert.SerializeObject(textValues));
debug("InvokeNewSystem(): Resultant int values " + JsonConvert.SerializeObject(intValues));
debug("InvokeNewSystem(): Resultant decimal values " + JsonConvert.SerializeObject(decimalValues));
debug("InvokeNewSystem(): Resultant boolean values " + JsonConvert.SerializeObject(booleanValues));
debug("InvokeNewSystem(): Resultant datetime values " + JsonConvert.SerializeObject(dateTimeValues));
}
setPluginStatus(ref textValues, "Operational", null, null);
}
catch (Exception e)
{
setPluginStatus(ref textValues, "Failed", "Failed to obtain system data", e);
}
}
