".$_COOKIE["niceAccountName"]."'s BrickFest Account\n"); ?>

This is your main account page. Here, you will find details on your registration, and have access to additional features like MOC display labels, the Ride/roommate contact list etc.

Now that you are registered..

  1. If you are from out of town be sure to make your hotel reservations before the cut off dates. More info.....
  2. Need a ride or a roommate? Post your contact info to find somebody going your way, or someone who wants to cut hotel costs.
  3. Get involved in one or more of the community projects or challenges before the event and discuss them on our LUGNET group list or Yahoo.
  4. Fill out the Build The Trust Entry Form
  5. Fill out your MOC Display Card(s) Form
  6. check this page once a week to see if there are new updates for you. Updates like the event kit price or the event logo.

*/ ?>

*/ ?>
What to do... Action
1. Register Myself (or a Friend) for
2. Make Hotel Reservations (before the cut off date)
3. Sign up for a Ride or a Roommate.
4. Get Involved in one or more of the BrickFest community projects
5. Add shirts or other items to your registration
8. Review Pick-A-Brick selection
8. Pick-a-Brick bulk case order form

Check this page once a week to see if there are new updates (e.g. event kit price, new event logo, etc).

\n"); // Set up registered ids for later $regUserList = ""; $theComma = ""; // New 1/17/04 kjm // If there's a reg, add "Add OCC Model" button, otherwise they don't need it /* $isRegisteredQ = "select registration.r_id, event_info.badge_lock_date from registration, event_info where registration.u_id = {$HTTP_COOKIE_VARS['u_id']} and registration.e_id = event_info.e_id and registration.active = 1 limit 1"; $isReg = mysql_query($isRegisteredQ); if(mysql_num_rows($isReg) > 0) { $firstRegID = mysql_result($isReg,0,0); $canEdit = mysql_result($isReg,0,1); #echo "Can Edit = $canEdit

\n"; #if($canEdit == 1) { echo("\n"); #} } echo("

\n"); */ if(mysql_num_rows($getReg) > 0) { #echo("Registered Events
\n"); // They've got at least one event, loop through $thisEventHdr = ""; $latestEvent = ""; echo("\n"); while($reg = mysql_fetch_array($getReg)) { if($latestEvent != $reg['e_id']) { $latestEvent = $reg['e_id']; echo("\n"); echo("\n"); } $regUserList .= $theComma . ($reg['r_id']); $theComma = ","; // Find out if the registrant gets a badge; get short event description $badgeCheckQ = "select event_price.badge_included, event_price.description from event_price, reg_items where reg_items.e_id = {$reg['e_id']} and reg_items.r_id = {$reg['r_id']} and reg_items.ep_id = event_price.ep_id and reg_items.active = 1"; $runBadgeCheck = mysql_query($badgeCheckQ); #echo($badgeCheckQ . "

\n"); $badgeCheck = mysql_result($runBadgeCheck,0,0); $eventDesc = mysql_result($runBadgeCheck,0,1); if($badgeCheck != 1) { // Don't show badge edit btn $badgeFlag = false; } else { $badgeFlag = true; } echo("

\n"); echo("\n"); // To do: make sure they can't alter this after a certain lock date echo("\n"); if($badgeFlag == true) { echo("\n"); } else { echo("\n"); } // CANNOT EDIT AFTER JAN. 30 // Review what they've got to pay, if anything $paymentQuery = "select SUM(item_price * item_qty) from reg_items where r_id = {$reg['r_id']} and active = 1"; $getPayment = mysql_query($paymentQuery); $totalPayment = mysql_result($getPayment,0,0); // Get the payment from the ledger (TO DO) echo("\n"); // New - add "Delete" button echo("\n"); // End commented out echo("\n"); echo("\n"); } echo("
{$reg['event_name']} ({$reg['theEventstart']}-{$reg['theEventend']})
NameRegistered onView/Edit RegistrationView/Edit Badge
{$reg['first_name']} {$reg['last_name']}Registered {$reg['reg_date']}\$$totalPayment

\n"); } // Now get the items and display totals, as in the review page $itemArr = explode(",",$regUserList); if($itemArr[0] != "") { // Test to see if there are any registered names echo("Registration Details
\n"); echo("\n"); $overallCost = 0; for($i=0; $i\n"); // Get name and which event they want $getPersonalInfoQ = "select registration.first_name, registration.last_name, reg_items.ep_id, reg_items.e_id from registration, reg_items where registration.r_id = $thisRID and registration.r_id = reg_items.r_id and reg_items.ep_id > 0 and registration.active = 1"; $getInfo = mysql_query($getPersonalInfoQ); #echo("getInfo numrows = " . mysql_num_rows($getInfo) . "
\n"); while($row = mysql_fetch_array($getInfo)) { $ep_id = $row['ep_id']; $e_id = $row['e_id']; $thisName = $row['first_name'] . " " . $row['last_name']; echo("\n\n"); // Get their chosen event name and date // Get which payment option they selected, double-check shirt and badge inclusion $priceQuery = "select Notes, cost, tshirt_included, badge_included from event_price where ep_id = $ep_id"; $price_info = mysql_query($priceQuery); $chosenDays = mysql_result($price_info,0,0); $chosenCost = mysql_result($price_info,0,1); $chosenShirtInc = mysql_result($price_info,0,2); $chosenBadgeInc = mysql_result($price_info,0,3); if($chosenShirtInc == 1) { $teeshirt = true; } else { $teeshirt = false; } echo("\n"); if($chosenBadgeInc == 1) { echo("\n\n\n"); } // List items that they've chosen $overallCost = $overallCost + $chosenCost; $subTotal = $subTotal + $chosenCost; /* Deprecated 11-11 kjm if($teeshirt == true) { // They get an included shirt, find which one they picked #$shirtquery = "select items.item_name, items.item_desc, items.item_id from items, reg_items where reg_items.r_id = $thisRID and reg_items.e_id = $e_id and reg_items.item_id = items.item_id and items.item_group = 'teeshirt'"; $shirtquery = "select items.item_name, items.item_desc, items.item_id from items, reg_items where reg_items.r_id = $thisRID and reg_items.e_id = $e_id and reg_items.item_id = items.item_id and items.item_group = 'teeshirt' and reg_items.item_price = 0 and reg_items.active = 1"; #echo($shirtquery."

"); $shirtResult = mysql_query($shirtquery); if(mysql_num_rows($shirtResult) > 0) { $inc_shirt_name = mysql_result($shirtResult,0,0); $inc_shirt_desc = mysql_result($shirtResult,0,1); echo("

\n\n\n"); #echo("\n"); } else { echo("\n\n\n"); } } */ // Now get the rest of their items from reg_items $getMyItemsQ = "select reg_items.item_price, reg_items.item_qty, items.item_name, reg_items.item_size from reg_items, items where reg_items.item_id = items.item_id and reg_items.r_id = $thisRID and reg_items.item_id > 0 and reg_items.active = 1"; $myItems = mysql_query($getMyItemsQ); if(mysql_num_rows($myItems) > 0) { while($itemRow = mysql_fetch_array($myItems)) { echo("\n"); $overallCost = $overallCost + ($itemRow['item_qty'] * $itemRow['item_price']); $subTotal = $subTotal + ($itemRow['item_qty'] * $itemRow['item_price']); } } echo("\n"); #echo("\n"); } } echo("\n\n"); echo("\n\n"); echo("\n\n"); echo("
Selected items for $thisName
Event Description:$chosenDays   \$$chosenCost
Badge:One (1) LEGO Conference Name Badge (price included in registration)\$0
Tee Shirt:One (1) $inc_shirt_name (price included in registration)\$0
Tee Shirt:Click to Select T-shirt Size 
Item:(Qty: {$itemRow['item_qty']}) "); if(strlen(trim($itemRow['item_size'])) > 0) { echo($itemRow['item_size'] . " "); } echo("{$itemRow['item_name']}{$itemRow['item_qty']}x \${$itemRow['item_price']}
Subtotal: \$$subTotal
Paid: \$0
"); // STUB for TOTAL DUE - Query ledger, get difference. If they've paid, don't show paypal (above) $getPaid = mysql_query("select sum(ledger.pmt_amount) as thePaid from ledger, registration where ledger.r_id = registration.r_id and registration.u_id = {$HTTP_COOKIE_VARS['u_id']} and registration.e_id = $master_event_id"); if(mysql_num_rows($getPaid) > 0) { $alreadyPaid = mysql_result($getPaid,0,0); if(!is_numeric($alreadyPaid)) { $alreadyPaid = 0; } } else { $alreadyPaid = 0; } $totalPaid = $alreadyPaid; $totalDue = $overallCost - $totalPaid; echo("TOTAL COST:  \$$overallCost
*TOTAL PAID:  \$$totalPaid
TOTAL DUE:  \$$totalDue
\n"); } if(isset($thisRID)) { $regQ = "select r_id, email, first_name, last_name, address1, address2, city, state, postal from registration where r_id = $thisRID"; $myRegInfo = mysql_query($regQ); while($row = mysql_fetch_array($myRegInfo)) { $theRegID = $row['r_id']; $first_name = $row['first_name']; $last_name = $row['last_name']; $address1 = $row['address1']; $address2 = $row['address2']; $city = $row['city']; $state = $row['state']; $zip = $row['postal']; $email = $row['email']; } ?>

* Your payment status will be updated within 48 hours of receipt of payment.

0) { ?>

Edit Account Settings