wp_set_option_autoload_values( array $options ): array

388function wp_set_option_autoload_values( array $options ) {389	global $wpdb;390 391	if ( ! $options ) {392		return array();393	}394 395	$grouped_options = array(396		'on'  => array(),397		'off' => array(),398	);399	$results         = array();400	foreach ( $options as $option => $autoload ) {401		wp_protect_special_option( $option ); // Ensure only valid options can be passed.402 403		/*404		 * Sanitize autoload value and categorize accordingly.405		 * The values 'yes', 'no', 'on', and 'off' are supported for backward compatibility.406		 */407		if ( 'off' === $autoload || 'no' === $autoload || false === $autoload ) {408			$grouped_options['off'][] = $option;409		} else {410			$grouped_options['on'][] = $option;411		}412		$results[ $option ] = false; // Initialize result value.413	}414 415	$where      = array();416	$where_args = array();417	foreach ( $grouped_options as $autoload => $options ) {418		if ( ! $options ) {419			continue;420		}421		$placeholders = implode( ',', array_fill( 0, count( $options ), '%s' ) );422		$where[]      = "autoload != '%s' AND option_name IN ($placeholders)";423		$where_args[] = $autoload;424		foreach ( $options as $option ) {425			$where_args[] = $option;426		}427	}428	$where = 'WHERE ' . implode( ' OR ', $where );429 430	/*431	 * Determine the relevant options that do not already use the given autoload value.432	 * If no options are returned, no need to update.433	 */434	// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared,WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare435	$options_to_update = $wpdb->get_col( $wpdb->prepare( "SELECT option_name FROM $wpdb->options $where", $where_args ) );436	if ( ! $options_to_update ) {437		return $results;438	}439 440	// Run UPDATE queries as needed (maximum 2) to update the relevant options' autoload values to 'yes' or 'no'.441	foreach ( $grouped_options as $autoload => $options ) {442		if ( ! $options ) {443			continue;444		}445		$options                      = array_intersect( $options, $options_to_update );446		$grouped_options[ $autoload ] = $options;447		if ( ! $grouped_options[ $autoload ] ) {448			continue;449		}450 451		// Run query to update autoload value for all the options where it is needed.452		$success = $wpdb->query(453			$wpdb->prepare(454				"UPDATE $wpdb->options SET autoload = %s WHERE option_name IN (" . implode( ',', array_fill( 0, count( $grouped_options[ $autoload ] ), '%s' ) ) . ')',455				array_merge(456					array( $autoload ),457					$grouped_options[ $autoload ]458				)459			)460		);461		if ( ! $success ) {462			// Set option list to an empty array to indicate no options were updated.463			$grouped_options[ $autoload ] = array();464			continue;465		}466 467		// Assume that on success all options were updated, which should be the case given only new values are sent.