Jonathan
11-26-2003, 11:41 PM
I was wondering if there was anything wrong w/ my script... I can't seem to find it... help?
<?
#####################################
# Copyright (c) 2003 Crosspoint #
# All rights reserved... #
# Written by Jonathan #
# webmaster@crosspoint.org #
#####################################
include 'connect.php';
#####################################
$username = $_POST['username'];
$password = $_POST['password'];
$password2 = $_POST['password2'];
$fname = $_POST['first_name'];
$lname = $_POST['last_name'];
$phone = $_POST['phone_number'];
$city = $_POST['city'];
$state = $_POST['state'];
$zip = $_POST['zip'];
$email = $_POST['email'];
$ip_addr = $_SERVER['REMOTE_ADDR'];
$date = now();
#####################################
if ((empty($fname)) || (empty($lname)) || (empty($phone)) || (empty($city)) || (empty($state)) || (empty($zip)) || (empty($email)) || (empty($password)) || (empty($password2)) || (empty($username))){
echo "Please enter all of the information";
include 'signup.html';
exit();
}
# Passwords
if ($password != $password2){
echo "Your passwords do not match.";
include 'signup.html';
exit();
}
# Usernames
if (ereg("([a-z,A-Z])"), $username){
echo "Please enter a valid username (all text, not letters / misc. symbols)";
include 'signup.html';
exit();
}
# First/Last Names
if ((strlen($fname) < 2) || (strlen($lname) < 2)){
echo "Please enter your full name";
include 'signup.html';
exit();
}
# Email Address
if(ereg("([[:alnum:]\.\-]+)(\@[[:alnum:]\.\-]+\.+)", $email)) {
return 1;
} else {
echo "Invalid e-mail.";
include 'signup.html';
exit();
}
if($email == "your@yourdomain.com"){
echo "Invalid e-mail.";
include 'signup.html';
exit();
}
# Phone Number
if(preg_match("/\d{3}(\w|-)?\d{3}(\w|-)?\d{4}\(w|-)?(\wext\w\d+/i", $phone)){
return 1;
} else {
echo "Invalid phone number";
include 'signup.html';
exit();
}
if($phone == "000-000-0000"){
echo "Please enter your phone number";
include 'signup.html';
exit();
}
# Convert & secure password...
$db_password = md5($password);
# Check for e-mail $ username
$check_user_text = mysql_query("select * from $table_name where username='$username'");
$check_user_in_db = mysql_num_rows($check_user_text);
$check_email_text = mysql_query("select * from $table_name where email='$email'");
$check_email_in_db = mysql_num_rows($check_email_text);
if (($check_email_in_db) == 0 && ($check_user_in_db == 0)){
$insert_query = "insert into $table_name (first_name,last_name,phone_num,city,state,zip,email,signup_date,activated,ip_address,username,passw ord)
values ('$fname','$lname','$phone','$city','$state','$zip','$email','$date','0','$ip_addr','$username','$db _password')";
$insert_action = mysql_query($insert_query);
$insert_id = mysql_insert_id();
##########################################################
### Emailing :::::::::::::::::::::::::::::::::::::::::::::
##########################################################
$subject = "Confirmation E-mail";
$message = "Dear $fname $lname,
Thank your for signing up for our Crosspoint Youth Affiliates website. We hope you will find whatever it is that you are looking for. If you would like to see something added to the site please contact the webmaster at webmaster@crosspoint.org. In order to log in you must complete this registration. To complete the registration please click below:
http://www.crosspoint.org/youth/members/activate.php?id=$userid&code=$db_password
*** If the above link is not clickable please copy and paste this into the address bar. ***
After you activate the account you can log in with the following information:
-------------------------------------
Username: $username
Password: $password
-------------------------------------
Thank you,
Webmaster
crosspoint.org
(This is an automated response, if you did not sign up for this then please ignore this email.)";
if(@mail($email,$subject,$message, "From: The Crosspoint Webmaster<webmaster@crosspoint.org>"){
echo "An e-mail has been sent to the e-mail specified. Please follow instructions on how to complete your registration.";
} else {
echo "An error has occured...";
}
##########################################################
##########################################################
} else {
echo "There was an error in creating your account... Such as the same e-mail is in our database, or the same username is in our database.";
include 'signup.html';
exit();
}
?>
<?
#####################################
# Copyright (c) 2003 Crosspoint #
# All rights reserved... #
# Written by Jonathan #
# webmaster@crosspoint.org #
#####################################
include 'connect.php';
#####################################
$username = $_POST['username'];
$password = $_POST['password'];
$password2 = $_POST['password2'];
$fname = $_POST['first_name'];
$lname = $_POST['last_name'];
$phone = $_POST['phone_number'];
$city = $_POST['city'];
$state = $_POST['state'];
$zip = $_POST['zip'];
$email = $_POST['email'];
$ip_addr = $_SERVER['REMOTE_ADDR'];
$date = now();
#####################################
if ((empty($fname)) || (empty($lname)) || (empty($phone)) || (empty($city)) || (empty($state)) || (empty($zip)) || (empty($email)) || (empty($password)) || (empty($password2)) || (empty($username))){
echo "Please enter all of the information";
include 'signup.html';
exit();
}
# Passwords
if ($password != $password2){
echo "Your passwords do not match.";
include 'signup.html';
exit();
}
# Usernames
if (ereg("([a-z,A-Z])"), $username){
echo "Please enter a valid username (all text, not letters / misc. symbols)";
include 'signup.html';
exit();
}
# First/Last Names
if ((strlen($fname) < 2) || (strlen($lname) < 2)){
echo "Please enter your full name";
include 'signup.html';
exit();
}
# Email Address
if(ereg("([[:alnum:]\.\-]+)(\@[[:alnum:]\.\-]+\.+)", $email)) {
return 1;
} else {
echo "Invalid e-mail.";
include 'signup.html';
exit();
}
if($email == "your@yourdomain.com"){
echo "Invalid e-mail.";
include 'signup.html';
exit();
}
# Phone Number
if(preg_match("/\d{3}(\w|-)?\d{3}(\w|-)?\d{4}\(w|-)?(\wext\w\d+/i", $phone)){
return 1;
} else {
echo "Invalid phone number";
include 'signup.html';
exit();
}
if($phone == "000-000-0000"){
echo "Please enter your phone number";
include 'signup.html';
exit();
}
# Convert & secure password...
$db_password = md5($password);
# Check for e-mail $ username
$check_user_text = mysql_query("select * from $table_name where username='$username'");
$check_user_in_db = mysql_num_rows($check_user_text);
$check_email_text = mysql_query("select * from $table_name where email='$email'");
$check_email_in_db = mysql_num_rows($check_email_text);
if (($check_email_in_db) == 0 && ($check_user_in_db == 0)){
$insert_query = "insert into $table_name (first_name,last_name,phone_num,city,state,zip,email,signup_date,activated,ip_address,username,passw ord)
values ('$fname','$lname','$phone','$city','$state','$zip','$email','$date','0','$ip_addr','$username','$db _password')";
$insert_action = mysql_query($insert_query);
$insert_id = mysql_insert_id();
##########################################################
### Emailing :::::::::::::::::::::::::::::::::::::::::::::
##########################################################
$subject = "Confirmation E-mail";
$message = "Dear $fname $lname,
Thank your for signing up for our Crosspoint Youth Affiliates website. We hope you will find whatever it is that you are looking for. If you would like to see something added to the site please contact the webmaster at webmaster@crosspoint.org. In order to log in you must complete this registration. To complete the registration please click below:
http://www.crosspoint.org/youth/members/activate.php?id=$userid&code=$db_password
*** If the above link is not clickable please copy and paste this into the address bar. ***
After you activate the account you can log in with the following information:
-------------------------------------
Username: $username
Password: $password
-------------------------------------
Thank you,
Webmaster
crosspoint.org
(This is an automated response, if you did not sign up for this then please ignore this email.)";
if(@mail($email,$subject,$message, "From: The Crosspoint Webmaster<webmaster@crosspoint.org>"){
echo "An e-mail has been sent to the e-mail specified. Please follow instructions on how to complete your registration.";
} else {
echo "An error has occured...";
}
##########################################################
##########################################################
} else {
echo "There was an error in creating your account... Such as the same e-mail is in our database, or the same username is in our database.";
include 'signup.html';
exit();
}
?>