Просмотр поста

adust,

$total_cat = mysql_result(mysql_query("SELECT COUNT(*) FROM `down_files` WHERE `refid` = '$id' AND `type` = 1"), 0);
$total_files = mysql_result(mysql_query("SELECT COUNT(*) FROM `down_files` WHERE `refid` = '$id' AND `type` = 2"), 0);
$sum_total = $total_files + $total_cat;
if ($sum_total) {
 $req_down = mysql_query("SELECT * FROM `down_files` WHERE `refid` = '$id' AND `type` < 3 ORDER BY `type` ASC, `sort` ASC $sql_sort LIMIT $start, $kmess");
 //Выводим список папок и файлов
 $i = 0;
 while ($res_down = mysql_fetch_assoc($req_down)) {
 $old = time() - 259200;
 $total_new = mysql_result(mysql_query("SELECT COUNT(*) FROM `down_files` WHERE `type` = '2' AND `time` > $old AND `dir` LIKE '" . ($res_down['dir'] . '/' . $res_down['name']) . "%'"), 0); 
 echo ($i % 2) ? '<div class="menu">' : '<div class="menu">';
 if ($res_down['type'] == 1) {
 echo '<img src="' . $set['homeurl'] . '/images/download/8.png" alt="" />&#160;' .
 '<a href="' . $set['homeurl'] . '/obmen/index.php?id=' . $res_down['id'] . '">' . functions::checkout($res_down['rus_name']) . '</a>'.
 '&#160;[' . $res_down['total'] . ']'.($total_new ? '<a href="index.php?act=new_files&amp;id=' . $res_down['id'] . '">&#160;<font color="#FF0000">+'.$total_new.'</font></a>' : '') . ' ';
 if ($res_down['time'] > $old)
 echo ' <span class="red">NEW</span>';
 if ($res_down['field'])
 echo '<div><small>Разрешено выгружать: <span class="green"><b>' . $res_down['text'] . '</b></span></small></div>';
 } else {
 $down = display_file($res_down);
 echo $down; 
 }
 echo '</div>';
 ++$i;
 }
}