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/hitadmin/application/models/
Upload File :
[ HOME SHELL ]
Current File : /var/www/comunicacion/produccion/hitadmin/application/models/Nota_md.php
<?php

class Nota_md extends CI_Model {

    function __construct() {
        parent::__construct();
        $this->load->database();
        $this->load->library('VariosLibrary_lb.php');
        //valores por defecto de las variables
        $this->edicion_id = "NULL";
        $this->antetitulo = "";
        $this->titulo = "";
        $this->sumario = "";
        $this->texto = "";
        $this->habilitada = "0";
        $this->permisoComent = "0";
        $this->fechaAlta = date("Y-m-d H:i:s");
        $this->fechamod = date("Y-m-d H:i:s");
        $this->url = "";
        $this->usuario_id = "";
        $this->id_seccion = "NULL";
        $this->id_subseccion = "NULL";
        $this->scroll_inactivo = 0;
        $this->video_en_nota = 0;
        $this->patrocinado = 0;
        $this->acceso_cultural = 0;
        $this->vista = 1;
    }

    public function add() {

        /* $urlAmig = new ObtenerUrl_lb();
          $this->url=$urlAmig->urls_amigables($this->titulo); */
        $urlAmig = new VariosLibrary_lb();
        $url = $urlAmig->limpiarurl($this->titulo);
        $url = $urlAmig->amigar_cadena($url);
        $var = filter_var($url, FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW);
        $this->url = trim($var) . ".html";

        $sql = "INSERT INTO nota (edicion_id,antetitulo,titulo,sumario,texto,habilitada,permisoComent,fechaAlta,url,vista,fechamod,usuario_id,id_seccion,id_subseccion,scroll_inactivo,video_en_nota,patrocinado,acceso_cultural) VALUE (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
        $this->db->query($sql, array($this->edicion_id, $this->antetitulo, $this->titulo, $this->sumario, $this->texto, $this->habilitada, $this->permisoComent, $this->fechaAlta, $this->url, $this->vista, $this->fechamod, $this->usuario_id, $this->id_seccion, $this->id_subseccion, $this->scroll_inactivo, $this->video_en_nota, $this->patrocinado, $this->acceso_cultural));
    }

    public function delById($id) {
        $sql = 'DELETE FROM nota WHERE id=?';
        $query = $this->db->query($sql, array($id));
    }

    public function del() {
        $sql = $this->db->query('DELETE FROM nota WHERE id=$this->id');
    }

    public function update($id) {

        $urlAmig = new VariosLibrary_lb();
        $url = $urlAmig->limpiarurl(html_entity_decode($this->titulo));
        $url = $urlAmig->amigar_cadena($url);
        $var = filter_var($url, FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW);
        $this->url = trim($var) . ".html";

        $sql = 'UPDATE nota SET anteTitulo=?,
								 titulo=?,
								 sumario=?,
								 texto=?,
								 habilitada=?,
								 url=?,
								 vista=?,
								 id_seccion=?,
								 id_subseccion=?,
								 scroll_inactivo=?,
								 video_en_nota=?,
								 patrocinado=?,
								 acceso_cultural=?
								 WHERE id=?';
        $this->db->query($sql, array($this->antetitulo, $this->titulo, $this->sumario, $this->texto, $this->habilitada, $this->url, $this->vista, $this->id_seccion, $this->id_subseccion, $this->scroll_inactivo, $this->video_en_nota, $this->patrocinado, $this->acceso_cultural, $id));
    }

    public function setHora($id) {
        $sql = 'UPDATE nota SET fechamod=? WHERE id=?';
        $this->db->query($sql, array($this->fechamod, $id));
    }

    public function getById($id) {
        $sql = 'SELECT * FROM nota WHERE id=?';
        $query = $this->db->query($sql, array($id));
        return $query->result();
    }

    public function getByIdRel($id) {
        $sql = "SELECT id, DATE_FORMAT(fechaAlta,'%d/%m/%Y') as fecha, titulo FROM nota WHERE id=?";
        $query = $this->db->query($sql, array($id));
        return $query->result();
    }

    public function countAllFROMToday() {
        $sql = $this->db->query('SELECT count(*) as c FROM nota WHERE date(fechaAlta)=date(NOW())');
        return $sql->result();
    }

    public function getAll() {
        $sql = $this->db->query('SELECT * FROM nota  ORDER BY fechaAlta DESC');
        return $sql->result();
    }

    public function getPorFecha($fecha) {
        $sql = "SELECT id,titulo,habilitada,DATE_FORMAT(fechamod, '%H:%i') as hora,usuario_id,id_seccion,id_subseccion,fechaAlta FROM nota WHERE DATE_FORMAT(fechaAlta,'%d-%m-%Y')=? ORDER BY fechaAlta DESC";
        $query = $this->db->query($sql, array($fecha));
        $res = $query->result_array();
        if ($query->num_rows() > 0)
            return $res;
        else
            return false;
    }

    public function getPorId($id) {
        $sql = "SELECT n.id,n.titulo,n.habilitada,DATE_FORMAT(n.fechamod, '%H:%i') as hora,n.usuario_id,n.id_seccion,n.id_subseccion,n.fechaAlta,n.url,nv.ranking, tg.nombre AS seccion
			FROM nota n 
			INNER JOIN nota_visitas nv ON nv.nota_id=n.id 
                        INNER JOIN tag tg ON tg.id = n.id_seccion
		    WHERE edicion_id=? ORDER BY fechaAlta DESC";
        $query = $this->db->query($sql, array($id));
        $res = $query->result_array();
        if ($query->num_rows() > 0)
            return $res;
        else
            return false;
    }

    public function getPorIdIndex($idE, $idU) {
        $sql = "SELECT n.id,n.titulo,n.habilitada,nv.ranking 
				FROM nota n 
				INNER JOIN nota_visitas nv ON nv.nota_id=n.id 
				WHERE edicion_id=?  and n.usuario_id=?
				ORDER BY fechaAlta DESC";
        $query = $this->db->query($sql, array($idE, $idU));
        $res = $query->result_array();
        if ($query->num_rows() > 0)
            return $res;
        else
            return false;
    }

    public function getLast1() {
        $sql = $this->db->query('SELECT * FROM nota ORDER BY fechaAlta DESC limit 1');
        return $sql->result();
    }

    public function getLast() {
        $sql = 'SELECT id FROM nota ORDER BY id DESC LIMIT 1';
        $query = $this->db->query($sql);
        if ($query->num_rows() > 0) {
            $res = $query->result_array();
            return $res[0]['id'];
        } else
            return false;
    }

    public function getLike($q) {
        $sql = $this->db->query("SELECT DISTINCT id, DATE_FORMAT(fechaAlta,'%d/%m/%Y') as fecha, titulo FROM nota WHERE (titulo like '%$q%' /*or texto like '%$q%'*/ or id like '%$q%') GROUP BY id DESC limit 10");
        return $sql->result();
    }

    /* consultas para la paginacion */

    public function total_paginados($por_pagina, $segmento) {
        $consulta = "SELECT id, DATE_FORMAT(fechaAlta,'%d-%m-%Y') as fecha
    				   FROM nota ORDER BY fechaAlta DESC
    				   LIMIT  " . $por_pagina . " OFFSET " . $segmento;

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

        if ($query->num_rows() > 0) {
            foreach ($query->result() as $fila) {
                $data[] = $fila;
            }
            return $data;
        }
    }

    public function contadorNotas() {
        $consulta = $this->db->get('nota');
        return $consulta->num_rows();
    }

    public function traerNotaPorEdicion($id) {

        $consulta = "SELECT nt.*, ed.fecha FROM nota AS nt
				   join edicion AS ed ON nt.edicion_id=ed.id
				   WHERE ed.id=" . $id;
        $query = $this->db->query($consulta);
        $res = $query->result_array();

        if ($query->num_rows() > 0)
            return $res;
        else
            return false;
    }

    public function cambiarEdicion($nota_id, $edicion_id) {

        $sql = "update nota set edicion_id = '" . $edicion_id . "' where id = '" . $nota_id . "'";
        $query = $this->db->query($sql);
    }

    public function setTitulo($titulo, $id) {
        $sql = "UPDATE nota SET titulo = ? WHERE id = ? ";
        $query = $this->db->query($sql, array($titulo, $id));
    }

    public function setHabilitar($hab, $id) {
        $sql = "UPDATE nota SET habilitada = ? WHERE id = ? ";
        $query = $this->db->query($sql, array($hab, $id));
    }

    public function delRelacion($id) {
        $sql = "DELETE FROM relacion WHERE nota_id=? and tipo=36";
        $query = $this->db->query($sql, array($id));
    }

    public function delRelacionNota($id) {
        $sql = "DELETE FROM relacion WHERE objeto_id=? and tipo=36";
        $query = $this->db->query($sql, array($id));
    }

    public function listado() {
        $sql = 'SELECT * FROM nota where habilitada=1 GROUP BY id DESC';
        $query = $this->db->query($sql);
        if ($query->num_rows() > 0) {
            foreach ($query->result() as $fila) {
                $data[] = $fila;
            }
            return $data;
        } else {
            return false;
        }
    }

    public function dameNombreNota($id) {
        $sql = 'SELECT titulo FROM nota where id=?';
        $query = $this->db->query($sql, array($id));
        if ($query->num_rows() > 0) {
            $res = $query->result_array();
            return $res[0]['titulo'];
        } else
            return false;
    }

    public function agregarRelacionNota($evento_id, $nota_id) {
        //$orden = $this->dameOrdenRelacionNota($nota_id);
        $datos['nota_id'] = $nota_id;
        $datos['objeto_id'] = $evento_id;
        $datos['tipo'] = 36;
        $datos['orden'] = 1;
        $datos['descripcion'] = 'Nota relacionada';
        if ($this->db->insert("relacion", $datos))
            return true;
        else
            return false;
    }

}

?>
Anon7 - 2022
AnonSec Team