✏️ Editing: usuariored2.php

<!DOCTYPE html>

<!-- =========================================================
* Sneat - Bootstrap 5 HTML Admin Template - Pro | v1.0.0
==============================================================

* Product Page: https://themeselection.com/products/sneat-bootstrap-html-admin-template/
* Created by: ThemeSelection
* License: You must have a valid license purchased in order to legally use the theme for your project.
* Copyright ThemeSelection (https://themeselection.com)

=========================================================
 -->

<html
  lang="en"
  class="light-style layout-menu-fixed"
  dir="ltr"
  data-theme="theme-default"
  data-assets-path="../assets/"
  data-template="vertical-menu-template-free"
>
  <head>
    <meta charset="utf-8" />
    <meta
      name="viewport"
      content="width=device-width, initial-scale=1.0, user-scalable=no, minimum-scale=1.0, maximum-scale=1.0"
    />

<title>Usuario - InRed</title>

<link rel="icon" type="image/x-icon" href="../assets/img/favicon/favicon.ico" />

<link rel="preconnect" href="https://fonts.googleapis.com" />
    <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin />
    <link
      href="https://fonts.googleapis.com/css2?family=Public+Sans:ital,wght@0,300;0,400;0,500;0,600;0,700;1,300;1,400;1,500;1,600;1,700&display=swap"
      rel="stylesheet"
    />

<link rel="stylesheet" href="../assets/vendor/fonts/boxicons.css" />

<link rel="stylesheet" href="../assets/vendor/css/core.css" class="template-customizer-core-css" />
    <link rel="stylesheet" href="../assets/vendor/css/theme-default.css" class="template-customizer-theme-css" />
    <link rel="stylesheet" href="../assets/css/demo.css" />

<link rel="stylesheet" href="../assets/vendor/libs/perfect-scrollbar/perfect-scrollbar.css" />

<script src="../assets/vendor/js/helpers.js"></script>

<script src="../assets/js/config.js"></script>
  </head>

<?php
       include '../conex.php';
       include 'menu.php';
       ?>

<div class="layout-page">

<?php
         
        $id= isset($_GET['id']) ? $_GET['id'] : '' ;
        $sqlx=$conex->query ("SELECT * FROM login WHERE id='$id' ") or die(mysqli_error());   
        if($row_cnt = $sqlx->num_rows>0) {       
            while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                   $user=$rowx['user'];
                   $pass=$rowx['pass'];
                   $nombre=$rowx['nombre'];
                   $estado=$rowx['estado'];
                   $ciudad=$rowx['ciudad'];
                   $barrio=$rowx['barrio'];
                   $telefono=$rowx['telefono'];
                   $email=$rowx['email'];
                   $sexo=$rowx['sexo'];   
                   $foto=$rowx['foto'];  
                   $fnacimiento=$rowx['fnacimiento'];          
                  }
          }

$swsexo1='';
         $swsexo2='';
         if($sexo=='M')$swsexo1='selected';
         if($sexo=='F')$swsexo2='selected';

$puntos=0;
     $sql=$conex->query ("SELECT * FROM resultados WHERE  usuario='$id' and status='3' ") or die(mysqli_error());   
     if($row_cnt = $sql->num_rows>0) {       
     while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) { 
     $pt=$row['puntos'];
     $puntos=$puntos+$pt;                    
           }
      }

$textnav='Invitados de: <b>'.strtoupper($nombre).'</b>';
         include 'nav.php';
         ?>

<div class="content-wrapper">

<div class="container-xxl flex-grow-1 container-p-y">
              
<!--
              <div class="row">
                <div class="col-md-12">
             
<form id="formAccountSettings" autocomplete="off" method="POST" action="asadminred.php" enctype="multipart/form-data">
<input class="form-control" type="hidden" id="id" name="id"   value="<?=$id?>" />
                  <div class="card mb-4">                   
                    
                    <div class="card-body">
                      <div class="row">
                        
                      <div class="mb-3 col-md-4">
                      Foto de Perfil: </br>
                      <div class="d-flex align-items-start align-items-sm-center gap-4">

<?php
                                 if($foto=='') echo "<img src='upload/red.PNG' alt='user-avatar' class='d-block rounded' height='100' width='100' id='uploadedAvatar' />";
                                 if($foto!='') echo "<img src='upload/$foto' alt='user-avatar' class='d-block rounded' height='100' width='100' id='uploadedAvatar' />";
                       ?>

</div>

<div class="mb-3 col-md-4">
                             <a href="javascript:eliminar('1');" class="btn btn-primary d-grid w-100"    >Eliminar Usuario</a>
                          </div>

<div class="mb-3 col-md-4">
                             <a href="javascript:eliminar('2');" class="btn btn-primary d-grid w-100"    >Eliminar Usuario + Red</a>
                          </div>
 </div>
                    </div>
                    <hr class="my-0" />
                    <div class="card-body">
                      
                        <div class="row">

<div class="mb-3 col-md-4">
                            <label for="firstName" class="form-label">Usuario</label>
                            <input class="form-control" type="text" id="usuario" name="usuario"  readonly="" autofocus  placeholder="User" value="<?=$user?>" />
                          </div>
                          <div class="mb-3 col-md-4">
                            <label for="lastName" class="form-label">Nombre y Apellido</label>
                            <input class="form-control" type="text" name="nombre" id="nombre"  readonly="" placeholder="Nombre y Apellido" value="<?=$nombre?>" />
                          </div>

<div class="mb-3 col-md-4">
                            <label for="lastName" class="form-label">Puntos acumulados</label>
                            <input class="form-control" type="text" name="puntos" id="puntos"  readonly="" placeholder="Puntos" value="<?=$puntos?>" />
                          </div>

<div class="mb-3 col-md-6">
                            <label for="firstName" class="form-label">Fecha de nacimiento</label>
                            <input class="form-control" type="date" id="fnacimiento" name="fnacimiento"  readonly=""  value="<?=$fnacimiento?>"   />
                          </div>
                          <div class="mb-3 col-md-6">
                            <label for="lastName" class="form-label">Sexo</label>
                             <select id="sexo" name="sexo" disabled="" class="select2 form-select" readonly="">
                              <option value="">Seleccionar sexo</option>
                              <option value="M" <?=$swsexo1?> >Masculino</option>
                              <option value="F" <?=$swsexo2?> >Femenino</option>                             
                            </select>
                          </div>

<div class="mb-3 col-md-6">
                            <label for="email" class="form-label">E-mail</label>
                            <input class="form-control" type="email" id="email" name="email" value="<?=$email?>" placeholder="pruebae@inred.com" readonly="" />
                          </div>

<div class="mb-3 col-md-6">
                            <label class="form-label" for="phoneNumber">Número de teléfono</label>
                            <div class="input-group input-group-merge">
                              <span class="input-group-text">MEX (+52)</span>
                              <input type="text" id="phoneNumber" name="phoneNumber" class="form-control" placeholder="202 555 0111" readonly="" value="<?=$telefono?>" />
                            </div>
                          </div>

<div class="mb-3 col-md-4">
                            <label for="address" class="form-label">Estado</label>
                            <input type="text" class="form-control" id="estado" name="estado" readonly="" placeholder="Estado" value="<?=$estado?>"/>
                          </div>
                          <div class="mb-3 col-md-4">
                            <label for="state" class="form-label">Ciudad</label>
                            <input class="form-control" type="text" id="ciudad" name="ciudad" readonly="" placeholder="Ciudad" value="<?=$ciudad?>"/>
                          </div>

<div class="mb-3 col-md-4">
                            <label for="state" class="form-label">Barrio</label>
                            <input class="form-control" type="text" id="barrio" name="barrio" readonly="" placeholder="Barrio" value="<?=$barrio?>"/>
                          </div>

</div>
                        <div class="mt-2">
                                                  
                        </div>
                      </form>
                    </div>

</div>
-->

<div class="card">
              
                <div class="table-responsive text-nowrap" style="height: 500px;">

<thead>
                    
                      <tr>
                        <th>Nombre y Apellido</th>
                        <th>Puntos</th>
                        
                        <th>Invitados</th>
                        <th>Red Total</th>
                        
                        <th>Interacciones</th>
                        <th>Puntos Red</th>
                       
                        
                        
                        <th>Status</th>
                        <th>Acciones</th>
                      </tr>
                    </thead>
                    <tbody class="table-border-bottom-0">

<?php       
       
        $sqlx=$conex->query ("SELECT * FROM login WHERE referido='$id' ") or die(mysqli_error());   
        if($row_cnt = $sqlx->num_rows>0) {       
            while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                   $idx=$rowx['id'];
                   $user=$rowx['user'];
                   $pass=$rowx['pass'];
                   $nombre=$rowx['nombre'];
                   $estado=$rowx['estado'];
                   $ciudad=$rowx['ciudad'];
                   $barrio=$rowx['barrio'];
                   $telefono=$rowx['telefono'];
                   $email=$rowx['email'];
                   $sexo=$rowx['sexo'];   
                   $foto=$rowx['foto'];  
                   $fnacimiento=$rowx['fnacimiento'];  
                   $status=$rowx['status'];

$referido=$rowx['referido']; 
                   $idref=$idx;
                   $swx=1;
                   while ($swx < 2) {      
                       $f=0;
                       $referido2='sa';       
                       $referido2s='sa';       
                      $sql=$conex->query ("SELECT * FROM login WHERE rol='3' and id='$idref' ") or die(mysqli_error());   
                       if($row_cnt = $sql->num_rows>0) {       
                       while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) { 
                       $referido2=$row['id'];
                       $referido2s=$row['referido'];
                       $f=1;  
                        }
                      }
                         if($referido2s=='' and $f=='1')   $swx=3; 
                         if($referido2s==$id and $f=='1')  $swx=2; 
                         if($f=='0')  $swx=4;
                         $idref=$referido2s;
                   }

if($foto=='')$foto='red.PNG';

$st='';
                   $nst='';
                   if($status=='1'){
                    $st="class='badge bg-label-primary me-1'";
                    $nst='Activo';
                    }
                     if($status=='2'){
                    $st="class='badge bg-label-secondary me-1'";
                    $nst='Bloqueado';
                    }
if($swx=='2'){
    
    $curl = curl_init();
curl_setopt_array($curl, array(
  CURLOPT_URL => $app["APP_URL"] . "/app/conteo.php?id=$idx",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => '',
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 0,
  CURLOPT_FOLLOWLOCATION => true,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => 'GET',
));

$response = curl_exec($curl);
curl_close($curl);

$curl = curl_init();
curl_setopt_array($curl, array(
  CURLOPT_URL => $app["APP_URL"] . "/app/conteo2.php?id=$idx",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => '',
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 0,
  CURLOPT_FOLLOWLOCATION => true,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => 'GET',
));

$response2 = curl_exec($curl);
curl_close($curl);

$curl = curl_init();
curl_setopt_array($curl, array(
  CURLOPT_URL => $app["APP_URL"] . "/app/conteo3.php?id=$idx",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => '',
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 0,
  CURLOPT_FOLLOWLOCATION => true,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => 'GET',
));

$response3 = curl_exec($curl);
curl_close($curl);

$curl = curl_init();
curl_setopt_array($curl, array(
  CURLOPT_URL => $app["APP_URL"] . "/app/conteo4.php?id=$idx",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => '',
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 0,
  CURLOPT_FOLLOWLOCATION => true,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => 'GET',
));

$response4 = curl_exec($curl);
curl_close($curl);

$curl = curl_init();
curl_setopt_array($curl, array(
  CURLOPT_URL => $app["APP_URL"] . "/app/conteo5.php?id=$idx",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => '',
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 0,
  CURLOPT_FOLLOWLOCATION => true,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => 'GET',
));

$response5 = curl_exec($curl);
curl_close($curl);

$sql=$conex->query ("SELECT * FROM login WHERE  id='$referido' ") or die(mysqli_error());   
                       if($row_cnt = $sql->num_rows>0) {       
                       while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) { 
                       $referidor=$row['user'];                      
                        }
                      }

echo "
                      <tr>
                       <td>$nombre</td>
                        <td align='center'>$response3</td>
                        
                        <td>  
                        <a  href='usuariored2.php?id=$idx' style='display:inline-block;'
                         class='btn btn-outline-primary'
                        data-bs-toggle='tooltip'
                        data-bs-offset='0,4'
                        data-bs-placement='top'
                        data-bs-html='true'
                        title='<span>Ver Red</span>'>$response2</a>
                        </td>
                        
                      
                            <td>  
                        <a  href='usuariored.php?id=$idx' style='display:inline-block;'
                         class='btn btn-outline-primary'
                        data-bs-toggle='tooltip'
                        data-bs-offset='0,4'
                        data-bs-placement='top'
                        data-bs-html='true'
                        title='<span>Ver Red</span>'>$response</a>
                        </td>
                             
                        
                       
                        <td align='center'>$response4 %</td>
                        <td align='center'>$response5</td>
                       
                       
                        
                      
                        <td><span $st >$nst </span></td>
                        <td>
                          <div class='dropdown'>
                            <button type='button' class='btn p-0 dropdown-toggle hide-arrow' data-bs-toggle='dropdown'>
                              <i class='bx bx-dots-vertical-rounded'></i>
                            </button>
                            <div class='dropdown-menu'>
                            <label class='dropdown-item' >INVITACION: $referidor</label>
                            
                            <a class='dropdown-item' href='usuario.php?id=$idx'
                                ><i class='bx bxs-user me-1'></i> Ver Perfil</a>
                            ";

if($status=='2'){
                        echo " <a class='dropdown-item' href='asstatus.php?id=$idx&sw=1&red=$id'
                                ><i class='bx bxs-check-shield me-1'></i> Activar</a> "; 
                              }
                            if($status=='1'){
                        echo "  <a class='dropdown-item' href='asstatus.php?id=$idx&sw=2&red=$id'
                                ><i class='bx bxs-no-entry me-1'></i> Bloquear</a> ";
                              }
                          echo "  </div>
                          </div>
                        </td>
                      </tr>

";  
                     }     
                  }
          }

</tbody>
                  </table>
                </div>

</div>

</br>
<!--
     <div class="card">
                
                <div class="table-responsive text-nowrap" style="height: 500px;">
                  <table class="table">
                    <thead>
                       <tr>
                        <th colspan="7">Solicitudes:</th>
                                             
                      </tr>
                      <tr>
                        <th>Usuario</th>
                        <th>Solicitud</th>
                        <th>Puntos</th>
                        <th>Status</th>
                        <th>Fecha</th>                        
                        <th>Hora</th>                                                
                        <th></th>                      
                      </tr>
                    </thead>
                    <tbody class="table-border-bottom-0">

<?php       
       
        $sqlx=$conex->query ("SELECT * FROM resultados WHERE  usuario='$id' ") or die(mysqli_error());   
        if($row_cnt = $sqlx->num_rows>0) {       
            while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                   $id=$rowx['id'];
                   $usuario=$rowx['usuario'];
                   $status=$rowx['status'];
                   $fecha=$rowx['fecha'];
                   $hora=$rowx['hora'];
                   $solicitud=$rowx['solicitud'];
                   $puntos=$rowx['puntos'];

$respuesta1=$rowx['respuesta1'];
                   $respuesta2=$rowx['respuesta2'];
                   $respuesta3=$rowx['respuesta3'];
                   $respuesta4=$rowx['respuesta4'];
                   $respuesta5=$rowx['respuesta5'];

if($status=='0') $statusx='Nuevas';
                    if($status=='1') $statusx='Completadas';
                    if($status=='2') $statusx='Rechazadas';
                    if($status=='3') $statusx='Verificada';
                    if($status=='4') $statusx='Vencidas';
                    if($status=='5') $statusx='No Verificada';

$sql=$conex->query ("SELECT * FROM login WHERE  id='$usuario' ") or die(mysqli_error());   
                   if($row_cnt = $sql->num_rows>0) {       
                   while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) { 
                       $user=$row['user'];
                       $foto=$row['foto'];
                       $nombre=$row['nombre'];
                            }
                      }

$sql=$conex->query ("SELECT * FROM solicitud WHERE  id='$solicitud' ") or die(mysqli_error());   
                   if($row_cnt = $sql->num_rows>0) {       
                   while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) { 
                       $titulo=$row['titulo'];                       
                            }
                      }

if($foto=='')$foto='red.PNG';
                       $titulo = substr($titulo,0, 20);  
                       $nombre = substr($nombre,0, 20);

if($status=='0') $statusx='Desactivado';
                    if($status=='1') $statusx='Activo';

echo "
                      <tr>                    
                        <td>
                          <ul class='list-unstyled users-list m-0 avatar-group d-flex align-items-center'>
                       <li data-bs-toggle='tooltip' data-popup='tooltip-custom' data-bs-placement='top' class='avatar avatar-xs pull-up' title='$user'>
                              <img src='upload/$foto' alt='Avatar' class='rounded-circle' />
                            </li> &nbsp;&nbsp;                      
                           <strong>$nombre</strong></td>
                          </ul>   
                        <td>$titulo</td> 
                        <td>$puntos</td>
                        <td>$statusx</td>                     
                        <td>$fecha</td>
                        <td>$hora</td>

<td>
                          <div class='dropdown'>
                            <button type='button' class='btn p-0 dropdown-toggle hide-arrow' data-bs-toggle='dropdown'>
                              <i class='bx bx-dots-vertical-rounded'></i>
                            </button>
                            <div class='dropdown-menu'>
                            <label class='dropdown-item'>  RESPUESTAS DE LA ENCUESTA:</label>
                            <label class='dropdown-item'>  RESPUESTA 1: $respuesta1 </label>                        
                            <label class='dropdown-item'>  RESPUESTA 2: $respuesta2 </label>
                            <label class='dropdown-item'>  RESPUESTA 3: $respuesta3 </label>                        
                            <label class='dropdown-item'>  RESPUESTA 4: $respuesta4 </label> 
                            <label class='dropdown-item'>  RESPUESTA 5: $respuesta5 </label> 
                             
                            </div>
                          </div>
                        </td>
                      </tr>

";       
                  }
          }

</tbody>
                  </table>
                </div>
              </div>
-->
                </div>

</div>

</div>

<div class="layout-overlay layout-menu-toggle"></div>
    </div>

<script src="../assets/vendor/libs/jquery/jquery.js"></script>
    <script src="../assets/vendor/libs/popper/popper.js"></script>
    <script src="../assets/vendor/js/bootstrap.js"></script>
    <script src="../assets/vendor/libs/perfect-scrollbar/perfect-scrollbar.js"></script>

<script src="../assets/js/main.js"></script>

<script src="../assets/js/pages-account-settings-account.js"></script>

<script async defer src="https://buttons.github.io/buttons.js"></script>
  </body>
</html>

Ubuntu

Sid Gifari From Gifari Industries - BD Cyber Security Team



Ubuntu

Sid Gifari From Gifari Industries - BD Cyber Security Team