mxchat-basic / mxchat-basic.php

mxchat-basic.php in MxChat – AI Chatbot & Content Generation for WordPress 3.2.22, at mxchat-basic.php

2,373 lines 92.6 KB

Raw Download Zip

1	<?php
2	/**
3	* Plugin Name: MxChat
4	* Plugin URI: https://mxchat.ai/
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.22
7	* Author: MxChat
8	* Author URI: https://mxchat.ai
9	* License: GPLv2 or later
10	* License URI: https://www.gnu.org/licenses/gpl-2.0.html
11	* Text Domain: mxchat
12	* Domain Path: /languages
13	*/
14
15	if (!defined('ABSPATH')) {
16	exit; // Exit if accessed directly.
17	}
18
19
20	if (!defined('MXCHAT_DEV_MODE')) {
21	define('MXCHAT_DEV_MODE', false);
22	}
23
24	if (!defined('MXCHAT_VERSION')) {
25	$plugin_data = get_file_data(__FILE__, array('Version' => 'Version'), 'plugin');
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);
35	if (MXCHAT_DEV_MODE) {
36	$version .= '.' . time();
37	}
38	define('MXCHAT_VERSION', $version);
39	}
40
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	/**
111	* Honest, versioned User-Agent for MXChat remote-content ingestion fetches
112	* (Knowledge Base PDF import, URL import, sitemap / website crawl).
113	*
114	* WAF rulesets (SiteGround/ModSecurity, Wordfence, Cloudflare managed rules)
115	* flag stale spoofed-browser UAs as scrapers and return 403 — which silently
116	* broke the single most common KB source: self-hosted media on the site's own
117	* domain. A truthful crawler identifier is the industry norm for well-behaved
118	* bots and lets a site owner allowlist "MXChatBot" in their WAF. Filterable so
119	* a locked-down host can supply a different string without a code change.
120	*/
121	if (!function_exists('mxchat_ingest_user_agent')) {
122	function mxchat_ingest_user_agent() {
123	$version = defined('MXCHAT_VERSION') ? MXCHAT_VERSION : '1.0';
124	$ua = 'MXChatBot/' . $version . ' (+https://mxchat.ai/bot)';
125	return apply_filters('mxchat_ingest_user_agent', $ua);
126	}
127	}
128
129	function mxchat_load_textdomain() {
130	$domain = 'mxchat';
131	$locale = determine_locale();
132
133	// First, try to load from /wp-content/languages/plugins/ (preserved during updates)
134	$mo_file = WP_LANG_DIR . '/plugins/' . $domain . '-' . $locale . '.mo';
135	if (file_exists($mo_file)) {
136	load_textdomain($domain, $mo_file);
137	return;
138	}
139
140	// Fallback to plugin's /languages directory
141	load_plugin_textdomain($domain, false, dirname(plugin_basename(__FILE__)) . '/languages');
142	}
143	add_action('init', 'mxchat_load_textdomain');
144
145	/**
146	* One-time migration: gemini-3-pro-preview was shut down by Google on March 9, 2026.
147	* Existing installs with the dead ID get auto-remapped to gemini-3.1-pro-preview
148	* (Google's official migration target) the first time admin_init fires after update.
149	*/
150	add_action('admin_init', function () {
151	if (get_option('mxchat_gemini_3_remap_done')) {
152	return;
153	}
154	$opts = get_option('mxchat_options');
155	if (is_array($opts) && isset($opts['model']) && $opts['model'] === 'gemini-3-pro-preview') {
156	$opts['model'] = 'gemini-3.1-pro-preview';
157	update_option('mxchat_options', $opts);
158	}
159	if (is_array($opts) && isset($opts['content_model']) && $opts['content_model'] === 'gemini-3-pro-preview') {
160	$opts['content_model'] = 'gemini-3.1-pro-preview';
161	update_option('mxchat_options', $opts);
162	}
163	update_option('mxchat_gemini_3_remap_done', 1);
164	});
165
166	/**
167	* One-time migration: the Grok 2 family was retired by xAI (grok-2, grok-2-1212,
168	* grok-2-latest, grok-2-vision-1212 all return 400 "Model not found"). Existing
169	* installs with the dead ID get auto-remapped to grok-4-1-fast-non-reasoning
170	* (modern, fast, broadly available) the first time admin_init fires after update.
171	*/
172	add_action('admin_init', function () {
173	if (get_option('mxchat_grok_2_remap_done')) {
174	return;
175	}
176	$opts = get_option('mxchat_options');
177	if (is_array($opts) && isset($opts['model']) && $opts['model'] === 'grok-2') {
178	$opts['model'] = 'grok-4-1-fast-non-reasoning';
179	update_option('mxchat_options', $opts);
180	}
181	if (is_array($opts) && isset($opts['content_model']) && $opts['content_model'] === 'grok-2') {
182	$opts['content_model'] = 'grok-4-1-fast-non-reasoning';
183	update_option('mxchat_options', $opts);
184	}
185	update_option('mxchat_grok_2_remap_done', 1);
186	});
187
188	/**
189	* One-time migration: Anthropic retired the Claude 4 (2025-05-14) snapshots on
190	* June 15, 2026 — claude-opus-4-20250514 and claude-sonnet-4-20250514 now return
191	* an API error. Existing installs with a dead ID get auto-remapped to the current
192	* equivalents Anthropic recommends (Opus 4.8 / Sonnet 4.6) the first time admin_init
193	* fires after update. Mirrors the gemini-3-pro-preview / grok-2 rescues above.
194	*/
195	add_action('admin_init', function () {
196	if (get_option('mxchat_claude_4_retire_remap_done')) {
197	return;
198	}
199	$map = array(
200	'claude-opus-4-20250514' => 'claude-opus-4-8',
201	'claude-sonnet-4-20250514' => 'claude-sonnet-4-6',
202	);
203	$opts = get_option('mxchat_options');
204	if (is_array($opts)) {
205	$changed = false;
206	if (isset($opts['model']) && isset($map[$opts['model']])) {
207	$opts['model'] = $map[$opts['model']];
208	$changed = true;
209	}
210	if (isset($opts['content_model']) && isset($map[$opts['content_model']])) {
211	$opts['content_model'] = $map[$opts['content_model']];
212	$changed = true;
213	}
214	if ($changed) {
215	update_option('mxchat_options', $opts);
216	}
217	}
218	update_option('mxchat_claude_4_retire_remap_done', 1);
219	});
220
221	/**
222	* Exclude MxChat assets from caching plugin optimizations
223	*
224	* This prevents issues with WP Rocket, LiteSpeed Cache, Autoptimize, WP Super Cache,
225	* W3 Total Cache, SG Optimizer, and similar plugins that may break the chatbot by
226	* removing "unused" CSS, minifying/combining JS, or deferring/delaying jQuery.
227	*
228	* Both chat-script.js and floating-script.js depend on jQuery, so jQuery must also
229	* be excluded from any optimization that changes load order or timing.
230	*/
231
232	// ── WP Rocket ────────────────────────────────────────────────────────────────
233
234	// Exclude from Remove Unused CSS (RUCSS)
235	add_filter('rocket_rucss_inline_atts_exclusions', function($exclusions) {
236	if (!is_array($exclusions)) $exclusions = array();
237	$exclusions[] = 'mxchat';
238	return $exclusions;
239	});
240
241	// Exclude CSS from minification/combination
242	add_filter('rocket_exclude_css', function($excluded) {
243	if (!is_array($excluded)) $excluded = array();
244	$excluded[] = '/plugins/mxchat-basic/css/chat-style.css';
245	return $excluded;
246	});
247
248	// Exclude JS from minification/combination
249	add_filter('rocket_exclude_js', function($excluded) {
250	if (!is_array($excluded)) $excluded = array();
251	$excluded[] = '/plugins/mxchat-basic/js/chat-script.js';
252	$excluded[] = '/plugins/mxchat-basic/js/floating-script.js';
253	$excluded[] = '/jquery-core';
254	$excluded[] = '/jquery.min.js';
255	$excluded[] = '/jquery.js';
256	$excluded[] = '/jquery-migrate';
257	return $excluded;
258	});
259
260	// Exclude JS from defer
261	add_filter('rocket_exclude_defer_js', function($excluded) {
262	if (!is_array($excluded)) $excluded = array();
263	$excluded[] = '/plugins/mxchat-basic/js/chat-script.js';
264	$excluded[] = '/plugins/mxchat-basic/js/floating-script.js';
265	$excluded[] = '/jquery-core';
266	$excluded[] = '/jquery.min.js';
267	$excluded[] = '/jquery.js';
268	$excluded[] = '/jquery-migrate';
269	return $excluded;
270	});
271
272	// Exclude from delay JS execution
273	add_filter('rocket_delay_js_exclusions', function($excluded) {
274	if (!is_array($excluded)) $excluded = array();
275	$excluded[] = 'mxchat';
276	$excluded[] = 'chat-script';
277	$excluded[] = 'floating-script';
278	$excluded[] = '/jquery-core';
279	$excluded[] = '/jquery.min.js';
280	$excluded[] = '/jquery.js';
281	$excluded[] = '/jquery-migrate';
282	return $excluded;
283	});
284
285	// ── LiteSpeed Cache ──────────────────────────────────────────────────────────
286
287	// Exclude CSS from optimization
288	add_filter('litespeed_optimize_css_excludes', function($excluded) {
289	if (!is_array($excluded)) $excluded = array();
290	$excluded[] = 'chat-style.css';
291	$excluded[] = 'mxchat';
292	return $excluded;
293	});
294
295	// Exclude from UCSS (Unique CSS) - prevents LiteSpeed from stripping "unused" MxChat CSS
296	add_filter('litespeed_ucss_whitelist', function($whitelist) {
297	if (!is_array($whitelist)) $whitelist = array();
298	$whitelist[] = '.mxchat-chatbot-wrapper';
299	$whitelist[] = '.floating-chatbot';
300	$whitelist[] = '.floating-chatbot-button';
301	$whitelist[] = '.chatbot-top-bar';
302	$whitelist[] = '.mxchat-chatbot';
303	$whitelist[] = '.chat-container';
304	$whitelist[] = '.chat-box';
305	$whitelist[] = '.bot-message';
306	$whitelist[] = '.input-container';
307	$whitelist[] = '.chat-input';
308	$whitelist[] = '.send-button';
309	$whitelist[] = '.pre-chat-message';
310	$whitelist[] = '.mxchat-popular-questions';
311	$whitelist[] = '.chat-toolbar';
312	$whitelist[] = '.exit-chat';
313	$whitelist[] = '.email-blocker';
314	return $whitelist;
315	});
316
317	// Exclude CSS from CCSS (Critical CSS) generation
318	add_filter('litespeed_optm_ccss_exc', function($excluded) {
319	if (!is_array($excluded)) $excluded = array();
320	$excluded[] = 'chat-style.css';
321	$excluded[] = 'mxchat';
322	return $excluded;
323	});
324
325	// Exclude JS from defer
326	add_filter('litespeed_optm_js_defer_exc', function($excluded) {
327	if (!is_array($excluded)) $excluded = array();
328	$excluded[] = 'chat-script.js';
329	$excluded[] = 'floating-script.js';
330	$excluded[] = 'mxchat';
331	$excluded[] = 'jquery.min.js';
332	$excluded[] = 'jquery.js';
333	return $excluded;
334	});
335
336	// Exclude JS from combining
337	add_filter('litespeed_optm_js_exc', function($excluded) {
338	if (!is_array($excluded)) $excluded = array();
339	$excluded[] = 'chat-script.js';
340	$excluded[] = 'floating-script.js';
341	$excluded[] = 'mxchat';
342	$excluded[] = 'jquery.min.js';
343	$excluded[] = 'jquery.js';
344	return $excluded;
345	});
346
347	// Exclude JS from delayed execution
348	add_filter('litespeed_optm_js_delay_exc', function($excluded) {
349	if (!is_array($excluded)) $excluded = array();
350	$excluded[] = 'chat-script.js';
351	$excluded[] = 'floating-script.js';
352	$excluded[] = 'mxchat';
353	return $excluded;
354	});
355
356	// Exclude from Guest Mode optimization
357	add_filter('litespeed_guest_optm_exc', function($excluded) {
358	if (!is_array($excluded)) $excluded = array();
359	$excluded[] = 'mxchat';
360	$excluded[] = 'chat-style';
361	$excluded[] = 'chat-script';
362	$excluded[] = 'floating-script';
363	return $excluded;
364	});
365
366	// ── Autoptimize ──────────────────────────────────────────────────────────────
367
368	// Exclude CSS from optimization (comma-separated strings)
369	add_filter('autoptimize_filter_css_exclude', function($excluded) {
370	if (!is_string($excluded)) $excluded = '';
371	return $excluded . ', mxchat, chat-style.css';
372	});
373
374	// Exclude JS from optimization (comma-separated strings)
375	add_filter('autoptimize_filter_js_exclude', function($excluded) {
376	if (!is_string($excluded)) $excluded = '';
377	return $excluded . ', mxchat, chat-script.js, floating-script.js, jquery.min.js, jquery.js';
378	});
379
380	// ── SG Optimizer (SiteGround) ────────────────────────────────────────────────
381
382	add_filter('sgo_js_minify_exclude', function($excluded) {
383	if (!is_array($excluded)) $excluded = array();
384	$excluded[] = 'chat-script.js';
385	$excluded[] = 'floating-script.js';
386	$excluded[] = 'jquery.min.js';
387	return $excluded;
388	});
389
390	add_filter('sgo_javascript_combine_exclude', function($excluded) {
391	if (!is_array($excluded)) $excluded = array();
392	$excluded[] = 'chat-script.js';
393	$excluded[] = 'floating-script.js';
394	$excluded[] = 'jquery.min.js';
395	return $excluded;
396	});
397
398	add_filter('sgo_js_async_exclude', function($excluded) {
399	if (!is_array($excluded)) $excluded = array();
400	$excluded[] = 'chat-script.js';
401	$excluded[] = 'floating-script.js';
402	$excluded[] = 'jquery.min.js';
403	return $excluded;
404	});
405
406	// ── W3 Total Cache ───────────────────────────────────────────────────────────
407
408	add_filter('w3tc_minify_js_do_tag_minification', function($do_minify, $script_tag, $file) {
409	if (strpos($file, 'chat-script.js') !== false \|\|
410	strpos($file, 'floating-script.js') !== false \|\|
411	strpos($file, 'jquery.min.js') !== false \|\|
412	strpos($file, 'jquery.js') !== false) {
413	return false;
414	}
415	return $do_minify;
416	}, 10, 3);
417
418	// ── WP Super Cache ──────────────────────────────────────────────────────────
419
420	add_filter('wpsc_rejected_uri', function($rejected) {
421	if (!is_array($rejected)) $rejected = array();
422	$rejected[] = 'wp-admin/admin-ajax.php';
423	return $rejected;
424	});
425
426	// ── Page-cache bypass for chat AJAX (companion to the 3.2.6 nonce-race hotfix)
427	// Each cache plugin gets its own filter export so that visitors hitting an
428	// edge-cached page never receive cached chat-AJAX responses. The chat send /
429	// stream send / file upload all POST to /wp-admin/admin-ajax.php with
430	// `action=mxchat_*`. Without these exports, a cache plugin can stale a response
431	// and break the per-session nonce flow on the first message.
432
433	// WP Rocket — `rocket_cache_reject_uri` takes a flat array of regex strings.
434	add_filter('rocket_cache_reject_uri', function($uris) {
435	if (!is_array($uris)) $uris = array();
436	$uris[] = '/wp-admin/admin-ajax\.php\?action=mxchat_.*';
437	return $uris;
438	});
439
440	// LiteSpeed Cache — `litespeed_cache_no_cache_for_request` short-circuits
441	// caching when the request matches our chat-AJAX pattern.
442	add_filter('litespeed_cache_no_cache_for_request', function($no_cache) {
443	if ($no_cache) return $no_cache;
444	if (!empty($_SERVER['REQUEST_URI']) &&
445	strpos($_SERVER['REQUEST_URI'], '/wp-admin/admin-ajax.php') !== false &&
446	!empty($_REQUEST['action']) &&
447	strpos((string) $_REQUEST['action'], 'mxchat_') === 0) {
448	return true;
449	}
450	return $no_cache;
451	});
452
453	// W3 Total Cache — `w3tc_pgcache_request_skip_uri` flips page-cache off when
454	// the URI matches.
455	add_filter('w3tc_pgcache_request_skip_uri', function($skip) {
456	if ($skip) return $skip;
457	if (!empty($_SERVER['REQUEST_URI']) &&
458	strpos($_SERVER['REQUEST_URI'], '/wp-admin/admin-ajax.php') !== false &&
459	!empty($_REQUEST['action']) &&
460	strpos((string) $_REQUEST['action'], 'mxchat_') === 0) {
461	return true;
462	}
463	return $skip;
464	});
465
466	// FlyingPress — `flying_press_cacheable` takes a boolean and is run per
467	// request. Same pattern as LiteSpeed / W3TC.
468	add_filter('flying_press_cacheable', function($cacheable) {
469	if (!$cacheable) return $cacheable;
470	if (!empty($_SERVER['REQUEST_URI']) &&
471	strpos($_SERVER['REQUEST_URI'], '/wp-admin/admin-ajax.php') !== false &&
472	!empty($_REQUEST['action']) &&
473	strpos((string) $_REQUEST['action'], 'mxchat_') === 0) {
474	return false;
475	}
476	return $cacheable;
477	});
478
479	// Include classes with error handling
480	function mxchat_include_classes() {
481	$class_files = array(
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',
486	'includes/class-mxchat-tool-registry.php',
487	'includes/class-mxchat-integrator.php',
488	'includes/class-mxchat-admin.php',
489	'includes/class-mxchat-public.php',
490	'includes/class-mxchat-block.php',
491	'includes/class-mxchat-elementor.php',
492	'includes/class-mxchat-utils.php',
493	'includes/class-mxchat-user.php',
494	'includes/class-mxchat-privacy.php',
495	'includes/class-mxchat-meta-box.php',
496	'includes/class-mxchat-chunker.php',
497	'includes/class-mxchat-word-handler.php',
498	'includes/class-mxchat-content-generator.php',
499	'includes/class-mxchat-cache-purge.php',
500	'includes/class-mxchat-editor-assistant.php',
501	'includes/class-rest-api.php',
502	'admin/class-ajax-handler.php',
503	'admin/class-pinecone-manager.php',
504	'admin/class-pinecone-documents.php',
505	'admin/class-knowledge-manager.php',
506	'admin/class-vectorstore-manager.php'
507	);
508
509	foreach ($class_files as $file) {
510	$file_path = plugin_dir_path(__FILE__) . $file;
511	if (file_exists($file_path)) {
512	require_once $file_path;
513	} else {
514	//error_log('MxChat: Missing class file - ' . $file);
515	}
516	}
517
518	// Register the native function-calling admin-post save handler (a41dee).
519	if (class_exists('MxChat_Tool_Registry')) {
520	MxChat_Tool_Registry::init();
521	}
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
569	// Admin pages that aren't classes (procedural include).
570	if (is_admin()) {
571	$admin_api_page = plugin_dir_path(__FILE__) . 'includes/admin-api-page.php';
572	if (file_exists($admin_api_page)) {
573	require_once $admin_api_page;
574	}
575	// f7c7d4 renamed this file admin-dashboard-page.php → admin-onboarding-page.php.
576	// The require MUST live here (admin bootstrap) and not just inside
577	// mxchat_add_plugin_page() on the admin_menu hook — admin_menu does NOT
578	// fire on admin-ajax.php requests, so the wizard's AJAX handlers
579	// (plan-905439: mxchat_onboarding_kb_status / save_step / mark_step /
580	// auto_graduate + the f7c7d4 dismiss handler) would never register.
581	$admin_onboarding_page = plugin_dir_path(__FILE__) . 'includes/admin-onboarding-page.php';
582	if (file_exists($admin_onboarding_page)) {
583	require_once $admin_onboarding_page;
584	}
585	}
586	}
587
588	/**
589	* Lazy-load the PDF parser library only when needed.
590	* Avoids loading 44 files on every page request.
591	*/
592	function mxchat_load_pdf_parser() {
593	if (class_exists('\Smalot\PdfParser\Parser')) {
594	return true;
595	}
596	$autoload_path = plugin_dir_path(__FILE__) . 'includes/pdf-parser/alt_autoload.php';
597	if (file_exists($autoload_path)) {
598	require_once $autoload_path;
599	return true;
600	}
601	return false;
602	}
603
604	/**
605	* Create URL click tracking table
606	*/
607	function mxchat_create_url_clicks_table() {
608	global $wpdb;
609
610	$table_name = $wpdb->prefix . 'mxchat_url_clicks';
611
612	$charset_collate = $wpdb->get_charset_collate();
613
614	$sql = "CREATE TABLE $table_name (
615	id mediumint(9) NOT NULL AUTO_INCREMENT,
616	session_id varchar(100) NOT NULL,
617	clicked_url text NOT NULL,
618	message_context text,
619	click_timestamp datetime DEFAULT CURRENT_TIMESTAMP,
620	user_ip varchar(45),
621	user_agent text,
622	PRIMARY KEY (id),
623	KEY session_id (session_id),
624	KEY click_timestamp (click_timestamp)
625	) $charset_collate;";
626
627	require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
628	dbDelta($sql);
629	}
630
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	/**
650	* FIXED: Robust table creation and column management
651	*/
652	function mxchat_create_chat_transcripts_table() {
653	global $wpdb;
654
655	$table_name = $wpdb->prefix . 'mxchat_chat_transcripts';
656	$charset_collate = $wpdb->get_charset_collate();
657
658	// Create table with ALL columns including user_name from the start
659	$sql = "CREATE TABLE $table_name (
660	id MEDIUMINT(9) NOT NULL AUTO_INCREMENT,
661	user_id MEDIUMINT(9) DEFAULT 0,
662	session_id VARCHAR(255) NOT NULL,
663	role VARCHAR(255) NOT NULL,
664	message TEXT NOT NULL,
665	user_email VARCHAR(255) DEFAULT NULL,
666	user_name VARCHAR(100) DEFAULT NULL,
667	user_identifier VARCHAR(255) DEFAULT NULL,
668	originating_page_url TEXT DEFAULT NULL,
669	originating_page_title VARCHAR(500) DEFAULT NULL,
670	timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
671	PRIMARY KEY (id),
672	KEY session_id (session_id),
673	KEY user_email (user_email),
674	KEY timestamp (timestamp)
675	) $charset_collate;";
676
677	require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
678	$result = dbDelta($sql);
679
680	// Log the result for debugging
681	if (empty($result)) {
682	//error_log("MxChat: dbDelta returned empty result for chat transcripts table");
683	} else {
684	//error_log("MxChat: dbDelta result: " . print_r($result, true));
685	}
686
687	// IMPORTANT: Ensure all columns exist for existing installations
688	mxchat_ensure_all_columns($table_name);
689	}
690
691	/**
692	* Ensure all required columns exist (for upgrades)
693	*/
694	function mxchat_ensure_all_columns($table_name) {
695	global $wpdb;
696
697	// First check if table exists
698	$table_exists = $wpdb->get_var("SHOW TABLES LIKE '$table_name'") === $table_name;
699	if (!$table_exists) {
700	//error_log("MxChat: Table $table_name does not exist, cannot add columns");
701	return;
702	}
703
704	// Define all required columns and their types
705	$required_columns = [
706	'user_identifier' => 'VARCHAR(255) DEFAULT NULL',
707	'user_email' => 'VARCHAR(255) DEFAULT NULL',
708	'user_name' => 'VARCHAR(100) DEFAULT NULL',
709	'originating_page_url' => 'TEXT DEFAULT NULL',
710	'originating_page_title' => 'VARCHAR(500) DEFAULT NULL',
711	'rag_context' => 'LONGTEXT DEFAULT NULL'
712	];
713
714	// Get existing columns
715	$existing_columns = $wpdb->get_results("SHOW COLUMNS FROM $table_name");
716	if (empty($existing_columns)) {
717	//error_log("MxChat: Could not get columns for table $table_name");
718	return;
719	}
720
721	$existing_column_names = array_column($existing_columns, 'Field');
722
723	// Add missing columns
724	foreach ($required_columns as $column_name => $column_definition) {
725	if (!in_array($column_name, $existing_column_names)) {
726	$alter_sql = "ALTER TABLE $table_name ADD COLUMN $column_name $column_definition";
727	$result = $wpdb->query($alter_sql);
728
729	if ($result === false) {
730	//error_log("MxChat: Failed to add column $column_name to $table_name. Error: " . $wpdb->last_error);
731	} else {
732	//error_log("MxChat: Successfully added column $column_name to $table_name");
733	}
734	}
735	}
736	}
737
738	/**
739	* Add role restriction column to knowledge base table
740	*/
741	function mxchat_add_role_restriction_column() {
742	global $wpdb;
743	$table_name = $wpdb->prefix . 'mxchat_system_prompt_content';
744
745	// Check if table exists first
746	$table_exists = $wpdb->get_var("SHOW TABLES LIKE '$table_name'") === $table_name;
747	if (!$table_exists) {
748	//error_log("MxChat: System prompt content table does not exist, cannot add role_restriction column");
749	return;
750	}
751
752	// Check if column already exists
753	$column_exists = $wpdb->get_results(
754	$wpdb->prepare(
755	"SHOW COLUMNS FROM {$table_name} LIKE %s",
756	'role_restriction'
757	)
758	);
759
760	if (empty($column_exists)) {
761	$alter_sql = "ALTER TABLE {$table_name} ADD COLUMN role_restriction VARCHAR(50) DEFAULT 'public' AFTER source_url";
762	$result = $wpdb->query($alter_sql);
763
764	if ($result === false) {
765	//error_log("MxChat: Failed to add role_restriction column. Error: " . $wpdb->last_error);
766	} else {
767	//error_log("MxChat: Successfully added role_restriction column");
768
769	// Set all existing records to 'public' (everyone can access)
770	$update_result = $wpdb->query(
771	"UPDATE {$table_name}
772	SET role_restriction = 'public'
773	WHERE role_restriction IS NULL OR role_restriction = ''"
774	);
775
776	if ($update_result !== false) {
777	//error_log("MxChat: Updated {$update_result} existing records to public access");
778	}
779	}
780	}
781	}
782
783	/**
784	* Add enabled_bots column to intents table for multi-bot action filtering
785	*/
786	function mxchat_add_enabled_bots_column() {
787	global $wpdb;
788	$table_name = $wpdb->prefix . 'mxchat_intents';
789
790	// Check if table exists first
791	$table_exists = $wpdb->get_var("SHOW TABLES LIKE '$table_name'") === $table_name;
792	if (!$table_exists) {
793	//error_log("MxChat: Intents table does not exist, cannot add enabled_bots column");
794	return;
795	}
796
797	// Check if column already exists
798	$column_exists = $wpdb->get_results(
799	$wpdb->prepare(
800	"SHOW COLUMNS FROM {$table_name} LIKE %s",
801	'enabled_bots'
802	)
803	);
804
805	if (empty($column_exists)) {
806	$alter_sql = "ALTER TABLE {$table_name} ADD COLUMN enabled_bots LONGTEXT DEFAULT NULL AFTER enabled";
807	$result = $wpdb->query($alter_sql);
808
809	if ($result === false) {
810	//error_log("MxChat: Failed to add enabled_bots column. Error: " . $wpdb->last_error);
811	} else {
812	//error_log("MxChat: Successfully added enabled_bots column");
813
814	// Set all existing actions to work with 'default' bot for backward compatibility
815	$default_bots = json_encode(['default']);
816	$update_result = $wpdb->query(
817	$wpdb->prepare(
818	"UPDATE {$table_name}
819	SET enabled_bots = %s
820	WHERE enabled_bots IS NULL OR enabled_bots = ''",
821	$default_bots
822	)
823	);
824
825	if ($update_result !== false) {
826	//error_log("MxChat: Updated {$update_result} existing actions to work with default bot");
827	}
828	}
829	}
830	}
831
832	/**
833	* Create Pinecone role restrictions table with multi-bot support
834	*/
835	function mxchat_create_pinecone_roles_table() {
836	global $wpdb;
837
838	$table_name = $wpdb->prefix . 'mxchat_pinecone_roles';
839	$charset_collate = $wpdb->get_charset_collate();
840
841	$sql = "CREATE TABLE $table_name (
842	id mediumint(9) NOT NULL AUTO_INCREMENT,
843	vector_id varchar(255) NOT NULL,
844	bot_id varchar(50) NOT NULL DEFAULT 'default',
845	source_url text,
846	role_restriction varchar(50) DEFAULT 'public',
847	updated_at timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
848	PRIMARY KEY (id),
849	UNIQUE KEY vector_bot (vector_id, bot_id),
850	KEY role_restriction (role_restriction),
851	KEY bot_id (bot_id)
852	) $charset_collate;";
853
854	require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
855	dbDelta($sql);
856	}
857
858	/**
859	* Add bot_id column to mxchat_pinecone_roles table for multi-bot support
860	* This migration runs once to update existing installations
861	*/
862	function mxchat_migrate_pinecone_roles_add_bot_id() {
863	global $wpdb;
864
865	// Check if migration already ran
866	$migration_version = get_option('mxchat_pinecone_roles_migration_version', '0');
867	if (version_compare($migration_version, '2.5.2', '>=')) {
868	return; // Already migrated
869	}
870
871	$table_name = $wpdb->prefix . 'mxchat_pinecone_roles';
872
873	// Check if table exists
874	if ($wpdb->get_var("SHOW TABLES LIKE '{$table_name}'") != $table_name) {
875	return; // Table doesn't exist yet
876	}
877
878	// Check if bot_id column already exists
879	$column_exists = $wpdb->get_results("SHOW COLUMNS FROM {$table_name} LIKE 'bot_id'");
880
881	if (empty($column_exists)) {
882	// Add bot_id column
883	$wpdb->query("ALTER TABLE {$table_name} ADD COLUMN bot_id VARCHAR(50) NOT NULL DEFAULT 'default' AFTER vector_id");
884
885	// Update the unique key to include bot_id
886	$wpdb->query("ALTER TABLE {$table_name} DROP INDEX vector_id");
887	$wpdb->query("ALTER TABLE {$table_name} ADD UNIQUE KEY vector_bot (vector_id, bot_id)");
888
889	// Add index for bot_id
890	$wpdb->query("ALTER TABLE {$table_name} ADD KEY bot_id (bot_id)");
891
892	//error_log('MxChat: Successfully added bot_id column to mxchat_pinecone_roles table');
893	}
894
895	// Mark migration as complete
896	update_option('mxchat_pinecone_roles_migration_version', '2.5.2');
897	}
898
899	/**
900	* 2.5.6: Add content_type column to mxchat_system_prompt_content table
901	* Enables filtering knowledge base by content type (posts, pages, PDFs, etc.)
902	*/
903	function mxchat_migrate_add_content_type_column() {
904	global $wpdb;
905
906	// Check if migration already ran
907	$migration_version = get_option('mxchat_content_type_migration_version', '0');
908	if (version_compare($migration_version, '2.5.6', '>=')) {
909	return;
910	}
911
912	$table_name = $wpdb->prefix . 'mxchat_system_prompt_content';
913
914	// Check if table exists
915	if ($wpdb->get_var("SHOW TABLES LIKE '{$table_name}'") != $table_name) {
916	return;
917	}
918
919	// Check if content_type column already exists
920	$column_exists = $wpdb->get_results("SHOW COLUMNS FROM {$table_name} LIKE 'content_type'");
921
922	if (empty($column_exists)) {
923	// Add content_type column with default value 'content' for backwards compatibility
924	$wpdb->query("ALTER TABLE {$table_name} ADD COLUMN content_type VARCHAR(50) DEFAULT 'content' AFTER role_restriction");
925
926	// Add index for better query performance
927	$wpdb->query("ALTER TABLE {$table_name} ADD KEY content_type (content_type)");
928
929	//error_log('MxChat: Successfully added content_type column to mxchat_system_prompt_content table');
930	}
931
932	// Mark migration as complete
933	update_option('mxchat_content_type_migration_version', '2.5.6');
934	}
935
936	/**
937	* 3.2.4: Backfill the active embedding model option for installs that already
938	* have KB content but no stamped model. The mismatch warning compares this
939	* against the user's currently selected model — no per-row column needed.
940	*/
941	function mxchat_backfill_active_embedding_model() {
942	global $wpdb;
943
944	if (get_option('mxchat_active_embedding_model', '') !== '') {
945	return;
946	}
947
948	$kb_table = $wpdb->prefix . 'mxchat_system_prompt_content';
949	if ($wpdb->get_var("SHOW TABLES LIKE '{$kb_table}'") !== $kb_table) {
950	return;
951	}
952
953	$kb_count = (int) $wpdb->get_var("SELECT COUNT(*) FROM {$kb_table}");
954	if ($kb_count > 0) {
955	$options = get_option('mxchat_options', array());
956	$current_model = $options['embedding_model'] ?? 'text-embedding-ada-002';
957	update_option('mxchat_active_embedding_model', $current_model, false);
958	}
959	}
960
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	/**
1020	* 2.5.2: Create queue processing tables for reliable background processing
1021	*/
1022	function mxchat_create_queue_tables() {
1023	global $wpdb;
1024	$charset_collate = $wpdb->get_charset_collate();
1025
1026	// Main queue table
1027	$queue_table = $wpdb->prefix . 'mxchat_processing_queue';
1028	$sql_queue = "CREATE TABLE $queue_table (
1029	id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1030	queue_id varchar(64) NOT NULL,
1031	item_type varchar(20) NOT NULL,
1032	item_data longtext NOT NULL,
1033	status varchar(20) NOT NULL DEFAULT 'pending',
1034	bot_id varchar(50) NOT NULL DEFAULT 'default',
1035	priority int(11) NOT NULL DEFAULT 0,
1036	attempts int(11) NOT NULL DEFAULT 0,
1037	max_attempts int(11) NOT NULL DEFAULT 3,
1038	error_message text DEFAULT NULL,
1039	created_at datetime NOT NULL,
1040	started_at datetime DEFAULT NULL,
1041	completed_at datetime DEFAULT NULL,
1042	PRIMARY KEY (id),
1043	KEY queue_id (queue_id),
1044	KEY status (status),
1045	KEY item_type (item_type),
1046	KEY priority (priority)
1047	) $charset_collate;";
1048
1049	// Queue metadata table
1050	$meta_table = $wpdb->prefix . 'mxchat_queue_meta';
1051	$sql_meta = "CREATE TABLE $meta_table (
1052	id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1053	queue_id varchar(64) NOT NULL,
1054	meta_key varchar(255) NOT NULL,
1055	meta_value longtext,
1056	PRIMARY KEY (id),
1057	KEY queue_id (queue_id),
1058	KEY meta_key (meta_key)
1059	) $charset_collate;";
1060
1061	require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
1062	dbDelta($sql_queue);
1063	dbDelta($sql_meta);
1064
1065	//error_log("MxChat: Queue tables created/updated successfully");
1066	}
1067
1068	/**
1069	* Create transcript translations table for persisting translations
1070	*/
1071	function mxchat_create_translations_table() {
1072	global $wpdb;
1073	$charset_collate = $wpdb->get_charset_collate();
1074
1075	$table_name = $wpdb->prefix . 'mxchat_transcript_translations';
1076	$sql = "CREATE TABLE $table_name (
1077	id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1078	session_id varchar(255) NOT NULL,
1079	language_code varchar(10) NOT NULL,
1080	translations longtext NOT NULL,
1081	created_at datetime NOT NULL,
1082	updated_at datetime NOT NULL,
1083	PRIMARY KEY (id),
1084	UNIQUE KEY session_lang (session_id, language_code),
1085	KEY session_id (session_id)
1086	) $charset_collate;";
1087
1088	require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
1089	dbDelta($sql);
1090	}
1091
1092	/**
1093	* Create per-session satisfaction ratings table (v3.2.6)
1094	* Stores one 👍/👎 rating + optional feedback per chat session.
1095	*/
1096	function mxchat_create_session_ratings_table() {
1097	global $wpdb;
1098	$charset_collate = $wpdb->get_charset_collate();
1099
1100	$table_name = $wpdb->prefix . 'mxchat_session_ratings';
1101	$sql = "CREATE TABLE $table_name (
1102	id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1103	session_id varchar(255) NOT NULL,
1104	bot_id varchar(50) NOT NULL DEFAULT 'default',
1105	rating_value tinyint(1) NOT NULL,
1106	rating_feedback text DEFAULT NULL,
1107	created_at datetime NOT NULL,
1108	PRIMARY KEY (id),
1109	UNIQUE KEY session_id (session_id),
1110	KEY bot_id (bot_id),
1111	KEY created_at (created_at)
1112	) $charset_collate;";
1113
1114	require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
1115	dbDelta($sql);
1116	}
1117
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	/**
1152	* 2.5.2: Fix URL column size to support long URLs (especially with UTF-8 encoding)
1153	* This fixes "url, source_url. The supplied values may be too long" errors
1154	*/
1155	function mxchat_fix_url_column_size() {
1156	global $wpdb;
1157	$table_name = $wpdb->prefix . 'mxchat_system_prompt_content';
1158
1159	// Check if table exists
1160	$table_exists = $wpdb->get_var("SHOW TABLES LIKE '$table_name'") === $table_name;
1161	if (!$table_exists) {
1162	return;
1163	}
1164
1165	// Change url and source_url from VARCHAR to TEXT to handle long URLs
1166	// This is especially important for URLs with UTF-8 encoded characters (Hebrew, Arabic, etc.)
1167	$wpdb->query("ALTER TABLE {$table_name} MODIFY COLUMN url TEXT");
1168	$wpdb->query("ALTER TABLE {$table_name} MODIFY COLUMN source_url TEXT");
1169
1170	//error_log("MxChat: Successfully updated url and source_url columns to TEXT type for long URL support");
1171	}
1172
1173	/**
1174	* Migrate deprecated AI models to their replacements
1175	* Version 2.5.1: Migrate Claude 3.5 Sonnet (deprecated) to Claude 3.7 Sonnet
1176	* Version 3.1.2: Convert chat transcripts table to utf8mb4 for emoji support
1177	* Without utf8mb4, any bot response containing emojis silently fails to insert.
1178	*/
1179	function mxchat_migrate_transcripts_charset() {
1180	global $wpdb;
1181	$table_name = $wpdb->prefix . 'mxchat_chat_transcripts';
1182	$wpdb->query("ALTER TABLE $table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci");
1183	}
1184
1185	/**
1186	* Version 3.0.55: Migrate GPT-4 series models (deprecated 2026-02-17) to GPT-5 series
1187	*/
1188	function mxchat_migrate_deprecated_models() {
1189	$options = get_option('mxchat_options', array());
1190	$migrated = false;
1191	$migration_message = '';
1192
1193	if (!isset($options['model'])) {
1194	return;
1195	}
1196
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
1203	}
1204	$map = MxChat_Model_Catalog::retired_model_map();
1205
1206	$current_model = $options['model'];
1207	if (isset($map[$current_model])) {
1208	$entry = $map[$current_model];
1209	$options['model'] = $entry['to'];
1210	$migrated = true;
1211	$migration_message = sprintf(
1212	'Your chatbot model has been automatically updated from %s to %s %s.',
1213	$current_model,
1214	$entry['label'],
1215	$entry['reason']
1216	);
1217	}
1218
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'];
1227	$migrated = true;
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	));
1234	}
1235
1236	if ($migrated) {
1237	update_option('mxchat_options', $options);
1238	update_option('mxchat_model_migrated_notice', true);
1239	update_option('mxchat_model_migration_message', $migration_message);
1240	}
1241	}
1242
1243	/**
1244	* Show admin notice after model migration
1245	*/
1246	function mxchat_show_migration_notice() {
1247	if (get_option('mxchat_model_migrated_notice')) {
1248	$migration_message = get_option('mxchat_model_migration_message', __('Your chatbot model has been automatically updated due to a model deprecation.', 'mxchat'));
1249	?>
1250	<div class="notice notice-info is-dismissible">
1251	<p>
1252	<strong><?php esc_html_e('MxChat Model Updated', 'mxchat'); ?></strong><br>
1253	<?php echo esc_html($migration_message); ?>
1254	</p>
1255	</div>
1256	<?php
1257	delete_option('mxchat_model_migrated_notice');
1258	delete_option('mxchat_model_migration_message');
1259	}
1260	}
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
1354	function mxchat_activate() {
1355	global $wpdb;
1356	$charset_collate = $wpdb->get_charset_collate();
1357
1358	//error_log("MxChat: Running activation function");
1359
1360	// Create chat transcripts table with improved function
1361	mxchat_create_chat_transcripts_table();
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
1367	// System Prompt Content Table - UPDATED: Use TEXT for url and source_url columns
1368	$system_prompt_table = $wpdb->prefix . 'mxchat_system_prompt_content';
1369	$sql_system_prompt = "CREATE TABLE $system_prompt_table (
1370	id MEDIUMINT(9) NOT NULL AUTO_INCREMENT,
1371	url TEXT NOT NULL,
1372	article_content LONGTEXT NOT NULL,
1373	embedding_vector LONGTEXT,
1374	source_url TEXT DEFAULT NULL,
1375	role_restriction VARCHAR(50) DEFAULT 'public',
1376	content_type VARCHAR(50) DEFAULT 'content',
1377	timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
1378	PRIMARY KEY (id),
1379	KEY content_type (content_type)
1380	) $charset_collate;";
1381
1382	// Intents Table - NOW INCLUDES enabled_bots column from the start
1383	$intents_table = $wpdb->prefix . 'mxchat_intents';
1384	$sql_intents_table = "CREATE TABLE $intents_table (
1385	id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
1386	intent_label VARCHAR(255) NOT NULL,
1387	phrases TEXT NOT NULL,
1388	embedding_vector LONGTEXT NOT NULL,
1389	callback_function VARCHAR(255) NOT NULL,
1390	similarity_threshold FLOAT DEFAULT 0.85,
1391	enabled TINYINT(1) NOT NULL DEFAULT 1,
1392	enabled_bots LONGTEXT DEFAULT NULL,
1393	PRIMARY KEY (id)
1394	) $charset_collate;";
1395
1396	// Individual Intent Phrases Table - each phrase gets its own embedding vector
1397	$intent_phrases_table = $wpdb->prefix . 'mxchat_intent_phrases';
1398	$sql_intent_phrases_table = "CREATE TABLE $intent_phrases_table (
1399	id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
1400	intent_id BIGINT(20) UNSIGNED NOT NULL,
1401	phrase TEXT NOT NULL,
1402	embedding_vector LONGTEXT NOT NULL,
1403	created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
1404	PRIMARY KEY (id),
1405	KEY intent_id (intent_id)
1406	) $charset_collate;";
1407
1408	require_once ABSPATH . 'wp-admin/includes/upgrade.php';
1409
1410	// Create other tables
1411	dbDelta($sql_system_prompt);
1412	dbDelta($sql_intents_table);
1413	dbDelta($sql_intent_phrases_table);
1414
1415	// Create URL click tracking table
1416	mxchat_create_url_clicks_table();
1417
1418	// Create Pinecone roles table
1419	mxchat_create_pinecone_roles_table();
1420
1421	// NEW 2.5.2: Create queue processing tables
1422	mxchat_create_queue_tables();
1423
1424	// Create transcript translations table
1425	mxchat_create_translations_table();
1426
1427	// Create per-session satisfaction ratings table (v3.2.6)
1428	mxchat_create_session_ratings_table();
1429
1430	// Create Vector Store file-mapping table (v3.2.20, plan 15b5c6)
1431	mxchat_create_vectorstore_files_table();
1432
1433	// Ensure additional columns in system prompt table
1434	$existing_system_columns = $wpdb->get_results("SHOW COLUMNS FROM $system_prompt_table");
1435	if (!empty($existing_system_columns)) {
1436	$existing_system_column_names = array_column($existing_system_columns, 'Field');
1437
1438	if (!in_array('embedding_vector', $existing_system_column_names)) {
1439	$wpdb->query("ALTER TABLE $system_prompt_table ADD COLUMN embedding_vector LONGTEXT");
1440	}
1441	if (!in_array('source_url', $existing_system_column_names)) {
1442	$wpdb->query("ALTER TABLE $system_prompt_table ADD COLUMN source_url TEXT DEFAULT NULL");
1443	}
1444	if (!in_array('role_restriction', $existing_system_column_names)) {
1445	$wpdb->query("ALTER TABLE $system_prompt_table ADD COLUMN role_restriction VARCHAR(50) DEFAULT 'public' AFTER source_url");
1446	}
1447	}
1448
1449	// Set default thresholds for existing intents
1450	$wpdb->query("UPDATE {$intents_table} SET similarity_threshold = 0.85 WHERE similarity_threshold IS NULL");
1451
1452	// Ensure enabled column exists in intents table
1453	$existing_intent_columns = $wpdb->get_results("SHOW COLUMNS FROM $intents_table");
1454	if (!empty($existing_intent_columns)) {
1455	$existing_intent_column_names = array_column($existing_intent_columns, 'Field');
1456
1457	if (!in_array('enabled', $existing_intent_column_names)) {
1458	$wpdb->query("ALTER TABLE $intents_table ADD COLUMN enabled TINYINT(1) NOT NULL DEFAULT 1");
1459	}
1460
1461	// Ensure enabled_bots column exists for existing installations
1462	if (!in_array('enabled_bots', $existing_intent_column_names)) {
1463	$wpdb->query("ALTER TABLE $intents_table ADD COLUMN enabled_bots LONGTEXT DEFAULT NULL AFTER enabled");
1464
1465	// Set existing actions to work with default bot
1466	$default_bots = json_encode(['default']);
1467	$wpdb->query($wpdb->prepare(
1468	"UPDATE {$intents_table} SET enabled_bots = %s WHERE enabled_bots IS NULL",
1469	$default_bots
1470	));
1471	}
1472	}
1473
1474	// Run migration for existing installations
1475	mxchat_migrate_pinecone_roles_add_bot_id();
1476
1477	// 3.2.4: Backfill active embedding model option (replaces 3.2.3 column-based tracking)
1478	mxchat_backfill_active_embedding_model();
1479
1480	// Setup cron jobs
1481	mxchat_setup_cron_jobs();
1482
1483	// Update version (stable base version — never the dev time()-suffixed one,
1484	// or the check_for_update comparison would churn every request)
1485	update_option('mxchat_plugin_version', MXCHAT_BASE_VERSION);
1486
1487	//error_log("MxChat: Activation function completed");
1488	}
1489
1490	/**
1491	* Setup cron jobs on plugin activation
1492	*/
1493	function mxchat_setup_cron_jobs() {
1494	// Clear any existing cron jobs first
1495	wp_clear_scheduled_hook('mxchat_reset_rate_limits');
1496
1497	// Check if WordPress cron is disabled
1498	if (defined('DISABLE_WP_CRON') && DISABLE_WP_CRON) {
1499	// Set flag to use fallback system
1500	update_option('mxchat_use_fallback_rate_limits', true);
1501	update_option('mxchat_next_rate_limit_check', time() + 3600);
1502	// Deliberately NO early return (plan-bc08a6): transcript cleanup below
1503	// must still be scheduled. DISABLE_WP_CRON only changes HOW cron events
1504	// execute (a server-side runner hitting wp-cron.php instead of loopback
1505	// spawns) — scheduling still just writes the cron option. The old early
1506	// return here meant a deactivate/reactivate cycle on a DISABLE_WP_CRON
1507	// site permanently lost the transcript cleanup event while the retention
1508	// setting still claimed to be active.
1509	} else {
1510	// Schedule the rate limit reset cron job
1511	$result = wp_schedule_event(time() + 300, 'hourly', 'mxchat_reset_rate_limits');
1512
1513	if ($result === false) {
1514	// Fallback if scheduling fails
1515	update_option('mxchat_use_fallback_rate_limits', true);
1516	update_option('mxchat_next_rate_limit_check', time() + 3600);
1517	} else {
1518	// Clear fallback flags if cron scheduling succeeded
1519	delete_option('mxchat_use_fallback_rate_limits');
1520	}
1521	}
1522
1523	// Schedule transcript cleanup if configured (bucket dropdown OR custom retention-days > 0)
1524	$transcript_options = get_option('mxchat_transcripts_options', array());
1525	$cleanup_interval = isset($transcript_options['mxchat_auto_delete_transcripts']) ? $transcript_options['mxchat_auto_delete_transcripts'] : 'never';
1526	$custom_retention = isset($transcript_options['mxchat_retention_days']) ? (int) $transcript_options['mxchat_retention_days'] : 0;
1527
1528	if ($cleanup_interval !== 'never' \|\| $custom_retention > 0) {
1529	// Check if not already scheduled
1530	if (!wp_next_scheduled('mxchat_cleanup_old_transcripts')) {
1531	// Schedule to run daily at 3 AM
1532	$next_run = strtotime('tomorrow 3:00 AM');
1533	wp_schedule_event($next_run, 'daily', 'mxchat_cleanup_old_transcripts');
1534	}
1535	}
1536	}
1537
1538	/**
1539	* Clean up on plugin deactivation
1540	*/
1541	function mxchat_deactivate() {
1542	// Clear scheduled cron jobs
1543	wp_clear_scheduled_hook('mxchat_reset_rate_limits');
1544	wp_clear_scheduled_hook('mxchat_cleanup_old_transcripts');
1545	wp_clear_scheduled_hook('mxchat_send_delayed_transcript');
1546	wp_clear_scheduled_hook('mxchat_model_liveness_check');
1547
1548	// Clear fallback options
1549	delete_option('mxchat_use_fallback_rate_limits');
1550	delete_option('mxchat_next_rate_limit_check');
1551	delete_option('mxchat_fallback_check_interval');
1552
1553	// NOTE: We do NOT delete queue tables on deactivation
1554	// This preserves data if user accidentally deactivates the plugin
1555	}
1556
1557	/**
1558	* Check if fallback rate limit cleanup is needed
1559	*/
1560	function mxchat_check_fallback_rate_limits() {
1561	$use_fallback = get_option('mxchat_use_fallback_rate_limits', false);
1562
1563	if (!$use_fallback) {
1564	return;
1565	}
1566
1567	$next_check = get_option('mxchat_next_rate_limit_check', 0);
1568
1569	if (time() >= $next_check) {
1570	// Reuse the bootstrap's integrator — mxchat_init() creates the global on
1571	// plugins_loaded (before this init-priority-5 callback), so it's always set
1572	// here. Constructing a second MxChat_Integrator just to call one method
1573	// re-registers every hook the plugin has (ajax pairs, wp_footer loader,
1574	// rest_api_init, admin_init guard) on a duplicate instance for the rest of
1575	// the request. Defensive construction only if the global is somehow unset.
1576	// NOTE: MxChat_Integrator::check_fallback_rate_limits() is a second
1577	// implementation of this same check — if either changes, change both.
1578	global $mxchat_integrator;
1579	$integrator = ($mxchat_integrator instanceof MxChat_Integrator)
1580	? $mxchat_integrator
1581	: (class_exists('MxChat_Integrator') ? new MxChat_Integrator() : null);
1582	if ($integrator && method_exists($integrator, 'mxchat_reset_rate_limits')) {
1583	$integrator->mxchat_reset_rate_limits();
1584	update_option('mxchat_next_rate_limit_check', time() + 3600);
1585	}
1586	}
1587	}
1588
1589	/**
1590	* Robust update checking with role restriction migration, model deprecation, and queue tables
1591	* CRITICAL: This runs on EVERY page load to ensure tables exist
1592	*/
1593	function mxchat_check_for_update() {
1594	global $wpdb;
1595
1596	try {
1597	$current_version = get_option('mxchat_plugin_version', '0.0.0');
1598	$plugin_version = MXCHAT_BASE_VERSION;
1599
1600	// Always ensure critical tables exist (even if version matches)
1601	// This handles manual table deletion or fresh installs
1602	$chat_table = $wpdb->prefix . 'mxchat_chat_transcripts';
1603	$queue_table = $wpdb->prefix . 'mxchat_processing_queue';
1604
1605	$sessions_table = $wpdb->prefix . 'mxchat_sessions';
1606
1607	$chat_exists = $wpdb->get_var("SHOW TABLES LIKE '$chat_table'") === $chat_table;
1608	$queue_exists = $wpdb->get_var("SHOW TABLES LIKE '$queue_table'") === $queue_table;
1609	$sessions_exists = get_option('mxchat_session_store_ready') === '1'
1610	\|\| $wpdb->get_var("SHOW TABLES LIKE '$sessions_table'") === $sessions_table;
1611
1612	if (!$chat_exists \|\| !$queue_exists \|\| !$sessions_exists) {
1613	//error_log("MxChat: Critical tables missing, running activation");
1614	mxchat_activate();
1615	}
1616
1617	// Version-specific migrations
1618	if ($current_version !== $plugin_version) {
1619	//error_log("MxChat: Version change detected: $current_version -> $plugin_version");
1620
1621	// Run live agent update BEFORE updating the stored version
1622	mxchat_handle_live_agent_update();
1623
1624	// Run theme migration notice for 3.0.1 (AI theme CSS structure changes)
1625	mxchat_handle_theme_migration_notice();
1626
1627	// Run role restriction migration for 2.4.1
1628	if (version_compare($current_version, '2.4.1', '<')) {
1629	mxchat_add_role_restriction_column();
1630	}
1631
1632	// Run enabled_bots column migration for 2.4.4
1633	if (version_compare($current_version, '2.4.4', '<')) {
1634	mxchat_add_enabled_bots_column();
1635	}
1636
1637	// Run model migration for 2.5.1 (Claude deprecation)
1638	if (version_compare($current_version, '2.5.1', '<')) {
1639	mxchat_migrate_deprecated_models();
1640	}
1641
1642	// 2.5.2: Ensure queue tables exist and fix URL column sizes for all users upgrading to 2.5.2
1643	if (version_compare($current_version, '2.5.2', '<')) {
1644	mxchat_create_queue_tables();
1645	mxchat_fix_url_column_size(); // NEW: Fix URL column size for long URLs
1646	//error_log("MxChat: Queue tables created and URL columns updated for upgrade to 2.5.2");
1647	}
1648
1649	// 2.6.0: Ensure rag_context column exists for retrieved documents feature
1650	if (version_compare($current_version, '2.6.0', '<')) {
1651	$chat_table = $wpdb->prefix . 'mxchat_chat_transcripts';
1652	mxchat_ensure_all_columns($chat_table);
1653	//error_log("MxChat: rag_context column migration for 2.6.0");
1654	}
1655
1656	// 3.0.5: Migrate deprecated Gemini embedding model
1657	if (version_compare($current_version, '3.0.5', '<')) {
1658	mxchat_migrate_gemini_embedding_model();
1659	}
1660
1661	// 3.0.6: Migrate deprecated OpenAI and Claude models
1662	if (version_compare($current_version, '3.0.6', '<')) {
1663	mxchat_migrate_deprecated_models();
1664	}
1665
1666	// 3.1.2: Convert chat transcripts table to utf8mb4 for emoji support
1667	if (version_compare($current_version, '3.1.2', '<')) {
1668	mxchat_migrate_transcripts_charset();
1669	}
1670
1671	// 3.1.7: Clean up stale shared session email/name entries
1672	if (version_compare($current_version, '3.1.7', '<')) {
1673	delete_option('mxchat_email_null');
1674	delete_option('mxchat_name_null');
1675	}
1676
1677	// 3.2.4: Backfill active embedding model option for the warning UI
1678	// (replaces the per-row column tracking from 3.2.3, which was reverted)
1679	if (version_compare($current_version, '3.2.4', '<')) {
1680	mxchat_backfill_active_embedding_model();
1681	}
1682
1683	// 3.2.15: Migrate retired DeepSeek ids (deepseek-chat / deepseek-reasoner
1684	// were shut off at the vendor on 2026-07-24). The function is idempotent —
1685	// it only rewrites models on its deprecation lists.
1686	if (version_compare($current_version, '3.2.15', '<')) {
1687	mxchat_migrate_deprecated_models();
1688	}
1689
1690	// 3.2.16: Migrate OpenAI ids retiring 2026-08-10 (gpt-5.1-chat-latest /
1691	// gpt-5.3-chat-latest → gpt-5.6-sol per OpenAI's deprecations page).
1692	// Idempotent — only rewrites models on the deprecation lists (e46b8f).
1693	if (version_compare($current_version, '3.2.16', '<')) {
1694	mxchat_migrate_deprecated_models();
1695	}
1696
1697	// 3.2.17: Credential options must not autoload (af2400) — the two
1698	// Pinecone-secret-holding rows were in alloptions, i.e. read into
1699	// memory on every request including anonymous page views. Idempotent.
1700	// Also carry the import modal's remembered ACF→PDF checkbox state
1701	// into the new install-level option (11720c).
1702	if (version_compare($current_version, '3.2.17', '<')) {
1703	mxchat_fix_credential_option_autoload();
1704	mxchat_migrate_acf_pdf_extraction_option();
1705	}
1706
1707	// 3.2.19: Claude Opus 4.1 retired Aug 5, 2026 — auto-move stranded
1708	// sites (and the older tiers on the migration's lists) per the
1709	// changelog's promise. Idempotent — only rewrites models on the
1710	// deprecation lists. Without a gate at this release's version,
1711	// nothing calls the migration for 3.2.18 upgraders (plan a5a598;
1712	// the gate value must equal the version this block ships in).
1713	if (version_compare($current_version, '3.2.19', '<')) {
1714	mxchat_migrate_deprecated_models();
1715	}
1716
1717	// 3.2.20: Seed the caee10 usage-hint defaults onto tool entries a
1718	// pre-3.2.20 autosave stamped with '' (plan 64c1ad). The gate value
1719	// equals the version this block ships in (a5a598 rule); the
1720	// function carries its own one-time marker on top.
1721	// Also re-run the deprecated-models migration: 202df5 widened it to
1722	// rescue a content_model stranded on ANY retired id (previously
1723	// only the two gpt-5.x-chat-latest aliases). Idempotent — only
1724	// rewrites models on the catalog's retired_model_map().
1725	if (version_compare($current_version, '3.2.20', '<')) {
1726	mxchat_backfill_tool_hint_defaults();
1727	mxchat_migrate_deprecated_models();
1728	}
1729
1730	// Run full activation to ensure everything is up to date
1731	mxchat_activate();
1732
1733	// Run migration functions
1734	mxchat_migrate_live_agent_status();
1735
1736	// (The 2.1.8 orphaned-history reconciliation sweep is gone —
1737	// 3.2.19's mxchat_history_backlog_* drain supersedes it, and it
1738	// self-arms without a version gate: plan 839c4c.)
1739
1740	// Update version LAST
1741	update_option('mxchat_plugin_version', $plugin_version);
1742
1743	//error_log("MxChat: Updated from version $current_version to $plugin_version");
1744	}
1745
1746	} catch (Exception $e) {
1747	//error_log('MxChat update error: ' . $e->getMessage());
1748	// Don't update version if there was an error
1749	}
1750	}
1751
1752	/**
1753	* Credential options must never enter the autoloaded alloptions set.
1754	* mxchat_prompts_options and mxchat_pinecone_addon_options can hold the
1755	* Pinecone API secret; mxchat_options already stores its keys with autoload
1756	* off and these two must match it. The filter covers every future
1757	* add_option()/update_option() that creates the row — Settings API saves
1758	* through options.php and WP-CLI included — on WP 6.6+; older cores are
1759	* covered by the explicit autoload arguments at the plugin's own write
1760	* sites plus the one-time migration below.
1761	*/
1762	add_filter('wp_default_autoload_value', 'mxchat_credential_option_autoload_value', 10, 2);
1763	function mxchat_credential_option_autoload_value($autoload, $option) {
1764	if (in_array($option, array('mxchat_prompts_options', 'mxchat_pinecone_addon_options'), true)) {
1765	return false;
1766	}
1767	return $autoload;
1768	}
1769
1770	/**
1771	* One-time upgrade migration: flip the autoload flag on credential option
1772	* rows that existing installs are already carrying autoloaded. Includes
1773	* mxchat_adv_api_token (Advanced Content bearer token) — harmless no-op
1774	* when that add-on is not installed, since missing rows simply don't match.
1775	*/
1776	function mxchat_fix_credential_option_autoload() {
1777	$keys = array('mxchat_prompts_options', 'mxchat_pinecone_addon_options', 'mxchat_adv_api_token');
1778	if (function_exists('wp_set_option_autoload_values')) {
1779	wp_set_option_autoload_values(array_fill_keys($keys, false));
1780	return;
1781	}
1782	// Pre-WP-6.4 fallback: direct flip + cache invalidation.
1783	global $wpdb;
1784	$placeholders = implode(',', array_fill(0, count($keys), '%s'));
1785	$wpdb->query($wpdb->prepare("UPDATE {$wpdb->options} SET autoload = 'no' WHERE option_name IN ($placeholders)", $keys));
1786	wp_cache_delete('alloptions', 'options');
1787	foreach ($keys as $key) {
1788	wp_cache_delete($key, 'options');
1789	}
1790	}
1791
1792	/**
1793	* One-time carry of the import modal's remembered ACF→PDF checkbox state
1794	* (mxchat_options['acf_pdf_extract_default'], written per-import until 3.2.16)
1795	* into the new install-level option mxchat_acf_pdf_extraction (plan 11720c).
1796	* Fresh installs and installs that never touched the checkbox default OFF,
1797	* matching the setting's own "recommended only if…" guidance.
1798	*/
1799	function mxchat_migrate_acf_pdf_extraction_option() {
1800	if (get_option('mxchat_acf_pdf_extraction', null) !== null) {
1801	return; // already set — never overwrite an owner's choice
1802	}
1803	$mxchat_options = get_option('mxchat_options', array());
1804	if (is_array($mxchat_options) && array_key_exists('acf_pdf_extract_default', $mxchat_options)) {
1805	update_option('mxchat_acf_pdf_extraction', !empty($mxchat_options['acf_pdf_extract_default']) ? '1' : '0', false);
1806	unset($mxchat_options['acf_pdf_extract_default']);
1807	update_option('mxchat_options', $mxchat_options);
1808	}
1809	}
1810
1811	/**
1812	* One-time migration of mxchat_acf_excluded_fields from field NAMES to field
1813	* KEYS (plan 30e81f). Names are not unique across ACF groups, so two fields
1814	* named the same in different groups shared one toggle, one saved state, and
1815	* one exclusion — and the save-on-exit beacon could revert a save through the
1816	* twin. Keys are unique; everything now runs on them.
1817	*
1818	* MIGRATION DIRECTION IS DELIBERATE: one stored name can match several keys —
1819	* exclude EVERY one of them. The UI describes these as "sensitive or
1820	* irrelevant fields"; an under-migration would silently start feeding a
1821	* previously-excluded sensitive field into embeddings sent to a third-party
1822	* provider. Over-excluding is visible in the UI and costs some retrieval
1823	* quality; under-excluding is a silent privacy regression.
1824	*
1825	* Self-arming on acf/init (NOT the version-gated upgrade block): resolving
1826	* names needs ACF fully booted with local JSON/PHP groups registered, and if
1827	* ACF is deactivated at upgrade time the migration simply waits for the next
1828	* load with ACF active. Until it runs, stored names keep working — every
1829	* exclusion read site honors legacy name entries alongside keys. A name that
1830	* matches no current key is KEPT (its group may be temporarily inactive), and
1831	* the per-field include path lazily converts it if it ever resolves again.
1832	*/
1833	function mxchat_migrate_acf_exclusions_to_keys() {
1834	if (get_option('mxchat_acf_exclusions_migrated', '') === '1') {
1835	return;
1836	}
1837	$stored = get_option('mxchat_acf_excluded_fields', array());
1838	if (!is_array($stored) \|\| empty($stored)) {
1839	update_option('mxchat_acf_exclusions_migrated', '1', false);
1840	return;
1841	}
1842	if (!function_exists('acf_get_field_groups') \|\| !function_exists('acf_get_fields')) {
1843	return; // acf/init fired without the API? Bail; retry next load.
1844	}
1845
1846	// Map every current top-level field: name => [keys], and the set of keys.
1847	$name_to_keys = array();
1848	$current_keys = array();
1849	foreach (acf_get_field_groups() as $group) {
1850	$group_fields = acf_get_fields($group['key']);
1851	if (empty($group_fields)) {
1852	continue;
1853	}
1854	foreach ($group_fields as $field) {
1855	if (empty($field['key']) \|\| !isset($field['name'])) {
1856	continue;
1857	}
1858	$current_keys[$field['key']] = true;
1859	$name_to_keys[$field['name']][] = $field['key'];
1860	}
1861	}
1862
1863	$migrated = array();
1864	$converted = 0;
1865	foreach ($stored as $entry) {
1866	if (!is_string($entry) \|\| $entry === '') {
1867	continue;
1868	}
1869	if (isset($current_keys[$entry])) {
1870	$migrated[] = $entry; // already a live key
1871	} elseif (isset($name_to_keys[$entry])) {
1872	foreach ($name_to_keys[$entry] as $key) {
1873	$migrated[] = $key; // every key wearing this name — fail toward more exclusion
1874	}
1875	$converted++;
1876	} else {
1877	$migrated[] = $entry; // unresolved — keep; still honored by name everywhere
1878	}
1879	}
1880	$migrated = array_values(array_unique($migrated));
1881
1882	update_option('mxchat_acf_excluded_fields', $migrated);
1883	update_option('mxchat_acf_exclusions_migrated', '1', false);
1884	if ($converted > 0) {
1885	update_option('mxchat_acf_exclusions_migrated_notice', '1', false);
1886	}
1887	}
1888	add_action('acf/init', 'mxchat_migrate_acf_exclusions_to_keys', 20);
1889
1890	/**
1891	* One-time notice after the ACF exclusion migration actually converted
1892	* name entries — the settings are worth a review, especially where one name
1893	* fanned out to several fields (every match is now excluded, on purpose).
1894	*/
1895	function mxchat_show_acf_exclusions_migrated_notice() {
1896	if (!current_user_can('manage_options')) {
1897	return;
1898	}
1899	if (get_option('mxchat_acf_exclusions_migrated_notice', '') !== '1') {
1900	return;
1901	}
1902	?>
1903	<div class="notice notice-info is-dismissible">
1904	<p>
1905	<strong><?php esc_html_e('MxChat: ACF field exclusions updated', 'mxchat'); ?></strong><br>
1906	<?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'); ?>
1907	</p>
1908	</div>
1909	<?php
1910	delete_option('mxchat_acf_exclusions_migrated_notice');
1911	}
1912	add_action('admin_notices', 'mxchat_show_acf_exclusions_migrated_notice');
1913
1914	/**
1915	* Ensure tables exist on every admin load for fresh installations
1916	* This is a safety net for cases where activation hook doesn't fire
1917	*/
1918	function mxchat_ensure_tables_exist() {
1919	global $wpdb;
1920
1921	// Only run for admin users to avoid performance impact
1922	if (!current_user_can('administrator')) {
1923	return;
1924	}
1925
1926	// Check if we've already verified tables in this session
1927	static $tables_checked = false;
1928	if ($tables_checked) {
1929	return;
1930	}
1931	$tables_checked = true;
1932
1933	$table_name = $wpdb->prefix . 'mxchat_chat_transcripts';
1934	$queue_table = $wpdb->prefix . 'mxchat_processing_queue';
1935
1936	$sessions_table = $wpdb->prefix . 'mxchat_sessions';
1937
1938	$chat_exists = $wpdb->get_var("SHOW TABLES LIKE '$table_name'") === $table_name;
1939	$queue_exists = $wpdb->get_var("SHOW TABLES LIKE '$queue_table'") === $queue_table;
1940	$sessions_exists = get_option('mxchat_session_store_ready') !== false
1941	\|\| $wpdb->get_var("SHOW TABLES LIKE '$sessions_table'") === $sessions_table;
1942
1943	if (!$chat_exists \|\| !$queue_exists \|\| !$sessions_exists) {
1944	//error_log("MxChat: Tables missing on admin load, running activation");
1945	mxchat_activate();
1946	}
1947	}
1948
1949	/**
1950	* One-shot cleanup of legacy mxchat_history_<sid> option rows (plan 839c4c).
1951	*
1952	* 3.2.19 deduplicated per-session chat history into the transcripts table
1953	* (which already held a superset of every option copy measured), so nothing
1954	* writes these options any more — but an upgraded install still carries one
1955	* per session, at up to 64 KB a row (462 rows measured on one production
1956	* install). This drain replaces the old mxchat_cleanup_orphaned_chat_history()
1957	* reconciliation sweep, which existed only because there were two copies to
1958	* reconcile.
1959	*
1960	* b64b77 pattern throughout: an option_id bookmark that only moves forward
1961	* (a crash mid-batch re-processes at most one batch), delete_option() per row
1962	* so the object + notoptions caches stay coherent, batches drained off
1963	* non-AJAX admin_init plus the session-store maintenance cron. Once the
1964	* backlog is gone the state marks done and every later call is one cached
1965	* option read.
1966	*/
1967	function mxchat_history_backlog_state() {
1968	// The state option name MUST NOT start with 'mxchat_history_' — the drain
1969	// deletes everything matching that prefix, and a state option inside the
1970	// pattern gets eaten by its own drain (caught by the 839c4c rig: batches
1971	// ran 2,2,2,1 instead of 2,2,1 because the bookmark row was being deleted
1972	// and re-created every pass).
1973	$state = get_option('mxchat_legacy_history_cleanup', array());
1974	if (!is_array($state)) {
1975	$state = array();
1976	}
1977
1978	return wp_parse_args($state, array(
1979	'done' => false,
1980	'last_option_id' => 0,
1981	'deleted' => 0,
1982	));
1983	}
1984
1985	/**
1986	* Delete one batch of legacy history options.
1987	*
1988	* @param int $batch Rows per pass — capped small; these can be 64 KB rows.
1989	* @return int Option rows deleted in this pass.
1990	*/
1991	function mxchat_history_backlog_batch($batch = 200) {
1992	global $wpdb;
1993
1994	$state = mxchat_history_backlog_state();
1995	if (!empty($state['done'])) {
1996	return 0;
1997	}
1998
1999	$batch = max(1, (int) $batch);
2000
2001	$rows = $wpdb->get_results(
2002	$wpdb->prepare(
2003	"SELECT option_id, option_name FROM {$wpdb->options}
2004	WHERE option_id > %d AND option_name LIKE %s
2005	ORDER BY option_id ASC LIMIT %d",
2006	(int) $state['last_option_id'],
2007	$wpdb->esc_like('mxchat_history_') . '%',
2008	$batch
2009	),
2010	ARRAY_A
2011	);
2012
2013	if (empty($rows)) {
2014	$state['done'] = true;
2015	update_option('mxchat_legacy_history_cleanup', $state, 'no');
2016	return 0;
2017	}
2018
2019	foreach ($rows as $row) {
2020	$state['last_option_id'] = max((int) $state['last_option_id'], (int) $row['option_id']);
2021	delete_option($row['option_name']);
2022	$state['deleted'] = (int) $state['deleted'] + 1;
2023	}
2024
2025	if (count($rows) < $batch) {
2026	$state['done'] = true;
2027	}
2028
2029	update_option('mxchat_legacy_history_cleanup', $state, 'no');
2030
2031	return count($rows);
2032	}
2033
2034	/** One batch per admin page load until drained. */
2035	function mxchat_history_backlog_drain() {
2036	mxchat_history_backlog_batch();
2037	}
2038
2039	/** Cron leg: drain faster, same cap per batch. */
2040	function mxchat_history_backlog_drain_cron() {
2041	for ($i = 0; $i < 10; $i++) {
2042	if (mxchat_history_backlog_batch() === 0) {
2043	break;
2044	}
2045	}
2046	}
2047
2048	// wp_doing_ajax() guard is load-bearing, not defensive (b64b77's shipped-and-
2049	// caught defect): admin-ajax.php fires admin_init too, and the chat widget's
2050	// message endpoint is an admin-ajax action — without the guard an anonymous
2051	// visitor would pay for a delete batch inside their own chat request.
2052	if (!wp_doing_ajax()) {
2053	add_action('admin_init', 'mxchat_history_backlog_drain', 21);
2054	}
2055	// Belt for installs whose admin is rarely visited: ride the session store's
2056	// existing daily maintenance event rather than scheduling another.
2057	add_action('mxchat_session_store_maintenance', 'mxchat_history_backlog_drain_cron');
2058
2059	function mxchat_migrate_live_agent_status() {
2060	$options = get_option('mxchat_options', []);
2061
2062	// Check if live_agent_status exists
2063	if (isset($options['live_agent_status'])) {
2064	$current_status = $options['live_agent_status'];
2065	$needs_update = false;
2066
2067	// Convert to new format if needed
2068	if ($current_status === 'online') {
2069	$options['live_agent_status'] = 'on';
2070	$needs_update = true;
2071	} else if ($current_status === 'offline') {
2072	$options['live_agent_status'] = 'off';
2073	$needs_update = true;
2074	} else if (!in_array($current_status, ['on', 'off'])) {
2075	// Default to off for any unexpected values
2076	$options['live_agent_status'] = 'off';
2077	$needs_update = true;
2078	}
2079
2080	// Only update if needed
2081	if ($needs_update) {
2082	update_option('mxchat_options', $options);
2083	}
2084	} else {
2085	// If status doesn't exist, set default to off
2086	$options['live_agent_status'] = 'off';
2087	update_option('mxchat_options', $options);
2088	}
2089	}
2090
2091	function mxchat_handle_live_agent_update() {
2092	// Get the CURRENT stored version (before it gets updated)
2093	$current_version = get_option('mxchat_plugin_version', '0.0.0');
2094	$new_version = '2.2.2';
2095
2096	// Only run this once for the update to 2.2.2
2097	$update_handled = get_option('mxchat_live_agent_update_2_2_2_handled', false);
2098
2099	// Check if we're upgrading TO 2.2.2 and haven't handled this yet
2100	if (version_compare($current_version, $new_version, '<') && !$update_handled) {
2101	$options = get_option('mxchat_options', array());
2102
2103	// Check if live agent was previously enabled
2104	if (isset($options['live_agent_status']) && $options['live_agent_status'] === 'on') {
2105	// Disable live agent
2106	$options['live_agent_status'] = 'off';
2107	update_option('mxchat_options', $options);
2108
2109	// Set flag to show the notification banner
2110	update_option('mxchat_show_live_agent_disabled_notice', true);
2111	}
2112
2113	// Mark this update as handled
2114	update_option('mxchat_live_agent_update_2_2_2_handled', true);
2115	}
2116	}
2117
2118	/**
2119	* Handle theme migration notice for version 3.0.1
2120	* Shows a dismissible notice to Pro users about migrating AI-generated themes
2121	*/
2122	function mxchat_handle_theme_migration_notice() {
2123	// Get the CURRENT stored version (before it gets updated)
2124	$current_version = get_option('mxchat_plugin_version', '0.0.0');
2125	$target_version = '3.0.1';
2126
2127	// Only run this once for the update to 3.0.1
2128	$update_handled = get_option('mxchat_theme_migration_update_3_0_1_handled', false);
2129
2130	// Check if we're upgrading TO 3.0.1 and haven't handled this yet
2131	if (version_compare($current_version, $target_version, '<') && !$update_handled) {
2132	// Check if Pro is activated - only show to Pro users
2133	$license_status = get_option('mxchat_license_status', 'inactive');
2134	$is_pro = ($license_status === 'active');
2135
2136	if ($is_pro) {
2137	// Set flag to show the theme migration notification banner
2138	update_option('mxchat_show_theme_migration_notice', true);
2139	}
2140
2141	// Mark this update as handled (whether Pro or not)
2142	update_option('mxchat_theme_migration_update_3_0_1_handled', true);
2143	}
2144	}
2145
2146	// Initialize plugin safely
2147	function mxchat_init() {
2148	// Include all class files first
2149	mxchat_include_classes();
2150
2151	// Run update check (this also ensures tables exist)
2152	mxchat_check_for_update();
2153
2154	// CRITICAL: Ensure tables exist on admin pages (safety net)
2155	add_action('admin_init', 'mxchat_ensure_tables_exist', 1);
2156
2157	// Add fallback rate limit check
2158	add_action('init', 'mxchat_check_fallback_rate_limits', 5);
2159
2160	// Add migration notice hook
2161	add_action('admin_notices', 'mxchat_show_migration_notice');
2162	add_action('admin_notices', 'mxchat_show_model_access_notice');
2163
2164	// Initialize classes with error handling
2165	try {
2166	// Initialize admin classes
2167	if (is_admin()) {
2168	if (class_exists('MxChat_Knowledge_Manager')) {
2169	$mxchat_knowledge_manager = new MxChat_Knowledge_Manager();
2170
2171	if (class_exists('MxChat_Admin')) {
2172	$mxchat_admin = new MxChat_Admin($mxchat_knowledge_manager);
2173	}
2174	}
2175
2176	// Initialize meta box class
2177	if (class_exists('MxChat_Meta_Box')) {
2178	new MxChat_Meta_Box();
2179	}
2180
2181	}
2182
2183	// Initialize content generator globally — it registers wp_head hook
2184	// for frontend CSS injection, plus wp_ajax_ hooks for admin.
2185	if (class_exists('MxChat_Content_Generator')) {
2186	new MxChat_Content_Generator();
2187	}
2188
2189	// Initialize cache purge globally — settings writes can happen on any
2190	// request type (admin screens, admin-ajax autosave, wp-cli), and the
2191	// deferred-purge cron event fires on front-end requests.
2192	if (class_exists('MxChat_Cache_Purge')) {
2193	MxChat_Cache_Purge::init();
2194	}
2195
2196	// Initialize REST API globally — endpoints must be registered on
2197	// every request (admin and frontend) so they're reachable via /wp-json/.
2198	// Endpoints are auth-gated and locked until the site owner generates
2199	// a token in MxChat → API Access.
2200	if (class_exists('MxChat_Rest_Api')) {
2201	new MxChat_Rest_Api();
2202	}
2203
2204	// Initialize public classes
2205	if (class_exists('MxChat_Public')) {
2206	$mxchat_public = new MxChat_Public();
2207	}
2208
2209	if (class_exists('MxChat_Integrator')) {
2210	global $mxchat_integrator;
2211	$mxchat_integrator = new MxChat_Integrator();
2212	}
2213
2214	} catch (Exception $e) {
2215	//error_log('MxChat initialization error: ' . $e->getMessage());
2216
2217	// Show admin notice if there's an error
2218	if (is_admin()) {
2219	add_action('admin_notices', function() use ($e) {
2220	echo '<div class="notice notice-error"><p>';
2221	echo '<strong>MxChat Error:</strong> Plugin initialization failed. ';
2222	echo 'Please check error logs or contact support. Error: ' . esc_html($e->getMessage());
2223	echo '</p></div>';
2224	});
2225	}
2226	}
2227	}
2228
2229	// Run initialization on plugins_loaded
2230	add_action('plugins_loaded', 'mxchat_init');
2231
2232	// Run migration check on admin init (for auto-updates without reactivation)
2233	add_action('admin_init', 'mxchat_check_and_run_migrations');
2234
2235	/**
2236	* Check and run migrations on admin init
2237	* This ensures migrations run even when plugin is auto-updated
2238	*/
2239	function mxchat_check_and_run_migrations() {
2240	// Only run in admin and not on every request
2241	static $checked = false;
2242	if ($checked) {
2243	return;
2244	}
2245	$checked = true;
2246
2247	mxchat_migrate_pinecone_roles_add_bot_id();
2248	mxchat_migrate_add_content_type_column();
2249	mxchat_migrate_add_translations_table();
2250	mxchat_migrate_add_session_ratings_table();
2251	}
2252
2253	/**
2254	* Migration: Create per-session satisfaction ratings table (v3.2.6)
2255	* For users upgrading from versions before 3.2.6
2256	*/
2257	function mxchat_migrate_add_session_ratings_table() {
2258	$migration_key = 'mxchat_session_ratings_table_created';
2259	if (get_option($migration_key)) {
2260	return;
2261	}
2262	mxchat_create_session_ratings_table();
2263	update_option($migration_key, '3.2.6');
2264	}
2265
2266	/**
2267	* Migration: Create transcript translations table (v3.0.4)
2268	* For users upgrading from versions before 3.0.4
2269	*/
2270	function mxchat_migrate_add_translations_table() {
2271	$migration_key = 'mxchat_translations_table_created';
2272
2273	// Check if migration already ran
2274	if (get_option($migration_key)) {
2275	return;
2276	}
2277
2278	// Create the translations table
2279	mxchat_create_translations_table();
2280
2281	// Mark migration as complete
2282	update_option($migration_key, '3.0.4');
2283	}
2284
2285	/**
2286	* Migration: Update deprecated Gemini embedding model (v3.0.5)
2287	* Updates gemini-embedding-exp-03-07 to gemini-embedding-001 for users who had it selected
2288	*/
2289	function mxchat_migrate_gemini_embedding_model() {
2290	$options = get_option('mxchat_options', array());
2291
2292	if (isset($options['embedding_model']) && $options['embedding_model'] === 'gemini-embedding-exp-03-07') {
2293	$options['embedding_model'] = 'gemini-embedding-001';
2294	update_option('mxchat_options', $options);
2295	}
2296	}
2297
2298	// Register activation hook
2299	register_activation_hook(__FILE__, 'mxchat_activate');
2300
2301	// Add cron schedule
2302	add_filter('cron_schedules', function($schedules) {
2303	$schedules['one_minute'] = array(
2304	'interval' => 60,
2305	'display' => 'Every Minute'
2306	);
2307	return $schedules;
2308	});
2309
2310	// Register deactivation hook
2311	register_deactivation_hook(__FILE__, 'mxchat_deactivate');
2312
2313	/**
2314	* Per-session satisfaction rating: AJAX save handler (v3.2.6).
2315	* Records one 👍/👎 + optional feedback per chat session. The UNIQUE KEY on
2316	* session_id makes this naturally idempotent — only the first rating per
2317	* session is stored; duplicate POSTs are silent no-ops.
2318	*/
2319	function mxchat_save_session_rating() {
2320	global $wpdb;
2321
2322	$session_id = isset($_POST['session_id']) ? MxChat_Utils::sanitize_session_id(wp_unslash($_POST['session_id'])) : '';
2323	$bot_id = isset($_POST['bot_id']) ? sanitize_text_field(wp_unslash($_POST['bot_id'])) : 'default';
2324	$rating_raw = isset($_POST['rating']) ? (int) $_POST['rating'] : 0;
2325	$feedback = isset($_POST['feedback']) ? sanitize_textarea_field(wp_unslash($_POST['feedback'])) : '';
2326
2327	if ($session_id === '' \|\| ($rating_raw !== 1 && $rating_raw !== -1)) {
2328	wp_send_json_error(array('message' => 'invalid_input'), 400);
2329	}
2330
2331	if (strlen($feedback) > 1000) {
2332	$feedback = substr($feedback, 0, 1000);
2333	}
2334
2335	$table_name = $wpdb->prefix . 'mxchat_session_ratings';
2336	$existing = $wpdb->get_var($wpdb->prepare(
2337	"SELECT id FROM $table_name WHERE session_id = %s LIMIT 1",
2338	$session_id
2339	));
2340
2341	if ($existing) {
2342	if ($feedback !== '') {
2343	$wpdb->update(
2344	$table_name,
2345	array('rating_feedback' => $feedback),
2346	array('id' => (int) $existing),
2347	array('%s'),
2348	array('%d')
2349	);
2350	}
2351	wp_send_json_success(array('updated' => true));
2352	}
2353
2354	$inserted = $wpdb->insert(
2355	$table_name,
2356	array(
2357	'session_id' => $session_id,
2358	'bot_id' => $bot_id !== '' ? $bot_id : 'default',
2359	'rating_value' => $rating_raw,
2360	'rating_feedback' => $feedback !== '' ? $feedback : null,
2361	'created_at' => current_time('mysql'),
2362	),
2363	array('%s', '%s', '%d', '%s', '%s')
2364	);
2365
2366	if ($inserted === false) {
2367	wp_send_json_error(array('message' => 'db_insert_failed'), 500);
2368	}
2369
2370	wp_send_json_success(array('saved' => true));
2371	}
2372	add_action('wp_ajax_mxchat_save_rating', 'mxchat_save_session_rating');
2373	add_action('wp_ajax_nopriv_mxchat_save_rating', 'mxchat_save_session_rating');