View file php/inc.index.news.php

<?
global $user, $time;
if (isset($user)) // новости показываем только зарегистрированным
{
$q=mysql_query("SELECT * FROM `news` LEFT JOIN `news_read` ON `news`.`id` = `news_read`.`id_news` AND `news_read`.`id_user` = '$user[id]' WHERE `news_read`.`id_user` IS NULL AND `news`.`time` > '".($time-60*60*24*7)."' ORDER BY `time` ASC LIMIT 1");
if (mysql_num_rows($q)){
$block = new Smarty_conf();
//echo "Новостей: ".mysql_num_rows($q)."<br />\n";
$news=mysql_fetch_assoc($q);

$content=output_text($news['msg'])."<br />";
$content.= "<a href='/news/hide.php?id=$news[id]'>Скрыть новость</a> ";
if ($news['link'])$content.="<a href='".input_value_text($news['link'])."'>Подробности</a> ";
$content.= "<a href='/news/komm.php?id=$news[id]'>Комментарии</a> (".mysql_result(mysql_query("SELECT COUNT(*) FROM `news_komm` WHERE `id_news` = '$news[id]'"),0).")";


echo "<div class='news'>\n";
echo "<div class='news_title'>\n";
echo $news['title'].' ('.vremja($news['time']).')';
echo "</div>\n";
echo "<div class='news_content'>\n";
echo $content;
echo "</div>\n";
echo "</div>\n";
/*
$block->assign('content',$content);
$block->assign('title',$news['title'].' ('.vremja($news['time']).')');
$block->display('inc.index.block.tpl');
*/
}
}

?>