Файл: audio/index.php
Строк: 227
<?
include_once '../sys/inc/start.php';
include_once '../sys/inc/compress.php';
include_once '../sys/inc/sess.php';
include_once '../sys/inc/home.php';
include_once '../sys/inc/settings.php';
include_once '../sys/inc/db_connect.php';
include_once '../sys/inc/ipua.php';
include_once '../sys/inc/fnc.php';
include_once '../sys/inc/user.php';
include_once 'config.php';
if (isset($_GET['act'])) {$act = power($_GET['act']);} else {$act = 'index';}
switch ($act):
########################### Главная страница ##########################
case "index":
$set['title']='Музыка [На] Fant1k.Ru';
include_once '../sys/inc/thead.php';
title();
aut();
$set['p_str']=20;
$k_post =mysql_result(mysql_query("SELECT count(*) FROM `audio_cat`"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
echo "<table class='post'>n";
if ($k_post==0)
{
echo " <tr>n";
echo " <td class='p_t'>n";
echo "Категорий не создано!n";
echo " </td>n";
echo " </tr>n";
}
$q=mysql_query("SELECT * FROM `audio_cat` ORDER BY `num` DESC LIMIT " . $start . ", " . $set['p_str'] . "");
while ($data = mysql_fetch_assoc($q)){
echo " <td class='icon14'>n";
echo "<img src='/images/mp3.gif'>n";
echo " </td>n";
echo " <td class='p_t'>n";
$k_p=mysql_result(mysql_query("SELECT COUNT(*) FROM `audio_file` WHERE `id_cat` = '$data[id]'"),0);
$k_n=mysql_result(mysql_query("SELECT COUNT(*) FROM `audio_file` WHERE `id_cat` = '$data[id]' AND `time` > '".(time()-86400)."'"),0);
if ($k_n==0)$k_n=NULL;
else $k_n='+'.$k_n;
$count =mysql_result(mysql_query("SELECT count(*) FROM `audio_file` WHERE `id_cat`='".$data['id']."'"),0);
echo "<a href='index.php?act=cat&id=$data[id]'>$data[name]</a> ($k_p)$k_n<br/>n";
echo " </td>n";
echo " </tr>n";
}
echo "</table>n";
/*
### Управление разделами
if (user_access('audio_move_dir') || user_access('audio_add_dir')){
echo'<div class="str">';
echo'Управление:';
echo'</div>';
echo'<div class="mess">';
if(user_access('audio_move_dir')){echo'<a href="admin.php?act=index">Управление разделами</a><br/>';}
if(user_access('audio_add_dir')){echo'<a href="admin.php?act=dir_add">Создать папку</a><br/>';}
echo'</div>';
}
*/
break;
########################### Мои файлы #########################
case "my":
$id = intval($_GET['id']);
$ank=get_user($id);
$set['title']='Музыка '.$ank['nick'].''; // заголовок страницы
include_once '../sys/inc/thead.php';
title();
aut();
$k_post =mysql_result(mysql_query("SELECT count(*) FROM `audio_file` WHERE `id_user`='".$id."'"),0);
$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){echo "<div class='f1'></div>";}
echo "<table class='post'>n";
if ($k_post==0)
{
echo " <tr>n";
echo " <td class='p_t'>n";
echo "Файлов нет!n";
echo " </td>n";
echo " </tr>n";
}
$q=mysql_query("SELECT * FROM `audio_file` WHERE `id_user`='".$id."' ORDER BY `time` DESC LIMIT " . $start . ", " . $set['p_str'] . "");
while ($file = mysql_fetch_assoc($q)){
echo " <td class='icon14'>n";
echo "<img src='/images/mp3.gif'>n";
echo " </td>n";
echo " <td class='p_t'>n";
echo "<a href='index.php?act=audio&id=$file[id]'>$file[artist] - $file[title]</a>n";
echo "[$file[dlit]] (".size($file['size']).")n";
echo " </td>n";
echo " </tr>n";
}
echo "</table>n";
if ($k_page>1)str('?act=my&id='.$id.'&',$k_page,$page); // Вывод страниц
break;
########################### Раздел ########################
case "cat":
$id = intval($_GET['id']);
$sort = (isset($_GET['sort'])) ? $_GET['sort'] : 'time';
if(mysql_result(mysql_query("SELECT count(*) FROM `audio_cat` WHERE `id`='".$id."'"),0)==0){header("Location: /audio/");}### Проверили есть ли каталог
$catalog=mysql_fetch_assoc(mysql_query("SELECT * FROM `audio_cat` WHERE `id`= $id LIMIT 1"));
$set['title']="Музыка из раздела "$catalog[name]""; // заголовок страницы
include_once '../sys/inc/thead.php';
title();
aut();
$k_post =mysql_result(mysql_query("SELECT count(*) FROM `audio_file` WHERE `id_cat`='".$id."'"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
echo "<table class='post'>n";
if ($k_post==0)
{
echo " <tr>n";
echo " <td class='p_t'>n";
echo "Файлов не добавлено!n";
echo " </td>n";
echo " </tr>n";
}
$q=mysql_query("SELECT * FROM `audio_file` WHERE `id_cat`='".$id."' ORDER BY `time` DESC LIMIT " . $start . ", " . $set['p_str'] . "");
while ($file = mysql_fetch_assoc($q)){
echo " <td class='icon14'>n";
echo "<img src='/images/mp3.gif'>n";
echo " </td>n";
echo " <td class='p_t'>n";
echo "<a href='index.php?act=audio&id=$file[id]'>$file[artist] - $file[title]</a>n";
echo "[$file[dlit]] (".size($file['size']).")n";
echo " </td>n";
echo " </tr>n";
}
echo "</table>n";
echo "<div class='f2'><img src='/images/icon_add_file.png'> <a href='upload.php?dir=$id'>Добавить музыку</a></div>n";
if ($k_page>1)str('?act=cat&id='.$id.'&',$k_page,$page); // Вывод страниц
break;
########################### Аудио ########################
case "audio":
$id = intval($_GET['id']);
if(mysql_result(mysql_query("SELECT count(*) FROM `audio_file` WHERE `id`='".$id."'"),0)==0){header("Location: /audio/");}
$audio=mysql_fetch_assoc(mysql_query("SELECT * FROM `audio_file` WHERE `id`= $id LIMIT 1"));
$set['title']=""$audio[artist] - $audio[title]" скачать"; // заголовок страницы
include_once '../sys/inc/thead.php';
title();
aut();
$artist = (isset($audio['artist']) && $audio['artist']>NULL) ? $audio['artist'] : 'Неизвестный';
$title = (isset($audio['title']) && $audio['title']>NULL) ? $audio['title'] : 'Неизвестно';
$albom = (isset($audio['albom']) && $audio['albom']>NULL) ? '<b>Альбом</b>: '.$audio['albom'].'<br/>' : '';
$year = (isset($audio['year']) && $audio['year']>NULL) ? '<b>Год</b>: '.$audio['year'].'<br/>' : '';
echo "<div class='f1'>n";
echo '<b>Исполнитель</b>: '.$artist.'<br/>';
echo '<b>Название</b>: '.$title.'<br/>';
echo $albom;
echo $year;
echo "</div>n";
echo "<div class='f2'>n";
echo'<object type="application/x-shockwave-flash" data="player_mp3_maxi.swf" width="240" height="20">
<param name="FlashVars" value="mp3=files/'.$id.'.mp3&width=240&volume=100&volume=50&showvolume=1&buttonwidth=20&sliderheight=8&volumewidth=50&volumeheight=8&loadingcolor=c2c2c2&bgcolor1=919191&bgcolor2=1a1a1a&slidercolor1=c2c2c2&slidercolor2=919191&sliderovercolor=ffffff&buttoncolor=c2c2c2&buttonovercolor=ffffff" />
</object><br/>';
echo "</div>n";
echo "<div class='f1'>n";
echo '<b>Длительность</b>: '.$audio['dlit'].'<br />';
echo '<b>Каналы</b>: '.$audio['kanal'].'<br/>';
echo '<b>Частота</b>: '.$audio['chastota'].'<br/>';
$ank = get_user($audio['id_user']);
$ank=mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = $audio[id_user] LIMIT 1"));
echo "<b>Добавил</b>: <a href='/info.php?id=$ank[id]'>$ank[nick]</a><br />n";
echo "<b>Дата</b>: ".vremja($audio['time'])."<br/>";
echo '<img src = "img/save.gif"> <a href="?act=load&id='.$audio['id'].'">Скачать MP3 ('.size($audio['size']).'; '.$audio['bitreit'].')</a><br/>';
echo "</div>n";
### Управление разделами
if(user_access('audio_edit_file') || user_access('audio_del_file') || $user['id']==$audio['id_user']){
echo "<div class='f2'>n";
echo "<b><u>Управление</b></u>:<br />n";
if(user_access('audio_edit_file') || $user['id']==$audio['id_user']){
echo "* <a href='index.php?act=edit&id=$audio[id]'>Редактирование тегов</a><br />n";
}
if(user_access('audio_del_file') || $user['id']==$audio['id_user']){
echo "* <a href='index.php?act=del&id=$audio[id]'>Удаление композиции</a><br/>n";
}
//echo "* <a href='admin.php?act=dir_add'>Создать папку</a><br/>n";
echo "</div>n";
}
break;
### Скачать трекккк
case "load":
include_once 'downloadfile.php';
$id = intval($_GET['id']);
$audio=mysql_fetch_assoc(mysql_query("SELECT * FROM `audio_file` WHERE `id`= $id LIMIT 1"));
$name= $audio['artist'].' - '.$audio['title'];
$ras='mp3';
$rass='Addtype audio/mp3';
$size=$audio['size'];
mysql_query("UPDATE `audio_file` SET `load`= `load`+1 WHERE `id` = '$id' LIMIT 1");
DownloadFile(H.'audio/files/'.$audio['id'].'.mp3', $name.'.'.$ras, ras_to_mime($ras));
exit;
break;
### Редактирование
case "edit":
$id = intval($_GET['id']);
if(mysql_result(mysql_query("SELECT count(*) FROM `audio_file` WHERE `id`='".$id."'"),0)==0){header("Location: /audio/");}### Проверили есть ли каталог
$audio=mysql_fetch_assoc(mysql_query("SELECT * FROM `audio_file` WHERE `id`= $id LIMIT 1"));
if($user['id']==$audio['id_user'] || user_access('audio_edit_file')){
$set['title']='Редактирование '.$audio['artist'].' - '.$audio['title'].''; // заголовок страницы
include_once '../sys/inc/thead.php';
title();
aut();
echo "<div class='f1'>n";
echo "<form method='post' enctype='multipart/form-data' action='?act=edit_save&id=".$_GET['id']."' >";
echo "Исполнитель:<br />";
echo "<input type='text' name='artist' value='$audio[artist]'><br />n";
echo "Название:<br />n";
echo "<input type='text' name='title' value='$audio[title]'><br />n";
echo "Альбом:<br />n";
echo "<input type='text' name='albom' value='$audio[albom]'><br />n";
echo "<input class='submit' type='submit' value='Редактировать' /><br />n";
echo "</form>";
echo "</div>n";
}else{header("location: /audio/index.php?");}
break;
################################################################################
case "edit_save":
$id = intval($_GET['id']);
$artist=my_esc($_POST['artist']);
$title=my_esc($_POST['title']);
$albom=my_esc($_POST['albom']);
if(mysql_result(mysql_query("SELECT count(*) FROM `audio_file` WHERE `id`='".$id."'"),0)==0){header("Location: /audio/");}### Проверили есть ли каталог
$audio=mysql_fetch_assoc(mysql_query("SELECT * FROM `audio_file` WHERE `id`= $id LIMIT 1"));
if($user['id']==$audio['id_user'] || user_access('audio_edit_file')){
if (utf_strlen($artist) < 300 || utf_strlen($title) < 300 || utf_strlen($albom) < 300){
mysql_query("UPDATE `audio_file` SET `artist`='$artist', `title`='$title', `albom`='$albom' WHERE `id` = '$id' LIMIT 1");
header("Location: index.php?act=audio&id=$id");
}else{header("Location: index.php?act=audio&id=$id&error=64");}
}else{header("Location: index.php?act=audio&id=$id");}
break;
################################################################################
case "del":
$id = intval($_GET['id']);
if(mysql_result(mysql_query("SELECT count(*) FROM `audio_file` WHERE `id`='".$id."'"),0)==0){header("Location: /audio/");}### Проверили есть ли каталог
$audio=mysql_fetch_assoc(mysql_query("SELECT * FROM `audio_file` WHERE `id`= $id LIMIT 1"));
if($user['id']==$audio['id_user'] || user_access('audio_del_file')){
$set['title']='Удаление '.$audio['artist'].' - '.$audio['title'].''; // заголовок страницы
include_once '../sys/inc/thead.php';
title();
aut();
if(isset($_GET['ok'])){
unlink(H.'audio/files/'.$id.'.mp3');
mysql_query("DELETE FROM `audio_file` WHERE `id` = '$id'");
header("Location: index.php");}
echo "<div class='f1'>n";
echo "Удаление композиции "$audio[title]"<br />n";
echo "<form method='post' action='?act=del&id=".$id."&ok' >";
echo "<input class='submit' type='submit' value='Удалить' /> / <a href='index.php?act=audio&id=$id'>Отмена</a><br/>";
echo "</div>n";
}else{header("Location: index.php?act=audio&id=$id");}
break;
################################################################################
default:
header("location: index.php?");
endswitch;
include_once '../sys/inc/tfoot.php';
?>