$user_info = explode("^", $user_info);
 $table_assign_judge = table_assignments($user_info[0], "J", $_SESSION['prefsTimeZone'], $_SESSION['prefsDateFormat'], $_SESSION['prefsTimeFormat'], 1);
 $table_assign_steward = table_assignments($user_info[0], "S", $_SESSION['prefsTimeZone'], $_SESSION['prefsDateFormat'], $_SESSION['prefsTimeFormat'], 1);
 if ($filter == "judges") {
     $locations = $row_brewer['brewerJudgeLocation'];
 }
 if ($filter == "stewards") {
     $locations = $row_brewer['brewerStewardLocation'];
 }
 if ($_SESSION['brewerCountry'] == "United States") {
     $us_phone = TRUE;
 } else {
     $us_phone = FALSE;
 }
 unset($brewer_assignment);
 $brewer_assignment = brewer_assignment($row_brewer['uid'], "1", $id, $dbTable);
 //$judge_array = str_replace(", ",",",$brewer_assignment);
 //$judge_array = explode(",",$judge_array);
 //if (in_array("Judge",$judge_array)) $brewer_judge = TRUE; else $brewer_judge = FALSE;
 if ($action == "print") {
     $output_datatables_body .= "<tr class='bdr1B_gray'>";
 } else {
     $output_datatables_body .= "<tr>";
 }
 $output_datatables_body .= "<td class='dataList'><a name='" . $row_brewer['uid'] . "'>" . $row_brewer['brewerLastName'] . "</a></td>";
 $output_datatables_body .= "<td class='dataList'>" . $row_brewer['brewerFirstName'] . "</td>";
 $output_datatables_body .= "<td class='dataList'>";
 $output_datatables_body .= "<a href='mailto:" . $row_brewer['brewerEmail'] . "?Subject={$email_subject}'>" . $row_brewer['brewerEmail'] . "</a><br />";
 if ($row_brewer['brewerPhone1'] != "") {
     if ($us_phone) {
         $output_datatables_body .= format_phone_us($row_brewer['brewerPhone1']) . " (1)<br>";
     $loc = "_" . str_replace(' ', '_', $row_judging['judgingLocName']);
 } else {
     $loc = "";
 }
 $date = date("m-d-Y");
 $a[] = array('First Name', 'Last Name', 'Address', 'City', 'State/Province', 'Zip', 'Country', 'Phone', 'Email', 'Clubs', 'Entries In...', 'Assignment', 'Judge ID', 'Judge Rank', 'Likes', 'Dislikes');
 //echo $query_sql;
 do {
     $brewerFirstName = strtr($row_sql['brewerFirstName'], $html_remove);
     $brewerLastName = strtr($row_sql['brewerLastName'], $html_remove);
     $brewerAddress = strtr($row_sql['brewerAddress'], $html_remove);
     $brewerCity = strtr($row_sql['brewerCity'], $html_remove);
     if ($go == "tab") {
         $assignment = $row_sql['brewerNickname'];
     } else {
         $assignment = brewer_assignment($row_sql['uid'], "1");
     }
     if ($row_sql['brewerCountry'] == "United States") {
         $phone = format_phone_us($row_sql['brewerPhone1']);
     } else {
         $phone = $row_sql['brewerPhone1'];
     }
     $a[] = array($brewerFirstName, $brewerLastName, $brewerAddress, $brewerCity, $row_sql['brewerState'], $row_sql['brewerZip'], $row_sql['brewerCountry'], $phone, $row_sql['brewerEmail'], $row_sql['brewerClubs'], judge_entries($row_sql['uid'], 0), $assignment, $row_sql['brewerJudgeID'], str_replace(",", ", ", $row_sql['brewerJudgeRank']), style_convert($row_sql['brewerJudgeLikes'], '6'), style_convert($row_sql['brewerJudgeDislikes'], '6'));
 } while ($row_sql = mysql_fetch_assoc($sql));
 $filename = ltrim(filename($contest) . "_Participants" . filename($date) . $loc . $extension, "_");
 header('Content-type: application/x-msdownload');
 header('Content-Disposition: attachment;filename="' . $filename . '"');
 header('Pragma: no-cache');
 header('Expires: 0');
 $fp = fopen('php://output', 'w');
 foreach ($a as $fields) {
    echo $base_url . "index.php?section=admin&amp;go=judging";
    ?>
">
</form>
<?php 
}
?>


<?php 
if ($action == "update" && $bid == "default") {
    ?>
<table>
 <tr>
   <td class="dataLabel">Assign <?php 
    echo brewer_assignment($filter, "3", "default", "default", "default");
    ?>
 To:</td>
   <td class="data">
   <select class="selectpicker" name="judge_loc" id="judge_loc" onchange="jumpMenu('self',this,0)" data-width="auto">
	<option value=""></option>
    <?php 
    do {
        ?>
	<option value="index.php?section=admin&amp;action=update&amp;go=judging&amp;filter=<?php 
        echo $filter;
        ?>
&amp;bid=<?php 
        echo $row_judging['id'];
        ?>
"><?php 
     $loc = "_" . str_replace(' ', '_', $row_judging['judgingLocName']);
 } else {
     $loc = "";
 }
 $date = date("m-d-Y");
 $a[] = array('First Name', 'Last Name', 'Address', 'City', 'State/Province', 'Zip', 'Country', 'Phone', 'Email', 'Clubs', 'Entries In...', 'Assignment', 'Judge ID', 'Judge Rank', 'Likes', 'Dislikes');
 //echo $query_sql;
 do {
     $brewerFirstName = strtr($row_sql['brewerFirstName'], $html_remove);
     $brewerLastName = strtr($row_sql['brewerLastName'], $html_remove);
     $brewerAddress = strtr($row_sql['brewerAddress'], $html_remove);
     $brewerCity = strtr($row_sql['brewerCity'], $html_remove);
     if ($go == "tab") {
         $assignment = $row_sql['brewerNickname'];
     } else {
         $assignment = brewer_assignment($row_sql['uid'], "1", "blah", "default", "default");
     }
     if ($row_sql['brewerCountry'] == "United States") {
         $phone = format_phone_us($row_sql['brewerPhone1']);
     } else {
         $phone = $row_sql['brewerPhone1'];
     }
     $a[] = array($brewerFirstName, $brewerLastName, $brewerAddress, $brewerCity, $row_sql['brewerState'], $row_sql['brewerZip'], $row_sql['brewerCountry'], $phone, $row_sql['brewerEmail'], $row_sql['brewerClubs'], judge_entries($row_sql['uid'], 0), $assignment, $row_sql['brewerJudgeID'], str_replace(",", ", ", $row_sql['brewerJudgeRank']), style_convert($row_sql['brewerJudgeLikes'], '6'), style_convert($row_sql['brewerJudgeDislikes'], '6'));
 } while ($row_sql = mysql_fetch_assoc($sql));
 $filename = ltrim(filename($contest) . "_Participants" . filename($date) . $loc . $extension, "_");
 header('Content-type: application/x-msdownload');
 header('Content-Disposition: attachment;filename="' . $filename . '"');
 header('Pragma: no-cache');
 header('Expires: 0');
 $fp = fopen('php://output', 'w');
 foreach ($a as $fields) {
 }
 if ($filter == "stewards") {
     $locations = $row_brewer['brewerStewardLocation'];
 }
 if ($_SESSION['brewerCountry'] == "United States") {
     $us_phone = TRUE;
 } else {
     $us_phone = FALSE;
 }
 if ($dbTable != "default") {
     $archive = get_suffix($dbTable);
 } else {
     $archive = "default";
 }
 unset($brewer_assignment);
 $brewer_assignment = brewer_assignment($row_brewer['uid'], "1", $id, $dbTable, $filter, $archive);
 if (!empty($brewer_assignment)) {
     // Build assignment modal for participants
     unset($assignment_modal_body);
     if (strpos($brewer_assignment, "Judge") !== false || strpos($brewer_assignment, "Steward") !== false) {
         if (strpos($brewer_assignment, "Judge") !== false) {
             if (!empty($table_assign_judge)) {
                 $assignment_modal_body = "<p>" . $row_brewer['brewerFirstName'] . " is assigned as a <strong>judge</strong> to table(s): " . $table_assign_judge . "<p>";
             } else {
                 $assignment_modal_body = "<p>" . $row_brewer['brewerFirstName'] . " has been added to the <strong>judge</strong> pool, but has not been assigned to a table yet.<p>";
             }
         }
         if (strpos($brewer_assignment, "Steward") !== false) {
             if (!empty($table_assign_steward)) {
                 $assignment_modal_body .= "<p>" . $row_brewer['brewerFirstName'] . " is assigned as a <strong>steward</strong> to table(s): " . $table_assign_steward . "<p>";
             } else {
 $output_datatables_actions = "";
 $user_info = user_info($row_brewer['uid']);
 $user_info = explode("^", $user_info);
 if ($filter == "judges") {
     $locations = $row_brewer['brewerJudgeLocation'];
 }
 if ($filter == "stewards") {
     $locations = $row_brewer['brewerStewardLocation'];
 }
 if ($_SESSION['brewerCountry'] == "United States") {
     $us_phone = TRUE;
 } else {
     $us_phone = FALSE;
 }
 unset($brewer_assignment);
 $brewer_assignment = brewer_assignment($row_brewer['uid'], "1");
 //$judge_array = str_replace(", ",",",$brewer_assignment);
 //$judge_array = explode(",",$judge_array);
 //if (in_array("Judge",$judge_array)) $brewer_judge = TRUE; else $brewer_judge = FALSE;
 if ($action == "print") {
     $output_datatables_body .= "<tr class='bdr1B_gray'>";
 } else {
     $output_datatables_body .= "<tr>";
 }
 $output_datatables_body .= "<td class='dataList'>" . $row_brewer['brewerLastName'] . "</td>";
 $output_datatables_body .= "<td class='dataList'>" . $row_brewer['brewerFirstName'] . "</td>";
 $output_datatables_body .= "<td class='dataList'>";
 $output_datatables_body .= "<a href='mailto:" . $row_brewer['brewerEmail'] . "?Subject={$email_subject}'>" . $row_brewer['brewerEmail'] . "</a><br />";
 if ($row_brewer['brewerPhone1'] != "") {
     if ($us_phone) {
         $output_datatables_body .= format_phone_us($row_brewer['brewerPhone1']) . " (1)<br>";
$table_head3 = "";
$table_body3 = "";
// Page specific variables
$user_edit_links = "";
$name = "";
$email = "";
$phone = "";
$discount = "";
$aha_number = "";
// Build useful variables
if ($_SESSION['brewerDiscount'] == "Y" && $_SESSION['contestEntryFeePasswordNum'] != "") {
    $entry_discount = TRUE;
} else {
    $entry_discount = FALSE;
}
$brewer_assignment .= brewer_assignment($_SESSION['user_id'], "1", "blah", $dbTable, $filter);
$assignment_array = str_replace(", ", ",", $brewer_assignment);
$assignment_array = explode(",", $assignment_array);
if (!in_array("Judge", $assignment_array) && $_SESSION['brewerJudge'] == "Y" && $totalRows_judging3 > 1) {
    $judge_available_not_assigned = TRUE;
} else {
    $judge_available_not_assigned = FALSE;
}
if (!in_array("Steward", $assignment_array) && $_SESSION['brewerSteward'] == "Y" && $totalRows_judging3 > 1) {
    $steward_available_not_assigned = TRUE;
} else {
    $steward_available_not_assigned = FALSE;
}
if (in_array("Judge", $assignment_array) && $_SESSION['brewerJudge'] == "Y" && $totalRows_judging3 > 1) {
    $assignment = "judge";
} elseif (in_array("Steward", $assignment_array) && $_SESSION['brewerSteward'] == "Y" && $totalRows_judging3 > 1) {
$user_edit_links = "";
$edit_user_info_link = "";
$edit_email_link = "";
$edit_password_link = "";
$name = "";
$email = "";
$phone = "";
$discount = "";
$aha_number = "";
// Build useful variables
if ($_SESSION['brewerDiscount'] == "Y" && $_SESSION['contestEntryFeePasswordNum'] != "") {
    $entry_discount = TRUE;
} else {
    $entry_discount = FALSE;
}
$brewer_assignment .= brewer_assignment($_SESSION['user_id'], "1");
$assignment_array = str_replace(", ", ",", $brewer_assignment);
$assignment_array = explode(",", $assignment_array);
if (!in_array("Judge", $assignment_array) && $_SESSION['brewerJudge'] == "Y" && $totalRows_judging3 > 1) {
    $judge_available_not_assigned = TRUE;
} else {
    $judge_available_not_assigned = FALSE;
}
if (!in_array("Steward", $assignment_array) && $_SESSION['brewerSteward'] == "Y" && $totalRows_judging3 > 1) {
    $steward_available_not_assigned = TRUE;
} else {
    $steward_available_not_assigned = FALSE;
}
if (in_array("Judge", $assignment_array) && $_SESSION['brewerJudge'] == "Y" && $totalRows_judging3 > 1) {
    $assignment = "judge";
} elseif (in_array("Steward", $assignment_array) && $_SESSION['brewerSteward'] == "Y" && $totalRows_judging3 > 1) {
    echo $base_url . "index.php?section=admin&amp;go=judging";
    ?>
">
</form>
<?php 
}
?>


<?php 
if ($action == "update" && $bid == "default") {
    ?>
<table>
 <tr>
   <td class="dataLabel">Assign <?php 
    echo brewer_assignment($filter, "3");
    ?>
 To:</td>
   <td class="data">
   <select name="judge_loc" id="judge_loc" onchange="jumpMenu('self',this,0)">
	<option value=""></option>
    <?php 
    do {
        ?>
	<option value="index.php?section=admin&amp;action=update&amp;go=judging&amp;filter=<?php 
        echo $filter;
        ?>
&amp;bid=<?php 
        echo $row_judging['id'];
        ?>
"><?php