include("../include/db.phtml");
include("../include/dbconn.phtml");
include("../include/header.phtml");
if($ca) { $var_sitio="$sitio$se$ca"; } else { $var_sitio="$sitio"; }
If(($se==251)){
header('HTTP/1.1 301 Moved Permanently');
header('location: http://legionariosdecristo.org/sumate/');
exit();
}
$sqlmax="SELECT L.* FROM LIGA_T L,REL_LIGA_MAPEO_T RLM WHERE RLM.REL_LIGA_ID=L.LIGA_ID ".
" AND RLM.REL_MAPEO_ID LIKE '$var_sitio%'";
if($pais != "") { $sqlmax.=" AND L.PAIS = '$pais' "; }
if($seccion != "") { $sqlmax.=" AND L.SECCION_ID = '$seccion' "; }
$result_max_ligas=mysql_query($sqlmax,$db);
$total_noticias=@mysql_num_rows($result_max_ligas);
$tot_articulos = $total_noticias;
if(!$fr){
$fr=0;
}
if(!$artxpag){
$artxpag=10;
}
$to=$fr+$artxpag;
$sql="SELECT L.*,replace(L.URL,'http://','') AS LIGASINHTTP FROM LIGA_T L,REL_LIGA_MAPEO_T RLM ";
$sql.=" WHERE RLM.REL_LIGA_ID=L.LIGA_ID ";
if($pais != "") { $sql.=" AND L.PAIS = '$pais' "; }
if($seccion != "") { $sql.=" AND L.SECCION_ID = '$seccion' "; }
$sql.=" AND RLM.REL_MAPEO_ID LIKE '$var_sitio%' ORDER BY ORDEN LIMIT $fr,$artxpag";
$result_ligas=mysql_query($sql,$db);
$bgcolor_liga="#F2F0EB";
?>
include("../include/table_top.phtml"); ?> |
include("../include/table_left.phtml"); ?> |
|
 |
|
Enlaces recomendados |
|
|
include("../include/filtro_enlaces.phtml");
?> |
|
$i=0;
while($myrowliga=mysql_fetch_array($result_ligas)){
$i=$i + 1;
$sql="SELECT I.* FROM REL_LIGA_IMAGEN_T RLI, IMAGENES_T I WHERE RLI.REL_LIGA='$myrowliga[LIGA_ID]' AND ".
"RLI.REL_IMAGEN=I.IMAGEN_ID";
$result_imagen=mysql_query($sql);
$sql="SELECT NACIONALIDAD_ESP FROM NACIONALIDAD_T WHERE NACIONALIDAD_ID='$myrowliga[PAIS]'";
$result_p=mysql_query($sql);
$my_row_p=mysql_fetch_array($result_p);
$tit_pais=$my_row_p[NACIONALIDAD_ESP];
if($tit_pais=="") {$tit_pais="Internacional";
$pai_id = "";}
else {$pai_id = $myrowliga[PAIS];}
$sql="SELECT DESCRIPCION FROM SECCION_T WHERE SECCION_ID='$myrowliga[SECCION_ID]'";
$result_s=mysql_query($sql);
$my_row_s=mysql_fetch_array($result_s);
$tit_seccion=$my_row_s[DESCRIPCION];
if($i!=1){?>
 |
|
 |
}else{?>
 |
|
|
}?>
if(mysql_num_rows($result_imagen)){
$my_row_imagen=mysql_fetch_array($result_imagen);
$img_array=getimagesize($my_row_imagen["URL_IMAGEN"]);
list($ancho, $altura, $tipoimg, $atr) = getimagesize("$my_row_imagen[URL_IMAGEN]");
if($ancho>130)
{
$ancho_foto=130;
$proporcion=($ancho_foto * 100)/$ancho;
$altura_foto=ceil(($altura*$proporcion)/100);
}else{
$ancho_foto=$ancho;
$altura_foto=$altura;
}
?>
" target="_blank"> " border="0" style="border: 1px #E3E1D2 solid;" vspace="0" width="" heigth="" />
}else{?>
}?> |
|
|
} // WHILE?>
|
|
|
|
|
|
|
|
|
|
include("../include/copyright.phtml"); ?> |
|
include("../include/footer.phtml");
include("../include/dbclose.phtml");
?>