ikan Uploader :
Directory : /www/wwwroot/jdih.dprd.mukomukokab.go.id/ildis_v4/frontend/components/
Upload File : |
| Current File : /www/wwwroot/jdih.dprd.mukomukokab.go.id/ildis_v4/frontend/components/UserCounter.php |
<?php
/**
* UserCounter for Yii 2.0
*
* This component is complete reworked port of pCounter, originally written by
* Andreas "Pr0g" Droesch. It uses MySQL for counting the number of visitors.
* Following information is provided by UserCounter.
*
* - users online
* - total users of today
* - total users of yesterday
* - total users overall
* - maximum users at a day
* - date for the maximum
*
* No cookies or sessions are used. The count is only based on the IP address
* of users, but this information is stored as md5-hash in database.
*
*
* USAGE
*
* For installation, have a look at the extension page on yiiframework.com or
* on GitHub. There you can find all information about this component:
* http://www.yiiframework.com/extension/yii-usercounter/
* https://github.com/armin-pfaeffle/yii-usercounter/
*
* Provides methods:
* - Yii::$app->userCounter->getOnline()
* - Yii::$app->userCounter->getToday()
* - Yii::$app->userCounter->getYesterday()
* - Yii::$app->userCounter->getTotal()
* - Yii::$app->userCounter->getMaximal()
* - date('d.m.Y', Yii::$app->userCounter->getMaximalTime())
*
*
* LICENSE
*
* UserCounter is freeware and you are allowed to distribute it, but only in case
* it is not commercial and the script does not get modified.
*
*
* @author Armin Pfäffle <mail@armin-pfaeffle.de>
* @author Andreas "Pr0g" Droesch
* @copyright Copyright (c) 2015, Armin Pfäffle <mail@armin-pfaeffle.de>
* @link https://github.com/armin-pfaeffle/yii-usercounter/
* @link http://www.yiiframework.com/extension/yii-usercounter/
* @link http://andreas.droesch.de
* @version 1.3.0
*/
namespace app\components;
use Yii;
use yii\base\Component;
use yii\base\InvalidConfigException;
class UserCounter extends Component
{
public $autoInstallTables = true;
public $tableUsers = 'pcounter_users';
public $tableSave = 'pcounter_save';
public $onlineTime = 10;
protected $alreadyUpdated = false;
protected $dayTime;
protected $total = 0;
protected $online = 0;
protected $today = 0;
protected $yesterday = 0;
protected $maxCount = 0;
protected $maxDate;
/**
*
*/
public function init()
{
$this->checkTables();
$this->refresh();
}
/**
* Checks if necessary tables exist and if not, create them.
*/
protected function checkTables()
{
if (Yii::$app->db->schema->getTableSchema($this->tableUsers, true) === null) {
if ($this->autoInstallTables) {
Yii::$app->db->createCommand()
->createTable(
$this->tableUsers,
array(
'id' => 'int(11) NOT NULL PRIMARY KEY',
'user_ip' => 'VARCHAR(255) NOT NULL',
'user_time' => 'int(10) unsigned NOT NULL',
'creation_date' => ' datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0)'
))
->execute();
}
}
if (Yii::$app->db->schema->getTableSchema($this->tableSave, true) === null) {
if ($this->autoInstallTables) {
Yii::$app->db->createCommand()
->createTable(
$this->tableSave,
array(
'save_name' => 'VARCHAR(10) NOT NULL PRIMARY KEY',
'save_value' => 'int(10) unsigned NOT NULL',
))
->execute();
Yii::$app->db->createCommand()
->batchInsert(
$this->tableSave,
array('save_name', 'save_value'),
array(
array('day_time', 0),
array('counter', 0),
array('yesterday', 0),
array('max_count', 0),
array('max_time', 0),
))
->execute();
}
}
}
/**
* Refreshes the counters and updates database. The updated values are stored in
* class variables.
*/
public function refresh($force = false)
{
if ($this->alreadyUpdated && !$force) {
return;
}
$this->getCurrentData();
$today = GregorianToJD(date('m'), date('j'), date('Y'));
$daysSinceLastUpdate = $today - $this->dayTime;
if ($this->isNewDay()) {
$lastUpdateTotalUsers = $this->getLastLoggedUsers();
$this->yesterday = $this->getYesterdayQuery();
//$this->yesterday = ($daysSinceLastUpdate == 1 ? $lastUpdateTotalUsers : 0);
$this->update($this->tableSave, array('save_value' => $this->yesterday), 'save_name = "yesterday"');
if ($this->isNewMaximum($lastUpdateTotalUsers)) {
$this->maxCount = $lastUpdateTotalUsers;
$this->maxDate = mktime(12, 0, 0, date('n'), date('j'), date('Y')) - 86400;
$this->update($this->tableSave, array('save_value' => $this->maxCount), 'save_name = "max_count"');
$this->update($this->tableSave, array('save_value' => $this->maxDate), 'save_name = "max_time"');
}
$this->update($this->tableSave, array('save_value' => $this->total + $lastUpdateTotalUsers), 'save_name = "counter"');
$this->update($this->tableSave, array('save_value' => $today), 'save_name = "day_time"');
//$this->truncate($this->tableUsers);
$this->total += $lastUpdateTotalUsers;
}
$this->insertOrUpdateIpAddress();
$this->today = $this->getLastLoggedUsers();
$this->online = $this->getLastLoggedUsers(true);
$this->total += $this->today;
if ($this->isNewMaximum($this->today)) {
$this->maxCount = $this->today;
$this->maxDate = time();
}
$this->alreadyUpdated = true;
}
/**
* Loads current values from databse.
*/
protected function getCurrentData()
{
$rows = (new \yii\db\Query())
->select(array('save_name', 'save_value'))
->from($this->tableSave)
->all();
$data = array();
foreach ($rows as $row) {
$data[ $row['save_name'] ] = $row['save_value'];
}
$this->dayTime = $data['day_time'];
$this->total = $data['counter'];
$this->yesterday = $data['yesterday'];
$this->maxCount = $data['max_count'];
$this->maxDate = $data['max_time'];
}
/**
* Detects if current day is a new day compared to {@see dayTime}.
*/
protected function isNewDay()
{
$today = GregorianToJD(date('m'), date('j'), date('Y'));
return ($today != $this->dayTime);
}
protected function getYesterdayQuery()
{
$yesterday = date('Y-m-d', strtotime("-1 days"));
$count = (new \yii\db\Query())
->select(array('count(user_ip) AS user_count'))
->from($this->tableUsers)
->where(['like','creation_date',$yesterday]);
return $count->scalar();
}
/**
* Returns the number of users which are online at the moment.
*/
protected function getLastLoggedUsers($onlyOnline = false)
{
$count = (new \yii\db\Query())
->select(array('count(user_ip) AS user_count'))
->from($this->tableUsers);
if ($onlyOnline) {
$count->where('user_time >= :time', array(':time' => time() - $this->onlineTime * 60));
}
return $count->scalar();
}
/**
*
*/
protected function isNewMaximum($count)
{
return ($count > $this->maxCount);
}
/**
*
*/
protected function insertOrUpdateIpAddress()
{
$ipAddress = isset($_SERVER['HTTP_X_FORWARDED_FOR']) ? $_SERVER['HTTP_X_FORWARDED_FOR'] : $_SERVER['REMOTE_ADDR'];
$hashedIpAddress = md5($ipAddress);
$currentTimestamp = time();
$today = date('Y-m-d')."%";
$sql = 'INSERT INTO ' . $this->tableUsers . ' (user_ip, user_time) select :ipAddress, :time from dual where not exists (SELECT * from '.$this->tableUsers.' where user_ip = :ipAddress and creation_date like :today) ';
Yii::$app->db->createCommand($sql)
->bindParam(':ipAddress', $hashedIpAddress, \PDO::PARAM_STR)
->bindParam(':time', $currentTimestamp, \PDO::PARAM_INT)
->bindParam(':today', $today, \PDO::PARAM_STR)
->execute();
}
/**
* Shortcut function.
*/
protected function update($table, $columns, $conditions='', $params=array())
{
return Yii::$app->db->createCommand()
->update($table, $columns, $conditions, $params)
->execute();
}
/**
* Shortcut function.
*/
protected function insert($table, $columns)
{
return Yii::$app->db->createCommand()
->insert($table, $columns)
->execute();
}
/**
* Shortcut function.
*/
protected function truncate($table)
{
return Yii::$app->db->createCommand()
->truncateTable($table)
->execute();
}
/**
* Total number of users since usage of this plugin.
* @return int
*/
public function getTotal()
{
return $this->total;
}
/**
* Getter for number of users which are online at the moment.
* @return int
*/
public function getOnline()
{
return $this->online;
}
/**
* Getter for number of users which were online today.
* @return int
*/
public function getToday()
{
return $this->today;
}
/**
* Getter for number of users which were online yesterday.
* @return int
*/
public function getYesterday()
{
return $this->yesterday;
}
/**
* Getter for maximal number of users which were online at a day.
* @return int
*/
public function getMaxCount()
{
return $this->maxCount;
}
/**
* Returns date when maximal users were online.
* @return date
*/
public function getMaximalDate()
{
return $this->maxDate;
}
/**
* @deprecated deprecated since version 1.2. Please use getMaxCount() instead.
*/
public function getMaximal()
{
return $this->getMaxCount();
}
/**
* @deprecated deprecated since version 1.2. Please use getMaximalDate() instead.
*/
public function getMaximalTime()
{
return $this->getMaximalDate();
}
}
Kontol Shell Bypass