KB Support: Search for tickets with an orphaned status and update

kbs-update-orphaned-ticket-status.php

<?php
/**
 * Find tickets that are set to a status that is no longer registered
 * and update their status to the value of the $new_status variable.
 *
 * @written by  Mike Howard
 * @for KB Support - https://wordpress.org/plugins/kb-support
 */
function kbs_update_orphaned_ticket_status()  {
    global $wpdb;

    $new_status   = 'hold';
    $valid_status = get_post_stati();
    $status_keys  = "";
    $i            = 0;

    foreach( $valid_status as $valid )  {
        if ( $i > 0 )   {
            $status_keys .= ',';
        }
        $status_keys .= "'{$valid}'";
        $i++;
    }

    $orphans = $wpdb->get_results(
        "
        UPDATE $wpdb->posts
        SET post_status = $new_status
        WHERE post_type = 'kbs_ticket'
        AND post_status NOT IN ($status_keys)
        "
    );

}
add_action( 'admin_init', 'kbs_update_orphaned_ticket_status' );