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