- switch ($type) {
- case self::TYPE_MENTION_CONTACT_GROUP:
- $r = q("SELECT `id`, `name`, `nick`, `micro`, `network`, `url`, `attag`, `addr`, `forum`, `prv`, (`prv` OR `forum`) AS `frm` FROM `contact`
- WHERE `uid` = %d AND NOT `self` AND NOT `deleted` AND NOT `blocked` AND NOT `pending` AND NOT `archive` AND `notify` != ''
- AND NOT (`network` IN ('%s', '%s'))
- $sql_extra2
- ORDER BY `name`",
- intval(local_user()),
- DBA::escape(Protocol::OSTATUS),
- DBA::escape(Protocol::STATUSNET)
- );
- break;
-
- case self::TYPE_MENTION_CONTACT:
- $r = q("SELECT `id`, `name`, `nick`, `micro`, `network`, `url`, `attag`, `addr`, `forum`, `prv` FROM `contact`
- WHERE `uid` = %d AND NOT `self` AND NOT `deleted` AND NOT `blocked` AND NOT `pending` AND NOT `archive` AND `notify` != ''
- AND NOT (`network` IN ('%s'))
- $sql_extra2
- ORDER BY `name`",
- intval(local_user()),
- DBA::escape(Protocol::STATUSNET)
- );
- break;
-
- case self::TYPE_MENTION_FORUM:
- $r = q("SELECT `id`, `name`, `nick`, `micro`, `network`, `url`, `attag`, `addr`, `forum`, `prv` FROM `contact`
- WHERE `uid` = %d AND NOT `self` AND NOT `deleted` AND NOT `blocked` AND NOT `pending` AND NOT `archive` AND `notify` != ''
- AND NOT (`network` IN ('%s'))
- AND (`forum` OR `prv`)
- $sql_extra2
- ORDER BY `name`",
- intval(local_user()),
- DBA::escape(Protocol::STATUSNET)
- );
- break;
-
- case self::TYPE_PRIVATE_MESSAGE:
- $r = q("SELECT `id`, `name`, `nick`, `micro`, `network`, `url`, `attag`, `addr` FROM `contact`
- WHERE `uid` = %d AND NOT `self` AND NOT `deleted` AND NOT `blocked` AND NOT `pending` AND NOT `archive`
- AND `network` IN ('%s', '%s', '%s')
- $sql_extra2
- ORDER BY `name`",
- intval(local_user()),
- DBA::escape(Protocol::ACTIVITYPUB),
- DBA::escape(Protocol::DFRN),
- DBA::escape(Protocol::DIASPORA)
- );
- break;
-
- case self::TYPE_ANY_CONTACT:
- default:
- $r = q("SELECT `id`, `name`, `nick`, `micro`, `network`, `url`, `attag`, `addr`, `forum`, `prv` FROM `contact`
- WHERE `uid` = %d AND NOT `deleted` AND NOT `pending` AND NOT `archive`
- $sql_extra2
- ORDER BY `name`",
- intval(local_user())
- );
- break;