File Manager

X7ROOT File Manager

Current Path: /home/iptvzxij/public_html/wp-content/plugins/wp-statistics/includes

home / iptvzxij / public_html / wp-content / plugins / wp-statistics / includes /

📁 ..
📁 admin
📁 api
📄 class-wp-statistics-admin-bar.php(9.23 KB)
📄 class-wp-statistics-country.php(4.1 KB)
📄 class-wp-statistics-db.php(7.73 KB)
📄 class-wp-statistics-exclusion.php(15.38 KB)
📄 class-wp-statistics-frontend.php(5.5 KB)
📄 class-wp-statistics-geoip.php(2.41 KB)
📄 class-wp-statistics-helper.php(81.85 KB)
📄 class-wp-statistics-historical.php(1.49 KB)
📄 class-wp-statistics-hits.php(5.55 KB)
📄 class-wp-statistics-install.php(19.51 KB)
📄 class-wp-statistics-ip.php(14.32 KB)
📄 class-wp-statistics-mail.php(9.67 KB)
📄 class-wp-statistics-menus.php(8.76 KB)
📄 class-wp-statistics-meta-box.php(1.42 KB)
📄 class-wp-statistics-option.php(11.46 KB)
📄 class-wp-statistics-pages.php(21.99 KB)
📄 class-wp-statistics-privacy-erasers.php(1.13 KB)
📄 class-wp-statistics-privacy-exporter.php(1.59 KB)
📄 class-wp-statistics-purge.php(9.14 KB)
📄 class-wp-statistics-referred.php(8.86 KB)
📄 class-wp-statistics-rest-api.php(2.68 KB)
📄 class-wp-statistics-schedule.php(12.56 KB)
📄 class-wp-statistics-search-engine.php(2.71 KB)
📄 class-wp-statistics-shortcode.php(12.71 KB)
📄 class-wp-statistics-timezone.php(12.43 KB)
📄 class-wp-statistics-uninstall.php(3.52 KB)
📄 class-wp-statistics-user-agent.php(1.38 KB)
📄 class-wp-statistics-user-online.php(3.71 KB)
📄 class-wp-statistics-user.php(9.93 KB)
📄 class-wp-statistics-visitor.php(17.29 KB)
📄 class-wp-statistics-widget.php(23.48 KB)
📄 class-wp-statistics.php(14.07 KB)
📁 defines
📄 defines.php(509 B)
📁 libraries
📄 template-functions.php(27.58 KB)

Editing: class-wp-statistics-db.php

<?php

namespace WP_STATISTICS;

use WP_Statistics\Service\Database\DatabaseFactory;

class DB
{
    /**
     * List Of wp-statistics Mysql Table
     *
     * @var array
     */
    public static $db_table = array(
        /**
         * WP Statistics Table
         */
        'visitor',
        'exclusions',
        'pages',
        'historical',
        'visitor_relationships',
        'summary_totals',

/**
         * Data Plus Table
         */
        'events',

/**
         * Advanced Reporting Table
         */
        'ar_outbox',

/**
         * Marketing Tables
         */
        'campaigns',
        'goals'
    );

/**
     * WP Statistics Table name Structure in Database
     *
     * @var string
     */
    public static $tbl_name = '[prefix]statistics_[name]';

/**
     * Get WordPress Table Prefix
     */
    public static function prefix()
    {
        global $wpdb;
        return $wpdb->prefix;
    }

/**
     * Get WordPress Table Collate
     *
     * @return mixed
     */
    public static function charset_collate()
    {
        global $wpdb;
        return $wpdb->get_charset_collate();
    }

/**
     * Get WP Statistics Table name
     *
     * @param $tbl
     * @return mixed
     */
    public static function getTableName($tbl)
    {
        return str_ireplace(array("[prefix]", "[name]"), array(self::prefix(), $tbl), self::$tbl_name);
    }

public static function getTableDesc($tbl)
    {
        $descriptions = [
            /**
             * WP Statistics Table
             */
            'visitor'               => __('This table keeps a record of individual visitors to your website. Each row represents a unique visitor\'s information and their activities.', 'wp-statistics'),
            'exclusions'            => __('This table logs views that have been excluded based on certain criteria, like bots or specific IP addresses. It helps keep your statistics clean from non-human or unwanted traffic.', 'wp-statistics'),
            'pages'                 => __('This table logs the number of views each page on your website receives. Each row represents the data for a specific page.', 'wp-statistics'),
            'historical'            => __('This table stores historical data about views and visitors over time. It\'s useful for tracking trends and patterns in your website\'s traffic.', 'wp-statistics'),
            'visitor_relationships' => __('This table captures the relationships between visitors and the content they interact with, helping you understand user behavior and preferences.', 'wp-statistics'),
            'summary_totals'        => __('This table stores the daily aggregated statistics of your website. Each row represents the summarized data for a specific date.', 'wp-statistics'),

/**
             * Data Plus Table
             */
            'events'                => __('<b>(Add-on Data Plus)</b> This table stores the events that are triggered on your website. It helps you track user interactions and behavior.', 'wp-statistics'),

/**
             * Advanced Reporting Table
             */
            'ar_outbox'             => __('<b>(Add-on Advanced Reporting)</b> This table stores the messages that are sent from this add-on.', 'wp-statistics'),
        ];

$tbl_name = str_replace(self::prefix() . 'statistics_', '', $tbl);

return (!empty($descriptions[$tbl_name]) ? $descriptions[$tbl_name] : '');
    }

/**
     * Check Exist Table in Database
     *
     * @param $tbl_name
     * @return bool
     */
    public static function ExistTable($tbl_name)
    {
        global $wpdb;
        return ($wpdb->get_var("SHOW TABLES LIKE '$tbl_name'") == $tbl_name);
    }

/**
     * Table List WP Statistics
     *
     * @param string $export
     * @param array $except
     * @return array|null|string
     */
    public static function table($export = 'all', $except = array())
    {

# Create Empty Object
        $list = array();

# Convert except String to array
        if (is_string($except)) {
            $except = array($except);
        }

# Check Except List
        $mysql_list_table = array_diff(self::$db_table, $except);

# Get List
        foreach ($mysql_list_table as $tbl) {

# WP Statistics table name
            $table_name = self::getTableName($tbl);

if ($export == "all") {
                $inspect = DatabaseFactory::table('inspect')
                    ->setName($tbl)
                    ->execute();

if ($inspect->getResult()) {
                    $list[$tbl] = $table_name;
                }
            } else {
                $list[$tbl] = $table_name;
            }
        }

# Export Data
        return ($export == 'all' ? $list : (array_key_exists($export, $list) ? $list[$export] : null));
    }

/**
     * Delete All record From Table
     *
     * @param bool $table_name
     * @return string
     */
    public static function EmptyTable($table_name = false)
    {
        global $wpdb;

if ($table_name) {
            // TRUNCATE TABLE
            $result = $wpdb->query('TRUNCATE TABLE ' . $table_name);

// Check Result
            if ($result) {

// add action
                do_action('wp_statistics_truncate_table', str_ireplace(self::prefix() . 'statistics_', "", $table_name));

// Return
                return sprintf(__('Data from the %s Table Successfully Deleted.', 'wp-statistics'), '<code>' . $table_name . '</code>');
            }
        }

return sprintf(__('Error: %s Table Not Cleared!', 'wp-statistics'), $table_name);
    }

/**
     * Modify For IGNORE insert Query
     *
     * @hook add_filter('query', function_name, 10);
     * @param $query
     * @return string
     */
    public static function insert_ignore($query)
    {
        $count = 0;
        $query = preg_replace('/^(INSERT INTO)/i', 'INSERT IGNORE INTO', $query, 1, $count);
        return $query;
    }

/**
     * Get Number of Table Rows
     */
    public static function getTableRows()
    {
        global $wpdb;
        $result = array();
        foreach (self::table('all') as $tbl_key => $tbl_name) {
            $result[$tbl_name] = [
                'rows' => $wpdb->get_var("SELECT COUNT(*) FROM `$tbl_name`"),
                'desc' => self::getTableDesc($tbl_name),
            ];
        }

return $result;
    }

/**
     * Get Table information
     *
     * @param $table_name
     * @return mixed
     */
    public static function getTableInformation($table_name)
    {
        global $wpdb;
        return $wpdb->get_row("show table status like '$table_name';", ARRAY_A);
    }

/**
     * Optimize MySQL Query
     *
     * @param $table_name
     */
    public static function optimizeTable($table_name)
    {
        global $wpdb;
        $wpdb->query("OPTIMIZE TABLE `{$table_name}`");
    }

/**
     * Repair MySQL Table
     *
     * @param $table_name
     */
    public static function repairTable($table_name)
    {
        global $wpdb;
        $wpdb->query("REPAIR TABLE `{$table_name}`");
    }

/**
     * @return array|object|void|null
     */
    public static function getColumnType($tableName, $column)
    {
        global $wpdb;

return $wpdb->get_row(
            $wpdb->prepare('SHOW COLUMNS FROM `' . self::table($tableName) . '` LIKE %s', $column)
        );
    }

/**
     * @param $tableName
     * @param $column
     * @param $type
     * @return bool
     */
    public static function isColumnType($tableName, $column, $type)
    {
        $column = self::getColumnType($tableName, $column);

if (isset($column->Type) and strtolower($column->Type) == $type) {
            return true;
        }

return false;
    }
}

X7ROOT File Manager

Editing: class-wp-statistics-db.php

Upload File

Create Folder