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