Comment Management

"; echo ""; echo "\n"; $x=1; // for row alternating colors $commentarray = "SELECT c.comment_id, c.comment_blog_id, c.comment_entry_id, c.comment_ip, c.comment_author, c.comment_email, c.comment_url, c.comment_text, b.blog_id, b.blog_name, b.blog_site_url, e.entry_id, e.entry_title FROM mt_comment c, mt_blog b, mt_entry e WHERE (c.comment_blog_id=b.blog_id) AND (c.comment_entry_id=e.entry_id) ORDER BY comment_id DESC LIMIT $start, $display"; $commentresult = mysql_query($commentarray); while ($row = mysql_fetch_array($commentresult)) { while (list($key,$value) = each($row)) { $$key=$value; } if (!empty($comment_url)) { $comment_url_trim = str_replace("http://", "", $comment_url); $comment_url_trim = str_replace("www.", "", $comment_url_trim); if (strlen($comment_url_trim) > 15) { $comment_url_trim = substr_replace($comment_url_trim, '…', 15); } } $comment_text = htmlentities($comment_text); $comment_text = str_replace(array(">", "<", """, "&"), array(">", "<", "\"", "&"), $comment_text); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; $x++; } echo "\n"; echo "

ID	Blog	Entry Title	Comment Author	Comment	edit	despam	ban
", $comment_id, "	", $blog_name, "	", $entry_title, "	"; if (!empty($comment_email)) { echo "", $comment_author, "";} else { echo $comment_author; } if (!empty($comment_url)) { echo " ", $comment_url_trim, "\n";} echo "	", $comment_text, "	edit	despam	blog ", $blog_id, "'s banlist ", $comment_ip, "
comment management script by kristine of virtualvenus. styles from mt-plugins by blogstyles.

"; echo "