wc_update_210_file_paths()
Update file paths to support multiple files for 2.1
Description Description
Return Return
(void)
Source Source
File: includes/wc-update-functions.php
function wc_update_210_file_paths() { global $wpdb; // Upgrade file paths to support multiple file paths + names etc. $existing_file_paths = $wpdb->get_results( "SELECT meta_value, meta_id FROM {$wpdb->postmeta} WHERE meta_key = '_file_paths' AND meta_value != '';" ); if ( $existing_file_paths ) { foreach ( $existing_file_paths as $existing_file_path ) { $needs_update = false; $new_value = array(); $value = maybe_unserialize( trim( $existing_file_path->meta_value ) ); if ( $value ) { foreach ( $value as $key => $file ) { if ( ! is_array( $file ) ) { $needs_update = true; $new_value[ $key ] = array( 'file' => $file, 'name' => wc_get_filename_from_url( $file ), ); } else { $new_value[ $key ] = $file; } } if ( $needs_update ) { $new_value = serialize( $new_value ); $wpdb->query( $wpdb->prepare( "UPDATE {$wpdb->postmeta} SET meta_key = %s, meta_value = %s WHERE meta_id = %d", '_downloadable_files', $new_value, $existing_file_path->meta_id ) ); } } } } }