← All changes | OnActivation.php +206 -203 5.3.2 → 5.6.0 View file →

		@@ -1,204 +1,207 @@
1		-<?php
2		-
3		-namespace forge12\contactform7\CF7DoubleOptIn;
4		-
5		-use Forge12\Shared\Logger;
6		-
7		-if ( ! defined( 'ABSPATH' ) ) {
8		- exit;
9		-}
10		-
11		-/**
12		- * Create the table to store the opt ins.
13		- *
14		- * @return void
15		- */
16		-function createTableOptIn() {
17		- global $wpdb;
18		-
19		- $logger = Logger::getInstance();
20		-
21		- $tableName = 'f12_cf7_doubleoptin';
22		- $wpTableName = $wpdb->prefix . $tableName;
23		-
24		- $logger->info( 'Creating database table', [
25		- 'plugin' => 'double-opt-in',
26		- 'table_name' => $wpTableName,
27		- 'class' => __CLASS__ ?? null,
28		- 'method' => __FUNCTION__,
29		- ] );
30		-
31		- require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
32		-
33		- $sql = "CREATE TABLE " . $wpTableName . " (
34		- id int(11) NOT NULL auto_increment,
35		- cf_form_id int(11) NOT NULL,
36		- doubleoptin int(2),
37		- content LONGTEXT,
38		- files LONGTEXT,
39		- hash VARCHAR(255),
40		- ipaddr_register varchar(255) NOT NULL DEFAULT '',
41		- ipaddr_confirmation varchar(255) NOT NULL DEFAULT '',
42		- ipaddr_optout varchar(255) NOT NULL DEFAULT '',
43		- createtime varchar(255) DEFAULT '',
44		- updatetime varchar(255) DEFAULT '',
45		- optouttime varchar(255) DEFAULT '',
46		- category int(11),
47		- email varchar(255),
48		- form LONGTEXT,
49		- mail_optin LONGTEXT,
50		- consent_text TEXT,
51		- consent_field varchar(64) DEFAULT '',
52		- reminder_sent_at varchar(255) DEFAULT '',
53		- mail_reminder LONGTEXT,
54		- PRIMARY KEY (id)
55		- )";
56		-
57		- dbDelta( $sql );
58		-
59		- $logger->info( 'Database table created or updated', [
60		- 'plugin' => 'double-opt-in',
61		- 'table_name' => $wpTableName,
62		- 'class' => __CLASS__ ?? null,
63		- 'method' => __FUNCTION__,
64		- ] );
65		-}
66		-
67		-
68		-/**
69		- * Create the table for the categories
70		- *
71		- * @return void
72		- */
73		-function createTableOptinCategories() {
74		- global $wpdb;
75		-
76		- $logger = Logger::getInstance();
77		-
78		- $tableName = 'f12_cf7_doubleoptin_categories';
79		- $wpTableName = $wpdb->prefix . $tableName;
80		-
81		- $logger->info( 'Creating database table', [
82		- 'plugin' => 'double-opt-in',
83		- 'table_name' => $wpTableName,
84		- 'class' => __CLASS__ ?? null,
85		- 'method' => __FUNCTION__,
86		- ] );
87		-
88		- require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
89		-
90		- $sql = "CREATE TABLE " . $wpTableName . " (
91		- id int(11) NOT NULL auto_increment,
92		- name varchar(255),
93		- createtime varchar(255) DEFAULT '',
94		- updatetime varchar(255) DEFAULT '',
95		- PRIMARY KEY (id)
96		- )";
97		-
98		- dbDelta( $sql );
99		-
100		- $logger->info( 'Database table created or updated', [
101		- 'plugin' => 'double-opt-in',
102		- 'table_name' => $wpTableName,
103		- 'class' => __CLASS__ ?? null,
104		- 'method' => __FUNCTION__,
105		- ] );
106		-}
107		-
108		-
109		-/**
110		- * On Activation create the custom table to store the required information
111		- * for the double opt in system.
112		- */
113		-function onActivation( $network_wide = false ) {
114		- $logger = Logger::getInstance();
115		-
116		- $logger->info( 'Plugin activation started', [
117		- 'plugin' => 'double-opt-in',
118		- 'network_wide' => $network_wide,
119		- 'class' => __CLASS__ ?? null,
120		- 'method' => __FUNCTION__,
121		- ] );
122		-
123		- if ( is_multisite() && $network_wide ) {
124		- $sites = get_sites( [ 'fields' => 'ids', 'number' => 0 ] );
125		- foreach ( $sites as $site_id ) {
126		- switch_to_blog( $site_id );
127		- createTableOptin();
128		- createTableOptinCategories();
129		- createTableAuditLog();
130		- restore_current_blog();
131		- }
132		- } else {
133		- createTableOptin();
134		- createTableOptinCategories();
135		- createTableAuditLog();
136		- }
137		-
138		- $logger->info( 'Plugin activation completed', [
139		- 'plugin' => 'double-opt-in',
140		- 'network_wide' => $network_wide,
141		- 'class' => __CLASS__ ?? null,
142		- 'method' => __FUNCTION__,
143		- ] );
144		-}
145		-
146		-/**
147		- * Create the table for the audit log.
148		- *
149		- * @since 4.2.0
150		- * @return void
151		- */
152		-function createTableAuditLog() {
153		- global $wpdb;
154		-
155		- $logger = Logger::getInstance();
156		-
157		- $tableName = 'f12_cf7_doubleoptin_audit_log';
158		- $wpTableName = $wpdb->prefix . $tableName;
159		-
160		- $logger->info( 'Creating audit log table', [
161		- 'plugin' => 'double-opt-in',
162		- 'table_name' => $wpTableName,
163		- 'method' => __FUNCTION__,
164		- ] );
165		-
166		- require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
167		-
168		- $sql = "CREATE TABLE " . $wpTableName . " (
169		- id bigint(20) unsigned NOT NULL auto_increment,
170		- event_type varchar(50) NOT NULL,
171		- severity varchar(20) NOT NULL DEFAULT 'info',
172		- message text NOT NULL,
173		- user_id bigint(20) unsigned DEFAULT NULL,
174		- details longtext DEFAULT NULL,
175		- created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
176		- PRIMARY KEY (id),
177		- KEY idx_type (event_type),
178		- KEY idx_severity (severity),
179		- KEY idx_created (created_at)
180		- )";
181		-
182		- dbDelta( $sql );
183		-
184		- $logger->info( 'Audit log table created or updated', [
185		- 'plugin' => 'double-opt-in',
186		- 'table_name' => $wpTableName,
187		- 'method' => __FUNCTION__,
188		- ] );
189		-}
190		-
191		-register_activation_hook( plugin_dir_path(__FILE__).'CF7DoubleOptIn.class.php', '\forge12\contactform7\CF7DoubleOptIn\onActivation' );
192		-
193		-add_action( 'wp_initialize_site', function ( $new_site ) {
194		- if ( ! is_plugin_active_for_network(
195		- plugin_basename( __DIR__ . '/CF7DoubleOptIn.class.php' )
196		- ) ) {
197		- return;
198		- }
199		- switch_to_blog( $new_site->blog_id );
200		- createTableOptin();
201		- createTableOptinCategories();
202		- createTableAuditLog();
203		- restore_current_blog();
	1	+<?php
	2	+
	3	+namespace forge12\contactform7\CF7DoubleOptIn;
	4	+
	5	+use Forge12\Shared\Logger;
	6	+
	7	+if ( ! defined( 'ABSPATH' ) ) {
	8	+ exit;
	9	+}
	10	+
	11	+/**
	12	+ * Create the table to store the opt ins.
	13	+ *
	14	+ * @return void
	15	+ */
	16	+function createTableOptIn() {
	17	+ global $wpdb;
	18	+
	19	+ $logger = Logger::getInstance();
	20	+
	21	+ $tableName = 'f12_cf7_doubleoptin';
	22	+ $wpTableName = $wpdb->prefix . $tableName;
	23	+
	24	+ $logger->info( 'Creating database table', [
	25	+ 'plugin' => 'double-opt-in',
	26	+ 'table_name' => $wpTableName,
	27	+ 'class' => __CLASS__ ?? null,
	28	+ 'method' => __FUNCTION__,
	29	+ ] );
	30	+
	31	+ require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
	32	+
	33	+ $sql = "CREATE TABLE " . $wpTableName . " (
	34	+ id int(11) NOT NULL auto_increment,
	35	+ cf_form_id int(11) NOT NULL,
	36	+ doubleoptin int(2),
	37	+ content LONGTEXT,
	38	+ files LONGTEXT,
	39	+ hash VARCHAR(255),
	40	+ ipaddr_register varchar(255) NOT NULL DEFAULT '',
	41	+ ipaddr_confirmation varchar(255) NOT NULL DEFAULT '',
	42	+ ipaddr_optout varchar(255) NOT NULL DEFAULT '',
	43	+ createtime varchar(255) DEFAULT '',
	44	+ updatetime varchar(255) DEFAULT '',
	45	+ optouttime varchar(255) DEFAULT '',
	46	+ category int(11),
	47	+ email varchar(255),
	48	+ form LONGTEXT,
	49	+ mail_optin LONGTEXT,
	50	+ consent_text TEXT,
	51	+ consent_field varchar(64) DEFAULT '',
	52	+ reminder_sent_at varchar(255) DEFAULT '',
	53	+ mail_reminder LONGTEXT,
	54	+ PRIMARY KEY (id)
	55	+ )";
	56	+
	57	+ dbDelta( $sql );
	58	+
	59	+ $logger->info( 'Database table created or updated', [
	60	+ 'plugin' => 'double-opt-in',
	61	+ 'table_name' => $wpTableName,
	62	+ 'class' => __CLASS__ ?? null,
	63	+ 'method' => __FUNCTION__,
	64	+ ] );
	65	+}
	66	+
	67	+
	68	+/**
	69	+ * Create the table for the categories
	70	+ *
	71	+ * @return void
	72	+ */
	73	+function createTableOptinCategories() {
	74	+ global $wpdb;
	75	+
	76	+ $logger = Logger::getInstance();
	77	+
	78	+ $tableName = 'f12_cf7_doubleoptin_categories';
	79	+ $wpTableName = $wpdb->prefix . $tableName;
	80	+
	81	+ $logger->info( 'Creating database table', [
	82	+ 'plugin' => 'double-opt-in',
	83	+ 'table_name' => $wpTableName,
	84	+ 'class' => __CLASS__ ?? null,
	85	+ 'method' => __FUNCTION__,
	86	+ ] );
	87	+
	88	+ require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
	89	+
	90	+ $sql = "CREATE TABLE " . $wpTableName . " (
	91	+ id int(11) NOT NULL auto_increment,
	92	+ name varchar(255),
	93	+ createtime varchar(255) DEFAULT '',
	94	+ updatetime varchar(255) DEFAULT '',
	95	+ PRIMARY KEY (id)
	96	+ )";
	97	+
	98	+ dbDelta( $sql );
	99	+
	100	+ $logger->info( 'Database table created or updated', [
	101	+ 'plugin' => 'double-opt-in',
	102	+ 'table_name' => $wpTableName,
	103	+ 'class' => __CLASS__ ?? null,
	104	+ 'method' => __FUNCTION__,
	105	+ ] );
	106	+}
	107	+
	108	+
	109	+/**
	110	+ * On Activation create the custom table to store the required information
	111	+ * for the double opt in system.
	112	+ */
	113	+function onActivation( $network_wide = false ) {
	114	+ $logger = Logger::getInstance();
	115	+
	116	+ $logger->info( 'Plugin activation started', [
	117	+ 'plugin' => 'double-opt-in',
	118	+ 'network_wide' => $network_wide,
	119	+ 'class' => __CLASS__ ?? null,
	120	+ 'method' => __FUNCTION__,
	121	+ ] );
	122	+
	123	+ if ( is_multisite() && $network_wide ) {
	124	+ $sites = get_sites( [ 'fields' => 'ids', 'number' => 0 ] );
	125	+ foreach ( $sites as $site_id ) {
	126	+ switch_to_blog( $site_id );
	127	+ createTableOptin();
	128	+ createTableOptinCategories();
	129	+ createTableAuditLog();
	130	+ \Forge12\DoubleOptIn\Repository\FollowUpSchema::install();
	131	+ restore_current_blog();
	132	+ }
	133	+ } else {
	134	+ createTableOptin();
	135	+ createTableOptinCategories();
	136	+ createTableAuditLog();
	137	+ \Forge12\DoubleOptIn\Repository\FollowUpSchema::install();
	138	+ }
	139	+
	140	+ $logger->info( 'Plugin activation completed', [
	141	+ 'plugin' => 'double-opt-in',
	142	+ 'network_wide' => $network_wide,
	143	+ 'class' => __CLASS__ ?? null,
	144	+ 'method' => __FUNCTION__,
	145	+ ] );
	146	+}
	147	+
	148	+/**
	149	+ * Create the table for the audit log.
	150	+ *
	151	+ * @since 4.2.0
	152	+ * @return void
	153	+ */
	154	+function createTableAuditLog() {
	155	+ global $wpdb;
	156	+
	157	+ $logger = Logger::getInstance();
	158	+
	159	+ $tableName = 'f12_cf7_doubleoptin_audit_log';
	160	+ $wpTableName = $wpdb->prefix . $tableName;
	161	+
	162	+ $logger->info( 'Creating audit log table', [
	163	+ 'plugin' => 'double-opt-in',
	164	+ 'table_name' => $wpTableName,
	165	+ 'method' => __FUNCTION__,
	166	+ ] );
	167	+
	168	+ require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
	169	+
	170	+ $sql = "CREATE TABLE " . $wpTableName . " (
	171	+ id bigint(20) unsigned NOT NULL auto_increment,
	172	+ event_type varchar(50) NOT NULL,
	173	+ severity varchar(20) NOT NULL DEFAULT 'info',
	174	+ message text NOT NULL,
	175	+ user_id bigint(20) unsigned DEFAULT NULL,
	176	+ details longtext DEFAULT NULL,
	177	+ created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
	178	+ PRIMARY KEY (id),
	179	+ KEY idx_type (event_type),
	180	+ KEY idx_severity (severity),
	181	+ KEY idx_created (created_at)
	182	+ )";
	183	+
	184	+ dbDelta( $sql );
	185	+
	186	+ $logger->info( 'Audit log table created or updated', [
	187	+ 'plugin' => 'double-opt-in',
	188	+ 'table_name' => $wpTableName,
	189	+ 'method' => __FUNCTION__,
	190	+ ] );
	191	+}
	192	+
	193	+register_activation_hook( plugin_dir_path(__FILE__).'CF7DoubleOptIn.class.php', '\forge12\contactform7\CF7DoubleOptIn\onActivation' );
	194	+
	195	+add_action( 'wp_initialize_site', function ( $new_site ) {
	196	+ if ( ! is_plugin_active_for_network(
	197	+ plugin_basename( __DIR__ . '/CF7DoubleOptIn.class.php' )
	198	+ ) ) {
	199	+ return;
	200	+ }
	201	+ switch_to_blog( $new_site->blog_id );
	202	+ createTableOptin();
	203	+ createTableOptinCategories();
	204	+ createTableAuditLog();
	205	+ \Forge12\DoubleOptIn\Repository\FollowUpSchema::install();
	206	+ restore_current_blog();
204	207	}, 900 );