Merge pull request #10936 from annando/speed-unused-contacts

[friendica.git] / src / Content / Widget.php

diff --git a/src/Content/Widget.php b/src/Content/Widget.php
index 3f97e9f259e50a4c37d6fcef472f755884cfce64..daa34a8b00b2d3a8c3a9681df3519e3e1b498483 100644 (file)
--- a/src/Content/Widget.php
+++ b/src/Content/Widget.php
@@ -259,12 +259,10 @@ class Widget
                }
 
                $networks = self::unavailableNetworks();
-               $extra_sql = " AND NOT `network` IN (" . substr(str_repeat("?, ", count($networks)), 0, -2) . ")";
-               $sql_values = array_merge([local_user()], $networks);
+               $query = "`uid` = ? AND NOT `deleted` AND `network` != '' AND NOT `network` IN (" . substr(str_repeat("?, ", count($networks)), 0, -2) . ")";
+               $condition = array_merge([$query], array_merge([local_user()], $networks));
 
-               $r = DBA::p("SELECT `network` FROM `contact` WHERE `uid` = ? AND NOT `deleted` AND `network` != '' $extra_sql GROUP BY `network` ORDER BY `network`",
-                       $sql_values
-               );
+               $r = DBA::select('contact', ['network'], $condition, ['group_by' => ['network'], 'order' => ['network']]);
 
                $nets = array();
                while ($rr = DBA::fetch($r)) {