public static function getFactory()
{
if (!self::$factory) {
self::$factory = new Memcache();
self::$factory->connect('127.0.0.1', 11211) or die("Could not connect");
}
return self::$factory;
}
public static function getAllCities()
{
$objCities = Lvl6MemCache::getCache('allCities');
if ($objCities) {
return $objCities;
}
$objCities = ConnectionFactory::SelectRowsAsClasses("SELECT * FROM cities", array(), __CLASS__);
Lvl6MemCache::addCache('allCities', $objCities);
return $objCities;
}
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 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 getLockedRealEstate($playerlevel)
{
$toreturn = Lvl6MemCache::getCache('lockedRealEstate' . $playerlevel);
if ($toreturn) {
return $toreturn;
}
$pLevel = $playerlevel;
$query = "SELECT * FROM realestate WHERE realestate.min_level =\n (SELECT realestate.min_level FROM realestate WHERE realestate.min_level > ? LIMIT 0,1)";
$objREs = ConnectionFactory::SelectRowsAsClasses($query, array($pLevel), __CLASS__);
$toreturn = array();
foreach ($objREs as $objRE) {
$reID = $objRE->getID();
$toreturn[$reID] = $objRE;
}
Lvl6MemCache::addCache('lockedRealEstate' . $playerlevel, $toreturn);
return $toreturn;
}
