aboutsummaryrefslogtreecommitdiffstats
path: root/mod
diff options
context:
space:
mode:
Diffstat (limited to 'mod')
-rw-r--r--mod/ping.php17
1 files changed, 4 insertions, 13 deletions
diff --git a/mod/ping.php b/mod/ping.php
index f32384952..9b29eacf7 100644
--- a/mod/ping.php
+++ b/mod/ping.php
@@ -180,24 +180,15 @@ function ping_init(&$a) {
$t2 = dba_timer();
- $intros1 = q("SELECT `intro`.`id`, `intro`.`datetime`,
- `fcontact`.`name`, `fcontact`.`url`, `fcontact`.`photo`
- FROM `intro` LEFT JOIN `fcontact` ON `intro`.`fid` = `fcontact`.`id`
- WHERE `intro`.`uid` = %d AND `intro`.`blocked` = 0 AND `intro`.`ignore` = 0 AND `intro`.`fid`!=0",
+ $intr = q("select count(abook_id) as total from abook where (abook_flags & %d) and abook_channel = %d",
+ intval(ABOOK_FLAG_PENDING),
intval(local_user())
);
$t3 = dba_timer();
- $intros2 = q("SELECT `intro`.`id`, `intro`.`datetime`,
- `contact`.`name`, `contact`.`url`, `contact`.`photo`
- FROM `intro` LEFT JOIN `contact` ON `intro`.`contact-id` = `contact`.`id`
- WHERE `intro`.`uid` = %d AND `intro`.`blocked` = 0 AND `intro`.`ignore` = 0 AND `intro`.`contact-id`!=0",
- intval(local_user())
- );
-
- $intros = count($intros1) + count($intros2);
- $result['intros'] = intval($intros);
+ if($intr)
+ $result['intros'] = intval($intr[0]['total']);
$t4 = dba_timer();
$channel = get_app()->get_channel();