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'])) {