Файл: masteram_us/forum/new.php
Строк: 37
<?
require'../shaxty.php'; // waphp.ru - закрытый клуб вап мастеров!
$align='left';
check_login();
$title='Форум';
include_once (H.'shaxty/head.php');
// Удаление выбранных
if (isset ($_GET['resetmn'])) {
if (isset ($_POST['delp'])) {
foreach ($_POST['delp'] as $v) {
$dc[] = intval($v);
}
foreach ($dc as $delid) {
$res = mysql_fetch_array(mysql_query("SELECT * FROM `forum_rdm` WHERE `t_id` = '".check(intval($delid))."' "));
if(!$res['id']){
mysql_query("INSERT INTO `forum_rdm` SET `t_id`='".check(intval($delid))."', `user_id`='" . $user['id'] . "', `time`='" . $time . "'");
}else{
mysql_query("UPDATE `forum_rdm` SET `time`='" . $time . "' WHERE `t_id`='".check(intval($delid))."' AND `user_id`='" . $user['id'] . "'");
}
}
header ('Location: ?'.SID);
unset($_POST['delp']);
unset($_GET['delp']);
} else echo "<br /><b>Ничего не отмечено</b><br/>";
}
if (isset($_GET['reset'])){
echo '<dl><dt></dt></dl><a href="'.F.'">Форумы</a>|<b>Непрочитанное</b><dl><dt></dt></dl><br />';
$req = mysql_query("SELECT * FROM `forum_t` LEFT JOIN `forum_rdm` ON `forum_t`.`id` = `forum_rdm`.`t_id` AND `forum_rdm`.`user_id` = '" . $user['id'] .
"'
WHERE `forum_rdm`.`t_id` Is Null");
while ($res = mysql_fetch_array($req)) {
mysql_query("INSERT INTO `forum_rdm` SET `t_id`='" . $res['id'] . "', `user_id`='" . $user['id'] . "', `time`='" . $time . "'");
}
$req = mysql_query("SELECT * FROM `forum_t` LEFT JOIN `forum_rdm` ON `forum_t`.`id` = `forum_rdm`.`t_id` AND `forum_rdm`.`user_id` = '" . $user['id'] . "' WHERE `forum_t`.`time` > `forum_rdm`.`time`");
while ($res = mysql_fetch_array($req)) {
mysql_query("UPDATE `forum_rdm` SET `time`='" . $time . "' WHERE `t_id`='" . $res['id'] . "' AND `user_id`='" . $user['id'] . "'");
}
echo '<b>Все темы помеченны как прочитанные</b><br />';
echo "<br />$div1<a href="./index.php">Форум</a>$div9";
include_once (H.'shaxty/foot.php');
}
echo '<form action="?resetmn" method="post">';
$total = forum_new();
echo '<dl><dt></dt></dl><a href="'.F.'">Форумы</a>|<b>Непрочитанное (<b>'.$total.'</b>)</b><dl><dt></dt></dl><br />';
$k_page=k_page($total,$max);
$page=page($k_page);
$start=$max*$page-$max;
// `forum_t`.`close` != '1' AND
$te = mysql_query("SELECT * FROM `forum_t` LEFT JOIN `forum_rdm` ON `forum_t`.`id` = `forum_rdm`.`t_id` AND `forum_rdm`.`user_id` = '" . $user['id'] . "' WHERE (`forum_rdm`.`t_id` Is Null OR `forum_t`.`time` > `forum_rdm`.`time`) ORDER BY `forum_t`.`time` DESC LIMIT $start, $max");
$k = mysql_num_rows($te);
if ($k == 0){echo '<b>Непрочитанного пока нет :)</b><br />';}
for($i = 1; $i <= $k; $i++) {
$tem = mysql_fetch_array($te);
$num = mysql_num_rows(mysql_query( "select id from forum_msg where t_id = '".$tem['id']."'".($level >= 8 ? "" : " AND `forum_msg`.`del` != '1'").""));
$razd = mysql_fetch_array( mysql_query( "select * from `forum_r` where id='".$tem['r_id']."';" ));
$for = mysql_fetch_array( mysql_query( "select * from `forum_f` where id='".$tem['f_id']."';" ));
if ($tem['close'] == 1) $gif = 'zakr';
else if ($tem['zak'] == 1) $gif = 'lock';
else $gif = 'tem';
echo $div2;
echo '<input type="checkbox" name="delp[]" value="' . $tem['id'] . '" /> ';
if($level>=$for['levels']){
if ($user['level']>=6) {
echo '<a href='.F.'admin/editt/'.$tem['id'].'><img src='.H2.'img/'.$gif.'.gif alt=*/></a> ';
}else{
echo '<img src='.H2.'img/'.$gif.'.gif alt=*/> ';
}
if ($tem['realid'] == 1)echo '<img src="'.H2.'img/votes1.png" alt=""/> ';
echo '<b><a href='.F.'tema/'.$tem['id'].'/page>'.$tem['name'].'</a></b> ('.$num.') <a href='.F.'tema/'.$tem['id'].'/page>>></a>';
echo "<br /><a href='razdel/".$for['id']."'>$for[name]</a> > <a href='temes/".$razd['id']."'>$razd[name]</a>";
echo $div9;
$post = mysql_fetch_array(mysql_query("select * from `forum_msg` WHERE t_id = '".$tem['id']."' order by time desc limit 1;"));
$tem1 = mysql_fetch_array(mysql_query( "select * from `forum_t` where `id`='".$tem['id']."' ;" ));
echo ''.user($tem1['user_id'],1).' / '.user($post['user_id'],1).' ('.times($post['time']).')';
$files=mysql_result(mysql_query("select COUNT(*) from `forum_file` WHERE t_id = '".$tem['id']."' and file != '';"),0);
if ($files>0)echo '<br />Вложений: <a href="'.F.'files/'.$tem['id'].'/">'.$files.'</a><br />';
}else echo "<b>Нет доступа к теме</b>";
echo $div9;
echo '<dl></dl>';
}
if ($k_page>1){
echo '<br/><dl><dt></dt></dl>';
str("?",$k_page,$page); // Вывод страниц
echo '<br/><dl><dt></dt></dl>';
}
//echo '<input type="submit" class="ibutton" value="Сбросить выбранное" /></form>';
echo '<br /><a href="?reset">Сбросить все</a><br/>';
// '<a href="?all">Показать за период</a><br/>';
echo "<br />$div1<a href="./index.php">Форум</a>$div9";
include_once (H.'shaxty/foot.php');
?>