class-activation.php — Admin and Site Enhancements (ASE) 8.2.3

admin-site-enhancements / classes / class-activation.php

admin-site-enhancements / classes Last commit date

class-activation.php

213 lines

1	<?php
2
3	namespace ASENHA\Classes;
4
5	/**
6	* Plugin Activation
7	*
8	* @since 1.0.0
9	*/
10	class Activation {
11
12	/**
13	* Create failed login log table for Limit Login Attempts feature
14	*
15	* @since 2.5.0
16	*/
17	public function create_failed_logins_log_table() {
18	global $wpdb;
19
20	// Limit Login Attempts Log Table
21
22	$table_name = $wpdb->prefix . 'asenha_failed_logins';
23
24	if ( ! empty( $wpdb->charset ) ) {
25	$charset_collation_sql = "DEFAULT CHARACTER SET $wpdb->charset";
26	}
27
28	if ( ! empty( $wpdb->collate ) ) {
29	$charset_collation_sql .= " COLLATE $wpdb->collate";
30	}
31
32	// Drop table if already exists
33	$wpdb->query("DROP TABLE IF EXISTS `". $table_name ."`");
34
35	// Create database table. This procedure may also be called
36	$sql =
37	"CREATE TABLE {$table_name} (
38	id int(6) unsigned NOT NULL auto_increment,
39	ip_address varchar(40) NOT NULL DEFAULT '',
40	username varchar(24) NOT NULL DEFAULT '',
41	fail_count int(10) NOT NULL DEFAULT '0',
42	lockout_count int(10) NOT NULL DEFAULT '0',
43	request_uri varchar(24) NOT NULL DEFAULT '',
44	unixtime int(10) NOT NULL DEFAULT '0',
45	datetime_wp varchar(36) NOT NULL DEFAULT '',
46	-- datetime_utc datetime NULL DEFAULT CURRENT_TIMESTAMP,
47	info varchar(64) NOT NULL DEFAULT '',
48	UNIQUE (ip_address),
49	PRIMARY KEY (id)
50	) {$charset_collation_sql}";
51
52	require_once ABSPATH . '/wp-admin/includes/upgrade.php';
53
54	dbDelta( $sql );
55
56	return true;
57	}
58
59	/**
60	* Create email delivery log table for Email Delivery module
61	*
62	* @since 7.1.0
63	*/
64	public function create_email_delivery_log_table() {
65	global $wpdb;
66	$table_name = $wpdb->prefix . 'asenha_email_delivery';
67
68	if ( ! empty( $wpdb->charset ) ) {
69	$charset_collation_sql = "DEFAULT CHARACTER SET $wpdb->charset";
70	}
71
72	if ( ! empty( $wpdb->collate ) ) {
73	$charset_collation_sql .= " COLLATE $wpdb->collate";
74	}
75
76	// Drop table if already exists
77	$wpdb->query("DROP TABLE IF EXISTS `". $table_name ."`");
78
79	// Create database table. This procedure may also be called
80	$sql =
81	"CREATE TABLE {$table_name} (
82	id int(6) unsigned NOT NULL auto_increment,
83	status enum('successful','failed','unknown') NOT NULL DEFAULT 'unknown',
84	error varchar(250) NOT NULL DEFAULT '',
85	subject varchar(250) NOT NULL DEFAULT '',
86	message longtext NOT NULL DEFAULT '',
87	send_to varchar(256) NOT NULL DEFAULT '',
88	sender varchar(256) NOT NULL DEFAULT '',
89	reply_to varchar(256) NOT NULL DEFAULT '',
90	headers text NOT NULL DEFAULT '',
91	content_type text NOT NULL DEFAULT '',
92	attachments text NOT NULL DEFAULT '',
93	backtrace text NOT NULL DEFAULT '',
94	processor text NOT NULL DEFAULT '',
95	sent_on datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
96	sent_on_unixtime int(10) NOT NULL DEFAULT '0',
97	extra longtext NOT NULL DEFAULT '',
98	PRIMARY KEY (id)
99	) {$charset_collation_sql}";
100
101	require_once ABSPATH . '/wp-admin/includes/upgrade.php';
102
103	dbDelta( $sql );
104
105	return true;
106	}
107
108	/**
109	* Create tables for the Form Builder module
110	*
111	* @since 7.8.0
112	*/
113	public function create_form_builder_tables() {
114	global $wpdb;
115
116	if ( ! empty( $wpdb->charset ) ) {
117	$charset_collation_sql = "DEFAULT CHARACTER SET $wpdb->charset";
118	}
119
120	if ( ! empty( $wpdb->collate ) ) {
121	$charset_collation_sql .= " COLLATE $wpdb->collate";
122	}
123
124	flush_rewrite_rules();
125
126	require_once ABSPATH . '/wp-admin/includes/upgrade.php';
127
128	$fields_table_name = $wpdb->prefix . 'asenha_formbuilder_fields';
129	$forms_table_name = $wpdb->prefix . 'asenha_formbuilder_forms';
130	$entries_table_name = $wpdb->prefix . 'asenha_formbuilder_entries';
131	$entry_meta_table_name = $wpdb->prefix . 'asenha_formbuilder_entry_meta';
132
133	$sql = "CREATE TABLE {$fields_table_name} (
134	id bigint(20) NOT NULL AUTO_INCREMENT,
135	field_key varchar(100) NULL,
136	name text NULL,
137	description longtext NULL,
138	type text NULL,
139	default_value longtext NULL,
140	options longtext NULL,
141	field_order int(11) DEFAULT 0,
142	required int(1) NULL,
143	field_options longtext NULL,
144	form_id int(11) NULL,
145	created_at datetime NOT NULL,
146	PRIMARY KEY (id),
147	KEY form_id (form_id),
148	UNIQUE KEY field_key (field_key)
149	) {$charset_collation_sql}";
150
151	dbDelta( $sql );
152
153	$sql = "CREATE TABLE {$forms_table_name} (
154	id int(11) NOT NULL AUTO_INCREMENT,
155	form_key varchar(100) NULL,
156	name varchar(255) NULL,
157	description text NULL,
158	status varchar(255) NULL,
159	options longtext NULL,
160	settings longtext NULL,
161	styles longtext NULL,
162	created_at datetime NOT NULL,
163	PRIMARY KEY (id),
164	UNIQUE KEY form_key (form_key)
165	) {$charset_collation_sql}";
166
167	dbDelta( $sql );
168
169	$sql = "CREATE TABLE {$entries_table_name} (
170	id bigint(20) NOT NULL AUTO_INCREMENT,
171	ip text NULL,
172	form_id bigint(20) NULL,
173	user_id bigint(20) NULL,
174	delivery_status tinyint(1) DEFAULT 0,
175	status varchar(255) NULL,
176	created_at datetime NOT NULL,
177	PRIMARY KEY (id),
178	KEY form_id (form_id),
179	KEY user_id (user_id)
180	) {$charset_collation_sql}";
181
182	dbDelta( $sql );
183
184	$sql = "CREATE TABLE {$entry_meta_table_name} (
185	id bigint(20) NOT NULL AUTO_INCREMENT,
186	meta_value longtext NULL,
187	field_id bigint(20) NOT NULL,
188	item_id bigint(20) NOT NULL,
189	created_at datetime NOT NULL,
190	PRIMARY KEY (id),
191	KEY field_id (field_id),
192	KEY item_id (item_id)
193	) {$charset_collation_sql}";
194
195	dbDelta( $sql );
196
197	return true;
198	}
199
200	/**
201	* Part of Disable Embeds module
202	* Remove embeds rewrite rules on plugin activation.
203	*
204	* @link https://plugins.trac.wordpress.org/browser/disable-embeds/tags/1.5.0/disable-embeds.php#L101
205	* @since 8.0.0
206	*/
207	public function disable_embeds_remove_rewrite_rules() {
208	$common_methods = new Common_Methods;
209	add_filter( 'rewrite_rules_array', [ $common_methods, 'disable_embeds_rewrites' ] );
210	flush_rewrite_rules( false );
211	}
212
213	}