edit-comments.php

在综合英文版XOOPS 2.09, 2.091, 2.092 的基础上正式发布XOOPS 2.09中文版 XOOPS 2.09x 版主要是PHP5升级、bug修正和安全补正： 1 全面兼容PHP 5.

<?php
$title = '编辑评论';
$parent_file = 'edit.php';
require_once('admin-header.php');

$showcomments = intval($_GET['showcomments']);
$comment_per_page = intval($_GET['comments_per_page']);
$commentstart = intval($_GET['commentstart']);
$commentend = intval($_GET['commentend']);
$commentorder = $_GET['commentorder'];

if (!$showcomments) {
	if ($comments_per_page) {
		$showcomments=$comments_per_page;
	} else {
		$showcomments=10;
		$comments_per_page=$showcomments;
	}
} else {
	$comments_per_page = $showcomments;
}

if ((!empty($commentstart)) && (!empty($commentend)) && ($commentstart == $commentend)) {
	$p=$commentstart;
	$commentstart=0;
	$commentend=0;
}

if (!$commentstart) {
	$commentstart=0;
	$commentend=$showcomments;
}

$nextXstart=$commentend;
$nextXend=$commentend+$showcomments;

$previousXstart=($commentstart-$showcomments);
$previousXend=$commentstart;
if ($previousXstart < 0) {
	$previousXstart=0;
	$previousXend=$showcomments;
}

ob_start();
?>
<ul id="adminmenu2">
	<li><a href="edit.php"><?php echo _LANG_E_LATEST_POSTS; ?></a></li>
	<li><a href="edit-comments.php" class="current"><?php echo _LANG_E_LATEST_COMMENTS; ?></a></li>
	<li class="last"><a href="moderation.php"><?php echo _LANG_E_AWAIT_MODER; ?></a></li>
</ul>

<div class="wrap">
<table width="100%">
  <tr>
    <td valign="top" width="200">
      <?php echo _LANG_EC_SHOW_COM; ?>
    </td>
    <td>
      <table cellpadding="0" cellspacing="0" border="0">
        <tr>
          <td colspan="2" align="center"><!-- show next/previous X comments -->
            <form name="previousXcomments" method="get" action="">
<?php
if ($previousXstart >= 0) {
?>
              <input type="hidden" name="showcomments" value="<?php echo $showcomments; ?>" />
              <input type="hidden" name="commentstart" value="<?php echo $previousXstart; ?>" />
              <input type="hidden" name="commentend" value="<?php echo $previousXend; ?>" />
              <input type="submit" name="submitprevious" value="< <?php echo $showcomments ?>" />
<?php
}
?>
            </form>
          </td>
          <td>
            <form name="nextXcomments" method="get" action="">
              <input type="hidden" name="showcomments" value="<?php echo $showcomments; ?>" />
              <input type="hidden" name="commentstart" value="<?php echo $nextXstart; ?>" />
              <input type="hidden" name="commentend" value="<?php echo $nextXend; ?>" />
              <input type="submit" name="submitnext" value="<?php echo $showcomments ?> >" />
            </form>
          </td>
        </tr>
      </table>
    </td>
  </tr>
  <tr>
    <td valign="top" width="200"><!-- show X first/last comments -->
      <form name="showXfirstlastcomments" method="get" action="">
        <input type="text" name="showcomments" value="<?php echo $showcomments ?>" style="width:40px;" /?>
<?php
if (empty($commentorder))
  $commentorder="DESC";
$i = $commentorder;
if ($i == "DESC")
 $besp_selected = "selected='selected'";
?>
        <select name="commentorder">
          <option value="DESC" <?php echo $besp_selected ?>>最后一个</option>
<?php
$besp_selected = "";
if ($i == "ASC")
$besp_selected = "selected='selected'";
?>
          <option value="ASC" <?php echo $besp_selected?>>第一个</option>
        </select>&nbsp;
        <input type="submit" name="submitfirstlast" value="确定" />
      </form>
    </td>
    <td valign="top"><!-- show comment X to comment X -->
      <form name="showXfirstlastcomments" method="get" action="">
        <input type="text" name="commentstart" value="<?php echo $commentstart ?>" style="width:40px;" /?>&nbsp;to&nbsp;<input type="text" name="commentend" value="<?php echo $commentend ?>" style="width:40px;" /?>&nbsp;
        <select name="commentorder">
<?php
$besp_selected = "";
$i = $commentorder;
if ($i == "DESC")
  $besp_selected = "selected='selected'";
?>
          <option value="DESC" "<?php echo $besp_selected ?>">从最后</option>
<?php
$besp_selected = "";
if ($i == "ASC")
  $besp_selected = "selected='selected'";
?>        <option value="ASC" "<?php echo $besp_selected ?>">从开始</option>
        </select>&nbsp;
        <input type="submit" name="submitXtoX" value="确定" />
      </form>
    </td>
  </tr>
</table>
</div>
<?php
$comments_nav_bar = ob_get_contents();
ob_end_clean();
echo $comments_nav_bar;
?>

<div class="wrap">

	<?php
	$comments = $wpdb->get_results("SELECT * FROM {$wpdb->comments}
									ORDER BY comment_date $commentorder
									LIMIT $commentstart, $commentend"
	                              );

// need to account for offet, etc.

	if ($comments) {
		echo '<ol>';
		foreach ($comments as $comment) {
			$comment_status = wp_get_comment_status($comment->comment_ID);
			if ('unapproved' == $comment_status) {
				echo '<li class="unapproved" style="border-bottom: 1px solid #ccc;">';
			} else {
				echo '<li style="border-bottom: 1px solid #ccc;">';
			}
		?>
		<p><strong>作者:</strong> <?php comment_author() ?> <?php if ($comment->comment_author_email) { ?>| <strong>Email:</strong> <?php comment_author_email_link() ?> <?php } if ($comment->comment_author_email) { ?> | <strong>URI:</strong> <?php comment_author_url_link() ?> <?php } ?>| <strong>IP:</strong> <a href="http://ws.arin.net/cgi-bin/whois.pl?queryinput=<?php comment_author_IP() ?>"><?php comment_author_IP() ?></a></p>

		<?php comment_text() ?>
		<p>发表于 <?php comment_date() ?> | <?php
			if (($user_level > $authordata->user_level) or ($user_login == $authordata->user_login)) {
				echo "<a href=\"post.php?action=editcomment&amp;comment=".$comment->comment_ID."\">编辑评论</a>";
				echo " | <a href=\"post.php?action=deletecomment&amp;p=".$comment->comment_post_ID."&amp;comment=".$comment->comment_ID."\" onclick=\"return confirm('要删除\'".$comment->comment_author."\'的评论\\n选择\'取消\'或\'确定\'')\">删除评论</a> &#8212; ";
			} // end if any comments to show
			// Get post title
			$post_title = $wpdb->get_var("SELECT post_title FROM {$wpdb->posts} WHERE ID = $comment->comment_post_ID");
			$post_title = ('' == $post_title) ? "# $comment->comment_post_ID" : $post_title;
			?> <a href="post.php?action=edit&amp;post=<?php echo $comment->comment_post_ID; ?>"><?php echo _LANG_EC_EDIT_POST; ?> [<?php echo stripslashes($post_title); ?>]</a> | <a href="<?php echo get_permalink($comment->comment_post_ID); ?>"><?php echo _LANG_EC_VIEW_POST; ?></a></p>
		</li>

		<?php
		} // end foreach
	echo '</ol>';
	} else {

		?>
		<p>
		<strong><?php echo _LANG_E_RESULTS_FOUND; ?></strong>
		</p>

		<?php
	} // end if ($comments)

	?>

</div>

<?php
echo $comments_nav_bar;
include('admin-footer.php');
?>