[pLog-CVS] plog/class/dao articles.class.php,1.2,1.3

[<phu...@us...>]

Update of /cvsroot/plog/plog/class/dao
In directory sc8-pr-cvs1:/tmp/cvs-serv24303/class/dao

Modified Files:
	articles.class.php 
Log Message:
added another action to purge all the posts in all the blogs. 'Purge' means
that all posts that were marked with 'Deleted' status in the db will be removed
forever from there.


Index: articles.class.php
===================================================================
RCS file: /cvsroot/plog/plog/class/dao/articles.class.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** articles.class.php	13 Nov 2003 13:14:39 -0000	1.2
--- articles.class.php	14 Nov 2003 14:17:18 -0000	1.3
***************
*** 438,444 ****
              	// the deleteArticle method will also take care of removing comments and
                  // trackbacks
-                 print("deleting article ".$article->getId()."<br/>");
              	$this->deleteArticle( $article->getId(), $article->getUser(), $article->getBlog(), true );
              }
          }
  
--- 438,461 ----
              	// the deleteArticle method will also take care of removing comments and
                  // trackbacks
              	$this->deleteArticle( $article->getId(), $article->getUser(), $article->getBlog(), true );
              }
+         }
+ 
+         /**
+          * removes all posts that have 'deleted' status
+          */
+         function purgePosts()
+         {
+         	$query = "SELECT * FROM ".$this->getPrefix()."articles WHERE status = 'deleted'";
+ 
+             $result = $this->_db->Execute( $query );
+             if( !$result )
+             	return false;
+ 
+             while( $row = $result->FetchRow()) {
+             	$this->deleteArticle( $row["id"], $row["user_id"], $row["blog_id"], true );
+             }
+ 
+             return true;
          }