Edit File by line

<?php

[0] Fix | Delete

/**

[1] Fix | Delete

* DataStorage Utility

[2] Fix | Delete

[3] Fix | Delete

* @package PUM

[4] Fix | Delete

[5] Fix | Delete

[6] Fix | Delete

[7] Fix | Delete

if ( ! defined( 'ABSPATH' ) ) {

[8] Fix | Delete

exit;

[9] Fix | Delete

}

[10] Fix | Delete

[11] Fix | Delete

/**

[12] Fix | Delete

* Initializes a temporary data storage engine used by core in various capacities.

[13] Fix | Delete

[14] Fix | Delete

class PUM_Utils_DataStorage {

[15] Fix | Delete

[16] Fix | Delete

/**

[17] Fix | Delete

* Retrieves stored data by key.

[18] Fix | Delete

[19] Fix | Delete

* Given a key, get the information from the database directly.

[20] Fix | Delete

[21] Fix | Delete

* @param string $key The stored option key.

[22] Fix | Delete

* @param null|mixed $default Optional. A default value to retrieve should `$value` be empty.

[23] Fix | Delete

* Default null.

[24] Fix | Delete

[25] Fix | Delete

* @return mixed|false The stored data, value of `$default` if not null, otherwise false.

[26] Fix | Delete

[27] Fix | Delete

public static function get( $key, $default = null ) {

[28] Fix | Delete

global $wpdb;

[29] Fix | Delete

$value = $wpdb->get_var( $wpdb->prepare( "SELECT option_value FROM $wpdb->options WHERE option_name = '%s'", $key ) );

[30] Fix | Delete

[31] Fix | Delete

if ( empty( $value ) && ! is_null( $default ) ) {

[32] Fix | Delete

return $default;

[33] Fix | Delete

}

[34] Fix | Delete

[35] Fix | Delete

return empty( $value ) ? false : maybe_unserialize( $value );

[36] Fix | Delete

}

[37] Fix | Delete

[38] Fix | Delete

/**

[39] Fix | Delete

* Write some data based on key and value.

[40] Fix | Delete

[41] Fix | Delete

* @param string $key The option_name.

[42] Fix | Delete

* @param mixed $value The value to store.

[43] Fix | Delete

[44] Fix | Delete

public static function write( $key, $value ) {

[45] Fix | Delete

global $wpdb;

[46] Fix | Delete

[47] Fix | Delete

$value = maybe_serialize( $value );

[48] Fix | Delete

[49] Fix | Delete

$data = [

[50] Fix | Delete

'option_name' => $key,

[51] Fix | Delete

'option_value' => $value,

[52] Fix | Delete

'autoload' => 'no',

[53] Fix | Delete

];

[54] Fix | Delete

[55] Fix | Delete

$formats = self::get_data_formats( $value );

[56] Fix | Delete

[57] Fix | Delete

$wpdb->replace( $wpdb->options, $data, $formats );

[58] Fix | Delete

}

[59] Fix | Delete

[60] Fix | Delete

/**

[61] Fix | Delete

* Derives the formats array based on the type of $value.

[62] Fix | Delete

[63] Fix | Delete

* @param mixed $value Value to store.

[64] Fix | Delete

[65] Fix | Delete

* @return array Formats array. First and last values will always be string ('%s').

[66] Fix | Delete

[67] Fix | Delete

public static function get_data_formats( $value ) {

[68] Fix | Delete

[69] Fix | Delete

switch ( gettype( $value ) ) {

[70] Fix | Delete

case 'integer':

[71] Fix | Delete

$formats = [ '%s', '%d', '%s' ];

[72] Fix | Delete

break;

[73] Fix | Delete

[74] Fix | Delete

case 'double':

[75] Fix | Delete

$formats = [ '%s', '%f', '%s' ];

[76] Fix | Delete

break;

[77] Fix | Delete

[78] Fix | Delete

default:

[79] Fix | Delete

case 'string':

[80] Fix | Delete

$formats = [ '%s', '%s', '%s' ];

[81] Fix | Delete

break;

[82] Fix | Delete

}

[83] Fix | Delete

[84] Fix | Delete

return $formats;

[85] Fix | Delete

}

[86] Fix | Delete

[87] Fix | Delete

/**

[88] Fix | Delete

* Deletes a piece of stored data by key.

[89] Fix | Delete

[90] Fix | Delete

* @param string $key The stored option name to delete.

[91] Fix | Delete

[92] Fix | Delete

* @return int|false The number of rows deleted, or false on error.

[93] Fix | Delete

[94] Fix | Delete

public static function delete( $key ) {

[95] Fix | Delete

global $wpdb;

[96] Fix | Delete

[97] Fix | Delete

return $wpdb->delete( $wpdb->options, [ 'option_name' => $key ] );

[98] Fix | Delete

}

[99] Fix | Delete

[100] Fix | Delete

/**

[101] Fix | Delete

* Deletes all options matching a given RegEx pattern.

[102] Fix | Delete

[103] Fix | Delete

* @param string $pattern Pattern to match against option keys.

[104] Fix | Delete

[105] Fix | Delete

* @return int|false The number of rows deleted, or false on error.

[106] Fix | Delete

[107] Fix | Delete

public static function delete_by_match( $pattern ) {

[108] Fix | Delete

global $wpdb;

[109] Fix | Delete

[110] Fix | Delete

// Double check to make sure the batch_id got included before proceeding.

[111] Fix | Delete

if ( '^[0-9a-z\\_]+' !== $pattern && ! empty( $pattern ) ) {

[112] Fix | Delete

$query = "DELETE FROM $wpdb->options WHERE option_name REGEXP %s";

[113] Fix | Delete

[114] Fix | Delete

$result = $wpdb->query( $wpdb->prepare( $query, $pattern ) );

[115] Fix | Delete

} else {

[116] Fix | Delete

$result = false;

[117] Fix | Delete

}

[118] Fix | Delete

[119] Fix | Delete

return $result;

[120] Fix | Delete

}

[121] Fix | Delete

[122] Fix | Delete

}

[123] Fix | Delete

[124] Fix | Delete