/** * @param $characterName * @param $characterID * @param $characterOwnerHash * * @return int */ public function createUserWithCrest($characterName, $characterID, $characterOwnerHash) { $id = $this->db->queryField("SELECT id FROM users WHERE characterName = :characterName", "id", array(":characterName" => $characterName)); if (!$id) { return $this->db->execute("INSERT INTO users (characterName, characterID, characterOwnerHash) VALUE (:characterName, :characterID, :characterOwnerHash)", array(":characterName" => $characterName, ":characterID" => $characterID, ":characterOwnerHash" => $characterOwnerHash), true); } return $id; }
/** * @param string $key * @param null $default * * @return null|string */ function get($key, $default = null) { $value = $this->db->queryField("SELECT value FROM storage WHERE `key` = :key", "value", array(":key" => $key), 0); if (!$value) { return $default; } return $value; }
/** * @param $characterName * * @return string */ public function getHistoryByName($characterName) { return $this->db->queryField("SELECT history FROM characters WHERE characterName = :name", "history", array(":name" => $characterName), 3600); }
/** * @param $typeID * * @return string */ function getIsDefaultByID($typeID) { return $this->db->queryField("SELECT isDefault FROM dgmTypeEffects WHERE typeID = :id", "isDefault", array(":id" => $typeID), 3600); }
/** * @param $typeID * * @return string */ public function getValueFloatByID($typeID) { return $this->db->queryField("SELECT valueFloat FROM dgmTypeAttributes WHERE typeID = :id", "valueFloat", array(":id" => $typeID), 3600); }
/** * @param $categoryName * * @return string */ public function getCategoryDescriptionByName($categoryName) { return $this->db->queryField("SELECT categoryDescription FROM dgmAttributeCategories WHERE categoryName = :name", "categoryDescription", array(":name" => $categoryName), 3600); }
/** * @param $typeName * * @return string */ public function getChanceOfDuplicatingByName($typeName) { return $this->db->queryField("SELECT chanceOfDuplicating FROM invTypes WHERE typeName = :name", "chanceOfDuplicating", array(":name" => $typeName), 3600); }
/** * @param $solarSystemName * * @return string */ public function getSecurityClassByName($solarSystemName) { return $this->db->queryField("SELECT securityClass FROM mapSolarSystems WHERE solarSystemName = :name", "securityClass", array(":name" => $solarSystemName), 3600); }
/** * @param $corporationName * * @return string */ public function getMemberCountByName($corporationName) { return $this->db->queryField("SELECT memberCount FROM corporations WHERE corporationName = :name", "memberCount", array(":name" => $corporationName), 3600); }
/** * @param $killID * * @return string */ public function getJSONByID($killID) { return $this->db->queryField("SELECT kill_json FROM killmails WHERE killID = :killID", "kill_json", array(":killID" => $killID)); }
/** * @param $keyID * * @return string */ public function getVCodeByKeyID($keyID) { return $this->db->queryField("SELECT vCode FROM apiKeys WHERE keyID = :keyID", "vCode", array(":keyID" => $keyID)); }
/** * @param $allianceName * * @return string */ public function getMemberCountByName($allianceName) { return $this->db->queryField("SELECT memberCount FROM alliances WHERE allianceName = :name", "memberCount", array(":name" => $allianceName), 3600); }
/** * @param $flagName * * @return string */ public function getOrderIDByName($flagName) { return $this->db->queryField("SELECT orderID FROM invFlags WHERE flagName = :name", "orderID", array(":name" => $flagName), 3600); }
/** * @param $attributeName * * @return string */ public function getCategoryIDByName($attributeName) { return $this->db->queryField("SELECT categoryID FROM dgmAttributeTypes WHERE attributeName = :name", "categoryID", array(":name" => $attributeName), 3600); }
/** * @param $regionName * * @return string */ public function getFactionIDByName($regionName) { return $this->db->queryField("SELECT factionID FROM mapRegions WHERE regionName = :name", "factionID", array(":name" => $regionName), 3600); }