| Server IP : 39.106.62.82 / Your IP : 216.73.216.110 Web Server : nginx/1.14.1 System : Linux iz2ze1m0zmp2dk5c3j5ap5z 3.10.0-1127.19.1.el7.x86_64 #1 SMP Tue Aug 25 17:23:54 UTC 2020 x86_64 User : www ( 1000) PHP Version : 7.4.33 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 MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /webdata/gohomesh.com/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);
# 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);
}
}