February 11, 2011 
0 Comments
Definition:
function akismet_spam_totals() {}
function akismet_spam_totals() {
global $wpdb;
$totals = $wpdb->get_results( "SELECT comment_type, COUNT(*) AS cc FROM $wpdb->comments WHERE comment_approved = 'spam' GROUP BY comment_type" );
$return = array();
foreach ( $totals as $total )
$return[$total->comment_type ? $total->comment_type : 'comment'] = $total->cc;
return $return;
}
493
February 11, 2011 0 Comments
Definition:
function akismet_spam_count( $type = false ) {}
function akismet_spam_count( $type = false ) {
global $wpdb;
if ( !$type ) { // total
$count = wp_cache_get( 'akismet_spam_count', 'widget' );
if ( false === $count ) {
if ( function_exists('wp_count_comments') ) {
$count = wp_count_comments();
$count = $count->spam;
} else {
$count = (int) $wpdb->get_var("SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE comment_approved = 'spam'");
}
wp_cache_set( 'akismet_spam_count', $count, 'widget', 3600 );
}
return $count;
} elseif ( 'comments' == $type || 'comment' == $type ) { // comments
$type = '';
} else { // pingback, trackback, ...
$type = $wpdb->escape( $type );
}
return (int) $wpdb->get_var("SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE comment_approved = 'spam' AND comment_type='$type'");
}
491
February 11, 2011 0 Comments
Definition:
function akismet_spam_count( $type = false ) {}
function akismet_spam_count( $type = false ) {
global $wpdb;
if ( !$type ) { // total
$count = wp_cache_get( 'akismet_spam_count', 'widget' );
if ( false === $count ) {
if ( function_exists('wp_count_comments') ) {
$count = wp_count_comments();
$count = $count->spam;
} else {
$count = (int) $wpdb->get_var("SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE comment_approved = 'spam'");
}
wp_cache_set( 'akismet_spam_count', $count, 'widget', 3600 );
}
return $count;
} elseif ( 'comments' == $type || 'comment' == $type ) { // comments
$type = '';
} else { // pingback, trackback, ...
$type = $wpdb->escape( $type );
}
return (int) $wpdb->get_var("SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE comment_approved = 'spam' AND comment_type='$type'");
}
489
February 11, 2011 0 Comments
Definition:
function akismet_spamtoham( $comment ) { akismet_submit_nonspam_comment( $comment->comment_ID ); }
function akismet_spamtoham( $comment ) { akismet_submit_nonspam_comment( $comment->comment_ID ); }
485
Did you find something that helps you save time or money on this site and just want to say "Thanks". Feel free to buy us a coffee using the button below.
Lost in time(zones)? http://localtime.at can help
WordPress Syntax mode for Panic Coda
Thorsten: Till, that's extra awesome. Especially as I alread...
Till: I just released a WordPress syntax mode for Coda 2...
madtownlems: Is there any good writeup on how to effectively an...
WP-Cron.com Links My random code snippets
A HitchHackers guide through WordPress 
akismet_spam_comments
Definition:
function akismet_spam_comments( $type = false, $page = 1, $per_page = 50 ) {}
Parameters
Source code
function akismet_spam_comments( $type = false, $page = 1, $per_page = 50 ) { global $wpdb; $page = (int) $page; if ( $page < 2 ) $page = 1; $per_page = (int) $per_page; if ( $per_page < 1 ) $per_page = 50; $start = ( $page - 1 ) * $per_page; $end = $start + $per_page; if ( $type ) { if ( 'comments' == $type || 'comment' == $type ) $type = ''; else $type = $wpdb->escape( $type ); return $wpdb->get_results( "SELECT * FROM $wpdb->comments WHERE comment_approved = 'spam' AND comment_type='$type' ORDER BY comment_date DESC LIMIT $start, $end"); } // All return $wpdb->get_results( "SELECT * FROM $wpdb->comments WHERE comment_approved = 'spam' ORDER BY comment_date DESC LIMIT $start, $end"); }487