{"id":3353,"date":"2026-02-09T01:34:47","date_gmt":"2026-02-08T23:34:47","guid":{"rendered":"https:\/\/www.sinetiqueta.com\/?p=3353"},"modified":"2026-02-09T01:38:20","modified_gmt":"2026-02-08T23:38:20","slug":"mini-cpanel-mejora-dashboard-red-y-accesos-profesionales-en-desarrollo","status":"publish","type":"post","link":"https:\/\/www.sinetiqueta.com\/?p=3353","title":{"rendered":"🟢 Mini CPanel \u2013 Mejora: Dashboard, Red y Accesos Profesionales (EN DESARROLLO)"},"content":{"rendered":"\n

Continuaci\u00f3n de: Mini CPanel Profesional \u2013 Procedimiento Completo para Raspberry Pi 3B<\/strong><\/p>\n\n\n\n

En este art\u00edculo vamos a mejorar nuestro Mini CPanel, haci\u00e9ndolo m\u00e1s profesional, visual y funcional<\/strong>. Esto incluye la configuraci\u00f3n de red, accesos r\u00e1pidos a herramientas, logs, y un dashboard con estad\u00edsticas de servidor.<\/p>\n\n\n\n

🔹 \u00cdndice de mejoras de este art\u00edculo<\/h2>\n\n\n\n
    \n
  1. Dashboard principal<\/strong>\n
      \n
    • Visualizaci\u00f3n de IP, MAC, estado de la red<\/li>\n\n\n\n
    • Estad\u00edsticas de servidor (CPU, memoria, almacenamiento, n\u00famero de archivos, conexiones activas)<\/li>\n\n\n\n
    • Graficar tr\u00e1fico de red (solo al abrir el dashboard)<\/li>\n\n\n\n
    • Dashboard secundario<\/strong>\n
        \n
      • Registro de LOGs de conexiones descargable por fechas y auto borrado.<\/li>\n\n\n\n
      • Geolocalizaci\u00f3n de IPs<\/li>\n\n\n\n
      • Lista de puertos abiertos<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n
      • Botones de acceso r\u00e1pido<\/strong>\n
          \n
        • FileBrowser<\/li>\n\n\n\n
        • phpMyAdmin<\/li>\n\n\n\n
        • Personalizaci\u00f3n con iconos adaptativos (logo de la app)<\/li>\n<\/ul>\n<\/li>\n\n\n\n
        • Logs de actividad<\/strong>\n
            \n
          • Inicio de sesi\u00f3n<\/li>\n\n\n\n
          • Acciones del panel (reinicio PHP, ajustes, backups)<\/li>\n\n\n\n
          • Auto-borrado a 60 d\u00edas<\/li>\n\n\n\n
          • Opci\u00f3n de borrado manual con confirmaci\u00f3n<\/li>\n<\/ul>\n<\/li>\n\n\n\n
          • Configuraci\u00f3n de red<\/strong>\n
              \n
            • Consultar IP, MAC, DNS y Gateway<\/li>\n\n\n\n
            • Test de conectividad (ping y nslookup)<\/li>\n\n\n\n
            • Interfaces activas y estad\u00edsticas de tr\u00e1fico<\/li>\n\n\n\n
            • N\u00famero de conexiones activas y por IP<\/li>\n<\/ul>\n<\/li>\n\n\n\n
            • Acciones r\u00e1pidas de red<\/strong>\n
                \n
              • Reinicio de interfaces<\/li>\n\n\n\n
              • Cambio de IP est\u00e1tica\/din\u00e1mica<\/li>\n\n\n\n
              • Configuraci\u00f3n WiFi<\/li>\n\n\n\n
              • Escaneo r\u00e1pido de LAN<\/li>\n<\/ul>\n<\/li>\n\n\n\n
              • Seguridad y buenas pr\u00e1cticas<\/strong>\n
                  \n
                • Acceso solo LAN<\/li>\n\n\n\n
                • HTTPS opcional con certificado self-signed<\/li>\n\n\n\n
                • Ejecuci\u00f3n de scripts con sudo seguro<\/li>\n\n\n\n
                • Usuario admin separado<\/li>\n<\/ul>\n<\/li>\n\n\n\n
                • Est\u00e9tica y UX<\/strong>\n
                    \n
                  • Tipograf\u00eda profesional y colores claros<\/li>\n\n\n\n
                  • Panel responsivo con tarjetas, tablas e iconos<\/li>\n\n\n\n
                  • Logo adaptable al tama\u00f1o para no interferir en la visualizaci\u00f3n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n
                    \n\n\n\n

                    🟢 Mini CPanel \u2013 Punto 1: Dashboard Principal<\/h1>\n\n\n\n

                    Objetivo:<\/strong> Crear un dashboard visual que muestre solo cuando se accede, informaci\u00f3n relevante como:<\/p>\n\n\n\n

                      \n
                    • IP y MAC de la Raspberry Pi<\/li>\n\n\n\n
                    • Gateway y DNS<\/li>\n\n\n\n
                    • Uso de CPU, RAM y almacenamiento<\/li>\n\n\n\n
                    • N\u00famero de archivos en \/var\/www\/apps<\/code><\/li>\n\n\n\n
                    • Conexiones activas por IP<\/li>\n\n\n\n
                    • Gr\u00e1fico de tr\u00e1fico de red (opcional con Chart.js)<\/li>\n<\/ul>\n\n\n\n
                      \n\n\n\n

                      1️⃣ Crear directorios para el dashboard<\/h2>\n\n\n\n

                      Primero asegur\u00e9monos de que existan los directorios donde guardaremos los assets (CSS, JS, im\u00e1genes):<\/p>\n\n\n\n

                      sudo mkdir -p \/var\/www\/html\/assets\/css
                      \nsudo mkdir -p \/var\/www\/html\/assets\/js
                      \nsudo mkdir -p \/var\/www\/html\/assets\/img
                      \nsudo chown -R www-data:www-data \/var\/www\/html\/assets
                      \nsudo chmod -R 755 \/var\/www\/html\/assets<\/code><\/pre>\n\n\n\n
                      \n\n\n\n
                      1️⃣ Modificar el ADMIN.php<\/p>\n\n\n\n
                      <?php
                      session_start();
                      $secret_pass = \"PASSWORD\";

                      \/* ========= LOGIN ========= *\/
                      if (isset($_POST['password'])) {
                          if (hash_equals($secret_pass, $_POST['password'])) {
                              $_SESSION['auth'] = true;
                          } else { $error = \"Contrase\u00f1a incorrecta\"; }
                      }

                      if (!isset($_SESSION['auth'])):
                      ?>
                      <!DOCTYPE html>
                      <html lang=\"es\">
                      <head>
                      <meta charset=\"utf-8\">
                      <title>Login<\/title>
                      <link rel=\"icon\" type=\"image\/png\" href=\"assets\/img\/logo.png\">
                      <style>
                      body{background:#0f172a;color:#e5e7eb;font-family:sans-serif;display:flex;justify-content:center;align-items:center;height:100vh;margin:0}
                      .login{background:#1e293b;padding:30px;border-radius:12px;width:90%;max-width:400px;text-align:center}
                      \/* Estilo para el logo en login *\/
                      .login-logo{width:80px;height:auto;margin-bottom:20px}
                      input,button{width:100%;padding:12px;margin-top:10px;border-radius:8px;border:none;box-sizing:border-box}
                      button{background:#3b82f6;color:#fff;font-weight:bold;cursor:pointer}
                      <\/style>
                      <\/head>
                      <body>
                      <div class=\"login\">
                          <img src=\"assets\/img\/logo.png\" alt=\"Logo\" class=\"login-logo\">
                          <form method=\"post\">
                              <input type=\"password\" name=\"password\" placeholder=\"Contrase\u00f1a\" autofocus>
                              <button type=\"submit\">Entrar<\/button>
                              <?php if(isset($error)) echo \"<p style='color:#ef4444;margin-top:15px'>$error<\/p>\"; ?>
                          <\/form>
                      <\/div>
                      <\/body>
                      <\/html>
                      <?php exit; endif; ?>

                      <?php
                      \/* ========= CONFIG & INTERFACE ========= *\/
                      if(isset($_GET['set_iface'])) $_SESSION['iface'] = $_GET['set_iface'];
                      $active_iface = $_SESSION['iface'] ?? 'eth0';

                      $netFile = \"\/tmp\/admin_net_prev.json\";
                      $scriptPath = \"\/var\/www\/apps\/admin-scripts\/\";

                      \/* ========= TERMINAL ========= *\/
                      if (!isset($_SESSION['terminal'])) $_SESSION['terminal'] = [];
                      function logTerm($type,$msg){
                          $_SESSION['terminal'][]=['t'=>date(\"Y-m-d H:i:s\"),'type'=>$type,'msg'=>trim($msg)];
                          if(count($_SESSION['terminal'])>300) $_SESSION['terminal']=array_slice($_SESSION['terminal'],-300);
                      }

                      \/* ========= ACTION AJAX ========= *\/
                      if(isset($_GET['action'])){
                          header(\"Content-Type: application\/json\");
                          if($_GET['action']==='run'){
                              $cmd = $_GET['cmd'] ?? '';
                              $map = ['reiniciar_php'=>'reiniciar-php.sh','permisos'=>'ajustar-permisos.sh','backup'=>'backup.sh'];
                              if(isset($map[$cmd])){
                                  $fullPath = $scriptPath . $map[$cmd];
                                  if(file_exists($fullPath)){
                                      $out = shell_exec(\"sudo -n $fullPath 2>&1 < \/dev\/null\");
                                      logTerm('ok', $out ?: 'OK');
                                  } else { logTerm('err', \"No existe: $fullPath\"); }
                                  echo json_encode(['ok'=>true]);
                              }
                              exit;
                          }
                          if($_GET['action']==='clear_term'){ $_SESSION['terminal']=[]; echo json_encode(['ok'=>true]); exit; }
                      }

                      \/* ========= SISTEMA ========= *\/
                      function cpu(){ return round(floatval(shell_exec(\"top -bn1 | awk '\/Cpu\/ {print 100-$8}'\")),1); }
                      function mem(){ return round(floatval(shell_exec(\"free | awk '\/Mem:\/ {print $3\/$2*100}'\")),1); }
                      function disk(){ return intval(shell_exec(\"df \/ | awk 'NR==2{gsub(\/%\/,\\\"\\\",$5);print $5}'\")); }
                      function temp(){ return round(@file_get_contents(\"\/sys\/class\/thermal\/thermal_zone0\/temp\")\/1000,1); }

                      \/* ========= RED AVANZADA ========= *\/
                      function get_network_details($i) {
                          $ip = trim(shell_exec(\"ip -4 addr show $i | awk '\/inet \/{print $2}' | cut -d\/ -f1\"));
                          $mask = trim(shell_exec(\"ip -4 addr show $i | awk '\/inet \/{print $2}' | cut -d\/ -f2\"));
                          $mac = trim(@file_get_contents(\"\/sys\/class\/net\/$i\/address\"));
                          $gateway = trim(shell_exec(\"ip route | grep default | awk '{print $3}'\"));
                          $dns = trim(shell_exec(\"grep nameserver \/etc\/resolv.conf | awk '{print $2}' | head -n 1\"));
                          $state = trim(@file_get_contents(\"\/sys\/class\/net\/$i\/operstate\"));
                          $public_ip = trim(@shell_exec(\"curl -s --max-time 2 https:\/\/api.ipify.org\") ?: '-');

                          return [
                              'interface' => $i,
                              'ip' => $ip ?: 'Desconectado',
                              'mask' => $mask ?: '-',
                              'mac' => $mac ?: '-',
                              'gateway' => $gateway ?: '-',
                              'dns' => $dns ?: '-',
                              'state' => $state ?: 'unknown',
                              'public' => $public_ip ?: '-',
                              'rx' => intval(@file_get_contents(\"\/sys\/class\/net\/$i\/statistics\/rx_bytes\")),
                              'tx' => intval(@file_get_contents(\"\/sys\/class\/net\/$i\/statistics\/tx_bytes\"))
                          ];
                      }

                      \/* ========= JSON ========= *\/
                      if(isset($_GET['json'])){
                          header(\"Content-Type: application\/json\");
                          $prev = file_exists($netFile) ? json_decode(file_get_contents($netFile),true) : [];
                          $net = get_network_details($active_iface);
                          
                          $rx_speed = isset($prev[$active_iface.'_rx']) ? ($net['rx']-$prev[$active_iface.'_rx'])\/1024 : 0;
                          $tx_speed = isset($prev[$active_iface.'_tx']) ? ($net['tx']-$prev[$active_iface.'_tx'])\/1024 : 0;
                          
                          $raw_conns = shell_exec(\"ss -tun | awk 'NR>1 {print $1, $6}'\");
                          $ip_counts = [];
                          if($raw_conns){
                              foreach(explode(\"\\n\", trim($raw_conns)) as $line){
                                  $cols = preg_split('\/\\s+\/', trim($line)); if(count($cols) < 2) continue;
                                  $remote_full = $cols[1];
                                  $parts = explode(':', $remote_full); array_pop($parts); 
                                  $ip = str_replace(['[',']'], '', implode(':', $parts));
                                  if($ip == \"127.0.0.1\" || $ip == \"::1\" || empty($ip) || $ip == \"*\" || $ip == \"0.0.0.0\") continue;
                                  $state = ($cols[0] == \"ESTAB\" ? 'ok' : 'err');
                                  if(!isset($ip_counts[$ip])) $ip_counts[$ip] = ['count'=>0, 'state'=>$state];
                                  $ip_counts[$ip]['count']++;
                              }
                          }

                          $prev[$active_iface.'_rx'] = $net['rx']; $prev[$active_iface.'_tx'] = $net['tx'];
                          file_put_contents($netFile,json_encode($prev));

                          echo json_encode([
                              'cpu'=>cpu(), 'mem'=>mem(), 'disk'=>disk(), 'temp'=>temp(),
                              'lan'=>$net, 'speed_rx'=>round(max(0,$rx_speed),1), 'speed_tx'=>round(max(0,$tx_speed),1),
                              'ips'=>$ip_counts, 'total_conns'=>count($ip_counts), 'term'=>$_SESSION['terminal']
                          ]);
                          exit;
                      }
                      $local_ip = $_SERVER['SERVER_ADDR'] ?? '127.0.0.1';
                      ?>
                      <!DOCTYPE html>
                      <html lang=\"es\">
                      <head>
                      <meta charset=\"utf-8\">
                      <title>Admin Dashboard<\/title>
                      <link rel=\"icon\" type=\"image\/png\" href=\"assets\/img\/logo.png\">
                      <script src=\"assets\/js\/chart.umd.min.js\"><\/script>
                      <style>
                      body{background:#0f172a;color:#e5e7eb;font-family:system-ui;margin:0;padding:20px}
                      .top-actions{display:flex;gap:10px;justify-content:center;flex-wrap:wrap;margin-bottom:15px}
                      .top-actions button,.top-actions a{background:#1e293b;color:#fff;border:none;padding:10px 18px;border-radius:8px;cursor:pointer;text-decoration:none;font-weight:bold}
                      .card{background:#1e293b;padding:20px;border-radius:12px;margin-bottom:20px}
                      .chart-box{height:250px}
                      .net-grid{display:grid;grid-template-columns:repeat(auto-fit, minmax(130px, 1fr));gap:10px;font-size:11px;color:#94a3b8;margin-bottom:15px;padding-bottom:10px;border-bottom:1px solid #334155}
                      .net-grid b{color:#facc15;display:block;font-size:9px;text-transform:uppercase}
                      .terminal{background:#020617;border-radius:12px;padding:10px;margin-bottom:15px;border:2px solid #facc15}
                      .term-log{height:15em;overflow:auto;font-family:monospace;font-size:12px}
                      .cmd{color:#38bdf8} .ok{color:#22c55e} .err{color:#ef4444}
                      .refresh-control{display:flex;gap:15px;align-items:center;margin-bottom:15px;color:#facc15;font-size:13px}
                      .ip-list{display:flex;flex-wrap:wrap;gap:5px;margin-top:10px}
                      .ip-tag{padding:2px 6px;border-radius:4px;background:#0f172a;font-family:monospace;font-size:11px;border:1px solid transparent;display:inline-block}
                      .ip-tag.ok{border-color:#22c55e} .ip-tag.err{border-color:#ef4444}
                      select{background:#1e293b;color:#facc15;border:1px solid #facc15;padding:4px;border-radius:4px;cursor:pointer}
                      <\/style>
                      <\/head>
                      <body>

                      <div class=\"terminal\">
                          <b>📟 Terminal de Eventos<\/b>
                          <button onclick=\"clearTerm()\" style=\"float:right;background:#facc15;border:none;padding:2px 8px;border-radius:4px;cursor:pointer;color:#000;font-weight:bold\">Limpiar<\/button>
                          <div class=\"term-log\" id=\"term\"><\/div>
                      <\/div>

                      <div class=\"top-actions\">
                          <a href=\"adminplus.php\" class=\"btn-auditoria\" style=\"background:#1e293b;color:#fff;border:none;padding:10px 18px;border-radius:8px;text-decoration:none;font-weight:bold\">🛡️ Auditor\u00eda LAN<\/a>
                          <button onclick=\"runCmd('reiniciar_php')\">🔁 PHP<\/button>
                          <button onclick=\"runCmd('permisos')\">🔐 Permisos<\/button>
                          <button onclick=\"runCmd('backup')\">📦 Backup<\/button>
                          <a href=\"http:\/\/<?= $local_ip ?>\/phpmyadmin\" target=\"_blank\">🖥️ phpMyAdmin<\/a>
                          <a href=\"http:\/\/<?= $local_ip ?>:8080\" target=\"_blank\">📁 FileBrowser<\/a>
                      <\/div>

                      <div class=\"refresh-control\">
                          <span><b>Refresco:<\/b> <input type=\"range\" min=\"100\" max=\"5000\" step=\"100\" value=\"1000\" id=\"refreshDial\"> <span id=\"refreshVal\">1000ms<\/span><\/span>
                          <button id=\"togglePauseBtn\" style=\"background:none;border:1px solid #facc15;color:#facc15;padding:2px 8px;border-radius:4px;cursor:pointer\">⏯️ Pausar<\/button>
                          <span><b>Interfaz:<\/b> 
                              <select id=\"ifaceSelect\" onchange=\"location.href='?set_iface='+this.value\">
                                  <option value=\"eth0\" <?= $active_iface=='eth0'?'selected':'' ?>>eth0 (Cable)<\/option>
                                  <option value=\"wlan0\" <?= $active_iface=='wlan0'?'selected':'' ?>>wlan0 (WiFi)<\/option>
                              <\/select>
                          <\/span>
                      <\/div>

                      <div class=\"card\">
                          <h3 style=\"margin-top:0\">📊 Carga de Sistema<\/h3>
                          <div class=\"chart-box\"><canvas id=\"sysChart\"><\/canvas><\/div>
                      <\/div>

                      <div class=\"card\">
                          <h3 style=\"margin-top:0\">🌐 Tr\u00e1fico de Red y LAN<\/h3>
                          <div id=\"netGrid\" class=\"net-grid\"><\/div>
                          <div class=\"chart-box\"><canvas id=\"lanChart\"><\/canvas><\/div>
                          <h4>🔌 Clientes Conectados (\u00danicos): <span id=\"connTotal\" style=\"color:#facc15\">0<\/span><\/h4>
                          <div id=\"ipMonitor\" class=\"ip-list\"><\/div>
                      <\/div>

                      <script>
                      let paused = false, refreshMs = 1000, timer = null;
                      const yellowAxis = { ticks:{color:'#facc15', font:{size:10}}, grid:{color:'rgba(250,204,21,0.05)'} };
                      const chartOpts = { borderWidth: 1.0, pointRadius: 1, tension: 0.3 };

                      const sysChart = new Chart(document.getElementById('sysChart'),{
                          type:'line',
                          data:{labels:[],datasets:[
                              {label:'CPU %',data:[],borderColor:'#3b82f6', ...chartOpts},
                              {label:'MEM %',data:[],borderColor:'#10b981', ...chartOpts},
                              {label:'DISK %',data:[],borderColor:'#f59e0b', ...chartOpts},
                              {label:'TEMP \u00b0C',data:[],borderColor:'#ef4444', ...chartOpts}
                          ]},
                          options:{responsive:true,maintainAspectRatio:false,animation:false,scales:{x:yellowAxis,y:yellowAxis},plugins:{legend:{labels:{color:'#facc15'}}}}
                      });

                      const lanChart = new Chart(document.getElementById('lanChart'),{
                          type:'line',
                          data:{labels:[],datasets:[
                              {label:'RX KB\/s',data:[],borderColor:'#22c55e', fill:true, backgroundColor:'rgba(34,197,94,0.05)', ...chartOpts},
                              {label:'TX KB\/s',data:[],borderColor:'#3b82f6', fill:true, backgroundColor:'rgba(59,130,246,0.05)', ...chartOpts}
                          ]},
                          options:{responsive:true,maintainAspectRatio:false,animation:false,scales:{x:yellowAxis,y:yellowAxis},plugins:{legend:{labels:{color:'#facc15'}}}}
                      });

                      function runCmd(c){ fetch(`?action=run&cmd=${c}`).then(()=>update(true)); }
                      function clearTerm(){ fetch('?action=clear_term').then(()=>update(true)); }
                      function startTimer(){ timer=setInterval(update,refreshMs); }

                      document.getElementById('refreshDial').oninput=e=>{
                          refreshMs=parseInt(e.target.value); document.getElementById('refreshVal').innerText=refreshMs+'ms';
                          if(!paused){ clearInterval(timer); startTimer(); }
                      };

                      document.getElementById('togglePauseBtn').onclick=()=>{
                          paused=!paused; document.getElementById('togglePauseBtn').innerText=paused?\"▶️ Continuar\":\"⏯️ Pausar\";
                          if(paused) clearInterval(timer); else startTimer();
                      };

                      function update(force=false){
                          if(paused && !force) return;
                          fetch('?json=1').then(r=>r.json()).then(d=>{
                              let t=new Date().toLocaleTimeString();
                              sysChart.data.labels.push(t);
                              [d.cpu, d.mem, d.disk, d.temp].forEach((v,i)=>{
                                  sysChart.data.datasets[i].data.push(v);
                                  sysChart.data.datasets[i].label = sysChart.data.datasets[i].label.split(':')[0] + ': ' + v;
                                  if(sysChart.data.datasets[i].data.length>50) sysChart.data.datasets[i].data.shift();
                              });
                              if(sysChart.data.labels.length>50) sysChart.data.labels.shift();
                              sysChart.update();

                              lanChart.data.labels.push(t);
                              [d.speed_rx, d.speed_tx].forEach((v,i)=>{
                                  lanChart.data.datasets[i].data.push(v);
                                  lanChart.data.datasets[i].label = lanChart.data.datasets[i].label.split(':')[0] + ': ' + v + ' KB\/s';
                                  if(lanChart.data.datasets[i].data.length>50) lanChart.data.datasets[i].data.shift();
                              });
                              if(lanChart.data.labels.length>50) lanChart.data.labels.shift();
                              lanChart.update();

                              document.getElementById('netGrid').innerHTML = `
                                  <div><b>Interface<\/b>${d.lan.interface} (${d.lan.state})<\/div>
                                  <div><b>IP Local<\/b>${d.lan.ip}<\/div>
                                  <div><b>M\u00e1scara<\/b>\/${d.lan.mask}<\/div>
                                  <div><b>Gateway<\/b>${d.lan.gateway}<\/div>
                                  <div><b>DNS<\/b>${d.lan.dns}<\/div>
                                  <div><b>IP P\u00fablica<\/b>${d.lan.public}<\/div>
                                  <div><b>MAC<\/b>${d.lan.mac}<\/div>
                              `;
                              document.getElementById('connTotal').innerText = d.total_conns;
                              document.getElementById('ipMonitor').innerHTML = Object.entries(d.ips).map(([ip, info]) => 
                                  `<span class=\"ip-tag ${info.state}\">${ip} ${info.count > 1 ? '(x'+info.count+')' : ''}<\/span>`
                              ).join('');
                              document.getElementById('term').innerHTML = d.term.map(l=>`<div class=\"${l.type}\">[${l.t}] ${l.msg}<\/div>`).join('');
                              document.getElementById('term').scrollTop = document.getElementById('term').scrollHeight;
                          });
                      }
                      startTimer(); update(true);
                      <\/script>
                      <\/body>
                      <\/html><\/body>
                      <\/html><\/html>
                      <\/pre>\n\n\n\n
                      Dashboard Secundarario (Auditoria LAN):<\/strong><\/p>\n\n\n\n
                      <?php
                      session_start();
                      if (!isset($_SESSION['auth'])) { header(\"Location: index.php\"); exit; }

                      \/* ========= CONFIGURACI\u00d3N DE RUTAS DIN\u00c1MICAS ========= *\/
                      $logDir = \"\/var\/www\/apps\/admin-scripts\/\";
                      $currentDate = date(\"Y-m-d\");
                      \/\/ Ahora el log principal es el del d\u00eda actual
                      $logFile = $logDir . \"auditoria_\" . $currentDate . \".log\";

                      \/* ========= EXPORTACI\u00d3N CSV SELECTIVA (Mejorado) ========= *\/
                      if (isset($_GET['export_csv'])) {
                          \/\/ Si viene un archivo espec\u00edfico por GET, lo usamos; si no, el de hoy
                          $targetLog = isset($_GET['file']) ? $logDir . $_GET['file'] : $logFile;
                          
                          if (file_exists($targetLog) && strpos(basename($targetLog), 'auditoria_') === 0) {
                              header('Content-Type: text\/csv; charset=utf-8');
                              header('Content-Disposition: attachment; filename=' . str_replace('.log', '.csv', basename($targetLog)));
                              
                              $output = fopen('php:\/\/output', 'w');
                              fputcsv($output, ['Fecha y Hora', 'Descripci\u00f3n del Evento']);
                              
                              $lines = file($targetLog, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);
                              foreach ($lines as $line) {
                                  if (preg_match('\/^\\[(.*?)\\] (.*)$\/', $line, $matches)) {
                                      fputcsv($output, [$matches[1], $matches[2]]);
                                  } else {
                                      fputcsv($output, ['', $line]);
                                  }
                              }
                              fclose($output);
                              exit;
                          }
                      }

                      \/* ========= L\u00d3GICA DE ELIMINACI\u00d3N POR BLOQUES ========= *\/
                      if (isset($_GET['delete_mode'])) {
                          $mode = $_GET['delete_mode'];
                          $files = glob($logDir . \"auditoria_*.log\");
                          foreach ($files as $f) {
                              if ($mode == 'all') @unlink($f);
                              if ($mode == 'today' && strpos($f, $currentDate) !== false) @unlink($f);
                              if ($mode == 'week' && filemtime($f) < (time() - (7 * 86400))) @unlink($f);
                          }
                          header(\"Location: adminplus.php\"); exit;
                      }

                      \/* ========= FUNCIONES DE AUDITOR\u00cdA (Tus funciones originales) ========= *\/

                      function get_ip_geo($ip) {
                          if (filter_var($ip, FILTER_VALIDATE_IP, FILTER_FLAG_NO_PRIV_RANGE | FILTER_FLAG_NO_RES_RANGE)) {
                              $details = @json_decode(file_get_contents(\"http:\/\/ip-api.com\/json\/{$ip}?fields=status,country,city,isp\"), true);
                              return ($details && $details['status'] === 'success') ? \"📍 {$details['city']}, {$details['country']} ({$details['isp']})\" : \"🌐 IP P\u00fablica\";
                          }
                          return \"🏠 Red Local \/ VPN\";
                      }

                      function get_hostname($ip) {
                          $host = @gethostbyaddr($ip);
                          return ($host && $host !== $ip) ? \"🏷️ $host\" : \"❓ Desconocido\";
                      }

                      function write_audit_log($msg) {
                          global $logFile;
                          $date = date(\"Y-m-d H:i:s\");
                          if (is_writable(dirname($logFile)) || (file_exists($logFile) && is_writable($logFile))) {
                              file_put_contents($logFile, \"[$date] $msg\\n\", FILE_APPEND);
                          }
                      }

                      \/* ========= PROCESAMIENTO AJAX (Tu l\u00f3gica original) ========= *\/
                      if (isset($_GET['ajax'])) {
                          header(\"Content-Type: application\/json\");
                          
                          $raw_conns = shell_exec(\"ss -tun | awk 'NR>1 {print $6}' | sed 's\/\\[\/\/g; s\/\\]\/\/g' | cut -d: -f1 | sort -u\");
                          $geo_data = [];
                          $lines = explode(\"\\n\", trim($raw_conns));
                          
                          foreach ($lines as $ip) {
                              $ip = trim($ip);
                              if (!empty($ip) && !in_array($ip, ['127.0.0.1', '::1', '0.0.0.0', '*'])) {
                                  $geo = get_ip_geo($ip);
                                  $host = get_hostname($ip);
                                  $geo_data[$ip] = ['geo' => $geo, 'host' => $host];
                                  
                                  $type = (strpos($geo, '📍') !== false) ? \"EXTERNA\" : \"LOCAL\";
                                  write_audit_log(\"Conexi\u00f3n $type: $ip ($host)\");
                              }
                          }

                          $temp = floatval(@file_get_contents(\"\/sys\/class\/thermal\/thermal_zone0\/temp\") \/ 1000);
                          if ($temp > 75) write_audit_log(\"⚠️ CR\u00cdTICO: Temperatura CPU {$temp}\u00b0C\");

                          $disk_usage = intval(shell_exec(\"df \/ | awk 'NR==2{gsub(\/%\/,\\\"\\\",$5); print $5}'\"));
                          if ($disk_usage > 90) write_audit_log(\"⚠️ CR\u00cdTICO: Disco casi lleno ({$disk_usage}%)\");

                          echo json_encode([
                              'uptime' => shell_exec(\"uptime -p\"),
                              'cpu_detail' => shell_exec(\"ps -eo %cpu,%mem,cmd --sort=-%cpu | head -n 10\"),
                              'ports' => shell_exec(\"netstat -tulnp | awk 'NR>2 {print $4, \\\"->\\\", $7}' | sort -u\"),
                              'geo_audit' => $geo_data,
                              'logs' => file_exists($logFile) ? nl2br(htmlspecialchars(shell_exec(\"tail -n 25 $logFile\"))) : \"Sin eventos hoy.\"
                          ]);
                          exit;
                      }
                      ?>
                      <!DOCTYPE html>
                      <html lang=\"es\">
                      <head>
                          <meta charset=\"utf-8\">
                          <title>Auditor\u00eda LAN Plus<\/title>
                          <link rel=\"icon\" type=\"image\/png\" href=\"\/assets\/img\/logo.png\">
                          
                          <style>
                              body{background:#0f172a;color:#e5e7eb;font-family:system-ui;margin:0;padding:20px}
                              .grid{display:flex; flex-direction: column; gap:20px}
                              .card{background:#1e293b;padding:20px;border-radius:12px;border:1px solid #334155; width: 100%; box-sizing: border-box;}
                              .top-actions{display:flex;gap:10px;margin-bottom:20px;justify-content:space-between; align-items: center; flex-wrap: wrap}
                              .btn-group{display:flex; gap:10px; align-items: center}
                              .btn{padding:10px 18px;border-radius:8px;text-decoration:none;font-weight:bold;color:#fff;border:none;cursor:pointer; font-size: 14px}
                              .btn-blue{background:#3b82f6} .btn-red{background:#ef4444} .btn-green{background:#10b981}
                              
                              .log-box{
                                  background:#020617;
                                  padding:15px;
                                  border-radius:8px;
                                  font-family:monospace;
                                  font-size:12px;
                                  height: 32em;
                                  overflow-y: auto;
                                  border:1px solid #facc15;
                                  color:#facc15; 
                                  line-height: 1.6;
                              }

                              pre{font-size:12px;color:#38bdf8;background:#0f172a;padding:15px;border-radius:8px;overflow-x:auto; white-space: pre-wrap}
                              h3{color:#facc15;margin-top:0;display:flex;align-items:center;gap:10px;font-size:18px; border-bottom: 1px solid #334155; padding-bottom: 10px}
                              .geo-item{padding:12px;border-bottom:1px solid #334155;font-size:13px; display: flex; justify-content: space-between}
                              select{padding:10px; border-radius:8px; background:#334155; color:#fff; border:1px solid #475569}
                          <\/style>
                      <\/head>
                      <body>

                          <div class=\"top-actions\">
                              <a href=\"admin.php\" class=\"btn btn-blue\">🔙 Volver<\/a>
                              <h2 style=\"margin:0; font-size:20px\">🛡️ Auditor\u00eda Full de Pantalla<\/h2>
                              <div class=\"btn-group\">
                                  <select id=\"fileSelector\">
                                      <?php
                                      $logFiles = array_reverse(glob($logDir . \"auditoria_*.log\"));
                                      foreach($logFiles as $f) {
                                          $base = basename($f);
                                          echo \"<option value='$base'>$base<\/option>\";
                                      }
                                      ?>
                                  <\/select>
                                  <button onclick=\"downloadCSV()\" class=\"btn btn-green\">📊 Exportar<\/button>
                                  <button onclick=\"deleteLogs()\" class=\"btn btn-red\">🗑️ Limpiar<\/button>
                              <\/div>
                          <\/div>

                          <div class=\"grid\">
                              <div class=\"card\">
                                  <h3>⏱️ Historial de Eventos (D\u00eda: <?php echo $currentDate; ?>)<\/h3>
                                  <p style=\"font-size:14px; margin-bottom: 10px\"><b>Uptime:<\/b> <span id=\"uptime\">...<\/span><\/p>
                                  <div class=\"log-box\" id=\"logContent\">Cargando...<\/div>
                              <\/div>
                              
                              <div class=\"card\">
                                  <h3>🌍 Geolocalizaci\u00f3n e IPs<\/h3>
                                  <div id=\"geoList\">Buscando conexiones...<\/div>
                              <\/div>

                              <div class=\"card\">
                                  <h3>🔥 Procesos Top<\/h3>
                                  <pre id=\"procData\">...<\/pre>
                              <\/div>

                              <div class=\"card\">
                                  <h3>🚪 Servicios \/ Puertos<\/h3>
                                  <pre id=\"portData\">...<\/pre>
                              <\/div>
                          <\/div>

                          <script>
                              function downloadCSV() {
                                  const file = document.getElementById('fileSelector').value;
                                  if(file) window.location.href = `?export_csv=1&file=${file}`;
                              }

                              function deleteLogs() {
                                  const opc = prompt(\"\u00bfQu\u00e9 deseas borrar?\\n1: Solo hoy\\n2: Historial antiguo (m\u00e1s de 1 semana)\\n3: TODO el historial\\nEscribe el n\u00famero:\");
                                  if(opc == \"1\") { if(confirm(\"\u00bfBorrar log de hoy?\")) window.location.href = \"?delete_mode=today\"; }
                                  else if(opc == \"2\") { if(confirm(\"\u00bfBorrar logs de m\u00e1s de 7 d\u00edas?\")) window.location.href = \"?delete_mode=week\"; }
                                  else if(opc == \"3\") { if(confirm(\"\u00a1ALERTA! Esto borrar\u00e1 todos los registros hist\u00f3ricos. \u00bfContinuar?\")) window.location.href = \"?delete_mode=all\"; }
                              }

                              function updatePlus() {
                                  fetch('?ajax=1').then(r => r.json()).then(d => {
                                      document.getElementById('uptime').innerText = d.uptime;
                                      
                                      const logContainer = document.getElementById('logContent');
                                      logContainer.innerHTML = d.logs;
                                      logContainer.scrollTop = logContainer.scrollHeight;

                                      document.getElementById('procData').innerText = d.cpu_detail;
                                      document.getElementById('portData').innerText = d.ports;
                                      
                                      let geoHTML = '';
                                      const entries = Object.entries(d.geo_audit);
                                      if(entries.length > 0) {
                                          for (const [ip, info] of entries) {
                                              geoHTML += `<div style=\"padding:10px; border-bottom:1px solid #334155; display:flex; justify-content:space-between\">
                                                  <span><b>${ip}<\/b><br><small style=\"color:#94a3b8\">${info.host}<\/small><\/span>
                                                  <span style=\"text-align: right\">${info.geo}<\/span>
                                              <\/div>`;
                                          }
                                      } else {
                                          geoHTML = '<p style=\"padding:15px; color:#94a3b8\">Solo conexiones locales.<\/p>';
                                      }
                                      document.getElementById('geoList').innerHTML = geoHTML;
                                  });
                              }
                              setInterval(updatePlus, 3000); 
                              updatePlus();
                          <\/script>
                      <\/body>
                      <\/html><\/body>
                      <\/html><\/pre>\n\n\n\n
                      2️⃣ Crear el archivo del dashboard (pero no lo usaremos 😅)<\/h2>\n\n\n\n
                      Archivo: \/var\/www\/html\/dashboard.php<\/code> <\/p>\n\n\n\n
                      sudo nano \/var\/www\/html\/dashboard.php<\/span><\/code><\/pre>\n\n\n\n
                      <?php\nsession_start();\n$secret_pass = \"TU_PASSWORD_SEGURA\"; \/\/ Cambiar antes de producci\u00f3n\n\n\/\/ Login simple\nif(isset($_POST['password'])){\n    if($_POST['password'] === $secret_pass){\n        $_SESSION['logged_in'] = true;\n    } else {\n        $error = \"Contrase\u00f1a incorrecta\";\n    }\n}\n\nif(!isset($_SESSION['logged_in'])){\n?>\n<div class=\"login panel\">\n    <img src=\"\/assets\/img\/logo.png\" class=\"logo\" alt=\"Logo\">\n    <form method=\"POST\">\n        <input type=\"password\" name=\"password\" placeholder=\"Contrase\u00f1a\">\n        <input type=\"submit\" value=\"Entrar\">\n        <?php if(isset($error)) echo \"<p style='color:red;'>$error<\/p>\"; ?>\n    <\/form>\n<\/div>\n<?php exit; }\n\n\/\/ Funci\u00f3n para ejecutar comandos seguros\nfunction runCommand($cmd){\n    $output = shell_exec($cmd . \" 2>&1\");\n    return htmlspecialchars($output);\n}\n\n\/\/ Recolectar datos del sistema\n$ip = runCommand(\"hostname -I | awk '{print $1}'\");\n$mac = runCommand(\"cat \/sys\/class\/net\/eth0\/address\");\n$gateway = runCommand(\"ip route | grep default | awk '{print $3}'\");\n$dns = runCommand(\"systemd-resolve --status | grep 'DNS Servers' | head -n1 | awk '{print $3}'\");\n$cpu_load = runCommand(\"top -bn1 | grep 'Cpu(s)' | awk '{print $2 + $4}'\");\n$mem_usage = runCommand(\"free -m | awk 'NR==2{printf \\\"%s\/%s MB\\\", $3,$2 }'\");\n$disk_usage = runCommand(\"df -h \/ | awk 'NR==2{printf \\\"%s\/%s\\\", $3,$2 }'\");\n$file_count = runCommand(\"find \/var\/www\/apps -type f | wc -l\");\n$connections = runCommand(\"ss -tn | awk 'NR>1 {print $5}' | cut -d':' -f1 | sort | uniq -c | sort -nr\");\n?>\n<!DOCTYPE html>\n<html lang=\"es\">\n<head>\n    <meta charset=\"UTF-8\">\n    <title>Mini CPanel Dashboard<\/title>\n    <link rel=\"stylesheet\" href=\"assets\/css\/panel.css\">\n<\/head>\n<body>\n    <div class=\"panel\">\n        <img src=\"assets\/img\/logo.png\" class=\"logo\" alt=\"Logo\">\n        <h1>Mini CPanel Dashboard<\/h1>\n\n        <div class=\"cards\">\n            <div class=\"card\"><h2>IP<\/h2><p><?php echo $ip; ?><\/p><\/div>\n            <div class=\"card\"><h2>MAC<\/h2><p><?php echo $mac; ?><\/p><\/div>\n            <div class=\"card\"><h2>Gateway<\/h2><p><?php echo $gateway; ?><\/p><\/div>\n            <div class=\"card\"><h2>DNS<\/h2><p><?php echo $dns; ?><\/p><\/div>\n            <div class=\"card\"><h2>CPU %<\/h2><p><?php echo $cpu_load; ?><\/p><\/div>\n            <div class=\"card\"><h2>RAM<\/h2><p><?php echo $mem_usage; ?><\/p><\/div>\n            <div class=\"card\"><h2>Disco<\/h2><p><?php echo $disk_usage; ?><\/p><\/div>\n            <div class=\"card\"><h2>Archivos Apps<\/h2><p><?php echo $file_count; ?><\/p><\/div>\n        <\/div>\n\n        <h2>Conexiones activas<\/h2>\n        <pre style=\"text-align:left; max-height:200px; overflow:auto; background:#1e293b; padding:10px; border-radius:8px;\"><?php echo $connections; ?><\/pre>\n    <\/div>\n<\/body>\n<\/html><\/pre>\n\n\n\n
                      \n\n\n\n
                      3️⃣ Crear CSS b\u00e1sico<\/h2>\n\n\n\n
                      Archivo: \/var\/www\/html\/assets\/css\/panel.css<\/code><\/p>\n\n\n\n
                      sudo nano \/var\/www\/html\/assets\/css\/panel.css<\/span><\/code><\/pre>\n\n\n\n
                      body {\n    background: #0f172a;\n    color: #e5e7eb;\n    font-family: system-ui, -apple-system, BlinkMacSystemFont, \"Segoe UI\", sans-serif;\n    margin: 0;\n}\n\n.logo {\n    max-width: 120px;\n    height: auto;\n    margin-bottom: 20px;\n    opacity: 0.9;\n}\n\n\/* --- SEPARACI\u00d3N DE LOGIN Y PANEL --- *\/\n\n\/* El login se mantiene estrecho y centrado *\/\n.login {\n    max-width: 420px;\n    margin: 120px auto;\n    text-align: center;\n    padding: 20px;\n}\n\n\/* El panel ahora ocupar\u00e1 casi todo el ancho de la pantalla *\/\n.panel {\n    max-width: 95%; \/* Cambiado de 420px a 95% *\/\n    margin: 40px auto;\n    text-align: center;\n}\n\n\/* --- ELEMENTOS COMUNES --- *\/\n\ninput, button {\n    width: 100%;\n    padding: 12px;\n    margin-top: 10px;\n    border-radius: 8px;\n    border: none;\n    font-size: 14px;\n    box-sizing: border-box; \/* Importante para que el padding no rompa el ancho *\/\n}\n\nbutton {\n    background: #3b82f6;\n    color: white;\n    cursor: pointer;\n    font-weight: bold;\n}\n\nbutton:hover {\n    background: #2563eb;\n}\n\n\/* Estilos de los enlaces\/botones del panel *\/\n.panel a {\n    display: inline-block; \/* Cambiado de block a inline-block para que respeten el flex de arriba *\/\n    margin: 5px;\n    padding: 12px 20px;\n    background: #1e293b;\n    color: #e5e7eb;\n    text-decoration: none;\n    border-radius: 8px;\n    transition: background 0.3s;\n}\n\n.panel a:hover {\n    background: #334155;\n}<\/pre>\n\n\n\n
                      \n\n\n\n
                      🧯 ERRORES en la EJECUCI\u00d3N de los Scripts<\/strong><\/p>\n\n\n\n
                      Correcci\u00f3n de Permisos: me he encontrado que los botones que apuntan a los Scripts, no funcionan y ha ocado aplicar estas correcciones a trav\u00e9s de PuTTY:\n\n1. Normalizaci\u00f3n de Permisos de Carpeta\nPrimero, corregimos la propiedad y los permisos de acceso para que el usuario del servidor web (www-data) pudiera \"ver\" los scripts.\n\nBash\n# Cambiar el due\u00f1o de la carpeta al usuario del servidor web\nsudo chown -R www-data:www-data \/var\/www\/apps\n\n# Dar permisos de lectura y ejecuci\u00f3n a las carpetas\nsudo chmod -R 755 \/var\/www\/apps\n2. Activaci\u00f3n de Ejecuci\u00f3n de Scripts\nEste comando fue vital para que Linux permitiera que los archivos .sh funcionaran como programas y no como simples archivos de texto.\n\nBash\n# Convertir los archivos .sh en ejecutables\nsudo chmod +x \/var\/www\/apps\/admin-scripts\/*.sh\n3. Configuraci\u00f3n de Privilegios Especiales (Sudoers)\nEsta es la parte m\u00e1s sensible. Entramos al archivo de configuraci\u00f3n de seguridad de Linux para autorizar la ejecuci\u00f3n sin contrase\u00f1a.\n\nComando para entrar:\n\nBash\nsudo visudo\nL\u00edneas a\u00f1adidas al final del archivo:\n\nPlaintext\nwww-data ALL=(ALL) NOPASSWD: \/var\/www\/apps\/admin-scripts\/reiniciar-php.sh\nwww-data ALL=(ALL) NOPASSWD: \/var\/www\/apps\/admin-scripts\/ajustar-permisos.sh\nwww-data ALL=(ALL) NOPASSWD: \/var\/www\/apps\/admin-scripts\/backup.sh\n4. Resoluci\u00f3n del Error en \/tmp\nPara el script de reinicio de PHP, habilitamos el archivo \"flag\" que el sistema utiliza para comunicarse con el servicio FPM.\n\nBash\n# Crear el archivo manualmente y darle permisos de escritura universal\nsudo touch \/tmp\/restart_php_fpm.flag\nsudo chmod 666 \/tmp\/restart_php_fpm.flag<\/pre>\n\n\n\n
                      ✅ Resultado esperado<\/h2>\n\n\n\n
                      Al abrir http:\/\/IP_DE_LA_RASPI\/dashboard.php<\/code>:<\/p>\n\n\n\n