View file forum/files_list.php

<?php
require( '../sys/inc/core.php' );
$set['title'] = 'Форум - TOP 20 файлов';
include_once '../sys/inc/thead.php';
title();
aut();
if ( $set['web'] ) {
    if ( db::count("SELECT COUNT(*) FROM `forum_files`") > 0 ) {
?>
        <table width='100%' border='1' align='center'>
            <tr class='forum_file_table_title'>
                <td width='14'>
                </td>
                <td>
                    Файл
                </td>
                <td>
                    Тип
                </td>
                <td width='50'>
                    Размер
                </td>
                <td width='50'>
                    Скачано
                </td>
                <td width='50'>
                    Рейтинг
                </td>
                <td width='50'>

                </td>
            </tr>
        <?php
        $q_f = db::query("SELECT COUNT(`forum_files_rating`.`rating`) AS `c_rating`, SUM(`forum_files_rating`.`rating`) AS `rating`, `forum_files`.* FROM `forum_files` LEFT JOIN `forum_files_rating` ON
`forum_files`.`id` = `forum_files_rating`.`id_file` GROUP BY `forum_files`.`id` ORDER BY `rating` DESC LIMIT 20");
        while ( $file =  $q_f->fetch_assoc() ) {
            echo "<tr class='forum_file_table_file'>\n";
            echo "<td>\n";
            if ( is_file( H . 'style/themes/' . $set['set_them'] . '/loads/14/' . $file['ras'] . '.png' ) ) {
                echo "<img src='/style/themes/$set[set_them]/loads/14/$file[ras].png' alt='$file[ras]' />\n";
                if ( $set['echo_rassh_forum'] == 1 )
                    $ras = ".$file[ras]";
                else
                    $ras = NULL;
            } else {
                echo "<img src='/style/themes/$set[set_them]/forum/14/file.png' alt='' />\n";
                $ras = ".$file[ras]";
            }
            echo "</td>\n";
            echo "<td>$file[name]$ras</td>\n";
            echo "<td>$file[type]</td>\n";
            echo "<td>" . size_file( $file['size'] ) . "</td>\n";
            echo "<td style='text-align:center;'>$file[count]</td>\n";
            echo "<td style='text-align:center;'> ";
            if ( $file['rating'] == null )
                $file['rating'] = 0;
            echo "&nbsp;$file[rating]/$file[c_rating]&nbsp;";
            echo "</td>\n";
            echo "<td><a href='/forum/files/$file[id]/$file[name].$file[ras]'>Скачать</a></td>\n";
            echo "</tr>\n";
        }
        echo "</table><br />\n";
    }
} else {
    $q_f = db::query("SELECT COUNT(`forum_files_rating`.`rating`) AS `c_rating`, SUM(`forum_files_rating`.`rating`) AS `rating`, `forum_files`.* FROM `forum_files` LEFT JOIN `forum_files_rating` ON
`forum_files`.`id` = `forum_files_rating`.`id_file` GROUP BY `forum_files`.`id` ORDER BY `rating` DESC LIMIT 20");
    while ( $file =  $q_f->fetch_assoc() ) {
        if ( is_file( H . 'style/themes/' . $set['set_them'] . '/loads/14/' . $file['ras'] . '.png' ) ) {
            echo "<img src='/style/themes/$set[set_them]/loads/14/$file[ras].png' alt='$file[ras]' />\n";
            if ( $set['echo_rassh_forum'] == 1 )
                $ras = ".$file[ras]";
            else
                $ras = NULL;
        } else {
            echo "<img src='/style/themes/$set[set_them]/forum/14/file.png' alt='' />\n";
            $ras = ".$file[ras]";
        }
        echo "<a href='/forum/files/$file[id]/$file[name].$file[ras]'>$file[name]$ras</a> (" . size_file( $file['size'] ) . ") \n";
        echo "<br />\n";
        echo "Рейтинг: ";
        if ( $file['rating'] == null )
            $file['rating'] = 0;
        echo "&nbsp;$file[rating]/$file[c_rating]&nbsp;";
        echo " | ";
        echo "Скачано: $file[count] раз(а) ";
        echo "<br />\n";
    }
}
echo "<div class=\"foot\">\n";
echo "&laquo;<a href=\"/forum/\">Форум</a><br />\n";
echo "</div>\n";
include_once '../sys/inc/tfoot.php';
?>