aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/viewtopic.php
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/viewtopic.php')
-rw-r--r--phpBB/viewtopic.php136
1 files changed, 67 insertions, 69 deletions
diff --git a/phpBB/viewtopic.php b/phpBB/viewtopic.php
index ebedb1b5c3..e93da664f5 100644
--- a/phpBB/viewtopic.php
+++ b/phpBB/viewtopic.php
@@ -1,48 +1,48 @@
<?php
-/***************************************************************************
+/***************************************************************************
* viewtopic.php
- * -------------------
- * begin : Saturday, Feb 13, 2001
- * copyright : (C) 2001 The phpBB Group
- * email : support@phpbb.com
- *
- * $Id$
- *
- *
- ***************************************************************************/
-
-/***************************************************************************
- *
- * This program is free software; you can redistribute it and/or modify
- * it under the terms of the GNU General Public License as published by
- * the Free Software Foundation; either version 2 of the License, or
- * (at your option) any later version.
- *
- *
- ***************************************************************************/
-include('extension.inc');
+ * -------------------
+ * begin : Saturday, Feb 13, 2001
+ * copyright : (C) 2001 The phpBB Group
+ * email : support@phpbb.com
+ *
+ * $Id$
+ *
+ *
+ ***************************************************************************/
+
+/***************************************************************************
+ *
+ * This program is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation; either version 2 of the License, or
+ * (at your option) any later version.
+ *
+ *
+ ***************************************************************************/
+ include('extension.inc');
include('common.'.$phpEx);
$is_moderator = 0;
if(!isset($forum_id) || !isset($topic_id))
{
- error_die($db, GENERAL_ERROR, "You have reached this page in error, please go back and try again");
+ error_die($db, GENERAL_ERROR, "You have reached this page in error, please go back and try again");
}
-$sql = "SELECT f.forum_type, u.username, u.user_id
- FROM ".FORUMS_TABLE." f, ".FORUM_MODS_TABLE." fm, ".USERS_TABLE." u
- WHERE f.forum_id = '$forum_id'
- AND fm.forum_id = '$forum_id'
- AND u.user_id = fm.user_id";
+$sql = "SELECT f.forum_type, f.forum_name, u.username, u.user_id
+ FROM ".FORUMS_TABLE." f, ".FORUM_MODS_TABLE." fm, ".USERS_TABLE." u
+ WHERE f.forum_id = '$forum_id'
+ AND fm.forum_id = '$forum_id'
+ AND u.user_id = fm.user_id";
if(!$result = $db->sql_query($sql))
-{
+{
error_die($db, QUERY_ERROR);
}
//
// Add checking for private forums here
-//
+//
if(!$total_rows = $db->sql_numrows($result))
{
@@ -50,6 +50,7 @@ if(!$total_rows = $db->sql_numrows($result))
}
$forum_row = $db->sql_fetchrowset($result);
+$forum_name = stripslashes($forum_row[0]["forum_name"]);
for($x = 0; $x < $total_rows; $x++)
{
$moderators[] = array("user_id" => $forum_row[$x]["user_id"],
@@ -64,19 +65,18 @@ if(!isset($start))
{
$start = 0;
}
-$sql = "SELECT t.topic_title, t.topic_status, t.topic_replies, f.forum_name
- FROM ".TOPICS_TABLE." t, ".FORUMS_TABLE." f
- WHERE t.topic_id = '$topic_id' AND f.forum_id = t.forum_id";
+$sql = "SELECT topic_title, topic_status, topic_replies
+ FROM ".TOPICS_TABLE."
+ WHERE topic_id = '$topic_id'";
if(!$result = $db->sql_query($sql))
{
- error_die($db, QUERY_ERROR);
+ error_die($db, QUERY_ERROR);
}
if(!$topic_info = $db->sql_fetchrowset($result))
{
- error_die($db, GENERAL_ERROR, "Could not get topic data<br>$sql");
+ error_die($db, GENERAL_ERROR, "Could not get topic data<br>$sql");
}
-$forum_name = stripslashes($topic_info[0]["forum_name"]);
$topic_title = stripslashes($topic_info[0]["topic_title"]);
$total_replies = $topic_info[0]["topic_replies"] + 1;
@@ -84,14 +84,15 @@ $pagetype = "viewtopic";
$page_title = "View Topic - $topic_title";
include('page_header.'.$phpEx);
-$sql = "SELECT u.*, r.rank_title, r.rank_image,
- p.post_time, p.post_id, pt.post_text
- FROM ".POSTS_TABLE." p
- LEFT JOIN ".USERS_TABLE." u ON p.poster_id = u.user_id
- LEFT JOIN ".RANKS_TABLE." r ON (u.user_rank = r.rank_id) AND NOT (u.user_posts > r.rank_min AND u.user_posts < r.rank_max)
- LEFT JOIN ".POSTS_TEXT_TABLE." pt ON p.post_id = pt.post_id
- WHERE p.topic_id = '$topic_id'
- ORDER BY p.post_time ASC LIMIT $start, $posts_per_page";
+$sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_icq, u.user_aim, u.user_yim,
+ u.user_regdate, u.user_msnm, u.user_viewemail, r.rank_title, r.rank_image,
+ p.post_time, p.post_id, pt.post_text
+ FROM ".POSTS_TABLE." p
+ LEFT JOIN ".USERS_TABLE." u ON p.poster_id = u.user_id
+ LEFT JOIN ".RANKS_TABLE." r ON (u.user_rank = r.rank_id) AND NOT (u.user_posts > r.rank_min AND u.user_posts < r.rank_max)
+ LEFT JOIN ".POSTS_TEXT_TABLE." pt ON p.post_id = pt.post_id
+ WHERE p.topic_id = '$topic_id'
+ ORDER BY p.post_time ASC LIMIT $start, $posts_per_page";
if(!$result = $db->sql_query($sql))
{
@@ -99,20 +100,20 @@ if(!$result = $db->sql_query($sql))
}
if(!$total_posts = $db->sql_numrows($result))
{
- error_die($db, GENERAL_ERROR, "Error getting post data.");
+ error_die($db, GENERAL_ERROR, "Error getting post data.");
}
$postrow = $db->sql_fetchrowset($result);
$template->set_block("body", "postrow", "posts");
-for($x = 0; $x < $total_posts; $x++)
+for($x = 0; $x < $total_posts; $x++)
{
$poster = stripslashes($postrow[$x]["username"]);
$poster_id = $postrow[$x]["user_id"];
$poster_rank = stripslashes($postrow[$x]["rank_title"]);
$rank_image = ($postrow[$x]["rank_image"]) ? "<img src=\"".$postrow[$x]["rank_image"]."\">" : "";
$post_date = date($date_format, $postrow[$x]["post_time"]);
-
+
$poster_posts = $postrow[$x]["user_posts"];
$poster_from = ($postrow[$x]["user_from"]) ? "$l_from: ".$postrow[$x]["user_from"] : "";
$poster_joined = $postrow[$x]["user_regdate"];
@@ -132,18 +133,18 @@ for($x = 0; $x < $total_posts; $x++)
$icq_add_img = "";
}
$aim_img = ($postrow[$x]["user_aim"]) ? "<a href=\"aim:goim?screenname=".$postrow[$x]["user_aim"]."&message=Hello+Are+you+there?\"><img src=\"$image_aim\" border=\"0\"></a>" : "";
- $msn_img = ($postrow[$x]["user_msn"]) ? "<a href=\"profile.$phpEx?mode=viewprofile&user_id=$poster_id\"><img src=\"$image_msn\" border=\"0\"></a>" : "";
+ $msn_img = ($postrow[$x]["user_msnm"]) ? "<a href=\"profile.$phpEx?mode=viewprofile&user_id=$poster_id\"><img src=\"$image_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=\"$image_yim\" border=\"0\"></a>" : "";
-
+
$edit_img = "<a href=\"posting.$phpEx?mode=editpost&post_id=".$postrow[$x]["post_id"]."&topic_id=$topic_id&forum_id=$forum_id\"><img src=\"$image_edit\" alt=\"$l_editdelete\" border=\"0\"></a>";
$quote_img = "<a href=\"posting.$phpEx?mode=reply&quote=true&post_id=".$postrow[$x]["post_id"]."&topic_id=$topic_id&forum_id=$forum_id\"><img src=\"$image_quote\" alt=\"$l_replyquote\" border=\"0\"></a>";
$pmsg_img = "<a href=\"priv_msgs.$phpEx?mode=send\"><img src=\"$image_pmsg\" alt=\"$l_sendpmsg\" border=\"0\"></a>";
- if($is_moderator)
+ if($is_moderator)
{
$ip_img = "<a href=\"topicadmin.$phpEx?mode=viewip&user_id=".$poster_id."\"><img src=\"$image_ip\" alt=\"$l_viewip\" border=\"0\"></a>";
$delpost_img = "<a href=\"topicadmin.$phpEx?mode=delpost$post_id=".$postrow[$x]["post_id"]."\"><img src=\"$image_delpost\" alt=\"$l_delete\" border=\"0\"></a>";
}
-
+
$message = stripslashes($postrow[$x]["post_text"]);
if(!$allow_html)
{
@@ -153,7 +154,7 @@ for($x = 0; $x < $total_posts; $x++)
{
// do bbcode stuff here
}
-
+
if(!($x % 2))
{
$color = "#DDDDDD";
@@ -162,7 +163,7 @@ for($x = 0; $x < $total_posts; $x++)
{
$color = "#CCCCCC";
}
-
+
$message = eregi_replace("\[addsig]$", "<BR>_________________<BR>" . stripslashes($postrow[$x]["user_sig"]), $message);
$template->set_var(array("TOPIC_TITLE" => $topic_title,
@@ -193,44 +194,44 @@ for($x = 0; $x < $total_posts; $x++)
$template->parse("posts", "postrow", true);
}
-if($total_replies > $posts_per_page)
+if($total_replies > $posts_per_page)
{
$times = 0;
for($x = 0; $x < $total_replies; $x += $posts_per_page)
- {
+ {
$times++;
}
$pages = $times . " pages";
-
+
$times = 1;
$pagination = "$l_gotopage (";
-
+
$last_page = $start - $posts_per_page;
- if($start > 0)
+ if($start > 0)
{
$pagination .= "<a href=\"$PHP_SELF?topic_id=$topic_id&forum_id=$forum_id&start=$last_page\">$l_prevpage</a> ";
}
- for($x = 0; $x < $total_replies; $x += $posts_per_page)
+ for($x = 0; $x < $total_replies; $x += $posts_per_page)
{
- if($times != 1)
+ if($times != 1)
{
$pagination .= " | ";
}
- if($start && ($start == $x))
+ if($start && ($start == $x))
{
$pagination .= $times;
}
- else if($start == 0 && $x == 0)
+ else if($start == 0 && $x == 0)
{
$pagination .= "1";
}
- else
+ else
{
$pagination .= "<a href=\"$PHP_SELF?topic_id=$topic_id&forum_id=$forum_id&start=$x\">$times</a>";
}
- $times++;
- }
- if(($start + $posts_per_page) < $total_replies)
+ $times++;
+ }
+ if(($start + $posts_per_page) < $total_replies)
{
$next_page = $start + $posts_per_page;
$pagination .= " <a href=\"$PHP_SELF?topic_id=$topic_id&forum_id=$forum_id&start=$next_page\">$l_nextpage</a>";
@@ -245,9 +246,6 @@ $template->set_var(array("PAGES" => $pages,
"PAGINATION" => $pagination));
$template->pparse("output", array("posts", "body"));
-include('page_tail.'.$phpEx);
-
-
-
+include('page_tail.'.$phpEx);
?>
generated by cgit v1.2.1 (git 2.21.0) at 2025-10-10 20:44:03 +0000