Menu Adam R Brown

WP hooks navigation: Home/browseActions indexFilters index

Source View: akismet_optimize_table

To save our bandwidth, we show only a snippet of code around each occurence of the hook. View complete file in SVN (without highlighting).

Understanding Source Code

The best way to understand what a hook does is to look at where it occurs in the source code.

Remember, this hook may occur in more than one file. Moreover, the hook's context may change from version to version.

Source View

This hook occurs 2 times in this file.

Line Code
354                $format_string = implode( ", ", array_fill( 0, count( $comment_ids ), '%s' ) );
355
356                $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->comments} WHERE comment_id IN ( " . $format_string . " )", $comment_ids ) );
357                $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->commentmeta} WHERE comment_id IN ( " . $format_string . " )", $comment_ids ) );
358
359                clean_comment_cache( $comment_ids );
360                do_action( 'akismet_delete_comment_batch', count( $comment_ids ) );
361           }
362
363           if ( apply_filters( 'akismet_optimize_table', ( mt_rand(1, 5000) == 11), $wpdb->comments ) ) // lucky number
364                $wpdb->query("OPTIMIZE TABLE {$wpdb->comments}");
365      }
366
367      public static function delete_old_comments_meta() {
368           global $wpdb;
369
370           $interval = apply_filters( 'akismet_delete_commentmeta_interval', 15 );
371
372           # enfore a minimum of 1 day
 
Line Code
383                $wpdb->queries = array();
384
385                foreach ( $comment_ids as $comment_id ) {
386                     delete_comment_meta( $comment_id, 'akismet_as_submitted' );
387                }
388
389                do_action( 'akismet_delete_commentmeta_batch', count( $comment_ids ) );
390           }
391
392           if ( apply_filters( 'akismet_optimize_table', ( mt_rand(1, 5000) == 11), $wpdb->commentmeta ) ) // lucky number
393                $wpdb->query("OPTIMIZE TABLE {$wpdb->commentmeta}");
394      }
395
396      // how many approved comments does this author have?
397      public static function get_user_comments_approved( $user_id, $comment_author_email, $comment_author, $comment_author_url ) {
398           global $wpdb;
399
400           if ( !empty( $user_id ) )
401                return (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM {$wpdb->comments} WHERE user_id = %d AND comment_approved = 1", $user_id ) );