[pLog-svn] r655 - plog/trunk/class/dao

[ork at devel.plogworld.net]

Author: ork
Date: 2005-01-03 14:28:19 +0000 (Mon, 03 Jan 2005)
New Revision: 655

Modified:
   plog/trunk/class/dao/mylinkscategories.class.php
Log:
fixed bug 111 .. more detail in mantis..


Modified: plog/trunk/class/dao/mylinkscategories.class.php
===================================================================
--- plog/trunk/class/dao/mylinkscategories.class.php	2005-01-03 12:21:21 UTC (rev 654)
+++ plog/trunk/class/dao/mylinkscategories.class.php	2005-01-03 14:28:19 UTC (rev 655)
@@ -152,15 +152,21 @@
         function getMyLinksCategory( $categoryId, $blogId = 0 )
         {
 			$prefix = $this->getPrefix();
-			$query = "SELECT c.id AS id, c.name AS name, c.blog_id AS blog_id, 
-							 c.last_modification AS last_modification, c.properties AS properties, 
-							 COUNT(*) AS num_links 
-					  FROM {$prefix}mylinks l, {$prefix}mylinks_categories c 
-					  WHERE c.id = ".Db::qstr($categoryId)." AND l.category_id = c.id ";
+//			$query = "SELECT c.id AS id, c.name AS name, c.blog_id AS blog_id, 
+//							 c.last_modification AS last_modification, c.properties AS properties, 
+//							 COUNT(*) AS num_links 
+//					  FROM {$prefix}mylinks l, {$prefix}mylinks_categories c 
+//					  WHERE c.id = ".Db::qstr($categoryId)." AND l.category_id = c.id ";
+//
+//          if( $blogId > 0 )
+//          	$query .= " AND c.blog_id = ".Db::qstr($blogId)." AND l.blog_id = c.blog_id";
 
-            if( $blogId > 0 )
-            	$query .= " AND c.blog_id = ".Db::qstr($blogId)." AND l.blog_id = c.blog_id";
-							
+            $query = "SELECT c.id AS id, c.name AS name, c.blog_id AS blog_id, 
+                             c.last_modification AS last_modification, c.properties AS properties, 
+                             IF(l.id IS NULL, 0, COUNT(*)) AS num_links 
+                      FROM {$prefix}mylinks_categories c LEFT JOIN plog_mylinks l ON l.blog_id = c.blog_id AND l.category_id = c.id
+                      WHERE c.id = ".Db::qstr($categoryId)." ";
+            
 			$query .= " GROUP BY c.id;";
 
             $result = $this->Execute( $query );