<?
/* 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'].'&dir='.$id_dir.'&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'].'&dir='.$id_dir.'&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';
?>