$__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";
}
}
