/** * 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); }