Newer
Older
WebMCR / upload / modules / admin / logs.class.php
@Qexy Qexy on 2 Mar 2016 3 KB Update to Beta 1.3
<?php

if(!defined("MCR")){ exit("Hacking Attempt!"); }

class submodule{
	private $core, $db, $config, $user, $lng;

	public function __construct($core){
		$this->core = $core;
		$this->db	= $core->db;
		$this->config = $core->config;
		$this->user	= $core->user;
		$this->lng	= $core->lng_m;

		if(!$this->core->is_access('sys_adm_logs')){ $this->core->notify($this->core->lng['403'], $this->core->lng['e_403']); }

		$bc = array(
			$this->lng['mod_name'] => BASE_URL."?mode=admin",
			$this->lng['logs'] => BASE_URL."?mode=admin&do=logs"
		);

		$this->core->bc = $this->core->gen_bc($bc);
	}

	private function logs_array(){

		$start		= $this->core->pagination($this->config->pagin['adm_logs'], 0, 0); // Set start pagination
		$end		= $this->config->pagin['adm_logs']; // Set end pagination

		$where		= "";
		$sort		= "`l`.id";
		$sortby		= "DESC";

		if(isset($_GET['search']) && !empty($_GET['search'])){
			$search = $this->db->safesql(urldecode($_GET['search']));
			$where = "WHERE `l`.`message` LIKE '%$search%'";
		}

		if(isset($_GET['sort']) && !empty($_GET['sort'])){
			$expl = explode(' ', $_GET['sort']);

			$sortby = ($expl[0]=='asc') ? "ASC" : "DESC";

			switch(@$expl[1]){
				case 'user': $sort = "`u`.login"; break;
				case 'msg': $sort = "`l`.`message`"; break;
				case 'date': $sort = "`l`.`date`"; break;
			}
		}

		$query = $this->db->query("SELECT `l`.id, `l`.uid, `l`.`message`, `l`.`date`, `u`.login, `u`.`color`, `g`.`color` AS `gcolor`
									FROM `mcr_logs` AS `l`
									LEFT JOIN `mcr_users` AS `u`
										ON `u`.id=`l`.uid
									LEFT JOIN `mcr_groups` AS `g`
										ON `g`.id=`u`.gid
									$where
									ORDER BY $sort $sortby
									LIMIT $start, $end");

		if(!$query || $this->db->num_rows($query)<=0){ return $this->core->sp(MCR_THEME_MOD."admin/logs/log-none.html"); }

		ob_start();

		while($ar = $this->db->fetch_assoc($query)){

			$color = (empty($ar['color'])) ? $this->db->HSC($ar['gcolor']) : $this->db->HSC($ar['color']);

			$login = (!is_null($ar['login'])) ? $this->db->HSC($ar['login']) : 'Пользователь удален';

			$page_data = array(
				"ID" => intval($ar['id']),
				"UID" => intval($ar['uid']),
				"MESSAGE" => $this->db->HSC($ar['message']),
				"DATE" => date("d.m.Y в H:i:s", $ar['date']),
				"LOGIN" => $this->core->colorize($login, $color),
			);
		
			echo $this->core->sp(MCR_THEME_MOD."admin/logs/log-id.html", $page_data);
		}

		return ob_get_clean();
	}

	private function logs_list(){

		$sql = "SELECT COUNT(*) FROM `mcr_logs`";
		$page = "?mode=admin&do=logs";

		if(isset($_GET['search']) && !empty($_GET['search'])){
			$search = $this->db->safesql(urldecode($_GET['search']));
			$sql = "SELECT COUNT(*) FROM `mcr_logs` WHERE `message` LIKE '%$search%'";
			$search = $this->db->HSC(urldecode($_GET['search']));
			$page = "?mode=admin&do=logs&search=$search";
		}

		if(isset($_GET['sort']) && !empty($_GET['sort'])){
			$page .= '&sort='.$this->db->HSC(urlencode($_GET['sort']));
		}

		$query = $this->db->query($sql);

		$ar = @$this->db->fetch_array($query);

		$data = array(
			"PAGINATION" => $this->core->pagination($this->config->pagin['adm_logs'], $page.'&pid=', $ar[0]),
			"LOGS" => $this->logs_array()
		);

		return $this->core->sp(MCR_THEME_MOD."admin/logs/log-list.html", $data);
	}

	public function content(){

		return $this->logs_list();
	}
}

?>