aboutsummaryrefslogtreecommitdiffstats
path: root/mod/message.php
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-07-01 19:17:21 -0700
committerfriendica <info@friendica.com>2012-07-01 19:17:21 -0700
commite2a725ff986f80e45dac842db51fcc007a9683d9 (patch)
treed3132f7b510e7af91ea2f2d4a89616804423389f /mod/message.php
parentdd71f9446b05274550ebcb3ce4773762832084e3 (diff)
downloadvolse-hubzilla-e2a725ff986f80e45dac842db51fcc007a9683d9.tar.gz
volse-hubzilla-e2a725ff986f80e45dac842db51fcc007a9683d9.tar.bz2
volse-hubzilla-e2a725ff986f80e45dac842db51fcc007a9683d9.zip
pagination start off by one
Diffstat (limited to 'mod/message.php')
-rw-r--r--mod/message.php4
1 files changed, 3 insertions, 1 deletions
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;