include 'pop-shock_conf.php'; $showform = true; if ($_POST['sent'] == 'true') { // Sanity Check if ($_POST['firstname']) { $firstname = mysql_real_escape_string($_POST['firstname']); } else { $err[0] = true; } $middlename = mysql_real_escape_string($_POST['middlename']); if ($_POST['lastname']) { $lastname = mysql_real_escape_string($_POST['lastname']); } else { $err[1] = true; } if ($_POST['alias']) { $alias = mysql_real_escape_string($_POST['alias']); } else { $err[2] = true; } if ($_POST['character']) { $character = mysql_real_escape_string($_POST['character']); } else { $err[2] = true; } if ($_POST['charactersrc']) { $charactersrc = mysql_real_escape_string($_POST['charactersrc']); } else { $err[2] = true; } if ($_POST['costume']) { $costume = mysql_real_escape_string($_POST['costume']); } else { $err[3] = true; } if ($_POST['prop']) { $prop = mysql_real_escape_string($_POST['prop']); } else { $err[2] = true; } if ($_POST['address']) { $address = mysql_real_escape_string($_POST['address']); } else { $err[4] = true; } if ($_POST['city']) { $city = mysql_real_escape_string($_POST['city']); } else { $err[5] = true; } if (preg_match('/^[a-zA-Z]{2}/', $_POST['state']) && $_POST['state']) { $state = mysql_real_escape_string($_POST['state']); } else { $err[6] = true; } if ($_POST['zipcode']) { $zipcode = mysql_real_escape_string($_POST['zipcode']); } else { $err[7] = true; } if ($_POST['country']) { $country = mysql_real_escape_string($_POST['country']); } else { $err[8] = true; } if (preg_match('/^[0-9]{3}/', $_POST['areacode']) && $_POST['areacode']) { $areacode = mysql_real_escape_string($_POST['areacode']); } else { $err[9] = true; } if (preg_match('/^[0-9]{3}/', $_POST['phone2']) && $_POST['phone2']) { $phone2 = mysql_real_escape_string($_POST['phone2']); } else { $err[9] = true; } if (preg_match('/^[0-9]{4}/', $_POST['phone3']) && $_POST['phone3']) { $phone3 = mysql_real_escape_string($_POST['phone3']); } else { $err[9] = true; } if (preg_match('/^[0-9]{3}/', $_POST['conareacode']) && $_POST['conareacode']) { $conareacode = mysql_real_escape_string($_POST['conareacode']); } else { $err[10] = true; } if (preg_match('/^[0-9]{3}/', $_POST['conphone2']) && $_POST['conphone2']) { $conphone2 = mysql_real_escape_string($_POST['conphone2']); } else { $err[10] = true; } if (preg_match('/^[0-9]{4}/', $_POST['conphone3']) && $_POST['conphone3']) { $conphone3 = mysql_real_escape_string($_POST['conphone3']); } else { $err[10] = true; } if (preg_match('/^[a-z0-9]+([_\\.-][a-z0-9]+)*@([a-z0-9]+([\.-][a-z0-9]+)*)+\\.[a-z]{2,}$/i', $_POST['email']) && $_POST['email']) { $email = mysql_real_escape_string($_POST['email']); } else { $err[11] = true; } if (($_POST['month'] >= 1) && ($_POST['month'] <= 12)) { $month = mysql_real_escape_string($_POST['month']); } else { $err[12] = true; } if (($_POST['day'] >= 1) && ($_POST['day'] <= 31)) { $day = mysql_real_escape_string($_POST['day']); } else { $err[12] = true; } if (preg_match('/^[0-9]{2}/', $_POST['year']) && $_POST['year']) { $year = mysql_real_escape_string($_POST['year']); } else { $err[12] = true; } if ($_POST['age']) { $age = mysql_real_escape_string($_POST['age']); } else { $err[13] = true; } $max = mysql_real_escape_string($_POST["group"]); for ($i=2; $i<11; $i++) { if ($i > $max) { break; } else { if ($_POST["firstname$i"]) { ${"firstname$i"} = mysql_real_escape_string($_POST["$firstname$i"]); } else { ${"err$i"}[0] = true; } ${"middlename$i"} = mysql_real_escape_string($_POST["middlename$i"]); if ($_POST["lastname$i"]) { ${"lastname$i"} = mysql_real_escape_string($_POST["lastname$i"]); } else { ${"err$i"}[1] = true; } if ($_POST["alias$i"]) { ${"alias$i"} = mysql_real_escape_string($_POST["alias$i"]); } else { ${"err$i"}[2] = true; } if ($_POST["character$i"]) { ${"character$i"} = mysql_real_escape_string($_POST["character$i"]); } else { ${"err$i"}[3] = true; } if ($_POST["charactersrc$i"]) { ${"charactersrc$i"} = mysql_real_escape_string($_POST["charactersrc$i"]); } else { ${"err$i"}[3] = true; } if ($_POST["costume$i"]) { ${"costume$i"} = mysql_real_escape_string($_POST["costume$i"]); } else { ${"err$i"}[3] = true; } if ($_POST["prop$i"]) { ${"prop$i"} = mysql_real_escape_string($_POST["prop$i"]); } else { ${"err$i"}[3] = true; } if (($_POST['month'.$i] >= 1) && ($_POST["month$i"] <= 12)) { ${"month$i"} = mysql_real_escape_string($_POST["month$i"]); } else { ${"err$i"}[4] = true; } if (($_POST['day'.$i] >= 1) && ($_POST["day$i"] <= 31)) { ${"day$i"} = mysql_real_escape_string($_POST["day$i"]); } else { ${"err$i"}[4] = true; } if (preg_match('/^[0-9]{2}/', $_POST["year$i"]) && $_POST["year$i"]) { ${'year'.$i} = mysql_real_escape_string($_POST["year$i"]); } else { ${"err$i"}[4] = true; } if ($_POST["age$i"]) { ${"age$i"} = mysql_real_escape_string($_POST["age$i"]); } else { ${"err$i"}[5] = true; } } $bigcostumedec = mysql_real_escape_string($_POST['bigcostumedec']); $bigpropdec = mysql_real_escape_string($_POST['bigpropdec']); } $max2 = mysql_real_escape_string($_POST["group"]); for ($i=1; $i<3; $i++) { if ($i > $max2) { break; } else { if ($_POST["helperfirstname$i"]) { ${"helperfirstname$i"} = mysql_real_escape_string($_POST["$helperfirstname$i"]); } else { ${"helpererr$i"}[0] = true; } ${"helpermiddlename$i"} = mysql_real_escape_string($_POST["helpermiddlename$i"]); if ($_POST["helperlastname$i"]) { ${"helperlastname$i"} = mysql_real_escape_string($_POST["helperlastname$i"]); } else { ${"helpererr$i"}[1] = true; } if (($_POST['helpermonth'.$i] >= 1) && ($_POST["helpermonth$i"] <= 12)) { ${"helpermonth$i"} = mysql_real_escape_string($_POST["helpermonth$i"]); } else { ${"helpererr$i"}[4] = true; } if (($_POST['helperday'.$i] >= 1) && ($_POST["helperday$i"] <= 31)) { ${"helperday$i"} = mysql_real_escape_string($_POST["helperday$i"]); } else { ${"helpererr$i"}[4] = true; } if (preg_match('/^[0-9]{2}/', $_POST["helperyear$i"]) && $_POST["helperyear$i"]) { ${'helperyear'.$i} = mysql_real_escape_string($_POST["helperyear$i"]); } else { ${"helpererr$i"}[4] = true; } if ($_POST["helperage$i"]) { ${"helperage$i"} = mysql_real_escape_string($_POST["helperage$i"]); } else { ${"helpererr$i"}[5] = true; } } if ($_POST["type"] == 'skit') $type = 'skit'; else if ($_POST["type"] == 'wkonwm') $type = 'wkonwm'; else $type = 'wkonnm'; if ($_POST['audio'] == true) $audio = true; else $audio = false; $performancedec = mysql_real_escape_string($_POST["performancedec"]); if ($err == false) { mysql_connect('localhost',$mysqlserverlogin, $mysqlserverpassword); mysql_select_db($mysqlserverdb); $result = mysql_query("select email from $mysqlservertable where email='$email'"); if (mysql_num_rows($result) == 0) { mysql_query("insert into $mysqlservertable values ( '', '$firstname', '$middlename', '$lastname', '$alias', '$character', '$charactersrc', '$costume', '$prop', '$address', '$city', '$state', '$zipcode', '$country', '$areacode', '$phone2$phone3', '$conareacode', '$conphone2$conphone3', '$email', '$month', '$day', '$year', '$age', '$firstname2', '$middlename2', '$lastname2', '$alias2', '$character2', '$charactersrc2', '$costume2', '$prop2', '$month2', '$day2','$year2', '$age2', '$firstname3', '$middlename3', '$lastname3', '$alias3', '$character3', '$charactersrc3', '$costume3', '$prop3, '$month3', '$day3','$year3', '$age3', '$firstname4', '$middlename4', '$lastname4', '$alias4', '$character4', '$charactersrc4', '$costume4', '$prop4', '$month4', '$day4','$year4', '$age4', '$firstname5', '$middlename5', '$lastname5', '$alias5', '$character5', '$charactersrc5', '$costume5', '$prop5', '$month5', '$day5','$year5', '$age5', '$firstname6', '$middlename6', '$lastname6', '$alias6', '$character6', '$charactersrc6', '$costume6', '$prop6', '$month6', '$day6','$year6', '$age6', '$firstname7', '$middlename7', '$lastname7', '$alias7', '$character7', '$charactersrc7', '$costume7', '$prop7', '$month7', '$day7','$year7', '$age7', '$firstname8', '$middlename8', '$lastname8', '$alias8', '$character8', '$charactersrc8', '$costume8', '$prop8', '$month8', '$day8','$year8', '$age8', '$firstname9', '$middlename9', '$lastname9', '$alias9', '$character9', '$charactersrc9', '$costume9', '$prop9', '$month9', '$day9','$year9', '$age9', '$firstname10', '$middlename10', '$lastname10', '$alias10', '$character10', '$charactersrc10', '$costume10', '$prop10', '$month10', '$day10','$year10', '$age10', '$bigcostumedec', '$bigpropdec', '$helperfirstname1', '$helpermiddlename1', '$helperlastname1', '$helpermonth1', '$helperday1','$helperyear1', '$helperage1', '$helperfirstname2', '$helpermiddlename2', '$helperlastname2', '$helpermonth2', '$helperday2','$helperyear2', '$helperage2', '$type', '$audio', '$performancedec')"); $conf_msg = "This email is to confirm that your entry into the \"Anime Expo 2007 Pop Shock Masquerade\" is complete and has been received. The falowing information is an exact duplicate of the data sent to us in your registration form, please keep it for your records. $firstname $middlename $lastname Cosplay Alias: $alias Character: $character Character Source: $charactersrc Name of Costume: $costume Prop Maker: $prop Address: $address City: $city State: $state Zipcode: $zipcode Country: $country Phone Num: ($areacode) $phone2 - $phone3 At-Con Phone Num: ($conareacode) $conphone2 - $conphone3 E-Mail: $email Date of Birth: $month : $day : $year Age by AX 2007: $age $firstname2 $middlename2 $lastname2 Cosplay Alias: $alias2 Character: $character2 Character Source: $charactersrc2 Name of Costume: $costume2 Prop Maker: $prop2 Age: $age2 Born: $month2 : $day2 : $year2 $firstname3 $middlename3 $lastname3 Cosplay Alias: $alias3 Character: $character3 Character Source: $charactersrc3 Name of Costume: $costume3 Prop Maker: $prop3 Age: $age3 Born: $month3 : $day3 : $year3 $firstname4 $middlename4 $lastname4 Cosplay Alias: $alias4 Character: $character4 Character Source: $charactersrc4 Name of Costume: $costume4 Prop Maker: $prop4 Age: $age4 Born: $month4 : $day4 : $year4 $firstname5 $middlename5 $lastname5 Cosplay Alias: $alias5 Character: $character5 Character Source: $charactersrc5 Name of Costume: $costume5 Prop Maker: $prop5 Age: $age5 Born: $month5 : $day5 : $year5 $firstname6 $middlename6 $lastname6 Cosplay Alias: $alias6 Character: $character6 Character Source: $charactersrc6 Name of Costume: $costume6 Prop Maker: $prop6 Age: $age6 Born: $month6 : $day6 : $year6 $firstname7 $middlename7 $lastname7 Cosplay Alias: $alias7 Character: $character7 Character Source: $charactersrc7 Name of Costume: $costume7 Prop Maker: $prop7 Age: $age7 Born: $month7 : $day7 : $year7 $firstname8 $middlename8 $lastname8 Cosplay Alias: $alias8 Character: $character8 Character Source: $charactersrc8 Name of Costume: $costume8 Prop Maker: $prop8 Age: $age8 Born: $month8 : $day8 : $year8 $firstname9 $middlename9 $lastname9 Cosplay Alias: $alias9 Character: $character9 Character Source: $charactersrc9 Name of Costume: $costume9 Prop Maker: $prop9 Age: $age9 Born: $month9 : $day9 : $year9 $firstname10 $middlename10 $lastname10 Cosplay Alias: $alias10 Character: $character10 Character Source: $charactersrc10 Name of Costume: $costume10 Prop Maker: $prop10 Age: $age10 Born: $month10 : $day10 : $year10 Good luck in this years competition, we look forward to seeing you at con!"; mail("$email", "Anime Expo 2007 Pop Shock Masquerade Registration", "$conf_msg"); $showform = false; } else { $err[15] = true; } } } $headertitle = "AX Pop Shock Masquerade Registration | Anime [AX] Expo ® 2007"; include 'header.php'; ?>
if ($showform == true) { ?> } else { ?> your app is done