View file mc-master/modules/news/controllers/news.php

<?php

/**
 * Ant0ha's project
 *
 * @package
 * @author Anton Pisarenko <[email protected]>
 * @copyright Copyright (c) 2006 - 2010, Anton Pisarenko
 * @license http://ant0ha.ru/license.txt
 * @link http://ant0ha.ru
 */
//---------------------------------------------



/**
 * Новости, пользовательская часть
 */
final class News_Controller extends Controller
{

    /**
     * Constructor
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * Действие по умолчанию
     */
    public function action_index()
    {
        $this->action_list_news();
    }

    /**
     * Детализирование новости
     */
    public function action_detail()
    {
        if (!$news = $this->db->get_row("SELECT * FROM #__news WHERE news_id = '" . intval($_GET['news_id']) . "'"))
            a_error('Новость не найдена!');

        $news['comments'] = $this->db->get_one("SELECT COUNT(*) FROM #__comments_posts WHERE module = 'news' AND item_id = '" . intval($_GET['news_id']) . "'");

        // Добавляем bbcod'ы
        $news['text'] = nl2br(main::bbcode($news['text']));

        $this->tpl->assign(array(
            'news' => $news
        ));

        $this->tpl->display('detail');
    }

    /**
     * Листинг новостей
     */
    public function action_list_news()
    {
        # Получение данных
        $result = $this->db->query("SELECT SQL_CALC_FOUND_ROWS n.*,
  		 (SELECT COUNT(*) FROM #__comments_posts WHERE module = 'news' AND item_id = n.news_id) AS comments
  		 FROM #__news AS n ORDER BY n.news_id DESC LIMIT $this->start, $this->per_page");

        $total = $this->db->get_one("SELECT FOUND_ROWS()");

        $list_news = array();
        while ($news = $this->db->fetch_array($result)) {
            $news['text'] = nl2br(main::bbcode($news['text']));
            $list_news[] = $news;
        }

        # Пагинация
        $pg_conf['base_url'] = a_url('news', 'start=');
        $pg_conf['total_rows'] = $total;
        $pg_conf['per_page'] = $this->per_page;

        a_import('libraries/pagination');
        $pg = new CI_Pagination($pg_conf);

        $this->tpl->assign(array(
            'list_news' => $list_news,
            'total' => $total,
            'pagination' => $pg->create_links()
        ));

        $this->tpl->display('list_news');
    }

    /**
     * Скрыть последнюю новость
     */
    public function action_hide_last_news()
    {
        if (ACCESS_LEVEL < 5)
            a_error('У вас нет прав на выполнение этой операции!');

        $this->db->query("UPDATE #__users SET hide_last_news = 'yes' WHERE user_id = '" . USER_ID . "'");

        header("Location: " . URL);
        exit;
    }

}

?>