}
     $territoryInfo = getTerritoryInfo($territory, $territories);
     $redir = $territoryInfo['redir'];
     $fields_recruiter = $territoryInfo['fields_recruiter'];
     $redirStr = $territoryInfo['redirStr'];
     $doRedir = $territoryInfo['doRedir'];
     $recruiter_email_handle = $territoryInfo['recruiter_email_handle'];
     $dup_flag = dupCheck($db, $email, $fname, $lname, $zip);
     /* !!!!!!!!!!!!!  SET $dup_flag to empty string until DB upload is fully ready
     			$dup_flag = "";
     */
     // build the form 1 email
     $emailArray = makeEmail($postArray, $formNum, $dup_flag);
     // add auto-submit icontact submission form in hidden iframe
     if (!$test_env) {
         $icontactFrame = makeIcontactFrame($email, $fname, $lname, $street_address, $city, $state, $zip, getDOB($dob_y, $dob_m, $dob_d), $anticipated_grad_year, $fields_recruiter);
     }
     // add to mysql db
     // get it all ready for safe insertion
     $db->do_query(makeSQL($postArray, $formNum));
     $db_id = mysql_insert_id();
 } else {
     // build the form 2 email
     $emailArray = makeEmail($postArray, $formNum, "");
     $db->do_query(makeSQL($postArray, $formNum));
     $doRedir = true;
 }
 $bad = array("*****@*****.**", "*****@*****.**");
 $from = $email;
 if (!in_array($bad, $from)) {
     $headers = "From: {$from}\r\n";
function makeSQL($postArray, $formNum)
{
    foreach ($postArray as $k => $v) {
        ${$k} = $v;
    }
    if ($formNum == "0") {
        $fname = safe($fname);
        $mname = safe($mname);
        $lname = safe($lname);
        $nickname = safe($nickname);
        $street_address = safe($street_address);
        $city = safe($city);
        $state = safe($state);
        $zip = safe($zip);
        $country = safe($country);
        $email = safe($email);
        $phone = safe($phone);
        $high_school = safe($high_school);
        $high_school_city = safe($high_school_city);
        $high_school_state = safe($high_school_state);
        $high_school_country = safe($high_school_country);
        $anticipated_grad_year = safe($anticipated_grad_year);
        if (isset($nycounty) && $nycounty != "") {
            $nycounty = safe($nycounty);
        }
        if (isset($paArea) && $paArea != "") {
            $paArea = safe($paArea);
        }
        $role = "student";
        // ('student','parent','donor','alumni')
        if ($gender == "male") {
            $gender = "m";
        } else {
            if ($gender == "female") {
                $gender = "f";
            } else {
                $gender = "";
            }
        }
        $dob = $dob_year;
        $dob .= '-';
        $dob .= $dob_month;
        $dob .= '-';
        $dob .= $dob_day;
        $hash_id = makeHash($fname, $lname, $dob_year, $dob_month, $dob_day);
        $this_ethnicity = "";
        foreach ($postArray['ethnicities'] as $ethnicity) {
            if ($postArray[$ethnicity] != "") {
                $this_ethnicity .= $ethnicity . ":" . $postArray[$ethnicity];
                $this_ethnicity .= ",";
            }
        }
        if ($this_ethnicity != "") {
            $this_ethnicity = substr($this_ethnicity, 0, strlen($this_ethnicity) - 1);
        }
        // clean up for db insert
        $academic_interests = safe($academic_interests);
        $extra_curricular = safe($extra_interests);
        $three_words = safe($three_words);
        $questions_and_comments = safe($questions_and_comments);
        $ethnicity = $this_ethnicity;
        $parent1_fname = safe($parent1_fname);
        $parent1_lname = safe($parent1_lname);
        $parent1_relationship = substr($parent1_type, 0, 1);
        $parent1_email = safe($parent1_email);
        $parent1_phone = safe($parent1_phone);
        $parent1_phonetype = $parent1_phonetype;
        $parent2_fname = safe($parent2_fname);
        $parent2_lname = safe($parent2_lname);
        $parent2_relationship = substr($parent2_type, 0, 1);
        $parent2_email = safe($parent2_email);
        $parent2_phone = safe($parent2_phone);
        $parent2_phonetype = $parent2_phonetype;
        if ($mailinglist != "") {
            $mail_list = "1";
        } else {
            $mail_list = "0";
        }
        if ($additional_questions != "") {
            $call = "1";
        } else {
            $call = "0";
        }
        $sql = "INSERT INTO forms.admission_form_submission \n\t\t\t(form_id, firstname, middlename, lastname, nickname, email, role, gender, street_address, street_address_2, \n\t\t\t city, state, country, postal_code, phone, dob, high_school, high_school_city, high_school_state, \n\t\t\t high_school_country, anticipated_grad_year, academic_interests, extra_curricular, three_words, ethnicity, \n\t\t\t reference, mail_list, `call`, comment, date_submitted, vr_email, vr_campaign, vr_term, hash_id, \n\t\t\t parent1_fname, parent1_lname, parent1_relationship, parent1_email, parent1_phone, parent1_phonetype, \n\t\t\t parent2_fname, parent2_lname, parent2_relationship, parent2_email, parent2_phone, parent2_phonetype, \n\t\t\t dup_flag, typage_wedcall, typage_thcall, typage_question, counselor) \n\t\t\t   VALUES (\n\t\t\t {$formNum}, '{$fname}', '{$mname}', '{$lname}', '{$nickname}', '{$email}', '{$role}', '{$gender}', '{$street_address}', \n\t\t\t '{$street_address_2}', '{$city}', '{$state}', '{$country}', '{$zip}', '{$phone}', '{$dob}', '{$high_school}', '{$high_school_city}', \n\t\t\t '{$high_school_state}', '{$high_school_country}', '{$anticipated_grad_year}', '{$academic_interests}', '{$extra_curricular}', \n\t\t\t '{$three_words}', '{$ethnicity}', '{$how_did_you_hear}', '{$mail_list}', '{$call}', '{$questions_and_comments}', NOW(), \n\t\t\t '', '', '', '{$hash_id}', '{$parent1_fname}', '{$parent1_lname}', '{$parent1_relationship}', '{$parent1_email}', \n\t\t\t '{$parent1_phone}', '{$parent1_phonetype}', '{$parent2_fname}', '{$parent2_lname}', '{$parent2_relationship}', \n\t\t\t '{$parent2_email}', '{$parent2_phone}', '{$parent2_phonetype}', '{$dup_flag}', '', '', '', '{$counselor}')";
    } else {
        if ($formNum == "1") {
            $fname = safe($fname);
            $mname = safe($mname);
            $lname = safe($lname);
            $nickname = safe($nickname);
            $street_address = safe($street_address);
            $city = safe($city);
            $state = safe($state);
            $zip = safe($zip);
            $country = safe($country);
            $email = safe($email);
            $phone = safe($phone);
            $high_school = safe($high_school);
            $high_school_city = safe($high_school_city);
            $high_school_state = safe($high_school_state);
            $high_school_country = safe($high_school_country);
            $anticipated_grad_year = safe($anticipated_grad_year);
            if (isset($nycounty) && $nycounty != "") {
                $nycounty = safe($nycounty);
            }
            if (isset($paArea) && $paArea != "") {
                $paArea = safe($paArea);
            }
            $role = "student";
            // ('student','parent','donor','alumni')
            if ($gender == "male") {
                $gender = "m";
            } else {
                if ($gender == "female") {
                    $gender = "f";
                } else {
                    $gender = "";
                }
            }
            $dob = getDOB($dob_y, $dob_m, $dob_d);
            $hash_id = makeHash($fname, $lname, $dob_y, $dob_m, $dob_d);
            $tinfo = getTerritoryInfo($high_school_state, $territories);
            $counselor = $tinfo['fields_recruiter'];
            $sql = "INSERT INTO forms.admission_form_submission\n(form_id, firstname, middlename, lastname, nickname, email, role, gender, street_address, street_address_2, city, state, country, postal_code, phone, dob, high_school, high_school_city, high_school_state, high_school_country, anticipated_grad_year, date_submitted, vr_email, vr_campaign, vr_term, hash_id, dup_flag,counselor) \nVALUES ({$formNum}, '{$fname}', '{$mname}', '{$lname}', '{$nickname}', '{$email}', '{$role}', '{$gender}', '{$street_address}', '{$street_address_2}', '{$city}', '{$state}', '{$country}', '{$zip}', '{$phone}', '{$dob}', '{$high_school}', '{$high_school_city}', '{$high_school_state}', '{$high_school_country}', '{$anticipated_grad_year}', NOW(), '{$vr_email}', '{$vr_campaign}', '{$vr_term}', '{$hash_id}','{$dup_flag}','{$counselor}');\n";
        } else {
            $this_ethnicity = "";
            foreach ($postArray['ethnicities'] as $ethnicity) {
                if ($postArray[$ethnicity] != "") {
                    $this_ethnicity .= $ethnicity . ":" . $postArray[$ethnicity];
                    $this_ethnicity .= ",";
                }
            }
            if ($this_ethnicity != "") {
                $this_ethnicity = substr($this_ethnicity, 0, strlen($this_ethnicity) - 1);
            }
            // clean up for db insert
            $academic_interests = safe($academic_interests);
            $extra_curricular = safe($extra_interests);
            $three_words = safe($three_words);
            $additional_questions = safe($questions_and_comments);
            $ethnicity = $this_ethnicity;
            $parent1_fname = safe($parent1_fname);
            $parent1_lname = safe($parent1_lname);
            $parent1_relationship = substr($parent1_type, 0, 1);
            $parent1_email = safe($parent1_email);
            $parent1_phone = safe($parent1_phone);
            $parent1_phonetype = $parent1_phonetype;
            $parent2_fname = safe($parent2_fname);
            $parent2_lname = safe($parent2_lname);
            $parent2_relationship = substr($parent2_type, 0, 1);
            $parent2_email = safe($parent2_email);
            $parent2_phone = safe($parent2_phone);
            $parent2_phonetype = $parent2_phonetype;
            $db_id = $db_id;
            $counselor = $counselor;
            $sql = "UPDATE forms.admission_form_submission SET \n\t\t\tacademic_interests = '{$academic_interests}',\n\t\t\textra_curricular = '{$extra_curricular}',\n\t\t\tthree_words = '{$three_words}',\n\t\t\tcomment = '{$additional_questions}',\n\t\t\tethnicity = '{$ethnicity}',\n\t\t\tparent1_fname = '{$parent1_fname}',\n\t\t\tparent1_lname = '{$parent1_lname}',\n\t\t\tparent1_relationship = '{$parent1_relationship}',\n\t\t\tparent1_email = '{$parent1_email}',\n\t\t\tparent1_phone = '{$parent1_phone}',\n\t\t\tparent1_phonetype = '{$parent1_phonetype}',\n\t\t\tparent2_fname = '{$parent2_fname}',\n\t\t\tparent2_lname = '{$parent2_lname}',\n\t\t\tparent2_relationship = '{$parent2_relationship}',\n\t\t\tparent2_email = '{$parent2_email}',\n\t\t\tparent2_phone = '{$parent2_phone}',\n\t\t\tparent2_phonetype = '{$parent2_phonetype}',\n\t\t\tcounselor = '{$counselor}' \n\t\t\t\tWHERE id = {$db_id}";
        }
    }
    return $sql;
}