$__BD = new funBD(); $__BD->conectaBD(); // $ordenSQL = "select max(hora) from transportersql where hora <> 'NULL'"; // $hora = $__BD->db_valor($ordenSQL); // $ordenSQL = "select tabla, lineas from transportersql where hora = '$hora'"; $codigo = ''; $ordenSQL = "select * from modificadossql"; $result = $__BD->db_query($ordenSQL); $now = date("H:i:s"); while ($row = $__BD->db_fetch_assoc($result)) { $tabla = $row['tabla']; $campoClave = $row['campoclave']; $valorClave = $row['valorclave']; $valores = $row['valores']; $ordenSQL = "select {$campoClave} from {$tabla} where {$campoClave} = '{$valorClave}'"; $existe = $__BD->db_valor($ordenSQL); if (!$existe) { $ordenSQL = "insert into {$tabla} ({$campoClave}) values ('{$valorClave}')"; $__BD->db_query($ordenSQL); } $ordenSQL = "update {$tabla} set {$valores} where {$campoClave} = '{$valorClave}'"; // echo $ordenSQL; $ok = $__BD->db_query($ordenSQL); if ($ok) { $ordenSQL = "delete from modificadossql where id=" . $row["id"]; $__BD->db_query($ordenSQL); } $ok = $ok ? ' OK' : ' ERROR'; $codigo .= $tabla . ' > ' . $valorClave . ': ' . $ok . '<br/>'; // echo '<br/><br/><br/>'; flush();
if (isset($_SESSION['user_id'])) { echo '<script type="text/javascript"> <!-- window.location = "im_index.php" //--> </script>'; $message = '<a href="im_index.php">Acceso</a>'; } elseif (ctype_alnum($_POST['img_password']) != true) { $error = "Password incorrecto"; } else { include_once '../includes/configure_bd.php'; include_once '../includes/libreria/fun_bd.php'; $__BD = new funBD(); $__BD->conectaBD(); $ordenSQL = "select managerpass from opcionestv"; $managerpass = $__BD->db_valor($ordenSQL); if (!$managerpass) { $error = 'Password incorrecto'; } else { if ($managerpass == sha1($_POST['img_password'])) { $_SESSION['user_id'] = sha1(time()); echo '<script type="text/javascript"> <!-- window.location = "im_index.php" //--> </script>'; $message = '<a href="im_index.php">Acceso</a>'; } else { $error = "Password incorrecto"; } }