';
$coltem = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `type` = 't' AND `refid` = '" . $res['id'] . "'"), 0);
echo '' . $res['text'] . '';
if ($coltem)
echo " [$coltem]";
if (!empty($res['soft']))
echo '
';
++$i;
}
unset($_SESSION['fsort_id']);
unset($_SESSION['fsort_users']);
} else {
echo '';
}
echo '' . $res['soft'] . '
';
echo '' . $lng['total'] . ': ' . $total . '
';
break;
case 'r':
/*
-----------------------------------------------------------------
Список топиков
-----------------------------------------------------------------
*/
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `type`='t' AND `refid`='$id'" . ($rights >= 7 ? '' : " AND `close`!='1'")), 0);
if ($user_id && !$ban['1'] && !$ban['11']) {
// Кнопка создания новой темы
echo '';
}
if ($total) {
$req = mysql_query("SELECT * FROM `forum` WHERE `type`='t'" . ($rights >= 7 ? '' : " AND `close`!='1'") . " AND `refid`='$id' ORDER BY `vip` DESC, `time` DESC LIMIT $start, $kmess");
while ($res = mysql_fetch_assoc($req)) {
if($res['close'])
echo '';
else
echo $i % 2 ? '
' : '
'; echo '![' . $lng_forum['rating'] . ': ' . $count_vote . '%](vote_img.php?img=' . $count_vote . ')
'; } echo '
';
if ($user_id && $vote_user == 0)
echo '';
}
}
/*
-----------------------------------------------------------------
Фиксация первого поста в теме
-----------------------------------------------------------------
*/
if (($set_forum['postclip'] == 2 && ($set_forum['upfp'] ? $start < (ceil($colmes - $kmess)) : $start > 0)) || isset($_GET['clip'])) {
$postreq = mysql_query("SELECT `forum`.*, `users`.`sex`, `users`.`rights`, `users`.`lastdate`, `users`.`status`, `users`.`datereg`
FROM `forum` LEFT JOIN `users` ON `forum`.`user_id` = `users`.`id`
WHERE `forum`.`type` = 'm' AND `forum`.`refid` = '$id'" . ($rights >= 7 ? "" : " AND `forum`.`close` != '1'") . "
ORDER BY `forum`.`id` LIMIT 1");
$postres = mysql_fetch_assoc($postreq);
echo '';
$nikuser = mysql_query("SELECT `from` FROM `forum` WHERE `type` = 'm' AND `close` != '1' AND `refid` = '" . $res['id'] . "' ORDER BY `time` DESC LIMIT 1");
$nam = mysql_fetch_assoc($nikuser);
$colmes = mysql_query("SELECT COUNT(*) FROM `forum` WHERE `type`='m' AND `refid`='" . $res['id'] . "'" . ($rights >= 7 ? '' : " AND `close` != '1'"));
$colmes1 = mysql_result($colmes, 0);
$cpg = ceil($colmes1 / $kmess);
$np = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_forum_rdm` WHERE `time` >= '" . $res['time'] . "' AND `topic_id` = '" . $res['id'] . "' AND `user_id`='$user_id'"), 0);
// Значки
$icons = array(
($np ? (!$res['vip'] ? '
' : '') : '
'),
($res['vip'] ? '
' : ''),
($res['realid'] ? '
' : ''),
($res['edit'] ? '
' : '')
);
echo functions::display_menu($icons, ' ', ' ');
echo '' . $res['text'] . ' [' . $colmes1 . ']';
if ($cpg > 1) {
echo ' >>';
}
echo '
';
++$i;
}
unset($_SESSION['fsort_id']);
unset($_SESSION['fsort_users']);
} else {
echo '';
}
echo '' : '') : ''),
($res['vip'] ? '' : ''),
($res['realid'] ? '' : ''),
($res['edit'] ? '' : '')
);
echo functions::display_menu($icons, ' ', ' ');
echo '' . $res['text'] . ' [' . $colmes1 . ']';
if ($cpg > 1) {
echo ' >>';
}
echo '';
echo $res['from'];
if (!empty($nam['from'])) {
echo ' / ' . $nam['from'];
}
$vrp = $res['time'] + $set_user['sdvig'] * 3600;
echo ' (' . date("d.m.y / H:i", $vrp) . ')
' . $lng['total'] . ': ' . $total . '
';
if ($total > $kmess) {
echo '' .
'';
}
break;
case 't':
/*
-----------------------------------------------------------------
Читаем топик
-----------------------------------------------------------------
*/
$filter = isset($_SESSION['fsort_id']) && $_SESSION['fsort_id'] == $id ? 1 : 0;
$sql = '';
if ($filter && !empty($_SESSION['fsort_users'])) {
// Подготавливаем запрос на фильтрацию юзеров
$sw = 0;
$sql = ' AND (';
$fsort_users = unserialize($_SESSION['fsort_users']);
foreach ($fsort_users as $val) {
if ($sw)
$sql .= ' OR ';
$sortid = intval($val);
$sql .= "`forum`.`user_id` = '$sortid'";
$sw = 1;
}
$sql .= ')';
}
if ($user_id && !$filter) {
// Фиксация факта прочтения топика
}
if ($rights < 7 && $type1['close'] == 1) {
echo '';
require('../incfiles/end.php');
exit;
}
// Счетчик постов темы
$colmes = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `type`='m'$sql AND `refid`='$id'" . ($rights >= 7 ? '' : " AND `close` != '1'")), 0);
// Выводим название топика
echo '';
if ($colmes > $kmess)
echo '';
// Метки удаления темы
if ($type1['close'])
echo '';
elseif (!empty($type1['close_who']) && $rights >= 7)
echo '';
// Метки закрытия темы
if ($type1['edit'])
echo '';
/*
-----------------------------------------------------------------
Блок голосований
-----------------------------------------------------------------
*/
if ($type1['realid']) {
if (isset($_GET['clip']))
$clip_forum = '&clip';
$vote_user = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_forum_vote_users` WHERE `user`='$user_id' AND `topic`='$id'"), 0);
$topic_vote = mysql_fetch_assoc(mysql_query("SELECT `name`, `time`, `count` FROM `cms_forum_vote` WHERE `type`='1' AND `topic`='$id' LIMIT 1"));
echo '';
} else {
// Выводим результаты голосования
echo '';
while ($vote = mysql_fetch_assoc($vote_result)) {
$count_vote = $topic_vote['count'] ? round(100 / $topic_vote['count'] * $vote['count']) : 0;
echo functions::checkout($vote['name']) . ' [' . $vote['count'] . ']
'; echo '
'; } echo '
';
if ($postres['sex'])
echo ' . ($postres['datereg'] > $realtime - 86400 ? '_new.png)
';
else
echo '
';
if ($user_id && $user_id != $postres['user_id']) {
echo '' . $postres['from'] . ' ' .
' ' . $lng_forum['reply_btn'] . ' ' .
' ' . $lng_forum['cytate_btn'] . ' ';
} else {
echo '' . $postres['from'] . ' ';
}
$user_rights = array (
1 => 'Kil',
3 => 'Mod',
6 => 'Smd',
7 => 'Adm',
8 => 'SV'
);
echo $user_rights[$postres['rights']];
echo ($realtime > $postres['lastdate'] + 300 ? ' [Off]' : ' [ON]');
echo ' (' . date("d.m.Y / H:i", $postres['time'] + $set_user['sdvig'] * 3600) . ')
'; if ($postres['close']) { echo '' . $lng_forum['post_deleted'] . '
'; } echo functions::checkout(mb_substr($postres['text'], 0, 500), 0, 2); if (mb_strlen($postres['text']) > 500) echo '...' . $lng_forum['read_all'] . ''; echo '
';
}
if ($filter)
echo '';
// Задаем правила сортировки (новые внизу / вверху)
if ($user_id)
$order = $set_forum['upfp'] ? 'DESC' : 'ASC';
else
$order = ((empty($_SESSION['uppost'])) || ($_SESSION['uppost'] == 0)) ? 'ASC' : 'DESC';
// Запрос в базу
$req = mysql_query("SELECT `forum`.*, `users`.`sex`, `users`.`rights`, `users`.`lastdate`, `users`.`status`, `users`.`datereg`
FROM `forum` LEFT JOIN `users` ON `forum`.`user_id` = `users`.`id`
WHERE `forum`.`type` = 'm' AND `forum`.`refid` = '$id'"
. ($rights >= 7 ? "" : " AND `forum`.`close` != '1'") . "$sql ORDER BY `forum`.`id` $order LIMIT $start, $kmess");
// Верхнее поле "Написать"
if (($user_id && !$type1['edit'] && $set_forum['upfp']) || ($rights >= 7 && $set_forum['upfp'])) {
echo '';
}
if ($rights == 3 || $rights >= 6)
echo ' ';
else
echo ' ';
if ($user_id && $user_id != $postres['user_id']) {
echo '' . $postres['from'] . ' ' .
' ' . $lng_forum['reply_btn'] . ' ' .
' ' . $lng_forum['cytate_btn'] . ' ';
} else {
echo '' . $postres['from'] . ' ';
}
$user_rights = array (
1 => 'Kil',
3 => 'Mod',
6 => 'Smd',
7 => 'Adm',
8 => 'SV'
);
echo $user_rights[$postres['rights']];
echo ($realtime > $postres['lastdate'] + 300 ? ' [Off]' : ' [ON]');
echo ' (' . date("d.m.Y / H:i", $postres['time'] + $set_user['sdvig'] * 3600) . ')'; if ($postres['close']) { echo '' . $lng_forum['post_deleted'] . '
'; } echo functions::checkout(mb_substr($postres['text'], 0, 500), 0, 2); if (mb_strlen($postres['text']) > 500) echo '...' . $lng_forum['read_all'] . ''; echo '