<?PHP
/************************************************************************/
/* NPDS V : Net Portal Dynamic System .                                 */
/* ===========================                                          */
/*                                                                      */
/* Original Copyright (c) 2001 by Francisco Burzi (fburzi@ncc.org.ve)   */
/* http://phpnuke.org                                                   */
/*                                                                      */
/* This version name NPDS Copyright (c) 2001-2005 by Philippe Brunier   */
/* Major changes from ALAT 2004-2005                                    */
/*                                                                      */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License.       */
/************************************************************************/
function Access_Error () {
  if (file_exists("meta/meta.php"))
     include ("meta/meta.php");
  echo "<title>NPDS</title></head><body bgcolor=\"white\"><br /><p align=\"center\"><span style=\"font-size: 14px; font-family: Arial; font-weight: bold; color: red;\">";
  echo "Access Denied / Acc&egrave;s Refus&eacute;";
  if (cur_charset=="utf-8") echo" / &#x901A;&#x5165;&#x88AB;&#x5426;&#x8BA4;";
  echo "</span>";
  echo "<br /><br /><span style=\"font-size: 12px; font-family: Arial; font-weight: bold; color: black;\">NPDS - Portal System";
  echo "</span></p></body></html>";
  die();
}
if (!eregi("admin.php", $PHP_SELF)) { Access_Error(); }
global $pdst; $pdst="0";

global $language;
$hlpfile = "manuels/$language/sections.html";
$result = mysql_query("select radminsection, radminsuper from authors where aid='$aid'");
list($radminsection, $radminsuper) = mysql_fetch_row($result);
if (($radminsection!=1) and ($radminsuper!=1)) {
   Access_Error();
}

function groupe($groupe) {
   $les_groupes=split(",",$groupe);
   $mX=liste_group();
   $nbg=0; $str="";
   while (list($groupe_id, $groupe_name)=each($mX)) {
      $selectionne=0;
      if ($les_groupes) {
         foreach ($les_groupes as $groupevalue) {
            if (($groupe_id==$groupevalue) and ($groupe_id!=0)) {$selectionne=1;}
         }
      }
      if ($selectionne==1) {
         $str.="<option value=\"$groupe_id\" selected>$groupe_name</option>";
      } else {
         $str.="<option value=\"$groupe_id\">$groupe_name</option>";
      }
      $nbg++;
   }
   if ($nbg>5) {$nbg=5;}
   return ("<select class=\"TEXTBOX_STANDARD\" name=\"Mmembers[]\" multiple size=\"$nbg\" style=\"top: -4;\">".$str."</select>");
}

function droits($member) {
   echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\"><tr><td align=\"left\" valign=\"top\" width=\"10%\" nowrap=\"nowrap\">";
   echo "<span class=\"ROUGE\">".adm_translate("Administrateurs")."</span> :";
   if ($member==-127) {$checked=" checked";} else {$checked="";}
   echo "<input type=\"radio\" name=\"members\" value=\"-127\"$checked></td><td align=\"center\" valign=\"top\" width=\"10%\" nowrap=\"nowrap\">";
   echo "<span class=\"ROUGE\">".adm_translate("Anonymes")."</span> :";
   if ($member==-1) {$checked=" checked";} else {$checked="";}
   echo "<input type=\"radio\" name=\"members\" value=\"-1\"$checked></td><td align=\"right\" valign=\"top\" width=\"15%\" nowrap=\"nowrap\">";
   echo "<span class=\"ROUGE\">".adm_translate("Membres")."</span> :";
   if ($member>0) {
      echo "<input type=\"radio\" name=\"members\" value=\"1\" checked>&nbsp;&nbsp;<b>=> ".adm_translate("Groupes")." :&nbsp;&nbsp;</b>";
      echo "</td><td align=\"left\" valign=\"top\" width=\"15%\">";
      echo groupe($member);
      echo "</td><td align=\"left\" valign=\"top\" width=\"10%\">";
      echo "<input type=\"radio\" name=\"members\" value=\"0\"><b>".adm_translate("Tous")."</b></td></tr></table>";
   } else {
      if ($member==0) {$checked=" checked";} else {$checked="";}
      echo "<input type=\"radio\" name=\"members\" value=\"1\">&nbsp;&nbsp;<b>=> ".adm_translate("Groupes")." :&nbsp;&nbsp;</b>";
      echo "</td><td align=\"left\" valign=\"top\" width=\"15%\">";
      echo groupe($member);
      echo "</td><td align=\"left\" valign=\"top\" width=\"10%\">";
      echo "<input type=\"radio\" name=\"members\" value=\"0\"$checked><b>".adm_translate("Tous")."</b></td></tr></table>";
   }
}

function sousrub_select($secid) {
   global $radminsuper, $aid;
   global $NPDS_Prefix;
   $ok_pub=false;

   $tmp="<select name=\"secid\" class=\"TEXTBOX_STANDARD\">";
   $result = mysql_query("select distinct rubid, rubname from ".$NPDS_Prefix."rubriques order by ordre");
   while(list($rubid, $rubname) = mysql_fetch_array($result)) {
      $rubname = aff_langue($rubname);
      $tmp.="<optgroup label=\"".aff_langue($rubname)."\">";
      if ($radminsuper==1) {
         $result2 = mysql_query("select secid, secname from ".$NPDS_Prefix."sections where rubid='$rubid' order by ordre");
      } else {
         $result2 = mysql_query("select distinct sections.secid, sections.secname from ".$NPDS_Prefix."sections, ".$NPDS_Prefix."publisujet where sections.rubid='$rubid' and sections.secid=publisujet.secid2 and publisujet.aid='$aid' and publisujet.type='1' order by ordre");
      }
      while(list($secid2, $secname) = mysql_fetch_array($result2)) {
         $secname=aff_langue($secname);
         $secname = substr($secname, 0, 50);
         $tmp.="<option value=\"$secid2\"";
         if ($secid2==$secid) $tmp.=" selected";
         $tmp.=">$secname</option>";
         $ok_pub=true;
      }
      mysql_free_result($result2);
      $tmp.="</optgroup>";
   }
   $tmp.="</select>";
   mysql_free_result($result);
   if (!$ok_pub) ($tmp="");
   return ($tmp);
}

function droits_publication($secid) {
   global $radminsuper, $aid;
   global $NPDS_Prefix;

   $droits=0; // 3=mod - 4=delete
   if ($radminsuper!=1) {
      $result = mysql_query("select type from ".$NPDS_Prefix."publisujet where secid2='$secid' and aid='$aid' and type in(3,4) order by type");
      if (mysql_num_rows($result)>0) {
         while(list($type) = mysql_fetch_array($result)) {
            $droits=$droits+$type;
         }
      }
   } else {
      $droits=7;
   }
   return ($droits);
}

function sections() {
   global $hlpfile, $aid, $radminsuper;
   include("header.php");
   include_once ("lib/togglediv.class.php");
   GraphicAdmin($hlpfile);   
   global $NPDS_Prefix;

   if ($radminsuper==1) {
      $result = mysql_query("select rubid, rubname, enligne, ordre from ".$NPDS_Prefix."rubriques order by ordre");
   } else {
      $result = mysql_query("select distinct rubriques.rubid, rubriques.rubname, rubriques.enligne, rubriques.ordre from ".$NPDS_Prefix."rubriques, ".$NPDS_Prefix."sections, ".$NPDS_Prefix."publisujet where rubriques.rubid=sections.rubid and sections.secid=publisujet.secid2 and publisujet.aid='$aid' order by ordre");
   }
   $nb_rub=@mysql_num_rows($result);
   OpenTable();
   echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"HEADER\">\n";
   echo adm_translate("Rubriques actives");;
   if ($ibid=theme_image("sections/prev.gif")) {$imgprev=$ibid;} else {$imgprev="images/sections/prev.gif";}
   echo "&nbsp;&nbsp;( <img src=\"$imgprev\" border=\"0\" alt=\"\" /> ".adm_translate("Pour prévisualiser le contenu dans son environnement d'exploitation.")." )</td>";
   echo "<td width=\"30%\" nowrap=\"nowrap\">";
   echo "<a href=\"admin.php?op=new_rub_section&amp;type=rub\" class=\"NOIR\">".adm_translate("Ajouter une nouvelle Rubrique")."</a><br /><br />";
   if ($nb_rub > 0) {
      echo "<a href=\"admin.php?op=new_rub_section&amp;type=sec\" class=\"NOIR\">".adm_translate("Ajouter une nouvelle Sous-Rubrique")."</a></td>";
   }
   echo "</tr></table>\n";
   echo "<br />\n";
   if ($nb_rub > 0) {
      $toggle = new ToggleDiv($nb_rub);
      echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\"><tr><td nowrap=\"nowrap\">\n";
      echo "<form action=\"admin.php\" method=\"post\"><input type=\"hidden\" name=\"op\" value=\"secartedit\">";
      echo $toggle->All()."</td><td align=\"center\" width=\"70%\">".adm_translate("Editer l'Article d'ID : ")."&nbsp;<input type=\"input\" class=\"TEXTBOX_STANDARD\" name=\"artid\" size=\"10\" maxlength=\"9\">";
      echo "</td></form></tr>\n</table>\n<hr noshade class=\"ONGL\">";
         
      while (list($rubid, $rubname, $enligne, $ordre) = mysql_fetch_array($result)) {
         echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"ONGL\">\n";
         if ($radminsuper==1) {
            $href1="<a href=\"admin.php?op=rubriquedit&amp;rubid=$rubid\">";
            $href2="</a>";
            $href3="&nbsp;<a href=\"admin.php?op=rubriquedelete&amp;rubid=$rubid\" class=\"ROUGE\" style=\"font-size: 10px;\">".adm_translate("Supprimer")."</a>";
         } else {
            $href1=""; $href2=""; $href3="";
         }
         $rubname = aff_langue($rubname);
         if ($rubname=="") {$rubname=adm_translate("Sans nom");}
         if ($enligne==0) { $online="<span class=\"ROUGE\">".adm_translate("Hors Ligne")."</span>"; } else if ($enligne==1) { $online = adm_translate("En Ligne"); }
            
         echo $toggle->Img();
         echo $href1.$rubname.$href2;
         echo "</td><td class=\"ONGL\" width=\"10%\" align=\"center\">$online</td><td class=\"ONGL\" width=\"5%\" align=\"center\">$href3</td></tr>\n</table>\n";

         echo $toggle->Begin();
         echo "<table width=\"100%\" cellpadding=\"3\" cellspacing=\"2\" border=\"0\">";
         if ($radminsuper==1) {
            $result2 = mysql_query("select distinct secid, secname from ".$NPDS_Prefix."sections where rubid='$rubid' order by ordre");
         } else {
            $result2 = mysql_query("select distinct sections.secid, sections.secname from ".$NPDS_Prefix."sections, ".$NPDS_Prefix."publisujet where sections.rubid='$rubid' and sections.secid=publisujet.secid2 and publisujet.aid='$aid' order by ordre");
         }
         if ($ibid=theme_image("sections/ordrecours.gif")) {$imgordcours=$ibid;} else {$imgordcours="images/sections/ordrecours.gif";}
         if ($ibid=theme_image("sections/ordrechapitre.gif")) {$imgordchapitre=$ibid;} else {$imgordchapitre="images/sections/ordrechapitre.gif";}
         if (mysql_num_rows($result2) > 0) {
            while (list($secid, $secname) = mysql_fetch_array($result2)) {
               $droit_pub=droits_publication($secid);
               $rowcolor=tablos();
               $secname=aff_langue($secname);
               echo "<tr $rowcolor><td colspan=\"2\"><b>".adm_translate("sous-rubrique")."</b> <a href=\"sections.php?op=listarticles&amp;secid=$secid&amp;prev=1\"><img src=\"$imgprev\" alt=\"\" border=\"0\" /></a>&nbsp;<a href=\"admin.php?op=sectionedit&amp;secid=$secid\" class=\"NOIR\">$secname</a>";
               if (($droit_pub==7) or ($droit_pub==4)) {
                  echo "&nbsp;&nbsp;&nbsp;&nbsp;<a href=\"admin.php?op=sectiondelete&amp;secid=$secid\" class=\"ROUGE\" style=\"font-size: 10px;\">".adm_translate("Supprimer")."</a>";
               }
               echo "</td></tr>";
               $result3 = mysql_query("select artid, title from ".$NPDS_Prefix."seccont where secid='$secid' order by ordre");
               if (mysql_num_rows($result3) > 0) {
                  $ibid=true;
                  while (list($artid, $title) = mysql_fetch_array($result3)) {
                     echo "<tr $rowcolor><td";
                     if (($droit_pub!=7) and ($droit_pub!=4))echo " colspan=\"2\"";
                     if ($title=="") $title=adm_translate("Sans titre");
                     echo ">&nbsp;&nbsp;<a href=\"sections.php?op=viewarticle&amp;artid=$artid&amp;prev=1\"><img src=\"$imgprev\" alt=\"\" border=\"0\" /></a>&nbsp;-&nbsp;<a href=\"admin.php?op=secartedit&amp;artid=$artid\" class=\"NOIR\">".aff_langue($title)."</a></td>";
                     if (($droit_pub==7) or ($droit_pub==4)) {
                        echo "<td width=\"5%\"><a href=\"admin.php?op=secartdelete&amp;artid=$artid\" class=\"ROUGE\" style=\"font-size: 10px;\">".adm_translate("Supprimer")."</a></td>";
                     }
                     echo "</tr>";
                  }
                  if ($radminsuper==1) {
                     // modifier l'ordre des publications au sein de la sous-rubrique
                     echo "<tr $rowcolor><td colspan=\"2\">&nbsp;&nbsp;<img src=\"$imgordcours\" alt=\"\" />&nbsp;<a href=\"admin.php?op=ordrecours&secid=$secid&amp;secname=$secname\" class=\"NOIR\">".adm_translate("Changer l'ordre")." ".adm_translate("des")." ".adm_translate("publications")."</a></td></tr>";
                     echo "<tr><td colspan=\"2\"></td></tr>";
                  }
               }
            }
            if ($radminsuper==1) {
               // modifier l'ordre des sous-rubriques au sein de la rubrique
               echo "<tr><td><img src=\"$imgordchapitre\" alt=\"\" />&nbsp;<a href=\"admin.php?op=ordrechapitre&amp;rubid=$rubid&amp;rubname=$rubname\" class=\"NOIR\">".adm_translate("Changer l'ordre")." ".adm_translate("des")." ".adm_translate("sous-rubriques")."</td></tr>";
            }
         }
         echo "</table><br />";
         echo $toggle->End();
      }

      if ($ibid=theme_image("sections/ordremodule.gif")) {$imgordmodule=$ibid;} else {$imgordmodule="images/sections/ordremodule.gif";}
      // le super administrateur peut modifier l'ordre des rubriques elles-mêmes
      if ($radminsuper==1) { echo "<img src=\"$imgordmodule\">&nbsp;<a href=\"admin.php?op=ordremodule\">".adm_translate("Changer l'ordre")." ".adm_translate("des")." ".adm_translate("rubriques")."</a>"; }
      CloseTable();

     // début d'affichage de l'ajout d'une publication
      $autorise_pub=sousrub_select("");
      if ($autorise_pub) {
         OpenTable();
         echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"HEADER\">\n";
         echo adm_translate("Ajouter une publication");
         echo "</td></tr></table>\n";

         echo "<table border=\"0\" width=\"100%\" cellpadding=\"2\" cellspacing=\"1\">
         <form action=\"admin.php\" method=\"post\" name=\"adminForm\">";
         $rowcolor=tablos();
         echo "<tr $rowcolor><td width=\"20%\"><b>".adm_translate("sous-rubrique")."</b></td>";
         echo "<td width=\"80%\">";
         echo $autorise_pub;
         echo "</td></tr>";
         echo "<tr $rowcolor><td><b>".adm_translate("Titre")."</b></td>";
         echo "<td><textarea class=\"textbox\" name=\"title\" cols=\"60\" rows=\"2\"></textarea></td></tr>";
         echo "<tr $rowcolor><td><b>".adm_translate("Contenu")."</b></td>";
         echo "<td><textarea class=\"textbox\" name=\"content\" cols=\"60\" rows=\"30\" style=\"width: 100%;\"></textarea>";
         echo aff_editeur("content","false");
         echo "</td></tr>";
         echo "<input type=\"hidden\" name=\"op\" value=\"secarticleadd\"><input type=\"hidden\" name=\"autho\" value=\"$aid\">";
         ################################# personnalisation des critères ######################################
         echo "<input type=\"hidden\" name=\"crit1\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit2\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit3\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit4\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit5\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit6\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit7\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit8\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit9\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit10\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit11\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit12\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit13\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit14\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit15\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit16\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit17\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit18\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit19\" value=\"\">";
         echo "<input type=\"hidden\" name=\"crit20\" value=\"\">";
         #######################################################################################################
         echo "<tr $rowcolor><td><b>".adm_translate("Niveau de l'Utilisateur")." :</b></td><td>";
         droits("0");
         echo "</td></tr>";
         echo "<tr $rowcolor><td colspan=\"2\"><input class=\"BOUTON_STANDARD\" type=\"submit\" value=\"".adm_translate("Ajouter")."\"></td></tr></form>";

         if ($radminsuper!=1) {
            echo "<tr $rowcolor><td colspan=\"2\">".adm_translate("Une fois que vous aurez validé cette publication, elle sera intégrée en base temporaire, et l'administrateur sera prévenu. Il visera cette publication et la mettra en ligne dans les meilleurs délais.<br />Il est normal que pour l'instant, cette publication n'apparaisse pas dans l'arborescence.")."</td></tr>";
         }
         echo "</table>";
      }
   }
   CloseTable();

   OpenTable();
   echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"HEADER\">\n";
   echo adm_translate("Publication(s) en en attente de validation");
   echo "</td></tr></table>\n";
   echo "<br />\n";
   echo "<table border=\"0\" width=\"100%\" cellpadding=\"2\"><tr><td width=\"100%\">";
   echo "<ul>";
   if ($radminsuper==1) {
      $result = mysql_query("select distinct artid, secid, title, content, author from ".$NPDS_Prefix."seccont_tempo order by artid");
      while(list($artid, $secid, $title, $content, $author) = @mysql_fetch_array($result)) {
         echo "<li>".aff_langue($title)."&nbsp;($author) [ <a href=\"admin.php?op=secartupdate&amp;artid=$artid\">".adm_translate("Editer")."</a> ]";
      }
   } else {
      $result = mysql_query("select distinct seccont_tempo.artid, seccont_tempo.title, seccont_tempo.author from ".$NPDS_Prefix."seccont_tempo, ".$NPDS_Prefix."publisujet where seccont_tempo.secid=publisujet.secid2 and publisujet.aid='$aid' and (publisujet.type='1' or publisujet.type='2')");
      while(list($artid, $title, $author) = mysql_fetch_array($result)) {
         echo "<li>".aff_langue($title)."&nbsp;($author) [ <a href=\"admin.php?op=secartupdate&amp;artid=$artid\">".adm_translate("Editer")."</a> ]";
      }
   }
   echo "</ul>";
   echo "</td></tr></table>";
   CloseTable();

   if ($radminsuper==1) {
      OpenTable();
      echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"HEADER\">\n";
      echo adm_translate("Droits des auteurs")."</a></td></tr></table>";
      $result = mysql_query("select aid, name, radminsuper from authors");
      echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\">";
      while(list($Xaid, $name, $Xradminsuper) = mysql_fetch_row($result)) {
         if (!$Xradminsuper) {
            $rowcolor = tablos();
            echo "<tr $rowcolor><td width=\"50%\">$Xaid&nbsp;&nbsp;/&nbsp;&nbsp;$name</td>";
            echo "<td align=\"right\" nowrap=\"nowrap\"><a href=\"admin.php?op=droitauteurs&amp;author=$Xaid\" CLASS=\"NOIR\">".adm_translate("Modifier l'information")."</a>";
            echo "</td></tr>";
         }
      }
      echo "</table><br />";
      CloseTable();

      OpenTable();
      if (file_exists("sections.config.php"))
         include ("sections.config.php");
      else {
         $sections_menudyn = 0; $sections_chemin = 0;
         $sections_menudynx = 150; $sections_menudyny = 80;
         $sections_menudynb = "FF0000"; $sections_menudynf = "FFFFFF";
         $sections_menudynr = "CCBBAA";
         $sections_menudynha = "30"; $sections_menudynla = "140";
         $sections_menudynlb = "120"; $sections_menudyntps = "500";
         $$togglesection = 0;
      }
      echo "<form action=\"admin.php\" method=\"post\" name=\"form2\">";
      echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"HEADER\" width=\"35%\">\n";
      echo adm_translate("Activer Toggle-Div :")."</td><td>";
      if ($togglesection==1) {
         echo "<input type=\"radio\" name=\"togglesection\" value=\"1\" checked>".adm_translate("Oui")." &nbsp;
         <input type=\"radio\" name=\"togglesection\" value=\"0\">".adm_translate("Non");
      } else {
         echo "<input type=\"radio\" name=\"togglesection\" value=\"1\">".adm_translate("Oui")." &nbsp;
         <input type=\"radio\" name=\"togglesection\" value=\"0\" checked>".adm_translate("Non");
      }
      echo "</td></tr></table>";

      echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"HEADER\">\n";
      echo adm_translate("Activer la barre de menu des sections :")."</td><td>";
      if ($sections_menudyn==1) {
         echo "<input type=\"radio\" name=\"sections_menudyn\" value=\"1\" checked>".adm_translate("Oui")." &nbsp;
         <input type=\"radio\" name=\"sections_menudyn\" value=\"0\">".adm_translate("Non");
      } else {
         echo "<input type=\"radio\" name=\"sections_menudyn\" value=\"1\">".adm_translate("Oui")." &nbsp;
         <input type=\"radio\" name=\"sections_menudyn\" value=\"0\" checked>".adm_translate("Non");
      }
      echo "</td></tr>
      <tr><td width=\"35%\">"
      .adm_translate("Position de la barre (pixel) // Haut :")."</td><td>
      <input class=\"TEXTBOX\" type=\"text\" name=\"sections_menudyny\" value=\"$sections_menudyny\" size=\"10\" maxlength=\"100\">
      </td></tr>
      <tr><td width=\"35%\">"
      .adm_translate("Position de la barre (pixel) // Gauche :")."</td><td>
      <input class=\"TEXTBOX\" type=\"text\" name=\"sections_menudynx\" value=\"$sections_menudynx\" size=\"10\" maxlength=\"100\">
      </td></tr>
      <tr><td width=\"35%\">"
      .adm_translate("Couleur de la bordure :")."</td><td>
      <input class=\"TEXTBOX\" type=\"text\" name=\"sections_menudynb\" value=\"$sections_menudynb\" size=\"10\" maxlength=\"100\">
      </td></tr>
      <tr><td width=\"35%\">"
      .adm_translate("Couleur de fond :")."</td><td>
      <input class=\"TEXTBOX\" type=\"text\" name=\"sections_menudynf\" value=\"$sections_menudynf\" size=\"10\" maxlength=\"100\">
      </td></tr>
      <tr><td width=\"35%\">"
      .adm_translate("Couleur de fond au rollover :")."</td><td>
      <input class=\"TEXTBOX\" type=\"text\" name=\"sections_menudynr\" value=\"$sections_menudynr\" size=\"10\" maxlength=\"100\">
      </td></tr>
      <tr><td width=\"35%\">"
      .adm_translate("Largeur des cellules rubriques :")."</td><td>
      <input class=\"TEXTBOX\" type=\"text\" name=\"sections_menudynla\" value=\"$sections_menudynla\" size=\"10\" maxlength=\"100\">
      </td></tr>
      <tr><td width=\"35%\">"
      .adm_translate("Largeur des cellules sous-rubriques :")."</td><td>
      <input class=\"TEXTBOX\" type=\"text\" name=\"sections_menudynlb\" value=\"$sections_menudynlb\" size=\"10\" maxlength=\"100\">
      </td></tr>
      <tr><td width=\"35%\">"
      .adm_translate("Hauteur des cellules :")."</td><td>
      <input class=\"TEXTBOX\" type=\"text\" name=\"sections_menudynha\" value=\"$sections_menudynha\" size=\"10\" maxlength=\"100\">
      </td></tr>
      <tr><td width=\"35%\">"
      .adm_translate("Délai de disparition :")."</td><td>
      <input class=\"TEXTBOX\" type=\"text\" name=\"sections_menudyntps\" value=\"$sections_menudyntps\" size=\"10\" maxlength=\"100\">
      </td></tr>
      <tr><td width=\"35%\">"
      .adm_translate("Afficher le chemin dans le titre de la page :")."</td><td>";
      if ($sections_chemin==1) {
         echo "<input type=\"radio\" name=\"sections_chemin\" value=\"1\" checked>".adm_translate("Oui")." &nbsp;
         <input type=\"radio\" name=\"sections_chemin\" value=\"0\">".adm_translate("Non");
      } else {
         echo "<input type=\"radio\" name=\"sections_chemin\" value=\"1\">".adm_translate("Oui")." &nbsp;
         <input type=\"radio\" name=\"sections_chemin\" value=\"0\" checked>".adm_translate("Non");
      }
      echo "</td></tr></table>";
      echo "<input type=\"hidden\" name=\"op\" value=\"menu_dyn\">";
      echo "<input class=\"BOUTON_STANDARD\" type=\"submit\" value=\"".adm_translate("Valider")."\"></form>";
      CloseTable();
   }
   include("footer.php");
}

function new_rub_section($type) {
   global $hlpfile, $aid, $radminsuper;
   global $NPDS_Prefix;

   include("header.php");
   GraphicAdmin($hlpfile);
   if ($type=="sec") {
      OpenTable();
      echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"HEADER\">\n";
      echo adm_translate("Ajouter une nouvelle Sous-Rubrique");
      echo "</td></tr></table>\n";

      $rowcolor=tablos();
      echo "<table border=\"0\" width=\"100%\" cellpadding=\"2\" cellspacing=\"1\">
      <form action=\"admin.php\" method=\"post\" name=\"adminForm\">";
         
      echo "<tr $rowcolor><td width=\"20%\"><b>".adm_translate("Rubriques")."</b></td>";
      echo "<td width=\"80%\"><select class=\"textbox_standard\" name=\"rubref\">";
      if ($radminsuper==1) {
         $result = mysql_query("select rubid, rubname from ".$NPDS_Prefix."rubriques order by ordre");
      } else {
         $result = mysql_query("select distinct rubriques.rubid, rubriques.rubname from ".$NPDS_Prefix."rubriques, ".$NPDS_Prefix."publisujet where publisujet.aid='$aid' order by ordre");
      }
      while (list($rubid, $rubname) = mysql_fetch_array($result)) {
         echo "<option value=\"$rubid\">".aff_langue($rubname)."</option>";
      }
      echo "</select></td></tr>";

      echo "<tr $rowcolor><td width=\"20%\"><b>".adm_translate("Titre :")."</b></td>";
      echo "<td width=\"80%\"><textarea class=\"textbox\" name=\"secname\" cols=\"60\" rows=\"2\"></textarea></td></tr>";
      echo "<tr $rowcolor><td width=\"20%\"><b>".adm_translate("Image pour la Sous-Rubrique : ")."</b></td>";
      echo "<td width=\"80%\"><input type=\"text\" class=\"textbox\" name=\"image\" size=\"60\"></td></tr>";
      echo "<tr $rowcolor><td width=\"20%\"><b>".adm_translate("Texte d'introduction")."</b></td>";
      echo "<td><textarea class=\"textbox\" name=\"introd\" cols=\"60\" rows=\"30\" style=\"width: 100%;\"></textarea>";
      echo aff_editeur("introd","false");
      echo "</td></tr>";
         
      echo "<tr $rowcolor><td width=\"20%\"><b>".adm_translate("Niveau de l'Utilisateur")." :</b></td><td width=\"80%\">";
      droits("0");
      echo "</td></tr>";
      echo "<input type=\"hidden\" name=\"op\" value=\"sectionmake\">";
      echo "<tr $rowcolor><td colspan=\"2\"><input class=\"BOUTON_STANDARD\" type=\"submit\" value=\"".adm_translate("Ajouter")."\">&nbsp;&nbsp;<input class=\"BOUTON_STANDARD\" type=\"button\" onClick=\"javascript:history.back()\" value=\"".adm_translate("Retour en arrière")."\"></td></tr>";
      echo "</form></table>";
      CloseTable();
   } else if ($type=="rub") {
      if ($radminsuper==1) {
         OpenTable();
         echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"HEADER\">\n";
         echo adm_translate("Ajouter une nouvelle Rubrique");
         echo "</td></tr></table>\n";
      
         $rowcolor=tablos();
         echo "<table border=\"0\" width=\"100%\" cellpadding=\"2\" cellspacing=\"1\">";
         echo "<form action=\"admin.php\" method=\"post\" name=\"adminForm\">";
         echo "<tr $rowcolor><td width=\"20%\"><b>".adm_translate("Nom de la Rubrique : ")."</b></td>";
         echo "<td width=\"80%\"><textarea class=\"textbox\" name=\"rubname\" cols=\"60\" rows=\"2\"></textarea></td></tr>";
         echo "<tr $rowcolor><td width=\"20%\"><b>".adm_translate("Texte d'introduction")."</b></td>";
         echo "<td width=\"80%\"><textarea class=\"textbox\" name=\"introc\" cols=\"60\" rows=\"30\" style=\"width: 100%;\"></textarea>";
         echo aff_editeur("introc","false");
         echo "</td></tr>";
         echo "<input type=\"hidden\" name=\"op\" value=\"rubriquemake\">";
         echo "<tr $rowcolor><td colspan=\"2\"><input class=\"BOUTON_STANDARD\" type=\"submit\" value=\"".adm_translate("Ajouter")."\">&nbsp;&nbsp;<input class=\"BOUTON_STANDARD\" type=\"button\" onClick=\"javascript:history.back()\" value=\"".adm_translate("Retour en arrière")."\"></td></tr>";
         echo "</form></table>";
         CloseTable();
      } else {
         redirect_url("admin.php?op=sections");
      }
   }
   include("footer.php");
}

// Fonction publications connexes
function publishcompat($article) {
   include_once ("lib/togglediv.class.php");
   global $hlpfile, $aid, $radminsuper;
   global $NPDS_Prefix;

   $result2 = mysql_query("select title from ".$NPDS_Prefix."seccont where artid='$article'");
   list($titre) = mysql_fetch_row($result2);

   include("header.php");
   GraphicAdmin($hlpfile);
   $result = mysql_query("select rubid, rubname, enligne, ordre from ".$NPDS_Prefix."rubriques order by ordre");
   $toggle = new ToggleDiv(mysql_num_rows($result));
   OpenTable();
   echo "<form action=\"admin.php\" method=\"post\">";
   echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"HEADER\">\n";
   echo adm_translate("Publications connexes")." : ".aff_langue($titre);
   echo "</td></tr></table>\n";
   echo "<br />";
   echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\"><tr><td>\n";
   echo $toggle->All();
   echo "</td></tr>\n</table>\n<hr noshade class=\"ONGL\">";
   $i = 0;
   while (list($rubid, $rubname, $enligne, $ordre) = mysql_fetch_array($result)) {
      echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"HEADER\">\n";
      if ($enligne == 0) { $online = adm_translate("Hors Ligne"); } else if ($enligne == 1) { $online = adm_translate("En Ligne"); }
      echo $toggle->Img();
      echo aff_langue($rubname);
      echo "</td><td class=\"HEADER\" width=\"10%\" align=\"center\">$online</td></tr>\n</table>\n";
      echo $toggle->Begin();
      echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\"><tr><td align=\"right\">\n";
      echo "<table width=\"98%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\">\n";
      if ($radminsuper==1) {
         $result2 = mysql_query("select secid, secname from ".$NPDS_Prefix."sections where rubid='$rubid' order by ordre");
      } else {
         $result2 = mysql_query("select distinct sections.secid, sections.secname from ".$NPDS_Prefix."sections, ".$NPDS_Prefix."publisujet where sections.rubid='$rubid' and sections.secid=publisujet.secid2 and publisujet.aid='$aid' and publisujet.type='1' order by ordre");
      }
      if (mysql_num_rows($result2) > 0) {
         while (list($secid, $secname) = mysql_fetch_array($result2)) {
            echo "<tr><td class=\"HEADER\" colspan=\"2\"><b>&nbsp;&nbsp;".adm_translate("sous-rubrique")." ".aff_langue($secname)."</b></td></tr>";
            $result3 = mysql_query("select artid, title from ".$NPDS_Prefix."seccont where secid='$secid' order by ordre");
            if (mysql_num_rows($result3) > 0) {
               $rowcolor=tablos();
               while (list($artid, $title) = mysql_fetch_array($result3)) {
                  $i++;
                  $result4 = mysql_query("select id2 from ".$NPDS_Prefix."compatsujet where id2='$artid' and id1='$article'");
                  echo "<tr $rowcolor><td width=\"90%\">&nbsp;&nbsp;&nbsp;&nbsp;".aff_langue($title)."</td><td width=\"10%\">";
                  if (mysql_num_rows($result4) > 0) {
                     echo "<input type=\"checkbox\" name=\"admin_rub[$i]\" value=\"$artid\" checked></td></tr>";
                  } else {
                     echo "<input type=\"checkbox\" name=\"admin_rub[$i]\" value=\"$artid\"></td></tr>";
                  }
               }
            }
         }
      }
      echo "</table>";
      echo "</td></tr></table><br />";
      echo $toggle->End();
   }
   echo "<br /><input type=\"hidden\" name=\"article\" value=\"$article\">
         <input type=\"hidden\" name=\"op\" value=\"updatecompat\">
         <input type=\"hidden\" name=\"idx\" value=\"$i\">
         <input class=\"BOUTON_STANDARD\" type=\"submit\" value=\"".adm_translate("Valider")."\">&nbsp;&nbsp;<input class=\"BOUTON_STANDARD\" type=\"button\" onClick=\"javascript:history.back()\" value=\"".adm_translate("Retour en arrière")."\"></form>";
   CloseTable();
   include("footer.php");
}
function updatecompat($article, $admin_rub, $idx) {
   global $NPDS_Prefix;

   $result=mysql_query("delete from ".$NPDS_Prefix."compatsujet where id1='$article'");
   for ($j = 1; $j < ($idx+1); $j++) {
      if ($admin_rub[$j]!="") { $result=mysql_query("insert into ".$NPDS_Prefix."compatsujet values ('$article','$admin_rub[$j]')"); }
   }
   Header("Location: admin.php?op=secartedit&artid=$article");
}
// Fonction publications connexes

// Fonctions RUBRIQUES
function rubriquedit($rubid) {
   global $hlpfile, $radminsuper;
   global $NPDS_Prefix;

   if ($radminsuper!=1) {
      Header("Location: admin.php?op=sections");
   }
   $result = mysql_query("select rubid, rubname, intro, enligne, ordre from ".$NPDS_Prefix."rubriques where rubid='$rubid'");
   list($rubid, $rubname, $intro, $enligne, $ordre) = mysql_fetch_array($result);
   if (!mysql_num_rows($result)) {
      Header("Location: admin.php?op=sections");
   }
   include("header.php");
   GraphicAdmin($hlpfile);
   $result2 = mysql_query("select secid from ".$NPDS_Prefix."sections where rubid='$rubid'");
   $number = mysql_num_rows($result2);

   $rubname = stripslashes($rubname);
   $intro = stripslashes($intro);
   OpenTable();
   echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"HEADER\">\n";
   echo adm_translate("Editer une Rubrique : ")." ".aff_langue($rubname);
   if ($number)
      echo " / <span class=\"ROUGE\">$number </span>".adm_translate("sous-rubrique(s) attachée(s)");
   echo "</td></tr></table>\n";
   echo "<br />\n";

   $rowcolor=tablos();
   echo "<table border=\"0\" width=\"100%\" cellpadding=\"2\" cellspacing=\"1\">
         <form action=\"admin.php\" method=\"post\" name=\"adminForm\">
         <tr $rowcolor><td width=\"20%\"><b>".adm_translate("rubrique")."</b></td>
         <td width=\"80%\"><textarea class=\"textbox\" name=\"rubname\" cols=\"60\" rows=\"2\">$rubname</textarea></td></tr>
         <tr $rowcolor>
         <td><b>".adm_translate("Texte d'introduction")."</b></td>
         <td><textarea name=\"introc\" class=\"textbox\" cols=\"60\" rows=\"30\" style=\"width: 100%;\">$intro</textarea>\n";
   echo aff_editeur("introc","false");
   echo "</td></tr>
         <tr $rowcolor>
         <td><b>".adm_translate("En Ligne")."</td>";
   if ($radminsuper==1) {
      if ($enligne==1) {
         $sel1 = "checked"; $sel2 = "";
      } else {
         $sel1 = ""; $sel2 = "checked";
      }
   }
   echo "<td><input type=\"radio\" name=\"enligne\" value=\"0\" $sel2>".adm_translate("Non")."&nbsp;<input type=\"radio\" name=\"enligne\" value=\"1\" $sel1>".adm_translate("Oui")."&nbsp;</td></tr>
         <input type=\"hidden\" name=\"rubid\" value=\"$rubid\">
         <input type=\"hidden\" name=\"op\" value=\"rubriquechange\">
         <tr $rowcolor>
         <td colspan=\"2\"><input class=\"BOUTON_STANDARD\" type=\"submit\" value=\"".adm_translate("Enregistrer")."\">&nbsp;&nbsp;
         <input class=\"BOUTON_STANDARD\" type=\"button\" value=\"".adm_translate("Retour en arrière")."\" onClick=\"javascript:history.back()\"></td>
         </tr>
         </table></form>";
   CloseTable();
   include("footer.php");
}
function rubriquemake($rubname, $introc) {
   global $NPDS_Prefix;

   $rubname = stripslashes(FixQuotes($rubname));
   $introc = stripslashes(FixQuotes($introc));
   mysql_query("INSERT INTO ".$NPDS_Prefix."rubriques VALUES (NULL,'$rubname','$introc','0','0')");
   Header("Location: admin.php?op=ordremodule");
}
function rubriquechange($rubid,$rubname,$introc,$enligne) {
   global $NPDS_Prefix;

   $rubname = stripslashes(FixQuotes($rubname));
   $introc = stripslashes(FixQuotes($introc));
   mysql_query("update ".$NPDS_Prefix."rubriques set rubname='$rubname', intro='$introc', enligne='$enligne' where rubid='$rubid'");
   Header("Location: admin.php?op=sections");
}
// Fonctions RUBRIQUES

// Fonctions SECTIONS
function sectionedit($secid) {
   global $hlpfile, $radminsuper;
   global $NPDS_Prefix;

   include("header.php");
   GraphicAdmin($hlpfile);
   $result = mysql_query("select secid, secname, image, userlevel, rubid, intro from ".$NPDS_Prefix."sections where secid='$secid'");
   list($secid, $secname, $image, $userlevel, $rubref, $intro) = mysql_fetch_array($result);
   $secname = stripslashes($secname);
   $intro = stripslashes($intro);

   OpenTable();
   echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"HEADER\">\n";
   echo adm_translate("sous-rubrique")." ".aff_langue($secname);
   $result2 = mysql_query("select artid from ".$NPDS_Prefix."seccont where secid='$secid'");
   $number = mysql_num_rows($result2);
   if ($number)
      echo " / <span class=\"ROUGE\">$number </span>".adm_translate("publication(s) attachée(s)");
   echo "</td></tr></table>\n";

   $rowcolor=tablos();
   echo "<table border=\"0\" width=\"100%\" cellpadding=\"2\" cellspacing=\"1\">
         <form action=\"admin.php\" method=\"post\" name=\"adminForm\">
         <tr $rowcolor><td><b>".adm_translate("rubrique")." :</b></td>";
   if ($radminsuper==1) {
      echo "<td width=\"80%\"><select class=\"textbox\" name=\"rubref\">";
         $result = mysql_query("select rubid, rubname from ".$NPDS_Prefix."rubriques order by ordre");
         while(list($rubid, $rubname) = mysql_fetch_array($result)) {
            if ($rubref==$rubid) {$sel="selected"; } else {$sel=""; }
               echo "<option value=\"$rubid\" $sel>".aff_langue($rubname)."</option>";
            }
      echo "</select></td>";
   } else {
      echo "<input type=\"hidden\" name=\"rubref\" value=\"$rubref\">";
      $result = mysql_query("select rubname from ".$NPDS_Prefix."rubriques where rubid='$rubref'");
      list($rubname) = mysql_fetch_row($result);
      echo "<td width=\"80%\"><b>".aff_langue($rubname)."</b></tr>";
   }
   echo "</tr>
         <tr $rowcolor>
         <td><b>".adm_translate("sous-rubrique")." :</b></td>
         <td><textarea class=\"textbox\" name=\"secname\" cols=\"60\" rows=\"2\">$secname</textarea></td>
         </tr>
         <tr $rowcolor>
         <td><b>".adm_translate("images")." :</b></td>
         <td width=\"80%\"><input type=\"text\" class=\"textbox\" name=\"image\" value=\"$image\"></td>
         </tr>
         <tr $rowcolor>
         <td><b>".adm_translate("Texte d'introduction")." :</b></td>
         <td><textarea class=\"textbox\" name=\"introd\" cols=\"60\" rows=\"30\" style=\"width: 100%;\">$intro</textarea>";
   echo aff_editeur("introd","false");
   echo "</td></tr>";
   echo "<tr $rowcolor><td><b>".adm_translate("Niveau de l'Utilisateur")." :</b></td><td>";
   droits($userlevel);
   echo "</td></tr>
         <tr $rowcolor><td colspan=\"2\">";
   $droit_pub=droits_publication($secid);
   if ($droit_pub==3 or $droit_pub==7) {
      echo "<input type=\"hidden\" name=\"secid\" value=\"$secid\">
            <input type=\"hidden\" name=\"op\" value=\"sectionchange\">
            <input class=\"BOUTON_STANDARD\" type=\"submit\" value=\"".adm_translate("Enregistrer")."\">&nbsp;&nbsp;";
   }
   echo "<input class=\"BOUTON_STANDARD\" type=\"button\" value=\"".adm_translate("Retour en arrière")."\" onClick=\"javascript:history.back()\">";
   echo "</td></tr></form>
         </table>";
   CloseTable();
   include("footer.php");
}
function sectionmake($secname, $image, $members, $Mmembers, $rubref, $introd) {
   global $NPDS_Prefix;

   if (is_array($Mmembers) and ($members==1)) {
      $members=implode(",",$Mmembers);
      if ($members==0) $members=1;
   }

   $secname = stripslashes(FixQuotes($secname));
   $rubref = stripslashes(FixQuotes($rubref));
   $image = stripslashes(FixQuotes($image));
   $introd = stripslashes(FixQuotes($introd));
   mysql_query("INSERT INTO ".$NPDS_Prefix."sections VALUES (NULL,'$secname', '$image', '$members', '$rubref', '$introd','99','0')");
   Header("Location: admin.php?op=sections");
}
function sectionchange($secid, $secname, $image, $members, $Mmembers, $rubref, $introd) {
   global $NPDS_Prefix;

   if (is_array($Mmembers) and ($members==1)) {
      $members=implode(",",$Mmembers);
      if ($members==0) $members=1;
   }

   $secname = stripslashes(FixQuotes($secname));
   $image = stripslashes(FixQuotes($image));
   $introd = stripslashes(FixQuotes($introd));
   mysql_query("update ".$NPDS_Prefix."sections set secname='$secname', image='$image', userlevel='$members', rubid='$rubref', intro='$introd' where secid='$secid'");
   Header("Location: admin.php?op=sections");
}
// Fonctions SECTIONS

// Fonction ARTICLES
function secartedit($artid) {
   global $radminsuper, $radminsection, $hlpfile;
   global $NPDS_Prefix;

   if ($radminsuper!=1 and $radminsection!=1) {
      Header("Location: admin.php?op=sections");
   }

   $result2 = mysql_query("select author, artid, secid, title, content, userlevel, crit1, crit2, crit3, crit4, crit5, crit6, crit7, crit8, crit9, crit10, crit11, crit12, crit13, crit14, crit15, crit16, crit17, crit18, crit19, crit20 from ".$NPDS_Prefix."seccont where artid='$artid'");
   list($author, $artid, $secid, $title, $content, $userlevel, $crit1, $crit2, $crit3, $crit4, $crit5, $crit6, $crit7, $crit8, $crit9, $crit10, $crit11, $crit12, $crit13, $crit14, $crit15, $crit16, $crit17, $crit18, $crit19, $crit20) = mysql_fetch_array($result2);
   if (!$artid) {
      Header("Location: admin.php?op=sections");
   }

   include("header.php");
   GraphicAdmin($hlpfile);

   OpenTable();
   echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"HEADER\">\n";
   echo adm_translate("Editer une publication");
   echo "</td></tr></table>\n";

   $title = stripslashes($title);
   $content = stripslashes($content);
   echo "<table border=\"0\" width=\"100%\" cellpadding=\"4\" cellspacing=\"1\">
         <form action=\"admin.php\" method=\"post\" name=\"adminForm\"><br />
         <input type=\"hidden\" name=\"artid\" value=\"$artid\"><input type=\"hidden\" name=\"op\" value=\"secartchange\">";

   $rowcolor=tablos();
   echo "<tr $rowcolor><td><b>".adm_translate("sous-rubriques")."</b></td><td width=\"80%\">";
   $tmp_autorise=sousrub_select($secid);
   if ($tmp_autorise) {
      echo $tmp_autorise;
   } else {
      $result = mysql_query("select secname from ".$NPDS_Prefix."sections where secid='$secid'");
      list($secname) = mysql_fetch_array($result);
      echo "<b>".aff_langue($secname)."</b>";
      echo "<input type=\"hidden\" name=\"secid\" value=\"$secid\">";
   }
   echo "</td></tr>";
   if ($tmp_autorise)
      echo "<tr $rowcolor><td colspan=\"2\"><a href=\"admin.php?op=publishcompat&amp;article=$artid\" class=\"NOIR\">".adm_translate("Publications connexes")."</a></td></tr>";

  echo "<tr $rowcolor>
         <td><b>".adm_translate("Titre")."</b></td>
         <td><textarea class=\"textbox\" name=\"title\" cols=\"60\" rows=\"2\">$title</textarea></td>
         </tr>
         <tr $rowcolor>
         <td valign=\"top\"><b>".adm_translate("Contenu")."</b></td>
         <td><textarea class=\"textbox\" name=\"content\" cols=\"60\" rows=\"30\" style=\"width: 100%;\">$content</textarea>";
   echo aff_editeur("content","false")."</td>";
   echo "</tr>";
   echo "<input type=\"hidden\" name=\"crit1\" value=\"$crit1\"><input type=\"hidden\" name=\"crit2\" value=\"$crit2\">
         <input type=\"hidden\" name=\"crit3\" value=\"$crit3\"><input type=\"hidden\" name=\"crit4\" value=\"$crit4\">
         <input type=\"hidden\" name=\"crit5\" value=\"$crit5\"><input type=\"hidden\" name=\"crit6\" value=\"$crit6\">
         <input type=\"hidden\" name=\"crit7\" value=\"$crit7\"><input type=\"hidden\" name=\"crit8\" value=\"$crit8\">
         <input type=\"hidden\" name=\"crit9\" value=\"$crit9\"><input type=\"hidden\" name=\"crit10\" value=\"$crit10\">
         <input type=\"hidden\" name=\"crit11\" value=\"$crit11\"><input type=\"hidden\" name=\"crit12\" value=\"$crit12\">
         <input type=\"hidden\" name=\"crit13\" value=\"$crit13\"><input type=\"hidden\" name=\"crit14\" value=\"$crit14\">
         <input type=\"hidden\" name=\"crit15\" value=\"$crit15\"><input type=\"hidden\" name=\"crit16\" value=\"$crit16\">
         <input type=\"hidden\" name=\"crit17\" value=\"$crit17\"><input type=\"hidden\" name=\"crit18\" value=\"$crit18\">
         <input type=\"hidden\" name=\"crit19\" value=\"$crit19\"><input type=\"hidden\" name=\"crit20\" value=\"$crit20\">";

   echo "<tr $rowcolor><td><b>".adm_translate("Niveau de l'Utilisateur")."</b></td><td>";
   droits($userlevel);
   echo "</td></tr><tr $rowcolor><td colspan=\"2\">";
   $droits_pub=droits_publication($secid);
   if ($droits_pub==3 or $droits_pub==7) { echo "<input class=\"BOUTON_STANDARD\" type=\"submit\" value=\"".adm_translate("Enregistrer")."\">"; }
   echo "&nbsp;&nbsp;<input class=\"BOUTON_STANDARD\" type=\"button\" value=\"".adm_translate("Retour en arrière")."\" onClick=\"javascript:history.back()\">";
   echo "</td></form></tr></table>";
   CloseTable();
   include("footer.php");
}
function secartupdate($artid) {
   global $hlpfile, $aid, $radminsuper;
   global $NPDS_Prefix;

   $result = mysql_query("select author, artid, secid, title, content, userlevel, crit1, crit2, crit3, crit4, crit5, crit6, crit7, crit8, crit9, crit10, crit11, crit12, crit13, crit14, crit15, crit16, crit17, crit18, crit19, crit20 from ".$NPDS_Prefix."seccont_tempo where artid='$artid'");
   list($author, $artid, $secid, $title, $content, $userlevel, $crit1, $crit2, $crit3, $crit4, $crit5, $crit6, $crit7, $crit8, $crit9, $crit10, $crit11, $crit12, $crit13, $crit14, $crit15, $crit16, $crit17, $crit18, $crit19, $crit20) = mysql_fetch_array($result);

   $testpubli = mysql_query("select type from ".$NPDS_Prefix."publisujet where secid2='$secid' and aid='$aid' and type='1'");
   list($test_publi)=mysql_fetch_array($testpubli);
   if ($test_publi==1) {
      $debut = "<span class=\"ROUGE\">".adm_translate("Vos droits de publications vous permettent de mettre à jour ou de supprimer ce contenu mais pas de la mettre en ligne sur le site.")."<br /></span>";
      $fin = "<select class=\"TEXTBOX_STANDARD\" name=\"op\">
      <option value=\"secartchangeup\" selected>".adm_translate("Mettre à jour")."</option>
      <option value=\"secartdelete2\">".adm_translate("Supprimer")."</option>
      </select>&nbsp;&nbsp;<input type=\"submit\" class=\"BOUTON_STANDARD\" name=\"submit\" value=\"".adm_translate("Ok")."\">";
   }
   $testpubli = mysql_query("select type from ".$NPDS_Prefix."publisujet where secid2='$secid' and aid='$aid' and type='2'");
   list($test_publi)=mysql_fetch_array($testpubli);
   if (($test_publi==2) or ($radminsuper==1))  {
      $debut = "<span class=\"ROUGE\">".adm_translate("Vos droits de publications vous permettent de mettre à jour, de supprimer ou de le mettre en ligne sur le site ce contenu.")."<br /></span>";
      $fin = "<select class=\"TEXTBOX_STANDARD\" name=\"op\">
      <option value=\"secartchangeup\" selected>".adm_translate("Mettre à jour")."</option>
      <option value=\"secartdelete2\">".adm_translate("Supprimer")."</option>
      <option value=\"secartpublish\">".adm_translate("Publier")."</option>
      </select>&nbsp;&nbsp;<input type=\"submit\" class=\"BOUTON_STANDARD\" name=\"submit\" value=\"".adm_translate("Ok")."\">";
   }
   $fin.="&nbsp;&nbsp;<input class=\"BOUTON_STANDARD\" type=\"button\" value=\"".adm_translate("Retour en arrière")."\" onClick=\"javascript:history.back()\">";
   include("header.php");
   GraphicAdmin($hlpfile);
   OpenTable();
      echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"HEADER\">\n";
      echo adm_translate("Editer une publication");
      echo "</td></tr></table>\n";
      echo "<br />\n";
      echo $debut;
      echo "<br />\n";

      $title = stripslashes($title);
      $content = stripslashes($content);
      echo "<table border=\"0\" width=\"100%\" cellpadding=\"2\" cellspacing=\"1\">
      <form action=\"admin.php\" method=\"post\" name=\"adminForm\"><input type=\"hidden\" name=\"artid\" value=\"$artid\">";
      $rowcolor=tablos();
      echo "<tr $rowcolor><td width=\"20%\"><b>".adm_translate("sous-rubrique")."</b></td>";
      echo "<td width=\"80%\">";
      $tmp_autorise=sousrub_select($secid);
      if ($tmp_autorise) {
         echo $tmp_autorise;
      } else {
         $result = mysql_query("select secname from ".$NPDS_Prefix."sections where secid='$secid'");
         list($secname) = mysql_fetch_array($result);
         echo "<b>".aff_langue($secname)."</b>";
         echo "<input type=\"hidden\" name=\"secid\" value=\"$secid\">";
      }
      echo "</td></tr>";
      echo "<tr $rowcolor><td><b>".adm_translate("Titre")."</b></td>";
      echo "<td><textarea class=\"textbox\" name=\"title\" cols=\"60\" rows=\"2\">$title</textarea></td></tr>";
      echo "<tr $rowcolor><td><b>".adm_translate("Contenu")."</b></td>";
      echo "<td><textarea class=\"textbox\" name=\"content\" cols=\"60\" rows=\"30\" style=\"width: 100%;\">$content</textarea>";
      echo aff_editeur("content","false");
      echo "</td></tr>";
      echo "<input type=\"hidden\" name=\"crit1\" value=\"$crit1\"><input type=\"hidden\" name=\"crit2\" value=\"$crit2\">
            <input type=\"hidden\" name=\"crit3\" value=\"$crit3\"><input type=\"hidden\" name=\"crit4\" value=\"$crit4\">
            <input type=\"hidden\" name=\"crit5\" value=\"$crit5\"><input type=\"hidden\" name=\"crit6\" value=\"$crit6\">
            <input type=\"hidden\" name=\"crit7\" value=\"$crit7\"><input type=\"hidden\" name=\"crit8\" value=\"$crit8\">
            <input type=\"hidden\" name=\"crit9\" value=\"$crit9\"><input type=\"hidden\" name=\"crit10\" value=\"$crit10\">
            <input type=\"hidden\" name=\"crit11\" value=\"$crit11\"><input type=\"hidden\" name=\"crit12\" value=\"$crit12\">
            <input type=\"hidden\" name=\"crit13\" value=\"$crit13\"><input type=\"hidden\" name=\"crit14\" value=\"$crit14\">
            <input type=\"hidden\" name=\"crit15\" value=\"$crit15\"><input type=\"hidden\" name=\"crit16\" value=\"$crit16\">
            <input type=\"hidden\" name=\"crit17\" value=\"$crit17\"><input type=\"hidden\" name=\"crit18\" value=\"$crit18\">
            <input type=\"hidden\" name=\"crit19\" value=\"$crit19\"><input type=\"hidden\" name=\"crit20\" value=\"$crit20\">";

      echo "<tr $rowcolor><td><b>".adm_translate("Niveau de l'Utilisateur")."</b></td><td>";
      droits($userlevel);
      echo "<tr $rowcolor><td colspan=\"2\">".$fin."</td><tr>";
      echo "</form></table>";
   CloseTable();
   include("footer.php");
}
function secarticleadd($secid, $title, $content, $autho, $members, $Mmembers, $crit1, $crit2, $crit3, $crit4, $crit5, $crit6, $crit7, $crit8, $crit9, $crit10, $crit11, $crit12, $crit13, $crit14, $crit15, $crit16, $crit17, $crit18, $crit19, $crit20) {
   global $NPDS_Prefix;

   if (is_array($Mmembers) and ($members==1)) {
      $members=implode(",",$Mmembers);
   }
   $title = stripslashes(FixQuotes($title));
   $content = stripslashes(FixQuotes($content));
   $crit1 = stripslashes(FixQuotes($crit1));    $crit11 = stripslashes(FixQuotes($crit11));
   $crit2 = stripslashes(FixQuotes($crit2));    $crit12 = stripslashes(FixQuotes($crit12));
   $crit3 = stripslashes(FixQuotes($crit3));    $crit13 = stripslashes(FixQuotes($crit13));
   $crit4 = stripslashes(FixQuotes($crit4));    $crit14 = stripslashes(FixQuotes($crit14));
   $crit5 = stripslashes(FixQuotes($crit5));    $crit15 = stripslashes(FixQuotes($crit15));
   $crit6 = stripslashes(FixQuotes($crit6));    $crit16 = stripslashes(FixQuotes($crit16));
   $crit7 = stripslashes(FixQuotes($crit7));    $crit17 = stripslashes(FixQuotes($crit17));
   $crit8 = stripslashes(FixQuotes($crit8));    $crit18 = stripslashes(FixQuotes($crit18));
   $crit9 = stripslashes(FixQuotes($crit9));    $crit19 = stripslashes(FixQuotes($crit19));
   $crit10 = stripslashes(FixQuotes($crit10));  $crit20 = stripslashes(FixQuotes($crit20));

   global $radminsection, $radminsuper;
   if ($radminsuper==1) {
      $timestamp=time();
      mysql_query("INSERT INTO ".$NPDS_Prefix."seccont VALUES (NULL,'$secid','$title','$content','0','$autho','99','$members', '$crit1', '$crit2', '$crit3', '$crit4', '$crit5', '$crit6', '$crit7', '$crit8', '$crit9', '$crit10', '$crit11', '$crit12', '$crit13', '$crit14', '$crit15', '$crit16', '$crit17', '$crit18', '$crit19', '$crit20', '$timestamp')");
   } else if ($radminsection==1) {
      mysql_query("INSERT INTO ".$NPDS_Prefix."seccont_tempo VALUES (NULL,'$secid','$title','$content','0','$autho','99','$members', '$crit1', '$crit2', '$crit3', '$crit4', '$crit5', '$crit6', '$crit7', '$crit8', '$crit9', '$crit10', '$crit11', '$crit12', '$crit13', '$crit14', '$crit15', '$crit16', '$crit17', '$crit18', '$crit19', '$crit20')");
   }
   Header("Location: admin.php?op=sections");
}
function secartchange($artid, $secid, $title, $content, $members, $Mmembers, $crit1, $crit2, $crit3, $crit4, $crit5, $crit6, $crit7, $crit8, $crit9, $crit10, $crit11, $crit12, $crit13, $crit14, $crit15, $crit16, $crit17, $crit18, $crit19, $crit20) {
   global $NPDS_Prefix;

   if (is_array($Mmembers) and ($members==1)) {
      $members=implode(",",$Mmembers);
   }
   $title = stripslashes(FixQuotes($title));
   $content = stripslashes(FixQuotes($content));
   $crit1 = stripslashes(FixQuotes($crit1));    $crit11 = stripslashes(FixQuotes($crit11));
   $crit2 = stripslashes(FixQuotes($crit2));    $crit12 = stripslashes(FixQuotes($crit12));
   $crit3 = stripslashes(FixQuotes($crit3));    $crit13 = stripslashes(FixQuotes($crit13));
   $crit4 = stripslashes(FixQuotes($crit4));    $crit14 = stripslashes(FixQuotes($crit14));
   $crit5 = stripslashes(FixQuotes($crit5));    $crit15 = stripslashes(FixQuotes($crit15));
   $crit6 = stripslashes(FixQuotes($crit6));    $crit16 = stripslashes(FixQuotes($crit16));
   $crit7 = stripslashes(FixQuotes($crit7));    $crit17 = stripslashes(FixQuotes($crit17));
   $crit8 = stripslashes(FixQuotes($crit8));    $crit18 = stripslashes(FixQuotes($crit18));
   $crit9 = stripslashes(FixQuotes($crit9));    $crit19 = stripslashes(FixQuotes($crit19));
   $crit10 = stripslashes(FixQuotes($crit10));  $crit20 = stripslashes(FixQuotes($crit20));
   $timestamp=time();
   mysql_query("update ".$NPDS_Prefix."seccont set secid='$secid', title='$title', content='$content', userlevel='$members', crit1='$crit1', crit2='$crit2', crit3='$crit3', crit4='$crit4', crit5='$crit5', crit6='$crit6', crit7='$crit7', crit8='$crit8', crit9='$crit9', crit10='$crit10', crit11='$crit11', crit12='$crit12', crit13='$crit13', crit14='$crit14', crit15='$crit15', crit16='$crit16', crit17='$crit17', crit18='$crit18', crit19='$crit19', crit20='$crit20', timestamp='$timestamp' where artid='$artid'");
   Header("Location: admin.php?op=secartedit&artid=$artid");
}
function secartchangeup($artid, $secid, $title, $content, $members, $Mmembers, $crit1, $crit2, $crit3, $crit4, $crit5, $crit6, $crit7, $crit8, $crit9, $crit10, $crit11, $crit12, $crit13, $crit14, $crit15, $crit16, $crit17, $crit18, $crit19, $crit20) {
   global $NPDS_Prefix;

   if (is_array($Mmembers) and ($members==1)) {
      $members=implode(",",$Mmembers);
   }

   $title = stripslashes(FixQuotes($title));
   $content = stripslashes(FixQuotes($content));
   $crit1 = stripslashes(FixQuotes($crit1));     $crit11 = stripslashes(FixQuotes($crit11));
   $crit2 = stripslashes(FixQuotes($crit2));    $crit12 = stripslashes(FixQuotes($crit12));
   $crit3 = stripslashes(FixQuotes($crit3));    $crit13 = stripslashes(FixQuotes($crit13));
   $crit4 = stripslashes(FixQuotes($crit4));    $crit14 = stripslashes(FixQuotes($crit14));
   $crit5 = stripslashes(FixQuotes($crit5));    $crit15 = stripslashes(FixQuotes($crit15));
   $crit6 = stripslashes(FixQuotes($crit6));    $crit16 = stripslashes(FixQuotes($crit16));
   $crit7 = stripslashes(FixQuotes($crit7));    $crit17 = stripslashes(FixQuotes($crit17));
   $crit8 = stripslashes(FixQuotes($crit8));    $crit18 = stripslashes(FixQuotes($crit18));
   $crit9 = stripslashes(FixQuotes($crit9));    $crit19 = stripslashes(FixQuotes($crit19));
   $crit10 = stripslashes(FixQuotes($crit10));     $crit20 = stripslashes(FixQuotes($crit20));
   mysql_query("update ".$NPDS_Prefix."seccont_tempo set secid='$secid', title='$title', content='$content', userlevel='$members', crit1='$crit1', crit2='$crit2', crit3='$crit3', crit4='$crit4', crit5='$crit5', crit6='$crit6', crit7='$crit7', crit8='$crit8', crit9='$crit9', crit10='$crit10', crit11='$crit11', crit12='$crit12', crit13='$crit13', crit14='$crit14', crit15='$crit15', crit16='$crit16', crit17='$crit17', crit18='$crit18', crit19='$crit19', crit20='$crit20' where artid='$artid'");
   Header("Location: admin.php?op=secartupdate&artid=$artid");
}
function secartpublish($artid, $secid, $title, $content, $author, $members, $Mmembers, $crit1, $crit2, $crit3, $crit4, $crit5, $crit6, $crit7, $crit8, $crit9, $crit10, $crit11, $crit12, $crit13, $crit14, $crit15, $crit16, $crit17, $crit18, $crit19, $crit20) {
   global $NPDS_Prefix;

   if (is_array($Mmembers) and ($members==1)) {
      $members=implode(",",$Mmembers);
   }
   $title = stripslashes(FixQuotes($title));
   $content = stripslashes(FixQuotes($content));
   $crit1 = stripslashes(FixQuotes($crit1));    $crit11 = stripslashes(FixQuotes($crit11));
   $crit2 = stripslashes(FixQuotes($crit2));    $crit12 = stripslashes(FixQuotes($crit12));
   $crit3 = stripslashes(FixQuotes($crit3));    $crit13 = stripslashes(FixQuotes($crit13));
   $crit4 = stripslashes(FixQuotes($crit4));    $crit14 = stripslashes(FixQuotes($crit14));
   $crit5 = stripslashes(FixQuotes($crit5));    $crit15 = stripslashes(FixQuotes($crit15));
   $crit6 = stripslashes(FixQuotes($crit6));    $crit16 = stripslashes(FixQuotes($crit16));
   $crit7 = stripslashes(FixQuotes($crit7));    $crit17 = stripslashes(FixQuotes($crit17));
   $crit8 = stripslashes(FixQuotes($crit8));    $crit18 = stripslashes(FixQuotes($crit18));
   $crit9 = stripslashes(FixQuotes($crit9));    $crit19 = stripslashes(FixQuotes($crit19));
   $crit10 = stripslashes(FixQuotes($crit10));  $crit20 = stripslashes(FixQuotes($crit20));
   mysql_query("delete from ".$NPDS_Prefix."seccont_tempo where artid='$artid'");
   $timestamp=time();
   mysql_query("INSERT INTO ".$NPDS_Prefix."seccont VALUES (NULL,'$secid','$title','$content', '0', '$author', '99', '$members', '$crit1', '$crit2', '$crit3', '$crit4', '$crit5', '$crit6', '$crit7', '$crit8', '$crit9', '$crit10', '$crit11', '$crit12', '$crit13', '$crit14', '$crit15', '$crit16', '$crit17', '$crit18', '$crit19', '$crit20', '$timestamp')");

   $result = mysql_query("select email from authors where aid='$author'");
   list($lemail) = mysql_fetch_row($result);
   $sujet = adm_translate("Validation de votre publication");
   $message = adm_translate("La publication que vous aviez en attente vient d'être validée");
   global $notify_from;
   send_email($lemail, $sujet, $message, $notify_from);

   Header("Location: admin.php?op=sections");
}
// Fonction ARTICLES

// Fonctions de DELETE
function rubriquedelete($rubid, $ok=0) {
   global $NPDS_Prefix;

   // protection
   global $radminsuper;
   if (!$radminsuper) {
      Header("Location: admin.php?op=sections");
   }

   if ($ok==1) {
      $result=mysql_query("SELECT secid FROM ".$NPDS_Prefix."sections WHERE rubid='$rubid'");
      if (mysql_num_rows($result)>0) {
         while(list($secid)=mysql_fetch_array($result)) {
            $result2=mysql_query("SELECT artid FROM ".$NPDS_Prefix."seccont WHERE secid='$secid'");
            if (mysql_num_rows($result2)>0) {
               while(list($artid)=mysql_fetch_array($result2)) {
                  mysql_query("delete from ".$NPDS_Prefix."seccont where artid='$artid'");
                  mysql_query("delete from ".$NPDS_Prefix."compatsujet where id1='$artid'");
               }
            }
         }
      }
      mysql_query("delete from ".$NPDS_Prefix."sections where rubid='$rubid'");
      mysql_query("delete from ".$NPDS_Prefix."rubriques where rubid='$rubid'");
      Header("Location: admin.php?op=sections");
   } else {
      global $hlpfile;
      include("header.php");
      GraphicAdmin($hlpfile);
      $result=mysql_query("select rubname from ".$NPDS_Prefix."rubriques where rubid='$rubid'");
      list($rubname) = mysql_fetch_row($result);
      OpenTable();
      echo "<p align=\"center\"><b>".adm_translate("Effacer la Rubrique : ").aff_langue($rubname)."</b><br /><br />
      ".adm_translate("Etes-vous sûr de vouloir effacer cette Rubrique ?")."<br /><br />
      [ <a href=\"admin.php?op=rubriquedelete&amp;rubid=$rubid&amp;ok=1\" class=\"ROUGE\">".adm_translate("Oui")."</a> | <a href=\"admin.php?op=sections\" class=\"NOIR\">".adm_translate("Non")."</a> ]<br /></p>";
      closetable();
      include("footer.php");
   }
}
function sectiondelete($secid, $ok=0) {
   global $NPDS_Prefix;

   // protection
   $tmp=droits_publication($secid);
   if (($tmp!=7) and ($tmp!=4)) {
      Header("Location: admin.php?op=sections");
   }

   if ($ok==1) {
      $result=mysql_query("SELECT artid FROM ".$NPDS_Prefix."seccont WHERE secid='$secid'");
      if (mysql_num_rows($result)>0) {
         while(list($artid)=mysql_fetch_array($result)) {
            mysql_query("delete from ".$NPDS_Prefix."compatsujet where id1='$artid'");
         }
      }
      mysql_query("delete from ".$NPDS_Prefix."seccont where secid='$secid'");
      mysql_query("delete from ".$NPDS_Prefix."sections where secid='$secid'");
      Header("Location: admin.php?op=sections");
   } else {
      global $hlpfile;
      include("header.php");
      GraphicAdmin($hlpfile);
      $result=mysql_query("select secname from ".$NPDS_Prefix."sections where secid='$secid'");
      list($secname) = mysql_fetch_row($result);
      OpenTable();
      echo "<p align=\"center\"<b>".adm_translate("Effacer la sous-rubrique : ").aff_langue($secname)."</b><br /><br />
      ".adm_translate("Etes-vous sûr de vouloir effacer cette sous-rubrique ?")."<br /><br />
      [ <a href=\"admin.php?op=sectiondelete&amp;secid=$secid&amp;ok=1\" class=\"ROUGE\">".adm_translate("Oui")."</a> | <a href=\"admin.php?op=sections\" class=\"NOIR\">".adm_translate("Non")."</a> ]<br /></p>";
      closetable();
      include("footer.php");
   }
}
function secartdelete($artid,$ok=0) {
   global $NPDS_Prefix;

   // protection
   $result = mysql_query("select secid from ".$NPDS_Prefix."seccont where artid='$artid'");
   list($secid) = mysql_fetch_row($result);
   $tmp=droits_publication($secid);
   if (($tmp!=7) and ($tmp!=4)) {
      Header("Location: admin.php?op=sections");
   }

   if ($ok==1) {
      mysql_query("delete from ".$NPDS_Prefix."seccont where artid='$artid'");
      mysql_query("delete from ".$NPDS_Prefix."compatsujet where id1='$artid'");
      Header("Location: admin.php?op=sections");
   } else {
       global $hlpfile;
       include ('header.php');
       GraphicAdmin($hlpfile);
       opentable();
       $result = mysql_query("select title from ".$NPDS_Prefix."seccont where artid='$artid'");
       list($title) = mysql_fetch_row($result);
       echo "<p align=\"center\">".adm_translate("Etes-vous certain de vouloir effacer cette publication ?")." : ".aff_langue($title);
       echo "<br /><br />[ <a href=\"admin.php?op=secartdelete&amp;artid=$artid&amp;ok=1\" class=\"ROUGE\">".adm_translate("Oui")."</a> | <a href=\"admin.php?op=sections\" class=\"NOIR\">".adm_translate("Non")."</a> ]</p><br />";
       closetable();
       include("footer.php");
   }
}
function secartdelete2($artid, $ok=0) {
   global $NPDS_Prefix;

   if ($ok==1) {
      mysql_query("delete from ".$NPDS_Prefix."seccont_tempo where artid='$artid'");
      Header("Location: admin.php?op=sections");
   } else {
      global $hlpfile;
      include ('header.php');
      GraphicAdmin($hlpfile);
      opentable();
      $result = mysql_query("select title from ".$NPDS_Prefix."seccont_tempo where artid='$artid'");
      list($title) = mysql_fetch_row($result);
      echo "<p align=\"center\">".adm_translate("Etes-vous certain de vouloir effacer cette publication ?")." : ".aff_langue($title);
      echo "<br /><br />[ <a href=\"admin.php?op=secartdelete2&amp;artid=$artid&amp;ok=1\" class=\"ROUGE\">".adm_translate("Oui")."</a> | <a href=\"admin.php?op=sections\" class=\"NOIR\">".adm_translate("Non")."</a> ]</p><br />";
      closetable();
      include("footer.php");
   }
}
// Fonctions de DELETE

// Fonctions de classement
function ordremodule() {
   global $hlpfile, $radminsuper;
   global $NPDS_Prefix;

   if ($radminsuper <> 1) {
      Header("Location: admin.php?op=sections");
   }
   include("header.php");
   GraphicAdmin($hlpfile);
   OpenTable();
   echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"HEADER\">\n";
   echo adm_translate("Changer l'ordre")." ".adm_translate("des")." ".adm_translate("rubriques");
   echo "</td></tr></table>\n";
   echo "<br />\n";

   echo "<form action=\"admin.php\" method=\"post\" name=\"adminForm\"><br />";
   echo "<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"2\">
         <tr>
         <td class=\"HEADER\">".adm_translate("Rubriques")."</td>
         <td class=\"HEADER\">".adm_translate("Index")."</td>
         </tr>";
      
   $result = mysql_query("select rubid, rubname, ordre from ".$NPDS_Prefix."rubriques order by ordre");
   $i = 0;
   while(list($rubid, $rubname, $ordre) = mysql_fetch_array($result)) {
      $i++;
      $rowcolor=tablos();
      echo "<tr $rowcolor>
            <td width=\"95%\">".aff_langue($rubname)."</td>
            <td width=\"5%\"><input type=\"hidden\" name=\"rubid[$i]\" value=\"$rubid\">
            <input type=\"text\" class=\"TEXTBOX_STANDARD\" name=\"ordre[$i]\" value=\"$ordre\" size=\"3\"></td>
           </tr>";
      }
   echo "</table>";
   echo "<input type=\"hidden\" name=\"i\" value=\"$i\"><input type=\"hidden\" name=\"op\" value=\"majmodule\">
         <br /><input type=\"submit\" class=\"BOUTON_STANDARD\" value=\"".adm_translate("Valider")."\">
         &nbsp;&nbsp;<input type=\"button\" class=\"BOUTON_STANDARD\" value=\"".adm_translate("Retour en arrière")."\" onClick=\"javascript:history.back()\">
         </form>";
   CloseTable();
   include("footer.php");
}
function ordrechapitre() {
   global $rubname, $rubid, $hlpfile, $radminsuper;
   global $NPDS_Prefix;

   if ($radminsuper <> 1) {
      Header("Location: admin.php?op=sections");
   }
      
   include("header.php");
   GraphicAdmin($hlpfile);
   OpenTable();
   echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"HEADER\">\n";
   echo adm_translate("Changer l'ordre")." ".adm_translate("des")." ".adm_translate("sous-rubriques")." ".adm_translate("dans")." / ".$rubname;
   echo "</td></tr></table>\n";
   echo "<br />\n";

   echo "<form action=\"admin.php\" method=\"post\" name=\"adminForm\">";
   echo "<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"2\">
         <tr>
         <td class=\"HEADER\">".adm_translate("sous-rubrique")."</td>
         <td class=\"HEADER\">".adm_translate("Index")."</td>
         </tr>";
      
   $result = mysql_query("select secid, secname, ordre from ".$NPDS_Prefix."sections where rubid='$rubid' order by ordre");
   $i=0;
   while(list($secid, $secname, $ordre) = mysql_fetch_array($result)) {
      $rowcolor=tablos();
      $i++;
      echo "<tr $rowcolor>
           <td width=\"95%\">".aff_langue($secname)."</td>
           <td width=\"5%\"><input type=\"hidden\" name=\"secid[$i]\" value=\"$secid\">
           <input type=\"text\" class=\"TEXTBOX\" name=\"ordre[$i]\" value=\"$ordre\" size=\"3\"></td>
           </tr>";
   }
   echo "</table>";
   echo "<input type=\"hidden\" name=\"op\" value=\"majchapitre\">
         <br /><input type=\"submit\" class=\"BOUTON_STANDARD\" value=\"".adm_translate("Valider")."\">
         &nbsp;&nbsp;<input type=\"button\" class=\"BOUTON_STANDARD\" value=\"".adm_translate("Retour en arrière")."\" onClick=\"javascript:history.back()\">
         </form>";
   CloseTable();
   include("footer.php");
}
function ordrecours() {
   global $secid, $hlpfile, $radminsuper;
   global $NPDS_Prefix;

   if ($radminsuper <> 1) {
      Header("Location: admin.php?op=sections");
   }

   include("header.php");
   GraphicAdmin($hlpfile);
   OpenTable();
   $result = mysql_query("select secname from ".$NPDS_Prefix."sections where secid='$secid'");
   list($secname) = mysql_fetch_row($result);
   echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"HEADER\">\n";
   echo adm_translate("Changer l'ordre")." ".adm_translate("des")." ".adm_translate("publications")." / ".aff_langue($secname);
   echo "</td></tr></table>\n";
   echo "<br />\n";
   echo "<form action=\"admin.php\" method=\"post\" name=\"adminForm\">";
   echo "<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"2\">
         <tr>
         <td class=\"HEADER\">".adm_translate("publications")."</td>
         <td class=\"HEADER\">".adm_translate("Index")."</td>
         </tr>";
      
   $result = mysql_query("select artid, title, ordre from ".$NPDS_Prefix."seccont where secid='$secid' order by ordre");
   $i=0;
   while(list($artid, $title, $ordre) = mysql_fetch_array($result)) {
      $rowcolor=tablos();
      $i++;
      echo "<tr $rowcolor>
            <td width=\"95%\">".aff_langue($title)."</td>
            <td width=\"5%\"><input type=\"hidden\" name=\"artid[$i]\" value=\"$artid\">
            <input type=\"text\" class=\"TEXTBOX\" name=\"ordre[$i]\" value=\"$ordre\" size=\"3\"></td>
            </tr>";
   }
   echo "</table>";
   echo "<input type=\"hidden\" name=\"op\" value=\"majcours\">
         <br /><input type=\"submit\" class=\"BOUTON_STANDARD\" value=\"".adm_translate("Valider")."\">
         &nbsp;&nbsp;<input type=\"button\" class=\"BOUTON_STANDARD\" value=\"".adm_translate("Retour en arrière")."\" onClick=\"javascript:history.back()\">
         </form>";
   CloseTable();
   include("footer.php");
}
function updateordre($rubid, $artid, $secid, $op, $ordre) {
   global $NPDS_Prefix;

   global $radminsuper;
   if ($radminsuper!=1) {
      Header("Location: admin.php?op=sections");
   }

   if ($op=="majchapitre") {
      $i=count($secid);
      for ($j = 1; $j < ($i+1); $j++) {
         $sec = $secid[$j];
         $ord = $ordre[$j];
         $result=mysql_query("update ".$NPDS_Prefix."sections set ordre='$ord' where secid='$sec'");
      }
   }
   if ($op=="majmodule") {
      $i=count($rubid);
      for ($j = 1; $j < ($i+1); $j++) {
         $rub = $rubid[$j];
         $ord = $ordre[$j];
         $result=mysql_query("update ".$NPDS_Prefix."rubriques set ordre='$ord' where rubid='$rub'");
      }
   }
   if ($op=="majcours") {
      $i=count($artid);
      for ($j = 1; $j < ($i+1); $j++) {
         $art = $artid[$j];
         $ord = $ordre[$j];
         $result=mysql_query("update ".$NPDS_Prefix."seccont set ordre='$ord' where artid='$art'");
      }
   }
   Header("Location: admin.php?op=sections");
}
// Fonctions de classement

// Fonctions DROIT des AUTEURS
function publishrights($author) {
   global $NPDS_Prefix;

   global $radminsuper;
   if ($radminsuper!=1) {
      Header("Location: admin.php?op=sections");
   }

   global $hlpfile;
   include("header.php");
   GraphicAdmin($hlpfile);
   OpenTable();
   echo "<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\" border=\"0\"><tr><td class=\"HEADER\">\n";
   echo adm_translate("Droits des auteurs")." :: $author</td></tr></table>";

   echo "<form action=\"admin.php\" method=\"post\">";
   include_once ("lib/togglediv.class.php");
   $result1 = mysql_query("select rubid, rubname from ".$NPDS_Prefix."rubriques order by ordre");
   $numrow=mysql_num_rows($result1);
   $toggle = new ToggleDiv($numrow);
   echo $toggle->All();
   echo "<hr noshade class=\"ONGL\">";

   $i = 0;
   while(list($rubid, $rubname) = mysql_fetch_row($result1)) {
      echo "<table width=\"100%\" cellspacing=\"1\" cellpadding=\"0\" border=\"0\">
            <tr>
            <td class=\"HEADER\" width=\"40%\">";
            echo $toggle->Img();
            echo aff_langue($rubname)."</td>
            <td class=\"HEADER\"align=\"center\" width=\"15%\">".adm_translate("Créer")."</td>
            <td class=\"HEADER\"align=\"center\" width=\"15%\">".adm_translate("Publier")."</td>
            <td class=\"HEADER\"align=\"center\" width=\"15%\">".adm_translate("Modifier")."</td>
            <td class=\"HEADER\"align=\"center\" width=\"15%\">".adm_translate("Supprimer")."</td>
            </tr></table>";

      echo $toggle->Begin();
      $result2 = mysql_query("select secid, secname from ".$NPDS_Prefix."sections where rubid='$rubid' order by ordre");
      echo "<table width=\"100%\" cellspacing=\"1\" cellpadding=\"2\" border=\"0\">";
      $rowcolor = tablos();
      while(list($secid, $secname) = mysql_fetch_row($result2)) {
         $result3 = mysql_query("select type from ".$NPDS_Prefix."publisujet where secid2='$secid' and aid='$author'");
         $i++;
         $crea="";$publi="";$modif="";$supp="";
         if (mysql_num_rows($result3) > 0) {
            while(list($type) = mysql_fetch_row($result3)) {
               if ($type==1) {$crea="checked";}
               else if ($type==2) {$publi="checked";}
               else if ($type==3) {$modif="checked";}
               else if ($type==4) {$supp="checked";}
            }
         }
         echo "<tr $rowcolor>
               <td width=\"40%\">".aff_langue($secname)."</td>
               <td align=\"center\" width=\"15%\"><input type=\"checkbox\" name=\"creation[$i]\" value=\"$secid\" $crea></td>
               <td align=\"center\" width=\"15%\"><input type=\"checkbox\" name=\"publication[$i]\" value=\"$secid\" $publi></td>
               <td align=\"center\" width=\"15%\"><input type=\"checkbox\" name=\"modification[$i]\" value=\"$secid\" $modif></td>
               <td align=\"center\" width=\"15%\"><input type=\"checkbox\" name=\"suppression[$i]\" value=\"$secid\" $supp></td>
               </tr>";
      }
      echo "</table>";
      echo $toggle->End();
      echo "<br />";
   }
   echo "<input type=\"hidden\" name=\"chng_aid\" value=\"$author\">
         <input type=\"hidden\" name=\"op\" value=\"updatedroitauteurs\">
         <input type=\"hidden\" name=\"maxindex\" value=\"$i\">
         <input class=\"BOUTON_STANDARD\" type=\"submit\" value=\"".adm_translate("Valider")."\">&nbsp;&nbsp;<input class=\"BOUTON_STANDARD\" type=\"button\" onClick=\"javascript:history.back()\" value=\"".adm_translate("Retour en arrière")."\"></form>";

   closetable();
   include("footer.php");
}

function updaterights($chng_aid, $maxindex, $creation, $publication, $modification, $suppression) {
   global $NPDS_Prefix;

   global $radminsuper;
   if ($radminsuper!=1) {
      Header("Location: admin.php?op=sections");
   }
      
   $result=mysql_query("delete from ".$NPDS_Prefix."publisujet where aid='$chng_aid'");
   for ($j = 1; $j < ($maxindex+1); $j++) {
      if ($creation[$j]!="") { $result=mysql_query("insert into ".$NPDS_Prefix."publisujet values ('$chng_aid','$creation[$j]','1')"); }
      if ($publication[$j]!="") { $result=mysql_query("insert into ".$NPDS_Prefix."publisujet values ('$chng_aid','$publication[$j]','2')"); }
      if ($modification[$j]!="") { $result=mysql_query("insert into ".$NPDS_Prefix."publisujet values ('$chng_aid','$modification[$j]','3')"); }
      if ($suppression[$j]!="") { $result=mysql_query("insert into ".$NPDS_Prefix."publisujet values ('$chng_aid','$suppression[$j]','4')"); }
   }
   Header("Location: admin.php?op=sections");
}
// Fonctions DROIT des AUTEURS

// Fonctions Param du menu barre des sections
function menudyn_save($sections_menudyn, $sections_chemin, $sections_menudynx, $sections_menudyny, $sections_menudynb, $sections_menudynf, $sections_menudynr, $sections_menudynha, $sections_menudynla, $sections_menudynlb, $sections_menudyntps, $togglesection) {
   $file = fopen("sections.config.php", "w");
   $content = "<?PHP\n";
   $content .= "$line";
   $content .= "# NPDS V : Net Portal Dynamic System\n";
   $content .= "# ===================================================\n";
   $content .= "#\n";
   $content .= "# This version name NPDS Copyright (c) 2001-2004 by Philippe Brunier\n";
   $content .= "#\n";
   $content .= "# This module is to configure de Sections Bar Menu\n";
   $content .= "#\n";
   $content .= "# This program is free software. You can redistribute it and/or modify\n";
   $content .= "# it under the terms of the GNU General Public License as published by\n";
   $content .= "# the Free Software Foundation; either version 2 of the License.\n";
   $content .= "\n";
   $content .= "\$sections_menudyn=$sections_menudyn;\n";
   $content .= "\$sections_chemin=$sections_chemin;\n";

   if (!$sections_menudynx) $sections_menudynx=150;
   $content .= "\$sections_menudynx=$sections_menudynx;\n";

   if (!$sections_menudyny) $sections_menudyny=80;
   $content .= "\$sections_menudyny=$sections_menudyny;\n";

   if (!$sections_menudynb) $sections_menudynb="FF0000";
   $content .= "\$sections_menudynb=\"$sections_menudynb\";\n";

   if (!$sections_menudynf) $sections_menudynf="FFFFFF";
   $content .= "\$sections_menudynf=\"$sections_menudynf\";\n";

   if (!$sections_menudynr) $sections_menudynr="CCBBAA";
   $content .= "\$sections_menudynr=\"$sections_menudynr\";\n";

   if (!$sections_menudynha) $sections_menudynha="30";
   $content .= "\$sections_menudynha=\"$sections_menudynha\";\n";

   if (!$sections_menudynla) $sections_menudynla="140";
   $content .= "\$sections_menudynla=\"$sections_menudynla\";\n";

   if (!$sections_menudynlb) $sections_menudynlb="120";
   $content .= "\$sections_menudynlb=\"$sections_menudynlb\";\n";

   if (!$sections_menudyntps) $sections_menudyntps="500";
   $content .= "\$sections_menudyntps=\"$sections_menudyntps\";\n";

   $content .= "\$togglesection=$togglesection;\n";
   $content .= "?>";
   fwrite($file, $content);
   fclose($file);
   Header("Location: admin.php?op=sections");
}
// Fonctions Param du menu barre des sections

switch ($op) {
      case "new_rub_section":    new_rub_section($type); break;
      case "sections":           sections(); break;
      case "sectionedit":        sectionedit($secid); break;
      case "sectionmake":        sectionmake($secname, $image, $members, $Mmembers, $rubref, $introd); break;
      case "sectiondelete":      sectiondelete($secid, $ok); break;
      case "sectionchange":      sectionchange($secid, $secname, $image, $members, $Mmembers, $rubref, $introd); break;

      case "rubriquedit":        rubriquedit($rubid); break;
      case "rubriquemake":       rubriquemake($rubname, $introc); break;
      case "rubriquedelete":     rubriquedelete($rubid, $ok); break;
      case "rubriquechange":     rubriquechange($rubid,$rubname,$introc,$enligne); break;

      case "secarticleadd":      secarticleadd($secid, $title, $content, $autho, $members, $Mmembers, $crit1, $crit2, $crit3, $crit4, $crit5, $crit6, $crit7, $crit8, $crit9, $crit10, $crit11, $crit12, $crit13, $crit14, $crit15, $crit16, $crit17, $crit18, $crit19, $crit20); break;
      case "secartedit":         secartedit($artid); break;
      case "secartchange":       secartchange($artid, $secid, $title, $content, $members, $Mmembers, $crit1, $crit2, $crit3, $crit4, $crit5, $crit6, $crit7, $crit8, $crit9, $crit10, $crit11, $crit12, $crit13, $crit14, $crit15, $crit16, $crit17, $crit18, $crit19, $crit20); break;
      case "secartchangeup":     secartchangeup($artid, $secid, $title, $content, $members, $Mmembers, $crit1, $crit2, $crit3, $crit4, $crit5, $crit6, $crit7, $crit8, $crit9, $crit10, $crit11, $crit12, $crit13, $crit14, $crit15, $crit16, $crit17, $crit18, $crit19, $crit20); break;
      case "secartdelete":       secartdelete($artid, $ok); break;
      case "secartpublish":      secartpublish($artid, $secid, $title, $content, $author, $members, $Mmembers, $crit1, $crit2, $crit3, $crit4, $crit5, $crit6, $crit7, $crit8, $crit9, $crit10, $crit11, $crit12, $crit13, $crit14, $crit15, $crit16, $crit17, $crit18, $crit19, $crit20); break;
      case "secartupdate":       secartupdate($artid); break;
      case "secartdelete2":      secartdelete2($artid, $ok); break;

      case "ordremodule":        ordremodule(); break;
      case "ordrechapitre":      ordrechapitre(); break;
      case "ordrecours":         ordrecours(); break;

      case "majmodule":          updateordre($rubid, $artid, $secid, $op, $ordre); break;
      case "majchapitre":        updateordre($rubid, $artid, $secid, $op, $ordre); break;
      case "majcours":           updateordre($rubid, $artid, $secid, $op, $ordre); break;

      case "publishcompat":      publishcompat($article); break;
      case "updatecompat":       updatecompat($article, $admin_rub, $idx); break;
      
      case "droitauteurs":       publishrights($author); break;
      case "updatedroitauteurs": updaterights($chng_aid, $maxindex, $creation, $publication, $modification, $suppression); break;

      case "menu_dyn":           menudyn_save($sections_menudyn, $sections_chemin, $sections_menudynx, $sections_menudyny, $sections_menudynb, $sections_menudynf, $sections_menudynr, $sections_menudynha, $sections_menudynla, $sections_menudynlb, $sections_menudyntps, $togglesection); break;
}
?>