From 8957293a71de49c24042cf2a60f92e97cdf6ba29 Mon Sep 17 00:00:00 2001 From: vargenau Date: Thu, 27 Dec 2012 17:56:07 +0000 Subject: [PATCH] Remove commented code git-svn-id: svn://svn.code.sf.net/p/phpwiki/code/trunk@8692 96ab9672-09ca-45d6-a79d-3d69d39ca109 --- lib/wikilens/RatingsDb.php | 124 ------------------------------------- 1 file changed, 124 deletions(-) diff --git a/lib/wikilens/RatingsDb.php b/lib/wikilens/RatingsDb.php index 02666f703..33f32298a 100644 --- a/lib/wikilens/RatingsDb.php +++ b/lib/wikilens/RatingsDb.php @@ -641,130 +641,6 @@ class RatingsDb extends WikiDB } -/* -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 -- 2.45.0