
 <?php include '../url_amigable.php';?>
<?php include 'sesion.php';?>
<?php include 'concha.php';?>
<!DOCTYPE html>
<html lang="es">
<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8">
	<!-- Required meta tags -->

	<meta name="description" content="Panel de Administracion">
	<meta name="author" content="<?php echo $nombresitio ?>">
	<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <title><?php echo $nombresitio ?> - Panel de Administracion</title>
  <!--link href='http://fonts.googleapis.com/css?family=Oswald' rel='stylesheet' type='text/css'-->
  <link href="https://fonts.googleapis.com/css?family=Montserrat:100,100i,200,200i,300,300i,400,400i,500,500i,600,600i,700,700i,800,800i,900&display=swap" rel="stylesheet">
  <link rel="shortcut icon" href="" type="image/x-icon">
	<link rel="apple-touch-icon" href="">

	<!-- Bootstrap CSS -->
	<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">

  <!-- Link to your css file -->
	<link rel="stylesheet" href="">
  <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>

  <!--script type="text/javascript" src="//recursos.radiosnethosting.com/ckeditor/ckeditor.js"></script-->

    <style>

        .carousel-cell {
          width: 66%;
          margin-right: 5px;
        }

        .display-flex{
            display: flex;
            justify-content: center;
            align-items: center;
        }

        *{
            border-radius: 0!important;

        }

        body {
            background-image: url(../fondeux.jpg);
            background-position:top center;
            background-repeat: repeat-x;
            background-color:#EBEBEB;
            height:100%;
        }

        .btn, a, h1, h2, h3, h4, h5, h6, b{
          font-family: 'Montserrat', sans-serif;
        }

        .btn, h1, h2, h3, h4, h5, h6 {
          font-weight: 600;
        }

        .navbar {
            position: relative;
        min-height: 50px;
        padding-bottom:  20px;
        /* border: 1px solid transparent; */

        }

      .btn-primary {
        color: #fff!important;
        background-color: #0066FF;
        border-color: #0066FF;
            }

        .page-header{
            margin: 0;
            padding: 1em;
            background-color: #0066FF;
            border: 0;
            text-align:center;
        }

        .page-header h2{

            color: #ffffff;
            font-weight: bold;
        }

        .bloqueAzul{
          /*  background-color: #0066FF;*/
          /* border: 1px solid #e4e4e4;*/
          /*  padding: 1em;*/
            text-align: center;
        }

        .bloqueAzul .div {
          border: 1px solid #e4e4e4;
            background-color: #fff;
        }

        ul{
            list-style: none;
            padding: 0;
        }

        .far{
            color:#0066FF;
        }
        .faso {
            color:#fff;
        }

        .colorAzul h3{
            color:#0066FF;

        }

    </style>

    <script language=javascript>
      function ventanaSecundaria (URL){
        window.open(URL,"ventana1","width=550,height=450,scrollbars=NO")
      }
    </script>

</head>

<body>

<?


  $N2 = 0;

mysql_connect ("$host", "$usuario", "$contra");
mysql_select_db ("$basedatos");
$sql = "SELECT * FROM chat WHERE ver = 'no' ";
$consulta = mysql_query ($sql);
while ($row = mysql_fetch_array($consulta))
{
$N2 = $N2 + 1;
$m_mensajes = $N2;
}
mysql_free_result($consulta);
$N = 0;
mysql_connect ("$host", "$usuario", "$contra");
mysql_select_db ("$basedatos");
$sql = "SELECT * FROM comentarios WHERE ver = 'no' ";
$consulta = mysql_query ($sql);
while ($row = mysql_fetch_array($consulta))
{
$N = $N + 1;
$m_comentarios = $N;
}
mysql_free_result($consulta);
$N = 0;
mysql_connect ("$host", "$usuario", "$contra");
mysql_select_db ("$basedatos");
$sql = "SELECT * FROM fotosoyentes WHERE ver = 'no' ";
$consulta = mysql_query ($sql);
while ($row = mysql_fetch_array($consulta))
{
$N = $N + 1;
$m_fotos = $N;
}
mysql_free_result($consulta);
$N = 0;
mysql_connect ("$host", "$usuario", "$contra");
mysql_select_db ("$basedatos");
$sql = "SELECT * FROM avisos WHERE ver = 'no' ";
$consulta = mysql_query ($sql);
while ($row = mysql_fetch_array($consulta))
{
$N = $N + 1;
$m_avisos = $N;
}
mysql_free_result($consulta);
$m_tot = $m_mensajes + $m_comentarios + $m_fotos + $m_avisos;
?>

<? $tour = (int)$_GET['tour']; ?>
<? if ($tour == 1) {} else { ?>
<div class="container" style="background-color:#F1F2ED;">
    <?php include 'menu.php';  ?>
</div> <? } ?>



<div role="main" style="background-color:#fff;" class="container pt-3">

    <div class="page-header" style="text-align:center;">

                <h2><? echo $idioma_100265 ?></h2>

            </div>




        <div class="row mt-3">

            <div class="col-12 col-md-6">

            <h3 class=""><? echo $idioma_100266 ?></h3>
         <form id="form1" name="form1" method="GET" action="buscar_noticias.php">


                   <input name="busqueda" type="text" class="form-control" id="busqueda" />

                    <input name="button" type="submit" class="btn btn-primary" id="button" value="<? echo $idioma_100267 ?>" />
         </form>

            </div>


              <div class="col-12 col-md-6">

        <h3 class=""><? echo $idioma_100268 ?></h3>

           <form id="form1" name="form1" method="GET" action="filtrar_noticias.php">

               <select name="ID_cat" class="form-control" id="cat5">
                      <option value="0" selected="selected"><? echo $idioma_100269 ?></option>
                      <?php include('concha.php');

mysql_connect ("$host", "$usuario", "$contra");

mysql_select_db ("$basedatos");



$sql = "SELECT * FROM categorias ORDER BY nombre";



$consulta = mysql_query ($sql);

while ($row = mysql_fetch_array($consulta))

{

$ID = $row["ID"];

$nombre = $row["nombre"];



?>
                      <option value="<?php echo $ID ?>"> <?php echo $nombre ?> </option>
                      <?



}

mysql_free_result($consulta);





?>
                    </select>

              <input name="button3" type="submit" class="btn btn-primary" id="button3" value="<? echo $idioma_100270 ?>" />

          </form>

              </div>
          </div>
        <hr />





              <div class="mt-3">



                  <?
//NOMBRE DEL ARCHIVO PHP
$pagina = "notas.php";
//NOMBRE DE LA TABLA ADONDE SE QUIERE REALIZAR LA CONSULTA
$tabla = "notas";
//CANTIDAD DE RESULTADOS POR TABLA
$c = 15;

$ID = (int)$_GET['ID'];
$i = $_GET['i'];
$p = $_GET['p'];
if ($i == NULL) {$i = 0; $p = 1;} else {};

?>
 <h6>MOSTRANDO NOTICIAS DE <?php echo $i; ?> a <?php $iii = $i + 15; echo $iii;?></h6>
<?


mysql_connect ("$host", "$usuario", "$contra");
mysql_select_db ("$basedatos");
$sql = "SELECT * FROM $tabla ORDER BY ID desc LIMIT $i,$c";
$consulta = mysql_query ($sql);
while ($row = mysql_fetch_array($consulta))
{

$i_d = 0;
 $ID = $row["ID"];
                                            $visitas = $row["visitas"];
                                            $impresiones = $row["impresiones"];
                                            $titulo = $row["titulo"];
                                            $color = $row["color"];
                                            $carpetafoto  = $row["carpetafoto"];
                                            $fechapub  = $row["fechapub"];
                                            $foto = $row["foto"];
                                            $destacado = $row["destacado"];
                                            $audio = $row["audio"];
                                            $youtube = $row["youtube"];
                                            $d = $row["d"];
                                            $m = $row["m"];
                                            $ver = $row["ver"];
                                            $a = $row["a"];
                                            $fecha = "$d - $m - $a";
                                            $ext_img = $row["ext_img"];
                                            $editor = $row["editor"];
                                            $des_cat = $row["des_cat"];
                                            $cat = $row["cat"];
                                            $user_carga_nota  = $row["user"];
                                            $pie_foto  = $row["pie_foto"];
                                            $altfoto  = $row["altfoto"];
                                            $titulofoto  = $row["titulofoto"];

?>
          <?php include 'mostrar_notisnew.php';?>
                <?


 }
mysql_free_result($consulta);

?>






                <div class="col-12">

                  <?php if ($p == 1) {} else { ?>

                  <a href="<?php echo $pagina ?>?i=<?php echo $i - $c; ?>&amp;p=<?php echo $p - 1; ?>"><? echo $idioma_100271 ?></a>
                  <?php }?>

                  <?php if ($p == $cant) {} else { ?>
                  <a href="<?php echo $pagina ?>?i=<?php echo $i + $c; ?>&amp;p=<?php echo $p + 1; ?>"><?php echo $idioma_siguiente ?></a>
                  <?php }?>


                    <hr>

                    <div>
                    <form action="notas.php" method="get">
                    <select name="i" class="form-control">
                  <?  $r = 0;
                    $e= 0;
                    while ($r  <= 4000) {

					$r = $r + 1;

                        ?>

PÁGINA: <option value="<? echo $e ?>"><? echo $r ?></option>


                      <?
                     $e = $e + 15;
                    } ?>
                    </select>

                    <input value="CAMBIAR PAGINA" type="submit"  class="form-control">
                    </form>

                    <br>


          </div>

                </div>

              <br />

              </div>




</div>


<!-- jQuery first, then Popper.js, then Bootstrap JS -->
	<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.6/umd/popper.min.js" integrity="sha384-wHAiFfRlMFy6i5SRaxvfOCifBUQy1xHdJ/yoi7FRNXMRBu5WHdZYu1hA6ZOblgut" crossorigin="anonymous"></script>
	<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/js/bootstrap.min.js" integrity="sha384-B0UglyR+jN6CkvvICOB2joaf5I4l3gm9GU6Hc1og6Ls7i6U/mkkaduKaBhlAXv9k" crossorigin="anonymous"></script>

<script src="https://unpkg.com/isotope-layout@3/dist/isotope.pkgd.js"></script>
<script type="text/javascript">
window.setInterval(function(){
  $('.grid').isotope({
  itemSelector: '.grid-item'
});
}, 500);
</script>
 <script defer src="https://use.fontawesome.com/releases/v5.8.1/js/all.js" integrity="sha384-g5uSoOSBd7KkhAMlnQILrecXvzst9TdC09/VM+pjDTCM+1il8RHz5fKANTFFb+gQ" crossorigin="anonymous"></script>
</body>
</html>
