<?php 

$bgcolor1 = "#8080ff";
$bgcolor2 = "#FFFFFF";
$bgcolor3 = "#FFFFFF";

if (strstr($PATH_INFO, "/")) {
	$p = substr($PATH_INFO, 1);
	$e_path = explode("/", $p);
	$i = 0;
	while ($i < count($e_path)) {
		$name = $e_path[$i];
		$val = $e_path[$i+1];
		$$name = $val;
		$i = $i+2;
	}
}

if (strstr($REQUEST_URI, "/espanol/")) {
	$lang = "es";
	$dir = "espanol";
	$lenguaid = "1";
} 
if (strstr($REQUEST_URI, "/francais/")) {
	$lang = "fr";
	$dir = "francais";
	$lenguaid = "2";
} 
if (strstr($REQUEST_URI, "/english/")) {
	$lang = "en";
	$dir = "english";
	$lenguaid = "3";
} 
if (strstr($REQUEST_URI, "/texto/")) {
	$dir = "texto/".$dir;
}

$conn = pg_pconnect("dbname=sif user=mike");

$titulo = "Mapa del sitio / Plan du Site / Site Map";

include("header.php3");

	$label_menu_col1_row1 = $label_menu_a1;
	$label_menu_col1_row2 = $label_menu_a2;
	$label_menu_col1_row3 = $label_menu_a3;
	$label_menu_col1_row4 = $label_menu_a4;
	$label_menu_col1_row5 = $label_menu_a5;
	$label_menu_col2_row1 = $label_menu_b1;
	$label_menu_col2_row2 = $label_menu_b2;
	$label_menu_col2_row3 = $label_menu_b3;
	$label_menu_col2_row4 = $label_menu_b4;
	$label_menu_col2_row5 = $label_menu_b5;

	$label_menu_col1_row1_url = "editoriales.php3";
	$label_menu_col1_row2_url = "nuevo.php3";
	$label_menu_col1_row3_url = "funredesin.php3";
	$label_menu_col1_row4_url = "servicios/index.php3";
	$label_menu_col1_row5_url = "institucion/faq.php3";
	$label_menu_col2_row1_url = "buscarsql.php3";
	$label_menu_col2_row2_url = "brochure.php3";
	$label_menu_col2_row3_url = "funredeson.php3";
	$label_menu_col2_row4_url = "institucion/index.php3";
	$label_menu_col2_row5_url = "infositio/index.php3";


// descripcion por idioma

if ($lang == "es") {
	$label_titulo = "Mapa del sitio";

	$label_menu_col1_row1_desc = "Vea los asuntos actuales m&aacute;s importantes en el mundo de las Nuevas Tecnolog&iacute;as de Informaci&oacute;n y de Comunicaci&oacute;n, seg&uacute;n Funredes.";
	$label_menu_col1_row2_desc = "Con&eacute;ctese a informaci&oacute;n sobre los nuevos proyectos, investigaciones, empleados, servicios y logros de FUNREDES.";
	$label_menu_col1_row3_desc = "Un &iacute;ndice de los trabajos de Funredes por regi&oacute;n de relevancia.  ¡Use nuestro nuevo mapa interactivo!";
	$label_menu_col1_row4_desc = "Diseño de web, Cursos de Internet, Asesorias de redes, Alojamiento de Sitios, etc.";
	$label_menu_col1_row5_desc = "Preguntas frecuentes sobre nuestra instituci&oacute;n y nuestros trabajos.";
	$label_menu_col2_row1_desc = "Buscar informaci&oacute;n o un documento espec&iacute;fico en el SIF por palabra clave, o por criterios m&aacute;s avanzados.";
	$label_menu_col2_row2_desc = "El Brochure de Funredes.  Mire una lista completa de nuestras investigaciones y trabajos desde el inicio en 1993.";
	$label_menu_col2_row3_desc = "Un &iacute;ndice de los trabajos de Funredes por tema de relevancia.";
	$label_menu_col2_row4_desc = "Info de contacto, Convenios, Trabajar para FUNREDES, Brochure, Publicidades, Recursos Humanos...";
	$label_menu_col2_row5_desc = "Estadísticas:  sepa de dónde conectan a este servidor.<br>Cr&eacute;ditos, Info del servidor, Concurso de diseño.";

	$label_contact = "<a href=\"mailto:contact@funredes.org\">contact@funredes.org</a>";
	$label_contact_desc = "Cualquier pregunta a Funredes no relacionada directamente a este sitio web.";
	$label_webmaster = "<a href=\"mailto:webmaster@funredes.org\">webmaster@funredes.org</a>";
	$label_webmaster_desc = "Env&iacute;enos correo para sugerencias y comentarios sobre este sitio web.";

	$label_docint = "FAQ";
	$label_convenio = "Convenios con otras fundaciones";
	$label_trabajar = "Ofertas de empleo";
	$label_faq = "Nuestro Brochure";
	$label_contacto = "Informaci&oacute;n de contacto";
	$label_brochure = "Nuestra publicidad";
	$label_mision = "Misi&oacute;n y objetivos";
	$label_estructura = "La estructura de nuestra fundaci&oacute;n";
	$label_enlaces = "Enlaces externos";
	$label_consejo = "Estatutos e informaci&oacute;n presupuestaria";
	$label_rh = "Recursos humanos";

	$label_docint_desc = "Preguntas frecuentes sobre todos los aspectos de FUNREDES.";
	$label_convenio_desc = "La lista de los convenios y acuerdos que FUNREDES tiene con otras fundaciones y organismos.";
	$label_trabajar_desc = "¿Le interesa juntarse con nuestro equipo?  Profesionales y jovenes bienvenidos.";
	$label_faq_desc = "Mire una lista completa de nuestras investigaciones y trabajos desde el inicio en 1993.";
	$label_contacto_desc = "Ver las maneras diferentes de contactarnos por correo electr&oacute;nico, correo normal, tel&eacute;fono y fax.";
	$label_brochure_desc = "Sepa en pocas palabras las informaciones centrales de nuestra organizaci&oacute;n.  Se puede bajar esta publicidad en varios formatos.";
	$label_mision_desc = "Las frases claves de FUNREDES.";
	$label_estructura_desc = "La organizaci&oacute;n pol&iacute;tica de la fundaci&oacute;n.";
	$label_enlaces_desc = "Con&eacute;ctese a los sitios que pensamos los m&aacute;s relevantes e interesantes sobre los NTIC.";
	$label_consejo_desc = "Los estatutos de Funredes en la Rep&uacute;blica Dominicana y Francia, y perspectivas financieras.";
	$label_rh_desc = "Conozca la gente que trabaja para FUNREDES y con&eacute;ctese a sus sitios personales.";

	$label_globalnav = "Navegaci&oacute;n global (que aparece en cada p&aacute;gina)";
	$label_localnav = "Navegaci&oacute;n local (en las p&aacute;ginas de la Instituci&oacute;n)";

	$label_lista_regiones = "&Iacute;NDICE POR REGI&Oacute;N";
	$label_lista_temas = "&Iacute;NDICE POR TEMA";
	$label_noticias = "Noticias de ";

} else if ($lang == "fr") {
	$label_titulo = "Plan du site";

	$label_menu_col1_row1_desc = "Voir les sujets les plus importants actuellement dans le monde des Nouvelles Techologies d'Information et de Communication selon Funredes.";
	$label_menu_col1_row2_desc = "Connectez vous à des informations à propos des nouveaux projets, des recherches, des employés, des services et des réussites de FUNREDES.";
	$label_menu_col1_row3_desc = "Un indexe des travaux de Funredes par r&eacute;gion.  Voir notre nouvelle carte interactive!";
	$label_menu_col1_row4_desc = "Infographie, Cours Internet, Administration de réseaux, Hébergement de Sites, etc.";
	$label_menu_col1_row5_desc = "Foire aux questions au sujet de notre institution.";
	$label_menu_col2_row1_desc = "Rechercher de l’information ou un document spécifique dans le SIF par mot clef, ou par des critères plus avancés.";
	$label_menu_col2_row2_desc = "Le Brochure de Funredes.  Voir une liste de nos travaux depuis le d&eacute;but en 1993.";
	$label_menu_col2_row3_desc = "Un indexe des travaux de Funredes par sujet.";
	$label_menu_col2_row4_desc = "Information de contact, Conventions, Travailler por FUNREDES, Brochure, Publicit&eacute;s, Ressources Humaines...";
	$label_menu_col2_row5_desc = "Statistiques : savoir d’où on se connecte à ce site.<br>Crédits, info sur le serveur, concours d’infographie.";

	$label_contact = "<a href=\"mailto:contact@funredes.org\">contact@funredes.org</a>";
	$label_contact_desc = "N'importe quelle question non-reli&eacute;e directement a ce site web.";
	$label_webmaster = "<a href=\"mailto:webmaster@funredes.org\">webmaster@funredes.org</a>";
	$label_webmaster_desc = "Envoyez-nous un courrier avec des suggestions ou commentaires de notre site web.";

	$label_docint = "FAQ";
	$label_convenio = "Conventions avec d'autres associations";
	$label_trabajar = "Offres d'emploi";
	$label_faq = "Notre Brochure";
	$label_contacto = "Information de contact";
	$label_brochure = "Notre publicit&eacute;";
	$label_mision = "Mission et objectifs";
	$label_estructura = "La structure de l'association";
	$label_enlaces = "Liens externes";
	$label_consejo = "Statuts et informations budg&eacute;taires";
	$label_rh = "Ressources humaines";

	$label_docint_desc = "La foire aux questions sur tous les aspects de FUNREDES.";
	$label_convenio_desc = "La liste des conventions et accords de FUNREDES avec d’autres associations et organismes.";
	$label_trabajar_desc = "Vous avez envie de rejoindre notre équipe ? Vous êtes professionnel(le), jeune ? Nous vous attendons.";
	$label_faq_desc = "Voir une liste de nos travaux et projets depuis le d&eacute;but en 1993.";
	$label_contacto_desc = "Voir les mani&egrave;res diff&eacute;rentes de nous contacter par courrier &eacute;lectronique, poste, t&eacute;l&eacute;phone ou fax.";
	$label_brochure_desc = "Découvrez en quelques mots les informations essentielles sur notre organisation. On peut télecharger cette publicité sous divers formats.";
	$label_mision_desc = "Les phrases-clés de FUNREDES.";
	$label_estructura_desc = "L’organisation politique de l’association.";
	$label_enlaces_desc = "Connectez-vous aux sites que nous jugeons les meilleurs et les plus intéressants sur le thème des NTIC.";
	$label_consejo_desc = "Los estatutos de Funredes en la Rep&uacute;blica Dominicana y Francia, y perspectivas financieras.";
	$label_rh_desc = "Faites connaissance avec les gens qui travaillent pour FUNREDES et connectez-vous à leurs pages personnelles.";

	$label_globalnav = "Nav&eacute;gation globale (qui apparait sur chaque page web)";
	$label_localnav = "Nav&eacute;gation locale (sur les pages de l'Institution)";

	$label_lista_regiones = "INDEX PAR R&Eacute;GION";
	$label_lista_temas = "INDEX PAR SUJET";
	$label_noticias = "Nouvelles de ";


} else if ($lang == "en") {
	$label_titulo = "Site Map";

	$label_menu_col1_row1_desc = "See the latest and most important issues related to New Information and Communication Technology, according to Funredes.";
	$label_menu_col1_row2_desc = "Connect to information about our latest projects, publications, services and achievements.";
	$label_menu_col1_row3_desc = "An index of our work by region.  Use our new interactive map!";
	$label_menu_col1_row4_desc = "Web Design, Internet Courses, Network Consulting, Web Hosting and more.";
	$label_menu_col1_row5_desc = "Frecuently Asked Questions about our institution.";
	$label_menu_col2_row1_desc = "Search for general information or a specific document in the SIF by keyword, or by more advanced search criteria.";
	$label_menu_col2_row2_desc = "Our Brochure of what we've done.  See what we have accomplished since our beginning in 1993.";
	$label_menu_col2_row3_desc = "An index of our work by topic.";
	$label_menu_col2_row4_desc = "Contact Information, Job Opportunities for FUNREDES, Brochure, Publicity, Human Resources.";
	$label_menu_col2_row5_desc = "Web Statistics:  find out who connects to our server.<br>Credits, Info about the server hardware and software, Web Design Contest.";

	$label_contact = "<a href=\"mailto:contact@funredes.org\">contact@funredes.org</a>";
	$label_contact_desc = "Any question or matter not directly related to this website.";
	$label_webmaster = "<a href=\"mailto:webmaster@funredes.org\">webmaster@funredes.org</a>";
	$label_webmaster_desc = "Send us comments or suggestions about our website.";

	$label_docint = "FAQ";
	$label_convenio = "Agreements With Other Organizations";
	$label_trabajar = "Job Postings";
	$label_faq = "Our Brochure";
	$label_contacto = "Contact Information";
	$label_brochure = "Our Advertisement";
	$label_mision = "Mission and Objectives";
	$label_estructura = "Our Organisation's Structure";
	$label_enlaces = "External Links";
	$label_consejo = "Statues and Budget Information";
	$label_rh = "Human Resources";

	$label_docint_desc = "Frequently asked questions about all aspects of Funredes.";
	$label_convenio_desc = "The list of agreements Funredes has with other organisations.";
	$label_trabajar_desc = "Interested in joining our group?  Find out what positions are currently available.";
	$label_faq_desc = "See what we have accomplished since our beginning in 1993.";
	$label_contacto_desc = "See the different ways to get in touch with us by email, regular mail, telephone and fax.";
	$label_brochure_desc = "Get a general idea of what our organisation does.  This publicity brochure is available for download in various formats.";
	$label_mision_desc = "Funredes' keywords and phrases.";
	$label_estructura_desc = "The political organisation of the foundation.";
	$label_enlaces_desc = "Connect to websites we deem important and relevant to New Information and Communications Technologies.";
	$label_consejo_desc = "Articles of incorporation in the Dominican Republic and in France, as well as financial projections.";
	$label_rh_desc = "Find out who works for Funredes and connect to their personal webpages.";

	$label_globalnav = "Global Navigation (appearing on every page)";
	$label_localnav = "Local Navigation (on the About Funredes page)";

	$label_lista_regiones = "INDEX BY REGION";
	$label_lista_temas = "INDEX BY TOPIC";
	$label_noticias = "News from ";

}

// termina descripcion por idioma

echo "<blockquote>\n\n";
echo "<br><center><h2>$label_titulo</center></h2><br></br>";
?>

<font size=+1><b><u><?php echo $label_globalnav ?>:</u></b><p>

<blockquote>
<font size=-1><b>
<a href="<?php echo $label_menu_col1_row1_url ?>"><?php echo $label_menu_col1_row1 ?></a></b><br>
<font size=-1>
<?php echo $label_menu_col1_row1_desc ?>
<blockquote>
<?php
//editoriales - indice por region y tema
	$queryregiones = pg_exec($conn, "SELECT DISTINCT rl.regionid, rl.region_$lang FROM regionlista rl, principal p, regiones r WHERE p.tipo=11 AND p.docid=r.docid AND r.regionid=rl.regionid ORDER BY rl.regionid");
	$regionrow = 0;
	$querytemas = pg_exec($conn, "SELECT DISTINCT tl.temaid, tl.tema_$lang FROM temalista tl, principal p, temas t WHERE p.tipo=11 AND p.docid=t.docid AND t.temaid=tl.temaid ORDER BY tl.temaid");
	$temarow = 0;
?>
	<dl>
	<b>
	<dt><?php echo $label_lista_regiones ?></dt>
	</b>
	

<?php
	do {
		$getregiones = pg_fetch_row($queryregiones, $regionrow);
		echo "<dd><a href=\"/$dir/editoriales.php3/regionid/$getregiones[0]\">$getregiones[1]</a></dd>\n";
		$regionrow++;
	} while ($regionrow < pg_numrows($queryregiones));
?>
	</dl>
	<dl>
	<b>
	<dt><?php echo $label_lista_temas ?></dt>
	</b>
	<br>
<?php
	do {
		$gettemas = pg_fetch_row($querytemas, $temarow);
		echo "<dd><a href=\"/$dir/editoriales.php3/temaid/$gettemas[0]\">$gettemas[1]</a></dd>\n";
		$temarow++;
	} while ($temarow < pg_numrows($querytemas));
?>
	</blockquote>


<font size=-1><b>

<a href="<?php echo $label_menu_col1_row2_url ?>"><?php echo $label_menu_col1_row2 ?></a></b><br>
<font size=-1>
<?php echo $label_menu_col1_row2_desc ?>

<blockquote>
<?php
	$querydates = pg_exec($conn, "SELECT fechadecreacion FROM principal WHERE tipo=12 ORDER BY fechadecreacion DESC");
	$i = 0;
	while ($i < pg_numrows($querydates)) {
		$getdates = pg_fetch_row($querydates, $i);
		if ($i != 0) {
			$getprevdates = pg_fetch_row($querydates, $i-1);
			$prevano = substr($getprevdates[0], 0, 4);
		}
		$ano = substr($getdates[0], 0, 4);
		$last = $ano-1;
		$next = $ano+1;
		if ($ano != $prevano) {
			$querycount = pg_exec($conn, "SELECT count(docid) FROM principal WHERE tipo=12 AND fechadecreacion>'$last-12-31' AND fechadecreacion<'$next-1-1'");
			if (pg_numrows($querycount) != 0) {
				$getcount = pg_fetch_row($querycount, 0);
			}
			echo "<a href=\"/$dir/nuevo.php3/ano/$ano\">$label_noticias $ano</a> ($getcount[0])<br>";
		}
		$i++;
	}
?>

</blockquote>

<font size=-1><b>

<a href="<?php echo $label_menu_col1_row3_url ?>"><?php echo $label_menu_col1_row3 ?></a></b> <br>
<font size=-1>
<?php echo $label_menu_col1_row3_desc ?><p>
<font size=-1><b>

<a href="<?php echo $label_menu_col1_row4_url ?>"><?php echo $label_menu_col1_row4 ?></a></b> <br>
<font size=-1>
<?php echo $label_menu_col1_row4_desc ?><p>
<font size=-1><b>

<a href="<?php echo $label_menu_col1_row5_url ?>"><?php echo $label_menu_col1_row5 ?></a></b> <br>
<font size=-1>
<?php echo $label_menu_col1_row5_desc ?><p>
<font size=-1><b>

<a href="<?php echo $label_menu_col2_row1_url ?>"><?php echo $label_menu_col2_row1 ?></a></b> <br>
<font size=-1>
<?php echo $label_menu_col2_row1_desc ?><p>
<font size=-1><b>

<a href="<?php echo $label_menu_col2_row2_url ?>"><?php echo $label_menu_col2_row2 ?></a></b> <br>
<font size=-1>
<?php echo $label_menu_col2_row2_desc ?><p>
<font size=-1><b>

<a href="<?php echo $label_menu_col2_row3_url ?>"><?php echo $label_menu_col2_row3 ?></a></b> <br>
<font size=-1>
<?php echo $label_menu_col2_row3_desc ?><p>
<font size=-1><b>

<a href="<?php echo $label_menu_col2_row4_url ?>"><?php echo $label_menu_col2_row4 ?></a></b> <br>
<font size=-1>
<?php echo $label_menu_col2_row4_desc ?><p>
<font size=-1><b>

<a href="<?php echo $label_menu_col2_row5_url ?>"><?php echo $label_menu_col2_row5 ?></a></b> <br>
<font size=-1>
<?php echo $label_menu_col2_row5_desc ?><p>
<font size=-1><b>

<?php echo $label_contact ?></a></b> <br>
<font size=-1>
<?php echo $label_contact_desc ?><p>
<font size=-1><b>

<?php echo $label_webmaster ?></a></b> <br>
<font size=-1>
<?php echo $label_webmaster_desc ?><p>
<font size=-1>

</blockquote>



<font size=+1><b><u><?php echo $label_localnav ?>:</u></b><p>

<blockquote>
<font size=-1><b>
<a href="/<?php echo $dir ?>/institucion/faq.php3"><?php echo $label_docint ?></a></b><br>
<font size=-1>
<?php echo $label_docint_desc ?><p>
<font size=-1><b>

<a href="/<?php echo $dir ?>/institucion/convenios.php3"><?php echo $label_convenio ?></a></b><br>
<font size=-1>
<?php echo $label_convenio_desc ?><p>
<font size=-1><b>

<a href="/<?php echo $dir ?>/institucion/expansion.php3"><?php echo $label_trabajar ?></a></b> <br>
<font size=-1>
<?php echo $label_trabajar_desc ?><p>
<font size=-1><b>

<a href="/<?php echo $dir ?>/brochure.php3"><?php echo $label_faq ?></a></b> <br>
<font size=-1>
<?php echo $label_faq_desc ?><p>
<font size=-1><b>

<a href="/<?php echo $dir ?>/institucion/institucion.php3/docid/298"><?php echo $label_contacto ?></a></b> <br>
<font size=-1>
<?php echo $label_contacto_desc ?><p>
<font size=-1><b>

<a href="/<?php echo $dir ?>/institucion/institucion.php3/docid/298"><?php echo $label_brochure ?></a></b> <br>
<font size=-1>
<?php echo $label_brochure_desc ?><p>
<font size=-1><b>

<a href="/<?php echo $dir ?>/institucion/institucion.php3/docid/281"><?php echo $label_mision ?></a></b> <br>
<font size=-1>
<?php echo $label_mision_desc ?><p>
<font size=-1><b>

<a href="/<?php echo $dir ?>/institucion/estructura.php3"><?php echo $label_estructura ?></a></b> <br>
<font size=-1>
<?php echo $label_estructura_desc ?><p>
<font size=-1><b>

<a href="/<?php echo $dir ?>/institucion/institucion.php3/docid/300"><?php echo $label_enlaces ?></a></b> <br>
<font size=-1>
<?php echo $label_enlaces_desc ?><p>
<font size=-1><b>

<a href="/<?php echo $dir ?>/institucion/estatutosypresupuestos.php3"><?php echo $label_consejo ?></a></b> <br>
<font size=-1>
<?php echo $label_consejo_desc ?><p>
<font size=-1><b>

<a href="/<?php echo $dir ?>/institucion/recursoshumanos.php3"><?php echo $label_rh ?></a></b> <br>
<font size=-1>
<?php echo $label_rh_desc ?><p>
<font size=-1>

</blockquote>




<?php
echo "</blockquote>\n\n";


include("footer.php3");
?>
