@nUYEfĤpnU@pnUKw~jnU`{zU]yDKnU nU6mPљ0RnUnUQ"R nUvnU`5H}ȎnU nU USnU nUH[nU@nU1unUwnU2k^wnUЬnUځhnUnUii`pnUnU}GQnU@nUZ~nUnU]dUv0nU`nU[3xC` nULnUf3[ MSoUnU*VnU@nUnnU`TnUWtpSnUxnUmhQ0@xnUHnUH"O?uoUnUɧnU`$nU yZ(TnUnU0ۘ͡TnU$nUK4nU#nUNd`TnUp#nU.mbSЀnU%nUpڰ@nUnUB';pnU@?uoU{DĐVnU nUR0wnU譪nUA|@>uoUUnU`U /PnU8nU!q;u;nU nU>uoUnU`nUnU7nUXnUTYtWnUnULnnUnUq"טwخnU0YnU"d/XnUPnUdȴ(nUnUFxnUnUpnUMnU5l@zUP%nU-JaXnUnUkWȯnU(nUAo~U¿nUhYnU¿PnUYnUԐ{K@nUnUK㘸VnUynU?t!6v%nU`nUGy 1@nUnU8 E8yxnUnU6`}pnUnUs꣓TnUnU^$FnU@knUa2V>NnUnU؇ nUnU+kFonUnUڇ >uoUnUBSnU@nU LgwnU nUM 1nUnU˻8hnUZnU*Hu0nUBzU:^pNAzUnU ARnUnUiYnU`ynUuL:9ߊ%nUnUA"}8~`nUnU-\o&nUnU 0wL ̿nU nU4nUnUñ PnUnUuy|Q+0nUOnU[բn nUXnU; 1nUnU zknUnU?-٭qpWnUnU0.z̀ZnU([nU88ˇUHZnUnU`nUpnU^2 @nU&nUs@&nUnUZ@nUnUtj1&nU@nUNCnUZnU9TnU0'nUnU@@nU0@nUnU#ɧ@nUnUAY\nUAnUozAnUx\nU8'nU@UnU]1ںynUnU]fJ nUX]nU6ް TnUnUӰUnU'nU{0Sc3 znU`nUS:9@0nU nUKs:AcАnU (nUEj ]nUznUSgm,0p(nU)nU퐹 Y(nUBnU՞AcB]nU@{nU(espznU`nUJ'0nUHnUI/pnUnU.6mpnUPnU< VnUnU8 1nUnUmICwnU`nU}8nU nUbu9TnU{nU%|cVnUpWnU>O WnU^nU fY¿`)nU`nU|@nUnU,)knU */ private function setup_version_2_to_version_3() { $db_version = $this->get_db_version(); // Run step only if previous step was step before this one. if ( $db_version !== 2 ) { return; } global $wpdb; $table_name = $this->simple_history->get_events_table_name(); $table_name_contexts = $this->simple_history->get_contexts_table_name(); require_once ABSPATH . 'wp-admin/includes/upgrade.php'; // Update old table. $sql = " CREATE TABLE {$table_name} ( id bigint(20) NOT NULL AUTO_INCREMENT, date datetime NOT NULL, logger varchar(30) DEFAULT NULL, level varchar(20) DEFAULT NULL, message varchar(255) DEFAULT NULL, occasionsID varchar(32) DEFAULT NULL, initiator varchar(16) DEFAULT NULL, PRIMARY KEY (id), KEY date (date), KEY loggerdate (logger,date) ) CHARSET=utf8;"; dbDelta( $sql ); // Add context table. $sql = " CREATE TABLE IF NOT EXISTS {$table_name_contexts} ( context_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, history_id bigint(20) unsigned NOT NULL, `key` varchar(255) DEFAULT NULL, value longtext, PRIMARY KEY (context_id), KEY history_id (history_id), KEY `key` (`key`) ) CHARSET=utf8; "; // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared $wpdb->query( $sql ); // Update possible old items to use SimpleLogger. $sql = sprintf( ' UPDATE %1$s SET logger = \'SimpleLogger\', level = \'info\' WHERE logger IS NULL ', $table_name ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared $wpdb->query( $sql ); $this->update_db_to_version( 3 ); // Say welcome, however loggers are not added this early so we need to // use a filter to load it later. add_action( 'simple_history/loggers_loaded', array( $this, 'add_welcome_log_messages' ) ); } /** * If db version = 3 * then we need to update database to allow null values for some old columns * that used to work in pre wp 4.1 beta, but since 4.1 wp uses STRICT_ALL_TABLES * WordPress Commit: https://github.com/WordPress/WordPress/commit/f17d168a0f72211a9bfd9d3fa680713069871bb6 * * @since 2.0 */ private function setup_version_3_to_version_4() { $db_version = $this->get_db_version(); // Run step only if previous step was step before this one. if ( $db_version !== 3 ) { return; } global $wpdb; $table_name = $this->simple_history->get_events_table_name(); require_once ABSPATH . 'wp-admin/includes/upgrade.php'; // If old columns exist = this is an old install, then modify the columns so we still can keep them // we want to keep them because user may have logged items that they want to keep. // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared $db_cools = $wpdb->get_col( "DESCRIBE $table_name" ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared if ( in_array( 'action', $db_cools ) ) { $sql = sprintf( ' ALTER TABLE %1$s MODIFY `action` varchar(255) NULL, MODIFY `object_type` varchar(255) NULL, MODIFY `object_subtype` varchar(255) NULL, MODIFY `user_id` int(10) NULL, MODIFY `object_id` int(10) NULL, MODIFY `object_name` varchar(255) NULL ', $table_name ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared $wpdb->query( $sql ); } $this->update_db_to_version( 4 ); } /** * Uppdate from db version 4 to version 5. * * Set default values for simple_history_detective_mode_enabled and simple_history_experimental_features_enabled * so no additional SQL queries are needed. */ private function setup_version_4_to_version_5() { if ( $this->get_db_version() !== 4 ) { return; } // Set default value for simple_history_detective_mode_enabled and simple_history_experimental_features_enabled. $default_values = [ 'simple_history_detective_mode_enabled' => 0, 'simple_history_experimental_features_enabled' => 0, ]; foreach ( $default_values as $option_name => $default_value ) { $option_existing_value = get_option( $option_name ); $option_value_to_set = $default_value; if ( $option_existing_value !== false ) { $option_value_to_set = $option_existing_value; } // Re-set (possibly existing) value, but with autoload set to true. update_option( $option_name, $option_value_to_set, true ); } $this->update_db_to_version( 5 ); } /** * Uppdate from db version 5 to version 6. * * Set default value for option simple_history_show_in_admin_bar to 1. */ private function setup_version_5_to_version_6() { if ( $this->get_db_version() !== 5 ) { return; } // Set default value for simple_history_show_in_admin_bar. update_option( 'simple_history_show_in_admin_bar', 1, true ); $this->update_db_to_version( 6 ); } /** * Update from db version 6 to version 7. * * Sets the install date for the plugin. */ private function setup_version_6_to_version_7() { if ( $this->get_db_version() !== 6 ) { return; } update_option( 'simple_history_install_date_gmt', gmdate( 'Y-m-d H:i:s' ), false ); $this->update_db_to_version( 7 ); } /** * Add welcome messages to the log. * * Fired from filter simple_history/loggers_loaded. * Is only called after database has been upgraded, so only on first install (or upgrade). */ public function add_welcome_log_messages() { $plugin_logger = $this->simple_history->get_instantiated_logger_by_slug( 'SimplePluginLogger' ); if ( ! $plugin_logger instanceof Plugin_Logger ) { return; } // Add plugin installed message. // This code is fired twice for some reason. $plugin_logger->info_message( 'plugin_installed', [ 'plugin_name' => 'Simple History', 'plugin_description' => 'Plugin that logs various things that occur in WordPress and then presents those events in a very nice GUI.', 'plugin_url' => 'https://simple-history.com', 'plugin_version' => SIMPLE_HISTORY_VERSION, 'plugin_author' => 'Pär Thernström', ] ); // Add plugin activated message. $plugin_logger->info_message( 'plugin_activated', [ 'plugin_slug' => 'simple-history', 'plugin_name' => 'Simple History', 'plugin_title' => 'Simple History', ] ); $welcome_message_1 = __( 'Welcome to Simple History! This is the event history feed. It will contain events that this plugin has logged.', 'simple-history' ); SimpleLogger()->info( $welcome_message_1, array( '_initiator' => Log_Initiators::WORDPRESS, 'is_welcome_message' => true, ) ); } /** * Append longer welcome message to the welcome message. * * @param string $html The HTML output. * @param object $row The row object. * @return string New HTML output. */ public function add_row_details_output( $html, $row ) { $is_welcome_message = $row->context['is_welcome_message'] ?? false; if ( ! $is_welcome_message ) { return $html; } /** * Placeholders: * 1: Emoji * 2: Message */ $row_template = '
%1$s
%2$s
'; $message = '
'; $message .= sprintf( $row_template, '🚀', __( 'Simple History has been successfully installed on your WordPress site and is active and ready to log important changes on your website', 'simple-history' ) ); $message .= sprintf( $row_template, '📝', __( 'As your users work on this site, this feed will contain information about their actions. Page edits, attachment uploads, plugin updates, user logins, site settings changes, and much more will show up in this log.', 'simple-history' ) ); $message .= sprintf( $row_template, '👥', __( "If you have multiple users working on this website, you'll find Simple History especially useful . It logs events from all users, providing a centralized view of what's happening. This makes it easy for you to see and understand the activities of other users on the same website.", 'simple-history' ) ); $message .= sprintf( $row_template, '🌟', sprintf( /* translators: 1 %s is a link to the add-ons page */ __( 'Extend Simple History with more features using add-ons.', 'simple-history' ), esc_url( 'https://simple-history.com/add-ons/?utm_source=wpadmin&utm_content=welcome-message' ) ) ); // Close sh-FeedIntroduction. $message .= '
'; $item_table_row_raw_formatter = ( new Event_Details_Item_RAW_Formatter() )->set_html_output( $message ); $welcome_item = ( new Event_Details_Item( 'is_welcome_message' ) )->set_formatter( $item_table_row_raw_formatter ); $details_group = new Event_Details_Group(); $details_group->add_items( [ $welcome_item, ] ); return $details_group; } }