functions-activation.php — Strong Testimonials trunk

strong-testimonials / includes / functions-activation.php

strong-testimonials / includes Last commit date

functions-activation.php

224 lines

1	<?php
2
3	/**
4	* Add tables for Views.
5	*
6	* @since 1.21.0
7	*/
8	function wpmtst_update_tables() {
9	global $wpdb;
10	require_once ABSPATH . 'wp-admin/includes/upgrade.php';
11
12	$charset_collate = $wpdb->get_charset_collate();
13
14	$table_name = $wpdb->prefix . 'strong_views';
15
16	$sql = "CREATE TABLE $table_name (
17	id mediumint(9) NOT NULL AUTO_INCREMENT,
18	name varchar(100) NOT NULL,
19	value text NOT NULL,
20	PRIMARY KEY (id)
21	) $charset_collate;";
22
23	$wpdb->show_errors();
24	$result = dbDelta( $sql );
25	$wpdb->hide_errors();
26
27	if ( $wpdb->last_error ) {
28	deactivate_plugins( 'strong-testimonials/strong-testimonials.php' );
29	$message = '<p><span style="color: #CD0000;">';
30	$message .= esc_html__( 'An error occurred:', 'strong-testimonials' ) . '</span> ';
31	$message .= esc_html__( 'The plugin has been deactivated.', 'strong-testimonials' );
32	$message .= '</p>';
33	$message .= '<p><code>' . $wpdb->last_error . '</code></p>';
34	// translators: %s is the URL to the WordPress dashboard.
35	$message .= '<p>' . sprintf( __( '<a href="%s">Go back to Dashboard</a>', 'strong-testimonials' ), esc_url( admin_url() ) ) . '</p>';
36
37	wp_die( sprintf( '<div class="error strong-view-error">%s</div>', wp_kses_post( $message ) ) );
38	}
39
40	update_option( 'wpmtst_db_version', WPMST()->get_db_version(), 'no' );
41	}
42
43	/**
44	* Returns true if any view in the table has the given mode.
45	*
46	* @since 3.2.23
47	*/
48	function wpmtst_mode_view_exists( $table, $mode ) {
49	global $wpdb;
50	$rows = $wpdb->get_col( "SELECT value FROM {$table}" ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
51	foreach ( $rows as $row ) {
52	$data = maybe_unserialize( $row );
53	if ( isset( $data['mode'] ) && $data['mode'] === $mode ) {
54	return true;
55	}
56	}
57	return false;
58	}
59
60	/**
61	* Create default views on plugin activation (and on admin_init as a safety net).
62	*
63	* - Single Template: protected, re-created if its stored ID no longer exists.
64	* - Display / Form: created once; skipped if any view with that mode already exists.
65	*
66	* @since 3.2.23
67	*/
68	function wpmtst_create_default_views() {
69	global $wpdb;
70
71	$table = $wpdb->prefix . 'strong_views';
72	$stored_ids = get_option( 'wpmtst_default_views', array() );
73	$updated = false;
74
75	// Single Template — always ensure one view is protected.
76	// If the stored protected ID is still in the DB, nothing to do.
77	// Otherwise find the first existing single_template view and protect it,
78	// or create a new one if none exist.
79	$protected_id = absint( $stored_ids['single_template'] ?? 0 );
80	$still_exists = $protected_id > 0 && $wpdb->get_var( $wpdb->prepare( "SELECT id FROM {$table} WHERE id = %d", $protected_id ) ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
81
82	if ( ! $still_exists ) {
83	// Find the first existing single_template view in the DB.
84	$rows = $wpdb->get_results( "SELECT id, value FROM {$table}", ARRAY_A ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
85	$first_id = 0;
86	foreach ( $rows as $row ) {
87	$data = maybe_unserialize( $row['value'] );
88	if ( isset( $data['mode'] ) && 'single_template' === $data['mode'] ) {
89	$first_id = absint( $row['id'] );
90	break;
91	}
92	}
93
94	if ( $first_id > 0 ) {
95	// Promote the first found view to protected.
96	$stored_ids['single_template'] = $first_id;
97	$updated = true;
98	} else {
99	// No single_template view exists — create one.
100	$view = Strong_Testimonials_Defaults::get_default_view();
101	$view['mode'] = 'single_template';
102	$view['client_section'] = array(
103	array(
104	'field' => 'client_name',
105	'type' => 'text',
106	'before' => '',
107	'class' => 'testimonial-name',
108	),
109	array(
110	'field' => 'company_name',
111	'type' => 'link',
112	'before' => '',
113	'url' => 'company_website',
114	'class' => 'testimonial-company',
115	'new_tab' => true,
116	),
117	array(
118	'field' => 'star_rating',
119	'type' => 'rating',
120	'before' => '',
121	'class' => 'testimonial-rating',
122	),
123	);
124	$wpdb->query( // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
125	$wpdb->prepare(
126	"INSERT INTO {$table} (name, value) VALUES (%s, %s)",
127	__( 'Single Template', 'strong-testimonials' ),
128	serialize( $view ) // phpcs:ignore WordPress.PHP.DiscouragedPHPFunctions.serialize_serialize
129	)
130	);
131	$new_id = absint( $wpdb->insert_id );
132	if ( $new_id > 0 ) {
133	$stored_ids['single_template'] = $new_id;
134	$updated = true;
135	}
136	}
137	}
138
139	// Testimonials Display — create once; if stored ID exists the user has already seen/deleted it.
140	if ( ! isset( $stored_ids['display'] ) && ! wpmtst_mode_view_exists( $table, 'display' ) ) {
141	$view = Strong_Testimonials_Defaults::get_default_view();
142	$view['mode'] = 'display';
143	$view['title'] = 'hidden';
144	$view['thumbnail_size'] = 'custom';
145	$view['thumbnail_width'] = 100;
146	$view['thumbnail_height'] = 100;
147
148	// Only offer fields that actually exist on the linked form.
149	$client_section = array();
150	if ( wpmtst_form_has_field( $view['form_id'], 'client_name' ) ) {
151	$client_section[] = array(
152	'field' => 'client_name',
153	'type' => 'author',
154	'before' => '',
155	'class' => 'testimonial-name',
156	);
157	}
158	if ( wpmtst_form_has_field( $view['form_id'], 'company_name' ) ) {
159	$client_section[] = array(
160	'field' => 'company_name',
161	'type' => 'link',
162	'before' => '',
163	'url' => 'company_website',
164	'class' => 'testimonial-company',
165	'new_tab' => true,
166	);
167	}
168	if ( wpmtst_form_has_field( $view['form_id'], 'star_rating' ) ) {
169	$client_section[] = array(
170	'field' => 'star_rating',
171	'type' => 'rating',
172	'before' => '',
173	'class' => 'testimonial-rating',
174	);
175	}
176	if ( $client_section ) {
177	$view['client_section'] = $client_section;
178	}
179
180	$wpdb->query( // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
181	$wpdb->prepare(
182	"INSERT INTO {$table} (name, value) VALUES (%s, %s)",
183	__( 'Testimonials Display', 'strong-testimonials' ),
184	serialize( $view ) // phpcs:ignore WordPress.PHP.DiscouragedPHPFunctions.serialize_serialize
185	)
186	);
187	$new_id = absint( $wpdb->insert_id );
188	if ( $new_id > 0 ) {
189	$stored_ids['display'] = $new_id;
190	$updated = true;
191	}
192	} elseif ( ! isset( $stored_ids['display'] ) && wpmtst_mode_view_exists( $table, 'display' ) ) {
193	// Existing install already has a display view — mark as seen so we never create one.
194	$stored_ids['display'] = 0;
195	$updated = true;
196	}
197
198	// Testimonials Collection Form — create once; if stored ID exists the user has already seen/deleted it.
199	if ( ! isset( $stored_ids['form'] ) && ! wpmtst_mode_view_exists( $table, 'form' ) ) {
200	$view = Strong_Testimonials_Defaults::get_default_view();
201	$view['mode'] = 'form';
202	$wpdb->query( // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
203	$wpdb->prepare(
204	"INSERT INTO {$table} (name, value) VALUES (%s, %s)",
205	__( 'Testimonials Collection Form', 'strong-testimonials' ),
206	serialize( $view ) // phpcs:ignore WordPress.PHP.DiscouragedPHPFunctions.serialize_serialize
207	)
208	);
209	$new_id = absint( $wpdb->insert_id );
210	if ( $new_id > 0 ) {
211	$stored_ids['form'] = $new_id;
212	$updated = true;
213	}
214	} elseif ( ! isset( $stored_ids['form'] ) && wpmtst_mode_view_exists( $table, 'form' ) ) {
215	// Existing install already has a form view — mark as seen so we never create one.
216	$stored_ids['form'] = 0;
217	$updated = true;
218	}
219
220	if ( $updated ) {
221	update_option( 'wpmtst_default_views', $stored_ids, 'no' );
222	}
223	}
224