Új hozzászólás Aktív témák

  • kevesbence

    csendes tag

    válasz miqlas #8787 üzenetére

    Eddig ezeket a parancsokat futtattam. Még nem tökéletes, de alakul.

    UPDATE `wp_postmeta` SET `meta_value` = REPLACE(`meta_value`, '.jpg', '.webp') WHERE `meta_value` LIKE '%.jpg%';
    UPDATE `wp_postmeta` SET `meta_value` = REPLACE(`meta_value`, '.jpeg', '.webp') WHERE `meta_value` LIKE '%.jpeg%';
    UPDATE `wp_postmeta` SET `meta_value` = REPLACE(`meta_value`, '.png', '.webp') WHERE `meta_value` LIKE '%.png%';
    UPDATE `wp_postmeta` SET `meta_value` = REPLACE(`meta_value`, 'image/jpeg', 'image/webp') WHERE `meta_value` LIKE '%image/jpeg%';
    UPDATE `wp_postmeta` SET `meta_value` = REPLACE(`meta_value`, 'image/png', 'image/webp') WHERE `meta_value` LIKE '%image/png%';
    UPDATE `wp_posts` SET `guid` = REPLACE(`guid`, '.jpg', '.webp') WHERE `guid` LIKE '%.jpg%';
    UPDATE `wp_posts` SET `guid` = REPLACE(`guid`, '.jpeg', '.webp') WHERE `guid` LIKE '%.jpeg%';
    UPDATE `wp_posts` SET `guid` = REPLACE(`guid`, '.png', '.webp') WHERE `guid` LIKE '%.png%';
    UPDATE `wp_posts` SET `post_content` = REPLACE(`post_content`, '.jpg', '.webp') WHERE `post_content` LIKE '%.jpg%';
    UPDATE `wp_posts` SET `post_content` = REPLACE(`post_content`, '.jpeg', '.webp') WHERE `post_content` LIKE '%.jpeg%';
    UPDATE `wp_posts` SET `post_content` = REPLACE(`post_content`, '.png', '.webp') WHERE `post_content` LIKE '%.png%';
    UPDATE `wp_posts` SET `post_mime_type` = REPLACE(`post_mime_type`, 'image/jpeg', 'image/webp') WHERE `post_mime_type` = 'image/jpeg';
    UPDATE `wp_posts` SET `post_mime_type` = REPLACE(`post_mime_type`, 'image/png', 'image/webp') WHERE `post_mime_type` = 'image/png';

Új hozzászólás Aktív témák