} //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; }