From e3b10414305b181aa4e39e211cf6b0e9bf992518 Mon Sep 17 00:00:00 2001
From: xue <>
Date: Wed, 31 May 2006 00:33:26 +0000
Subject: Added sticky feature for published posts.

---
 demos/blog/protected/Pages/Posts/ListPost.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'demos/blog/protected/Pages/Posts/ListPost.php')

diff --git a/demos/blog/protected/Pages/Posts/ListPost.php b/demos/blog/protected/Pages/Posts/ListPost.php
index bed18222..8c51546f 100644
--- a/demos/blog/protected/Pages/Posts/ListPost.php
+++ b/demos/blog/protected/Pages/Posts/ListPost.php
@@ -28,7 +28,7 @@ class ListPost extends BlogPage
 		$this->_posts=$this->DataAccess->queryPosts(
 				$this->getPostFilter(),
 				$this->getCategoryFilter(),
-				'ORDER BY create_time DESC',
+				'ORDER BY a.status DESC, create_time DESC',
 				'LIMIT '.$this->getPageOffset().','.$this->getPageSize());
 		if($this->Request['cat']!==null)
 		{
@@ -73,7 +73,7 @@ class ListPost extends BlogPage
 
 	private function getPostFilter()
 	{
-		$filter='a.status=0';
+		$filter='(a.status=0 OR a.status=3)';
 		if(($timeFilter=$this->getTimeFilter())!=='')
 			return "$filter AND $timeFilter";
 		else
-- 
cgit v1.2.3