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 {