WC_Log_Handler_DB::delete_logs_before_timestamp │ public static │ WC 3.4.0

Delete all logs older than a defined timestamp.

Method of the class: WC_Log_Handler_DB{}

No Hooks.

Returns

null. Nothing (null).

Usage

$result = WC_Log_Handler_DB::delete_logs_before_timestamp( $timestamp );

$timestamp(int)

Timestamp to delete logs before.

Changelog

WC_Log_Handler_DB::delete_logs_before_timestamp() WC Log Handler DB::delete logs before timestamp code ^{WC 10.5.0}

public static function delete_logs_before_timestamp( $timestamp = 0 ) {
	if ( ! $timestamp ) {
		return;
	}

	global $wpdb;

	$wpdb->query(
		$wpdb->prepare(
			"DELETE FROM {$wpdb->prefix}woocommerce_log WHERE timestamp < %s",
			date( 'Y-m-d H:i:s', $timestamp )
		)
	);

	\WC_Cache_Helper::get_transient_version( 'logs-db', true );
}