Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- global $wpdb;
- $c_results = $wpdb->get_results(
- "
- SELECT *
- FROM wp_postmeta
- WHERE meta_key LIKE '%sub_cells%'
- AND meta_value LIKE '%size-medium%'
- "
- );
- // var_dump( count( $c_results ) );
- if ( ! empty( $c_results ) ) {
- foreach ( $c_results as $key => $c_item ) {
- $c_id = $c_item->post_id;
- $c_key = $c_item->meta_key;
- $c_val = $c_item->meta_value;
- $c_val = str_replace( '<p>', '', $c_val );
- $c_val = str_replace( '</p>', '', $c_val );
- $c_val = str_replace( '<img', '', $c_val );
- $c_val = str_replace( 'alignnone', '', $c_val );
- $c_val = str_replace( 'size-medium', '', $c_val );
- $c_val = str_replace( 'class', '', $c_val );
- $c_val = str_replace( '=', '', $c_val );
- $c_val = str_replace( '"', '', $c_val );
- $c_val = str_replace( 'wp-image-', '', $c_val );
- $c_val = trim( $c_val );
- $c_val = explode( ' ', $c_val );
- $c_attach_id = $c_val[0];
- // var_dump( $c_item->meta_value, $c_attach_id );
- $c_img_src = wp_get_attachment_image_src( $c_attach_id, 'full' );
- // var_dump( $c_img_src );
- $c_new_val = '<img class="alignnone size-full wp-image-' . $c_attach_id . '" src="' . $c_img_src[0] . '" alt="" width="' . $c_img_src[1] . '" height="' . $c_img_src[2] . '" />';
- // var_dump( $c_new_val );
- // var_dump( $c_id, $c_key, $c_new_val );
- $c_update = $wpdb->update(
- 'wp_postmeta',
- array( 'meta_value' => $c_new_val ),
- array( 'post_id' => $c_id, 'meta_key' => $c_key )
- );
- var_dump( $c_update );
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement