PHP ConnectionFactory::SelectRowsAsClasses方法代码示例

 public static function getBountiesCountForUser($userID)
 {
     /*$query = "SELECT * FROM bounties JOIN users ON (bounties.target_id = users.id) WHERE bounties.is_complete = 0 AND bounties.target_id != ? ORDER BY rand() LIMIT 15";*/
     $query = "SELECT SUM( payment ) AS bounty\n\t\t\t\t\t\tFROM  `bounties` \n\t\t\t\t\t\tJOIN users ON ( bounties.target_id = users.id ) \n\t\t\t\t\t\tWHERE bounties.is_complete =0\n\t\t\t\t\t\tAND bounties.target_id !=?\n\t\t\t\t\t\tAND target_id NOT IN (SELECT bounties.target_id FROM bounties WHERE bounties.requester_id = {$userID})\n\t\t\t\t\t\tGROUP BY  `target_id` \n\t\t\t\t\t\tLIMIT 15";
     $objBounties = ConnectionFactory::SelectRowsAsClasses($query, array($userID), __CLASS__);
     return $objBounties;
 }

 public static function getUserComments($userID)
 {
     $query = "Select * FROM comments Where comments.receiver_id = ? AND comments.type=1 ORDER BY comments.id DESC LIMIT 0,10";
     $values = array($userID);
     $comments = ConnectionFactory::SelectRowsAsClasses($query, $values, __CLASS__);
     return $comments;
 }

 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 getItemIDsToItemsVisibleInShop($playerLevel)
 {
     $query = "SELECT * FROM items WHERE min_level <= ? ORDER BY min_level";
     $objItems = ConnectionFactory::SelectRowsAsClasses($query, array($playerLevel + 1), __CLASS__);
     $toreturn = array();
     foreach ($objItems as $objItem) {
         $itemID = $objItem->getID();
         $toreturn[$itemID] = $objItem;
     }
     return $toreturn;
 }

 public static function getRealEstateIDsToRealEstatesVisibleInShop($playerLevel)
 {
     $query = "SELECT * FROM realestate WHERE min_level <= ? ORDER BY min_level";
     $objREs = ConnectionFactory::SelectRowsAsClasses($query, array($playerLevel + 1), __CLASS__);
     $toreturn = array();
     foreach ($objREs as $objRE) {
         $reID = $objRE->getID();
         $toreturn[$reID] = $objRE;
     }
     return $toreturn;
 }

 public static function getUnlockMissionsInCity($playerLevel, $cityID)
 {
     $objMissions = Lvl6MemCache::getCache('unlockMissionsInCity' . $playerLevel . $cityID);
     if ($objMissions) {
         return $objMissions;
     }
     $query = "SELECT * FROM missions WHERE missions.min_level =\n                    (SELECT missions.min_level FROM missions WHERE missions.min_level > ? AND missions.city_id = ? LIMIT 0,1)";
     //$query = "SELECT * FROM missions WHERE min_level > ? AND city_id = ? ORDER BY min_level LIMIT 2";
     $objMissions = ConnectionFactory::SelectRowsAsClasses($query, array($playerLevel, $cityID), __CLASS__);
     Lvl6MemCache::addCache('unlockMissionsInCity' . $playerLevel . $cityID, $objMissions);
     return $objMissions;
 }

 /**
  * this function will display the next two locked items
  * TODO: make it configurable bu assigning constant instead of two
  * @return the locked items as classes
  */
 public static function get_locked_items_visible_in_shop($playerLevel, $item_type)
 {
     $toreturn = Lvl6MemCache::getCache('locked_items_visible_in_shop' . $playerLevel . $item_type);
     if ($toreturn) {
         return $toreturn;
     }
     $query = "SELECT * FROM items WHERE items.min_level = (SELECT items.min_level as next_level FROM items WHERE items.min_level > ? and items.type = ? LIMIT 0,1)";
     //$query = "SELECT * FROM items WHERE min_level > ? AND type = ? ORDER BY min_level ASC LIMIT 0,1";
     $objItems = ConnectionFactory::SelectRowsAsClasses($query, array($playerLevel, $item_type), __CLASS__);
     $toreturn = array();
     foreach ($objItems as $objItem) {
         $itemID = $objItem->getID();
         $toreturn[$itemID] = $objItem;
     }
     Lvl6MemCache::addCache('locked_items_visible_in_shop' . $playerLevel . $item_type, $toreturn);
     return $toreturn;
 }

 public function getPotentialOpponents()
 {
     $userID = $this->id;
     $level = $this->level;
     $agencySize = $this->agency_size;
     // get up to 10 people to list on the attack list
     $attackListSize = 10;
     $maxAgencySize = $agencySize + 5;
     $minAgencySize = max(array(1, $agencySize - 5));
     // temporary solution for level range
     $minLevel = $level - 5;
     $maxLevel = $level + 5;
     $query = "SELECT * FROM users WHERE level <= ? AND level >= ? AND agency_size <= ? AND agency_size >= ? AND id != ?";
     $objAllPotOpps = ConnectionFactory::SelectRowsAsClasses($query, array($maxLevel, $minLevel, $maxAgencySize, $minAgencySize, $userID), __CLASS__);
     if (!$objAllPotOpps || count($objAllPotOpps) < $attackListSize) {
         // TODO: execute further queries with higher level or agency size ranges if too few users
         //the next lines is temp solution if there is 1<x<attacklistsize opponents
         if ($objAllPotOpps) {
             return $objAllPotOpps;
         } else {
             return array();
         }
     }
     // get random indices
     $randomIntegers = getRandomIntegers($attackListSize, count($objAllPotOpps));
     $opponents = array();
     foreach ($randomIntegers as $key => $value) {
         array_push($opponents, $objAllPotOpps[$key]);
     }
     return $opponents;
 }

 private function allMissionsInCityReadyForNextLevel($nextLevel, $cityID, $userID)
 {
     $cityMissions = Mission::getMissionsInCity($cityID);
     $numCityMissions = count($cityMissions);
     $query = "SELECT * from users_missions WHERE user_id=? AND curr_rank=? AND (";
     $missionConditions = array();
     $values = array();
     array_push($values, $userID);
     array_push($values, $nextLevel);
     foreach ($cityMissions as $mission) {
         array_push($missionConditions, "mission_id=?");
         $missionID = $mission->getID();
         array_push($values, $missionID);
     }
     $query .= getArrayInString($missionConditions, ' OR ') . ")";
     $usersMissionsReadyInCity = ConnectionFactory::SelectRowsAsClasses($query, $values, __CLASS__);
     return count($usersMissionsReadyInCity) >= $numCityMissions;
 }

function getdeviceTokenAndSendMessage($udid, $message)
{
    echo "UDID = " . $udid;
    $query = "select apns_devices.pid, apns_devices.devicetoken from apns_devices WHERE apns_devices.deviceuid = '" . $udid . "'";
    $devices = ConnectionFactory::SelectRowsAsClasses($query, array(), __CLASS__);
    print_r($device);
    die;
    //$inactiveUsers = User::lastTwoDayInactive();
    foreach ($devices as $device) {
        echo "DEVICE TOKEN = " . $device->devicetoken;
        sendMessageToDevice($device->devicetoken, $message);
    }
}

 public static function getSoldierCode()
 {
     $soldierCode = ConnectionFactory::SelectRowsAsClasses("SELECT code FROM soldier_code LIMIT 0,1", array(), __CLASS__);
     return $soldierCode;
 }

 public static function getMissionsInCityGivenPlayerLevel($playerLevel, $cityID)
 {
     $query = "SELECT * FROM missions WHERE min_level <= ? AND city_id = ? ORDER BY min_level";
     $objMissions = ConnectionFactory::SelectRowsAsClasses($query, array($playerLevel, $cityID), __CLASS__);
     return $objMissions;
 }

 public static function getBountiesForUser($userID)
 {
     $query = "SELECT * FROM bounties JOIN users ON (bounties.target_id = users.id) WHERE bounties.is_complete = 0 AND bounties.target_id != ?";
     $objBounties = ConnectionFactory::SelectRowsAsClasses($query, array($userID), __CLASS__);
     return $objBounties;
 }

 public static function updateHealthOfflineTimerSpecialUsers($interval)
 {
     $query = "SELECT users.id, users.udid, users.c2dm_token, users.device_os FROM users JOIN user_timers ON (users.id = user_timers.user_id) WHERE FLOOR(TIMESTAMPDIFF(MINUTE, health_timer, NOW())/" . $interval . ")> (users.health_max-users.health) AND (users.health_max-users.health)>0";
     $fullHealth = ConnectionFactory::SelectRowsAsClasses($query, array(), __CLASS__);
     $query = "update users, user_timers set user_timers.health_timer = NOW(), users.health =\n                    IF (users.health + FLOOR(TIMESTAMPDIFF(MINUTE, user_timers.health_timer, NOW())/" . $interval . ") < users.health_max,\n                         users.health + FLOOR(TIMESTAMPDIFF(MINUTE, user_timers.health_timer, NOW())/" . $interval . "),\n                        users.health_max)\n                    WHERE users.id = user_timers.user_id AND TIMESTAMPDIFF(HOUR, user_timers.health_timer, NOW()) > 1 AND users.type = 3";
     if (ConnectionFactory::getAssociativeArray($query)) {
         return $fullHealth;
     }
 }

 public static function getUserUpkeepRealEstate($userID)
 {
     $query = "Select realestate.id, realestate.price, users_realestates.quantity, realestate.upkeep From realestate, users_realestates\n                where users_realestates.user_id = :userID and users_realestates.realestate_id = realestate.id\n                AND realestate.upkeep > 0\n                order by realestate.upkeep desc";
     $objItem = ConnectionFactory::SelectRowsAsClasses($query, array("userID" => $userID), __CLASS__);
     return $objItem;
 }