43 lines
1.5 KiB
PHP
Executable file
43 lines
1.5 KiB
PHP
Executable file
<?php declare(strict_types=1);
|
|
|
|
require_once 'web/wp/wp-load.php';
|
|
|
|
ini_set('max_execution_time', 3_600);
|
|
set_time_limit(3_600);
|
|
|
|
$pdo = new PDO('mysql:dbname=haiku_atelier;host=localhost', 'haiku_utilisateur', 'spNFx5EAYwvF7o7XFMjiHpNPYJimDtmKWv');
|
|
|
|
// replace _wp_attached_file meta_key
|
|
global $wpdb;
|
|
$wp_postmeta = "{$wpdb->prefix}postmeta";
|
|
|
|
try {
|
|
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
|
// Error Handling
|
|
$sql = "UPDATE {$wp_postmeta} SET meta_value = REPLACE(meta_value,'-scaled.jpg','.jpg') WHERE meta_key='_wp_attached_file' AND meta_value LIKE '%-scaled.jpg%'";
|
|
$result = $pdo->exec($sql);
|
|
print_r($result);
|
|
} catch (PDOException $e) {
|
|
print_r($e->getMessage());
|
|
}
|
|
|
|
// replace _wp_attachment_metadata meta_key.
|
|
$image_metas = [];
|
|
|
|
try {
|
|
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
|
// Error Handling
|
|
$sql = "SELECT * FROM {$wp_postmeta} WHERE meta_value LIKE '%-scaled.jpg%' AND meta_key='_wp_attachment_metadata'";
|
|
$statement = $pdo->query($sql);
|
|
$image_metas = $statement->fetchAll();
|
|
foreach ($image_metas as $meta) {
|
|
$meta_value = unserialize($meta['meta_value']);
|
|
$file = $meta_value['file'];
|
|
$meta_value['file'] = str_replace('-scaled.jpg', '.jpg', $file);
|
|
update_post_meta($meta['post_id'], $meta['meta_key'], $meta_value);
|
|
$result = get_post_meta($meta['post_id'], $meta['meta_key']);
|
|
print_r($result);
|
|
}
|
|
} catch (PDOException $e) {
|
|
print_r($e->getMessage());
|
|
}
|