public static function getCity($cityID)
{
$objCity = Lvl6MemCache::getCache('city' . $cityID);
if ($objCity) {
return $objCity;
}
$objCity = ConnectionFactory::SelectRowAsClass("SELECT * FROM cities where id = :cityID", array("cityID" => $cityID), __CLASS__);
Lvl6MemCache::addCache('city' . $cityID, $objCity);
return $objCity;
}
public static function getLevelExp($levelID)
{
$objItem = Lvl6MemCache::getCache('levelExp' . $levelID);
if ($objItem) {
return $objItem;
}
$objItem = ConnectionFactory::SelectRowAsClass("SELECT required_experience_points FROM level_experience_points where level_id = :levelID", array("levelID" => $levelID), __CLASS__);
Lvl6MemCache::addCache('levelExp' . $levelID, $objItem);
return $objItem;
}
public static function getRealEstate($realEstateID)
{
$objRE = Lvl6MemCache::getCache('realEstate' . $realEstateID);
if ($objRE) {
return $objRE;
}
$objRE = ConnectionFactory::SelectRowAsClass("SELECT * FROM realestate where id = :realEstateID", array("realEstateID" => $realEstateID), __CLASS__);
Lvl6MemCache::addCache('realEstate' . $realEstateID, $objRE);
return $objRE;
}
public static function getItem($itemID)
{
$objItem = ConnectionFactory::SelectRowAsClass("SELECT * FROM items where id = :itemID", array("itemID" => $itemID), __CLASS__);
return $objItem;
}
public static function getNextUnlockMissionLevel($playerLevel, $currentCityID)
{
$objItem = Lvl6MemCache::getCache('nextUnlockMissionLevel' . $playerLevel . $currentCityID);
if ($objItem) {
return $objItem;
}
$query = "SELECT * FROM missions WHERE min_level > ? AND city_id = ? ORDER BY min_level";
$objItem = ConnectionFactory::SelectRowAsClass($query, array($playerLevel, $currentCityID), __CLASS__);
Lvl6MemCache::addCache('nextUnlockMissionLevel' . $playerLevel . $currentCityID, $objItem);
return $objItem;
}
public static function getNextUnlockWeaponLevel($playerLevel)
{
$objItem = Lvl6MemCache::getCache('nextUnlockWeaponLeve' . $playerLevel);
if ($objItem) {
return $objItem;
}
$query = "SELECT * FROM items WHERE min_level > ? ORDER BY min_level";
$objItem = ConnectionFactory::SelectRowAsClass($query, array($playerLevel), __CLASS__);
Lvl6MemCache::addCache('nextUnlockWeaponLeve' . $playerLevel, $objItem);
return $objItem;
}
public static function getBounty($bountyID)
{
$objBounty = ConnectionFactory::SelectRowAsClass("SELECT * FROM bounties where id = :bountyID", array("bountyID" => $bountyID), __CLASS__);
return $objBounty;
}
public static function getUser($userID)
{
$objUser = ConnectionFactory::SelectRowAsClass("SELECT * FROM users where id = :userID", array("userID" => $userID), __CLASS__);
return $objUser;
}
public static function getUserMissionData($userID, $missionID)
{
$objData = ConnectionFactory::SelectRowAsClass("SELECT * FROM users_missions where user_id = ? and mission_id= ?", array($userID, $missionID), __CLASS__);
return $objData;
}
public static function getTimersInSeconds($user_id)
{
$query = "SELECT TIMESTAMPDIFF(SECOND, income_timer, NOW()) as income_timer, TIMESTAMPDIFF(SECOND, health_timer, NOW()) as health_timer,\n TIMESTAMPDIFF(SECOND, energy_timer, NOW()) as energy_timer, TIMESTAMPDIFF(SECOND, stamina_timer, NOW()) as stamina_timer FROM user_timers Where user_id = :userID";
return ConnectionFactory::SelectRowAsClass($query, array("userID" => $user_id), __CLASS__);
}
public static function getRealEstate($realEstateID)
{
$objRE = ConnectionFactory::SelectRowAsClass("SELECT * FROM realestate where id = :realEstateID", array("realEstateID" => $realEstateID), __CLASS__);
return $objRE;
}
public static function getMission($missionID)
{
$objMission = ConnectionFactory::SelectRowAsClass("SELECT * FROM missions where id = :missionID", array("missionID" => $missionID), __CLASS__);
return $objMission;
}
public function updateLevel($level, $skillPointsGained)
{
$absParams = array();
$absParams['level'] = $level;
$relParams = array();
$relParams['skill_points'] = $skillPointsGained;
$conditions = array();
$conditions['id'] = $this->id;
$objItem = ConnectionFactory::SelectRowAsClass("SELECT required_experience_points FROM level_experience_points where level_id = :levelID", array("levelID" => $level + 1), __CLASS__);
$nextRequiredExp = $objItem->required_experience_points;
$absParams['next_level_experince_points'] = $nextRequiredExp;
$success = ConnectionFactory::updateTableRowGenericBasic("users", $absParams, $relParams, $conditions);
if ($success) {
$this->level = $level;
$this->skill_points += $skillPointsGained;
}
return $success;
}
