Exemplo n.º 1
0
 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;
 }