MR K IS HERE

MRKShell
Server IP : 104.21.73.244 / Your IP : 104.23.243.234
Web Server : nginx/1.14.1
System : Linux comtuc2-s-2vcpu-8gb-160gb-intel-nyc3 4.18.0-348.7.1.el8_5.x86_64 #1 SMP Wed Dec 22 13:25:12 UTC 2021 x86_64
User : nginx ( 991)
PHP Version : 7.2.34
Disable Function : NONE
MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON
Directory : /var/www/comunicacion/produccion/vuelos/application/libraries/
Upload File :
[ HOME SHELL ]
Current File : /var/www/comunicacion/produccion/vuelos/application/libraries/sudaca.php
<?php 

if ( ! defined('BASEPATH')) exit('No direct script access allowed');


class Sudaca {
	
	private $CI;
	
	function __construct() {
		$this->CI = & get_instance();			
	}
	
	public function __get($var){
		return get_instance()->$var;
	}	
	
	function _required($required, $data){
		foreach($required as $field)
			if(!isset($data[$field])) return false;

		return true;
	}
		
	function _default($defaults, $options){
		return array_merge($defaults, $options);
	}

	function getMenu($id_usuario){		
		$consulta_padres = "SELECT  u.id usuario, ug.user_id, ug.group_id, p.menu_id, p.read, p.insert, p.update, p.delete, p.group_id, m.*
		FROM users u
		JOIN users_groups ug 		ON u.id = ug.user_id
		JOIN permisos p 			ON ug.group_id = p.group_id
		JOIN menus m 				ON p.menu_id = m.id
		WHERE u.id = ".$id_usuario." 	AND m.active=1
		AND m.parent=0
		ORDER BY m.estado
		";
		$query_padres = $this->CI->db->query($consulta_padres);
		
		if($query_padres->num_rows()>0)
		{		
			foreach($query_padres->result() as $field)
			{
				$consulta_hijos = "SELECT  u.id usuario, ug.user_id, ug.group_id, p.menu_id, p.read, p.insert, p.update, p.delete, p.group_id, m.*
				FROM users u
				JOIN users_groups ug 		ON u.id = ug.user_id
				JOIN permisos p 			ON ug.group_id = p.group_id
				JOIN menus m 				ON p.menu_id = m.id
				WHERE u.id = ".$id_usuario." 	AND m.active=1
				AND m.parent=".$field->id."
				AND p.read=1
				ORDER BY m.estado";
				$query_hijos = $this->CI->db->query($consulta_hijos);
				if($query_hijos->num_rows()>0){
					$submenus = '';
					$menu_activo = '';
					$menu_activo_collapse = '';
					foreach ($query_hijos->result() as $result_dos) {
								if ($this->uri->segment(1) == $result_dos->link) {
									$submenus .= "<li class='active'><a href='". base_url().$result_dos->link."'><i class='".$result_dos->iconpath."'></i> ".$result_dos->descripcion."</a></li>";
									$menu_activo = 'active';
									$menu_activo_collapse = 'collapse in';
								}else{
									$submenus .= "<li><a href='". base_url().$result_dos->link."'><i class='".$result_dos->iconpath."'></i> ".$result_dos->descripcion."</a></li>";
								}
					}

					echo "<li class='".$menu_activo."'>
							<a href='javascript:;'><i class='".$field->iconpath."'></i> ".$field->descripcion."</a>
							<ul class='sub-menu'>
							".$submenus."
							</ul>
						</li>";
				}
				else if ($this->uri->segment(1) == $field->link || $this->uri->segment(1) == '') {
					echo "<li class='active'><a href='".site_url($field->link)."'><i class='".$field->iconpath."'></i> ".$field->descripcion."</a></li>";
				}else{
					echo "<li><a href='".site_url($field->link)."'><i class='".$field->iconpath."'></i> ".$field->descripcion."</a></li>";
				}

			}
		}
	}

	function getDashboard($id_usuario)	{
		$consulta_padres = "SELECT  u.id usuario, ug.user_id, ug.group_id, p.menu_id, p.read, p.insert, p.update, p.delete, p.group_id, m.*
		FROM users u
		JOIN users_groups ug 		ON u.id = ug.user_id
		JOIN permisos p 			ON ug.group_id = p.group_id
		JOIN menus m 				ON p.menu_id = m.id
		WHERE u.id = ".$id_usuario." 	
									AND m.active = 1
									AND m.parent = 0
									AND m.dashboard = 1
		ORDER BY m.estado
		";
		$query_padres = $this->CI->db->query($consulta_padres);
		
		if($query_padres->num_rows()>0)
		{		
			$i = 1;
			foreach($query_padres->result() as $field)
			{

				$consulta_hijos = "SELECT  u.id usuario, ug.user_id, ug.group_id, p.menu_id, p.read, p.insert, p.update, p.delete, p.group_id, m.*
				FROM users u
				JOIN users_groups ug 		ON u.id = ug.user_id
				JOIN permisos p 			ON ug.group_id = p.group_id
				JOIN menus m 				ON p.menu_id = m.id
				WHERE u.id = ".$id_usuario." 	AND m.active=1
												AND m.parent=".$field->id."
												AND p.read=1
												AND m.dashboard = 1
				ORDER BY m.orden, m.descripcion";
				$query_hijos = $this->CI->db->query($consulta_hijos);

				echo "	
						<div class='panel panel-success'>
			              <div class='panel-heading'>
			                <h3 class='panel-title'><i class='".$field->iconpath."'></i> ".$field->descripcion."</h3>
			              </div>
			              <div class='panel-body'>
				";
				if($query_hijos->num_rows()>0)
				{
					echo "
						  	<div class='panel-body'>
						  		<div class='row'>
						  ";
						  	foreach ($query_hijos->result() as $result_dos) {
								echo "	
										<div class='col-sm-2'>
											<a href='".$result_dos->link."' class='btn btn-icon btn-block'>
												<i class='".$result_dos->iconpath." fa-3x'></i><p>".$result_dos->descripcion."</p>
											</a>
										</div>";
									}
							echo "
								</div>
							</div>";
				}
				echo "</div></div>";
			}
		}
	}

	function getAccesos($id_usuario){		
		$consulta_padres = "SELECT * FROM login_attempts WHERE user_id = ".$id_usuario."  ORDER BY id desc LIMIT 5";
		$query_padres = $this->CI->db->query($consulta_padres);		
		if($query_padres->num_rows()>0){		
			foreach($query_padres->result() as $field){
				echo "<li class='list-group-item'><i class='fa fa-calendar'></i> ".$field->time."<p><i class='fa fa-desktop'></i> ".$field->ip_address."</p></li>";
			}
		}
	}

	function getUserChat($id_usuario){
		$permisos = "SELECT p.* FROM permisos_chat p JOIN users_groups g ON g.id = p.group_id JOIN users u ON u.id = g.user_id WHERE u.id = ".$id_usuario;
		$query_permisos = $this->CI->db->query($permisos);
		if($query_permisos->num_rows()>0){		
			if ($query_permisos->row()->nuevo==1) {
				$consulta_padres = "SELECT id, username, nombre, apellido FROM users WHERE id !=".$id_usuario;
				$query_padres = $this->CI->db->query($consulta_padres);
				if($query_padres->num_rows()>0){		
					foreach($query_padres->result() as $field){
						echo "<li class='list-group-item'><a href='#' onclick=\"addChat('".$id_usuario."', '".$field->id."', '".base_url()."ajax/ventanaChat')\">".$field->apellido.", ".$field->nombre."</a></li> ";
					}
				}
			}else{
				$consulta_uno = "SELECT usuario_id FROM chat_usuarios WHERE usuario_id != ".$id_usuario." AND chat_id IN (SELECT chat_id FROM chat_usuarios WHERE usuario_id = ".$id_usuario.")";				
				$query_uno = $this->CI->db->query($consulta_uno);
				if($query_uno->num_rows()>0){		
					foreach($query_uno->result() as $f){
						$consulta_padres = "SELECT id, username, nombre, apellido FROM users WHERE id =".$f->usuario_id;
						$query_padres = $this->CI->db->query($consulta_padres);
						echo "<li class='list-group-item'><a href='#' onclick=\"addChat('".$id_usuario."', '".$query_padres->row()->id."', '".base_url()."ajax/ventanaChat')\">".$query_padres->row()->apellido.", ".$query_padres->row()->nombre."</a></li> ";
					}
				}
			}
			if ($query_permisos->row()->grupal==1) {
				echo "<li class='list-group-item'><a data-toggle='modal' href='#chatGrupal'><b>Nuevo chat Grupal</b></a></li>";
			}
		}
	}

	function getAllUsers($id){
		 $usuarios = "SELECT id, apellido, nombre FROM users WHERE id !=".$id;
		 $query_uno = $this->CI->db->query($usuarios);
		 foreach($query_uno->result() as $f){
			echo "<p><input type='checkbox' name='".$f->id."' id='".$f->id."'> ".$f->apellido.", ".$f->nombre."</p>";
		}
	}
}
?>
Anon7 - 2022
AnonSec Team