sql_query($sql))
{
message_die(GENERAL_ERROR, "Couldn't obtain forums information.", "", __LINE__, __FILE__, $sql);
}
//
// If the query doesn't return any rows this
// isn't a valid forum. Inform the user.
//
if(!$total_rows = $db->sql_numrows($result))
{
message_die(GENERAL_MESSAGE, "The forum you selected does not exist, please go back and try again.");
}
$forum_row = $db->sql_fetchrow($result);
//
// Start auth check
//
$is_auth = auth(AUTH_ALL, $forum_id, $userdata, $forum_row);
if(!$is_auth['auth_read'] || !$is_auth['auth_view'])
{
//
// Ooopss, user is not authed
// to read this forum ...
//
include('includes/page_header.'.$phpEx);
$msg = $lang['Sorry_auth'] . $is_auth['auth_read_type'] . $lang['can_read'] . $lang['this_forum'];
message_die(GENERAL_MESSAGE, $msg);
}
//
// End of auth check
//
//
// Do the forum Prune
//
if( ( $is_auth['auth_mod'] || $is_auth['auth_admin'] ) && $board_config['prune_enable'] )
{
if( $forum_row['prune_next'] < time() && $forum_row['prune_enable'] )
{
include('includes/prune.php');
auto_prune($forum_id);
}
}
//
// End of forum prune
//
$forum_name = stripslashes($forum_row['forum_name']);
if(empty($HTTP_POST_VARS['postdays']))
{
$topics_count = $forum_row['forum_topics'];
}
//
// Obtain list of moderators of this forum
//
$sql = "SELECT u.username, u.user_id
FROM " . USERS_TABLE . " u, " . USER_GROUP_TABLE . " ug, " . AUTH_ACCESS_TABLE . " aa
WHERE aa.forum_id = $forum_id
AND aa.auth_mod = 1
AND ug.group_id = aa.group_id
AND u.user_id = ug.user_id";
if(!$result_mods = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, "Couldn't obtain forums information.", "", __LINE__, __FILE__, $sql);
}
$total_mods = $db->sql_numrows($result_mods);
if($total_mods)
{
$mods_rowset = $db->sql_fetchrowset($result_mods);
for($i = 0; $i < $total_mods; $i++)
{
if($i > 0)
$forum_moderators .= ", ";
$forum_moderators .= "" . $mods_rowset[$i]['username'] . "";
}
}
else
{
$forum_moderators = $lang['None'];
}
//
// Generate a 'Show posts in previous x days'
// select box. If the postdays var is POSTed
// then get it's value, find the number of topics
// with dates newer than it (to properly handle
// pagination) and alter the main query
//
$previous_days = array(0, 1, 7, 14, 30, 90, 180, 364);
$previous_days_text = array($lang['All_Topics'], "1 " . $lang['Day'], "7 " . $lang['Days'], "2 " . $lang['Weeks'], "1 " . $lang['Month'], "3 ". $lang['Months'], "6 " . $lang['Months'], "1 " . $lang['Year']);
if(!empty($HTTP_POST_VARS['postdays']) || !empty($HTTP_GET_VARS['postdays']))
{
$post_days = (!empty($HTTP_POST_VARS['postdays'])) ? $HTTP_POST_VARS['postdays'] : $HTTP_GET_VARS['postdays'];
$min_post_time = time() - ($post_days * 86400);
$sql = "SELECT COUNT(*) AS forum_topics
FROM ".TOPICS_TABLE."
WHERE forum_id = $forum_id
AND topic_time > $min_post_time";
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, "Couldn't obtain limited topics count information", "", __LINE__, __FILE__, $sql);
}
$topics_count = $db->sql_fetchfield("forum_topics", -1, $result);
$limit_posts_time = "AND t.topic_time > $min_post_time ";
if(!empty($HTTP_POST_VARS['postdays']))
{
$start = 0;
}
}
else
{
$limit_posts_time = "";
$post_days = 0;
}
$select_post_days = "";
//
// Grab all the basic data for
// this forum
//
$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_username
FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . USERS_TABLE . " u2
WHERE t.forum_id = $forum_id
AND t.topic_poster = u.user_id
AND p.post_id = t.topic_last_post_id
AND p.poster_id = u2.user_id
AND t.topic_type <> " . POST_GLOBAL_ANNOUNCE . "
$limit_posts_time
ORDER BY t.topic_type DESC, p.post_time DESC
LIMIT $start, ".$board_config['topics_per_page'];
if(!$t_result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, "Couldn't obtain topic information", "", __LINE__, __FILE__, $sql);
}
$total_topics = $db->sql_numrows($t_result);
//
// Post URL generation for
// templating vars
//
$post_new_topic_url = append_sid("posting.".$phpEx."?mode=newtopic&".POST_FORUM_URL."=$forum_id");
$template->assign_vars(array(
"U_POST_NEW_TOPIC" => $post_new_topic_url,
"S_SELECT_POST_DAYS" => $select_post_days,
"S_POST_DAYS_ACTION" => append_sid("viewforum.$phpEx?".POST_FORUM_URL."=".$forum_id."&start=$start")));
//
// Dump out the page header and
// load viewforum template
//
include('includes/page_header.'.$phpEx);
$template->set_filenames(array(
"body" => "viewforum_body.tpl",
"jumpbox" => "jumpbox.tpl")
);
$jumpbox = make_jumpbox();
$template->assign_vars(array(
"JUMPBOX_LIST" => $jumpbox,
"SELECT_NAME" => POST_FORUM_URL)
);
$template->assign_var_from_handle("JUMPBOX", "jumpbox");
$template->assign_vars(array(
"FORUM_ID" => $forum_id,
"FORUM_NAME" => $forum_name,
"MODERATORS" => $forum_moderators,
"USERS_BROWSING" => $users_browsing)
);
//
// End header
//
//
// Okay, lets dump out the page ...
//
if($total_topics)
{
$topic_rowset = $db->sql_fetchrowset($t_result);
/*
//
// This code allows for individual topic
// read tracking, on small, low volume sites
// it'll probably work very well. However, for
// busy sites the use of a text field in the DB
// combined with the additional UPDATE's required
// in viewtopic may be unacceptable. So, by default
// this code is off, however you may want to play
// ...
//
// psoTFX
//
if($userdata['user_id'] != ANONYMOUS)
{
$unread_topic_list = unserialize($userdata['user_topics_unvisited']);
$last_update_time = (isset($unread_topic_list['lastupdate'])) ? $unread_topic_list['lastupdate'] : $userdata['session_last_visit'];
for($x = 0; $x < $total_topics; $x++)
{
if($topic_rowset[$x]['topic_time'] > $last_update_time)
{
$unread_topic_list[$forum_id][$topic_rowset[$x]['topic_id']] = 1;
}
}
$unread_topic_list['lastupdate'] = time();
$sql = "UPDATE " . USERS_TABLE . "
SET user_topics_unvisited = '" . serialize($unread_topic_list) . "'
WHERE user_id = " . $userdata['user_id'];
if(!$s_topic_times = $db->sql_query($sql))
{
error_die(SQL_QUERY, "Could not update user topics list.", __LINE__, __FILE__);
}
}
*/
for($x = 0; $x < $total_topics; $x++)
{
$topic_title = stripslashes($topic_rowset[$x]['topic_title']);
$topic_type = $topic_rowset[$x]['topic_type'];
if($topic_type == POST_ANNOUNCE)
{
$topic_type = $lang['Annoucement'] . " ";
}
else if($topic_type == POST_STICKY)
{
$topic_type = $lang['Sticky'] . " ";
}
else
{
$topic_type = "";
}
$topic_id = $topic_rowset[$x]['topic_id'];
$replies = $topic_rowset[$x]['topic_replies'];
if($replies > $board_config['posts_per_page'])
{
$goto_page = " (![](\"".$images['posticon']."\")
" . $lang['Goto_page'] .": ";
$times = 1;
for($i = 0; $i < ($replies + 1); $i += $board_config['posts_per_page'])
{
if($times > 4)
{
if(($i + $board_config['posts_per_page']) >= ($replies + 1))
{
$goto_page.=" ... $times";
}
}
else
{
if($times != 1)
{
$goto_page.= ", ";
}
$goto_page.= "$times";
}
$times++;
}
$goto_page.= ")";
}
else
{
$goto_page = "";
}
// if($userdata['user_id'] != ANONYMOUS)
// {
// $folder_image = (isset($unread_topic_list[$forum_id][$topic_id])) ? "![](\"".$images['new_folder']."\")
" : "![](\"".$images['folder']."\")
";
// }
// else
// {
if($userdata['session_start'] == $userdata['session_time'])
{
$folder_image = ($topic_rowset[$x]['post_time'] > $userdata['session_last_visit']) ? "" : "";
}
else
{
$folder_image = ($topic_rowset[$x]['post_time'] > $userdata['session_time'] - 300) ? "" : "";
}
// }
$view_topic_url = append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=" . $topic_id . "&" . $replies);
$topic_poster = stripslashes($topic_rowset[$x]['username']);
$topic_poster_profile_url = append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL."=" . $topic_rowset[$x]['user_id']);
$last_post_time = create_date($board_config['default_dateformat'], $topic_rowset[$x]['post_time'], $board_config['default_timezone']);
if($topic_rowset[$x]['id2'] == ANONYMOUS && $topic_rowset[$x]['post_username'] != '')
{
$last_post_user = $topic_rowset[$x]['post_username'];
}
else
{
$last_post_user = $topic_rowset[$x]['user2'];
}
$last_post = $last_post_time . "
by ";
$last_post .= "" . $last_post_user . " ";
$last_post .= "![\"View](\"")
";
$views = $topic_rowset[$x]['topic_views'];
$template->assign_block_vars("topicrow", array(
"FORUM_ID" => $forum_id,
"TOPIC_ID" => $topic_id,
"FOLDER" => $folder_image,
"TOPIC_POSTER" => $topic_poster,
"GOTO_PAGE" => $goto_page,
"REPLIES" => $replies,
"TOPIC_TITLE" => $topic_title,
"TOPIC_TYPE" => $topic_type,
"VIEWS" => $views,
"LAST_POST" => $last_post,
"U_VIEW_TOPIC" => $view_topic_url,
"U_TOPIC_POSTER_PROFILE" => $topic_poster_profile_url)
);
}
$s_auth_can = "You " . (($is_auth['auth_read']) ? "can" : "cannot" ) . " read posts in this forum
";
$s_auth_can .= "You " . (($is_auth['auth_post']) ? "can" : "cannot") . " add new topics to this forum
";
$s_auth_can .= "You " . (($is_auth['auth_reply']) ? "can" : "cannot") . " reply to posts in this forum
";
$s_auth_can .= "You " . (($is_auth['auth_edit']) ? "can" : "cannot") . " edit your posts in this forum
";
$s_auth_can .= "You " . (($is_auth['auth_delete']) ? "can" : "cannot") . " delete your posts in this forum
";
$template->assign_vars(array(
"PAGINATION" => generate_pagination("viewforum.$phpEx?".POST_FORUM_URL."=$forum_id&postdays=$post_days", $topics_count, $board_config['topics_per_page'], $start),
"ON_PAGE" => (floor($start/$board_config['topics_per_page'])+1),
"TOTAL_PAGES" => ceil($topics_count/$board_config['topics_per_page']),
"S_AUTH_LIST" => $s_auth_can,
"L_OF" => $lang['of'],
"L_PAGE" => $lang['Page'],
"L_GOTO_PAGE" => $lang['Goto_page'])
);
$template->pparse("body");
}
else
{
//
// This will be present in the templates
// at some future point when if...else
// constructs are available
//
message_die(GENERAL_MESSAGE, $lang['No_topics_post_one']);
}
include('includes/page_tail.'.$phpEx);
?>