/**
* returns a subset of the profile visits for a member
*
* @param Member $member - profile to check
* @param PagerWidget $pager - pager containing data on subset
*
* @access public
* @return array
*/
public function getVisitingMembersSubset(Member $member, PagerWidget $pager)
{
if (!$member->isLoaded()) {
return array();
}
$return = array();
if ($result = $this->dao->query(<<<SQL
SELECT m.*, p.updated FROM members AS m, {$this->getTableName()} AS p WHERE m.id = p.IdVisitor AND p.IdMember = {$member->getPKValue()} AND m.Status NOT IN ('Banned', 'TakenOut', 'Rejected','ActiveHidden', 'Buggy') ORDER BY p.updated DESC LIMIT {$pager->getActiveStart()}, {$pager->getActiveLength()}
SQL
)) {
while ($row = $result->fetch(PDB::FETCH_ASSOC)) {
$m = $this->createEntity('Member')->loadFromArray($row);
$m->visited = $row['updated'];
$return[] = $m;
}
}
return $return;
}
