【php开源代码栏目提醒】:网学会员php开源代码为您提供view_threads.php参考,解决您在view_threads.php学习中工作中的难题,参考学习。
<?
/* Redirect if this file is called directly */
$file_name = "view_forums.php";
/* Get the negative length of $file_name */
$file_name_length = -(strlen($file_name));
/* Check if the values match, if so, redirect */
if (substr($_SERVER['SCRIPT_NAME'], $file_name_length) == $file_name)
header("Location: ../index.php");
/* 首先获取所有论坛版信息*/
$SQL = "SELECT forum_id FROM " . TABLE_PREFIX . "forums;";
$results = ExeSQL($SQL);
/* 将所有论坛版块编号保存到一个数组中 */
while ($row = mysql_fetch_array($results))
$forum_list[] = $row["forum_id"];
/* 如果论坛不存在,则停止*/
if (!in_array($forum_id, $forum_list))
{
/* Tell the user what's up */
echo " <CENTER class=\"error_message\">论坛不存在 !</CENTER><BR>\n";
require ("./content/view_forums.php");
return;
}
/* 开始显示表格 */
echo " <TABLE width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n"
. " <TR>\n";
/* 从论坛数据库中读取数据 */
$SQL = "SELECT * FROM " . TABLE_PREFIX . "forums WHERE forum_id='$forum_id';";
$results = ExeSQL($SQL);
/*读取并显示*/
while ($row = mysql_fetch_array($results))
echo " <TD class=\"regular_text\"><A href=\"?pid=view_forums\">" . BOARD_NAME . "</A> > " . $row["forum_name"]."</TD>\n";
/* 获取论坛总文章数量 */
$SQL = "SELECT COUNT(*) AS any_threads FROM " . TABLE_PREFIX . "threads WHERE forum_id='$forum_id';";
$results = ExeSQL($SQL);
/* 获取文章发表 */
while ($row = my
sql_fetch_array($results))
$any_threads = $row["any_threads"];
/* 显示发表文章连接,如果已经有文章*/
if ($any_threads != 0)
{
/* 显示发表新文章连接 */
echo " <TD align=\"right\" class=\"regular_text\"><A href=\"?pid=post_thread&forum_id=$forum_id\">Post New Thread</A></TD>\n"
. " </TR>\n"
. " </TABLE>\n"
. " <BR>\n";
/* 显示表格头 */
echo " <TABLE cellspacing=\"0\" cellpadding=\"5\" width=\"100%\" border class=\"table_border\">\n"
. " <TR class=\"table_header\">\n"
. " <TD width=\"100%\">Thread</TD>\n"
. " <TD align=\"center\" width=\"1\">Author</TD>\n"
. " <TD align=\"center\" width=\"1\">Replies</TD>\n"
. " <TD width=\"\" nowrap>Posted on</TD>\n"
. " </TR>\n";
/* 从论坛文章
列表中获取每个帖子的信息,按照时间进行排序*/
$SQL = "SELECT *, DATE_FORMAT(thread_time, '%W, %M %e, %Y %r') AS nice_time, DATE_FORMAT(thread_time, '%Y-%m-%d') AS post_date FROM " . TABLE_PREFIX . "threads WHERE forum_id='$forum_id' ORDER BY thread_time DESC;";
$results = ExeSQL($SQL);
/*获取数据并显示 */
while ($row =
mysql_fetch_array($results))
{
/*获取时间*/
$current_date = strftime ("%Y-%m-%d", time());
/* 获取文章编号和用户编号 */
$thread_id = $row["thread_id"];
$user_id = $row["user_id"];
/* 获取每篇文章的回复数量 */
$SQL = "SELECT COUNT(*) AS total_items FROM " . TABLE_PREFIX . "replies WHERE thread_id='$thread_id';";
$results2 = ExeSQL($SQL);
/* 将数据保存到数组 */
while ($row2 = mysql_fetch_array($results2))
$total_items = $row2["total_items"];
/* 显示回复文章数 */
if ($total_items == "")
$total_replies = "--";
else
$total_replies = $total_items;
/* 根据用户编号来获取用户名称 */
$SQL = "SELECT * FROM " . TABLE_PREFIX . "users WHERE user_id='$user_id';";
$results2 = ExeSQL($SQL);
/* 获取数据 */
while ($row2 = mysql_fetch_array($results2))
$the_user = $row2["user_name"];
/* 根据文章的热门程度,显示不同的图标 */
if ( $row["post_date"] == $current_date && $total_replies >= 25 )
$which_image = "folder-blue-fire";
else if ( $row["post_date"] == $current_date )
$which_image = "folder-blue";
else if ( $total_replies >= 25 )
$which_image = "folder-yellow-fire";
else
$which_image = "folder-yellow";
/* 显示具体信息 */
echo " <TR>\n"
. " <TD bgcolor=\"" . TABLE_COLOR_1 . "\" class=\"regular_text\">\n"
. " <IMG src=\"./images/$which_image.png\"> <A href=\"?pid=view_replies&thread_id=" . $row["thread_id"] . "&forum_id=$forum_id\">" . $row["thread_title"] . "</A>\n"
. " </TD>\n"
. " <TD bgcolor=\"" . TABLE_COLOR_2 . "\" align=\"center\" nowrap class=\"small_text\">\n"
. " <A href=\"?pid=view_profile&user=" . $the_user . "\">" . $the_user . "</A>\n"
. " </TD>\n"
. " <TD bgcolor=\"" . TABLE_COLOR_1 . "\" align=\"center\" class=\"regular_text\">\n"
. " " . $total_replies . "\n"
. " </TD>\n"
. " <TD bgcolor=\"" . TABLE_COLOR_2 . "\" nowrap class=\"small_text\">\n"
. " " . $row["nice_time"] . "\n"
. " </TD>\n"
. " </TR>\n";
}
/* 文章图标说明信息 */
echo " </TABLE>\n"
. " <BR>\n"
. " <FONT class=\"small_text\">\n"
. " <IMG src=\"./images/folder-yellow.p