From 9de80c6d84b10b918c575ec123d5c94d63827268 Mon Sep 17 00:00:00 2001
From: mensonge
Date: Thu, 13 Mar 2008 10:07:22 +0000
Subject: Bug fix: correct counting for unified bookmarks

git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@77 b3834d28-1941-0410-a4f8-b48e95affb8f
---
 services/bookmarkservice.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'services/bookmarkservice.php')

diff --git a/services/bookmarkservice.php b/services/bookmarkservice.php
index 68f3821..b5ce452 100644
--- a/services/bookmarkservice.php
+++ b/services/bookmarkservice.php
@@ -370,7 +370,7 @@ class BookmarkService {
         if (SQL_LAYER == 'mysql4') {
             $totalquery = 'SELECT FOUND_ROWS() AS total';
         } else {
-            $totalquery = 'SELECT COUNT(*) AS total'. $query_2 . $query_3 . $query_4;
+            $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-54-g00ecf