From 81ce5f14d2c85fb7c4a19c169acc06fe2424eac8 Mon Sep 17 00:00:00 2001 From: friendica Date: Sun, 6 Apr 2014 18:57:04 -0700 Subject: missing pagination on viewconnections page --- mod/viewconnections.php | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'mod/viewconnections.php') diff --git a/mod/viewconnections.php b/mod/viewconnections.php index 84b976042..a9fb967f7 100644 --- a/mod/viewconnections.php +++ b/mod/viewconnections.php @@ -29,6 +29,15 @@ function viewconnections_content(&$a) { } + $r = q("SELECT count(*) as total FROM abook left join xchan on abook_xchan = xchan_hash where abook_channel = %d and abook_flags = 0 and not ( xchan_flags & %d ) and not ( xchan_flags & %d ) and not ( xchan_flags & %d ) ", + intval($a->profile['uid']), + intval(XCHAN_FLAGS_HIDDEN), + intval(XCHAN_FLAGS_ORPHAN), + intval(XCHAN_FLAGS_DELETED) + ); + if($r) { + $a->set_pager_total($r[0]['total']); + } $r = q("SELECT * FROM abook left join xchan on abook_xchan = xchan_hash where abook_channel = %d and abook_flags = 0 and not ( xchan_flags & %d ) and not ( xchan_flags & %d ) and not ( xchan_flags & %d ) order by xchan_name LIMIT %d , %d ", intval($a->profile['uid']), -- cgit v1.2.3