Register

if(isset($_POST['submitF']))
{

$reg = true;

/* Validation */

$host = "localhost";
$username = "lgn";
$password = "qlnNvlcgvg6OR";
$db_name = "createunaoc";
$table = "login";

$con=mysql_connect($host, $username, $password)or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$user = strtoupper($_POST['user']);

$result = mysql_query("SELECT * from login WHERE user LIKE '$user'");

if(mysql_num_rows($result) != 0)
{
echo "This username is already taken
“;
$reg=false;
}

if(strlen($_POST['pass']) < 6){
echo "Your password must be a minimum of 6 characters
“;
$reg=false;
}

if($_POST['pass'] != $_POST['pass2']){
echo “Your passwords do not match
“;
$reg=false;
}

if(strlen($_POST['user']) <1 || strlen($_POST['pass']) <1 || strlen($_POST['fname']) <1 || strlen($_POST['sname']) <1 || strlen($_POST['add1']) <1 || $_POST['add1'] == 'Address 1'|| strlen($_POST['city']) <1 || strlen($_POST['state']) <1 || strlen($_POST['zip']) <1 || strlen($_POST['country']) <1 || strlen($_POST['phone']) <1 || strlen($_POST['email']) <1 || strlen($_POST['placeofbirth']) <1
|| strlen($_POST['age']) <1){
echo "All mandatory fields must be filled in
“;
$reg=false;
}

if(!filter_var($_POST['email'], FILTER_VALIDATE_EMAIL)) {
echo “Please enter a valid Email Address
“;
$reg=false;
}

/* If it’s Individual or Team Registration and Information is Valid*/
if($reg == true)
{

$to_md5 = $_POST['user'].$_POST['pass'].”UNAOC Create”;
$auth_key = md5($to_md5);
$nuser = strtoupper($_POST[user]);

if($_POST['add2'] != “Address 2″)
$add = $_POST['add1'].” “.$_POST['add2'];
else
$add = $_POST['add1'];

$other = “1.~”.$_POST['1fname'].” ~”.$_POST['1sname'].”(“.$_POST['1age'].”)”.” “.”2.~”.$_POST['2fname'].” ~”.$_POST['2sname'].”(“.$_POST['2age'].”)”.” “.”3.~”.$_POST['3fname'].” ~”.$_POST['3sname'].”(“.$_POST['3age'].”)”.” “.”4.~”.$_POST['4fname'].” ~”.$_POST['4sname'].”(“.$_POST['4age'].”)”.” “.”5.~”.$_POST['5fname'].” ~”.$_POST['5sname'].”(“.$_POST['5age'].”)”.” “.”6.~”.$_POST['6fname'].” ~”.$_POST['6sname'].”(“.$_POST['6age'].”)”.” “.”7.~”.$_POST['7fname'].” ~”.$_POST['7sname'].”(“.$_POST['7age'].”)”.” “.”8.~”.$_POST['8fname'].” ~”.$_POST['8sname'].”(“.$_POST['8age'].”)”;

$sql=”INSERT INTO “.$table.” (user, pass, fname, sname, oname, role, address, city, state, zip, country, phone, altphone, fax, email, placeofbirth, age, other, auth_key,add1,add2)
VALUES(‘$nuser’,'$_POST[pass]‘,’$_POST[fname]‘,’$_POST[sname]‘,’$_POST[oname]‘,’$_POST[role]‘,’$add’,'$_POST[city]‘,’$_POST[state]‘,’$_POST[zip]‘,’$_POST[country]‘,’$_POST[phone]‘,’$_POST[altphone]‘,’$_POST[fax]‘,’$_POST[email]‘,’$_POST[placeofbirth]‘,’$_POST[age]‘,’$other’,'$auth_key’,'$_POST[add1]‘,’$_POST[add2]‘)”;

if (!mysql_query($sql,$con))
{
die(‘Error: ‘ . mysql_error());
}

echo “Congratulations! A confirmation email has been sent – Login Here “;

$to = $_POST['email'];
$subject = “Welcome to Create UNAOC”;
$body = “Thank you for signing up!”. “
“. “Welcome to Create UNAOC. You can now log onto our website at CreateUNAOC.org. Have fun creating!”;

$headers = ‘MIME-Version: 1.0′ . “\r\n”;
$headers .= ‘Content-type: text/html; charset=iso-8859-1′ . “\r\n”;
$headers .= ‘From: Create UNAOC ‘.”\r\n”;

mail($to,$subject, $body,$headers);

}

}

?>

if($_POST['reg'] == "indi" || !isset($_POST['reg']))
include "/var/www/domains/unaoc.org/www/htdocs/wp-content/themes/lgn-create/indi.php";

else if($_POST['reg']=="team")
include "/var/www/domains/unaoc.org/www/htdocs/wp-content/themes/lgn-create/team.php";

?>