get_results( "SELECT term_taxonomy_id FROM {$wpdb->term_taxonomy}" );
foreach ( $term_taxonomy_ids as $term_taxonomy_id_obj ) {
$term_taxonomy_id = $term_taxonomy_id_obj->term_taxonomy_id;
$count_result = $wpdb->get_var( $wpdb->prepare(
"SELECT count(*) FROM {$wpdb->term_relationships} WHERE term_taxonomy_id = %d",
$term_taxonomy_id
) );
$wpdb->update(
$wpdb->term_taxonomy,
[ 'count' => $count_result ],
[ 'term_taxonomy_id' => $term_taxonomy_id ]
);
}
// Update comment count
$post_ids = $wpdb->get_results( "SELECT ID FROM {$wpdb->posts}" );
foreach ( $post_ids as $post_id_obj ) {
$post_id = $post_id_obj->ID;
$count_result = $wpdb->get_var( $wpdb->prepare(
"SELECT count(*) FROM {$wpdb->comments} WHERE comment_post_ID = %d AND comment_approved = 1",
$post_id
) );
$wpdb->update(
$wpdb->posts,
[ 'comment_count' => $count_result ],
[ 'ID' => $post_id ]
);
}
}
/**
* Remove import temporary options.
*/
public function remove_import_temp_options() {
$demo = Utils::get_demo();
if ( 'imported' !== get_option( "cmsmasters_bella-beauty_{$demo}_content_import_status" ) ) {
return;
}
delete_option( "cmsmasters_bella-beauty_{$demo}_elementor_import_templates_ids" );
delete_option( "cmsmasters_bella-beauty_{$demo}_forminator_import_forms_ids" );
delete_option( "cmsmasters_bella-beauty_{$demo}_import_attachments_ids" );
delete_option( "cmsmasters_bella-beauty_{$demo}_import_displayed_ids" );
delete_option( "cmsmasters_bella-beauty_{$demo}_wpforms_import_forms_ids" );
}
}