X-Git-Url: https://scripts.mit.edu/gitweb/autoinstallsdev/wordpress.git/blobdiff_plain/177fd6fefd2e3d5a0ea6591c71d660cabdb3c1a4..a349837896628462bf8c9bdc27d1477a10fe03eb:/wp-admin/includes/export.php
diff --git a/wp-admin/includes/export.php b/wp-admin/includes/export.php
index 96239af9..a7f20991 100644
--- a/wp-admin/includes/export.php
+++ b/wp-admin/includes/export.php
@@ -1,164 +1,326 @@
get_col("SELECT ID FROM $wpdb->posts $where ORDER BY post_date_gmt ASC");
-
-$categories = (array) get_categories('get=all');
-$tags = (array) get_tags('get=all');
-
-function wxr_missing_parents($categories) {
- if ( !is_array($categories) || empty($categories) )
- return array();
-
- foreach ( $categories as $category )
- $parents[$category->term_id] = $category->parent;
-
- $parents = array_unique(array_diff($parents, array_keys($parents)));
-
- if ( $zero = array_search('0', $parents) )
- unset($parents[$zero]);
-
- return $parents;
-}
-
-while ( $parents = wxr_missing_parents($categories) ) {
- $found_parents = get_categories("include=" . join(', ', $parents));
- if ( is_array($found_parents) && count($found_parents) )
- $categories = array_merge($categories, $found_parents);
- else
- break;
-}
-
-// Put them in order to be inserted with no child going before its parent
-$pass = 0;
-$passes = 1000 + count($categories);
-while ( ( $cat = array_shift($categories) ) && ++$pass < $passes ) {
- if ( $cat->parent == 0 || isset($cats[$cat->parent]) ) {
- $cats[$cat->term_id] = $cat;
+/**
+ * WordPress Export Administration API
+ *
+ * @package WordPress
+ * @subpackage Administration
+ */
+
+/**
+ * Version number for the export format.
+ *
+ * Bump this when something changes that might affect compatibility.
+ *
+ * @since 2.5.0
+ */
+define( 'WXR_VERSION', '1.2' );
+
+/**
+ * Generates the WXR export file for download
+ *
+ * @since 2.1.0
+ *
+ * @param array $args Filters defining what should be included in the export
+ */
+function export_wp( $args = array() ) {
+ global $wpdb, $post;
+
+ $defaults = array( 'content' => 'all', 'author' => false, 'category' => false,
+ 'start_date' => false, 'end_date' => false, 'status' => false,
+ );
+ $args = wp_parse_args( $args, $defaults );
+
+ do_action( 'export_wp', $args );
+
+ $sitename = sanitize_key( get_bloginfo( 'name' ) );
+ if ( ! empty($sitename) ) $sitename .= '.';
+ $filename = $sitename . 'wordpress.' . date( 'Y-m-d' ) . '.xml';
+
+ header( 'Content-Description: File Transfer' );
+ header( 'Content-Disposition: attachment; filename=' . $filename );
+ header( 'Content-Type: text/xml; charset=' . get_option( 'blog_charset' ), true );
+
+ if ( 'all' != $args['content'] && post_type_exists( $args['content'] ) ) {
+ $ptype = get_post_type_object( $args['content'] );
+ if ( ! $ptype->can_export )
+ $args['content'] = 'post';
+
+ $where = $wpdb->prepare( "{$wpdb->posts}.post_type = %s", $args['content'] );
} else {
- $categories[] = $cat;
+ $post_types = get_post_types( array( 'can_export' => true ) );
+ $esses = array_fill( 0, count($post_types), '%s' );
+ $where = $wpdb->prepare( "{$wpdb->posts}.post_type IN (" . implode( ',', $esses ) . ')', $post_types );
}
-}
-unset($categories);
-
-function wxr_cdata($str) {
- if ( seems_utf8($str) == false )
- $str = utf8_encode($str);
-
- // $str = ent2ncr(wp_specialchars($str));
- $str = "";
+ if ( $args['status'] && ( 'post' == $args['content'] || 'page' == $args['content'] ) )
+ $where .= $wpdb->prepare( " AND {$wpdb->posts}.post_status = %s", $args['status'] );
+ else
+ $where .= " AND {$wpdb->posts}.post_status != 'auto-draft'";
+
+ $join = '';
+ if ( $args['category'] && 'post' == $args['content'] ) {
+ if ( $term = term_exists( $args['category'], 'category' ) ) {
+ $join = "INNER JOIN {$wpdb->term_relationships} ON ({$wpdb->posts}.ID = {$wpdb->term_relationships}.object_id)";
+ $where .= $wpdb->prepare( " AND {$wpdb->term_relationships}.term_taxonomy_id = %d", $term['term_taxonomy_id'] );
+ }
+ }
- return $str;
-}
+ if ( 'post' == $args['content'] || 'page' == $args['content'] ) {
+ if ( $args['author'] )
+ $where .= $wpdb->prepare( " AND {$wpdb->posts}.post_author = %d", $args['author'] );
-function wxr_site_url() {
- global $current_site;
+ if ( $args['start_date'] )
+ $where .= $wpdb->prepare( " AND {$wpdb->posts}.post_date >= %s", date( 'Y-m-d', strtotime($args['start_date']) ) );
- // mu: the base url
- if ( isset($current_site->domain) ) {
- return 'http://'.$current_site->domain.$current_site->path;
+ if ( $args['end_date'] )
+ $where .= $wpdb->prepare( " AND {$wpdb->posts}.post_date < %s", date( 'Y-m-d', strtotime('+1 month', strtotime($args['end_date'])) ) );
}
- // wp: the blog url
- else {
- return get_bloginfo_rss('url');
+
+ // grab a snapshot of post IDs, just in case it changes during the export
+ $post_ids = $wpdb->get_col( "SELECT ID FROM {$wpdb->posts} $join WHERE $where" );
+
+ // get the requested terms ready, empty unless posts filtered by category or all content
+ $cats = $tags = $terms = array();
+ if ( isset( $term ) && $term ) {
+ $cat = get_term( $term['term_id'], 'category' );
+ $cats = array( $cat->term_id => $cat );
+ unset( $term, $cat );
+ } else if ( 'all' == $args['content'] ) {
+ $categories = (array) get_categories( array( 'get' => 'all' ) );
+ $tags = (array) get_tags( array( 'get' => 'all' ) );
+
+ $custom_taxonomies = get_taxonomies( array( '_builtin' => false ) );
+ $custom_terms = (array) get_terms( $custom_taxonomies, array( 'get' => 'all' ) );
+
+ // put categories in order with no child going before its parent
+ while ( $cat = array_shift( $categories ) ) {
+ if ( $cat->parent == 0 || isset( $cats[$cat->parent] ) )
+ $cats[$cat->term_id] = $cat;
+ else
+ $categories[] = $cat;
+ }
+
+ // put terms in order with no child going before its parent
+ while ( $t = array_shift( $custom_terms ) ) {
+ if ( $t->parent == 0 || isset( $terms[$t->parent] ) )
+ $terms[$t->term_id] = $t;
+ else
+ $custom_terms[] = $t;
+ }
+
+ unset( $categories, $custom_taxonomies, $custom_terms );
}
-}
-function wxr_cat_name($c) {
- if ( empty($c->name) )
- return;
+ /**
+ * Wrap given string in XML CDATA tag.
+ *
+ * @since 2.1.0
+ *
+ * @param string $str String to wrap in XML CDATA tag.
+ * @return string
+ */
+ function wxr_cdata( $str ) {
+ if ( seems_utf8( $str ) == false )
+ $str = utf8_encode( $str );
+
+ // $str = ent2ncr(esc_html($str));
+ $str = '', ']]]]>', $str ) . ']]>';
+
+ return $str;
+ }
- echo '' . wxr_cdata($c->name) . '';
-}
+ /**
+ * Return the URL of the site
+ *
+ * @since 2.5.0
+ *
+ * @return string Site URL.
+ */
+ function wxr_site_url() {
+ // ms: the base url
+ if ( is_multisite() )
+ return network_home_url();
+ // wp: the blog url
+ else
+ return get_bloginfo_rss( 'url' );
+ }
-function wxr_category_description($c) {
- if ( empty($c->description) )
- return;
+ /**
+ * Output a cat_name XML tag from a given category object
+ *
+ * @since 2.1.0
+ *
+ * @param object $category Category Object
+ */
+ function wxr_cat_name( $category ) {
+ if ( empty( $category->name ) )
+ return;
+
+ echo '' . wxr_cdata( $category->name ) . '';
+ }
- echo '' . wxr_cdata($c->description) . '';
-}
+ /**
+ * Output a category_description XML tag from a given category object
+ *
+ * @since 2.1.0
+ *
+ * @param object $category Category Object
+ */
+ function wxr_category_description( $category ) {
+ if ( empty( $category->description ) )
+ return;
+
+ echo '' . wxr_cdata( $category->description ) . '';
+ }
-function wxr_tag_name($t) {
- if ( empty($t->name) )
- return;
+ /**
+ * Output a tag_name XML tag from a given tag object
+ *
+ * @since 2.3.0
+ *
+ * @param object $tag Tag Object
+ */
+ function wxr_tag_name( $tag ) {
+ if ( empty( $tag->name ) )
+ return;
+
+ echo '' . wxr_cdata( $tag->name ) . '';
+ }
- echo '' . wxr_cdata($t->name) . '';
-}
+ /**
+ * Output a tag_description XML tag from a given tag object
+ *
+ * @since 2.3.0
+ *
+ * @param object $tag Tag Object
+ */
+ function wxr_tag_description( $tag ) {
+ if ( empty( $tag->description ) )
+ return;
+
+ echo '' . wxr_cdata( $tag->description ) . '';
+ }
-function wxr_tag_description($t) {
- if ( empty($t->description) )
- return;
+ /**
+ * Output a term_name XML tag from a given term object
+ *
+ * @since 2.9.0
+ *
+ * @param object $term Term Object
+ */
+ function wxr_term_name( $term ) {
+ if ( empty( $term->name ) )
+ return;
+
+ echo '' . wxr_cdata( $term->name ) . '';
+ }
- echo '' . wxr_cdata($t->description) . '';
-}
+ /**
+ * Output a term_description XML tag from a given term object
+ *
+ * @since 2.9.0
+ *
+ * @param object $term Term Object
+ */
+ function wxr_term_description( $term ) {
+ if ( empty( $term->description ) )
+ return;
+
+ echo '' . wxr_cdata( $term->description ) . '';
+ }
-function wxr_post_taxonomy() {
- $categories = get_the_category();
- $tags = get_the_tags();
- $the_list = '';
- $filter = 'rss';
+ /**
+ * Output list of authors with posts
+ *
+ * @since 3.1.0
+ */
+ function wxr_authors_list() {
+ global $wpdb;
+
+ $authors = array();
+ $results = $wpdb->get_results( "SELECT DISTINCT post_author FROM $wpdb->posts WHERE post_status != 'auto-draft'" );
+ foreach ( (array) $results as $result )
+ $authors[] = get_userdata( $result->post_author );
+
+ $authors = array_filter( $authors );
+
+ foreach ( $authors as $author ) {
+ echo "\t";
+ echo '' . $author->ID . '';
+ echo '' . $author->user_login . '';
+ echo '' . $author->user_email . '';
+ echo '' . wxr_cdata( $author->display_name ) . '';
+ echo '' . wxr_cdata( $author->user_firstname ) . '';
+ echo '' . wxr_cdata( $author->user_lastname ) . '';
+ echo "\n";
+ }
+ }
- if ( !empty($categories) ) foreach ( (array) $categories as $category ) {
- $cat_name = sanitize_term_field('name', $category->name, $category->term_id, 'category', $filter);
- // for backwards compatibility
- $the_list .= "\n\t\t\n";
- // forwards compatibility: use a unique identifier for each cat to avoid clashes
- // http://trac.wordpress.org/ticket/5447
- $the_list .= "\n\t\tslug}\">\n";
+ /**
+ * Ouput all navigation menu terms
+ *
+ * @since 3.1.0
+ */
+ function wxr_nav_menu_terms() {
+ $nav_menus = wp_get_nav_menus();
+ if ( empty( $nav_menus ) || ! is_array( $nav_menus ) )
+ return;
+
+ foreach ( $nav_menus as $menu ) {
+ echo "\t{$menu->term_id}nav_menu{$menu->slug}";
+ wxr_term_name( $menu );
+ echo "\n";
+ }
}
- if ( !empty($tags) ) foreach ( (array) $tags as $tag ) {
- $tag_name = sanitize_term_field('name', $tag->name, $tag->term_id, 'post_tag', $filter);
- $the_list .= "\n\t\t\n";
- // forwards compatibility as above
- $the_list .= "\n\t\tslug}\">\n";
+ /**
+ * Output list of taxonomy terms, in XML tag format, associated with a post
+ *
+ * @since 2.3.0
+ */
+ function wxr_post_taxonomy() {
+ $post = get_post();
+
+ $taxonomies = get_object_taxonomies( $post->post_type );
+ if ( empty( $taxonomies ) )
+ return;
+ $terms = wp_get_object_terms( $post->ID, $taxonomies );
+
+ foreach ( (array) $terms as $term ) {
+ echo "\t\ttaxonomy}\" nicename=\"{$term->slug}\">" . wxr_cdata( $term->name ) . "\n";
+ }
}
- echo $the_list;
-}
+ function wxr_filter_postmeta( $return_me, $meta_key ) {
+ if ( '_edit_lock' == $meta_key )
+ $return_me = true;
+ return $return_me;
+ }
+ add_filter( 'wxr_export_skip_postmeta', 'wxr_filter_postmeta', 10, 2 );
-echo '\n";
+ echo '\n";
-?>
-
-
+ ?>
+
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
\n";
>
-
-
-
-
- http://wordpress.org/?v=
-
+
+
+
+
+
-
-
- slug; ?>parent ? $cats[$c->parent]->name : ''; ?>
-
-
- slug; ?>
-
-
- in_the_loop = true; // Fake being in the loop.
- // fetch 20 posts at a time rather than loading the entire table into memory
- while ( $next_posts = array_splice($post_ids, 0, 20) ) {
- $where = "WHERE ID IN (".join(',', $next_posts).")";
- $posts = $wpdb->get_results("SELECT * FROM $wpdb->posts $where ORDER BY post_date_gmt ASC");
- foreach ($posts as $post) {
- setup_postdata($post); ?>
--
-post_title); ?>
-
-
-
-
-
-
-
-post_content) ); ?>
-ID; ?>
-post_date; ?>
-post_date_gmt; ?>
-comment_status; ?>
-ping_status; ?>
-post_name; ?>
-post_status; ?>
-post_parent; ?>
-menu_order; ?>
-post_type; ?>
-post_password; ?>
-post_type == 'attachment') { ?>
-ID); ?>
-
-get_results("SELECT * FROM $wpdb->postmeta WHERE post_id = $post->ID");
-if ( $postmeta ) {
+
+
+
+
+
+ term_id ?>slug; ?>parent ? $cats[$c->parent]->slug : ''; ?>
+
+
+ term_id ?>slug; ?>
+
+
+ term_id ?>taxonomy; ?>slug; ?>parent ? $terms[$t->parent]->slug : ''; ?>
+
+
+
+
+
+in_the_loop = true; // Fake being in the loop.
+
+ // fetch 20 posts at a time rather than loading the entire table into memory
+ while ( $next_posts = array_splice( $post_ids, 0, 20 ) ) {
+ $where = 'WHERE ID IN (' . join( ',', $next_posts ) . ')';
+ $posts = $wpdb->get_results( "SELECT * FROM {$wpdb->posts} $where" );
+
+ // Begin Loop
+ foreach ( $posts as $post ) {
+ setup_postdata( $post );
+ $is_sticky = is_sticky( $post->ID ) ? 1 : 0;
?>
-
-
-meta_key; ?>
-meta_value; ?>
-
-
-
-get_results("SELECT * FROM $wpdb->comments WHERE comment_post_ID = $post->ID");
-if ( $comments ) { foreach ( $comments as $c ) { ?>
-
-comment_ID; ?>
-comment_author); ?>
-comment_author_email; ?>
-comment_author_url; ?>
-comment_author_IP; ?>
-comment_date; ?>
-comment_date_gmt; ?>
-comment_content) ?>
-comment_approved; ?>
-comment_type; ?>
-comment_parent; ?>
-user_id; ?>
-
-
+
-
+
+ post_title ); ?>
+
+
+
+
+
+ post_content ) ); ?>
+ post_excerpt ) ); ?>
+ ID; ?>
+ post_date; ?>
+ post_date_gmt; ?>
+ comment_status; ?>
+ ping_status; ?>
+ post_name; ?>
+ post_status; ?>
+ post_parent; ?>
+ menu_order; ?>
+ post_type; ?>
+ post_password; ?>
+
+post_type == 'attachment' ) : ?>
+ ID ); ?>
+
+
+get_results( $wpdb->prepare( "SELECT * FROM $wpdb->postmeta WHERE post_id = %d", $post->ID ) );
+ foreach ( $postmeta as $meta ) :
+ if ( apply_filters( 'wxr_export_skip_postmeta', false, $meta->meta_key, $meta ) )
+ continue;
+ ?>
+
+ meta_key; ?>
+ meta_value ); ?>
+
+
+get_results( $wpdb->prepare( "SELECT * FROM $wpdb->comments WHERE comment_post_ID = %d AND comment_approved <> 'spam'", $post->ID ) );
+ foreach ( $comments as $c ) : ?>
+
+ comment_ID; ?>
+ comment_author ); ?>
+ comment_author_email; ?>
+ comment_author_url ); ?>
+ comment_author_IP; ?>
+ comment_date; ?>
+ comment_date_gmt; ?>
+ comment_content ) ?>
+ comment_approved; ?>
+ comment_type; ?>
+ comment_parent; ?>
+ user_id; ?>
+get_results( $wpdb->prepare( "SELECT * FROM $wpdb->commentmeta WHERE comment_id = %d", $c->comment_ID ) );
+ foreach ( $c_meta as $meta ) : ?>
+
+ meta_key; ?>
+ meta_value ); ?>
+
+
+
+
-
+
\ No newline at end of file