if (isset($arr[$key]['replies']) && !empty($arr[$key]['replies'])) {
$prefix .= " ";
foreach ($arr[$key]['replies'] as $replykey) {
$current = $current == 0 ? $replykey : $current;
xhnewbb_show_tree($arr, $current, $replykey, $prefix, $foundusers);
}
}
}
if ($order == 'DESC') {
$xoopsTpl->assign(array('order_current' => 'DESC', 'order_other' => 'ASC', 'lang_order_other' => _OLDESTFIRST));
} else {
$xoopsTpl->assign(array('order_current' => 'ASC', 'order_other' => 'DESC', 'lang_order_other' => _NEWESTFIRST));
}
// initialize the start number of select query
$start = !empty($_GET['start']) ? intval($_GET['start']) : 0;
$total_posts = xhnewbb_get_total_posts($topic_id, 'topic');
if ($total_posts > 50) {
$viewmode = "flat";
// hide link to theaded view
$xoopsTpl->assign('lang_threaded', "");
$xoopsTpl->assign('lang_flat', _FLAT);
} else {
$xoopsTpl->assign(array('lang_threaded' => _THREADED, 'lang_flat' => _FLAT));
}
if ($can_post == 1) {
$xoopsTpl->assign(array('viewer_can_post' => true, 'forum_post_or_register' => "<a href=\"newtopic.php?forum=" . $forum . "\">" . _MD_XHNEWBB_POSTNEW . "</a>"));
//jidaikobo
} else {
$xoopsTpl->assign('viewer_can_post', false);
if ($show_reg == 1) {
$xoopsTpl->assign('forum_post_or_register', '<a href="' . XOOPS_URL . '/user.php?xoops_redirect=' . htmlspecialchars($xoopsRequestUri) . '">' . _MD_XHNEWBB_REGTOPOST . '</a>');
include XOOPS_ROOT_PATH . "/header.php";
$sql = 'SELECT c.* FROM ' . $xoopsDB->prefix('xhnewbb_categories') . ' c, ' . $xoopsDB->prefix("xhnewbb_forums") . ' f WHERE f.cat_id=c.cat_id GROUP BY c.cat_id, c.cat_title, c.cat_order ORDER BY c.cat_order';
if (!($result = $xoopsDB->query($sql))) {
redirect_header(XOOPS_URL . '/', 1, _MD_XHNEWBB_ERROROCCURED);
exit;
}
$uid = is_object(@$xoopsUser) ? $xoopsUser->getVar('uid') : 0;
if ($uid > 0) {
$db =& Database::getInstance();
$lv_result = $db->query("SELECT MAX(u2t_time) FROM " . $db->prefix("xhnewbb_users2topics") . " WHERE uid='{$uid}'");
list($last_visit) = $db->fetchRow($lv_result);
}
if (empty($last_visit)) {
$last_visit = time();
}
$xoopsTpl->assign(array("lang_welcomemsg" => sprintf(_MD_XHNEWBB_WELCOME, $xoopsConfig['sitename']), "lang_tostart" => _MD_XHNEWBB_TOSTART, "lang_totaltopics" => _MD_XHNEWBB_TOTALTOPICSC, "lang_totalposts" => _MD_XHNEWBB_TOTALPOSTSC, "total_topics" => xhnewbb_get_total_topics(), "total_posts" => xhnewbb_get_total_posts(0, 'all'), "lang_lastvisit" => sprintf(_MD_XHNEWBB_LASTVISIT, formatTimestamp($last_visit, 'm')), "lang_currenttime" => sprintf(_MD_XHNEWBB_TIMENOW, formatTimestamp(time(), "m")), "lang_forum" => _MD_XHNEWBB_FORUM, "lang_topics" => _MD_XHNEWBB_TOPICS, "lang_posts" => _MD_XHNEWBB_POSTS, "lang_lastpost" => _MD_XHNEWBB_LASTPOST, "lang_moderators" => _MD_XHNEWBB_MODERATOR));
// category limitation
$viewcat = !empty($_GET['cat']) ? intval($_GET['cat']) : 0;
if ($viewcat != 0) {
$whr_categories = 'f.cat_id=' . $viewcat;
$xoopsTpl->assign('forum_index_title', _MD_XHNEWBB_FORUMINDEX);
} else {
$whr_categories = '1';
$xoopsTpl->assign('forum_index_title', '');
}
$categories = array();
while ($cat_row = $xoopsDB->fetchArray($result)) {
$categories[] = $cat_row;
}
if ($uid > 0) {
$sql = 'SELECT f.*, u.uname, u.uid, p.topic_id, p.post_time, p.subject, p.icon, u2t.u2t_time FROM ' . $xoopsDB->prefix('xhnewbb_forums') . ' f LEFT JOIN ' . $xoopsDB->prefix('xhnewbb_posts') . ' p ON p.post_id = f.forum_last_post_id LEFT JOIN ' . $xoopsDB->prefix('users') . ' u ON u.uid = p.uid LEFT JOIN ' . $xoopsDB->prefix('xhnewbb_users2topics') . ' u2t ON u2t.topic_id = p.topic_id AND u2t.uid = ' . $uid . ' WHERE ' . $whr_categories;
