From: <var...@us...> - 2012-12-27 17:56:15
|
Revision: 8692 http://phpwiki.svn.sourceforge.net/phpwiki/?rev=8692&view=rev Author: vargenau Date: 2012-12-27 17:56:07 +0000 (Thu, 27 Dec 2012) Log Message: ----------- Remove commented code Modified Paths: -------------- trunk/lib/wikilens/RatingsDb.php Modified: trunk/lib/wikilens/RatingsDb.php =================================================================== --- trunk/lib/wikilens/RatingsDb.php 2012-12-27 11:05:49 UTC (rev 8691) +++ trunk/lib/wikilens/RatingsDb.php 2012-12-27 17:56:07 UTC (rev 8692) @@ -641,130 +641,6 @@ } -/* -class RatingsDB_backend_PearDB -extends WikiDB_backend_PearDB { - function get_rating($dimension=null, $rater=null, $ratee=null, - $orderby=null, $pageinfo = "ratee") { - $result = $this->_get_rating_result( - $dimension, $rater, $ratee, $orderby, $pageinfo); - return new WikiDB_backend_PearDB_generic_iter($this, $result); - } - - function get_users_rated($dimension=null, $orderby=null) { - $result = $this->_get_users_rated_result( - $dimension, $orderby); - return new WikiDB_backend_PearDB_generic_iter($this, $result); - } - - function get_rating_page($dimension=null, $rater=null, $ratee=null, - $orderby=null, $pageinfo = "ratee") { - $result = $this->_get_rating_result( - $dimension, $rater, $ratee, $orderby, $pageinfo); - return new WikiDB_backend_PearDB_iter($this, $result); - } - - function _get_rating_result($dimension=null, $rater=null, $ratee=null, - $orderby=null, $pageinfo = "ratee") { - // pageinfo must be 'rater' or 'ratee' - if (($pageinfo != "ratee") && ($pageinfo != "rater")) - return; - - $dbh = &$this->_dbh; - extract($this->_table_names); - - $where = "WHERE r." . $pageinfo . "page = p.id"; - if (isset($dimension)) { - $where .= " AND dimension=$dimension"; - } - if (isset($rater)) { - $raterid = $this->_get_pageid($rater, true); - $where .= " AND raterpage=$raterid"; - } - if (isset($ratee)) { - if(is_array($ratee)){ - $where .= " AND ("; - for($i = 0; $i < count($ratee); $i++){ - $rateeid = $this->_get_pageid($ratee[$i], true); - $where .= "rateepage=$rateeid"; - if($i != (count($ratee) - 1)){ - $where .= " OR "; - } - } - $where .= ")"; - } else { - $rateeid = $this->_get_pageid($ratee, true); - $where .= " AND rateepage=$rateeid"; - } - } - - $orderbyStr = ""; - if (isset($orderby)) { - $orderbyStr = " ORDER BY " . $orderby; - } - - $query = "SELECT *" - . " FROM $rating_tbl r, $page_tbl p " - . $where - . $orderbyStr; - - $result = $dbh->query($query); - - return $result; - } - - function _get_users_rated_result($dimension=null, $orderby=null) { - $dbh = &$this->_dbh; - extract($this->_table_names); - - $where = "WHERE p.id=r.raterpage"; - if (isset($dimension)) { - $where .= " AND dimension=$dimension"; - } - $orderbyStr = ""; - if (isset($orderby)) { - $orderbyStr = " ORDER BY " . $orderby; - } - - $query = "SELECT DISTINCT p.pagename" - . " FROM $rating_tbl r, $page_tbl p " - . $where - . $orderbyStr; - - $result = $dbh->query($query); - - return $result; - } - function delete_rating($rater, $ratee, $dimension) { - $dbh = &$this->_dbh; - extract($this->_table_names); - - $this->lock(); - $raterid = $this->_get_pageid($rater, true); - $rateeid = $this->_get_pageid($ratee, true); - - $dbh->query("DELETE FROM $rating_tbl WHERE raterpage=$raterid and rateepage=$rateeid and dimension=$dimension"); - $this->unlock(); - return true; - } - - function rate($rater, $ratee, $rateeversion, $dimension, $rating, $isPrivate = 'no') { - $dbh = &$this->_dbh; - extract($this->_table_names); - - $this->lock(); - $raterid = $this->_get_pageid($rater, true); - $rateeid = $this->_get_pageid($ratee, true); - - $dbh->query("DELETE FROM $rating_tbl WHERE raterpage=$raterid and rateepage=$rateeid and dimension=$dimension and isPrivate='$isPrivate'"); - // NOTE: Leave tstamp off the insert, and MySQL automatically updates it - $dbh->query("INSERT INTO $rating_tbl (dimension, raterpage, rateepage, ratingvalue, rateeversion, isPrivate) VALUES ($dimension, $raterid, $rateeid, $rating, $rateeversion, '$isPrivate')"); - $this->unlock(); - return true; - } -} -*/ - // Local Variables: // mode: php // tab-width: 8 This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |