| [ Index ] |
PHP Cross Reference of Wordpress 2.7.1 |
[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 wp_enqueue_script( 'jquery-ui-resizable' ); 14 15 if (!current_user_can('upload_files')) 16 wp_die(__('You do not have permission to upload files.')); 17 18 if ( isset($_GET['find_detached'] ) ) { 19 check_admin_referer('bulk-media'); 20 21 if ( ! current_user_can('edit_posts') ) 22 wp_die( __('You are not allowed to scan for lost attachments.') ); 23 24 $all_posts = $wpdb->get_col("SELECT ID FROM $wpdb->posts WHERE post_type = 'post' OR post_type = 'page'"); 25 $all_att = $wpdb->get_results("SELECT ID, post_parent FROM $wpdb->posts WHERE post_type = 'attachment'"); 26 27 $lost = array(); 28 foreach ( (array) $all_att as $att ) { 29 if ( $att->post_parent > 0 && ! in_array($att->post_parent, $all_posts) ) 30 $lost[] = $att->ID; 31 } 32 $_GET['detached'] = 1; 33 34 } elseif ( isset($_GET['found_post_id']) && isset($_GET['media']) ) { 35 check_admin_referer('bulk-media'); 36 37 if ( ! ( $parent_id = (int) $_GET['found_post_id'] ) ) 38 return; 39 40 $parent = &get_post($parent_id); 41 if ( !current_user_can('edit_post', $parent_id) ) 42 wp_die( __('You are not allowed to edit this post.') ); 43 44 $attach = array(); 45 foreach( (array) $_GET['media'] as $att_id ) { 46 $att_id = (int) $att_id; 47 48 if ( !current_user_can('edit_post', $att_id) ) 49 continue; 50 51 $attach[] = $att_id; 52 } 53 54 if ( ! empty($attach) ) { 55 $attach = implode(',', $attach); 56 $attached = $wpdb->query( $wpdb->prepare("UPDATE $wpdb->posts SET post_parent = %d WHERE post_type = 'attachment' AND ID IN ($attach)", $parent_id) ); 57 } 58 59 if ( isset($attached) ) { 60 $location = 'upload.php'; 61 if ( $referer = wp_get_referer() ) { 62 if ( false !== strpos($referer, 'upload.php') ) 63 $location = $referer; 64 } 65 66 $location = add_query_arg( array( 'detached' => 1, 'attached' => $attached ) , $location ); 67 wp_redirect($location); 68 exit; 69 } 70 71 } elseif ( isset($_GET['action']) && isset($_GET['media']) && ( -1 != $_GET['action'] || -1 != $_GET['action2'] ) ) { 72 check_admin_referer('bulk-media'); 73 $doaction = ( -1 != $_GET['action'] ) ? $_GET['action'] : $_GET['action2']; 74 75 if ( 'delete' == $doaction ) { 76 foreach( (array) $_GET['media'] as $post_id_del ) { 77 $post_del = & get_post($post_id_del); 78 79 if ( !current_user_can('delete_post', $post_id_del) ) 80 wp_die( __('You are not allowed to delete this post.') ); 81 82 if ( $post_del->post_type == 'attachment' ) 83 if ( ! wp_delete_attachment($post_id_del) ) 84 wp_die( __('Error in deleting...') ); 85 } 86 87 $location = 'upload.php'; 88 if ( $referer = wp_get_referer() ) { 89 if ( false !== strpos($referer, 'upload.php') ) 90 $location = $referer; 91 } 92 93 $location = add_query_arg('message', 2, $location); 94 $location = remove_query_arg('posted', $location); 95 wp_redirect($location); 96 exit; 97 } 98 } elseif ( isset($_GET['_wp_http_referer']) && ! empty($_GET['_wp_http_referer']) ) { 99 wp_redirect( remove_query_arg( array('_wp_http_referer', '_wpnonce'), stripslashes($_SERVER['REQUEST_URI']) ) ); 100 exit; 101 } 102 103 $title = __('Media Library'); 104 $parent_file = 'upload.php'; 105 106 if ( ! isset( $_GET['paged'] ) || $_GET['paged'] < 1 ) 107 $_GET['paged'] = 1; 108 109 if ( isset($_GET['detached']) ) { 110 111 if ( !empty($lost) ) { 112 $start = ( $_GET['paged'] - 1 ) * 50; 113 $page_links_total = ceil(count($lost) / 50); 114 $lost = implode(',', $lost); 115 116 $orphans = $wpdb->get_results( "SELECT * FROM $wpdb->posts WHERE post_type = 'attachment' AND ID IN ($lost) LIMIT $start, 50" ); 117 } else { 118 $start = ( $_GET['paged'] - 1 ) * 25; 119 $orphans = $wpdb->get_results( "SELECT SQL_CALC_FOUND_ROWS * FROM $wpdb->posts WHERE post_type = 'attachment' AND post_parent < 1 LIMIT $start, 25" ); 120 $page_links_total = ceil($wpdb->get_var( "SELECT FOUND_ROWS()" ) / 25); 121 } 122 123 $post_mime_types = array( 124 'image' => array(__('Images'), __('Manage Images'), __ngettext_noop('Image (%s)', 'Images (%s)')), 125 'audio' => array(__('Audio'), __('Manage Audio'), __ngettext_noop('Audio (%s)', 'Audio (%s)')), 126 'video' => array(__('Video'), __('Manage Video'), __ngettext_noop('Video (%s)', 'Video (%s)')), 127 ); 128 $post_mime_types = apply_filters('post_mime_types', $post_mime_types); 129 130 $avail_post_mime_types = get_available_post_mime_types('attachment'); 131 132 if ( isset($_GET['post_mime_type']) && !array_intersect( (array) $_GET['post_mime_type'], array_keys($post_mime_types) ) ) 133 unset($_GET['post_mime_type']); 134 135 } else { 136 list($post_mime_types, $avail_post_mime_types) = wp_edit_attachments_query(); 137 } 138 139 require_once ('admin-header.php'); ?> 140 141 <?php 142 if ( isset($_GET['posted']) && (int) $_GET['posted'] ) { 143 $_GET['message'] = '1'; 144 $_SERVER['REQUEST_URI'] = remove_query_arg(array('posted'), $_SERVER['REQUEST_URI']); 145 } 146 147 if ( isset($_GET['attached']) && (int) $_GET['attached'] ) { 148 $attached = (int) $_GET['attached']; 149 $message = sprintf( __ngettext('Reattached %d attachment', 'Reattached %d attachments', $attached), $attached ); 150 $_SERVER['REQUEST_URI'] = remove_query_arg(array('attached'), $_SERVER['REQUEST_URI']); 151 } 152 153 $messages[1] = __('Media attachment updated.'); 154 $messages[2] = __('Media deleted.'); 155 $messages[3] = __('Error saving media attachment.'); 156 157 if ( isset($_GET['message']) && (int) $_GET['message'] ) { 158 $message = $messages[$_GET['message']]; 159 $_SERVER['REQUEST_URI'] = remove_query_arg(array('message'), $_SERVER['REQUEST_URI']); 160 } 161 ?> 162 163 <?php do_action('restrict_manage_posts'); ?> 164 165 <div class="wrap"> 166 <?php screen_icon(); ?> 167 <h2><?php echo wp_specialchars( $title ); 168 if ( isset($_GET['s']) && $_GET['s'] ) 169 printf( '<span class="subtitle">' . __('Search results for “%s”') . '</span>', wp_specialchars( get_search_query() ) ); ?> 170 </h2> 171 172 <?php 173 if ( isset($message) ) { ?> 174 <div id="message" class="updated fade"><p><?php echo $message; ?></p></div> 175 <?php 176 } 177 ?> 178 179 <ul class="subsubsub"> 180 <?php 181 $type_links = array(); 182 $_num_posts = (array) wp_count_attachments(); 183 $_total_posts = array_sum( $_num_posts ); 184 $matches = wp_match_mime_types(array_keys($post_mime_types), array_keys($_num_posts)); 185 foreach ( $matches as $type => $reals ) 186 foreach ( $reals as $real ) 187 $num_posts[$type] = ( isset( $num_posts[$type] ) ) ? $num_posts[$type] + $_num_posts[$real] : $_num_posts[$real]; 188 189 $class = empty($_GET['post_mime_type']) && ! isset($_GET['detached']) ? ' class="current"' : ''; 190 $type_links[] = "<li><a href='upload.php'$class>" . sprintf( __ngettext( 'All <span class="count">(%s)</span>', 'All <span class="count">(%s)</span>', $_total_posts ), number_format_i18n( $_total_posts ) ) . '</a>'; 191 foreach ( $post_mime_types as $mime_type => $label ) { 192 $class = ''; 193 194 if ( !wp_match_mime_types($mime_type, $avail_post_mime_types) ) 195 continue; 196 197 if ( !empty($_GET['post_mime_type']) && wp_match_mime_types($mime_type, $_GET['post_mime_type']) ) 198 $class = ' class="current"'; 199 200 $type_links[] = "<li><a href='upload.php?post_mime_type=$mime_type'$class>" . sprintf( __ngettext( $label[2][0], $label[2][1], $num_posts[$mime_type] ), number_format_i18n( $num_posts[$mime_type] )) . '</a>'; 201 } 202 $class = isset($_GET['detached']) ? ' class="current"' : ''; 203 $type_links[] = '<li><a href="upload.php?detached=1"' . $class . '>' . __('Unattached') . '</a>'; 204 205 echo implode( " |</li>\n", $type_links) . '</li>'; 206 unset($type_links); 207 ?> 208 </ul> 209 210 <form class="search-form" action="" method="get"> 211 <p class="search-box"> 212 <label class="hidden" for="media-search-input"><?php _e( 'Search Media' ); ?>:</label> 213 <input type="text" class="search-input" id="media-search-input" name="s" value="<?php the_search_query(); ?>" /> 214 <input type="submit" value="<?php _e( 'Search Media' ); ?>" class="button" /> 215 </p> 216 </form> 217 218 <form id="posts-filter" action="" method="get"> 219 <div class="tablenav"> 220 <?php 221 if ( ! isset($page_links_total) ) 222 $page_links_total = $wp_query->max_num_pages; 223 224 $page_links = paginate_links( array( 225 'base' => add_query_arg( 'paged', '%#%' ), 226 'format' => '', 227 'prev_text' => __('«'), 228 'next_text' => __('»'), 229 'total' => $page_links_total, 230 'current' => $_GET['paged'] 231 )); 232 233 if ( $page_links ) : ?> 234 <div class="tablenav-pages"><?php $page_links_text = sprintf( '<span class="displaying-num">' . __( 'Displaying %s–%s of %s' ) . '</span>%s', 235 number_format_i18n( ( $_GET['paged'] - 1 ) * $wp_query->query_vars['posts_per_page'] + 1 ), 236 number_format_i18n( min( $_GET['paged'] * $wp_query->query_vars['posts_per_page'], $wp_query->found_posts ) ), 237 number_format_i18n( $wp_query->found_posts ), 238 $page_links 239 ); echo $page_links_text; ?></div> 240 <?php endif; ?> 241 242 <div class="alignleft actions"> 243 <select name="action" class="select-action"> 244 <option value="-1" selected="selected"><?php _e('Bulk Actions'); ?></option> 245 <option value="delete"><?php _e('Delete'); ?></option> 246 <?php if ( isset($orphans) ) { ?> 247 <option value="attach"><?php _e('Attach to a post'); ?></option> 248 <?php } ?> 249 </select> 250 <input type="submit" value="<?php _e('Apply'); ?>" name="doaction" id="doaction" class="button-secondary action" /> 251 <?php wp_nonce_field('bulk-media'); ?> 252 253 <?php 254 if ( ! is_singular() && ! isset($_GET['detached']) ) { 255 $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"; 256 257 $arc_result = $wpdb->get_results( $arc_query ); 258 259 $month_count = count($arc_result); 260 261 if ( $month_count && !( 1 == $month_count && 0 == $arc_result[0]->mmonth ) ) : ?> 262 <select name='m'> 263 <option<?php selected( @$_GET['m'], 0 ); ?> value='0'><?php _e('Show all dates'); ?></option> 264 <?php 265 foreach ($arc_result as $arc_row) { 266 if ( $arc_row->yyear == 0 ) 267 continue; 268 $arc_row->mmonth = zeroise( $arc_row->mmonth, 2 ); 269 270 if ( $arc_row->yyear . $arc_row->mmonth == $_GET['m'] ) 271 $default = ' selected="selected"'; 272 else 273 $default = ''; 274 275 echo "<option$default value='$arc_row->yyear$arc_row->mmonth'>"; 276 echo $wp_locale->get_month($arc_row->mmonth) . " $arc_row->yyear"; 277 echo "</option>\n"; 278 } 279 ?> 280 </select> 281 <?php endif; // month_count ?> 282 283 <input type="submit" id="post-query-submit" value="<?php _e('Filter'); ?>" class="button-secondary" /> 284 285 <?php } // ! is_singular ?> 286 287 <?php if ( isset($_GET['detached']) ) { ?> 288 <input type="submit" id="find_detached" name="find_detached" value="<?php _e('Scan for lost attachments'); ?>" class="button-secondary" /> 289 <?php } ?> 290 291 </div> 292 293 <br class="clear" /> 294 </div> 295 296 <div class="clear"></div> 297 298 <?php if ( isset($orphans) ) { ?> 299 <table class="widefat" cellspacing="0"> 300 <thead> 301 <tr> 302 <th scope="col" class="check-column"><input type="checkbox" /></th> 303 <th scope="col"></th> 304 <th scope="col"><?php echo _c('Media|media column header'); ?></th> 305 <th scope="col"><?php echo _c('Date Added|media column header'); ?></th> 306 </tr> 307 </thead> 308 309 <tfoot> 310 <tr> 311 <th scope="col" class="check-column"><input type="checkbox" /></th> 312 <th scope="col"></th> 313 <th scope="col"><?php echo _c('Media|media column header'); ?></th> 314 <th scope="col"><?php echo _c('Date Added|media column header'); ?></th> 315 </tr> 316 </tfoot> 317 318 <tbody id="the-list" class="list:post"> 319 <?php 320 if ( $orphans ) { 321 foreach ( $orphans as $post ) { 322 $class = 'alternate' == $class ? '' : 'alternate'; 323 $att_title = wp_specialchars( _draft_or_post_title($post->ID) ); 324 ?> 325 <tr id='post-<?php echo $post->ID; ?>' class='<?php echo $class; ?>' valign="top"> 326 <th scope="row" class="check-column"><input type="checkbox" name="media[]" value="<?php echo $post->ID; ?>" /></th> 327 328 <td class="media-icon"><?php 329 if ( $thumb = wp_get_attachment_image( $post->ID, array(80, 60), true ) ) { ?> 330 <a href="media.php?action=edit&attachment_id=<?php echo $post->ID; ?>" title="<?php echo attribute_escape(sprintf(__('Edit "%s"'), $att_title)); ?>"><?php echo $thumb; ?></a> 331 <?php } ?></td> 332 333 <td><strong><a href="<?php echo get_edit_post_link( $post->ID ); ?>" title="<?php echo attribute_escape(sprintf(__('Edit "%s"'), $att_title)); ?>"><?php echo $att_title; ?></a></strong><br /> 334 <?php echo strtoupper(preg_replace('/^.*?\.(\w+)$/', '$1', get_attached_file($post->ID))); ?> 335 336 <p> 337 <?php 338 $actions = array(); 339 if ( current_user_can('edit_post', $post->ID) ) 340 $actions['edit'] = '<a href="' . get_edit_post_link($post->ID, true) . '">' . __('Edit') . '</a>'; 341 if ( current_user_can('delete_post', $post->ID) ) 342 $actions['delete'] = "<a class='submitdelete' href='" . wp_nonce_url("post.php?action=delete&post=$post->ID", 'delete-post_' . $post->ID) . "' onclick=\"if ( confirm('" . js_escape(sprintf( ('draft' == $post->post_status) ? __("You are about to delete this attachment '%s'\n 'Cancel' to stop, 'OK' to delete.") : __("You are about to delete this attachment '%s'\n 'Cancel' to stop, 'OK' to delete."), $post->post_title )) . "') ) { return true;}return false;\">" . __('Delete') . "</a>"; 343 $actions['view'] = '<a href="' . get_permalink($post->ID) . '" title="' . attribute_escape(sprintf(__('View "%s"'), $title)) . '" rel="permalink">' . __('View') . '</a>'; 344 if ( current_user_can('edit_post', $post->ID) ) 345 $actions['attach'] = '<a href="#the-list" onclick="findPosts.open(\'media[]\',\''.$post->ID.'\');return false;">'.__('Attach').'</a>'; 346 $action_count = count($actions); 347 $i = 0; 348 foreach ( $actions as $action => $link ) { 349 ++$i; 350 ( $i == $action_count ) ? $sep = '' : $sep = ' | '; 351 echo "<span class='$action'>$link$sep</span>"; 352 } ?> 353 </p></td> 354 355 <?php if ( '0000-00-00 00:00:00' == $post->post_date && 'date' == $column_name ) { 356 $t_time = $h_time = __('Unpublished'); 357 } else { 358 $t_time = get_the_time(__('Y/m/d g:i:s A')); 359 $m_time = $post->post_date; 360 $time = get_post_time( 'G', true ); 361 if ( ( abs($t_diff = time() - $time) ) < 86400 ) { 362 if ( $t_diff < 0 ) 363 $h_time = sprintf( __('%s from now'), human_time_diff( $time ) ); 364 else 365 $h_time = sprintf( __('%s ago'), human_time_diff( $time ) ); 366 } else { 367 $h_time = mysql2date(__('Y/m/d'), $m_time); 368 } 369 } ?> 370 <td><?php echo $h_time ?></td> 371 </tr> 372 <?php } 373 374 } else { ?> 375 <tr><td colspan="5"><?php _e('No posts found.') ?></td></tr> 376 <?php } ?> 377 </tbody> 378 </table> 379 380 <?php find_posts_div(); 381 382 } else { 383 include ( 'edit-attachment-rows.php' ); 384 } ?> 385 386 <div id="ajax-response"></div> 387 388 <div class="tablenav"> 389 390 <?php 391 if ( $page_links ) 392 echo "<div class='tablenav-pages'>$page_links_text</div>"; 393 ?> 394 395 <div class="alignleft actions"> 396 <select name="action2" class="select-action"> 397 <option value="-1" selected="selected"><?php _e('Bulk Actions'); ?></option> 398 <option value="delete"><?php _e('Delete'); ?></option> 399 <?php if ( isset($orphans) ) { ?> 400 <option value="attach"><?php _e('Attach to a post'); ?></option> 401 <?php } ?> 402 </select> 403 <input type="submit" value="<?php _e('Apply'); ?>" name="doaction2" id="doaction2" class="button-secondary action" /> 404 </div> 405 406 <br class="clear" /> 407 </div> 408 </form> 409 <br class="clear" /> 410 411 </div> 412 413 <script type="text/javascript"> 414 /* <![CDATA[ */ 415 (function($){ 416 $(document).ready(function(){ 417 $('#doaction, #doaction2').click(function(e){ 418 if ( $('select[name^="action"]').val() == 'delete' ) { 419 var m = '<?php echo js_escape(__("You are about to delete the selected attachments.\n 'Cancel' to stop, 'OK' to delete.")); ?>'; 420 return showNotice.warn(m); 421 } else if ( $('select[name^="action"]').val() == 'attach' ) { 422 e.preventDefault(); 423 findPosts.open(); 424 } 425 }); 426 }); 427 })(jQuery); 428 columns.init('upload'); 429 /* ]]> */ 430 </script> 431 432 <?php 433 434 include ('admin-footer.php'); 435 ?>
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
| Generated: Mon Mar 23 16:23:02 2009 | Cross-referenced by PHPXref 0.7 |