Файл: www/forum/user_topic.php
Строк: 45
<?php
include '../config.php';
if(isset($aut)){
mysql_query("UPDATE `users` SET `link`='Форум [<a href=/forum/>Форум</a>]', `link2`='<a href=/forum/>Форум</a>', `link1`='' WHERE `id`='$aut[id]'");}
$se=mysql_fetch_array(mysql_query("SELECT * FROM `forum_set` WHERE `id_user`='$aut[id]'"));
if(isset($_GET['tid_del'])){
div('Удаление тем');
if(!isset($_POST['yes'])){
echo '<form action="/forum/user_topic.php?tid_del='.$rand.'" method="POST">';
echo 'Подтвердите удаление<br/>';
foreach($_POST as $id => $vv){
$t=mysql_fetch_array(mysql_query("SELECT * FROM `forum_theme` WHERE `id`='$id'"));
$n++;
if(is_integer($n/2)){
echo '<div class="msg2">';
}else{
echo '<div class="msg1">';}
echo '<input name="'.$id.'" type="checkbox" value="1" checked> '.$t['name'];
echo '</div>';}
echo '<input type="submit" name="yes" value="Удалить отмеченые"></form>';
}else{
foreach($_POST as $id => $vv){
mysql_query("DELETE FROM `forum_user_topic` WHERE `id_theme`='$id' AND `id_user`='$aut[id]'");}
header('Location: /forum/user_topic.php');}
}else{
if(isset($_GET['tid_add'])){
$tid_add=intval($_GET['tid_add']);
$t=mysql_fetch_array(mysql_query("SELECT * FROM `forum_theme` WHERE `id`='$tid_add'"));
if(!isset($_POST['no'])){
if(!isset($_POST['yes'])){
div('Добавление темы');
echo '<form action="/forum/user_topic.php?tid_add='.$tid_add.'" method="POST">';
echo 'Подтвердите добавление темы<br/>Тема: <b>'.$t['name'].'</b><br/>';
echo '<input type="submit" name="no" value="Вернуться"> или <input type="submit" name="yes" value="Добавить"></form>';
}else{
mysql_query("INSERT INTO `forum_user_topic` SET `id_user`='$aut[id]', `id_theme`='$tid_add'");
div('Поздравляем');
echo 'Поздравляем!<br/>Тема <b>'.$t['name'].'</b> успешно добавлено Вам в закладки<br/>Перейти в <a href="/forum/user_topic.php">мои закладки</a>';}
}else{
header('Location: /forum/?tid='.$tid_add);}
}else{
$i=mysql_num_rows(mysql_query("SELECT `id` FROM `forum_user_topic` WHERE `id_user`='$aut[id]'"));
if($i==0){
div('Ошибка');
echo 'У Вас нет тем, добавленных в закладки';
}else{
div('Мои закладки');
$q=mysql_query("SELECT * FROM `forum_user_topic` WHERE `id_user`='$aut[id]' ORDER BY `id` DESC");
echo 'Всего закладок: '.$i.'<br/>';
echo '<form action="/forum/user_topic.php?tid_del='.$rand.'" method="POST">';
while($r=mysql_fetch_array($q)){
$coun=mysql_num_rows(mysql_query('SELECT `id` FROM `forum_msg` WHERE `id_theme`='.$r['id_theme']));
$str=$se['st_msg'];
$sp=ceil($coun/$str);
$t=mysql_fetch_array(mysql_query("SELECT * FROM `forum_theme` WHERE `id`='$r[id_theme]'"));
$msg=mysql_num_rows(mysql_query('SELECT `id` FROM `forum_msg` WHERE `id_theme`='.$r['id_theme']));
$x=mysql_fetch_array(mysql_query("SELECT * FROM `forum_msg` WHERE `id_theme`='$r[id_theme]' ORDER BY `id` ASC LIMIT 1"));
$x1=mysql_fetch_array(mysql_query('SELECT * FROM `users` WHERE `id`='.$x['id_user']));
$x2=mysql_fetch_array(mysql_query("SELECT * FROM `forum_msg` WHERE `id_theme`='$r[id_theme]' ORDER BY `id` DESC"));
$x3=mysql_fetch_array(mysql_query('SELECT * FROM `users` WHERE `id`='.$x2['id_user']));
$n++;
if(is_integer($n/2)){
echo '<div class="msg2">';
}else{
echo '<div class="msg1">';}
echo '<input name="'.$r['id_theme'].'" type="checkbox" value="1"> <a href="/forum/?tid='.$r['id_theme'].'">'.$t['name'].'</a> ';
if($sp>=2){
echo '<a href="/forum/?tid='.$r['id_theme'].'&p='.$sp.'">»</a> ';}
echo '['.$msg.']<br/>['.$x1['login'].'/'.$x3['login'].']<br/>';
echo '['.data($t['time_ed']).']';
echo '</div>';}
echo '<input type="submit" value="Удалить отмеченые"></form>';}}}
echo '</div>';
include '../foot.php';
echo '</div>';
?>