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