+global\Jetpack_Sync_Options::update_option()

Complexity

Conditions	3
Paths	4

Size

Total Lines	29
Code Lines	16

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
	static function update_option( $name, $value, $autoload = false ) {

		$autoload_value = $autoload ? 'yes' : 'no';

		// we write our own option updating code to bypass filters/caching/etc on set_option/get_option
		global $wpdb;
		$serialized_value = maybe_serialize( $value );
		// try updating, if no update then insert
		// TODO: try to deal with the fact that unchanged values can return updated_num = 0

Comments for TODO tasks are often forgotten in the code; it might be better to use a dedicated issue tracker.

		// below we used "insert ignore" to at least suppress the resulting error
		$updated_num = $wpdb->query(
			$wpdb->prepare(
				"UPDATE $wpdb->options SET option_value = %s WHERE option_name = %s", 
				$serialized_value,
				$name
			)
		);

		if ( ! $updated_num ) {
			$updated_num = $wpdb->query(
				$wpdb->prepare(
					"INSERT IGNORE INTO $wpdb->options ( option_name, option_value, autoload ) VALUES ( %s, %s, '$autoload_value' )", 
					$name,
					$serialized_value
				)
			);
		}
		return $updated_num;
	}

}