View file äó¿ª«¬/modules/blogs/dir.php

World Fastest and Cheapest Hosting
File size: 15.96Kb
<?
/* Mixanza
 * Дата последнего редактирования 03.12.2017
 * Модифицировал Mixanza
 */
foreach (array('start', 'compress', 'sess', 'settings', 'db_connect', 'ipua', 'fnc', 'user') as $inc) {
    require_once "../../sys/inc/$inc.php";
}





$set['title']='Категории блогов';
include_once '../../sys/inc/thead.php';
$ank=get_user($user['id']);

if (isset($_POST['title']) && access('adm_mysql'))
{
$title = htmlspecialchars($_POST['title'],1);


if (utf8_strlen($title)>32){$err='Название не может превышать больше 32 символов';}
if (utf8_strlen($title)<3){$err='Короткое название';}

if (!isset($err)){
$pdo->query("INSERT INTO `notes_dir` (`name`) values('$title')")->fetchColumn();
$pdo->query("OPTIMIZE TABLE `notes_dir`")->fetchColumn();

$_SESSION['message']='Категория успешно создана';
header("Location: dir.php?".SID);
exit;
}
}

err();
aut();






#Навигация
echo "<div class='card-header'>";
echo "<a href='/' data-toggle='tooltipecho' data-placement='right' title='" . lang('На главную') . "'><i class='fa fa-home fa-lg'></i></a> <i class='fa fa-angle-right fa-fw'></i> ";
echo "<a href='/modules/blogs/'>Блоги</a> <i class='fa fa-angle-right fa-fw'></i> Категории блогов";
echo "</div>";



echo "<div class='list-group-item'>";

$usearch=NULL;
if (isset($_SESSION['usearch']))$usearch=htmlspecialchars($_SESSION['usearch']);
if (isset($_POST['usearch']))$usearch=htmlspecialchars($_POST['usearch']);

if ($usearch==NULL)
unset($_SESSION['usearch']);
else
$_SESSION['usearch']=$usearch;
$usearch=preg_replace("#( ){1,}#","",$usearch);
$order='order by `time` desc';
$usearch = htmlspecialchars($usearch);

echo "<form action='search.php?go' method='GET'>";
echo "<input type='hidden' name='s' value='' />";
echo "<div class='input-group'>
<input type='text' name='q' value='" . htmlspecialchars($usearch) . "' class='form-control' placeholder='" . lang('Поиск записей') . "'>
<span class='input-group-btn'>
<button class='btn btn-secondary' type='submit'><i class='fa fa-search fa-fw'></i></button>
</span></div>";
echo "</form>";
echo "</div>";










echo'<div style="padding: 4px; background-color: white;">';


echo "<table style='width: 100%; text-align: center;'><tr>
<td class='fn-lefti'><a style='display: block;$padding_menu' href='/modules/blogs/index.php?sort=t'><font color=#587C94><b>НОВЫЕ</b></font></a></td>
<td class='fn-centeri'><a style='display: block;$padding_menu' href='/modules/blogs/index.php?sort=c'><b><font color=#587C94>ТОП</font></b></a></td>
<td class='fn-lefti-o'><a style='display: block;$padding_menu' href='dir.php'><b><font color=#587C94>КАТЕГОРИИ</font></b></a></td>
<td class='fn-righti'><a style='display: block;$padding_menu' href='vse.php'><b><font color=#587C94>ВСЕ</font></b></a></td>


</tr></table>";



echo'</div>';







if(isset($user) && $user['id']==$ank['id'])
{
echo "<div class='list-group-item'>"; 


if (isset($user) && access('adm_mysql')){
if (isset($_GET['create'])){
}else{
$doc->Link('btn btn-primary btn-sm', 'dir.php?create', 'plus', 'Новая категория');     
}
}
 $doc->Link('btn btn-primary btn-sm', "add.php", 'plus', 'Создать запись');  
 $doc->Link('btn btn-secondary btn-sm', "user.php", 'book', 'Мои записи'); 
echo "</div>";      
}





if (isset($user) && access('adm_mysql')){
if (isset($_GET['create'])){
echo "<div class='list-group-item'>";     
    
echo "<form method=\"post\" action=\"dir.php\">\n";
echo "Название:<br />\n<input class=\"form-control\" name=\"title\" size=\"16\" maxlength=\"32\" value=\"\" type=\"text\" /><br />\n";
echo "<input class=\"btn btn-primary btn-sm\" value=\"Добавить\" type=\"submit\" />\n";
echo "</form>\n";
echo "</div>";
}}







 











/*
==================================
Дневники
==================================
*/

if (isset($_GET['id']))
{
$id_dir=intval($_GET['id']);
$kount=$pdo->query(("SELECT COUNT(*) FROM `notes_dir` WHERE `id` = '$id_dir' "),0)->fetchColumn();
}
if (isset($_GET['id']) && $kount==1)
{
if (isset($_GET['sort']) && $_GET['sort'] =='t')$order='order by `time` desc';
elseif (isset($_GET['sort']) && $_GET['sort'] =='c') $order='order by `count` desc';
else $order='order by `time` desc';

if (isset($_GET['sort']) && $_GET['sort'] =='t'){
echo'<div class="list-group-item"><b>Сортировка:</b> ';
echo"<b>Новые</b> | <a href='?id=$id_dir&amp;sort=c'>Популярные</a>\n";
echo '</div>';
}elseif (isset($_GET['sort']) && $_GET['sort'] =='c'){
echo'<div class="list-group-item"><b>Сортировка:</b> ';
echo"<a href='?id=$id_dir&amp;sort=t'>Новые</a> | <b>Популярные</b>\n";
echo '</div>';
}else{
echo'<div class="list-group-item"><b>Сортировка:</b> ';
echo"<b>Новые</b> | <a href='?id=$id_dir&amp;sort=c'>Популярные</a>\n";
echo '</div>';
}
$k_post = $pdo->query(("SELECT COUNT(*) FROM `notes`  WHERE `id_dir` = '$id_dir' AND `block` = '0' AND `private` = '0'"),0)->fetchColumn();
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
$q=$pdo->query("SELECT * FROM `notes` WHERE `id_dir` = '$id_dir' AND `block` = '0' AND `private` = '0' $order LIMIT $start, $set[p_str]");

if ($k_post==0)
{
$doc->NoResult();
}
$num=0;
while ($post = $q->fetch(PDO::FETCH_ASSOC))
{

$notes_type = $post['notes_type'];



if($notes_type=='user'){


echo'<div class="list-group-item">';

$ank = get_user($post['id_user']);

$frend = $pdo->query(("SELECT COUNT(*) FROM `friendsi` WHERE (`user` = '$user[id]' AND `friendsi` = '$ank[id]') OR (`user` = '$ank[id]' AND `friendsi` = '$user[id]') LIMIT 1"),0)->fetchColumn();


echo '<i class="fa fa-book fa-fw"></i> ';
echo user($post['id_user']);
echo ' : ';
    
echo "<a href='/modules/blogs/list.php?id=$post[id]'>" . text($post['name']) . "</a>\n";

echo "<span style='float: right;'>";
echo "<font color=gray><small>".date::times($post['time'])."</small></font>";
echo "</span><br>";




$files = $pdo->query("SELECT * FROM `notes_files` WHERE `id_post` = '$post[id]' 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_file']."'")->fetch(PDO::FETCH_BOTH);	
		if(isset($file_id['id'])){
		$ras = htmlspecialchars(text($file_id['ras']));
		
		
if (IS_WEB == 1) {

	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: 85px; height:85px;'>\n";
}else{
	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: 70px; height: 70px;'>\n";
     
 }	}
		
		
		
	}elseif($posti['type']=='files'){
		$ras = htmlspecialchars(text($posti['ras']));

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


 if (IS_WEB == 1) {

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

			

	}


	}

}











echo "<br />\n";
   
echo mb_substr($post['msg'],0,50,'UTF-8')."...\n"; 

echo "<br />\n";

$cat = $pdo->query(("SELECT * FROM `notes_dir` WHERE `id` = '$post[id_dir]' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);

if($cat['id'] > 0){
echo "<div style='text-align: right; padding: 0px;'><a href='/modules/blogs/dir.php?id=$cat[id]'><font color=#85A0AC><small><i class='fa fa-feed'></i> $cat[name]</small></font></a></div>";
}


echo "<br />\n";

if (isset($user)){
if ($pdo->query(("SELECT COUNT(*) FROM `notes_like` WHERE `id_user` = '".$user['id']."' AND `id_notes` = '".$post['id']."' LIMIT 1"),0)->fetchColumn()==0){
$like=$pdo->query(("SELECT COUNT(*) FROM `notes_like` WHERE `id_notes`='$post[id]'"),0)->fetchColumn();
echo "<a href='list.php?id=$post[id]&amp;like=1'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Нравится') . "'>";
echo "<i class='fa fa-heart-o fa-fw'></i> $like</span></a> ";
}else{
$like=$pdo->query(("SELECT COUNT(*) FROM `notes_like` WHERE `id_notes`='$post[id]'"),0)->fetchColumn();
echo "<a href='list.php?id=$post[id]'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Понравилось') . "'>";
echo "<i class='fa fa-heart fa-fw'></i> $like</span></a> ";    
}
}

$pod=$pdo->query(("SELECT COUNT(*)FROM `notes` WHERE `share_id`='".$post['id']."' AND `share_type`='notes'"),0)->fetchColumn();

echo "<a href='/modules/blogs/share.php?id=$post[id]'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Поделиться') . "'>";
echo "<i class='fa fa-mail-forward fa-fw'></i> $pod</span></a> ";

$comm=$pdo->query(("SELECT COUNT(*) FROM `notes_komm` WHERE `id_notes`='$post[id]'"),0)->fetchColumn();
echo "<a href='/modules/blogs/list.php?id=$post[id]'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Комментарии') . "'>";
echo "<i class='fa fa-comments fa-fw'></i> $comm</span></a>";

$pr=$pdo->query(("SELECT COUNT(*) FROM `notes_count` WHERE `id_notes`='$post[id]'"),0)->fetchColumn();
echo "<span style='float: right;'><a href='/modules/blogs/list.php?id=$post[id]'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Просмотры') . "'>";
echo "<i class='fa fa-eye fa-fw'></i> $pr</span></a></span>";
echo "   </div>\n";
}

if($notes_type=='soo'){

echo '<div class="list-group-item">';

$ank = get_user($post['id_user']);
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '$post[id_soo]' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$news = $pdo->query(("SELECT * FROM `soo_news` WHERE `id` = '$post[id_news]' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);

echo '<i class="fa fa-book fa-fw"></i> ';
echo "<a href='/modules/groups/group.php?id=$post[id_soo]'><font color='#4B8085'><i class='fa fa-users fa-fw'></i></font> <font color='black'><b>$soo[name]</b></font></a>";
echo ' : ';

   
echo "<a href='/modules/groups/news/list.php?id=$post[id_soo]&id_news=$post[id_news]'>" . text($post['name']) . "</a>\n";

echo "<span style='float: right;'>";
echo "<font color=gray><small>".date::times($post['time'])."</small></font>";
echo "</span><br>";



$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_file']."'")->fetch(PDO::FETCH_BOTH);	
		if(isset($file_id['id'])){
		$ras = htmlspecialchars(text($file_id['ras']));
		
		
if (IS_WEB == 1) {

	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: 85px; height:85px;'>\n";
}else{
	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: 70px; height: 70px;'>\n";
     
 }	}
		
		
		
	}elseif($posti['type']=='foto_upload'){
		$ras = htmlspecialchars(text($posti['ras']));

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


 if (IS_WEB == 1) {

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

			

	}


	}

}




echo "<br />\n";


echo mb_substr($post['msg'],0,50,'UTF-8')."...\n"; 

echo "<br />\n";

$cat = $pdo->query(("SELECT * FROM `notes_dir` WHERE `id` = '$post[id_dir]' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);

if($cat['id'] > 0){
echo "<div style='text-align: right; padding: 0px;'><a href='/modules/blogs/dir.php?id=$cat[id]'><font color=#85A0AC><small><i class='fa fa-feed'></i> $cat[name]</small></font></a></div>";
}


echo "<br />\n";

if (isset($user)){
if ($pdo->query(("SELECT COUNT(*) FROM `like_object_soo_news` WHERE `id_object` = '$post[id_news]' AND `type` = 'soo_newsl' AND `id_user` = '$user[id]' LIMIT 1"),0)->fetchColumn()==0){
echo "<a href='/modules/groups/news/list.php?id=$post[id_soo]&id_news=$post[id_news]&like=1'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Нравится') . "'>";
echo "<i class='fa fa-heart-o fa-fw'></i> ".$pdo->query(("SELECT COUNT(*) FROM `like_object_soo_news` WHERE `id_object` = '$post[id_news]' AND `type` = 'soo_newsl' AND `like` = '1'"),0)->fetchColumn()."</span></a> ";
}else{
echo "<a href='/modules/groups/news/list.php?id=".htmlspecialchars($soo['id'])."&id_news=$post[id_news]'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Понравилось') . "'>";
echo "<i class='fa fa-heart fa-fw'></i> ".$pdo->query(("SELECT COUNT(*) FROM `like_object_soo_news` WHERE `id_object` = '$post[id_news]' AND `type` = 'soo_newsl' AND `like` = '1'"),0)->fetchColumn()."</span></a> ";    
}
}

$pod=$pdo->query(("SELECT COUNT(*)FROM `notes` WHERE `share_id`='$post[id_news]' AND `share_type`='soo_news'"),0)->fetchColumn();

echo "<a href='/modules/groups/news/share.php?id=$post[id_soo]&id_news=$post[id_news]'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Поделиться') . "'>";
echo "<i class='fa fa-mail-forward fa-fw'></i> $pod</span></a> ";

$comm=$pdo->query(("SELECT COUNT(*) FROM `soo_news_komm` WHERE `id_news`='$post[id_news]'"),0)->fetchColumn();
echo "<a href='/modules/groups/news/list.php?id=$post[id_soo]&id_news=$post[id_news]'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Комментарии') . "'>";
echo "<i class='fa fa-comments fa-fw'></i> $comm</span></a>";

echo "<span style='float: right;'><a href='/modules/groups/news/list.php?id=$post[id_soo]&id_news=$post[id_news]'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Просмотры') . "'>";
echo "<i class='fa fa-eye fa-fw'></i> $post[count]</span></a></span>";
echo "   </div>\n";




}





}

if (isset($_GET['sort'])) $dop="sort=" . $_GET['sort'] . "&amp;";
else $dop='';
if ($k_page>1)str('?id='.$id_dir.'&'.$dop.'',$k_page,$page); // Вывод страниц

include_once '../../sys/inc/tfoot.php';
exit;
}


/*
==================================
Категории
==================================
*/
$k_post=$pdo->query(("SELECT COUNT(*) FROM `notes_dir` "),0)->fetchColumn();
$q=$pdo->query("SELECT * FROM `notes_dir` ORDER BY `id` DESC");

if ($k_post==0)
{
$doc->NoResult();
}
$num=0;
while ($post = $q->fetch(PDO::FETCH_ASSOC))
{

echo "<div class='list-group-item'>";

echo "<i class='fa fa-book fa-fw'></i> ";
$k_pp=$pdo->query(("SELECT COUNT(*) FROM `notes`  WHERE `id_dir` = '$post[id]'"),0)->fetchColumn();
$k_nn=$pdo->query(("SELECT COUNT(*) FROM `notes`  WHERE `id_dir` = '$post[id]' AND `time` > '$ftime'"),0)->fetchColumn();


echo "<a href='dir.php?id=$post[id]'>" . toOutput($post['name']) . "</a> <span class='badge' style='float:right;'>$k_pp</span>\n";


if (isset($user) && access('adm_mysql'))
echo "  <a href='delete.php?dir=$post[id]'><i class='fa fa-trash fa-fw'></i></a>\n";

echo "   </div>\n";
}





include_once '../../sys/inc/tfoot.php';
?>