← All changes | mxchat-basic.php +10 -292 3.2.7 → 3.1.5 View file →

		@@ -2,9 +2,9 @@
2	2	/**
3	3	* Plugin Name: MxChat
4	4	* Plugin URI: https://mxchat.ai/
5	5	* Description: AI chatbot for WordPress with OpenAI, Claude, xAI, DeepSeek, live agent, PDF uploads, WooCommerce, and training on website data.
6		- * Version: 3.2.7
	6	+ * Version: 3.1.5
7	7	* Author: MxChat
8	8	* Author URI: https://mxchat.ai
9	9	* License: GPLv2 or later
10	10	* License URI: https://www.gnu.org/licenses/gpl-2.0.html
		@@ -46,51 +46,8 @@
46	46	}
47	47	add_action('init', 'mxchat_load_textdomain');
48	48
49	49	/**
50		- * One-time migration: gemini-3-pro-preview was shut down by Google on March 9, 2026.
51		- * Existing installs with the dead ID get auto-remapped to gemini-3.1-pro-preview
52		- * (Google's official migration target) the first time admin_init fires after update.
53		- */
54		-add_action('admin_init', function () {
55		- if (get_option('mxchat_gemini_3_remap_done')) {
56		- return;
57		- }
58		- $opts = get_option('mxchat_options');
59		- if (is_array($opts) && isset($opts['model']) && $opts['model'] === 'gemini-3-pro-preview') {
60		- $opts['model'] = 'gemini-3.1-pro-preview';
61		- update_option('mxchat_options', $opts);
62		- }
63		- if (is_array($opts) && isset($opts['content_model']) && $opts['content_model'] === 'gemini-3-pro-preview') {
64		- $opts['content_model'] = 'gemini-3.1-pro-preview';
65		- update_option('mxchat_options', $opts);
66		- }
67		- update_option('mxchat_gemini_3_remap_done', 1);
68		-});
69		-
70		-/**
71		- * One-time migration: the Grok 2 family was retired by xAI (grok-2, grok-2-1212,
72		- * grok-2-latest, grok-2-vision-1212 all return 400 "Model not found"). Existing
73		- * installs with the dead ID get auto-remapped to grok-4-1-fast-non-reasoning
74		- * (modern, fast, broadly available) the first time admin_init fires after update.
75		- */
76		-add_action('admin_init', function () {
77		- if (get_option('mxchat_grok_2_remap_done')) {
78		- return;
79		- }
80		- $opts = get_option('mxchat_options');
81		- if (is_array($opts) && isset($opts['model']) && $opts['model'] === 'grok-2') {
82		- $opts['model'] = 'grok-4-1-fast-non-reasoning';
83		- update_option('mxchat_options', $opts);
84		- }
85		- if (is_array($opts) && isset($opts['content_model']) && $opts['content_model'] === 'grok-2') {
86		- $opts['content_model'] = 'grok-4-1-fast-non-reasoning';
87		- update_option('mxchat_options', $opts);
88		- }
89		- update_option('mxchat_grok_2_remap_done', 1);
90		-});
91		-
92		-/**
93	50	* Exclude MxChat assets from caching plugin optimizations
94	51	*
95	52	* This prevents issues with WP Rocket, LiteSpeed Cache, Autoptimize, WP Super Cache,
96	53	* W3 Total Cache, SG Optimizer, and similar plugins that may break the chatbot by
		@@ -293,61 +250,8 @@
293	250	$rejected[] = 'wp-admin/admin-ajax.php';
294	251	return $rejected;
295	252	});
296	253
297		-// ── Page-cache bypass for chat AJAX (companion to the 3.2.6 nonce-race hotfix)
298		-// Each cache plugin gets its own filter export so that visitors hitting an
299		-// edge-cached page never receive cached chat-AJAX responses. The chat send /
300		-// stream send / file upload all POST to /wp-admin/admin-ajax.php with
301		-// `action=mxchat_*`. Without these exports, a cache plugin can stale a response
302		-// and break the per-session nonce flow on the first message.
303		-
304		-// WP Rocket — `rocket_cache_reject_uri` takes a flat array of regex strings.
305		-add_filter('rocket_cache_reject_uri', function($uris) {
306		- if (!is_array($uris)) $uris = array();
307		- $uris[] = '/wp-admin/admin-ajax\.php\?action=mxchat_.*';
308		- return $uris;
309		-});
310		-
311		-// LiteSpeed Cache — `litespeed_cache_no_cache_for_request` short-circuits
312		-// caching when the request matches our chat-AJAX pattern.
313		-add_filter('litespeed_cache_no_cache_for_request', function($no_cache) {
314		- if ($no_cache) return $no_cache;
315		- if (!empty($_SERVER['REQUEST_URI']) &&
316		- strpos($_SERVER['REQUEST_URI'], '/wp-admin/admin-ajax.php') !== false &&
317		- !empty($_REQUEST['action']) &&
318		- strpos((string) $_REQUEST['action'], 'mxchat_') === 0) {
319		- return true;
320		- }
321		- return $no_cache;
322		-});
323		-
324		-// W3 Total Cache — `w3tc_pgcache_request_skip_uri` flips page-cache off when
325		-// the URI matches.
326		-add_filter('w3tc_pgcache_request_skip_uri', function($skip) {
327		- if ($skip) return $skip;
328		- if (!empty($_SERVER['REQUEST_URI']) &&
329		- strpos($_SERVER['REQUEST_URI'], '/wp-admin/admin-ajax.php') !== false &&
330		- !empty($_REQUEST['action']) &&
331		- strpos((string) $_REQUEST['action'], 'mxchat_') === 0) {
332		- return true;
333		- }
334		- return $skip;
335		-});
336		-
337		-// FlyingPress — `flying_press_cacheable` takes a boolean and is run per
338		-// request. Same pattern as LiteSpeed / W3TC.
339		-add_filter('flying_press_cacheable', function($cacheable) {
340		- if (!$cacheable) return $cacheable;
341		- if (!empty($_SERVER['REQUEST_URI']) &&
342		- strpos($_SERVER['REQUEST_URI'], '/wp-admin/admin-ajax.php') !== false &&
343		- !empty($_REQUEST['action']) &&
344		- strpos((string) $_REQUEST['action'], 'mxchat_') === 0) {
345		- return false;
346		- }
347		- return $cacheable;
348		-});
349		-
350	254	// Include classes with error handling
351	255	function mxchat_include_classes() {
352	256	$class_files = array(
353	257	'includes/class-mxchat-integrator.php',
		@@ -358,9 +262,8 @@
358	262	'includes/class-mxchat-meta-box.php',
359	263	'includes/class-mxchat-chunker.php',
360	264	'includes/class-mxchat-word-handler.php',
361	265	'includes/class-mxchat-content-generator.php',
362		- 'includes/class-rest-api.php',
363	266	'admin/class-ajax-handler.php',
364	267	'admin/class-pinecone-manager.php',
365	268	'admin/class-knowledge-manager.php'
366	269	);
		@@ -372,26 +275,8 @@
372	275	} else {
373	276	//error_log('MxChat: Missing class file - ' . $file);
374	277	}
375	278	}
376		-
377		- // Admin pages that aren't classes (procedural include).
378		- if (is_admin()) {
379		- $admin_api_page = plugin_dir_path(__FILE__) . 'includes/admin-api-page.php';
380		- if (file_exists($admin_api_page)) {
381		- require_once $admin_api_page;
382		- }
383		- // f7c7d4 renamed this file admin-dashboard-page.php → admin-onboarding-page.php.
384		- // The require MUST live here (admin bootstrap) and not just inside
385		- // mxchat_add_plugin_page() on the admin_menu hook — admin_menu does NOT
386		- // fire on admin-ajax.php requests, so the wizard's AJAX handlers
387		- // (plan-905439: mxchat_onboarding_kb_status / save_step / mark_step /
388		- // auto_graduate + the f7c7d4 dismiss handler) would never register.
389		- $admin_onboarding_page = plugin_dir_path(__FILE__) . 'includes/admin-onboarding-page.php';
390		- if (file_exists($admin_onboarding_page)) {
391		- require_once $admin_onboarding_page;
392		- }
393		- }
394	279	}
395	280
396	281	/**
397	282	* Lazy-load the PDF parser library only when needed.
		@@ -723,33 +608,8 @@
723	608	update_option('mxchat_content_type_migration_version', '2.5.6');
724	609	}
725	610
726	611	/**
727		- * 3.2.4: Backfill the active embedding model option for installs that already
728		- * have KB content but no stamped model. The mismatch warning compares this
729		- * against the user's currently selected model — no per-row column needed.
730		- */
731		-function mxchat_backfill_active_embedding_model() {
732		- global $wpdb;
733		-
734		- if (get_option('mxchat_active_embedding_model', '') !== '') {
735		- return;
736		- }
737		-
738		- $kb_table = $wpdb->prefix . 'mxchat_system_prompt_content';
739		- if ($wpdb->get_var("SHOW TABLES LIKE '{$kb_table}'") !== $kb_table) {
740		- return;
741		- }
742		-
743		- $kb_count = (int) $wpdb->get_var("SELECT COUNT(*) FROM {$kb_table}");
744		- if ($kb_count > 0) {
745		- $options = get_option('mxchat_options', array());
746		- $current_model = $options['embedding_model'] ?? 'text-embedding-ada-002';
747		- update_option('mxchat_active_embedding_model', $current_model, false);
748		- }
749		-}
750		-
751		-/**
752	612	* 2.5.2: Create queue processing tables for reliable background processing
753	613	*/
754	614	function mxchat_create_queue_tables() {
755	615	global $wpdb;
		@@ -821,34 +681,8 @@
821	681	dbDelta($sql);
822	682	}
823	683
824	684	/**
825		- * Create per-session satisfaction ratings table (v3.2.6)
826		- * Stores one 👍/👎 rating + optional feedback per chat session.
827		- */
828		-function mxchat_create_session_ratings_table() {
829		- global $wpdb;
830		- $charset_collate = $wpdb->get_charset_collate();
831		-
832		- $table_name = $wpdb->prefix . 'mxchat_session_ratings';
833		- $sql = "CREATE TABLE $table_name (
834		- id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
835		- session_id varchar(255) NOT NULL,
836		- bot_id varchar(50) NOT NULL DEFAULT 'default',
837		- rating_value tinyint(1) NOT NULL,
838		- rating_feedback text DEFAULT NULL,
839		- created_at datetime NOT NULL,
840		- PRIMARY KEY (id),
841		- UNIQUE KEY session_id (session_id),
842		- KEY bot_id (bot_id),
843		- KEY created_at (created_at)
844		- ) $charset_collate;";
845		-
846		- require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
847		- dbDelta($sql);
848		-}
849		-
850		-/**
851	685	* 2.5.2: Fix URL column size to support long URLs (especially with UTF-8 encoding)
852	686	* This fixes "url, source_url. The supplied values may be too long" errors
853	687	*/
854	688	function mxchat_fix_url_column_size() {
		@@ -907,9 +741,9 @@
907	741	if (in_array($current_model, $deprecated_claude_models, true)) {
908	742	$options['model'] = 'claude-opus-4-6';
909	743	$migrated = true;
910	744	$migration_message = sprintf(
911		- 'Your chatbot model has been automatically updated from %s to Claude Opus 4.6 due to Anthropic deprecating older Claude models.',
	745	+ __('Your chatbot model has been automatically updated from %s to Claude Opus 4.6 due to Anthropic deprecating older Claude models.', 'mxchat'),
912	746	$current_model
913	747	);
914	748	}
915	749
		@@ -916,9 +750,9 @@
916	750	// Migrate deprecated Claude Haiku 3.5 to Claude Haiku 4.5
917	751	if ($current_model === 'claude-3-5-haiku-20241022') {
918	752	$options['model'] = 'claude-haiku-4-5-20251001';
919	753	$migrated = true;
920		- $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.';
	754	+ $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.', 'mxchat');
921	755	}
922	756
923	757	// Migrate deprecated GPT-4 series and GPT-3.5 Turbo to GPT-5.1 Chat Latest
924	758	if (in_array($current_model, array('gpt-4o', 'gpt-4.1-2025-04-14', 'gpt-4-turbo', 'gpt-4', 'gpt-3.5-turbo'), true)) {
		@@ -924,9 +758,9 @@
924	758	if (in_array($current_model, array('gpt-4o', 'gpt-4.1-2025-04-14', 'gpt-4-turbo', 'gpt-4', 'gpt-3.5-turbo'), true)) {
925	759	$options['model'] = 'gpt-5.1-chat-latest';
926	760	$migrated = true;
927	761	$migration_message = sprintf(
928		- 'Your chatbot model has been automatically updated from %s to GPT-5.1 Chat Latest due to OpenAI deprecating older models.',
	762	+ __('Your chatbot model has been automatically updated from %s to GPT-5.1 Chat Latest due to OpenAI deprecating older models.', 'mxchat'),
929	763	$current_model
930	764	);
931	765	}
932	766
		@@ -934,9 +768,9 @@
934	768	if (in_array($current_model, array('gpt-4o-mini', 'gpt-4.1-mini'), true)) {
935	769	$options['model'] = 'gpt-5-mini';
936	770	$migrated = true;
937	771	$migration_message = sprintf(
938		- 'Your chatbot model has been automatically updated from %s to GPT-5 Mini due to OpenAI deprecating GPT-4 series models.',
	772	+ __('Your chatbot model has been automatically updated from %s to GPT-5 Mini due to OpenAI deprecating GPT-4 series models.', 'mxchat'),
939	773	$current_model
940	774	);
941	775	}
942	776
		@@ -1003,26 +837,13 @@
1003	837	enabled_bots LONGTEXT DEFAULT NULL,
1004	838	PRIMARY KEY (id)
1005	839	) $charset_collate;";
1006	840
1007		- // Individual Intent Phrases Table - each phrase gets its own embedding vector
1008		- $intent_phrases_table = $wpdb->prefix . 'mxchat_intent_phrases';
1009		- $sql_intent_phrases_table = "CREATE TABLE $intent_phrases_table (
1010		- id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
1011		- intent_id BIGINT(20) UNSIGNED NOT NULL,
1012		- phrase TEXT NOT NULL,
1013		- embedding_vector LONGTEXT NOT NULL,
1014		- created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
1015		- PRIMARY KEY (id),
1016		- KEY intent_id (intent_id)
1017		- ) $charset_collate;";
1018		-
1019	841	require_once ABSPATH . 'wp-admin/includes/upgrade.php';
1020	842
1021	843	// Create other tables
1022	844	dbDelta($sql_system_prompt);
1023	845	dbDelta($sql_intents_table);
1024		- dbDelta($sql_intent_phrases_table);
1025	846
1026	847	// Create URL click tracking table
1027	848	mxchat_create_url_clicks_table();
1028	849
		@@ -1034,11 +855,8 @@
1034	855
1035	856	// Create transcript translations table
1036	857	mxchat_create_translations_table();
1037	858
1038		- // Create per-session satisfaction ratings table (v3.2.6)
1039		- mxchat_create_session_ratings_table();
1040		-
1041	859	// Ensure additional columns in system prompt table
1042	860	$existing_system_columns = $wpdb->get_results("SHOW COLUMNS FROM $system_prompt_table");
1043	861	if (!empty($existing_system_columns)) {
1044	862	$existing_system_column_names = array_column($existing_system_columns, 'Field');
		@@ -1081,11 +899,8 @@
1081	899
1082	900	// Run migration for existing installations
1083	901	mxchat_migrate_pinecone_roles_add_bot_id();
1084	902
1085		- // 3.2.4: Backfill active embedding model option (replaces 3.2.3 column-based tracking)
1086		- mxchat_backfill_active_embedding_model();
1087		-
1088	903	// Setup cron jobs
1089	904	mxchat_setup_cron_jobs();
1090	905
1091	906	// Update version
		@@ -1120,14 +935,13 @@
1120	935	// Clear fallback flags if cron scheduling succeeded
1121	936	delete_option('mxchat_use_fallback_rate_limits');
1122	937	}
1123	938
1124		- // Schedule transcript cleanup if configured (bucket dropdown OR custom retention-days > 0)
	939	+ // Schedule transcript cleanup if configured
1125	940	$transcript_options = get_option('mxchat_transcripts_options', array());
1126	941	$cleanup_interval = isset($transcript_options['mxchat_auto_delete_transcripts']) ? $transcript_options['mxchat_auto_delete_transcripts'] : 'never';
1127		- $custom_retention = isset($transcript_options['mxchat_retention_days']) ? (int) $transcript_options['mxchat_retention_days'] : 0;
1128		-
1129		- if ($cleanup_interval !== 'never' || $custom_retention > 0) {
	942	+
	943	+ if ($cleanup_interval !== 'never') {
1130	944	// Check if not already scheduled
1131	945	if (!wp_next_scheduled('mxchat_cleanup_old_transcripts')) {
1132	946	// Schedule to run daily at 3 AM
1133	947	$next_run = strtotime('tomorrow 3:00 AM');
		@@ -1255,20 +1069,8 @@
1255	1069	if (version_compare($current_version, '3.1.2', '<')) {
1256	1070	mxchat_migrate_transcripts_charset();
1257	1071	}
1258	1072
1259		- // 3.1.7: Clean up stale shared session email/name entries
1260		- if (version_compare($current_version, '3.1.7', '<')) {
1261		- delete_option('mxchat_email_null');
1262		- delete_option('mxchat_name_null');
1263		- }
1264		-
1265		- // 3.2.4: Backfill active embedding model option for the warning UI
1266		- // (replaces the per-row column tracking from 3.2.3, which was reverted)
1267		- if (version_compare($current_version, '3.2.4', '<')) {
1268		- mxchat_backfill_active_embedding_model();
1269		- }
1270		-
1271	1073	// Run full activation to ensure everything is up to date
1272	1074	mxchat_activate();
1273	1075
1274	1076	// Run migration functions
		@@ -1439,9 +1241,9 @@
1439	1241	// Check if we're upgrading TO 3.0.1 and haven't handled this yet
1440	1242	if (version_compare($current_version, $target_version, '<') && !$update_handled) {
1441	1243	// Check if Pro is activated - only show to Pro users
1442	1244	$license_status = get_option('mxchat_license_status', 'inactive');
1443		- $is_pro = ($license_status === 'active');
	1245	+ $is_pro = ($license_status === 'active' || $license_status === esc_html__('active', 'mxchat'));
1444	1246
1445	1247	if ($is_pro) {
1446	1248	// Set flag to show the theme migration notification banner
1447	1249	update_option('mxchat_show_theme_migration_notice', true);
		@@ -1493,16 +1295,8 @@
1493	1295	if (class_exists('MxChat_Content_Generator')) {
1494	1296	new MxChat_Content_Generator();
1495	1297	}
1496	1298
1497		- // Initialize REST API globally — endpoints must be registered on
1498		- // every request (admin and frontend) so they're reachable via /wp-json/.
1499		- // Endpoints are auth-gated and locked until the site owner generates
1500		- // a token in MxChat → API Access.
1501		- if (class_exists('MxChat_Rest_Api')) {
1502		- new MxChat_Rest_Api();
1503		- }
1504		-
1505	1299	// Initialize public classes
1506	1300	if (class_exists('MxChat_Public')) {
1507	1301	$mxchat_public = new MxChat_Public();
1508	1302	}
		@@ -1547,25 +1341,11 @@
1547	1341
1548	1342	mxchat_migrate_pinecone_roles_add_bot_id();
1549	1343	mxchat_migrate_add_content_type_column();
1550	1344	mxchat_migrate_add_translations_table();
1551		- mxchat_migrate_add_session_ratings_table();
1552	1345	}
1553	1346
1554	1347	/**
1555		- * Migration: Create per-session satisfaction ratings table (v3.2.6)
1556		- * For users upgrading from versions before 3.2.6
1557		- */
1558		-function mxchat_migrate_add_session_ratings_table() {
1559		- $migration_key = 'mxchat_session_ratings_table_created';
1560		- if (get_option($migration_key)) {
1561		- return;
1562		- }
1563		- mxchat_create_session_ratings_table();
1564		- update_option($migration_key, '3.2.6');
1565		-}
1566		-
1567		-/**
1568	1348	* Migration: Create transcript translations table (v3.0.4)
1569	1349	* For users upgrading from versions before 3.0.4
1570	1350	*/
1571	1351	function mxchat_migrate_add_translations_table() {
		@@ -1608,67 +1388,5 @@
1608	1388	return $schedules;
1609	1389	});
1610	1390
1611	1391	// Register deactivation hook
1612		-register_deactivation_hook(__FILE__, 'mxchat_deactivate');
1613		-
1614		-/**
1615		- * Per-session satisfaction rating: AJAX save handler (v3.2.6).
1616		- * Records one 👍/👎 + optional feedback per chat session. The UNIQUE KEY on
1617		- * session_id makes this naturally idempotent — only the first rating per
1618		- * session is stored; duplicate POSTs are silent no-ops.
1619		- */
1620		-function mxchat_save_session_rating() {
1621		- global $wpdb;
1622		-
1623		- $session_id = isset($_POST['session_id']) ? sanitize_text_field(wp_unslash($_POST['session_id'])) : '';
1624		- $bot_id = isset($_POST['bot_id']) ? sanitize_text_field(wp_unslash($_POST['bot_id'])) : 'default';
1625		- $rating_raw = isset($_POST['rating']) ? (int) $_POST['rating'] : 0;
1626		- $feedback = isset($_POST['feedback']) ? sanitize_textarea_field(wp_unslash($_POST['feedback'])) : '';
1627		-
1628		- if ($session_id === '' || ($rating_raw !== 1 && $rating_raw !== -1)) {
1629		- wp_send_json_error(array('message' => 'invalid_input'), 400);
1630		- }
1631		-
1632		- if (strlen($feedback) > 1000) {
1633		- $feedback = substr($feedback, 0, 1000);
1634		- }
1635		-
1636		- $table_name = $wpdb->prefix . 'mxchat_session_ratings';
1637		- $existing = $wpdb->get_var($wpdb->prepare(
1638		- "SELECT id FROM $table_name WHERE session_id = %s LIMIT 1",
1639		- $session_id
1640		- ));
1641		-
1642		- if ($existing) {
1643		- if ($feedback !== '') {
1644		- $wpdb->update(
1645		- $table_name,
1646		- array('rating_feedback' => $feedback),
1647		- array('id' => (int) $existing),
1648		- array('%s'),
1649		- array('%d')
1650		- );
1651		- }
1652		- wp_send_json_success(array('updated' => true));
1653		- }
1654		-
1655		- $inserted = $wpdb->insert(
1656		- $table_name,
1657		- array(
1658		- 'session_id' => $session_id,
1659		- 'bot_id' => $bot_id !== '' ? $bot_id : 'default',
1660		- 'rating_value' => $rating_raw,
1661		- 'rating_feedback' => $feedback !== '' ? $feedback : null,
1662		- 'created_at' => current_time('mysql'),
1663		- ),
1664		- array('%s', '%s', '%d', '%s', '%s')
1665		- );
1666		-
1667		- if ($inserted === false) {
1668		- wp_send_json_error(array('message' => 'db_insert_failed'), 500);
1669		- }
1670		-
1671		- wp_send_json_success(array('saved' => true));
1672		-}
1673		-add_action('wp_ajax_mxchat_save_rating', 'mxchat_save_session_rating');
1674		-add_action('wp_ajax_nopriv_mxchat_save_rating', 'mxchat_save_session_rating');
	1392	+register_deactivation_hook(__FILE__, 'mxchat_deactivate');