📄 re_news.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
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\r\n</head>\r\n";
echo "<s";
echo "cript>\r\nfunction CheckForm()\r\n{\r\n if(document.form1.CONTENT.value==\"\")\r\n { alert(\"评论的内容不能为空！\");\r\n return (false);\r\n }\r\n return (true);\r\n}\r\n</script>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
$connection = openconnection( );
$query = "SELECT * from NEWS where NEWS_ID={$NEWS_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$SUBJECT = $ROW['SUBJECT'];
}
echo "<table width=100% border=0 cellspacing=0 cellpadding=0>\r\n <tr height=\"40\">\r\n <td align=center>";
echo "<s";
echo "pan class=\"big3\">原文 </span><a href=\"read_news.php?NEWS_ID=";
echo $NEWS_ID;
echo "\" style=\"TEXT-DECORATION:underline\">";
echo "<s";
echo "pan class=\"big3\">";
echo $SUBJECT;
echo "</span></a></span></td>\r\n </tr>\r\n</table>\r\n\r\n";
$connection = openconnection( );
$query = "SELECT count(*) from NEWS_COMMENT where NEWS_ID={$NEWS_ID}";
$cursor = exequery( $connection, $query );
$COMMENT_COUNT = 0;
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$COMMENT_COUNT = $ROW[0];
}
if ( $COMMENT_COUNT == 0 )
{
message( "", "暂无评论" );
echo "<form action=\"submit.php\" method=\"post\" name=\"form1\" onsubmit=\"return CheckForm();\">\r\n <table border=\"0\" width=\"95%\" cellpadding=\"2\" cellspacing=\"1\" align=\"center\" bgcolor=\"#000000\" class=\"small\">\r\n <tr>\r\n <td class=\"TableHeader\">\r\n <img src=\"/images/green_arrow.gif\">发表评论：\r\n </td>\r\n </tr>\r\n <tr>\r\n <td align=\"center\" class=\"TableData\">\r\n <textarea cols=\"60\" name=";
echo "\"CONTENT\" rows=\"5\" class=\"BigInput\" wrap=\"on\"></textarea>\r\n </td>\r\n </tr>\r\n <tr align=\"center\" class=\"TableControl\">\r\n <td nowrap>\r\n <input type=\"hidden\" value=\"";
echo $NEWS_ID;
echo "\" name=\"NEWS_ID\">\r\n <input type=\"submit\" value=\"发表\" class=\"BigButton\"> \r\n <input type=\"button\" value=\"关闭\" class=\"BigButton\" onClick=\"javascript:window.close();\">\r\n </td>\r\n </tr>\r\n </table>\r\n</form>\r\n";
exit( );
}
$PER_PAGE = 10;
$PAGES = 10;
$PAGE_COUNT = ceil( $COMMENT_COUNT / $PER_PAGE );
if ( $CUR_PAGE <= 0 || $CUR_PAGE == "" )
{
$CUR_PAGE = 1;
}
if ( $PAGE_COUNT < $CUR_PAGE )
{
$CUR_PAGE = $PAGE_COUNT;
}
echo "<table width=95% border=0 cellspacing=0 cellpadding=0 align=\"center\" class=\"small\">\r\n <tr class=\"TableContent\">\r\n <td> 相关评论 ";
echo $COMMENT_COUNT;
echo " 条</td>\r\n <td align=\"right\">\r\n <a href=\"re_news.php?NEWS_ID=";
echo $NEWS_ID;
echo "&MANAGE=";
echo $MANAGE;
echo "\" style=\"text-decoration:underline\">首页</a> \r\n <a href=\"re_news.php?NEWS_ID=";
echo $NEWS_ID;
echo "&CUR_PAGE=";
echo $PAGE_COUNT;
echo "&MANAGE=";
echo $MANAGE;
echo "\" style=\"text-decoration:underline\">末页</a> \r\n";
if ( $CUR_PAGE % $PAGES == 0 )
{
$J = $PAGES;
}
else
{
$J = $CUR_PAGE % $PAGES;
}
if ( $PAGES < $CUR_PAGE )
{
echo " <a href=\"re_news.php?NEWS_ID=";
echo $NEWS_ID;
echo "&CUR_PAGE=";
echo $CUR_PAGE - $J - $PAGES + 1;
echo "&MANAGE=";
echo $MANAGE;
echo "\" style=\"text-decoration:underline\">上";
echo $PAGES;
echo "页</a> \r\n";
}
$I = $CUR_PAGE - $J + 1;
for ( ; $I <= $CUR_PAGE - $J + $PAGES; ++$I )
{
if ( $PAGE_COUNT < $I )
{
}
else if ( $I == $CUR_PAGE )
{
echo " [";
echo $I;
echo "] \r\n";
}
else
{
echo " [<a href=\"re_news.php?NEWS_ID=";
echo $NEWS_ID;
echo "&CUR_PAGE=";
echo $I;
echo "&MANAGE=";
echo $MANAGE;
echo "\" style=\"text-decoration:underline\">";
echo $I;
echo "</a>] \r\n";
}
}
echo " \r\n";
if ( $I - 1 < $PAGE_COUNT )
{
echo " <a href=\"re_news.php?NEWS_ID=";
echo $NEWS_ID;
echo "&CUR_PAGE=";
echo $I;
echo "&MANAGE=";
echo $MANAGE;
echo "\" style=\"text-decoration:underline\">下";
echo $PAGES;
echo "页</a> \r\n";
}
if ( 1 <= $CUR_PAGE - 1 )
{
echo " <a href=\"re_news.php?NEWS_ID=";
echo $NEWS_ID;
echo "&CUR_PAGE=";
echo $CUR_PAGE - 1;
echo "&MANAGE=";
echo $MANAGE;
echo "\" style=\"text-decoration:underline\">上一页</a> \r\n";
}
else
{
echo " 上一页 \r\n";
}
if ( $CUR_PAGE + 1 <= $PAGE_COUNT )
{
echo " <a href=\"re_news.php?NEWS_ID=";
echo $NEWS_ID;
echo "&CUR_PAGE=";
echo $CUR_PAGE + 1;
echo "&MANAGE=";
echo $MANAGE;
echo "\" style=\"text-decoration:underline\">下一页</a> \r\n";
}
else
{
echo " 下一页 \r\n";
}
echo " \r\n </td>\r\n </tr>\r\n</table>\r\n<table width=95% border=0 cellspacing=0 cellpadding=0 align=\"center\">\r\n\t<tr>\r\n\t <td height=3 bgcolor=#ffffff></td>\r\n\t</tr>\r\n</table>\r\n \r\n";
$COUNT = 0;
$query = "SELECT * from NEWS_COMMENT where NEWS_ID={$NEWS_ID} order by RE_TIME desc";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$COUNT;
if ( $COUNT < $CUR_PAGE * $PER_PAGE - $PER_PAGE + 1 )
{
}
else if ( $CUR_PAGE * $PER_PAGE < $COUNT )
{
}
else
{
$COMMENT_ID = $ROW['COMMENT_ID'];
$PARENT_ID = $ROW['PARENT_ID'];
$CONTENT = $ROW['CONTENT'];
$RE_TIME = $ROW['RE_TIME'];
$USER_ID = $ROW['USER_ID'];
$CONTENT = str_replace( "<", "<", $CONTENT );
$CONTENT = str_replace( ">", ">", $CONTENT );
$CONTENT = stripslashes( $CONTENT );
$CONTENT = str_replace( "\n", "<br>", $CONTENT );
$query = "SELECT * from USER where USER_ID='{$USER_ID}'";
$cursor1 = exequery( $connection, $query );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$USER_NAME = $ROW1['USER_NAME'];
$DEPT_ID = $ROW1['DEPT_ID'];
$DEPT_NAME = dept_long_name( $DEPT_ID );
}
$query = "SELECT * from NEWS_COMMENT where COMMENT_ID={$PARENT_ID}";
$cursor1 = exequery( $connection, $query );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$CONTENT1 = $ROW1['CONTENT'];
$CONTENT1 = str_replace( "<", "<", $CONTENT1 );
$CONTENT1 = str_replace( ">", ">", $CONTENT1 );
$CONTENT1 = stripslashes( $CONTENT1 );
$CONTENT1 = str_replace( "\n", "<br>", $CONTENT1 );
}
$query = "SELECT count(*) from NEWS_COMMENT where PARENT_ID={$COMMENT_ID}";
$cursor1 = exequery( $connection, $query );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$RELAY_COUNT = $ROW1[0];
}
echo " <table border=\"0\" width=\"95%\" cellpadding=\"0\" cellspacing=\"1\" align=\"center\" bgcolor=\"#1C599F\" class=\"small\">\r\n <tr>\r\n <td> \r\n <table border=\"0\" width=\"100%\" cellpadding=\"2\" cellspacing=\"0\" align=\"center\" bgcolor=\"#000000\" class=\"small\">\r\n <tr>\r\n <td class=\"TableControl\">\r\n <u title=\"部门：";
echo $DEPT_NAME;
echo "\" style=\"cursor:hand\">";
echo $USER_NAME;
echo "</u> 发表时间：";
echo $RE_TIME;
echo " </td>\r\n </tr>\r\n <tr height=\"40\">\r\n <td class=\"TableData\">\r\n ";
echo $CONTENT;
if ( $PARENT_ID != 0 )
{
echo " <br><hr width=\"95%\">\r\n <b>[原贴]</b><br>\r\n ";
echo $CONTENT1;
}
echo " </td>\r\n </tr>\r\n <tr>\r\n <td class=\"Tableline1\" align=\"right\">\r\n <a href=\"relay.php?COMMENT_ID=";
echo $COMMENT_ID;
echo "&NEWS_ID=";
echo $NEWS_ID;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "&MANAGE=";
echo $MANAGE;
echo "\" style=\"text-decoration:underline\">回复本贴</a> \r\n";
if ( $MANAGE == 1 )
{
echo " <a href=\"delete.php?COMMENT_ID=";
echo $COMMENT_ID;
echo "&NEWS_ID=";
echo $NEWS_ID;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "&MANAGE=";
echo $MANAGE;
echo "\" style=\"text-decoration:underline\">删除</a> \r\n";
}
echo " 回复数：";
echo $RELAY_COUNT;
echo " \r\n </td>\r\n </tr>\r\n </table>\r\n \r\n </td>\r\n </tr>\r\n </table>\r\n <table width=95% border=0 cellspacing=0 cellpadding=0 align=\"center\">\r\n \t<tr>\r\n \t <td height=3 bgcolor=#ffffff></td>\r\n \t</tr>\r\n </table>\r\n";
}
}
echo "<form action=\"submit.php\" method=\"post\" name=\"form1\" onsubmit=\"return CheckForm();\">\r\n <table border=\"0\" width=\"95%\" cellpadding=\"2\" cellspacing=\"1\" align=\"center\" bgcolor=\"#000000\" class=\"small\">\r\n <tr>\r\n <td class=\"TableHeader\">\r\n <img src=\"/images/green_arrow.gif\">发表评论：\r\n </td>\r\n </tr>\r\n <tr>\r\n <td align=\"center\" class=\"TableData\">\r\n <textarea cols=\"60\" name=";
echo "\"CONTENT\" rows=\"5\" class=\"BigInput\" wrap=\"on\"></textarea>\r\n </td>\r\n </tr>\r\n <tr align=\"center\" class=\"TableControl\">\r\n <td nowrap>\r\n <input type=\"hidden\" value=\"";
echo $NEWS_ID;
echo "\" name=\"NEWS_ID\">\r\n <input type=\"hidden\" value=\"";
echo $MANAGE;
echo "\" name=\"MANAGE\">\r\n <input type=\"submit\" value=\"发表\" class=\"BigButton\"> \r\n <input type=\"button\" value=\"关闭\" class=\"BigButton\" onClick=\"javascript:window.close();\">\r\n </td>\r\n </tr>\r\n </table>\r\n</form>\r\n</body>\r\n\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -