File "FrmProDb.php"
Full path: /home/bud/public_html/swamp/Response/cgi-bin/wp-admin/wp-content/plugins/formidable-pro/classes/models/FrmProDb.php
File size: 26.13 KB
MIME-type: text/x-php
Charset: utf-8
<?php
if ( ! defined( 'ABSPATH' ) ) {
die( 'You are not allowed to call this page directly.' );
}
class FrmProDb {
public static $db_version = 83;
/**
* @since 3.0.02
*/
public static $plug_version = '5.4.3';
/**
* @since 2.3
*/
public static function needs_upgrade( $needs_upgrade = false ) {
if ( ! $needs_upgrade ) {
if ( is_callable( 'FrmAppHelper::compare_for_update' ) ) {
$needs_upgrade = FrmAppHelper::compare_for_update(
array(
'option' => 'frmpro_db_version',
'new_db_version' => self::$db_version,
'new_plugin_version' => self::$plug_version,
)
);
} else {
// deprecated
$db_version = get_option( 'frmpro_db_version' );
if ( strpos( $db_version, '-' ) === false ) {
$needs_upgrade = true;
} else {
$last_upgrade = explode( '-', $db_version );
$needs_db_upgrade = (int) $last_upgrade[1] < (int) self::$db_version;
$new_version = version_compare( $last_upgrade[0], self::$plug_version, '<' );
$needs_upgrade = $needs_db_upgrade || $new_version;
}
}
}
return $needs_upgrade;
}
public static function upgrade() {
if ( ! self::needs_upgrade() ) {
return;
}
$db_version = self::$db_version; // this is the version of the database we're moving to
$old_db_version = get_option( 'frmpro_db_version' );
if ( strpos( $old_db_version, '-' ) ) {
$last_upgrade = explode( '-', $old_db_version );
$old_db_version = (int) $last_upgrade[1];
}
if ( $old_db_version && is_numeric( $old_db_version ) ) {
$migrations = array( 16, 17, 25, 27, 28, 29, 30, 31, 32, 34, 36, 37, 39, 43, 44, 50, 62, 65, 66, 71, 78, 79, 81, 83 );
foreach ( $migrations as $migration ) {
if ( $db_version >= $migration && $old_db_version < $migration ) {
call_user_func( array( __CLASS__, 'migrate_to_' . $migration ) );
}
}
}
FrmProCopiesController::install();
update_option( 'frmpro_db_version', self::$plug_version . '-' . self::$db_version );
FrmAppHelper::save_combined_js();
}
public static function uninstall() {
if ( ! current_user_can( 'administrator' ) ) {
$frm_settings = FrmAppHelper::get_settings();
wp_die( esc_html( $frm_settings->admin_permission ) );
}
delete_option('frmpro_options');
delete_option('frmpro_db_version');
//locations
delete_option( 'frm_usloc_options' );
delete_option('frmpro_copies_db_version');
delete_option('frmpro_copies_checked');
// updating
delete_site_option( 'frmpro-authorized' );
delete_site_option( 'frmpro-credentials' );
delete_site_option( 'frm_autoupdate' );
delete_site_option( 'frmpro-wpmu-sitewide' );
}
/**
* Make sure new endpoints are added before the free version upgrade happens
*
* @since 2.02.09
*/
public static function before_free_version_db_upgrade() {
FrmProContent::add_rewrite_endpoint();
}
/**
* Remove item meta for checkboxes that matches a:0:{}
* This was being inserted when there was an Other option included and nothing was selected.
* We want to clear this meta so that it can appear in a search for an empty answer.
*/
private static function migrate_to_83() {
$query = array(
'field_options like' => 's:5:"other";s:1:"1"',
'type' => 'checkbox',
);
$checkbox_field_ids_with_other_option = FrmDb::get_col( 'frm_fields', $query, 'id' );
if ( $checkbox_field_ids_with_other_option ) {
self::delete_empty_array_meta_data_from_meta( $checkbox_field_ids_with_other_option );
FrmEntry::clear_cache();
}
}
/**
* @param array $field_ids
*/
private static function delete_empty_array_meta_data_from_meta( $field_ids ) {
global $wpdb;
$field_meta = FrmDb::get_results( 'frm_item_metas', array( 'field_id' => $field_ids ), 'id, meta_value' );
$delete_ids = array();
foreach ( $field_meta as $row ) {
if ( 'a:0:{}' === $row->meta_value ) {
$delete_ids[] = $row->id;
}
}
if ( $delete_ids ) {
$meta_table = $wpdb->prefix . 'frm_item_metas';
$delete_ids_csv = implode( ',', $delete_ids );
$wpdb->query( 'DELETE FROM ' . $meta_table . ' WHERE id IN (' . $delete_ids_csv . ')' );
}
}
public static function delete_nested_views_folder() {
_deprecated_function( __METHOD__, '5.3.1' );
}
/**
* Move the range unit into the append setting.
*
* @since 4.05.01
*/
private static function migrate_to_81() {
$query = array(
'field_options like' => '"unit";s:',
'field_options not like' => '"unit";s:0:',
'type' => 'range',
);
$fields = FrmDb::get_results( 'frm_fields', $query, 'id, field_options' );
foreach ( $fields as $field ) {
$field_options = $field->field_options;
FrmProAppHelper::unserialize_or_decode( $field_options );
if ( ! isset( $field_options['unit'] ) || trim( $field_options['unit'] ) === '' ) {
continue;
}
$field_options['append'] = $field_options['unit'];
unset( $field_options['unit'] );
FrmField::update( $field->id, compact( 'field_options' ) );
unset( $field, $field_options );
}
}
/**
* Move the lookup placeholder into the normal placeholder setting.
*
* @since 4.0
*/
private static function migrate_to_79() {
$query = array(
'field_options like' => '"lookup_placeholder_text";s:',
'field_options not like' => '"lookup_placeholder_text";s:0:',
'type' => 'lookup',
);
$fields = FrmDb::get_results( 'frm_fields', $query, 'id, field_options' );
foreach ( $fields as $field ) {
$field_options = $field->field_options;
FrmProAppHelper::unserialize_or_decode( $field_options );
$original = $field_options;
FrmProXMLHelper::migrate_lookup_placeholder( $field_options );
if ( $original !== $field_options ) {
FrmField::update( $field->id, compact( 'field_options' ) );
}
unset( $field );
}
}
/**
* Remove the checkbox to use Lookup values.
*
* @since 4.0
*/
private static function migrate_to_78() {
$query = array(
'field_options like' => '"get_values_field";s:',
'field_options not like' => '"get_values_field";s:0:',
);
$fields = FrmDb::get_results( 'frm_fields', $query, 'id, field_options' );
foreach ( $fields as $field ) {
$field_options = $field->field_options;
FrmProAppHelper::unserialize_or_decode( $field_options );
$original = $field_options;
FrmProXMLHelper::migrate_lookup_checkbox_setting( $field_options );
if ( $original !== $field_options ) {
FrmField::update( $field->id, compact( 'field_options' ) );
}
unset( $field );
}
}
/**
* Move dyn_default_value to default value.
* Fields that still support dyn_default: data, radio, select, dropdown, lookup, address
*
* @since 4.0
*/
private static function migrate_to_71() {
$query = array(
'field_options like' => ':"dyn_default_value";s:',
'field_options not like' => ':"dyn_default_value";s:0',
);
$fields = FrmDb::get_results( 'frm_fields', $query, 'id, type, field_options, default_value' );
foreach ( $fields as $field ) {
$field_options = $field->field_options;
FrmProAppHelper::unserialize_or_decode( $field_options );
$update = FrmProXMLHelper::migrate_dyn_default_value( $field->type, $field_options );
if ( ! empty( $update ) ) {
FrmField::update( $field->id, $update );
}
unset( $field );
}
}
/**
* Delete uneeded default templates
*
* @since 3.06
*/
private static function migrate_to_66() {
$form_keys = array( 'frmproapplication', 'frmprorealestatelistings', 'frmprocontact' );
foreach ( $form_keys as $form_key ) {
$form = FrmForm::getOne( $form_key );
if ( $form && $form->default_template == 1 ) {
FrmForm::destroy( $form_key );
}
}
}
/**
* Make another attempt to move Pro if still nested.
* Before running the move, check if migration 50 be triggered anyway.
*
* @since 3.04.03
*/
public static function migrate_to_65() {
$pro_folder = substr( untrailingslashit( FrmProAppHelper::plugin_path() ), -4 );
if ( '/pro' !== $pro_folder || ! is_callable( 'FrmProAddonsController::get_pro_download_url' ) ) {
// not nested
return;
}
$new_plugin = WP_PLUGIN_DIR . '/formidable-pro/';
if ( file_exists( $new_plugin ) ) {
return;
}
require_once( ABSPATH . 'wp-admin/includes/class-wp-upgrader.php' );
$download_url = esc_url_raw( FrmProAddonsController::get_pro_download_url() );
// Create the plugin upgrader with our custom skin.
$installer = new Plugin_Upgrader( new FrmInstallerSkin() );
$installer->install( $download_url );
// Flush the cache and get the newly installed plugin basename.
wp_cache_flush();
$installed = $installer->plugin_info();
if ( ! $installed ) {
return;
}
activate_plugin( $installed );
}
/**
* Switch end year from 2020 to +10
*
* @since 3.01
*/
public static function migrate_to_62() {
// Get all date fields
$fields = FrmDb::get_results( 'frm_fields', array( 'type' => 'date' ), 'id, field_options, form_id' );
foreach ( $fields as $field ) {
$field_options = $field->field_options;
FrmProAppHelper::unserialize_or_decode( $field_options );
if ( isset( $field_options['end_year'] ) && $field_options['end_year'] == '2020' ) {
$field_options['end_year'] = '+10';
$options = array(
'form_id' => $field->form_id,
'field_options' => $field_options,
);
FrmField::update( $field->id, $options );
}
}
}
/**
* Attempt to move formidable/pro to formidable-pro and activate
*
* @since 3.0
*/
public static function migrate_to_50() {
$pro_folder = substr( untrailingslashit( FrmProAppHelper::plugin_path() ), -4 );
if ( '/pro' === $pro_folder ) {
// setup $wp_filesystem
new FrmCreateFile(
array(
'file_name' => '',
)
);
$plugin_helper = new FrmProInstallPlugin(
array(
'plugin_file' => 'formidable-pro/formidable-pro.php',
)
);
if ( $plugin_helper->is_active() ) {
return;
}
$attempted = get_option( 'frm_attempt_copy' );
if ( false !== $attempted ) {
// let's be sure this doesn't get run again
return;
}
update_option( 'frm_attempt_copy', true, 'no' );
if ( $plugin_helper->is_installed() ) {
$plugin_helper->activate_plugin();
} else {
// copy to new plugin folder
$new_plugin = WP_PLUGIN_DIR . '/formidable-pro/';
global $wp_filesystem;
$m = $wp_filesystem->mkdir( $new_plugin );
$result = copy_dir( FrmProAppHelper::plugin_path(), $new_plugin );
if ( true === $result ) {
$plugin_helper->activate_plugin();
}
}
}
}
/**
* Separate star from scale field
*
* @since 3.0
*/
public static function migrate_to_44() {
$image_fields = FrmDb::get_results( 'frm_fields', array( 'type' => array( 'scale', '10radio' ) ), 'id, field_options, form_id' );
foreach ( $image_fields as $field ) {
$field_options = $field->field_options;
FrmProAppHelper::unserialize_or_decode( $field_options );
if ( isset( $field_options['star'] ) && $field_options['star'] ) {
$options = array(
'form_id' => $field->form_id,
'type' => 'star',
);
FrmField::update( $field->id, $options );
}
}
}
/**
* Switch image field to url
*
* @since 3.0
*/
public static function migrate_to_43() {
// Get all image fields
$image_fields = FrmDb::get_results( 'frm_fields', array( 'type' => 'image' ), 'id, field_options, form_id' );
foreach ( $image_fields as $field ) {
$field_options = $field->field_options;
FrmProAppHelper::unserialize_or_decode( $field_options );
$field_options['show_image'] = 1;
$options = array(
'form_id' => $field->form_id,
'field_options' => $field_options,
'type' => 'url',
);
FrmField::update( $field->id, $options );
}
}
/**
* Change saved time formats
*
* @since 2.3
*/
public static function migrate_to_39() {
// Get all time fields on site
$times = FrmDb::get_col( 'frm_fields', array( 'type' => array( 'time', 'lookup' ) ), 'id' );
if ( ! $times ) {
return;
}
$values = FrmDb::get_results( 'frm_item_metas', array( 'field_id' => $times, 'meta_value LIKE' => array( ' AM', ' PM' ) ), 'meta_value, id' );
global $wpdb;
foreach ( $values as $value ) {
$meta_id = $value->id;
$value = $value->meta_value;
FrmProAppHelper::unserialize_or_decode( $value );
$new_value = array();
foreach ( (array) $value as $v ) {
$formatted_time = FrmProAppHelper::format_time( $v );
if ( $formatted_time ) {
// double check to make sure the time is correct
$check_time = gmdate( 'h:i A', strtotime( $formatted_time ) );
if ( $check_time != $v ) {
break;
}
$new_value[] = $formatted_time;
}
}
if ( ! empty( $new_value ) ) {
if ( count( $new_value ) <= 1 ) {
$new_time = implode( '', $new_value );
} else {
$new_time = maybe_serialize( $new_value );
}
$wpdb->update( $wpdb->prefix . 'frm_item_metas', array( 'meta_value' => $new_time ), array( 'id' => $meta_id ) );
}
}
}
/**
* Delete orphaned entries from duplicated repeating section data
*/
public static function migrate_to_37() {
// Get all section fields on site
$dividers = FrmDb::get_col( 'frm_fields', array( 'type' => 'divider' ), 'id' );
if ( ! $dividers ) {
return;
}
foreach ( $dividers as $divider_id ) {
$section_field = FrmField::getOne( $divider_id );
if ( ! $section_field || ! FrmField::is_repeating_field( $section_field ) ) {
continue;
}
self::delete_duplicate_data_in_section( $section_field );
}
}
/**
* Delete orphaned entries from duplicated repeating section data
*
* @param object $section_field
*/
private static function delete_duplicate_data_in_section( $section_field ) {
// Get all parent entry IDs for section field's parent form
$check_parents = FrmDb::get_col( 'frm_items', array( 'form_id' => $section_field->form_id ), 'id' );
if ( ! $check_parents ) {
return;
}
$child_form_id = $section_field->field_options['form_select'];
foreach ( $check_parents as $parent_id ) {
$all_child_ids = FrmDb::get_col( 'frm_items', array( 'form_id' => $child_form_id, 'parent_item_id' => $parent_id ), 'id' );
if ( ! $all_child_ids ) {
continue;
}
$keep_child_ids = FrmDb::get_var( 'frm_item_metas', array( 'field_id' => $section_field->id, 'item_id' => $parent_id ), 'meta_value' );
FrmProAppHelper::unserialize_or_decode( $keep_child_ids );
if ( ! is_array( $keep_child_ids ) ) {
$keep_child_ids = (array) $keep_child_ids;
}
foreach ( $all_child_ids as $child_id ) {
if ( ! in_array( $child_id, $keep_child_ids ) ) {
FrmEntry::destroy( $child_id );
}
}
}
}
/**
* Add the _frm_file meta to images without a post
* This will prevent old files from showing in the media libarary
*/
public static function migrate_to_36() {
global $wpdb;
$file_field_ids = $wpdb->get_col( $wpdb->prepare( 'SELECT id FROM ' . $wpdb->prefix . 'frm_fields WHERE type=%s', 'file' ) );
if ( ! empty( $file_field_ids ) ) {
$file_field_ids = array_filter( $file_field_ids, 'is_numeric' );
$query = 'SELECT meta_value FROM ' . $wpdb->prefix . 'frm_item_metas m LEFT JOIN ' . $wpdb->prefix . 'frm_items e ON (e.id = m.item_id) WHERE e.post_id < %d';
$uploaded_files = $wpdb->get_col( $wpdb->prepare( $query, 1 ) . ' AND field_id in (' . implode( ',', $file_field_ids ) . ')' );
$file_ids = array();
foreach ( $uploaded_files as $files ) {
if ( ! is_numeric( $files ) ) {
FrmProAppHelper::unserialize_or_decode( $files );
}
$add_files = array_filter( (array) $files, 'is_numeric' );
$file_ids = array_merge( $file_ids, $add_files );
}
foreach ( $file_ids as $file_id ) {
update_post_meta( absint( $file_id ), '_frm_file', 1 );
}
}
}
/**
* Add in_section variable to all fields within sections
*
* @since 2.01.0
*/
private static function migrate_to_34() {
$dividers = FrmDb::get_col( 'frm_fields', array( 'type' => 'divider' ), 'id' );
if ( ! $dividers ) {
return;
}
foreach ( $dividers as $divider_id ) {
$section_field = FrmField::getOne( $divider_id );
if ( ! $section_field ) {
continue;
}
self::add_in_section_variable_to_section_children( $section_field );
}
}
/**
* Add in_section variable to all of a section's children
*
* @param object $section_field
*/
private static function add_in_section_variable_to_section_children( $section_field ) {
$section_field_array = FrmProFieldsHelper::convert_field_object_to_flat_array( $section_field );
// Get all children for divider
$children = FrmProField::get_children( $section_field_array );
// Set in_section variable for all children
FrmProXMLHelper::add_in_section_value_to_field_ids( $children, $section_field->id );
}
/**
* Add an "Entry ID is equal to [get param=entry old_filter=1]" filter on single entry Views
* As of 2.0.23, single entry Views will no longer be filtered automatically by an "entry" parameter
*
* @since 2.0.23
*/
private static function migrate_to_32() {
global $wpdb;
// Get all single entry View IDs
$raw_query = '
SELECT
post_id
FROM
' . $wpdb->prefix . 'postmeta
WHERE
meta_key=%s AND
meta_value=%s';
$query = $wpdb->prepare( $raw_query, 'frm_show_count', 'one' );
$single_entry_view_ids = $wpdb->get_col( $query );
foreach ( $single_entry_view_ids as $view_id ) {
$view_options = get_post_meta( $view_id, 'frm_options', true );
if ( ! $view_options ) {
$view_options = array();
} else {
FrmProAppHelper::unserialize_or_decode( $view_options );
}
self::add_entry_id_is_equal_to_get_param_filter( $view_options );
update_post_meta( $view_id, 'frm_options', $view_options );
}
}
/**
* Add "Entry ID is equal to [get param=entry old_filter=1]" filter to a View's options
*
* @since 2.0.23
* @param array $view_options
*/
private static function add_entry_id_is_equal_to_get_param_filter( &$view_options ) {
if ( ! isset( $view_options['where'] ) ) {
$view_options['where'] = array();
}
if ( ! isset( $view_options['where_is'] ) ) {
$view_options['where_is'] = array();
}
if ( ! isset( $view_options['where_val'] ) ) {
$view_options['where_val'] = array();
}
if ( ! in_array( 'id', $view_options['where'] ) ) {
$view_options['where'][] = 'id';
$view_options['where_is'][] = '=';
$view_options['where_val'][] = '[get param=entry old_filter=1]';
}
}
/**
* Save the view shortcode to the page if it's inserted automatically
* Before removing these options, we need to get the view onto the page
*/
private static function migrate_to_31() {
$query = array(
'post_type' => 'frm_display',
'posts_per_page' => 100,
'post_status' => array( 'publish', 'private' ),
'meta_query' => array(
array(
'key' => 'frm_insert_loc',
'compare' => 'IN',
'value' => array( 'before', 'after', 'replace' ),
),
array(
'key' => 'frm_post_id',
'compare' => '>',
'value' => '0',
),
),
);
$auto_inserted_views = get_posts( $query );
foreach ( $auto_inserted_views as $view ) {
$location = get_post_meta( $view->ID, 'frm_insert_loc', true );
$post_id = get_post_meta( $view->ID, 'frm_post_id', true );
$shortcode = '[display-frm-data id=' . absint( $view->ID ) . ' filter=1]';
$post = get_post( $post_id );
if ( $post ) {
$updated_post = array( 'ID' => $post_id, 'post_content' => $post->post_content );
if ( $location == 'before' ) {
$updated_post['post_content'] = $shortcode . $updated_post['post_content'];
} else {
$updated_post['post_content'] .= $shortcode;
}
if ( wp_update_post( $updated_post ) ) {
delete_post_meta( $post_id, 'frm_display_id' );
delete_post_meta( $view->ID, 'frm_insert_loc' );
delete_post_meta( $view->ID, 'frm_post_id' );
}
}
}
}
/**
* Remove form_select from all non-repeating sections
*/
private static function migrate_to_30() {
// Get all section fields
$dividers = FrmField::getAll( array( 'fi.type' => 'divider' ) );
// Remove form_select for non-repeating sections
foreach ( $dividers as $d ) {
if ( FrmField::is_repeating_field( $d ) ) {
continue;
}
if ( FrmField::is_option_value_in_object( $d, 'form_select' ) ) {
$d->field_options['form_select'] = '';
FrmField::update( $d->id, array( 'field_options' => maybe_serialize( $d->field_options ) ) );
}
}
}
/**
* Switch repeating section forms to published and give them names
*/
private static function migrate_to_29() {
// Get all section fields
$dividers = FrmField::getAll( array( 'fi.type' => 'divider' ) );
// Update the form name and status for repeating sections
foreach ( $dividers as $d ) {
if ( ! FrmField::is_repeating_field( $d ) ) {
continue;
}
$form_id = $d->field_options['form_select'];
$new_name = $d->name;
if ( $form_id && is_numeric( $form_id ) ) {
FrmForm::update( $form_id, array( 'name' => $new_name, 'status' => 'published' ) );
}
}
}
/**
* Update incorrect end_divider form IDs
*/
private static function migrate_to_28() {
global $wpdb;
$query = $wpdb->prepare( 'SELECT fi.id, fi.form_id, form.parent_form_id FROM ' . $wpdb->prefix . 'frm_fields fi INNER JOIN ' . $wpdb->prefix . 'frm_forms form ON fi.form_id = form.id WHERE fi.type = %s AND parent_form_id > %d', 'end_divider', 0 );
$end_dividers = $wpdb->get_results( $query );
foreach ( $end_dividers as $e ) {
// Update the form_id column for the end_divider field
$wpdb->update( $wpdb->prefix . 'frm_fields', array( 'form_id' => $e->parent_form_id ), array( 'id' => $e->id ) );
// Clear the cache
wp_cache_delete( $e->id, 'frm_field' );
FrmField::delete_form_transient( $e->form_id );
}
}
/**
* Migrate style to custom post type
*/
private static function migrate_to_27() {
$new_post = array(
'post_type' => FrmStylesController::$post_type,
'post_title' => __( 'Formidable Style', 'formidable-pro' ),
'post_status' => 'publish',
'post_content' => array(),
'menu_order' => 1, //set as default
);
$exists = get_posts(
array(
'post_type' => $new_post['post_type'],
'post_status' => $new_post['post_status'],
'numberposts' => 1,
)
);
if ( $exists ) {
$new_post['ID'] = reset($exists)->ID;
}
$frmpro_settings = get_option('frmpro_options');
// If unserializing didn't work
if ( ! is_object($frmpro_settings) ) {
if ( $frmpro_settings ) { //workaround for W3 total cache conflict
$frmpro_settings = unserialize(serialize($frmpro_settings));
}
}
if ( ! is_object($frmpro_settings) ) {
return;
}
$frm_style = new FrmStyle();
$default_styles = $frm_style->get_defaults();
foreach ( $default_styles as $setting => $default ) {
if ( isset($frmpro_settings->{$setting}) ) {
$new_post['post_content'][ $setting ] = $frmpro_settings->{$setting};
}
}
$frm_style->save($new_post);
}
/**
* Let's remove the old displays now
*/
private static function migrate_to_25() {
global $wpdb;
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.SchemaChange
$wpdb->query( 'DROP TABLE IF EXISTS ' . $wpdb->prefix . 'frm_display' );
}
/**
* Migrate "allow one per field" into "unique"
*/
private static function migrate_to_17() {
global $wpdb;
$form = FrmForm::getAll();
$field_ids = array();
foreach ( $form as $f ) {
if ( isset($f->options['single_entry']) && $f->options['single_entry'] && is_numeric($f->options['single_entry_type']) ) {
$f->options['single_entry'] = 0;
$wpdb->update( $wpdb->prefix . 'frm_forms', array( 'options' => serialize( $f->options ) ), array( 'id' => $f->id ) );
$field_ids[] = $f->options['single_entry_type'];
}
unset($f);
}
if ( ! empty($field_ids) ) {
$fields = FrmDb::get_results( 'frm_fields', array( 'id' => $field_ids ), 'id, field_options' );
foreach ( $fields as $f ) {
$opts = $f->field_options;
FrmProAppHelper::unserialize_or_decode( $opts );
$opts['unique'] = 1;
$wpdb->update( $wpdb->prefix . 'frm_fields', array( 'field_options' => serialize( $opts ) ), array( 'id' => $f->id ) );
unset($f);
}
}
}
/**
* Migrate displays table into wp_posts
*/
private static function migrate_to_16() {
global $wpdb;
$display_posts = array();
if ( $wpdb->get_var( "SHOW TABLES LIKE '{$wpdb->prefix}frm_display'" ) ) { //only migrate if table exists
$dis = FrmDb::get_results('frm_display');
} else {
$dis = array();
}
foreach ( $dis as $d ) {
$post = array(
'post_title' => $d->name,
'post_content' => $d->content,
'post_date' => $d->created_at,
'post_excerpt' => $d->description,
'post_name' => $d->display_key,
'post_status' => 'publish',
'post_type' => 'frm_display',
);
$post_ID = wp_insert_post( $post );
unset($post);
update_post_meta($post_ID, 'frm_old_id', $d->id);
if ( ! isset($d->show_count) || empty($d->show_count) ) {
$d->show_count = 'none';
}
foreach ( array(
'dyncontent', 'param', 'form_id', 'post_id', 'entry_id',
'param', 'type', 'show_count', 'insert_loc',
) as $f ) {
update_post_meta( $post_ID, 'frm_' . $f, $d->{$f} );
unset($f);
}
FrmProAppHelper::unserialize_or_decode( $d->options );
update_post_meta($post_ID, 'frm_options', $d->options);
if ( isset( $d->options['insert_loc'] ) && $d->options['insert_loc'] != 'none' && is_numeric( $d->options['post_id'] ) && ! isset( $display_posts[ $d->options['post_id'] ] ) ) {
$display_posts[ $d->options['post_id'] ] = $post_ID;
}
unset($d, $post_ID);
}
unset($dis);
//get all post_ids from frm_entries
$entry_posts = FrmDb::get_results( $wpdb->prefix . 'frm_items', array( 'post_id >' => 1 ), 'id, post_id, form_id' );
$form_display = array();
foreach ( $entry_posts as $ep ) {
if ( isset( $form_display[ $ep->form_id ] ) ) {
$display_posts[ $ep->post_id ] = $form_display[ $ep->form_id ];
} else {
$d = FrmProDisplay::get_auto_custom_display( array( 'post_id' => $ep->post_id, 'form_id' => $ep->form_id, 'entry_id' => $ep->id ) );
$display_posts[ $ep->post_id ] = $d ? $d->ID : 0;
$form_display[ $ep->form_id ] = $display_posts[ $ep->post_id ];
unset( $d );
}
unset($ep);
}
unset($form_display);
foreach ( $display_posts as $post_ID => $d ) {
if ( $d ) {
update_post_meta($post_ID, 'frm_display_id', $d);
}
unset($d, $post_ID);
}
unset($display_posts);
}
}