← All changes | OnActivation.php +215 -81 3.0.3 → 5.8.0 View file →

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