
<?php

$conn=pg_pconnect("dbname=emecmistica user=postgres"); 
//retrouver mes variables
$tableau=explode("/", $_SERVER['PATH_INFO']);
$x=count($tableau);
$idi=$tableau[$x-1];

if (($idi !="es") && ($idi!="en")&&($idi !="fr")&& ($idi !="po")) {
include "error.php3";
}
else {

include "foo.php3";
include "bibo.php3";
include "bibusc.php3";
include "head5.php3";

$coord = array(
    "cm"  => array("es"=>"Coordinación Mistica","en"=>"Mistica Coordination","fr"=>"Coordination Mistica","po"=>"Coordenação Mistica"),
    "ce"  => array("es"=>"Coordinación EMEC","en"=>"EMEC Coordination","fr"=>"Coordination EMEC","po"=>"EMEC Coordenação"));

$conn=pg_pconnect("dbname=emecmistica user=postgres");
 
?> 

<table width="640" border="0">
  <tr> 
    <td width="615" align="center"> 
      <p>&nbsp;</p>
      <table width="75%" border="1">
        <tr>
          <td width="53%" bgcolor="#FF9933"><font face="helvetica"><b><font size="2" face="Arial, Helvetica, sans-serif"><? echo $catcat?></font></b></font></td>
          <td width="47%">
      <FORM ACTION="/mistica/bdd/res.php3" METHOD="POST">
<input type= "hidden" name="idi" value="<?echo $idi?>">            

<?php
if ($idi=="es") {
$querycat = pg_exec($conn,"select id_categoria, titulo_es from categoria");
}
elseif ($idi=="en") {
$querycat = pg_exec($conn,"select id_categoria, titulo_en from categoria");
}
elseif ($idi=="fr") {
$querycat = pg_exec($conn,"select id_categoria, titulo_fr from categoria");
}
elseif ($idi=="po") {
$querycat = pg_exec($conn,"select id_categoria, titulo_po from categoria");
}

for($n=0; $n<pg_numrows($querycat)-2; $n++) {
$getcat = pg_fetch_row($querycat,$n);
if ($n != 0) { echo "<br>";}
echo "<input type= \"checkbox\" name=\"$getcat[0]\" value=\"T\" checked>
<font size=\"2\" face=\"Arial, Helvetica, sans-serif\">$getcat[1] </font>"
;
}
?> 

            </td>
        </tr>
        <tr>
          <td width="53%" bgcolor="#FF9933" height="167"><font face="helvetica"><b><font size="2" face="Arial, Helvetica, sans-serif"><?echo $tictem?></font></b></font></td>
          <td width="47%" height="167"> 
            <select multiple name="temi[]" size=8><?php
$conn=pg_pconnect("dbname=emecmistica user=postgres");
if ($idi=="es") {
$querytemi = pg_exec($conn,"select id_tema, tema_es from tema");
}
elseif ($idi=="en") {
$querytemi = pg_exec($conn,"select id_tema, tema_en from tema");
}
elseif ($idi=="fr") {
$querytemi = pg_exec($conn,"select id_tema, tema_fr from tema");
}
elseif ($idi=="po") {
$querytemi = pg_exec($conn,"select id_tema, tema_po from tema");
}


for ($u=0; $u<pg_numrows($querytemi); $u++) {
$ty=pg_fetch_row($querytemi, $u);
$ty[1]=stripslashes($ty[1]);
echo "<option value=\"$ty[0]\">

 
$ty[1]"; 
}
?>
              
            </select>
          </td>
        </tr>
        <tr>
          <td width="53%" bgcolor="#FF9933"><font face="helvetica"><b><font size="2" face="Arial, Helvetica, sans-serif"><?echo $ticauto?></font></b></font></td>
          <td width="47%">


            <select multiple name="totor[]" size=10>
<?php
$querytotor = pg_exec($conn,"select id_miembro, apellido_miembro, nombre_miembro from communidad where id_miembro in (select distinct id_creador from mensajes) and id_miembro>'0' order by apellido_miembro");  
$n=0;
while ($n<pg_numrows($querytotor)) {
$tor= pg_fetch_row($querytotor,$n);
$tor[1]=stripslashes($tor[1]);
if (($tor[0]<'3') && ($idi != "en")) {
$toritori=$tor[1];
$tor[1]=$tor[2];
$tor[2]=$toritori;
}
$preki="$tor[1] $tor[2]";
$ki=foo($preki);
$ki=strtolower($ki);

$autortab=explode ("-", $tor[1]);
for ($erx=0; $erx<count($autortab); $erx++) {
$autortab[$erx]=ucwords($autortab[$erx]);
}
$tor[1]=implode ("-", $autortab);
$tor[2]=stripslashes($tor[2]);
$tor[2]=ucwords($tor[2]);
$arrtor[$ki]=array("nom"=> "$tor[1]", "prenom"=>"$tor[2]", "id"=>"$tor[0]");
$n++;
}
ksort($arrtor);

for (reset($arrtor); $key=key($arrtor); next($arrtor)) {
$tor_id=$arrtor[$key]["id"];
$tor_nom=$arrtor[$key]["nom"];
$tor_prenom=$arrtor[$key]["prenom"];
if ($tor_id==1) {
$nomentier=$coord["cm"]["$idi"];
echo "<option value=\"$tor_id\">$nomentier</option>";
}
elseif ($tor_id==2) {
$nomentier=$coord["ce"]["$idi"];
echo "<option value=\"$tor_id\">$nomentier</option>";
}
 else {

echo " 
              <option value=\"$tor_id\">$tor_nom; $tor_prenom</option>"; 
} 
}
?>
              
            </select>
          </td>
        </tr>
        <tr>
          <td width="53%" bgcolor="#FF9933"><font size="2"><b><font face="Arial, Helvetica, sans-serif"><?echo $ticpal?></font></b></font></td>
          <td width="47%">
            <select multiple name="palabra[]" size=10>
<?php
if ($idi=="es") {
$querypal = pg_exec($conn,"select id_palabra, palabra_es from indice order by palabra_es");  
}
elseif ($idi=="en") {
$querypal = pg_exec($conn,"select id_palabra, palabra_en from indice order by palabra_en");  
}
elseif ($idi=="fr") {
$querypal = pg_exec($conn,"select id_palabra, palabra_fr from indice order by palabra_fr");  
}
elseif ($idi=="po") {
$querypal = pg_exec($conn,"select id_palabra, palabra_po from indice order by palabra_po");  
}


$m=0;
while ($m<pg_numrows($querypal)) {
$pal= pg_fetch_row ($querypal,$m);
$pal[1]=stripslashes($pal[1]);
$k=foo($pal[1]);
$k=strtolower($k);
$k="a $k";
$arrpal[$k]=array("es"=>"$pal[1]", "id"=>"$pal[0]");
$m++;
}
ksort($arrpal);

for (reset($arrpal); $key=key($arrpal); next($arrpal)) {
$pal_id=$arrpal[$key]["id"];
$pal_es=$arrpal[$key]["es"];
echo "<option value=\"$pal_id\">$pal_es</option>"; 

} 
?>
              
            </select>
          </td>
        </tr>
      </table>
      <p>&nbsp;</p>

        <p><i><b><?echo $ticescrib?></b></i></p>
        <p>
          <input type="text" name="palo" size="60" value="">
          <BR>
        </p>
        <p>&nbsp;</p>
        <p><b><i><?echo $ticpara?> :</i></b> </p>
        <p> 
          <INPUT type= "checkbox" name="titulos" value="T" checked>
          <?echo $tictit?>
          <INPUT type= "checkbox" name="syntheses" value="T" checked>
          <?echo $ticsin?>
          <INPUT type= "checkbox" name="textintegral" value="T" checked>
          <?echo $ticmen?> </p>
        <p> 
          <INPUT type= "checkbox" name="attacho" value="T" checked>
          <?echo $ticatt?>
          <INPUT type= "checkbox" name="indice" value="T" checked>
          <?echo $ticindic?> <br>
        </p>
        <H3><i><?echo $ticreduc?>:</i></H3>
        <p>
          <select name="dia" size="1">
            <option value="8j"><?echo $ticsemana?></option>
            <option value="15j"><?echo $ticdesemana?></option>
            <option value="1m"><?echo $ticmes?></option>
            <option value="2m"><?echo $ticmeses?></option>
            <option value="nacimiento" selected><?echo $ticprincip?></option>
          </select>
        </p>
        <p><br>
          <input type="submit" name="submit" value="<?echo $ticbusc?>">
          <br>
        </p>
      </form>
    </td>
    <td bgcolor="#41a13f" width="15" rowspan="2">&nbsp; </td>
  </tr>
  <tr>
    <td width="615">&nbsp;</td>
  </tr>
</table>
<table width="640" border="0">
        <tr>
                <td bgcolor="#5050d1">
                        <table width="630" border="0">
                                <tr>
                                        <td bgcolor="#eeeeee" align="center">
                                                <font face="helvetica, verdana, arial,  sans serif" size="2">
                                                &nbsp;
                                                </font>
                                        </td>   
                                </tr>
                        </table>
                </td>   
        </tr>
</table>

<!--pie--> 
<hr>
<table width="640" border="0" bgcolor="#eeeeee">
        <tr>
                <td>
                        <a HREF="javascript:history.go(-1)" onMouseOver="if (VersionNavigateur(3.0,4.0))img7.src='/mistica/bdd/img/backcolor.gif' " onMouseOut="img7.src='/mistica/bdd/img/backnegro.gif' "><img name="img7" src="/mistica/bdd/img/backnegro.gif" width="18" height="18" border="0" alt="<?echo $prev?>" onLoad="tempImg=new Image(0,0); tempImg.src='/mistica/bdd/img/backcolor.gif'"></a>
                        
                </td>
                <td align="center">
                        <a HREF="#top" onMouseOver="if (VersionNavigateur(3.0,4.0))img6.src='/mistica/bdd/img/topcolor.gif' " onMouseOut="img6.src='/mistica/bdd/img/topnegro.gif'"><img name="img6" src="/mistica/bdd/img/topnegro.gif" width="18" height="18" border="0" alt="<?echo $cabeza?>" onLoad="tempImg=new Image(0,0); tempImg.src='/mistica/bdd/img/topcolor.gif'"></a>
                </td>
                <td align="right">
                        
                        <a HREF="javascript:history.go(+1)" onMouseOver="if (VersionNavigateur(3.0,4.0))img8.src='/mistica/img/forwardcolor.gif' " onMouseOut="img8.src='/mistica/bdd/img/forwardnegro.gif' "><img name="img8" src="/mistica/bdd/img/forwardnegro.gif" width="18" height="18" border="0" alt="<?echo $prox?>" onLoad="tempImg=new Image(0,0); tempImg.src='/mistica/bdd/img/forwardcolor.gif'"></a>
                </td>
                
        </tr>
        
</table>

<table width="640" border="0">
        <tr>
                
                
    <td align="center"> <font face="helvetica, verdana, arial, sans serif" size="2"> 
      <?echo"$credit";?> | 
<?echo "$mapa";?> | <?echo"$correo"?>: <a HREF="MAILTO:webmistica@funredes.org">&lt;webmistica@funredes.org&gt;</a> 
      </font> </td>
        </tr>
        <tr>
<?
echo "<td align=\"center\"> <font face=\"helvetica, verdana, arial, sans serif\" size=\"2\">http://www.funredes.org/mistica/bdd/search.php3".$_SERVER['PATH_INFO']."<br>$modif: 14/01/2014</font>";
?>

        </tr>
</table>

</body>
</html>
<?
}
?>
