Форумы портала PHP.SU

PHP:
скопировать код в буфер обмена
$id = num($_GET['id']);
if(empty($id)){echo'<div class="name">Ошибка</div>';include HOME.'/system/foot.php';exit;}    //проверка
$tema = mysql_fetch_assoc(mysql_query("SELECT * FROM `forum_tem` WHERE `id`='$id' LIMIT 1"));
if(!$tema){echo'<div class="name">Такой темы нет в БД</div>';include HOME.'/system/foot.php';exit;} //проверка
 
$podcat=mysql_fetch_array(mysql_query("SELECT * FROM `forum_podcat` WHERE `id`='$tema[cat]'"));
$cat=mysql_fetch_array(mysql_query("SELECT * FROM `forum_cat` WHERE `id`='$podcat[refid]'"));
if($podcat && $cat)
{
echo'<div class="cat">
<a href="cat.php?id='.$cat['id'].'">'.output($cat['name']).'</a> / <a href="podcat.php?id='.output($podcat['id']).'">'.output($podcat['name']).'</a></div>
<div class="login">Тема: <b>'.output($tema['name']).'</b></div>';
}
if(!isset($user)){ //ДЛЯ НЕАВТОРИЗОВАННЫХ//
$count_tem=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_post` WHERE `tema`='$id'"), 0);
$page=isset($_GET['p'])?num($_GET['p']):1;
 
$post_q=mysql_query("SELECT * FROM `forum_post` WHERE `tema`='$id' ORDER BY `time` LIMIT ".(($page-1)*$config['points_page']).", $config[points_page]");
while($post=mysql_fetch_array($post_q))
{
 
$fi = mysql_query( "select `login` from `users` where id='".$post['id_user']."';" );
$fi_info = @mysql_fetch_array( @$fi );
 
echo'<div class="main"><a href="'.$HOME.'/user.php?id='.num($post['id_user']).'">'.$fi_info['login'].'</a> '.date('d.m.y H:i',$post['time']).'</br>'.BBcode(smile(output($gb['text']))).'<br/></div>';
 
echo'<div class="text">
'.output($post['text']).'</div>';
}
nav($count_tem, $page, '?id='.$id.'&', $config['points_page']); //навигация
}else   {//ДЛЯ АВТОРИЗОВАННЫХ
 
$count_tem=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_post` WHERE `tema`='$id'"), 0);
$page=isset($_GET['p'])?num($_GET['p']):1;
 
$post_q=mysql_query("SELECT * FROM `forum_post` WHERE `tema`='$id' ORDER BY `time` LIMIT ".(($page-1)*$user['points_page']).", $user[points_page]");
if (!mysql_num_rows($post_q)) {
        echo "Созданных тем нет";       
}else{
while($post=mysql_fetch_array($post_q))
{
 
$fi = mysql_query( "select `login` from `users` where id='".$post['id_user']."';" );
$fi_info = @mysql_fetch_array( @$fi );
 
echo'<div class="main"><a href="'.$HOME.'/user.php?id='.num($post['id_user']).'">'.$fi_info['login'].' </a>'.date('d.m.y H:i',$post['time']).'</a></b></div>';
 
if($user['status']==admin){echo'<div class="main"><a href="/adminka/post.php?edit='.num($post['id']).'"> Редактировать</a> | <a href="/adminka/post.php?del='.num($post['id']).'">Удалить</a></div>';}
echo '<div class="text">
'.output($post['text']).'</div>';
}
}
nav($count_tem, $page, '?id='.$id.'&', $user['points_page']); //навигация
if($tema['close']==1){echo'<div class="cat">Данная тема закрыта</div>';
if($user['status']==admin) echo'<div class="login"><img src="/tema/default/close.png" alt=""> <a href="/adminka/tema.php?close='.num($tema['id']).'">Открыть тему</a><br/></div>';}
 
 
else{
echo'<div class="login">
Добавить сообщение<br/>
<form action="post-add.php?id='.$id.'" method="post"><input name="tema" type="hidden" value="'.$id.'" />
<textarea name="text" cols="40" rows="3"></textarea><br/>
<div class="text"><input name="" type="submit" value="Написать" /></form></div>';
if($user['status']==admin){
echo'<div class="login"><img src="/tema/default/close.png" alt=""> <a href="/adminka/tema.php?close='.num($tema['id']).'">Закрыть тему</a><br/></div>';
}
}}