function dia_dma($a)
{
if (es_fecha($a)) {
$a = strtr($a, "/", "-");
$a_ok = explode("-", $a);
$fecha = getdate(mktime(0, 0, 0, $a_ok[1], $a_ok[0], $a_ok[2]));
if ($fecha['wday'] != 0) {
return $fecha['wday'];
} else {
return 7;
}
} else {
return '';
}
}
$mysql = 'select * from RUTA where ID=' . mysqli_real_escape_string($link, $ID);
} else {
// Se utilizan parámetros
if (isset($PARAMS['u']) && is_numeric($PARAMS['u'])) {
$mysql = 'select r.*,';
$mysql .= '(select f.ARCHIVO from FOTO f where f.ID_RUTA=r.ID order by f.ID LIMIT 0,1) as ARCHIVO,';
$mysql .= '(select count(*) from FOTO f where f.ID_RUTA=r.ID) as NFOTOS,';
$mysql .= '(select count(*) from COMENTARIO c where c.ID_RUTA=r.ID) as NCOMENTARIOS';
$mysql .= ' FROM RUTA r order by r.FECHA desc LIMIT 0,' . mysqli_real_escape_string($link, $PARAMS['u']);
} else {
$mysql = 'select r.*, ';
$mysql .= '(select f.ARCHIVO from FOTO f where f.ID_RUTA=r.ID order by f.ID LIMIT 0,1) as ARCHIVO, ';
$mysql .= '(select count(*) from FOTO f where f.ID_RUTA=r.ID) as NFOTOS, ';
$mysql .= '(select count(*) from COMENTARIO c where c.ID_RUTA=r.ID) as NCOMENTARIOS ';
$mysql .= 'from RUTA r where false';
if (isset($PARAMS['fi']) && isset($PARAMS['ff']) && es_fecha($PARAMS['fi'])) {
$mysql .= ' or FECHA between "' . mysqli_real_escape_string($link, $PARAMS['fi']);
$mysql .= '" and "' . mysqli_real_escape_string($link, $PARAMS['ff']) . '"';
}
if (isset($PARAMS['di']) && isset($PARAMS['df']) && is_numeric($PARAMS['di']) && is_numeric($PARAMS['df'])) {
$mysql .= ' or DISTANCIA between "' . mysqli_real_escape_string($link, $PARAMS['di']);
$mysql .= '" and "' . mysqli_real_escape_string($link, $PARAMS['df']) . '"';
}
if (isset($PARAMS['dfi']) && isset($PARAMS['dff']) && is_numeric($PARAMS['dfi']) && is_numeric($PARAMS['dff'])) {
$mysql .= ' or DIFICULTAD between ' . mysqli_real_escape_string($link, $PARAMS['dfi']);
$mysql .= ' and ' . mysqli_real_escape_string($link, $PARAMS['dff']);
}
if (isset($PARAMS['t'])) {
$mysql .= ' or NOMBRE like "%' . mysqli_real_escape_string($link, $PARAMS['t']) . '%"';
}
if (isset($PARAMS['r'])) {
