标题增加评论管理MOD(完善版)
日期:2008-01-22    作者:FlyDa|cityreader   来源:
文章打印自: PHP学习之家
访问文章完全地址: http://www.444p.com/mod/phparticle/aid2560/
头部广告
增加评论管理MOD(完善版)
想知道访客都评论了些什么,一篇文章一篇文章的看吗,加上这个MOD就方便多了!代码很简单,不知道有人发过没有
1.在admin/comment.php里查找
$cachesorts = cachesorts();

cpheader();


在其后加入:

//---------------------评论管理代码开始 by FlyDa---------------------
if ($_GET[action]=="list") {
   $nav = new buildNav;
   $total = $DB->fetch_one_array("SELECT COUNT(*) AS count FROM ".$db_prefix."comment AS comment");
   $nav->total_result = $total[count];
   if (empty($total[count])) {
       pa_exit("到目前为止还没有任何评论");
   }
   $nav->execute("SELECT * FROM ".$db_prefix."comment AS comment ORDER BY lastupdate DESC");
   echo $nav->pagenav();
   echo "<table boder=0 width=100% cellpadding=4 cellspacing=1 class=tableoutline>
          <form action=comment.php method=post>
              <tr align=center class=tbhead>
               <td nowrap> id# </td>
               <td width=30%> 标题 </td>
               <td nowrap> 作者 </td>
               <td width=30%> 文章 </td>
               <td nowrap> 最后更新日期 </td>
               <td nowrap> 点击 </td>
               <td nowrap> 回复 </td>
               <td nowrap> 编辑 </td>
               <td nowrap> 删除 </td>
              </tr>";
   while ($comment = $DB->fetch_array($nav->sql_result)){
   $article = validate_articleid($comment[articleid]);
          echo "<tr class=".getrowbg().">
                     <td align=center nowrap>$comment[commentid]</td>
                     <td><a target=_blank href=../message.php?action=view&commentid=$comment[commentid]>$comment[title]</a></td>
                     <td align=center nowrap> $comment[author]</td>
                     <td><a target=_blank href=../article.php?articleid=$comment[articleid]>$article[title]</td>
                     <td align=center nowrap>".date("Y-m-d H:i:s",$comment[lastupdate])."</td>
                     <td align=center nowrap>$comment[views]</td>
                     <td align=center nowrap><a href=message.php?action=edit&commentid=$comment[commentid]>$comment[replies]</a></td>
                     <td align=center nowrap> [<a href=comment.php?action=mod&commentid=$comment[commentid]>编辑</a>] [<a href=comment.php?action=kill&commentid=$comment[commentid]>删除</a>]</td>
                     <td align=center><input type=checkbox name=comment[] value=$comment[commentid]></td>
                    </tr>";
   }
   echo "<tr class=tbhead>
               <td align=center colspan=9>
               <input type=hidden name=articleid value=$articleid>
               <input type=hidden name=action value=deleteselected>
               <input type=submit name=deletecomments value=删除所有选中的评论 class=bginput>
               <input type=submit name=deleteallcomments value=删除本文章的所有评论 class=bginput>
               </td>
             </tr>";
   echo "</form>";
   echo "</table>";
   echo $nav->pagenav();
}
// ---------------------评论管理代码结束---------------------

2.在admin/menu.php中查找:

makenav("文章管理",0,array('查看分类'=>'article.php?action=list',
                           '添加文章'=>'article.php?action=add',
                           '审批文章'=>'article.php?action=validate',
                           '最后更新'=>'article.php?action=edit',


其后加入
                           '评论管理'=>'comment.php?action=list',



3.在admin/comment.php中查找到(该步由cityreader编写):

if ($_GET[action] == "edit") {
$articleid = intval($_GET[articleid]);

$article = validate_articleid($articleid);

if (!empty($article)) {
$cpforms->tableheader();
echo "<tr class=" . getrowbg() . ">
<td>导航: <a href=\"./article.php?action=list\">根分类</a>" . buildsortnav($article[sortid]) . " \ <a href=\"comment.php?action=edit&articleid=$article[articleid]\">$article[title]</a> \ 评论</td>
</tr>";
$cpforms->tablefooter();
echo "<br>";
}

$nav = new buildNav;

$total = $DB->fetch_one_array("SELECT COUNT(*) AS count FROM " . $db_prefix . "comment WHERE articleid='$articleid'");

$nav->total_result = $total[count];

if (empty($total[count])) {
pa_exit("该文章还没有任何评论");
}

$nav->execute("SELECT * FROM " . $db_prefix . "comment WHERE articleid='$articleid' ORDER BY lastupdate DESC");

echo $nav->pagenav();

echo "<table boder=\"0\" width=\"100%\" cellpadding=\"4\" cellspacing=\"1\" class=\"tableoutline\">
<form action=\"comment.php\" method=\"post\">
<tr align=\"center\" class=\"tbhead\">
<td nowrap> id# </td>
<td width=\"60%\"> 标题 </td>
<td nowrap> 作者 </td>
<td nowrap> 日期 </td>
<td nowrap> 点击 </td>
<td nowrap> 回复 </td>
<td nowrap> 编辑 </td>
<td nowrap> 删除 </td>
</tr>\n";
while ($comment = $DB->fetch_array($nav->sql_result)) {
echo "<tr class=" . getrowbg() . ">
<td align=\"center\" nowrap>$comment[commentid]</td>
<td><a target=_blank href=\"../message.php?action=view&commentid=$comment[commentid]\">$comment[title]</a></td>
<td align=\"center\" nowrap> $comment[author]</td>
<td align=\"center\" nowrap>" . date("Y-m-d H:i:s", $comment[date]) . "</td>
<td align=\"center\" nowrap>$comment[views]</td>
<td align=\"center\" nowrap><a href=\"message.php?action=edit&commentid=$comment[commentid]\">$comment[replies]</a></td>
<td align=\"center\" nowrap> [<a href=\"comment.php?action=mod&commentid=$comment[commentid]\">编辑</a>] [<a href=\"comment.php?action=kill&commentid=$comment[commentid]\">删除</a>]</td>
<td align=\"center\"><input type=\"checkbox\" name=\"comment[]\" value=\"$comment[commentid]\"></td>
</tr>\n";
}
echo "<tr class=\"tbhead\">
<td align=\"center\" colspan=\"8\">
<input type=\"hidden\" name=\"articleid\" value=\"$articleid\">
<input type=\"hidden\" name=\"action\" value=\"deleteselected\">
<input type=\"submit\" name=\"deletecomments\" value=\"删除所有选中的评论\" class=\"bginput\">
<input type=\"submit\" name=\"deleteallcomments\" value=\"删除本文章的所有评论\" class=\"bginput\">
</td>
</tr>";
echo "</form>";
echo "</table>\n";

echo $nav->pagenav();
}

if ($_GET[action] == "mod") {
$commentid = intval($_GET[commentid]);
$comment = validate_commentid($commentid);
$cpforms->formheader(array('title' => "编辑评论: $comment[title]"));
$cpforms->makeinput(array('text' => '评论标题:',
'name' => 'title',
'value' => $comment[title]));
$cpforms->makehidden(array('name' => 'commentid',
'value' => $commentid));
$cpforms->makehidden(array('name' => 'action',
'value' => 'update'));
$cpforms->formfooter();
}
if ($_POST[action] == "update") {
$commentid = intval($_POST[commentid]);
$comment = validate_commentid($commentid);
$DB->query("UPDATE " . $db_prefix . "comment SET
title='" . addslashes(htmlspecialchars(trim($_POST[title]))) . "'
WHERE commentid='$commentid'");

redirect("./comment.php?action=edit&articleid=$comment[articleid]", "该评论已更新");
}

替换为

 

if ($_GET[action] == "edit") {
       $articleid = intval($_GET[articleid]);

       $article = validate_articleid($articleid);

       if (!empty($article)) {
               $cpforms->tableheader();
               echo "<tr class=" . getrowbg() . ">
                <td>导航: <a href=\"./article.php?action=list\">根分类</a>" . buildsortnav($article[sortid]) . " \ <a href=\"comment.php?action=edit&articleid=$article[articleid]\">$article[title]</a> \ 评论</td>
             </tr>";
               $cpforms->tablefooter();
               echo "<br>";
       }

       $nav = new buildNav;

       $total = $DB->fetch_one_array("SELECT COUNT(*) AS count FROM " . $db_prefix . "comment WHERE articleid='$articleid'");

       $nav->total_result = $total[count];

       if (empty($total[count])) {
               pa_exit("该文章还没有任何评论");
       }

       $nav->execute("SELECT * FROM " . $db_prefix . "comment WHERE articleid='$articleid' ORDER BY lastupdate DESC");

       echo $nav->pagenav();

       echo "<table boder=\"0\" width=\"100%\" cellpadding=\"4\" cellspacing=\"1\" class=\"tableoutline\">
          <form action=\"comment.php\" method=\"post\">
              <tr align=\"center\" class=\"tbhead\">
               <td nowrap> id# </td>
               <td width=30%> 标题 </td>
               <td nowrap> 作者 </td>
            <td width=30%> 文章 </td>
               <td nowrap> 日期 </td>
               <td nowrap> 点击 </td>
               <td nowrap> 回复 </td>
               <td nowrap> 编辑 </td>
               <td nowrap> 删除 </td>
              </tr>\n";
       while ($comment = $DB->fetch_array($nav->sql_result)) {
               echo "<tr class=" . getrowbg() . ">
                     <td align=\"center\" nowrap>$comment[commentid]</td>
                     <td><a target=_blank href=\"../message.php?action=view&commentid=$comment[commentid]\">$comment[title]</a></td>
                     <td align=\"center\" nowrap> $comment[author]</td>
                     <td><a target=_blank href=../article.php?articleid=$comment[articleid]>$article[title]</td>
                     <td align=\"center\" nowrap>" . date("Y-m-d H:i:s", $comment[date]) . "</td>
                     <td align=\"center\" nowrap>$comment[views]</td>
                     <td align=\"center\" nowrap><a href=\"message.php?action=edit&commentid=$comment[commentid]\">$comment[replies]</a></td>
                     <td align=\"center\" nowrap> [<a href=\"comment.php?action=mod&commentid=$comment[commentid]\">编辑</a>] [<a href=\"comment.php?action=kill&commentid=$comment[commentid]\">删除</a>]</td>
                     <td align=\"center\"><input type=\"checkbox\" name=\"comment[]\" value=\"$comment[commentid]\"></td>
                    </tr>\n";
       }
       echo "<tr class=\"tbhead\">
               <td align=\"center\" colspan=\"9\">
               <input type=\"hidden\" name=\"articleid\" value=\"$articleid\">
               <input type=\"hidden\" name=\"action\" value=\"deleteselected\">
               <input type=\"submit\" name=\"deletecomments\" value=\"删除所有选中的评论\" class=\"bginput\">
               <input type=\"submit\" name=\"deleteallcomments\" value=\"删除本文章的所有评论\" class=\"bginput\">
               </td>
             </tr>";
       echo "</form>";
       echo "</table>\n";

       echo $nav->pagenav();
}

if ($_GET[action] == "mod") {
       $commentid = intval($_GET[commentid]);
       $comment = validate_commentid($commentid);
       $messages = $DB->fetch_one_array("SELECT commentid,title,messageid,message FROM " . $db_prefix . "message
                                        WHERE commentid='$commentid'");
       $cpforms->formheader(array('title' => "编辑评论: $comment[title]"));
       $cpforms->makeinput(array('text' => '评论标题:',
                       'name' => 'title',
                       'value' => $comment[title]));
       $cpforms->maketextarea(array('text' => '评论内容:<br>可以使用html代码',
                       'name' => 'message',
                       'value' => $messages[message],
                       'html' => 1));
       $cpforms->makehidden(array('name' => 'commentid',
                       'value' => $commentid));
       $cpforms->makehidden(array('name' => 'action',
                       'value' => 'update'));
       $cpforms->formfooter();
}

if ($_POST[action] == "update") {
$commentid = intval($_POST[commentid]);
$comment = validate_commentid($commentid);
$DB->query("UPDATE " . $db_prefix . "comment SET
title='" . addslashes(htmlspecialchars(trim($_POST[title]))) . "'
WHERE commentid='$commentid'");
$DB->query("UPDATE " . $db_prefix . "message SET
title='" . addslashes(htmlspecialchars(trim($_POST[title]))) . "',
message='" . addslashes(trim($_POST[message])) . "'
WHERE commentid='$commentid'");
redirect("./comment.php?action=edit&articleid=$comment[articleid]", "该评论已更新");
}


(完毕,pa201和pa206都可以安装)
责任编辑:semirock