require ("/home/ncacaa/config.php"); require ("variables.php"); if ($_POST[action] != 'Register') { include ("registration_form.php"); exit; } elseif (isset ($_POST[email]) && ($_POST[email] != '') && isset ($_POST[first_name]) && ($_POST[first_name] != '') && isset ($_POST[last_name]) && ($_POST[last_name] != '') && isset ($_POST[county]) && ($_POST[county] != '') && isset ($_POST[address]) && ($_POST[address] != '') && isset ($_POST[city]) && ($_POST[city] != '') && isset ($_POST[zip]) && ($_POST[zip] != '') && isset ($_POST[phone]) && ($_POST[phone] != '') && (($_POST[members] + $_POST[spouse] + $_POST[life_members] + $_POST[life_member_spouse] + $_POST[banquet_only]) >= 1)) { // All required info is passed - continue use_ncacaa(); // clean up rest of the variables foreach ($_POST as $key => $value) { $$key = $value; } $party_cnt = ($_POST[members] + $_POST[spouse] + $_POST[free_children] + $_POST[children] + $_POST[life_members] + $_POST[life_member_spouse] + $_POST[banquet_only]); // error checking if ($party_cnt < $meal1cnt || $party_cnt < ($meal2acnt + $meal2bcnt + $meal2ccnt) || $party_cnt < $meal3cnt || $party_cnt < $meal4cnt || $party_cnt < $meal5cnt || $party_cnt < $meal6cnt) { print(" \n"); print("
\n"); print("You have indicated that there will be more people attending one or more of the meals than you have registered. Please go back and correct this. If you feel there is an error or would like to make a change, please contact John Dorner.
\n"); print(" \n"); print(" \n"); exit ; } if (trim ($golf_player1) != '') { $golfers++ ; } if (trim ($golf_player2) != '') { $golfers++ ; } $last_name = htmlentities (trim ($last_name), ENT_QUOTES); $first_name = htmlentities (trim ($first_name), ENT_QUOTES); $county = htmlentities (trim ($county), ENT_QUOTES); $address = htmlentities (trim ($address), ENT_QUOTES); $city = trim ($city); $zip = trim ($zip); $phone = trim ($phone); $spouse = htmlentities (trim ($spouse), ENT_QUOTES); $child_name_age = htmlentities (trim ($child_name_age), ENT_QUOTES); $golf_player1 = htmlentities (trim ($golf_player1), ENT_QUOTES); $golf_player2 = htmlentities (trim ($golf_player2), ENT_QUOTES); $golf_team1 = htmlentities (trim ($golf_team1), ENT_QUOTES); $golf_team2 = htmlentities (trim ($golf_team2), ENT_QUOTES); $golf_player_score1 = trim ($golf_player_score1); $golf_player_score2 = trim ($golf_player_score2); $comments = htmlentities (trim ($comments), ENT_QUOTES); $meal2cnt = $meal2acnt + $meal2bcnt + $meal2ccnt; $total_amt = ($members * $member_cost ) + ($spouse * $spouse_cost) + ($children * $child_cost) + ($life_members * $life_member_cost) + ($life_member_spouse * $life_member_spouse_cost) + ($banquet_only * $banquet_cost) + ($golfers * $golf_cost) ; $today = getdate (); $today_epoch = mktime(0,0,0,$today[mon], $today[mday], $today[year]); if ($today_epoch > $late_date_epoch) { $total_amt += $late_fee; } else { $late_fee = 0; } $sql = "INSERT INTO 2007registration (first_name, last_name, email, address, county, city, state, zip, phone, cell_phone, spouse_name, child_name_age, members, spouse, children, free_children, life_members, life_member_spouse, special_guests, banquet_only, golfers, total_amt, late_fee, meal1cnt, meal2acnt, meal2bcnt, meal2ccnt, meal3cnt, meal4cnt, meal5cnt, meal6cnt, event1cnt, event2cnt, event3acnt, event3ycnt, event4acnt, event4ycnt, event4ages, event5cnt, event8cnt, event9cnt, event10cnt, event11cnt, event12cnt, event13cnt, comments, date, last_updated) VALUES ('$first_name', '$last_name', '$email', '$address', '$county', '$city', '$state', '$zip', '$phone', '$cell_phone', '$spouse_name', '$child_name_age', '$members', '$spouse', '$children', '$free_children', '$life_members', '$life_member_spouse', '$special_guests', '$banquet_only', '$golfers', '$total_amt', '$late_fee', '$meal1cnt', '$meal2acnt', '$meal2bcnt', '$meal2ccnt', '$meal3cnt', '$meal4cnt', '$meal5cnt', '$meal6cnt', '$event1cnt', '$event2cnt', '$event3acnt', '$event3ycnt', '$event4acnt', '$event4ycnt', '$event4ages', '$event5cnt', '$event8cnt', '$event9cnt', '$event10cnt', '$event11cnt', '$event12cnt', '$event13cnt', '$comments', NOW(), NOW()) "; $result = mysql_query ($sql) or die (mysql_error_message()); $id = mysql_insert_id (); if ($golf_player1 != '') { $sql = "INSERT INTO 2007golf (reg_id, player, player_score, team, board_mtg) VALUES ('$id', '$golf_player1', '$golf_player_score1', '$golf_team1', '$board_mtg1')"; $result = mysql_query ($sql) or die (mysql_error_message()); } if ($golf_player2 != '') { $sql = "INSERT INTO 2007golf (reg_id, player, player_score, team, board_mtg) VALUES ('$id', '$golf_player2', '$golf_player_score2', '$golf_team2', '$board_mtg2')"; $result = mysql_query ($sql) or die (mysql_error_message()); } print(" \n"); print(" \n"); print("Spouse: " . stripslashes ($spouse_name) . " | \n");
print ("
Guests/Children: " . stripslashes ($child_name_age) . " | \n");
print ("
County: " . stripslashes ($county) . " | \n");
print ("
" . stripslashes ($address) . " | \n");
print ("
$phone | \n");
print ("
Fees | \n"); print ("|
---|---|
$" . ($members * $member_cost) . " | \n"); print ("Members & Guests | \n"); print ("
$" . ($spouse * $spouse_cost) . " | \n"); print ("Spouse | \n"); print ("
$" . ($children * $child_cost) . " | \n"); print ("Children | \n"); print ("
$" . ($life_members * $life_member_cost) . " | \n"); print ("Life Members | \n"); print ("
$" . ($life_member_spouse * $life_member_spouse_cost) . " | \n"); print ("Life Members' Spouse | \n"); print ("
$" . ($banquet_only * $banquet_cost) . " | \n"); print ("Banquet Only | \n"); print ("
$" . ($golfers * $golf_cost) . " | \n"); print ("Golf Tournament | \n"); print ("
$" . ($event2cnt * $event2_cost) . " | \n"); print ("$event2_title | \n"); print ("
$" . ($late_fee) . " | \n"); print ("Late Fee | \n"); print ("
\$" . number_format ($total_amt, 0). " | \n"); print ("Total | \n"); print ("
Quantity | \n"); print ("Meals and Activities | \n"); print ("
---|---|
$meal1cnt | \n"); print ("$meal1 | \n"); print ("
$meal2cnt | \n"); print ("$meal2 | \n"); print ("
$meal6cnt | \n"); print ("$meal6 | \n"); print ("
$meal3cnt | \n"); print ("$meal3 | \n"); print ("
$meal4cnt | \n"); print ("$meal4 | \n"); print ("
$meal5cnt | \n"); print ("$meal5 | \n"); print ("
$golfers | \n"); print ("Golf Tournament | \n"); print ("
$event1cnt | \n"); print ("$event1 | \n"); print ("
" . ($event2cnt) . " | \n"); print ("$event2 | \n"); print ("
" . ($event3acnt + $event3ycnt) . " | \n"); print ("$event3 | \n"); print ("
". ($event4acnt + $event4ycnt) ." | \n"); print ("$event4 | \n"); print ("
$event5cnt | \n"); print ("$event5 | \n"); print ("
$event8cnt | \n"); print ("$event8 | \n"); print ("
$event9cnt | \n"); print ("$event9 | \n"); print ("
$event10cnt | \n"); print ("$event10 | \n"); print ("
$event11cnt | \n"); print ("$event11 | \n"); print ("
$event12cnt | \n"); print ("$event12 | \n"); print ("
$event13cnt | \n"); print ("$event13 | \n"); print ("
Comments: | \n"); print ("" . stripslashes ($comments) . " | \n"); print ("
Thank you for registering for the NCACAA Annual Meeting. Please verify that all the information is correct. If you need to make changes, please contact Keith Walters - (910) 875-3461 ex. 255\n"); print("
Print this page and mail it, along with a check made payable to NCACAA, to:
\n");
print("
Keith Walters
NCCES
Hoke County Center
P.O. Box 578
Raeford, NC 28376
If you have any problems with the registration process, contact John Dorner.
\n");
print(" If you have any questions about the meeting, either contact the person responsible for that activity or Sam Groce or Randy Wood.
Please go back and make sure you completed the form. If you feel there is an error or would like to make a change, please contact John Dorner.
\n"); print ("