← All changes | mxchat-basic.php +712 -89 3.2.14 → 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.14
	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,15 +479,20 @@
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',
406	485	'includes/class-mxchat-live-agent-schedule.php',
407	486	'includes/class-mxchat-tool-registry.php',
408	487	'includes/class-mxchat-integrator.php',
409	488	'includes/class-mxchat-admin.php',
410	489	'includes/class-mxchat-public.php',
	490	+ 'includes/class-mxchat-block.php',
	491	+ 'includes/class-mxchat-elementor.php',
411	492	'includes/class-mxchat-utils.php',
412	493	'includes/class-mxchat-user.php',
	494	+ 'includes/class-mxchat-privacy.php',
413	495	'includes/class-mxchat-meta-box.php',
414	496	'includes/class-mxchat-chunker.php',
415	497	'includes/class-mxchat-word-handler.php',
416	498	'includes/class-mxchat-content-generator.php',
		@@ -418,9 +500,11 @@
418	500	'includes/class-mxchat-editor-assistant.php',
419	501	'includes/class-rest-api.php',
420	502	'admin/class-ajax-handler.php',
421	503	'admin/class-pinecone-manager.php',
422		- 'admin/class-knowledge-manager.php'
	504	+ 'admin/class-pinecone-documents.php',
	505	+ 'admin/class-knowledge-manager.php',
	506	+ 'admin/class-vectorstore-manager.php'
423	507	);
424	508
425	509	foreach ($class_files as $file) {
426	510	$file_path = plugin_dir_path(__FILE__) . $file;
		@@ -435,8 +519,39 @@
435	519	if (class_exists('MxChat_Tool_Registry')) {
436	520	MxChat_Tool_Registry::init();
437	521	}
438	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	+
439	554	// Editor Assistant — free, OFF-by-default block-editor AI actions (plan-8cb0cb).
440	555	// init() wires REST + streaming AJAX + sidebar enqueue ONLY when the
441	556	// mxchat_editor_assistant_enabled option is 'on'; otherwise zero footprint.
442	557	if (class_exists('MxChat_Editor_Assistant')) {
		@@ -442,8 +557,16 @@
442	557	if (class_exists('MxChat_Editor_Assistant')) {
443	558	MxChat_Editor_Assistant::init();
444	559	}
445	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	+
446	569	// Admin pages that aren't classes (procedural include).
447	570	if (is_admin()) {
448	571	$admin_api_page = plugin_dir_path(__FILE__) . 'includes/admin-api-page.php';
449	572	if (file_exists($admin_api_page)) {
		@@ -505,8 +628,26 @@
505	628	dbDelta($sql);
506	629	}
507	630
508	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	+/**
509	650	* FIXED: Robust table creation and column management
510	651	*/
511	652	function mxchat_create_chat_transcripts_table() {
512	653	global $wpdb;
		@@ -817,8 +958,66 @@
817	958	}
818	959	}
819	960
820	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	+/**
821	1020	* 2.5.2: Create queue processing tables for reliable background processing
822	1021	*/
823	1022	function mxchat_create_queue_tables() {
824	1023	global $wpdb;
		@@ -916,8 +1115,41 @@
916	1115	dbDelta($sql);
917	1116	}
918	1117
919	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	+/**
920	1152	* 2.5.2: Fix URL column size to support long URLs (especially with UTF-8 encoding)
921	1153	* This fixes "url, source_url. The supplied values may be too long" errors
922	1154	*/
923	1155	function mxchat_fix_url_column_size() {
		@@ -961,53 +1193,45 @@
961	1193	if (!isset($options['model'])) {
962	1194	return;
963	1195	}
964	1196
965		- $current_model = $options['model'];
966		-
967		- // Migrate deprecated Claude models to Claude Opus 4.6 (recommended replacement per Anthropic)
968		- $deprecated_claude_models = array(
969		- 'claude-3-5-sonnet-20240620', // Retired Oct 28, 2025
970		- 'claude-3-5-sonnet-20241022', // Retired Oct 28, 2025
971		- 'claude-3-7-sonnet-20250219', // Retiring Feb 19, 2026
972		- 'claude-3-opus-20240229', // Retired Jan 5, 2026
973		- 'claude-3-sonnet-20240229', // Legacy
974		- 'claude-3-haiku-20240307', // Legacy
975		- );
976		- if (in_array($current_model, $deprecated_claude_models, true)) {
977		- $options['model'] = 'claude-opus-4-6';
978		- $migrated = true;
979		- $migration_message = sprintf(
980		- 'Your chatbot model has been automatically updated from %s to Claude Opus 4.6 due to Anthropic deprecating older Claude models.',
981		- $current_model
982		- );
	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
983	1203	}
	1204	+ $map = MxChat_Model_Catalog::retired_model_map();
984	1205
985		- // Migrate deprecated Claude Haiku 3.5 to Claude Haiku 4.5
986		- if ($current_model === 'claude-3-5-haiku-20241022') {
987		- $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'];
988	1210	$migrated = true;
989		- $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.';
990		- }
991		-
992		- // Migrate deprecated GPT-4 series and GPT-3.5 Turbo to GPT-5.1 Chat Latest
993		- if (in_array($current_model, array('gpt-4o', 'gpt-4.1-2025-04-14', 'gpt-4-turbo', 'gpt-4', 'gpt-3.5-turbo'), true)) {
994		- $options['model'] = 'gpt-5.1-chat-latest';
995		- $migrated = true;
996	1211	$migration_message = sprintf(
997		- 'Your chatbot model has been automatically updated from %s to GPT-5.1 Chat Latest due to OpenAI deprecating older models.',
998		- $current_model
	1212	+ 'Your chatbot model has been automatically updated from %s to %s %s.',
	1213	+ $current_model,
	1214	+ $entry['label'],
	1215	+ $entry['reason']
999	1216	);
1000	1217	}
1001	1218
1002		- // Migrate deprecated GPT-4o Mini and GPT-4.1 Mini to GPT-5 Mini
1003		- if (in_array($current_model, array('gpt-4o-mini', 'gpt-4.1-mini'), true)) {
1004		- $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'];
1005	1227	$migrated = true;
1006		- $migration_message = sprintf(
1007		- 'Your chatbot model has been automatically updated from %s to GPT-5 Mini due to OpenAI deprecating GPT-4 series models.',
1008		- $current_model
1009		- );
	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	+ ));
1010	1234	}
1011	1235
1012	1236	if ($migrated) {
1013	1237	update_option('mxchat_options', $options);
		@@ -1034,8 +1258,100 @@
1034	1258	delete_option('mxchat_model_migration_message');
1035	1259	}
1036	1260	}
1037	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	+
1038	1354	function mxchat_activate() {
1039	1355	global $wpdb;
1040	1356	$charset_collate = $wpdb->get_charset_collate();
1041	1357
		@@ -1043,8 +1359,12 @@
1043	1359
1044	1360	// Create chat transcripts table with improved function
1045	1361	mxchat_create_chat_transcripts_table();
1046	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	+
1047	1367	// System Prompt Content Table - UPDATED: Use TEXT for url and source_url columns
1048	1368	$system_prompt_table = $wpdb->prefix . 'mxchat_system_prompt_content';
1049	1369	$sql_system_prompt = "CREATE TABLE $system_prompt_table (
1050	1370	id MEDIUMINT(9) NOT NULL AUTO_INCREMENT,
		@@ -1051,8 +1371,9 @@
1051	1371	url TEXT NOT NULL,
1052	1372	article_content LONGTEXT NOT NULL,
1053	1373	embedding_vector LONGTEXT,
1054	1374	source_url TEXT DEFAULT NULL,
	1375	+ title VARCHAR(255) DEFAULT NULL,
1055	1376	role_restriction VARCHAR(50) DEFAULT 'public',
1056	1377	content_type VARCHAR(50) DEFAULT 'content',
1057	1378	timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
1058	1379	PRIMARY KEY (id),
		@@ -1106,8 +1427,11 @@
1106	1427
1107	1428	// Create per-session satisfaction ratings table (v3.2.6)
1108	1429	mxchat_create_session_ratings_table();
1109	1430
	1431	+ // Create Vector Store file-mapping table (v3.2.20, plan 15b5c6)
	1432	+ mxchat_create_vectorstore_files_table();
	1433	+
1110	1434	// Ensure additional columns in system prompt table
1111	1435	$existing_system_columns = $wpdb->get_results("SHOW COLUMNS FROM $system_prompt_table");
1112	1436	if (!empty($existing_system_columns)) {
1113	1437	$existing_system_column_names = array_column($existing_system_columns, 'Field');
		@@ -1120,8 +1444,13 @@
1120	1444	}
1121	1445	if (!in_array('role_restriction', $existing_system_column_names)) {
1122	1446	$wpdb->query("ALTER TABLE $system_prompt_table ADD COLUMN role_restriction VARCHAR(50) DEFAULT 'public' AFTER source_url");
1123	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	+ }
1124	1453	}
1125	1454
1126	1455	// Set default thresholds for existing intents
1127	1456	$wpdb->query("UPDATE {$intents_table} SET similarity_threshold = 0.85 WHERE similarity_threshold IS NULL");
		@@ -1156,10 +1485,11 @@
1156	1485
1157	1486	// Setup cron jobs
1158	1487	mxchat_setup_cron_jobs();
1159	1488
1160		- // Update version
1161		- 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);
1162	1492
1163	1493	//error_log("MxChat: Activation function completed");
1164	1494	}
1165	1495
		@@ -1218,8 +1548,9 @@
1218	1548	// Clear scheduled cron jobs
1219	1549	wp_clear_scheduled_hook('mxchat_reset_rate_limits');
1220	1550	wp_clear_scheduled_hook('mxchat_cleanup_old_transcripts');
1221	1551	wp_clear_scheduled_hook('mxchat_send_delayed_transcript');
	1552	+ wp_clear_scheduled_hook('mxchat_model_liveness_check');
1222	1553
1223	1554	// Clear fallback options
1224	1555	delete_option('mxchat_use_fallback_rate_limits');
1225	1556	delete_option('mxchat_next_rate_limit_check');
		@@ -1239,17 +1570,25 @@
1239	1570	return;
1240	1571	}
1241	1572
1242	1573	$next_check = get_option('mxchat_next_rate_limit_check', 0);
1243		-
	1574	+
1244	1575	if (time() >= $next_check) {
1245		- // Only run reset if the MxChat_Integrator class exists
1246		- if (class_exists('MxChat_Integrator')) {
1247		- $integrator = new MxChat_Integrator();
1248		- if (method_exists($integrator, 'mxchat_reset_rate_limits')) {
1249		- $integrator->mxchat_reset_rate_limits();
1250		- update_option('mxchat_next_rate_limit_check', time() + 3600);
1251		- }
	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);
1252	1591	}
1253	1592	}
1254	1593	}
1255	1594
		@@ -1261,9 +1600,9 @@
1261	1600	global $wpdb;
1262	1601
1263	1602	try {
1264	1603	$current_version = get_option('mxchat_plugin_version', '0.0.0');
1265		- $plugin_version = MXCHAT_VERSION;
	1604	+ $plugin_version = MXCHAT_BASE_VERSION;
1266	1605
1267	1606	// Always ensure critical tables exist (even if version matches)
1268	1607	// This handles manual table deletion or fresh installs
1269	1608	$chat_table = $wpdb->prefix . 'mxchat_chat_transcripts';
		@@ -1268,12 +1607,16 @@
1268	1607	// This handles manual table deletion or fresh installs
1269	1608	$chat_table = $wpdb->prefix . 'mxchat_chat_transcripts';
1270	1609	$queue_table = $wpdb->prefix . 'mxchat_processing_queue';
1271	1610
	1611	+ $sessions_table = $wpdb->prefix . 'mxchat_sessions';
	1612	+
1272	1613	$chat_exists = $wpdb->get_var("SHOW TABLES LIKE '$chat_table'") === $chat_table;
1273	1614	$queue_exists = $wpdb->get_var("SHOW TABLES LIKE '$queue_table'") === $queue_table;
1274		-
1275		- 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) {
1276	1619	//error_log("MxChat: Critical tables missing, running activation");
1277	1620	mxchat_activate();
1278	1621	}
1279	1622
		@@ -1342,8 +1685,55 @@
1342	1685	if (version_compare($current_version, '3.2.4', '<')) {
1343	1686	mxchat_backfill_active_embedding_model();
1344	1687	}
1345	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	+
1346	1736	// Run full activation to ensure everything is up to date
1347	1737	mxchat_activate();
1348	1738
1349	1739	// Run migration functions
		@@ -1348,12 +1738,11 @@
1348	1738
1349	1739	// Run migration functions
1350	1740	mxchat_migrate_live_agent_status();
1351	1741
1352		- // Add the cleanup function for version 2.1.8
1353		- if (version_compare($current_version, '2.1.8', '<')) {
1354		- $deleted = mxchat_cleanup_orphaned_chat_history();
1355		- }
	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.)
1356	1745
1357	1746	// Update version LAST
1358	1747	update_option('mxchat_plugin_version', $plugin_version);
1359	1748
		@@ -1366,8 +1755,170 @@
1366	1755	}
1367	1756	}
1368	1757
1369	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	+/**
1370	1921	* Ensure tables exist on every admin load for fresh installations
1371	1922	* This is a safety net for cases where activation hook doesn't fire
1372	1923	*/
1373	1924	function mxchat_ensure_tables_exist() {
		@@ -1387,12 +1938,16 @@
1387	1938
1388	1939	$table_name = $wpdb->prefix . 'mxchat_chat_transcripts';
1389	1940	$queue_table = $wpdb->prefix . 'mxchat_processing_queue';
1390	1941
	1942	+ $sessions_table = $wpdb->prefix . 'mxchat_sessions';
	1943	+
1391	1944	$chat_exists = $wpdb->get_var("SHOW TABLES LIKE '$table_name'") === $table_name;
1392	1945	$queue_exists = $wpdb->get_var("SHOW TABLES LIKE '$queue_table'") === $queue_table;
1393		-
1394		- 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) {
1395	1950	//error_log("MxChat: Tables missing on admin load, running activation");
1396	1951	mxchat_activate();
1397	1952	}
1398	1953	}
		@@ -1397,49 +1952,116 @@
1397	1952	}
1398	1953	}
1399	1954
1400	1955	/**
1401		- * Clean up orphaned chat history options from the wp_options table
1402		- * @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.
1403	1972	*/
1404		-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) {
1405	1998	global $wpdb;
1406		- $count = 0;
1407	1999
1408		- // Get all option keys that match our pattern
1409		- $history_options = $wpdb->get_results(
1410		- "SELECT option_name FROM {$wpdb->options}
1411		- 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
1412	2017	);
1413	2018
1414		- if (!empty($history_options)) {
1415		- foreach ($history_options as $option) {
1416		- // Extract the session ID from the option name
1417		- $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	+ }
1418	2024
1419		- // Check if this session still exists in the custom table
1420		- $table_name = $wpdb->prefix . 'mxchat_chat_transcripts';
1421		- $exists = $wpdb->get_var(
1422		- $wpdb->prepare(
1423		- "SELECT COUNT(*) FROM {$table_name} WHERE session_id = %s",
1424		- $session_id
1425		- )
1426		- );
	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	+ }
1427	2030
1428		- // If session doesn't exist in the main table, delete the option
1429		- if ($exists == 0) {
1430		- delete_option($option->option_name);
1431		- // Also delete related metadata
1432		- delete_option("mxchat_email_{$session_id}");
1433		- delete_option("mxchat_name_{$session_id}");
1434		- delete_option("mxchat_agent_name_{$session_id}");
1435		- $count++;
1436		- }
	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;
1437	2050	}
1438	2051	}
	2052	+}
1439	2053
1440		- 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);
1441	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');
1442	2064
1443	2065	function mxchat_migrate_live_agent_status() {
1444	2066	$options = get_option('mxchat_options', []);
1445	2067
		@@ -1542,8 +2164,9 @@
1542	2164	add_action('init', 'mxchat_check_fallback_rate_limits', 5);
1543	2165
1544	2166	// Add migration notice hook
1545	2167	add_action('admin_notices', 'mxchat_show_migration_notice');
	2168	+ add_action('admin_notices', 'mxchat_show_model_access_notice');
1546	2169
1547	2170	// Initialize classes with error handling
1548	2171	try {
1549	2172	// Initialize admin classes
		@@ -1701,9 +2324,9 @@
1701	2324	*/
1702	2325	function mxchat_save_session_rating() {
1703	2326	global $wpdb;
1704	2327
1705		- $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'])) : '';
1706	2329	$bot_id = isset($_POST['bot_id']) ? sanitize_text_field(wp_unslash($_POST['bot_id'])) : 'default';
1707	2330	$rating_raw = isset($_POST['rating']) ? (int) $_POST['rating'] : 0;
1708	2331	$feedback = isset($_POST['feedback']) ? sanitize_textarea_field(wp_unslash($_POST['feedback'])) : '';
1709	2332