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