Viewing file:  resta.php (7.22 KB) -rw-rw-rw-
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Restauración Ecológica en el D.C.</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body link="#339900" vlink="#339900" alink="#339900" topmargin="0">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="128"><img src="resta/1.gif" width="141" height="98"></td>
<td align="left"><img src="resta/2.gif" width="612" height="98"></td>
</tr>
<tr>
<td width="128" valign="top" background="resta/f.gif" bgcolor="#FCF5C7"> <p><img src="resta/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"><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=10"
. " 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> <table width="100%" border="0" cellspacing="0" cellpadding="4">
<tr>
<td width="250" valign="top"> <p><img src="resta/3.gif" width="124" height="39"><br>
<font color="#339900" size="1" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $dya; ?>/<?php echo $mp; ?>/<?php echo $ap; ?></font><font face="Verdana, Arial, Helvetica, sans-serif"><br>
<font size="4"><strong><?php echo $titularacc1; ?></strong></font><br>
<font color="#666666" size="2"><?php echo $descriacc1; ?></font></font></p>
<p><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><font color="#339900"><a href="#">
</a></font><img src="resta/5.gif" width="8" height="12">
<font color="#FF9900"><a href="requirenew3.php?id=<?php echo $idacc1; ?>">Ver
la historia completa...</a></font></font></p>
</td>
<td valign="top">
<div align="right">
<p align="center"><img src="resta/foto.gif" width="220" height="248" border="1"></p>
<p align="left"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="resta/5.gif" width="8" height="12">
<?php echo $resto; ?>...</font></p>
</div></td>
</tr>
</table></td>
<?php }} ?>
</tr>
</table></td>
<td> </td>
</tr>
<tr>
<td width="600"><table width="100%" border="0" cellspacing="0" cellpadding="6">
<tr>
<td width="50%" valign="top">
<table width="100%" border="1" cellpadding="4" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td bordercolor="#FFFFFF">
<div align="left"><img src="incegra/6.gif" width="232" height="29"></div></td>
</tr>
<tr>
<?php
include('conect/conect.php');
$consul = "SELECT *
FROM links where temas_id like '%$patron%' and perfil=1"
. " order by fecha DESC,mes DESC,dis DESC,priority DESC,nombre limit 0,1";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
$myrow = mysql_fetch_array($result);
$tid = $myrow["id"];
$tnombre = $myrow["nombre"];
$tdescripcion = $myrow["descripcion"];
$tlink = $myrow["link"];
$tfecha = $myrow["fecha"];
$tmes = $myrow["mes"];
$tdia = $myrow["dis"];
$tdescripcion = str_replace("\n", "<br>", $tdescripcion);
$fecha = $tdia . "/" . $tmes . "/" . $tfecha;
?>
<td bordercolor="#CCCCCC">
<?php if($num_filas != 0) { ?>
<p><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="resta/5.gif" width="8" height="12">
<strong><?php echo $tnombre; ?></strong><br>
<?php echo $tdescripcion; ?><br>
</font></p>
<?php } ?>
</td>
</tr>
</table> </td>
<td width="50%" valign="top">
<table width="100%" border="1" cellpadding="4" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td><img src="incegra/7.gif" width="232" height="29"></td>
</tr>
<tr>
<td bordercolor="#CCCCCC"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="resta/5.gif" width="8" height="12">
Más Información del Programa de Restauración
Ecológica: <a href="mailto:restauracion@dama.gov.co"><font color="#339900">restauracion@dama.gov.co</font></a>,
<br>
Sandra Montoya</font></td>
</tr>
</table></td>
</tr>
</table></td>
<td> </td>
</tr>
</table></td>
</tr>
<tr>
<td width="128" valign="top" background="resta/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-2004, Bogotá,
Colombia. </font></td>
</tr>
</table>
</body>
</html>
|