Файл: backup/down/index.php
Строк: 84
<?php
require_once('../core/start.php');
func::is_auth();
$title = 'Загруз-Центер';
require_once(root.'core/header.php');
echo '<div class="wizart">'.$title.'</div>';
switch($do){
default:
if(isset($_GET['del'])){
if($level<2){
header('location:/');
exit;
}
$file = core::$dbs->query("SELECT * FROM `down` WHERE `id_r` = ",array($id));
while($arr = $file->fetch()){
unlink(root.'files/'.$arr['file']);
core::$dbs->query("DELETE FROM `down` WHERE `id_r` = ?",array($id));
}
core::$dbs->query("DELETE FROM `down_pr` WHERE `id_r` = ?",array($id));
core::$dbs->query("DELETE FROM `down_r` WHERE `id` = ?",array($id));
header('location:?');
}
$count = core::$dbs->querySingle("SELECT count(id) from `down_r`");
if($count==0){
func::error('Категорий нет!');}
$q = core::$dbs->query("SELECT * FROM `down_r` order by `id` ASC");
while($a = $q->fetch()){
$n = core::$dbs->querySingle("SELECT COUNT(id) from `down` WHERE `id_r` = ? and `time` > ? and `type` = ?",array($a['id'],time()-84600,1));
echo '<a class="l1" href="/down/pr/'.$a['id'].'"><img src="/down/ext/dir.gif" alt="*"/> '.$a['name'].' ('.core::$dbs->querySingle("SELECT COUNT(id) from `down` WHERE `id_r` = ? and `type` = ?",array($a['id'],1)).((!empty($n)) ? '<span style="color:#FF0000;">+'.$n.'</span>':NULL).') '.(!empty($a['value']) ? '<br/>'.$a['value'] : '').'</a>';
}
break;
case 'add':
if($level<2){
header('location:/');}
if(isset($_POST['ok'])){
$name = func::check($_POST['name']);
$value = func::check($_POST['value']);
if(empty($name)){
$err .='Введите название категории!';}
if(core::$dbs->querySingle("SELECT COUNT(id) from `down_r` where `name` = ?",array($name))==1){
$err .='Такая категория уже есть!';}
if(!isset($err)){
core::$dbs->query("INSERT INTO `down_r` SET `name` = ?, `value` = ?",array($name,$value));
header('location:?');
} else {
echo func::error($err);
}
}
echo '<form action="?do=add" method="post">Название:<br/><input type="text" name="name"/><br/>Описание:<br/><textarea name="about"></textarea><br/><input type="submit" name="ok" value="Сохранить"/></form>';
break;
case 'red':
if($level<2){
header('location:/');
}
$inf = core::$dbs->queryFetch("SELECT * FROM `down_r` WHERE `id` = ? LIMIT 1",array($id));
if(empty($inf['id'])){
header('location:/');
exit;
}
if(isset($_POST['ok'])){
$name = func::check($_POST['name']);
$value = func::check($_POST['value']);
if(empty($name)){
$err = 'Введите название!';
}
if(empty($err)){
core::$dbs->query("UPDATE `fo_r` SET `name` = ?, `value` = ? WHERE `id` = ? LIMIT 1",array($name,$value,$id));
header('location:?');
} else {
echo func::error($err);
}
}
echo '<form action="/down/red/'.$id.'" method="post">Название:<br/><input type="text" name="name" value="'.$inf['name'].'"/><br/>Описание:<br/><textarea name="value">'.$inf['value'].'</textarea><br/><input type="submit" name="ok" value="Сохранить"/></form>';
break;
}
if($level>=2){
echo '<a class="l1" href="?do=add">Новая категория</a>';}
func::footer_menu();
require_once(root.'core/footer.php');
?>