View file ä󿪫¬/modules/groups/file/dir.php

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


### Проверка существует ли папка
if (isset($_GET['id']))$id=intval($_GET['id']);
$id_dir=intval($_GET['dir']);

if(isset($_GET['id']) && $pdo->query(("SELECT COUNT(*) FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"),0)->fetchColumn()==1)
{
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
include_once '../../../modules/groups/inc/ban.php';
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$dir = $pdo->query("SELECT * FROM `soo_dir` WHERE `id` = '$id_dir' AND `id_soo` = '$soo[id]' LIMIT 1")->fetch(PDO::FETCH_ASSOC);

if(isset($_GET['dir']) && $pdo->query(("SELECT COUNT(*) FROM `soo_dir` WHERE `id` = '".intval($_GET['dir'])."' AND `id_soo`='$soo[id]' LIMIT 1"),0)->fetchColumn()==1)
{
$id = intval($_GET['dir']);    
}else{
$set['title']='Ошибка 404'; // заголовок страницы
include_once '../../../sys/inc/thead.php';    
    
err404(); 
include_once '../../../sys/inc/tfoot.php';

exit();
}




$set['title']='Файлы группы'; // заголовок страницы
include_once '../../../sys/inc/thead.php';




$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
if($pdo->query(("SELECT COUNT(*) FROM `soo_bl` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' LIMIT 1"),0)->fetchColumn()!=0)
{
$set['title']='Файл'; // заголовок страницы
include_once '../../../sys/inc/thead.php';

echo '<div class="list-group-item">'; 
echo '<div class="err">Вы добавлены в черный список группы и не можете просмотреть данный объект</div>';
echo '</div>'; 
}else{








$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);








#Навигация
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/groups/group.php?id=$soo[id]'>$soo[name]</a> <i class='fa fa-angle-right fa-fw'></i> <a href='/modules/groups/file/index.php?id=$soo[id]'>";
echo lang('Файлы группы');
echo "</a> <i class='fa fa-angle-right fa-fw'></i> $dir[name] </div>";

if($soo['private_file']==1 && $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' LIMIT 1"),0)->fetchColumn()==0 && $user['id']!=$soo['admid'])
{
   
echo '<div class="list-group-item">';   
echo '<center><img src="/style/info/12.png" style="width: 120px; height: 120px;"><br><br><b>Просматривать файлы группы могут только её участники</b></center>';
echo '</div>'; 
}else{


echo "<div class='list-group-item'>"; 
 
if($soo['private_fileadd']==0){
$fileadd = $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' LIMIT 1"),0)->fetchColumn()==0 && $user['id']!=$soo['admid'];
}elseif($soo['private_fileadd']==1){
$fileadd = $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' AND `mod` = '1' LIMIT 1"),0)->fetchColumn()==0 && $user['id']!=$soo['admid'];
}elseif($soo['private_fileadd']==2){
$fileadd = $pdo->query(("SELECT COUNT(*) FROM `soo` WHERE `id` = '$soo[id]' AND `admid` = '$user[id]' LIMIT 1"),0)->fetchColumn()==0 && $user['id']!=$soo['admid'];
}
if($soo['private_fileadd']==$soo['private_fileadd'] && $fileadd)
{}else{ 
echo'<a style="margin-top: 2px;" class="btn btn-primary btn-sm" href="upload.php?id='.$soo['id'].'&dir='.$id_dir.'"><i class="fa fa-upload fa-fw"></i> Загрузить файл</a> ';
}

if($soo['private_fileadd']==0){
$fileadd = $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' AND `mod` = '1' LIMIT 1"),0)->fetchColumn()==0 && $user['id']!=$soo['admid'];
}elseif($soo['private_fileadd']==1){
$fileadd = $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' AND `mod` = '1' LIMIT 1"),0)->fetchColumn()==0 && $user['id']!=$soo['admid'];
}elseif($soo['private_fileadd']==2){
$fileadd = $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' AND `mod` = '1' LIMIT 1"),0)->fetchColumn()==0 && $user['id']!=$soo['admid'];
}
if($soo['private_fileadd']==$soo['private_fileadd'] && $fileadd)
{}else{ 
echo'<a style="margin-top: 2px;" class="btn btn-secondary btn-sm" href="edit.php?id='.$soo['id'].'&amp;dir='.$id_dir.'&amp;act=rename"><i class="fa fa-edit fa-fw"></i> Переименовать</a> ';
echo'<a style="margin-top: 2px;" class="btn btn-secondary btn-sm" href="edit.php?id='.$soo['id'].'&amp;dir='.$id_dir.'&amp;act=delete"><i class="fa fa-trash fa-fw"></i> Удалить</a> ';
}
echo "</div>";

$k_post = $pdo->query(("SELECT COUNT(*) FROM `soo_files` WHERE `id_soo` = '$soo[id]' AND `dir` = '$id_dir'"),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();
}

$q=$pdo->query("SELECT * FROM `soo_files` WHERE `dir` = '$id_dir' AND `id_soo` = '$soo[id]' ORDER BY `time` DESC LIMIT $start, $set[p_str]");
while ($post = $q->fetch(PDO::FETCH_ASSOC))
{
$ras=htmlspecialchars($post['ras']);
$name=htmlspecialchars($post['name']);
$size=htmlspecialchars($post['size']); 


    
    
//////////////////////////////////////

echo "<div class='list-group-item'><a href='file.php?id=$soo[id]&dir=$id_dir&id_file=".htmlspecialchars($post['id'])."'>";

/////////файлы///////////
if($post['ras']=='zip' || $post['ras']=='wmv' || $post['ras']=='rar' || $post['ras']=='tar' || $post['ras']=='amr' || $post['ras']=='txt' || $post['ras']=='thm' || $post['ras']=='sdt' || $post['ras']=='nth'
 || $post['ras']=='mtf' || $post['ras']=='bmp' || $post['ras']=='wbmp' || $post['ras']=='pic' || $post['ras']=='ani' || $post['ras']=='pco' || $post['ras']=='mmf' || $post['ras']=='apk' || $post['ras']=='jar'
  || $post['ras']=='jad' || $post['ras']=='docx' || $post['ras']=='doc' || $post['ras']=='sis'){

echo "<span style='position: absolute;'><font color=#4CAF50><i class='fa fa-file fa-fw'></i></font> ";

if (IS_WEB == 1) {
echo "<font color=black><b>".substr(text($post['name']),0,45).".$post[ras]</b>";
if ($post['metka'] == 1)echo ' <span style="border: 1px #AEB6BD solid; border-radius: 3px; color: red;"><small><b>18+</b></small></span> ';
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 "<font color=black>".htmlspecialchars(substr(text($post['opis']),0,45))."...</font></a>";
}else{
echo "<font color=black><b>".substr(text($post['name']),0,18).".$post[ras]</b>";
if ($post['metka'] == 1)echo ' <span style="border: 1px #AEB6BD solid; border-radius: 3px; color: red;"><small><b>18+</b></small></span> ';
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 "<font color=black>".htmlspecialchars(substr(text($post['opis']),0,25))."...</font></a>";
}      
}

////////Музыка///////////
if($post['ras']=='mp3' || $post['ras']=='wav' || $post['ras']=='aac'){

echo "<span style='position: absolute;'><font color=#4CAF50><font color=#E66A44><i class='fa fa-music fa-fw'></i></font> ";

if (IS_WEB == 1) {
echo "<font color=black><b>".substr(text($post['name']),0,45).".$post[ras]</b>";
if ($post['metka'] == 1)echo ' <span style="border: 1px #AEB6BD solid; border-radius: 3px; color: red;"><small><b>18+</b></small></span> ';
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 "<font color=black>".htmlspecialchars(substr(text($post['opis']),0,45))."...</font></a>";
}else{
echo "<font color=black><b>".substr(text($post['name']),0,18).".$post[ras]</b>";
if ($post['metka'] == 1)echo ' <span style="border: 1px #AEB6BD solid; border-radius: 3px; color: red;"><small><b>18+</b></small></span> ';
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 "<font color=black>".htmlspecialchars(substr(text($post['opis']),0,25))."...</font></a>";
}

echo '<br><audio src="'.$df['name'].''.$group_files77.''.$post['id'].'.'.$post['ras'].'"  width="98%" controls /></audio>';

}

////////видео///////////
if($post['ras']=='mp4' || $post['ras']=='3gp' || $post['ras']=='flv' || $post['ras']=='avi'){


echo "<font color=#367CB4><i class='fa fa-video-camera'></i></font> <font color=black><b>".htmlspecialchars(substr(text($post['name']),0,18)).".$post[ras]</b>";
if ($post['metka'] == 1)echo ' <span style="border: 1px #AEB6BD solid; border-radius: 3px; color: red;"><small><b>18+</b></small></span> ';
echo "<span style='border: 1px #AEB6BD solid; border-radius: 3px; color: #AEB6BD; float: right;'><small>".size_file(htmlspecialchars($size))."</small></span><br>";
echo "<font color=black>".htmlspecialchars(substr(text($post['opis']),0,25))."...</font></a>";


}


////////картинки////////////

if($post['ras']=='jpeg' || $post['ras']=='jpg' || $post['ras']=='png'){
    
if (IS_WEB == 1) {

echo "<img src='".$df['name']."".$group_files77."$post[id].$post[ras]' style='width: 65px; height: 65px; border-radius: 2px;'/> ";
echo "<span style='position: absolute; left: 80px; bottom: 160px;'><font color=#15A2AF><i class='fa fa-image fa-fw'></i></font> <font color=black><b>".htmlspecialchars(substr(text($post['name']),0,45)).".$post[ras]</b>";
if ($post['metka'] == 1)echo ' <span style="border: 1px #AEB6BD solid; border-radius: 3px; color: red;"><small><b>18+</b></small></span> ';
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: 130px;'> <font color=black>".htmlspecialchars(substr(text($post['opis']),0,45))."...</font></a>";
}else{
echo "<img src='".$df['name']."".$group_files77."$post[id].$post[ras]' style='width: 65px; height: 65px; border-radius: 2px;'/> ";
echo "<span style='position: absolute; left: 80px; bottom: 160px;'><font color=#15A2AF><i class='fa fa-image fa-fw'></i></font> <font color=black><b>".htmlspecialchars(substr(text($post['name']),0,18)).".$post[ras]</b>";
if ($post['metka'] == 1)echo ' <span style="border: 1px #AEB6BD solid; border-radius: 3px; color: red;"><small><b>18+</b></small></span> ';
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: 130px;'> <font color=black>".htmlspecialchars(substr(text($post['opis']),0,25))."...</font></a>";
}    

}



////////анимации////////////

if($post['ras']=='gif'){
    
if (IS_WEB == 1) {
echo "<img src='".$df['name']."".$group_files77."$post[id].$post[ras]' style='width: 65px; height: 65px; border-radius: 2px;'/> ";
echo "<span style='position: absolute; left: 80px; bottom: 160px;'><font color=#B3A31F><i class='fa fa-file-image-o fa-fw'></i></font> <font color=black><b>".htmlspecialchars(substr(text($post['name']),0,45)).".$post[ras]</b>";
if ($post['metka'] == 1)echo ' <span style="border: 1px #AEB6BD solid; border-radius: 3px; color: red;"><small><b>18+</b></small></span> ';
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: 130px;'> <font color=black>".htmlspecialchars(substr(text($post['opis']),0,45))."...</font></a>";
}else{
echo "<img src='".$df['name']."".$group_files77."$post[id].$post[ras]' style='width: 65px; height: 65px; border-radius: 2px;'/> ";
echo "<span style='position: absolute; left: 80px; bottom: 160px;'><font color=#B3A31F><i class='fa fa-file-image-o fa-fw'></i></font> <font color=black><b>".htmlspecialchars(substr(text($post['name']),0,18)).".$post[ras]</b>";
if ($post['metka'] == 1)echo ' <span style="border: 1px #AEB6BD solid; border-radius: 3px; color: red;"><small><b>18+</b></small></span> ';
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: 130px;'> <font color=black>".htmlspecialchars(substr(text($post['opis']),0,25))."...</font></a>";
}    

}




?>
<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 "<br><br><a href='/files/groups/files/".$post['id'].".".$post['ras']."' download=''><span class='d_c'><font color=white><i class='fa fa-download'></i> Скачать</font></span></a>";
echo '<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_objectf` WHERE `id_object` = '$post[id]' AND `type` = 'soo_files' AND `id_user` = '$user[id]' LIMIT 1"),0)->fetchColumn()==0){
echo "<a href='file.php?id=$soo[id]&dir=$id_dir&id_file=".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_objectf` WHERE `id_object` = '$post[id]' AND `type` = 'soo_files' AND `like` = '1'"),0)->fetchColumn()."</span></a> ";
}else{
echo "<a href='file.php?id=$soo[id]&dir=$id_dir&id_file=".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_objectf` WHERE `id_object` = '$post[id]' AND `type` = 'soo_files' AND `like` = '1'"),0)->fetchColumn()."</span></a> ";    
}
}

$comm=$pdo->query(("SELECT COUNT(*) FROM `soo_files_komm` WHERE `id_file`='$post[id]'"),0)->fetchColumn();
echo "<a href='file.php?id=$soo[id]&dir=$id_dir&id_file=".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='file.php?id=$soo[id]&dir=$id_dir&id_file=".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'>";
    str("?id=$soo[id]&dir=$id_dir&", $k_page, $page);
    echo "</div>";
}

}

}



}
else
{
$set['title']='Ошибка 404'; // заголовок страницы
include_once '../../../sys/inc/thead.php';    
    
err404(); 
}







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