Edit File by line

<?php if ( ! defined( 'ABSPATH' ) ) exit;

[0] Fix | Delete

[1] Fix | Delete

class NF_Database_Migrations

[2] Fix | Delete

{

[3] Fix | Delete

protected $migrations = array();

[4] Fix | Delete

[5] Fix | Delete

[6] Fix | Delete

/**

[7] Fix | Delete

* Constructor method for the NF_Database_Migrations class.

[8] Fix | Delete

[9] Fix | Delete

* @since 3.0.0

[10] Fix | Delete

[11] Fix | Delete

* @updated 3.3.8

[12] Fix | Delete

[13] Fix | Delete

public function __construct()

[14] Fix | Delete

{

[15] Fix | Delete

$this->migrations[ 'forms' ] = new NF_Database_Migrations_Forms();

[16] Fix | Delete

$this->migrations[ 'form_meta' ] = new NF_Database_Migrations_FormMeta();

[17] Fix | Delete

$this->migrations[ 'fields' ] = new NF_Database_Migrations_Fields();

[18] Fix | Delete

$this->migrations[ 'field_meta' ] = new NF_Database_Migrations_FieldMeta();

[19] Fix | Delete

$this->migrations[ 'actions' ] = new NF_Database_Migrations_Actions();

[20] Fix | Delete

$this->migrations[ 'action_meta' ] = new NF_Database_Migrations_ActionMeta();

[21] Fix | Delete

$this->migrations[ 'objects' ] = new NF_Database_Migrations_Objects();

[22] Fix | Delete

$this->migrations[ 'object_meta' ] = new NF_Database_Migrations_ObjectMeta();

[23] Fix | Delete

$this->migrations[ 'relationships' ] = new NF_Database_Migrations_Relationships();

[24] Fix | Delete

$this->migrations[ 'settings' ] = new NF_Database_Migrations_Settings();

[25] Fix | Delete

$this->migrations[ 'upgrades' ] = new NF_Database_Migrations_Upgrades();

[26] Fix | Delete

$this->migrations[ 'chunks' ] = new NF_Database_Migrations_Chunks();

[27] Fix | Delete

}

[28] Fix | Delete

[29] Fix | Delete

[30] Fix | Delete

/**

[31] Fix | Delete

* Function to run each migration on the stack.

[32] Fix | Delete

[33] Fix | Delete

* @since 3.0.0

[34] Fix | Delete

[35] Fix | Delete

public function migrate()

[36] Fix | Delete

{

[37] Fix | Delete

foreach( $this->migrations as $migration ){

[38] Fix | Delete

$migration->_run();

[39] Fix | Delete

}

[40] Fix | Delete

}

[41] Fix | Delete

[42] Fix | Delete

[43] Fix | Delete

/**

[44] Fix | Delete

* Function to run any required database upgrades.

[45] Fix | Delete

[46] Fix | Delete

* @param $callback (String) The method this upgrade will call from individual migration files.

[47] Fix | Delete

[48] Fix | Delete

* @since 3.4.0

[49] Fix | Delete

[50] Fix | Delete

public function do_upgrade( $callback )

[51] Fix | Delete

{

[52] Fix | Delete

foreach( $this->migrations as $migration ) {

[53] Fix | Delete

$migration->_do_upgrade( $callback );

[54] Fix | Delete

}

[55] Fix | Delete

}

[56] Fix | Delete

[57] Fix | Delete

/**

[58] Fix | Delete

* This function drops ninja forms tables and options

[59] Fix | Delete

[60] Fix | Delete

* @param $areYouSure (Boolean)

[61] Fix | Delete

* @param $areYouReallySure (Boolean)

[62] Fix | Delete

* @param $nuke_multisite (Boolean)

[63] Fix | Delete

[64] Fix | Delete

* @since 2.9.34

[65] Fix | Delete

* @updated 3.3.16

[66] Fix | Delete

[67] Fix | Delete

public function nuke( $areYouSure = FALSE, $areYouReallySure = FALSE, $nuke_multisite = TRUE )

[68] Fix | Delete

{

[69] Fix | Delete

if( ! $areYouSure || ! $areYouReallySure ) return;

[70] Fix | Delete

[71] Fix | Delete

global $wpdb;

[72] Fix | Delete

[73] Fix | Delete

if( ! function_exists( 'is_multisite' ) || ! is_multisite() ){

[74] Fix | Delete

$this->_nuke();

[75] Fix | Delete

return;

[76] Fix | Delete

}

[77] Fix | Delete

// adding this to make sure we don't nuke ALL subsites when upgrading one subsite

[78] Fix | Delete

if ( $nuke_multisite ) {

[79] Fix | Delete

$blog_ids = $wpdb->get_col( "SELECT blog_id FROM $wpdb->blogs" );

[80] Fix | Delete

[81] Fix | Delete

foreach( $blog_ids as $blog_id ){

[82] Fix | Delete

switch_to_blog( $blog_id );

[83] Fix | Delete

$this->_nuke();

[84] Fix | Delete

restore_current_blog(); // Call after EVERY switch_to_blog().

[85] Fix | Delete

}

[86] Fix | Delete

} else {

[87] Fix | Delete

$this->_nuke();

[88] Fix | Delete

return;

[89] Fix | Delete

}

[90] Fix | Delete

}

[91] Fix | Delete

[92] Fix | Delete

[93] Fix | Delete

/**

[94] Fix | Delete

* Function to handle the actual deletion of tables and caches.

[95] Fix | Delete

[96] Fix | Delete

* @since 3.1.0

[97] Fix | Delete

[98] Fix | Delete

private function _nuke()

[99] Fix | Delete

{

[100] Fix | Delete

global $wpdb;

[101] Fix | Delete

[102] Fix | Delete

/* Drop THREE Tables */

[103] Fix | Delete

foreach( $this->migrations as $migration ){

[104] Fix | Delete

$migration->_drop();

[105] Fix | Delete

}

[106] Fix | Delete

[107] Fix | Delete

/* Delete form caches */

[108] Fix | Delete

$wpdb->query( "DELETE FROM `{$wpdb->options}` WHERE `option_name` LIKE 'nf_form_%'" );

[109] Fix | Delete

$wpdb->query( "DELETE FROM `{$wpdb->options}` WHERE `option_name` LIKE '_transient_nf_form_%'" );

[110] Fix | Delete

$wpdb->query( "DELETE FROM `{$wpdb->options}` WHERE `option_name` LIKE '_transient_timeout_nf_form_%'" );

[111] Fix | Delete

}

[112] Fix | Delete

[113] Fix | Delete

[114] Fix | Delete

/**

[115] Fix | Delete

* Function to nuke our 3.0 settings.

[116] Fix | Delete

[117] Fix | Delete

* @param $areYouSure (Boolean)

[118] Fix | Delete

* @param $areYouReallySure (Boolean)

[119] Fix | Delete

[120] Fix | Delete

* @since 3.1.0

[121] Fix | Delete

[122] Fix | Delete

public function nuke_settings( $areYouSure = FALSE, $areYouReallySure = FALSE )

[123] Fix | Delete

{

[124] Fix | Delete

if( ! $areYouSure || ! $areYouReallySure ) return;

[125] Fix | Delete

[126] Fix | Delete

global $wpdb;

[127] Fix | Delete

[128] Fix | Delete

if( ! function_exists( 'is_multisite' ) || ! is_multisite() ){

[129] Fix | Delete

$this->_nuke_settings();

[130] Fix | Delete

return;

[131] Fix | Delete

}

[132] Fix | Delete

[133] Fix | Delete

$blog_ids = $wpdb->get_col( "SELECT blog_id FROM $wpdb->blogs" );

[134] Fix | Delete

[135] Fix | Delete

foreach( $blog_ids as $blog_id ){

[136] Fix | Delete

switch_to_blog( $blog_id );

[137] Fix | Delete

$this->_nuke_settings();

[138] Fix | Delete

restore_current_blog(); // Call after EVERY switch_to_blog().

[139] Fix | Delete

}

[140] Fix | Delete

}

[141] Fix | Delete

[142] Fix | Delete

[143] Fix | Delete

/**

[144] Fix | Delete

* Function to handle the actual deletion of our 3.0 settings.

[145] Fix | Delete

[146] Fix | Delete

* @since 3.1.0

[147] Fix | Delete

[148] Fix | Delete

private function _nuke_settings()

[149] Fix | Delete

{

[150] Fix | Delete

global $wpdb;

[151] Fix | Delete

/* Delete known options */

[152] Fix | Delete

delete_option( 'nf_admin_notice' );

[153] Fix | Delete

delete_option( 'nf_form_tel_data' );

[154] Fix | Delete

delete_option( 'nf_form_tel_sent' );

[155] Fix | Delete

delete_option( 'nf_tel_collate' );

[156] Fix | Delete

delete_option( 'ninja_forms_allow_tracking' );

[157] Fix | Delete

delete_option( 'ninja_forms_db_version' );

[158] Fix | Delete

delete_option( 'ninja_forms_do_not_allow_tracking' );

[159] Fix | Delete

delete_option( 'ninja_forms_load_deprecated' );

[160] Fix | Delete

delete_option( 'ninja_forms_mailchimp_interests' );

[161] Fix | Delete

delete_option( 'ninja_forms_oauth_client_secret' );

[162] Fix | Delete

delete_option( 'ninja_forms_optin_reported' );

[163] Fix | Delete

delete_option( 'ninja_forms_settings' );

[164] Fix | Delete

delete_option( 'ninja_forms_transactional_email_enabled' );

[165] Fix | Delete

delete_option( 'ninja_forms_version' );

[166] Fix | Delete

[167] Fix | Delete

/* Delete possible options */

[168] Fix | Delete

$wpdb->query( "DELETE FROM `{$wpdb->options}` WHERE `option_name` LIKE 'wp_nf_%'" );

[169] Fix | Delete

$wpdb->query( "DELETE FROM `{$wpdb->options}` WHERE `option_name` LIKE 'ninja_forms_%'" );

[170] Fix | Delete

[171] Fix | Delete

/* Delete background processing flags */

[172] Fix | Delete

$wpdb->query( "DELETE FROM `{$wpdb->options}` WHERE `option_name` LIKE 'wp_nf_update_fields_%'" );

[173] Fix | Delete

}

[174] Fix | Delete

[175] Fix | Delete

[176] Fix | Delete

/**

[177] Fix | Delete

* Function to nuke our 2.9 database tables.

[178] Fix | Delete

[179] Fix | Delete

* @param $areYouSure (Boolean)

[180] Fix | Delete

* @param $areYouReallySure (Boolean)

[181] Fix | Delete

[182] Fix | Delete

* @since 3.1.0

[183] Fix | Delete

[184] Fix | Delete

public function nuke_deprecated( $areYouSure = FALSE, $areYouReallySure = FALSE )

[185] Fix | Delete

{

[186] Fix | Delete

if( ! $areYouSure || ! $areYouReallySure ) return;

[187] Fix | Delete

[188] Fix | Delete

global $wpdb;

[189] Fix | Delete

[190] Fix | Delete

if( ! function_exists( 'is_multisite' ) || ! is_multisite() ){

[191] Fix | Delete

$this->_nuke_deprecated();

[192] Fix | Delete

return;

[193] Fix | Delete

}

[194] Fix | Delete

[195] Fix | Delete

$blog_ids = $wpdb->get_col( "SELECT blog_id FROM $wpdb->blogs" );

[196] Fix | Delete

[197] Fix | Delete

foreach( $blog_ids as $blog_id ){

[198] Fix | Delete

switch_to_blog( $blog_id );

[199] Fix | Delete

$this->_nuke_deprecated();

[200] Fix | Delete

restore_current_blog(); // Call after EVERY switch_to_blog().

[201] Fix | Delete

}

[202] Fix | Delete

}

[203] Fix | Delete

[204] Fix | Delete

[205] Fix | Delete

/**

[206] Fix | Delete

* Function to handle the actual deletion of deprecated tables and options.

[207] Fix | Delete

[208] Fix | Delete

* @since 3.1.0

[209] Fix | Delete

[210] Fix | Delete

private function _nuke_deprecated()

[211] Fix | Delete

{

[212] Fix | Delete

global $wpdb;

[213] Fix | Delete

[214] Fix | Delete

/* Drop Deprecated Tables (v2.9.x) */

[215] Fix | Delete

$wpdb->query( "DROP TABLE IF EXISTS `{$wpdb->prefix}nf_objectmeta`" );

[216] Fix | Delete

$wpdb->query( "DROP TABLE IF EXISTS `{$wpdb->prefix}nf_objects`" );

[217] Fix | Delete

$wpdb->query( "DROP TABLE IF EXISTS `{$wpdb->prefix}nf_relationships`" );

[218] Fix | Delete

$wpdb->query( "DROP TABLE IF EXISTS `{$wpdb->prefix}ninja_forms_fav_fields`" );

[219] Fix | Delete

$wpdb->query( "DROP TABLE IF EXISTS `{$wpdb->prefix}ninja_forms_fields`" );

[220] Fix | Delete

[221] Fix | Delete

/* Delete Deprecated Options (v2.9.x) */

[222] Fix | Delete

delete_option( 'nf_upgrade_notice' );

[223] Fix | Delete

delete_option( 'nf_converted_subs' );

[224] Fix | Delete

delete_option( 'nf_converted_forms' );

[225] Fix | Delete

delete_option( 'nf_convert_subs_num' );

[226] Fix | Delete

delete_option( 'nf_convert_subs_step' );

[227] Fix | Delete

delete_option( 'nf_convert_subs_step' );

[228] Fix | Delete

delete_option( 'nf_email_fav_updated' );

[229] Fix | Delete

delete_option( 'nf_database_migrations' );

[230] Fix | Delete

delete_option( 'nf_converted_form_reset' );

[231] Fix | Delete

delete_option( 'nf_version_upgraded_from' );

[232] Fix | Delete

delete_option( 'nf_convert_forms_complete' );

[233] Fix | Delete

delete_option( 'nf_convert_notifications_forms' );

[234] Fix | Delete

delete_option( 'nf_convert_notifications_complete' );

[235] Fix | Delete

delete_option( 'nf_update_email_settings_complete' );

[236] Fix | Delete

[237] Fix | Delete

/* Delete Deprecarted Upgrade Options (v2.9.x) */

[238] Fix | Delete

$wpdb->query( "DELETE FROM `{$wpdb->options}` WHERE `option_name` LIKE 'nf_upgrade_%'" );

[239] Fix | Delete

[240] Fix | Delete

/* Maybe Remove Deprecated Scheduled Cron (v2.9.x) */

[241] Fix | Delete

if( $timestamp = wp_next_scheduled( 'ninja_forms_daily_action' ) ){

[242] Fix | Delete

wp_unschedule_event( $timestamp, 'ninja_forms_daily_action' );

[243] Fix | Delete

}

[244] Fix | Delete

}

[245] Fix | Delete

[246] Fix | Delete

}

[247] Fix | Delete

[248] Fix | Delete