Support » Plugin: Cache Images » [Plugin: Cache Images] Extracting images from post_meta

  • We have a MySQL database where the image urls are stored in the post_meta tables rather than the posts table.

    We have tried amending the plugin but haven’t been able to get it to work.

    here is the original code:

    $postid_list = $wpdb->get_results(“SELECT DISTINCT ID FROM $wpdb->posts WHERE post_content LIKE (‘%<img%’) AND post_content LIKE (‘%$domain%’)”);

    Our code:

    $postid_list = “
    SELECT $wpdb->posts.* FROM $wpdb->posts, $wpdb->postmeta WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id AND $wpdb->postmeta.meta_key = ‘image’ AND $wpdb->postmeta.meta_value LIKE (‘%jpg%’) “;

    Has anybody got any better ideas than this?

  • The topic ‘[Plugin: Cache Images] Extracting images from post_meta’ is closed to new replies.