Changeset 4485 for trunk/wp-admin/export.php

Timestamp:

11/18/2006 11:13:15 PM (18 years ago)

Author:

matt

Message:

Add IDs to export, and let it filter by authors.

File:

• trunk/wp-admin/export.php (modified) (4 diffs)

trunk/wp-admin/export.php

@@ -16 +16 @@
 <p><?php _e('This format, which we call WordPress eXtended RSS or WXR, will contain your posts, comments, custom fields, and categories.'); ?></p>
 <form action="" method="get">
+<h3><?php _e('Optional options'); ?></h3>
+
+<table>
+<tr>
+<th><?php _e('Restrict Author:'); ?></th>
+<td>
+<select name="author">
+<option value="all" selected="selected"><?php _e('All'); ?></option>
+<?php
+$authors = $wpdb->get_col( "SELECT post_author FROM $wpdb->posts GROUP BY post_author" );  
+foreach ( $authors as $id ) {
+    $o = get_userdata( $id );
+    echo "<option value='$o->ID'>$o->display_name</option>";
+}
+?>
+</select>
+</td>
+</tr>
+</table>
 <p class="submit"><input type="submit" name="submit" value="<?php _e('Download Export File'); ?> &raquo;" />
 <input type="hidden" name="download" value="true" />
@@ -26 +45 @@
 
 function export_wp() {
-    global $wpdb, $posts, $post;
-    $filename = 'wordpress.' . date('Y-m-d') . '.xml';
+global $wpdb, $posts, $post;
+
+$filename = 'wordpress.' . date('Y-m-d') . '.xml';
+
 header('Content-Description: File Transfer');
 header('Content-Type: application/octet-stream');
 header("Content-Disposition: attachment; filename=$filename");
 header('Content-type: text/wxr+xml; charset=' . get_option('blog_charset'), true);
-//$posts = query_posts('');
-$posts = $wpdb->get_results("SELECT * FROM $wpdb->posts ORDER BY post_date_gmt ASC");
+
+$where = '';
+if ( isset( $_GET['author'] ) && $_GET['author'] != 'all' ) {
+    $author_id = (int) $_GET['author'];
+    $where = " WHERE post_author = '$author_id' ";
+}
+
+$posts = $wpdb->get_results("SELECT * FROM $wpdb->posts $where ORDER BY post_date_gmt ASC");
 ?>
 <!-- This is a WordPress eXtended RSS file generated by WordPress as an export of your blog. -->
@@ -72 +99 @@
 <description></description>
 <content:encoded><![CDATA[<?php echo $post->post_content ?>]]></content:encoded>
+<wp:post_id><?php echo $post->ID; ?></wp:post_id>
 <wp:post_date><?php echo $post->post_date; ?></wp:post_date>
 <wp:post_date_gmt><?php echo $post->post_date_gmt; ?></wp:post_date_gmt>
@@ -95 +123 @@
 if ( $comments ) { foreach ( $comments as $c ) { ?>
 <wp:comment>
+<wp:comment_id><?php echo $c->comment_ID; ?></wp:comment_id>
 <wp:comment_author><?php echo $c->comment_author; ?></wp:comment_author>
 <wp:comment_author_email><?php echo $c->comment_author_email; ?></wp:comment_author_email>