_get_forms_using_deprecated_shortcodes();
if ( empty( $affected_forms ) ) {
return;
}
$list_items = array();
foreach ( $affected_forms as $form ) {
$edit_link = get_edit_post_link( $form->ID );
$title = '' !== (string) $form->post_title
? $form->post_title
: __( '(no title)', 'mw-wp-form' );
if ( $edit_link ) {
$list_items[] = sprintf(
'%2$s',
esc_url( $edit_link ),
esc_html( $title )
);
} else {
$list_items[] = esc_html( $title );
}
}
?>
*/
protected function _get_forms_using_deprecated_shortcodes() {
$cached = get_transient( self::CACHE_KEY );
if ( false !== $cached ) {
return $cached;
}
global $wpdb;
$like_file = '%' . $wpdb->esc_like( '[mwform_file' ) . '%';
$like_image = '%' . $wpdb->esc_like( '[mwform_image' ) . '%';
$candidates = $wpdb->get_results(
$wpdb->prepare(
"SELECT ID, post_title, post_content FROM {$wpdb->posts}
WHERE post_type = %s
AND post_status NOT IN ( 'trash', 'auto-draft' )
AND ( post_content LIKE %s OR post_content LIKE %s )
ORDER BY post_title ASC",
MWF_Config::NAME,
$like_file,
$like_image
)
);
$results = array();
if ( is_array( $candidates ) ) {
foreach ( $candidates as $row ) {
// LIKE can match other shortcodes whose name begins with
// "mwform_file" or "mwform_image" (e.g. "mwform_filepicker").
// Re-check with a shortcode-aware regex.
if ( preg_match( '/\[(mwform_file|mwform_image)(\s|\])/', (string) $row->post_content ) ) {
$results[] = (object) array(
'ID' => (int) $row->ID,
'post_title' => (string) $row->post_title,
);
}
}
}
set_transient( self::CACHE_KEY, $results, HOUR_IN_SECONDS );
return $results;
}
/**
* Invalidate the cached list of forms using deprecated shortcodes.
* Fires when a form is saved, deleted, trashed, or untrashed.
*
* @param int $post_id Post ID.
*/
public function _invalidate_cache( $post_id = 0 ) {
if ( $post_id && MWF_Config::NAME !== get_post_type( $post_id ) ) {
return;
}
delete_transient( self::CACHE_KEY );
}
}