- $r = q("SELECT `pending` FROM `contact` WHERE `uid` = %d AND ((`rel` != %d) OR (`network` = '%s')) AND
- (`nurl` = '%s' OR `alias` = '%s' OR `alias` = '%s') AND
- `network` != '%s' LIMIT 1",
- intval(local_user()), DBA::escape(Contact::FOLLOWER), DBA::escape(Protocol::DFRN), DBA::escape(Strings::normaliseLink($url)),
- DBA::escape(Strings::normaliseLink($url)), DBA::escape($url), DBA::escape(Protocol::STATUSNET));
-
- if ($r) {
- if ($r[0]['pending']) {
+ $user_contact = DBA::selectFirst('contact', ['pending'], ["`uid` = ? AND ((`rel` != ?) OR (`network` = ?)) AND
+ (`nurl` = ? OR `alias` = ? OR `alias` = ?) AND `network` != ?",
+ $uid, Contact::FOLLOWER, Protocol::DFRN, Strings::normaliseLink($url),
+ Strings::normaliseLink($url), $url, Protocol::STATUSNET]);
+
+ if (DBA::isResult($user_contact)) {
+ if ($user_contact['pending']) {