View file www/sys/inc/news_main.php

File size: 1.17Kb
<?
$q = mysql_query("SELECT * FROM `news` WHERE `main_time` > '".time()."' ORDER BY `id` DESC LIMIT 1");

if (mysql_num_rows($q) == 1 && !$set['web'] && $user['news_read'] == 0)
{
	$news = mysql_fetch_assoc($q);
	echo '<div class="mess" style="padding:8px;">';
	
	
	?>
	<table><tr>
    <td><?echo '<img src="/style/icons/blogi.png" alt="*" /> <a href="/news/news.php?id=' . $news['id'] . '">' . text($news['title']) . '</a> ';?></td>
    <td style="float:right;"><?if (isset($user)){	
	echo '<span floar="right"><a href="?news_read">Скрыть</a></span><br>';}	?>
</td></tr></table>
	<?
	
	echo output_text($news['msg']) . '<br />';
	
	if ($news['link']!=NULL)
	echo '<a href="' .htmlentities($news['link'], ENT_QUOTES, 'UTF-8').'">Подробности</a><br />';
	
	?>
	<table><tr>
    <td><?	echo 'Опубликовал: '.group($news['id_user']).' ';
 echo user::nick($news['id_user'],1,1,1).' ';?></td>
    <td style="float:right;"><?echo ' <img src="/style/icons/komm.png" alt="*" /> Коментарии (' . mysql_result(mysql_query("SELECT COUNT(*) FROM `news_komm` WHERE `id_news` = '$news[id]'"),0) . ')';?>
</td></tr></table>
	<?
	echo '</div>';
}
?>