public function removeExpiredEvents()
    {
        global $wpdb;
        $post_type = 'event';
        // Get all events from databse
        $query = "SELECT ID FROM $wpdb->posts WHERE post_type = %s AND (post_status = %s or post_status = %s)";
        $completeQuery = $wpdb->prepare($query, $post_type, 'publish', 'draft');
        $events = $wpdb->get_results($completeQuery);

        if (count($events) == 0) {
            return;
        }

        $db_table = $wpdb->prefix."integrate_occasions";
        $query = "SELECT ID, event_id FROM $db_table WHERE event_id = %s";
        // Loop through events and check if occasions exist
        foreach ($events as $e) {
            $completeQuery = $wpdb->prepare($query, $e->ID);
            $results = $wpdb->get_results($completeQuery);
            // Delete event if occasions is empty
            if (count($results) == 0) {
                wp_delete_post($e->ID, true);
            }
        }

        return;
    }
public function removeExpiredEvents()
    {
        global $wpdb;
        $post_type = 'event';
        // Get all events from databse
        $query = "SELECT ID FROM $wpdb->posts WHERE post_type = %s AND (post_status = %s or post_status = %s)";
        $completeQuery = $wpdb->prepare($query, $post_type, 'publish', 'draft');
        $events = $wpdb->get_results($completeQuery);

        if (count($events) == 0) {
            return;
        }

        $db_table = $wpdb->prefix."integrate_occasions";
        $query = "SELECT ID, event_id FROM $db_table WHERE event_id = %s";
        // Loop through events and check if occasions exist
        foreach ($events as $e) {
            $completeQuery = $wpdb->prepare($query, $e->ID);
            $results = $wpdb->get_results($completeQuery);
            // Delete event if occasions is empty
            if (count($results) == 0) {
                wp_delete_post($e->ID, true);
            }
        }

        return;
    }
public function removeExpiredEvents ( ) { global $ wpdb ; $ post_type = 'event' ; // Get all events from databse $ query = "SELECT ID FROM $wpdb->posts WHERE post_type = %s AND (post_status = %s or post_status = %s)" ; $ completeQuery = $ wpdb -> prepare ( $ query , $ post_type , 'publish' , 'draft' ) ; $ events = $ wpdb -> get_results ( $ completeQuery ) ; if ( count ( $ events ) == 0 ) { return ; } $ db_table = $ wpdb -> prefix . "integrate_occasions" ; $ query = "SELECT ID, event_id FROM $db_table WHERE event_id = %s" ; // Loop through events and check if occasions exist foreach ( $ events as $ e ) { $ completeQuery = $ wpdb -> prepare ( $ query , $ e -> ID ) ; $ results = $ wpdb -> get_results ( $ completeQuery ) ; // Delete event if occasions is empty if ( count ( $ results ) == 0 ) { wp_delete_post ( $ e -> ID , true ) ; } } return ; }
Remove expired events from databse
@return void
Remove expired events from databse