← All changes | mxchat-basic.php +68 -103 2.0.3 → 1.3 View file →

		@@ -1,15 +1,13 @@
1	1	<?php
2	2	/**
3	3	* Plugin Name: MxChat
4		- * Description: AI chatbot for WordPress with OpenAI, Claude, xAI, DeepSeek, live agent, PDF uploads, WooCommerce, and training on website data.
5		- * Version: 2.0.3
	4	+ * Description: AI Chatbot for WordPress with support for OpenAI, X.AI, and Claude models. Includes features like custom knowledge submission, chat transcripts, and seamless integration with WooCommerce. Perfect for blogs, business sites, e-commerce platforms, and more, offering real-time intelligent interactions with advanced AI models.
	5	+ * Version: 1.3
6	6	* Author: MxChat
7	7	* Author URI: https://mxchat.ai
8	8	* License: GPLv2 or later
9	9	* License URI: https://www.gnu.org/licenses/gpl-2.0.html
10		- * Text Domain: mxchat
11		- * Domain Path: /languages
12	10	*/
13	11
14	12	if (!defined('ABSPATH')) {
15	13	exit; // Exit if accessed directly.
		@@ -14,14 +12,8 @@
14	12	if (!defined('ABSPATH')) {
15	13	exit; // Exit if accessed directly.
16	14	}
17	15
18		-
19		-function mxchat_load_textdomain() {
20		- load_plugin_textdomain('mxchat', false, dirname(plugin_basename(__FILE__)) . '/languages');
21		-}
22		-add_action('plugins_loaded', 'mxchat_load_textdomain');
23		-
24	16	// Include classes
25	17	require_once plugin_dir_path(__FILE__) . 'includes/class-mxchat-integrator.php';
26	18	require_once plugin_dir_path(__FILE__) . 'includes/class-mxchat-admin.php';
27	19	require_once plugin_dir_path(__FILE__) . 'includes/class-mxchat-public.php';
		@@ -27,10 +19,8 @@
27	19	require_once plugin_dir_path(__FILE__) . 'includes/class-mxchat-public.php';
28	20	require_once plugin_dir_path(__FILE__) . 'includes/class-mxchat-utils.php';
29	21	require_once plugin_dir_path(__FILE__) . 'includes/class-mxchat-user.php';
30	22	require_once plugin_dir_path(__FILE__) . 'includes/class-mxchat-woocommerce.php';
31		-require_once plugin_dir_path(__FILE__) . 'includes/pdf-parser/alt_autoload.php';
32		-require_once plugin_dir_path(__FILE__) . 'includes/class-mxchat-word-handler.php';
33	23
34	24	function mxchat_activate() {
35	25	global $wpdb;
36	26	$charset_collate = $wpdb->get_charset_collate();
		@@ -37,29 +27,27 @@
37	27
38	28	// Chat Transcripts Table
39	29	$chat_transcripts_table = $wpdb->prefix . 'mxchat_chat_transcripts';
40	30	$sql_chat_transcripts = "CREATE TABLE $chat_transcripts_table (
41		- id MEDIUMINT(9) NOT NULL AUTO_INCREMENT,
42		- user_id MEDIUMINT(9) DEFAULT 0,
43		- session_id VARCHAR(255) NOT NULL,
44		- role VARCHAR(255) NOT NULL,
45		- message TEXT NOT NULL,
46		- user_email VARCHAR(255) DEFAULT NULL,
47		- timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
48		- PRIMARY KEY (id)
49		- ) $charset_collate;";
	31	+ id mediumint(9) NOT NULL AUTO_INCREMENT,
	32	+ user_id mediumint(9) DEFAULT 0,
	33	+ session_id varchar(255) NOT NULL,
	34	+ role varchar(255) NOT NULL,
	35	+ message text NOT NULL,
	36	+ timestamp timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
	37	+ PRIMARY KEY (id)
	38	+ );";
50	39
51	40	// System Prompt Content Table
52	41	$system_prompt_table = $wpdb->prefix . 'mxchat_system_prompt_content';
53	42	$sql_system_prompt = "CREATE TABLE $system_prompt_table (
54		- id MEDIUMINT(9) NOT NULL AUTO_INCREMENT,
55		- url VARCHAR(255) NOT NULL,
56		- article_content LONGTEXT NOT NULL,
57		- embedding_vector LONGTEXT,
58		- source_url VARCHAR(255) DEFAULT NULL,
59		- timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
60		- PRIMARY KEY (id)
61		- ) $charset_collate;";
	43	+ id mediumint(9) NOT NULL AUTO_INCREMENT,
	44	+ url varchar(255) NOT NULL,
	45	+ article_content longtext NOT NULL,
	46	+ embedding_vector longtext,
	47	+ timestamp timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
	48	+ PRIMARY KEY (id)
	49	+ );";
62	50
63	51	// Intents Table
64	52	$intents_table = $wpdb->prefix . 'mxchat_intents';
65	53	$sql_intents_table = "CREATE TABLE $intents_table (
		@@ -67,107 +55,84 @@
67	55	intent_label VARCHAR(255) NOT NULL,
68	56	phrases TEXT NOT NULL,
69	57	embedding_vector LONGTEXT NOT NULL,
70	58	callback_function VARCHAR(255) NOT NULL,
71		- similarity_threshold FLOAT DEFAULT 0.85,
72		- PRIMARY KEY (id)
	59	+ PRIMARY KEY (id)
73	60	) $charset_collate;";
74	61
75		- require_once ABSPATH . 'wp-admin/includes/upgrade.php';
	62	+ require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
76	63
77		- // Create or update tables
	64	+ // Create or update the chat transcripts table
78	65	dbDelta($sql_chat_transcripts);
	66	+
	67	+ // Create or update the system prompt content table
79	68	dbDelta($sql_system_prompt);
	69	+
	70	+ // Create or update the intents table
80	71	dbDelta($sql_intents_table);
81	72
82		- // Ensure additional columns in `mxchat_chat_transcripts`
83		- mxchat_add_missing_columns($chat_transcripts_table, 'user_identifier', 'VARCHAR(255)');
84		- mxchat_add_missing_columns($chat_transcripts_table, 'user_email', 'VARCHAR(255) DEFAULT NULL');
	73	+ // Ensure 'embedding_vector' column exists in the 'system_prompt_content' table
	74	+ $column_exists = $wpdb->get_results($wpdb->prepare(
	75	+ "SHOW COLUMNS FROM {$system_prompt_table} LIKE %s",
	76	+ 'embedding_vector'
	77	+ ));
	78	+ if (empty($column_exists)) {
	79	+ $wpdb->query(
	80	+ "ALTER TABLE {$system_prompt_table} ADD COLUMN embedding_vector longtext"
	81	+ );
	82	+ }
85	83
86		- // Ensure additional columns in `mxchat_system_prompt_content`
87		- mxchat_add_missing_columns($system_prompt_table, 'embedding_vector', 'LONGTEXT');
88		- mxchat_add_missing_columns($system_prompt_table, 'source_url', 'VARCHAR(255) DEFAULT NULL');
	84	+ // Ensure 'source_url' column exists in the 'system_prompt_content' table
	85	+ $source_url_exists = $wpdb->get_results($wpdb->prepare(
	86	+ "SHOW COLUMNS FROM {$system_prompt_table} LIKE %s",
	87	+ 'source_url'
	88	+ ));
	89	+ if (empty($source_url_exists)) {
	90	+ $wpdb->query(
	91	+ "ALTER TABLE {$system_prompt_table} ADD COLUMN source_url VARCHAR(255) DEFAULT NULL"
	92	+ );
	93	+ }
89	94
90		- // Set default thresholds for existing intents
91		- $wpdb->query("UPDATE {$intents_table} SET similarity_threshold = 0.85 WHERE similarity_threshold IS NULL");
	95	+ // Ensure 'user_identifier' and 'user_email' columns exist in the 'chat_transcripts' table
	96	+ $user_identifier_exists = $wpdb->get_results($wpdb->prepare(
	97	+ "SHOW COLUMNS FROM {$chat_transcripts_table} LIKE %s",
	98	+ 'user_identifier'
	99	+ ));
	100	+ if (empty($user_identifier_exists)) {
	101	+ $wpdb->query(
	102	+ "ALTER TABLE {$chat_transcripts_table} ADD COLUMN user_identifier VARCHAR(255)"
	103	+ );
	104	+ }
92	105
93		- // Update plugin version in the database
94		- update_option('mxchat_plugin_version', '2.0.3');
95		-}
	106	+ $user_email_exists = $wpdb->get_results($wpdb->prepare(
	107	+ "SHOW COLUMNS FROM {$chat_transcripts_table} LIKE %s",
	108	+ 'user_email'
	109	+ ));
	110	+ if (empty($user_email_exists)) {
	111	+ $wpdb->query(
	112	+ "ALTER TABLE {$chat_transcripts_table} ADD COLUMN user_email VARCHAR(255)"
	113	+ );
	114	+ }
96	115
97		-
98		-function mxchat_add_missing_columns($table, $column_name, $column_type) {
99		- global $wpdb;
100		- $column_exists = $wpdb->get_results($wpdb->prepare("SHOW COLUMNS FROM $table LIKE %s", $column_name));
101		- if (empty($column_exists)) {
102		- $wpdb->query("ALTER TABLE $table ADD COLUMN $column_name $column_type");
103		- }
	116	+ // Update the version number in the database
	117	+ update_option('mxchat_plugin_version', '1.3');
104	118	}
105	119
106	120	function mxchat_check_for_update() {
107	121	$current_version = get_option('mxchat_plugin_version');
108		- $plugin_version = '2.0.3'; // Update with your latest version
	122	+ $plugin_version = '1.3';
109	123
110	124	if ($current_version !== $plugin_version) {
111		- mxchat_activate(); // Run the activation script to apply schema changes
112		- mxchat_migrate_live_agent_status(); // Add migration for live agent status
113		- update_option('mxchat_plugin_version', $plugin_version); // Update the version
	125	+ mxchat_activate(); // Run the activation script which includes database migrations
	126	+ update_option('mxchat_plugin_version', $plugin_version); // Update to the latest version
114	127	}
115	128	}
116	129
117		-function mxchat_migrate_live_agent_status() {
118		- $options = get_option('mxchat_options', []);
119		-
120		- // Check if live_agent_status exists
121		- if (isset($options['live_agent_status'])) {
122		- $current_status = $options['live_agent_status'];
123		- $needs_update = false;
124		-
125		- // Convert to new format if needed
126		- if ($current_status === 'online') {
127		- $options['live_agent_status'] = 'on';
128		- $needs_update = true;
129		- } else if ($current_status === 'offline') {
130		- $options['live_agent_status'] = 'off';
131		- $needs_update = true;
132		- } else if (!in_array($current_status, ['on', 'off'])) {
133		- // Default to off for any unexpected values
134		- $options['live_agent_status'] = 'off';
135		- $needs_update = true;
136		- }
137		-
138		- // Only update if needed
139		- if ($needs_update) {
140		- update_option('mxchat_options', $options);
141		- }
142		- } else {
143		- // If status doesn't exist, set default to off
144		- $options['live_agent_status'] = 'off';
145		- update_option('mxchat_options', $options);
146		- }
147		-}
148		-
149		-
150	130	// Run the update check function on every request
151	131	add_action('plugins_loaded', 'mxchat_check_for_update');
152	132
153	133	// Register activation hook
154	134	register_activation_hook(__FILE__, 'mxchat_activate');
155		-
156		-
157		-add_filter('cron_schedules', function($schedules) {
158		- $schedules['one_minute'] = array(
159		- 'interval' => 60,
160		- 'display' => 'Every Minute'
161		- );
162		- return $schedules;
163		-});
164		-
165		-add_action('init', function() {
166		- add_action('mxchat_process_pdf_pages', array('MxChat_Admin', 'process_pdf_pages_cron'), 10, 5);
167		- add_action('mxchat_process_sitemap_urls', array('MxChat_Admin', 'process_sitemap_urls_cron'), 10, 5);
168		-});
169		-
170	135
171	136	// Instantiate classes
172	137	if (is_admin()) {
173	138	$mxchat_admin = new MxChat_Admin();