Merge pull request #6223 from annando/ap-dba-error

[friendica.git] / mod / viewcontacts.php

diff --git a/mod/viewcontacts.php b/mod/viewcontacts.php
index f3d457e2959d89a90ba0cb08b3e5c6f66fca49a4..8b7acffbdc90fdd597a8680862101430eea1dad0 100644 (file)
--- a/mod/viewcontacts.php
+++ b/mod/viewcontacts.php
@@ -68,8 +68,9 @@ function viewcontacts_content(App $a)
        $r = q("SELECT COUNT(*) AS `total` FROM `contact`
                WHERE `uid` = %d AND NOT `blocked` AND NOT `pending`
                        AND NOT `hidden` AND NOT `archive`
-                       AND `network` IN ('%s', '%s', '%s')",
+                       AND `network` IN ('%s', '%s', '%s', '%s')",
                intval($a->profile['uid']),
+               DBA::escape(Protocol::ACTIVITYPUB),
                DBA::escape(Protocol::DFRN),
                DBA::escape(Protocol::DIASPORA),
                DBA::escape(Protocol::OSTATUS)
@@ -82,9 +83,10 @@ function viewcontacts_content(App $a)
        $r = q("SELECT * FROM `contact`
                WHERE `uid` = %d AND NOT `blocked` AND NOT `pending`
                        AND NOT `hidden` AND NOT `archive`
-                       AND `network` IN ('%s', '%s', '%s')
+                       AND `network` IN ('%s', '%s', '%s', '%s')
                ORDER BY `name` ASC LIMIT %d, %d",
                intval($a->profile['uid']),
+               DBA::escape(Protocol::ACTIVITYPUB),
                DBA::escape(Protocol::DFRN),
                DBA::escape(Protocol::DIASPORA),
                DBA::escape(Protocol::OSTATUS),