()

|

get_var("SELECT comment_post_id FROM $tablecomments WHERE comment_id = $comment"); $authordata = get_userdata($wpdb->get_var("SELECT post_author FROM $tableposts WHERE id = $post_id")); if (($user_level > $authordata->user_level) or ($user_login == $authordata->user_login)) { $wpdb->query("DELETE FROM $tablecomments WHERE comment_id = $comment"); ++$i; } } echo ""; } if (isset($_GET['s'])) { $s = $wpdb->escape($_GET['s']); $comments = $wpdb->get_results("SELECT * FROM $tablecomments WHERE comment_author LIKE '%$s%' OR comment_author_email LIKE '%$s%' OR comment_author_url LIKE ('%$s%') OR comment_author_ip LIKE ('%$s%') OR comment_content LIKE ('%$s%') ORDER BY comment_date DESC"); } else { $comments = $wpdb->get_results("SELECT * FROM $tablecomments ORDER BY comment_date DESC "); // was LIMIT 20 } if ('view' == $mode) { if ($comments) { echo '

'; foreach ($comments as $comment) { $authordata = get_userdata($wpdb->get_var("SELECT post_author FROM $tableposts WHERE ID = $comment->comment_post_id")); $comment_status = wp_get_comment_status($comment->comment_id); if ('unapproved' == $comment_status) { echo '
1. '; } else { echo '
2. '; } ?>

   comment_author_email) { ?>| comment_author_email) { ?> | | IP:

   | $authordata->user_level) or ($user_login == $authordata->user_login)) { echo "comment_id."\">" . _LANG_EC_LINK_EDIT . ""; echo " | comment_post_id."&comment=".$comment->comment_id."\" onclick=\"return confirm('" . sprintf("You are about to delete this comment by \'%s\'\\n \'Cancel\' to stop, \'OK\' to delete.", $comment->comment_author) . "')\">" . _LANG_EC_LINK_DELETE . " - "; } // end if any comments to show // Get post title $post_title = $wpdb->get_var("SELECT post_title FROM $tableposts WHERE ID = $comment->comment_post_id"); $post_title = ('' == $post_title) ? "# $comment->comment_post_id" : $post_title; ?> |

'; } else { ?>
'; foreach ($comments as $comment) { $authordata = get_userdata($wpdb->get_var("SELECT post_author FROM $tableposts WHERE ID = $comment->comment_post_id")); $bgcolor = ('#eee' == $bgcolor) ? 'none' : '#eee'; ?>

*	' . _LANG_EFC_COM_NAME . '	' . _LANG_EFC_COM_MAIL . '	' . 'IP' . '	' . _LANG_EC_COM_EXCERPT . '	' . _LANG_WAF_CUSTOM_ACTION . '
$authordata->user_level) or ($user_login == $authordata->user_login)) { ?>						$authordata->user_level) or ($user_login == $authordata->user_login)) { echo "" . _LANG_EC_LINK_EDIT . ""; } ?>	$authordata->user_level) or ($user_login == $authordata->user_login)) { echo "comment_post_id."&comment=".$comment->comment_id."\" onclick=\"return confirm('" . sprintf("You are about to delete this comment by \'%s\'\\n \'Cancel\' to stop, \'OK\' to delete.", $comment->comment_author) . "')\" class='delete'>" . _LANG_EC_LINK_DELETE . ""; } ?>