48 lines
1.1 KiB
PHP
48 lines
1.1 KiB
PHP
<?php
|
|
|
|
class Brizy_Admin_Migrations_AttachmentUidMigration implements Brizy_Admin_Migrations_MigrationInterface {
|
|
|
|
/**
|
|
* @return int|mixed
|
|
*/
|
|
public function getPriority() {
|
|
return 0;
|
|
}
|
|
|
|
/**
|
|
* Return the version
|
|
*
|
|
* @return mixed
|
|
*/
|
|
public function getVersion() {
|
|
return '2.3.21';
|
|
}
|
|
|
|
/**
|
|
* @return mixed|void
|
|
*/
|
|
public function execute() {
|
|
|
|
try {
|
|
global $wpdb;
|
|
$invalidAttachments = $wpdb->get_results(
|
|
"SELECT
|
|
p.ID as post_id,
|
|
'brizy_attachment_uid' as meta_key,
|
|
wp.meta_value as meta_value
|
|
FROM {$wpdb->posts} p
|
|
JOIN {$wpdb->postmeta} wp on p.ID = wp.post_id and wp.meta_key='brizy_post_uid'
|
|
LEFT JOIN {$wpdb->postmeta} wp2 on p.ID = wp2.post_id and wp2.meta_key='brizy_attachment_uid'
|
|
WHERE post_type='attachment' and wp2.meta_value is NULL", ARRAY_A );
|
|
|
|
if ( is_array( $invalidAttachments ) ) {
|
|
foreach ( $invalidAttachments as $id => $insertData ) {
|
|
$wpdb->insert($wpdb->postmeta,$insertData);
|
|
}
|
|
}
|
|
} catch ( Exception $e ) {
|
|
return;
|
|
}
|
|
}
|
|
}
|