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

[oscar at devel.plogworld.net]

Author: oscar
Date: 2005-02-13 12:54:03 +0000 (Sun, 13 Feb 2005)
New Revision: 1053

Modified:
   plog/trunk/class/dao/mylinkscategories.class.php
Log:
removed "plog_" and added "{$prefix}"

Modified: plog/trunk/class/dao/mylinkscategories.class.php
===================================================================
--- plog/trunk/class/dao/mylinkscategories.class.php	2005-02-13 05:19:05 UTC (rev 1052)
+++ plog/trunk/class/dao/mylinkscategories.class.php	2005-02-13 12:54:03 UTC (rev 1053)
@@ -164,7 +164,7 @@
             $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
+                      FROM {$prefix}mylinks_categories c LEFT JOIN {$prefix}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;";