From 815c4e9be9806e7a467f6894d1884201458969d5 Mon Sep 17 00:00:00 2001 From: vargenau Date: Thu, 15 Nov 2012 13:54:31 +0000 Subject: [PATCH] Simpler SQL query git-svn-id: svn://svn.code.sf.net/p/phpwiki/code/trunk@8476 96ab9672-09ca-45d6-a79d-3d69d39ca109 --- lib/wikilens/RatingsDb.php | 6 +----- 1 file changed, 1 insertion(+), 5 deletions(-) diff --git a/lib/wikilens/RatingsDb.php b/lib/wikilens/RatingsDb.php index f9d4e786f..c22ed913b 100644 --- a/lib/wikilens/RatingsDb.php +++ b/lib/wikilens/RatingsDb.php @@ -383,12 +383,8 @@ class RatingsDb extends WikiDB if (isset($pagename)) $where .= " AND"; $where .= " dimension=$dimension"; } - //$dbh = &$this->_dbi; extract($dbi->_table_names); - $query = "SELECT AVG(ratingvalue) as avg" - . " FROM $rating_tbl r, $page_tbl p " - . $where - . " GROUP BY raterpage"; + $query = "SELECT AVG(ratingvalue) as avg FROM $rating_tbl r, $page_tbl p " . $where . " GROUP BY raterpage"; $result = $dbi->_dbh->query($query); $iter = new $this->iter_class($this, $result); $row = $iter->next(); -- 2.45.0