- }
-
- if(get_config('system', 'old_pager')) {
- $r = q("SELECT COUNT(*) AS `total` FROM `item`
- WHERE `item`.`uid` = %d AND `author-link` IN ('%s', '%s')",
- intval(local_user()),
- dbesc(normalise_link($contact["url"])),
- dbesc(str_replace("http://", "https://", $contact["url"])));
-
- $a->set_pager_total($r[0]['total']);
- }
-
- $r = q("SELECT `item`.`uri`, `item`.*, `item`.`id` AS `item_id`,
- `author-name` AS `name`, `owner-avatar` AS `photo`,
- `owner-link` AS `url`, `owner-avatar` AS `thumb`
- FROM `item` FORCE INDEX (uid_contactid_created)
- WHERE `item`.`uid` = %d AND `contact-id` = %d
- AND `author-link` IN ('%s', '%s')
- ORDER BY `item`.`created` DESC LIMIT %d, %d",
- intval(local_user()),
- intval($contact_id),
- dbesc(normalise_link($contact["url"])),
- dbesc(str_replace("http://", "https://", $contact["url"])),
- intval($a->pager['start']),
- intval($a->pager['itemspage'])
- );
-
- if (!$r)
- $o = $contact["url"]." - ".$contact_id;