Top-files

<?php

if( !defined( 'DATALIFEENGINE' ) ) {
    die( "Hacking attempt!" );
}

$is_change = false;

if( $config['allow_cache'] != "yes" ) {
    $config['allow_cache'] = "yes";
    $is_change = true;
}

$topfiles = dle_cache( "topfiles", $config['skin'], $member_id['user_group'] );

if( $topfiles === false ) {
    
    function ok_type($n) {
        return ($n%10==1 && $n%100!=11 ? 0 : ($n%10>=2 && $n%10<=4 && ($n%100<10 || $n%100>=20) ? 1 : 2));
    }
    
    $sum = 10;
    $cat = "1"; // ID категорий через запятую

    //$db->query( "SELECT * FROM " . PREFIX . "_files WHERE dcount > 0 ORDER BY dcount DESC LIMIT 0," . $sum );
    $count = $db->query( "SELECT p.id, p.category, f.id, f.news_id, f.name, f.dcount FROM " . PREFIX . "_files f LEFT JOIN " . PREFIX . "_post p ON (p.id=f.news_id) WHERE f.dcount > 0 AND p.category IN ({$cat}) ORDER BY dcount DESC LIMIT 0," . $sum );

    $i = 1;

    $file_list = array();
    
    while ( $row = $db->get_row($count) ) {
        $alls_num = array('раз', 'раза', 'раз');
        $counts_u = $alls_num[ok_type($row['dcount'])];
        
        if( $user_group[$member_id['user_group']]['allow_files'] ) {
            if( $user_group[$member_id['user_group']]['allow_hide'] ) {
                $files = "<li><a href=\"/engine/download.php?id=" . $row['id'] . "\" title=\"Скачали: " . $row['dcount'] . " " . $alls_num[ok_type($row['dcount'])] . "\">" . $i . ". " . $row['name'] . "</a></li>";
            } else {
                $files = "<li>Скрытый текст</li>";
            }
        } else {
            $files = "<li>Загрузка запрещена</li>";
        }
        
        $file_list[] = $files;
        $i++;
    }
    $db->free($count);
    
    $topfiles = ( count( $file_list ) ) ? implode( "", $file_list ) : "Ничего нет";

    create_cache( "topfiles", $topfiles, $config['skin'], $member_id['user_group'] );
}

echo $topfiles;

if( $is_change ) $config['allow_cache'] = false;

?>