<?
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();
#Навигация
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/music/'>Музыка</a> <i class='fa fa-angle-right fa-fw'></i> все";
echo "</div>";
$k_post = $pdo->query(("SELECT COUNT(*) FROM `user_music` WHERE `ras` = 'mp3'"),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();
}
$m1 = $pdo->query(("SELECT COUNT(*) FROM `user_music`"),0)->fetchColumn();
$m2 = $pdo->query(("SELECT COUNT(*) FROM `obmennik_files` WHERE `ras` = 'mp3'"),0)->fetchColumn();
$music = $m2 + $m1;
echo "<div class='list-group-item'><b>Всего песен: $music</b>";
echo '</div>';
$q = $pdo->query("SELECT * FROM `user_music` WHERE `ras` = 'mp3' ORDER BY `time` DESC LIMIT $start, $set[p_str];");
while ($post = $q->fetch(PDO::FETCH_ASSOC))
{
$ras = htmlspecialchars($post['ras']);
$file = H."sys/obmen/files/$post[id].dat";
$name = htmlspecialchars($post['name']);
$size = htmlspecialchars($post['size']);
echo '<div class="list-group-item">';
echo '<table style="cellspacing="0" cellpadding="0" width="100%"><tr>';
if (IS_WEB == 1) {
echo '<td style="width: 15%;">';
}else{
echo '<td style="width: 25%;">';
}
// Cкриншот
if (is_file(H."sys/obmen/screens/128/$post[id].gif"))
{
echo '<img src="/sys/obmen/screens/128/' . $post['id'] . '.gif" alt="Скрин..." style = "-moz-box-shadow: 0 0 10px rgba(0,0,0,0.5);-webkit-box-shadow: 0 0 10px rgba(0,0,0,0.5);box-shadow: 0 0 10px rgba(0,0,0,0.5);border: 1px solid #CCDDED; padding: 2px; border-radius: 5px; width: 70px; height: 70px; "/>';
}else{
echo '<img src="/site/files/music.png" style = "-moz-box-shadow: 0 0 10px rgba(0,0,0,0.5);-webkit-box-shadow: 0 0 10px rgba(0,0,0,0.5);box-shadow: 0 0 10px rgba(0,0,0,0.5);border: 1px solid #CCDDED; padding: 2px; border-radius: 5px; width: 70px; height: 70px; ">';
}
echo '</td>';
if (IS_WEB == 1) {
echo '<td style="width: 85%;">';
echo ' <span style="position: relative; bottom: 15px; left: 0px;"><font color=#E66A44><i class="fa fa-music"></i></font> <a href="/user/music/file.php?id='.$post['id'].'"><b><font color=black>' . substr(stripcslashes(htmlspecialchars($post['name'])),0,45) . '....mp3</b></font></a></span></br>';
// Описание
if ($post['opis'] != NULL)
{
echo ' <span style="position: relative;top: 0px;">';
echo substr(output_text($post['opis']),0,50);
echo '... </span></br>';
}else{
echo ' <span style="position: relative;top: 0px;">';
echo 'Без описания';
echo ' </span></br>';
}
}else{
echo '<td style="width: 75%;">';
echo ' <span style="position: relative; bottom: 15px; left: 0px;"><font color=#E66A44><i class="fa fa-music"></i></font> <a href="/user/music/file.php?id='.$post['id'].'"><font color=black><b>' . substr(stripcslashes(htmlspecialchars($post['name'])),0,23) . '....mp3</b></font></a></span></br>';
// Описание
if ($post['opis'] != NULL)
{
echo ' <span style="position: relative;top: 0px;">';
echo substr(output_text($post['opis']),0,30);
echo '... </span></br>';
}else{
echo ' <span style="position: relative;top: 0px;">';
echo 'Без описания';
echo ' </span></br>';
}
}
echo '</td>';
echo '</tr></table>';
echo '<br><audio style="border: 1px solid #CCDDED; padding: 1px; border-radius: 3px; width: 100%;" src="'.$df['name'].''.$music77.''.$post['id'].'.mp3" controls /></audio>';
?><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 load="none" href="'.$df['name'].''.$music77.''.$post['id'].'.'.$post['ras'].'" download="FaceFree.Ru_' . stripcslashes(htmlspecialchars($post['name'])) . '.mp3">
<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>';
echo '<br /><br />';
if (isset($user)){
if ($pdo->query(("SELECT COUNT(*) FROM `like_objectm` WHERE `id_object` = '$post[id]' AND `type` = 'user_music' AND `id_user` = '$user[id]' LIMIT 1"),0)->fetchColumn()==0){
$like=$pdo->query(("SELECT COUNT(*) FROM `like_objectm` WHERE `id_object`='$post[id]'"),0)->fetchColumn();
echo "<a href='/user/music/file.php?id=".$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> $like</span></a> ";
}else{
$like=$pdo->query(("SELECT COUNT(*) FROM `like_objectm` WHERE `id_object`='$post[id]'"),0)->fetchColumn();
echo "<a href='/user/music/file.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> ";
}
}
$comm=$pdo->query(("SELECT COUNT(*) FROM `user_music_komm` WHERE `id_file`='$post[id]'"),0)->fetchColumn();
echo "<a href='/user/music/file.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>";
echo "<span style='float: right;'><a href='/user/music/file.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> $post[k_loads]</span></a></span>";
echo '</div>';
}
if ($k_page>1){
echo '<div class="list-group-item">';
echo str("?",$k_page,$page); // Вывод страниц
echo '</div>';
}
include_once '../../sys/inc/tfoot.php';
?>