From e2a725ff986f80e45dac842db51fcc007a9683d9 Mon Sep 17 00:00:00 2001 From: friendica Date: Sun, 1 Jul 2012 19:17:21 -0700 Subject: pagination start off by one --- mod/message.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'mod/message.php') diff --git a/mod/message.php b/mod/message.php index 519634be5..80d2c6d99 100644 --- a/mod/message.php +++ b/mod/message.php @@ -224,6 +224,7 @@ function message_content(&$a) { // list messages $o .= $header; + $r = q("SELECT count(*) AS `total` FROM `mail` WHERE `mail`.`uid` = %d GROUP BY `parent-uri` ORDER BY `created` DESC", @@ -232,7 +233,7 @@ function message_content(&$a) { ); if(count($r)) $a->set_pager_total($r[0]['total']); - + $r = q("SELECT max(`mail`.`created`) AS `mailcreated`, min(`mail`.`seen`) AS `mailseen`, `mail`.* , `contact`.`name`, `contact`.`url`, `contact`.`thumb` , `contact`.`network`, count( * ) as count @@ -243,6 +244,7 @@ function message_content(&$a) { intval($a->pager['start']), intval($a->pager['itemspage']) ); + if(! count($r)) { info( t('No messages.') . EOL); return $o; -- cgit v1.2.3