← All changes | mxchat-basic.php +740 -102 3.2.13 → 3.2.23 View file →

		@@ -2,9 +2,9 @@
2	2	/**
3	3	* Plugin Name: MxChat
4	4	* Plugin URI: https://mxchat.ai/
5	5	* Description: AI chatbot for WordPress with OpenAI, Claude, xAI, DeepSeek, live agent, PDF uploads, WooCommerce, and training on website data.
6		- * Version: 3.2.13
	6	+ * Version: 3.2.23
7	7	* Author: MxChat
8	8	* Author URI: https://mxchat.ai
9	9	* License: GPLv2 or later
10	10	* License URI: https://www.gnu.org/licenses/gpl-2.0.html
		@@ -23,8 +23,16 @@
23	23
24	24	if (!defined('MXCHAT_VERSION')) {
25	25	$plugin_data = get_file_data(__FILE__, array('Version' => 'Version'), 'plugin');
26	26	$version = $plugin_data['Version'];
	27	+ // MXCHAT_BASE_VERSION: the plain header version, stable across requests even in
	28	+ // dev mode. Use it for anything PERSISTED or COMPARED (the stored
	29	+ // mxchat_plugin_version option and the migration gate in
	30	+ // mxchat_check_for_update). MXCHAT_VERSION keeps the time() suffix in dev for
	31	+ // ASSET cache-busting only — persisting the suffixed value made the version
	32	+ // comparison churn every request, re-running the full activation/migration
	33	+ // suite per page load on dev installs.
	34	+ define('MXCHAT_BASE_VERSION', $version);
27	35	if (MXCHAT_DEV_MODE) {
28	36	$version .= '.' . time();
29	37	}
30	38	define('MXCHAT_VERSION', $version);
		@@ -30,8 +38,77 @@
30	38	define('MXCHAT_VERSION', $version);
31	39	}
32	40
33	41	/**
	42	+ * Toolbar items API level (plan-mxchat-20260916-65c9b6). Defined only by cores
	43	+ * that apply the `mxchat_chat_toolbar_items` filter while rendering the chat
	44	+ * toolbar and fire the `mxchat:toolbar-ready` / `mxchat:opened` document events.
	45	+ * Add-ons test `defined('MXCHAT_TOOLBAR_ITEMS_API')` and fall back to their
	46	+ * older DOM-injection path on cores without it, so a button is never rendered
	47	+ * twice. Bump the value only if the item shape (id / html / order) changes.
	48	+ */
	49	+if (!defined('MXCHAT_TOOLBAR_ITEMS_API')) {
	50	+ define('MXCHAT_TOOLBAR_ITEMS_API', 1);
	51	+}
	52	+
	53	+/**
	54	+ * Default confidence floor for the in-chat YouTube card, as a percentage
	55	+ * (plan-mxchat-20260813-f52492). Higher than the site-wide Similarity
	56	+ * Threshold default of 35 by design — see MxChat_Utils::video_embed_threshold().
	57	+ * Declared here so the gate, the admin field and the tests all read ONE number.
	58	+ */
	59	+if (!defined('MXCHAT_VIDEO_EMBED_THRESHOLD_DEFAULT')) {
	60	+ define('MXCHAT_VIDEO_EMBED_THRESHOLD_DEFAULT', 55);
	61	+}
	62	+
	63	+/**
	64	+ * One-time install stamp: records the plain version this site first ran, so
	65	+ * behavior defaults can differ between fresh installs and upgrades without
	66	+ * touching anyone's stored settings. Mirrors mxchat-mcp's 1.0.7 stamp shape
	67	+ * (plan 7b578e); first consumer is the "Strip unapproved links" default
	68	+ * (plan 58f8b4). Runs at init priority 1 — BEFORE initialize_default_options
	69	+ * (init 20) writes mxchat_options on a fresh site's first request, because
	70	+ * that option's pre-existing presence is how an upgrade is recognized.
	71	+ */
	72	+function mxchat_stamp_install_version() {
	73	+ if (get_option('mxchat_installed_at_version', '') !== '') {
	74	+ return;
	75	+ }
	76	+ $existing = get_option('mxchat_options', false) !== false;
	77	+ $version = defined('MXCHAT_BASE_VERSION') ? MXCHAT_BASE_VERSION : '0.0.0';
	78	+ update_option('mxchat_installed_at_version', $existing ? 'legacy' : $version, false);
	79	+}
	80	+add_action('init', 'mxchat_stamp_install_version', 1);
	81	+
	82	+/**
	83	+ * Stamp-derived default for the "Strip unapproved links" toggle (plan 58f8b4,
	84	+ * option-c split of the old Citation Links conflation): 'on' only for installs
	85	+ * born at 3.2.20+. A missing or 'legacy' stamp means the site predates the
	86	+ * setting — keep 'off' so no existing site's links start vanishing on update.
	87	+ */
	88	+function mxchat_strip_unapproved_links_default() {
	89	+ $stamp = get_option('mxchat_installed_at_version', '');
	90	+ if ($stamp === '' || $stamp === 'legacy') {
	91	+ return 'off';
	92	+ }
	93	+ return version_compare($stamp, '3.2.20', '>=') ? 'on' : 'off';
	94	+}
	95	+
	96	+/**
	97	+ * Effective state of "Strip unapproved links": an explicitly saved option
	98	+ * always wins; until one exists the install-stamp default governs. Read via
	99	+ * a fresh get_option on purpose — the response URL guard runs late in the
	100	+ * request and must see a value saved moments earlier.
	101	+ */
	102	+function mxchat_strip_unapproved_links_enabled() {
	103	+ $opts = get_option('mxchat_options', array());
	104	+ if (is_array($opts) && isset($opts['strip_unapproved_links_toggle'])) {
	105	+ return $opts['strip_unapproved_links_toggle'] === 'on';
	106	+ }
	107	+ return mxchat_strip_unapproved_links_default() === 'on';
	108	+}
	109	+
	110	+/**
34	111	* Honest, versioned User-Agent for MXChat remote-content ingestion fetches
35	112	* (Knowledge Base PDF import, URL import, sitemap / website crawl).
36	113	*
37	114	* WAF rulesets (SiteGround/ModSecurity, Wordfence, Cloudflare managed rules)
		@@ -402,23 +479,32 @@
402	479	// Include classes with error handling
403	480	function mxchat_include_classes() {
404	481	$class_files = array(
405	482	'includes/class-mxchat-model-catalog.php',
	483	+ 'includes/class-mxchat-model-liveness.php',
	484	+ 'includes/class-mxchat-session-store.php',
	485	+ 'includes/class-mxchat-live-agent-schedule.php',
406	486	'includes/class-mxchat-tool-registry.php',
407	487	'includes/class-mxchat-integrator.php',
408	488	'includes/class-mxchat-admin.php',
409	489	'includes/class-mxchat-public.php',
	490	+ 'includes/class-mxchat-block.php',
	491	+ 'includes/class-mxchat-elementor.php',
410	492	'includes/class-mxchat-utils.php',
411	493	'includes/class-mxchat-user.php',
	494	+ 'includes/class-mxchat-privacy.php',
412	495	'includes/class-mxchat-meta-box.php',
413	496	'includes/class-mxchat-chunker.php',
414	497	'includes/class-mxchat-word-handler.php',
415	498	'includes/class-mxchat-content-generator.php',
416	499	'includes/class-mxchat-cache-purge.php',
	500	+ 'includes/class-mxchat-editor-assistant.php',
417	501	'includes/class-rest-api.php',
418	502	'admin/class-ajax-handler.php',
419	503	'admin/class-pinecone-manager.php',
420		- 'admin/class-knowledge-manager.php'
	504	+ 'admin/class-pinecone-documents.php',
	505	+ 'admin/class-knowledge-manager.php',
	506	+ 'admin/class-vectorstore-manager.php'
421	507	);
422	508
423	509	foreach ($class_files as $file) {
424	510	$file_path = plugin_dir_path(__FILE__) . $file;
		@@ -433,8 +519,54 @@
433	519	if (class_exists('MxChat_Tool_Registry')) {
434	520	MxChat_Tool_Registry::init();
435	521	}
436	522
	523	+ // GDPR: register with WP's personal-data export/erase tools (b81e42).
	524	+ if (class_exists('MxChat_Privacy')) {
	525	+ MxChat_Privacy::init();
	526	+ }
	527	+
	528	+ // Per-session state store: retention cron + the cron-independent
	529	+ // migration drain off admin_init (b64b77).
	530	+ if (class_exists('MxChat_Session_Store')) {
	531	+ MxChat_Session_Store::init();
	532	+ }
	533	+
	534	+ // Daily model-liveness check + its warning notice (b65e8d). Read-only and
	535	+ // fail-open: one listing request per in-use provider per day, none at all
	536	+ // when no key is stored.
	537	+ if (class_exists('MxChat_Model_Liveness')) {
	538	+ MxChat_Model_Liveness::init();
	539	+ }
	540	+
	541	+ // Gutenberg chatbot block (plan-95dd1e): a click-to-place wrapper over the
	542	+ // [mxchat_chatbot] shortcode. Registers on init; no-op below WP 5.0.
	543	+ if (class_exists('MxChat_Block')) {
	544	+ MxChat_Block::init();
	545	+ }
	546	+
	547	+ // Elementor chatbot widget (plan-95dd1e part 2): registered ONLY inside
	548	+ // elementor/widgets/register (Elementor >= 3.5) — with Elementor absent or
	549	+ // older, the hook never fires and nothing further loads.
	550	+ if (class_exists('MxChat_Elementor')) {
	551	+ MxChat_Elementor::init();
	552	+ }
	553	+
	554	+ // Editor Assistant — free, OFF-by-default block-editor AI actions (plan-8cb0cb).
	555	+ // init() wires REST + streaming AJAX + sidebar enqueue ONLY when the
	556	+ // mxchat_editor_assistant_enabled option is 'on'; otherwise zero footprint.
	557	+ if (class_exists('MxChat_Editor_Assistant')) {
	558	+ MxChat_Editor_Assistant::init();
	559	+ }
	560	+
	561	+ // OpenAI Vector Store write path (plan-15b5c6): import/sync AJAX, the
	562	+ // import cron tick, the pending-delete sweeper, and the WP-CLI command
	563	+ // all register in the constructor. The sync itself only runs when the
	564	+ // sync toggle + store ID + OpenAI key are all present.
	565	+ if (class_exists('MxChat_Vectorstore_Manager')) {
	566	+ MxChat_Vectorstore_Manager::get_instance();
	567	+ }
	568	+
437	569	// Admin pages that aren't classes (procedural include).
438	570	if (is_admin()) {
439	571	$admin_api_page = plugin_dir_path(__FILE__) . 'includes/admin-api-page.php';
440	572	if (file_exists($admin_api_page)) {
		@@ -496,8 +628,26 @@
496	628	dbDelta($sql);
497	629	}
498	630
499	631	/**
	632	+ * Create the per-session state table (b64b77).
	633	+ *
	634	+ * Callable from the activation hook, which can run before plugins_loaded has
	635	+ * included the class files — so it loads the class itself when needed.
	636	+ */
	637	+function mxchat_create_sessions_table() {
	638	+ if (!class_exists('MxChat_Session_Store')) {
	639	+ $path = plugin_dir_path(__FILE__) . 'includes/class-mxchat-session-store.php';
	640	+ if (!file_exists($path)) {
	641	+ return false;
	642	+ }
	643	+ require_once $path;
	644	+ }
	645	+
	646	+ return MxChat_Session_Store::create_table();
	647	+}
	648	+
	649	+/**
500	650	* FIXED: Robust table creation and column management
501	651	*/
502	652	function mxchat_create_chat_transcripts_table() {
503	653	global $wpdb;
		@@ -808,8 +958,66 @@
808	958	}
809	959	}
810	960
811	961	/**
	962	+ * 3.2.20: One-time backfill of the caee10 catalog usage-hint defaults
	963	+ * (plan 64c1ad). persist() writes usage_hint for EVERY shown tool on every
	964	+ * autosave — as '' when the box is untouched — and resolve_tool_setting()
	965	+ * seeds a catalog default_hint ONLY onto an ABSENT key. So any install that
	966	+ * saved the AI Tools screen before 3.2.20 holds '' everywhere and the shipped
	967	+ * defaults can never reach it. On an upgrade from < 3.2.20 an empty stored
	968	+ * hint cannot be a deliberate clear of a rendered default (those builds never
	969	+ * rendered one), so seeding is safe. From 3.2.20 on, empty means the owner
	970	+ * cleared a visible default and is respected — this never runs again (version
	971	+ * gate + its own marker, deliberately not caee10's flag).
	972	+ *
	973	+ * Never touched: entries with owner text, legacy bare-bool entries and
	974	+ * absent-key entries (both already resolve to the default at read time), and
	975	+ * tools whose catalog entry ships no default_hint.
	976	+ */
	977	+function mxchat_backfill_tool_hint_defaults() {
	978	+ if (get_option('mxchat_tool_hint_backfill_64c1ad') === '1') {
	979	+ return;
	980	+ }
	981	+
	982	+ if (class_exists('MxChat_Tool_Registry')) {
	983	+ $map = get_option('mxchat_function_calling_tools', array());
	984	+ if (is_array($map) && !empty($map)) {
	985	+ $defaults = array();
	986	+ foreach (MxChat_Tool_Registry::core_tool_catalog() as $fn => $meta) {
	987	+ if (!empty($meta['default_hint'])) {
	988	+ $defaults[$fn] = (string) $meta['default_hint'];
	989	+ }
	990	+ }
	991	+
	992	+ $changed = false;
	993	+ foreach ($map as $fn => $entry) {
	994	+ if (!isset($defaults[$fn])) {
	995	+ continue; // no catalog default — nothing to seed
	996	+ }
	997	+ if (!is_array($entry)) {
	998	+ continue; // legacy bare bool: key absent, resolves to the default already
	999	+ }
	1000	+ if (!array_key_exists('usage_hint', $entry)) {
	1001	+ continue; // absent key gets the default at read time — must stay absent
	1002	+ }
	1003	+ if (trim((string) $entry['usage_hint']) !== '') {
	1004	+ continue; // owner text — never touch
	1005	+ }
	1006	+ $map[$fn]['usage_hint'] = $defaults[$fn];
	1007	+ $changed = true;
	1008	+ }
	1009	+
	1010	+ if ($changed) {
	1011	+ update_option('mxchat_function_calling_tools', $map);
	1012	+ }
	1013	+ }
	1014	+ }
	1015	+
	1016	+ update_option('mxchat_tool_hint_backfill_64c1ad', '1', false);
	1017	+}
	1018	+
	1019	+/**
812	1020	* 2.5.2: Create queue processing tables for reliable background processing
813	1021	*/
814	1022	function mxchat_create_queue_tables() {
815	1023	global $wpdb;
		@@ -907,8 +1115,41 @@
907	1115	dbDelta($sql);
908	1116	}
909	1117
910	1118	/**
	1119	+ * Create the OpenAI Vector Store file-mapping table (v3.2.20, plan 15b5c6).
	1120	+ * One row per mirrored KB entry: which store, which bot, which OpenAI file id,
	1121	+ * and a hash of the uploaded body for change detection. Vector store files are
	1122	+ * not patchable in place — without this mapping an update cannot find its
	1123	+ * predecessor, and the store silently accumulates stale duplicates.
	1124	+ * status: 'live' (serving) or 'pending_delete' (condemned, swept later).
	1125	+ */
	1126	+function mxchat_create_vectorstore_files_table() {
	1127	+ global $wpdb;
	1128	+ $charset_collate = $wpdb->get_charset_collate();
	1129	+
	1130	+ $table_name = $wpdb->prefix . 'mxchat_vectorstore_files';
	1131	+ $sql = "CREATE TABLE $table_name (
	1132	+ id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
	1133	+ store_id varchar(64) NOT NULL,
	1134	+ bot_id varchar(64) NOT NULL DEFAULT 'default',
	1135	+ entry_key char(32) NOT NULL,
	1136	+ source_url text,
	1137	+ file_id varchar(64) NOT NULL,
	1138	+ content_hash char(32) NOT NULL DEFAULT '',
	1139	+ status varchar(20) NOT NULL DEFAULT 'live',
	1140	+ last_error text,
	1141	+ updated_at datetime DEFAULT NULL,
	1142	+ PRIMARY KEY (id),
	1143	+ KEY store_entry (store_id, bot_id, entry_key, status),
	1144	+ KEY status (status)
	1145	+ ) $charset_collate;";
	1146	+
	1147	+ require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
	1148	+ dbDelta($sql);
	1149	+}
	1150	+
	1151	+/**
911	1152	* 2.5.2: Fix URL column size to support long URLs (especially with UTF-8 encoding)
912	1153	* This fixes "url, source_url. The supplied values may be too long" errors
913	1154	*/
914	1155	function mxchat_fix_url_column_size() {
		@@ -952,53 +1193,45 @@
952	1193	if (!isset($options['model'])) {
953	1194	return;
954	1195	}
955	1196
956		- $current_model = $options['model'];
957		-
958		- // Migrate deprecated Claude models to Claude Opus 4.6 (recommended replacement per Anthropic)
959		- $deprecated_claude_models = array(
960		- 'claude-3-5-sonnet-20240620', // Retired Oct 28, 2025
961		- 'claude-3-5-sonnet-20241022', // Retired Oct 28, 2025
962		- 'claude-3-7-sonnet-20250219', // Retiring Feb 19, 2026
963		- 'claude-3-opus-20240229', // Retired Jan 5, 2026
964		- 'claude-3-sonnet-20240229', // Legacy
965		- 'claude-3-haiku-20240307', // Legacy
966		- );
967		- if (in_array($current_model, $deprecated_claude_models, true)) {
968		- $options['model'] = 'claude-opus-4-6';
969		- $migrated = true;
970		- $migration_message = sprintf(
971		- 'Your chatbot model has been automatically updated from %s to Claude Opus 4.6 due to Anthropic deprecating older Claude models.',
972		- $current_model
973		- );
	1197	+ // The retired-id → replacement mapping lives in ONE place:
	1198	+ // MxChat_Model_Catalog::retired_model_map() (plan 202df5). This function
	1199	+ // and every add-on that stores model ids consume that map — do not add a
	1200	+ // deprecation list here again.
	1201	+ if (!class_exists('MxChat_Model_Catalog') || !method_exists('MxChat_Model_Catalog', 'retired_model_map')) {
	1202	+ return; // catalog not loaded (defensive) — the next admin load retries
974	1203	}
	1204	+ $map = MxChat_Model_Catalog::retired_model_map();
975	1205
976		- // Migrate deprecated Claude Haiku 3.5 to Claude Haiku 4.5
977		- if ($current_model === 'claude-3-5-haiku-20241022') {
978		- $options['model'] = 'claude-haiku-4-5-20251001';
	1206	+ $current_model = $options['model'];
	1207	+ if (isset($map[$current_model])) {
	1208	+ $entry = $map[$current_model];
	1209	+ $options['model'] = $entry['to'];
979	1210	$migrated = true;
980		- $migration_message = 'Your chatbot model has been automatically updated from Claude Haiku 3.5 to Claude Haiku 4.5 due to Anthropic deprecating the older model.';
981		- }
982		-
983		- // Migrate deprecated GPT-4 series and GPT-3.5 Turbo to GPT-5.1 Chat Latest
984		- if (in_array($current_model, array('gpt-4o', 'gpt-4.1-2025-04-14', 'gpt-4-turbo', 'gpt-4', 'gpt-3.5-turbo'), true)) {
985		- $options['model'] = 'gpt-5.1-chat-latest';
986		- $migrated = true;
987	1211	$migration_message = sprintf(
988		- 'Your chatbot model has been automatically updated from %s to GPT-5.1 Chat Latest due to OpenAI deprecating older models.',
989		- $current_model
	1212	+ 'Your chatbot model has been automatically updated from %s to %s %s.',
	1213	+ $current_model,
	1214	+ $entry['label'],
	1215	+ $entry['reason']
990	1216	);
991	1217	}
992	1218
993		- // Migrate deprecated GPT-4o Mini and GPT-4.1 Mini to GPT-5 Mini
994		- if (in_array($current_model, array('gpt-4o-mini', 'gpt-4.1-mini'), true)) {
995		- $options['model'] = 'gpt-5-mini';
	1219	+ // The content generator has its own model option — the same map applies.
	1220	+ // (Pre-202df5 this branch covered only the two gpt-5.x-chat-latest aliases;
	1221	+ // it now covers every retired id, so e.g. a content model stranded on a
	1222	+ // retired Claude id is rescued the same way the chat model is.)
	1223	+ if (isset($options['content_model']) && isset($map[$options['content_model']])) {
	1224	+ $old_content_model = $options['content_model'];
	1225	+ $entry = $map[$old_content_model];
	1226	+ $options['content_model'] = $entry['to'];
996	1227	$migrated = true;
997		- $migration_message = sprintf(
998		- 'Your chatbot model has been automatically updated from %s to GPT-5 Mini due to OpenAI deprecating GPT-4 series models.',
999		- $current_model
1000		- );
	1228	+ $migration_message = trim($migration_message . ' ' . sprintf(
	1229	+ 'Your content generation model has also been automatically updated from %s to %s %s.',
	1230	+ $old_content_model,
	1231	+ $entry['label'],
	1232	+ $entry['reason']
	1233	+ ));
1001	1234	}
1002	1235
1003	1236	if ($migrated) {
1004	1237	update_option('mxchat_options', $options);
		@@ -1025,8 +1258,100 @@
1025	1258	delete_option('mxchat_model_migration_message');
1026	1259	}
1027	1260	}
1028	1261
	1262	+/**
	1263	+ * One-time recommendation on EXISTING installs (stamp 'legacy') that the new
	1264	+ * "Strip unapproved links" guard exists and is worth turning on (plan 58f8b4).
	1265	+ * Fresh 3.2.20+ installs default it on and never see this. Shown only on
	1266	+ * MxChat admin pages, gone for good once dismissed or once the site saves an
	1267	+ * explicit value for the toggle either way.
	1268	+ */
	1269	+function mxchat_show_strip_links_notice() {
	1270	+ if (!current_user_can('manage_options')) {
	1271	+ return;
	1272	+ }
	1273	+ $page = isset($_GET['page']) ? sanitize_key($_GET['page']) : '';
	1274	+ if (strpos($page, 'mxchat') !== 0) {
	1275	+ return;
	1276	+ }
	1277	+ if (get_option('mxchat_strip_links_notice_dismissed', '') === '1') {
	1278	+ return;
	1279	+ }
	1280	+ if (get_option('mxchat_installed_at_version', '') !== 'legacy') {
	1281	+ return;
	1282	+ }
	1283	+ $opts = get_option('mxchat_options', array());
	1284	+ if (is_array($opts) && isset($opts['strip_unapproved_links_toggle'])) {
	1285	+ return; // The site already made its choice — stop recommending.
	1286	+ }
	1287	+ $dismiss_url = wp_nonce_url(
	1288	+ admin_url('admin-post.php?action=mxchat_dismiss_strip_links_notice'),
	1289	+ 'mxchat_dismiss_strip_links_notice'
	1290	+ );
	1291	+ ?>
	1292	+ <div class="notice notice-info">
	1293	+ <p>
	1294	+ <strong><?php esc_html_e('MxChat: new link protection available', 'mxchat'); ?></strong><br>
	1295	+ <?php esc_html_e('The new "Strip Unapproved Links" setting removes links the AI invents from its answers even when Citation Links is off — links to real pages on your site and links your integrations return are always kept. It is off on existing sites so nothing changes without you; we recommend turning it on under MxChat → Settings → Chatbot Behavior.', 'mxchat'); ?>
	1296	+ <a href="<?php echo esc_url($dismiss_url); ?>"><?php esc_html_e('Dismiss', 'mxchat'); ?></a>
	1297	+ </p>
	1298	+ </div>
	1299	+ <?php
	1300	+}
	1301	+add_action('admin_notices', 'mxchat_show_strip_links_notice');
	1302	+
	1303	+/** Dismiss handler for the strip-links recommendation notice (plan 58f8b4). */
	1304	+function mxchat_dismiss_strip_links_notice() {
	1305	+ if (!current_user_can('manage_options')) {
	1306	+ wp_die(esc_html__('Insufficient permissions.', 'mxchat'), '', array('response' => 403));
	1307	+ }
	1308	+ check_admin_referer('mxchat_dismiss_strip_links_notice');
	1309	+ update_option('mxchat_strip_links_notice_dismissed', '1', false);
	1310	+ $referer = wp_get_referer();
	1311	+ wp_safe_redirect($referer ? $referer : admin_url('admin.php?page=mxchat-max'));
	1312	+ exit;
	1313	+}
	1314	+add_action('admin_post_mxchat_dismiss_strip_links_notice', 'mxchat_dismiss_strip_links_notice');
	1315	+
	1316	+/**
	1317	+ * Persistent admin notice when the provider rejected the configured model
	1318	+ * (model_not_found / no access). Set by mxchat_friendly_chat_error() in the
	1319	+ * integrator whenever a chat request fails on a model-access error — including
	1320	+ * requests from anonymous visitors, which is the case that otherwise stays
	1321	+ * invisible to the site owner for weeks (plan e46b8f).
	1322	+ *
	1323	+ * Deleted after render so it re-arms on the next failed chat: the notice keeps
	1324	+ * reappearing until the model is fixed, then stops on its own.
	1325	+ */
	1326	+function mxchat_show_model_access_notice() {
	1327	+ if (!current_user_can('manage_options')) {
	1328	+ return;
	1329	+ }
	1330	+ $notice = get_option('mxchat_model_access_notice');
	1331	+ if (!is_array($notice) || empty($notice['model'])) {
	1332	+ return;
	1333	+ }
	1334	+ $settings_url = admin_url('admin.php?page=mxchat-max');
	1335	+ ?>
	1336	+ <div class="notice notice-error is-dismissible">
	1337	+ <p>
	1338	+ <strong><?php esc_html_e('MxChat: your AI model is being rejected by the provider', 'mxchat'); ?></strong><br>
	1339	+ <?php
	1340	+ printf(
	1341	+ /* translators: 1: model id, 2: provider name */
	1342	+ esc_html__('Chat requests using the model "%1$s" are failing because %2$s reports it as unavailable on your API key (it may have been retired). Visitors may be seeing errors instead of replies.', 'mxchat'),
	1343	+ esc_html($notice['model']),
	1344	+ esc_html(!empty($notice['provider']) ? $notice['provider'] : __('the AI provider', 'mxchat'))
	1345	+ );
	1346	+ ?>
	1347	+ <a href="<?php echo esc_url($settings_url); ?>"><?php esc_html_e('Choose a different model in MxChat Settings', 'mxchat'); ?></a>
	1348	+ </p>
	1349	+ </div>
	1350	+ <?php
	1351	+ delete_option('mxchat_model_access_notice');
	1352	+}
	1353	+
1029	1354	function mxchat_activate() {
1030	1355	global $wpdb;
1031	1356	$charset_collate = $wpdb->get_charset_collate();
1032	1357
		@@ -1034,8 +1359,12 @@
1034	1359
1035	1360	// Create chat transcripts table with improved function
1036	1361	mxchat_create_chat_transcripts_table();
1037	1362
	1363	+ // Per-session state table (b64b77). Activation can run before
	1364	+ // plugins_loaded has included the class files, so require it directly.
	1365	+ mxchat_create_sessions_table();
	1366	+
1038	1367	// System Prompt Content Table - UPDATED: Use TEXT for url and source_url columns
1039	1368	$system_prompt_table = $wpdb->prefix . 'mxchat_system_prompt_content';
1040	1369	$sql_system_prompt = "CREATE TABLE $system_prompt_table (
1041	1370	id MEDIUMINT(9) NOT NULL AUTO_INCREMENT,
		@@ -1042,8 +1371,9 @@
1042	1371	url TEXT NOT NULL,
1043	1372	article_content LONGTEXT NOT NULL,
1044	1373	embedding_vector LONGTEXT,
1045	1374	source_url TEXT DEFAULT NULL,
	1375	+ title VARCHAR(255) DEFAULT NULL,
1046	1376	role_restriction VARCHAR(50) DEFAULT 'public',
1047	1377	content_type VARCHAR(50) DEFAULT 'content',
1048	1378	timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
1049	1379	PRIMARY KEY (id),
		@@ -1097,8 +1427,11 @@
1097	1427
1098	1428	// Create per-session satisfaction ratings table (v3.2.6)
1099	1429	mxchat_create_session_ratings_table();
1100	1430
	1431	+ // Create Vector Store file-mapping table (v3.2.20, plan 15b5c6)
	1432	+ mxchat_create_vectorstore_files_table();
	1433	+
1101	1434	// Ensure additional columns in system prompt table
1102	1435	$existing_system_columns = $wpdb->get_results("SHOW COLUMNS FROM $system_prompt_table");
1103	1436	if (!empty($existing_system_columns)) {
1104	1437	$existing_system_column_names = array_column($existing_system_columns, 'Field');
		@@ -1111,8 +1444,13 @@
1111	1444	}
1112	1445	if (!in_array('role_restriction', $existing_system_column_names)) {
1113	1446	$wpdb->query("ALTER TABLE $system_prompt_table ADD COLUMN role_restriction VARCHAR(50) DEFAULT 'public' AFTER source_url");
1114	1447	}
	1448	+ // Page title captured at import time (3.2.23, plan d9ee66) - read by
	1449	+ // add-ons that name a source, e.g. AI Search's source cards.
	1450	+ if (!in_array('title', $existing_system_column_names)) {
	1451	+ $wpdb->query("ALTER TABLE $system_prompt_table ADD COLUMN title VARCHAR(255) DEFAULT NULL AFTER source_url");
	1452	+ }
1115	1453	}
1116	1454
1117	1455	// Set default thresholds for existing intents
1118	1456	$wpdb->query("UPDATE {$intents_table} SET similarity_threshold = 0.85 WHERE similarity_threshold IS NULL");
		@@ -1147,10 +1485,11 @@
1147	1485
1148	1486	// Setup cron jobs
1149	1487	mxchat_setup_cron_jobs();
1150	1488
1151		- // Update version
1152		- update_option('mxchat_plugin_version', MXCHAT_VERSION);
	1489	+ // Update version (stable base version — never the dev time()-suffixed one,
	1490	+ // or the check_for_update comparison would churn every request)
	1491	+ update_option('mxchat_plugin_version', MXCHAT_BASE_VERSION);
1153	1492
1154	1493	//error_log("MxChat: Activation function completed");
1155	1494	}
1156	1495
		@@ -1165,23 +1504,29 @@
1165	1504	if (defined('DISABLE_WP_CRON') && DISABLE_WP_CRON) {
1166	1505	// Set flag to use fallback system
1167	1506	update_option('mxchat_use_fallback_rate_limits', true);
1168	1507	update_option('mxchat_next_rate_limit_check', time() + 3600);
1169		- return;
1170		- }
1171		-
1172		- // Schedule the rate limit reset cron job
1173		- $result = wp_schedule_event(time() + 300, 'hourly', 'mxchat_reset_rate_limits');
1174		-
1175		- if ($result === false) {
1176		- // Fallback if scheduling fails
1177		- update_option('mxchat_use_fallback_rate_limits', true);
1178		- update_option('mxchat_next_rate_limit_check', time() + 3600);
	1508	+ // Deliberately NO early return (plan-bc08a6): transcript cleanup below
	1509	+ // must still be scheduled. DISABLE_WP_CRON only changes HOW cron events
	1510	+ // execute (a server-side runner hitting wp-cron.php instead of loopback
	1511	+ // spawns) — scheduling still just writes the cron option. The old early
	1512	+ // return here meant a deactivate/reactivate cycle on a DISABLE_WP_CRON
	1513	+ // site permanently lost the transcript cleanup event while the retention
	1514	+ // setting still claimed to be active.
1179	1515	} else {
1180		- // Clear fallback flags if cron scheduling succeeded
1181		- delete_option('mxchat_use_fallback_rate_limits');
	1516	+ // Schedule the rate limit reset cron job
	1517	+ $result = wp_schedule_event(time() + 300, 'hourly', 'mxchat_reset_rate_limits');
	1518	+
	1519	+ if ($result === false) {
	1520	+ // Fallback if scheduling fails
	1521	+ update_option('mxchat_use_fallback_rate_limits', true);
	1522	+ update_option('mxchat_next_rate_limit_check', time() + 3600);
	1523	+ } else {
	1524	+ // Clear fallback flags if cron scheduling succeeded
	1525	+ delete_option('mxchat_use_fallback_rate_limits');
	1526	+ }
1182	1527	}
1183		-
	1528	+
1184	1529	// Schedule transcript cleanup if configured (bucket dropdown OR custom retention-days > 0)
1185	1530	$transcript_options = get_option('mxchat_transcripts_options', array());
1186	1531	$cleanup_interval = isset($transcript_options['mxchat_auto_delete_transcripts']) ? $transcript_options['mxchat_auto_delete_transcripts'] : 'never';
1187	1532	$custom_retention = isset($transcript_options['mxchat_retention_days']) ? (int) $transcript_options['mxchat_retention_days'] : 0;
		@@ -1203,8 +1548,9 @@
1203	1548	// Clear scheduled cron jobs
1204	1549	wp_clear_scheduled_hook('mxchat_reset_rate_limits');
1205	1550	wp_clear_scheduled_hook('mxchat_cleanup_old_transcripts');
1206	1551	wp_clear_scheduled_hook('mxchat_send_delayed_transcript');
	1552	+ wp_clear_scheduled_hook('mxchat_model_liveness_check');
1207	1553
1208	1554	// Clear fallback options
1209	1555	delete_option('mxchat_use_fallback_rate_limits');
1210	1556	delete_option('mxchat_next_rate_limit_check');
		@@ -1224,17 +1570,25 @@
1224	1570	return;
1225	1571	}
1226	1572
1227	1573	$next_check = get_option('mxchat_next_rate_limit_check', 0);
1228		-
	1574	+
1229	1575	if (time() >= $next_check) {
1230		- // Only run reset if the MxChat_Integrator class exists
1231		- if (class_exists('MxChat_Integrator')) {
1232		- $integrator = new MxChat_Integrator();
1233		- if (method_exists($integrator, 'mxchat_reset_rate_limits')) {
1234		- $integrator->mxchat_reset_rate_limits();
1235		- update_option('mxchat_next_rate_limit_check', time() + 3600);
1236		- }
	1576	+ // Reuse the bootstrap's integrator — mxchat_init() creates the global on
	1577	+ // plugins_loaded (before this init-priority-5 callback), so it's always set
	1578	+ // here. Constructing a second MxChat_Integrator just to call one method
	1579	+ // re-registers every hook the plugin has (ajax pairs, wp_footer loader,
	1580	+ // rest_api_init, admin_init guard) on a duplicate instance for the rest of
	1581	+ // the request. Defensive construction only if the global is somehow unset.
	1582	+ // NOTE: MxChat_Integrator::check_fallback_rate_limits() is a second
	1583	+ // implementation of this same check — if either changes, change both.
	1584	+ global $mxchat_integrator;
	1585	+ $integrator = ($mxchat_integrator instanceof MxChat_Integrator)
	1586	+ ? $mxchat_integrator
	1587	+ : (class_exists('MxChat_Integrator') ? new MxChat_Integrator() : null);
	1588	+ if ($integrator && method_exists($integrator, 'mxchat_reset_rate_limits')) {
	1589	+ $integrator->mxchat_reset_rate_limits();
	1590	+ update_option('mxchat_next_rate_limit_check', time() + 3600);
1237	1591	}
1238	1592	}
1239	1593	}
1240	1594
		@@ -1246,9 +1600,9 @@
1246	1600	global $wpdb;
1247	1601
1248	1602	try {
1249	1603	$current_version = get_option('mxchat_plugin_version', '0.0.0');
1250		- $plugin_version = MXCHAT_VERSION;
	1604	+ $plugin_version = MXCHAT_BASE_VERSION;
1251	1605
1252	1606	// Always ensure critical tables exist (even if version matches)
1253	1607	// This handles manual table deletion or fresh installs
1254	1608	$chat_table = $wpdb->prefix . 'mxchat_chat_transcripts';
		@@ -1253,12 +1607,16 @@
1253	1607	// This handles manual table deletion or fresh installs
1254	1608	$chat_table = $wpdb->prefix . 'mxchat_chat_transcripts';
1255	1609	$queue_table = $wpdb->prefix . 'mxchat_processing_queue';
1256	1610
	1611	+ $sessions_table = $wpdb->prefix . 'mxchat_sessions';
	1612	+
1257	1613	$chat_exists = $wpdb->get_var("SHOW TABLES LIKE '$chat_table'") === $chat_table;
1258	1614	$queue_exists = $wpdb->get_var("SHOW TABLES LIKE '$queue_table'") === $queue_table;
1259		-
1260		- if (!$chat_exists || !$queue_exists) {
	1615	+ $sessions_exists = get_option('mxchat_session_store_ready') === '1'
	1616	+ || $wpdb->get_var("SHOW TABLES LIKE '$sessions_table'") === $sessions_table;
	1617	+
	1618	+ if (!$chat_exists || !$queue_exists || !$sessions_exists) {
1261	1619	//error_log("MxChat: Critical tables missing, running activation");
1262	1620	mxchat_activate();
1263	1621	}
1264	1622
		@@ -1327,8 +1685,55 @@
1327	1685	if (version_compare($current_version, '3.2.4', '<')) {
1328	1686	mxchat_backfill_active_embedding_model();
1329	1687	}
1330	1688
	1689	+ // 3.2.15: Migrate retired DeepSeek ids (deepseek-chat / deepseek-reasoner
	1690	+ // were shut off at the vendor on 2026-07-24). The function is idempotent —
	1691	+ // it only rewrites models on its deprecation lists.
	1692	+ if (version_compare($current_version, '3.2.15', '<')) {
	1693	+ mxchat_migrate_deprecated_models();
	1694	+ }
	1695	+
	1696	+ // 3.2.16: Migrate OpenAI ids retiring 2026-08-10 (gpt-5.1-chat-latest /
	1697	+ // gpt-5.3-chat-latest → gpt-5.6-sol per OpenAI's deprecations page).
	1698	+ // Idempotent — only rewrites models on the deprecation lists (e46b8f).
	1699	+ if (version_compare($current_version, '3.2.16', '<')) {
	1700	+ mxchat_migrate_deprecated_models();
	1701	+ }
	1702	+
	1703	+ // 3.2.17: Credential options must not autoload (af2400) — the two
	1704	+ // Pinecone-secret-holding rows were in alloptions, i.e. read into
	1705	+ // memory on every request including anonymous page views. Idempotent.
	1706	+ // Also carry the import modal's remembered ACF→PDF checkbox state
	1707	+ // into the new install-level option (11720c).
	1708	+ if (version_compare($current_version, '3.2.17', '<')) {
	1709	+ mxchat_fix_credential_option_autoload();
	1710	+ mxchat_migrate_acf_pdf_extraction_option();
	1711	+ }
	1712	+
	1713	+ // 3.2.19: Claude Opus 4.1 retired Aug 5, 2026 — auto-move stranded
	1714	+ // sites (and the older tiers on the migration's lists) per the
	1715	+ // changelog's promise. Idempotent — only rewrites models on the
	1716	+ // deprecation lists. Without a gate at this release's version,
	1717	+ // nothing calls the migration for 3.2.18 upgraders (plan a5a598;
	1718	+ // the gate value must equal the version this block ships in).
	1719	+ if (version_compare($current_version, '3.2.19', '<')) {
	1720	+ mxchat_migrate_deprecated_models();
	1721	+ }
	1722	+
	1723	+ // 3.2.20: Seed the caee10 usage-hint defaults onto tool entries a
	1724	+ // pre-3.2.20 autosave stamped with '' (plan 64c1ad). The gate value
	1725	+ // equals the version this block ships in (a5a598 rule); the
	1726	+ // function carries its own one-time marker on top.
	1727	+ // Also re-run the deprecated-models migration: 202df5 widened it to
	1728	+ // rescue a content_model stranded on ANY retired id (previously
	1729	+ // only the two gpt-5.x-chat-latest aliases). Idempotent — only
	1730	+ // rewrites models on the catalog's retired_model_map().
	1731	+ if (version_compare($current_version, '3.2.20', '<')) {
	1732	+ mxchat_backfill_tool_hint_defaults();
	1733	+ mxchat_migrate_deprecated_models();
	1734	+ }
	1735	+
1331	1736	// Run full activation to ensure everything is up to date
1332	1737	mxchat_activate();
1333	1738
1334	1739	// Run migration functions
		@@ -1333,12 +1738,11 @@
1333	1738
1334	1739	// Run migration functions
1335	1740	mxchat_migrate_live_agent_status();
1336	1741
1337		- // Add the cleanup function for version 2.1.8
1338		- if (version_compare($current_version, '2.1.8', '<')) {
1339		- $deleted = mxchat_cleanup_orphaned_chat_history();
1340		- }
	1742	+ // (The 2.1.8 orphaned-history reconciliation sweep is gone —
	1743	+ // 3.2.19's mxchat_history_backlog_* drain supersedes it, and it
	1744	+ // self-arms without a version gate: plan 839c4c.)
1341	1745
1342	1746	// Update version LAST
1343	1747	update_option('mxchat_plugin_version', $plugin_version);
1344	1748
		@@ -1351,8 +1755,170 @@
1351	1755	}
1352	1756	}
1353	1757
1354	1758	/**
	1759	+ * Credential options must never enter the autoloaded alloptions set.
	1760	+ * mxchat_prompts_options and mxchat_pinecone_addon_options can hold the
	1761	+ * Pinecone API secret; mxchat_options already stores its keys with autoload
	1762	+ * off and these two must match it. The filter covers every future
	1763	+ * add_option()/update_option() that creates the row — Settings API saves
	1764	+ * through options.php and WP-CLI included — on WP 6.6+; older cores are
	1765	+ * covered by the explicit autoload arguments at the plugin's own write
	1766	+ * sites plus the one-time migration below.
	1767	+ */
	1768	+add_filter('wp_default_autoload_value', 'mxchat_credential_option_autoload_value', 10, 2);
	1769	+function mxchat_credential_option_autoload_value($autoload, $option) {
	1770	+ if (in_array($option, array('mxchat_prompts_options', 'mxchat_pinecone_addon_options'), true)) {
	1771	+ return false;
	1772	+ }
	1773	+ return $autoload;
	1774	+}
	1775	+
	1776	+/**
	1777	+ * One-time upgrade migration: flip the autoload flag on credential option
	1778	+ * rows that existing installs are already carrying autoloaded. Includes
	1779	+ * mxchat_adv_api_token (Advanced Content bearer token) — harmless no-op
	1780	+ * when that add-on is not installed, since missing rows simply don't match.
	1781	+ */
	1782	+function mxchat_fix_credential_option_autoload() {
	1783	+ $keys = array('mxchat_prompts_options', 'mxchat_pinecone_addon_options', 'mxchat_adv_api_token');
	1784	+ if (function_exists('wp_set_option_autoload_values')) {
	1785	+ wp_set_option_autoload_values(array_fill_keys($keys, false));
	1786	+ return;
	1787	+ }
	1788	+ // Pre-WP-6.4 fallback: direct flip + cache invalidation.
	1789	+ global $wpdb;
	1790	+ $placeholders = implode(',', array_fill(0, count($keys), '%s'));
	1791	+ $wpdb->query($wpdb->prepare("UPDATE {$wpdb->options} SET autoload = 'no' WHERE option_name IN ($placeholders)", $keys));
	1792	+ wp_cache_delete('alloptions', 'options');
	1793	+ foreach ($keys as $key) {
	1794	+ wp_cache_delete($key, 'options');
	1795	+ }
	1796	+}
	1797	+
	1798	+/**
	1799	+ * One-time carry of the import modal's remembered ACF→PDF checkbox state
	1800	+ * (mxchat_options['acf_pdf_extract_default'], written per-import until 3.2.16)
	1801	+ * into the new install-level option mxchat_acf_pdf_extraction (plan 11720c).
	1802	+ * Fresh installs and installs that never touched the checkbox default OFF,
	1803	+ * matching the setting's own "recommended only if…" guidance.
	1804	+ */
	1805	+function mxchat_migrate_acf_pdf_extraction_option() {
	1806	+ if (get_option('mxchat_acf_pdf_extraction', null) !== null) {
	1807	+ return; // already set — never overwrite an owner's choice
	1808	+ }
	1809	+ $mxchat_options = get_option('mxchat_options', array());
	1810	+ if (is_array($mxchat_options) && array_key_exists('acf_pdf_extract_default', $mxchat_options)) {
	1811	+ update_option('mxchat_acf_pdf_extraction', !empty($mxchat_options['acf_pdf_extract_default']) ? '1' : '0', false);
	1812	+ unset($mxchat_options['acf_pdf_extract_default']);
	1813	+ update_option('mxchat_options', $mxchat_options);
	1814	+ }
	1815	+}
	1816	+
	1817	+/**
	1818	+ * One-time migration of mxchat_acf_excluded_fields from field NAMES to field
	1819	+ * KEYS (plan 30e81f). Names are not unique across ACF groups, so two fields
	1820	+ * named the same in different groups shared one toggle, one saved state, and
	1821	+ * one exclusion — and the save-on-exit beacon could revert a save through the
	1822	+ * twin. Keys are unique; everything now runs on them.
	1823	+ *
	1824	+ * MIGRATION DIRECTION IS DELIBERATE: one stored name can match several keys —
	1825	+ * exclude EVERY one of them. The UI describes these as "sensitive or
	1826	+ * irrelevant fields"; an under-migration would silently start feeding a
	1827	+ * previously-excluded sensitive field into embeddings sent to a third-party
	1828	+ * provider. Over-excluding is visible in the UI and costs some retrieval
	1829	+ * quality; under-excluding is a silent privacy regression.
	1830	+ *
	1831	+ * Self-arming on acf/init (NOT the version-gated upgrade block): resolving
	1832	+ * names needs ACF fully booted with local JSON/PHP groups registered, and if
	1833	+ * ACF is deactivated at upgrade time the migration simply waits for the next
	1834	+ * load with ACF active. Until it runs, stored names keep working — every
	1835	+ * exclusion read site honors legacy name entries alongside keys. A name that
	1836	+ * matches no current key is KEPT (its group may be temporarily inactive), and
	1837	+ * the per-field include path lazily converts it if it ever resolves again.
	1838	+ */
	1839	+function mxchat_migrate_acf_exclusions_to_keys() {
	1840	+ if (get_option('mxchat_acf_exclusions_migrated', '') === '1') {
	1841	+ return;
	1842	+ }
	1843	+ $stored = get_option('mxchat_acf_excluded_fields', array());
	1844	+ if (!is_array($stored) || empty($stored)) {
	1845	+ update_option('mxchat_acf_exclusions_migrated', '1', false);
	1846	+ return;
	1847	+ }
	1848	+ if (!function_exists('acf_get_field_groups') || !function_exists('acf_get_fields')) {
	1849	+ return; // acf/init fired without the API? Bail; retry next load.
	1850	+ }
	1851	+
	1852	+ // Map every current top-level field: name => [keys], and the set of keys.
	1853	+ $name_to_keys = array();
	1854	+ $current_keys = array();
	1855	+ foreach (acf_get_field_groups() as $group) {
	1856	+ $group_fields = acf_get_fields($group['key']);
	1857	+ if (empty($group_fields)) {
	1858	+ continue;
	1859	+ }
	1860	+ foreach ($group_fields as $field) {
	1861	+ if (empty($field['key']) || !isset($field['name'])) {
	1862	+ continue;
	1863	+ }
	1864	+ $current_keys[$field['key']] = true;
	1865	+ $name_to_keys[$field['name']][] = $field['key'];
	1866	+ }
	1867	+ }
	1868	+
	1869	+ $migrated = array();
	1870	+ $converted = 0;
	1871	+ foreach ($stored as $entry) {
	1872	+ if (!is_string($entry) || $entry === '') {
	1873	+ continue;
	1874	+ }
	1875	+ if (isset($current_keys[$entry])) {
	1876	+ $migrated[] = $entry; // already a live key
	1877	+ } elseif (isset($name_to_keys[$entry])) {
	1878	+ foreach ($name_to_keys[$entry] as $key) {
	1879	+ $migrated[] = $key; // every key wearing this name — fail toward more exclusion
	1880	+ }
	1881	+ $converted++;
	1882	+ } else {
	1883	+ $migrated[] = $entry; // unresolved — keep; still honored by name everywhere
	1884	+ }
	1885	+ }
	1886	+ $migrated = array_values(array_unique($migrated));
	1887	+
	1888	+ update_option('mxchat_acf_excluded_fields', $migrated);
	1889	+ update_option('mxchat_acf_exclusions_migrated', '1', false);
	1890	+ if ($converted > 0) {
	1891	+ update_option('mxchat_acf_exclusions_migrated_notice', '1', false);
	1892	+ }
	1893	+}
	1894	+add_action('acf/init', 'mxchat_migrate_acf_exclusions_to_keys', 20);
	1895	+
	1896	+/**
	1897	+ * One-time notice after the ACF exclusion migration actually converted
	1898	+ * name entries — the settings are worth a review, especially where one name
	1899	+ * fanned out to several fields (every match is now excluded, on purpose).
	1900	+ */
	1901	+function mxchat_show_acf_exclusions_migrated_notice() {
	1902	+ if (!current_user_can('manage_options')) {
	1903	+ return;
	1904	+ }
	1905	+ if (get_option('mxchat_acf_exclusions_migrated_notice', '') !== '1') {
	1906	+ return;
	1907	+ }
	1908	+ ?>
	1909	+ <div class="notice notice-info is-dismissible">
	1910	+ <p>
	1911	+ <strong><?php esc_html_e('MxChat: ACF field exclusions updated', 'mxchat'); ?></strong><br>
	1912	+ <?php esc_html_e('Your ACF field exclusion settings were migrated to identify fields precisely, so same-named fields in different groups no longer share one toggle. Where a saved exclusion matched several fields, all of them are now excluded — please review the toggles under MxChat → Knowledge → ACF Field Settings.', 'mxchat'); ?>
	1913	+ </p>
	1914	+ </div>
	1915	+ <?php
	1916	+ delete_option('mxchat_acf_exclusions_migrated_notice');
	1917	+}
	1918	+add_action('admin_notices', 'mxchat_show_acf_exclusions_migrated_notice');
	1919	+
	1920	+/**
1355	1921	* Ensure tables exist on every admin load for fresh installations
1356	1922	* This is a safety net for cases where activation hook doesn't fire
1357	1923	*/
1358	1924	function mxchat_ensure_tables_exist() {
		@@ -1372,12 +1938,16 @@
1372	1938
1373	1939	$table_name = $wpdb->prefix . 'mxchat_chat_transcripts';
1374	1940	$queue_table = $wpdb->prefix . 'mxchat_processing_queue';
1375	1941
	1942	+ $sessions_table = $wpdb->prefix . 'mxchat_sessions';
	1943	+
1376	1944	$chat_exists = $wpdb->get_var("SHOW TABLES LIKE '$table_name'") === $table_name;
1377	1945	$queue_exists = $wpdb->get_var("SHOW TABLES LIKE '$queue_table'") === $queue_table;
1378		-
1379		- if (!$chat_exists || !$queue_exists) {
	1946	+ $sessions_exists = get_option('mxchat_session_store_ready') !== false
	1947	+ || $wpdb->get_var("SHOW TABLES LIKE '$sessions_table'") === $sessions_table;
	1948	+
	1949	+ if (!$chat_exists || !$queue_exists || !$sessions_exists) {
1380	1950	//error_log("MxChat: Tables missing on admin load, running activation");
1381	1951	mxchat_activate();
1382	1952	}
1383	1953	}
		@@ -1382,49 +1952,116 @@
1382	1952	}
1383	1953	}
1384	1954
1385	1955	/**
1386		- * Clean up orphaned chat history options from the wp_options table
1387		- * @return int Number of options deleted
	1956	+ * One-shot cleanup of legacy mxchat_history_<sid> option rows (plan 839c4c).
	1957	+ *
	1958	+ * 3.2.19 deduplicated per-session chat history into the transcripts table
	1959	+ * (which already held a superset of every option copy measured), so nothing
	1960	+ * writes these options any more — but an upgraded install still carries one
	1961	+ * per session, at up to 64 KB a row (462 rows measured on one production
	1962	+ * install). This drain replaces the old mxchat_cleanup_orphaned_chat_history()
	1963	+ * reconciliation sweep, which existed only because there were two copies to
	1964	+ * reconcile.
	1965	+ *
	1966	+ * b64b77 pattern throughout: an option_id bookmark that only moves forward
	1967	+ * (a crash mid-batch re-processes at most one batch), delete_option() per row
	1968	+ * so the object + notoptions caches stay coherent, batches drained off
	1969	+ * non-AJAX admin_init plus the session-store maintenance cron. Once the
	1970	+ * backlog is gone the state marks done and every later call is one cached
	1971	+ * option read.
1388	1972	*/
1389		-function mxchat_cleanup_orphaned_chat_history() {
	1973	+function mxchat_history_backlog_state() {
	1974	+ // The state option name MUST NOT start with 'mxchat_history_' — the drain
	1975	+ // deletes everything matching that prefix, and a state option inside the
	1976	+ // pattern gets eaten by its own drain (caught by the 839c4c rig: batches
	1977	+ // ran 2,2,2,1 instead of 2,2,1 because the bookmark row was being deleted
	1978	+ // and re-created every pass).
	1979	+ $state = get_option('mxchat_legacy_history_cleanup', array());
	1980	+ if (!is_array($state)) {
	1981	+ $state = array();
	1982	+ }
	1983	+
	1984	+ return wp_parse_args($state, array(
	1985	+ 'done' => false,
	1986	+ 'last_option_id' => 0,
	1987	+ 'deleted' => 0,
	1988	+ ));
	1989	+}
	1990	+
	1991	+/**
	1992	+ * Delete one batch of legacy history options.
	1993	+ *
	1994	+ * @param int $batch Rows per pass — capped small; these can be 64 KB rows.
	1995	+ * @return int Option rows deleted in this pass.
	1996	+ */
	1997	+function mxchat_history_backlog_batch($batch = 200) {
1390	1998	global $wpdb;
1391		- $count = 0;
1392	1999
1393		- // Get all option keys that match our pattern
1394		- $history_options = $wpdb->get_results(
1395		- "SELECT option_name FROM {$wpdb->options}
1396		- WHERE option_name LIKE 'mxchat_history_%'"
	2000	+ $state = mxchat_history_backlog_state();
	2001	+ if (!empty($state['done'])) {
	2002	+ return 0;
	2003	+ }
	2004	+
	2005	+ $batch = max(1, (int) $batch);
	2006	+
	2007	+ $rows = $wpdb->get_results(
	2008	+ $wpdb->prepare(
	2009	+ "SELECT option_id, option_name FROM {$wpdb->options}
	2010	+ WHERE option_id > %d AND option_name LIKE %s
	2011	+ ORDER BY option_id ASC LIMIT %d",
	2012	+ (int) $state['last_option_id'],
	2013	+ $wpdb->esc_like('mxchat_history_') . '%',
	2014	+ $batch
	2015	+ ),
	2016	+ ARRAY_A
1397	2017	);
1398	2018
1399		- if (!empty($history_options)) {
1400		- foreach ($history_options as $option) {
1401		- // Extract the session ID from the option name
1402		- $session_id = str_replace('mxchat_history_', '', $option->option_name);
	2019	+ if (empty($rows)) {
	2020	+ $state['done'] = true;
	2021	+ update_option('mxchat_legacy_history_cleanup', $state, 'no');
	2022	+ return 0;
	2023	+ }
1403	2024
1404		- // Check if this session still exists in the custom table
1405		- $table_name = $wpdb->prefix . 'mxchat_chat_transcripts';
1406		- $exists = $wpdb->get_var(
1407		- $wpdb->prepare(
1408		- "SELECT COUNT(*) FROM {$table_name} WHERE session_id = %s",
1409		- $session_id
1410		- )
1411		- );
	2025	+ foreach ($rows as $row) {
	2026	+ $state['last_option_id'] = max((int) $state['last_option_id'], (int) $row['option_id']);
	2027	+ delete_option($row['option_name']);
	2028	+ $state['deleted'] = (int) $state['deleted'] + 1;
	2029	+ }
1412	2030
1413		- // If session doesn't exist in the main table, delete the option
1414		- if ($exists == 0) {
1415		- delete_option($option->option_name);
1416		- // Also delete related metadata
1417		- delete_option("mxchat_email_{$session_id}");
1418		- delete_option("mxchat_name_{$session_id}");
1419		- delete_option("mxchat_agent_name_{$session_id}");
1420		- $count++;
1421		- }
	2031	+ if (count($rows) < $batch) {
	2032	+ $state['done'] = true;
	2033	+ }
	2034	+
	2035	+ update_option('mxchat_legacy_history_cleanup', $state, 'no');
	2036	+
	2037	+ return count($rows);
	2038	+}
	2039	+
	2040	+/** One batch per admin page load until drained. */
	2041	+function mxchat_history_backlog_drain() {
	2042	+ mxchat_history_backlog_batch();
	2043	+}
	2044	+
	2045	+/** Cron leg: drain faster, same cap per batch. */
	2046	+function mxchat_history_backlog_drain_cron() {
	2047	+ for ($i = 0; $i < 10; $i++) {
	2048	+ if (mxchat_history_backlog_batch() === 0) {
	2049	+ break;
1422	2050	}
1423	2051	}
	2052	+}
1424	2053
1425		- return $count;
	2054	+// wp_doing_ajax() guard is load-bearing, not defensive (b64b77's shipped-and-
	2055	+// caught defect): admin-ajax.php fires admin_init too, and the chat widget's
	2056	+// message endpoint is an admin-ajax action — without the guard an anonymous
	2057	+// visitor would pay for a delete batch inside their own chat request.
	2058	+if (!wp_doing_ajax()) {
	2059	+ add_action('admin_init', 'mxchat_history_backlog_drain', 21);
1426	2060	}
	2061	+// Belt for installs whose admin is rarely visited: ride the session store's
	2062	+// existing daily maintenance event rather than scheduling another.
	2063	+add_action('mxchat_session_store_maintenance', 'mxchat_history_backlog_drain_cron');
1427	2064
1428	2065	function mxchat_migrate_live_agent_status() {
1429	2066	$options = get_option('mxchat_options', []);
1430	2067
		@@ -1527,8 +2164,9 @@
1527	2164	add_action('init', 'mxchat_check_fallback_rate_limits', 5);
1528	2165
1529	2166	// Add migration notice hook
1530	2167	add_action('admin_notices', 'mxchat_show_migration_notice');
	2168	+ add_action('admin_notices', 'mxchat_show_model_access_notice');
1531	2169
1532	2170	// Initialize classes with error handling
1533	2171	try {
1534	2172	// Initialize admin classes
		@@ -1686,9 +2324,9 @@
1686	2324	*/
1687	2325	function mxchat_save_session_rating() {
1688	2326	global $wpdb;
1689	2327
1690		- $session_id = isset($_POST['session_id']) ? sanitize_text_field(wp_unslash($_POST['session_id'])) : '';
	2328	+ $session_id = isset($_POST['session_id']) ? MxChat_Utils::sanitize_session_id(wp_unslash($_POST['session_id'])) : '';
1691	2329	$bot_id = isset($_POST['bot_id']) ? sanitize_text_field(wp_unslash($_POST['bot_id'])) : 'default';
1692	2330	$rating_raw = isset($_POST['rating']) ? (int) $_POST['rating'] : 0;
1693	2331	$feedback = isset($_POST['feedback']) ? sanitize_textarea_field(wp_unslash($_POST['feedback'])) : '';
1694	2332