session_start();
include('docs/connect.php');
error_reporting(0);
$usuario_nombre=$_SESSION['usuario_nombre'];
$anio=$_GET['anio'];
if($usuario_nombre){
?>
AÑO echo $anio; ?>
$resultk = "SELECT * FROM pppeliculator_anios ORDER BY anio DESC LIMIT 77";
$cadk = mysqli_query($con,$resultk) or die (mysqli_error());
while ($arrayk = mysqli_fetch_array($cadk))
{
$idanio = "$arrayk[id]";
echo "$arrayk[anio], ";
}
echo "TODAS
";
?>
if($anio){
echo "
PELICULAS CON ENLACES pero sin info, POR AÑOS
";
//PELICULAS CON ENLACES PERO NO HAY INFO!! HAY QUE SUBIRLA!
$result = "SELECT * FROM pppeliculator where title like '%$anio%' AND image = '' ORDER BY views DESC LIMIT 3000";
$cad = mysqli_query($con,$result) or die (mysqli_error());
while ($array = mysqli_fetch_array($cad))
{
$phpdate2 = date('Y-m-d',strtotime( $array['fecha_estreno'] ));
$resultgo = "SELECT * FROM pppeliculator_linksstreaming where idpelicula = $array[id] LIMIT 3000";
$cadgo = mysqli_query($con,$resultgo) or die (mysqli_error());
$counting = mysqli_num_rows($cadgo);
if ($counting != 0){
echo "";
echo "$array[title] (Visitas: $array[views]) ($array[uploader])";
echo "
";
}else{
}//Fin if mysqli_num_rows($cadgo) === 0
}//Fin while
}else{//else if $anio
echo "Todas las películas Sin Info pero con enlaces
";
$resultgo = "SELECT * FROM pppeliculator_linksstreaming GROUP BY idpelicula LIMIT 100000";
$cadgo = mysqli_query($con,$resultgo) or die (mysqli_error());
$counting = mysqli_num_rows($cadgo);
while ($arraygo = mysqli_fetch_array($cadgo))
{
$result = "SELECT * FROM pppeliculator where image = '' and id = $arraygo[idpelicula] ORDER BY anio DESC LIMIT 100000";
$cad = mysqli_query($con,$result) or die (mysqli_error());
while ($array = mysqli_fetch_array($cad))
{
$phpdate2 = date('Y-m-d',strtotime( $array['fecha_estreno'] ));
echo "";
echo "$array[title] (Visitas: $array[views]) ($array[uploader])";
echo "
";
}
}//Fin while 2
echo "Ultimos títulos subidos
";
$resulto = "SELECT * FROM pppeliculator order by id DESC limit 40"; //
$cado = mysqli_query($con,$resulto) or die (mysqli_error());
while ($arrayo = mysqli_fetch_array($cado))
{
echo "$arrayo[title] ($arrayo[uploader]) -";
$resultn = "SELECT * FROM pppeliculator_linksstreaming where idpelicula='$arrayo[id]' limit 40";
$cadn = mysqli_query($con,$resultn) or die (mysqli_error());
if ($arrayn = mysqli_num_rows($cadn)){
echo " Estado:

";
} else{
echo " Estado:

";
}
if($arrayo[uploader] != '' AND $arrayo[uploader] != 'ojomovies'){ echo "⭐"; }
if(empty($arrayo[image])){ echo "NOINFO
";}
echo "";
}
}//Fin if $anio
}//Fin if usuario_nombre
?>