/**
* Loads all SolarSystem names from DB to PHP.
*
* @return void
*/
protected static function loadNames()
{
//lookup SDE class
$sdeClass = Config::getIveeClassName('SDE');
$res = $sdeClass::instance()->query("SELECT solarSystemID, solarSystemName\n FROM mapSolarSystems;");
$namesToIds = [];
while ($row = $res->fetch_assoc()) {
$namesToIds[$row['solarSystemName']] = (int) $row['solarSystemID'];
}
static::$instancePool->setNamesToKeys(static::getClassHierarchyKeyPrefix() . 'Names', $namesToIds);
}
/**
* Loads all Station names from DB to PHP.
*
* @return void
*/
protected static function loadNames()
{
//lookup SDE class
$sdeClass = Config::getIveeClassName('SDE');
$res = $sdeClass::instance()->query("SELECT stationID, stationName\n FROM staStations\n UNION\n SELECT facilityID as stationID, stationName\n FROM " . Config::getIveeDbName() . ".outposts;");
$namesToIds = [];
while ($row = $res->fetch_assoc()) {
$namesToIds[$row['stationName']] = (int) $row['stationID'];
}
static::$instancePool->setNamesToKeys(static::getClassHierarchyKeyPrefix() . 'Names', $namesToIds);
}
/**
* Loads all type names from DB to PHP.
*
* @return void
*/
protected static function loadNames()
{
//lookup SDE class
$sdeClass = Config::getIveeClassName('SDE');
$res = $sdeClass::instance()->query("SELECT typeID, typeName\n FROM invTypes\n WHERE marketGroupID IS NOT NULL OR published = 1;");
$namesToIds = [];
while ($row = $res->fetch_assoc()) {
$namesToIds[$row['typeName']] = (int) $row['typeID'];
}
self::$instancePool->setNamesToKeys(static::getClassHierarchyKeyPrefix() . 'Names', $namesToIds);
}
