View file news.php

File size: 3.81Kb
<?php 
// by mides, 1da.su

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

$type = 'news';

switch ($act) {
	default:
		echo '<div class="title">Новости</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'].'">Комментарии</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'].': '.date('d.m.y, H:i', $news['time']));
			$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'].'">Все комментарии</a> ('.$comm.')';
			
			// comms
			echo '</div><div class="title"><i>Последние комментарии</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=reply&amp;id='.$comm['id'].'">Отв</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=edit&amp;id='.$comm['id'].'">Ред</a>';
					if ($u['access'] > 0) echo '|<a href="?act=del&amp;id='.$comm['id'].'">Уд</a>';
					echo '<br />'.bb($comm['text']);
					if ($comm['edit_by']) echo '<br />_______<br /><span style="font-size: 10px;">отредактировано: '.login_simple($comm['edit_by']).' ('.date('d.m.y, H:i', $comm['edit_time']).' )</span>';
					echo '</div>';
				}
			} else {
				echo 'Комментарий к этой новости еще нет.';
			}
			echo '</div>';
			if ($u['id']) {
				echo '<div class="main">Добавить (max250):<br />
				<form action="?act=comm_add&amp;id='.$id.'" method="post">
				<textarea name="text" cols="" rows="3"></textarea>';
				echo '<input name="" type="submit" value="Ok">
				</form>
				</div>';
			}
			nav2('?', 'К новостям');
		} else {
			redirect('?');
		}
	break;
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
}

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