Current path: home/webdevt/www/wdp/wp-content/plugins/brizy/admin/migrations/
?? Go up: /home/webdevt/www/wdp/wp-content/plugins/brizy/admin
<?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;
}
}
}