$forum_id = intval($forum_row['forum_id']);
// get last visit each forums
if ($uid > 0) {
$sql = 'SELECT u2t.u2t_time FROM ' . $db->prefix($mydirname . '_posts') . ' p LEFT JOIN ' . $db->prefix($mydirname . '_users2topics') . ' u2t ON u2t.topic_id=p.topic_id WHERE p.post_id=' . intval($forum_row['forum_last_post_id']) . ' AND u2t.uid=' . $uid;
list($u2t_time) = $db->fetchRow($db->query($sql));
}
if (empty($u2t_time)) {
$u2t_time = 0;
}
// get last poster's object
$user_handler =& xoops_gethandler('user');
$last_poster_obj =& $user_handler->get(intval($forum_row['uid']));
if (is_object($last_poster_obj)) {
// naao from
//$last_post_uname = $last_poster_obj->getVar( 'uname' ) ;
if ($xoopsModuleConfig['use_name'] == 1 && $last_poster_obj->getVar('name')) {
$last_post_uname = $last_poster_obj->getVar('name');
} else {
$last_post_uname = $last_poster_obj->getVar('uname');
}
// naao to
} else {
$last_post_uname = $xoopsConfig['anonymous'];
}
// forums array
$forums[] = array('id' => $forum_row['forum_id'], 'title' => $myts->makeTboxData4Show($forum_row['forum_title']), 'desc' => $myts->displayTarea($forum_row['forum_desc']), 'external_link_format' => htmlspecialchars($forum_row['forum_external_link_format'], ENT_QUOTES), 'topics_count' => intval($forum_row['forum_topics_count']), 'posts_count' => intval($forum_row['forum_posts_count']), 'last_post_time' => intval($forum_row['forum_last_post_time']), 'last_post_time_formatted' => formatTimestamp($forum_row['forum_last_post_time'], 'm'), 'last_post_id' => intval($forum_row['forum_last_post_id']), 'bit_new' => $forum_row['forum_last_post_time'] > $u2t_time && !empty($forum_row['forum_topics_count']) ? 1 : 0, 'last_post_icon' => intval($forum_row['icon']), 'last_post_subject' => $myts->makeTboxData4Show($forum_row['subject']), 'last_post_uid' => intval($forum_row['uid']), 'last_post_uname' => htmlspecialchars($last_post_uname), 'last_post_gname' => htmlspecialchars($forum_row['guest_name']), 'moderate_groups' => d3forum_get_forum_moderate_groups4show($mydirname, $forum_row['forum_id']), 'moderate_users' => d3forum_get_forum_moderate_users4show($mydirname, $forum_row['forum_id']), 'can_post' => (bool) $forum_permissions[$forum_row['forum_id']]['can_post'], 'isadminormod' => (bool) $forum_permissions[$forum_id]['is_moderator'] || $isadmin);
}
$xoopsOption['template_main'] = $mydirname . '_main_listforums.html';
include XOOPS_ROOT_PATH . '/header.php';
unset($xoops_breadcrumbs[sizeof($xoops_breadcrumbs) - 1]['url']);
$xoopsTpl->assign(array('total_topics_count' => $total_topics_count, 'total_posts_count' => $total_posts_count, 'lastvisit' => $last_visit, 'lastvisit_formatted' => formatTimestamp($last_visit, 'm'), 'currenttime' => time(), 'currenttime_formatted' => formatTimestamp(time(), 'm'), 'forums' => $forums, 'cat_jumpbox_options' => d3forum_make_cat_jumpbox_options($mydirname, $whr_read4cat, $cat_id), 'subcategories' => $subcategories, 'category' => $category4assign, 'page' => 'listforums', 'xoops_pagetitle' => join(' - ', array($category4assign['title'], $xoopsModule->getVar('name'))), 'xoops_breadcrumbs' => $xoops_breadcrumbs));
<?php
// get this "forum" from given $forum_id
$sql = "SELECT * FROM " . $db->prefix($mydirname . "_forums") . " f WHERE ({$whr_read4forum}) AND f.forum_id={$forum_id}";
if (!($frs = $db->query($sql))) {
die(_MD_D3FORUM_ERR_SQL . __LINE__);
}
//if( $db->getRowsNum( $frs ) <= 0 ) die( _MD_D3FORUM_ERR_READFORUM ) ;
if ($db->getRowsNum($frs) <= 0) {
return false;
}
$forum_row = $db->fetchArray($frs);
$cat_id = intval($forum_row['cat_id']);
$isadminormod = (bool) $forum_permissions[$forum_id]['is_moderator'] || $isadmin;
$can_post = (bool) $forum_permissions[$forum_id]['can_post'] || $isadminormod;
$can_edit = (bool) $forum_permissions[$forum_id]['can_edit'] || $isadminormod;
$can_delete = (bool) $forum_permissions[$forum_id]['can_delete'] || $isadminormod;
$need_approve = !(bool) $forum_permissions[$forum_id]['post_auto_approved'] && !$isadminormod;
$forum4assign = array('id' => $forum_row['forum_id'], 'title' => $myts->makeTboxData4Show($forum_row['forum_title']), 'desc' => $myts->displayTarea($forum_row['forum_desc']), 'external_link_format' => htmlspecialchars($forum_row['forum_external_link_format'], ENT_QUOTES), 'topics_count' => intval($forum_row['forum_topics_count']), 'posts_count' => intval($forum_row['forum_posts_count']), 'last_post_time' => intval($forum_row['forum_last_post_time']), 'last_post_time_formatted' => formatTimestamp($forum_row['forum_last_post_time'], 'm'), 'last_post_id' => intval($forum_row['forum_last_post_id']), 'moderate_groups' => d3forum_get_forum_moderate_groups4show($mydirname, $forum_row['forum_id']), 'moderate_users' => d3forum_get_forum_moderate_users4show($mydirname, $forum_row['forum_id']), 'need_approve' => $need_approve, 'can_post' => $can_post, 'isadminormod' => $isadminormod);
// assign link or free description (by class) as comment
if (!empty($external_link_id)) {
$topic4assign['comment_link'] = d3forum_get_comment_link($forum_row['forum_external_link_format'], $external_link_id);
$topic4assign['comment_description'] = d3forum_get_comment_description($mydirname, $forum_row['forum_external_link_format'], $external_link_id);
}
// assign breadcrumbs of this forum
array_splice($xoops_breadcrumbs, 1, 0, array(array('url' => XOOPS_URL . '/modules/' . $mydirname . '/index.php?forum_id=' . $forum_id, 'name' => $forum4assign['title'])));
