<?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 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 -->
  <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>

  
        <style type="text/css">

            *{
                border-radius: 0!important;
                
            }

            body {
                background-image: url(../fondeux.jpg);
            }

            .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:#0066FF;
            } 
            
            .colorAzul h3{
                color:#0066FF;
                
            }
            
        </style>

        <script language=javascript>

            function ventanaSecundaria (URL){
            window.open(URL,"ventana1","width=550,height=450,scrollbars=NO")
            }

        </script>
    
</head>



<body>


<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_100552 ?></h2>

  </div>


      <div class="row pt-3">



                                  <?

                                $N2 = 0;
                               
                                $sql = "SELECT * FROM chat WHERE ver = 'no' ";
                                $consulta = $conn->query($sql);
                               while ($row = $consulta->fetch_assoc())
                                {
                                $N2 = $N2 + 1;
                                $m_mensajes = $N2;
                                }
                                $consulta->free_result();
                                $N = 0;
                                
                                $sql = "SELECT * FROM comentarios WHERE ver = 'no' ";
                                $consulta = $conn->query($sql);
                                while ($row = $consulta->fetch_assoc())
                                {
                                $N = $N + 1;
                                $m_comentarios = $N;
                                }
                                $consulta->free_result();
                                $N = 0;
                                
                                $sql = "SELECT * FROM fotosoyentes WHERE ver = 'no' ";
                                $consulta = $conn->query($sql);
                                while ($row = $consulta->fetch_assoc())
                                {
                                $N = $N + 1;
                                $m_fotos = $N;
                                }
                                $consulta->free_result();
                                $N = 0;
                                
                                $sql = "SELECT * FROM avisos WHERE ver = 'no' ";
                                $consulta = $conn->query($sql);
                              while ($row = $consulta->fetch_assoc())
                                {
                                $N = $N + 1;
                                $m_avisos = $N;
                                }
                                $consulta->free_result();
                                $m_tot = $m_mensajes + $m_comentarios + $m_fotos + $m_avisos;

                                ?>


      
                  <div class="col-12">



                            <?
                           
                            $sql = "SELECT * FROM avisos where ver = 'no'";
                            $consulta = $conn->query($sql);
                            while ($row = $consulta->fetch_assoc())
                            {
                            $ID = $row["ID"];
                            $titulo = $row["titulo"];
                            $linea1 = $row["linea1"];
                            $linea2 = $row["linea2"];
                            $IDC = $row["IDC"];
                            $IDS = $row["IDS"];
                            $userp = $row["user"];
                            $foto = $row["foto"];
                            ?>

                      
                                <div class="col-12 col-sm-4 px-2">

                              

                                              
                                      <h4 class="Estilo42"><?php echo $titulo ?></h4>

                                        <div class="col-12">

                                      
                                              <?php if ($foto == NULL) {} else {?>
                                              
                                              <img src="../upload_pic/resize_<?php echo $foto ?>.jpg" /> <?php };?>

                                              <p><?php echo $linea1 ?></p>
                                          
                                              <p><?php echo $linea2 ?></p>

                                                <?php   

                                                  $sql2 = "SELECT * FROM cla_categorias WHERE ID = $IDC";
                                                  $consulta2 = $conn->query($sql2);
                                                  while ($row2 = $consulta2->fetch_assoc())
                                                  {
                                                  $nombrecat = $row2["nombre"];
                                                  }
                                                  $consulta2->free_result();
                                                  $sql3 = "SELECT * FROM subcategorias where ID = $IDS";
                                                  $consulta3 = $conn->query($sql3);
                                                  while ($row3 = $consulta3->fetch_assoc())
                                                  {
                                                  $nombresub = $row3["nombresub"];
                                                  }
                                                $consulta2->free_result();
                                                ?>

                                            <div>

                                              <?php echo $nombrecat ?>
                                              <?php echo $nombresub ?>

                                            </div>
                                          
                                          </table>

                                        </div>

                                                  <ul class="d-flex justify-content-center">

                                                      <li>
                                                        <a class="btn btn-outline-primary" href="aceptar_cla.php?ID=<?php echo $ID ?>"><? echo $idioma_aceptar ?></a>
                                                      </li>

                                                      <li>
                                                        <a class="btn btn-link" href="borrar_cla.php?ID=<?php echo $ID ?>"><? echo $idioma_borrar ?></a>
                                                      </li>
                                    
                                                      
                                                  </ul>
                                    
                                </div>

                                <? }
                                $consulta->free_result();
                                ?>

                              <ul  class="d-flex justify-content-center">
                                  <li>
                                    <a class="btn btn-outline-primary" href="panelcat.php"><? echo $idioma_100553 ?></a>
                                  </li>

                                  <li>
                                    <a class="btn btn-link" href="borrar_clasificados.php"><? echo $idioma_100554 ?></a>
                                  </li>
                              </ul>

                  </div>                 

      </div>
  

<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" 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>
