Usach, echo \"<div class=\'title\'>\";
echo \"Последние темы форума\";
echo \"</div>\";
$adm_add = NULL;
$adm_add2 = NULL;
if (!isset($user) || $user[\'level\'] == 0)
{
$q222 = mysql_query(\"SELECT * FROM `forum_f` WHERE `adm` = \'1\'\"
;
while ($adm_f = mysql_fetch_assoc($q222))
{
$adm_add[] = \"`id_forum` <> \'$adm_f[id]\'\";
}
if (sizeof($adm_add) != 0)
$adm_add2 = \' WHERE\'.implode(\' AND \', $adm_add);
}
$k_post = mysql_result(mysql_query(\"SELECT COUNT(*) FROM `forum_t`$adm_add2\"
,0);
$k_page = k_page($k_post,$set[\'p_str\']);
$page = page($k_page);
$start = $set[\'p_str\']*$page-$set[\'p_str\'];
$q = mysql_query(\"SELECT * FROM `forum_t`$adm_add2 ORDER BY `time` DESC LIMIT 3\"
;
// Если список пуст
if ($k_post == 0)
{
echo \'<div class=\"mess\">\';
echo \'Нет новых тем для обсуждения\';
echo \'</div>\';
}
while ($them = mysql_fetch_assoc($q))
{
// Определение подфорума
$forum = mysql_fetch_array(mysql_query(\"SELECT * FROM `forum_f` WHERE `id` = \'$them[id_forum]\' LIMIT 1\"
);
// Определение раздела
$razdel = mysql_fetch_array(mysql_query(\"SELECT * FROM `forum_r` WHERE `id` = \'$them[id_razdel]\' LIMIT 1\"
);
// Лесенка дивов
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\'] . \'/\"><b>\' . htmlspecialchars($them[\'name\']) . \'</b></a>
<a href=\"/forum/\' . $forum[\'id\'] . \'/\' . $razdel[\'id\'] . \'/\' . $them[\'id\'] . \'/?page=\' . $pageEnd . \'\">
(\' . mysql_result(mysql_query(\"SELECT COUNT(*) FROM `forum_p` WHERE `id_forum` = \'$forum[id]\' AND `id_razdel` = \'$razdel[id]\' AND `id_them` = \'$them[id]\'\"
,0) . \')</a><br/>\';
// Последний пост
$post = mysql_fetch_array(mysql_query(\"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\"
);
// Автор последнего поста
$ank2 = mysql_fetch_assoc(mysql_query(\"SELECT * FROM `user` WHERE `id` = \'\".$post[\'id_user\'].\"\' LIMIT 1\"
);
if ($ank2[\'id\'])echo \'Посл.: <a href=\"/info.php?id=\' . $ank2[\'id\'] . \'\">\' . $ank2[\'nick\'] . \'</a> (\' . vremja($post[\'time\']) . \')<br />\';
echo \'</div>\';
}