";
echo "";
echo " ";
$sorter = "p.titulo_$lang";
$i = 0;
while ($i < pg_numrows($queryregiones)) {
$getregions = pg_fetch_row($queryregiones, $i);
if (!$regionids) {
$regionids = "AND (r.regionid=$getregions[0]";
} else {
$regionids = $regionids." OR r.regionid=$getregions[0]";
}
$i++;
}
$regionids = $regionids.")";
$j = 0;
while ($f < pg_numrows($querytemas)) {
$gettemas = pg_fetch_row($querytemas, $f);
if (!$temaids) {
$temaids = "AND (t.temaid=$gettemas[0]";
} else {
$temaids = $temaids." OR t.temaid=$gettemas[0]";
}
$f++;
}
$temaids = $temaids.")";
//display all publicaciones
$tipoid = 1;
do {
include("../incluir/filepathandname.inc");
$querytipos = pg_exec($conn, "SELECT * FROM tipos WHERE tipoid>0");
$query = "select p.docid, p.titulo_$lang, p.descripcion_$lang, p.conferencia_$lang, tp.tipo_$lang, p.kb FROM principal p, regiones r, temas t, tipos tp where r.docid=p.docid and t.docid=p.docid and p.tipo=tp.tipoid $regionids $temaids AND p.tipo=$tipoid AND p.docid!=$docid order by $sorter";
$querytitles = pg_exec($conn, $query);
if (pg_numrows($querytitles) > 0) {
$gettipo = pg_fetch_row($querytitles, 0);
$row = 0;
echo "$gettipo[4] ";
if ($tipoid != 3 || $tipoid != 4) {
echo $gettitles[1];
} else {
echo $gettitles[3];
}
echo " $gettitles[5]KB";
echo "$label_descripcion:
$getdocinfo[1]";
while ($row < pg_numrows($querytitles)) {
$gettitles = pg_fetch_row($querytitles, $row);
echo "
";
}
$tipoid++;
} while ($tipoid <= pg_numrows($querytipos));
include("footer.php3");
?>
";
if ($gettitles[2]) {
echo "$gettitles[2]
";
}
$row++;
}
echo "