View file forum/new_p.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>';
$adm_add  = NULL;
$adm_add2 = NULL;
if ( !isset( $user ) || $user['level'] == 0 ) {
    $q222 = db::query("SELECT * FROM `forum_f` WHERE `adm` = '1'");
    while ( $adm_f =  $q222->fetch_assoc() ) {
        $adm_add[] = "`id_forum` <> '$adm_f[id]'";
    }
    if ( sizeof( $adm_add ) != 0 )
        $adm_add2 = ' WHERE' . implode( ' AND ', $adm_add );
}
$k_post = db::count("SELECT COUNT(*) FROM `forum_t`$adm_add2");
$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`$adm_add2 ORDER BY `time` DESC LIMIT $start, $set[p_str]");
if ( $k_post == 0 ) {
    echo '<div class="mess">';
    echo 'Ваших тем нет в форуме';
    echo '</div>';
}
while ( $them =  $q->fetch_assoc() ) {
    $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 />';
    $ank = db::fetch("SELECT * FROM `user` WHERE `id` = $them[id_user] LIMIT 1", ARRAY_A);
    echo 'Автор: <a href="/info.php?id=' . $ank['id'] . '">' . $ank['nick'] . '</a> (' . vremja( $them['time_create'] ) . ')<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';
?>