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
259
260                $comma_comment_ids = implode( ', ', array_map('intval', $comment_ids) );
261
262                $wpdb->query("DELETE FROM {$wpdb->comments} WHERE comment_id IN ( $comma_comment_ids )");
263                $wpdb->query("DELETE FROM {$wpdb->commentmeta} WHERE comment_id IN ( $comma_comment_ids )");
264
265                clean_comment_cache( $comment_ids );
266           }
267
268           if ( apply_filters( 'akismet_optimize_table', ( mt_rand(1, 5000) == 11), $wpdb->comments ) ) // lucky number
269                $wpdb->query("OPTIMIZE TABLE {$wpdb->comments}");
270      }
271
272      public static function delete_old_comments_meta() {
273           global $wpdb;
274
275           $interval = apply_filters( 'akismet_delete_commentmeta_interval', 15 );
276
277           # enfore a minimum of 1 day
 
Line Code
286                     return;
287
288                $wpdb->queries = array();
289
290                foreach ( $comment_ids as $comment_id ) {
291                     delete_comment_meta( $comment_id, 'akismet_as_submitted' );
292                }
293           }
294
295           if ( apply_filters( 'akismet_optimize_table', ( mt_rand(1, 5000) == 11), $wpdb->commentmeta ) ) // lucky number
296                $wpdb->query("OPTIMIZE TABLE {$wpdb->commentmeta}");
297      }
298
299      // how many approved comments does this author have?
300      public static function get_user_comments_approved( $user_id, $comment_author_email, $comment_author, $comment_author_url ) {
301           global $wpdb;
302
303           if ( !empty( $user_id ) )
304                return (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM {$wpdb->comments} WHERE user_id = %d AND comment_approved = 1", $user_id ) );