function fetch_data()
 {
     global $dbh, $lang, $include_path;
     if (file_exists($include_path . "/section_param/{$lang}.xml")) {
         _parser_($include_path . "/section_param/{$lang}.xml", array("SECTION" => "_section_"), "PMBSECTIONS");
         $this->allow_section = 1;
     }
     $this->subst_param = array();
     $myQuery = pmb_mysql_query("SELECT * FROM param_subst where subst_type_param= '" . $this->type . "' and  subst_module_param= '" . $this->module . "' and subst_module_num= '" . $this->module_num . "' ", $dbh);
     if (pmb_mysql_num_rows($myQuery)) {
         while ($r = pmb_mysql_fetch_assoc($myQuery)) {
             $this->subst_param[] = $r;
         }
     }
     $this->no_subst_param = array();
     $myQuery = pmb_mysql_query("SELECT * FROM parametres where type_param= '" . $this->type . "' and gestion=0 order by section_param,sstype_param", $dbh);
     while ($r = pmb_mysql_fetch_assoc($myQuery)) {
         $found = 0;
         foreach ($this->subst_param as $key => $subst_param) {
             if ($subst_param['subst_sstype_param'] == $r['sstype_param']) {
                 $this->subst_param[$key]['valeur_param_origine'] = $r['valeur_param'];
                 $this->subst_param[$key]['section_param'] = $r['section_param'];
                 $found = 1;
                 break;
             }
         }
         if (!$found) {
             $this->no_subst_param[] = $r;
         }
     }
 }

 function __construct($notice_ids, $filter_by_view = 1)
 {
     if (is_array($notice_ids)) {
         $notice_ids = implode(',', $notice_ids);
     }
     $this->notice_ids = $notice_ids;
     if ($this->notice_ids != '') {
         //filtrage sur statut ou droits d'accès..
         $query = $this->_get_filter_query();
         $res = pmb_mysql_query($query);
         $this->notice_ids = "";
         if (pmb_mysql_num_rows($res)) {
             while ($row = pmb_mysql_fetch_assoc($res)) {
                 if ($this->notice_ids != "") {
                     $this->notice_ids .= ",";
                 }
                 $this->notice_ids .= $row['id_notice'];
             }
         }
         //filtrage par vue...
         if ($filter_by_view) {
             $this->_filter_by_view();
         }
     }
 }

 function __construct($notice_ids, $user = 0)
 {
     global $PMBuserid;
     $this->user = $user;
     if ($this->user = 0) {
         $this->user = $PMBuserid;
     }
     $this->notice_ids = $notice_ids;
     if ($this->notice_ids != '') {
         //filtrage sur statut ou droits d'accès..
         $query = $this->_get_filter_query();
         if ($query) {
             $res = pmb_mysql_query($query);
             $this->notice_ids = "";
             if (pmb_mysql_num_rows($res)) {
                 while ($row = pmb_mysql_fetch_assoc($res)) {
                     if ($this->notice_ids != "") {
                         $this->notice_ids .= ",";
                     }
                     $this->notice_ids .= $row['id_notice'];
                 }
             }
         }
     }
 }

 function listBannettesAuto($filtre_search = "", $id_classement = 0)
 {
     global $dbh;
     if (SESSrights & DSI_AUTH) {
         $result = array();
         //auto = 1 : bannettes automatiques sans contrôle de date
         $auto = 1;
         $filtre_search = str_replace("*", "%", $filtre_search);
         if ($filtre_search) {
             $clause = "WHERE nom_bannette like '{$filtre_search}%' and bannette_auto='{$auto}' ";
         } else {
             $clause = "WHERE bannette_auto='{$auto}' ";
         }
         //			if ($id_classement!=0) $clause.= " and num_classement=0 ";
         if ($id_classement > 0) {
             $clause .= " and num_classement='{$id_classement}' ";
         }
         $requete = "SELECT COUNT(1) FROM bannettes {$clause} ";
         $res = pmb_mysql_query($requete, $dbh);
         $nbr_lignes = pmb_mysql_result($res, 0, 0);
         if ($nbr_lignes) {
             $requete = "SELECT id_bannette, nom_bannette, date_last_remplissage, date_last_envoi, proprio_bannette, bannette_auto, nb_notices_diff FROM bannettes {$clause} ORDER BY nom_bannette, id_bannette ";
             $res = pmb_mysql_query($requete, $dbh);
             while ($row = pmb_mysql_fetch_assoc($res)) {
                 $result[] = array("id_bannette" => $row["id_bannette"], "nom_bannette" => utf8_normalize($row["nom_bannette"]), "date_last_remplissage" => $row["date_last_remplissage"], "date_last_envoi" => $row["date_last_envoi"], "proprio_bannette" => $row["proprio_bannette"], "bannette_auto" => $row["bannette_auto"], "nb_notices_diff" => $row["nb_notices_diff"]);
             }
         }
         return $result;
     } else {
         return array();
     }
 }

 function indexGlobal()
 {
     global $msg, $dbh, $charset, $PMBusername;
     if (SESSrights & ADMINISTRATION_AUTH) {
         $result .= "<h3>" . htmlentities($msg["nettoyage_reindex_global"], ENT_QUOTES, $charset) . "</h3>";
         pmb_mysql_query("set wait_timeout=3600");
         //remise a zero de la table au début
         pmb_mysql_query("delete from notices_global_index", $dbh);
         pmb_mysql_query("delete from notices_mots_global_index", $dbh);
         $query = pmb_mysql_query("select notice_id from notices order by notice_id");
         if (pmb_mysql_num_rows($query)) {
             while ($mesNotices = pmb_mysql_fetch_assoc($query)) {
                 // Mise à jour de la table "notices_global_index"
                 notice::majNoticesGlobalIndex($mesNotices['notice_id']);
                 // Mise à jour de la table "notices_mots_global_index"
                 notice::majNoticesMotsGlobalIndex($mesNotices['notice_id']);
             }
             pmb_mysql_free_result($query);
         }
         $not = pmb_mysql_query("SELECT count(1) FROM notices_global_index", $dbh);
         $count = pmb_mysql_result($not, 0, 0);
         $result .= $count . " " . htmlentities($msg["nettoyage_res_reindex_global"], ENT_QUOTES, $charset);
     } else {
         $result .= sprintf($msg["planificateur_rights_bad_user_rights"], $PMBusername);
     }
     return $result;
 }

 public function get_authors_informations()
 {
     $return = array();
     $query = "select count(author_id) as nb from authors";
     $result = pmb_mysql_query($query);
     if (pmb_mysql_num_rows($result)) {
         $return = pmb_mysql_fetch_assoc($result);
     }
     return $return;
 }

 function list_agnostic_repositories($source_id, $notice)
 {
     $result = array();
     $sql = 'SELECT source_id, comment, name FROM connectors_sources WHERE id_connector = \'agnostic\'';
     $res = pmb_mysql_query($sql);
     while ($row = pmb_mysql_fetch_assoc($res)) {
         $result[] = array('id' => $row["source_id"], 'name' => utf8_normalize($row["name"]), 'comment' => utf8_normalize($row["comment"]));
     }
     return $result;
 }

 function fetch_data()
 {
     global $dbh;
     $this->subst_param = array();
     $myQuery = pmb_mysql_query("SELECT * FROM param_subst where subst_type_param= '" . $this->type . "' and  subst_module_param= '" . $this->module . "' and subst_module_num= '" . $this->module_num . "' ", $dbh);
     if (pmb_mysql_num_rows($myQuery)) {
         while ($r = pmb_mysql_fetch_assoc($myQuery)) {
             $this->subst_param[] = $r;
         }
     }
 }

 function listProcs()
 {
     global $dbh;
     if (SESSrights & ADMINISTRATION_AUTH) {
         $result = array();
         $rqt = 'select idproc, name, requete, comment from procs';
         $res = pmb_mysql_query($rqt, $dbh);
         while ($row = pmb_mysql_fetch_assoc($res)) {
             $result[] = array('idproc' => $row->idproc, 'name' => $row->name, 'requete' => $row->requete, 'comment' => $row->comment);
         }
         return $result;
     } else {
         return array();
     }
 }

 function listEntrepotSources()
 {
     global $dbh;
     if (SESSrights & ADMINISTRATION_AUTH) {
         $result = array();
         $requete = "select source_id, id_connector, comment, name from connectors_sources where repository=1";
         $res = pmb_mysql_query($requete) or die(pmb_mysql_error());
         while ($row = pmb_mysql_fetch_assoc($res)) {
             $result[] = array("source_id" => $row["source_id"], "id_connector" => utf8_normalize($row["id_connector"]), "comment" => utf8_normalize($row["comment"]), "name_connector_in" => utf8_normalize($row["name"]));
         }
         return $result;
     } else {
         return array();
     }
 }

 function render($context, $stream)
 {
     global $dbh;
     $query_stream = new StreamWriter();
     $this->pmb_query->render($context, $query_stream);
     $query = $query_stream->close();
     $result = pmb_mysql_query($query, $dbh);
     if (pmb_mysql_num_rows($result)) {
         $struct = array();
         while ($row = pmb_mysql_fetch_assoc($result)) {
             $struct[] = $row;
         }
         $context->set($this->struct_name, $struct);
     } else {
         $context->set($this->struct_name, 0);
     }
 }

 function getStatopacView($id_view)
 {
     global $dbh;
     if (SESSrights & ADMINISTRATION_AUTH) {
         $result = array();
         $query = "select * from statopac_vue_" . $id_view;
         $res = pmb_mysql_query($query, $dbh);
         if ($res) {
             while ($row = pmb_mysql_fetch_assoc($res)) {
                 $result[] = $row;
             }
         }
         return $result;
     } else {
         return array();
     }
 }

 /**
  * Pour initialiser un parcours des tris
  * Retourne le nombre de tris
  */
 function initParcoursTris($objSort)
 {
     //on initialise la position du parcours
     $this->posParcours = 0;
     $this->nbResult = 0;
     $this->tabParcours = null;
     switch ($this->typeData) {
         case 'base':
             $result = pmb_mysql_query("SELECT id_tri, nom_tri, tri_par FROM tris WHERE tri_reference='" . $this->sortName . "' ORDER BY nom_tri;");
             //echo "SELECT id_tri, nom_tri, tri_par FROM tris WHERE tri_reference='" . $this->sortName . "' ORDER BY nom_tri<br />";
             if ($result) {
                 //on charge les tris dans un tableau
                 while ($this->tabParcours[$this->nbResult] = pmb_mysql_fetch_assoc($result)) {
                     $this->nbResult++;
                 }
                 pmb_mysql_free_result($result);
                 //s'il n'y a pas de tris
                 if ($this->nbResult == 0) {
                     //on vide la session stockant le tri en cours
                     $_SESSION["tri"] = "";
                 }
                 return $this->nbResult;
             } else {
                 $_SESSION["tri"] = "";
                 return 0;
             }
             break;
         case 'session':
             $this->nbResult = $_SESSION["nb_sort" . $this->sortName];
             //s'il n'y a pas de tris
             if ($this->nbResult == 0) {
                 //on vide la session stockant le tri en cours
                 $_SESSION["last_sort" . $this->sortName] = "";
             } else {
                 //on charge les tris dans un tableau
                 for ($i = 0; $i < $this->nbResult; $i++) {
                     $this->tabParcours[$i]["id_tri"] = $i;
                     $this->tabParcours[$i]["nom_tri"] = $objSort->descriptionTri($_SESSION["sort" . $this->sortName . $i]);
                     $this->tabParcours[$i]["tri_par"] = $_SESSION["sort" . $this->sortName . $i];
                 }
             }
             return $this->nbResult;
             break;
     }
 }

 function get_publisher_information($publisher_id)
 {
     global $dbh;
     global $msg;
     $result = array();
     $publisher_id += 0;
     if (!$publisher_id) {
         throw new Exception("Missing parameter: publisher_id");
     }
     $sql = "SELECT * FROM publishers WHERE ed_id = " . $publisher_id;
     $res = pmb_mysql_query($sql);
     if (!$res) {
         throw new Exception("Not found: publisher_id = " . $publisher_id);
     }
     $row = pmb_mysql_fetch_assoc($res);
     $result = array("publisher_id" => $row["ed_id"], "publisher_name" => utf8_normalize($row["ed_name"]), "publisher_address1" => utf8_normalize($row["ed_adr1"]), "publisher_address2" => utf8_normalize($row["ed_adr2"]), "publisher_zipcode" => utf8_normalize($row["ed_cp"]), "publisher_city" => utf8_normalize($row["ed_ville"]), "publisher_country" => utf8_normalize($row["ed_pays"]), "publisher_web" => utf8_normalize($row["ed_web"]), "publisher_comment" => utf8_normalize($row["ed_comment"]), "publisher_links" => $this->proxy_parent->pmbesAutLinks_getLinks(3, $publisher_id));
     return $result;
 }

 function get_author_information($author_id)
 {
     global $dbh;
     global $msg;
     $result = array();
     $author_id += 0;
     if (!$author_id) {
         throw new Exception("Missing parameter: author_id");
     }
     $sql = "SELECT * FROM authors WHERE author_id = " . $author_id;
     $res = pmb_mysql_query($sql);
     if (!$res) {
         throw new Exception("Not found: author_id = " . $author_id);
     }
     $row = pmb_mysql_fetch_assoc($res);
     $result = array("author_id" => $row["author_id"], "author_type" => $row["author_type"], "author_name" => utf8_normalize($row["author_name"]), "author_rejete" => utf8_normalize($row["author_rejete"]), "author_see" => $row["author_see"], "author_date" => utf8_normalize($row["author_date"]), "author_web" => utf8_normalize($row["author_web"]), "author_comment" => utf8_normalize($row["author_comment"]), "author_lieu" => utf8_normalize($row["author_lieu"]), "author_ville" => utf8_normalize($row["author_ville"]), "author_pays" => utf8_normalize($row["author_pays"]), "author_subdivision" => utf8_normalize($row["author_subdivision"]), "author_numero" => utf8_normalize($row["author_numero"]));
     if (method_exists($this->proxy_parent, "pmbesAutLinks_getLinks")) {
         $result['author_links'] = $this->proxy_parent->pmbesAutLinks_getLinks(1, $author_id);
     } else {
         $result['author_links'] = array();
     }
     return $result;
 }

 function get_empr_information($idempr)
 {
     global $pmb_lecteurs_localises, $deflt_docs_location;
     global $dbh;
     global $msg;
     if (SESSrights & CIRCULATION_AUTH) {
         $result = array();
         $empr_id += 0;
         if (!$idempr) {
             throw new Exception("Missing parameter: idempr");
         }
         $sql = "SELECT id_empr, empr_cb, empr_nom, empr_prenom FROM empr WHERE id_empr = " . $idempr;
         $res = pmb_mysql_query($sql);
         if (!$res) {
             throw new Exception("Not found: idempr = " . $idempr);
         }
         $row = pmb_mysql_fetch_assoc($res);
         $result = $row;
         return $result;
     } else {
         return array();
     }
 }

 function fetch_data()
 {
     global $dbh;
     $this->docs_location_data = array();
     if ($this->id) {
         $requete = "SELECT * FROM sur_location WHERE surloc_id='" . $this->id . "' LIMIT 1";
         $res = pmb_mysql_query($requete, $dbh) or die(pmb_mysql_error() . "<br />{$requete}");
         if (pmb_mysql_num_rows($res)) {
             $row = pmb_mysql_fetch_object($res);
         }
         $this->libelle = $row->surloc_libelle;
         $this->pic = $row->surloc_pic;
         $this->visible_opac = $row->surloc_visible_opac;
         $this->name = $row->surloc_name;
         $this->adr1 = $row->surloc_adr1;
         $this->adr2 = $row->surloc_adr2;
         $this->cp = $row->surloc_cp;
         $this->town = $row->surloc_town;
         $this->state = $row->surloc_state;
         $this->country = $row->surloc_country;
         $this->phone = $row->surloc_phone;
         $this->email = $row->surloc_email;
         $this->website = $row->surloc_website;
         $this->logo = $row->surloc_logo;
         $this->comment = $row->surloc_comment;
         $this->num_infopage = $row->surloc_num_infopage;
         $this->css_style = $row->surloc_css_style;
         $requete = "SELECT * FROM docs_location where surloc_num='" . $this->id . "' or surloc_num=0 ORDER BY location_libelle";
     } else {
         $requete = "SELECT * FROM docs_location where surloc_num=0 ORDER BY location_libelle";
     }
     $myQuery = pmb_mysql_query($requete, $dbh);
     while ($r = pmb_mysql_fetch_assoc($myQuery)) {
         $this->docs_location_data[] = $r;
     }
     $this->get_list();
 }

 function update_config_from_form()
 {
     global $dbh;
     parent::update_config_from_form();
     global $repo_name, $admin_email, $included_sets, $repositoryIdentifier, $chunksize, $token_lifeduration, $cache_complete_records, $cache_complete_records_seconds, $link_status_to_deletion, $linked_status_to_deletion, $allow_gzip_compression, $baseURL, $include_items, $suppr_feuille_xslt;
     global $deletion_management, $deletion_management_transient_duration;
     //les trucs faciles
     $this->config["repo_name"] = stripslashes($repo_name);
     $this->config["admin_email"] = stripslashes($admin_email);
     $this->config["repositoryIdentifier"] = stripslashes($repositoryIdentifier);
     $this->config["chunksize"] = $chunksize + 0;
     $this->config["token_lifeduration"] = $token_lifeduration + 0;
     $this->config["cache_complete_records"] = isset($cache_complete_records);
     $this->config["cache_complete_records_seconds"] = $cache_complete_records_seconds + 0;
     $this->config["link_status_to_deletion"] = isset($link_status_to_deletion);
     $this->config["linked_status_to_deletion"] = $linked_status_to_deletion + 0;
     $this->config["allow_gzip_compression"] = isset($allow_gzip_compression);
     $this->config["baseURL"] = stripslashes($baseURL);
     $this->config["include_items"] = isset($include_items);
     $this->config["deletion_management"] = $deletion_management;
     $this->config["deletion_management_transient_duration"] = $deletion_management_transient_duration * 1;
     if (!$_FILES['feuille_xslt']['error']) {
         $this->config['feuille_xslt'] = file_get_contents($_FILES['feuille_xslt']['tmp_name']);
         $this->config['feuille_xslt_name'] = $_FILES['feuille_xslt']['name'];
     }
     if ($suppr_feuille_xslt) {
         $this->config['feuille_xslt'] = "";
         $this->config['feuille_xslt_name'] = "";
     }
     $this->config['include_links'] = array();
     $this->config['include_links']['genere_lien'] = 0;
     global $include_path, $class_path;
     require_once $class_path . '/export_param.class.php';
     $e_param = new export_param(EXP_GLOBAL_CONTEXT);
     $this->config['include_links'] = $e_param->get_parametres(EXP_OAI_CONTEXT);
     //Vérifions que le statut proposé existe bien
     $sql = "SELECT COUNT(1) > 0 FROM notice_statut WHERE id_notice_statut = " . ($linked_status_to_deletion + 0);
     $status_exists = pmb_mysql_result(pmb_mysql_query($sql, $dbh), 0, 0);
     if (!$status_exists) {
         $this->config["linked_status_to_deletion"] = 0;
     }
     if (!$this->config["cache_complete_records_seconds"]) {
         $this->config["cache_complete_records_seconds"] = 86400;
     }
     if ($this->config["deletion_management"] == 1 && !$this->config["deletion_management_transient_duration"]) {
         $this->config["deletion_management"] = 0;
     }
     //et maintenant les sets
     if (!is_array($included_sets)) {
         $included_sets = array($included_sets);
     }
     array_walk($included_sets, create_function('&$a', '$a+=0;'));
     //Virons ce qui n'est pas entier
     //Virons ce qui n'est pas un index de set de notice
     $sql = "SELECT connector_out_set_id FROM connectors_out_sets WHERE connector_out_set_type IN (" . implode(",", $this->allowed_set_types) . ") AND connector_out_set_id IN (" . implode(",", $included_sets) . ')';
     $res = pmb_mysql_query($sql, $dbh);
     $this->config["included_sets"] = array();
     while ($row = pmb_mysql_fetch_assoc($res)) {
         $this->config["included_sets"][] = $row["connector_out_set_id"];
     }
     //Vérifions que les formats autorisés proposés existent bien
     $allowed_paths = array();
     $admin_convert_catalog = external_services_converter_notices::get_export_possibilities();
     foreach ($admin_convert_catalog as $aconvert) {
         $allowed_paths[] = $aconvert["path"];
     }
     global $allowed_admin_convert_paths;
     if (!is_array($allowed_admin_convert_paths)) {
         $allowed_admin_convert_paths = array($allowed_admin_convert_paths);
     }
     $this->config["allowed_admin_convert_paths"] = array();
     foreach ($allowed_admin_convert_paths as $apath) {
         if (!in_array($apath, $allowed_paths)) {
             continue;
         }
         $this->config["allowed_admin_convert_paths"][] = $apath;
     }
     return;
 }

}
print "<br /><br /><h2 align='center'>" . htmlentities($msg["nettoyage_synchrordfstore_reindexation"], ENT_QUOTES, $charset) . "</h2>";
$NoIndex = 1;
$query = pmb_mysql_query("select notice_id from notices order by notice_id LIMIT {$start}, {$lot}");
if (pmb_mysql_num_rows($query)) {
    // définition de l'état de la jauge
    $state = floor($start / ($count / $jauge_size));
    $state .= "px";
    // mise à jour de l'affichage de la jauge
    print "<table border='0' align='center' width='{$jauge_size}' cellpadding='0'><tr><td class='jauge' width='100%'>";
    print "<img src='../../images/jauge.png' width='{$state}' height='16px'></td></tr></table>";
    // calcul pourcentage avancement
    $percent = floor($start / $count * 100);
    // affichage du % d'avancement et de l'état
    print "<div align='center'>{$percent}%</div>";
    while ($mesNotices = pmb_mysql_fetch_assoc($query)) {
        $synchro_rdf->addRdf($mesNotices['notice_id'], 0);
        $notice = new notice($mesNotices['notice_id']);
        $niveauB = strtolower($notice->biblio_level);
        //Si c'est un article, il faut réindexer son bulletin
        if ($niveauB == 'a') {
            $bulletin = analysis::getBulletinIdFromAnalysisId($mesNotices['notice_id']);
            $synchro_rdf->addRdf(0, $bulletin);
        }
    }
    pmb_mysql_free_result($query);
    $next = $start + $lot;
    print "\n\t<form class='form-{$current_module}' name='current_state' action='./clean.php' method='post'>\n\t<input type='hidden' name='v_state' value=\"" . urlencode($v_state) . "\">\n\t<input type='hidden' name='spec' value=\"{$spec}\">\n\t<input type='hidden' name='start' value=\"{$next}\">\n\t<input type='hidden' name='count' value=\"{$count}\">\n\t</form>\n\t<script type=\"text/javascript\"><!-- \n\tsetTimeout(\"document.forms['current_state'].submit()\",1000); \n\t-->\n\t</script>";
} else {
    $spec = $spec - INDEX_SYNCHRORDFSTORE;
    $compte = 0;

//.........这里部分代码省略.........
         z3950_notice::substitute("f_subcoll_existing", $existing_subcollection["sub_coll_name"], $ptab[2]);
         z3950_notice::substitute("f_subcoll_existing_id", $existing_subcollection_id, $ptab[2]);
     } else {
         z3950_notice::substitute("f_subcoll_existing", '', $ptab[2]);
         z3950_notice::substitute("f_subcoll_existing_id", '0', $ptab[2]);
     }
     z3950_notice::substitute("subcollection_name", $this->subcollection['name'], $ptab[2]);
     z3950_notice::substitute("subcollection_issn", $this->subcollection['issn'], $ptab[2]);
     z3950_notice::substitute("nbr_in_collection", $this->nbr_in_collection, $ptab[2]);
     z3950_notice::substitute("year", $this->year, $ptab[2]);
     z3950_notice::substitute("mention_edition", $this->mention_edition, $ptab[2]);
     $form_notice = str_replace('!!tab2!!', $ptab[2], $form_notice);
     z3950_notice::substitute("isbn", $this->isbn, $ptab[3]);
     $form_notice = str_replace('!!tab3!!', $ptab[3], $form_notice);
     z3950_notice::substitute("page_nbr", $this->page_nbr, $ptab[4]);
     z3950_notice::substitute("illustration", $this->illustration, $ptab[4]);
     z3950_notice::substitute("prix", $this->prix, $ptab[4]);
     z3950_notice::substitute("accompagnement", $this->accompagnement, $ptab[4]);
     z3950_notice::substitute("size", $this->size, $ptab[4]);
     $form_notice = str_replace('!!tab4!!', $ptab[4], $form_notice);
     z3950_notice::substitute("general_note", $this->general_note, $ptab[5]);
     z3950_notice::substitute("content_note", $this->content_note, $ptab[5]);
     z3950_notice::substitute("abstract_note", $this->abstract_note, $ptab[5]);
     $form_notice = str_replace('!!tab5!!', $ptab[5], $form_notice);
     // indexation interne
     $pclassement_sql = "SELECT * FROM pclassement";
     $res = pmb_mysql_query($pclassement_sql);
     $pclassement_count = pmb_mysql_num_rows($res);
     if (!$pclassement_count) {
         $pclassement_count = 1;
     }
     if ($pclassement_count > 1) {
         $pclassements = array();
         while ($row = pmb_mysql_fetch_assoc($res)) {
             $pclassements[] = array("id" => $row["id_pclass"], "name" => $row["name_pclass"]);
         }
         $pclassement_combobox = '<select name="f_indexint_new_pclass">';
         foreach ($pclassements as $pclassement) {
             $pclassement_combobox .= '<option value="' . $pclassement["id"] . '">' . $pclassement["name"] . '</option>';
         }
         $pclassement_combobox .= '</select>';
     } else {
         $pclassement_combobox = "";
     }
     $ptab[6] = str_replace("!!multiple_pclass_combo_box!!", $pclassement_combobox, $ptab[6]);
     $index_int_sql = "SELECT indexint_name, indexint_comment, indexint_id, name_pclass FROM indexint LEFT JOIN pclassement ON (pclassement.id_pclass = indexint.num_pclass) WHERE indexint_name = '" . addslashes($this->dewey[0]) . "'";
     $res = pmb_mysql_query($index_int_sql, $dbh);
     $num_rows = pmb_mysql_num_rows($res);
     if ($num_rows == 1) {
         $the_row = pmb_mysql_fetch_assoc($res);
         z3950_notice::substitute("indexint", $the_row["indexint_name"] . ': ' . $the_row["indexint_comment"], $ptab[6]);
         z3950_notice::substitute("indexint_id", $the_row["indexint_id"], $ptab[6]);
         z3950_notice::substitute("indexint_type_use_existing", 'checked', $ptab[6]);
         z3950_notice::substitute("indexint_type_insert_new", '', $ptab[6]);
         z3950_notice::substitute("multiple_index_int_propositions", '', $ptab[6]);
     } else {
         if ($num_rows > 1) {
             $index_ints = array();
             while ($row = pmb_mysql_fetch_assoc($res)) {
                 $index_ints[] = array("id" => $row["indexint_id"], "name" => $row["indexint_name"], "comment" => $row["indexint_comment"], "pclass" => $row["name_pclass"]);
             }
             $form_indexint_proposition = "<ul>";
             foreach ($index_ints as $index_int) {
                 $form_indexint_proposition .= "<li><b>[" . $index_int["pclass"] . "]</b> " . $index_int["name"] . ": " . $index_int["comment"] . '&nbsp;';
                 $jsaction = "document.getElementById('indexint_type_use_existing').checked=1; document.getElementById('f_indexint').value='" . addslashes($index_int["name"] . ' - ' . $index_int["comment"]) . "'; document.getElementById('f_indexint_id').value='" . addslashes($index_int["id"]) . "'";
                 $form_indexint_proposition .= '<input type="button" class="bouton" value="' . $msg["notice_integre_indexint_use"] . '" onclick="' . $jsaction . '">';