View file forum/my_t.php

<?php
require( '../sys/inc/core.php' );
if ( db::count("SELECT COUNT(*) FROM `ban` WHERE `razdel` = 'forum' AND `id_user` = '$user[id]' AND (`time` > '$time' OR `view` = '0' OR `navsegda` = '1')") != 0 ) {
    header( 'Location: /ban.php?' . SID );
    exit;
}
$set['title'] = 'Форум - Мои темы';
include_once '../sys/inc/thead.php';
title();
aut();
echo '<div class="foot">';
echo '<img src="/style/icons/str2.gif" /> <a href="/forum/">Форум</a> | <b>Мои темы</b>';
echo '</div>';
$k_post = db::count("SELECT COUNT(*) FROM `forum_t`  WHERE `id_user` = '$user[id]'");
$k_page = k_page( $k_post, $set['p_str'] );
$page   = page( $k_page );
$start  = $set['p_str'] * $page - $set['p_str'];
echo '<table class="post">';
$q = db::query("SELECT * FROM `forum_t` WHERE `id_user` = '$user[id]' ORDER BY `time` DESC  LIMIT $start, $set[p_str]");
if ( $k_post == 0 ) {
    echo '<div class="mess">';
    echo 'Ваших тем нет в форуме';
    echo '</div>';
}
while ( $them =  $q->fetch_array() ) {
    $forum  = db::fetch("SELECT * FROM `forum_f` WHERE `id` = '$them[id_forum]' LIMIT 1", ARRAY_N);
    $razdel = db::fetch("SELECT * FROM `forum_r` WHERE `id` = '$them[id_razdel]' LIMIT 1", ARRAY_N);
    if ( $num == 0 ) {
        echo '<div class="nav1">';
        $num = 1;
    } elseif ( $num == 1 ) {
        echo '<div class="nav2">';
        $num = 0;
    }
    echo '<img src="/style/themes/' . $set['set_them'] . '/forum/14/them_' . $them['up'] . $them['close'] . '.png" alt="" /> ';
    echo '<a href="/forum/' . $forum['id'] . '/' . $razdel['id'] . '/' . $them['id'] . '/">' . text( $them['name'] ) . '</a> 
    <a href="/forum/' . $forum['id'] . '/' . $razdel['id'] . '/' . $them['id'] . '/?page=' . $pageEnd . '">
    (' . db::count("SELECT COUNT(*) FROM `forum_p` WHERE `id_forum` = '$forum[id]' AND `id_razdel` = '$razdel[id]' AND `id_them` = '$them[id]'") . ')</a><br/>';
    echo '<a href="/forum/' . $forum['id'] . '/">' . text( $forum['name'] ) . '</a> &gt; <a href="/forum/' . $forum['id'] . '/' . $razdel['id'] . '/">' . text( $razdel['name'] ) . '</a><br />';
    $last = db::fetch("SELECT * FROM `forum_p` WHERE `id_them` = '$them[id]' AND `id_razdel` = '$razdel[id]' AND `id_forum` = '$forum[id]' ORDER BY `time` DESC LIMIT 1", ARRAY_N);
    if ( !empty($last) ) {
        $last_user = db::fetch("SELECT * FROM `user` WHERE `id` = $last[id_user] LIMIT 1", ARRAY_A);
        if ( $last_user['id'] )
            echo 'Посл.: <a href="/info.php?id=' . $last_user['id'] . '">' . $last_user['nick'] . '</a> (' . vremja( $last['time'] ) . ')<br />';
    }
    echo '</div>';
}
echo '</table>';
if ( $k_page > 1 )
    str( "?", $k_page, $page );
echo '<div class="foot">';
echo '<img src="/style/icons/str2.gif" /> <a href="/forum/">Форум</a> | <b>Мои темы</b>';
echo '</div>';
include_once '../sys/inc/tfoot.php';
?>