learnpress / inc / class-lp-install.php

class-lp-install.php in LearnPress – WordPress LMS Plugin for Create and Sell Online Courses 4.4.9.1, at inc/class-lp-install.php

414 lines 11.6 KB

Raw Download Zip

1	<?php
2	/**
3	* Install and update functions.
4	*
5	* @author ThimPress
6	* @package LearnPress/Classes
7	* @version 3.0.1
8	*/
9
10	use LearnPress\Helpers\Config;
11
12	defined( 'ABSPATH' ) \|\| exit();
13
14	if ( ! function_exists( 'LP_Install' ) ) {
15
16	/**
17	* Class LP_Install
18	*/
19	class LP_Install {
20	protected static $instance;
21	protected $lp_db;
22	/**
23	* Default pages used by LP
24	*
25	* @var array
26	*/
27	private static $_pages = array(
28	'checkout',
29	'profile',
30	'courses',
31	'instructors',
32	'single_instructor',
33	'become_a_teacher',
34	'term_conditions',
35	);
36
37	protected function __construct() {
38	$this->lp_db = LP_Database::getInstance();
39	ini_set( 'max_execution_time', HOUR_IN_SECONDS );
40	// From LP v4.2.2 temporary run create table thim_cache.
41	// After a long time, will remove this code. Only run create table when activate plugin LP.
42	if ( ! LP_Settings::is_created_tb_thim_cache() ) {
43	$this->create_table_thim_cache();
44	}
45
46	// From LP v4.2.6.9 temporary run create table learnpress_files.
47	// After a long time, will remove this code. Only run create table when activate plugin LP.
48	if ( ! LP_Settings::is_created_tb_courses() ) {
49	$this->create_table_courses();
50	}
51
52	// From LP v4.2.6.6 temporary run create table learnpress_files.
53	// After a long time, will remove this code. Only run create table when activate plugin LP.
54	if ( ! LP_Settings::is_created_tb_material_files() ) {
55	$this->create_table_learnpress_files();
56	}
57
58	// Runtime migration for MCP API keys table.
59	if ( ! LP_Settings::is_created_tb_mcp_api_keys() ) {
60	$this->create_table_mcp_api_keys();
61	}
62
63	// Runtime migration for Webhooks table.
64	if ( ! LP_Settings::is_created_tb_webhooks() ) {
65	$this->create_table_webhooks();
66	}
67
68	// Set roles and capabilities.
69	learn_press_add_user_roles();
70
71	ini_set( 'max_execution_time', LearnPress::$time_limit_default_of_sever );
72	}
73
74	/**
75	* Get instance
76	*
77	* @return LP_Install
78	*/
79	public static function instance(): self {
80	if ( ! self::$instance ) {
81	self::$instance = new self();
82	}
83
84	return self::$instance;
85	}
86
87	/**
88	* Run installation tasks when LearnPress is activated.
89	*
90	* 1. Create required database tables.
91	* 2. Stop here if table creation failed.
92	* 3. Save the current database version.
93	* 4. Register LearnPress custom post types and taxonomies.
94	* 5. Create default pages (courses, profile, checkout, become a teacher, etc.).
95	* 6. Set permalink structure to post name if not configured.
96	* 7. Soft flush rewrite rules so WordPress rebuilds them with LP CPTs and pages on the next request.
97	*
98	* @since 4.0.0
99	*/
100	public function on_activate() {
101	$this->create_tables();
102
103	if ( ! $this->tables_install_done() ) {
104	return;
105	}
106
107	// Check if LP install before has db version
108	if ( ! get_option( LP_KEY_DB_VERSION, false ) ) {
109	// Save database version of LP
110	update_option( LP_KEY_DB_VERSION, LearnPress::instance()->db_version );
111	}
112
113	// Register custom post type and taxonomies .
114	include_once LP_PLUGIN_PATH . 'inc/custom-post-types/abstract.php';
115	include_once LP_PLUGIN_PATH . 'inc/custom-post-types/course.php';
116	include_once LP_PLUGIN_PATH . 'inc/custom-post-types/lesson.php';
117	include_once LP_PLUGIN_PATH . 'inc/custom-post-types/quiz.php';
118	include_once LP_PLUGIN_PATH . 'inc/custom-post-types/question.php';
119	include_once LP_PLUGIN_PATH . 'inc/custom-post-types/order.php';
120
121	// Create pages default.
122	self::create_pages();
123
124	// Set permalink is "Post name".
125	if ( ! get_option( 'permalink_structure' ) ) {
126	update_option( 'permalink_structure', '/%postname%/' );
127	// flush_rewrite_rules();
128	}
129
130	// Set roles and capabilities.
131	learn_press_add_user_roles();
132
133	// Rebuilds them with LP CPTs and pages on next request.
134	flush_rewrite_rules();
135
136	// Force option users_can_register to ON.
137	/*if ( ! get_option( 'users_can_register' ) ) {
138	update_option( 'users_can_register', 1 );
139	}*/
140	}
141
142	/**
143	* Create tables required for LP
144	* @throws Exception
145	*/
146	private function create_tables() {
147	$db = LP_Database::getInstance();
148	$tables = Config::instance()->get( 'tables-v4', 'table' );
149	foreach ( $tables as $table ) {
150	$db->wpdb->query( $table );
151
152	$db->check_execute_has_error();
153	}
154
155	if ( ! LP_Settings::is_created_tb_thim_cache() ) {
156	$this->create_table_thim_cache();
157	}
158
159	if ( ! LP_Settings::is_created_tb_material_files() ) {
160	$this->create_table_learnpress_files();
161	}
162
163	// Ensure MCP API keys table exists for activation/upgrade flows.
164	// Keep this explicit guard in addition to tables-v4 config loading.
165	if ( ! LP_Settings::is_created_tb_mcp_api_keys() ) {
166	$this->create_table_mcp_api_keys();
167	}
168
169	// Ensure Webhooks table exists for activation/upgrade flows.
170	// Keep this explicit guard in addition to tables-v4 config loading.
171	if ( ! LP_Settings::is_created_tb_webhooks() ) {
172	$this->create_table_webhooks();
173	}
174
175	update_option( 'learn_press_check_tables', 'yes' );
176	}
177
178	/**
179	* Create table thim_cache
180	*
181	* @since 4.2.2
182	*/
183	private function create_table_thim_cache() {
184	global $wpdb;
185
186	try {
187	$collation = $wpdb->has_cap( 'collation' ) ? $wpdb->get_charset_collate() : 'ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci';
188
189	$sql = "CREATE TABLE IF NOT EXISTS {$this->lp_db->tb_thim_cache} (
190	key_cache VARCHAR (191) NOT NULL UNIQUE,
191	value LONGTEXT NOT NULL,
192	expiration VARCHAR (191),
193	PRIMARY KEY (key_cache)
194	) $collation";
195
196	$rs = $wpdb->query( $sql );
197
198	if ( $rs ) {
199	update_option( 'thim_cache_tb_created', 'yes' );
200	}
201	} catch ( Throwable $e ) {
202	error_log( $e->getMessage() );
203	}
204	}
205
206	/**
207	* Create table learnpress_courses
208	*
209	* @since 4.2.6.9
210	*/
211	public function create_table_courses() {
212	global $wpdb;
213
214	try {
215	$collation = $wpdb->has_cap( 'collation' ) ? $wpdb->get_charset_collate() : 'ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci';
216
217	$sql = "CREATE TABLE IF NOT EXISTS {$this->lp_db->tb_lp_courses} (
218	ID bigint(20) unsigned NOT NULL,
219	json LONGTEXT NOT NULL,
220	price_to_sort FLOAT,
221	is_sale int(1) default 0,
222	post_author bigint unsigned,
223	post_date_gmt datetime,
224	post_content LONGTEXT,
225	post_title text not null,
226	post_status varchar(20) default 'publish' not null,
227	post_name varchar(200) default '',
228	menu_order int default 0,
229	lang varchar(20),
230	PRIMARY KEY (ID),
231	KEY post_title (post_title(191)),
232	KEY post_status (post_status),
233	KEY post_name (post_name(191)),
234	KEY id_status (ID, post_status)
235	) $collation";
236
237	$rs = $wpdb->query( $sql );
238
239	if ( $rs ) {
240	update_option( 'tb_learnpress_courses', 'yes' );
241	}
242	} catch ( Throwable $e ) {
243	error_log( $e->getMessage() );
244	}
245	}
246
247	/**
248	* Create table learnpress_material_files
249	*
250	* @since 4.2.6.6
251	*/
252	private function create_table_learnpress_files() {
253	global $wpdb;
254
255	try {
256	$collation = $wpdb->has_cap( 'collation' ) ? $wpdb->get_charset_collate() : 'ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci';
257
258	$sql = "CREATE TABLE IF NOT EXISTS {$this->lp_db->tb_lp_files} (
259	file_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
260	file_name varchar(191) NOT NULL DEFAULT '',
261	file_type varchar(100) NOT NULL DEFAULT '',
262	item_id bigint(20) unsigned NOT NULL DEFAULT '0',
263	item_type varchar(100) NOT NULL DEFAULT '',
264	method varchar(10) NOT NULL DEFAULT 'upload',
265	file_path varchar(255) NOT NULL DEFAULT '',
266	orders int(4) NOT NULL DEFAULT '0',
267	created_at datetime NULL DEFAULT NULL,
268	PRIMARY KEY (file_id),
269	KEY file_name (file_name),
270	KEY item_id (item_id),
271	KEY item_type (item_type)
272	) $collation";
273
274	$rs = $wpdb->query( $sql );
275
276	if ( $rs ) {
277	update_option( 'table_learnpress_files_created', 'yes' );
278	}
279	} catch ( Throwable $e ) {
280	error_log( $e->getMessage() );
281	}
282	}
283
284	/**
285	* Create table learnpress_mcp_api_keys.
286	*
287	* @since 4.3.3
288	* @return void
289	*/
290	public function create_table_mcp_api_keys() {
291	global $wpdb;
292
293	try {
294	$collation = $wpdb->has_cap( 'collation' ) ? $wpdb->get_charset_collate() : 'ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci';
295
296	$sql = "CREATE TABLE IF NOT EXISTS {$this->lp_db->tb_lp_mcp_api_keys} (
297	key_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
298	user_id bigint(20) unsigned NOT NULL,
299	description varchar(200) NULL DEFAULT NULL,
300	permissions varchar(10) NOT NULL DEFAULT 'read',
301	consumer_key char(64) NOT NULL,
302	consumer_secret char(64) NOT NULL,
303	truncated_key char(7) NOT NULL,
304	last_access datetime NULL DEFAULT NULL,
305	call_count bigint(20) unsigned NOT NULL DEFAULT 0,
306	created_at datetime NOT NULL,
307	updated_at datetime NULL DEFAULT NULL,
308	PRIMARY KEY (key_id),
309	UNIQUE KEY consumer_key (consumer_key),
310	KEY user_id (user_id)
311	) $collation";
312
313	$wpdb->query( $sql );
314	} catch ( Throwable $e ) {
315	error_log( $e->getMessage() );
316	}
317	}
318
319	/**
320	* Create table learnpress_webhooks.
321	*
322	* @since 4.3.3
323	* @return void
324	*/
325	public function create_table_webhooks() {
326	global $wpdb;
327
328	try {
329	$collation = $wpdb->has_cap( 'collation' ) ? $wpdb->get_charset_collate() : 'ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci';
330
331	$sql = "CREATE TABLE IF NOT EXISTS {$this->lp_db->tb_lp_webhooks} (
332	webhook_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
333	user_id bigint(20) unsigned NOT NULL DEFAULT 0,
334	status varchar(20) NOT NULL DEFAULT 'active',
335	name varchar(200) NOT NULL DEFAULT '',
336	delivery_url longtext NOT NULL,
337	secret text NOT NULL,
338	events longtext NOT NULL,
339	created_at datetime NOT NULL,
340	updated_at datetime NULL DEFAULT NULL,
341	PRIMARY KEY (webhook_id),
342	KEY user_id (user_id),
343	KEY status (status)
344	) $collation";
345
346	$wpdb->query( $sql );
347	} catch ( Throwable $e ) {
348	error_log( $e->getMessage() );
349	}
350	}
351
352	/**
353	* Create default pages for LP
354	*/
355	public static function create_pages() {
356	$pages = self::$_pages;
357
358	try {
359	foreach ( $pages as $page ) {
360	// Check if page has already existed
361	$page_id = get_option( "learn_press_{$page}_page_id", false );
362
363	if ( $page_id && get_post_type( $page_id ) === 'page' && get_post_status( $page_id ) == 'publish' ) {
364	continue;
365	}
366
367	if ( $page === 'courses' ) {
368	$page_title = 'Courses';
369	$page_slug = $page;
370	} elseif ( 'single_instructor' === $page ) {
371	$page_title = 'Instructor';
372	$page_slug = 'instructor';
373	} elseif ( 'instructors' === $page ) {
374	$page_title = 'Instructors';
375	$page_slug = $page;
376	} elseif ( 'become_a_teacher' === $page ) {
377	$page_title = 'Become an Instructor';
378	$page_slug = $page;
379	} elseif ( 'term_conditions' === $page ) {
380	$page_title = 'Terms and Conditions';
381	$page_slug = $page;
382	} else {
383	$page_title = ucwords( str_replace( '_', ' ', $page ) );
384	$page_slug = 'lp-' . str_replace( '_', '-', $page );
385	}
386
387	$data_create_page = array(
388	'post_title' => $page_title,
389	'post_name' => $page_slug,
390	);
391	LP_Helper::create_page( $data_create_page, "learn_press_{$page}_page_id" );
392	}
393	} catch ( Exception $ex ) {
394	error_log( $ex->getMessage() );
395	}
396	}
397
398	/**
399	* Check installed all tables required for LearnPress.
400	*
401	* @return bool
402	*/
403	public function tables_install_done(): bool {
404	$install_done = 'yes' === get_option( 'learn_press_check_tables', 'no' );
405	if ( ! $install_done ) {
406	$this->create_tables();
407	$install_done = 'yes' === get_option( 'learn_press_check_tables', 'no' );
408	}
409
410	return $install_done;
411	}
412	}
413	}
414