function analyzeChoices() { #---------------------------------------------------------------------- global $chosenNameHtml, $chosenNameMysql, $chosenCountryIdHtml, $chosenCountryIdMysql; $chosenNameHtml = getHtmlParam('name'); $chosenNameMysql = getMysqlParam('name'); $chosenCountryIdHtml = getHtmlParam('countryId'); $chosenCountryIdMysql = getMysqlParam('countryId'); }
function analyzeChoices() { #---------------------------------------------------------------------- global $chosenEventId, $chosenRegionId, $chosenPatternHtml, $chosenPatternMysql; $chosenEventId = getNormalParam('eventId'); $chosenRegionId = getNormalParam('regionId'); $chosenPatternHtml = getHtmlParam('pattern'); $chosenPatternMysql = getMysqlParam('pattern'); }
function analyzeChoices () { #---------------------------------------------------------------------- global $chosenId, $chosenConfirm, $chosenName, $chosenNameHtml, $chosenCountryId, $chosenGender, $chosenDay, $chosenMonth, $chosenYear, $chosenUpdate, $chosenFix; $chosenConfirm = getBooleanParam( 'confirm' ); $chosenUpdate = getBooleanParam( 'update' ); $chosenFix = getBooleanParam( 'fix' ); $chosenId = getNormalParam ( 'id' ); $chosenName = getMysqlParam ( 'name' ); $chosenNameHtml = getHtmlParam ( 'name' ); $chosenCountryId = getMysqlParam ( 'countryId' ); $chosenGender = getNormalParam ( 'gender' ); $chosenDay = getNormalParam ( 'day' ); $chosenMonth = getNormalParam ( 'month' ); $chosenYear = getNormalParam ( 'year' ); }
function analyzeChoices() { #---------------------------------------------------------------------- global $chosenEventId, $chosenRegionId, $chosenYears, $chosenPatternHtml, $chosenPatternMysql, $chosenList, $chosenMap; $chosenEventId = getNormalParam('eventId'); $chosenRegionId = getNormalParam('regionId'); $chosenPatternHtml = getHtmlParam('pattern'); $chosenPatternMysql = getMysqlParam('pattern'); $chosenYears = getNormalParam('years'); $chosenList = getBooleanParam('list'); $chosenMap = getBooleanParam('map'); if (!$chosenList && !$chosenMap) { $chosenYears = "current"; } if (!$chosenMap) { $chosenList = true; } }
function analyzeChoices() { #---------------------------------------------------------------------- global $chosenCompetitionId, $chosenType, $chosenText, $chosenUri; global $chosenSubmitterName, $chosenSubmitterEmail, $chosenSubmitterComment; global $chosenTextHtml, $chosenUriHtml, $chosenSubmitterNameHtml, $chosenSubmitterEmailHtml, $chosenSubmitterCommentHtml; global $chosenRecaptchaChallenge, $chosenRecaptchaResponse; $chosenCompetitionId = getNormalParam('competitionId'); $chosenType = getNormalParam('type'); $chosenText = getMysqlParam('text'); $chosenUri = getMysqlParam('uri'); $chosenSubmitterName = getMysqlParam('submitterName'); $chosenSubmitterEmail = getMysqlParam('submitterEmail'); $chosenSubmitterComment = getMysqlParam('submitterComment'); $chosenTextHtml = getHtmlParam('text'); $chosenUriHtml = getHtmlParam('uri'); $chosenSubmitterNameHtml = getHtmlParam('submitterName'); $chosenSubmitterEmailHtml = getHtmlParam('submitterEmail'); $chosenSubmitterCommentHtml = getHtmlParam('submitterComment'); $chosenRecaptchaChallenge = getRawParamThisShouldBeAnException('recaptcha_challenge_field'); $chosenRecaptchaResponse = getRawParamThisShouldBeAnException('recaptcha_response_field'); }
function saveMedium() { #---------------------------------------------------------------------- global $mediumId; $type = getNormalParam('type'); $competitionId = getNormalParam('competitionId'); $text = getMysqlParam('text'); $link = getMysqlParam('link'); $submitterName = getMysqlParam('submitterName'); $submitterEmail = getMysqlParam('submitterEmail'); $submitterComment = getMysqlParam('submitterComment'); $command = "\n UPDATE CompetitionsMedia\n SET type='{$type}',\n competitionId='{$competitionId}',\n text='{$text}',\n uri='{$link}',\n submitterName='{$submitterName}',\n submitterEmail='{$submitterEmail}',\n submitterComment='{$submitterComment}'\n WHERE id={$mediumId}"; dbCommand($command); echo "I just did this : \n"; echo $command; }
function savePreregForm() { #---------------------------------------------------------------------- global $chosenCompetitionId, $competition, $config; $personId = getMysqlParam('personId'); $name = getMysqlParam('name'); $countryId = getMysqlParam('countryId'); $gender = getMysqlParam('gender'); $birthYear = getMysqlParam('birthYear'); $birthMonth = getMysqlParam('birthMonth'); $birthDay = getMysqlParam('birthDay'); $email = getMysqlParam('email'); $guests = getMysqlParam('guests'); $comments = getMysqlParam('comments'); $ip = getMysqlParam('ip'); if (!$name or !$email or !$gender) { noticeBox(false, "Fields 'name', 'gender' and 'email' are required."); return false; } if (!preg_match("/^[_0-9a-zA-Z-]+(\\.[_0-9a-zA-Z-]+)*@[0-9a-zA-Z-]+(\\.[0-9a-zA-Z-]+)*(\\.[a-zA-Z]{2,3})\$/", $email)) { noticeBox(false, "Incorrect email address."); return false; } if ($birthYear == date('Y')) { noticeBox(false, "Please enter your date of birth."); return false; } if (!$birthYear) { $chosenPerson = dbQuery("SELECT * FROM Persons WHERE id='{$personId}'"); $chosenPerson = $chosenPerson[0]; $birthYear = $chosenPerson['year']; $birthMonth = $chosenPerson['month']; $birthDay = $chosenPerson['day']; } $guests = str_replace(array("\r\n", "\n", "\r", ","), ";", $guests); #--- Building query $eventIds = ''; foreach (getAllEventIds() as $eventId) { if (getBooleanParam("E{$eventId}")) { $eventIds .= "{$eventId} "; } } rtrim($eventIds); # Remove last space $into = "competitionId, name, personId, countryId, gender, birthYear, birthMonth, birthDay, email, guests, comments, ip, status, eventIds"; $values = "'{$chosenCompetitionId}', '{$name}', '{$personId}', '{$countryId}', '{$gender}', '{$birthYear}', '{$birthMonth}', '{$birthDay}', '{$email}', '{$guests}', '{$comments}', '{$ip}', 'p', '{$eventIds}'"; dbCommand("INSERT INTO Preregs ({$into}) VALUES ({$values})"); $organizers = getCompetitionOrganizers($competition['id']); foreach ($organizers as $organizer) { $mailEmail = $organizer['email']; // load more competition data for a nicer email $result = dbQuery("SELECT * FROM Competitions WHERE id='{$chosenCompetitionId}'"); $competition_data = $result[0]; $mailBody = "A new competitor has registered for your competition - " . $competition['cellName'] . "! "; $mailBody .= "Their information is below.\n-------------------\n"; if ($personId) { $mailBody .= "Name : {$name}"; $mailBody .= " {$personId} - https://www.worldcubeassociation.org/results/p.php?i={$personId}\n"; } else { $mailBody .= "Name : {$name}\n"; } $mailBody .= "Country : {$countryId}\n"; $mailBody .= "Gender : {$gender}\n"; $mailBody .= "Date of birth : {$birthYear}/{$birthMonth}/{$birthDay}\n"; $mailBody .= "Email : {$email}\n"; $mailBody .= "Events : {$eventIds}\n"; $mailBody .= "Guests : {$guests}\n"; $mailBody .= "Comments : {$comments}\n"; $mailBody .= "Ip : {$ip}\n"; $mailBody .= "-------------------\n"; $mailBody .= "You may edit this registration (and others) at:\n"; $mailBody .= "https://www.worldcubeassociation.org/competitions/{$chosenCompetitionId}/registrations"; $mailSubject = $competition['cellName'] . " - New registration"; $mail_config = $config->get('mail'); // only send mails on the real website if (preg_match('/^www.worldcubeassociation.org$/', $_SERVER["SERVER_NAME"])) { if ($mail_config['pear']) { // send smtp mail $headers = array('From' => $mail_config['from'], 'To' => $mailEmail, 'Subject' => $mailSubject); $smtp = Mail::factory('smtp', array('host' => $mail_config['host'], 'port' => $mail_config['port'], 'auth' => true, 'username' => $mail_config['user'], 'password' => $mail_config['pass'])); $mail = $smtp->send($mailEmail, $headers, $mailBody); } else { // normal php mail $mailHeaders = "From: \"WCA\" <" . $mail_config['from'] . ">\r\n"; $mailHeaders .= "Reply-To: board@worldcubeassociation.org\r\n"; $mailHeaders .= "MIME-Version: 1.0\r\n"; $mailHeaders .= "Content-Type: text/plain; charset=UTF-8\r\n"; mail($mailEmail, $mailSubject, $mailBody, $mailHeaders, "-f" . $mail_config['from']); } } else { // just print out message when testing noticeBox3(0, "Mail not sent (test website): " . $mailBody); } } noticeBox(true, "Registration complete.<br />Please note that all registrations must be approved by the organizer.<br/>Your registration will appear here within a few days."); return true; }