Файл: module/recent.php
Строк: 42
<?php
/*************************************************
* apwa.ru recent.php
* -------------
* Anv@r.all 2009 Модуль портала для phpbb 2.0.23
************************************************/
if ( !defined('IN_PHPBB') )
{
die("Hacking attempt");
}
$template->set_filenames(array(
'recent' => 'module/recent_body.tpl')
);
$template->assign_block_vars('recent', array());
$orig_word = array();
$replacement_word = array();
obtain_word_list($orig_word, $replacement_word);
$limit = ($template_name == 'web') ? $CFG['nm_topics']+$CFG['nm_topics'] : $CFG['nm_topics'];
$sql = "SELECT t.topic_title, t.topic_last_post_id
FROM " . TOPICS_TABLE . " AS t, " . POSTS_TABLE . " AS p
WHERE t.forum_id NOT IN(" . $CFG['ignore_forums'] . ")
AND p.post_id = t.topic_last_post_id
AND t.topic_moved_id = 0
ORDER BY p.post_time DESC LIMIT $limit";
if ( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Не возможно отобразить информацию о случайных темах.", '', __LINE__, __FILE__, $sql);
}
$recentrow = array();
while( $row = $db->sql_fetchrow($result) )
{
$recentrow[] = $row;
}
for ($i = 0; $i < count($recentrow); $i += 2)
{
$template->assign_block_vars('recent.topic', array());
for ($j = $i; $j < ($i + 2); $j++)
{
if( $j >= count($recentrow) )
{
break;
}
$topic_title = $recentrow[$j]['topic_title'];
$topic_title = preg_replace('#(<)([/]?.*?)(>)#is', "<\2>", $topic_title);
$topic_title = ( strlen($topic_title) > $CFG['topic_length']) ? substr($topic_title, 0, $CFG['topic_length']-strlen(strrchr(substr($topic_title, 0, $CFG['topic_length']), ' '))) . '…' : $topic_title;
if ( count($orig_word) )
{
$topic_title = str_replace($orig_word, $replacement_word, $topic_title);
}
$template->assign_block_vars('recent.topic.row', array(
'U_LAST_POST' => append_sid('post' . $recentrow[$j]['topic_last_post_id'] . '.xhtml#' . $recentrow[$j]['topic_last_post_id']),
'TOPIC_TITLE' => str_replace("'", "'", $topic_title))
);
}
}
$template->assign_var_from_handle('MODULE_RECENT', 'recent');
?>