From 7884e0e33bf6e9502f0b193b33074e9b62563cc0 Mon Sep 17 00:00:00 2001 From: mensonge Date: Thu, 13 Mar 2008 10:11:26 +0000 Subject: Bug fix: correct counting result for history page git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@78 b3834d28-1941-0410-a4f8-b48e95affb8f --- services/bookmarkservice.php | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'services/bookmarkservice.php') diff --git a/services/bookmarkservice.php b/services/bookmarkservice.php index b5ce452..54c2773 100644 --- a/services/bookmarkservice.php +++ b/services/bookmarkservice.php @@ -370,7 +370,11 @@ class BookmarkService { if (SQL_LAYER == 'mysql4') { $totalquery = 'SELECT FOUND_ROWS() AS total'; } else { - $totalquery = 'SELECT COUNT(DISTINCT bAddress) AS total'. $query_2 . $query_3 . $query_4; + if ($hash) { + $totalquery = 'SELECT COUNT(*) AS total'. $query_2 . $query_3 . $query_4; + } else { + $totalquery = 'SELECT COUNT(DISTINCT bAddress) AS total'. $query_2 . $query_3 . $query_4; + } } if (!($totalresult = & $this->db->sql_query($totalquery)) || (!($row = & $this->db->sql_fetchrow($totalresult)))) { -- cgit v1.2.3