moneyslow.com

discuz

Discuz附件的seo处理

—

from

moneyslow
of 
UPDATE pre_forum_attachment_9
    SET filename = REPLACE(filename, 'jpg', 'webp'),
    attachment = REPLACE(attachment, 'jpg', 'webp');


UPDATE pre_forum_attachment_9
    SET filename = REPLACE(filename, 'jpeg', 'webp'),
    attachment = REPLACE(attachment, 'jpeg', 'webp');

把 /data/bin/change.sh 放到图片目录执行

select attachment from pre_forum_attachment_0 where attachment not like "%webp%";