summaryrefslogtreecommitdiff
path: root/services
diff options
context:
space:
mode:
authormensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>2009-02-11 12:39:44 +0000
committermensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>2009-02-11 12:39:44 +0000
commit44915a6e54843ccba31cc18c5a5ae469f253b1fd (patch)
tree6e45dc0f0d1df6ec094fa8677373cd602654359b /services
parentfe83f9ea0eb58b7f5b2e034bf7ba9f855a73cb23 (diff)
downloadsemanticscuttle-44915a6e54843ccba31cc18c5a5ae469f253b1fd.tar.gz
semanticscuttle-44915a6e54843ccba31cc18c5a5ae469f253b1fd.tar.bz2
Interface Fix: add bookmarks counting into admin page
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@273 b3834d28-1941-0410-a4f8-b48e95affb8f
Diffstat (limited to 'services')
-rw-r--r--services/bookmarkservice.php26
-rw-r--r--services/userservice.php5
2 files changed, 29 insertions, 2 deletions
diff --git a/services/bookmarkservice.php b/services/bookmarkservice.php
index e77e40d..635d8ed 100644
--- a/services/bookmarkservice.php
+++ b/services/bookmarkservice.php
@@ -71,8 +71,30 @@ class BookmarkService {
return $this->_getbookmark('bHash', $hash, true);
}
- function countBookmarks($uId) {
-
+ /* Counts bookmarks for a user. $range = {'public', 'shared', 'private', 'all'}*/
+ function countBookmarks($uId, $range = 'public') {
+ $sql = 'SELECT COUNT(*) FROM '. $GLOBALS['tableprefix'] .'bookmarks';
+ $sql.= ' WHERE uId = '.$uId;
+ switch ($range) {
+ case 'all':
+ //no constraints
+ break;
+ case 'private':
+ $sql.= ' AND bStatus = 2';
+ break;
+ case 'shared':
+ $sql.= ' AND bStatus = 1';
+ break;
+ case 'public':
+ default:
+ $sql.= ' AND bStatus = 0';
+ break;
+ }
+
+ if (!($dbresult = & $this->db->sql_query($sql))) {
+ message_die(GENERAL_ERROR, 'Could not get vars', '', __LINE__, __FILE__, $sql, $this->db);
+ }
+ return $this->db->sql_fetchfield(0, 0);
}
function editAllowed($bookmark) {
diff --git a/services/userservice.php b/services/userservice.php
index 7f0382d..a4ed3ac 100644
--- a/services/userservice.php
+++ b/services/userservice.php
@@ -592,5 +592,10 @@ class User {
}
return $this->isAdmin;
}
+
+ function getNbBookmarks($range = 'public') {
+ $bookmarkservice =& ServiceFactory::getServiceInstance('BookmarkService');
+ return $bookmarkservice->countBookmarks($this->getId(), $range);
+ }
}
?>