3 * Media Library administration panel.
6 * @subpackage Administration
9 /** WordPress Administration Bootstrap */
10 require_once('admin.php');
11 wp_enqueue_script( 'wp-ajax-response' );
12 wp_enqueue_script( 'jquery-ui-draggable' );
14 if ( !current_user_can('upload_files') )
15 wp_die(__('You do not have permission to upload files.'));
17 if ( isset($_GET['find_detached']) ) {
18 check_admin_referer('bulk-media');
20 if ( !current_user_can('edit_posts') )
21 wp_die( __('You are not allowed to scan for lost attachments.') );
23 $all_posts = $wpdb->get_col("SELECT ID FROM $wpdb->posts WHERE post_type = 'post' OR post_type = 'page'");
24 $all_att = $wpdb->get_results("SELECT ID, post_parent FROM $wpdb->posts WHERE post_type = 'attachment'");
27 foreach ( (array) $all_att as $att ) {
28 if ( $att->post_parent > 0 && ! in_array($att->post_parent, $all_posts) )
31 $_GET['detached'] = 1;
33 } elseif ( isset($_GET['found_post_id']) && isset($_GET['media']) ) {
34 check_admin_referer('bulk-media');
36 if ( ! ( $parent_id = (int) $_GET['found_post_id'] ) )
39 $parent = &get_post($parent_id);
40 if ( !current_user_can('edit_post', $parent_id) )
41 wp_die( __('You are not allowed to edit this post.') );
44 foreach( (array) $_GET['media'] as $att_id ) {
45 $att_id = (int) $att_id;
47 if ( !current_user_can('edit_post', $att_id) )
53 if ( ! empty($attach) ) {
54 $attach = implode(',', $attach);
55 $attached = $wpdb->query( $wpdb->prepare("UPDATE $wpdb->posts SET post_parent = %d WHERE post_type = 'attachment' AND ID IN ($attach)", $parent_id) );
58 if ( isset($attached) ) {
59 $location = 'upload.php';
60 if ( $referer = wp_get_referer() ) {
61 if ( false !== strpos($referer, 'upload.php') )
65 $location = add_query_arg( array( 'attached' => $attached ) , $location );
66 wp_redirect($location);
70 } elseif ( isset($_GET['doaction']) || isset($_GET['doaction2']) || isset($_GET['delete_all']) || isset($_GET['delete_all2']) ) {
71 check_admin_referer('bulk-media');
73 if ( isset($_GET['delete_all']) || isset($_GET['delete_all2']) ) {
74 $post_ids = $wpdb->get_col( "SELECT ID FROM $wpdb->posts WHERE post_type='attachment' AND post_status = 'trash'" );
76 } elseif ( ( $_GET['action'] != -1 || $_GET['action2'] != -1 ) && ( isset($_GET['media']) || isset($_GET['ids']) ) ) {
77 $post_ids = isset($_GET['media']) ? $_GET['media'] : explode(',', $_GET['ids']);
78 $doaction = ($_GET['action'] != -1) ? $_GET['action'] : $_GET['action2'];
80 wp_redirect($_SERVER['HTTP_REFERER']);
83 $location = 'upload.php';
84 if ( $referer = wp_get_referer() ) {
85 if ( false !== strpos($referer, 'upload.php') )
86 $location = remove_query_arg( array('trashed', 'untrashed', 'deleted', 'message', 'ids', 'posted'), $referer );
89 switch ( $doaction ) {
91 foreach( (array) $post_ids as $post_id ) {
92 if ( !current_user_can('delete_post', $post_id) )
93 wp_die( __('You are not allowed to move this post to the trash.') );
95 if ( !wp_trash_post($post_id) )
96 wp_die( __('Error in moving to trash...') );
98 $location = add_query_arg( array( 'message' => 4, 'ids' => join(',', $post_ids) ), $location );
101 foreach( (array) $post_ids as $post_id ) {
102 if ( !current_user_can('delete_post', $post_id) )
103 wp_die( __('You are not allowed to move this post out of the trash.') );
105 if ( !wp_untrash_post($post_id) )
106 wp_die( __('Error in restoring from trash...') );
108 $location = add_query_arg('message', 5, $location);
111 foreach( (array) $post_ids as $post_id_del ) {
112 if ( !current_user_can('delete_post', $post_id_del) )
113 wp_die( __('You are not allowed to delete this post.') );
115 if ( !wp_delete_attachment($post_id_del) )
116 wp_die( __('Error in deleting...') );
118 $location = add_query_arg('message', 2, $location);
122 wp_redirect($location);
124 } elseif ( isset($_GET['_wp_http_referer']) && ! empty($_GET['_wp_http_referer']) ) {
125 wp_redirect( remove_query_arg( array('_wp_http_referer', '_wpnonce'), stripslashes($_SERVER['REQUEST_URI']) ) );
129 $title = __('Media Library');
130 $parent_file = 'upload.php';
132 if ( ! isset( $_GET['paged'] ) || $_GET['paged'] < 1 )
135 if ( isset($_GET['detached']) ) {
137 $media_per_page = (int) get_user_option( 'upload_per_page', 0, false );
138 if ( empty($media_per_page) || $media_per_page < 1 )
139 $media_per_page = 20;
140 $media_per_page = apply_filters( 'upload_per_page', $media_per_page );
142 if ( !empty($lost) ) {
143 $start = ( (int) $_GET['paged'] - 1 ) * $media_per_page;
144 $page_links_total = ceil(count($lost) / $media_per_page);
145 $lost = implode(',', $lost);
147 $orphans = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM $wpdb->posts WHERE post_type = 'attachment' AND ID IN (%s) LIMIT %d, %d", $lost, $start, $media_per_page ) );
149 $start = ( (int) $_GET['paged'] - 1 ) * $media_per_page;
150 $orphans = $wpdb->get_results( $wpdb->prepare( "SELECT SQL_CALC_FOUND_ROWS * FROM $wpdb->posts WHERE post_type = 'attachment' AND post_status != 'trash' AND post_parent < 1 LIMIT %d, %d", $start, $media_per_page ) );
151 $page_links_total = ceil($wpdb->get_var( "SELECT FOUND_ROWS()" ) / $media_per_page);
154 $post_mime_types = get_post_mime_types();
155 $avail_post_mime_types = get_available_post_mime_types('attachment');
157 if ( isset($_GET['post_mime_type']) && !array_intersect( (array) $_GET['post_mime_type'], array_keys($post_mime_types) ) )
158 unset($_GET['post_mime_type']);
161 list($post_mime_types, $avail_post_mime_types) = wp_edit_attachments_query();
164 $is_trash = ( isset($_GET['status']) && $_GET['status'] == 'trash' );
166 wp_enqueue_script('media');
167 require_once('admin-header.php');
169 do_action('restrict_manage_posts');
173 <?php screen_icon(); ?>
174 <h2><?php echo esc_html( $title ); ?> <a href="media-new.php" class="button add-new-h2"><?php echo esc_html_x('Add New', 'file'); ?></a> <?php
175 if ( isset($_GET['s']) && $_GET['s'] )
176 printf( '<span class="subtitle">' . __('Search results for “%s”') . '</span>', esc_html( get_search_query() ) ); ?>
181 if ( isset($_GET['posted']) && (int) $_GET['posted'] ) {
182 $_GET['message'] = '1';
183 $_SERVER['REQUEST_URI'] = remove_query_arg(array('posted'), $_SERVER['REQUEST_URI']);
186 if ( isset($_GET['attached']) && (int) $_GET['attached'] ) {
187 $attached = (int) $_GET['attached'];
188 $message = sprintf( _n('Reattached %d attachment', 'Reattached %d attachments', $attached), $attached );
189 $_SERVER['REQUEST_URI'] = remove_query_arg(array('attached'), $_SERVER['REQUEST_URI']);
192 if ( isset($_GET['deleted']) && (int) $_GET['deleted'] ) {
193 $_GET['message'] = '2';
194 $_SERVER['REQUEST_URI'] = remove_query_arg(array('deleted'), $_SERVER['REQUEST_URI']);
197 if ( isset($_GET['trashed']) && (int) $_GET['trashed'] ) {
198 $_GET['message'] = '4';
199 $_SERVER['REQUEST_URI'] = remove_query_arg(array('trashed'), $_SERVER['REQUEST_URI']);
202 if ( isset($_GET['untrashed']) && (int) $_GET['untrashed'] ) {
203 $_GET['message'] = '5';
204 $_SERVER['REQUEST_URI'] = remove_query_arg(array('untrashed'), $_SERVER['REQUEST_URI']);
207 $messages[1] = __('Media attachment updated.');
208 $messages[2] = __('Media permanently deleted.');
209 $messages[3] = __('Error saving media attachment.');
210 $messages[4] = __('Media moved to the trash.') . ' <a href="' . esc_url( wp_nonce_url( 'upload.php?doaction=undo&action=untrash&ids='.(isset($_GET['ids']) ? $_GET['ids'] : ''), "bulk-media" ) ) . '">' . __('Undo') . '</a>';
211 $messages[5] = __('Media restored from the trash.');
213 if ( isset($_GET['message']) && (int) $_GET['message'] ) {
214 $message = $messages[$_GET['message']];
215 $_SERVER['REQUEST_URI'] = remove_query_arg(array('message'), $_SERVER['REQUEST_URI']);
218 if ( !empty($message) ) { ?>
219 <div id="message" class="updated fade"><p><?php echo $message; ?></p></div>
222 <ul class="subsubsub">
224 $type_links = array();
225 $_num_posts = (array) wp_count_attachments();
226 $_total_posts = array_sum($_num_posts) - $_num_posts['trash'];
227 $matches = wp_match_mime_types(array_keys($post_mime_types), array_keys($_num_posts));
228 foreach ( $matches as $type => $reals )
229 foreach ( $reals as $real )
230 $num_posts[$type] = ( isset( $num_posts[$type] ) ) ? $num_posts[$type] + $_num_posts[$real] : $_num_posts[$real];
232 $class = ( empty($_GET['post_mime_type']) && !isset($_GET['detached']) && !isset($_GET['status']) ) ? ' class="current"' : '';
233 $type_links[] = "<li><a href='upload.php'$class>" . sprintf( _nx( 'All <span class="count">(%s)</span>', 'All <span class="count">(%s)</span>', $_total_posts, 'uploaded files' ), number_format_i18n( $_total_posts ) ) . '</a>';
234 foreach ( $post_mime_types as $mime_type => $label ) {
237 if ( !wp_match_mime_types($mime_type, $avail_post_mime_types) )
240 if ( !empty($_GET['post_mime_type']) && wp_match_mime_types($mime_type, $_GET['post_mime_type']) )
241 $class = ' class="current"';
243 $type_links[] = "<li><a href='upload.php?post_mime_type=$mime_type'$class>" . sprintf( _n( $label[2][0], $label[2][1], $num_posts[$mime_type] ), number_format_i18n( $num_posts[$mime_type] )) . '</a>';
245 $type_links[] = '<li><a href="upload.php?detached=1"' . ( isset($_GET['detached']) ? ' class="current"' : '' ) . '>' . __('Unattached') . '</a>';
246 if ( EMPTY_TRASH_DAYS && ( MEDIA_TRASH || !empty($_num_posts['trash']) ) )
247 $type_links[] = '<li><a href="upload.php?status=trash"' . ( (isset($_GET['status']) && $_GET['status'] == 'trash' ) ? ' class="current"' : '') . '>' . sprintf( _nx( 'Trash <span class="count">(%s)</span>', 'Trash <span class="count">(%s)</span>', $_num_posts['trash'], 'uploaded files' ), number_format_i18n( $_num_posts['trash'] ) ) . '</a>';
249 echo implode( " |</li>\n", $type_links) . '</li>';
254 <form class="search-form" action="" method="get">
255 <p class="search-box">
256 <label class="screen-reader-text" for="media-search-input"><?php _e( 'Search Media' ); ?>:</label>
257 <input type="text" id="media-search-input" name="s" value="<?php the_search_query(); ?>" />
258 <input type="submit" value="<?php esc_attr_e( 'Search Media' ); ?>" class="button" />
262 <form id="posts-filter" action="" method="get">
263 <div class="tablenav">
265 if ( ! isset($page_links_total) )
266 $page_links_total = $wp_query->max_num_pages;
268 $page_links = paginate_links( array(
269 'base' => add_query_arg( 'paged', '%#%' ),
271 'prev_text' => __('«'),
272 'next_text' => __('»'),
273 'total' => $page_links_total,
274 'current' => $_GET['paged']
277 if ( $page_links ) : ?>
278 <div class="tablenav-pages"><?php $page_links_text = sprintf( '<span class="displaying-num">' . __( 'Displaying %s–%s of %s' ) . '</span>%s',
279 number_format_i18n( ( $_GET['paged'] - 1 ) * $wp_query->query_vars['posts_per_page'] + 1 ),
280 number_format_i18n( min( $_GET['paged'] * $wp_query->query_vars['posts_per_page'], $wp_query->found_posts ) ),
281 number_format_i18n( $wp_query->found_posts ),
283 ); echo $page_links_text; ?></div>
286 <div class="alignleft actions">
287 <select name="action" class="select-action">
288 <option value="-1" selected="selected"><?php _e('Bulk Actions'); ?></option>
289 <?php if ( $is_trash ) { ?>
290 <option value="untrash"><?php _e('Restore'); ?></option>
291 <?php } if ( $is_trash || !EMPTY_TRASH_DAYS || !MEDIA_TRASH ) { ?>
292 <option value="delete"><?php _e('Delete Permanently'); ?></option>
294 <option value="trash"><?php _e('Move to Trash'); ?></option>
295 <?php } if ( isset($orphans) ) { ?>
296 <option value="attach"><?php _e('Attach to a post'); ?></option>
299 <input type="submit" value="<?php esc_attr_e('Apply'); ?>" name="doaction" id="doaction" class="button-secondary action" />
300 <?php wp_nonce_field('bulk-media'); ?>
303 if ( !is_singular() && !isset($_GET['detached']) && !$is_trash ) {
304 $arc_query = "SELECT DISTINCT YEAR(post_date) AS yyear, MONTH(post_date) AS mmonth FROM $wpdb->posts WHERE post_type = 'attachment' ORDER BY post_date DESC";
306 $arc_result = $wpdb->get_results( $arc_query );
308 $month_count = count($arc_result);
310 if ( $month_count && !( 1 == $month_count && 0 == $arc_result[0]->mmonth ) ) : ?>
312 <option value='0'><?php _e('Show all dates'); ?></option>
314 foreach ($arc_result as $arc_row) {
315 if ( $arc_row->yyear == 0 )
317 $arc_row->mmonth = zeroise( $arc_row->mmonth, 2 );
319 if ( isset($_GET['m']) && ( $arc_row->yyear . $arc_row->mmonth == $_GET['m'] ) )
320 $default = ' selected="selected"';
324 echo "<option$default value='" . esc_attr("$arc_row->yyear$arc_row->mmonth") . "'>";
325 echo $wp_locale->get_month($arc_row->mmonth) . " $arc_row->yyear";
330 <?php endif; // month_count ?>
332 <input type="submit" id="post-query-submit" value="<?php esc_attr_e('Filter'); ?>" class="button-secondary" />
334 <?php } // ! is_singular ?>
336 <?php if ( isset($_GET['detached']) ) { ?>
337 <input type="submit" id="find_detached" name="find_detached" value="<?php esc_attr_e('Scan for lost attachments'); ?>" class="button-secondary" />
338 <?php } elseif ( isset($_GET['status']) && $_GET['status'] == 'trash' && current_user_can('edit_others_posts') ) { ?>
339 <input type="submit" id="delete_all" name="delete_all" value="<?php esc_attr_e('Empty Trash'); ?>" class="button-secondary apply" />
347 <div class="clear"></div>
349 <?php if ( isset($orphans) ) { ?>
350 <table class="widefat" cellspacing="0">
353 <th scope="col" class="check-column"><input type="checkbox" /></th>
354 <th scope="col"></th>
355 <th scope="col"><?php /* translators: column name in media */ echo _x('Media', 'media column name'); ?></th>
356 <th scope="col"><?php /* translators: column name in media */ echo _x('Author', 'media column name'); ?></th>
357 <th scope="col"><?php /* translators: column name in media */ echo _x('Date Added', 'media column name'); ?></th>
363 <th scope="col" class="check-column"><input type="checkbox" /></th>
364 <th scope="col"></th>
365 <th scope="col"><?php /* translators: column name in media */ echo _x('Media', 'media column name'); ?></th>
366 <th scope="col"><?php /* translators: column name in media */ echo _x('Author', 'media column name'); ?></th>
367 <th scope="col"><?php /* translators: column name in media */ echo _x('Date Added', 'media column name'); ?></th>
371 <tbody id="the-list" class="list:post">
374 foreach ( $orphans as $post ) {
375 $class = 'alternate' == $class ? '' : 'alternate';
376 $att_title = esc_html( _draft_or_post_title($post->ID) );
378 <tr id='post-<?php echo $post->ID; ?>' class='<?php echo $class; ?>' valign="top">
379 <th scope="row" class="check-column"><?php if ( current_user_can('edit_post', $post->ID) ) { ?><input type="checkbox" name="media[]" value="<?php echo esc_attr($post->ID); ?>" /><?php } ?></th>
381 <td class="media-icon"><?php
382 if ( $thumb = wp_get_attachment_image( $post->ID, array(80, 60), true ) ) { ?>
383 <a href="media.php?action=edit&attachment_id=<?php echo $post->ID; ?>" title="<?php echo esc_attr(sprintf(__('Edit “%s”'), $att_title)); ?>"><?php echo $thumb; ?></a>
386 <td class="media column-media"><strong><a href="<?php echo get_edit_post_link( $post->ID ); ?>" title="<?php echo esc_attr(sprintf(__('Edit “%s”'), $att_title)); ?>"><?php echo $att_title; ?></a></strong><br />
387 <?php echo strtoupper(preg_replace('/^.*?\.(\w+)$/', '$1', get_attached_file($post->ID))); ?>
389 <div class="row-actions">
392 if ( current_user_can('edit_post', $post->ID) )
393 $actions['edit'] = '<a href="' . get_edit_post_link($post->ID, true) . '">' . __('Edit') . '</a>';
394 if ( current_user_can('delete_post', $post->ID) )
395 if ( EMPTY_TRASH_DAYS && MEDIA_TRASH )
396 $actions['trash'] = "<a class='submitdelete' href='" . wp_nonce_url("post.php?action=trash&post=$post->ID", 'trash-post_' . $post->ID) . "'>" . __('Trash') . "</a>";
398 $actions['delete'] = "<a class='submitdelete' href='" . wp_nonce_url("post.php?action=delete&post=$post->ID", 'delete-post_' . $post->ID) . "'>" . __('Delete Permanently') . "</a>";
399 $actions['view'] = '<a href="' . get_permalink($post->ID) . '" title="' . esc_attr(sprintf(__('View “%s”'), $title)) . '" rel="permalink">' . __('View') . '</a>';
400 if ( current_user_can('edit_post', $post->ID) )
401 $actions['attach'] = '<a href="#the-list" onclick="findPosts.open(\'media[]\',\''.$post->ID.'\');return false;" class="hide-if-no-js">'.__('Attach').'</a>';
402 $actions = apply_filters( 'media_row_actions', $actions, $post );
403 $action_count = count($actions);
405 foreach ( $actions as $action => $link ) {
407 ( $i == $action_count ) ? $sep = '' : $sep = ' | ';
408 echo "<span class='$action'>$link$sep</span>";
411 <td class="author column-author"><?php $author = get_userdata($post->post_author); echo $author->display_name; ?></td>
412 <?php if ( '0000-00-00 00:00:00' == $post->post_date && 'date' == $column_name ) {
413 $t_time = $h_time = __('Unpublished');
415 $t_time = get_the_time(__('Y/m/d g:i:s A'));
416 $m_time = $post->post_date;
417 $time = get_post_time( 'G', true );
418 if ( ( abs($t_diff = time() - $time) ) < 86400 ) {
420 $h_time = sprintf( __('%s from now'), human_time_diff( $time ) );
422 $h_time = sprintf( __('%s ago'), human_time_diff( $time ) );
424 $h_time = mysql2date(__('Y/m/d'), $m_time);
427 <td class="date column-date"><?php echo $h_time ?></td>
432 <tr><td colspan="5"><?php _e('No media attachments found.') ?></td></tr>
440 include( 'edit-attachment-rows.php' );
443 <div id="ajax-response"></div>
445 <div class="tablenav">
449 echo "<div class='tablenav-pages'>$page_links_text</div>";
452 <div class="alignleft actions">
453 <select name="action2" class="select-action">
454 <option value="-1" selected="selected"><?php _e('Bulk Actions'); ?></option>
455 <?php if ($is_trash) { ?>
456 <option value="untrash"><?php _e('Restore'); ?></option>
457 <?php } if ( $is_trash || !EMPTY_TRASH_DAYS || !MEDIA_TRASH ) { ?>
458 <option value="delete"><?php _e('Delete Permanently'); ?></option>
460 <option value="trash"><?php _e('Move to Trash'); ?></option>
461 <?php } if (isset($orphans)) { ?>
462 <option value="attach"><?php _e('Attach to a post'); ?></option>
465 <input type="submit" value="<?php esc_attr_e('Apply'); ?>" name="doaction2" id="doaction2" class="button-secondary action" />
467 <?php if ( isset($_GET['status']) && $_GET['status'] == 'trash' && current_user_can('edit_others_posts') ) { ?>
468 <input type="submit" id="delete_all2" name="delete_all2" value="<?php esc_attr_e('Empty Trash'); ?>" class="button-secondary apply" />
474 <?php find_posts_div(); ?>
481 include('admin-footer.php');