/** * 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;"); $namesToIds = array(); while ($row = $res->fetch_assoc()) { $namesToIds[$row['stationName']] = (int) $row['stationID']; } static::$instancePool->setNamesToIds($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 published = 1;"); $namesToIds = array(); while ($row = $res->fetch_assoc()) { $namesToIds[$row['typeName']] = (int) $row['typeID']; } self::$instancePool->setNamesToIds($namesToIds); }