*/ class WPP_Activator { /** * Fired when the plugin is activated. * * @since 1.0.0 * @param bool $network_wide True if WPMU superadmin uses "Network Activate" action, false if WPMU is disabled or plugin is activated on an individual blog. */ public static function activate( $network_wide ) { global $wpdb; if ( function_exists( 'is_multisite' ) && is_multisite() ) { // run activation for each blog in the network if ( $network_wide ) { $original_blog_id = get_current_blog_id(); $blogs_ids = $wpdb->get_col( "SELECT blog_id FROM {$wpdb->blogs}" ); foreach( $blogs_ids as $blog_id ) { switch_to_blog( $blog_id ); self::plugin_activate(); } // switch back to current blog switch_to_blog( $original_blog_id ); return; } } self::plugin_activate(); } // end activate /** * When a new MU site is added, generate its WPP DB tables. * * @since 4.0.0 */ public static function track_new_site() { self::plugin_activate(); } // end track_new_site /** * On plugin activation, checks that the WPP database tables are present. * * @since 2.4.0 * @global object wpdb */ private static function plugin_activate() { // Get WPP version $wpp_ver = get_option( 'wpp_ver' ); if ( !$wpp_ver || version_compare( $wpp_ver, WPP_VER, '<' ) ) { global $wpdb; $prefix = $wpdb->prefix . "popularposts"; self::do_db_tables( $prefix ); } } // end plugin_activate /** * Creates/updates the WPP database tables. * * @since 2.4.0 * @global object wpdb */ private static function do_db_tables( $prefix ) { global $wpdb; $charset_collate = ""; if ( !empty( $wpdb->charset ) ) $charset_collate = "DEFAULT CHARACTER SET {$wpdb->charset} "; if ( !empty( $wpdb->collate ) ) $charset_collate .= "COLLATE {$wpdb->collate}"; $sql = " CREATE TABLE {$prefix}data ( postid bigint(20) NOT NULL, day datetime NOT NULL, last_viewed datetime NOT NULL, pageviews bigint(20) DEFAULT 1, PRIMARY KEY (postid) ) {$charset_collate} ENGINE=InnoDB; CREATE TABLE {$prefix}summary ( ID bigint(20) NOT NULL AUTO_INCREMENT, postid bigint(20) NOT NULL, pageviews bigint(20) NOT NULL DEFAULT 1, view_date date NOT NULL, view_datetime datetime NOT NULL, PRIMARY KEY (ID), KEY postid (postid), KEY view_date (view_date), KEY view_datetime (view_datetime) ) {$charset_collate} ENGINE=InnoDB;"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); dbDelta( $sql ); } // end do_db_tables } // end WPP_Activator class