| Server IP : 38.190.208.107 / Your IP : 216.73.217.46 Web Server : nginx/1.28.1 System : Linux ht2026040333114 6.1.0-10-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.37-1 (2023-07-03) x86_64 User : root ( 0) PHP Version : 8.2.28 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv,eval,assert,passthru,system,exec,shell_exec,popen,proc_open MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /www/wwwroot/wp.3/wp-content/plugins/wp-statistics/includes/ |
Upload File : |
<?php
namespace WP_STATISTICS;
class Historical
{
/**
* List Of Historical Category
*
* @var array
*/
public static $historical_cat = array(
'visitors',
'visits',
'uri'
);
/**
* Get historical data
*
* @param $type
* @param string $id
*
* @return int|null|string
*/
public static function get($type, $id = '')
{
global $wpdb;
# Default Count
$count = 0;
# Create SQL
switch ($type) {
case 'uri':
$sql = "SELECT `value` FROM `" . DB::table('historical') . "` WHERE `category` = 'uri'";
break;
case 'page':
$sql = $wpdb->prepare("SELECT `value` FROM `" . DB::table('historical') . "` WHERE `category` = 'uri' AND `page_id` = %d", $id);
break;
case 'visitors':
case 'visits':
default:
$sql = $wpdb->prepare("SELECT `value` FROM `" . DB::table('historical') . "` WHERE `category` = %s", $type);
break;
}
# Get Count Dara
$result = $wpdb->get_var($sql); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
# Return
return $result > $count ? $result : $count;
}
/**
* Check Is Empty Historical Table
*/
public static function isEmpty()
{
global $wpdb;
return ($wpdb->get_var("SELECT COUNT(*) FROM " . DB::table('historical')) < 1);
}
}