-

-if(!isset($HTTP_GET_VARS['topic'])) // For backward compatibility

-else

-{

- $topic_id = $HTTP_GET_VARS['topic'];

-}

-$start = (isset($HTTP_GET_VARS['start'])) ? $HTTP_GET_VARS['start'] : 0;

-

-$is_moderator = 0;

-// This is the single/double 'integrated'

-// query to obtain the next/previous

-// topic from just the current topic_id

-// We will make this word, if it's the last thing I

-// do ... and it quite possibly will be!

-/*

-if(isset($HTTP_GET_VARS['view']))

- if($HTTP_GET_VARS['view'] == 'newer')

- $operator = ">";

- else if($HTTP_GET_VARS['view'] == 'older')

- $operator = "<";

- switch($dbms)

- case 'mysql':

- // And now the stupid MySQL case...I wish they would get around to implementing subselectes...

- $sub_query = "SELECT topic_time

- FROM ".TOPICS_TABLE."

- WHERE topic_id = $topic_id";

- if($sub_result = $db->sql_query($sub_query))

- {

- $resultset = $db->sql_fetchrowset($sub_result);

- $sql = "SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies,

- f.forum_type, f.forum_name, f.forum_id, u.username, u.user_id

- FROM ".TOPICS_TABLE." t, ".FORUMS_TABLE." f, ".FORUM_MODS_TABLE." fm, ".USERS_TABLE." u

- WHERE t.topic_time ".$operator." ".$resultset[0]['topic_time']."

- AND f.forum_id = ".$HTTP_GET_VARS[POST_FORUM_URL]."

- AND f.forum_id = t.forum_id

- AND fm.forum_id = t.forum_id

- AND u.user_id = fm.user_id";

- $db->sql_freeresult($sub_result);

- }

- else

- {

- if(DEBUG)

- {

- $dberror = $db->sql_error();

- error_die(SQL_QUERY, "Couldn't obtain topic information.<br>Reason: ".$dberror['message']."<br>Query: $sql", __LINE__, __FILE__);

- }

- else

- {

- error_die(SQL_QUERY, "Couldn't obtain topic information.", __LINE__, __FILE__);

- }

- }

- break;

- default:

- $sql = "SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies,

- f.forum_type, f.forum_name, f.forum_id, u.username, u.user_id

- FROM ".TOPICS_TABLE." t, ".FORUMS_TABLE." f, ".FORUM_MODS_TABLE." fm, ".USERS_TABLE." u

- WHERE t.topic_id in

- (select max(topic_id) from ".TOPICS_TABLE." WHERE topic_time ".$operator." (select topic_time as t_time from ".TOPICS_TABLE." where topic_id = $topic_id))

- AND f.forum_id = ".$HTTP_GET_VARS[POST_FORUM_URL]."

- AND f.forum_id = t.forum_id

- AND fm.forum_id = t.forum_id

- AND u.user_id = fm.user_id";

- break;

-// End.

-else

-{

-*/

- //

- // This is perhaps a bodged(?) way of allowing a direct link to a post

- // it also allows calculation of which page the post should be on. This

- // query no longer grabs moderator info for this forum ... right now

- // that's fine, but if needed it can be easily replaced/added

- //

- $join_sql_table = (!isset($post_id)) ? "" : "" . POSTS_TABLE . " p, " . POSTS_TABLE . " p2,";

- $join_sql = (!isset($post_id)) ? "t.topic_id = $topic_id" : "p.post_id = $post_id AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_id <= $post_id";

- $count_sql = (!isset($post_id)) ? "" : ", COUNT(p2.post_id) AS prev_posts";

-

- $order_sql = (!isset($post_id)) ? "" : "GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, f.forum_name, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_votecreate, f.auth_vote, f.auth_attachments ORDER BY p.post_id ASC";

- $sql = "SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, f.forum_name, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_votecreate, f.auth_vote, f.auth_attachments" . $count_sql . "

- FROM $join_sql_table " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f

- WHERE $join_sql

- AND f.forum_id = t.forum_id

- $order_sql";

-

-// This closes out the opening braces above

-// Needed for the view/next query

-//}

- message_die(GENERAL_MESSAGE, $lang['Topic_post_not_exist'], "", __LINE__, __FILE__, $sql);

- // Ooopss, user is not authed

- // to read this forum ...

- include('includes/page_header.'.$phpEx);

-

- $msg = "I am sorry but only " . $is_auth['auth_read_type'] . " can read this topic.";

-// 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

-for($x = 0; $x < $total_rows; $x++)

-{

- $moderators[] = array(

- "user_id" => $forum_row[$x]['user_id'],

- "username" => $forum_row[$x]['username']);

-

- if($userdata['user_id'] == $forum_row[$x]['user_id'])

- {

- $is_moderator = 1;

- }

-}

-

-//

-// Get next and previous topic_id's

-//

-$sql_next_id = "SELECT topic_id

- FROM ".TOPICS_TABLE."

- WHERE topic_time > $topic_time

- AND forum_id = $forum_id

- ORDER BY topic_time ASC

- LIMIT 1";

-

-$sql_prev_id = "SELECT topic_id

- FROM ".TOPICS_TABLE."

- WHERE topic_time < $topic_time

- AND forum_id = $forum_id

- ORDER BY topic_time DESC

- LIMIT 1";

-

-$result_next = $db->sql_query($sql_next_id);

-$result_prev = $db->sql_query($sql_prev_id);

-$topic_next_row = $db->sql_fetchrow($result_next);

-$topic_prev_row = $db->sql_fetchrow($result_prev);

-

- FROM ".POSTS_TABLE." p, ".USERS_TABLE." u, ".POSTS_TEXT_TABLE." pt

- //

- // Again this should be considered temporary and

- // will appear in the templates file at some

- // point

- //

- FROM ".RANKS_TABLE."

- ORDER BY rank_min";

-// Dump out the page header and

-// load viewtopic body template

-$view_prev_topic_url = (!empty($topic_prev_row['topic_id'])) ? append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=" . $topic_prev_row['topic_id']) : "";

-$view_next_topic_url = (!empty($topic_next_row['topic_id'])) ? append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=" . $topic_next_row['topic_id']) : "";

- "L_POSTED" => $l_posted,

- "U_POST_NEW_TOPIC" => $new_topic_url,

-$sql = "UPDATE ".TOPICS_TABLE."

-for($x = 0; $x < $total_posts; $x++)

- $poster = stripslashes($postrow[$x]['username']);

- $poster_id = $postrow[$x]['user_id'];

- $post_date = create_date($board_config['default_dateformat'], $postrow[$x]['post_time'], $board_config['default_timezone']);

- $poster_posts = ($postrow[$x]['user_id'] != ANONYMOUS) ? $lang['Posts'] . ": " . $postrow[$x]['user_posts'] : "";

- $poster_from = ($postrow[$x]['user_from'] && $postrow[$x]['user_id'] != ANONYMOUS) ? $lang['From'] . ": " .$postrow[$x]['user_from'] : "";

- $poster_joined = ($postrow[$x]['user_id'] != ANONYMOUS) ? $lang['Joined'] . ": " . create_date($board_config['default_dateformat'], $postrow[$x]['user_regdate'], $board_config['default_timezone']) : "";

- $poster_avatar = ($postrow[$x]['user_avatar'] != "" && $userdata['user_id'] != ANONYMOUS) ? "<img src=\"".$board_config['avatar_path']."/".$postrow[$x]['user_avatar']."\">" : "";

- if(empty($postrow[$x]['user_rank']) && $postrow[$x]['user_id'] != ANONYMOUS)

- for($i = 0; $i < count($ranksrow); $i++)

- if($poster_posts > $ranksrow[$i]['rank_min'] && $poster_posts < $ranksrow[$i]['rank_max'])

- $poster_rank = $ranksrow[$i]['rank_title'];

- $rank_image = ($ranksrow[$i]['rank_image']) ? "<img src=\"".$ranksrow[$i]['rank_image']."\">" : "";

- if(!empty($postrow[$x]['user_rank']))

- for($i = 0; $i < count($ranksrow); $i++)

- if($postrow[$x]['user_rank'] == $ranksrow[$i]['rank_special'])

- {

- $poster_rank = $ranksrow[$i]['rank_title'];

- $rank_image = ($ranksrow[$i]['rank_image']) ? "<img src=\"".$ranksrow[$i]['rank_image']."\">" : "";

- }

- if($poster_id == ANONYMOUS && $postrow[$x]['post_username'] != '')

- $poster = stripslashes($postrow[$x]['post_username']);

- $email_img = ($postrow[$x]['user_viewemail'] == 1) ? "<a href=\"mailto:".$postrow[$x]['user_email']."\"><img src=\"".$images['email']."\" alt=\"$l_email $poster\" border=\"0\"></a>" : "";

- $www_img = ($postrow[$x]['user_website']) ? "<a href=\"".$postrow[$x]['user_website']."\"><img src=\"".$images['www']."\" alt=\"$l_viewsite\" border=\"0\"></a>" : "";

- if($postrow[$x]['user_icq'])

- $icq_status_img = "<a href=\"http://wwp.icq.com/".$postrow[$x]['user_icq']."#pager\"><img src=\"http://online.mirabilis.com/scripts/online.dll?icq=".$postrow[$x]['user_icq']."&img=5\" alt=\"$l_icqstatus\" border=\"0\"></a>";

- $icq_add_img = "<a href=\"http://wwp.icq.com/scripts/search.dll?to=".$postrow[$x]['user_icq']."\"><img src=\"".$images['icq']."\" alt=\"$l_icq\" border=\"0\"></a>";

-

- $aim_img = ($postrow[$x]['user_aim']) ? "<a href=\"aim:goim?screenname=".$postrow[$x]['user_aim']."&message=Hello+Are+you+there?\"><img src=\"".$images['aim']."\" border=\"0\"></a>" : "";

- $msn_img = ($postrow[$x]['user_msnm']) ? "<a href=\"profile.$phpEx?mode=viewprofile&".POST_USERS_URL."=$poster_id\"><img src=\"".$images['msn']."\" border=\"0\"></a>" : "";

- $yim_img = ($postrow[$x]['user_yim']) ? "<a href=\"http://edit.yahoo.com/config/send_webmesg?.target=".$postrow[$x]['user_yim']."&.src=pg\"><img src=\"".$images['yim']."\" border=\"0\"></a>" : "";

- if($x == 0)

- $edit_post_url = append_sid("posting.$phpEx?mode=editpost&".POST_POST_URL."=".$postrow[$x]['post_id']."&".POST_TOPIC_URL."=$topic_id&".POST_FORUM_URL."=$forum_id&is_first_post=1");

- $edit_post_url = append_sid("posting.$phpEx?mode=editpost&".POST_POST_URL."=".$postrow[$x]['post_id']."&".POST_TOPIC_URL."=$topic_id&".POST_FORUM_URL."=$forum_id");

- $quote_img = "<a href=\"".append_sid("posting.$phpEx?mode=reply&quote=true&".POST_POST_URL."=".$postrow[$x]['post_id']."&".POST_TOPIC_URL."=$topic_id&".POST_FORUM_URL."=$forum_id")."\"><img src=\"".$images['quote']."\" alt=\"$l_replyquote\" border=\"0\"></a>";

- $delpost_img = "<a href=\"".append_sid("topicadmin.$phpEx?mode=delpost&".POST_POST_URL."=".$postrow[$x]['post_id'])."\"><img src=\"".$images['delpost']."\" alt=\"$l_delete\" border=\"0\"></a>";

- $post_subject = ($postrow[$x]['post_subject'] != "") ? stripslashes($postrow[$x]['post_subject']) : "Re: ".$topic_title;

- $bbcode_uid = $postrow[$x]['bbcode_uid'];

- $user_sig = stripslashes($postrow[$x]['user_sig']);

- $message = stripslashes($postrow[$x]['post_text']);

- if(!($x % 2))

- "U_POST_ID" => $postrow[$x]['post_id']));