Просмотр файла download/index.php

<?php
/*
=============================================
Движок: SHCMS Engine
=============================================
Название файла: Обменник
=============================================
Official website: http://shcms.ru
=============================================
*/
define('SHCMS', true);
include_once'../system/inc/basic_settings.php';
 if(isset($_GET['act_dir']))
{$shcmsengine['title'] = 'Создание новой папки';}
else{$shcmsengine['title'] = 'Файловый обменник';}
include_once'../template/head.php';


        $allfield = mysql_result(mysql_query("SELECT COUNT(*) FROM `download_dir` WHERE `dir_index`='0'"),0);
        $newlist = new Navigation($allfield,10, true);
        $file_cat = mysql_query("SELECT * FROM `download_dir` WHERE `dir_index`='0' ". $newlist->limit()."");
        $dir_cats = mysql_fetch_array($file_cat);
    
	if($_GET['dir']){
	    $dir = $_GET['dir'];
	}
	
    if($dir == false) {
 if($user_id) {	
		echo '<div class="maintitle mainrazd">Поиск файлов:</div>
		<div class="maintext"><form action="search.php" method="post">';
		echo '<input type="text" name="search">';
		echo '<input type="submit" name="submit" value="Искать"></form>
		<small> * Файлы найти можно по названию</small></div>';
            }
        $new_files = mysql_result(mysql_query("SELECT COUNT(*) FROM `download_file` WHERE `time` > '".(time()-86400)."'"),0);
        echo '<div class="maintext"><a href="new.files.php">Новые поступление  ('.$new_files .')</a></div><hr/>';
    
	if($dir_cats == null)
    {
        echo '<div class="maintext">Файловый обменник пуст.</div>';
    }
    else
    {
        echo '<div class="maintitle mainrazd">Обменник файлов</div><div class="maintext">';
  do
  {
        echo '<div class="posts"> <img src="icons/dir.png"/>  <a href="?dir='.$dir_cats['id'].'">'.$dir_cats['name'].' </a>';
        echo '</div>';
  }
		
  while($dir_cats = mysql_fetch_array($file_cat));
        echo '</div>';
        echo '<div class="pages">';
        echo $newlist->pagination();
        echo '</div>';
    }
    if($user4['team'] == 6)
    {
	echo '<div class="maintitle mainrazd">Навигация</div>';
        echo '<div class="maintext"><div class="posts"><a href="new_dir.php">Создать папку</a></div>';
		echo '<div class="posts"><a href="edit.php">Настройка папок</a></div></div>';
    }
            }	

		/*
		@ $dir
		*/	
			
    if(isset($_GET['dir']))
    {
        $id = $dir;
        $yel_down = mysql_query("SELECT * FROM `download_dir` WHERE `dir_index`='$dir'");
	    $ok_down = mysql_fetch_array($yel_down);

            if($ok_down)
            {
 do {
        $result_count = mysql_result(mysql_query("SELECT COUNT(*) FROM `download_file` WHERE `id_dir` = '$ok_down[id]'"),0);

    if (mysql_result(mysql_query("SELECT COUNT(*) FROM `download_dir` WHERE `dir_path` LIKE '%$ok_down[dir_path]%' AND `id` != '$ok_down[id]'  AND `time` > '". (time()-3600*24*3) ."'"), 0) != 0) ;
	    echo '<div class="posts">
	         <img src="icons/dir.png"/> <a href="?dir='.$ok_down['id'].'">'.$ok_down['name'].'</a> 
			 <span class="count">'. $result_count.'</span></div>';
    }
  while ($ok_down = mysql_fetch_array($yel_down));
            }

        $files = mysql_fetch_array(mysql_query("SELECT * FROM `download_file` WHERE `id_dir`='$dir'"));
        $rt_d = mysql_result(mysql_query("SELECT COUNT(*) FROM  `download_dir` WHERE `dir_index` = '$dir'"), 0);
        $allfield1 = mysql_result(mysql_query("SELECT COUNT(*) FROM `download_file` WHERE `id_dir`='$dir'"),0);
        $newlist1 = new Navigation($allfield1,10,true);   	  
        $filew = mysql_query("SELECT * FROM `download_file` WHERE `id_dir`= '$dir' ORDER BY `id` DESC ". $newlist1->limit()."");
		
				
					$type_file = mysql_fetch_array(mysql_query("SELECT * FROM `download_dir` WHERE `id` = '$dir'"));
					if($type_file['type'] == 2) {	
        echo '<div class="maintitle mainrazd"><center>Раздел картинок</center></div><div class="maintext">';
					echo  'Всего картинок:&nbsp;'.mysql_result(mysql_query("SELECT COUNT(*) FROM `download_file` WHERE `type` = 'png' OR `type` = 'jpg' OR `type` = 'jpeg' OR `type` = 'gif'"),0).'<br/>';
					$new_photo = mysql_fetch_array(mysql_query("SELECT * FROM `download_file` WHERE `type` = 'png' OR `type` = 'jpg' OR `type` = 'jpeg' OR `type` = 'gif' ORDER BY `id` DESC LIMIT 1"));
					echo 'Последняя добавленная картинка:&nbsp; <a href="files.php?id='.$new_photo['id'].'">'.$new_photo['names'].'</a>';
					
					echo '</div>';
			}
			elseif($type_file['type'] == 3) {	
        echo '<div class="maintitle mainrazd"><center>Музыкальный раздел</center></div><div class="maintext">';
					echo  'Всего песен:&nbsp;'.mysql_result(mysql_query("SELECT COUNT(*) FROM `download_file` WHERE `type` = 'mp3'"),0).'<br/>';
					$new_music = mysql_fetch_array(mysql_query("SELECT * FROM `download_file` WHERE `type` = 'mp3' ORDER BY `id` DESC LIMIT 1"));
					echo 'Последняя добавленная песня:&nbsp; <a href="files.php?id='.$new_music['id'].'">'.$new_music['names'].'</a>';
					
					echo '</div>';
			}
			elseif($type_file['type'] == 4) {
        echo '<div class="maintitle mainrazd"><center>Видео раздел</center></div><div class="maintext">';
					echo  'Всего видео:&nbsp;'.mysql_result(mysql_query("SELECT COUNT(*) FROM `download_file` WHERE `type` = 'mp4' OR `type` = 'avi' OR `type` = '3gp' OR `type` = 'flv' OR `type` = 'mpg'"),0).'<br/>';
					$new_video = mysql_fetch_array(mysql_query("SELECT * FROM `download_file` WHERE `type` = 'mp4' OR `type` = 'avi' OR `type` = '3gp' OR `type` = 'flv' OR `type` = 'mpg' ORDER BY `id` DESC LIMIT 1"));
					if($new_video == false) {
					echo 'Последняя добавленная видео:&nbsp; Видео отсутствуют';							
					}else {
					echo 'Последняя добавленная видео:&nbsp; <a href="files.php?id='.$new_video['id'].'">'.$new_video['names'].'</a>';			
			    }
			echo '</div>';}
		elseif($type_file['type'] == 5) {	
        echo '<div class="maintitle mainrazd"><center>Архивный раздел</center></div><div class="maintext">';
					echo  'Всего картинок:&nbsp;'.mysql_result(mysql_query("SELECT COUNT(*) FROM `download_file` WHERE `type` = 'zip' OR `type` = 'rar' "),0).'<br/>';
					$new_arhive = mysql_fetch_array(mysql_query("SELECT * FROM `download_file` WHERE `type` = 'zip' OR `type` = 'rar' ORDER BY `id` DESC LIMIT 1"));
					echo 'Последний добавленный архив:&nbsp; <a href="files.php?id='.$new_arhive['id'].'">'.$new_arhive['names'].'</a>';
					
					echo '</div>';
			}
		
				if(mysql_num_rows($yel_down) == NULL and mysql_num_rows($filew)== NULL )
		{
		echo '<div class="maintext">';
		SHCMS_core::img_shcms('../template/icon/empty.png');
		echo 'В данной папки не найдено файлов</div>';
		}
		
        $file_while = mysql_fetch_array($filew);
            if($file_while != null)
            {
	echo '<div class="maintext">';
 do
 {
    files::files_icon($file_while['type']);
 }
  while($file_while = mysql_fetch_array($filew));
        echo '</div><div class="pages">';
        echo $newlist1->pagination('dir='.$id);
        echo '</div>';

            }
        if($user_id)
        {  
        $world =  mysql_fetch_array(mysql_query("SELECT * FROM `download_dir` WHERE `id`='$id'"));
		echo '<div class="maintitle mainrazd">Добавление</div><div class="maintext">';
   if($world['vib'] == 1 or $user4['team'] == 6)
   {
       echo '<div class="posts"><a href="upload.php?act=rules&dir='.$dir.'&'.$conservation.'">Выгрузить файл</a></div>';
   }
        }  
	if($user4['team'] == 6){
        echo '<div class="posts"><a href="new_dir.php?dir='.$dir.'&act_dir&'.$conservation.'">Создать папку</a></div>';
    } 
	if($user_id)
	{
	echo '</div>';
	}

    }
include_once'../template/foot.php';
?>