Erreur (non critique) sur la requête : ".$requete." (".mysql_errno()." : ".mysql_error().") \n";
break;
case "1068":
// Des cléfs existent déjà : pas de problème
$retour = "";
break;
case "1091":
// Déjà supprimé : pas de problème
$retour = "";
break;
default:
$retour = "Erreur sur la requête : ".$requete." (".mysql_errno()." : ".mysql_error().") \n";
break;
}
}
return $retour;
}
$valid = isset($_POST["valid"]) ? $_POST["valid"] : 'no';
$version_old = isset($_POST["version_old"]) ? $_POST["version_old"] : '';
if (isset($_POST['submit'])) {
if (isset($_POST['login']) && isset($_POST['password'])) {
// Test pour tenir compte du changement de nom de la table grr_utilisateurs lors du passage à la version 1.8
$num_version = sql_query1("select NAME from grr_setting WHERE NAME='version'");
if ($num_version != -1)
$sql = "select upper(login) login, password, prenom, nom, statut from grr_utilisateurs where login = '" . $_POST['login'] . "' and password = md5('" . $_POST['password'] . "') and etat != 'inactif' and statut='administrateur' ";
else
$sql = "select upper(login) login, password, prenom, nom, statut from utilisateurs where login = '" . $_POST['login'] . "' and password = md5('" . $_POST['password'] . "') and etat != 'inactif' and statut='administrateur' ";
$res_user = sql_query($sql);
$num_row = sql_count($res_user);
if ($num_row == 1) {
$valid='yes';
} else {
$message = $vocab["wrong_pwd"];
}
}
}
if ((!@resumeSession()) and $valid!='yes') {
?>
GRR GRR
Mise à jour jusqu'à la version 1.4 : ";
$result_inter .= traite_requete("ALTER TABLE mrbs_area ADD order_display TINYINT NOT NULL;");
$result_inter .= traite_requete("ALTER TABLE mrbs_room ADD max_booking SMALLINT DEFAULT '-1' NOT NULL ;");
$req = sql_query1("SELECT VALUE FROM setting WHERE NAME='sessionMaxLength'");
if ($req == -1) $result_inter .= traite_requete("INSERT INTO setting VALUES ('sessionMaxLength', '30');");
$req = sql_query1("SELECT VALUE FROM setting WHERE NAME='automatic_mail'");
if ($req == -1) $result_inter .= traite_requete("INSERT INTO setting VALUES ('automatic_mail', 'yes');");
$req = sql_query1("SELECT VALUE FROM setting WHERE NAME='begin_bookings'");
if ($req == -1) $result_inter .= traite_requete("INSERT INTO setting VALUES ('begin_bookings', '1062367200');");
$req = sql_query1("SELECT VALUE FROM setting WHERE NAME='end_bookings'");
if ($req == -1) $result_inter .= traite_requete("INSERT INTO setting VALUES ('end_bookings', '1088546400');");
$req = sql_query1("SELECT VALUE FROM setting WHERE NAME='company'");
if ($req == -1) $result_inter .= traite_requete("INSERT INTO setting VALUES ('company', 'Nom de l\'établissement');");
$req = sql_query1("SELECT VALUE FROM setting WHERE NAME='webmaster_name'");
if ($req == -1) $result_inter .= traite_requete("INSERT INTO setting VALUES ('webmaster_name', 'Webmestre de GRR');");
$req = sql_query1("SELECT VALUE FROM setting WHERE NAME='webmaster_email'");
if ($req == -1) $result_inter .= traite_requete("INSERT INTO setting VALUES ('webmaster_email', 'admin@mon.site.fr');");
$req = sql_query1("SELECT VALUE FROM setting WHERE NAME='technical_support_email'");
if ($req == -1) $result_inter .= traite_requete("INSERT INTO setting VALUES ('technical_support_email', 'support.technique@mon.site.fr');");
$req = sql_query1("SELECT VALUE FROM setting WHERE NAME='grr_url'");
if ($req == -1) $result_inter .= traite_requete("INSERT INTO setting VALUES ('grr_url', 'http://mon.site.fr/grr/');");
$req = sql_query1("SELECT VALUE FROM setting WHERE NAME='disable_login'");
if ($req == -1) $result_inter .= traite_requete("INSERT INTO setting VALUES ('disable_login', 'no');");
if ($result_inter == '') {
$result .= "Ok ! ";
} else {
$result .= $result_inter;
}
$result_inter = '';
}
if (($version_old == '') or ($version_old < "1.5")) {
$result .= "Mise à jour jusqu'à la version 1.5 : ";
// GRR1.5
$result_inter .= traite_requete("ALTER TABLE utilisateurs ADD default_area SMALLINT NOT NULL ;");
$result_inter .= traite_requete("ALTER TABLE utilisateurs ADD default_room SMALLINT NOT NULL ;");
$result_inter .= traite_requete("ALTER TABLE utilisateurs ADD default_style VARCHAR( 50 ) NOT NULL ;");
$result_inter .= traite_requete("ALTER TABLE utilisateurs ADD default_list_type VARCHAR( 50 ) NOT NULL ;");
$result_inter .= traite_requete("ALTER TABLE utilisateurs ADD default_language VARCHAR( 3 ) NOT NULL ;");
$req = sql_query1("SELECT VALUE FROM setting WHERE NAME='title_home_page'");
if ($req == -1) $result_inter .= traite_requete("INSERT INTO setting VALUES ('title_home_page', 'Gestion et Réservation de Ressources');");
if ($req == -1) $result_inter .= traite_requete("INSERT INTO setting VALUES ('message_home_page', 'En raison du caractère personnel du contenu, ce site est soumis à des restrictions utilisateurs. Pour accéder aux outils de réservation, identifiez-vous :');");
if ($result_inter == '') {
$result .= "Ok ! ";
} else {
$result .= $result_inter;
}
$result_inter = '';
}
if (($version_old == '') or ($version_old < "1.6")) {
$result .= "Mise à jour jusqu'à la version 1.6 : ";
// GRR1.6
$req = sql_query1("SELECT VALUE FROM setting WHERE NAME='default_language'");
if ($req == -1) $result_inter .= traite_requete("INSERT INTO setting VALUES ('default_language', 'fr');");
$result_inter .= traite_requete("ALTER TABLE mrbs_entry ADD statut_entry CHAR( 1 ) DEFAULT '-' NOT NULL ;");
$result_inter .= traite_requete("ALTER TABLE mrbs_room ADD statut_room CHAR( 1 ) DEFAULT '1' NOT NULL ;");
$result_inter .= traite_requete("ALTER TABLE mrbs_room ADD show_fic_room CHAR( 1 ) DEFAULT 'n' NOT NULL ;");
$result_inter .= traite_requete("ALTER TABLE mrbs_room ADD picture_room VARCHAR( 50 ) NOT NULL;");
$result_inter .= traite_requete("ALTER TABLE mrbs_room ADD comment_room TEXT NOT NULL;");
if ($result_inter == '') {
$result .= "Ok ! ";
} else {
$result .= $result_inter;
}
$result_inter = '';
}
if (($version_old == '') or ($version_old < "1.7")) {
$result .= "Mise à jour jusqu'à la version 1.7 : ";
// GRR1.7
$result_inter .= traite_requete("ALTER TABLE utilisateurs ADD source VARCHAR( 10 ) NOT NULL ;");
$result_inter .= traite_requete("ALTER TABLE j_mailuser_room CHANGE login login VARCHAR( 20 ) NOT NULL;");
$result_inter .= traite_requete("ALTER TABLE j_user_area CHANGE login login VARCHAR( 20 ) NOT NULL;");
$result_inter .= traite_requete("ALTER TABLE j_user_room CHANGE login login VARCHAR( 20 ) NOT NULL;");
$result_inter .= traite_requete("ALTER TABLE j_mailuser_room ADD PRIMARY KEY ( login , id_room ) ;");
$result_inter .= traite_requete("ALTER TABLE j_user_area ADD PRIMARY KEY ( login , id_area ) ;");
$result_inter .= traite_requete("ALTER TABLE j_user_room ADD PRIMARY KEY ( login , id_room ) ;");
$result_inter .= traite_requete("ALTER TABLE log CHANGE LOGIN LOGIN VARCHAR( 20 ) NOT NULL;");
$req = sql_query1("SELECT VALUE FROM setting WHERE NAME='url_disconnect'");
if ($req == -1) $result_inter .= traite_requete("INSERT INTO setting VALUES ('url_disconnect', '');");
if ($result_inter == '') {
$result .= "Ok ! ";
} else {
$result .= $result_inter;
}
$result_inter = '';
}
if (($version_old == '') or ($version_old < "1.8")) {
$result .= "Mise à jour jusqu'à la version 1.8 : ";
// GRR1.8
$result_inter .= traite_requete("ALTER TABLE utilisateurs CHANGE login login VARCHAR( 20 ) NOT NULL;");
$result_inter .= traite_requete("ALTER TABLE utilisateurs CHANGE nom nom VARCHAR( 30 ) NOT NULL;");
$result_inter .= traite_requete("ALTER TABLE utilisateurs CHANGE prenom prenom VARCHAR( 30 ) NOT NULL;");
$result_inter .= traite_requete("ALTER TABLE utilisateurs CHANGE password password VARCHAR( 32 ) NOT NULL;");
$result_inter .= traite_requete("ALTER TABLE utilisateurs CHANGE email email VARCHAR( 100 ) NOT NULL;");
$result_inter .= traite_requete("ALTER TABLE utilisateurs CHANGE statut statut VARCHAR( 30 ) NOT NULL;");
$result_inter .= traite_requete("ALTER TABLE utilisateurs ADD PRIMARY KEY ( login );");
$result_inter .= traite_requete("CREATE TABLE IF NOT EXISTS grr_j_useradmin_area (login varchar(20) NOT NULL default '', id_area int(11) NOT NULL default '0', PRIMARY KEY (login,id_area) );");
$result_inter .= traite_requete("ALTER TABLE j_mailuser_room RENAME grr_j_mailuser_room;");
$result_inter .= traite_requete("ALTER TABLE j_user_area RENAME grr_j_user_area;");
$result_inter .= traite_requete("ALTER TABLE j_user_room RENAME grr_j_user_room;");
$result_inter .= traite_requete("ALTER TABLE log RENAME grr_log;");
$result_inter .= traite_requete("ALTER TABLE mrbs_area RENAME grr_area;");
$result_inter .= traite_requete("ALTER TABLE mrbs_entry RENAME grr_entry;");
$result_inter .= traite_requete("ALTER TABLE mrbs_repeat RENAME grr_repeat;");
$result_inter .= traite_requete("ALTER TABLE mrbs_room RENAME grr_room;");
$result_inter .= traite_requete("ALTER TABLE setting RENAME grr_setting;");
$result_inter .= traite_requete("ALTER TABLE utilisateurs RENAME grr_utilisateurs;");
$result_inter .= traite_requete("ALTER TABLE grr_area ADD ip_adr VARCHAR( 15 ) NOT NULL;");
$result_inter .= traite_requete("ALTER TABLE grr_area CHANGE area_name area_name VARCHAR( 30 ) NOT NULL;");
$result_inter .= traite_requete("ALTER TABLE grr_room CHANGE description description VARCHAR( 60 ) NOT NULL;");
if ($result_inter == '') {
$result .= "Ok ! ";
} else {
$result .= $result_inter;
}
$result_inter = '';
}
// Mise à jour du numéro de version
$req = sql_query1("SELECT VALUE FROM grr_setting WHERE NAME='version'");
if ($req == -1) {
$result_inter .= traite_requete("INSERT INTO grr_setting VALUES ('version', '$version_grr');");
} else {
$result_inter .= traite_requete("UPDATE grr_setting SET VALUE='$version_grr' WHERE NAME='version';");
}
//Re-Chargement des valeurs de la table settingS
if (!loadSettings()) {
die("Erreur chargement settings");
}
echo "";
}
// Numéro de version effective
$version_old = getSettingValue("version");
echo "