📄 comment.php
字号:
<?php
function bbs_page( $page, $array )
{
global $cur_page;
if ( $array == NULL )
{
return true;
}
$new_array = @array_reverse( $array );
$page_size = sizeof( $new_array );
$count_page = array_chunk( $new_array, 20 );
$end_page = sizeof( $count_page ) - 1;
echo ( "<span style='color:#999999'>共<font style='color:#FF9900;'>".( $end_page + 1 ) )."</font>页</span> ";
echo ( "<span style='color:#999999'>当前第<font style='color:#FF9900;'>".( $cur_page + 1 ) )."</font>页</span> ";
if ( $page_size <= $page )
{
echo "<span style='color:#999999'>首页</span> ";
echo "<span style='color:#999999'>上一页</span> ";
echo "<span style='color:#999999'>下一页</span> ";
echo "<span style='color:#999999'>末页</span>";
return true;
}
else
{
if ( $cur_page != 0 )
{
echo "<a href='".$_SERVER['SCRIPT_NAME']."?BOARD_ID=".$_REQUEST['BOARD_ID']."&COMMENT_ID=".$_REQUEST['COMMENT_ID']."&PAGE_START=".$_REQUEST['PAGE_START']."'>首页</a> ";
echo ( "<a href='".$_SERVER['SCRIPT_NAME']."?cur_page=".( $cur_page - 1 ) )."&BOARD_ID=".$_REQUEST['BOARD_ID']."&COMMENT_ID=".$_REQUEST['COMMENT_ID']."&PAGE_START=".$_REQUEST['PAGE_START']."'>上一页</a> ";
}
else
{
echo "<span style='color:#999999'>首页</span> ";
echo "<span style='color:#999999'>上一页</span> ";
}
if ( $cur_page < $end_page )
{
echo ( "<a href='".$_SERVER['SCRIPT_NAME']."?cur_page=".( $cur_page + 1 ) )."&BOARD_ID=".$_REQUEST['BOARD_ID']."&COMMENT_ID=".$_REQUEST['COMMENT_ID']."&PAGE_START=".$_REQUEST['PAGE_START']."'>下一页</a> ";
echo "<a href='".$_SERVER['SCRIPT_NAME']."?cur_page=".$end_page."&BOARD_ID=".$_REQUEST['BOARD_ID']."&COMMENT_ID=".$_REQUEST['COMMENT_ID']."&PAGE_START=".$_REQUEST['PAGE_START']."'>末页</a>";
}
else
{
echo "<span style='color:#999999'>下一页</span> ";
echo "<span style='color:#999999'>末页</span>";
}
}
return true;
}
function recursionbbsc( $parentid, &$outstr, $prefixc, $BOARD_ID, $PAGE_START )
{
global $connection;
global $old_comment_id;
$sql = "SELECT * FROM BBS_COMMENT where BOARD_ID={$BOARD_ID} AND PARENT_ID={$parentid}";
$rs = exequery( $connection, $sql );
$count = 0;
while ( $ROW = mysql_fetch_array( $rs ) )
{
++$count;
$COMMENT_ID = $ROW['COMMENT_ID'];
$USER_ID = $ROW['USER_ID'];
$BOARD_ID = $ROW['BOARD_ID'];
$AUTHOR_NAME = $ROW['AUTHOR_NAME'];
$SUBJECT = $ROW['SUBJECT'];
$SUBMIT_TIME = $ROW['SUBMIT_TIME'];
$READ_CONT = $ROW['READ_CONT'];
$REPLY_CONT = $ROW['REPLY_CONT'];
$PARENT_ID = $ROW['PARENT_ID'];
$CONTENT = $ROW['CONTENT'];
$query2 = "select * from bbs_comment where COMMENT_ID=".$PARENT_ID;
$cursor2 = exequery( $connection, $query2 );
if ( $row2 = mysql_fetch_array( $cursor2 ) )
{
$comment_id2 = $row2['COMMENT_ID'];
$board_id2 = $row2['BOARD_ID'];
$subject2 = $row2['SUBJECT'];
$content2 = $row2['CONTENT'];
}
$query6 = "SELECT * from USER where USER_ID='{$USER_ID}'";
$cursor6 = exequery( $connection, $query6 );
if ( $ROW6 = mysql_fetch_array( $cursor6 ) )
{
$user_name2 = $ROW6['USER_NAME'];
}
$CONTENT_SIZE = strlen( $CONTENT );
$CONTENT_SIZE = number_format( $CONTENT_SIZE, 0, ".", "," );
$AUTHOR_NAME = str_replace( "<", "<", $AUTHOR_NAME );
$AUTHOR_NAME = str_replace( ">", ">", $AUTHOR_NAME );
$AUTHOR_NAME = stripslashes( $AUTHOR_NAME );
$SUBJECT = str_replace( "<", "<", $SUBJECT );
$SUBJECT = str_replace( ">", ">", $SUBJECT );
$SUBJECT = stripslashes( $SUBJECT );
$subjectstr = "<a href=\"comment.php?BOARD_ID={$BOARD_ID}&COMMENT_ID={$COMMENT_ID}&PAGE_START={$PAGE_START}\">\r\n ".substrgb( $SUBJECT, 50, "..." )."\r\n </a>";
$authorstr = $AUTHOR_NAME;
$consizestr = $CONTENT_SIZE;
$countreadstr = $READ_CONT;
$countreplaystr = $REPLY_CONT;
$datestr = "<span style='font-size:10px'>".date( "Y-m-d H:i", strtotime( $SUBMIT_TIME ) )."</span>";
$optionstr = "<a href=\"edit.php?title_revert2=title_revert2&r_type=comment&REPLY=1&BOARD_ID={$BOARD_ID}&COMMENT_ID={$COMMENT_ID}&PAGE_START={$PAGE_START}&BOARD_ID2=".$_REQUEST['BOARD_ID']."&COMMENT_ID2=".$_REQUEST['COMMENT_ID']."&PAGE_START2=".$_REQUEST['PAGE_START']."\">回复</a> ";
if ( $USER_ID == $_SESSION['LOGIN_USER_ID'] )
{
$optionstr .= "<a href=\"edit.php?title_edit2=title_edit2&r_type=comment&BOARD_ID={$BOARD_ID}&COMMENT_ID={$COMMENT_ID}&PAGE_START={$PAGE_START}&BOARD_ID2=".$_REQUEST['BOARD_ID']."&COMMENT_ID2=".$_REQUEST['COMMENT_ID']."&PAGE_START2=".$_REQUEST['PAGE_START']."\">编辑</a> ";
}
if ( $USER_ID == $_SESSION['LOGIN_USER_ID'] || $_SESSION['LOGIN_USER_ID'] == "admin" )
{
$optionstr .= "<a href=\"javascript:delete_comment({$COMMENT_ID}, ".$old_comment_id.");\">删除</a>";
}
$from_str = nl2br( $CONTENT );
if ( $_SESSION['LOGIN_USER_ID'] == "admin" )
{
$query3 = "select USER_NAME from user where USER_ID='".$USER_ID."'";
$cursor3 = exequery( $connection, $query3 );
if ( $row3 = mysql_fetch_row( $cursor3 ) )
{
$user_name = $row3[0];
}
$authorstr = $user_name;
}
if ( $_SESSION['LOGIN_USER_ID'] == "admin" )
{
if ( $user_name == $AUTHOR_NAME )
{
$author2 = $user_name;
}
else
{
$author2 = $user_name."(昵称：".$AUTHOR_NAME.")";
}
}
else
{
$author2 = $AUTHOR_NAME;
}
$outstr[] .= "\r\n\t\t<tr class=TableLine2>\r\n\t\t\t<td>回复人：{$author2}</td>\r\n\t\t\t<td>发表时间：{$datestr}</td>\r\n\t\t\t<td>字节：{$consizestr}</td>\r\n\t\t\t<td>{$optionstr}</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td colspan='4'> <b>标题：<a href=\"comment.php?BOARD_ID=".$BOARD_ID."&COMMENT_ID=".$COMMENT_ID."&PAGE_START=".$PAGE_START."\">".$SUBJECT."</a></b> <b>原贴：</b><a href=\"comment.php?BOARD_ID=".$board_id2."&COMMENT_ID=".$comment_id2."&PAGE_START=".$PAGE_START."\">".$subject2."</a><br><hr width='95%' style='border:1pt dotted #666666;'><br> {$from_str}</td>\r\n\t\t</tr>";
recursionbbsc( $COMMENT_ID, &$outstr, $prefixc, $BOARD_ID, $PAGE_START );
}
return $outstr;
}
include_once( "inc/conn.php" );
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
if ( $_REQUEST['cur_page'] == "" )
{
$cur_page = 0;
}
else
{
$cur_page = $_REQUEST['cur_page'];
}
$old_comment_id = $_REQUEST['COMMENT_ID'];
echo "\r\n<html>\r\n<head>\r\n<title>讨论区 - 读文章</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n";
echo "<s";
echo "cript>\r\nfunction delete_comment(COMMENT_ID, old_comment_id)\r\n{\r\n msg=\"确定要删除该回复吗?\";\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete.php?del_title=del_title&BOARD_ID=";
echo $BOARD_ID;
echo "&PAGE_START=";
echo $PAGE_START;
echo "&COMMENT_ID=\"+COMMENT_ID+\"&old_comment_id=\"+old_comment_id;\r\n window.location=URL;\r\n }\r\n}\r\n\r\nfunction delete_comment2(COMMENT_ID)\r\n{\r\n msg=\"确定要删除该文章吗?\";\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete.php?BOARD_ID=";
echo $BOARD_ID;
echo "&PAGE_START=";
echo $PAGE_START;
echo "&COMMENT_ID=\"+COMMENT_ID;\r\n window.location=URL;\r\n }\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$connection = openconnection( );
$query = "SELECT * from BBS_BOARD where BOARD_ID={$BOARD_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$DEPT_ID = $ROW['DEPT_ID'];
$BOARD_NAME = $ROW['BOARD_NAME'];
$ANONYMITY_YN = $ROW['ANONYMITY_YN'];
$BOARD_NAME = str_replace( "<", "<", $BOARD_NAME );
$BOARD_NAME = str_replace( ">", ">", $BOARD_NAME );
$BOARD_NAME = stripslashes( $BOARD_NAME );
}
$connection = openconnection( );
$query = "update BBS_COMMENT set READ_CONT=READ_CONT+1 where COMMENT_ID={$COMMENT_ID}";
$cursor = exequery( $connection, $query );
$query = "SELECT * from BBS_COMMENT where COMMENT_ID={$COMMENT_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$BOARD_ID = $ROW['BOARD_ID'];
$COMMENT_ID = $ROW['COMMENT_ID'];
$USER_ID = $ROW['USER_ID'];
$AUTHOR_NAME = $ROW['AUTHOR_NAME'];
$SUBJECT = $ROW['SUBJECT'];
$CONTENT = $ROW['CONTENT'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$SUBMIT_TIME = $ROW['SUBMIT_TIME'];
$REPLY_CONT = $ROW['REPLY_CONT'];
$READ_CONT = $ROW['READ_CONT'];
$AUTHOR_NAME = str_replace( "<", "<", $AUTHOR_NAME );
$AUTHOR_NAME = str_replace( ">", ">", $AUTHOR_NAME );
$AUTHOR_NAME = stripslashes( $AUTHOR_NAME );
$SUBJECT = str_replace( "<", "<", $SUBJECT );
$SUBJECT = str_replace( ">", ">", $SUBJECT );
$SUBJECT = stripslashes( $SUBJECT );
$CONTENT = str_replace( "<", "<", $CONTENT );
$CONTENT = str_replace( ">", ">", $CONTENT );
$CONTENT = stripslashes( $CONTENT );
$CONTENT = str_replace( "\n", "<br>", $CONTENT );
$CONTENT = str_replace( " ", " ", $CONTENT );
$query1 = "SELECT * from USER where USER_ID='{$USER_ID}'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$user_name = $ROW['USER_NAME'];
}
if ( $_SESSION['LOGIN_USER_ID'] == "admin" )
{
if ( $user_name == $AUTHOR_NAME )
{
$author = $user_name;
}
else
{
$author = $user_name."(昵称：".$AUTHOR_NAME.")";
}
}
else
{
$author = $AUTHOR_NAME;
}
}
echo "<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\" >\r\n <tr class=\"tablehead1\">\r\n <td><img src=\"/images/menu/bbs.gif\" align=\"absmiddle\"><a href=\"index.php\"> 讨论区</a> - <a href=\"board.php?BOARD_ID=";
echo $BOARD_ID;
echo "\">";
echo $BOARD_NAME;
echo " - 查看文章\r\n </td>\r\n </tr>\r\n <tr class=\"tablehead2\">\r\n <td>\r\n <a href=\"edit.php?title_revert=title_revert&r_type=comment&REPLY=1&BOARD_ID=";
echo $BOARD_ID;
echo "&COMMENT_ID=";
echo $COMMENT_ID;
echo "&PAGE_START=";
echo $PAGE_START;
echo "&BOARD_ID2=";
echo $_REQUEST['BOARD_ID'];
echo "&COMMENT_ID2=";
echo $_REQUEST['COMMENT_ID'];
echo "&PAGE_START2=";
echo $_REQUEST['PAGE_START'];
echo ";\"><img src=\"/images/button/revert.gif\" border=\"0\" title=\"回复此文章\"></a>\r\n <a href=\"edit.php?title_edit=title_edit&r_type=comment&BOARD_ID=";
echo $BOARD_ID;
echo "&COMMENT_ID=";
echo $COMMENT_ID;
echo "&PAGE_START=";
echo $PAGE_START;
echo "&BOARD_ID2=";
echo $_REQUEST['BOARD_ID'];
echo "&COMMENT_ID2=";
echo $_REQUEST['COMMENT_ID'];
echo "&PAGE_START2=";
echo $_REQUEST['PAGE_START'];
echo ";\">\r\n ";
if ( $LOGIN_USER_ID == $USER_ID )
{
echo " <img src=\"/images/button/edit.gif\" border=\"0\" title=\"编辑此文章\"></a>\r\n <a href=\"#\" onclick=\"delete_comment2('";
echo $COMMENT_ID;
echo "');\"> <img src=\"/images/button/del.gif\" border=\"0\" title=\"删除此文章\"></a>\r\n ";
}
echo " <a href=\"javascript:history.back()\"><img src=\"/images/button/return.gif\" border=\"0\"></a>\r\n </td>\r\n </tr>\r\n</table>\r\n<hr width=\"95%\" height=\"1\" align=\"left\" color=\"#ffffff\">\r\n <table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" cellpadding=\"5\">\r\n <tr>\r\n <td nowrap class=\"TableLine2\">标题:</td>\r\n <td class=\"TableLine1\" colspan='6'>";
echo $SUBJECT;
echo "</td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableLine2\">作者:</td>\r\n <td class=\"TableLine1\" colspan='6'>";
echo $author;
echo "</td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableLine2\">发表时间:</td>\r\n <td class=\"TableLine1\" colspan='6'>";
echo $SUBMIT_TIME;
echo "</td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableLine2\">状态:</td>\r\n <td nowrap class=\"TableLine1\" colspan='6'>回复 ";
echo $REPLY_CONT;
echo " 篇 阅读 ";
echo $READ_CONT;
echo " 次</td>\r\n </tr>\r\n </tr>\r\n";
if ( $ATTACHMENT_NAME != "" )
{
echo " <tr>\r\n <td class=\"TableLine1\" width=\"80\">附件：</td>\r\n <td class=\"TableLine1\" width=\"420\" colspan='6'>\r\n";
$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
if ( $ATTACHMENT_ID_ARRAY[$I] == "" )
{
}
else
{
$ATTACH_SIZE = attach_size( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
$ATTACH_SIZE = number_format( $ATTACH_SIZE, 0, ".", "," );
echo " <img src=\"/images/email_atta.gif\"><a href=\"/inc/attach.php?ATTACHMENT_ID=";
echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
echo "&ATTACHMENT_NAME=";
echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
echo "\">";
echo $ATTACHMENT_NAME_ARRAY[$I];
echo "</a> (";
echo $ATTACH_SIZE;
echo "字节)\r\n";
if ( stristr( $ATTACHMENT_NAME_ARRAY[$I], ".doc" ) || stristr( $ATTACHMENT_NAME_ARRAY[$I], ".ppt" ) || stristr( $ATTACHMENT_NAME_ARRAY[$I], ".xls" ) )
{
echo "\t <input type=\"button\" onClick=\"window.open('/iWebOffice/DocumentEdit.php?RecordID=";
echo $CONTENT_ID;
echo "&EditType=0&UserName=";
echo $_SESSION['LOGIN_USER_ID'];
echo ";&ATTACHMENT_ID=";
echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
echo "&ATTACHMENT_NAME=";
echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
echo "',null,'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');\" value=\"阅读\" class=\"SmallButton\"> \r\n";
}
echo "<br>";
}
}
echo " </td>\r\n </tr>\r\n";
}
echo " <tr>\r\n <td class=\"TableLine1\" colspan=\"7\" height=\"160\" valign=\"top\">";
echo $CONTENT;
echo "</td>\r\n </tr>\r\n\t<tr>\r\n\t\t<td class=\"TableLine2\" colspan=\"7\"><b>相关回复</b></td>\r\n\t</tr>\r\n\t";
if ( 0 < $COMMENT_ID )
{
$restr = recursionbbsc( $COMMENT_ID, $outstr, $prefixc, $BOARD_ID, $PAGE_START );
$array = $restr;
$new_restr = @array_reverse( $array );
$num_page = @array_chunk( $new_restr, 20 );
$i = 0;
for ( ; $i < sizeof( $num_page[$cur_page] ); ++$i )
{
echo $num_page[$cur_page][$i];
}
}
unset( $restr );
unset( $outstr );
echo " </table>\r\n <table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"5\">\r\n\t<tr>\r\n\t\t<td class=\"TableLine1\" nowrap align=\"right\">";
bbs_page( 1, $array );
echo "</td>\r\n\t</tr>\r\n</table>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -