Update content
Bulk content update is available in Pro version after
adding keys and setting up
tuning parameters.
';
} else {
aiit_show_update_form();
}
?>
Information
What this function is for
WordPress images have four text fields: Titles, ALTs, Captions, and Descriptions. These texts are visible in the Media Library, where all your site's images are stored. Our plugin automatically writes new text to these fields. However, both the Gutenberg and Classic editors offer a feature that allows you to have custom Titles, ALTs, Captions, and Descriptions specific to the images on a particular page or post. The "Update content" feature enables you to refresh these images in your posts or pages with the newly generated text from the Media Library source.
If you use another Wordpress builder
If you're using a different WordPress builder and have added custom titles, ALTs, or captions to your posts and images, updating these images with new text from the Media Library may require manual intervention. To check the text status of your images, use the developer tool "Inspect" on any of your images to see what text is displayed.
If you use the Gutenberg or Classic editor, you might have already published posts, pages, or products with custom image titles, ALTs, or captions. This function helps you to update these images that are published on older posts and pages with the newly written texts from the Media Library. If you're unsure whether you need this, you likely don't.
'post',
'title' => "Posts",
'description' => "",
),
array(
'value' => 'page',
'title' => "Pages",
'description' => '',
),
array(
'value' => 'product',
'title' => "Products",
'description' => "WooCommerce product pages",
)
);
if ($selection_criteria){
foreach ($dropdown as $item) {
if ($item['value'] === $selection_criteria) {
$selected_option = $item['title'];
}
}
}
echo '
' . esc_html($selected_option) . '
';
foreach ($dropdown as $item) {
echo '
' . esc_html($item['title']) . '
' . esc_html($item['description']) . '
';
}
echo '
';
echo '| Post ID | Image ID | Existing content | Media Library |
|---|
';
echo '';
foreach ($update_table as $row) {
echo '';
echo '| ' . esc_html($row['post_id']) . ' | ';
echo '' . esc_html($row['image_id']) . ' | ';
echo 'ALT text: ' . esc_html($row['old_alt']) . '
Caption: ' . esc_html($row['old_caption']) . '
Title: ' . esc_html($row['old_title']) . ' | ';
echo 'ALT text: ' . esc_html($row['ml_alt']) . '
Caption: ' . esc_html($row['ml_caption']) . '
Title: ' . esc_html($row['ml_title']) . ' | ';
echo '
';
}
echo '
';
wp_die();
}
function aiit_update_data_callback(){
if (!isset($_POST['security']) || !wp_verify_nonce( sanitize_text_field( wp_unslash($_POST['security'])), 'aiit_update_nonce')) {
wp_send_json_error('Permission check failed');
}
global $wpdb;
$last_jobs = wp_cache_get('aiit_update_data_callback');
if ($last_jobs === false) {
$last_jobs = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}aiit_bckg_processing WHERE `type` = 'Update' ORDER BY id DESC LIMIT 3", ARRAY_A);
wp_cache_set('aiit_update_data_callback', $last_jobs, '', 3);
}
echo '';
echo '| ID | Total | Processed | Status | Started |
|---|
';
echo '';
foreach ($last_jobs as $row) {
echo '';
echo '| ' . esc_html($row['id']) . ' | ';
echo '' . esc_html($row['initial_count']) . ' | ';
echo '' . esc_html($row['processed_count']) . ' | ';
echo '' . esc_html($row['status']) . ' | ';
echo '' . esc_html($row['created_on']) . ' | ';
echo '
';
}
echo '
';
wp_die();
}
##schedule job
function aiit_schedule_update() {
if (!isset($_POST['security']) || !wp_verify_nonce( sanitize_text_field( wp_unslash($_POST['security'])), 'aiit_update_nonce')) {
wp_send_json_error('Permission check failed');
}
if (wp_schedule_single_event(time(), 'aiit_schedule_update_event')) {
global $wpdb;
$image_exists = $wpdb->get_var("SELECT COUNT(*) FROM {$wpdb->prefix}aiit_posts_update");
wp_send_json_success(array('images' => $image_exists));
} else {
error_log('aiit_schedule_update - Failed to schedule the event.');
wp_send_json_error(array('message' => 'Failed to optimize image.'));
}
}
function aiit_update_posts() {
if (!aiit_oai_k_valid() || !aiit_k_valid()) {
wp_send_json_error('Invalid OpenAI API or License Key provided.');
}
global $wpdb;
$table_job = $wpdb->prefix . 'aiit_bckg_processing';
$image_exists = $wpdb->get_var("SELECT COUNT(*) FROM {$wpdb->prefix}aiit_posts_update");
if ($image_exists>0){
//clean up existing jobs in progress
$jobs_in_progress = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}aiit_bckg_processing WHERE `status` = 'In progress' AND `type` = 'Update'");
foreach ( $jobs_in_progress as $job ) {
$wpdb->update($table_job, array('status' => 'Canceled'), array('id' => $job->id));
}
//add the new job
$result = $wpdb->insert($table_job, array('initial_count' => $image_exists, 'status' => 'In progress', 'type' => 'Update'), array('%d', '%s', '%s'));
$job_id = null;
if ($result !== false) {
$job_id = $wpdb->insert_id;
$processed_images = 0;
$errors_in_row = 0;
$newStatus = 'Completed';
while ($imageForUpdate = aiit_fetchNextImageInPost()) {
$post_type = get_post_type($imageForUpdate->post_id);
$processingResult = aiit_update_figures($imageForUpdate, $job_id);
$processingResult2 = aiit_update_captions($imageForUpdate, $job_id);
if($processingResult == "ok" || $processingResult2 == "ok"){
$processingResult == "ok";
$processed_images += 1;
$errors_in_row = 0;
$wpdb->update($table_job, array('processed_count' => $processed_images), array('id' => $job_id));
} else if ($processingResult == "nok"){
$errors_in_row += 1;
if($errors_in_row == 5){
$newStatus = 'Canceled due errors';
break;
}
}
aiit_removeProcessedRecordInPost($imageForUpdate->id);
}
if($processed_images == 0 && $newStatus == 'Completed'){
$newStatus = 'Failed';
}
$jobRow = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}aiit_bckg_processing WHERE `id` = %d", $job_id));
if($jobRow && $jobRow->status == 'In progress' ){
$wpdb->update($table_job, array('status' => $newStatus), array('id' => $job_id));
}
} else {
error_log('aiit_update_posts, failed to insert job');
}
}
}
function aiit_fetchNextImageInPost() {
global $wpdb;
return $wpdb->get_row("SELECT * FROM {$wpdb->prefix}aiit_posts_update LIMIT 1");
}
function aiit_removeProcessedRecordInPost($id) {
global $wpdb;
$table_optimization = $wpdb->prefix . 'aiit_posts_update';
$wpdb->delete($table_optimization, array('id' => $id));
}
function aiit_update_figures($imageForUpdate, $job_id){
$post_content = get_post_field('post_content', $imageForUpdate->post_id);
$processingResult = 'nok';
$reason = '';
if (!empty($post_content)) {
$new_content = aiit_replace_figure_content($post_content, $imageForUpdate->image_id, $imageForUpdate->post_id, $job_id);
if ($new_content != ''){
wp_update_post(array('ID' => $imageForUpdate->post_id, 'post_content' => $new_content));
$processingResult = 'ok';
} else {
$reason = 'Failed to get result';
}
} else {
$reason = 'Failed to load post content';
}
return $processingResult;
}
function aiit_replace_figure_content($post_content, $image_id, $post_id, $job_id){
$try_update_all = 'false';
if($image_id == -1){
$try_update_all = 'true';
} else {
$altTextML = get_post_meta($image_id, '_wp_attachment_image_alt', true);
$captionML = get_post_field('post_excerpt', $image_id);
$titleML = get_post_field('post_title', $image_id);
}
$images_updated = 0;
$updateTitle = (get_option('aiit_generate_title') === 'on') ? "true" : "false";
$updateCaption = (get_option('aiit_generate_caption') === 'on') ? "true" : "false";
Global $wpdb;
$table_log = $wpdb->prefix . 'aiit_processed_images';
$doc = new DOMDocument('1.0', 'UTF-8');
$doc->formatOutput = true;
$content_new = '' . '' . $post_content . '
';
libxml_use_internal_errors(true);
$doc->loadHTML($content_new);
$xpath = new DOMXPath($doc);
$figures = $xpath->query('//figure[contains(@class, "wp-block-image")]');
foreach ($figures as $figure) {
$img = $xpath->query('.//img', $figure)->item(0);
if($img){
$imgClass = $img ? $img->getAttribute('class') : '';
if (preg_match('/wp-image-(\d+)/', $imgClass, $matches)) {
$imgID = $matches[1];
if($imgID == $image_id || $try_update_all == 'true'){
$updated = 'false';
if($try_update_all == 'true'){
$altTextML = get_post_meta($imgID, '_wp_attachment_image_alt', true);
$captionML = get_post_field('post_excerpt', $imgID);
$titleML = get_post_field('post_title', $imgID);
}
$current_alt = $img ? $img->getAttribute('alt') : '';
$current_title = $img ? $img->getAttribute('title') : '';
$figcaption = $xpath->query('.//figcaption', $figure)->item(0);
$current_caption = $figcaption ? $figcaption->nodeValue : '';//old caption
if($updateCaption == "true" && $current_caption != $captionML){
if(!$figcaption){
$newFigcaption = $doc->createElement('figcaption', $captionML);
$newFigcaption->setAttribute('class', 'wp-element-caption');
$figure->appendChild($newFigcaption);
} else {
$figcaption->nodeValue = $captionML;
}
$updated = 'true';
}
if ($current_alt != $altTextML){
$img->setAttribute('alt', $altTextML);
$updated = 'true';
}
if ($updateTitle === "true" && $titleML != $current_title) {
$img->setAttribute('title', $titleML);
$updated = 'true';
}
if ($updated == 'true'){
$wpdb->insert($table_log, array('image_name' => basename(get_attached_file($imgID)), 'image_id' => $imgID, 'post_id' => $post_id, 'job_id' => $job_id, 'old_alt' => $current_alt, 'old_caption' => $current_caption, 'old_title' => $current_title, 'status' => 'ok'), array('%s', '%d', '%d', '%d', '%s', '%s', '%s', '%s'));
$images_updated++;
}
}
}
}
}
if($images_updated > 0){
$firstDivElement = $xpath->query('//div[1]')->item(0);
$post_content = $doc->saveHTML($firstDivElement);
$post_content = substr($post_content, 5, -6);
} else {
$post_content = "";
}
return $post_content;
}
function aiit_update_captions($imageForUpdate, $job_id){
$post_content = get_post_field('post_content', $imageForUpdate->post_id);
$processingResult = 'nok';
$reason = '';
if (!empty($post_content)) {
$new_content = aiit_replace_caption_content($post_content, $imageForUpdate->image_id, $imageForUpdate->post_id, $job_id);
if ($new_content != ''){
wp_update_post(array('ID' => $imageForUpdate->post_id, 'post_content' => $new_content));
$processingResult = 'ok';
} else {
$reason = 'Failed to get result';
}
} else {
$reason = 'Failed to load post content';
}
if($processingResult == "nok"){
Global $wpdb;
$table_log = $wpdb->prefix . 'aiit_processed_images';
$wpdb->insert($table_log, array('image_name' => basename(get_attached_file($imageForUpdate->image_id)), 'image_id' => $imageForUpdate->image_id, 'post_id' => $imageForUpdate->post_id, 'job_id' => $job_id, 'status' => 'failed', 'reason' => $reason), array('%s', '%d', '%d', '%d', '%s', '%s'));
}
return $processingResult;
}
function aiit_replace_caption_content($post_content, $image_id, $post_id, $job_id){
$content = $post_content;
$try_update_all = 'false';
if($image_id == -1){
$try_update_all = 'true';
} else {
$altTextML = get_post_meta($image_id, '_wp_attachment_image_alt', true);
$captionML = get_post_field('post_excerpt', $image_id);
$titleML = get_post_field('post_title', $image_id);
}
$images_updated = 0;
$updateTitle = (get_option('aiit_generate_title') === 'on') ? "true" : "false";
$updateCaption = (get_option('aiit_generate_caption') === 'on') ? "true" : "false";
Global $wpdb;
$table_log = $wpdb->prefix . 'aiit_processed_images';
$pattern = '/(\[caption\s*.*?\])()(.*?)\[\/caption\]/i';
preg_match_all($pattern, $post_content, $captions, PREG_SET_ORDER);
foreach ($captions as $caption) {
$imgTag = $caption[2];
$current_caption = $caption[3];
$doc = new DOMDocument('1.0', 'UTF-8');
$doc->formatOutput = true;
$doc->loadHTML('' . $imgTag);
$img = $doc->getElementsByTagName('img')->item(0);
if($img){
$imgClass = $img ? $img->getAttribute('class') : '';
if (preg_match('/wp-image-(\d+)/', $imgClass, $captions)) {
$updated = 'false';
$imgID = $captions[1];
if($imgID == $image_id || $try_update_all == 'true'){
if($try_update_all == 'true'){
$altTextML = get_post_meta($imgID, '_wp_attachment_image_alt', true);
$captionML = get_post_field('post_excerpt', $imgID);
$titleML = get_post_field('post_title', $imgID);
}
$current_alt = $img ? $img->getAttribute('alt') : '';
$current_title = $img ? $img->getAttribute('title') : '';
if ($altTextML != $current_alt){
$img->setAttribute('alt', $altTextML);
$updated = 'true';
}
if ($updateTitle === "true" && $titleML != $current_title) {
$img->setAttribute('title', $titleML);
$updated = 'true';
}
$captionTxt = $current_caption;
if ($updateCaption === "true" && $captionML != $captionTxt){
$captionTxt = $captionML;
$updated = 'true';
}
if ($updated == 'true'){
$imgTagNew = $doc->saveHTML($img);
$contentNew = $caption[1] . $imgTagNew . $captionTxt . "[/caption]";
$content = str_replace($caption[0], $contentNew, $content);
$wpdb->insert($table_log, array('image_name' => basename(get_attached_file($imgID)), 'image_id' => $imgID, 'post_id' => $post_id, 'job_id' => $job_id, 'old_alt' => $current_alt, 'old_caption' => $current_caption, 'old_title' => $current_title, 'status' => 'ok'), array('%s', '%d', '%d', '%d', '%s', '%s', '%s', '%s'));
$images_updated++;
}
}
}
}
}
if($images_updated == 0){
$content = '';
}
return $content;
}
function aiit_stop_update() {
if (!isset($_POST['security']) || !wp_verify_nonce( sanitize_text_field( wp_unslash($_POST['security'])), 'aiit_update_nonce')) {
wp_send_json_error('Permission check failed');
}
global $wpdb;
$table_job = $wpdb->prefix . 'aiit_bckg_processing';
$jobs_in_progress = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}aiit_bckg_processing WHERE `status` = 'In progress'");
$table_name = $wpdb->prefix . 'aiit_posts_update';
$delete = $wpdb->query("TRUNCATE TABLE {$wpdb->prefix}aiit_posts_update");
foreach ( $jobs_in_progress as $job ) {
$wpdb->update($table_job, array('status' => 'Canceled manually'), array('id' => $job->id));
}
}
function aiit_update_on_save_post($post_id, $post, $update){
if (defined('DOING_AUTOSAVE') && DOING_AUTOSAVE) {
return;
}
if (!current_user_can('edit_post', $post_id)) {
return;
}
if (get_option('aiit_replace_on_save') != 'on'){
return;
}
if (!aiit_oai_k_valid() || !aiit_k_valid()) {
return;
}
Global $wpdb;
$latest_record = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}aiit_processed_images WHERE post_id = %s ORDER BY id DESC LIMIT 1", $post_id));
$currentTimestamp = current_time('timestamp');
$diff = 100;
if ($latest_record && $latest_record->created_on){
$dateTime = new DateTime($latest_record->created_on);
$timestamp = $dateTime->getTimestamp();
$diff = $currentTimestamp - $timestamp;
}
if ($diff > 3) {
if (!empty($post->post_content)) {
$postsUpdated = 'false';
$new_content = aiit_replace_figure_content($post->post_content, -1, $post_id, -1);
if ($new_content != ''){
$postsUpdated = 'true';
} else {
$new_content = $post->post_content;
}
$new_content2 = aiit_replace_caption_content($new_content, -1, $post_id, -1);
if ($new_content2 != ''){
$postsUpdated = 'true';
$new_content = $new_content2;
}
if ($postsUpdated == 'true'){
wp_update_post(array('ID' => $post_id, 'post_content' => $new_content));
}
}
}
}