View file äó¿ª«¬/modules/video/vse.php

World Fastest and Cheapest Hosting
File size: 15.08Kb
<?
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';

aut();

?><style>
.d_c {
background-color: #5CAC5F;  
padding: 5px;
border-radius: 4px 0px 0px 4px;
border: 1px #9AADB6 solid;
}

.d_c2 {
background-color: white;  
padding: 5px;
border-radius: 0px 4px 4px 0px;
border: 1px #9AADB6 solid;
}
</style>	<?	

#Навигация
echo "<div class='card-header'>";
echo "<a href='/' data-toggle='tooltip' 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/video/'>Видео</a>";
echo "</div>";

$sort = 'id'; 
$por = 'DESC';

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

if ($search_video == NULL)
unset($_SESSION['search_video']);
else
$_SESSION['search_video'] = $search_video;
$search_video = preg_replace("#( ){1,}#","",$search_video);



  echo "<div class='list-group-item'>\n";
    echo "<form action='?go&amp;sort=" . $sort . "&amp;" . $por . "' method='post'>";
    echo "<input type='hidden' name='search_video' value='' />";
    echo "<div class='input-group'>
      <input type='text' name='search_video' value='" . $search_video . "' 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>";




if (!isset($_GET['go']))
{

	$k_post = $pdo->query(("SELECT COUNT(*) FROM `user_video` WHERE `private_folder` = '0' AND `metka` = '0' AND `block_yes` = '0'"),0)->fetchColumn();
	$k_page = k_page($k_post,$set['p_str']);
	$page = page($k_page);
	$start = $set['p_str']*$page-$set['p_str'];




	if ($k_post == 0)
	{
$doc->NoResult();
	}
	else
	{
		

		
		
		
echo "<div style='padding: 4px; background-color: white;'>";		
		
		switch (@$_GET['sort']) 
		{
case 'rate':$sql_sort = '`k_loads`'; $sort = 'rate'; // баллы		    
			


echo "<table style='width: 100%; text-align: center;'><tr>
<td class='fn-lefti'><a style='display: block;padding: 10px;' href='index.php?sort=id&amp;DESC&amp;page=$page'><font color=#587C94><b>НОВЫЕ</b></font></a></td>

<td class='fn-centeri'><a style='display: block;padding: 10px;' href='index.php?sort=rate&amp;DESC&amp;page=$page'><b><font color=#587C94>ТОП</font></b></a></td>

<td class='fn-lefti-o'><a style='display: block;padding: 10px;' href='vse.php'><b><font color=#587C94>ВСЕ</font></b></a></td>

<td class='fn-righti'><a style='display: block;padding: 10px;' href='/modules/videos/'><font color=#587C94><b>YOUTUBE</b></font></a></td></tr></table>";



		 	break;
		 	default:$sql_sort = '`id`'; $sort = 'id'; // ID
			
echo "<table style='width: 100%; text-align: center;'><tr>
<td class='fn-lefti'><a style='display: block;padding: 10px;' href='index.php?sort=id&amp;DESC&amp;page=$page'><font color=#587C94><b>НОВЫЕ</b></font></a></td>

<td class='fn-centeri'><a style='display: block;padding: 10px;' href='index.php?sort=rate&amp;DESC&amp;page=$page'><b><font color=#587C94>ТОП</font></b></a></td>

<td class='fn-lefti-o'><a style='display: block;padding: 10px;' href='vse.php'><b><font color=#587C94>ВСЕ</font></b></a></td>
<td class='fn-righti'><a style='display: block;padding: 10px;' href='/modules/videos/'><font color=#587C94><b>YOUTUBE</b></font></a></td></tr></table>";

		 	break;
		}
echo '</div>';		
	}
$v1 = $pdo->query(("SELECT COUNT(*) FROM `user_video`"),0)->fetchColumn();
$v2 = $pdo->query(("SELECT COUNT(*) FROM `videos`"),0)->fetchColumn();
$video = $v2 + $v1;

echo "<div class='list-group-item'><b>Всего видеороликов: $video</b>";
echo '</div>';

	$q = $pdo->query("SELECT * FROM `user_video` WHERE `private_folder` = '0' AND `metka` = '0' AND `block_yes` = '0' ORDER BY $sql_sort $por LIMIT $start, $set[p_str];");

	while ($post = $q->fetch(PDO::FETCH_ASSOC))
	{

$ras=htmlspecialchars($post['ras']);
$name=htmlspecialchars($post['name']);
$size=htmlspecialchars($post['size']);

if (IS_WEB == 1) {
echo "<div class='list-group-item'><a href='/user/video/file.php?id=".htmlspecialchars($post['id'])."'>";
echo "<span style='position: absolute; left: 30px; bottom: 108px;'><font color=white><i class='fa fa-play-circle-o fa-2x'></i></font></span><img src='".$df['name']."".$video77."screen/$post[id].jpg' style='width: 65px; height: 65px; border-radius: 2px;'/> ";
echo "<span style='position: absolute; left: 80px; bottom: 140px;'><font color=#367CB4><i class='fa fa-video-camera'></i></font> <font color=black><b>".substr(output_text($post['name']),0,45)."...</b>";
echo "</font></span>";
echo "<span style='border: 1px #AEB6BD solid; border-radius: 3px; color: #AEB6BD; float: right;'><small>".size_file(htmlspecialchars($size))."</small></span><br>";
echo "<span style='position: absolute; left: 80px; bottom: 115px;'> <font color=black>".htmlspecialchars(substr(text($post['opis']),0,45))."...</font></a><br>";
}else{
echo "<div class='list-group-item'><a href='/user/video/file.php?id=".htmlspecialchars($post['id'])."'>";
echo "<span style='position: absolute; left: 30px; bottom: 108px;'><font color=white><i class='fa fa-play-circle-o fa-2x'></i></font></span><img src='".$df['name']."".$video77."screen/$post[id].jpg' style='width: 65px; height: 65px; border-radius: 2px;'/> ";
echo "<span style='position: absolute; left: 80px; bottom: 140px;'><font color=#367CB4><i class='fa fa-video-camera'></i></font> <font color=black><b>".substr(output_text($post['name']),0,18)."...</b>";
echo "</font></span> <span style='border: 1px #AEB6BD solid; border-radius: 3px; color: #AEB6BD; float: right;'><small>".size_file(htmlspecialchars($size))."</small></span><br>";
echo "<span style='position: absolute; left: 80px; bottom: 115px;'> <font color=black>".substr(output_text($post['opis']),0,25)."...</font></a><br>";
}

echo '<a href="'.$df['name'].''.$video77.''.$post['id'].'.'.$post['ras'].'" download="FaceFree.Ru_' . stripcslashes(htmlspecialchars($post['name'])) . '.mp4">
<span class="d_c"><font color=white><i class="fa fa-download"></i> Скачать</font></span></a><span class="d_c2"><font color="gray">'.size_file($post['size']).'</font></span><br><br>';


if (isset($user)){
if ($pdo->query(("SELECT COUNT(*) FROM `like_object` WHERE `id_object` = '$post[id]' AND `type` = 'user_video' AND `id_user` = '$user[id]' LIMIT 1"),0)->fetchColumn()==0){
echo "<a href='/user/video/file.php?id=".htmlspecialchars($post['id'])."&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` WHERE `id_object` = '$post[id]' AND `type` = 'user_video' AND `like` = '1'"),0)->fetchColumn()."</span></a> ";
}else{
echo "<a href='/user/video/file.php?id=".htmlspecialchars($post['id'])."'><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` WHERE `id_object` = '$post[id]' AND `type` = 'user_video' AND `like` = '1'"),0)->fetchColumn()."</span></a> ";    
}
}

$comm=$pdo->query(("SELECT COUNT(*) FROM `user_video_komm` WHERE `id_file`='$post[id]'"),0)->fetchColumn();
echo "<a href='/user/video/file.php?id=".htmlspecialchars($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>";

echo "<span style='float: right;'><a href='/user/video/file.php?id=".htmlspecialchars($post['id'])."'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Просмотры') . "'>";
echo "<i class='fa fa-eye fa-fw'></i> $post[k_loads]</span></a></span></div>";
}






	if ($k_page>1){
echo '<div class="list-group-item">';	    
echo str("?sort=$sort&amp;$por&amp;",$k_page,$page); // Вывод страниц
echo '</div>';
	}	 
	
include_once '../../sys/inc/tfoot.php';
}else{





// Поиск
if (isset ($_GET['go']) && $search_video!=NULL)
{

	$k_post = $pdo->query(("SELECT COUNT(*) FROM `user_video` WHERE `private_folder` = '0' AND `metka` = '0' AND `block_yes` = '0' AND (`name` like '%".htmlspecialchars(translit($search_video))."%' OR `name` like '%".htmlspecialchars(retranslit($search_video))."%' OR `name` like '%".htmlspecialchars($search_video)."%' OR `opis` = '".htmlspecialchars($search_video)."')"),0)->fetchColumn();
	$k_page = k_page($k_post,$set['p_str']);
	$page = page($k_page);
	$start = $set['p_str'] * $page - $set['p_str'];
	   
	    
echo "<div style='padding: 4px; background-color: white;'>";
		switch (@$_GET['sort']) 
		{    
			case 'rate':$sql_sort = '`k_loads`'; $sort = 'rate'; // баллы

echo "<table style='width: 100%; text-align: center;'><tr>
<td class='fn-lefti'><a style='display: block;padding: 10px;' href='index.php?sort=id&amp;DESC&amp;page=$page'><font color=#587C94><b>НОВЫЕ</b></font></a></td>

<td class='fn-centeri'><a style='display: block;padding: 10px;' href='index.php?sort=rate&amp;DESC&amp;page=$page'><b><font color=#587C94>ТОП</font></b></a></td>

<td class='fn-lefti-o'><a style='display: block;padding: 10px;' href='vse.php'><b><font color=#587C94>ВСЕ</font></b></a></td>
<td class='fn-righti'><a style='display: block;padding: 10px;' href='/modules/videos/'><font color=#587C94><b>YOUTUBE</b></font></a></td></tr></table>";


		 	break;
		 	default:$sql_sort = '`id`'; $sort = 'id'; // ID

echo "<table style='width: 100%; text-align: center;'><tr>
<td class='fn-lefti'><a style='display: block;padding: 10px;' href='index.php?sort=id&amp;DESC&amp;page=$page'><font color=#587C94><b>НОВЫЕ</b></font></a></td>

<td class='fn-centeri'><a style='display: block;padding: 10px;' href='index.php?sort=rate&amp;DESC&amp;page=$page'><b><font color=#587C94>ТОП</font></b></a></td>

<td class='fn-lefti-o'><a style='display: block;padding: 10px;' href='vse.php'><b><font color=#587C94>ВСЕ</font></b></a></td>
<td class='fn-righti'><a style='display: block;padding: 10px;' href='/modules/videos/'><font color=#587C94><b>YOUTUBE</b></font></a></td></tr></table>";

		 	break;
		}
		echo '</div>';
	}
	if ($k_post == 0)
	{
$doc->NoResult();
	}	
	$q = $pdo->query("SELECT * FROM `user_video` WHERE `private_folder` = '0' AND `metka` = '0' AND `block_yes` = '0' AND (`name` like '%".htmlspecialchars(translit($search_video))."%' OR `name` like '%".htmlspecialchars(retranslit($search_video))."%' OR `name` like '%".htmlspecialchars($search_video)."%' OR `opis` = '".htmlspecialchars($search_video)."') ORDER BY $sql_sort $por LIMIT $start, $set[p_str];");

	while ($post = $q->fetch(PDO::FETCH_ASSOC))
	{
$ras=htmlspecialchars($post['ras']);
$name=htmlspecialchars($post['name']);
$size=htmlspecialchars($post['size']);

if (IS_WEB == 1) {
echo "<div class='list-group-item'><a href='/user/video/file.php?id=".htmlspecialchars($post['id'])."'>";
echo "<span style='position: absolute; left: 30px; bottom: 108px;'><font color=white><i class='fa fa-play-circle-o fa-2x'></i></font></span><img src='".$df['name']."".$video77."screen/$post[id].jpg' style='width: 65px; height: 65px; border-radius: 2px;'/> ";
echo "<span style='position: absolute; left: 80px; bottom: 140px;'><font color=#367CB4><i class='fa fa-video-camera'></i></font> <font color=black><b>".substr(output_text($post['name']),0,45)."...</b>";
echo "</font></span>";
echo "<span style='border: 1px #AEB6BD solid; border-radius: 3px; color: #AEB6BD; float: right;'><small>".size_file(htmlspecialchars($size))."</small></span><br>";
echo "<span style='position: absolute; left: 80px; bottom: 115px;'> <font color=black>".substr(output_text($post['opis']),0,45)."...</font></a><br>";
}else{
echo "<div class='list-group-item'><a href='/user/video/file.php?id=".htmlspecialchars($post['id'])."'>";
echo "<span style='position: absolute; left: 30px; bottom: 108px;'><font color=white><i class='fa fa-play-circle-o fa-2x'></i></font></span><img src='".$df['name']."".$video77."screen/$post[id].jpg' style='width: 65px; height: 65px; border-radius: 2px;'/> ";
echo "<span style='position: absolute; left: 80px; bottom: 140px;'><font color=#367CB4><i class='fa fa-video-camera'></i></font> <font color=black><b>".substr(output_text($post['name']),0,18)."...</b>";
echo "</font></span> <span style='border: 1px #AEB6BD solid; border-radius: 3px; color: #AEB6BD; float: right;'><small>".size_file(htmlspecialchars($size))."</small></span><br>";
echo "<span style='position: absolute; left: 80px; bottom: 115px;'> <font color=black>".substr(output_text($post['opis']),0,25)."...</font></a><br>";
}

echo '<a href="'.$df['name'].''.$video77.''.$post['id'].'.'.$post['ras'].'" download="FaceFree.Ru_' . stripcslashes(htmlspecialchars($post['name'])) . '.mp4">
<span class="d_c"><font color=white><i class="fa fa-download"></i> Скачать</font></span></a><span class="d_c2"><font color="gray">'.size_file($post['size']).'</font></span><br><br>';


if (isset($user)){
if ($pdo->query(("SELECT COUNT(*) FROM `like_object` WHERE `id_object` = '$post[id]' AND `type` = 'user_video' AND `id_user` = '$user[id]' LIMIT 1"),0)->fetchColumn()==0){
echo "<a href='/user/video/file.php?id=".htmlspecialchars($post['id'])."&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` WHERE `id_object` = '$post[id]' AND `type` = 'user_video' AND `like` = '1'"),0)->fetchColumn()."</span></a> ";
}else{
echo "<a href='/user/video/file.php?id=".htmlspecialchars($post['id'])."'><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` WHERE `id_object` = '$post[id]' AND `type` = 'user_video' AND `like` = '1'"),0)->fetchColumn()."</span></a> ";    
}
}

$comm=$pdo->query(("SELECT COUNT(*) FROM `user_video_komm` WHERE `id_file`='$post[id]'"),0)->fetchColumn();
echo "<a href='/user/video/file.php?id=".htmlspecialchars($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>";

echo "<span style='float: right;'><a href='/user/video/file.php?id=".htmlspecialchars($post['id'])."'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Просмотры') . "'>";
echo "<i class='fa fa-eye fa-fw'></i> $post[k_loads]</span></a></span></div>";			
}
	if ($k_page > 1)str("?go&amp;sort=$sort&amp;$por&amp;",$k_page,$page); // Вывод страниц

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