diff options
| author | cweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f> | 2009-10-28 08:03:08 +0000 |
|---|---|---|
| committer | cweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f> | 2009-10-28 08:03:08 +0000 |
| commit | 64a44cceb80e29d14c718c576c1db02ca38b2195 (patch) | |
| tree | 733e6a94a743c7712b14c88090b1cc8b6dc57ba1 | |
| parent | a3ba58dfc048c948230317191c67101c4aa80bfb (diff) | |
| download | semanticscuttle-64a44cceb80e29d14c718c576c1db02ca38b2195.tar.gz semanticscuttle-64a44cceb80e29d14c718c576c1db02ca38b2195.tar.bz2 | |
update only one bookmark when voting;
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@446 b3834d28-1941-0410-a4f8-b48e95affb8f
| -rw-r--r-- | src/SemanticScuttle/Service/Vote.php | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/src/SemanticScuttle/Service/Vote.php b/src/SemanticScuttle/Service/Vote.php index 6db940c..168040d 100644 --- a/src/SemanticScuttle/Service/Vote.php +++ b/src/SemanticScuttle/Service/Vote.php @@ -246,8 +246,9 @@ class SemanticScuttle_Service_Vote extends SemanticScuttle_DbService //update bookmark table $bm = SemanticScuttle_Service_Factory::get('Bookmark'); $res = $this->db->sql_query( - 'UPDATE ' . $bm->getTableName() + $sql='UPDATE ' . $bm->getTableName() . ' SET bVoting = bVoting + ' . (int)$vote + . ' WHERE bId = ' . (int)$bookmark ); $this->db->sql_freeresult($res); @@ -267,7 +268,10 @@ class SemanticScuttle_Service_Vote extends SemanticScuttle_DbService { throw new Exception('Not implemented yet'); //FIXME - //SELECT bid, SUM( vote ) FROM sc_votes GROUP BY bid + $bm = SemanticScuttle_Service_Factory::get('Bookmark'); + $sql = 'UPDATE ' . $bm->getTableName() . ' as B SET bVoting = ' + . '(SELECT SUM(vote) FROM ' . $this->getTableName() . ' as V' + . ' WHERE V.bId = B.bId GROUP BY bid)'; } |