Файл: modules/forum/view/new_themes.php
Строк: 30
<?php
/* Мод "Форум"
* Версия v0.0.1
* Дата последнего редактирования 27.11.2014
* Двиг DCMS Special
* Модифицировал densnet
* Автор yadalay
* Файл new_themes.php
* Описание: новые темы
*/
$set['title'] = 'Новые темы';
require_once H . 'sys/inc/thead.php';
title() . aut();
#Навигация
echo "<div class = 'navigation'><a href = '/index.php'>Главная</a> > <a href = '" . DIR_FORUM . "'>Форум</a> > <b>Новые темы</b></div>";
$k_post = mysql_result(mysql_query('SELECT COUNT(*) FROM `forum_themes` WHERE `time` > ' . (time() - 60 * 60 * 24)), 0);
$k_page = k_page($k_post, $set['p_str']);
$page = page($k_page);
$start = $set['p_str'] * $page - $set['p_str'];
if ($k_post == 0) {
echo "<div class = 'errs'>";
echo img('error.png') . " Нет результатов";
echo "</div>";
} else {
$themes = mysql_query('SELECT * FROM `forum_themes` WHERE `time` > ' . (time() - 60 * 60 * 24) . ' ORDER BY `id` DESC LIMIT ' . $start . ', ' . $set['p_str']);
while ($theme = mysql_fetch_object($themes)) {
$creater = mysql_fetch_object(mysql_query('SELECT `id`, `nick` FROM `user` WHERE `id` = ' . $theme->id_user));
$razdel = mysql_fetch_object(mysql_query('SELECT `id`, `id_forum` FROM `forum_razdels` WHERE `id` = ' . $theme->id_razdel));
$forum = mysql_fetch_object(mysql_query('SELECT `id` FROM `forum` WHERE `id` = ' . $razdel->id_forum));
$hide = (user::access('forum_post_ed')) ? NULL : '`hide` = "0" AND';
$last_post = mysql_fetch_object(mysql_query('SELECT `id`, `hide`, `id_user`, `time` FROM `forum_posts` WHERE ' . $hide . ' `id_theme` = ' . $theme->id . ' ORDER BY `id` DESC'));
$who = ($last_post && $last_post->id_user != 0) ? mysql_fetch_object(mysql_query('SELECT `id`, `nick` FROM `user` WHERE `id` = ' . $last_post->id_user)) : array();
$who_id = ($last_post && $last_post->id_user != 0) ? $who->id : 0;
$who_nick = ($last_post && $last_post->id_user != 0) ? $who->nick : 'Система';
echo "<table class = 'razd'><tr><td class = 'null'>";
echo img('theme.png') . " <a href = '" . DIR_FORUM . "$forum->id/$razdel->id/$theme->id.html'>" . text::toOutput($theme->name, 1, 1, 0, 0, 0) . "</a> (" . date::time($theme->time) . ")<br />";
if ($last_post) {
echo "<b>Автор: <a href = '/info.php?id=$theme->id_user'>$creater->nick</a> | Посл.:</b> <a href = '/info.php?id=$who_id'>$who_nick</a> (" . date::time($last_post->time) . ")<br />";
} else {
$continue = (mb_strlen($theme->description) > 150) ? '.....' : NULL;
echo text::toOutput(mb_substr($theme->description, 0, 150), 1, 1, 0, 1, 1) . $continue;
}
echo "</td></tr></table>";
}
if ($k_page > 1) {
str('/modules/forum/new_themes/', $k_page, $page);
}
}
echo "<div class = 'razd'>" . img('left.png') . " <a href = '" . DIR_FORUM . "'>Вернуться в форум</a></div>";