description TEXT NOT NULL
) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;";
$result_inter = traite_requete($sql);
if ($result_inter == '') {
$result .= msj_ok("SUCCES !");
$result .= "Initialisation de 'mod_disc_terme_avertissement_fin_periode' : ";
if(saveSetting("mod_disc_terme_avertissement_fin_periode", "avertissement de fin de période")) {
$result .= msj_ok("SUCCES !");
$mod_disc_terme_avertissement_fin_periode=getSettingValue('mod_disc_terme_avertissement_fin_periode');
}
else {
$result .= msj_erreur("ECHEC !");
}
$result.=insere_avertissement_fin_periode_par_defaut()."<br />";
}
else {
$result .= msj_erreur("ECHEC !");
}
} else {
$result .= msj_present("La table existe déjà");
}
$result .= "Test du type du champ 'date_avertissement' de la table 's_avertissements'<br />";
$sql="show columns from s_avertissements where type like 'datetime' and field='date_avertissement';";
$res_sa=mysqli_query($GLOBALS["mysqli"], $sql);
if(mysqli_num_rows($res_sa)>0) {
$result .= msj_present("Le champ a le bon type (DATETIME)");
}
else {
) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;";
$creation=mysqli_query($GLOBALS["mysqli"], $sql);
}
$sql="SHOW TABLES LIKE 's_types_avertissements';";
$test=mysqli_query($GLOBALS["mysqli"], $sql);
if(mysqli_num_rows($test)==0) {
$sql="CREATE TABLE IF NOT EXISTS s_types_avertissements (
id_type_avertissement INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
nom_court VARCHAR( 50 ) NOT NULL ,
nom_complet VARCHAR( 255 ) NOT NULL,
description TEXT NOT NULL
) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;";
$creation=mysqli_query($GLOBALS["mysqli"], $sql);
echo "<p style='color:red'>".insere_avertissement_fin_periode_par_defaut()."</p>\n";
}
echo "<p class='bold'><a href='index.php'>Retour</a>";
echo "</p>\n";
echo "<form name='formulaire' action='".$_SERVER['PHP_SELF']."' method='post'>
<fieldset id='infosPerso' style='border: 1px solid grey; background-image: url(\"../images/background/opacite50.png\");'>
".add_token_field();
$tab_type_avertissement_fin_periode=get_tab_type_avertissement();
if(!isset($tab_type_avertissement_fin_periode['id_type_avertissement'])) {
echo "
<p style='color:red'>Aucun type d'$mod_disc_terme_avertissement_fin_periode n'est encore défini.</p>";
}
else {
