incubator-olio-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ak...@apache.org
Subject svn commit: r734333 - /incubator/olio/webapp/php/trunk/controllers/Tags_Controller.php
Date Wed, 14 Jan 2009 05:03:26 GMT
Author: akara
Date: Tue Jan 13 21:03:26 2009
New Revision: 734333

URL: http://svn.apache.org/viewvc?rev=734333&view=rev
Log:
Fix for issue OLIO-14: Changed $cloudquery as suggested by Richard Smith

Modified:
    incubator/olio/webapp/php/trunk/controllers/Tags_Controller.php

Modified: incubator/olio/webapp/php/trunk/controllers/Tags_Controller.php
URL: http://svn.apache.org/viewvc/incubator/olio/webapp/php/trunk/controllers/Tags_Controller.php?rev=734333&r1=734332&r2=734333&view=diff
==============================================================================
--- incubator/olio/webapp/php/trunk/controllers/Tags_Controller.php (original)
+++ incubator/olio/webapp/php/trunk/controllers/Tags_Controller.php Tue Jan 13 21:03:26 2009
@@ -66,9 +66,14 @@
     }
     
     function getEventsPageTagCloud($connection,$se) {
-                $cloudquery = "select tag, refcount as count from SOCIALEVENTTAG " .
-                    "where socialeventtagid in (select socialeventtagid " .
-                     "from SOCIALEVENTTAG_SOCIALEVENT where socialeventid = '$se') and refcount>0
order by tag ASC"; 
+                $cloudquery = "select  tag, refcount as count ".
+                              "from SOCIALEVENTTAG a, ".
+                              "SOCIALEVENTTAG_SOCIALEVENT b ".
+                              "where a.socialeventtagid = b.socialeventtagid ".
+                              "and b.socialeventid = '$se' ".
+                              "and a.refcount > 0 ".
+                              "order by tag ASC";
+
                 $cloudresult = $connection->query($cloudquery);
                 while ($row = $cloudresult->getArray())	{
                         $tags[$row['tag']] = $row['count'];



Mime
View raw message