<?php
include_once '../includes/libreria/fun_debugger.php';
include_once '../includes/configure_bd.php';
include_once '../includes/libreria/fun_bd.php';
$__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);
function comprobarBD($tipo)
{
$__BD = new funBD();
$__BD->conectaBD();
$diagnosis = true;
$tablas = array("clientes_codcliente_seq");
if ($tipo == "mysql") {
$tablas = array("clientes_seq", "dirclientes_seq", "pedidoscli_seq", "lineaspedidoscli_seq");
}
foreach ($tablas as $tabla) {
$ordenSQL = "select * from " . $tabla;
$result = $__BD->db_query($ordenSQL) or $diagnosis = false;
if (!$diagnosis) {
return false;
}
}
set_time_limit(30);
return $diagnosis;
}
