/var/www/html/alliance_sms/edit_numbers.php:79	ext_id	$st = $pdo->prepare("SELECT id, user_id, campaign_name, campaign_ext_id, originating_number FROM campaigns WHERE id=:id");
/var/www/html/alliance_sms/delete_campaign_backup_20251208.php:60	ext_id	$campaign_ext  = (string)($camp['campaign_ext_id'] ?? '');
/var/www/html/alliance_sms/process_campaign.php:74	fs_html_txt	$target = "/var/www/html/{$finalBase}.txt";
/var/www/html/alliance_sms/send_campaign_sw.php:178	fs_html_txt	$fs = "/var/www/html/{$nameOrId}.txt";
/var/www/html/alliance_sms/send_campaign_sw.php:185	fs_html_txt	if ($campExt !== '' && is_file("/var/www/html/{$campExt}.txt")) return text_url_and_contents_for($campExt);
/var/www/html/alliance_sms/send_campaign_sw.php:302	ext_id	$stmt = $pdo->prepare("SELECT id, campaign_name, campaign_ext_id, originating_number, user_id FROM campaigns WHERE id=:id");
/var/www/html/alliance_sms/send_campaign_sw.php:313	ext_id	$campExt = (string)$camp['campaign_ext_id'];
/var/www/html/alliance_sms/send_campaign_sw.php:657	ext_id	$insAudit = $pdo->prepare("INSERT INTO msg_sent_audit (campaigns_id,campaign_ext_id,destnum,srcnum,operator_msg_id,user_id) VALUES (:cid,:cex,:dst,:src,:omid,:uid)");
/var/www/html/alliance_sms/send_campaign_sw.php:658	ext_id	$insAuditOpt = $pdo->prepare("INSERT INTO msg_sent_audit (campaigns_id,campaign_ext_id,destnum,srcnum,operator_msg_id,user_id,dlr_delivery_status) VALUES (:cid,:cex,:dst,:src,NULL,:uid,'NOT_SENT_OPT_OUT')");
/var/www/html/alliance_sms/mmsmon.php:172	ext_id	$rows = $pdoLocal->query("SELECT id, campaign_ext_id, datesent, destnum, srcnum, operator_msg_id
/var/www/html/alliance_sms/mmsmon.php:183	ext_id	$stmt = $pdoLocal->prepare("SELECT id, campaign_ext_id, datesent, destnum, srcnum, operator_msg_id
/var/www/html/alliance_sms/mmsmon.php:544	ext_id	<div>campaign_ext_id</div>
/var/www/html/alliance_sms/mmsmon.php:814	ext_id	'<div>' + (r.campaign_ext_id || '') + '</div>' +
/var/www/html/alliance_sms/cl_bar_chart_resizing_by_itself.php:439	ext_id	$stmt = $mysqli->prepare("SELECT campaign_name, campaign_ext_id FROM campaigns WHERE id=?");
/var/www/html/alliance_sms/cl_bar_chart_resizing_by_itself.php:447	ext_id	$campExt = (string)$row['campaign_ext_id'];
/var/www/html/alliance_sms/view_campaign.php:100	ext_id	$stmt = $mysqli->prepare("SELECT campaign_name, campaign_ext_id FROM campaigns WHERE id=?");
/var/www/html/alliance_sms/view_campaign.php:112	ext_id	$campExt    = (string)$row['campaign_ext_id'];
/var/www/html/alliance_sms/view_campaign.php:116	ext_id	/* Text & image strictly by campaign_ext_id; if empty, fallback to slug */
/var/www/html/alliance_sms/upload_campaign.php:577	ext_id	campaign_ext_id VARCHAR(128) NOT NULL UNIQUE,
/var/www/html/alliance_sms/upload_campaign.php:683	ext_id	$camp = trim((string)($_GET['campaign_ext_id'] ?? ''));
/var/www/html/alliance_sms/upload_campaign.php:687	ext_id	$s = $pdo->prepare("SELECT id, company_id FROM campaign_ids WHERE campaign_ext_id=:e");
/var/www/html/alliance_sms/upload_campaign.php:695	ext_id	$ins = $pdo->prepare("INSERT INTO campaign_ids (company_id, source_number_id, campaign_ext_id, user_name, date_created) VALUES (:c, :s, :e, :u, NOW())");
/var/www/html/alliance_sms/upload_campaign.php:813	ext_id	$campaign_ext  = trim((string)($_POST['campaign_ext_id'] ?? ''));
/var/www/html/alliance_sms/upload_campaign.php:848	ext_id	$s2 = $pdo->prepare("SELECT id,company_id FROM campaign_ids WHERE campaign_ext_id=:e");
/var/www/html/alliance_sms/upload_campaign.php:857	ext_id	$ins = $pdo->prepare("INSERT INTO campaign_ids (company_id, source_number_id, campaign_ext_id, user_name, date_created) VALUES (:c,:s,:e,:u,NOW())");
/var/www/html/alliance_sms/upload_campaign.php:877	ext_id	$qq = $pdo->prepare("SELECT id FROM campaign_ids WHERE campaign_ext_id=:e");
/var/www/html/alliance_sms/upload_campaign.php:1018	ext_id	(campaign_name, campaign_ext_id, originating_number,
/var/www/html/alliance_sms/upload_campaign.php:1592	ext_id	<label for="campaign_ext_id">Campaign ID (max 30)</label>
/var/www/html/alliance_sms/upload_campaign.php:1595	ext_id	id="campaign_ext_id"
/var/www/html/alliance_sms/upload_campaign.php:1596	ext_id	name="campaign_ext_id"
/var/www/html/alliance_sms/upload_campaign.php:1634	ext_id	<div class="note">Original → <code><?= h(UP_REL_TEXTS) ?></code>; processed → <code>/var/www/html/{slug}.txt</code> (&amp; <code>{campaign_ext_id}.txt</code>).</div>
/var/www/html/alliance_sms/upload_campaign.php:1634	fs_html_txt	<div class="note">Original → <code><?= h(UP_REL_TEXTS) ?></code>; processed → <code>/var/www/html/{slug}.txt</code> (&amp; <code>{campaign_ext_id}.txt</code>).</div>
/var/www/html/alliance_sms/upload_campaign.php:1802	ext_id	var inpCamp = $('#campaign_ext_id');
/var/www/html/alliance_sms/upload_campaign.php:2035	ext_id	campaign_ext_id: v
/var/www/html/alliance_sms/upload_campaign.php:2183	ext_id	var el = document.getElementById('campaign_ext_id');
/var/www/html/alliance_sms/archived_campaigns_backup_20251208.php:17	ext_id	$sql = "SELECT id, campaign_name, campaign_ext_id, user_id, user_name, created_at, archived_at
/var/www/html/alliance_sms/archived_campaigns_backup_20251208.php:20	ext_id	ORDER BY campaign_ext_id ";
/var/www/html/alliance_sms/archived_campaigns_backup_20251208.php:90	ext_id	<td class="mono"><?= h($c['campaign_ext_id']) ?></td>
/var/www/html/alliance_sms/reprocess_assets.php:172	ext_id	$campaignExtId  = trim($_POST['campaign_ext_id'] ?? ''); // NEW: external ID from the form
/var/www/html/alliance_sms/reprocess_assets.php:196	ext_id	// 2) Insert the campaign row (store raw, app-relative file paths) + campaign_ext_id + user_id
/var/www/html/alliance_sms/reprocess_assets.php:197	ext_id	$stmt = $db->prepare("INSERT INTO campaigns (campaign_name, campaign_ext_id, image_file, text_file, phone_numbers_file, user_id, created_at)
/var/www/html/alliance_sms/reprocess_assets.php:306	ext_id	<label for="campaign_ext_id">Campaign External ID</label>
/var/www/html/alliance_sms/reprocess_assets.php:307	ext_id	<input type="text" id="campaign_ext_id" name="campaign_ext_id" required placeholder="e.g., PIEDMONT_2025_W1">
/var/www/html/alliance_sms/reprocess_assets.php:308	ext_id	<div class="note">Stored in <code>campaigns.campaign_ext_id</code> and copied into recipients column <code>campaignID</code> (if it exists).</div>
/var/www/html/alliance_sms/reprocess_assets.php:333	fs_html_txt	<div class="note">Normalized UTF-8 saved as <code>/var/www/html/{slug}.txt</code>.</div>
/var/www/html/alliance_sms/receive_sms.php:140	ext_id	campaign_ext_id VARCHAR(20) NULL,
/var/www/html/alliance_sms/receive_sms.php:150	ext_id	KEY idx_campaign_ext_id (campaign_ext_id),
/var/www/html/alliance_sms/cl_last_good_20251203.php:422	ext_id	$stmt = $mysqli->prepare("SELECT campaign_name, campaign_ext_id FROM campaigns WHERE id=?");
/var/www/html/alliance_sms/cl_last_good_20251203.php:430	ext_id	$campExt = (string)$row['campaign_ext_id'];
/var/www/html/alliance_sms/archived_campaigns.php:31	ext_id	$sql = "SELECT id, campaign_name, campaign_ext_id, user_id, user_name, created_at, archived_at
/var/www/html/alliance_sms/archived_campaigns.php:34	ext_id	ORDER BY campaign_ext_id ";
/var/www/html/alliance_sms/archived_campaigns.php:207	ext_id	<td class="mono"><?= h($c['campaign_ext_id']) ?></td>
/var/www/html/alliance_sms/send_campaign_twilio.php:193	fs_html_txt	$fs  = "/var/www/html/{$nameOrId}.txt";
/var/www/html/alliance_sms/send_campaign_twilio.php:200	fs_html_txt	if ($campExt !== '' && is_file("/var/www/html/{$campExt}.txt")) return text_url_and_contents_for($campExt);
/var/www/html/alliance_sms/send_campaign_twilio.php:316	ext_id	$stmt = $pdo->prepare("SELECT id, campaign_name, campaign_ext_id, originating_number, user_id FROM campaigns WHERE id=:id");
/var/www/html/alliance_sms/send_campaign_twilio.php:328	ext_id	$campExt      = (string)$camp['campaign_ext_id'];
/var/www/html/alliance_sms/send_campaign_twilio.php:725	ext_id	"INSERT INTO msg_sent_audit (campaigns_id, campaign_ext_id, destnum, srcnum, operator_msg_id, user_id)
/var/www/html/alliance_sms/send_campaign_twilio.php:729	ext_id	"INSERT INTO msg_sent_audit (campaigns_id, campaign_ext_id, destnum, srcnum, operator_msg_id, user_id, dlr_delivery_status)
/var/www/html/alliance_sms/sms_thread.php:162	ext_id	campaign_ext_id VARCHAR(20) NULL,
/var/www/html/alliance_sms/sms_thread.php:173	ext_id	KEY idx_campaign_ext_id (campaign_ext_id),
/var/www/html/alliance_sms/sms_thread.php:448	ext_id	(campaigns_id, campaign_ext_id, destnum, srcnum, operator_msg_id, user_id, datesent)
/var/www/html/alliance_sms/export_recipients_csv.php:13	ext_id	$stmt=$pdo->prepare("SELECT campaign_name, campaign_ext_id FROM campaigns WHERE id=?");
/var/www/html/alliance_sms/receive_sms_twilio.php:135	ext_id	campaign_ext_id VARCHAR(20) NULL,
/var/www/html/alliance_sms/receive_sms_twilio.php:145	ext_id	KEY idx_campaign_ext_id (campaign_ext_id),
/var/www/html/alliance_sms/list_campaigns_horizontal_cards.php:32	DB.text_file	/** Resolve campaigns.text_file (absolute or relative) to an absolute path; fall back to /var/www/html/{slug}.txt */
/var/www/html/alliance_sms/list_campaigns_horizontal_cards.php:32	fs_html_txt	/** Resolve campaigns.text_file (absolute or relative) to an absolute path; fall back to /var/www/html/{slug}.txt */
/var/www/html/alliance_sms/list_campaigns_horizontal_cards.php:42	uploads_texts	// Relative to PROCESSED_ROOT (handles 'uploads/text/' or 'uploads/texts/' etc.)
/var/www/html/alliance_sms/list_campaigns_horizontal_cards.php:56	DB.text_file	/** Read preview from the resolved absolute text path (campaigns.text_file preferred; slug fallback) */
/var/www/html/alliance_sms/list_campaigns_horizontal_cards.php:152	DB.text_file	/* fetch non-archived campaigns (include campaigns.text_file for preview resolution) */
/var/www/html/alliance_sms/list_campaigns_horizontal_cards.php:153	ext_id	$res = $mysqli->query("SELECT id, campaign_name, campaign_ext_id, user_id, user_name, created_at, text_file FROM campaigns WHERE archived=0 ORDER BY id DESC");
/var/www/html/alliance_sms/list_campaigns_horizontal_cards.php:517	ext_id	$ext    = (string)($row['campaign_ext_id'] ?? '');
/var/www/html/alliance_sms/list_campaigns_horizontal_cards.php:525	DB.text_file	// Use campaigns.text_file if present; fallback to {slug}.txt
/var/www/html/alliance_sms/list_campaigns_horizontal_cards.php:599	ext_id	$ext    = (string)($row['campaign_ext_id'] ?? '');
/var/www/html/alliance_sms/list_campaigns_horizontal_cards.php:607	DB.text_file	// Use campaigns.text_file if present; fallback to {slug}.txt
/var/www/html/alliance_sms/cl.php:447	ext_id	$stmt = $mysqli->prepare("SELECT campaign_name, campaign_ext_id FROM campaigns WHERE id=?");
/var/www/html/alliance_sms/cl.php:455	ext_id	$campExt = (string)$row['campaign_ext_id'];
/var/www/html/alliance_sms/update_summary.php:39	ext_id	campaign_ext_id,
/var/www/html/alliance_sms/update_summary.php:53	ext_id	msa.campaign_ext_id,
/var/www/html/alliance_sms/update_summary.php:85	ext_id	msa.campaign_ext_id,
/var/www/html/alliance_sms/edit_text.php:43	ext_id	$stmt = $pdo->prepare("SELECT campaign_name, campaign_ext_id, created_at FROM campaigns WHERE id=?");
/var/www/html/alliance_sms/edit_text.php:49	ext_id	$ext  = (string)($camp['campaign_ext_id'] ?? '');
/var/www/html/alliance_sms/edit_text.php:53	fs_html_txt	$idTxtPath   = "/var/www/html/{$ext}.txt";
/var/www/html/alliance_sms/edit_text.php:54	fs_html_txt	$slugTxtPath = "/var/www/html/{$slug}.txt";
/var/www/html/alliance_sms/list_campaigns.php:210	ext_id	c.campaign_ext_id,
/var/www/html/alliance_sms/list_campaigns.php:658	ext_id	$ext    = (string)($row['campaign_ext_id'] ?? '');
/var/www/html/alliance_sms/list_campaigns.php:724	ext_id	<a href="msg_audit.php?campaign_ext_id=<?= urlencode($ext) ?>" class="icon-btn" title="Audit this campaign">
/var/www/html/alliance_sms/list_campaigns.php:762	ext_id	$ext    = (string)($row['campaign_ext_id'] ?? '');
/var/www/html/alliance_sms/list_campaigns.php:846	ext_id	<a href="msg_audit.php?campaign_ext_id=<?= urlencode($ext) ?>" class="icon-btn" title="Audit this campaign">
/var/www/html/alliance_sms/cl3_working_perfect.php:440	ext_id	$stmt = $pdo->prepare("SELECT campaign_name, campaign_ext_id FROM campaigns WHERE id = :id LIMIT 1");
/var/www/html/alliance_sms/cl3_working_perfect.php:446	ext_id	$campExt = (string)$row['campaign_ext_id'];
/var/www/html/alliance_sms/send_campaign.php:204	fs_html_txt	$fs  = "/var/www/html/{$nameOrId}.txt";
/var/www/html/alliance_sms/send_campaign.php:211	fs_html_txt	if ($campExt !== '' && is_file("/var/www/html/{$campExt}.txt")) {
/var/www/html/alliance_sms/send_campaign.php:458	ext_id	$stmt = $pdo->prepare("SELECT id, campaign_name, campaign_ext_id, originating_number, user_id FROM campaigns WHERE id=:id");
/var/www/html/alliance_sms/send_campaign.php:469	ext_id	$campExt      = (string)$camp['campaign_ext_id'];
/var/www/html/alliance_sms/send_campaign.php:878	ext_id	$insAudit = $pdo->prepare("INSERT INTO msg_sent_audit (campaigns_id, campaign_ext_id, destnum, srcnum, operator_msg_id, user_id) VALUES (:cid,:cex,:dst,:src,:omid,:uid)");
/var/www/html/alliance_sms/send_campaign.php:887	ext_id	"INSERT INTO msg_sent_audit (campaigns_id, campaign_ext_id, destnum, srcnum, operator_msg_id, user_id, dlr_delivery_status)
/var/www/html/alliance_sms/send_campaign.php:1224	ext_id	campaign_ext_id,
/var/www/html/alliance_sms/send_campaign.php:1237	ext_id	msa.campaign_ext_id,
/var/www/html/alliance_sms/send_campaign.php:1255	ext_id	msa.campaign_ext_id,
/var/www/html/alliance_sms/delete_campaign.php:112	ext_id	$campaign_ext  = (string)($camp['campaign_ext_id'] ?? '');
/var/www/html/alliance_sms/campaign_report.php:142	ext_id	/** Positive DLR from msg_sent_audit by campaign_ext_id in range */
/var/www/html/alliance_sms/campaign_report.php:147	ext_id	WHERE campaign_ext_id=?
/var/www/html/alliance_sms/campaign_report.php:156	ext_id	/** Begin/End from msg_sent_audit by campaign_ext_id (and optional user) in range */
/var/www/html/alliance_sms/campaign_report.php:162	ext_id	WHERE campaign_ext_id=?
/var/www/html/alliance_sms/campaign_report.php:170	ext_id	WHERE campaign_ext_id=?
/var/www/html/alliance_sms/campaign_report.php:186	ext_id	WHERE campaign_ext_id=?
/var/www/html/alliance_sms/campaign_report.php:234	ext_id	$stmt = $pdo->prepare("SELECT id, campaign_name, campaign_ext_id, company_name, user_id, user_name, image_file, text_file, phone_numbers_file, created_at FROM campaigns WHERE id=?");
/var/www/html/alliance_sms/campaign_report.php:244	ext_id	$extId = (string)($camp['campaign_ext_id'] ?? '');
/var/www/html/alliance_sms/receive_sms_sw.php:139	ext_id	campaign_ext_id VARCHAR(20) NULL,
/var/www/html/alliance_sms/receive_sms_sw.php:149	ext_id	KEY idx_campaign_ext_id (campaign_ext_id),
/var/www/html/alliance_sms/msg_audit.php:12	ext_id	$campaign_ext_id = trim((string)($_GET['campaign_ext_id'] ?? ''));
/var/www/html/alliance_sms/msg_audit.php:23	ext_id	if ($campaign_ext_id !== '') { $where[] = "campaign_ext_id = :cxe"; $params[':cxe'] = $campaign_ext_id; }
/var/www/html/alliance_sms/msg_audit.php:29	ext_id	$sqlBase = "SELECT id, campaigns_id, campaign_ext_id, datesent, destnum, srcnum, operator_msg_id, dlr_id, dlr_done_at, dlr_delivery_status, dlr_delivery_error_code FROM msg_sent_audit";
/var/www/html/alliance_sms/msg_audit.php:45	ext_id	fputcsv($out, ['id','campaigns_id','campaign_ext_id','datesent','destnum','srcnum','operator_msg_id','dlr_id','dlr_done_at','dlr_delivery_status','dlr_delivery_error_code']);
/var/www/html/alliance_sms/msg_audit.php:48	ext_id	$row['id'],$row['campaigns_id'],$row['campaign_ext_id'],$row['datesent'],$row['destnum'],
/var/www/html/alliance_sms/msg_audit.php:92	ext_id	<input name="campaign_ext_id" value="<?= h($campaign_ext_id) ?>" placeholder="e.g. ALLIANCE_ABC">
/var/www/html/alliance_sms/msg_audit.php:117	ext_id	'campaign_ext_id'=>$campaign_ext_id?:null,'destnum'=>$destnum?:null,'date_from'=>$date_from?:null,'date_to'=>$date_to?:null,'status'=>$status?:null,'download'=>1
/var/www/html/alliance_sms/msg_audit.php:126	ext_id	<th>campaign_ext_id</th>
/var/www/html/alliance_sms/msg_audit.php:142	ext_id	<td><?= h($r['campaign_ext_id']) ?></td>
/var/www/html/alliance_sms/send_campaign_parallel.php:203	fs_html_txt	$fs  = "/var/www/html/{$nameOrId}.txt";
/var/www/html/alliance_sms/send_campaign_parallel.php:210	fs_html_txt	if ($campExt !== '' && is_file("/var/www/html/{$campExt}.txt")) {
/var/www/html/alliance_sms/send_campaign_parallel.php:451	ext_id	$stmt = $pdo->prepare("SELECT id, campaign_name, campaign_ext_id, originating_number, user_id FROM campaigns WHERE id=:id");
/var/www/html/alliance_sms/send_campaign_parallel.php:462	ext_id	$campExt      = (string)$camp['campaign_ext_id'];
/var/www/html/alliance_sms/send_campaign_parallel.php:864	ext_id	$insAudit = $pdo->prepare("INSERT INTO msg_sent_audit (campaigns_id, campaign_ext_id, destnum, srcnum, operator_msg_id, user_id) VALUES (:cid,:cex,:dst,:src,:omid,:uid)");
/var/www/html/alliance_sms/send_campaign_parallel.php:869	ext_id	"INSERT INTO msg_sent_audit (campaigns_id, campaign_ext_id, destnum, srcnum, operator_msg_id, user_id, dlr_delivery_status)
/var/www/html/alliance_sms/backupitall.php:140	ext_id	`campaign_ext_id` VARCHAR(64) NOT NULL,
/var/www/html/alliance_sms/backupitall.php:150	ext_id	UNIQUE KEY `ux_campaigns_ext` (`campaign_ext_id`)
/var/www/html/alliance_sms/send_campaign_twilio_DUAL_MESSAGE_10_SEC_DELAY.php:193	fs_html_txt	$fs  = "/var/www/html/{$nameOrId}.txt";
/var/www/html/alliance_sms/send_campaign_twilio_DUAL_MESSAGE_10_SEC_DELAY.php:200	fs_html_txt	if ($campExt !== '' && is_file("/var/www/html/{$campExt}.txt")) return text_url_and_contents_for($campExt);
/var/www/html/alliance_sms/send_campaign_twilio_DUAL_MESSAGE_10_SEC_DELAY.php:318	ext_id	$stmt = $pdo->prepare("SELECT id, campaign_name, campaign_ext_id, originating_number, user_id FROM campaigns WHERE id=:id");
/var/www/html/alliance_sms/send_campaign_twilio_DUAL_MESSAGE_10_SEC_DELAY.php:330	ext_id	$campExt      = (string)$camp['campaign_ext_id'];
/var/www/html/alliance_sms/send_campaign_twilio_DUAL_MESSAGE_10_SEC_DELAY.php:687	ext_id	"INSERT INTO msg_sent_audit (campaigns_id, campaign_ext_id, destnum, srcnum, operator_msg_id, user_id)
/var/www/html/alliance_sms/send_campaign_twilio_DUAL_MESSAGE_10_SEC_DELAY.php:698	ext_id	"INSERT INTO msg_sent_audit (campaigns_id, campaign_ext_id, destnum, srcnum, operator_msg_id, user_id, dlr_delivery_status)
/var/www/html/alliance_sms/send_campaign_optout.php:71	ext_id	$stmt = $pdo->prepare("SELECT campaign_name, campaign_ext_id, sending_paused FROM campaigns WHERE id=?");
/var/www/html/alliance_sms/send_campaign_optout.php:77	ext_id	$campExt  = $camp['campaign_ext_id'] ?? '';