- if ($filter === 'comments') {
- $sql_extra .= sprintf(" AND `item`.`object-type` = '%s' ", dbesc(ACTIVITY_OBJ_COMMENT));
- }
-
- if ($owner['account-type'] != ACCOUNT_TYPE_COMMUNITY) {
- $sql_extra .= sprintf(" AND `item`.`contact-id` = %d AND `item`.`author-id` = %d ", intval($owner["id"]), intval($authorid));
- }
-
- $items = q(
- "SELECT `item`.*, `item`.`id` AS `item_id` FROM `item` USE INDEX (`uid_contactid_created`)
- STRAIGHT_JOIN `thread` ON `thread`.`iid` = `item`.`parent`
- WHERE `item`.`uid` = %d
- AND `item`.`created` > '%s'
- AND NOT `item`.`deleted`
- AND NOT `item`.`private`
- AND `item`.`visible`
- AND `thread`.`network` IN ('%s', '%s')
- $sql_extra
- ORDER BY `item`.`created` DESC LIMIT %d",
- intval($owner["uid"]),
- dbesc($check_date),
- dbesc(NETWORK_OSTATUS),
- dbesc(NETWORK_DFRN),
- intval($max_items)
- );