= 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 < $meal2cnt || $party_cnt < ($meal3acnt + $meal3bcnt + $meal3ccnt) || $party_cnt < $meal4cnt) { print(" \n"); print(" \n"); print(" NCACAA $meeting_year State Meeting: Registration Failed \n"); require("header.txt"); print("
\n"); print("

Registration Failed

\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 ; } $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); $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 2009registration (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, meal2cnt, meal3acnt, meal3bcnt, meal3ccnt, meal4cnt, event1cnt, event2cnt, event3cnt, event4cnt, event5cnt, event6cnt, event7cnt, event8cnt, event9cnt, event10cnt, event11cnt, event12cnt, event13cnt, event14cnt, event15cnt, event16cnt, event17cnt, event18cnt, event19cnt, event20cnt, event21cnt, event22cnt, event23cnt, 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', '$meal2cnt', '$meal3acnt', '$meal3bcnt', '$meal3ccnt', '$meal4cnt', '$event1cnt', '$event2cnt', '$event3cnt', '$event4cnt', '$event5cnt', '$event6cnt', '$event7cnt', '$event8cnt', '$event9cnt', '$event10cnt', '$event11cnt', '$event12cnt', '$event13cnt', '$event14cnt', '$event15cnt', '$event16cnt', '$event17cnt', '$event18cnt', '$event19cnt', '$event20cnt', '$event21cnt', '$event22cnt', '$event23cnt', '$comments', NOW(), NOW()) "; $result = mysql_query ($sql) or die (mysql_error_message()); $id = mysql_insert_id (); if ($golf_player1 != '') { $sql = "INSERT INTO 2009golf (reg_id, player, player_score, team) VALUES ('$id', '$golf_player1', '$golf_player_score1', '$golf_team1')"; $result = mysql_query ($sql) or die (mysql_error_message()); } if ($golf_player2 != '') { $sql = "INSERT INTO 2009golf (reg_id, player, player_score, team) VALUES ('$id', '$golf_player2', '$golf_player_score2', '$golf_team2')"; $result = mysql_query ($sql) or die (mysql_error_message()); } if ($golf_player3 != '') { $sql = "INSERT INTO 2009golf (reg_id, player, player_score, team) VALUES ('$id', '$golf_player3', '$golf_player_score3', '$golf_team3')"; $result = mysql_query ($sql) or die (mysql_error_message()); } if ($golf_player4 != '') { $sql = "INSERT INTO 2009golf (reg_id, player, player_score, team) VALUES ('$id', '$golf_player4', '$golf_player_score4', '$golf_team4')"; $result = mysql_query ($sql) or die (mysql_error_message()); } print(" \n"); print(" \n"); print(" NCACAA $meeting_year State Meeting: Registration Completed \n"); include ("header.txt"); print("
\n"); print("

Registration Submitted for $first_name $last_name

\n"); print("
\n"); print ("
\n"); print ("\n"); if ($spouse != '') { print (" \n"); print (" \n"); print (" \n"); } if ($child_name_age != '') { print (" \n"); print (" \n"); print (" \n"); } /* print (" \n"); print (" \n"); print (" \n"); print (" \n"); print (" \n"); print (" \n"); print (" \n"); print (" \n"); print (" \n"); */ print ("

Spouse: " . stripslashes ($spouse_name) . "

Guests/Children: " . stripslashes ($child_name_age) . "

County: " . stripslashes ($county) . "

" . stripslashes ($address) . "
" . stripslashes ($city) . ", $state $zip

$phone
$email

\n"); print ("\n"); print (" \n"); print (" \n"); print (" \n"); if ($members > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($spouse > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($children > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($life_members > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($life_member_spouse > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($banquet_only > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($golfers > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } /* if ($event2cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } */ if ($today_epoch >= $late_date_epoch) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($total_amt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } print ("
Fees
$" . ($members * $member_cost) . "Members & Guests
$" . ($spouse * $spouse_cost) . "Spouse
$" . ($children * $child_cost) . "Children
$" . ($life_members * $life_member_cost) . "Life Members
$" . ($life_member_spouse * $life_member_spouse_cost) . "Life Members' Spouse
$" . ($banquet_only * $banquet_cost) . "Banquet Only
$" . ($golfers * $golf_cost) . "Golf Tournament
$" . ($event2cnt * $event2_cost) . "$event2_title
$" . ($late_fee) . "Late Fee
\$" . number_format ($total_amt, 0). "Total
\n"); print ("\n"); print (" \n"); print (" \n"); print (" \n"); print (" \n"); if ($meal1cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($meal2cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($meal6cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($meal3acnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($meal3bcnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($meal3ccnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($meal4cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($golfers > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event1cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event2cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event3cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event4cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event5cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event6cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event7cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event8cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event9cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event10cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event11cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event12cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event13cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event14cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event15cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event16cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event17cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event18cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event19cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event20cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event21cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event22cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event23cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($comments > '') { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } print ("
QuantityMeals and Activities
$meal1cnt$meal1
$meal2cnt$meal2
$meal6cnt$meal6
$meal3acnt$meal3 ($meal3a)
$meal3bcnt$meal3 ($meal3a)
$meal3ccnt$meal3 ($meal3a)
$meal4cnt$meal4
$golfersGolf Tournament
$event1cnt$event1
" . ($event2cnt) . "$event2
$event3cnt$event3
$event4cnt$event4
$event5cnt$event5
$event6cnt$event6
$event7cnt$event7
$event8cnt$event8
$event9cnt$event9
$event10cnt$event10
$event11cnt$event11
$event12cnt$event12
$event13cnt$event13
$event14cnt$event14
$event15cnt$event15
$event16cnt$event16
$event17cnt$event17
$event18cnt$event18
$event19cnt$event19
$event20cnt$event20
$event21cnt$event21
$event22cnt$event22
$event23cnt$event23
Comments: " . stripslashes ($comments) . "
\n"); print("
\n"); print("
\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 $treasurer_name - $treasurer_phone\n"); print("

Print this page and mail it, along with a check made payable to NCACAA, to:
\n"); print("

$treasurer_address

\n"); print("

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.

\n"); print(" \n"); print(" \n"); } else { // not all required info passed print(" \n"); print(" \n"); print(" NCACAA $meeting_year State Meeting: Registration Failed \n"); require("header.txt"); print("
\n"); print("

Registration Failed

\n"); print("
\n"); print("

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 ("

Missing fields

\n"); print (" \n"); print(" \n"); print(" \n"); exit ; } ?>