?> <th class="dataHeading bdr1B">Round <?php echo $i; ?> </th> <?php } } ?> </tr> </thead> <tbody> <?php do { $table_location = "Y-" . $row_tables_edit['tableLocation']; $judge_info = judge_info($row_brewer['uid']); $judge_info = explode("^", $judge_info); /* $r = $row_brewer_info['brewerFirstName']."^". $row_brewer_info['brewerLastName']."^". $row_brewer_info['brewerJudgeLikes']."^". $row_brewer_info['brewerJudgeDislikes']."^". $row_brewer_info['brewerJudgeMead']."^". $row_brewer_info['brewerJudgeRank']."^". $row_brewer_info['brewerJudgeID']."^". $row_brewer_info['brewerStewardLocation']."^". $row_brewer_info['brewerJudgeLocation']; */ $bjcp_rank = explode(",", $judge_info[5]); $display_rank = bjcp_rank($bjcp_rank[0], 1);
function not_assigned($method) { require CONFIG . 'config.php'; mysql_select_db($database, $brewing); $return = ""; $assignment = ""; if ($method == "J") { $query_brewer = sprintf("SELECT a.uid, b.uid FROM %s a, %s b WHERE b.staff_judge='1' AND a.uid=b.uid", $prefix . "brewer", $prefix . "staff"); $human_readable = "judge"; } if ($method == "S") { $query_brewer = sprintf("SELECT a.uid, b.uid FROM %s a, %s b WHERE b.staff_steward='1' AND a.uid=b.uid", $prefix . "brewer", $prefix . "staff"); $human_readable = "steward"; } $brewer = mysql_query($query_brewer, $brewing) or die(mysql_error()); $row_brewer = mysql_fetch_assoc($brewer); $totalRows_brewer = mysql_num_rows($brewer); if ($totalRows_brewer > 0) { do { $user[] .= $row_brewer['uid']; } while ($row_brewer = mysql_fetch_assoc($brewer)); foreach ($user as $bid) { if ($method == "J") { $query_assignments = sprintf("SELECT COUNT(*) as 'count' FROM %s WHERE bid='%s' AND assignment='J'", $prefix . "judging_assignments", $bid); $assignments = mysql_query($query_assignments, $brewing) or die(mysql_error()); $row_assignments = mysql_fetch_assoc($assignments); // If no assignment, get info and build output if ($row_assignments['count'] == 0) { $info = judge_info($bid); $assignment_info = explode("^", $info); $judge_rank = $assignment_info[5]; $judge_rank_explode = explode(",", $assignment_info[5]); $judge_rank_display = $judge_rank_explode[0]; if (empty($judge_rank)) { $judge_rank_display = "Novice"; } $assignment .= "<tr><td class=\"small\">" . $assignment_info[1] . ", " . $assignment_info[0] . "</td><td class=\"small\">" . $judge_rank_display . "</td></tr>"; } } if ($method == "S") { $query_assignments = sprintf("SELECT COUNT(*) as 'count' FROM %s WHERE bid='%s' AND assignment='S'", $prefix . "judging_assignments", $bid); $assignments = mysql_query($query_assignments, $brewing) or die(mysql_error()); $row_assignments = mysql_fetch_assoc($assignments); // If no assignment, get info and build output if ($row_assignments['count'] == 0) { $info = judge_info($bid); $assignment_info = explode("^", $info); $judge_rank = $assignment_info[5]; $judge_rank_explode = explode(",", $assignment_info[5]); $judge_rank_display = $judge_rank_explode[0]; if (empty($judge_rank)) { $judge_rank_display = "Novice"; } $assignment .= "<tr><td class=\"small\">" . $assignment_info[1] . ", " . $assignment_info[0] . "</td><td class=\"small\">" . $judge_rank_display . "</td></tr>"; } } } // Return the modal body text $return .= "<p>These " . $human_readable . "s have not been assigned to any table.</p>"; $return .= "<table class=\"table table-responsive table-striped table-bordered table-condensed\" id=\"sortable" . $method . "\">"; $return .= "<thead>"; $return .= "<tr>"; $return .= "<th>Name</th>"; $return .= "<th>Rank</th>"; $return .= "</tr>"; $return .= "</thead>"; $return .= "<tbody>"; $return .= $assignment; $return .= "</tbody>"; $return .= "</table>"; } else { $return = "<p>No participants have been added to the " . $human_readable . " pool yet. Therefore, there no table assignments.</p>"; } return $return; }