\n"; ?> \n"; mysql_select_db($database_amweek, $amweek); if ($UserIsManager) { $query_CamperInfo = sprintf("SELECT * FROM campers2013 WHERE id = %s", GetSQLValueString($colname_CamperID, "text")); } else { $query_CamperInfo = sprintf("SELECT * FROM campers2013 WHERE Email = %s", GetSQLValueString($colname_CamperInfo, "text")); } $query_limit_CamperInfo = sprintf("%s LIMIT %d, %d", $query_CamperInfo, $startRow_CamperInfo, $maxRows_CamperInfo); echo ""; $CamperInfo = mysql_query($query_limit_CamperInfo, $amweek) or die(mysql_error()); $row_CamperInfo = mysql_fetch_assoc($CamperInfo); if (isset($_GET['totalRows_CamperInfo'])) { $totalRows_CamperInfo = $_GET['totalRows_CamperInfo']; } else { $all_CamperInfo = mysql_query($query_CamperInfo, $amweek); $totalRows_CamperInfo = mysql_num_rows($all_CamperInfo); } $totalPages_CamperInfo = ceil($totalRows_CamperInfo/$maxRows_CamperInfo)-1; $_SESSION['CamperID'] = $row_CamperInfo['id']; $maxRows_Payments = 15; $pageNum_Payments = 0; if (isset($_GET['pageNum_Payments'])) { $pageNum_Payments = $_GET['pageNum_Payments']; } $startRow_Payments = $pageNum_Payments * $maxRows_Payments; $colname_Payments = "-1"; if (isset($_SESSION['CamperID'])) { $colname_Payments = $_SESSION['CamperID']; } mysql_select_db($database_amweek, $amweek); $query_Payments = sprintf("SELECT * FROM payments2013 WHERE CamperID = %s", GetSQLValueString($colname_Payments, "int")); $query_limit_Payments = sprintf("%s LIMIT %d, %d", $query_Payments, $startRow_Payments, $maxRows_Payments); $Payments = mysql_query($query_limit_Payments, $amweek) or die(mysql_error()); $row_Payments = mysql_fetch_assoc($Payments); if (isset($_GET['totalRows_Payments'])) { $totalRows_Payments = $_GET['totalRows_Payments']; } else { $all_Payments = mysql_query($query_Payments, $amweek); $totalRows_Payments = mysql_num_rows($all_Payments); } $totalPages_Payments = ceil($totalRows_Payments/$maxRows_Payments)-1; $_SESSION["CamperID"] = $row_CamperInfo['id']; ?> BACDS American Dance and Music Week - View/Update Camper Information

BACDS American Dance and Music Week — June 30–July 5, 2013 BACDS American Dance and Music Week, June 30–July 5, 2013

View/Update Camper Information

"; } else { ?>

Here's your current information:

We have "; if (!isset($row_CamperInfo['WaiverReceived']) || $row_CamperInfo['WaiverReceived']==0) { echo "NOT "; } if ($UserIsManager) { echo " received the camper's Waiver Form." ; } else { echo "received your required Waiver Form [PDF]." ; if (!isset($row_CamperInfo['WaiverReceived']) || $row_CamperInfo['WaiverReceived']==0) { echo " Please download the Waiver Form, fill it in and sign it, and mail it or scan and email the scan image."; } } echo "

"; ?>
Contact Information
First Name: Last Name: Primary Phone:
Address Line1: Email:
Address Line2: Sex:
City: State/Province: ZIP/PostalCode:
Country: Name for Button:  
" > " > " > " > " > " > " > " > " >
Preferences "; } elseif ($row_CamperInfo['HousingPref'] == "OffSite") { echo " Off-Site"; } else { echo " in a shared dormitory cabin"; } if ($row_CamperInfo['ShareWith'] != "") { echo "\n"; $NoPrefs = ""; } echo ""; } elseif ($row_CamperInfo['HousingGenderPref'] == "F") { echo " Female Only"; } else { echo " Mixed Gender OK"; } ?> "; $NoPrefs = ""; } ?> "; $NoPrefs = ""; } if ($row_CamperInfo['Sponsors'] != "") { echo ""; $NoPrefs = ""; } ?> 0) || ($row_CamperInfo['OmitAddress'] > 0) || ($row_CamperInfo['OmitHomePhone'] > 0) || ($row_CamperInfo['OmitEmail'] > 0)) { echo ""; } ?> "; } ?> "; } else { echo ""; } if ($row_CamperInfo['Diet'] != "") { echo ""; } echo ""; if ($row_CamperInfo['ApplicationComments'] != "") { echo ""; $NoPrefs = ""; } ?>
I will be staying "; if ($row_CamperInfo['HousingPref'] == "Tent") { echo " in my own tent
Please assign me to same shared cabin as: " . $row_CamperInfo['ShareWith']. "
My housing preference is:         "; if ($row_CamperInfo['HousingGenderPref'] == "M") { echo " Male Only
I will attend only if this person also attends:       " . $row_CamperInfo['AttendWith'] . "
I am sponsoring this camper for "Four for Three": " . $row_CamperInfo['Referral'] . "
My sponsors for "Four for Three" are: " . $row_CamperInfo['Sponsors'] . "
Do NOT print on the camp roster: "; $NoPrefs = ""; if ($row_CamperInfo['OmitName'] > 0) echo "Name  "; if ($row_CamperInfo['OmitAddress'] > 0) echo "Address  "; if ($row_CamperInfo['OmitHomePhone'] > 0) echo "Phone  "; if ($row_CamperInfo['OmitEmail'] > 0) echo "Email  "; echo "
I am: "; $NoPrefs = ""; if ($row_CamperInfo['NightOwl'] > 0) echo "Night Owl      "; if ($row_CamperInfo['EarlyToBed'] > 0) echo "Early To Bed      "; if ($row_CamperInfo['PartyAnimal'] > 0) echo "Party Animal      "; if ($row_CamperInfo['LateToRise'] > 0) echo "Late To Rise      "; if ($row_CamperInfo['EarlyBird'] > 0) echo "Early Bird"; echo "
No size/style specified for T-shirt
T-shirt size/style: " . $row_CamperInfo['Tshirt'] . "
Dietary Restrictions:   " . $row_CamperInfo['Diet'] . "
Food Allergies:   "; if ($row_CamperInfo['Allergies'] == "") { echo "<none>"; } else { echo "" . $row_CamperInfo['Allergies'] . ""; $NoPrefs = ""; } echo "
Notes:
    " . $row_CamperInfo['ApplicationComments'] . "
" > " > " > " > " > " > " > " > " >
Payments 0) && ($FeeStructure != "Full Camper Fee")) { ?> "; echo ""; $Total += $DonationAmount; } ?> "; } ?> "; if ($Donation != "") { echo ""; echo ""; } if ($SemiPrivate != "") { echo ""; } } ?> 0) { ?>
"Full Fee Adult", "Camper26-300" => "Age 26-30", "Camper23-250" => "Age 23-25", "Camper17-200" => "Age 17-22", "Camper13-150" => "Age 13-16", "UnderEmployed-300" => "Underemployed", "Committee-300" => "Committee", "Staff-0" => "Staff", "Camper4For3-0" => "Hey for 4 for 3", "Spice-300" => "Spice" ); $CamperType = $feeStructure[$row_CamperInfo['CamperType']]; echo $row_CamperInfo['FeeStructure'] . "Camper Fee: " . $CamperType . ""; ?> $$FeeAmount" ?>
Age when camp opens June 30, 2013:     "; ?> 
Donation — Thank you!" . $row_CamperInfo['Donation'] . "
$100.00    (per person, double-occupancy)"; $Total += 100.00; } ?>

Total Amount:

 $$DisplayTotal

"; ?>
Referral (for 4-for-3 group discount):$Referral
Minimum Deposit: $$DepositAmount
Donation — Thank you!$Donation
Requested Semi-Private room: $100.00    (per person, double-occupancy)

Payments Received:      
Date Paid By Amount
<none>
Total Payments Received: $$TotalPaymentsString"; $Balance = $Total - $TotalPayments; $BalanceAmount = sprintf("%01.2f", $Balance); ?>
Remaining Balance Due before June 1:
$$BalanceAmount"; ?>
" > " > " > " > " > " > " > " > " >
PAID IN FULL
Carpooling
" > " > " > " > " > " > " > " > " >

New! Offer a ride to out-of-town campers!

(our Hospitality Coordinator will be in touch to connect you with riders)

Out of town Campers: our Hospitality Coordinator can help connect you with rides

from:
to:
(Please also post an email request to <amweek2013-campers@bacds.org> asking for a ride)