<?php
// Connect to database
include_once("mainfile.php");
$from = "noreplay@".$site_url.""; // Initialize the email from variable
// This code runs only if the username is posted
if (isset ($_POST['username'])){
$username = preg_replace('#[^A-Za-z0-9]#i', '', $_POST['username']); // filter everything but letters and numbers $gender = preg_replace('#[^a-z]#i', '', $_POST['gender']); // filter everything but lowercase letters $b_m = preg_replace('#[^0-9]#i', '', $_POST['birth_month']); // filter everything but numbers $b_d = preg_replace('#[^0-9]#i', '', $_POST['birth_day']); // filter everything but numbers $b_y = preg_replace('#[^0-9]#i', '', $_POST['birth_year']); // filter everything but numbers $email1 = $_POST['email1'];
$email2 = $_POST['email2'];
$pass1 = $_POST['pass1'];
$pass2 = $_POST['pass2'];
$humancheck = $_POST['humancheck'];
// Database duplicate username check setup for use below in the error handling if else conditionals
$sql_uname_check = dbquery("SELECT username FROM myMembers WHERE username='$username'");
// Database duplicate e-mail check setup for use below in the error handling if else conditionals
$sql_email_check = dbquery("SELECT email FROM myMembers WHERE email='$emailCHecker'");
// Error handling for missing data
if ((!$username) || (!$gender) || (!$b_m) || (!$b_d) || (!$b_y) || (!$email1) || (!$email2) || (!$pass1) || (!$pass2)) {
$errorMsg = 'ERROR: You did not submit the following required information:<br /><br />';
if(!$username){
$errorMsg .= ' * User Name<br />';
}
if(!$gender){
$errorMsg .= ' * Gender: Confirm your sex.<br />';
}
if(!$b_m){
$errorMsg .= ' * Birth Month<br />';
}
if(!$b_d){
$errorMsg .= ' * Birth Day<br />';
}
if(!$b_y){
$errorMsg .= ' * Birth year<br />';
}
if(!$email1){
$errorMsg .= ' * Email Address<br />';
}
if(!$email2){
$errorMsg .= ' * Confirm Email Address<br />';
}
if(!$pass1){
$errorMsg .= ' * Login Password<br />';
}
if(!$pass2){
$errorMsg .= ' * Confirm Login Password<br />';
}
} else if ($email1 != $email2) {
$errorMsg = 'ERROR: Your Email fields below do not match<br />';
} else if ($pass1 != $pass2) {
$errorMsg = 'ERROR: Your Password fields below do not match<br />';
} else if ($humancheck != "") {
$errorMsg = 'ERROR: The Human Check field must be cleared to be sure you are human<br />';
} else if (strlen($username) < 4) { $errorMsg = "<u>ERROR:</u><br />Your User Name is too short. 4 - 20 characters please.<br />";
} else if (strlen($username) > 20) { $errorMsg = "<u>ERROR:</u><br />Your User Name is too long. 4 - 20 characters please.<br />";
} else if ($uname_check > 0){
$errorMsg = "<u>ERROR:</u><br />Your User Name is already in use inside of our system. Please try another.<br />";
} else if ($email_check > 0){
$errorMsg = "<u>ERROR:</u><br />Your Email address is already in use inside of our system. Please use another.<br />";
} else { // Error handling is ended, process the data and add member to database
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Add MD5 Hash to the password variable
$db_password = md5($pass1);
// Convert Birthday to a DATE field type format(YYYY-MM-DD) out of the month, day, and year supplied
$full_birthday = "$b_y-$b_m-$b_d";
// GET USER IP ADDRESS
$ipaddress = getenv('REMOTE_ADDR');
// Add user info into the database table for the main site table
$sql = dbquery("INSERT INTO myMembers (username, gender, birthday, email, password, ipaddress, sign_up_date)
VALUES('$username','$gender','$full_birthday','$email1','$db_password', '$ipaddress', now())")
// Create directory(folder) to hold each user's files(pics, MP3s, etc.)
mkdir("members/$id", 0755);
//!!!!!!!!!!!!!!!!!!!!!!!!! Email User the activation link !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
$to = "$email1";
$from = $site_mail;
$subject = 'Complete Your ' . $site_title . ' Registration';
//Begin HTML Email Message
base64_decode(ICAkbWVzc2FnZSA9ICJIaSAkdXNlcm5hbWUsDQoNCiAgIENvbXBsZXRlIHRoaXMgc3RlcCB0byBh
Y3RpdmF0ZSB5b3VyIGxvZ2luIGlkZW50aXR5IGF0ICRzaXRlX3VybA0KDQogICBDbGljayB0aGUg
bGluZSBiZWxvdyB0byBhY3RpdmF0ZSB3aGVuIHJlYWR5DQoNCiAgICIuJHNpdGVfdXJsLiJhY3Rp
dmF0aW9uLnBocD9pZD0kaWQmc2VxdWVuY2U9JGRiX3Bhc3N3b3JkDQogICBJZiB0aGUgVVJMIGFi
b3ZlIGlzIG5vdCBhbiBhY3RpdmUgbGluaywgcGxlYXNlIGNvcHkgYW5kIHBhc3RlIGl0IGludG8g
eW91ciBicm93c2VyIGFkZHJlc3MgYmFyDQoNCiAgIExvZ2luIGFmdGVyIHN1Y2Nlc3NmdWwgYWN0
aXZhdGlvbiB1c2luZyB5b3VyOiAgDQogICBFLW1haWwgQWRkcmVzczogJGVtYWlsMSANCiAgIFBh
c3N3b3JkOiAkcGFzczENCg0KICAgU2VlIHlvdSBvbiB0aGUgc2l0ZSEiOw0KICAgLy9lbmQgb2Yg
bWVzc2FnZQ0KCSRoZWFkZXJzICA9ICJGcm9tOiAkZnJvbVxyXG4iOw0KICAgICRoZWFkZXJzIC49
ICJDb250ZW50LXR5cGU6IHRleHRcclxuIjsNCg0KICAgIG1haWwoJHRvLCAkc3ViamVjdCwgJG1l
c3NhZ2UsICRoZWFkZXJzKTsNCgkNCiAgICRtc2dUb1VzZXIgPSAiPGgyPk9uZSBMYXN0IFN0ZXAg
LSBBY3RpdmF0ZSB0aHJvdWdoIEVtYWlsPC9oMj48aDQ+JHVzZXJuYW1lLCB0aGVyZSBpcyBvbmUg
bGFzdCBzdGVwIHRvIHZlcmlmeSB5b3VyIGVtYWlsIGlkZW50aXR5OjwvaDQ+PGJyIC8+DQogICBJ
biBhIG1vbWVudCB5b3Ugd2lsbCBiZSBzZW50IGFuIEFjdGl2YXRpb24gbGluayB0byB5b3VyIGVt
YWlsIGFkZHJlc3MuPGJyIC8+PGJyIC8+DQogICA8YnIgLz4NCiAgIDxzdHJvbmc+PGZvbnQgY29s
b3I9XCIjOTkwMDAwXCI+VkVSWSBJTVBPUlRBTlQ6PC9mb250Pjwvc3Ryb25nPiANCiAgICIuJHNp
dGVfdXJsLiIgaXQncyB1c2luZyBhbiB1bmxpY2Vuc2VkIHZlcnNpb24gb2YgPGEgaHJlZj1cImh0
dHA6Ly93d3cucGhwVmliZS5jb21cIj5waHBWaWJlPC9hPjxiciAvPjxiciAvPg0KICAgIjs=);
include_once 'msg.php';
} // Close else after duplication checks
} else { // if the form is not posted with variables, place default empty variables so no warnings or errors show
$errorMsg = "";
$username = "";
$gender = "";
$b_m = "";
$b_d = "";
$b_y = "";
$email1 = "";
$email2 = "";
$pass1 = "";
$pass2 = "";
}
?>