} $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);