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

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

admin-site-enhancements / classes Last commit date

class-activation.php

200 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) default NULL,
136	name text default NULL,
137	description longtext default NULL,
138	type text default NULL,
139	default_value longtext default NULL,
140	options longtext default NULL,
141	field_order int(11) default 0,
142	required int(1) default NULL,
143	field_options longtext default NULL,
144	form_id int(11) default 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) default NULL,
156	name varchar(255) default NULL,
157	description text default NULL,
158	status varchar(255) default NULL,
159	options longtext default NULL,
160	settings longtext default NULL,
161	styles longtext default 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 default NULL,
172	form_id BIGINT(20) default NULL,
173	user_id BIGINT(20) default NULL,
174	delivery_status tinyint(1) default 0,
175	status varchar(255) default 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 default 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	}