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