$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;