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

c этим содержимым (+/-)

<?php


////////////////////////////////////////////////////////////
// Список Категорий форума //
////////////////////////////////////////////////////////////
$count = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_forum_files`" . ($rights >= 7 ? '' : " WHERE `del` != '1'")), 0);

$req = mysql_query("SELECT `id`, `text`, `soft` FROM `forum` WHERE `type`='f' ORDER BY `realid`");
$i = 0;
while (($res = mysql_fetch_array($req)) !== false) {
echo $i % 2 ? '<div class="phdr">' : '<div class="phdr">';
$count = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `type`='r' and `refid`='" . $res['id'] . "'"), 0);
echo '<a href="index.php?id=' . $res['id'] . '">' . $res['text'] . '</a> [' . $count . ']';
if (!empty($res['soft']))
echo '<div class="sub"><span class="gray">' . $res['soft'] . '</span></div>';

echo '</div>';
++$i;
//////////////////////////////Разделы/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

$razdel = mysql_query("SELECT * FROM `forum` WHERE `type` = 'r' AND `refid` = '".$res['id']."' ORDER BY `realid`");

while($row_r = mysql_fetch_assoc($razdel)){
$coltem = mysql_query("SELECT COUNT(*) FROM `forum` WHERE `type`='t' AND `refid`='" . $row_r['id'] . "'" . ($rights >= 7 ? '' : " AND `close` != '1'"));
$coltem1 = mysql_result($coltem, 0);
echo ($o % 2) ? '<div class="list2">' : '<div class="list1">';
echo "<a href='index.php?id=".$row_r['id']."'>".$row_r['text']."</a>";
if ($coltem1)
echo " [$coltem1]";

if (!empty($res['soft']))
echo '<div class="phdr"><span class="gray">' . $row_r['soft'] . '</span>';
echo '</div>';
echo "</div>";
++$o;
}


}