}
$html .= '</td>';
$html .= '</tr>';
} while ($row_scores = mysql_fetch_assoc($scores));
$html .= '</table>';
}
} while ($row_tables = mysql_fetch_assoc($tables));
}
// end if ($_SESSION['prefsWinnerMethod'] == 0)
if ($_SESSION['prefsWinnerMethod'] == 1) {
$style = styles_active(0);
foreach (array_unique($style) as $style) {
$results_count = results_count($style);
$results_count = explode("^", $results_count);
if ($results_count[0] > 0 && $results_count[1] > 0) {
$html .= '<br><br><strong>Category ' . ltrim($style, "0") . ': ' . style_convert($style, "1") . ' (' . $results_count[0] . ' entries)</strong><br>';
$html .= '<table border="1">';
$html .= '<tr>';
$html .= '<td width="35" align="center" bgcolor="#cccccc" nowrap="nowrap"><strong>Pl.</strong></td>';
$html .= '<td width="150" align="center" bgcolor="#cccccc"><strong>Brewer(s)</strong></td>';
$html .= '<td width="200" align="center" bgcolor="#cccccc"><strong>Entry Name</strong></td>';
$html .= '<td width="200" align="center" bgcolor="#cccccc"><strong>Style</strong></td>';
$html .= '<td width="175" align="center" bgcolor="#cccccc"><strong>Club</strong></td>';
$html .= '</tr>';
include DB . 'scores.db.php';
do {
$style = $row_scores['brewCategory'] . $row_scores['brewSubCategory'];
$html .= '<tr>';
$html .= '<td width="35">' . display_place($row_scores['scorePlace'], 1) . '</td>';
$html .= '<td width="150">' . $row_scores['brewerFirstName'] . ' ' . $row_scores['brewerLastName'] . '</td>';
$html .= '<td width="200">';
function winner_check($id, $judging_scores_db_table, $judging_tables_db_table, $brewing_db_table, $method)
{
require CONFIG . 'config.php';
mysql_select_db($database, $brewing);
if ($method == 6) {
// reserved for NHC admin advance
$r = "Administrative Advance";
}
if ($method == "") {
$r = "";
}
if ($method < 6) {
$query_scores = sprintf("SELECT eid,scorePlace,scoreTable FROM %s WHERE eid='%s'", $judging_scores_db_table, $id);
$scores = mysql_query($query_scores, $brewing) or die(mysql_error());
$row_scores = mysql_fetch_assoc($scores);
if ($row_scores['scorePlace'] >= "1") {
if ($method == "0") {
// Display by Table
$query_table = sprintf("SELECT tableName FROM {$judging_tables_db_table} WHERE id='%s'", $row_scores['scoreTable']);
$table = mysql_query($query_table, $brewing) or die(mysql_error());
$row_table = mysql_fetch_assoc($table);
$r = display_place($row_scores['scorePlace'], 1) . ": " . $row_table['tableName'];
}
if ($method == "1") {
// Display by Category
$query_entry = sprintf("SELECT brewCategorySort FROM {$brewing_db_table} WHERE id='%s'", $row_scores['eid']);
$entry = mysql_query($query_entry, $brewing) or die(mysql_error());
$row_entry = mysql_fetch_assoc($entry);
$r = display_place($row_scores['scorePlace'], 1) . ": " . style_convert($row_entry['brewCategorySort'], 1);
}
if ($method == "2") {
// Display by Category
$query_entry = sprintf("SELECT brewCategorySort,brewCategory,brewSubCategory FROM {$brewing_db_table} WHERE id='%s'", $row_scores['eid']);
$entry = mysql_query($query_entry, $brewing) or die(mysql_error());
$row_entry = mysql_fetch_assoc($entry);
$query_style = sprintf("SELECT brewStyle FROM %s WHERE (brewStyleVersion='%s' OR brewStyleOwn='custom') AND brewStyleGroup='%s' AND brewStyleNum='%s'", $prefix . "styles", $_SESSION['prefsStyleSet'], $row_entry['brewCategorySort'], $row_entry['brewSubCategory']);
$style = mysql_query($query_style, $brewing) or die(mysql_error());
$row_style = mysql_fetch_assoc($style);
$r = display_place($row_scores['scorePlace'], 1) . ": " . $row_style['brewStyle'] . " (" . $row_entry['brewCategory'] . $row_entry['brewSubCategory'] . ")";
}
} else {
$r = "";
}
}
//$r = "<td class=\"dataList\">".$query_scores."<br>".$query_table."</td>";
return $r;
}
foreach (array_unique($b) as $style) {
$style = explode("-", $style);
$query_score_count = sprintf("SELECT COUNT(*) as 'count' FROM %s a, %s b, %s c WHERE b.brewCategorySort='%s' AND b.brewSubCategory='%s' AND a.eid = b.id AND a.scorePlace IS NOT NULL AND c.uid = b.brewBrewerID", $judging_scores_db_table, $brewing_db_table, $brewer_db_table, $style[0], $style[1]);
$score_count = mysql_query($query_score_count, $brewing) or die(mysql_error());
$row_score_count = mysql_fetch_assoc($score_count);
//echo $row_score_count['count'];
//echo $query_score_count;
if ($row_score_count['count'] > 0) {
$query_scores = sprintf("SELECT a.scoreTable, a.scorePlace, a.scoreEntry, b.brewName, b.brewCategory, b.brewCategorySort, b.brewSubCategory, b.brewStyle, b.brewCoBrewer, c.brewerLastName, c.brewerFirstName, c.brewerClubs, c.brewerAddress, c.brewerState, c.brewerCity, c.brewerZip, c.brewerPhone1, c.brewerCountry FROM %s a, %s b, %s c WHERE b.brewCategorySort='%s' AND b.brewSubCategory='%s' AND a.eid = b.id AND c.uid = b.brewBrewerID", $judging_scores_db_table, $brewing_db_table, $brewer_db_table, $style[0], $style[1]);
$query_scores .= " AND a.scorePlace IS NOT NULL";
$query_scores .= " ORDER BY b.brewCategory,b.brewSubCategory,a.scorePlace";
//echo $query_scores;
$scores = mysql_query($query_scores, $brewing) or die(mysql_error());
$row_scores = mysql_fetch_assoc($scores);
$totalRows_scores = mysql_num_rows($scores);
do {
$style = $row_scores['brewCategory'] . $row_scores['brewSubCategory'];
if ($row_scores['brewCategorySort'] > 28) {
$style_long = style_convert($row_scores['brewCategorySort'], 1);
} else {
$style_long = $row_scores['brewStyle'];
}
$query_table_name = sprintf("SELECT tableName,tableNumber from %s WHERE id = '%s'", $judging_tables_db_table, $row_scores['scoreTable']);
$table_name = mysql_query($query_table_name, $brewing) or die(mysql_error());
$row_table_name = mysql_fetch_assoc($table_name);
$a[] = array($row_table_name['tableNumber'], strtr($row_table_name['tableName'], $html_remove), $row_scores['brewCategory'], $row_scores['brewSubCategory'], $style_long, $row_scores['scorePlace'], strtr($row_scores['brewerLastName'], $html_remove), strtr($row_scores['brewerFirstName'], $html_remove), $row_scores['brewerEmail'], $row_scores['brewerAddress'], $row_scores['brewerCity'], $row_brewer['brewerState'], $row_scores['brewerZip'], $row_scores['brewerCountry'], $row_scores['brewerPhone1'], strtr($row_scores['brewName'], $html_remove), $row_scores['brewerClubs'], $row_scores['brewCoBrewer']);
} while ($row_scores = mysql_fetch_assoc($scores));
}
}
}
// end if ($_SESSION['prefsWinnerMethod'] == 2)
echo $base_url;
?>
js_includes/jquery.dataTables.js"></script>
</head>
<body>
<div id="content">
<div id="content-inner">
<?php
foreach (array_unique($s) as $style) {
include DB . 'output_sorting.db.php';
if ($totalRows_entries > 0) {
?>
<div id="header">
<div id="header-inner">
<h1><?php
echo "Category " . ltrim($style, "0") . ": " . style_convert($style, 1);
?>
</h1>
<h3><?php
echo $totalRows_entries . " Entries";
?>
</h3>
</div>
</div>
<?php
if ($go == "default") {
?>
<script type="text/javascript" language="javascript">
$(document).ready(function() {
$('#sortable<?php
echo $style;
$accepted_categories[] = $row_styles['brewStyleGroup'];
} while ($row_styles = mysql_fetch_assoc($styles));
$total_cat = array_unique($accepted_categories);
//print_r($total_cat);
$html = "";
$style_other_count[] = 0;
$style_beer_count[] = 0;
$style_mead_count[] = 0;
$style_cider_count[] = 0;
$style_beer_count_logged[] = 0;
$style_mead_count_logged[] = 0;
$style_cider_count_logged[] = 0;
$style_other_count_logged[] = 0;
foreach ($total_cat as $cat) {
$cat_convert = $cat;
$cat_name = style_convert($cat_convert, 1);
// Perform query in appropriate db table rows
$query_style_count = sprintf("SELECT COUNT(*) AS 'count' FROM %s WHERE brewCategorySort='%s' AND brewPaid='1' AND brewReceived='1'", $prefix . "brewing", $cat);
$style_count = mysql_query($query_style_count, $brewing) or die(mysql_error());
$row_style_count = mysql_fetch_assoc($style_count);
$query_style_count_logged = sprintf("SELECT COUNT(*) AS 'count' FROM %s WHERE brewCategorySort='%s'", $prefix . "brewing", $cat);
$style_count_logged = mysql_query($query_style_count_logged, $brewing) or die(mysql_error());
$row_style_count_logged = mysql_fetch_assoc($style_count_logged);
if ($cat > $category_end) {
$query_style_type = sprintf("SELECT brewStyleType FROM %s WHERE brewStyleGroup='%s'", $styles_db_table, $cat);
$style_type = mysql_query($query_style_type, $brewing) or die(mysql_error());
$row_style_type = mysql_fetch_assoc($style_type);
}
if ($cat <= $beer_end) {
$count_beer = TRUE;
$count_mead = FALSE;
}
$eid = $row_entries['id'];
// $bid is the brewBrewerID/uid
$bid = $row_entries['brewBrewerID'];
if (NHC && $prefix == "final_") {
$entry_number = sprintf("%06s", $row_entries['id']);
} else {
$entry_number = sprintf("%04s", $row_entries['id']);
}
if (NHC || $_SESSION['prefsEntryForm'] == "N") {
$judging_number = sprintf("%06s", $row_entries['brewJudgingNumber']);
} else {
$judging_number = readable_judging_number($table_score_data[1], $row_entries['brewJudgingNumber']);
}
$judging_number = sprintf("%06s", $row_entries['brewJudgingNumber']);
$style_display = $style . " " . style_convert($row_entries['brewCategorySort'], 1) . ": " . $score_style_data[2];
?>
<tr>
<input type="hidden" name="score_id[]" value="<?php
echo $score_id;
?>
" />
<?php
if ($action == "edit") {
?>
<input type="hidden" name="scorePrevious<?php
echo $score_id;
?>
" value="<?php
echo $score_previous;
?>
function style_choose($section, $go, $action, $filter, $view, $script_name, $method)
{
require CONFIG . 'config.php';
mysql_select_db($database, $brewing);
if ($_SESSION['prefsStyleSet'] == "BJCP2008") {
$end = 28;
}
if ($_SESSION['prefsStyleSet'] == "BJCP2015") {
$end = 34;
}
if ($method == "thickbox") {
$suffix = '';
$class = 'class="menuItem" id="modal_window_link"';
}
if ($method == "none") {
$suffix = '';
$class = 'class="menuItem"';
}
$random = random_generator(7, 2);
$style_choose = '<div class="menuBar"><a class="menuButton" href="#" onclick="#" onmouseover="buttonMouseover(event, \'menu_categories' . $random . '\');">Select Below...</a></div>';
$style_choose .= '<div id="menu_categories' . $random . '" class="menu" onmouseover="menuMouseover(event)">';
for ($i = 1; $i < 29; $i++) {
if ($i <= 9) {
$num = "0" . $i;
} else {
$num = $i;
}
$query_entry_count = sprintf("SELECT COUNT(*) as 'count' FROM %s WHERE brewCategory='%s'", $prefix . "brewing", $i);
$result = mysql_query($query_entry_count, $brewing) or die(mysql_error());
$row = mysql_fetch_array($result);
//if ($num == $filter) $selected = ' "selected"'; else $selected = '';
if ($row['count'] > 0) {
$style_choose .= '<a ' . $class . ' style="font-size: 0.9em; padding: 1px;" href="' . $script_name . '?section=' . $section . '&go=' . $go . '&action=' . $action . '&filter=' . $num . $suffix . '&view=' . $view . '" title="Print ' . style_convert($i, "1") . '">' . $num . ' ' . style_convert($i, "1") . ' (' . $row['count'] . ' entries)</a>';
}
}
$query_styles = sprintf("SELECT brewStyle,brewStyleGroup FROM %s WHERE brewStyleGroup > %s", $prefix . "styles", $end);
$styles = mysql_query($query_styles, $brewing) or die(mysql_error());
$row_styles = mysql_fetch_assoc($styles);
$totalRows_styles = mysql_num_rows($styles);
do {
$query_entry_count = sprintf("SELECT COUNT(*) as 'count' FROM %s WHERE brewCategorySort='%s'", $prefix . "brewing", $row_styles['brewStyleGroup']);
$result = mysql_query($query_entry_count, $brewing) or die(mysql_error());
$row = mysql_fetch_array($result);
//if ($row_styles['brewStyleGroup'] == $filter) $selected = ' "selected"'; else $selected = '';
if ($row['count'] > 0) {
$style_choose .= '<a ' . $class . ' style="font-size: 0.9em; padding: 1px;" href="' . $script_name . '?section=' . $section . '&go=' . $go . '&action=' . $action . '&filter=' . $row_styles['brewStyleGroup'] . $suffix . '" title="Print ' . $row_styles['brewStyle'] . '">' . $row_styles['brewStyleGroup'] . ' ' . $row_styles['brewStyle'] . ' (' . $row['count'] . ' entries)</a>';
}
} while ($row_styles = mysql_fetch_assoc($styles));
$style_choose .= '</div>';
return $style_choose;
}
if ($action == "add") {
echo $row_entries['id'];
}
if ($action == "edit" && $flight_number[0] != "") {
echo $flight_number[0];
} else {
echo $random;
}
?>
" value="<?php
echo $row_entries['id'];
?>
" />
</td>
<td><?php
echo $row_entries['brewCategorySort'] . $row_entries['brewSubCategory'] . " " . style_convert($row_entries['brewCategorySort'], 1) . ": " . $row_entries['brewStyle'];
?>
</td>
<?php
for ($i = 1; $i < $flight_count + 1; $i++) {
?>
<td><input type="radio" name="flightNumber<?php
if ($action == "add") {
echo $row_entries['id'];
}
if ($action == "edit" && $flight_number[0] != "") {
echo $flight_number[0];
} else {
echo $random;
}
?>
$table_body1 .= "</div>";
$table_body1 .= "<div class=\"row bcoem-account-info\">";
$table_body1 .= "<div class=\"col-lg-3 col-md-3 col-sm-4 col-xs-4\"><strong>Preferred</strong></div>";
$table_body1 .= "<div class=\"col-lg-9 col-md-9 col-sm-8 col-xs-8\">";
if ($_SESSION['brewerJudgeLikes'] != "") {
$table_body1 .= style_convert($_SESSION['brewerJudgeLikes'], 4, $base_url);
} else {
$table_body1 .= "N/A";
}
$table_body1 .= "</div>";
$table_body1 .= "</div>";
$table_body1 .= "<div class=\"row bcoem-account-info\">";
$table_body1 .= "<div class=\"col-lg-3 col-md-3 col-sm-4 col-xs-4\"><strong>Non-Preferred</strong></div>";
$table_body1 .= "<div class=\"col-lg-9 col-md-9 col-sm-8 col-xs-8\">";
if ($_SESSION['brewerJudgeDislikes'] != "") {
$table_body1 .= style_convert($_SESSION['brewerJudgeDislikes'], 4, $base_url);
} else {
$table_body1 .= "N/A";
}
$table_body1 .= "</div>";
$table_body1 .= "</div>";
if (!empty($judge_info)) {
$table_body1 .= "<div class=\"row bcoem-account-info\">";
$table_body1 .= "<div class=\"col-lg-3 col-md-3 col-sm-4 col-xs-4\"><strong>Availability</strong></div>";
$table_body1 .= "<div class=\"col-lg-9 col-md-9 col-sm-8 col-xs-8\">";
if ($assignment == "judge" || empty($assignment)) {
if (empty($table_assign_judge)) {
$table_body1 .= "<table id=\"sortable_judge\" class=\"table table-condensed table-striped table-bordered table-responsive\">";
$table_body1 .= "<thead>";
$table_body1 .= "<tr>";
$table_body1 .= "<th width=\"10%\">Yes/No</th>";
} while ($row_styles = mysql_fetch_assoc($styles));
foreach (array_unique($style) as $style) {
$query_entry_count = sprintf("SELECT COUNT(*) as 'count' FROM %s WHERE brewCategorySort='%s' AND brewReceived='1'", $brewing_db_table, $style);
$entry_count = mysql_query($query_entry_count, $brewing) or die(mysql_error());
$row_entry_count = mysql_fetch_assoc($entry_count);
$query_score_count = sprintf("SELECT COUNT(*) as 'count' FROM %s a, %s b, %s c WHERE b.brewCategorySort='%s' AND a.eid = b.id AND c.uid = b.brewBrewerID AND (a.scorePlace IS NOT NULL OR a.scorePlace='')", $judging_scores_db_table, $brewing_db_table, $brewer_db_table, $style);
$score_count = mysql_query($query_score_count, $brewing) or die(mysql_error());
$row_score_count = mysql_fetch_assoc($score_count);
if ($row_entry_count['count'] > 0 && $row_score_count['count'] > 0) {
$query_scores = sprintf("SELECT a.scorePlace, a.scoreEntry, b.brewName, b.brewCategory, b.brewCategorySort, b.brewSubCategory, b.brewStyle, b.brewCoBrewer, c.brewerLastName, c.brewerFirstName, c.brewerClubs FROM %s a, %s b, %s c WHERE b.brewCategorySort='%s' AND a.eid = b.id AND c.uid = b.brewBrewerID AND (a.scorePlace IS NOT NULL OR a.scorePlace='') ORDER BY a.scorePlace", $judging_scores_db_table, $brewing_db_table, $brewer_db_table, $style);
$scores = mysql_query($query_scores, $brewing) or die(mysql_error());
$row_scores = mysql_fetch_assoc($scores);
$totalRows_scores = mysql_num_rows($scores);
do {
$style = $row_scores['brewCategory'] . $row_scores['brewSubCategory'];
$text = sprintf("\n%s%s\n%s\n%s", display_place($row_scores['scorePlace'], 1) . " - ", style_convert($row_scores['brewCategorySort'], 1), strtr($row_scores['brewerFirstName'], $html_remove) . " " . strtr($row_scores['brewerLastName'], $html_remove), strtr($row_scores['brewName'], $html_remove));
$text = iconv('UTF-8', 'windows-1252', $text);
$pdf->Add_Label($text);
} while ($row_scores = mysql_fetch_assoc($scores));
}
}
} elseif ($_SESSION['prefsWinnerMethod'] == "2") {
// Output by sub-category
$query_styles = sprintf("SELECT brewStyleGroup,brewStyleNum,brewStyle FROM %s WHERE brewStyleActive='Y' AND (brewStyleVersion='%s' OR brewStyleOwn='custom') ORDER BY brewStyleGroup,brewStyleNum ASC", $styles_db_table, $_SESSION['prefsStyleSet']);
$styles = mysql_query($query_styles, $brewing) or die(mysql_error());
$row_styles = mysql_fetch_assoc($styles);
$totalRows_styles = mysql_num_rows($styles);
do {
$style[] = $row_styles['brewStyleGroup'] . "-" . $row_styles['brewStyleNum'] . "-" . $row_styles['brewStyle'];
} while ($row_styles = mysql_fetch_assoc($styles));
foreach (array_unique($style) as $style) {
$style_special = $row_entries_1['brewCategorySort'] . "^" . $row_entries_1['brewSubCategory'] . "^" . $_SESSION['prefsStyleSet'];
$special = style_convert($style_special, "9");
//echo $special."<br>";
$special = explode("^", $special);
$special = $special[4];
$strength = $special[5];
$carb = $special[6];
$sweet = $special[7];
echo $style . " " . $row_entries_1['brewStyle'] . "<em><br>" . style_convert($row_entries_1['brewCategorySort'], 1) . "</em>";
if ($row_entries_1['brewInfo'] != "" && $special == "1") {
echo "<p><strong>Special Ingredients/Classic Style: </strong>" . $row_entries_1['brewInfo'] . "</p>";
}
if ($row_entries_1['brewComments'] != "") {
echo "<p><strong>Specifics: </strong>" . $row_entries_1['brewComments'] . "</p>";
}
if (style_convert($style, "5")) {
echo "<p>";
}
if ($row_entries_1['brewMead1'] != '' && $strengh == "1") {
echo $row_entries_1['brewMead1'] . " ";
}
if ($row_entries_1['brewMead2'] != '' && $carb == "1") {
echo $row_entries_1['brewMead2'] . " ";
}
if ($row_entries_1['brewMead3'] != '' && $sweet == "1") {
echo $row_entries_1['brewMead3'] . "</p>";
}
?>
</td>
<td nowrap="nowrap" class="data bdr1B_gray"><?php
echo $row_entries['brewBoxNum'];
$brewing_info['meadType'] = 'Hydromel';
break;
case "Standard":
$brewing_info['meadType'] = 'Standard';
break;
case "Sack":
$brewing_info['meadType'] = 'Sack';
break;
default:
$brewing_info['meadType'] = '';
break;
}
// Style name
if ($brewing_info['brewCategory'] < $category_end) {
$brewing_info['styleName'] = $brewing_info['brewStyle'];
$brewing_info['styleCat'] = style_convert($brewing_info['brewCategory'], 1);
} else {
$brewing_info['styleName'] = $brewing_info['brewStyle'];
}
// Some metric/US conversions
$brewing_info['brewSize']['us'] = $brewing_info['brewYield'];
$brewing_info['brewSize']['metric'] = round($brewing_info['brewYield'] * 3.78541, 2);
$brewing_info['styleCat'] = "";
if ($_SESSION['prefsEntryForm'] == "N") {
if (strstr($prefix, "region")) {
// Only for NHC - comment out in general release
include MODS . 'nhc_region.php';
$region_city = nhc_region($prefix, 1);
$region = nhc_region($prefix, 3);
}
}
$page_info16 .= ".";
$page_info16 .= "</p>";
}
if (!empty($row_limits['prefsUSCLExLimit'])) {
$excepted_styles = explode(",", $row_limits['prefsUSCLEx']);
if (count($excepted_styles) == 1) {
$sub = "sub-category";
} else {
$sub = "sub-categories";
}
if ($row_limits['prefsUSCLExLimit'] == 1) {
$page_info16 .= sprintf("<p>Each entrant is limited to %s for the following %s: </p>", readable_number($row_limits['prefsUSCLExLimit']) . " (" . $row_limits['prefsUSCLExLimit'] . ")", $sub);
} else {
$page_info16 .= sprintf("<p>Each entrant is limited to %s entries for for the following %s: </p>", readable_number($row_limits['prefsUSCLExLimit']) . " (" . $row_limits['prefsUSCLExLimit'] . ")", $sub);
}
$page_info16 .= style_convert($row_limits['prefsUSCLEx'], "7");
}
}
// Payment
$header1_6 .= "<a name='payment'></a><h2>Payment</h2>";
$page_info6 .= "<p>After registering your personal information and adding your entries to the system, you must pay your entry fee(s). Accepted payment methods are:</p>";
$page_info6 .= "<ul>";
if ($_SESSION['prefsCash'] == "Y") {
$page_info6 .= "<li>Cash</li>";
}
if ($_SESSION['prefsCheck'] == "Y") {
$page_info6 .= sprintf("<li>Check, made out to <em>%s</em></li>", $_SESSION['prefsCheckPayee']);
}
if ($_SESSION['prefsPaypal'] == "Y") {
$page_info6 .= "<li>Credit/debit card and e-check, via PayPal</li>";
}
//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) {
fputcsv($fp, $fields, $separator);
}
fclose($fp);
} else {
echo "<p>Not Available</p>";
}
echo $bos_entry_info[14];
?>
" />
<?php
}
?>
<td><?php
echo sprintf("%04s", $row_enter_bos['eid']);
?>
</td>
<td><?php
echo $judging_number;
?>
</td>
<td><?php
echo $style . " " . style_convert($bos_entry_info[1], 1) . ": " . $bos_entry_info[0];
?>
</td>
<td><input class="form-control" type="text" name="scoreEntry<?php
echo $score_id;
?>
" size="5" maxlength="2" value="<?php
echo $bos_entry_info[11];
?>
" /></td>
<td>
<select class="form-control nodupe" name="scorePlace<?php
echo $score_id;
?>
">
<option value=""></option>
// end if ($action == "edit")
?>
<?php
if ($action == "default" && $filter == "orphans") {
?>
<h3>Style Categories with Entries Not Assigned to Tables</h3>
<?php
if ($totalRows_tables > 0) {
do {
if (get_table_info($row_styles['brewStyleNum'] . "^" . $row_styles['brewStyleGroup'], "count", "", $dbTable, "default")) {
$a[] = 0;
if (!get_table_info($row_styles['id'], "styles", $id, $dbTable, "default")) {
$a[] = $row_styles['id'];
echo "<ul><li>" . $row_styles['brewStyleGroup'] . $row_styles['brewStyleNum'] . " " . style_convert($row_styles['brewStyleGroup'], "1") . ": " . $row_styles['brewStyle'] . " (" . get_table_info($row_styles['brewStyleNum'] . "^" . $row_styles['brewStyleGroup'], "count", "default", $dbTable, "default") . " entries)</li></ul>";
}
}
} while ($row_styles = mysql_fetch_assoc($styles));
$b = array_sum($a);
if ($b == 0) {
echo "<p>All style categories with entries have been assigned to tables.</p>";
}
} else {
echo "<p>No tables have been defined.";
if ($go == "judging_tables") {
echo " <a href='index.php?section=admin&go=judging_tables&action=add'>Add a table?</a></p>";
}
}
// end else
}
<th class="dataHeading bdr1B">Loc / Box</th>
<?php
if ($action != "print" && $dbTable == "default") {
?>
<th class="dataHeading bdr1B">Actions</th>
<?php
}
?>
</tr>
</thead>
<tbody>
<?php
do {
$brewer_info = brewer_info($row_log['brewBrewerID']);
$brewer_info = explode("^", $brewer_info);
$styleConvert = style_convert($row_log['brewCategorySort'], 1);
$entry_style = $row_log['brewCategorySort'] . "-" . $row_log['brewSubCategory'];
?>
<tr<?php
if ($row_log['brewConfirmed'] == "0" && $action != "print") {
echo " style='background-color: #ff9; border-top: 1px solid #F90; border-bottom: 1px solid #F90;'";
} elseif (check_special_ingredients($entry_style) && $row_log['brewInfo'] == "") {
echo " style='background-color: #ff9; border-top: 1px solid #F90; border-bottom: 1px solid #F90;'";
}
?>
>
<input type="hidden" name="id[]" value="<?php
echo $row_log['id'];
?>
" />
<td class="dataList ">
} else {
echo $row_styles['brewStyleGroup'];
}
echo $row_styles['brewStyleNum'];
?>
"></a>
<h2><?php
echo $row_styles['brewStyle'];
?>
</h2>
<table>
<tr>
<td class="dataLabel">Category:</td>
<td class="data"><?php
echo style_convert($row_styles['brewStyleGroup'], 1);
?>
</td>
</tr>
</tr>
<td class="dataLabel">Number:</td>
<td class="data"><?php
echo $row_styles['brewStyleGroup'];
echo $row_styles['brewStyleNum'];
?>
</td>
</tr>
</table>
<table>
<tr>
<td class="data-left"><p style="padding-bottom: 15px;"><?php
include DB . 'output_bos_mat.db.php';
//$output .= $query_scores;
$endRow = 0;
$columns = 3;
// number of columns
$hloopRow1 = 0;
// first row flag
$output .= '<table class="BOS-mat">';
do {
if ($row_scores['brewJudgingNumber'] > 0) {
$style = $row_scores['brewCategory'] . $row_scores['brewSubCategory'];
if ($endRow == 0 && $hloopRow1++ != 0) {
$output .= "<tr>";
}
$output .= '<td>';
$output .= '<h3>' . $row_scores['brewCategory'] . ': ' . style_convert($row_scores['brewCategorySort'], 1) . '</h3>';
$output .= '<p class="lead">' . $style . ': ' . $row_scores['brewStyle'] . '</p>';
if ($filter == "entry") {
$output .= '<p>#' . $row_scores['id'] . '</p>';
} else {
$output .= '<p>#' . readable_judging_number($row_scores['brewCategorySort'], $row_scores['brewJudgingNumber']) . '</p>';
}
$output .= '<p><small><em>' . $row_scores['brewInfo'] . '</em></small></p>';
$output .= '<p><small><em>' . $row_scores['brewComments'] . '</em></small></p>';
if ($type == 2) {
$output .= '<p>' . $row_scores['brewMead1'] . ', ' . $row_scores['brewMead2'] . '</p>';
}
if ($type == 3) {
$output .= '<p>' . $row_scores['brewMead1'] . ', ' . $row_scores['brewMead2'] . ', ' . $row_scores['brewMead3'] . '</p>';
}
$output .= '</td>';
if ($row_entry_count['count'] > 1) {
$entries = "entries";
} else {
$entries = "entry";
}
if ($row_score_count['count'] > "0") {
$primary_page_info = "";
$header1_1 = "";
$page_info1 = "";
$header1_2 = "";
$page_info2 = "";
$table_head1 = "";
$table_body1 = "";
// Build headers
$header1_1 .= "<h3>";
$header1_1 .= "Category " . ltrim($style, "0") . ": " . style_convert($style, "1") . " (" . $row_entry_count['count'] . " " . $entries . ")";
$header1_1 .= "</h3>";
// Build table headers
$table_head1 .= "<tr>";
$table_head1 .= "<th class='dataList bdr1B' width='1%' nowrap='nowrap'>Place</th>";
$table_head1 .= "<th class='dataList bdr1B' width='25%'>Brewer(s)</th>";
$table_head1 .= "<th class='dataList bdr1B' width='25%'>Entry Name</th>";
$table_head1 .= "<th class='dataList bdr1B' width='25%'>Style</th>";
$table_head1 .= "<th class='dataList bdr1B'>Club</th>";
if ($filter == "scores") {
$table_head1 .= "<th class='dataList bdr1B' width='1%' nowrap='nowrap'>Score</th>";
}
$table_head1 .= "</tr>";
// Build table body
include DB . 'scores.db.php';
do {
do {
$brewerFirstName = strtr($row_sql['brewerFirstName'], $html_remove);
$brewerLastName = strtr($row_sql['brewerLastName'], $html_remove);
if ($filter == "default") {
$brewerAddress = strtr($row_sql['brewerAddress'], $html_remove);
$brewerCity = strtr($row_sql['brewerCity'], $html_remove);
if ($row_sql['brewerCountry'] == "United States") {
$phone = format_phone_us($row_sql['brewerPhone1']);
} else {
$phone = $row_sql['brewerPhone1'];
}
}
$judge_avail = judge_steward_availability($row_sql['brewerJudgeLocation'], 2);
$steward_avail = judge_steward_availability($row_sql['brewerStewardLocation'], 2);
if ($filter == "judges" || $filter == "avail_judges") {
$a[] = array($brewerFirstName, $brewerLastName, $row_sql['brewerEmail'], str_replace(",", ", ", $row_sql['brewerJudgeRank']), strtoupper(strtr($row_sql['brewerJudgeID'], $bjcp_num_replace)), $judge_avail, style_convert($row_sql['brewerJudgeLikes'], '6'), style_convert($row_sql['brewerJudgeDislikes'], '6'), judge_entries($row_sql['uid'], 0));
} elseif ($filter == "stewards" || $filter == "avail_stewards") {
$a[] = array($brewerFirstName, $brewerLastName, $row_sql['brewerEmail'], $steward_avail, judge_entries($row_sql['uid'], 0));
} elseif ($filter == "staff") {
$a[] = array($brewerFirstName, $brewerLastName, $row_sql['brewerEmail'], judge_entries($row_sql['uid'], 0));
} else {
$a[] = array($brewerFirstName, $brewerLastName, $row_sql['brewerEmail'], $brewerAddress, $brewerCity, $row_sql['brewerState'], $row_sql['brewerZip'], $row_sql['brewerCountry'], $phone, $row_sql['brewerClubs'], judge_entries($row_sql['uid'], 0));
}
} while ($row_sql = mysql_fetch_assoc($sql));
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) {
fputcsv($fp, $fields, $separator);
