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
344                $format_string = implode( ", ", array_fill( 0, count( $comment_ids ), '%s' ) );
345
346                $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->comments} WHERE comment_id IN ( " . $format_string . " )", $comment_ids ) );
347                $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->commentmeta} WHERE comment_id IN ( " . $format_string . " )", $comment_ids ) );
348
349                clean_comment_cache( $comment_ids );
350                do_action( 'akismet_delete_comment_batch', count( $comment_ids ) );
351           }
352
353           if ( apply_filters( 'akismet_optimize_table', ( mt_rand(1, 5000) == 11), $wpdb->comments ) ) // lucky number
354                $wpdb->query("OPTIMIZE TABLE {$wpdb->comments}");
355      }
356
357      public static function delete_old_comments_meta() {
358           global $wpdb;
359
360           $interval = apply_filters( 'akismet_delete_commentmeta_interval', 15 );
361
362           # enfore a minimum of 1 day
 
Line Code
373                $wpdb->queries = array();
374
375                foreach ( $comment_ids as $comment_id ) {
376                     delete_comment_meta( $comment_id, 'akismet_as_submitted' );
377                }
378
379                do_action( 'akismet_delete_commentmeta_batch', count( $comment_ids ) );
380           }
381
382           if ( apply_filters( 'akismet_optimize_table', ( mt_rand(1, 5000) == 11), $wpdb->commentmeta ) ) // lucky number
383                $wpdb->query("OPTIMIZE TABLE {$wpdb->commentmeta}");
384      }
385
386      // how many approved comments does this author have?
387      public static function get_user_comments_approved( $user_id, $comment_author_email, $comment_author, $comment_author_url ) {
388           global $wpdb;
389
390           if ( !empty( $user_id ) )
391                return (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM {$wpdb->comments} WHERE user_id = %d AND comment_approved = 1", $user_id ) );