CHIEFSOFT\ameye
115 lines
2.9 KiB
PHP
115 lines
2.9 KiB
PHP
<?php
|
|
/**
|
|
* Post Views DB
|
|
*
|
|
* @package Powerkit
|
|
* @subpackage Modules/DB
|
|
*/
|
|
|
|
class Powerkit_Post_Views_DB {
|
|
|
|
/**
|
|
* Construct.
|
|
*/
|
|
public function __construct() {
|
|
add_action( 'powerkit_post_views_save_options', array( $this, 'multisite_activation' ) );
|
|
add_action( 'powerkit_plugin_activation', array( $this, 'multisite_activation' ) );
|
|
add_action( 'powerkit_plugin_deactivation', array( $this, 'multisite_deactivation' ) );
|
|
}
|
|
|
|
/**
|
|
* Multisite activation.
|
|
*
|
|
* @global object $wpdb
|
|
* @param bool $networkwide The networkwide.
|
|
*/
|
|
public function multisite_activation( $networkwide ) {
|
|
if ( is_multisite() && $networkwide ) {
|
|
global $wpdb;
|
|
|
|
$activated_blogs = array();
|
|
$current_blog_id = $wpdb->blogid;
|
|
$blogs_ids = $wpdb->get_col( $wpdb->prepare( 'SELECT blog_id FROM ' . $wpdb->blogs, '' ) );
|
|
|
|
foreach ( $blogs_ids as $blog_id ) {
|
|
switch_to_blog( $blog_id );
|
|
$this->activate_single();
|
|
$activated_blogs[] = (int) $blog_id;
|
|
}
|
|
|
|
switch_to_blog( $current_blog_id );
|
|
|
|
update_site_option( 'pk_post_views_activated_blogs', $activated_blogs, array() );
|
|
} else {
|
|
$this->activate_single();
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Single site activation.
|
|
*
|
|
* @global array $wp_roles
|
|
*/
|
|
public function activate_single() {
|
|
global $wpdb;
|
|
|
|
$table_name = $wpdb->prefix . 'pk_post_views';
|
|
|
|
$charset_collate = $wpdb->get_charset_collate();
|
|
|
|
// Required for dbdelta.
|
|
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
|
|
|
|
// Create post views table.
|
|
maybe_create_table( $table_name, 'CREATE TABLE ' . $table_name . ' ( id bigint unsigned NOT NULL, type tinyint(1) unsigned NOT NULL, period varchar(20) NOT NULL, count bigint unsigned NOT NULL, PRIMARY KEY (id)) ' . $charset_collate . ';' );
|
|
}
|
|
|
|
/**
|
|
* Multisite deactivation.
|
|
*
|
|
* @global array $wpdb
|
|
* @param bool $networkwide The networkwide.
|
|
*/
|
|
public function multisite_deactivation( $networkwide ) {
|
|
if ( is_multisite() && $networkwide ) {
|
|
global $wpdb;
|
|
|
|
$current_blog_id = $wpdb->blogid;
|
|
$blogs_ids = $wpdb->get_col( $wpdb->prepare( 'SELECT blog_id FROM ' . $wpdb->blogs, '' ) );
|
|
|
|
if ( ! ( $activated_blogs = get_site_option( 'pk_post_views_activated_blogs', false, false ) ) ) {
|
|
$activated_blogs = array();
|
|
}
|
|
|
|
foreach ( $blogs_ids as $blog_id ) {
|
|
switch_to_blog( $blog_id );
|
|
$this->deactivate_single( true );
|
|
|
|
if ( in_array( (int) $blog_id, $activated_blogs, true ) ) {
|
|
unset( $activated_blogs[ array_search( $blog_id, $activated_blogs ) ] );
|
|
}
|
|
}
|
|
|
|
switch_to_blog( $current_blog_id );
|
|
update_site_option( 'post_views_counter_activated_blogs', $activated_blogs );
|
|
} else {
|
|
$this->deactivate_single();
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Single site deactivation.
|
|
*
|
|
* @param bool $multi The multi.
|
|
*/
|
|
public function deactivate_single( $multi = false ) {
|
|
global $wpdb;
|
|
|
|
// Delete table from database.
|
|
$wpdb->query( 'DROP TABLE IF EXISTS ' . $wpdb->prefix . 'pk_post_views' );
|
|
}
|
|
}
|
|
|
|
|
|
new Powerkit_Post_Views_DB();
|