API Email	API Key	Zone ID	CloudFlare Connection

'email-account', 'posts_per_page' => -1, 'meta_query' => [ [ 'key' => 'domain', 'value' => $post_id, 'compare' => '=' ] ] ]); if (!empty($email_accounts)) { echo '

Email Accounts (' . count($email_accounts) . ')

'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; foreach ($email_accounts as $account) { $full_name = get_post_meta($account->ID, 'full_name', true); $smtp_status = get_post_meta($account->ID, 'smtp_status', true); $imap_status = get_post_meta($account->ID, 'imap_status', true); echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } echo '

Email Address	Full Name	SMTP Status	IMAP Status	Actions
' . esc_html($account->post_title) . '	' . esc_html($full_name) . '	' . esc_html($smtp_status) . '	' . esc_html($imap_status) . '	'; echo 'View '; echo 'Edit'; echo '

'; } else { echo '

No email accounts found for this domain.

'; } echo '

Create New Email Account

'; ?>

prefix . 'rl_mailwarmer_conversations'; // First, get all email accounts for this domain $email_account_ids = array(); if (!empty($email_accounts)) { foreach ($email_accounts as $account) { $email_account_ids[] = $account->ID; } } if (!empty($email_account_ids)) { // Convert to a comma-separated string for SQL $email_account_ids_str = implode(',', $email_account_ids); // Find campaign IDs that use these email accounts $campaign_ids = $wpdb->get_col(" SELECT DISTINCT campaign_id FROM $conversations_table WHERE email_account_id IN ($email_account_ids_str) "); if (!empty($campaign_ids)) { // Get campaign details $campaigns = get_posts([ 'post_type' => 'campaign', 'posts_per_page' => -1, 'post__in' => $campaign_ids ]); if (!empty($campaigns)) { echo '

Campaigns (' . count($campaigns) . ')

'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; foreach ($campaigns as $campaign) { $tracking_id = get_post_meta($campaign->ID, 'campaign_tracking_id', true); $start_date = get_post_meta($campaign->ID, 'start_date', true); $target_volume = get_post_meta($campaign->ID, 'target_volume', true); echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } echo '

Campaign Name	Tracking ID	Start Date	Target Volume	Actions
' . esc_html($campaign->post_title) . '	' . esc_html($tracking_id) . '	' . esc_html($start_date) . '	' . esc_html($target_volume) . '	'; echo 'View '; echo 'Edit'; echo '

'; } } else { echo '

No campaigns found that use email accounts from this domain.

'; } } else { echo '

No campaigns found since there are no email accounts for this domain.

'; } echo '

Create New Campaign

'; ?>