0) { $demorecord=true; $demo=mysql_fetch_array($getdemo); $occupation=$demo[occupation]; $marital=$demo[marital]; $gender=$demo[gender]; $month=$demo[month]; $day=$demo[day]; $year=$demo[year]; } } else { $badLogin = true; } } if ($submit == "yes") { require ("errorchk.php3"); $emailErr1 = errorEmail($email); $fnameErr = requiredField($firstname); $emailErr = requiredField($email); $lnameErr = requiredField($lastname); $passErr1 = requiredField($password); if ($password != $cpassword) $passErr = true; else $passErr = false; if ($pass1Err == false && $emailErr1 == false && $fnameErr == false && $emailErr == false && $lnameErr == false && $passErr == false && ! $exists) { if ($loggedin) { // check if password and regid still match (security) $checkpass=mysql_query("SELECT password FROM registrants WHERE ID=$regID") or die(mysql_error()); if (mysql_result($checkpass, 0, 0)==$oldpassword) { // update registrants and demographics tables $sql="UPDATE registrants SET fname='$firstname', lname='$lastname', dear='$dear', email='$email', address1='$address1', address2='$address2', city='$city', state='$state', zip='$zip', country='$country', homephone='$homephone', busphone='$busphone', password='$password', fax='$fax', cellphone='$cellphone' WHERE ID=$regID"; mysql_query($sql); if ($demorecord) $sql="UPDATE demographics SET gender='$gender', marital='$marital', dob='$year-$month-$day', occupation='$occupation' where regID=$regID"; else $sql = "INSERT INTO demographics (gender, marital, dob, regID, occupation) values ('$gender', '$marital', '$year-$month-$day', $regID, '$occupation')"; mysql_query($sql); } else echo "error: pass and regid do not match"; } else { $checkemail=mysql_query("select email from registrants where email='$email' and orgid=$oid"); if (mysql_num_rows($checkemail)>0) { Header("Location: page1db.php3?exists=yes&ID=$regID&oid=$oid&pid=$pid&url=$url"); exit; } else { $today = date( "Ymd", time() ); $sql = "INSERT INTO registrants (fname, lname, dear, email, address1, address2, city, state, zip, country, homephone, busphone, password, fax, cellphone, datejoined, orgid) VALUES ('$firstname', '$lastname', '$title', '$email', '$address1', '$address2', '$city', '$state', '$zip', '$country', '$homephone', '$busphone', '$password', '$fax', '$cell', '$today', $oid)"; $result = mysql_query ($sql) or die(mysql_error()); $regID = mysql_insert_id(); $sql = "INSERT INTO demographics (gender, marital, dob, regID, occupation) values ('$gender', '$marital', '$year-$month-$day', $regID, '$occupation')"; $result = mysql_query ($sql) or die(mysql_error()); mysql_query("INSERT INTO updates (regID) VALUES ($regID)"); //mailthe org that they have a new registrant $to=$orgemail; $from="website@jewishlearning.net"; $subject="New Registrant"; $body="You have a new registrant!\n"; $body.="Name: $title $firstname $lastname\n"; $body.="Email: $email\n"; $body.="Address: $address1 $address2 \n $city $state $zip $country\n"; $body.="Phone: $homephone\n"; $body.="Gender: $gender\n"; $body.="DOB: $month-$day-$year\n"; mail($to, $subject, $body, "From: $from"); } } // insert record into regorg if oid is set if ($pid!="") { //SEE IF THEY ALREADY REGISTERD FOR THIS EVENT $chkexist=mysql_query("select * from eventreg where regID=$regID and eventID=$pid"); if (mysql_num_rows($chkexist)==0) { //see where this person is coming from if(strstr($h_referer,'search')) $referer= "search"; if(strstr($h_referer,'events')) $referer= "calendar"; mysql_query("INSERT INTO eventreg (regID, eventID, orgid, referer) VALUES ($regID, $pid, $oid, '$referer')"); //enter in roievents if theres a refering org if ($referorg) { $ip = getenv ("REMOTE_ADDR"); mysql_query("insert into roievents (ip, orgid, profileid, regid) values ('$ip', $referorg, $pid, $regID)"); } //email the person to tell him that he's registered //echo "you've, $reginfo[fname] $reginfo[lname] $reginfo[email] registered for $eventinfo[longname]"; $body= "$firstname $lastname,"; $body .="\nYou've been pre-registered for $eventinfo[longname]. "; $body.="\nTo see our calendar please click the link below"; $body .="\nwww.jewishlearning.net/events/calendar.php3?oid=$oid"; $mailorgprereg='yes'; mail($email, "Event Registration", $body, "From: $orgemail"); $to2=$orgemail; $from2="website@jewishlearning.net"; $subject2="Registrant Pre-Registered"; $body2.="$title $firstname $lastname,"; $body2.=" $email"; $body2.=" registered for $eventinfo[longname]"; mail($to2, $subject2, $body2, "From: $from2"); } } // update updates table mysql_query("UPDATE updates SET page1db=NOW() WHERE regID=$regID"); Header("Location: page2db.php3?ID=$regID&oid=$oid&pid=$pid&url=$url"); } else $errors=true; } require ('headers/header.php3'); ?>

"; if ($emailErr == true) requiredFieldHandler('Email'); if ($fnameErr == true) requiredFieldHandler('FirstName'); if ($lnameErr == true) requiredFieldHandler('LastName'); if ($passErr) echo "
Your password and confirmation do not match. Please re-enter."; if ($emailErr1 == true && $emailErr == false) errorEmailHandler(); echo "

"; } if ($exists=='yes') echo "

Your email address already exists in our system.
To retrieve your password, please click the forgot password link below

"; if (!$loggedin && $submit != 'yes') { ?>
Previous Registrants
Invalid password.
  Email
  
 Password
Remember me on this computer
Remember me, but request my password
Do not remember me on this computer
Forgot your password?

New Registrants
 
First Name:
Last Name:
Title:
E-mail Address:
Postal Address: (optional)
City:
State or Province:
Zip or Postal Code:
Country:
Home Telephone:(optional)
Business Telephone:(optional)
Fax:(optional)
Cellphone:(optional)
Gender: checked > Male    checked > Female
Date of Birth : --
 Year         Month    Day
Marital Status:
Current Education or Employment status:

Please enter a password here. You will use it - along with your email address as entered above - for any future updates to your user information, and for access to any special sections of our web space which Project Genesis might make available to you.

Choose a Password: Enter again to confirm:
> >

> >

$HTTP_REFERER hi"; require ('footers/footer.php3'); ?>