📄 re_news.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/function_page_02.php" );
echo "<html>\r\n<head>\r\n<title>新闻评论</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n";
if ( !$_REQUEST['cur_page'] )
{
$cur_page = 1;
}
else
{
$cur_page = $_REQUEST['cur_page'];
}
echo "<s";
echo "cript>\r\nfunction delete_all(NEWS_ID,COMMENT_ID)\r\n{\r\n\tmsg\t=\t\"确定要删除所有评论吗？\";\r\n\tif(window.confirm(msg))\r\n\t{\r\n\t\turl\t=\t\"delete.php?NEWS_ID=\"+ NEWS_ID +\"&update=delete_all&MANAGE=";
echo $_REQUEST['MANAGE'];
echo "&cur_page=";
echo $cur_page;
echo "\";\r\n\t\twindow.location\t= url;\r\n\t}\r\n}\r\n\r\nfunction deletes(COMMENT_ID, NEWS_ID, MANAGE)\r\n{\r\n\tmsg = '确认要删除该评论吗？'; \r\n\tif(window.confirm(msg)) \r\n\t{\r\n\t\turl\t= \"delete.php?update=deletes&COMMENT_ID=\"+ COMMENT_ID +\"&NEWS_ID=\"+ NEWS_ID +\"&MANAGE=\"+ MANAGE +\"&cur_page=";
echo $cur_page;
echo "\";\r\n\t\twindow.location\t= url;\r\n\t}\r\n}\r\n\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( );
if ( $NEWS_ID )
{
$query = "SELECT * from NEWS where NEWS_ID={$NEWS_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$NEWS_ID = $ROW['NEWS_ID'];
$SUBJECT = $ROW['SUBJECT'];
$NEWS_TIME = $ROW['NEWS_TIME'];
$PROVIDER = $ROW['PROVIDER'];
}
}
echo "<table width=100% border=0 cellspacing=0 cellpadding=0>\r\n <tr height=\"40\">\r\n <td align=center>原文标题：<a href=\"read_news.php?NEWS_ID=";
echo $NEWS_ID;
echo "\">\r\n ";
echo $SUBJECT;
echo " </a>\r\n ";
echo $NEWS_TIME;
echo "\t ";
if ( $_SESSION['LOGIN_USER_ID'] == "admin" || $_SESSION['LOGIN_USER_ID'] == $PROVIDER )
{
echo " 【<a href=\"javascript:delete_all(";
echo $NEWS_ID;
echo ");\">删除全部评论</a>】\r\n\t ";
}
echo "</td>\r\n </tr>\r\n</table>\r\n<p>\r\n ";
$connection = openconnection( );
if ( $NEWS_ID )
{
$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=\"100%\" cellpadding=\"5\" cellspacing=\"1\" align=\"center\" class=\"small\">\r\n <tr>\r\n <td class=\"TableLine1\"><img src=\"/images/green_arrow.gif\">发表评论： </td>\r\n </tr>\r\n <tr>\r\n <td align=\"center\" class=\"TableLine2\"><textarea cols=\"60\" name=\"CONTENT\" rows=\"5\" class=\"BigInput\" wrap=\"on\"";
echo "></textarea>\r\n </td>\r\n </tr>\r\n <tr align=\"center\">\r\n <td><input type=\"hidden\" value=\"";
echo $NEWS_ID;
echo "\" name=\"NEWS_ID\">\r\n <input type=\"submit\" value=\"发表\" class=\"BigButton\" >\r\n \r\n <input type=\"button\" value=\"关闭\" class=\"BigButton\" onClick=\"javascript:window.close();\"> </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;
}
$COUNT = 0;
$query = "SELECT * from NEWS_COMMENT where NEWS_ID={$NEWS_ID} order by RE_TIME desc";
$query = page( $query, 5 );
$cursor = exequery( $connection, $query );
echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"small\">\r\n <tr>\r\n <td class=\"TableLine2\" align=\"right\">";
disp( "NEWS_ID=".$NEWS_ID."&MANAGE=".$_REQUEST['MANAGE']."" );
echo "</td>\r\n </tr>\r\n</table>\r\n<table width=100% border=0 cellspacing=0 cellpadding=0 align=\"center\" class=\"small\">\r\n <tr class=\"TableLine1\">\r\n <td> 相关评论\r\n ";
echo $COMMENT_COUNT;
echo " 条</td>\r\n </tr>\r\n</table>\r\n<table width=100% border=0 cellspacing=0 cellpadding=0 >\r\n <tr>\r\n <td height=3 bgcolor=#ffffff></td>\r\n </tr>\r\n</table>\r\n";
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 width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"5\" cellspacing=\"1\" class=\"small\">\r\n <tr class=\"TableLine2\">\r\n <td > 回复人：\r\n ";
echo $USER_NAME;
echo " 发表时间：\r\n ";
echo $RE_TIME;
echo " </td>\r\n <td align=\"right\">";
if ( $MANAGE == 1 && $_SESSION['LOGIN_USER_ID'] == $PROVIDER )
{
echo " 【<a href=\"javascript:deletes(";
echo $COMMENT_ID;
echo ", ";
echo $NEWS_ID;
echo ", ";
echo $MANAGE;
echo ");\" style=\"text-decoration:underline\">删除</a>】 \r\n ";
}
echo " 【<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>】</td>\r\n </tr>\r\n <tr height=\"40\" class=\"TableLine1\">\r\n <td colspan=\"2\">";
if ( $PARENT_ID != 0 )
{
echo " <br>\r\n <b>原贴：</b>\r\n ";
echo $CONTENT1;
echo " <hr width=\"95%\" style=\"border:1pt dotted #666666;\">\r\n \r\n ";
}
echo $CONTENT;
echo "</td>\r\n </tr>\r\n</table>\r\n<br>\r\n";
}
}
echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"small\">\r\n <tr>\r\n <td class=\"TableLine1\" align=\"right\">";
disp( "NEWS_ID=".$NEWS_ID."&MANAGE=".$_REQUEST['MANAGE']."" );
echo "</td>\r\n </tr>\r\n</table>\r\n<form action=\"submit.php\" method=\"post\" name=\"form1\" onSubmit=\"return CheckForm();\">\r\n <table border=\"0\" width=\"100%\" cellpadding=\"5\" cellspacing=\"1\" align=\"center\" class=\"small\">\r\n <tr>\r\n <td class=\"TableHeader\"> 发表评论： </td>\r\n </tr>\r\n <tr>\r\n <td align=\"center\" class=\"TableData\"><textarea cols=\"60\" name=\"CONTENT\" rows=\"5\" class=\"BigInput\" wrap=\"on\"></textarea";
echo ">\r\n </td>\r\n </tr>\r\n <tr align=\"center\">\r\n <td><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 \r\n <input type=\"button\" value=\"关闭\" class=\"BigButton\" onClick=\"javascript:window.close();\"> </td>\r\n </tr>\r\n </table>\r\n</form>\r\n";
if ( 0 < ( $n = $_REQUEST['cur_page'] - $total_page_nums ) )
{
$cur_page = $_REQUEST['cur_page'] - $n;
header( "location:".$_SERVER['PHP_SELF']."?&order=".$_REQUEST['order']."&sens=".$_REQUEST['sens']."&cur_page=".$cur_page );
}
echo "</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -