View file ä󿪫¬/modules/blogs/news_include.php

<?
echo '<div style="background-color: white; padding: 4px;">';
echo "<a href='/modules/blogs/dir.php?id=58'><div class='link_p'><span style='float: right'><font color=#4D8199><b><i class='fa fa-feed fa-lg'></i></span>СЕГОДНЯ В НОВОСТЯХ</b></font></div></a>";  



 $q1 = $pdo->query("SELECT * FROM `notes` WHERE `id_dir` = '58' AND `block` = '0' AND `private_komm` = '0' AND `metka` = '0' ORDER BY id DESC LIMIT 5");
  
 while ($post = $q1->fetch(PDO::FETCH_ASSOC)) {
echo "<div style='padding: 8px; border-bottom: 1px #C8D4DF solid; border-left: 1px #C8D4DF solid; border-right: 1px #C8D4DF solid;'>";

$notes_type = $post['notes_type'];
if($notes_type=='user'){ 
echo '<a href="/modules/blogs/list.php?id='.$post['id'].'">';



$files = $pdo->query("SELECT * FROM `notes_files` WHERE `id_post` = '$post[id]' LIMIT 1");

while ($posti = $files->fetch(PDO::FETCH_ASSOC))
{

	
	if($posti['type']=='foto'){
		$file_id = $pdo->query("SELECT * FROM `gallery_foto` WHERE `id_user` = '$posti[id_user]' AND `id` = '".$posti['id_file']."'")->fetch(PDO::FETCH_BOTH);	
		if(isset($file_id['id'])){
		$ras = htmlspecialchars(text($file_id['ras']));
		

	echo "<img class='avatar' src='/modules/foto/foto50/".$file_id['id'].".".$file_id['ras']."' style='border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;width: 35px; height: 35px;'> ";
     
 }	
		
		
		
	}elseif($posti['type']=='files'){
		$ras = htmlspecialchars(text($posti['ras']));

	if(is_file(H.'sys/blogs/files/'.$posti['id'].'.jpg')){



	echo "<img class='avatar' src='/sys/blogs/files/" . $posti['id'] . ".jpg' style='border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;width: 35px; height: 35px;'> ";
     
 

			

	}
	}
	}
}
////////////////////////////////////////////

if($notes_type=='soo'){
    
echo '<a href="/modules/groups/news/list.php?id='.$post['id_soo'].'&id_news='.$post['id_news'].'">';    
    
    
    
$files = $pdo->query("SELECT * FROM `soo_news_foto` WHERE `id_news` = '$post[id_news]' LIMIT 3");

while ($posti = $files->fetch(PDO::FETCH_ASSOC))
{

	
	if($posti['type']=='foto'){
		$file_id = $pdo->query("SELECT * FROM `gallery_foto` WHERE `id_user` = '$posti[id_user]' AND `id` = '".$posti['id_foto']."'")->fetch(PDO::FETCH_BOTH);	
		if(isset($file_id['id'])){
		$ras = htmlspecialchars(text($file_id['ras']));
		

	echo "<img class='avatar' src='/modules/foto/foto50/".$file_id['id'].".".$file_id['ras']."' style='border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;width: 35px; height: 35px;'> ";
     
 }	
		
		
		
	}elseif($posti['type']=='foto_upload'){
		$ras = htmlspecialchars(text($posti['ras']));

	if(is_file(H.'sys/groups/foto/' . $posti['id'] . '.jpg')){



	echo "<img class='avatar' src='/sys/groups/foto/" . $posti['id'] . ".jpg' style='border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;width: 35px; height: 35px;'> ";
     
 

			

	}
	}
	}	
}	





echo " <font color=#4D8199>" . $post['name'] . "</font> <font color=gray>(" . date::time($post['time']) . ")</font>";
echo "<br>";





echo "</div>";

 }






echo "<a href='/modules/blogs/dir.php?id=58'><div style='padding: 8px; border-bottom: 1px #C8D4DF solid; border-left: 1px #C8D4DF solid; border-right: 1px #C8D4DF solid;'>
<font color=#4D8199><span style='float: right'><i class='fa fa-chevron-right'></i></span>Читать все</font></div></a>";  
echo "</div>";

?>