public function show($id = null)
{
$tag = self::load_tag($id);
$this->assign("tag", $tag);
$page = 1;
if (isset($_GET['page'])) {
$page = $_GET['page'];
}
$tag_id = mysql_real_escape_string($tag->id);
$news = NewsTag::paginate("tags.id = '{$tag_id}'", $page, 10);
$items = array();
foreach ($news->collection as $newsitem) {
$items[] = News::find_by_id($newsitem->news->id);
}
$news->collection = $items;
$this->assign("page", $news);
$this->title = "View Tag";
$this->render("tag/show.tpl");
}
public function tags($tag = null)
{
$tag = self::load_tag($tag);
$page = 1;
if (isset($_GET['page'])) {
$page = $_GET['page'];
}
$tag_id = mysql_real_escape_string($tag->id);
$news = NewsTag::paginate("tags.id = '{$tag_id}' AND news.published = true AND news.publish_at < NOW()", "news.publish_at DESC", $page, 10);
$items = array();
foreach ($news->collection as $newsitem) {
$item = News::find_by_id($newsitem->news->id);
if (!$item) {
continue;
}
$items[] = $item;
}
$news->collection = $items;
$this->assign("page", $news);
$this->assign("tag", $tag);
$this->title = "News :: {$tag->tag}";
$this->render("news/tags.tpl");
}
