$output_datatables_body .= format_phone_us($row_brewer['brewerPhone1']) . " (1)<br>"; } else { $output_datatables_body .= $row_brewer['brewerPhone1'] . " (1)<br>"; } } if ($row_brewer['brewerPhone2'] != "") { if ($us_phone) { $output_datatables_body .= format_phone_us($row_brewer['brewerPhone2']) . " (2)<br>"; } else { $output_datatables_body .= $row_brewer['brewerPhone2'] . " (2)<br>"; } } $output_datatables_body .= "</td>"; $output_datatables_body .= "<td class='dataList'>"; if ($totalRows_judging > 0 && ($filter == "judges" || $filter == "stewards")) { $output_datatables_body .= judge_steward_availability($locations, 1); } else { $output_datatables_body .= $row_brewer['brewerClubs']; } //else $output_datatables_body .= " "; $output_datatables_body .= "</td>"; if ($filter == "default") { $output_datatables_body .= "<td class='dataList'>"; if ($row_brewer['brewerSteward'] == "Y") { if ($action == "print") { $output_datatables_body .= "Y"; } else { $output_datatables_body .= "<img src='" . $base_url . "images/tick.png'>"; } } if ($row_brewer['brewerSteward'] == "N") {
$a[] = array('First Name', 'Last Name', 'Email', 'Address', 'City', 'State/Province', 'Zip', 'Country', 'Phone', 'Club', 'Entries In...'); } 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');