# performance-lab/1.8.0/modules/database/sqlite/activate.php

Performance Lab, version 1.8.0. 180 lines.

- Page: https://pluginprobe.com/plugins/performance-lab/1.8.0/code/modules/database/sqlite/activate.php
- Raw: https://pluginprobe.com/plugins/performance-lab/1.8.0/raw/modules/database/sqlite/activate.php
- Modified: 2022-12-19T18:15:22+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/performance-lab/1.8.0/code/modules/database/sqlite/activate.php#L10-L20`.

```php
<?php
/**
 * Actions to run when the module gets activated.
 *
 * @since 1.8.0
 * @package performance-lab
 */

/**
 * Copies the db.php file in wp-content and reloads the page.
 *
 * @since 1.8.0
 */
return function() {
	// Bail early if the SQLite3 class does not exist.
	if ( ! class_exists( 'SQLite3' ) ) {
		return;
	}

	$destination = WP_CONTENT_DIR . '/db.php';

	// Place database drop-in if not present yet, except in case there is
	// another database drop-in present already.
	if ( ! defined( 'PERFLAB_SQLITE_DB_DROPIN_VERSION' ) && ! file_exists( $destination ) ) {
		// Init the filesystem to allow copying the file.
		global $wp_filesystem;

		require_once ABSPATH . '/wp-admin/includes/file.php';

		// Init the filesystem if needed, then copy the file, replacing contents as needed.
		if ( ( $wp_filesystem || WP_Filesystem() ) && $wp_filesystem->touch( $destination ) ) {

			// Get the db.copy.php file contents, replace placeholders and write it to the destination.
			$file_contents = str_replace(
				'{SQLITE_IMPLEMENTATION_FOLDER_PATH}',
				__DIR__,
				file_get_contents( __DIR__ . '/db.copy.php' )
			);

			$wp_filesystem->put_contents( $destination, $file_contents );
		}
	}

	// Do not automatically set up SQLite DB on a multisite as that is notably
	// more complex. Potentially it can be added in the future.
	if ( is_multisite() ) {
		return;
	}

	// As an extra safety check, bail if the current user cannot update
	// (or install) WordPress core.
	if ( ! current_user_can( 'update_core' ) ) {
		return;
	}

	// Otherwise install WordPress in the SQLite database before the redirect,
	// so that the user does not end up on the WordPress installation screen
	// but rather remains in the Performance Lab modules screen.
	add_filter(
		'wp_redirect',
		function( $redirect_location ) {
			if ( ! defined( 'DATABASE_TYPE' ) ) {
				define( 'DATABASE_TYPE', 'sqlite' );
			}
			require_once __DIR__ . '/constants.php';

			// If the SQLite DB already exists, simply ensure the module is
			// active there.
			if ( file_exists( FQDB ) ) {
				require_once __DIR__ . '/wp-includes/sqlite/db.php';
				wp_set_wpdb_vars();
				global $wpdb;
				$row = $wpdb->get_row( $wpdb->prepare( "SELECT option_value FROM $wpdb->options WHERE option_name = %s LIMIT 1", PERFLAB_MODULES_SETTING ) );
				if ( is_object( $row ) ) {
					$value = maybe_unserialize( $row->option_value );
					if ( is_array( $value ) && ( ! isset( $value['database/sqlite'] ) || ! $value['database/sqlite']['enabled'] ) ) {
						$value['database/sqlite'] = array( 'enabled' => true );
						$wpdb->update( $wpdb->options, array( 'option_value' => maybe_serialize( $value ) ), array( 'option_name' => PERFLAB_MODULES_SETTING ) );
					}
				}
				return $redirect_location;
			}

			// Get current basic setup data to install WordPress in the new DB.
			$blog_title  = get_bloginfo( 'name' );
			$is_public   = (bool) get_option( 'blog_public' );
			$language    = get_option( 'WPLANG' );
			$admin_email = get_option( 'admin_email' );
			$admin_user  = get_user_by( 'email', $admin_email );
			if ( ! $admin_user ) {
				$admin_user = wp_get_current_user();
			}

			// Look up the data for the current user (in case they're not the
			// admin email user). Additionally, attempt to keep them
			// logged-in by retaining their current session. Depending on the
			// site configuration, this is not 100% reliable as sites may store
			// session tokens outside of user meta. However that does not lead
			// to any problem, the user would simply be required to sign in
			// again.
			$current_user          = wp_get_current_user();
			$current_user_sessions = get_user_meta( $current_user->ID, 'session_tokens', true );

			// Get current data to keep the Performance Lab plugin and relevant
			// modules active in the new DB.
			$active_plugins_option = array( plugin_basename( PERFLAB_MAIN_FILE ) );
			$active_modules_option = get_option( PERFLAB_MODULES_SETTING, array() );

			// Load and set up SQLite database.
			require_once __DIR__ . '/wp-includes/sqlite/db.php';
			wp_set_wpdb_vars();

			// Load WordPress installation API functions.
			require_once ABSPATH . 'wp-admin/includes/upgrade.php';

			// Install WordPress in the SQLite database with the same base
			// configuration as the MySQL database.
			// Since $admin_user->user_pass is already hashed, add a filter to
			// ensure it is inserted into the database like that, instead of
			// being re-hashed.
			$unhash_user_pass = function( $data, $update, $user_id, $userdata ) use ( $admin_user, $current_user ) {
				// Double check this is actually the already hashed password,
				// to prevent any chance of accidentally putting another
				// password into the database which would then be plain text.
				if (
					! empty( $userdata['user_pass'] )
					&& (
						$userdata['user_pass'] === $admin_user->user_pass
						|| $userdata['user_pass'] === $current_user->user_pass
					)
				) {
					$data['user_pass'] = $userdata['user_pass'];
				}
				return $data;
			};
			add_filter( 'wp_pre_insert_user_data', $unhash_user_pass, 10, 4 );
			wp_install( $blog_title, $admin_user->user_login, $admin_user->user_email, $is_public, '', $admin_user->user_pass, $language );
			// If the current user is not the admin user, create an account for that user too.
			if ( $current_user->user_login !== $admin_user->user_login ) {
				wp_create_user( $current_user->user_login, $current_user->user_pass, $current_user->user_email );
			}
			remove_filter( 'wp_pre_insert_user_data', $unhash_user_pass );

			// If the admin email was originally not attached to any user
			// (e.g. when the original admin email user was deleted), reset
			// the option to the original admin email again (by default
			// `wp_install()` will set it to the same email as the initial
			// admin user email).
			if ( 0 !== strcasecmp( $admin_user->user_email, $admin_email ) ) {
				update_option( 'admin_email', $admin_email );
			}

			// If user sessions are found, migrate them over so that the
			// current user remains logged in.
			if ( $current_user_sessions ) {
				$session_user = get_user_by( 'login', $current_user->user_login );
				if ( $session_user ) {
					update_user_meta( $session_user->ID, 'session_tokens', $current_user_sessions );
				}
			}

			// Activate the Performance Lab plugin and its modules.
			// Use direct database query for Performance Lab modules to
			// prevent module activation logic from firing again.
			update_option( 'active_plugins', $active_plugins_option );
			global $wpdb;
			$wpdb->insert(
				$wpdb->options,
				array(
					'option_name'  => PERFLAB_MODULES_SETTING,
					'option_value' => maybe_serialize( $active_modules_option ),
					'autoload'     => 'yes',
				)
			);

			return $redirect_location;
		}
	);
};

```