3 * WordPress Post Administration API.
6 * @subpackage Administration
10 * Rename $_POST data from form names to DB post columns.
12 * Manipulates $_POST directly.
17 * @param bool $update Are we updating a pre-existing post?
18 * @param array $post_data Array of post data. Defaults to the contents of $_POST.
19 * @return object|bool WP_Error on failure, true on success.
21 function _wp_translate_postdata( $update = false, $post_data = null ) {
23 if ( empty($post_data) )
27 $post_data['ID'] = (int) $post_data['post_ID'];
29 $ptype = get_post_type_object( $post_data['post_type'] );
31 if ( $update && ! current_user_can( 'edit_post', $post_data['ID'] ) ) {
32 if ( 'page' == $post_data['post_type'] )
33 return new WP_Error( 'edit_others_pages', __( 'You are not allowed to edit pages as this user.' ) );
35 return new WP_Error( 'edit_others_posts', __( 'You are not allowed to edit posts as this user.' ) );
36 } elseif ( ! $update && ! current_user_can( $ptype->cap->create_posts ) ) {
37 if ( 'page' == $post_data['post_type'] )
38 return new WP_Error( 'edit_others_pages', __( 'You are not allowed to create pages as this user.' ) );
40 return new WP_Error( 'edit_others_posts', __( 'You are not allowed to create posts as this user.' ) );
43 if ( isset( $post_data['content'] ) )
44 $post_data['post_content'] = $post_data['content'];
46 if ( isset( $post_data['excerpt'] ) )
47 $post_data['post_excerpt'] = $post_data['excerpt'];
49 if ( isset( $post_data['parent_id'] ) )
50 $post_data['post_parent'] = (int) $post_data['parent_id'];
52 if ( isset($post_data['trackback_url']) )
53 $post_data['to_ping'] = $post_data['trackback_url'];
55 $post_data['user_ID'] = get_current_user_id();
57 if (!empty ( $post_data['post_author_override'] ) ) {
58 $post_data['post_author'] = (int) $post_data['post_author_override'];
60 if (!empty ( $post_data['post_author'] ) ) {
61 $post_data['post_author'] = (int) $post_data['post_author'];
63 $post_data['post_author'] = (int) $post_data['user_ID'];
67 if ( isset( $post_data['user_ID'] ) && ( $post_data['post_author'] != $post_data['user_ID'] )
68 && ! current_user_can( $ptype->cap->edit_others_posts ) ) {
70 if ( 'page' == $post_data['post_type'] )
71 return new WP_Error( 'edit_others_pages', __( 'You are not allowed to edit pages as this user.' ) );
73 return new WP_Error( 'edit_others_posts', __( 'You are not allowed to edit posts as this user.' ) );
75 if ( 'page' == $post_data['post_type'] )
76 return new WP_Error( 'edit_others_pages', __( 'You are not allowed to create pages as this user.' ) );
78 return new WP_Error( 'edit_others_posts', __( 'You are not allowed to create posts as this user.' ) );
82 if ( ! empty( $post_data['post_status'] ) )
83 $post_data['post_status'] = sanitize_key( $post_data['post_status'] );
85 // What to do based on which button they pressed
86 if ( isset($post_data['saveasdraft']) && '' != $post_data['saveasdraft'] )
87 $post_data['post_status'] = 'draft';
88 if ( isset($post_data['saveasprivate']) && '' != $post_data['saveasprivate'] )
89 $post_data['post_status'] = 'private';
90 if ( isset($post_data['publish']) && ( '' != $post_data['publish'] ) && ( !isset($post_data['post_status']) || $post_data['post_status'] != 'private' ) )
91 $post_data['post_status'] = 'publish';
92 if ( isset($post_data['advanced']) && '' != $post_data['advanced'] )
93 $post_data['post_status'] = 'draft';
94 if ( isset($post_data['pending']) && '' != $post_data['pending'] )
95 $post_data['post_status'] = 'pending';
97 if ( isset( $post_data['ID'] ) )
98 $post_id = $post_data['ID'];
101 $previous_status = $post_id ? get_post_field( 'post_status', $post_id ) : false;
103 if ( isset( $post_data['post_status'] ) && 'private' == $post_data['post_status'] && ! current_user_can( $ptype->cap->publish_posts ) ) {
104 $post_data['post_status'] = $previous_status ? $previous_status : 'pending';
107 $published_statuses = array( 'publish', 'future' );
109 // Posts 'submitted for approval' present are submitted to $_POST the same as if they were being published.
110 // Change status from 'publish' to 'pending' if user lacks permissions to publish or to resave published posts.
111 if ( isset($post_data['post_status']) && (in_array( $post_data['post_status'], $published_statuses ) && !current_user_can( $ptype->cap->publish_posts )) )
112 if ( ! in_array( $previous_status, $published_statuses ) || !current_user_can( 'edit_post', $post_id ) )
113 $post_data['post_status'] = 'pending';
115 if ( ! isset($post_data['post_status']) )
116 $post_data['post_status'] = $previous_status;
118 if ( isset( $post_data['post_password'] ) && ! current_user_can( $ptype->cap->publish_posts ) ) {
119 unset( $post_data['post_password'] );
122 if (!isset( $post_data['comment_status'] ))
123 $post_data['comment_status'] = 'closed';
125 if (!isset( $post_data['ping_status'] ))
126 $post_data['ping_status'] = 'closed';
128 foreach ( array('aa', 'mm', 'jj', 'hh', 'mn') as $timeunit ) {
129 if ( !empty( $post_data['hidden_' . $timeunit] ) && $post_data['hidden_' . $timeunit] != $post_data[$timeunit] ) {
130 $post_data['edit_date'] = '1';
135 if ( !empty( $post_data['edit_date'] ) ) {
136 $aa = $post_data['aa'];
137 $mm = $post_data['mm'];
138 $jj = $post_data['jj'];
139 $hh = $post_data['hh'];
140 $mn = $post_data['mn'];
141 $ss = $post_data['ss'];
142 $aa = ($aa <= 0 ) ? date('Y') : $aa;
143 $mm = ($mm <= 0 ) ? date('n') : $mm;
144 $jj = ($jj > 31 ) ? 31 : $jj;
145 $jj = ($jj <= 0 ) ? date('j') : $jj;
146 $hh = ($hh > 23 ) ? $hh -24 : $hh;
147 $mn = ($mn > 59 ) ? $mn -60 : $mn;
148 $ss = ($ss > 59 ) ? $ss -60 : $ss;
149 $post_data['post_date'] = sprintf( "%04d-%02d-%02d %02d:%02d:%02d", $aa, $mm, $jj, $hh, $mn, $ss );
150 $valid_date = wp_checkdate( $mm, $jj, $aa, $post_data['post_date'] );
151 if ( !$valid_date ) {
152 return new WP_Error( 'invalid_date', __( 'Whoops, the provided date is invalid.' ) );
154 $post_data['post_date_gmt'] = get_gmt_from_date( $post_data['post_date'] );
161 * Update an existing post with values provided in $_POST.
165 * @param array $post_data Optional.
166 * @return int Post ID.
168 function edit_post( $post_data = null ) {
170 if ( empty($post_data) )
171 $post_data = &$_POST;
173 // Clear out any data in internal vars.
174 unset( $post_data['filter'] );
176 $post_ID = (int) $post_data['post_ID'];
177 $post = get_post( $post_ID );
178 $post_data['post_type'] = $post->post_type;
179 $post_data['post_mime_type'] = $post->post_mime_type;
181 if ( ! empty( $post_data['post_status'] ) ) {
182 $post_data['post_status'] = sanitize_key( $post_data['post_status'] );
184 if ( 'inherit' == $post_data['post_status'] ) {
185 unset( $post_data['post_status'] );
189 $ptype = get_post_type_object($post_data['post_type']);
190 if ( !current_user_can( 'edit_post', $post_ID ) ) {
191 if ( 'page' == $post_data['post_type'] )
192 wp_die( __('You are not allowed to edit this page.' ));
194 wp_die( __('You are not allowed to edit this post.' ));
197 if ( post_type_supports( $ptype->name, 'revisions' ) ) {
198 $revisions = wp_get_post_revisions( $post_ID, array( 'order' => 'ASC', 'posts_per_page' => 1 ) );
199 $revision = current( $revisions );
201 // Check if the revisions have been upgraded
202 if ( $revisions && _wp_get_post_revision_version( $revision ) < 1 )
203 _wp_upgrade_revisions_of_post( $post, wp_get_post_revisions( $post_ID ) );
206 if ( ( empty( $post_data['action'] ) || 'autosave' != $post_data['action'] ) && 'auto-draft' == $post_data['post_status'] ) {
207 $post_data['post_status'] = 'draft';
210 if ( isset($post_data['visibility']) ) {
211 switch ( $post_data['visibility'] ) {
213 $post_data['post_password'] = '';
216 unset( $post_data['sticky'] );
219 $post_data['post_status'] = 'private';
220 $post_data['post_password'] = '';
221 unset( $post_data['sticky'] );
226 $post_data = _wp_translate_postdata( true, $post_data );
227 if ( is_wp_error($post_data) )
228 wp_die( $post_data->get_error_message() );
231 if ( isset( $post_data['post_format'] ) )
232 set_post_format( $post_ID, $post_data['post_format'] );
234 $format_meta_urls = array( 'url', 'link_url', 'quote_source_url' );
235 foreach ( $format_meta_urls as $format_meta_url ) {
236 $keyed = '_format_' . $format_meta_url;
237 if ( isset( $post_data[ $keyed ] ) )
238 update_post_meta( $post_ID, $keyed, wp_slash( esc_url_raw( wp_unslash( $post_data[ $keyed ] ) ) ) );
241 $format_keys = array( 'quote', 'quote_source_name', 'image', 'gallery', 'audio_embed', 'video_embed' );
243 foreach ( $format_keys as $key ) {
244 $keyed = '_format_' . $key;
245 if ( isset( $post_data[ $keyed ] ) ) {
246 if ( current_user_can( 'unfiltered_html' ) )
247 update_post_meta( $post_ID, $keyed, $post_data[ $keyed ] );
249 update_post_meta( $post_ID, $keyed, wp_filter_post_kses( $post_data[ $keyed ] ) );
254 if ( isset($post_data['meta']) && $post_data['meta'] ) {
255 foreach ( $post_data['meta'] as $key => $value ) {
256 if ( !$meta = get_post_meta_by_id( $key ) )
258 if ( $meta->post_id != $post_ID )
260 if ( is_protected_meta( $value['key'], 'post' ) || ! current_user_can( 'edit_post_meta', $post_ID, $value['key'] ) )
262 update_meta( $key, $value['key'], $value['value'] );
266 if ( isset($post_data['deletemeta']) && $post_data['deletemeta'] ) {
267 foreach ( $post_data['deletemeta'] as $key => $value ) {
268 if ( !$meta = get_post_meta_by_id( $key ) )
270 if ( $meta->post_id != $post_ID )
272 if ( is_protected_meta( $meta->meta_key, 'post' ) || ! current_user_can( 'delete_post_meta', $post_ID, $meta->meta_key ) )
279 if ( 'attachment' == $post_data['post_type'] ) {
280 if ( isset( $post_data[ '_wp_attachment_image_alt' ] ) ) {
281 $image_alt = wp_unslash( $post_data['_wp_attachment_image_alt'] );
282 if ( $image_alt != get_post_meta( $post_ID, '_wp_attachment_image_alt', true ) ) {
283 $image_alt = wp_strip_all_tags( $image_alt, true );
284 // update_meta expects slashed
285 update_post_meta( $post_ID, '_wp_attachment_image_alt', wp_slash( $image_alt ) );
289 $attachment_data = isset( $post_data['attachments'][ $post_ID ] ) ? $post_data['attachments'][ $post_ID ] : array();
290 /** This filter is documented in wp-admin/includes/media.php */
291 $post_data = apply_filters( 'attachment_fields_to_save', $post_data, $attachment_data );
294 add_meta( $post_ID );
296 update_post_meta( $post_ID, '_edit_last', get_current_user_id() );
298 wp_update_post( $post_data );
300 // Now that we have an ID we can fix any attachment anchor hrefs
301 _fix_attachment_links( $post_ID );
303 wp_set_post_lock( $post_ID );
305 if ( current_user_can( $ptype->cap->edit_others_posts ) ) {
306 if ( ! empty( $post_data['sticky'] ) )
307 stick_post( $post_ID );
309 unstick_post( $post_ID );
316 * Process the post data for the bulk editing of posts.
318 * Updates all bulk edited posts/pages, adding (but not removing) tags and
319 * categories. Skips pages when they would be their own parent or child.
323 * @param array $post_data Optional, the array of post data to process if not provided will use $_POST superglobal.
326 function bulk_edit_posts( $post_data = null ) {
329 if ( empty($post_data) )
330 $post_data = &$_POST;
332 if ( isset($post_data['post_type']) )
333 $ptype = get_post_type_object($post_data['post_type']);
335 $ptype = get_post_type_object('post');
337 if ( !current_user_can( $ptype->cap->edit_posts ) ) {
338 if ( 'page' == $ptype->name )
339 wp_die( __('You are not allowed to edit pages.'));
341 wp_die( __('You are not allowed to edit posts.'));
344 if ( -1 == $post_data['_status'] ) {
345 $post_data['post_status'] = null;
346 unset($post_data['post_status']);
348 $post_data['post_status'] = $post_data['_status'];
350 unset($post_data['_status']);
352 if ( ! empty( $post_data['post_status'] ) ) {
353 $post_data['post_status'] = sanitize_key( $post_data['post_status'] );
355 if ( 'inherit' == $post_data['post_status'] ) {
356 unset( $post_data['post_status'] );
360 $post_IDs = array_map( 'intval', (array) $post_data['post'] );
363 'post_author', 'post_status', 'post_password',
364 'post_parent', 'page_template', 'comment_status',
365 'ping_status', 'keep_private', 'tax_input',
366 'post_category', 'sticky', 'post_format',
369 foreach ( $reset as $field ) {
370 if ( isset($post_data[$field]) && ( '' == $post_data[$field] || -1 == $post_data[$field] ) )
371 unset($post_data[$field]);
374 if ( isset($post_data['post_category']) ) {
375 if ( is_array($post_data['post_category']) && ! empty($post_data['post_category']) )
376 $new_cats = array_map( 'absint', $post_data['post_category'] );
378 unset($post_data['post_category']);
381 $tax_input = array();
382 if ( isset($post_data['tax_input'])) {
383 foreach ( $post_data['tax_input'] as $tax_name => $terms ) {
386 if ( is_taxonomy_hierarchical( $tax_name ) ) {
387 $tax_input[ $tax_name ] = array_map( 'absint', $terms );
389 $comma = _x( ',', 'tag delimiter' );
390 if ( ',' !== $comma )
391 $terms = str_replace( $comma, ',', $terms );
392 $tax_input[ $tax_name ] = explode( ',', trim( $terms, " \n\t\r\0\x0B," ) );
397 if ( isset($post_data['post_parent']) && ($parent = (int) $post_data['post_parent']) ) {
398 $pages = $wpdb->get_results("SELECT ID, post_parent FROM $wpdb->posts WHERE post_type = 'page'");
401 for ( $i = 0; $i < 50 && $parent > 0; $i++ ) {
402 $children[] = $parent;
404 foreach ( $pages as $page ) {
405 if ( $page->ID == $parent ) {
406 $parent = $page->post_parent;
413 $updated = $skipped = $locked = array();
414 foreach ( $post_IDs as $post_ID ) {
415 $post_type_object = get_post_type_object( get_post_type( $post_ID ) );
417 if ( !isset( $post_type_object ) || ( isset($children) && in_array($post_ID, $children) ) || !current_user_can( 'edit_post', $post_ID ) ) {
418 $skipped[] = $post_ID;
422 if ( wp_check_post_lock( $post_ID ) ) {
423 $locked[] = $post_ID;
427 $post = get_post( $post_ID );
428 $tax_names = get_object_taxonomies( $post );
429 foreach ( $tax_names as $tax_name ) {
430 $taxonomy_obj = get_taxonomy($tax_name);
431 if ( isset( $tax_input[$tax_name]) && current_user_can( $taxonomy_obj->cap->assign_terms ) )
432 $new_terms = $tax_input[$tax_name];
434 $new_terms = array();
436 if ( $taxonomy_obj->hierarchical )
437 $current_terms = (array) wp_get_object_terms( $post_ID, $tax_name, array('fields' => 'ids') );
439 $current_terms = (array) wp_get_object_terms( $post_ID, $tax_name, array('fields' => 'names') );
441 $post_data['tax_input'][$tax_name] = array_merge( $current_terms, $new_terms );
444 if ( isset($new_cats) && in_array( 'category', $tax_names ) ) {
445 $cats = (array) wp_get_post_categories($post_ID);
446 $post_data['post_category'] = array_unique( array_merge($cats, $new_cats) );
447 unset( $post_data['tax_input']['category'] );
450 $post_data['post_type'] = $post->post_type;
451 $post_data['post_mime_type'] = $post->post_mime_type;
452 $post_data['guid'] = $post->guid;
454 foreach ( array( 'comment_status', 'ping_status', 'post_author' ) as $field ) {
455 if ( ! isset( $post_data[ $field ] ) ) {
456 $post_data[ $field ] = $post->$field;
460 $post_data['ID'] = $post_ID;
461 $post_data['post_ID'] = $post_ID;
463 $translated_post_data = _wp_translate_postdata( true, $post_data );
464 if ( is_wp_error( $translated_post_data ) ) {
465 $skipped[] = $post_ID;
469 $updated[] = wp_update_post( $translated_post_data );
471 if ( isset( $post_data['sticky'] ) && current_user_can( $ptype->cap->edit_others_posts ) ) {
472 if ( 'sticky' == $post_data['sticky'] )
473 stick_post( $post_ID );
475 unstick_post( $post_ID );
478 if ( isset( $post_data['post_format'] ) )
479 set_post_format( $post_ID, $post_data['post_format'] );
482 return array( 'updated' => $updated, 'skipped' => $skipped, 'locked' => $locked );
486 * Default post information to use when populating the "Write Post" form.
490 * @param string $post_type A post type string, defaults to 'post'.
491 * @return WP_Post Post object containing all the default post data as attributes
493 function get_default_post_to_edit( $post_type = 'post', $create_in_db = false ) {
497 if ( !empty( $_REQUEST['post_title'] ) )
498 $post_title = esc_html( wp_unslash( $_REQUEST['post_title'] ));
501 if ( !empty( $_REQUEST['content'] ) )
502 $post_content = esc_html( wp_unslash( $_REQUEST['content'] ));
505 if ( !empty( $_REQUEST['excerpt'] ) )
506 $post_excerpt = esc_html( wp_unslash( $_REQUEST['excerpt'] ));
508 if ( $create_in_db ) {
509 $post_id = wp_insert_post( array( 'post_title' => __( 'Auto Draft' ), 'post_type' => $post_type, 'post_status' => 'auto-draft' ) );
510 $post = get_post( $post_id );
511 if ( current_theme_supports( 'post-formats' ) && post_type_supports( $post->post_type, 'post-formats' ) && get_option( 'default_post_format' ) )
512 set_post_format( $post, get_option( 'default_post_format' ) );
514 $post = new stdClass;
516 $post->post_author = '';
517 $post->post_date = '';
518 $post->post_date_gmt = '';
519 $post->post_password = '';
520 $post->post_type = $post_type;
521 $post->post_status = 'draft';
524 $post->comment_status = get_option( 'default_comment_status' );
525 $post->ping_status = get_option( 'default_ping_status' );
526 $post->post_pingback = get_option( 'default_pingback_flag' );
527 $post->post_category = get_option( 'default_category' );
528 $post->page_template = 'default';
529 $post->post_parent = 0;
530 $post->menu_order = 0;
531 $post = new WP_Post( $post );
534 $post->post_content = apply_filters( 'default_content', $post_content, $post );
535 $post->post_title = apply_filters( 'default_title', $post_title, $post );
536 $post->post_excerpt = apply_filters( 'default_excerpt', $post_excerpt, $post );
537 $post->post_name = '';
543 * Determine if a post exists based on title, content, and date
547 * @param string $title Post title
548 * @param string $content Optional post content
549 * @param string $date Optional post date
550 * @return int Post ID if post exists, 0 otherwise.
552 function post_exists($title, $content = '', $date = '') {
555 $post_title = wp_unslash( sanitize_post_field( 'post_title', $title, 0, 'db' ) );
556 $post_content = wp_unslash( sanitize_post_field( 'post_content', $content, 0, 'db' ) );
557 $post_date = wp_unslash( sanitize_post_field( 'post_date', $date, 0, 'db' ) );
559 $query = "SELECT ID FROM $wpdb->posts WHERE 1=1";
562 if ( !empty ( $date ) ) {
563 $query .= ' AND post_date = %s';
564 $args[] = $post_date;
567 if ( !empty ( $title ) ) {
568 $query .= ' AND post_title = %s';
569 $args[] = $post_title;
572 if ( !empty ( $content ) ) {
573 $query .= 'AND post_content = %s';
574 $args[] = $post_content;
577 if ( !empty ( $args ) )
578 return (int) $wpdb->get_var( $wpdb->prepare($query, $args) );
584 * Creates a new post from the "Write Post" form using $_POST information.
590 function wp_write_post() {
591 if ( isset($_POST['post_type']) )
592 $ptype = get_post_type_object($_POST['post_type']);
594 $ptype = get_post_type_object('post');
596 if ( !current_user_can( $ptype->cap->edit_posts ) ) {
597 if ( 'page' == $ptype->name )
598 return new WP_Error( 'edit_pages', __( 'You are not allowed to create pages on this site.' ) );
600 return new WP_Error( 'edit_posts', __( 'You are not allowed to create posts or drafts on this site.' ) );
603 $_POST['post_mime_type'] = '';
605 // Clear out any data in internal vars.
606 unset( $_POST['filter'] );
608 // Edit don't write if we have a post id.
609 if ( isset( $_POST['post_ID'] ) )
612 if ( isset($_POST['visibility']) ) {
613 switch ( $_POST['visibility'] ) {
615 $_POST['post_password'] = '';
618 unset( $_POST['sticky'] );
621 $_POST['post_status'] = 'private';
622 $_POST['post_password'] = '';
623 unset( $_POST['sticky'] );
628 $translated = _wp_translate_postdata( false );
629 if ( is_wp_error($translated) )
633 $post_ID = wp_insert_post( $_POST );
634 if ( is_wp_error( $post_ID ) )
637 if ( empty($post_ID) )
640 add_meta( $post_ID );
642 add_post_meta( $post_ID, '_edit_last', $GLOBALS['current_user']->ID );
644 // Now that we have an ID we can fix any attachment anchor hrefs
645 _fix_attachment_links( $post_ID );
647 wp_set_post_lock( $post_ID );
653 * Calls wp_write_post() and handles the errors.
657 * @uses wp_write_post()
658 * @uses is_wp_error()
662 function write_post() {
663 $result = wp_write_post();
664 if ( is_wp_error( $result ) )
665 wp_die( $result->get_error_message() );
675 * {@internal Missing Short Description}}
679 * @param unknown_type $post_ID
682 function add_meta( $post_ID ) {
684 $post_ID = (int) $post_ID;
686 $metakeyselect = isset($_POST['metakeyselect']) ? wp_unslash( trim( $_POST['metakeyselect'] ) ) : '';
687 $metakeyinput = isset($_POST['metakeyinput']) ? wp_unslash( trim( $_POST['metakeyinput'] ) ) : '';
688 $metavalue = isset($_POST['metavalue']) ? $_POST['metavalue'] : '';
689 if ( is_string( $metavalue ) )
690 $metavalue = trim( $metavalue );
692 if ( ('0' === $metavalue || ! empty ( $metavalue ) ) && ( ( ( '#NONE#' != $metakeyselect ) && !empty ( $metakeyselect) ) || !empty ( $metakeyinput ) ) ) {
693 // We have a key/value pair. If both the select and the
694 // input for the key have data, the input takes precedence:
696 if ( '#NONE#' != $metakeyselect )
697 $metakey = $metakeyselect;
700 $metakey = $metakeyinput; // default
702 if ( is_protected_meta( $metakey, 'post' ) || ! current_user_can( 'add_post_meta', $post_ID, $metakey ) )
705 $metakey = wp_slash( $metakey );
707 return add_post_meta( $post_ID, $metakey, $metavalue );
714 * {@internal Missing Short Description}}
718 * @param unknown_type $mid
721 function delete_meta( $mid ) {
722 return delete_metadata_by_mid( 'post' , $mid );
726 * Get a list of previously defined keys.
732 function get_meta_keys() {
735 $keys = $wpdb->get_col( "
739 ORDER BY meta_key" );
745 * {@internal Missing Short Description}}
749 * @param unknown_type $mid
752 function get_post_meta_by_id( $mid ) {
753 return get_metadata_by_mid( 'post', $mid );
757 * {@internal Missing Short Description}}
759 * Some postmeta stuff.
763 * @param unknown_type $postid
766 function has_meta( $postid ) {
769 return $wpdb->get_results( $wpdb->prepare("SELECT meta_key, meta_value, meta_id, post_id
770 FROM $wpdb->postmeta WHERE post_id = %d
771 ORDER BY meta_key,meta_id", $postid), ARRAY_A );
775 * {@internal Missing Short Description}}
779 * @param unknown_type $meta_id
780 * @param unknown_type $meta_key Expect Slashed
781 * @param unknown_type $meta_value Expect Slashed
784 function update_meta( $meta_id, $meta_key, $meta_value ) {
785 $meta_key = wp_unslash( $meta_key );
786 $meta_value = wp_unslash( $meta_value );
788 return update_metadata_by_mid( 'post', $meta_id, $meta_value, $meta_key );
796 * Replace hrefs of attachment anchors with up-to-date permalinks.
801 * @param int|object $post Post ID or post object.
802 * @return void|int|WP_Error Void if nothing fixed. 0 or WP_Error on update failure. The post ID on update success.
804 function _fix_attachment_links( $post ) {
805 $post = get_post( $post, ARRAY_A );
806 $content = $post['post_content'];
808 // Don't run if no pretty permalinks or post is not published, scheduled, or privately published.
809 if ( ! get_option( 'permalink_structure' ) || ! in_array( $post['post_status'], array( 'publish', 'future', 'private' ) ) )
812 // Short if there aren't any links or no '?attachment_id=' strings (strpos cannot be zero)
813 if ( !strpos($content, '?attachment_id=') || !preg_match_all( '/<a ([^>]+)>[\s\S]+?<\/a>/', $content, $link_matches ) )
816 $site_url = get_bloginfo('url');
817 $site_url = substr( $site_url, (int) strpos($site_url, '://') ); // remove the http(s)
820 foreach ( $link_matches[1] as $key => $value ) {
821 if ( !strpos($value, '?attachment_id=') || !strpos($value, 'wp-att-')
822 || !preg_match( '/href=(["\'])[^"\']*\?attachment_id=(\d+)[^"\']*\\1/', $value, $url_match )
823 || !preg_match( '/rel=["\'][^"\']*wp-att-(\d+)/', $value, $rel_match ) )
826 $quote = $url_match[1]; // the quote (single or double)
827 $url_id = (int) $url_match[2];
828 $rel_id = (int) $rel_match[1];
830 if ( !$url_id || !$rel_id || $url_id != $rel_id || strpos($url_match[0], $site_url) === false )
833 $link = $link_matches[0][$key];
834 $replace = str_replace( $url_match[0], 'href=' . $quote . get_attachment_link( $url_id ) . $quote, $link );
836 $content = str_replace( $link, $replace, $content );
840 $post['post_content'] = $content;
841 // Escape data pulled from DB.
842 $post = add_magic_quotes($post);
844 return wp_update_post($post);
849 * Move child posts to a new parent.
854 * @param unknown_type $old_ID
855 * @param unknown_type $new_ID
858 function _relocate_children( $old_ID, $new_ID ) {
860 $old_ID = (int) $old_ID;
861 $new_ID = (int) $new_ID;
863 $children = $wpdb->get_col( $wpdb->prepare("
866 WHERE meta_key = '_wp_attachment_temp_parent'
867 AND meta_value = %d", $old_ID) );
869 foreach ( $children as $child_id ) {
870 $wpdb->update($wpdb->posts, array('post_parent' => $new_ID), array('ID' => $child_id) );
871 delete_post_meta($child_id, '_wp_attachment_temp_parent');
876 * Get all the possible statuses for a post_type
880 * @param string $type The post_type you want the statuses for
881 * @return array As array of all the statuses for the supplied post type
883 function get_available_post_statuses($type = 'post') {
884 $stati = wp_count_posts($type);
886 return array_keys(get_object_vars($stati));
890 * Run the wp query to fetch the posts for listing on the edit posts page
894 * @param array|bool $q Array of query variables to use to build the query or false to use $_GET superglobal.
897 function wp_edit_posts_query( $q = false ) {
900 $q['m'] = isset($q['m']) ? (int) $q['m'] : 0;
901 $q['cat'] = isset($q['cat']) ? (int) $q['cat'] : 0;
902 $post_stati = get_post_stati();
904 if ( isset($q['post_type']) && in_array( $q['post_type'], get_post_types() ) )
905 $post_type = $q['post_type'];
909 $avail_post_stati = get_available_post_statuses($post_type);
911 if ( isset($q['post_status']) && in_array( $q['post_status'], $post_stati ) ) {
912 $post_status = $q['post_status'];
916 if ( isset($q['orderby']) )
917 $orderby = $q['orderby'];
918 elseif ( isset($q['post_status']) && in_array($q['post_status'], array('pending', 'draft')) )
919 $orderby = 'modified';
921 if ( isset($q['order']) )
922 $order = $q['order'];
923 elseif ( isset($q['post_status']) && 'pending' == $q['post_status'] )
926 $per_page = 'edit_' . $post_type . '_per_page';
927 $posts_per_page = (int) get_user_option( $per_page );
928 if ( empty( $posts_per_page ) || $posts_per_page < 1 )
929 $posts_per_page = 20;
931 $posts_per_page = apply_filters( $per_page, $posts_per_page );
932 $posts_per_page = apply_filters( 'edit_posts_per_page', $posts_per_page, $post_type );
934 $query = compact('post_type', 'post_status', 'perm', 'order', 'orderby', 'posts_per_page');
936 // Hierarchical types require special args.
937 if ( is_post_type_hierarchical( $post_type ) && !isset($orderby) ) {
938 $query['orderby'] = 'menu_order title';
939 $query['order'] = 'asc';
940 $query['posts_per_page'] = -1;
941 $query['posts_per_archive_page'] = -1;
944 if ( ! empty( $q['show_sticky'] ) )
945 $query['post__in'] = (array) get_option( 'sticky_posts' );
949 return $avail_post_stati;
953 * {@internal Missing Short Description}}
957 * @param unknown_type $type
960 function get_available_post_mime_types($type = 'attachment') {
963 $types = $wpdb->get_col($wpdb->prepare("SELECT DISTINCT post_mime_type FROM $wpdb->posts WHERE post_type = %s", $type));
968 * Executes a query for attachments. An array of WP_Query arguments
969 * can be passed in, which will override the arguments set by this function.
972 * @uses apply_filters() Calls 'upload_per_page' on posts_per_page argument
974 * @param array|bool $q Array of query variables to use to build the query or false to use $_GET superglobal.
977 function wp_edit_attachments_query( $q = false ) {
981 $q['m'] = isset( $q['m'] ) ? (int) $q['m'] : 0;
982 $q['cat'] = isset( $q['cat'] ) ? (int) $q['cat'] : 0;
983 $q['post_type'] = 'attachment';
984 $post_type = get_post_type_object( 'attachment' );
986 if ( current_user_can( $post_type->cap->read_private_posts ) )
987 $states .= ',private';
989 $q['post_status'] = isset( $q['status'] ) && 'trash' == $q['status'] ? 'trash' : $states;
990 $media_per_page = (int) get_user_option( 'upload_per_page' );
991 if ( empty( $media_per_page ) || $media_per_page < 1 )
992 $media_per_page = 20;
993 $q['posts_per_page'] = apply_filters( 'upload_per_page', $media_per_page );
995 $post_mime_types = get_post_mime_types();
996 $avail_post_mime_types = get_available_post_mime_types('attachment');
998 if ( isset($q['post_mime_type']) && !array_intersect( (array) $q['post_mime_type'], array_keys($post_mime_types) ) )
999 unset($q['post_mime_type']);
1001 if ( isset($q['detached']) )
1002 add_filter('posts_where', '_edit_attachments_query_helper');
1006 if ( isset($q['detached']) )
1007 remove_filter('posts_where', '_edit_attachments_query_helper');
1009 return array($post_mime_types, $avail_post_mime_types);
1012 function _edit_attachments_query_helper($where) {
1014 return $where .= " AND {$wpdb->posts}.post_parent < 1";
1018 * Returns the list of classes to be used by a metabox
1020 * @uses get_user_option()
1023 * @param unknown_type $id
1024 * @param unknown_type $page
1027 function postbox_classes( $id, $page ) {
1028 if ( isset( $_GET['edit'] ) && $_GET['edit'] == $id ) {
1029 $classes = array( '' );
1030 } elseif ( $closed = get_user_option('closedpostboxes_'.$page ) ) {
1031 if ( !is_array( $closed ) ) {
1032 $classes = array( '' );
1034 $classes = in_array( $id, $closed ) ? array( 'closed' ) : array( '' );
1037 $classes = array( '' );
1040 $classes = apply_filters( "postbox_classes_{$page}_{$id}", $classes );
1041 return implode( ' ', $classes );
1045 * {@internal Missing Short Description}}
1049 * @param int|object $id Post ID or post object.
1050 * @param string $title (optional) Title
1051 * @param string $name (optional) Name
1052 * @return array With two entries of type string
1054 function get_sample_permalink($id, $title = null, $name = null) {
1055 $post = get_post( $id );
1057 return array( '', '' );
1059 $ptype = get_post_type_object($post->post_type);
1061 $original_status = $post->post_status;
1062 $original_date = $post->post_date;
1063 $original_name = $post->post_name;
1065 // Hack: get_permalink() would return ugly permalink for drafts, so we will fake that our post is published.
1066 if ( in_array( $post->post_status, array( 'draft', 'pending' ) ) ) {
1067 $post->post_status = 'publish';
1068 $post->post_name = sanitize_title($post->post_name ? $post->post_name : $post->post_title, $post->ID);
1071 // If the user wants to set a new name -- override the current one
1072 // Note: if empty name is supplied -- use the title instead, see #6072
1073 if ( !is_null($name) )
1074 $post->post_name = sanitize_title($name ? $name : $title, $post->ID);
1076 $post->post_name = wp_unique_post_slug($post->post_name, $post->ID, $post->post_status, $post->post_type, $post->post_parent);
1078 $post->filter = 'sample';
1080 $permalink = get_permalink($post, true);
1082 // Replace custom post_type Token with generic pagename token for ease of use.
1083 $permalink = str_replace("%$post->post_type%", '%pagename%', $permalink);
1085 // Handle page hierarchy
1086 if ( $ptype->hierarchical ) {
1087 $uri = get_page_uri($post);
1088 $uri = untrailingslashit($uri);
1089 $uri = strrev( stristr( strrev( $uri ), '/' ) );
1090 $uri = untrailingslashit($uri);
1091 $uri = apply_filters( 'editable_slug', $uri );
1094 $permalink = str_replace('%pagename%', "{$uri}%pagename%", $permalink);
1097 $permalink = array($permalink, apply_filters('editable_slug', $post->post_name));
1098 $post->post_status = $original_status;
1099 $post->post_date = $original_date;
1100 $post->post_name = $original_name;
1101 unset($post->filter);
1107 * Returns the HTML of the sample permalink slug editor.
1111 * @param int|object $id Post ID or post object.
1112 * @param string $new_title Optional. New title.
1113 * @param string $new_slug Optional. New slug.
1114 * @return string The HTML of the sample permalink slug editor.
1116 function get_sample_permalink_html( $id, $new_title = null, $new_slug = null ) {
1117 $post = get_post( $id );
1121 list($permalink, $post_name) = get_sample_permalink($post->ID, $new_title, $new_slug);
1123 if ( 'publish' == get_post_status( $post ) ) {
1124 $ptype = get_post_type_object($post->post_type);
1125 $view_post = $ptype->labels->view_item;
1126 $title = __('Click to edit this part of the permalink');
1128 $title = __('Temporary permalink. Click to edit this part.');
1131 if ( false === strpos($permalink, '%postname%') && false === strpos($permalink, '%pagename%') ) {
1132 $return = '<strong>' . __('Permalink:') . "</strong>\n" . '<span id="sample-permalink" tabindex="-1">' . $permalink . "</span>\n";
1133 if ( '' == get_option( 'permalink_structure' ) && current_user_can( 'manage_options' ) && !( 'page' == get_option('show_on_front') && $id == get_option('page_on_front') ) )
1134 $return .= '<span id="change-permalinks"><a href="options-permalink.php" class="button button-small" target="_blank">' . __('Change Permalinks') . "</a></span>\n";
1135 if ( isset( $view_post ) )
1136 $return .= "<span id='view-post-btn'><a href='$permalink' class='button button-small'>$view_post</a></span>\n";
1138 $return = apply_filters('get_sample_permalink_html', $return, $id, $new_title, $new_slug);
1143 if ( function_exists('mb_strlen') ) {
1144 if ( mb_strlen($post_name) > 30 ) {
1145 $post_name_abridged = mb_substr($post_name, 0, 14). '…' . mb_substr($post_name, -14);
1147 $post_name_abridged = $post_name;
1150 if ( strlen($post_name) > 30 ) {
1151 $post_name_abridged = substr($post_name, 0, 14). '…' . substr($post_name, -14);
1153 $post_name_abridged = $post_name;
1157 $post_name_html = '<span id="editable-post-name" title="' . $title . '">' . $post_name_abridged . '</span>';
1158 $display_link = str_replace(array('%pagename%','%postname%'), $post_name_html, $permalink);
1159 $view_link = str_replace(array('%pagename%','%postname%'), $post_name, $permalink);
1160 $return = '<strong>' . __('Permalink:') . "</strong>\n";
1161 $return .= '<span id="sample-permalink" tabindex="-1">' . $display_link . "</span>\n";
1162 $return .= '‎'; // Fix bi-directional text display defect in RTL languages.
1163 $return .= '<span id="edit-slug-buttons"><a href="#post_name" class="edit-slug button button-small hide-if-no-js" onclick="editPermalink(' . $id . '); return false;">' . __('Edit') . "</a></span>\n";
1164 $return .= '<span id="editable-post-name-full">' . $post_name . "</span>\n";
1165 if ( isset($view_post) )
1166 $return .= "<span id='view-post-btn'><a href='$view_link' class='button button-small'>$view_post</a></span>\n";
1168 $return = apply_filters('get_sample_permalink_html', $return, $id, $new_title, $new_slug);
1174 * Output HTML for the post thumbnail meta-box.
1178 * @param int $thumbnail_id ID of the attachment used for thumbnail
1179 * @param mixed $post The post ID or object associated with the thumbnail, defaults to global $post.
1180 * @return string html
1182 function _wp_post_thumbnail_html( $thumbnail_id = null, $post = null ) {
1183 global $content_width, $_wp_additional_image_sizes;
1185 $post = get_post( $post );
1187 $upload_iframe_src = esc_url( get_upload_iframe_src('image', $post->ID ) );
1188 $set_thumbnail_link = '<p class="hide-if-no-js"><a title="' . esc_attr__( 'Set featured image' ) . '" href="%s" id="set-post-thumbnail" class="thickbox">%s</a></p>';
1189 $content = sprintf( $set_thumbnail_link, $upload_iframe_src, esc_html__( 'Set featured image' ) );
1191 if ( $thumbnail_id && get_post( $thumbnail_id ) ) {
1192 $old_content_width = $content_width;
1193 $content_width = 266;
1194 if ( !isset( $_wp_additional_image_sizes['post-thumbnail'] ) )
1195 $thumbnail_html = wp_get_attachment_image( $thumbnail_id, array( $content_width, $content_width ) );
1197 $thumbnail_html = wp_get_attachment_image( $thumbnail_id, 'post-thumbnail' );
1198 if ( !empty( $thumbnail_html ) ) {
1199 $ajax_nonce = wp_create_nonce( 'set_post_thumbnail-' . $post->ID );
1200 $content = sprintf( $set_thumbnail_link, $upload_iframe_src, $thumbnail_html );
1201 $content .= '<p class="hide-if-no-js"><a href="#" id="remove-post-thumbnail" onclick="WPRemoveThumbnail(\'' . $ajax_nonce . '\');return false;">' . esc_html__( 'Remove featured image' ) . '</a></p>';
1203 $content_width = $old_content_width;
1206 return apply_filters( 'admin_post_thumbnail_html', $content, $post->ID );
1210 * Check to see if the post is currently being edited by another user.
1214 * @param int $post_id ID of the post to check for editing
1215 * @return bool|int False: not locked or locked by current user. Int: user ID of user with lock.
1217 function wp_check_post_lock( $post_id ) {
1218 if ( !$post = get_post( $post_id ) )
1221 if ( !$lock = get_post_meta( $post->ID, '_edit_lock', true ) )
1224 $lock = explode( ':', $lock );
1226 $user = isset( $lock[1] ) ? $lock[1] : get_post_meta( $post->ID, '_edit_last', true );
1228 $time_window = apply_filters( 'wp_check_post_lock_window', 120 );
1230 if ( $time && $time > time() - $time_window && $user != get_current_user_id() )
1236 * Mark the post as currently being edited by the current user
1240 * @param int $post_id ID of the post to being edited
1241 * @return bool|array Returns false if the post doesn't exist of there is no current user, or
1242 * an array of the lock time and the user ID.
1244 function wp_set_post_lock( $post_id ) {
1245 if ( !$post = get_post( $post_id ) )
1247 if ( 0 == ($user_id = get_current_user_id()) )
1251 $lock = "$now:$user_id";
1253 update_post_meta( $post->ID, '_edit_lock', $lock );
1254 return array( $now, $user_id );
1258 * Outputs the HTML for the notice to say that someone else is editing or has taken over editing of this post.
1263 function _admin_notice_post_locked() {
1264 if ( ! $post = get_post() )
1268 if ( $user_id = wp_check_post_lock( $post->ID ) )
1269 $user = get_userdata( $user_id );
1272 if ( ! apply_filters( 'show_post_locked_dialog', true, $post, $user ) )
1280 if ( $locked && ( $sendback = wp_get_referer() ) &&
1281 false === strpos( $sendback, 'post.php' ) && false === strpos( $sendback, 'post-new.php' ) ) {
1283 $sendback_text = __('Go back');
1285 $sendback = admin_url( 'edit.php' );
1287 if ( 'post' != $post->post_type )
1288 $sendback = add_query_arg( 'post_type', $post->post_type, $sendback );
1290 $sendback_text = get_post_type_object( $post->post_type )->labels->all_items;
1293 $hidden = $locked ? '' : ' hidden';
1296 <div id="post-lock-dialog" class="notification-dialog-wrap<?php echo $hidden; ?>">
1297 <div class="notification-dialog-background"></div>
1298 <div class="notification-dialog">
1302 if ( get_post_type_object( $post->post_type )->public ) {
1303 $preview_link = set_url_scheme( add_query_arg( 'preview', 'true', get_permalink( $post->ID ) ) );
1305 if ( 'publish' == $post->post_status || $user->ID != $post->post_author ) {
1306 // Latest content is in autosave
1307 $nonce = wp_create_nonce( 'post_preview_' . $post->ID );
1308 $preview_link = add_query_arg( array( 'preview_id' => $post->ID, 'preview_nonce' => $nonce ), $preview_link );
1314 $preview_link = apply_filters( 'preview_post_link', $preview_link );
1315 $override = apply_filters( 'override_post_lock', true, $post, $user );
1316 $tab_last = $override ? '' : ' wp-tab-last';
1319 <div class="post-locked-message">
1320 <div class="post-locked-avatar"><?php echo get_avatar( $user->ID, 64 ); ?></div>
1321 <p class="currently-editing wp-tab-first" tabindex="0">
1323 _e( 'This content is currently locked.' );
1325 printf( ' ' . __( 'If you take over, %s will be blocked from continuing to edit.' ), esc_html( $user->display_name ) );
1328 <?php do_action( 'post_locked_dialog', $post ); ?>
1330 <a class="button" href="<?php echo esc_url( $sendback ); ?>"><?php echo $sendback_text; ?></a>
1331 <?php if ( $preview_link ) { ?>
1332 <a class="button<?php echo $tab_last; ?>" href="<?php echo esc_url( $preview_link ); ?>"><?php _e('Preview'); ?></a>
1336 // Allow plugins to prevent some users overriding the post lock
1339 <a class="button button-primary wp-tab-last" href="<?php echo esc_url( add_query_arg( 'get-post-lock', '1', get_edit_post_link( $post->ID, 'url' ) ) ); ?>"><?php _e('Take over'); ?></a>
1349 <div class="post-taken-over">
1350 <div class="post-locked-avatar"></div>
1351 <p class="wp-tab-first" tabindex="0">
1352 <span class="currently-editing"></span><br>
1353 <span class="locked-saving hidden"><img src="images/wpspin_light-2x.gif" width="16" height="16" /> <?php _e('Saving revision...'); ?></span>
1354 <span class="locked-saved hidden"><?php _e('Your latest changes were saved as a revision.'); ?></span>
1356 <?php do_action( 'post_lock_lost_dialog', $post ); ?>
1357 <p><a class="button button-primary wp-tab-last" href="<?php echo esc_url( $sendback ); ?>"><?php echo $sendback_text; ?></a></p>
1369 * Creates autosave data for the specified post from $_POST data.
1371 * @package WordPress
1372 * @subpackage Post_Revisions
1375 * @uses _wp_translate_postdata()
1376 * @uses _wp_post_revision_fields()
1380 function wp_create_post_autosave( $post_id ) {
1381 $translated = _wp_translate_postdata( true );
1382 if ( is_wp_error( $translated ) )
1385 $post_author = get_current_user_id();
1387 // Store one autosave per author. If there is already an autosave, overwrite it.
1388 if ( $old_autosave = wp_get_post_autosave( $post_id, $post_author ) ) {
1389 $new_autosave = _wp_post_revision_fields( $_POST, true );
1390 $new_autosave['ID'] = $old_autosave->ID;
1391 $new_autosave['post_author'] = $post_author;
1393 // If the new autosave is the same content as the post, delete the old autosave.
1394 $post = get_post( $post_id );
1395 $autosave_is_different = false;
1396 foreach ( array_keys( _wp_post_revision_fields() ) as $field ) {
1397 if ( normalize_whitespace( $new_autosave[ $field ] ) != normalize_whitespace( $post->$field ) ) {
1398 $autosave_is_different = true;
1403 if ( ! $autosave_is_different ) {
1404 wp_delete_post_revision( $old_autosave->ID );
1408 return wp_update_post( $new_autosave );
1411 // _wp_put_post_revision() expects unescaped.
1412 $post_data = wp_unslash( $_POST );
1414 // Otherwise create the new autosave as a special post revision
1415 return _wp_put_post_revision( $post_data, true );
1419 * Save draft or manually autosave for showing preview.
1421 * @package WordPress
1424 * @uses get_post_status()
1427 * @uses current_user_can()
1429 * @uses wp_create_post_autosave()
1430 * @uses add_query_arg()
1431 * @uses wp_create_nonce()
1433 * @return str URL to redirect to show the preview
1435 function post_preview() {
1437 $post_ID = (int) $_POST['post_ID'];
1438 $status = get_post_status( $post_ID );
1439 if ( 'auto-draft' == $status )
1440 wp_die( __('Preview not available. Please save as a draft first.') );
1442 if ( isset($_POST['catslist']) )
1443 $_POST['post_category'] = explode(",", $_POST['catslist']);
1445 if ( isset($_POST['tags_input']) )
1446 $_POST['tags_input'] = explode(",", $_POST['tags_input']);
1448 if ( $_POST['post_type'] == 'page' || empty($_POST['post_category']) )
1449 unset($_POST['post_category']);
1451 $_POST['ID'] = $post_ID;
1452 $post = get_post($post_ID);
1454 if ( 'page' == $post->post_type ) {
1455 if ( ! current_user_can('edit_page', $post_ID) )
1456 wp_die( __('You are not allowed to edit this page.') );
1458 if ( ! current_user_can('edit_post', $post_ID) )
1459 wp_die( __('You are not allowed to edit this post.') );
1462 $user_id = get_current_user_id();
1463 $locked = wp_check_post_lock( $post->ID );
1464 if ( ! $locked && 'draft' == $post->post_status && $user_id == $post->post_author ) {
1466 } else { // Non drafts are not overwritten. The autosave is stored in a special post revision.
1467 $id = wp_create_post_autosave( $post->ID );
1468 if ( ! is_wp_error($id) )
1472 if ( is_wp_error($id) )
1473 wp_die( $id->get_error_message() );
1475 if ( ! $locked && $_POST['post_status'] == 'draft' && $user_id == $post->post_author ) {
1476 $url = add_query_arg( 'preview', 'true', get_permalink($id) );
1478 $nonce = wp_create_nonce('post_preview_' . $id);
1480 'preview' => 'true',
1481 'preview_id' => $id,
1482 'preview_nonce' => $nonce,
1485 if ( isset( $_POST['post_format'] ) )
1486 $args['post_format'] = empty( $_POST['post_format'] ) ? 'standard' : sanitize_key( $_POST['post_format'] );
1488 $url = add_query_arg( $args, get_permalink($id) );
1491 return apply_filters( 'preview_post_link', $url );