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 ) );
}
}
}
}
}