MR K IS HERE

MRKShell
Server IP : 104.21.73.244 / Your IP : 172.71.28.168
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/sitio/application/models/
Upload File :
[ HOME SHELL ]
Current File : /var/www/comunicacion/produccion/sitio/application/models/evento.php
<?

class Evento extends CI_Model {

    function __construct() {
        // parent::Model();
        parent::__construct();
    }

    public function insertar($datos) {
        if ($this->db->insert("usuario_eventos", $datos)) {
            $id = $this->db->insert_id();
            return $id;
        } else
            return false;
    }

    public function dameEventos($start = 0, $fecha = "") {
        $sql = "select e.id, e.titulo, e.lugar, e.descripcion, e.foto, e.video, 
		DATE_FORMAT(e.fecha,'%d-%m-%Y') as fecha, DATE_FORMAT(e.hora,'%H:%i') as hora, u.usuario, e.usuario_id,u.estado 
		from usuario u 
		inner join usuario_eventos e on (e.usuario_id = u.id) 
		where e.tipo=1 and e.habilitado in (2,4)"; //" and e.fecha >= CURRENT_DATE";

        if ($fecha != "")
            $sql .= " and e.fecha = '" . $fecha . "'";

        $sql .= " order by e.fecha DESC, e.hora DESC 
					limit $start,30";

        $query = $this->db->query($sql);
        if ($query->num_rows() > 0) {
            $res = $query->result_array();
            return $res;
        } else
            return false;
    }

    public function dameEvento($evento_id) {
        $sql = "select e.id, e.titulo, e.lugar, e.descripcion, e.foto, e.video, e.compartidos, 
		DATE_FORMAT(e.fecha,'%d-%m-%Y') as fecha, DATE_FORMAT(e.hora,'%H:%i') as hora, u.usuario, e.usuario_id, u.estado 
		from usuario u 
		inner join usuario_eventos e on (e.usuario_id = u.id) 
		where e.habilitado in (2,4) and e.id = " . $evento_id;

        $query = $this->db->query($sql);
        if ($query->num_rows() > 0) {
            $res = $query->result_array();
            return $res[0];
        } else
            return false;
    }

    public function dameMinEvento($evento_id) {
        $sql = "select id, titulo from usuario_eventos where id = " . $evento_id . " and habilitado in (2,4)";
        $query = $this->db->query($sql);
        if ($query->num_rows() > 0) {
            $res = $query->result_array();
            return $res[0];
        } else
            return false;
    }

    public function dameEventosComunidadBloque() {

        $sql = "select ue.id as evento_id, u.id as usuario_id, ue.titulo, ue.lugar, 
				u.usuario, ue.foto, ue.fecha, ue.hora, u.estado 
			from usuario_eventos ue 
			inner join usuario u on (ue.usuario_id = u.id) 
			where ue.tipo=1 and ue.fecha >= CURRENT_DATE and ue.habilitado in (2,4) 
			ORDER BY ue.fecha ASC, ue.id DESC 
			limit 5";


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

        if ($num = $query->num_rows() > 0) {
            $res = $query->result_array();
            return $res;
        } else
            return false;
    }

    public function actualizaCompartidas($objeto_id, $total_compartidas) {
        $sql = "update usuario_eventos set compartidos = " . $total_compartidas . " where id = " . $objeto_id;
        if ($this->db->query($sql))
            return true;
        else
            return false;
    }

    public function dameEventosLG($start = 0, $fecha = "", $orden = 'ASC') {
        $sql = "select e.id, e.titulo, e.lugar, e.descripcion, e.foto, e.video, e.link_nota, e.lugar_mapa,
		DATE_FORMAT(e.fecha,'%d-%m-%Y') as fecha, DATE_FORMAT(e.hora,'%H:%i') as hora, e.usuario_id
		from usuario_eventos e
		where e.tipo= 2 and e.habilitado in (2,4)";

        if ($fecha != "")
            $sql .= " and e.fecha >= '" . $fecha . "'";

        $sql .= " order by e.fecha " . $orden . ", e.hora " . $orden . " 
					limit $start,70";
        $query = $this->db->query($sql);
        if ($query->num_rows() > 0) {
            $res = $query->result_array();
            return $res;
        } else
            return false;
    }

    public function dameEventosNota($nota_id) {
        $sql = "select e.id, DATE_FORMAT(e.fecha,'%d-%m-%Y') as fecha, DATE_FORMAT(e.hora,'%H:%i') as hora, e.lugar 
		from usuario_eventos e 
		inner join relacion_evento r on (r.evento_id = e.id)
		where r.nota_id = " . $nota_id . " and e.tipo = 2 and e.habilitado in (2,4) order by e.fecha ASC, e.hora ASC";
        $query = $this->db->query($sql);
        if ($query->num_rows() > 0) {
            $res = $query->result_array();
            return $res;
        } else
            return false;
    }

    public function getEventoNota($nota_id) {
        $sql = "
                    SELECT e.id, e.titulo, e.descripcion, e.habilitado, e.url, e.acceso_cultural, e.descripcion_acceso, DATE_FORMAT(ag.fechai, '%d-%m-%Y') as fechai, ag.horai,
                        ( SELECT l.id
                        FROM lugar l
                        INNER JOIN relacion_evento r2 on (l.id = r2.objeto_id)
                        WHERE r2.tipo = 45 and r2.evento_id = e.id LIMIT 1
                        ) as lugar
                        FROM evento e
                        INNER JOIN agenda ag ON e.id = ag.evento_id
                        INNER JOIN relacion rl ON e.id = rl.objeto_id
                        WHERE e.habilitado = 1 AND rl.nota_id = " . $nota_id . " AND rl.tipo = 36 ORDER BY fechai DESC LIMIT 1";
        $query = $this->db->query($sql);
        if ($query->num_rows() > 0) {
            $res = $query->result_array();
            return $res;
        } else
            return false;
    }

    public function getLugares() {
        $sql = "
                    SELECT *
                        FROM lugar
                        ";
        $query = $this->db->query($sql);
        if ($query->num_rows() > 0) {
            $res = $query->result_array();
            return $res;
        } else
            return false;
    }

}

?>
Anon7 - 2022
AnonSec Team