You are viewing a plain text version of this content. The canonical link for it is here.
Posted to olio-commits@incubator.apache.org by ak...@apache.org on 2009/01/14 05:03:26 UTC
svn commit: r734333 -
/incubator/olio/webapp/php/trunk/controllers/Tags_Controller.php
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'];