Marko Bischof

$news = News::model()->getRecent(10);

class News extends CActiveRecord
{
    public function getRecent($limit = 10) {
        $c = new CDbCriteria();
        $c->order = "created DESC";
        $c->limit = 10;
 
        return $this->findAll($c);
    }
}

$news = News::model()->recently(5)->findAll();

class News extends CActiveRecord
{
    public function recently($limit = 10) {
        $this->getDbCriteria()->mergeWith(array(
            'order' => 'created DESC',
            'limit' => $limit
        ));
 
        return $this;
    }
}

$news = News::model()->recently(5)->published()->findAll();

class News extends CActiveRecord
{
    public function published() {
        $this->getDbCriteria()->mergeWith(array(
            'condition' => 'status = 1',
        ));
 
        return $this;
    }
}

$news = News::model()->recently()->published()->findAll();

class News extends CActiveRecord
{
    public function scopes() {
        return array(
            "published" => array(
                "condition" => "status = 1"
            ),
            "recently" => array(
                "order" => "created DESC",
                "limit" => 10
            )
        );
    }
}