View file subscribe_posts.php

<?
// Скриваем рассылку
	if (isset($_GET['close_news']) && intval($_GET['news_id']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `subscribe_posts` WHERE `id` = '". intval($_GET['news_id']) ."'"), 0)==1 && mysql_result(mysql_query("SELECT COUNT(*) FROM `subscribe_posts_close` WHERE `id_user` = '$user[id]' AND `id_news` = '". intval($_GET['news_id']) ."'"), 0)==0) {
	mysql_query("INSERT INTO `subscribe_posts_close` (`id_user`, `id_news`) values('$user[id]', '".intval($_GET['news_id'])."')");
		header('Location: /');
		exit;
	}
// Выводим рассылку
	// Вывод рассылки Ak47res1
	$s_postsQ = mysql_query("SELECT * FROM `subscribe_posts`");
	while ($s_posts = mysql_fetch_assoc($s_postsQ)) {
	if (mysql_result(mysql_query("SELECT COUNT(*) FROM `subscribe_posts_close` WHERE `id_user` = '$user[id]' AND `id_news` = '$s_posts[id]'"), 0)==0){
		echo '<div class="msg">';
		
		echo '<span style="float:right"><a href="/?close_news&news_id='.$s_posts['id'].'" title="Удалить"><img src="/style/icons/delete.gif"></a></span>';
		
		echo '<img src="/style/icons/news_modsimg.png"> '.text($s_posts['msg']);
		
		if ($s_posts['url'] != NULL) {
		echo '<br> <a href="'.$s_posts['url'].'"><span style="color:darkgreen;">Подробнее →</span></a>';
		}
		echo '</div>';
	}	
	}	
?>