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