}
//on précise si une source peut enrichir ou non des notices
$rqt = "ALTER TABLE connectors_sources ADD enrichment INT NOT NULL default 0";
echo traite_rqt($rqt, "alter table connectors_sources add enrichment");
//stockage des enrichissements de notices
$rqt = "create table if not exists sources_enrichment(\n\t\t\tsource_enrichment_num int not null default 0,\n\t\t\tsource_enrichment_typnotice varchar(2) not null default '',\n\t\t\tsource_enrichment_typdoc varchar(2) not null default '',\n\t\t\tsource_enrichment_params text not null,\n\t\t\tprimary key (source_enrichment_num, source_enrichment_typnotice, source_enrichment_typdoc),\n\t\t\tindex i_s_enrichment_typnoti(source_enrichment_typnotice),\n\t\t\tindex i_s_enrichment_typdoc(source_enrichment_typdoc))";
echo traite_rqt($rqt, "create table sources_enrichment");
// Enrichissement OPAC
if (pmb_mysql_num_rows(pmb_mysql_query("select 1 from parametres where type_param= 'opac' and sstype_param='notice_enrichment' ")) == 0) {
$rqt = "INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param) VALUES (0, 'opac', 'notice_enrichment', '0', 'Activer l\\'enrichissement des notices\n 0: Non \n 1: Oui','e_aff_notice')";
echo traite_rqt($rqt, "insert opac_notice_enrichment='0' into parametres");
}
// Social Network
if (pmb_mysql_num_rows(pmb_mysql_query("select 1 from parametres where type_param= 'opac' and sstype_param='show_social_network' ")) == 0) {
$rqt = "INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param) VALUES (0, 'opac', 'show_social_network', '0', 'Activer les partages sur les réseaux sociaux \n 0: Non \n 1: Oui','e_aff_notice')";
echo traite_rqt($rqt, "insert show_social_network='0' into parametres");
}
// valeur par défaut restrict infopages
$rqt = "ALTER TABLE infopages CHANGE restrict_infopage restrict_infopage INT( 11 ) NOT NULL DEFAULT 0";
echo traite_rqt($rqt, "ALTER TABLE infopages CHANGE restrict_infopage DEFAULT 0");
// +-------------------------------------------------+
echo "</table>";
$rqt = "update parametres set valeur_param='" . $action . "' where type_param='pmb' and sstype_param='bdd_version' ";
$res = pmb_mysql_query($rqt, $dbh);
echo "<strong><font color='#FF0000'>" . $msg[1807] . $action . " !</font></strong><br />";
echo form_relance("v5.00");
break;
default:
include "{$include_path}/messages/help/{$lang}/alter.txt";
break;
}
}
//DG - Modification de la longueur du champ description de la table opac_liste_lecture
$rqt = "ALTER TABLE opac_liste_lecture MODIFY description TEXT ";
echo traite_rqt($rqt, "alter table opac_liste_lecture modify description");
//DB - Ajout d'un champ timestamp dans la table acces_user_2
@mysql_query("describe acces_usr_2", $dbh);
if (!mysql_error($dbh)) {
$rqt = "ALTER IGNORE TABLE acces_usr_2 ADD updated TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ";
echo traite_rqt($rqt, "alter table acces_usr_2 add field updated");
}
// +-------------------------------------------------+
echo "</table>";
$rqt = "update parametres set valeur_param='" . $action . "' where type_param='pmb' and sstype_param='bdd_version' ";
$res = mysql_query($rqt, $dbh);
echo "<strong><font color='#FF0000'>" . $msg[1807] . $action . " !</font></strong><br />";
echo form_relance("v5.14");
break;
case "v5.14":
echo "<table ><tr><th>" . $msg['admin_misc_action'] . "</th><th>" . $msg['admin_misc_resultat'] . "</th></tr>";
// +-------------------------------------------------+
// MB - Indexer la colonne num_renvoi_voir de la table noeuds
$rqt = "ALTER TABLE noeuds DROP INDEX i_num_renvoi_voir";
echo traite_rqt($rqt, "ALTER TABLE noeuds DROP INDEX i_num_renvoi_voir");
$rqt = "ALTER TABLE noeuds ADD INDEX i_num_renvoi_voir (num_renvoi_voir)";
echo traite_rqt($rqt, "ALTER TABLE noeuds ADD INDEX i_num_renvoi_voir (num_renvoi_voir)");
$rqt = "update parametres set comment_param='Liste des id de template de notice pour ajouter des onglets personnalisés en affichage de notice\nExemple: 1,3,ISBD,PUBLIC\nLe paramètre notices_format doit être à 0 pour placer ISBD et PUBLIC' where type_param='opac' and sstype_param='notices_format_onglets' ";
echo traite_rqt($rqt, "update opac notices_format_onglets comments in parametres");
$rqt = "update parametres set comment_param='0 : mode normal de recherche\n1 : Affiche directement le résultat de la recherche tous les champs sans passer par la présentation du niveau 1 de recherche \n2 : Affiche directement le résultat de la recherche tous les champs sans passer par la présentation du niveau 1 de recherche sans faire de recherche intermédaire' where type_param='opac' and sstype_param='autolevel2' ";
echo traite_rqt($rqt, "update opac_autolevel comments in parametres");
//Création des tables pour le portfolio
$rqt = "create table cms_collections (\n\t\t\tid_collection int unsigned not null auto_increment primary key,\n\t\t\tcollection_title varchar(255) not null default '',\n\t\t\tcollection_description text not null,\n\t\t\tcollection_num_parent int not null default 0,\n\t\t\tcollection_num_storage int not null default 0,\n\t\t\tindex i_cms_collection_title(collection_title)\n\t\t)";
echo form_relance("v1.58");
break;
case "v1.58":
echo "<table ><tr><th>" . $msg['admin_misc_action'] . "</th><th>" . $msg['admin_misc_resultat'] . "</th></tr>";
// +--------------------------------------------------------------------------+
$rqt = "ALTER TABLE empr CHANGE empr_ville empr_ville VARCHAR( 255 ) NOT NULL ";
echo traite_rqt($rqt, "ville varchar(255)");
$rqt = "ALTER TABLE empr CHANGE empr_adr1 empr_adr1 VARCHAR( 255 ) NOT NULL ";
echo traite_rqt($rqt, "adr1 varchar(255)");
$rqt = "ALTER TABLE empr CHANGE empr_adr2 empr_adr2 VARCHAR( 255 ) NOT NULL ";
echo traite_rqt($rqt, "adr2 varchar(255)");
$rqt = "ALTER TABLE empr CHANGE empr_tel1 empr_tel1 VARCHAR( 255 ) NOT NULL ";
echo traite_rqt($rqt, "tel1 varchar(255)");
$rqt = "ALTER TABLE empr CHANGE empr_tel2 empr_tel2 VARCHAR( 255 ) NOT NULL ";
echo traite_rqt($rqt, "tel2 varchar(255)");
$rqt = "ALTER TABLE empr CHANGE empr_nom empr_nom VARCHAR( 255 ) NOT NULL ";
echo traite_rqt($rqt, "nom varchar(255)");
$rqt = "ALTER TABLE empr CHANGE empr_prenom empr_prenom VARCHAR( 255 ) NOT NULL ";
echo traite_rqt($rqt, "prenom varchar(255)");
$rqt = "ALTER TABLE empr ADD empr_pays VARCHAR( 255 ) NOT NULL default '' AFTER empr_ville ";
echo traite_rqt($rqt, "ADD pays varchar(255)");
echo "</table>";
$rqt = "update parametres set valeur_param='" . $action . "' where type_param='pmb' and sstype_param='bdd_version' ";
$res = pmb_mysql_query($rqt, $dbh);
echo "<strong><font color='#FF0000'>" . $msg[1807] . $action . " !</font></strong><br />";
echo form_relance("v2.00");
break;
default:
include "{$include_path}/messages/help/{$lang}/alter.txt";
break;
}
echo traite_rqt($rqt, "insert pmb_recouvrement_auto='1' into parametres");
}
if (pmb_mysql_num_rows(pmb_mysql_query("select 1 from parametres where type_param= 'opac' and sstype_param='show_dernieresnotices_nb' ")) == 0) {
$rqt = "INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (0, 'opac', 'show_dernieresnotices_nb', '10', 'Nombre de dernières notices affichées en OPAC lors de l\\'activation du paramètre show_dernieresnotices', 'f_modules', 0)";
echo traite_rqt($rqt, "insert opac_show_dernieresnotices_nb='10' into parametres");
}
// +-------------------------------------------------+
echo "</table>";
$rqt = "update parametres set valeur_param='" . $action . "' where type_param='pmb' and sstype_param='bdd_version' ";
$res = pmb_mysql_query($rqt, $dbh);
echo "<strong><font color='#FF0000'>" . $msg[1807] . $action . " !</font></strong><br />";
echo form_relance("v3.49");
break;
case "v3.49":
echo "<table ><tr><th>" . $msg['admin_misc_action'] . "</th><th>" . $msg['admin_misc_resultat'] . "</th></tr>";
// +-------------------------------------------------+
if (pmb_mysql_num_rows(pmb_mysql_query("select 1 from parametres where type_param= 'pmb' and sstype_param='keyword_sep' ")) == 0) {
$rqt = "INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param) VALUES (0, 'pmb', 'keyword_sep', ' ', 'Séparateur des mots clés dans la partie indexation libre, espace ou ; ou , ou ...')";
echo traite_rqt($rqt, "insert pmb_keyword_sep=' ' into parametres");
}
// +-------------------------------------------------+
echo "</table>";
$rqt = "update parametres set valeur_param='" . $action . "' where type_param='pmb' and sstype_param='bdd_version' ";
$res = pmb_mysql_query($rqt, $dbh);
echo "<strong><font color='#FF0000'>" . $msg[1807] . $action . " !</font></strong><br />";
echo form_relance("v4.00");
break;
default:
include "{$include_path}/messages/help/{$lang}/alter.txt";
break;
}
echo traite_rqt($rqt, "ALTER TABLE caddie ADD caddie_classement ");
$rqt = "ALTER TABLE empr_caddie ADD empr_caddie_classement varchar(255) NOT NULL default ''";
echo traite_rqt($rqt, "ALTER TABLE empr_caddie ADD empr_caddie_classement ");
$rqt = "ALTER TABLE etagere ADD etagere_classement varchar(255) NOT NULL default ''";
echo traite_rqt($rqt, "ALTER TABLE etagere ADD etagere_classement ");
// MB - LDAP gestion de l'encodage lors de l'import
if (pmb_mysql_num_rows(pmb_mysql_query("select 1 from parametres where type_param= 'ldap' and sstype_param='encoding_utf8' ")) == 0) {
$rqt = "INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion)\n\t\t\t\t\tVALUES (0, 'ldap', 'encoding_utf8', '0', 'Les informations du LDAP sont en utf-8 ?\n 0: Non \n 1: Oui.','',0)";
echo traite_rqt($rqt, "insert ldap_encoding_utf8 = 0 into parametres");
}
// +-------------------------------------------------+
echo "</table>";
$rqt = "update parametres set valeur_param='" . $action . "' where type_param='pmb' and sstype_param='bdd_version' ";
$res = pmb_mysql_query($rqt, $dbh);
echo "<strong><font color='#FF0000'>" . $msg[1807] . $action . " !</font></strong><br />";
echo form_relance("v5.19");
break;
case "v5.19":
echo "<table ><tr><th>" . $msg['admin_misc_action'] . "</th><th>" . $msg['admin_misc_resultat'] . "</th></tr>";
// +-------------------------------------------------+
//DG - Code Javascript d'analyse d'audience
if (pmb_mysql_num_rows(pmb_mysql_query("select 1 from parametres where type_param= 'opac' and sstype_param='script_analytics' ")) == 0) {
$rqt = "INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion)\n\t\t\t\t\tVALUES (0, 'opac', 'script_analytics', '', 'Code Javascript d\\'analyse d\\'audience (Par exemple pour Google Analytics, XiTi,..).','a_general',0)";
echo traite_rqt($rqt, "insert opac_script_analytics into parametres");
}
//DG - Accessibilité OPAC : Paramètre d'activation
if (pmb_mysql_num_rows(pmb_mysql_query("select 1 from parametres where type_param= 'opac' and sstype_param='accessibility' ")) == 0) {
$rqt = "INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion)\n\t\t\t\t\tVALUES (0, 'opac', 'accessibility', '1', 'Accessibilité activée.\n 0 : Non.\n 1 : Oui.','a_general',0)";
echo traite_rqt($rqt, "insert opac_accessibility = 1 into parametres");
}
//JP - Renseigner les champs d'exemplaires transfert_location_origine et transfert_statut_origine pour les statistiques et si ils ne le sont pas déjà (ajout sur la requête en v5.17)
echo traite_rqt($rqt, "insert opac_cookies_consent into parametres");
}
//DG - Grille d'auteur pour les personnes physiques
if (pmb_mysql_num_rows(pmb_mysql_query("select 1 from grilles_auth where grille_auth_type= 'auteurs' and grille_auth_filter='70' ")) == 0) {
$rqt = "INSERT INTO grilles_auth (grille_auth_type, grille_auth_filter, grille_auth_descr_format)\n\t\t\t\t\t\t\t\tVALUES ('auteurs', '70', '[{\"nodeId\":\"el0\",\"label\":\"Zone par d\\u00e9faut\",\"isExpandable\":false,\"showLabel\":false,\"visible\":true,\"elements\":[{\"nodeId\":\"el0Child_0\",\"visible\":true,\"className\":\"row\"},{\"nodeId\":\"el0Child_1_a\",\"visible\":true,\"className\":\"colonne2\"},{\"nodeId\":\"el0Child_1_b\",\"visible\":true,\"className\":\"colonne_suite\"},{\"nodeId\":\"el0Child_2\",\"visible\":true,\"className\":\"row\"},{\"nodeId\":\"el0Child_3\",\"visible\":false,\"className\":\"row\"},{\"nodeId\":\"el0Child_4_a\",\"visible\":false,\"className\":\"colonne2\"},{\"nodeId\":\"el0Child_4_b\",\"visible\":false,\"className\":\"colonne_suite\"},{\"nodeId\":\"el0Child_5_a\",\"visible\":false,\"className\":\"colonne2\"},{\"nodeId\":\"el0Child_5_b\",\"visible\":false,\"className\":\"colonne_suite\"},{\"nodeId\":\"el0Child_6\",\"visible\":true,\"className\":\"row\"},{\"nodeId\":\"el0Child_7\",\"visible\":true,\"className\":\"row\"},{\"nodeId\":\"el0Child_8\",\"visible\":true,\"className\":\"row\"},{\"nodeId\":\"el6Child_3\",\"visible\":true,\"className\":\"row\"},{\"nodeId\":\"el0Child_9\",\"visible\":true,\"className\":\"row\"},{\"nodeId\":\"el7Child_0\",\"visible\":true,\"className\":\"row\"}]}]')";
echo traite_rqt($rqt, "insert minimum into grilles_auth");
}
//DG - Info de réindexation
$rqt = " select 1 ";
echo traite_rqt($rqt, "<b><a href='" . $base_path . "/admin.php?categ=netbase' target=_blank>VOUS DEVEZ REINDEXER LES AUTORITES (APRES ETAPES DE MISE A JOUR) / YOU MUST REINDEX THE AUTHORITIES (STEPS AFTER UPDATE) : Admin > Outils > Nettoyage de base</a></b> ");
// +-------------------------------------------------+
echo "</table>";
$rqt = "update parametres set valeur_param='" . $action . "' where type_param='pmb' and sstype_param='bdd_version' ";
$res = pmb_mysql_query($rqt, $dbh);
echo "<strong><font color='#FF0000'>" . $msg[1807] . $action . " !</font></strong><br />";
echo form_relance("v5.21");
break;
case "v5.21":
echo "<table ><tr><th>" . $msg['admin_misc_action'] . "</th><th>" . $msg['admin_misc_resultat'] . "</th></tr>";
// +-------------------------------------------------+
//NG - DSI: Ajout de bannette_aff_notice_number pour afficher ou pas le nombre de notices envoyées dans le mail
$rqt = "ALTER TABLE bannettes ADD bannette_aff_notice_number int unsigned NOT NULL default 1 ";
echo traite_rqt($rqt, "ALTER TABLE bannettes ADD bannette_aff_notice_number ");
//JP - Personnalisation des colonnes pour l'affichage des états des collections en gestion
if (pmb_mysql_num_rows(pmb_mysql_query("select 1 from parametres where type_param= 'pmb' and sstype_param='collstate_data' ")) == 0) {
$rqt = "INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion)\n\t\t\t\t\t\tVALUES (0, 'pmb', 'collstate_data', '', 'Colonne des états des collections, dans l\\'ordre donné, séparé par des virgules : location_libelle,emplacement_libelle,cote,type_libelle,statut_opac_libelle,origine,state_collections,archive,lacune,surloc_libelle,note,#n : id des champs personnalisés\nLes valeurs possibles sont les propriétés de la classe PHP \"pmb/classes/collstate.class.php\".','',0)";
echo traite_rqt($rqt, "insert pmb_collstate_data = '' into parametres");
}
$action = "v5.20";
// +-------------------------------------------------+
echo "</table>";
case "v2.23":
echo "<table ><tr><th>Action</th><th>Resultat</th></tr>";
// +-------------------------------------------------+
$rqt = "ALTER TABLE pret CHANGE pret_date pret_date DATETIME DEFAULT '0000-00-00' NOT NULL ";
echo traite_rqt($rqt, "TABLE pret change pret_date DATETIME ");
$rqt = "ALTER TABLE pret_archive CHANGE arc_debut arc_debut DATETIME DEFAULT '0000-00-00' ";
echo traite_rqt($rqt, "TABLE pret_archive change arc_debut DATETIME ");
// +-------------------------------------------------+
echo "</table>";
$rqt = "update parametres set valeur_param='" . $action . "' where type_param='pmb' and sstype_param='bdd_version' ";
$res = pmb_mysql_query($rqt, $dbh);
echo "<strong><font color='#FF0000'>" . $msg[1807] . $action . " !</font></strong><br />";
echo form_relance("v2.24");
break;
case "v2.24":
echo "<table ><tr><th>Action</th><th>Resultat</th></tr>";
// +-------------------------------------------------+
$rqt = "ALTER TABLE import_marc CHANGE origine origine varchar(50) DEFAULT '' ";
echo traite_rqt($rqt, "TABLE import_marc change origine varchar(50) ");
$rqt = "ALTER TABLE import_marc ADD no_notice integer(10) UNSIGNED DEFAULT 0 ";
echo traite_rqt($rqt, "TABLE import_marc ADD no_notice ");
// +-------------------------------------------------+
$rqt = "update parametres set valeur_param='" . $action . "' where type_param='pmb' and sstype_param='bdd_version' ";
$res = pmb_mysql_query($rqt, $dbh);
echo "<strong><font color='#FF0000'>" . $msg[1807] . $action . " !</font></strong><br />";
echo form_relance("v3.00");
break;
default:
include "{$include_path}/messages/help/{$lang}/alter.txt";
break;
}
