PluginProbe
MxChat – AI Chatbot & Content Generation for WordPress / 3.2.24
MxChat – AI Chatbot & Content Generation for WordPress v3.2.24
3.2.25 3.2.24 3.2.23 3.2.22 3.2.21 3.2.20 3.2.19 3.2.18 3.2.17 3.2.16 3.2.15 3.2.14 3.2.12 3.2.13 3.2.11 3.2.10 3.2.9 3.2.8 3.2.7 3.2.6 3.2.5 3.2.4 3.2.3 3.2.2 3.2.1 All 156 releases
← All changes | mxchat-basic.php +552 -112 3.2.17 → 3.2.24 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.17
6 + * Version: 3.2.24
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
@@ -38,8 +38,77 @@
38 38 define('MXCHAT_VERSION', $version);
39 39 }
40 40
41 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 +/**
42 111 * Honest, versioned User-Agent for MXChat remote-content ingestion fetches
43 112 * (Knowledge Base PDF import, URL import, sitemap / website crawl).
44 113 *
45 114 * WAF rulesets (SiteGround/ModSecurity, Wordfence, Cloudflare managed rules)
@@ -410,13 +479,17 @@
410 479 // Include classes with error handling
411 480 function mxchat_include_classes() {
412 481 $class_files = array(
413 482 'includes/class-mxchat-model-catalog.php',
483 + 'includes/class-mxchat-model-liveness.php',
484 + 'includes/class-mxchat-session-store.php',
414 485 'includes/class-mxchat-live-agent-schedule.php',
415 486 'includes/class-mxchat-tool-registry.php',
416 487 'includes/class-mxchat-integrator.php',
417 488 'includes/class-mxchat-admin.php',
418 489 'includes/class-mxchat-public.php',
490 + 'includes/class-mxchat-block.php',
491 + 'includes/class-mxchat-elementor.php',
419 492 'includes/class-mxchat-utils.php',
420 493 'includes/class-mxchat-user.php',
421 494 'includes/class-mxchat-privacy.php',
422 495 'includes/class-mxchat-meta-box.php',
@@ -427,9 +500,11 @@
427 500 'includes/class-mxchat-editor-assistant.php',
428 501 'includes/class-rest-api.php',
429 502 'admin/class-ajax-handler.php',
430 503 'admin/class-pinecone-manager.php',
431 - 'admin/class-knowledge-manager.php'
504 + 'admin/class-pinecone-documents.php',
505 + 'admin/class-knowledge-manager.php',
506 + 'admin/class-vectorstore-manager.php'
432 507 );
433 508
434 509 foreach ($class_files as $file) {
435 510 $file_path = plugin_dir_path(__FILE__) . $file;
@@ -449,8 +524,34 @@
449 524 if (class_exists('MxChat_Privacy')) {
450 525 MxChat_Privacy::init();
451 526 }
452 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 +
453 554 // Editor Assistant — free, OFF-by-default block-editor AI actions (plan-8cb0cb).
454 555 // init() wires REST + streaming AJAX + sidebar enqueue ONLY when the
455 556 // mxchat_editor_assistant_enabled option is 'on'; otherwise zero footprint.
456 557 if (class_exists('MxChat_Editor_Assistant')) {
@@ -456,8 +557,16 @@
456 557 if (class_exists('MxChat_Editor_Assistant')) {
457 558 MxChat_Editor_Assistant::init();
458 559 }
459 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 +
460 569 // Admin pages that aren't classes (procedural include).
461 570 if (is_admin()) {
462 571 $admin_api_page = plugin_dir_path(__FILE__) . 'includes/admin-api-page.php';
463 572 if (file_exists($admin_api_page)) {
@@ -519,8 +628,26 @@
519 628 dbDelta($sql);
520 629 }
521 630
522 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 +/**
523 650 * FIXED: Robust table creation and column management
524 651 */
525 652 function mxchat_create_chat_transcripts_table() {
526 653 global $wpdb;
@@ -831,8 +958,66 @@
831 958 }
832 959 }
833 960
834 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 +/**
835 1020 * 2.5.2: Create queue processing tables for reliable background processing
836 1021 */
837 1022 function mxchat_create_queue_tables() {
838 1023 global $wpdb;
@@ -930,8 +1115,41 @@
930 1115 dbDelta($sql);
931 1116 }
932 1117
933 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 +/**
934 1152 * 2.5.2: Fix URL column size to support long URLs (especially with UTF-8 encoding)
935 1153 * This fixes "url, source_url. The supplied values may be too long" errors
936 1154 */
937 1155 function mxchat_fix_url_column_size() {
@@ -975,93 +1193,47 @@
975 1193 if (!isset($options['model'])) {
976 1194 return;
977 1195 }
978 1196
979 - $current_model = $options['model'];
980 -
981 - // Migrate deprecated Claude models to Claude Opus 4.6 (recommended replacement per Anthropic)
982 - $deprecated_claude_models = array(
983 - 'claude-3-5-sonnet-20240620', // Retired Oct 28, 2025
984 - 'claude-3-5-sonnet-20241022', // Retired Oct 28, 2025
985 - 'claude-3-7-sonnet-20250219', // Retiring Feb 19, 2026
986 - 'claude-3-opus-20240229', // Retired Jan 5, 2026
987 - 'claude-3-sonnet-20240229', // Legacy
988 - 'claude-3-haiku-20240307', // Legacy
989 - );
990 - if (in_array($current_model, $deprecated_claude_models, true)) {
991 - $options['model'] = 'claude-opus-4-6';
992 - $migrated = true;
993 - $migration_message = sprintf(
994 - 'Your chatbot model has been automatically updated from %s to Claude Opus 4.6 due to Anthropic deprecating older Claude models.',
995 - $current_model
996 - );
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
997 1203 }
1204 + $map = MxChat_Model_Catalog::retired_model_map();
998 1205
999 - // Migrate deprecated Claude Haiku 3.5 to Claude Haiku 4.5
1000 - if ($current_model === 'claude-3-5-haiku-20241022') {
1001 - $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'];
1002 1210 $migrated = true;
1003 - $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.';
1004 - }
1005 -
1006 - // Migrate deprecated GPT-4 series and GPT-3.5 Turbo to GPT-5.6 Sol.
1007 - // (Previous target gpt-5.1-chat-latest itself retires 2026-08-10 — never
1008 - // migrate onto a model that is already on a deprecation list.)
1009 - if (in_array($current_model, array('gpt-4o', 'gpt-4.1-2025-04-14', 'gpt-4-turbo', 'gpt-4', 'gpt-3.5-turbo'), true)) {
1010 - $options['model'] = 'gpt-5.6-sol';
1011 - $migrated = true;
1012 1211 $migration_message = sprintf(
1013 - 'Your chatbot model has been automatically updated from %s to GPT-5.6 Sol due to OpenAI deprecating older models.',
1014 - $current_model
1212 + 'Your chatbot model has been automatically updated from %s to %s %s.',
1213 + $current_model,
1214 + $entry['label'],
1215 + $entry['reason']
1015 1216 );
1016 1217 }
1017 1218
1018 - // Migrate the gpt-5.x-chat-latest aliases OpenAI retires on August 10, 2026.
1019 - // Replacement per OpenAI's deprecations page: gpt-5.6-sol (plan e46b8f).
1020 - if (in_array($current_model, array('gpt-5.1-chat-latest', 'gpt-5.3-chat-latest'), true)) {
1021 - $options['model'] = 'gpt-5.6-sol';
1022 - $migrated = true;
1023 - $migration_message = sprintf(
1024 - 'Your chatbot model has been automatically updated from %s to GPT-5.6 Sol because OpenAI retires the GPT-5.x Chat Latest models on August 10, 2026.',
1025 - $current_model
1026 - );
1027 - }
1028 -
1029 - // The content generator has its own model option — same retirement applies.
1030 - if (isset($options['content_model'])
1031 - && in_array($options['content_model'], array('gpt-5.1-chat-latest', 'gpt-5.3-chat-latest'), true)) {
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']])) {
1032 1224 $old_content_model = $options['content_model'];
1033 - $options['content_model'] = 'gpt-5.6-sol';
1225 + $entry = $map[$old_content_model];
1226 + $options['content_model'] = $entry['to'];
1034 1227 $migrated = true;
1035 1228 $migration_message = trim($migration_message . ' ' . sprintf(
1036 - 'Your content generation model has also been updated from %s to GPT-5.6 Sol for the same OpenAI retirement.',
1037 - $old_content_model
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']
1038 1233 ));
1039 1234 }
1040 1235
1041 - // Migrate deprecated GPT-4o Mini and GPT-4.1 Mini to GPT-5 Mini
1042 - if (in_array($current_model, array('gpt-4o-mini', 'gpt-4.1-mini'), true)) {
1043 - $options['model'] = 'gpt-5-mini';
1044 - $migrated = true;
1045 - $migration_message = sprintf(
1046 - 'Your chatbot model has been automatically updated from %s to GPT-5 Mini due to OpenAI deprecating GPT-4 series models.',
1047 - $current_model
1048 - );
1049 - }
1050 -
1051 - // Migrate retired DeepSeek ids to DeepSeek V4 Flash — the vendor removed
1052 - // deepseek-chat and deepseek-reasoner on 2026-07-24 (hard cutoff, every
1053 - // request 400s). V4 Flash is DeepSeek's designated successor for the
1054 - // legacy deepseek-chat alias.
1055 - if (in_array($current_model, array('deepseek-chat', 'deepseek-reasoner'), true)) {
1056 - $options['model'] = 'deepseek-v4-flash';
1057 - $migrated = true;
1058 - $migration_message = sprintf(
1059 - 'Your chatbot model has been automatically updated from %s to DeepSeek V4 Flash because DeepSeek retired its older API models on July 24, 2026.',
1060 - $current_model
1061 - );
1062 - }
1063 -
1064 1236 if ($migrated) {
1065 1237 update_option('mxchat_options', $options);
1066 1238 update_option('mxchat_model_migrated_notice', true);
1067 1239 update_option('mxchat_model_migration_message', $migration_message);
@@ -1087,8 +1259,62 @@
1087 1259 }
1088 1260 }
1089 1261
1090 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 +/**
1091 1317 * Persistent admin notice when the provider rejected the configured model
1092 1318 * (model_not_found / no access). Set by mxchat_friendly_chat_error() in the
1093 1319 * integrator whenever a chat request fails on a model-access error — including
1094 1320 * requests from anonymous visitors, which is the case that otherwise stays
@@ -1133,8 +1359,12 @@
1133 1359
1134 1360 // Create chat transcripts table with improved function
1135 1361 mxchat_create_chat_transcripts_table();
1136 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 +
1137 1367 // System Prompt Content Table - UPDATED: Use TEXT for url and source_url columns
1138 1368 $system_prompt_table = $wpdb->prefix . 'mxchat_system_prompt_content';
1139 1369 $sql_system_prompt = "CREATE TABLE $system_prompt_table (
1140 1370 id MEDIUMINT(9) NOT NULL AUTO_INCREMENT,
@@ -1141,8 +1371,9 @@
1141 1371 url TEXT NOT NULL,
1142 1372 article_content LONGTEXT NOT NULL,
1143 1373 embedding_vector LONGTEXT,
1144 1374 source_url TEXT DEFAULT NULL,
1375 + title VARCHAR(255) DEFAULT NULL,
1145 1376 role_restriction VARCHAR(50) DEFAULT 'public',
1146 1377 content_type VARCHAR(50) DEFAULT 'content',
1147 1378 timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
1148 1379 PRIMARY KEY (id),
@@ -1196,8 +1427,11 @@
1196 1427
1197 1428 // Create per-session satisfaction ratings table (v3.2.6)
1198 1429 mxchat_create_session_ratings_table();
1199 1430
1431 + // Create Vector Store file-mapping table (v3.2.20, plan 15b5c6)
1432 + mxchat_create_vectorstore_files_table();
1433 +
1200 1434 // Ensure additional columns in system prompt table
1201 1435 $existing_system_columns = $wpdb->get_results("SHOW COLUMNS FROM $system_prompt_table");
1202 1436 if (!empty($existing_system_columns)) {
1203 1437 $existing_system_column_names = array_column($existing_system_columns, 'Field');
@@ -1210,8 +1444,13 @@
1210 1444 }
1211 1445 if (!in_array('role_restriction', $existing_system_column_names)) {
1212 1446 $wpdb->query("ALTER TABLE $system_prompt_table ADD COLUMN role_restriction VARCHAR(50) DEFAULT 'public' AFTER source_url");
1213 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 + }
1214 1453 }
1215 1454
1216 1455 // Set default thresholds for existing intents
1217 1456 $wpdb->query("UPDATE {$intents_table} SET similarity_threshold = 0.85 WHERE similarity_threshold IS NULL");
@@ -1309,8 +1548,9 @@
1309 1548 // Clear scheduled cron jobs
1310 1549 wp_clear_scheduled_hook('mxchat_reset_rate_limits');
1311 1550 wp_clear_scheduled_hook('mxchat_cleanup_old_transcripts');
1312 1551 wp_clear_scheduled_hook('mxchat_send_delayed_transcript');
1552 + wp_clear_scheduled_hook('mxchat_model_liveness_check');
1313 1553
1314 1554 // Clear fallback options
1315 1555 delete_option('mxchat_use_fallback_rate_limits');
1316 1556 delete_option('mxchat_next_rate_limit_check');
@@ -1367,12 +1607,16 @@
1367 1607 // This handles manual table deletion or fresh installs
1368 1608 $chat_table = $wpdb->prefix . 'mxchat_chat_transcripts';
1369 1609 $queue_table = $wpdb->prefix . 'mxchat_processing_queue';
1370 1610
1611 + $sessions_table = $wpdb->prefix . 'mxchat_sessions';
1612 +
1371 1613 $chat_exists = $wpdb->get_var("SHOW TABLES LIKE '$chat_table'") === $chat_table;
1372 1614 $queue_exists = $wpdb->get_var("SHOW TABLES LIKE '$queue_table'") === $queue_table;
1373 -
1374 - 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) {
1375 1619 //error_log("MxChat: Critical tables missing, running activation");
1376 1620 mxchat_activate();
1377 1621 }
1378 1622
@@ -1465,8 +1709,31 @@
1465 1709 mxchat_fix_credential_option_autoload();
1466 1710 mxchat_migrate_acf_pdf_extraction_option();
1467 1711 }
1468 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 +
1469 1736 // Run full activation to ensure everything is up to date
1470 1737 mxchat_activate();
1471 1738
1472 1739 // Run migration functions
@@ -1471,12 +1738,11 @@
1471 1738
1472 1739 // Run migration functions
1473 1740 mxchat_migrate_live_agent_status();
1474 1741
1475 - // Add the cleanup function for version 2.1.8
1476 - if (version_compare($current_version, '2.1.8', '<')) {
1477 - $deleted = mxchat_cleanup_orphaned_chat_history();
1478 - }
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.)
1479 1745
1480 1746 // Update version LAST
1481 1747 update_option('mxchat_plugin_version', $plugin_version);
1482 1748
@@ -1548,8 +1814,111 @@
1548 1814 }
1549 1815 }
1550 1816
1551 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 +/**
1552 1921 * Ensure tables exist on every admin load for fresh installations
1553 1922 * This is a safety net for cases where activation hook doesn't fire
1554 1923 */
1555 1924 function mxchat_ensure_tables_exist() {
@@ -1569,12 +1938,16 @@
1569 1938
1570 1939 $table_name = $wpdb->prefix . 'mxchat_chat_transcripts';
1571 1940 $queue_table = $wpdb->prefix . 'mxchat_processing_queue';
1572 1941
1942 + $sessions_table = $wpdb->prefix . 'mxchat_sessions';
1943 +
1573 1944 $chat_exists = $wpdb->get_var("SHOW TABLES LIKE '$table_name'") === $table_name;
1574 1945 $queue_exists = $wpdb->get_var("SHOW TABLES LIKE '$queue_table'") === $queue_table;
1575 -
1576 - 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) {
1577 1950 //error_log("MxChat: Tables missing on admin load, running activation");
1578 1951 mxchat_activate();
1579 1952 }
1580 1953 }
@@ -1579,49 +1952,116 @@
1579 1952 }
1580 1953 }
1581 1954
1582 1955 /**
1583 - * Clean up orphaned chat history options from the wp_options table
1584 - * @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.
1585 1972 */
1586 -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) {
1587 1998 global $wpdb;
1588 - $count = 0;
1589 1999
1590 - // Get all option keys that match our pattern
1591 - $history_options = $wpdb->get_results(
1592 - "SELECT option_name FROM {$wpdb->options}
1593 - 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
1594 2017 );
1595 2018
1596 - if (!empty($history_options)) {
1597 - foreach ($history_options as $option) {
1598 - // Extract the session ID from the option name
1599 - $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 + }
1600 2024
1601 - // Check if this session still exists in the custom table
1602 - $table_name = $wpdb->prefix . 'mxchat_chat_transcripts';
1603 - $exists = $wpdb->get_var(
1604 - $wpdb->prepare(
1605 - "SELECT COUNT(*) FROM {$table_name} WHERE session_id = %s",
1606 - $session_id
1607 - )
1608 - );
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 + }
1609 2030
1610 - // If session doesn't exist in the main table, delete the option
1611 - if ($exists == 0) {
1612 - delete_option($option->option_name);
1613 - // Also delete related metadata
1614 - delete_option("mxchat_email_{$session_id}");
1615 - delete_option("mxchat_name_{$session_id}");
1616 - delete_option("mxchat_agent_name_{$session_id}");
1617 - $count++;
1618 - }
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;
1619 2050 }
1620 2051 }
2052 +}
1621 2053
1622 - 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);
1623 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');
1624 2064
1625 2065 function mxchat_migrate_live_agent_status() {
1626 2066 $options = get_option('mxchat_options', []);
1627 2067