/**
* @param $typeID
*
* @return array
*/
public function getAllByID($typeID)
{
return $this->db->queryRow("SELECT * FROM dgmTypeAttributes WHERE typeID = :id", array(":typeID" => $typeID), 3600);
}
/**
* @param $typeID
*
* @return array
*/
function getAllByID($typeID)
{
return $this->db->queryRow("SELECT * FROM dgmTypeEffects WHERE typeID = :id", array(":id" => $typeID), 3600);
}
/**
* @param $typeName
*
* @return array
*/
public function getAllByName($typeName)
{
return $this->db->queryRow("SELECT * FROM invTypes WHERE typeName = :name", array(":name" => $typeName), 3600);
}
/**
* @param $categoryName
*
* @return array
*/
public function getAllByName($categoryName)
{
return $this->db->queryRow("SELECT * FROM dgmAttributeCategories WHERE categoryName = :name", array(":name" => $categoryName), 3600);
}
/**
* @param $corporationID
*
* @return array
*/
public function getAllByID($corporationID)
{
return $this->db->queryRow("SELECT * FROM corporations WHERE corporationID = :id", array(":id" => $corporationID), 3600);
}
/**
* @param $solarSystemName
*
* @return null
*/
public function getCoordinatesByName($solarSystemName)
{
return $this->db->queryRow("SELECT x, y, z, xMin, xMax, yMin, yMax, zMin, zMax, luminosity, border, fringe, corridor, hub, international, regional, constellation FROM mapSolarSystems WHERE solarSystemName = :name", array(":name" => $solarSystemName), 3600);
}
/**
* @param $apiKey
*
* @return array
*/
public function getAPIKey($apiKey)
{
return $this->db->queryRow('SELECT * FROM apiKeys WHERE keyID = :keyID', array(':keyID' => $apiKey));
}
/**
* @param $itemName
*
* @return array
*/
public function getAllByName($itemName)
{
return $this->db->queryRow("SELECT * FROM mapDenormalize WHERE itemName = :name", array(":name" => $itemName), 3600);
}
/**
* @param $flagName
*
* @return array
*/
public function getAllByName($flagName)
{
return $this->db->queryRow("SELECT * FROM invFlags WHERE flagName = :name", array(":name" => $flagName), 3600);
}
/**
* @param $allianceID
*
* @return array
*/
public function getAllByAllianceID($allianceID)
{
return $this->db->queryRow("SELECT * FROM alliances WHERE allianceID = :id", array(":id" => $allianceID), 3600);
}
/**
* @param $attributeName
*
* @return array
*/
public function getAllByName($attributeName)
{
return $this->db->queryRow("SELECT * FROM dgmAttributeTypes WHERE attributeName = :name", array(":name" => $attributeName), 3600);
}
/**
* @param $regionName
*
* @return null
*/
public function getCoordinatesByName($regionName)
{
return $this->db->queryRow("SELECT x, y, z, xMin, xMax, yMin, yMax, zMin, zMax, radius FROM mapRegions WHERE regionName = :name", array(":name" => $regionName), 3600);
}
/**
* @param $groupName
*
* @return array
*/
public function getAllByName($groupName)
{
return $this->db->queryRow("SELECT * FROM invGroups WHERE groupName = :name", array(":name" => $groupName), 3600);
}
/**
* @param $hash
*
* @return array
*/
public function getUserDataByLoginHash($hash)
{
return $this->db->queryRow("SELECT * FROM users WHERE loginHash = :hash", array(":hash" => $hash));
}
/**
* @param $killID
*
* @return array
*/
public function getAllByID($killID)
{
return $this->db->queryRow("SELECT * FROM killmails WHERE killID = :killID", array(":killID" => $killID), 60);
}
/**
* @param $characterID
* @param int $cacheTime
*
* @return array
*/
public function getAllByID($characterID, $cacheTime = 3600)
{
return $this->db->queryRow("SELECT * FROM characters WHERE characterID = :id", array(":id" => $characterID), $cacheTime);
}
/**
* @param $effectName
*
* @return array
*/
public function getAllByName($effectName)
{
return $this->db->queryRow("SELECT * FROM dgmEffects WHERE effectName = :name", array(":name" => $effectName), 3600);
}