View file news.php

File size: 4.38Kb
<?php 
// by Mike O. (mides), coolcms.mobi

$title = 'Новости';
require_once 'system/sys.php';
require_once 'system/header.php';

$type = 'news';

switch ($act) {
    default:
        echo '<div class="title">'.$lang['news'].'</div><div class="list">';
        $total = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `news`"), 0);
        if ($total > 0) {
            $pages = ceil($total / $config['onpage']);
            if ($page > $pages or $page == 0) {
                    $page = 1;
            }
            $begin = ($page - 1) * $config['onpage'];

            $news_r = mysql_query("SELECT * FROM `news` ORDER BY `time` DESC LIMIT $begin, $config[onpage]");
            while ($news = mysql_fetch_assoc($news_r)) {
                if (!isset($num) ) $num = 1;  
                $num++;
                $row_class = (!($num % 2)) ? 'row1' : 'row2';	
                $comm = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `news_comm` WHERE `id_news` = '$news[id]'"), 0);
                echo '<div class="'.$row_class.'"><a href="?act=view&amp;id='.$news['id'].'"><b>'.$news['name'].'</b></a>: '.date('d.m.Y, H:i', $news['time']).'<br />'.bb($news['text']).'<br /><a href="?act=comm&amp;id='.$news['id'].'">'.$lang['comments'].'</a> ('.$comm.')</div>';
            }
            navig($page, '?', $pages);
        }
        nav_main();
    break;

    case 'comm':
        require_once 'system/comm.php';
    break;

    case 'comm_add':
        require_once 'system/comm_add.php';
    break;

    case 'comm_reply':
        require_once 'system/comm_reply.php';
    break;

    case 'comm_edit':
        require_once 'system/comm_edit.php';
    break;

    case 'comm_del':
        require_once 'system/comm_del.php';
    break;

    case 'view':
        $news_r = mysql_query("SELECT * FROM `news` WHERE `id` = '$id'");
        $news = mysql_fetch_assoc($news_r);
        if ($news['id']) {
            tp($news['name'].': '.ccdate($news['time'], 0));
            $comm = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `news_comm` WHERE `id_news` = '$id'"), 0);
            echo bb($news['text']).'<br /><a href="news.php?act=comm&amp;id='.$news['id'].'">'.$lang['all_comments'].'</a> ('.$comm.')';

            // comments
            echo '</div><div class="title"><i>'.$lang['recent_comments'].'</i></div><div class="list">';
            $count_comm = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `news_comm` WHERE `id_news` = '$id'"), 0);
            if ($count_comm > 0) {
                $comm_r = mysql_query("SELECT * FROM `news_comm` WHERE `id_news` = '$id' ORDER BY `time` DESC LIMIT 5");
                while ($comm = mysql_fetch_assoc($comm_r)) {
                    if (!isset($num) ) $num = 1;  
                    $num++;
                    $row_class = (!($num % 2)) ? 'row1' : 'row2';	
                    echo '<div class="'.$row_class.'">';

                    echo '<a href="profile.php?id='.$comm['id_user'].'">'.login($comm['id_user']).'</a> '.ccdate($comm['time'], $comm['id_user']).' <a href="?act=comm_reply&amp;id='.$comm['id'].'">'.$lang['re'].'</a>';
                    if ($u['access'] > 0 or $u['id'] and $u['id'] == $comm['id_user'] and time() - $comm['time'] < $config['edit_time']) echo '|<a href="?act=comm_edit&amp;id='.$comm['id'].'">'.$lang['edit'].'</a>';
                    if ($u['access'] > 0) echo '|<a href="?act=comm_del&amp;id='.$comm['id'].'">DEL</a>';
                    echo '<br />'.bb($comm['text']);
                    if ($comm['edit_by']) echo '<br />_______<br /><span style="font-size: 10px;">'.$lang['edited_by'].': '.justusername($comm['edit_by']).' ('.ccdate($comm['edit_time'], 0).' )</span>';
                    echo '</div>';
                }
            } else {
                echo $lang['no_comments_yet'];
            }
            echo '</div>';
            if ($u['id']) {
                echo '<div class="main">
                <form name="form" action="?act=comm_add&amp;id='.$id.'" method="post">
                 '.bbpanel('form', 'text').'<textarea name="text" cols="" rows="3"></textarea>';
                echo '<input name="" type="submit" value="Ok">
                </form>
                </div>';
            }
            nav2('?', $lang['news']);
        } else {
            redirect('?');
        }
    break;			
	
}

require_once ('system/tail.php');
?>