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

biluy3 (27.03.2012/11:17)
ошибся...не работает

$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="list2">' : '<div class="list1">';
		if ($res_down['type'] == 1) {
			echo '<img src="' . $set['homeurl'] . '/images/download/file.gif" alt="" />&#160;' .
				 '<a href="' . $set['homeurl'] . '/download/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;
	}
}