<?php

define("BASEDIR","../"); ini_set('error_reporting', 0); 

include 'moduls/fun.php';
include 'moduls/connect.php';
$set['title']='Загрузки';  $set['mesto']='Загрузки'; theme_head(); aut();
###############Проверка переменных###############

$prew   = get2ses('prew');
$sorts   = get2ses('sorts');
is_num($id,'id');
is_num($prew,'prew');
if(!isset($prew) or $prew != 0 and $prew != 1) $prew = $setup['preview'];
$valid_sorts = array('load' => '','eval' =>'');
if(!isset($valid_sorts[$sorts])) $sorts = 'load';
if($sorts == 'load') $MODE = '`loads` > 0 AND `size` > 0 ORDER BY `loads` DESC';
if($sorts == 'eval') $MODE = '`yes` > 0 AND `size` > 0 ORDER BY `yes` DESC';
###############Готовим заголовок###################
if ($sorts == 'load') $sortslink = '<a href="top.php?sorts=eval">рейтинг</a>';
if ($sorts == 'eval') $sortslink = '<a href="top.php?sorts=load">популярность</a>';
###############Вывод###############
echo '<div class="post_title"><img src="dis/in.png" alt=""/>ТОП '.$setup['top_num'].' файлов:<br/>Сортировка: '.$sortslink.'</div>';
###############Cтраницы###############
$all = mysql_result(mysql_query('SELECT COUNT(*) FROM `files` WHERE '.$MODE),0);
$k_page=k_page($all,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];

$query = mysql_query('SELECT * FROM `files` WHERE '.$MODE.' LIMIT '.$start.', '.$set['p_str']);

while($list_sw = mysql_fetch_array($query)) $array_id[] = $list_sw['id'];
$all = count($array_id);
###############Если их нет...###########
if($all == 0) echo 'Пока пусто :(';
###############Вывод списка#############
foreach($array_id as $key => $value)
{

	if(is_integer($n / 2)) $post_title = '<div class="post_title">'; else $post_title = '<div class="post">';
	$file_info = mysql_fetch_array(mysql_query('SELECT * FROM `files` WHERE `id` = '.$value));
	$backdir = @mysql_fetch_array(mysql_query("SELECT * FROM `files` WHERE `path` = '".clean($file_info['infolder'])."'"));
	$basename = basename($file_info['path']);
	$ex = pathinfo($file_info['path']);
	$ex = strtolower($ex['extension']);
	$name_file = str_replace('.'.$ex,'',$basename);
//Транслит
if(strpos($basename , '!') !== false){
$name_file = translit($name_file);
}
else{

}

//Красивый размер
if($file_info['size'] < 1024) $file_info['size'] = '('.$file_info['size'].'b)';
elseif($file_info['size'] < 1048576 and $file_info['size'] >= 1024) $file_info['size'] = '('.round($file_info['size']/1024, 2).'Kb)';
else $file_info['size'] = '('.round($file_info['size']/1024/1024, 2).'Mb)';

//Предосмотр
$pre='';

	

		if ($ext == 'gif' or $ext == 'jpeg' or $ext == 'jpe' or $ext == 'jpg' or $ext == 'png') $pre = "<img style='margin: 1px;' src='im.php?id=".$file_info['id']."' alt=\"\"/> <br/>";
	
	$new_info='';
    	if ($sorts=='load') $info = '[<font color="#FFFF00">'.$file_info[loads].'</font>]';
  		if ($sorts=='eval') $info = '[<font color="#800000">'.$file_info[yes].'</font>/<font color="#004080">'.$file_info[no].'</font>]';
	$filtime2 = $file_info['timeupload']+(3600*24*$setup['day_new']);
	if($filtime2>=$time) $new_info = '(New)';
	//Иконка к файлу
	if(!file_exists("ext/$ext.png")) $ico = '<img src="ext/stand.png" alt=""/>'; else $ico = '<img src="ext/'.$ext.'.png" alt=""/>';
	
	//Собсвенно вывод
  	echo $post_title.$pre.' '.$ico.'<a href="view.php?id='.$file_info['id'].'"><strong>'.$name_file.'</strong></a>'.$ex.$file_info['size'].$info.'[<a href="index.php?id='.$backdir['id'].'">В категорию</a>]<br/></div>';
	$n++;
}
//------------------------------------------------------------------------------------------
echo '</div>';
if ($k_page>1)str('?',$k_page,$page); // Вывод страниц

echo '<div class="post">- <a href="index.php">Загрузки</a><br/>
- <a href="'.$set[sait_adr].'?'.SID.'">На главную</a>';
navigation(); theme_foot();
?>