PluginProbe
MxChat – AI Chatbot & Content Generation for WordPress / 2.4.3
MxChat – AI Chatbot & Content Generation for WordPress v2.4.3
3.2.21 3.2.20 3.2.19 3.2.18 3.2.17 3.2.16 3.2.15 3.2.14 3.2.12 3.2.13 3.2.11 3.2.10 3.2.9 3.2.8 3.2.7 3.2.6 3.2.5 3.2.4 3.2.3 3.2.2 3.2.1 2.0.3 2.0.4 2.0.5 2.0.6 All 152 releases
← All changes | mxchat-basic.php +75 -1243 3.2.16 → 2.4.3 View file →
@@ -1,10 +1,9 @@
1 1 <?php
2 2 /**
3 3 * Plugin Name: MxChat
4 - * Plugin URI: https://mxchat.ai/
5 4 * Description: AI chatbot for WordPress with OpenAI, Claude, xAI, DeepSeek, live agent, PDF uploads, WooCommerce, and training on website data.
6 - * Version: 3.2.16
5 + * Version: 2.4.3
7 6 * Author: MxChat
8 7 * Author URI: https://mxchat.ai
9 8 * License: GPLv2 or later
10 9 * License URI: https://www.gnu.org/licenses/gpl-2.0.html
@@ -15,418 +14,27 @@
15 14 if (!defined('ABSPATH')) {
16 15 exit; // Exit if accessed directly.
17 16 }
18 17
18 +// Define plugin version constant for asset versioning
19 +define('MXCHAT_VERSION', '2.4.3');
19 20
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 - * Honest, versioned User-Agent for MXChat remote-content ingestion fetches
43 - * (Knowledge Base PDF import, URL import, sitemap / website crawl).
44 - *
45 - * WAF rulesets (SiteGround/ModSecurity, Wordfence, Cloudflare managed rules)
46 - * flag stale spoofed-browser UAs as scrapers and return 403 — which silently
47 - * broke the single most common KB source: self-hosted media on the site's own
48 - * domain. A truthful crawler identifier is the industry norm for well-behaved
49 - * bots and lets a site owner allowlist "MXChatBot" in their WAF. Filterable so
50 - * a locked-down host can supply a different string without a code change.
51 - */
52 -if (!function_exists('mxchat_ingest_user_agent')) {
53 - function mxchat_ingest_user_agent() {
54 - $version = defined('MXCHAT_VERSION') ? MXCHAT_VERSION : '1.0';
55 - $ua = 'MXChatBot/' . $version . ' (+https://mxchat.ai/bot)';
56 - return apply_filters('mxchat_ingest_user_agent', $ua);
57 - }
58 -}
59 -
60 21 function mxchat_load_textdomain() {
61 - $domain = 'mxchat';
62 - $locale = determine_locale();
63 -
64 - // First, try to load from /wp-content/languages/plugins/ (preserved during updates)
65 - $mo_file = WP_LANG_DIR . '/plugins/' . $domain . '-' . $locale . '.mo';
66 - if (file_exists($mo_file)) {
67 - load_textdomain($domain, $mo_file);
68 - return;
69 - }
70 -
71 - // Fallback to plugin's /languages directory
72 - load_plugin_textdomain($domain, false, dirname(plugin_basename(__FILE__)) . '/languages');
22 + load_plugin_textdomain('mxchat', false, dirname(plugin_basename(__FILE__)) . '/languages');
73 23 }
74 -add_action('init', 'mxchat_load_textdomain');
24 +add_action('plugins_loaded', 'mxchat_load_textdomain');
75 25
76 -/**
77 - * One-time migration: gemini-3-pro-preview was shut down by Google on March 9, 2026.
78 - * Existing installs with the dead ID get auto-remapped to gemini-3.1-pro-preview
79 - * (Google's official migration target) the first time admin_init fires after update.
80 - */
81 -add_action('admin_init', function () {
82 - if (get_option('mxchat_gemini_3_remap_done')) {
83 - return;
84 - }
85 - $opts = get_option('mxchat_options');
86 - if (is_array($opts) && isset($opts['model']) && $opts['model'] === 'gemini-3-pro-preview') {
87 - $opts['model'] = 'gemini-3.1-pro-preview';
88 - update_option('mxchat_options', $opts);
89 - }
90 - if (is_array($opts) && isset($opts['content_model']) && $opts['content_model'] === 'gemini-3-pro-preview') {
91 - $opts['content_model'] = 'gemini-3.1-pro-preview';
92 - update_option('mxchat_options', $opts);
93 - }
94 - update_option('mxchat_gemini_3_remap_done', 1);
95 -});
96 -
97 -/**
98 - * One-time migration: the Grok 2 family was retired by xAI (grok-2, grok-2-1212,
99 - * grok-2-latest, grok-2-vision-1212 all return 400 "Model not found"). Existing
100 - * installs with the dead ID get auto-remapped to grok-4-1-fast-non-reasoning
101 - * (modern, fast, broadly available) the first time admin_init fires after update.
102 - */
103 -add_action('admin_init', function () {
104 - if (get_option('mxchat_grok_2_remap_done')) {
105 - return;
106 - }
107 - $opts = get_option('mxchat_options');
108 - if (is_array($opts) && isset($opts['model']) && $opts['model'] === 'grok-2') {
109 - $opts['model'] = 'grok-4-1-fast-non-reasoning';
110 - update_option('mxchat_options', $opts);
111 - }
112 - if (is_array($opts) && isset($opts['content_model']) && $opts['content_model'] === 'grok-2') {
113 - $opts['content_model'] = 'grok-4-1-fast-non-reasoning';
114 - update_option('mxchat_options', $opts);
115 - }
116 - update_option('mxchat_grok_2_remap_done', 1);
117 -});
118 -
119 -/**
120 - * One-time migration: Anthropic retired the Claude 4 (2025-05-14) snapshots on
121 - * June 15, 2026 — claude-opus-4-20250514 and claude-sonnet-4-20250514 now return
122 - * an API error. Existing installs with a dead ID get auto-remapped to the current
123 - * equivalents Anthropic recommends (Opus 4.8 / Sonnet 4.6) the first time admin_init
124 - * fires after update. Mirrors the gemini-3-pro-preview / grok-2 rescues above.
125 - */
126 -add_action('admin_init', function () {
127 - if (get_option('mxchat_claude_4_retire_remap_done')) {
128 - return;
129 - }
130 - $map = array(
131 - 'claude-opus-4-20250514' => 'claude-opus-4-8',
132 - 'claude-sonnet-4-20250514' => 'claude-sonnet-4-6',
133 - );
134 - $opts = get_option('mxchat_options');
135 - if (is_array($opts)) {
136 - $changed = false;
137 - if (isset($opts['model']) && isset($map[$opts['model']])) {
138 - $opts['model'] = $map[$opts['model']];
139 - $changed = true;
140 - }
141 - if (isset($opts['content_model']) && isset($map[$opts['content_model']])) {
142 - $opts['content_model'] = $map[$opts['content_model']];
143 - $changed = true;
144 - }
145 - if ($changed) {
146 - update_option('mxchat_options', $opts);
147 - }
148 - }
149 - update_option('mxchat_claude_4_retire_remap_done', 1);
150 -});
151 -
152 -/**
153 - * Exclude MxChat assets from caching plugin optimizations
154 - *
155 - * This prevents issues with WP Rocket, LiteSpeed Cache, Autoptimize, WP Super Cache,
156 - * W3 Total Cache, SG Optimizer, and similar plugins that may break the chatbot by
157 - * removing "unused" CSS, minifying/combining JS, or deferring/delaying jQuery.
158 - *
159 - * Both chat-script.js and floating-script.js depend on jQuery, so jQuery must also
160 - * be excluded from any optimization that changes load order or timing.
161 - */
162 -
163 -// ── WP Rocket ────────────────────────────────────────────────────────────────
164 -
165 -// Exclude from Remove Unused CSS (RUCSS)
166 -add_filter('rocket_rucss_inline_atts_exclusions', function($exclusions) {
167 - if (!is_array($exclusions)) $exclusions = array();
168 - $exclusions[] = 'mxchat';
169 - return $exclusions;
170 -});
171 -
172 -// Exclude CSS from minification/combination
173 -add_filter('rocket_exclude_css', function($excluded) {
174 - if (!is_array($excluded)) $excluded = array();
175 - $excluded[] = '/plugins/mxchat-basic/css/chat-style.css';
176 - return $excluded;
177 -});
178 -
179 -// Exclude JS from minification/combination
180 -add_filter('rocket_exclude_js', function($excluded) {
181 - if (!is_array($excluded)) $excluded = array();
182 - $excluded[] = '/plugins/mxchat-basic/js/chat-script.js';
183 - $excluded[] = '/plugins/mxchat-basic/js/floating-script.js';
184 - $excluded[] = '/jquery-core';
185 - $excluded[] = '/jquery.min.js';
186 - $excluded[] = '/jquery.js';
187 - $excluded[] = '/jquery-migrate';
188 - return $excluded;
189 -});
190 -
191 -// Exclude JS from defer
192 -add_filter('rocket_exclude_defer_js', function($excluded) {
193 - if (!is_array($excluded)) $excluded = array();
194 - $excluded[] = '/plugins/mxchat-basic/js/chat-script.js';
195 - $excluded[] = '/plugins/mxchat-basic/js/floating-script.js';
196 - $excluded[] = '/jquery-core';
197 - $excluded[] = '/jquery.min.js';
198 - $excluded[] = '/jquery.js';
199 - $excluded[] = '/jquery-migrate';
200 - return $excluded;
201 -});
202 -
203 -// Exclude from delay JS execution
204 -add_filter('rocket_delay_js_exclusions', function($excluded) {
205 - if (!is_array($excluded)) $excluded = array();
206 - $excluded[] = 'mxchat';
207 - $excluded[] = 'chat-script';
208 - $excluded[] = 'floating-script';
209 - $excluded[] = '/jquery-core';
210 - $excluded[] = '/jquery.min.js';
211 - $excluded[] = '/jquery.js';
212 - $excluded[] = '/jquery-migrate';
213 - return $excluded;
214 -});
215 -
216 -// ── LiteSpeed Cache ──────────────────────────────────────────────────────────
217 -
218 -// Exclude CSS from optimization
219 -add_filter('litespeed_optimize_css_excludes', function($excluded) {
220 - if (!is_array($excluded)) $excluded = array();
221 - $excluded[] = 'chat-style.css';
222 - $excluded[] = 'mxchat';
223 - return $excluded;
224 -});
225 -
226 -// Exclude from UCSS (Unique CSS) - prevents LiteSpeed from stripping "unused" MxChat CSS
227 -add_filter('litespeed_ucss_whitelist', function($whitelist) {
228 - if (!is_array($whitelist)) $whitelist = array();
229 - $whitelist[] = '.mxchat-chatbot-wrapper';
230 - $whitelist[] = '.floating-chatbot';
231 - $whitelist[] = '.floating-chatbot-button';
232 - $whitelist[] = '.chatbot-top-bar';
233 - $whitelist[] = '.mxchat-chatbot';
234 - $whitelist[] = '.chat-container';
235 - $whitelist[] = '.chat-box';
236 - $whitelist[] = '.bot-message';
237 - $whitelist[] = '.input-container';
238 - $whitelist[] = '.chat-input';
239 - $whitelist[] = '.send-button';
240 - $whitelist[] = '.pre-chat-message';
241 - $whitelist[] = '.mxchat-popular-questions';
242 - $whitelist[] = '.chat-toolbar';
243 - $whitelist[] = '.exit-chat';
244 - $whitelist[] = '.email-blocker';
245 - return $whitelist;
246 -});
247 -
248 -// Exclude CSS from CCSS (Critical CSS) generation
249 -add_filter('litespeed_optm_ccss_exc', function($excluded) {
250 - if (!is_array($excluded)) $excluded = array();
251 - $excluded[] = 'chat-style.css';
252 - $excluded[] = 'mxchat';
253 - return $excluded;
254 -});
255 -
256 -// Exclude JS from defer
257 -add_filter('litespeed_optm_js_defer_exc', function($excluded) {
258 - if (!is_array($excluded)) $excluded = array();
259 - $excluded[] = 'chat-script.js';
260 - $excluded[] = 'floating-script.js';
261 - $excluded[] = 'mxchat';
262 - $excluded[] = 'jquery.min.js';
263 - $excluded[] = 'jquery.js';
264 - return $excluded;
265 -});
266 -
267 -// Exclude JS from combining
268 -add_filter('litespeed_optm_js_exc', function($excluded) {
269 - if (!is_array($excluded)) $excluded = array();
270 - $excluded[] = 'chat-script.js';
271 - $excluded[] = 'floating-script.js';
272 - $excluded[] = 'mxchat';
273 - $excluded[] = 'jquery.min.js';
274 - $excluded[] = 'jquery.js';
275 - return $excluded;
276 -});
277 -
278 -// Exclude JS from delayed execution
279 -add_filter('litespeed_optm_js_delay_exc', function($excluded) {
280 - if (!is_array($excluded)) $excluded = array();
281 - $excluded[] = 'chat-script.js';
282 - $excluded[] = 'floating-script.js';
283 - $excluded[] = 'mxchat';
284 - return $excluded;
285 -});
286 -
287 -// Exclude from Guest Mode optimization
288 -add_filter('litespeed_guest_optm_exc', function($excluded) {
289 - if (!is_array($excluded)) $excluded = array();
290 - $excluded[] = 'mxchat';
291 - $excluded[] = 'chat-style';
292 - $excluded[] = 'chat-script';
293 - $excluded[] = 'floating-script';
294 - return $excluded;
295 -});
296 -
297 -// ── Autoptimize ──────────────────────────────────────────────────────────────
298 -
299 -// Exclude CSS from optimization (comma-separated strings)
300 -add_filter('autoptimize_filter_css_exclude', function($excluded) {
301 - if (!is_string($excluded)) $excluded = '';
302 - return $excluded . ', mxchat, chat-style.css';
303 -});
304 -
305 -// Exclude JS from optimization (comma-separated strings)
306 -add_filter('autoptimize_filter_js_exclude', function($excluded) {
307 - if (!is_string($excluded)) $excluded = '';
308 - return $excluded . ', mxchat, chat-script.js, floating-script.js, jquery.min.js, jquery.js';
309 -});
310 -
311 -// ── SG Optimizer (SiteGround) ────────────────────────────────────────────────
312 -
313 -add_filter('sgo_js_minify_exclude', function($excluded) {
314 - if (!is_array($excluded)) $excluded = array();
315 - $excluded[] = 'chat-script.js';
316 - $excluded[] = 'floating-script.js';
317 - $excluded[] = 'jquery.min.js';
318 - return $excluded;
319 -});
320 -
321 -add_filter('sgo_javascript_combine_exclude', function($excluded) {
322 - if (!is_array($excluded)) $excluded = array();
323 - $excluded[] = 'chat-script.js';
324 - $excluded[] = 'floating-script.js';
325 - $excluded[] = 'jquery.min.js';
326 - return $excluded;
327 -});
328 -
329 -add_filter('sgo_js_async_exclude', function($excluded) {
330 - if (!is_array($excluded)) $excluded = array();
331 - $excluded[] = 'chat-script.js';
332 - $excluded[] = 'floating-script.js';
333 - $excluded[] = 'jquery.min.js';
334 - return $excluded;
335 -});
336 -
337 -// ── W3 Total Cache ───────────────────────────────────────────────────────────
338 -
339 -add_filter('w3tc_minify_js_do_tag_minification', function($do_minify, $script_tag, $file) {
340 - if (strpos($file, 'chat-script.js') !== false ||
341 - strpos($file, 'floating-script.js') !== false ||
342 - strpos($file, 'jquery.min.js') !== false ||
343 - strpos($file, 'jquery.js') !== false) {
344 - return false;
345 - }
346 - return $do_minify;
347 -}, 10, 3);
348 -
349 -// ── WP Super Cache ──────────────────────────────────────────────────────────
350 -
351 -add_filter('wpsc_rejected_uri', function($rejected) {
352 - if (!is_array($rejected)) $rejected = array();
353 - $rejected[] = 'wp-admin/admin-ajax.php';
354 - return $rejected;
355 -});
356 -
357 -// ── Page-cache bypass for chat AJAX (companion to the 3.2.6 nonce-race hotfix)
358 -// Each cache plugin gets its own filter export so that visitors hitting an
359 -// edge-cached page never receive cached chat-AJAX responses. The chat send /
360 -// stream send / file upload all POST to /wp-admin/admin-ajax.php with
361 -// `action=mxchat_*`. Without these exports, a cache plugin can stale a response
362 -// and break the per-session nonce flow on the first message.
363 -
364 -// WP Rocket — `rocket_cache_reject_uri` takes a flat array of regex strings.
365 -add_filter('rocket_cache_reject_uri', function($uris) {
366 - if (!is_array($uris)) $uris = array();
367 - $uris[] = '/wp-admin/admin-ajax\.php\?action=mxchat_.*';
368 - return $uris;
369 -});
370 -
371 -// LiteSpeed Cache — `litespeed_cache_no_cache_for_request` short-circuits
372 -// caching when the request matches our chat-AJAX pattern.
373 -add_filter('litespeed_cache_no_cache_for_request', function($no_cache) {
374 - if ($no_cache) return $no_cache;
375 - if (!empty($_SERVER['REQUEST_URI']) &&
376 - strpos($_SERVER['REQUEST_URI'], '/wp-admin/admin-ajax.php') !== false &&
377 - !empty($_REQUEST['action']) &&
378 - strpos((string) $_REQUEST['action'], 'mxchat_') === 0) {
379 - return true;
380 - }
381 - return $no_cache;
382 -});
383 -
384 -// W3 Total Cache — `w3tc_pgcache_request_skip_uri` flips page-cache off when
385 -// the URI matches.
386 -add_filter('w3tc_pgcache_request_skip_uri', function($skip) {
387 - if ($skip) return $skip;
388 - if (!empty($_SERVER['REQUEST_URI']) &&
389 - strpos($_SERVER['REQUEST_URI'], '/wp-admin/admin-ajax.php') !== false &&
390 - !empty($_REQUEST['action']) &&
391 - strpos((string) $_REQUEST['action'], 'mxchat_') === 0) {
392 - return true;
393 - }
394 - return $skip;
395 -});
396 -
397 -// FlyingPress — `flying_press_cacheable` takes a boolean and is run per
398 -// request. Same pattern as LiteSpeed / W3TC.
399 -add_filter('flying_press_cacheable', function($cacheable) {
400 - if (!$cacheable) return $cacheable;
401 - if (!empty($_SERVER['REQUEST_URI']) &&
402 - strpos($_SERVER['REQUEST_URI'], '/wp-admin/admin-ajax.php') !== false &&
403 - !empty($_REQUEST['action']) &&
404 - strpos((string) $_REQUEST['action'], 'mxchat_') === 0) {
405 - return false;
406 - }
407 - return $cacheable;
408 -});
409 -
410 26 // Include classes with error handling
411 27 function mxchat_include_classes() {
412 28 $class_files = array(
413 - 'includes/class-mxchat-model-catalog.php',
414 - 'includes/class-mxchat-live-agent-schedule.php',
415 - 'includes/class-mxchat-tool-registry.php',
416 29 'includes/class-mxchat-integrator.php',
417 30 'includes/class-mxchat-admin.php',
418 31 'includes/class-mxchat-public.php',
419 32 'includes/class-mxchat-utils.php',
420 33 'includes/class-mxchat-user.php',
421 - 'includes/class-mxchat-privacy.php',
422 34 'includes/class-mxchat-meta-box.php',
423 - 'includes/class-mxchat-chunker.php',
35 + 'includes/pdf-parser/alt_autoload.php',
424 36 'includes/class-mxchat-word-handler.php',
425 - 'includes/class-mxchat-content-generator.php',
426 - 'includes/class-mxchat-cache-purge.php',
427 - 'includes/class-mxchat-editor-assistant.php',
428 - 'includes/class-rest-api.php',
429 37 'admin/class-ajax-handler.php',
430 38 'admin/class-pinecone-manager.php',
431 39 'admin/class-knowledge-manager.php'
432 40 );
@@ -438,62 +46,11 @@
438 46 } else {
439 47 //error_log('MxChat: Missing class file - ' . $file);
440 48 }
441 49 }
442 -
443 - // Register the native function-calling admin-post save handler (a41dee).
444 - if (class_exists('MxChat_Tool_Registry')) {
445 - MxChat_Tool_Registry::init();
446 - }
447 -
448 - // GDPR: register with WP's personal-data export/erase tools (b81e42).
449 - if (class_exists('MxChat_Privacy')) {
450 - MxChat_Privacy::init();
451 - }
452 -
453 - // Editor Assistant — free, OFF-by-default block-editor AI actions (plan-8cb0cb).
454 - // init() wires REST + streaming AJAX + sidebar enqueue ONLY when the
455 - // mxchat_editor_assistant_enabled option is 'on'; otherwise zero footprint.
456 - if (class_exists('MxChat_Editor_Assistant')) {
457 - MxChat_Editor_Assistant::init();
458 - }
459 -
460 - // Admin pages that aren't classes (procedural include).
461 - if (is_admin()) {
462 - $admin_api_page = plugin_dir_path(__FILE__) . 'includes/admin-api-page.php';
463 - if (file_exists($admin_api_page)) {
464 - require_once $admin_api_page;
465 - }
466 - // f7c7d4 renamed this file admin-dashboard-page.php → admin-onboarding-page.php.
467 - // The require MUST live here (admin bootstrap) and not just inside
468 - // mxchat_add_plugin_page() on the admin_menu hook — admin_menu does NOT
469 - // fire on admin-ajax.php requests, so the wizard's AJAX handlers
470 - // (plan-905439: mxchat_onboarding_kb_status / save_step / mark_step /
471 - // auto_graduate + the f7c7d4 dismiss handler) would never register.
472 - $admin_onboarding_page = plugin_dir_path(__FILE__) . 'includes/admin-onboarding-page.php';
473 - if (file_exists($admin_onboarding_page)) {
474 - require_once $admin_onboarding_page;
475 - }
476 - }
477 50 }
478 51
479 52 /**
480 - * Lazy-load the PDF parser library only when needed.
481 - * Avoids loading 44 files on every page request.
482 - */
483 -function mxchat_load_pdf_parser() {
484 - if (class_exists('\Smalot\PdfParser\Parser')) {
485 - return true;
486 - }
487 - $autoload_path = plugin_dir_path(__FILE__) . 'includes/pdf-parser/alt_autoload.php';
488 - if (file_exists($autoload_path)) {
489 - require_once $autoload_path;
490 - return true;
491 - }
492 - return false;
493 -}
494 -
495 -/**
496 53 * Create URL click tracking table
497 54 */
498 55 function mxchat_create_url_clicks_table() {
499 56 global $wpdb;
@@ -576,13 +133,12 @@
576 133
577 134 // Define all required columns and their types
578 135 $required_columns = [
579 136 'user_identifier' => 'VARCHAR(255) DEFAULT NULL',
580 - 'user_email' => 'VARCHAR(255) DEFAULT NULL',
137 + 'user_email' => 'VARCHAR(255) DEFAULT NULL',
581 138 'user_name' => 'VARCHAR(100) DEFAULT NULL',
582 139 'originating_page_url' => 'TEXT DEFAULT NULL',
583 - 'originating_page_title' => 'VARCHAR(500) DEFAULT NULL',
584 - 'rag_context' => 'LONGTEXT DEFAULT NULL'
140 + 'originating_page_title' => 'VARCHAR(500) DEFAULT NULL'
585 141 ];
586 142
587 143 // Get existing columns
588 144 $existing_columns = $wpdb->get_results("SHOW COLUMNS FROM $table_name");
@@ -653,9 +209,9 @@
653 209 }
654 210 }
655 211
656 212 /**
657 - * Add enabled_bots column to intents table for multi-bot action filtering
213 + * NEW: Add enabled_bots column to intents table for multi-bot action filtering
658 214 */
659 215 function mxchat_add_enabled_bots_column() {
660 216 global $wpdb;
661 217 $table_name = $wpdb->prefix . 'mxchat_intents';
@@ -702,430 +258,31 @@
702 258 }
703 259 }
704 260
705 261 /**
706 - * Create Pinecone role restrictions table with multi-bot support
262 + * Create Pinecone role restrictions table
707 263 */
708 264 function mxchat_create_pinecone_roles_table() {
709 265 global $wpdb;
710 -
266 +
711 267 $table_name = $wpdb->prefix . 'mxchat_pinecone_roles';
712 268 $charset_collate = $wpdb->get_charset_collate();
713 -
269 +
714 270 $sql = "CREATE TABLE $table_name (
715 271 id mediumint(9) NOT NULL AUTO_INCREMENT,
716 272 vector_id varchar(255) NOT NULL,
717 - bot_id varchar(50) NOT NULL DEFAULT 'default',
718 273 source_url text,
719 274 role_restriction varchar(50) DEFAULT 'public',
720 275 updated_at timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
721 276 PRIMARY KEY (id),
722 - UNIQUE KEY vector_bot (vector_id, bot_id),
723 - KEY role_restriction (role_restriction),
724 - KEY bot_id (bot_id)
277 + UNIQUE KEY vector_id (vector_id),
278 + KEY role_restriction (role_restriction)
725 279 ) $charset_collate;";
726 -
727 - require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
728 - dbDelta($sql);
729 -}
730 -
731 -/**
732 - * Add bot_id column to mxchat_pinecone_roles table for multi-bot support
733 - * This migration runs once to update existing installations
734 - */
735 -function mxchat_migrate_pinecone_roles_add_bot_id() {
736 - global $wpdb;
737 -
738 - // Check if migration already ran
739 - $migration_version = get_option('mxchat_pinecone_roles_migration_version', '0');
740 - if (version_compare($migration_version, '2.5.2', '>=')) {
741 - return; // Already migrated
742 - }
743 -
744 - $table_name = $wpdb->prefix . 'mxchat_pinecone_roles';
745 -
746 - // Check if table exists
747 - if ($wpdb->get_var("SHOW TABLES LIKE '{$table_name}'") != $table_name) {
748 - return; // Table doesn't exist yet
749 - }
750 -
751 - // Check if bot_id column already exists
752 - $column_exists = $wpdb->get_results("SHOW COLUMNS FROM {$table_name} LIKE 'bot_id'");
753 -
754 - if (empty($column_exists)) {
755 - // Add bot_id column
756 - $wpdb->query("ALTER TABLE {$table_name} ADD COLUMN bot_id VARCHAR(50) NOT NULL DEFAULT 'default' AFTER vector_id");
757 -
758 - // Update the unique key to include bot_id
759 - $wpdb->query("ALTER TABLE {$table_name} DROP INDEX vector_id");
760 - $wpdb->query("ALTER TABLE {$table_name} ADD UNIQUE KEY vector_bot (vector_id, bot_id)");
761 -
762 - // Add index for bot_id
763 - $wpdb->query("ALTER TABLE {$table_name} ADD KEY bot_id (bot_id)");
764 -
765 - //error_log('MxChat: Successfully added bot_id column to mxchat_pinecone_roles table');
766 - }
767 -
768 - // Mark migration as complete
769 - update_option('mxchat_pinecone_roles_migration_version', '2.5.2');
770 -}
771 -
772 -/**
773 - * 2.5.6: Add content_type column to mxchat_system_prompt_content table
774 - * Enables filtering knowledge base by content type (posts, pages, PDFs, etc.)
775 - */
776 -function mxchat_migrate_add_content_type_column() {
777 - global $wpdb;
778 -
779 - // Check if migration already ran
780 - $migration_version = get_option('mxchat_content_type_migration_version', '0');
781 - if (version_compare($migration_version, '2.5.6', '>=')) {
782 - return;
783 - }
784 -
785 - $table_name = $wpdb->prefix . 'mxchat_system_prompt_content';
786 -
787 - // Check if table exists
788 - if ($wpdb->get_var("SHOW TABLES LIKE '{$table_name}'") != $table_name) {
789 - return;
790 - }
791 -
792 - // Check if content_type column already exists
793 - $column_exists = $wpdb->get_results("SHOW COLUMNS FROM {$table_name} LIKE 'content_type'");
794 -
795 - if (empty($column_exists)) {
796 - // Add content_type column with default value 'content' for backwards compatibility
797 - $wpdb->query("ALTER TABLE {$table_name} ADD COLUMN content_type VARCHAR(50) DEFAULT 'content' AFTER role_restriction");
798 -
799 - // Add index for better query performance
800 - $wpdb->query("ALTER TABLE {$table_name} ADD KEY content_type (content_type)");
801 -
802 - //error_log('MxChat: Successfully added content_type column to mxchat_system_prompt_content table');
803 - }
804 -
805 - // Mark migration as complete
806 - update_option('mxchat_content_type_migration_version', '2.5.6');
807 -}
808 -
809 -/**
810 - * 3.2.4: Backfill the active embedding model option for installs that already
811 - * have KB content but no stamped model. The mismatch warning compares this
812 - * against the user's currently selected model — no per-row column needed.
813 - */
814 -function mxchat_backfill_active_embedding_model() {
815 - global $wpdb;
816 -
817 - if (get_option('mxchat_active_embedding_model', '') !== '') {
818 - return;
819 - }
820 -
821 - $kb_table = $wpdb->prefix . 'mxchat_system_prompt_content';
822 - if ($wpdb->get_var("SHOW TABLES LIKE '{$kb_table}'") !== $kb_table) {
823 - return;
824 - }
825 -
826 - $kb_count = (int) $wpdb->get_var("SELECT COUNT(*) FROM {$kb_table}");
827 - if ($kb_count > 0) {
828 - $options = get_option('mxchat_options', array());
829 - $current_model = $options['embedding_model'] ?? 'text-embedding-ada-002';
830 - update_option('mxchat_active_embedding_model', $current_model, false);
831 - }
832 -}
833 -
834 -/**
835 - * 2.5.2: Create queue processing tables for reliable background processing
836 - */
837 -function mxchat_create_queue_tables() {
838 - global $wpdb;
839 - $charset_collate = $wpdb->get_charset_collate();
840 280
841 - // Main queue table
842 - $queue_table = $wpdb->prefix . 'mxchat_processing_queue';
843 - $sql_queue = "CREATE TABLE $queue_table (
844 - id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
845 - queue_id varchar(64) NOT NULL,
846 - item_type varchar(20) NOT NULL,
847 - item_data longtext NOT NULL,
848 - status varchar(20) NOT NULL DEFAULT 'pending',
849 - bot_id varchar(50) NOT NULL DEFAULT 'default',
850 - priority int(11) NOT NULL DEFAULT 0,
851 - attempts int(11) NOT NULL DEFAULT 0,
852 - max_attempts int(11) NOT NULL DEFAULT 3,
853 - error_message text DEFAULT NULL,
854 - created_at datetime NOT NULL,
855 - started_at datetime DEFAULT NULL,
856 - completed_at datetime DEFAULT NULL,
857 - PRIMARY KEY (id),
858 - KEY queue_id (queue_id),
859 - KEY status (status),
860 - KEY item_type (item_type),
861 - KEY priority (priority)
862 - ) $charset_collate;";
863 -
864 - // Queue metadata table
865 - $meta_table = $wpdb->prefix . 'mxchat_queue_meta';
866 - $sql_meta = "CREATE TABLE $meta_table (
867 - id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
868 - queue_id varchar(64) NOT NULL,
869 - meta_key varchar(255) NOT NULL,
870 - meta_value longtext,
871 - PRIMARY KEY (id),
872 - KEY queue_id (queue_id),
873 - KEY meta_key (meta_key)
874 - ) $charset_collate;";
875 -
876 281 require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
877 - dbDelta($sql_queue);
878 - dbDelta($sql_meta);
879 -
880 - //error_log("MxChat: Queue tables created/updated successfully");
881 -}
882 -
883 -/**
884 - * Create transcript translations table for persisting translations
885 - */
886 -function mxchat_create_translations_table() {
887 - global $wpdb;
888 - $charset_collate = $wpdb->get_charset_collate();
889 -
890 - $table_name = $wpdb->prefix . 'mxchat_transcript_translations';
891 - $sql = "CREATE TABLE $table_name (
892 - id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
893 - session_id varchar(255) NOT NULL,
894 - language_code varchar(10) NOT NULL,
895 - translations longtext NOT NULL,
896 - created_at datetime NOT NULL,
897 - updated_at datetime NOT NULL,
898 - PRIMARY KEY (id),
899 - UNIQUE KEY session_lang (session_id, language_code),
900 - KEY session_id (session_id)
901 - ) $charset_collate;";
902 -
903 - require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
904 282 dbDelta($sql);
905 283 }
906 284
907 -/**
908 - * Create per-session satisfaction ratings table (v3.2.6)
909 - * Stores one 👍/👎 rating + optional feedback per chat session.
910 - */
911 -function mxchat_create_session_ratings_table() {
912 - global $wpdb;
913 - $charset_collate = $wpdb->get_charset_collate();
914 -
915 - $table_name = $wpdb->prefix . 'mxchat_session_ratings';
916 - $sql = "CREATE TABLE $table_name (
917 - id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
918 - session_id varchar(255) NOT NULL,
919 - bot_id varchar(50) NOT NULL DEFAULT 'default',
920 - rating_value tinyint(1) NOT NULL,
921 - rating_feedback text DEFAULT NULL,
922 - created_at datetime NOT NULL,
923 - PRIMARY KEY (id),
924 - UNIQUE KEY session_id (session_id),
925 - KEY bot_id (bot_id),
926 - KEY created_at (created_at)
927 - ) $charset_collate;";
928 -
929 - require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
930 - dbDelta($sql);
931 -}
932 -
933 -/**
934 - * 2.5.2: Fix URL column size to support long URLs (especially with UTF-8 encoding)
935 - * This fixes "url, source_url. The supplied values may be too long" errors
936 - */
937 -function mxchat_fix_url_column_size() {
938 - global $wpdb;
939 - $table_name = $wpdb->prefix . 'mxchat_system_prompt_content';
940 -
941 - // Check if table exists
942 - $table_exists = $wpdb->get_var("SHOW TABLES LIKE '$table_name'") === $table_name;
943 - if (!$table_exists) {
944 - return;
945 - }
946 -
947 - // Change url and source_url from VARCHAR to TEXT to handle long URLs
948 - // This is especially important for URLs with UTF-8 encoded characters (Hebrew, Arabic, etc.)
949 - $wpdb->query("ALTER TABLE {$table_name} MODIFY COLUMN url TEXT");
950 - $wpdb->query("ALTER TABLE {$table_name} MODIFY COLUMN source_url TEXT");
951 -
952 - //error_log("MxChat: Successfully updated url and source_url columns to TEXT type for long URL support");
953 -}
954 -
955 -/**
956 - * Migrate deprecated AI models to their replacements
957 - * Version 2.5.1: Migrate Claude 3.5 Sonnet (deprecated) to Claude 3.7 Sonnet
958 - * Version 3.1.2: Convert chat transcripts table to utf8mb4 for emoji support
959 - * Without utf8mb4, any bot response containing emojis silently fails to insert.
960 - */
961 -function mxchat_migrate_transcripts_charset() {
962 - global $wpdb;
963 - $table_name = $wpdb->prefix . 'mxchat_chat_transcripts';
964 - $wpdb->query("ALTER TABLE $table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci");
965 -}
966 -
967 -/**
968 - * Version 3.0.55: Migrate GPT-4 series models (deprecated 2026-02-17) to GPT-5 series
969 - */
970 -function mxchat_migrate_deprecated_models() {
971 - $options = get_option('mxchat_options', array());
972 - $migrated = false;
973 - $migration_message = '';
974 -
975 - if (!isset($options['model'])) {
976 - return;
977 - }
978 -
979 - $current_model = $options['model'];
980 -
981 - // Migrate deprecated Claude models to Claude Opus 4.6 (recommended replacement per Anthropic)
982 - $deprecated_claude_models = array(
983 - 'claude-3-5-sonnet-20240620', // Retired Oct 28, 2025
984 - 'claude-3-5-sonnet-20241022', // Retired Oct 28, 2025
985 - 'claude-3-7-sonnet-20250219', // Retiring Feb 19, 2026
986 - 'claude-3-opus-20240229', // Retired Jan 5, 2026
987 - 'claude-3-sonnet-20240229', // Legacy
988 - 'claude-3-haiku-20240307', // Legacy
989 - );
990 - if (in_array($current_model, $deprecated_claude_models, true)) {
991 - $options['model'] = 'claude-opus-4-6';
992 - $migrated = true;
993 - $migration_message = sprintf(
994 - 'Your chatbot model has been automatically updated from %s to Claude Opus 4.6 due to Anthropic deprecating older Claude models.',
995 - $current_model
996 - );
997 - }
998 -
999 - // Migrate deprecated Claude Haiku 3.5 to Claude Haiku 4.5
1000 - if ($current_model === 'claude-3-5-haiku-20241022') {
1001 - $options['model'] = 'claude-haiku-4-5-20251001';
1002 - $migrated = true;
1003 - $migration_message = 'Your chatbot model has been automatically updated from Claude Haiku 3.5 to Claude Haiku 4.5 due to Anthropic deprecating the older model.';
1004 - }
1005 -
1006 - // Migrate deprecated GPT-4 series and GPT-3.5 Turbo to GPT-5.6 Sol.
1007 - // (Previous target gpt-5.1-chat-latest itself retires 2026-08-10 — never
1008 - // migrate onto a model that is already on a deprecation list.)
1009 - if (in_array($current_model, array('gpt-4o', 'gpt-4.1-2025-04-14', 'gpt-4-turbo', 'gpt-4', 'gpt-3.5-turbo'), true)) {
1010 - $options['model'] = 'gpt-5.6-sol';
1011 - $migrated = true;
1012 - $migration_message = sprintf(
1013 - 'Your chatbot model has been automatically updated from %s to GPT-5.6 Sol due to OpenAI deprecating older models.',
1014 - $current_model
1015 - );
1016 - }
1017 -
1018 - // Migrate the gpt-5.x-chat-latest aliases OpenAI retires on August 10, 2026.
1019 - // Replacement per OpenAI's deprecations page: gpt-5.6-sol (plan e46b8f).
1020 - if (in_array($current_model, array('gpt-5.1-chat-latest', 'gpt-5.3-chat-latest'), true)) {
1021 - $options['model'] = 'gpt-5.6-sol';
1022 - $migrated = true;
1023 - $migration_message = sprintf(
1024 - 'Your chatbot model has been automatically updated from %s to GPT-5.6 Sol because OpenAI retires the GPT-5.x Chat Latest models on August 10, 2026.',
1025 - $current_model
1026 - );
1027 - }
1028 -
1029 - // The content generator has its own model option — same retirement applies.
1030 - if (isset($options['content_model'])
1031 - && in_array($options['content_model'], array('gpt-5.1-chat-latest', 'gpt-5.3-chat-latest'), true)) {
1032 - $old_content_model = $options['content_model'];
1033 - $options['content_model'] = 'gpt-5.6-sol';
1034 - $migrated = true;
1035 - $migration_message = trim($migration_message . ' ' . sprintf(
1036 - 'Your content generation model has also been updated from %s to GPT-5.6 Sol for the same OpenAI retirement.',
1037 - $old_content_model
1038 - ));
1039 - }
1040 -
1041 - // Migrate deprecated GPT-4o Mini and GPT-4.1 Mini to GPT-5 Mini
1042 - if (in_array($current_model, array('gpt-4o-mini', 'gpt-4.1-mini'), true)) {
1043 - $options['model'] = 'gpt-5-mini';
1044 - $migrated = true;
1045 - $migration_message = sprintf(
1046 - 'Your chatbot model has been automatically updated from %s to GPT-5 Mini due to OpenAI deprecating GPT-4 series models.',
1047 - $current_model
1048 - );
1049 - }
1050 -
1051 - // Migrate retired DeepSeek ids to DeepSeek V4 Flash — the vendor removed
1052 - // deepseek-chat and deepseek-reasoner on 2026-07-24 (hard cutoff, every
1053 - // request 400s). V4 Flash is DeepSeek's designated successor for the
1054 - // legacy deepseek-chat alias.
1055 - if (in_array($current_model, array('deepseek-chat', 'deepseek-reasoner'), true)) {
1056 - $options['model'] = 'deepseek-v4-flash';
1057 - $migrated = true;
1058 - $migration_message = sprintf(
1059 - 'Your chatbot model has been automatically updated from %s to DeepSeek V4 Flash because DeepSeek retired its older API models on July 24, 2026.',
1060 - $current_model
1061 - );
1062 - }
1063 -
1064 - if ($migrated) {
1065 - update_option('mxchat_options', $options);
1066 - update_option('mxchat_model_migrated_notice', true);
1067 - update_option('mxchat_model_migration_message', $migration_message);
1068 - }
1069 -}
1070 -
1071 -/**
1072 - * Show admin notice after model migration
1073 - */
1074 -function mxchat_show_migration_notice() {
1075 - if (get_option('mxchat_model_migrated_notice')) {
1076 - $migration_message = get_option('mxchat_model_migration_message', __('Your chatbot model has been automatically updated due to a model deprecation.', 'mxchat'));
1077 - ?>
1078 - <div class="notice notice-info is-dismissible">
1079 - <p>
1080 - <strong><?php esc_html_e('MxChat Model Updated', 'mxchat'); ?></strong><br>
1081 - <?php echo esc_html($migration_message); ?>
1082 - </p>
1083 - </div>
1084 - <?php
1085 - delete_option('mxchat_model_migrated_notice');
1086 - delete_option('mxchat_model_migration_message');
1087 - }
1088 -}
1089 -
1090 -/**
1091 - * Persistent admin notice when the provider rejected the configured model
1092 - * (model_not_found / no access). Set by mxchat_friendly_chat_error() in the
1093 - * integrator whenever a chat request fails on a model-access error — including
1094 - * requests from anonymous visitors, which is the case that otherwise stays
1095 - * invisible to the site owner for weeks (plan e46b8f).
1096 - *
1097 - * Deleted after render so it re-arms on the next failed chat: the notice keeps
1098 - * reappearing until the model is fixed, then stops on its own.
1099 - */
1100 -function mxchat_show_model_access_notice() {
1101 - if (!current_user_can('manage_options')) {
1102 - return;
1103 - }
1104 - $notice = get_option('mxchat_model_access_notice');
1105 - if (!is_array($notice) || empty($notice['model'])) {
1106 - return;
1107 - }
1108 - $settings_url = admin_url('admin.php?page=mxchat-max');
1109 - ?>
1110 - <div class="notice notice-error is-dismissible">
1111 - <p>
1112 - <strong><?php esc_html_e('MxChat: your AI model is being rejected by the provider', 'mxchat'); ?></strong><br>
1113 - <?php
1114 - printf(
1115 - /* translators: 1: model id, 2: provider name */
1116 - 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'),
1117 - esc_html($notice['model']),
1118 - esc_html(!empty($notice['provider']) ? $notice['provider'] : __('the AI provider', 'mxchat'))
1119 - );
1120 - ?>
1121 - <a href="<?php echo esc_url($settings_url); ?>"><?php esc_html_e('Choose a different model in MxChat Settings', 'mxchat'); ?></a>
1122 - </p>
1123 - </div>
1124 - <?php
1125 - delete_option('mxchat_model_access_notice');
1126 -}
1127 -
1128 285 function mxchat_activate() {
1129 286 global $wpdb;
1130 287 $charset_collate = $wpdb->get_charset_collate();
1131 288
@@ -1133,21 +290,19 @@
1133 290
1134 291 // Create chat transcripts table with improved function
1135 292 mxchat_create_chat_transcripts_table();
1136 293
1137 - // System Prompt Content Table - UPDATED: Use TEXT for url and source_url columns
294 + // System Prompt Content Table
1138 295 $system_prompt_table = $wpdb->prefix . 'mxchat_system_prompt_content';
1139 296 $sql_system_prompt = "CREATE TABLE $system_prompt_table (
1140 297 id MEDIUMINT(9) NOT NULL AUTO_INCREMENT,
1141 - url TEXT NOT NULL,
298 + url VARCHAR(255) NOT NULL,
1142 299 article_content LONGTEXT NOT NULL,
1143 300 embedding_vector LONGTEXT,
1144 - source_url TEXT DEFAULT NULL,
301 + source_url VARCHAR(255) DEFAULT NULL,
1145 302 role_restriction VARCHAR(50) DEFAULT 'public',
1146 - content_type VARCHAR(50) DEFAULT 'content',
1147 303 timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
1148 - PRIMARY KEY (id),
1149 - KEY content_type (content_type)
304 + PRIMARY KEY (id)
1150 305 ) $charset_collate;";
1151 306
1152 307 // Intents Table - NOW INCLUDES enabled_bots column from the start
1153 308 $intents_table = $wpdb->prefix . 'mxchat_intents';
@@ -1162,42 +317,20 @@
1162 317 enabled_bots LONGTEXT DEFAULT NULL,
1163 318 PRIMARY KEY (id)
1164 319 ) $charset_collate;";
1165 320
1166 - // Individual Intent Phrases Table - each phrase gets its own embedding vector
1167 - $intent_phrases_table = $wpdb->prefix . 'mxchat_intent_phrases';
1168 - $sql_intent_phrases_table = "CREATE TABLE $intent_phrases_table (
1169 - id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
1170 - intent_id BIGINT(20) UNSIGNED NOT NULL,
1171 - phrase TEXT NOT NULL,
1172 - embedding_vector LONGTEXT NOT NULL,
1173 - created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
1174 - PRIMARY KEY (id),
1175 - KEY intent_id (intent_id)
1176 - ) $charset_collate;";
1177 -
1178 321 require_once ABSPATH . 'wp-admin/includes/upgrade.php';
1179 322
1180 323 // Create other tables
1181 324 dbDelta($sql_system_prompt);
1182 325 dbDelta($sql_intents_table);
1183 - dbDelta($sql_intent_phrases_table);
1184 326
1185 327 // Create URL click tracking table
1186 328 mxchat_create_url_clicks_table();
1187 329
1188 - // Create Pinecone roles table
330 + //Create Pinecone roles table
1189 331 mxchat_create_pinecone_roles_table();
1190 -
1191 - // NEW 2.5.2: Create queue processing tables
1192 - mxchat_create_queue_tables();
1193 332
1194 - // Create transcript translations table
1195 - mxchat_create_translations_table();
1196 -
1197 - // Create per-session satisfaction ratings table (v3.2.6)
1198 - mxchat_create_session_ratings_table();
1199 -
1200 333 // Ensure additional columns in system prompt table
1201 334 $existing_system_columns = $wpdb->get_results("SHOW COLUMNS FROM $system_prompt_table");
1202 335 if (!empty($existing_system_columns)) {
1203 336 $existing_system_column_names = array_column($existing_system_columns, 'Field');
@@ -1205,9 +338,9 @@
1205 338 if (!in_array('embedding_vector', $existing_system_column_names)) {
1206 339 $wpdb->query("ALTER TABLE $system_prompt_table ADD COLUMN embedding_vector LONGTEXT");
1207 340 }
1208 341 if (!in_array('source_url', $existing_system_column_names)) {
1209 - $wpdb->query("ALTER TABLE $system_prompt_table ADD COLUMN source_url TEXT DEFAULT NULL");
342 + $wpdb->query("ALTER TABLE $system_prompt_table ADD COLUMN source_url VARCHAR(255) DEFAULT NULL");
1210 343 }
1211 344 if (!in_array('role_restriction', $existing_system_column_names)) {
1212 345 $wpdb->query("ALTER TABLE $system_prompt_table ADD COLUMN role_restriction VARCHAR(50) DEFAULT 'public' AFTER source_url");
1213 346 }
@@ -1224,9 +357,9 @@
1224 357 if (!in_array('enabled', $existing_intent_column_names)) {
1225 358 $wpdb->query("ALTER TABLE $intents_table ADD COLUMN enabled TINYINT(1) NOT NULL DEFAULT 1");
1226 359 }
1227 360
1228 - // Ensure enabled_bots column exists for existing installations
361 + // NEW: Ensure enabled_bots column exists for existing installations
1229 362 if (!in_array('enabled_bots', $existing_intent_column_names)) {
1230 363 $wpdb->query("ALTER TABLE $intents_table ADD COLUMN enabled_bots LONGTEXT DEFAULT NULL AFTER enabled");
1231 364
1232 365 // Set existing actions to work with default bot
@@ -1237,21 +370,14 @@
1237 370 ));
1238 371 }
1239 372 }
1240 373
1241 - // Run migration for existing installations
1242 - mxchat_migrate_pinecone_roles_add_bot_id();
1243 -
1244 - // 3.2.4: Backfill active embedding model option (replaces 3.2.3 column-based tracking)
1245 - mxchat_backfill_active_embedding_model();
1246 -
1247 374 // Setup cron jobs
1248 375 mxchat_setup_cron_jobs();
1249 376
1250 - // Update version (stable base version — never the dev time()-suffixed one,
1251 - // or the check_for_update comparison would churn every request)
1252 - update_option('mxchat_plugin_version', MXCHAT_BASE_VERSION);
1253 -
377 + // Update version
378 + update_option('mxchat_plugin_version', MXCHAT_VERSION);
379 +
1254 380 //error_log("MxChat: Activation function completed");
1255 381 }
1256 382
1257 383 /**
@@ -1265,42 +391,22 @@
1265 391 if (defined('DISABLE_WP_CRON') && DISABLE_WP_CRON) {
1266 392 // Set flag to use fallback system
1267 393 update_option('mxchat_use_fallback_rate_limits', true);
1268 394 update_option('mxchat_next_rate_limit_check', time() + 3600);
1269 - // Deliberately NO early return (plan-bc08a6): transcript cleanup below
1270 - // must still be scheduled. DISABLE_WP_CRON only changes HOW cron events
1271 - // execute (a server-side runner hitting wp-cron.php instead of loopback
1272 - // spawns) — scheduling still just writes the cron option. The old early
1273 - // return here meant a deactivate/reactivate cycle on a DISABLE_WP_CRON
1274 - // site permanently lost the transcript cleanup event while the retention
1275 - // setting still claimed to be active.
395 + return;
396 + }
397 +
398 + // Schedule the rate limit reset cron job
399 + $result = wp_schedule_event(time() + 300, 'hourly', 'mxchat_reset_rate_limits');
400 +
401 + if ($result === false) {
402 + // Fallback if scheduling fails
403 + update_option('mxchat_use_fallback_rate_limits', true);
404 + update_option('mxchat_next_rate_limit_check', time() + 3600);
1276 405 } else {
1277 - // Schedule the rate limit reset cron job
1278 - $result = wp_schedule_event(time() + 300, 'hourly', 'mxchat_reset_rate_limits');
1279 -
1280 - if ($result === false) {
1281 - // Fallback if scheduling fails
1282 - update_option('mxchat_use_fallback_rate_limits', true);
1283 - update_option('mxchat_next_rate_limit_check', time() + 3600);
1284 - } else {
1285 - // Clear fallback flags if cron scheduling succeeded
1286 - delete_option('mxchat_use_fallback_rate_limits');
1287 - }
406 + // Clear fallback flags if cron scheduling succeeded
407 + delete_option('mxchat_use_fallback_rate_limits');
1288 408 }
1289 -
1290 - // Schedule transcript cleanup if configured (bucket dropdown OR custom retention-days > 0)
1291 - $transcript_options = get_option('mxchat_transcripts_options', array());
1292 - $cleanup_interval = isset($transcript_options['mxchat_auto_delete_transcripts']) ? $transcript_options['mxchat_auto_delete_transcripts'] : 'never';
1293 - $custom_retention = isset($transcript_options['mxchat_retention_days']) ? (int) $transcript_options['mxchat_retention_days'] : 0;
1294 -
1295 - if ($cleanup_interval !== 'never' || $custom_retention > 0) {
1296 - // Check if not already scheduled
1297 - if (!wp_next_scheduled('mxchat_cleanup_old_transcripts')) {
1298 - // Schedule to run daily at 3 AM
1299 - $next_run = strtotime('tomorrow 3:00 AM');
1300 - wp_schedule_event($next_run, 'daily', 'mxchat_cleanup_old_transcripts');
1301 - }
1302 - }
1303 409 }
1304 410
1305 411 /**
1306 412 * Clean up on plugin deactivation
@@ -1307,18 +413,13 @@
1307 413 */
1308 414 function mxchat_deactivate() {
1309 415 // Clear scheduled cron jobs
1310 416 wp_clear_scheduled_hook('mxchat_reset_rate_limits');
1311 - wp_clear_scheduled_hook('mxchat_cleanup_old_transcripts');
1312 - wp_clear_scheduled_hook('mxchat_send_delayed_transcript');
1313 417
1314 418 // Clear fallback options
1315 419 delete_option('mxchat_use_fallback_rate_limits');
1316 420 delete_option('mxchat_next_rate_limit_check');
1317 421 delete_option('mxchat_fallback_check_interval');
1318 -
1319 - // NOTE: We do NOT delete queue tables on deactivation
1320 - // This preserves data if user accidentally deactivates the plugin
1321 422 }
1322 423
1323 424 /**
1324 425 * Check if fallback rate limit cleanup is needed
@@ -1330,134 +431,49 @@
1330 431 return;
1331 432 }
1332 433
1333 434 $next_check = get_option('mxchat_next_rate_limit_check', 0);
1334 -
435 +
1335 436 if (time() >= $next_check) {
1336 - // Reuse the bootstrap's integrator — mxchat_init() creates the global on
1337 - // plugins_loaded (before this init-priority-5 callback), so it's always set
1338 - // here. Constructing a second MxChat_Integrator just to call one method
1339 - // re-registers every hook the plugin has (ajax pairs, wp_footer loader,
1340 - // rest_api_init, admin_init guard) on a duplicate instance for the rest of
1341 - // the request. Defensive construction only if the global is somehow unset.
1342 - // NOTE: MxChat_Integrator::check_fallback_rate_limits() is a second
1343 - // implementation of this same check — if either changes, change both.
1344 - global $mxchat_integrator;
1345 - $integrator = ($mxchat_integrator instanceof MxChat_Integrator)
1346 - ? $mxchat_integrator
1347 - : (class_exists('MxChat_Integrator') ? new MxChat_Integrator() : null);
1348 - if ($integrator && method_exists($integrator, 'mxchat_reset_rate_limits')) {
1349 - $integrator->mxchat_reset_rate_limits();
1350 - update_option('mxchat_next_rate_limit_check', time() + 3600);
437 + // Only run reset if the MxChat_Integrator class exists
438 + if (class_exists('MxChat_Integrator')) {
439 + $integrator = new MxChat_Integrator();
440 + if (method_exists($integrator, 'mxchat_reset_rate_limits')) {
441 + $integrator->mxchat_reset_rate_limits();
442 + update_option('mxchat_next_rate_limit_check', time() + 3600);
443 + }
1351 444 }
1352 445 }
1353 446 }
1354 447
1355 448 /**
1356 - * Robust update checking with role restriction migration, model deprecation, and queue tables
1357 - * CRITICAL: This runs on EVERY page load to ensure tables exist
449 + * Robust update checking with role restriction migration
1358 450 */
1359 451 function mxchat_check_for_update() {
1360 - global $wpdb;
452 + global $wpdb; // CRITICAL: Declare this at the top
1361 453
1362 454 try {
1363 455 $current_version = get_option('mxchat_plugin_version', '0.0.0');
1364 - $plugin_version = MXCHAT_BASE_VERSION;
456 + $plugin_version = MXCHAT_VERSION;
1365 457
1366 - // Always ensure critical tables exist (even if version matches)
1367 - // This handles manual table deletion or fresh installs
1368 - $chat_table = $wpdb->prefix . 'mxchat_chat_transcripts';
1369 - $queue_table = $wpdb->prefix . 'mxchat_processing_queue';
1370 -
1371 - $chat_exists = $wpdb->get_var("SHOW TABLES LIKE '$chat_table'") === $chat_table;
1372 - $queue_exists = $wpdb->get_var("SHOW TABLES LIKE '$queue_table'") === $queue_table;
1373 -
1374 - if (!$chat_exists || !$queue_exists) {
1375 - //error_log("MxChat: Critical tables missing, running activation");
1376 - mxchat_activate();
1377 - }
1378 -
1379 - // Version-specific migrations
458 + // Always run activation to ensure tables exist (safe for existing installations)
1380 459 if ($current_version !== $plugin_version) {
1381 460 //error_log("MxChat: Version change detected: $current_version -> $plugin_version");
1382 -
461 +
1383 462 // Run live agent update BEFORE updating the stored version
1384 463 mxchat_handle_live_agent_update();
1385 -
1386 - // Run theme migration notice for 3.0.1 (AI theme CSS structure changes)
1387 - mxchat_handle_theme_migration_notice();
1388 464
1389 - // Run role restriction migration for 2.4.1
465 + //Run role restriction migration for 2.4.1
1390 466 if (version_compare($current_version, '2.4.1', '<')) {
1391 467 mxchat_add_role_restriction_column();
1392 468 }
1393 469
1394 - // Run enabled_bots column migration for 2.4.4
1395 - if (version_compare($current_version, '2.4.4', '<')) {
470 + // NEW: Run enabled_bots column migration for 2.4.3
471 + if (version_compare($current_version, '2.4.3', '<')) {
1396 472 mxchat_add_enabled_bots_column();
1397 473 }
1398 474
1399 - // Run model migration for 2.5.1 (Claude deprecation)
1400 - if (version_compare($current_version, '2.5.1', '<')) {
1401 - mxchat_migrate_deprecated_models();
1402 - }
1403 -
1404 - // 2.5.2: Ensure queue tables exist and fix URL column sizes for all users upgrading to 2.5.2
1405 - if (version_compare($current_version, '2.5.2', '<')) {
1406 - mxchat_create_queue_tables();
1407 - mxchat_fix_url_column_size(); // NEW: Fix URL column size for long URLs
1408 - //error_log("MxChat: Queue tables created and URL columns updated for upgrade to 2.5.2");
1409 - }
1410 -
1411 - // 2.6.0: Ensure rag_context column exists for retrieved documents feature
1412 - if (version_compare($current_version, '2.6.0', '<')) {
1413 - $chat_table = $wpdb->prefix . 'mxchat_chat_transcripts';
1414 - mxchat_ensure_all_columns($chat_table);
1415 - //error_log("MxChat: rag_context column migration for 2.6.0");
1416 - }
1417 -
1418 - // 3.0.5: Migrate deprecated Gemini embedding model
1419 - if (version_compare($current_version, '3.0.5', '<')) {
1420 - mxchat_migrate_gemini_embedding_model();
1421 - }
1422 -
1423 - // 3.0.6: Migrate deprecated OpenAI and Claude models
1424 - if (version_compare($current_version, '3.0.6', '<')) {
1425 - mxchat_migrate_deprecated_models();
1426 - }
1427 -
1428 - // 3.1.2: Convert chat transcripts table to utf8mb4 for emoji support
1429 - if (version_compare($current_version, '3.1.2', '<')) {
1430 - mxchat_migrate_transcripts_charset();
1431 - }
1432 -
1433 - // 3.1.7: Clean up stale shared session email/name entries
1434 - if (version_compare($current_version, '3.1.7', '<')) {
1435 - delete_option('mxchat_email_null');
1436 - delete_option('mxchat_name_null');
1437 - }
1438 -
1439 - // 3.2.4: Backfill active embedding model option for the warning UI
1440 - // (replaces the per-row column tracking from 3.2.3, which was reverted)
1441 - if (version_compare($current_version, '3.2.4', '<')) {
1442 - mxchat_backfill_active_embedding_model();
1443 - }
1444 -
1445 - // 3.2.15: Migrate retired DeepSeek ids (deepseek-chat / deepseek-reasoner
1446 - // were shut off at the vendor on 2026-07-24). The function is idempotent —
1447 - // it only rewrites models on its deprecation lists.
1448 - if (version_compare($current_version, '3.2.15', '<')) {
1449 - mxchat_migrate_deprecated_models();
1450 - }
1451 -
1452 - // 3.2.16: Migrate OpenAI ids retiring 2026-08-10 (gpt-5.1-chat-latest /
1453 - // gpt-5.3-chat-latest → gpt-5.6-sol per OpenAI's deprecations page).
1454 - // Idempotent — only rewrites models on the deprecation lists (e46b8f).
1455 - if (version_compare($current_version, '3.2.16', '<')) {
1456 - mxchat_migrate_deprecated_models();
1457 - }
1458 -
1459 - // Run full activation to ensure everything is up to date
475 + // Run activation (this will create/update all tables and columns)
1460 476 mxchat_activate();
1461 477
1462 478 // Run migration functions
1463 479 mxchat_migrate_live_agent_status();
@@ -1472,8 +488,18 @@
1472 488
1473 489 //error_log("MxChat: Updated from version $current_version to $plugin_version");
1474 490 }
1475 491
492 + // CRITICAL: Always ensure tables exist, even if version matches
493 + // This handles cases where tables were manually deleted
494 + $table_name = $wpdb->prefix . 'mxchat_chat_transcripts';
495 + $table_exists = $wpdb->get_var("SHOW TABLES LIKE '$table_name'") === $table_name;
496 +
497 + if (!$table_exists) {
498 + //error_log("MxChat: Chat transcripts table missing, recreating...");
499 + mxchat_activate(); // Run full activation instead of just table creation
500 + }
501 +
1476 502 } catch (Exception $e) {
1477 503 //error_log('MxChat update error: ' . $e->getMessage());
1478 504 // Don't update version if there was an error
1479 505 }
@@ -1479,10 +505,9 @@
1479 505 }
1480 506 }
1481 507
1482 508 /**
1483 - * Ensure tables exist on every admin load for fresh installations
1484 - * This is a safety net for cases where activation hook doesn't fire
509 + * Ensure tables exist on every load for fresh installations
1485 510 */
1486 511 function mxchat_ensure_tables_exist() {
1487 512 global $wpdb;
1488 513
@@ -1490,22 +515,12 @@
1490 515 if (!current_user_can('administrator')) {
1491 516 return;
1492 517 }
1493 518
1494 - // Check if we've already verified tables in this session
1495 - static $tables_checked = false;
1496 - if ($tables_checked) {
1497 - return;
1498 - }
1499 - $tables_checked = true;
1500 -
1501 519 $table_name = $wpdb->prefix . 'mxchat_chat_transcripts';
1502 - $queue_table = $wpdb->prefix . 'mxchat_processing_queue';
520 + $table_exists = $wpdb->get_var("SHOW TABLES LIKE '$table_name'") === $table_name;
1503 521
1504 - $chat_exists = $wpdb->get_var("SHOW TABLES LIKE '$table_name'") === $table_name;
1505 - $queue_exists = $wpdb->get_var("SHOW TABLES LIKE '$queue_table'") === $queue_table;
1506 -
1507 - if (!$chat_exists || !$queue_exists) {
522 + if (!$table_exists) {
1508 523 //error_log("MxChat: Tables missing on admin load, running activation");
1509 524 mxchat_activate();
1510 525 }
1511 526 }
@@ -1588,77 +603,45 @@
1588 603 function mxchat_handle_live_agent_update() {
1589 604 // Get the CURRENT stored version (before it gets updated)
1590 605 $current_version = get_option('mxchat_plugin_version', '0.0.0');
1591 606 $new_version = '2.2.2';
1592 -
607 +
1593 608 // Only run this once for the update to 2.2.2
1594 609 $update_handled = get_option('mxchat_live_agent_update_2_2_2_handled', false);
1595 -
610 +
1596 611 // Check if we're upgrading TO 2.2.2 and haven't handled this yet
1597 612 if (version_compare($current_version, $new_version, '<') && !$update_handled) {
1598 613 $options = get_option('mxchat_options', array());
1599 -
614 +
1600 615 // Check if live agent was previously enabled
1601 616 if (isset($options['live_agent_status']) && $options['live_agent_status'] === 'on') {
1602 617 // Disable live agent
1603 618 $options['live_agent_status'] = 'off';
1604 619 update_option('mxchat_options', $options);
1605 -
620 +
1606 621 // Set flag to show the notification banner
1607 622 update_option('mxchat_show_live_agent_disabled_notice', true);
1608 623 }
1609 -
624 +
1610 625 // Mark this update as handled
1611 626 update_option('mxchat_live_agent_update_2_2_2_handled', true);
1612 627 }
1613 628 }
1614 629
1615 -/**
1616 - * Handle theme migration notice for version 3.0.1
1617 - * Shows a dismissible notice to Pro users about migrating AI-generated themes
1618 - */
1619 -function mxchat_handle_theme_migration_notice() {
1620 - // Get the CURRENT stored version (before it gets updated)
1621 - $current_version = get_option('mxchat_plugin_version', '0.0.0');
1622 - $target_version = '3.0.1';
1623 -
1624 - // Only run this once for the update to 3.0.1
1625 - $update_handled = get_option('mxchat_theme_migration_update_3_0_1_handled', false);
1626 -
1627 - // Check if we're upgrading TO 3.0.1 and haven't handled this yet
1628 - if (version_compare($current_version, $target_version, '<') && !$update_handled) {
1629 - // Check if Pro is activated - only show to Pro users
1630 - $license_status = get_option('mxchat_license_status', 'inactive');
1631 - $is_pro = ($license_status === 'active');
1632 -
1633 - if ($is_pro) {
1634 - // Set flag to show the theme migration notification banner
1635 - update_option('mxchat_show_theme_migration_notice', true);
1636 - }
1637 -
1638 - // Mark this update as handled (whether Pro or not)
1639 - update_option('mxchat_theme_migration_update_3_0_1_handled', true);
1640 - }
1641 -}
1642 -
1643 630 // Initialize plugin safely
1644 631 function mxchat_init() {
1645 632 // Include all class files first
1646 633 mxchat_include_classes();
1647 634
1648 - // Run update check (this also ensures tables exist)
635 + // Run update check
1649 636 mxchat_check_for_update();
1650 637
1651 - // CRITICAL: Ensure tables exist on admin pages (safety net)
638 + // CRITICAL: Ensure tables exist (for fresh installations that don't trigger activation hook)
1652 639 add_action('admin_init', 'mxchat_ensure_tables_exist', 1);
1653 640
1654 641 // Add fallback rate limit check
1655 642 add_action('init', 'mxchat_check_fallback_rate_limits', 5);
1656 643
1657 - // Add migration notice hook
1658 - add_action('admin_notices', 'mxchat_show_migration_notice');
1659 - add_action('admin_notices', 'mxchat_show_model_access_notice');
1660 -
1661 644 // Initialize classes with error handling
1662 645 try {
1663 646 // Initialize admin classes
1664 647 if (is_admin()) {
@@ -1673,32 +656,10 @@
1673 656 // Initialize meta box class
1674 657 if (class_exists('MxChat_Meta_Box')) {
1675 658 new MxChat_Meta_Box();
1676 659 }
1677 -
1678 660 }
1679 -
1680 - // Initialize content generator globally — it registers wp_head hook
1681 - // for frontend CSS injection, plus wp_ajax_ hooks for admin.
1682 - if (class_exists('MxChat_Content_Generator')) {
1683 - new MxChat_Content_Generator();
1684 - }
1685 -
1686 - // Initialize cache purge globally — settings writes can happen on any
1687 - // request type (admin screens, admin-ajax autosave, wp-cli), and the
1688 - // deferred-purge cron event fires on front-end requests.
1689 - if (class_exists('MxChat_Cache_Purge')) {
1690 - MxChat_Cache_Purge::init();
1691 - }
1692 -
1693 - // Initialize REST API globally — endpoints must be registered on
1694 - // every request (admin and frontend) so they're reachable via /wp-json/.
1695 - // Endpoints are auth-gated and locked until the site owner generates
1696 - // a token in MxChat → API Access.
1697 - if (class_exists('MxChat_Rest_Api')) {
1698 - new MxChat_Rest_Api();
1699 - }
1700 -
661 +
1701 662 // Initialize public classes
1702 663 if (class_exists('MxChat_Public')) {
1703 664 $mxchat_public = new MxChat_Public();
1704 665 }
@@ -1703,9 +664,8 @@
1703 664 $mxchat_public = new MxChat_Public();
1704 665 }
1705 666
1706 667 if (class_exists('MxChat_Integrator')) {
1707 - global $mxchat_integrator;
1708 668 $mxchat_integrator = new MxChat_Integrator();
1709 669 }
1710 670
1711 671 } catch (Exception $e) {
@@ -1725,74 +685,8 @@
1725 685
1726 686 // Run initialization on plugins_loaded
1727 687 add_action('plugins_loaded', 'mxchat_init');
1728 688
1729 -// Run migration check on admin init (for auto-updates without reactivation)
1730 -add_action('admin_init', 'mxchat_check_and_run_migrations');
1731 -
1732 -/**
1733 - * Check and run migrations on admin init
1734 - * This ensures migrations run even when plugin is auto-updated
1735 - */
1736 -function mxchat_check_and_run_migrations() {
1737 - // Only run in admin and not on every request
1738 - static $checked = false;
1739 - if ($checked) {
1740 - return;
1741 - }
1742 - $checked = true;
1743 -
1744 - mxchat_migrate_pinecone_roles_add_bot_id();
1745 - mxchat_migrate_add_content_type_column();
1746 - mxchat_migrate_add_translations_table();
1747 - mxchat_migrate_add_session_ratings_table();
1748 -}
1749 -
1750 -/**
1751 - * Migration: Create per-session satisfaction ratings table (v3.2.6)
1752 - * For users upgrading from versions before 3.2.6
1753 - */
1754 -function mxchat_migrate_add_session_ratings_table() {
1755 - $migration_key = 'mxchat_session_ratings_table_created';
1756 - if (get_option($migration_key)) {
1757 - return;
1758 - }
1759 - mxchat_create_session_ratings_table();
1760 - update_option($migration_key, '3.2.6');
1761 -}
1762 -
1763 -/**
1764 - * Migration: Create transcript translations table (v3.0.4)
1765 - * For users upgrading from versions before 3.0.4
1766 - */
1767 -function mxchat_migrate_add_translations_table() {
1768 - $migration_key = 'mxchat_translations_table_created';
1769 -
1770 - // Check if migration already ran
1771 - if (get_option($migration_key)) {
1772 - return;
1773 - }
1774 -
1775 - // Create the translations table
1776 - mxchat_create_translations_table();
1777 -
1778 - // Mark migration as complete
1779 - update_option($migration_key, '3.0.4');
1780 -}
1781 -
1782 -/**
1783 - * Migration: Update deprecated Gemini embedding model (v3.0.5)
1784 - * Updates gemini-embedding-exp-03-07 to gemini-embedding-001 for users who had it selected
1785 - */
1786 -function mxchat_migrate_gemini_embedding_model() {
1787 - $options = get_option('mxchat_options', array());
1788 -
1789 - if (isset($options['embedding_model']) && $options['embedding_model'] === 'gemini-embedding-exp-03-07') {
1790 - $options['embedding_model'] = 'gemini-embedding-001';
1791 - update_option('mxchat_options', $options);
1792 - }
1793 -}
1794 -
1795 689 // Register activation hook
1796 690 register_activation_hook(__FILE__, 'mxchat_activate');
1797 691
1798 692 // Add cron schedule
@@ -1804,67 +698,5 @@
1804 698 return $schedules;
1805 699 });
1806 700
1807 701 // Register deactivation hook
1808 -register_deactivation_hook(__FILE__, 'mxchat_deactivate');
1809 -
1810 -/**
1811 - * Per-session satisfaction rating: AJAX save handler (v3.2.6).
1812 - * Records one 👍/👎 + optional feedback per chat session. The UNIQUE KEY on
1813 - * session_id makes this naturally idempotent — only the first rating per
1814 - * session is stored; duplicate POSTs are silent no-ops.
1815 - */
1816 -function mxchat_save_session_rating() {
1817 - global $wpdb;
1818 -
1819 - $session_id = isset($_POST['session_id']) ? MxChat_Utils::sanitize_session_id(wp_unslash($_POST['session_id'])) : '';
1820 - $bot_id = isset($_POST['bot_id']) ? sanitize_text_field(wp_unslash($_POST['bot_id'])) : 'default';
1821 - $rating_raw = isset($_POST['rating']) ? (int) $_POST['rating'] : 0;
1822 - $feedback = isset($_POST['feedback']) ? sanitize_textarea_field(wp_unslash($_POST['feedback'])) : '';
1823 -
1824 - if ($session_id === '' || ($rating_raw !== 1 && $rating_raw !== -1)) {
1825 - wp_send_json_error(array('message' => 'invalid_input'), 400);
1826 - }
1827 -
1828 - if (strlen($feedback) > 1000) {
1829 - $feedback = substr($feedback, 0, 1000);
1830 - }
1831 -
1832 - $table_name = $wpdb->prefix . 'mxchat_session_ratings';
1833 - $existing = $wpdb->get_var($wpdb->prepare(
1834 - "SELECT id FROM $table_name WHERE session_id = %s LIMIT 1",
1835 - $session_id
1836 - ));
1837 -
1838 - if ($existing) {
1839 - if ($feedback !== '') {
1840 - $wpdb->update(
1841 - $table_name,
1842 - array('rating_feedback' => $feedback),
1843 - array('id' => (int) $existing),
1844 - array('%s'),
1845 - array('%d')
1846 - );
1847 - }
1848 - wp_send_json_success(array('updated' => true));
1849 - }
1850 -
1851 - $inserted = $wpdb->insert(
1852 - $table_name,
1853 - array(
1854 - 'session_id' => $session_id,
1855 - 'bot_id' => $bot_id !== '' ? $bot_id : 'default',
1856 - 'rating_value' => $rating_raw,
1857 - 'rating_feedback' => $feedback !== '' ? $feedback : null,
1858 - 'created_at' => current_time('mysql'),
1859 - ),
1860 - array('%s', '%s', '%d', '%s', '%s')
1861 - );
1862 -
1863 - if ($inserted === false) {
1864 - wp_send_json_error(array('message' => 'db_insert_failed'), 500);
1865 - }
1866 -
1867 - wp_send_json_success(array('saved' => true));
1868 -}
1869 -add_action('wp_ajax_mxchat_save_rating', 'mxchat_save_session_rating');
1870 -add_action('wp_ajax_nopriv_mxchat_save_rating', 'mxchat_save_session_rating');
702 +register_deactivation_hook(__FILE__, 'mxchat_deactivate');