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

[subaochen at devel.plogworld.net]

Author: subaochen
Date: 2005-02-19 09:07:22 +0000 (Sat, 19 Feb 2005)
New Revision: 1132

Modified:
   plog/trunk/class/dao/articlecategories.class.php
Log:
fix deleteBlogCategories: if delete blog categories, should also delete all article categories links  


Modified: plog/trunk/class/dao/articlecategories.class.php
===================================================================
--- plog/trunk/class/dao/articlecategories.class.php	2005-02-18 21:48:40 UTC (rev 1131)
+++ plog/trunk/class/dao/articlecategories.class.php	2005-02-19 09:07:22 UTC (rev 1132)
@@ -361,6 +361,13 @@
          */
         function deleteBlogCategories( $blogId )
         {
+            // first delete all article category links
+            $query = "DELETE FROM ".$this->getPrefix()."article_categories_links 
+                      WHERE category_id IN 
+                          (SELECT id FROM ".$this->getPrefix()."articles_categories 
+                              WHERE blog_id = $blogId)";
+            $this->Execute( $query );
+
         	$query = "DELETE FROM ".$this->getPrefix()."articles_categories 
 			          WHERE blog_id = $blogId";