Файл: download/top.php
Строк: 93
<?php
/**
* @package JohnCMS
* @link http://johncms.com
* @copyright Copyright (C) 2008-2011 JohnCMS Community
* @license LICENSE.txt (see attached file)
* @version VERSION.txt (see attached file)
* @author http://johncms.com/about
*
* @var $lng_dl
*/
define('_IN_JOHNCMS', 1);
$headmod = 'loadtop';
require_once '../incfiles/core.php';
require_once 'functions.php';
$textl = $lng_dl['downloads'].' / '.$lng_dl['top_files'];
$cat = intval($_GET['cat']);
$sort = isset($_GET['sort']) ? $_GET['sort'] : '';
require_once '../incfiles/head.php';
echo'<div class="phdr">'.$lng_dl['top_files'].'</div>';
$cat_inf = db::query("SELECT * FROM `downpath` WHERE `id` = '" . $cat . "' LIMIT 1");
if(mysqli_num_rows($cat_inf)){
$cat_inf = mysqli_fetch_assoc($cat_inf);
}else{
$cat_inf = array('way' => '');
}
$totalfile = db::result(db::query("SELECT COUNT(*) FROM `downfiles` WHERE `type` != 1 AND `status` = 1 && `way` LIKE '" . $cat_inf['way'] ."%'"), 0);
if($sort){
$_SESSION['downsor'] = $sort;
}else{
$sort = isset($_SESSION['downsor']) ? $_SESSION['downsor'] : "";
}
switch ($sort){
case "rating":
$zap = db::query("SELECT * FROM `downfiles` WHERE `type` != 1 AND `status` = 1 && `way` LIKE '" . $cat_inf['way'] ."%' ORDER BY `rating` DESC LIMIT " . $start . "," . $kmess);
echo'<div class="menu">'.$lng_dl['sorting'].': <a href="top.html?cat='.$cat.'&sort=count">'.$lng_dl['loads_count'].'</a> | <b>'.$lng_dl['rating'].'</b></div>';
break;
default:
$zap = db::query("SELECT * FROM `downfiles` WHERE `type` != 1 AND `status` = 1 && `way` LIKE '" . $cat_inf['way'] ."%' ORDER BY `count` DESC LIMIT " . $start . "," . $kmess);
echo'<div class="menu">'.$lng_dl['sorting'].': <b>'.$lng_dl['loads_count'].'</b> | <a href="top.html?cat='.$cat.'&sort=rating">'.$lng_dl['rating'].'</a></div>';
break;
}
while ($zap2 = mysqli_fetch_array($zap))
{
echo ($i % 2) ? '<div class="list1">' : '<div class="list2">';
++$i;
$tf = pathinfo($zap2['way'], PATHINFO_EXTENSION); // Тип файла
if($tf == 'mp3'){
$set_view = array('variant' => 1, 'way_to_path' => 1);
}elseif((($tf == 'thm' or $tf == 'nth') && $down_setting['tmini']) || (($tf == '3gp' or $tf == 'mp4' or $tf == 'avi') && $down_setting['vmini']) || ($tf == 'jpg' or $tf == 'png' or $tf == 'jpeg' or $tf == 'gif')){
$set_view = array('link_download' => 1, 'div' => 1, 'way_to_path' => 1);
}else{
$set_view = array('variant' => 1,
'size' => 1, 'desc' => 1, 'count' => 1, 'div' => 1,
'comments' => 1, 'add_date' => 1, 'rating' => 1, 'way_to_path' => 1);
}
echo f_preview($zap2, $set_view, $tf);
echo '</div>';
}
if ($totalfile > $kmess)
{
echo '<div class="phdr">' . functions::display_pagination('top.html?cat='.$cat.'&', $start, $totalfile, $kmess) . '</div>';
echo '<div class="menu"><form action="top.html" method="get"><input type="hidden" name="cat" value="'.$cat.'"/><input type="text" name="page" size="2"/><input type="submit" value="'.$lng_dl['to_page'].' >>"/></form></div>';
}
echo '<div class="menu"><a href="/download/">'.$lng['back'].'</a></div>';
require_once '../incfiles/end.php';