public static function delete(Autoresponder $autoresponder) { global $wpdb; $deleteAutoresponderQuery = sprintf("DELETE FROM {$wpdb->prefix}wpr_autoresponders WHERE id=%d", $autoresponder->getId()); $wpdb->query($deleteAutoresponderQuery); $deleteAutoresponderMessagesQuery = sprintf("DELETE FROM %swpr_autoresponder_messages WHERE aid=%d", $wpdb->prefix, $autoresponder->getId()); $wpdb->query($deleteAutoresponderMessagesQuery); $deleteSubscriptionsQuery = sprintf("DELETE FROM %swpr_followup_subscriptions WHERE eid=%d AND type='autoresponder';", $wpdb->prefix, $autoresponder->getId()); $wpdb->query($deleteSubscriptionsQuery); $deleteAutoresponderEmailsQuery = sprintf("DELETE FROM %swpr_queue WHERE meta_key LIKE 'AR-%d-%%'", $wpdb->prefix, $autoresponder->getId()); $wpdb->query($deleteAutoresponderEmailsQuery); }