X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Fdirectory.php;h=5f3605ebffb01162a8a0abfb2a078ea76c46579b;hb=229fb0439e3971ad93fb76b85ab41248606e2d6a;hp=b8b0482127172fd38b4e178aa41a7f147cf4b9d6;hpb=9cf218352451671b5d2c3a9cbf3154da838708a2;p=friendica.git diff --git a/mod/directory.php b/mod/directory.php index b8b0482127..5f3605ebff 100644 --- a/mod/directory.php +++ b/mod/directory.php @@ -81,12 +81,12 @@ function directory_content(App $a) $publish = ((Config::get('system', 'publish_all')) ? '' : " AND `publish` = 1 " ); - $total = q("SELECT COUNT(*) AS `total` FROM `profile` - LEFT JOIN `user` ON `user`.`uid` = `profile`.`uid` - WHERE `is-default` = 1 $publish AND `user`.`blocked` = 0 $sql_extra " + $cnt = dba::select_first("SELECT COUNT(*) AS `total` FROM `profile` + LEFT JOIN `user` ON `user`.`uid` = `profile`.`uid` + WHERE `is-default` = 1 $publish AND `user`.`blocked` = 0 $sql_extra " ); - if (DBM::is_result($total)) { - $a->set_pager_total($total[0]['total']); + if (DBM::is_result($cnt)) { + $a->set_pager_total($cnt['total']); } $order = " ORDER BY `name` ASC ";