View file forum/section.php

<?php

# Coding by LinX
# ICQ 339890

# фильтрация ID
$id = $_GET['id'] != null ? s_filtr($_GET['id']) : null;

$Query = mysql_query("SELECT `id`,`title` FROM `forum` WHERE `id` = '" . $id .
    "' && `type` = 'r' LIMIT 1");

# Просмотр или такой раздел существует
if (mysql_num_rows($Query) > 0) {
    $sect = mysql_fetch_assoc($Query);
    s_header('Форум - ' . $sect['title']);

    echo '<div class="gt"><a href="'.MYURL.'for">Форум</a>::' . $sect['title'] .
        '</div><div class="cont">';

    $all = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `cid` = '" .
        $id . "' && `type` = 't'"), 0);

    if ($all > 0) {

        if (isset($_GET['page']) && !empty($_GET['page'])) {
            $page = abs(intval($_GET['page']));

            if ($page > 0) {
                $start = ($page - 1) * $_CONF['tcount'];
            } else {
                $start = 0;
            }
        } else {
            $start = 0;
        }
        
        # Вывод раздела
        $t = mysql_query("SELECT * FROM `forum` WHERE `cid` = '" . $id .
            "' && `type` = 't' ORDER BY `updatetime` DESC LIMIT " . $start . "," . $_CONF['tcount'] .
            "");

        while ($top = mysql_fetch_assoc($t)) {
            $count = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `cid` = '" .
                $top['id'] . "' && `type` = 'm'"), 0);

            $l = $count > $_CONF['pcount'] ? '<a href="'. MYURL .'topic/' . $top['id'] .
                '.html?page=' . (ceil($count / $_CONF['pcount'])) . '">&raquo;</a>' : '';
            
            # Кто последний написал в теме    
            if ($count > 0) {
                $last = mysql_fetch_assoc(mysql_query("SELECT `uid` FROM `forum` WHERE `cid` = '" .
                    $top['id'] . "' && `type` = 'm' ORDER BY `time` DESC LIMIT 1"));
            } else {
                $last['uid'] = $top['uid'];
            }
            echo '<div class="raz"><a href="'.MYURL.'topic/' . $top['id'] .
                '.html">' . $top['title'] . '</a>[' . ($count + 1) .
                ']' . s_userlogin($last['uid']) . $l . '</div>';
        }
        s_nav($all, $_CONF['tcount'], "mode=section&amp;id={$id}");
    } else {
        echo 'Тем в разделе не найдено!<br />';
    }

    if (AUT == 1) {
        echo '<form action="'.MYURL.'create_topic/' . $id .
            '.html" method="post"><input type="submit" value="Создать тему" /></form>';
    }
    echo '<hr /><a href="'.MYURL.'for">Форумы</a></div>';
} else {
    # ошибка, раздел не найден
    s_header("Ошибка!");
    echo '<div class="gt">Ошибка</div><div class="cont">
    Такого раздела не найдено!<hr />
    <a href="'.MYURL.'">Форумы</a>';
}
s_footer();
?>