if ($count_cider) {
$style_type = "Cider";
$style_beer_count[] .= 0;
$style_beer_count_logged[] .= 0;
$style_mead_count[] .= 0;
$style_mead_count_logged[] .= 0;
$style_cider_count[] .= $row_style_count['count'];
$style_cider_count_logged[] .= $row_style_count_logged['count'];
}
if ($other_count) {
if ($row_style_type['brewStyleType'] <= 3) {
$source = "bcoe";
} else {
$source = "custom";
}
$style_type = style_type($row_style_type['brewStyleType'], "2", $source);
if ($style_type == "Beer") {
$style_beer_count[] .= $row_style_count['count'];
$style_beer_count_logged[] .= $row_style_count_logged['count'];
} elseif ($style_type == "Mead") {
$style_mead_count[] .= $row_style_count['count'];
$style_mead_count_logged[] .= $row_style_count_logged['count'];
} elseif ($style_type == "Cider") {
$style_cider_count[] .= $row_style_count['count'];
$style_cider_count_logged[] .= $row_style_count_logged['count'];
} else {
$style_other_count[] .= $row_style_count['count'];
$style_other_count_logged[] .= $row_style_count_logged['count'];
}
//$style_type_array[] = $style_type;
}
echo "Update Accepted Style Categories";
}
?>
" /></p>
<input type="hidden" name="relocate" value="<?php
echo relocate($_SERVER['HTTP_REFERER'], "default", $msg, $id);
?>
">
</form>
<?php
}
?>
<?php
if ($action == "add" || $action == "edit") {
$style_type_2 = style_type($row_styles['brewStyleType'], "1", "bcoe");
?>
<script type='text/javascript'>//<![CDATA[
$(document).ready(function(){
$("#mead-cider").hide("fast");
$("#mead").hide("fast");
<?php
if ($action == "edit" && $view == "2") {
?>
$("#mead-cider").show("slow");
$("#mead").hide("slow");
<?php
<?php
$query_scores = sprintf("SELECT scoreEntry,scorePlace,scoreType FROM {$judging_scores_db_table} WHERE eid='%s'", $row_sql['id']);
$scores = mysql_query($query_scores, $brewing) or die(mysql_error());
$row_scores = mysql_fetch_assoc($scores);
$query_flight = sprintf("SELECT * FROM {$judging_flights_db_table} WHERE flightEntryID='%s'", $row_sql['id']);
$flight = mysql_query($query_flight, $brewing) or die(mysql_error());
$row_flight = mysql_fetch_assoc($flight);
$query_bos = sprintf("SELECT scorePlace FROM {$judging_scores_bos_db_table} WHERE eid='%s'", $row_sql['id']);
$bos = mysql_query($query_bos, $brewing) or die(mysql_error());
$row_bos = mysql_fetch_assoc($bos);
$totalRows_bos = mysql_num_rows($bos);
if ($totalRows_bos > 0) {
$bos_place = $row_bos['scorePlace'];
} else {
$bos_place = "";
}
$style_type = style_type($row_scores['scoreType'], 2, "bcoe");
$location = explode("^", get_table_info(1, "location", $row_flight['flightTable'], "default", "default"));
$table_info = explode("^", get_table_info(1, "basic", $row_flight['flightTable'], "default", "default"));
$table_name = sprintf("%02s", $table_info[0]) . ": " . $table_info[1];
function orphan_styles()
{
require CONFIG . 'config.php';
if ($_SESSION['prefsStyleSet'] == "BJCP2008") {
$end = 28;
}
if ($_SESSION['prefsStyleSet'] == "BJCP2015") {
$end = 34;
}
$query_styles = sprintf("SELECT id,brewStyle,brewStyleType 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);
$query_style_types = sprintf("SELECT id FROM %s WHERE styleTypeOwn = 'custom'", $prefix . "style_types");
$style_types = mysql_query($query_style_types, $brewing) or die(mysql_error());
$row_style_types = mysql_fetch_assoc($style_types);
$totalRows_style_types = mysql_num_rows($style_types);
do {
$a[] = style_type($row_style_types['id'], "2", "bcoe");
} while ($row_style_types = mysql_fetch_assoc($style_types));
$return = "";
if ($totalRows_styles > 0) {
do {
if (!in_array($row_styles['brewStyleType'], $a)) {
if ($row_styles['brewStyleType'] > 3) {
$return .= "<p><a href='index.php?section=admin&go=styles&action=edit&id=" . $row_styles['id'] . "'><span class='icon'><img src='" . $base_url . "images/pencil.png' alt='Edit " . $row_styles['brewStyle'] . "' title='Edit " . $row_styles['brewStyle'] . "'></span></a>" . $row_styles['brewStyle'] . "</p>";
}
}
} while ($row_styles = mysql_fetch_assoc($styles));
}
if ($return == "") {
$return .= "<p>All custom styles have a valid style type associated with them.</p>";
}
return $return;
}
<?php
$query_tables = "SELECT * FROM {$judging_tables_db_table} ORDER BY tableNumber";
$tables = mysql_query($query_tables, $brewing) or die(mysql_error());
$row_tables = mysql_fetch_assoc($tables);
$totalRows_tables = mysql_num_rows($tables);
$query_bos = "SELECT * FROM {$judging_scores_bos_db_table} ORDER BY scoreType,scorePlace ASC";
$bos = mysql_query($query_bos, $brewing) or die(mysql_error());
$row_bos = mysql_fetch_assoc($bos);
$totalRows_bos = mysql_num_rows($bos);
do {
$query_entries = sprintf("SELECT id,brewBrewerFirstName,brewBrewerLastName,brewName,brewStyle,brewCategory,brewSubCategory FROM {$brewing_db_table} WHERE id='%s'", $row_bos['eid']);
$entries = mysql_query($query_entries, $brewing) or die(mysql_error());
$row_entries = mysql_fetch_assoc($entries);
if ($row_bos['scorePlace'] != "") {
$text = sprintf("\n%s\n%s\n%s\n%s", display_place($row_bos['scorePlace'], 1) . " - BEST IN SHOW", style_type($row_bos['scoreType'], "3", "default"), strtr($row_entries['brewBrewerFirstName'], $html_remove) . " " . strtr($row_entries['brewBrewerLastName'], $html_remove), strtr($row_entries['brewName'], $html_remove) . " - " . $row_entries['brewStyle']);
$text = iconv('UTF-8', 'windows-1252', $text);
$pdf->Add_Label($text);
}
} while ($row_bos = mysql_fetch_assoc($bos));
if ($_SESSION['prefsWinnerMethod'] == "1") {
// Output by Category
$query_styles = sprintf("SELECT brewStyleGroup FROM %s WHERE brewStyleActive='Y' AND (brewStyleVersion='%s' OR brewStyleOwn='custom') ORDER BY brewStyleGroup 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'];
} 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);
" value="<?php
echo $bid;
?>
" />
<input type="hidden" name="scoreTable<?php
echo $score_id;
?>
" value="<?php
echo $id;
?>
" />
<input type="hidden" name="scoreType<?php
echo $score_id;
?>
" value="<?php
echo style_type($score_style_data[3], "1", "bcoe");
?>
" />
<td><?php
echo $entry_number;
?>
</td>
<td class="data"><?php
echo $judging_number;
?>
</td>
<td class="data"><?php
echo $style_display;
?>
</td>
<td class="data"><input type="checkbox" name="scoreMiniBOS<?php
