47 lines
1.4 KiB
PHP
Executable file
47 lines
1.4 KiB
PHP
Executable file
<?php
|
|
|
|
require_once "web/wp/wp-load.php";
|
|
|
|
ini_set("max_execution_time", 3600);
|
|
set_time_limit(3600);
|
|
|
|
$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());
|
|
}
|