$description = $_POST['description'];
$color_theme = $_POST['color-theme'];
$logo = $_FILES['logo']['name'];
$banner = $_FILES['banner']['name'];
if (isset($active_contest)) {
$active_contest = $_POST['active-contest'];
}
// On vérifie si tous les champs ne sont pas null
if (empty($title) or empty($date_begin) or empty($date_ending) or empty($description)) {
// Si les champs sont vides, on affiche une erreur
echo '<font color="red">Attention, les champs doivent être remplis !</font>';
} else {
// Si le bouton radio "Actif" est coché
if (isset($active_contest)) {
// On update l'ancien is_active pour le remettre à false
// car il ne peut y avoir qu'un concours actif
$updateActiveStatut = $db->prepare("UPDATE contest SET is_active = false WHERE is_active = true");
$updateActiveStatut->execute();
// On insère dans la BDD le nouveau concours avec la colonne is_active à true
$insertContest = $db->prepare("INSERT INTO contest(title, date_begin, date_ending, description, color_theme, banner, logo, is_active) VALUES ('" . $title . "', '" . $date_begin . "', '" . $date_ending . "', '" . $description . "', '" . $color_theme . "', '" . $banner . "', '" . $logo . "', true)");
$insertContest->execute();
// Si le bouton "Actif" n'est pas coché
} else {
// On insère dans la BDD avec la colonne is_active à false
$insertContest = $db->prepare("INSERT INTO contest(title, date_begin, date_ending, description, color_theme, banner, logo, is_active) VALUES ('" . $title . "', '" . $date_begin . "', '" . $date_ending . "', '" . $description . "', '" . $color_theme . "', '" . $banner . "', '" . $logo . "', false)");
$insertContest->execute();
}
upload_logo();
upload_banner();
//header("Location: /contestList");
}
break;
}
}
} else {
$var_sitetitleL = "";
$var_LogoURL = "";
$var_emailfooter = "";
$var_emailheader = "";
}
mysql_free_result($var_result);
} elseif ($_POST["postback"] == "U") {
$var_sitetitle = trim($_POST["txtSiteTitle"]);
$var_LogoURL = trim($_POST["txtHelpLogoURLh"]);
$var_emailfooter = trim($_POST["txtEmailFooter"]);
$var_emailheader = trim($_POST["txtEmailHeader"]);
$uploadstatus = upload_logo("txtHelpLogoURL", "../custom/", "", "image/jpeg,image/pjpeg,image/gif,image/png,image/xpng,image/x-png", "10000000", $var_LogoURL);
$errorcode = "";
$dup_flag = 0;
$file_name = "";
switch ($uploadstatus) {
case "FNA":
$errorcode = "";
break;
case "IS":
$errorcode = MESSAGE_UPLOAD_ERROR_3;
break;
case "IT":
$errorcode = MESSAGE_UPLOAD_ERROR_2;
break;
case "NW":
$errorcode = MESSAGE_UPLOAD_ERROR_4;
