Viewing file:  air1.php (7.01 KB) -rw-rw-rw-
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Red de la Calidad del Aire para Bogotá</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body link="#003366" vlink="#003366" alink="#003366" topmargin="0">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="128"><img src="air/1.gif" width="141" height="98"></td>
<td align="left"><img src="air/2.gif" width="612" height="98"></td>
</tr>
<tr>
<td width="128" valign="top" background="air/f.gif" bgcolor="#FCF5C7"> <p><img src="air/c.gif" width="141" height="30"><font face="Verdana, Arial, Helvetica, sans-serif">
<table width="120" border="0" cellspacing="0" cellpadding="4">
<tr>
<td colspan="2" valign="top">
<?php
include('reqcollap.php');
?>
</td>
</tr>
</table>
</font></p> </td>
<td rowspan="2" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="8">
<tr>
<td width="600" rowspan="2"><table width="100%" border="1" cellpadding="6" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<?php
require('conexion3.php');
$hora = getdate();
$yr = $hora["year"];
$mo = $hora["mon"];
$dy = $hora["mday"];
$mo = $mo * 100;
$yr = $yr - 2000;
$yr = $yr * 10000;
$fc = $mo + $yr;
$fc1 = $fc + 100;
//echo $fc;
//echo $fc1;
//$fc = $mo + $yr + $dy;
$consul = "SELECT *
FROM news where fecha<'$fc1' and cat=12"
. " order by fecha DESC";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
while ($myrow = mysql_fetch_array($result))
{
$idacc1 = $myrow["id"];
$descriacc1 = $myrow["descri"];
$catacc1 = $myrow["cat"];
$fechara = $myrow["fecha"];
$tax = $myrow["texto"];
$titularacc1 = $myrow["titular"];
$anne = $fechara / 10000;
$anne = intval($anne);
$ap = $anne + 2000;
$rf = $anne * 10000;
$fechara = $fechara - $rf;
$mun = $fechara / 100;
$mun = intval($mun);
$mp = $mun;
$rfa = $mun * 100;
$dya = $fechara - $rfa;
$frj = strlen($tax);
if ($frj > 150) {
$resto = substr ("$tax", 0, 200);
}else{
$resto = $tax;
}
$resto = str_replace("\n", "<br>", $resto);
$veri1 = 1;
if ($veri1 == 1) {
?>
<td valign="top">
<table width="550" border="1" cellpadding="6" cellspacing="0" bordercolor="#E7F5FE">
<tr>
<?php
include('conect/conect.php');
$consul = "SELECT *
FROM links where temas_id like '%$titix-%' or temas_id like '%$titix'"
. " order by priority DESC,id,nombre";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
//echo $num_filas;
$consula = "SELECT *
FROM cate where tema_id like '$titix'";
$resulta = mysql_query($consula,$db);
$num_filasa = mysql_num_rows($resulta);
$myrowa = mysql_fetch_array($resulta);
$fidel = $myrowa["tema_desc"];
?>
<td> <p><strong><font size="4" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $fidel; ?></font></strong></p>
<table width="550" border="0" cellspacing="0" cellpadding="4">
<?php
while ($myrow = mysql_fetch_array($result))
{
$lid = $myrow["id"];
$lnombre = $myrow["nombre"];
$ldescripcion = $myrow["descripcion"];
$ldescripcion = str_replace("\n", "<br>", $ldescripcion);
$ltipo_info = $myrow["tipo_info"];
$llink = $myrow["link"];
$lentidad_id = $myrow["entidad_id"];
$lgraphic = $myrow["graphic"];
$lfotolink = $myrow["foto_link"];
$lsuj_a_fecha = $myrow["suj_a_fecha"];
$lfecha = $myrow["fecha"];
$lalcance = $myrow["alcance"];
$ldis = $myrow["dis"];
$lmes = $myrow["mes"];
$ltemas_id = $myrow["temas_id"];
$bodytag = str_replace("reqpml3", "reqresta3", $llink);
?>
<tr>
<td valign="top"><font face="Verdana, Arial, Helvetica, sans-serif">
<?php
if ($lgraphic == 1) {
$sof = $lfotolink;
$br = 1;
}else{
$sof = "none.gif";
$br = 0;
}
?>
<img src="<?php echo $sof; ?>" border="<?php echo $sof; ?>"></font></td>
</tr>
<tr>
<td valign="top"> <p align="justify"><img src="cfle.gif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><strong>
<a href="<?php echo $bodytag; ?>"><?php echo $lnombre; ?></a></strong></font><br>
<font color="#666666" size="2"><?php echo $ldescripcion; ?></font></font><br>
<font size="1" face="Verdana, Arial, Helvetica, sans-serif"><font color="#339900"><a href="#">
</a></font><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<?php
if ($llink != "#") { ?>
<img src="fleg.gif" width="9" height="12"></font>
<font color="#339900"><a href="<?php echo $bodytag; ?>">Ver
el documento o ir al vinculo...</a></font>
<?php } ?>
</font></p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td valign="top"><img src="linpun.gif" width="540" height="1"></td>
</tr>
<?php } ?>
</table>
<p><img src="cfle.gif"> <font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><?php echo $num_filas; ?></strong>
Documentos o vinculos encontrados...</font><br>
<a href="mailto:sistemas@dama.gov.co"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Sistemas@dama.gov.co</font></a></p></td>
</tr>
</table>
</td>
<?php }} ?>
</tr>
</table></td>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
</table></td>
</tr>
<tr>
<td width="128" valign="top" background="air/f.gif"> </td>
</tr>
<tr>
<td width="128"><font face="Verdana, Arial, Helvetica, sans-serif">>>
</font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Todos los
Derechos Reservados para el DAMA, Departamento Técnico Administrativo
del Medio Ambiente<br>
Sistema de Información Ambiental SIA-DAMA, 1998-2006, Bogotá,
Colombia. </font></td>
</tr>
</table>
</body>
</html>
|