diff -r 56befcb22751 -r 94a1dc255022 thd/apps/frontend/modules/homepage/actions/components.class.php --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/thd/apps/frontend/modules/homepage/actions/components.class.php Tue Sep 22 16:40:38 2009 +0200 @@ -0,0 +1,42 @@ +from('ThdFilm F') + ->leftJoin('F.images I ') + ->leftJoin('F.videos V') + //->where("cu.code='{$culture}' AND mo.code='{$module}' AND ms.code='{$section}'") + ->orderBy('F.id DESC') + ->limit(0,10); + $this->lastTaggedFilms = $query->execute(); + $this->videoPath = sfConfig::get('app_player_videoPath'); + + } + public function executeMostTaggedList() { + $query = Doctrine_Query::create() + ->from('ThdFilm F') + ->leftJoin('F.images I ') + ->leftJoin('F.videos V') + //->where("cu.code='{$culture}' AND mo.code='{$module}' AND ms.code='{$section}'") + ->orderBy('F.ref ASC') + ->limit(0,10); + $this->mostTaggedFilms = $query->execute(); + $this->videoPath = sfConfig::get('app_player_videoPath'); + } +} \ No newline at end of file