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; }