'.__('Settings', 'tw_asi-settings').''; array_unshift($links, $settings_link); return $links; } $tw_asi_plugin = TWASI_PLUGIN_BASENAME; add_filter("plugin_action_links_$tw_asi_plugin", 'tw_asi_settings_link' ); function tw_asi_getSizes($size){ $size_r = ''; if($size==0){ $size_r = "0"; } else if($size<1024){ $size_r = $size. ' B'; } else if($size>=1024 && $size<(1024*1024)){ $size_r = round($size/(1024),2). ' KB'; } else{ $size_r = round($size/(1024*1024),2). ' MB'; } return $size_r; } function tw_asi_table_optimize($tables){ global $wpdb; $status = true; $sql_opt = "OPTIMIZE TABLE ".$tables; $wpdb->query($sql_opt); return $status; } function tw_asi_table_remove($type){ global $wpdb; $status = true; if($type==1){ $sql = "DELETE FROM `$wpdb->posts` WHERE post_type = 'revision'"; $wpdb->query( $sql ); } else if($type==2){ $sql = "DELETE FROM `$wpdb->posts` WHERE post_status = 'auto-draft'"; $wpdb->query( $sql ); } else if($type==3){ $sql = "DELETE FROM `$wpdb->posts` WHERE post_status = 'trash'"; $wpdb->query( $sql ); $sql = "DELETE asi FROM `$wpdb->postmeta` asi LEFT JOIN `$wpdb->posts` wp ON wp.ID = asi.post_id WHERE wp.ID IS NULL"; $wpdb->query( $sql ); } else if($type==4){ $sql = "DELETE FROM `$wpdb->comments` WHERE comment_approved = 'spam'"; $wpdb->query( $sql ); } else if($type==5){ $sql = "DELETE FROM `$wpdb->comments` WHERE comment_approved = 'trash'"; $wpdb->query( $sql ); } else if($type==6){ $sql = "DELETE FROM `$wpdb->options` WHERE option_name LIKE '_site_transient_browser_%' OR option_name LIKE '_site_transient_timeout_browser_%' OR option_name LIKE '_transient_feed_%' OR option_name LIKE '_transient_timeout_feed_%'"; $wpdb->query( $sql ); } return $status; }