learnpress / inc / class-lp-install.php

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

411 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	// Rebuilds them with LP CPTs and pages on next request.
131	flush_rewrite_rules();
132
133	// Force option users_can_register to ON.
134	/*if ( ! get_option( 'users_can_register' ) ) {
135	update_option( 'users_can_register', 1 );
136	}*/
137	}
138
139	/**
140	* Create tables required for LP
141	* @throws Exception
142	*/
143	private function create_tables() {
144	$db = LP_Database::getInstance();
145	$tables = Config::instance()->get( 'tables-v4', 'table' );
146	foreach ( $tables as $table ) {
147	$db->wpdb->query( $table );
148
149	$db->check_execute_has_error();
150	}
151
152	if ( ! LP_Settings::is_created_tb_thim_cache() ) {
153	$this->create_table_thim_cache();
154	}
155
156	if ( ! LP_Settings::is_created_tb_material_files() ) {
157	$this->create_table_learnpress_files();
158	}
159
160	// Ensure MCP API keys table exists for activation/upgrade flows.
161	// Keep this explicit guard in addition to tables-v4 config loading.
162	if ( ! LP_Settings::is_created_tb_mcp_api_keys() ) {
163	$this->create_table_mcp_api_keys();
164	}
165
166	// Ensure Webhooks table exists for activation/upgrade flows.
167	// Keep this explicit guard in addition to tables-v4 config loading.
168	if ( ! LP_Settings::is_created_tb_webhooks() ) {
169	$this->create_table_webhooks();
170	}
171
172	update_option( 'learn_press_check_tables', 'yes' );
173	}
174
175	/**
176	* Create table thim_cache
177	*
178	* @since 4.2.2
179	*/
180	private function create_table_thim_cache() {
181	global $wpdb;
182
183	try {
184	$collation = $wpdb->has_cap( 'collation' ) ? $wpdb->get_charset_collate() : 'ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci';
185
186	$sql = "CREATE TABLE IF NOT EXISTS {$this->lp_db->tb_thim_cache} (
187	key_cache VARCHAR (191) NOT NULL UNIQUE,
188	value LONGTEXT NOT NULL,
189	expiration VARCHAR (191),
190	PRIMARY KEY (key_cache)
191	) $collation";
192
193	$rs = $wpdb->query( $sql );
194
195	if ( $rs ) {
196	update_option( 'thim_cache_tb_created', 'yes' );
197	}
198	} catch ( Throwable $e ) {
199	error_log( $e->getMessage() );
200	}
201	}
202
203	/**
204	* Create table learnpress_courses
205	*
206	* @since 4.2.6.9
207	*/
208	public function create_table_courses() {
209	global $wpdb;
210
211	try {
212	$collation = $wpdb->has_cap( 'collation' ) ? $wpdb->get_charset_collate() : 'ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci';
213
214	$sql = "CREATE TABLE IF NOT EXISTS {$this->lp_db->tb_lp_courses} (
215	ID bigint(20) unsigned NOT NULL,
216	json LONGTEXT NOT NULL,
217	price_to_sort FLOAT,
218	is_sale int(1) default 0,
219	post_author bigint unsigned,
220	post_date_gmt datetime,
221	post_content LONGTEXT,
222	post_title text not null,
223	post_status varchar(20) default 'publish' not null,
224	post_name varchar(200) default '',
225	menu_order int default 0,
226	lang varchar(20),
227	PRIMARY KEY (ID),
228	KEY post_title (post_title(191)),
229	KEY post_status (post_status),
230	KEY post_name (post_name(191)),
231	KEY id_status (ID, post_status)
232	) $collation";
233
234	$rs = $wpdb->query( $sql );
235
236	if ( $rs ) {
237	update_option( 'tb_learnpress_courses', 'yes' );
238	}
239	} catch ( Throwable $e ) {
240	error_log( $e->getMessage() );
241	}
242	}
243
244	/**
245	* Create table learnpress_material_files
246	*
247	* @since 4.2.6.6
248	*/
249	private function create_table_learnpress_files() {
250	global $wpdb;
251
252	try {
253	$collation = $wpdb->has_cap( 'collation' ) ? $wpdb->get_charset_collate() : 'ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci';
254
255	$sql = "CREATE TABLE IF NOT EXISTS {$this->lp_db->tb_lp_files} (
256	file_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
257	file_name varchar(191) NOT NULL DEFAULT '',
258	file_type varchar(100) NOT NULL DEFAULT '',
259	item_id bigint(20) unsigned NOT NULL DEFAULT '0',
260	item_type varchar(100) NOT NULL DEFAULT '',
261	method varchar(10) NOT NULL DEFAULT 'upload',
262	file_path varchar(255) NOT NULL DEFAULT '',
263	orders int(4) NOT NULL DEFAULT '0',
264	created_at datetime NULL DEFAULT NULL,
265	PRIMARY KEY (file_id),
266	KEY file_name (file_name),
267	KEY item_id (item_id),
268	KEY item_type (item_type)
269	) $collation";
270
271	$rs = $wpdb->query( $sql );
272
273	if ( $rs ) {
274	update_option( 'table_learnpress_files_created', 'yes' );
275	}
276	} catch ( Throwable $e ) {
277	error_log( $e->getMessage() );
278	}
279	}
280
281	/**
282	* Create table learnpress_mcp_api_keys.
283	*
284	* @since 4.3.3
285	* @return void
286	*/
287	public function create_table_mcp_api_keys() {
288	global $wpdb;
289
290	try {
291	$collation = $wpdb->has_cap( 'collation' ) ? $wpdb->get_charset_collate() : 'ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci';
292
293	$sql = "CREATE TABLE IF NOT EXISTS {$this->lp_db->tb_lp_mcp_api_keys} (
294	key_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
295	user_id bigint(20) unsigned NOT NULL,
296	description varchar(200) NULL DEFAULT NULL,
297	permissions varchar(10) NOT NULL DEFAULT 'read',
298	consumer_key char(64) NOT NULL,
299	consumer_secret char(64) NOT NULL,
300	truncated_key char(7) NOT NULL,
301	last_access datetime NULL DEFAULT NULL,
302	call_count bigint(20) unsigned NOT NULL DEFAULT 0,
303	created_at datetime NOT NULL,
304	updated_at datetime NULL DEFAULT NULL,
305	PRIMARY KEY (key_id),
306	UNIQUE KEY consumer_key (consumer_key),
307	KEY user_id (user_id)
308	) $collation";
309
310	$wpdb->query( $sql );
311	} catch ( Throwable $e ) {
312	error_log( $e->getMessage() );
313	}
314	}
315
316	/**
317	* Create table learnpress_webhooks.
318	*
319	* @since 4.3.3
320	* @return void
321	*/
322	public function create_table_webhooks() {
323	global $wpdb;
324
325	try {
326	$collation = $wpdb->has_cap( 'collation' ) ? $wpdb->get_charset_collate() : 'ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci';
327
328	$sql = "CREATE TABLE IF NOT EXISTS {$this->lp_db->tb_lp_webhooks} (
329	webhook_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
330	user_id bigint(20) unsigned NOT NULL DEFAULT 0,
331	status varchar(20) NOT NULL DEFAULT 'active',
332	name varchar(200) NOT NULL DEFAULT '',
333	delivery_url longtext NOT NULL,
334	secret text NOT NULL,
335	events longtext NOT NULL,
336	created_at datetime NOT NULL,
337	updated_at datetime NULL DEFAULT NULL,
338	PRIMARY KEY (webhook_id),
339	KEY user_id (user_id),
340	KEY status (status)
341	) $collation";
342
343	$wpdb->query( $sql );
344	} catch ( Throwable $e ) {
345	error_log( $e->getMessage() );
346	}
347	}
348
349	/**
350	* Create default pages for LP
351	*/
352	public static function create_pages() {
353	$pages = self::$_pages;
354
355	try {
356	foreach ( $pages as $page ) {
357	// Check if page has already existed
358	$page_id = get_option( "learn_press_{$page}_page_id", false );
359
360	if ( $page_id && get_post_type( $page_id ) === 'page' && get_post_status( $page_id ) == 'publish' ) {
361	continue;
362	}
363
364	if ( $page === 'courses' ) {
365	$page_title = 'Courses';
366	$page_slug = $page;
367	} elseif ( 'single_instructor' === $page ) {
368	$page_title = 'Instructor';
369	$page_slug = 'instructor';
370	} elseif ( 'instructors' === $page ) {
371	$page_title = 'Instructors';
372	$page_slug = $page;
373	} elseif ( 'become_a_teacher' === $page ) {
374	$page_title = 'Become an Instructor';
375	$page_slug = $page;
376	} elseif ( 'term_conditions' === $page ) {
377	$page_title = 'Terms and Conditions';
378	$page_slug = $page;
379	} else {
380	$page_title = ucwords( str_replace( '_', ' ', $page ) );
381	$page_slug = 'lp-' . str_replace( '_', '-', $page );
382	}
383
384	$data_create_page = array(
385	'post_title' => $page_title,
386	'post_name' => $page_slug,
387	);
388	LP_Helper::create_page( $data_create_page, "learn_press_{$page}_page_id" );
389	}
390	} catch ( Exception $ex ) {
391	error_log( $ex->getMessage() );
392	}
393	}
394
395	/**
396	* Check installed all tables required for LearnPress.
397	*
398	* @return bool
399	*/
400	public function tables_install_done(): bool {
401	$install_done = 'yes' === get_option( 'learn_press_check_tables', 'no' );
402	if ( ! $install_done ) {
403	$this->create_tables();
404	$install_done = 'yes' === get_option( 'learn_press_check_tables', 'no' );
405	}
406
407	return $install_done;
408	}
409	}
410	}
411