As the sun rises and the forest mist clears, and the clouds return and the caves darken, these changes of light and shadow are the morning and evening in the mountains. Wildflowers bloom with their subtle fragrance, fine trees flourish with their dense shade, the wind and frost are pure and clean, and the water recedes to reveal the rocks—these are the four seasons in the mountains. Going out in the morning and returning in the evening, the scenery of the four seasons is different, and the joy is endless.至于负者歌于途,行者休于树,前者呼,后者应,伛偻提携,往来而不绝者,滁人游也。临溪而渔,溪深而鱼肥,酿泉为酒,泉香而酒洌,山肴野蔌,杂然而前陈者,太守宴也。宴酣之乐,非丝非竹,射者中,弈者胜,觥筹交错,起坐而喧哗者,众宾欢也。苍颜白发,颓然乎其间者,太守醉也。
<?php
namespace Code_Snippets;
use WP_User;
/**
* Manages upgrade tasks such as deleting and updating options
*/
class Upgrade {
/**
* Instance of database class
*
* @var DB
*/
private DB $db;
/**
* The current plugin version number
*
* @var string
*/
private string $current_version;
/**
* Class constructor
*
* @param string $version Current plugin version.
* @param DB $db Instance of database class.
*/
public function __construct( string $version, DB $db ) {
$this->db = $db;
$this->current_version = $version;
}
/**
* Run the upgrade functions
*/
public function run() {
// Always run multisite upgrades, even if not on the main site, as sub-sites depend on the network snippet table.
if ( is_multisite() ) {
$this->do_multisite_upgrades();
}
$this->do_site_upgrades();
}
/**
* Perform upgrades for the current site
*/
private function do_site_upgrades() {
$table_name = $this->db->table;
$prev_version = get_option( 'code_snippets_version' );
// Do nothing if the plugin has not just been updated or installed.
if ( ! version_compare( $prev_version, $this->current_version, '<' ) ) {
return;
}
// Update the plugin version stored in the database.
$updated = update_option( 'code_snippets_version', $this->current_version );
if ( ! $updated ) {
return; // Bail if the data was not successfully saved to prevent this process from repeating.
}
$this->db->create_table( $table_name );
// Remove outdated user meta.
if ( version_compare( $prev_version, '2.14.1', '<' ) ) {
global $wpdb;
$prefix = $wpdb->get_blog_prefix();
$menu_slug = code_snippets()->get_menu_slug();
$option_name = "{$prefix}managetoplevel_page_{$menu_slug}columnshidden";
// Loop through each user ID and remove all matching user meta.
foreach ( get_users( array( 'fields' => 'ID' ) ) as $user_id ) {
delete_metadata( 'user', $user_id, $option_name, '', true );
}
}
// Update the scope column of the database.
if ( version_compare( $prev_version, '2.10.0', '<' ) ) {
$this->migrate_scope_data( $table_name );
}
// Custom capabilities were removed after version 2.9.5.
if ( version_compare( $prev_version, '2.9.5', '<=' ) ) {
$role = get_role( apply_filters( 'code_snippets_role', 'administrator' ) );
$role->remove_cap( apply_filters( 'code_snippets_cap', 'manage_snippets' ) );
}
if ( false === $prev_version ) {
add_action( 'init', [ $this, 'create_sample_content' ] );
}
clean_snippets_cache( $table_name );
Welcome_API::clear_cache();
}
/**
* Create example snippets.
*
* As this uses translation functions, this should not be called earlier than 'init'.
*
* @return void
*/
public function create_sample_content() {
if ( apply_filters( 'code_snippets/create_sample_content', true ) ) {
$sample_snippets = $this->get_sample_content();
foreach ( $sample_snippets as $sample_snippet ) {
save_snippet( $sample_snippet );
}
}
}
/**
* Perform multisite-only upgrades
*/
private function do_multisite_upgrades() {
$table_name = $this->db->ms_table;
$prev_version = get_site_option( 'code_snippets_version' );
// Do nothing if the plugin has not been updated or installed.
if ( ! version_compare( $prev_version, $this->current_version, '<' ) ) {
return;
}
// Always attempt to create or upgrade the database tables.
$this->db->create_table( $table_name );
// Update the plugin version stored in the database.
update_site_option( 'code_snippets_version', $this->current_version );
// Update the scope column of the database.
if ( version_compare( $prev_version, '2.10.0', '<' ) ) {
$this->migrate_scope_data( $table_name );
}
// Custom capabilities were removed after version 2.9.5.
if ( version_compare( $prev_version, '2.9.5', '<=' ) ) {
$network_cap = apply_filters( 'code_snippets_network_cap', 'manage_network_snippets' );
foreach ( get_super_admins() as $admin ) {
$user = new WP_User( 0, $admin );
$user->remove_cap( $network_cap );
}
}
clean_snippets_cache( $table_name );
}
/**
* Migrate data from the old integer method of storing scopes to the new string method
*
* @param string $table_name Name of database table.
*/
private function migrate_scope_data( string $table_name ) {
global $wpdb;
$scopes = array(
0 => 'global',
1 => 'admin',
2 => 'front-end',
);
foreach ( $scopes as $scope_number => $scope_name ) {
// phpcs:disable WordPress.DB.DirectDatabaseQuery.NoCaching, will flush at end of process.
$wpdb->query(
$wpdb->prepare(
"UPDATE $table_name SET scope = %s WHERE scope = %d",
$scope_name,
$scope_number
)
);
}
}
/**
* Build a collection of sample snippets for new users to try out.
*
* @return array<string, Snippet> List of Snippet objects.
*/
private function get_sample_content(): array {
$tag = "\n\n" . esc_html__( 'This is a sample snippet. Feel free to use it, edit it, or remove it.', 'code-snippets' );
$snippets_data = array(
array(
'name' => esc_html__( 'Make upload filenames lowercase', 'code-snippets' ),
'code' => "add_filter( 'sanitize_file_name', 'mb_strtolower' );",
'desc' => esc_html__( 'Makes sure that image and file uploads have lowercase filenames.', 'code-snippets' ) . $tag,
'tags' => array( 'sample', 'media' ),
),
array(
'name' => esc_html__( 'Disable admin bar', 'code-snippets' ),
'code' => "add_action( 'wp', function () {\n\tif ( ! current_user_can( 'manage_options' ) ) {\n\t\tshow_admin_bar( false );\n\t}\n} );",
'desc' => esc_html__( 'Turns off the WordPress admin bar for everyone except administrators.', 'code-snippets' ) . $tag,
'tags' => array( 'sample', 'admin-bar' ),
'scope' => 'front-end',
),
array(
'name' => esc_html__( 'Allow smilies', 'code-snippets' ),
'code' => "add_filter( 'widget_text', 'convert_smilies' );\nadd_filter( 'the_title', 'convert_smilies' );\nadd_filter( 'wp_title', 'convert_smilies' );\nadd_filter( 'get_bloginfo', 'convert_smilies' );",
'desc' => esc_html__( 'Allows smiley conversion in obscure places.', 'code-snippets' ) . $tag,
'tags' => array( 'sample' ),
),
array(
'name' => esc_html__( 'Current year', 'code-snippets' ),
'code' => "<?php echo date( 'Y' ); ?>",
'desc' => esc_html__( 'Shortcode for inserting the current year into a post or page..', 'code-snippets' ) . $tag,
'tags' => array( 'sample', 'dates' ),
'scope' => 'content',
),
);
return array_map(
function ( $snippet_data ) {
return new Snippet( $snippet_data );
},
$snippets_data
);
}
}