![Ico: open in new window](" . APBCT_URL_PATH . "/inc/images/new_window.gif)
"
.""
.""
: '');
} else {
$column_content .= esc_html__( 'No email', 'cleantalk-spam-protect');
}
$column_content .= '"
.""
: '');
}else
$column_content .= esc_html__( 'No IP adress', 'cleantalk-spam-protect');
return $column_content;
}
function column_ct_comment( $item ){
$id = $item['ct_id'];
$column_content = '';
$column_content .= 'Approve', $_REQUEST['page'],'approve', $id ),
'spam' => sprintf( 'Spam', $_REQUEST['page'],'spam', $id ),
'trash' => sprintf( 'Trash', $_REQUEST['page'],'trash', $id ),
);
return sprintf( '%1$s %2$s', $column_content, $this->row_actions( $actions ) );
}
function column_ct_response_to( $item ) {
$post_id = $item['ct_response_to'];
?>
esc_html__( 'Mark as spam', 'cleantalk-spam-protect' ),
'trash' => esc_html__( 'Move to trash', 'cleantalk-spam-protect' ),
);
return $actions;
}
function bulk_actions_handler() {
if( empty($_POST['spamids']) || empty($_POST['_wpnonce']) ) return;
if ( ! $action = $this->current_action() ) return;
if( ! wp_verify_nonce( $_POST['_wpnonce'], 'bulk-' . $this->_args['plural'] ) )
wp_die('nonce error');
if( 'trash' == $action ) {
$this->moveToTrash( $_POST['spamids'] );
}
if( 'spam' == $action ) {
$this->moveToSpam( $_POST['spamids'] );
}
}
function row_actions_handler() {
if( empty($_GET['action']) ) return;
if( $_GET['action'] == 'approve' ) {
$id = filter_input( INPUT_GET, 'spam', FILTER_SANITIZE_NUMBER_INT );
$this->approveSpam( $id );
}
if( $_GET['action'] == 'trash' ) {
$id = filter_input( INPUT_GET, 'spam', FILTER_SANITIZE_NUMBER_INT );
$this->moveToTrash( array( $id ) );
}
if( $_GET['action'] == 'spam' ) {
$id = filter_input( INPUT_GET, 'spam', FILTER_SANITIZE_NUMBER_INT );
$this->moveToSpam( array( $id ) );
}
}
function no_items() {
esc_html_e( 'No spam found.', 'cleantalk-spam-protect');
}
//********************************************//
// LOGIC //
//*******************************************//
function approveSpam( $id ) {
$comment_meta = delete_comment_meta( $id, 'ct_marked_as_spam' );
if( $comment_meta ) {
$comment = get_comment($id, 'ARRAY_A');
$comment['comment_approved'] = 1;
wp_update_comment( $comment );
apbct_comment__send_feedback( $id, 'approve', false, true );
}
}
function moveToTrash( $ids ) {
if( ! empty( $ids ) ) {
foreach ( $ids as $id) {
delete_comment_meta( $id, 'ct_marked_as_spam' );
$comment = get_comment( $id );
wp_trash_comment( $comment );
}
}
}
function moveToSpam( $ids ) {
if( ! empty( $ids ) ) {
foreach ( $ids as $id) {
delete_comment_meta( $id, 'ct_marked_as_spam' );
$comment = get_comment( $id );
wp_spam_comment( $comment );
}
}
}
public function getTotal() {
$total_comments = new \WP_Comment_Query();
return $total_comments;
}
public function getChecked() {
$params_spam = array(
'meta_key' => 'ct_checked',
);
$spam_comments = new \WP_Comment_Query($params_spam);
return $spam_comments;
}
public function getCheckedNow() {
$params_spam = array(
'meta_key' => 'ct_checked_now',
);
$spam_comments = new \WP_Comment_Query($params_spam);
return $spam_comments;
}
public function getSpam() {
$params_spam = array(
'meta_key' => 'ct_marked_as_spam',
);
$spam_comments = new \WP_Comment_Query($params_spam);
return $spam_comments;
}
public function getSpamNow() {
// Spam comments
$params_spam = array(
'meta_query' => array(
'relation' => 'AND',
array(
'key' => 'ct_marked_as_spam',
'compare' => 'EXISTS'
),
array(
'key' => 'ct_checked_now',
'compare' => 'EXISTS'
),
)
);
$spam_comments = new \WP_Comment_Query($params_spam);
return $spam_comments;
}
public function getBad() { // Without IP and EMAIL
$params_bad = array(
'meta_key' => 'ct_bad',
);
$bad_users = new \WP_Comment_Query($params_bad);
return $bad_users;
}
public function getScansLogs() {
global $wpdb;
$query = "SELECT * FROM " . APBCT_SPAMSCAN_LOGS . " WHERE scan_type = 'comments'";
$res = $wpdb->get_results( $query, ARRAY_A );
return $res;
}
protected function removeLogs( $ids ) {
$ids_string = implode( ', ', $ids );
global $wpdb;
$wpdb->query("DELETE FROM " . APBCT_SPAMSCAN_LOGS . " WHERE
ID IN ($ids_string)");
}
}
' . $item['ct_comment']->comment_content . '
'; $column_content .= '