= 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[children] + $_POST[free_children] + $_POST[life_members] + $_POST[life_member_spouse] + $_POST[banquet_only]); // error checking if ($party_cnt < ($meal1acnt + $meal1ycnt) || $party_cnt < ($meal2acnt + $meal2bcnt) || $party_cnt < $meal3cnt || $party_cnt < $meal4cnt) { print(" \n"); print(" \n"); print(" NCACAA $meeting_year State Meeting: Registration Failed \n"); require("header.html"); 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 ; } 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; $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) + ($event1cnt * $event1_cost) + ($event2ycnt * $event2y_cost) + ($event2acnt * $event2a_cost) + ($event2scnt * $event2s_cost) + ($event23cnt * $event23_cost) + ($event9cnt * $event9_cost) + ($event10cnt * $event10_cost) + ($event11cnt * $event11_cost) + ($event12cnt * $event12_cost) + ($event13cnt * $event13_cost) + ($event14cnt * $event14_cost) + ($event15cnt * $event15_cost) + ($event16cnt * $event16_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 2010registration (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, meal1acnt, meal1ycnt, meal2acnt, meal2bcnt, meal3cnt, meal4cnt, event1cnt, event2ycnt, event2acnt, event2scnt, event3cnt, event4cnt, event5cnt, event6cnt, event7cnt, event8cnt, event9cnt, event10cnt, event11cnt, event12cnt, event13cnt, event14cnt, event15cnt, event16cnt, event17cnt, event18cnt, event19cnt, event20cnt, event21cnt, event22cnt, event23cnt, event24cnt, event25cnt, event26cnt, need_youth_transportation, 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', '$meal1acnt', '$meal1ycnt', '$meal2acnt', '$meal2bcnt', '$meal3cnt', '$meal4cnt', '$event1cnt', '$event2ycnt', '$event2acnt', '$event2scnt', '$event3cnt', '$event4cnt', '$event5cnt', '$event6cnt', '$event7cnt', '$event8cnt', '$event9cnt', '$event10cnt', '$event11cnt', '$event12cnt', '$event13cnt', '$event14cnt', '$event15cnt', '$event16cnt', '$event17cnt', '$event18cnt', '$event19cnt', '$event20cnt', '$event21cnt', '$event22cnt', '$event23cnt', '$event24cnt', '$event25cnt', '$event26cnt', '$need_youth_transportation', '$comments', NOW(), NOW()) "; $result = mysql_query ($sql) or die (mysql_error_message()); $id = mysql_insert_id (); if ($golf_player1 != '') { $sql = "INSERT INTO 2010golf (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 2010golf (reg_id, player, player_score, team) VALUES ('$id', '$golf_player2', '$golf_player_score2', '$golf_team2')"; $result = mysql_query ($sql) or die (mysql_error_message()); } print(" \n"); print(" \n"); print(" NCACAA $meeting_year State Meeting: Registration Completed \n"); include ("header.html"); 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 ($event1cnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event2ycnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event2acnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($event2scnt > 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 ($event23cnt > 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
$" . ($event1cnt * $event1_cost) . "$event1
$" . ($event2ycnt * $event2y_cost) . "$event2 Youth
$" . ($event2acnt * $event2a_cost) . "$event2 Adult
$" . ($event2scnt * $event2s_cost) . "$event2 Senior
$" . ($event9cnt * $event9_cost) . "$event9
$" . ($event10cnt * $event10_cost) . "$event10
$" . ($event11cnt * $event11_cost) . "$event11
$" . ($event12cnt * $event12_cost) . "$event12
$" . ($event13cnt * $event13_cost) . "$event13
$" . ($event14cnt * $event14_cost) . "$event14
$" . ($event15cnt * $event15_cost) . "$event15
$" . ($event16cnt * $event16_cost) . "$event16
$" . ($event23cnt * $event23_cost) . "$event23
$" . ($late_fee) . "Late Fee
\$" . number_format ($total_amt, 0). "Total
\n"); print ("\n"); print (" \n"); print (" \n"); print (" \n"); print (" \n"); if ($meal1acnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($meal1ycnt > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if (($meal2acnt + $meal2bcnt) > 0) { print (" \n"); print (" \n"); print (" \n"); print (" \n"); } if ($meal3cnt > 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 ($event2ycnt > 0 || $event2acnt > 0 || $event2scnt > 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 ($event24cnt > 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 ($event26cnt > 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 ($event25cnt > 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
$meal1acnt$meal1a
$meal1ycnt$meal1y
". ($meal2acnt + $meal2bcnt) ."$meal2
$meal3cnt$meal3
$meal4cnt$meal4
$golfersGolf Tournament
$event1cnt$event1
". ($event2ycnt + $event2acnt + $event2scnt) ."$event2
$event3cnt$event3
$event4cnt$event4
$event24cnt$event24
$event5cnt$event5
$event6cnt$event6
$event7cnt$event7
$event26cnt$event26
$event8cnt$event8
$event9cnt$event9
$event10cnt$event10
$event11cnt$event11
$event12cnt$event12
$event13cnt$event13
$event14cnt$event14
$event15cnt$event15
$event16cnt$event16
$event17cnt$event17
$event25cnt$event25
$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 Katy Shook - (252) 482-6585 ex. 115\n"); print("

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

Katy Shook
\n"); print (" Chowan County Agricultural Center
\n"); print (" 730 North Granville Street, Suite A
\n"); print (" Edenton, NC 27932-1434

\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 or Katy Shook or Art Bradley.

\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.html"); 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 ; } ?>