[Summary view] [Print] [Text view]

   1  <?php
   2  /**
   3   * Media Library administration panel.
   4   *
   5   * @package WordPress
   6   * @subpackage Administration
   7   */
   8  
   9  /** WordPress Administration Bootstrap */
  10  require_once ('admin.php');
  11  wp_enqueue_script( 'wp-ajax-response' );
  12  wp_enqueue_script( 'jquery-ui-draggable' );
  13  
  14  if ( !current_user_can('upload_files') )
  15      wp_die(__('You do not have permission to upload files.'));
  16  
  17  if ( isset($_GET['find_detached']) ) {
  18      check_admin_referer('bulk-media');
  19  
  20      if ( !current_user_can('edit_posts') )
  21          wp_die( __('You are not allowed to scan for lost attachments.') );
  22  
  23      $all_posts = implode(',', $wpdb->get_col("SELECT ID FROM $wpdb->posts WHERE post_type IN ('post', 'page')"));
  24      $lost = $wpdb->get_col("SELECT ID FROM $wpdb->posts WHERE post_type = 'attachment' AND post_parent > '0' and post_parent NOT IN ($all_posts)");
  25  
  26      $_GET['detached'] = 1;
  27  
  28  } elseif ( isset($_GET['found_post_id']) && isset($_GET['media']) ) {
  29      check_admin_referer('bulk-media');
  30  
  31      if ( ! ( $parent_id = (int) $_GET['found_post_id'] ) )
  32          return;
  33  
  34      $parent = &get_post($parent_id);
  35      if ( !current_user_can('edit_post', $parent_id) )
  36          wp_die( __('You are not allowed to edit this post.') );
  37  
  38      $attach = array();
  39      foreach( (array) $_GET['media'] as $att_id ) {
  40          $att_id = (int) $att_id;
  41  
  42          if ( !current_user_can('edit_post', $att_id) )
  43              continue;
  44  
  45          $attach[] = $att_id;
  46          clean_attachment_cache($att_id);
  47      }
  48  
  49      if ( ! empty($attach) ) {
  50          $attach = implode(',', $attach);
  51          $attached = $wpdb->query( $wpdb->prepare("UPDATE $wpdb->posts SET post_parent = %d WHERE post_type = 'attachment' AND ID IN ($attach)", $parent_id) );
  52      }
  53  
  54      if ( isset($attached) ) {
  55          $location = 'upload.php';
  56          if ( $referer = wp_get_referer() ) {
  57              if ( false !== strpos($referer, 'upload.php') )
  58                  $location = $referer;
  59          }
  60  
  61          $location = add_query_arg( array( 'attached' => $attached ) , $location );
  62          wp_redirect($location);
  63          exit;
  64      }
  65  
  66  } elseif ( isset($_GET['doaction']) || isset($_GET['doaction2']) || isset($_GET['delete_all']) || isset($_GET['delete_all2']) ) {
  67      check_admin_referer('bulk-media');
  68  
  69      if ( isset($_GET['delete_all']) || isset($_GET['delete_all2']) ) {
  70          $post_ids = $wpdb->get_col( "SELECT ID FROM $wpdb->posts WHERE post_type='attachment' AND post_status = 'trash'" );
  71          $doaction = 'delete';
  72      } elseif ( ( $_GET['action'] != -1 || $_GET['action2'] != -1 ) && ( isset($_GET['media']) || isset($_GET['ids']) ) ) {
  73          $post_ids = isset($_GET['media']) ? $_GET['media'] : explode(',', $_GET['ids']);
  74          $doaction = ($_GET['action'] != -1) ? $_GET['action'] : $_GET['action2'];
  75      } else {
  76          wp_redirect($_SERVER['HTTP_REFERER']);
  77      }
  78  
  79      $location = 'upload.php';
  80      if ( $referer = wp_get_referer() ) {
  81          if ( false !== strpos($referer, 'upload.php') )
  82              $location = remove_query_arg( array('trashed', 'untrashed', 'deleted', 'message', 'ids', 'posted'), $referer );
  83      }
  84  
  85      switch ( $doaction ) {
  86          case 'trash':
  87              foreach( (array) $post_ids as $post_id ) {
  88                  if ( !current_user_can('delete_post', $post_id) )
  89                      wp_die( __('You are not allowed to move this post to the trash.') );
  90  
  91                  if ( !wp_trash_post($post_id) )
  92                      wp_die( __('Error in moving to trash...') );
  93              }
  94              $location = add_query_arg( array( 'trashed' => count($post_ids), 'ids' => join(',', $post_ids) ), $location );
  95              break;
  96          case 'untrash':
  97              foreach( (array) $post_ids as $post_id ) {
  98                  if ( !current_user_can('delete_post', $post_id) )
  99                      wp_die( __('You are not allowed to move this post out of the trash.') );
 100  
 101                  if ( !wp_untrash_post($post_id) )
 102                      wp_die( __('Error in restoring from trash...') );
 103              }
 104              $location = add_query_arg('untrashed', count($post_ids), $location);
 105              break;
 106          case 'delete':
 107              foreach( (array) $post_ids as $post_id_del ) {
 108                  if ( !current_user_can('delete_post', $post_id_del) )
 109                      wp_die( __('You are not allowed to delete this post.') );
 110  
 111                  if ( !wp_delete_attachment($post_id_del) )
 112                      wp_die( __('Error in deleting...') );
 113              }
 114              $location = add_query_arg('deleted', count($post_ids), $location);
 115              break;
 116      }
 117  
 118      wp_redirect($location);
 119      exit;
 120  } elseif ( ! empty($_GET['_wp_http_referer']) ) {
 121       wp_redirect( remove_query_arg( array('_wp_http_referer', '_wpnonce'), stripslashes($_SERVER['REQUEST_URI']) ) );
 122       exit;
 123  }
 124  
 125  $title = __('Media Library');
 126  $parent_file = 'upload.php';
 127  
 128  if ( ! isset( $_GET['paged'] ) || $_GET['paged'] < 1 )
 129      $_GET['paged'] = 1;
 130  
 131  if ( isset($_GET['detached']) ) {
 132  
 133      $media_per_page = (int) get_user_option( 'upload_per_page' );
 134      if ( empty($media_per_page) || $media_per_page < 1 )
 135          $media_per_page = 20;
 136      $media_per_page = apply_filters( 'upload_per_page', $media_per_page );
 137  
 138      if ( !empty($lost) ) {
 139          $start = ( (int) $_GET['paged'] - 1 ) * $media_per_page;
 140          $page_links_total = ceil(count($lost) / $media_per_page);
 141          $lost = implode(',', $lost);
 142  
 143          $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 ) );
 144      } else {
 145          $start = ( (int) $_GET['paged'] - 1 ) * $media_per_page;
 146          $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 ) );
 147          $total_orphans = $wpdb->get_var( "SELECT FOUND_ROWS()" );
 148          $page_links_total = ceil( $total_orphans / $media_per_page );
 149      }
 150  
 151      $post_mime_types = get_post_mime_types();
 152      $avail_post_mime_types = get_available_post_mime_types('attachment');
 153  
 154      if ( isset($_GET['post_mime_type']) && !array_intersect( (array) $_GET['post_mime_type'], array_keys($post_mime_types) ) )
 155          unset($_GET['post_mime_type']);
 156  
 157  } else {
 158      list($post_mime_types, $avail_post_mime_types) = wp_edit_attachments_query();
 159  }
 160  
 161  $is_trash = ( isset($_GET['status']) && $_GET['status'] == 'trash' );
 162  
 163  wp_enqueue_script('media');
 164  require_once ('admin-header.php');
 165  ?>
 166  
 167  <div class="wrap">
 168  <?php screen_icon(); ?>
 169  <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
 170  if ( isset($_GET['s']) && $_GET['s'] )
 171      printf( '<span class="subtitle">' . __('Search results for &#8220;%s&#8221;') . '</span>', esc_html( get_search_query() ) ); ?>
 172  </h2>
 173  
 174  <?php
 175  $message = '';
 176  if ( isset($_GET['posted']) && (int) $_GET['posted'] ) {
 177      $message = __('Media attachment updated.');
 178      $_SERVER['REQUEST_URI'] = remove_query_arg(array('posted'), $_SERVER['REQUEST_URI']);
 179  }
 180  
 181  if ( isset($_GET['attached']) && (int) $_GET['attached'] ) {
 182      $attached = (int) $_GET['attached'];
 183      $message = sprintf( _n('Reattached %d attachment.', 'Reattached %d attachments.', $attached), $attached );
 184      $_SERVER['REQUEST_URI'] = remove_query_arg(array('attached'), $_SERVER['REQUEST_URI']);
 185  }
 186  
 187  if ( isset($_GET['deleted']) && (int) $_GET['deleted'] ) {
 188      $message = sprintf( _n( 'Media attachment permanently deleted.', '%d media attachments permanently deleted.', $_GET['deleted'] ), number_format_i18n( $_GET['deleted'] ) );
 189      $_SERVER['REQUEST_URI'] = remove_query_arg(array('deleted'), $_SERVER['REQUEST_URI']);
 190  }
 191  
 192  if ( isset($_GET['trashed']) && (int) $_GET['trashed'] ) {
 193      $message = sprintf( _n( 'Media attachment moved to the trash.', '%d media attachments moved to the trash.', $_GET['trashed'] ), number_format_i18n( $_GET['trashed'] ) );
 194      $message .= ' <a href="' . esc_url( wp_nonce_url( 'upload.php?doaction=undo&action=untrash&ids='.(isset($_GET['ids']) ? $_GET['ids'] : ''), "bulk-media" ) ) . '">' . __('Undo') . '</a>';
 195      $_SERVER['REQUEST_URI'] = remove_query_arg(array('trashed'), $_SERVER['REQUEST_URI']);
 196  }
 197  
 198  if ( isset($_GET['untrashed']) && (int) $_GET['untrashed'] ) {
 199      $message = sprintf( _n( 'Media attachment restored from the trash.', '%d media attachments restored from the trash.', $_GET['untrashed'] ), number_format_i18n( $_GET['untrashed'] ) );
 200      $_SERVER['REQUEST_URI'] = remove_query_arg(array('untrashed'), $_SERVER['REQUEST_URI']);
 201  }
 202  
 203  $messages[1] = __('Media attachment updated.');
 204  $messages[2] = __('Media permanently deleted.');
 205  $messages[3] = __('Error saving media attachment.');
 206  $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>';
 207  $messages[5] = __('Media restored from the trash.');
 208  
 209  if ( isset($_GET['message']) && (int) $_GET['message'] ) {
 210      $message = $messages[$_GET['message']];
 211      $_SERVER['REQUEST_URI'] = remove_query_arg(array('message'), $_SERVER['REQUEST_URI']);
 212  }
 213  
 214  if ( !empty($message) ) { ?>
 215  <div id="message" class="updated"><p><?php echo $message; ?></p></div>
 216  <?php } ?>
 217  
 218  <ul class="subsubsub">
 219  <?php
 220  $type_links = array();
 221  $_num_posts = (array) wp_count_attachments();
 222  $_total_posts = array_sum($_num_posts) - $_num_posts['trash'];
 223  if ( !isset( $total_orphans ) )
 224          $total_orphans = $wpdb->get_var( "SELECT COUNT( * ) FROM $wpdb->posts WHERE post_type = 'attachment' AND post_status != 'trash' AND post_parent < 1" );
 225  $matches = wp_match_mime_types(array_keys($post_mime_types), array_keys($_num_posts));
 226  foreach ( $matches as $type => $reals )
 227      foreach ( $reals as $real )
 228          $num_posts[$type] = ( isset( $num_posts[$type] ) ) ? $num_posts[$type] + $_num_posts[$real] : $_num_posts[$real];
 229  
 230  $class = ( empty($_GET['post_mime_type']) && !isset($_GET['detached']) && !isset($_GET['status']) ) ? ' class="current"' : '';
 231  $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>';
 232  foreach ( $post_mime_types as $mime_type => $label ) {
 233      $class = '';
 234  
 235      if ( !wp_match_mime_types($mime_type, $avail_post_mime_types) )
 236          continue;
 237  
 238      if ( !empty($_GET['post_mime_type']) && wp_match_mime_types($mime_type, $_GET['post_mime_type']) )
 239          $class = ' class="current"';
 240      if ( !empty( $num_posts[$mime_type] ) )
 241          $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>';
 242  }
 243  $type_links[] = '<li><a href="upload.php?detached=1"' . ( isset($_GET['detached']) ? ' class="current"' : '' ) . '>' . sprintf( _nx( 'Unattached <span class="count">(%s)</span>', 'Unattached <span class="count">(%s)</span>', $total_orphans, 'detached files' ), number_format_i18n( $total_orphans ) ) . '</a>';
 244  
 245  if ( !empty($_num_posts['trash']) )
 246      $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>';
 247  
 248  echo implode( " |</li>\n", $type_links) . '</li>';
 249  unset($type_links);
 250  ?>
 251  </ul>
 252  
 253  <form class="search-form" action="" method="get">
 254  <p class="search-box">
 255      <label class="screen-reader-text" for="media-search-input"><?php _e( 'Search Media' ); ?>:</label>
 256      <input type="text" id="media-search-input" name="s" value="<?php the_search_query(); ?>" />
 257      <input type="submit" value="<?php esc_attr_e( 'Search Media' ); ?>" class="button" />
 258  </p>
 259  </form>
 260  
 261  <form id="posts-filter" action="" method="get">
 262  <?php if ( have_posts() || isset( $orphans ) ) { ?>
 263  <div class="tablenav">
 264  <?php
 265  if ( ! isset($page_links_total) )
 266      $page_links_total =  $wp_query->max_num_pages;
 267  
 268  $page_links = paginate_links( array(
 269      'base' => add_query_arg( 'paged', '%#%' ),
 270      'format' => '',
 271      'prev_text' => __('&laquo;'),
 272      'next_text' => __('&raquo;'),
 273      'total' => $page_links_total,
 274      'current' => $_GET['paged']
 275  ));
 276  
 277  if ( $page_links ) : ?>
 278  <div class="tablenav-pages"><?php $page_links_text = sprintf( '<span class="displaying-num">' . __( 'Displaying %s&#8211;%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 ),
 282      $page_links
 283  ); echo $page_links_text; ?></div>
 284  <?php endif; ?>
 285  
 286  <div class="alignleft actions">
 287  <?php if ( ! isset( $orphans ) || ! empty( $orphans ) ) { ?>
 288  <select name="action" class="select-action">
 289  <option value="-1" selected="selected"><?php _e('Bulk Actions'); ?></option>
 290  <?php if ( $is_trash ) { ?>
 291  <option value="untrash"><?php _e('Restore'); ?></option>
 292  <?php } if ( $is_trash || !EMPTY_TRASH_DAYS || !MEDIA_TRASH ) { ?>
 293  <option value="delete"><?php _e('Delete Permanently'); ?></option>
 294  <?php } else { ?>
 295  <option value="trash"><?php _e('Move to Trash'); ?></option>
 296  <?php } if ( isset($orphans) ) { ?>
 297  <option value="attach"><?php _e('Attach to a post'); ?></option>
 298  <?php } ?>
 299  </select>
 300  <input type="submit" value="<?php esc_attr_e('Apply'); ?>" name="doaction" id="doaction" class="button-secondary action" />
 301  <?php wp_nonce_field('bulk-media'); ?>
 302  
 303  <?php
 304  if ( !is_singular() && !isset($_GET['detached']) && !$is_trash ) {
 305      $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  
 307      $arc_result = $wpdb->get_results( $arc_query );
 308  
 309      $month_count = count($arc_result);
 310  
 311      if ( $month_count && !( 1 == $month_count && 0 == $arc_result[0]->mmonth ) ) : ?>
 312  <select name='m'>
 313  <option value='0'><?php _e('Show all dates'); ?></option>
 314  <?php
 315  foreach ($arc_result as $arc_row) {
 316      if ( $arc_row->yyear == 0 )
 317          continue;
 318      $arc_row->mmonth = zeroise( $arc_row->mmonth, 2 );
 319  
 320      if ( isset($_GET['m']) && ( $arc_row->yyear . $arc_row->mmonth == $_GET['m'] ) )
 321          $default = ' selected="selected"';
 322      else
 323          $default = '';
 324  
 325      echo "<option$default value='" . esc_attr("$arc_row->yyear$arc_row->mmonth") . "'>";
 326      echo $wp_locale->get_month($arc_row->mmonth) . " $arc_row->yyear";
 327      echo "</option>\n";
 328  }
 329  ?>
 330  </select>
 331  <?php endif; // month_count ?>
 332  
 333  <?php do_action('restrict_manage_posts'); ?>
 334  
 335  <input type="submit" id="post-query-submit" value="<?php esc_attr_e('Filter'); ?>" class="button-secondary" />
 336  
 337  <?php } // ! is_singular ?>
 338  
 339  <?php
 340  
 341  } // ! empty( $orphans )
 342  
 343  if ( isset($_GET['detached']) ) { ?>
 344      <input type="submit" id="find_detached" name="find_detached" value="<?php esc_attr_e('Scan for lost attachments'); ?>" class="button-secondary" />
 345  <?php } elseif ( isset($_GET['status']) && $_GET['status'] == 'trash' && current_user_can('edit_others_posts') ) { ?>
 346      <input type="submit" id="delete_all" name="delete_all" value="<?php esc_attr_e('Empty Trash'); ?>" class="button-secondary apply" />
 347  <?php } ?>
 348  
 349  </div>
 350  
 351  <br class="clear" />
 352  </div>
 353  
 354  <?php } // have_posts() || !empty( $orphans ) ?>
 355  
 356  <div class="clear"></div>
 357  
 358  <?php if ( ! empty( $orphans ) ) { ?>
 359  <table class="widefat" cellspacing="0">
 360  <thead>
 361  <tr>
 362      <th scope="col" class="check-column"><input type="checkbox" /></th>
 363      <th scope="col"></th>
 364      <th scope="col"><?php /* translators: column name in media */ echo _x('Media', 'media column name'); ?></th>
 365      <th scope="col"><?php /* translators: column name in media */ echo _x('Author', 'media column name'); ?></th>
 366      <th scope="col"><?php /* translators: column name in media */ echo _x('Date Added', 'media column name'); ?></th>
 367  </tr>
 368  </thead>
 369  
 370  <tfoot>
 371  <tr>
 372      <th scope="col" class="check-column"><input type="checkbox" /></th>
 373      <th scope="col"></th>
 374      <th scope="col"><?php /* translators: column name in media */ echo _x('Media', 'media column name'); ?></th>
 375      <th scope="col"><?php /* translators: column name in media */ echo _x('Author', 'media column name'); ?></th>
 376      <th scope="col"><?php /* translators: column name in media */ echo _x('Date Added', 'media column name'); ?></th>
 377  </tr>
 378  </tfoot>
 379  
 380  <tbody id="the-list" class="list:post">
 381  <?php
 382          foreach ( $orphans as $post ) {
 383              $class = 'alternate' == $class ? '' : 'alternate';
 384              $att_title = esc_html( _draft_or_post_title($post->ID) );
 385  ?>
 386      <tr id='post-<?php echo $post->ID; ?>' class='<?php echo $class; ?>' valign="top">
 387          <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>
 388  
 389          <td class="media-icon"><?php
 390          if ( $thumb = wp_get_attachment_image( $post->ID, array(80, 60), true ) ) { ?>
 391              <a href="media.php?action=edit&amp;attachment_id=<?php echo $post->ID; ?>" title="<?php echo esc_attr(sprintf(__('Edit &#8220;%s&#8221;'), $att_title)); ?>"><?php echo $thumb; ?></a>
 392  <?php    } ?></td>
 393  
 394          <td class="media column-media"><strong><a href="<?php echo get_edit_post_link( $post->ID ); ?>" title="<?php echo esc_attr(sprintf(__('Edit &#8220;%s&#8221;'), $att_title)); ?>"><?php echo $att_title; ?></a></strong><br />
 395          <?php
 396          if ( preg_match( '/^.*?\.(\w+)$/', get_attached_file( $post->ID ), $matches ) )
 397              echo esc_html( strtoupper( $matches[1] ) );
 398          else
 399              echo strtoupper( str_replace( 'image/', '', get_post_mime_type() ) );
 400          ?>
 401  
 402          <div class="row-actions">
 403          <?php
 404          $actions = array();
 405          if ( current_user_can('edit_post', $post->ID) )
 406              $actions['edit'] = '<a href="' . get_edit_post_link($post->ID, true) . '">' . __('Edit') . '</a>';
 407          if ( current_user_can('delete_post', $post->ID) )
 408              if ( EMPTY_TRASH_DAYS && MEDIA_TRASH ) {
 409                  $actions['trash'] = "<a class='submitdelete' href='" . wp_nonce_url("post.php?action=trash&amp;post=$post->ID", 'trash-attachment_' . $post->ID) . "'>" . __('Trash') . "</a>";
 410              } else {
 411                  $delete_ays = !MEDIA_TRASH ? " onclick='return showNotice.warn();'" : '';
 412                  $actions['delete'] = "<a class='submitdelete'$delete_ays href='" . wp_nonce_url("post.php?action=delete&amp;post=$post->ID", 'delete-attachment_' . $post->ID) . "'>" . __('Delete Permanently') . "</a>";
 413              }
 414          $actions['view'] = '<a href="' . get_permalink($post->ID) . '" title="' . esc_attr(sprintf(__('View &#8220;%s&#8221;'), $title)) . '" rel="permalink">' . __('View') . '</a>';
 415          if ( current_user_can('edit_post', $post->ID) )
 416              $actions['attach'] = '<a href="#the-list" onclick="findPosts.open(\'media[]\',\''.$post->ID.'\');return false;" class="hide-if-no-js">'.__('Attach').'</a>';
 417          $actions = apply_filters( 'media_row_actions', $actions, $post );
 418          $action_count = count($actions);
 419          $i = 0;
 420          foreach ( $actions as $action => $link ) {
 421              ++$i;
 422              ( $i == $action_count ) ? $sep = '' : $sep = ' | ';
 423              echo "<span class='$action'>$link$sep</span>";
 424          } ?>
 425          </div></td>
 426          <td class="author column-author"><?php $author = get_userdata($post->post_author); echo $author->display_name; ?></td>
 427  <?php    if ( '0000-00-00 00:00:00' == $post->post_date && 'date' == $column_name ) {
 428              $t_time = $h_time = __('Unpublished');
 429          } else {
 430              $t_time = get_the_time(__('Y/m/d g:i:s A'));
 431              $m_time = $post->post_date;
 432              $time = get_post_time( 'G', true );
 433              if ( ( abs($t_diff = time() - $time) ) < 86400 ) {
 434                  if ( $t_diff < 0 )
 435                      $h_time = sprintf( __('%s from now'), human_time_diff( $time ) );
 436                  else
 437                      $h_time = sprintf( __('%s ago'), human_time_diff( $time ) );
 438              } else {
 439                  $h_time = mysql2date(__('Y/m/d'), $m_time);
 440              }
 441          } ?>
 442          <td class="date column-date"><?php echo $h_time ?></td>
 443      </tr>
 444  <?php    } ?>
 445  </tbody>
 446  </table>
 447  
 448  <?php
 449  
 450  } else {
 451      include ( 'edit-attachment-rows.php' );
 452  } ?>
 453  
 454  <div id="ajax-response"></div>
 455  
 456  <div class="tablenav">
 457  
 458  <?php
 459  if ( have_posts() || ! empty( $orphans ) ) {
 460  
 461  if ( $page_links )
 462      echo "<div class='tablenav-pages'>$page_links_text</div>";
 463  ?>
 464  
 465  <div class="alignleft actions">
 466  <select name="action2" class="select-action">
 467  <option value="-1" selected="selected"><?php _e('Bulk Actions'); ?></option>
 468  <?php if ($is_trash) { ?>
 469  <option value="untrash"><?php _e('Restore'); ?></option>
 470  <?php } if ( $is_trash || !EMPTY_TRASH_DAYS || !MEDIA_TRASH ) { ?>
 471  <option value="delete"><?php _e('Delete Permanently'); ?></option>
 472  <?php } else { ?>
 473  <option value="trash"><?php _e('Move to Trash'); ?></option>
 474  <?php } if (isset($orphans)) { ?>
 475  <option value="attach"><?php _e('Attach to a post'); ?></option>
 476  <?php } ?>
 477  </select>
 478  <input type="submit" value="<?php esc_attr_e('Apply'); ?>" name="doaction2" id="doaction2" class="button-secondary action" />
 479  
 480  <?php if ( isset($_GET['status']) && $_GET['status'] == 'trash' && current_user_can('edit_others_posts') ) { ?>
 481      <input type="submit" id="delete_all2" name="delete_all2" value="<?php esc_attr_e('Empty Trash'); ?>" class="button-secondary apply" />
 482  <?php } ?>
 483  </div>
 484  
 485  <?php } ?>
 486  <br class="clear" />
 487  </div>
 488  <?php find_posts_div(); ?>
 489  </form>
 490  <br class="clear" />
 491  
 492  </div>
 493  
 494  <?php
 495  include ('admin-footer.php');