[phpwiki-checkins] SF.net SVN: phpwiki:[8477] trunk/lib/wikilens/RatingsDb.php

[<var...@us...>]

Revision: 8477
          http://phpwiki.svn.sourceforge.net/phpwiki/?rev=8477&view=rev
Author:   vargenau
Date:     2012-11-15 14:07:14 +0000 (Thu, 15 Nov 2012)
Log Message:
-----------
Check for FUSIONFORGE

Modified Paths:
--------------
    trunk/lib/wikilens/RatingsDb.php

Modified: trunk/lib/wikilens/RatingsDb.php
===================================================================
--- trunk/lib/wikilens/RatingsDb.php	2012-11-15 13:54:31 UTC (rev 8476)
+++ trunk/lib/wikilens/RatingsDb.php	2012-11-15 14:07:14 UTC (rev 8477)
@@ -376,15 +376,24 @@
                 $where = "WHERE";
             }
             if (isset($pagename)) {
-                $raterid = $this->_sqlbackend->_get_pageid($pagename, true);
-                $where .= " raterpage=$raterid";
+                if (defined('FUSIONFORGE') and FUSIONFORGE) {
+                    $rateeid = $this->_sqlbackend->_get_pageid($pagename, true);
+                    $where .= " rateepage=$rateeid";
+                } else {
+                    $raterid = $this->_sqlbackend->_get_pageid($pagename, true);
+                    $where .= " raterpage=$raterid";
+                }
             }
             if (isset($dimension)) {
                 if (isset($pagename)) $where .= " AND";
                 $where .= " dimension=$dimension";
             }
             extract($dbi->_table_names);
-            $query = "SELECT AVG(ratingvalue) as avg FROM $rating_tbl r, $page_tbl p " . $where . " GROUP BY raterpage";
+            if (defined('FUSIONFORGE') and FUSIONFORGE) {
+                $query = "SELECT AVG(ratingvalue) as avg FROM $rating_tbl " . $where;
+            } else {
+                $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();

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.