From 55598932936196d4a5012f801336c5d850b168ae Mon Sep 17 00:00:00 2001 From: Friendika Date: Thu, 13 Jan 2011 02:01:00 -0800 Subject: event and birthday data structures --- mod/notifications.php | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'mod') diff --git a/mod/notifications.php b/mod/notifications.php index ef7202363..49157c444 100644 --- a/mod/notifications.php +++ b/mod/notifications.php @@ -72,6 +72,16 @@ function notifications_content(&$a) { '$hide_text' => ((strlen($sql_extra)) ? t('Show Ignored Requests') : t('Hide Ignored Requests')) )); + + $r = q("SELECT COUNT(*) AS `total` FROM `intro` + WHERE `intro`.`uid` = %d $sql_extra AND `intro`.`blocked` = 0 ", + intval($_SESSION['uid']) + ); + if($r && count($r)) { + $a->set_pager_total($r[0]['total']); + $a->set_pager_itemspage(20); + } + $r = q("SELECT `intro`.`id` AS `intro_id`, `intro`.*, `contact`.* FROM `intro` LEFT JOIN `contact` ON `intro`.`contact-id` = `contact`.`id` WHERE `intro`.`uid` = %d $sql_extra AND `intro`.`blocked` = 0 ", @@ -152,5 +162,6 @@ function notifications_content(&$a) { } + $o .= paginate($a); return $o; } -- cgit v1.2.3