PluginProbe
HTML Forms – Simple WordPress Forms Plugin / 1.3.30
HTML Forms – Simple WordPress Forms Plugin v1.3.30
1.7.0 trunk 1.0 1.0.1 1.0.2 1.0.3 1.0.4 1.0.5 1.0.6 1.1 1.1.1 1.1.2 1.1.3 1.1.4 1.1.5 1.2.0 1.3.0 1.3.1 1.3.10 1.3.11 1.3.12 1.3.13 1.3.14 1.3.15 1.3.16 All 67 releases
← All changes | src/functions.php +334 -206 1.3.141.3.30 View file →
@@ -6,21 +6,21 @@
6 6 /**
7 7 * @param array $args
8 8 * @return array
9 9 */
10 -function hf_get_forms(array $args = array()) {
11 - $default_args = array(
12 - 'post_type' => 'html-form',
13 - 'post_status' => array( 'publish', 'draft', 'pending', 'future' ),
14 - 'posts_per_page' => -1,
15 - 'ignore_sticky_posts' => true,
16 - 'no_found_rows' => true,
17 - );
18 - $args = array_merge($default_args, $args);
19 - $query = new WP_Query;
20 - $posts = $query->query($args);
21 - $forms = array_map('hf_get_form', $posts);
22 - return $forms;
10 +function hf_get_forms( array $args = array() ) {
11 + $default_args = array(
12 + 'post_type' => 'html-form',
13 + 'post_status' => array( 'publish', 'draft', 'pending', 'future' ),
14 + 'posts_per_page' => -1,
15 + 'ignore_sticky_posts' => true,
16 + 'no_found_rows' => true,
17 + );
18 + $args = array_merge( $default_args, $args );
19 + $query = new WP_Query;
20 + $posts = $query->query( $args );
21 + $forms = array_map( 'hf_get_form', $posts );
22 + return $forms;
23 23 }
24 24
25 25 /**
26 26 * @param $form_id_or_slug int|string|WP_Post
@@ -28,97 +28,110 @@
28 28 * @throws Exception
29 29 */
30 30 function hf_get_form( $form_id_or_slug ) {
31 31
32 - if( is_numeric( $form_id_or_slug ) || $form_id_or_slug instanceof WP_Post ) {
33 - $post = get_post( $form_id_or_slug );
32 + if ( is_numeric( $form_id_or_slug ) || $form_id_or_slug instanceof WP_Post ) {
33 + $post = get_post( $form_id_or_slug );
34 34
35 - if( ! $post instanceof WP_Post || $post->post_type !== 'html-form' ) {
36 - throw new Exception( "Invalid form ID" );
37 - }
38 - } else {
35 + if ( ! $post instanceof WP_Post || $post->post_type !== 'html-form' ) {
36 + throw new Exception( 'Invalid form ID' );
37 + }
38 + } else {
39 39
40 - $query = new WP_Query;
41 - $posts = $query->query(array(
42 - 'post_type' => 'html-form',
43 - 'name' => $form_id_or_slug,
44 - 'post_status' => 'publish',
45 - 'posts_per_page' => 1,
46 - 'ignore_sticky_posts' => true,
47 - 'no_found_rows' => true,
48 - ));
49 - if( empty( $posts ) ) {
50 - throw new Exception( 'Invalid form slug' );
51 - }
52 - $post = $posts[0];
53 - }
40 + $query = new WP_Query;
41 + $posts = $query->query(
42 + array(
43 + 'post_type' => 'html-form',
44 + 'name' => $form_id_or_slug,
45 + 'post_status' => 'publish',
46 + 'posts_per_page' => 1,
47 + 'ignore_sticky_posts' => true,
48 + 'no_found_rows' => true,
49 + )
50 + );
51 + if ( empty( $posts ) ) {
52 + throw new Exception( 'Invalid form slug' );
53 + }
54 + $post = $posts[0];
55 + }
54 56
55 - // get all post meta in a single call for performance
56 - $post_meta = get_post_meta( $post->ID );
57 + // get all post meta in a single call for performance
58 + $post_meta = get_post_meta( $post->ID );
57 59
58 - // grab & merge form settings
59 - $default_settings = array(
60 - 'save_submissions' => 1,
61 - 'hide_after_success' => 0,
62 - 'redirect_url' => '',
63 - 'required_fields' =>'',
64 - 'email_fields' => '',
65 - );
66 - $default_settings = apply_filters( 'hf_form_default_settings', $default_settings );
67 - $settings = array();
68 - if( ! empty( $post_meta['_hf_settings'][0] ) ) {
69 - $settings = (array) maybe_unserialize( $post_meta['_hf_settings'][0] );
70 - }
71 - $settings = array_merge( $default_settings, $settings );
60 + // grab & merge form settings
61 + $default_settings = array(
62 + 'save_submissions' => 1,
63 + 'hide_after_success' => 0,
64 + 'redirect_url' => '',
65 + 'required_fields' => '',
66 + 'email_fields' => '',
67 + );
68 + $default_settings = apply_filters( 'hf_form_default_settings', $default_settings );
69 + $settings = array();
70 + if ( ! empty( $post_meta['_hf_settings'][0] ) ) {
71 + $settings = (array) maybe_unserialize( $post_meta['_hf_settings'][0] );
72 + }
73 + $settings = array_merge( $default_settings, $settings );
72 74
73 - // grab & merge form messages
74 - $default_messages = array(
75 - 'success' => __('Thank you! We will be in touch soon.', 'html-forms'),
76 - 'invalid_email' => __( 'Sorry, that email address looks invalid.', 'html-forms' ),
77 - 'required_field_missing' => __( "Please fill in the required fields.", "html-forms" ),
78 - 'error' => __( 'Oops. An error occurred.', 'html-forms' ),
75 + // grab & merge form messages
76 + $default_messages = array(
77 + 'success' => __( 'Thank you! We will be in touch soon.', 'html-forms' ),
78 + 'invalid_email' => __( 'Sorry, that email address looks invalid.', 'html-forms' ),
79 + 'required_field_missing' => __( 'Please fill in the required fields.', 'html-forms' ),
80 + 'error' => __( 'Oops. An error occurred.', 'html-forms' ),
79 81 );
80 82 $default_messages = apply_filters( 'hf_form_default_messages', $default_messages );
81 - $messages = array();
82 - foreach( $post_meta as $meta_key => $meta_values ) {
83 - if( strpos( $meta_key, 'hf_message_' ) === 0 ) {
84 - $message_key = substr( $meta_key, strlen( 'hf_message_' ) );
85 - $messages[$message_key] = (string) $meta_values[0];
86 - }
87 - }
88 - $messages = array_merge( $default_messages, $messages );
83 + $messages = array();
84 + foreach ( $post_meta as $meta_key => $meta_values ) {
85 + if ( strpos( $meta_key, 'hf_message_' ) === 0 ) {
86 + $message_key = substr( $meta_key, strlen( 'hf_message_' ) );
87 + $messages[ $message_key ] = (string) $meta_values[0];
88 + }
89 + }
90 + $messages = array_merge( $default_messages, $messages );
89 91
90 - // finally, create form instance
91 - $form = new Form( $post->ID );
92 - $form->title = $post->post_title;
93 - $form->slug = $post->post_name;
94 - $form->markup = $post->post_content;
95 - $form->settings = $settings;
96 - $form->messages = $messages;
97 - return $form;
92 + // finally, create form instance
93 + $form = new Form( $post->ID );
94 + $form->title = $post->post_title;
95 + $form->slug = $post->post_name;
96 + $form->markup = $post->post_content;
97 + $form->settings = $settings;
98 + $form->messages = $messages;
99 + return $form;
98 100 }
99 101
100 102 /**
101 103 * @param $form_id
104 + * @return int
105 + */
106 +function hf_count_form_submissions( $form_id ) {
107 + global $wpdb;
108 + $table = $wpdb->prefix . 'hf_submissions';
109 + $result = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM {$table} s WHERE s.form_id = %d;", $form_id ) );
110 + return (int) $result;
111 +}
112 +
113 +/**
114 + * @param $form_id
102 115 * @param array $args
103 116 * @return Submission[]
104 117 */
105 118 function hf_get_form_submissions( $form_id, array $args = array() ) {
106 - $default_args = array(
107 - 'offset' => 0,
108 - 'limit' => 1000,
109 - );
110 - $args = array_merge( $default_args, $args );
119 + $default_args = array(
120 + 'offset' => 0,
121 + 'limit' => 1000,
122 + );
123 + $args = array_merge( $default_args, $args );
111 124
112 - global $wpdb;
113 - $table = $wpdb->prefix .'hf_submissions';
114 - $results = $wpdb->get_results( $wpdb->prepare( "SELECT s.* FROM {$table} s WHERE s.form_id = %d ORDER BY s.submitted_at DESC LIMIT %d, %d;", $form_id, $args['offset'], $args['limit'] ), OBJECT_K );
115 - $submissions = array();
116 - foreach( $results as $key => $object ) {
117 - $submission = Submission::from_object( $object );
118 - $submissions[$key] = $submission;
119 - }
120 - return $submissions;
125 + global $wpdb;
126 + $table = $wpdb->prefix . 'hf_submissions';
127 + $results = $wpdb->get_results( $wpdb->prepare( "SELECT s.* FROM {$table} s WHERE s.form_id = %d ORDER BY s.submitted_at DESC LIMIT %d, %d;", $form_id, $args['offset'], $args['limit'] ), OBJECT_K );
128 + $submissions = array();
129 + foreach ( $results as $key => $object ) {
130 + $submission = Submission::from_object( $object );
131 + $submissions[ $key ] = $submission;
132 + }
133 + return $submissions;
121 134 }
122 135
123 136 /**
124 137 * @param int $submission_id
@@ -124,41 +137,41 @@
124 137 * @param int $submission_id
125 138 * @return Submission
126 139 */
127 140 function hf_get_form_submission( $submission_id ) {
128 - global $wpdb;
129 - $table = $wpdb->prefix .'hf_submissions';
130 - $object = $wpdb->get_row( $wpdb->prepare( "SELECT s.* FROM {$table} s WHERE s.id = %d;", $submission_id ), OBJECT );
131 - $submission = Submission::from_object( $object );
132 - return $submission;
141 + global $wpdb;
142 + $table = $wpdb->prefix . 'hf_submissions';
143 + $object = $wpdb->get_row( $wpdb->prepare( "SELECT s.* FROM {$table} s WHERE s.id = %d;", $submission_id ), OBJECT );
144 + $submission = Submission::from_object( $object );
145 + return $submission;
133 146 }
134 147 /**
135 148 * @return array
136 149 */
137 150 function hf_get_settings() {
138 - $default_settings = array(
139 - 'load_stylesheet' => 0,
140 - );
151 + $default_settings = array(
152 + 'load_stylesheet' => 0,
153 + );
141 154
142 - $settings = get_option( 'hf_settings', null );
155 + $settings = get_option( 'hf_settings', null );
143 156
144 - // prevent a SQL query when option does not yet exist
145 - if ($settings === null) {
146 - update_option('hf_settings', array(), true);
147 - $settings = array();
148 - }
157 + // prevent a SQL query when option does not yet exist
158 + if ( $settings === null ) {
159 + update_option( 'hf_settings', array(), true );
160 + $settings = array();
161 + }
149 162
150 - // merge with default settings
151 - $settings = array_merge( $default_settings, $settings );
163 + // merge with default settings
164 + $settings = array_merge( $default_settings, $settings );
152 165
153 - /**
154 - * Filters the global HTML Forms hf_settings
155 - *
156 - * @param array $settings
157 - */
158 - $settings = apply_filters( 'hf_settings', $settings );
166 + /**
167 + * Filters the global HTML Forms hf_settings
168 + *
169 + * @param array $settings
170 + */
171 + $settings = apply_filters( 'hf_settings', $settings );
159 172
160 - return $settings;
173 + return $settings;
161 174 }
162 175
163 176 /**
164 177 * Get element from array, allows for dot notation eg: "foo.bar"
@@ -168,25 +181,25 @@
168 181 * @param mixed $default
169 182 * @return mixed
170 183 */
171 184 function hf_array_get( $array, $key, $default = null ) {
172 - if ( is_null( $key ) ) {
173 - return $array;
174 - }
185 + if ( is_null( $key ) ) {
186 + return $array;
187 + }
175 188
176 - if ( isset( $array[$key] ) ) {
177 - return $array[$key];
178 - }
189 + if ( isset( $array[ $key ] ) ) {
190 + return $array[ $key ];
191 + }
179 192
180 - foreach (explode( '.', $key ) as $segment) {
181 - if ( ! is_array( $array ) || ! array_key_exists( $segment, $array ) ) {
182 - return $default;
183 - }
193 + foreach ( explode( '.', $key ) as $segment ) {
194 + if ( ! is_array( $array ) || ! array_key_exists( $segment, $array ) ) {
195 + return $default;
196 + }
184 197
185 - $array = $array[$segment];
186 - }
198 + $array = $array[ $segment ];
199 + }
187 200
188 - return $array;
201 + return $array;
189 202 }
190 203
191 204 /**
192 205 * Processes template tags like {{user.user_email}}
@@ -195,40 +208,44 @@
195 208 *
196 209 * @return string
197 210 */
198 211 function hf_template( $template ) {
199 - $replacers = new HTML_Forms\TagReplacers();
200 - $tags = array(
201 - 'user' => array( $replacers, 'user' ),
202 - 'post' => array( $replacers, 'post'),
203 - 'url_params' => array( $replacers, 'url_params' ),
204 - );
212 + $replacers = new HTML_Forms\TagReplacers();
213 + $tags = array(
214 + 'user' => array( $replacers, 'user' ),
215 + 'post' => array( $replacers, 'post' ),
216 + 'url_params' => array( $replacers, 'url_params' ),
217 + );
205 218
206 - /**
207 - * Filters the available tags in HTML Forms templates, like {{user.user_email}}.
208 - *
209 - * Can be used to add simple scalar replacements or more advanced replacement functions that accept a parameter.
210 - *
211 - * @param array $tags
212 - */
213 - $tags = apply_filters( 'hf_template_tags', $tags );
219 + /**
220 + * Filters the available tags in HTML Forms templates, like {{user.user_email}}.
221 + *
222 + * Can be used to add simple scalar replacements or more advanced replacement functions that accept a parameter.
223 + *
224 + * @param array $tags
225 + */
226 + $tags = apply_filters( 'hf_template_tags', $tags );
214 227
215 - $template = preg_replace_callback( '/\{\{ *(\w+)(?:\.([\w\.]+))? *(?:\|\| *(\w+))? *\}\}/', function( $matches ) use ( $tags ) {
216 - $tag = $matches[1];
217 - $param = ! isset( $matches[2] ) ? "" : $matches[2];
218 - $default = ! isset( $matches[3] ) ? "" : $matches[3];
228 + $template = preg_replace_callback(
229 + '/\{\{ *(\w+)(?:\.([\w\.]+))? *(?:\|\| *(\w+))? *\}\}/',
230 + function( $matches ) use ( $tags ) {
231 + $tag = $matches[1];
232 + $param = ! isset( $matches[2] ) ? '' : $matches[2];
233 + $default = ! isset( $matches[3] ) ? '' : $matches[3];
219 234
220 - // do not change anything if we have no replacer with that key, could be custom user logic or another plugin.
221 - if( ! isset( $tags[ $tag] ) ) {
222 - return $matches[0];
223 - }
235 + // do not change anything if we have no replacer with that key, could be custom user logic or another plugin.
236 + if ( ! isset( $tags[ $tag ] ) ) {
237 + return $matches[0];
238 + }
224 239
225 - $replacement = $tags[$tag];
226 - $value = is_callable( $replacement ) ? call_user_func_array( $replacement, array( $param ) ) : $replacement;
227 - return ! empty( $value ) ? $value : $default;
228 - }, $template );
240 + $replacement = $tags[ $tag ];
241 + $value = is_callable( $replacement ) ? call_user_func_array( $replacement, array( $param ) ) : $replacement;
242 + return ! empty( $value ) ? $value : $default;
243 + },
244 + $template
245 + );
229 246
230 - return $template;
247 + return $template;
231 248 }
232 249
233 250 /**
234 251 * @param string $string
@@ -235,17 +252,22 @@
235 252 * @param array $data
236 253 * @param Closure|string $escape_function
237 254 * @return string
238 255 */
239 -function hf_replace_data_variables($string, $data = array(), $escape_function = null) {
240 - $string = preg_replace_callback( '/\[([a-zA-Z0-9\-\._]+)\]/', function($matches) use ($data, $escape_function) {
241 - $key = $matches[1];
242 - $replacement = hf_array_get( $data, $key, '' );
243 - $replacement = hf_field_value( $replacement, 0, $escape_function);
244 - return $replacement;
245 - }, $string );
246 - return $string;
247 -}
256 +function hf_replace_data_variables( $string, $data = array(), $escape_function = null ) {
257 + return preg_replace_callback(
258 + '/\[(.+?)\]/',
259 + function( $matches ) use ( $data, $escape_function ) {
260 + $key = $matches[1];
261 + // replace spaces in name with underscores to match PHP requirement for keys in $_POST superglobal
262 + $key = str_replace( ' ', '_', $key );
263 + $replacement = hf_array_get( $data, $key, '' );
264 + $replacement = hf_field_value( $replacement, 0, $escape_function );
265 + return $replacement;
266 + },
267 + $string
268 + );
269 +}
248 270
249 271 /**
250 272 * Returns a formatted & HTML-escaped field value. Detects file-, array- and date-types.
251 273 *
@@ -256,49 +278,49 @@
256 278 * @param Closure|string $escape_function
257 279 * @return string
258 280 * @since 1.3.1
259 281 */
260 -function hf_field_value( $value, $limit = 0, $escape_function = 'esc_html') {
261 - if( $value === '' ) {
262 - return $value;
263 - }
282 +function hf_field_value( $value, $limit = 0, $escape_function = 'esc_html' ) {
283 + if ( $value === '' ) {
284 + return $value;
285 + }
264 286
265 - if( hf_is_file( $value ) ) {
266 - $file_url = isset( $value['url'] ) ? $value['url'] : '';
267 - if( isset( $value['attachment_id'] ) ) {
268 - $file_url = admin_url( sprintf( 'post.php?action=edit&post=%d', $value['attachment_id'] ) );
269 - }
270 - $short_name = substr( $value['name'], 0, 20 );
271 - $suffix = strlen( $value['name'] ) > 20 ? '...' : '';
272 - return sprintf( '<a href="%s">%s%s</a> (%s)', esc_attr( $file_url ), esc_html( $short_name ), esc_html( $suffix ), hf_human_filesize( $value['size'] ) );
273 - }
287 + if ( hf_is_file( $value ) ) {
288 + $file_url = isset( $value['url'] ) ? $value['url'] : '';
289 + if ( isset( $value['attachment_id'] ) && apply_filters( 'hf_file_upload_use_direct_links', false ) === false ) {
290 + $file_url = admin_url( sprintf( 'post.php?action=edit&post=%d', $value['attachment_id'] ) );
291 + }
292 + $short_name = substr( $value['name'], 0, 20 );
293 + $suffix = strlen( $value['name'] ) > 20 ? '...' : '';
294 + return sprintf( '<a href="%s">%s%s</a> (%s)', esc_attr( $file_url ), esc_html( $short_name ), esc_html( $suffix ), hf_human_filesize( $value['size'] ) );
295 + }
274 296
275 - if( hf_is_date( $value ) ) {
276 - $date_format = get_option( 'date_format' );
277 - return date( $date_format, strtotime( $value ) );
278 - }
297 + if ( hf_is_date( $value ) ) {
298 + $date_format = get_option( 'date_format' );
299 + return gmdate( $date_format, strtotime( $value ) );
300 + }
279 301
280 - // join array-values with comma
281 - if( is_array( $value ) ) {
282 - $value = join( ', ', $value );
283 - }
302 + // join array-values with comma
303 + if ( is_array( $value ) ) {
304 + $value = join( ', ', $value );
305 + }
284 306
285 - // limit string to certain length
286 - if( $limit > 0 ) {
287 - $limited = strlen($value) > $limit;
288 - $value = substr( $value, 0, $limit );
307 + // limit string to certain length
308 + if ( $limit > 0 ) {
309 + $limited = strlen( $value ) > $limit;
310 + $value = substr( $value, 0, $limit );
289 311
290 - if ($limited) {
291 - $value .= '...';
292 - }
293 - }
312 + if ( $limited ) {
313 + $value .= '...';
314 + }
315 + }
294 316
295 - // escape value
296 - if ($escape_function !== null && is_callable($escape_function)) {
297 - $value = $escape_function($value);
298 - }
317 + // escape value
318 + if ( $escape_function !== null && is_callable( $escape_function ) ) {
319 + $value = $escape_function( $value );
320 + }
299 321
300 - return $value;
322 + return $value;
301 323 }
302 324
303 325 /**
304 326 * Returns true if value is a "file"
@@ -306,12 +328,12 @@
306 328 * @param mixed $value
307 329 * @return bool
308 330 */
309 331 function hf_is_file( $value ) {
310 - return is_array( $value )
311 - && isset( $value['name'] )
312 - && isset( $value['size'] )
313 - && isset( $value['type'] );
332 + return is_array( $value )
333 + && isset( $value['name'] )
334 + && isset( $value['size'] )
335 + && isset( $value['type'] );
314 336 }
315 337
316 338 /**
317 339 * Returns true if value looks like a date-string submitted from a <input type="date">
@@ -319,13 +341,16 @@
319 341 * @return bool
320 342 * @since 1.3.1
321 343 */
322 344 function hf_is_date( $value ) {
323 - return is_string( $value )
324 - && strlen( $value ) === 10
325 - && preg_match( '/\d{2,4}[-\/]\d{2}[-\/]\d{2,4}/', $value ) > 0
326 - && ( $timestamp = strtotime($value) )
327 - && $timestamp != false;
345 + if ( ! is_string( $value )
346 + || strlen( $value ) !== 10
347 + || (int) preg_match( '/\d{2,4}[-\/]\d{2}[-\/]\d{2,4}/', $value ) === 0 ) {
348 + return false;
349 + }
350 +
351 + $timestamp = strtotime( $value );
352 + return $timestamp != false;
328 353 }
329 354
330 355 /**
331 356 * @param int $size
@@ -331,11 +356,114 @@
331 356 * @param int $size
332 357 * @param int $precision
333 358 * @return string
334 359 */
335 -function hf_human_filesize($size, $precision = 2) {
336 - for( $i = 0; ($size / 1024) > 0.9; $i++, $size /= 1024 ) {
337 - // nothing, loop logic contains everything
338 - }
339 - $steps = array( 'B', 'kB', 'MB', 'GB', 'TB', 'PB', 'EB', 'ZB', 'YB' );
340 - return round($size, $precision) . $steps[$i];
360 +function hf_human_filesize( $size, $precision = 2 ) {
361 + for ( $i = 0; ( $size / 1024 ) > 0.9; $i++, $size /= 1024 ) {
362 + // nothing, loop logic contains everything
363 + }
364 + $steps = array( 'B', 'kB', 'MB', 'GB', 'TB', 'PB', 'EB', 'ZB', 'YB' );
365 + return round( $size, $precision ) . $steps[ $i ];
366 +}
367 +
368 +/**
369 + * Gets all the form tabs to show in the admin.
370 + * @param Form $form
371 + * @return array
372 + */
373 +function hf_get_admin_tabs( Form $form ) {
374 + $tabs = array(
375 + 'fields' => __( 'Fields', 'html-forms' ),
376 + 'messages' => __( 'Messages', 'html-forms' ),
377 + 'settings' => __( 'Settings', 'html-forms' ),
378 + 'actions' => __( 'Actions', 'html-forms' ),
379 + );
380 +
381 + if ( $form->settings['save_submissions'] ) {
382 + $tabs['submissions'] = __( 'Submissions', 'html-forms' );
383 + }
384 + return apply_filters( 'hf_admin_tabs', $tabs, $form );
385 +}
386 +
387 +function _hf_on_plugin_activation() {
388 + if ( is_multisite() ) {
389 + _hf_on_plugin_activation_multisite();
390 + return;
391 + }
392 +
393 + // install table for regular wp install
394 + _hf_create_submissions_table();
395 +
396 + // add "edit_forms" cap to user that activated the plugin
397 + $user = wp_get_current_user();
398 + $user->add_cap( 'edit_forms', true );
399 +}
400 +
401 +function _hf_on_plugin_activation_multisite() {
402 + $added_caps = array();
403 +
404 + foreach ( get_sites( array( 'number' => PHP_INT_MAX ) ) as $site ) {
405 + switch_to_blog( (int) $site->blog_id );
406 +
407 + // install table for current blog
408 + _hf_create_submissions_table();
409 +
410 + // iterate through current blog admins
411 + foreach ( get_users(
412 + array(
413 + 'blog_id' => (int) $site->blog_id,
414 + 'role' => 'administrator',
415 + 'fields' => 'ID',
416 + )
417 + ) as $admin_id ) {
418 + if ( ! (int) $admin_id || in_array( $admin_id, $added_caps ) ) {
419 + continue;
420 + }
421 +
422 + // add "edit_forms" cap to site admin
423 + $user = new \WP_User( (int) $admin_id );
424 + $user->add_cap( 'edit_forms', true );
425 +
426 + $added_caps[] = $admin_id;
427 + }
428 +
429 + restore_current_blog();
430 + }
431 +}
432 +
433 +// install table for main site on regular installs, or active site for multisite
434 +function _hf_create_submissions_table() {
435 + /** @var wpdb */
436 + global $wpdb;
437 +
438 + $charset_collate = $wpdb->get_charset_collate();
439 +
440 + // create table for storing submissions
441 + $table = $wpdb->prefix . 'hf_submissions';
442 + $wpdb->query(
443 + "CREATE TABLE IF NOT EXISTS {$table}(
444 + `id` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
445 + `form_id` INT UNSIGNED NOT NULL,
446 + `data` TEXT NOT NULL,
447 + `user_agent` TEXT NULL,
448 + `ip_address` VARCHAR(255) NULL,
449 + `referer_url` TEXT NULL,
450 + `submitted_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
451 +) {$charset_collate};"
452 + );
453 +}
454 +
455 +function _hf_on_add_user_to_blog( $user_id, $role, $blog_id ) {
456 + if ( 'administrator' !== $role ) {
457 + return;
458 + }
459 +
460 + // add "edit_forms" cap to site admin
461 + $user = new \WP_User( (int) $user_id );
462 + $user->add_cap( 'edit_forms', true );
463 +}
464 +
465 +function _hf_on_wp_insert_site( \WP_Site $site ) {
466 + switch_to_blog( (int) $site->blog_id );
467 + _hf_create_submissions_table();
468 + restore_current_blog();
341 469 }