Upgrader.php — Tutor LMS – eLearning and online course solution 2.3.0

tutor / classes / Upgrader.php

tutor / classes Last commit date

Addons.php 2 years ago Admin.php 2 years ago Ajax.php 2 years ago Announcements.php 3 years ago Assets.php 2 years ago Backend_Page_Trait.php 3 years ago Course.php 2 years ago Course_Embed.php 3 years ago Course_Filter.php 3 years ago Course_List.php 2 years ago Course_Settings_Tabs.php 3 years ago Course_Widget.php 3 years ago Custom_Validation.php 3 years ago Dashboard.php 3 years ago FormHandler.php 2 years ago Frontend.php 3 years ago Gutenberg.php 3 years ago Input.php 3 years ago Instructor.php 2 years ago Instructors_List.php 3 years ago Lesson.php 2 years ago Options_V2.php 2 years ago Post_types.php 2 years ago Private_Course_Access.php 3 years ago Q_and_A.php 3 years ago Question_Answers_List.php 3 years ago Quiz.php 2 years ago Quiz_Attempts_List.php 2 years ago RestAPI.php 3 years ago Reviews.php 3 years ago Rewrite_Rules.php 3 years ago Shortcode.php 2 years ago Student.php 2 years ago Students_List.php 3 years ago Taxonomies.php 3 years ago Template.php 2 years ago Theme_Compatibility.php 3 years ago Tools.php 3 years ago Tools_V2.php 3 years ago Tutor.php 3 years ago TutorEDD.php 2 years ago Tutor_Base.php 3 years ago Tutor_Setup.php 3 years ago Upgrader.php 3 years ago User.php 3 years ago Utils.php 2 years ago Video_Stream.php 3 years ago Withdraw.php 2 years ago Withdraw_Requests_List.php 3 years ago WooCommerce.php 2 years ago

Upgrader.php

193 lines

1	<?php
2	/**
3	* Tutor up grader
4	*
5	* @package Tutor\UpGrader
6	* @author Themeum <support@themeum.com>
7	* @link https://themeum.com
8	* @since 1.0.0
9	*/
10
11	namespace TUTOR;
12
13	if ( ! defined( 'ABSPATH' ) ) {
14	exit;
15	}
16
17	/**
18	* Manage up grade
19	*
20	* @since 1.0.0
21	*/
22	class Upgrader {
23
24	/**
25	* Register hooks
26	*
27	* @since 1.0.0
28	*/
29	public function __construct() {
30	add_action( 'admin_init', array( $this, 'init_upgrader' ) );
31	$base_name = tutor()->basename;
32	/**
33	* Installing Gradebook Addon from TutorPro
34	*/
35	add_action( 'tutor_addon_before_enable_tutor-pro/addons/gradebook/gradebook.php', array( $this, 'install_gradebook' ) );
36	add_action( 'tutor_addon_before_enable_tutor-pro/addons/tutor-email/tutor-email.php', array( $this, 'install_tutor_email_queue' ) );
37	add_action( 'upgrader_process_complete', array( $this, 'init_email_table_deployment' ), 10, 2 );
38	}
39
40	/**
41	* Init up grader
42	*
43	* @since 1.0.0
44	*
45	* @return void
46	*/
47	public function init_upgrader() {
48	$upgrades = $this->available_upgrades();
49
50	if ( tutor_utils()->count( $upgrades ) ) {
51	foreach ( $upgrades as $upgrade ) {
52	$this->{$upgrade}();
53	}
54	}
55	}
56
57	/**
58	* Check availability
59	*
60	* @since 1.0.0
61	*
62	* @return array
63	*/
64	public function available_upgrades() {
65	$version = get_option( 'tutor_version' );
66
67	$upgrades = array();
68	if ( $version ) {
69	$upgrades[] = 'upgrade_to_1_3_1';
70	}
71
72	return $upgrades;
73	}
74
75	/**
76	* Upgrade to version 1.3.1
77	*
78	* @since 1.0.0
79	*
80	* @return void
81	*/
82	public function upgrade_to_1_3_1() {
83	if ( version_compare( get_option( 'tutor_version' ), '1.3.1', '<' ) ) {
84	global $wpdb;
85
86	if ( ! get_option( 'is_course_post_type_updated' ) ) {
87	$wpdb->update( $wpdb->posts, array( 'post_type' => tutor()->course_post_type ), array( 'post_type' => 'course' ) );
88	update_option( 'is_course_post_type_updated', true );
89	update_option( 'tutor_version', '1.3.1' );
90	flush_rewrite_rules();
91	}
92	}
93	}
94
95	/**
96	* Installing Gradebook if Tutor Pro exists
97	*
98	* @since v1.4.2
99	*
100	* @return void
101	*/
102	public function install_gradebook() {
103	global $wpdb;
104
105	$exists_gradebook_table = $wpdb->query( "SHOW TABLES LIKE '{$wpdb->tutor_gradebooks}';" );
106	$exists_gradebook_results_table = $wpdb->query( "SHOW TABLES LIKE '{$wpdb->tutor_gradebooks_results}';" );
107	$charset_collate = $wpdb->get_charset_collate();
108
109	require_once ABSPATH . 'wp-admin/includes/upgrade.php';
110
111	if ( ! $exists_gradebook_table ) {
112	$gradebook_table = "CREATE TABLE IF NOT EXISTS {$wpdb->tutor_gradebooks} (
113	gradebook_id bigint(20) NOT NULL AUTO_INCREMENT,
114	grade_name varchar(50) DEFAULT NULL,
115	grade_point varchar(20) DEFAULT NULL,
116	grade_point_to varchar(20) DEFAULT NULL,
117	percent_from int(3) DEFAULT NULL,
118	percent_to int(3) DEFAULT NULL,
119	grade_config longtext,
120	PRIMARY KEY (gradebook_id)
121	) $charset_collate;";
122	dbDelta( $gradebook_table );
123	}
124	if ( ! $exists_gradebook_results_table ) {
125	$gradebook_results = "CREATE TABLE IF NOT EXISTS {$wpdb->tutor_gradebooks_results} (
126	gradebook_result_id bigint(20) NOT NULL AUTO_INCREMENT,
127	user_id bigint(20) DEFAULT NULL,
128	course_id bigint(20) DEFAULT NULL,
129	quiz_id bigint(20) DEFAULT NULL,
130	assignment_id bigint(20) DEFAULT NULL,
131	gradebook_id bigint(20) DEFAULT NULL,
132	result_for varchar(50) DEFAULT NULL,
133	grade_name varchar(50) DEFAULT NULL,
134	grade_point varchar(20) DEFAULT NULL,
135	earned_grade_point varchar(20) DEFAULT NULL,
136	earned_percent int(3) DEFAULT NULL,
137	generate_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
138	update_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
139	PRIMARY KEY (gradebook_result_id)
140	) {$charset_collate};";
141	dbDelta( $gradebook_results );
142	}
143
144	}
145
146	/**
147	* Email table deployment
148	*
149	* @param mixed $upgrader_object up grader obj.
150	* @param mixed $options options.
151	*
152	* @return void
153	*/
154	public function init_email_table_deployment( $upgrader_object, $options ) {
155
156	if ( is_object( $upgrader_object ) && is_array( $upgrader_object->result ) && isset( $upgrader_object->result['destination_name'] ) && 'tutor-pro' == $upgrader_object->result['destination_name'] ) {
157	$addon_config = tutor_utils()->get_addon_config( 'tutor-pro/addons/tutor-email/tutor-email.php' );
158	$is_enable = (bool) tutor_utils()->avalue_dot( 'is_enable', $addon_config );
159
160	$is_enable ? $this->install_tutor_email_queue() : 0;
161	}
162	}
163
164	/**
165	* Installing email addon if Tutor Pro exists
166	*
167	* @since 1.8.6
168	*
169	* @return void
170	*/
171	public function install_tutor_email_queue() {
172
173	global $wpdb;
174	$exists_email_queue_table = $wpdb->query( "SHOW TABLES LIKE '{$wpdb->tutor_email_queue}';" );
175	$charset_collate = $wpdb->get_charset_collate();
176
177	require_once ABSPATH . 'wp-admin/includes/upgrade.php';
178
179	if ( ! $exists_email_queue_table ) {
180	$table = "CREATE TABLE IF NOT EXISTS {$wpdb->tutor_email_queue} (
181	id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
182	mail_to varchar(255) NOT NULL,
183	subject text NOT NULL,
184	message text NOT NULL,
185	headers text NOT NULL,
186	PRIMARY KEY (id)
187	) {$charset_collate};";
188
189	dbDelta( $table );
190	}
191	}
192	}
193