$page = $_GET["page"];
$cid = $_GET["cid"];
if ($_GET["mode"] == "full") {
$fullmode = true;
} else {
$fullmode = false;
}
function showTeam($team)
{
printf("team_%03d,", $team['id']);
for ($i = 0; $i < 6; $i++) {
print chr(rand(ord('a'), ord('z')));
}
print ",{$team['name']},{$team['member']}";
print "\n";
}
if (!isset($_GET["debug"])) {
header("Content-Disposition: attachment; filename=\"{$contest[name]}.csv\"");
header("Content-Type: text/csv");
}
echo "Username, Password, English Team Name, Members\n";
$result = mysql_query("SELECT * FROM temp");
$rank = 0;
for ($i = 0;; $i++, $rank++) {
$team = mysql_fetch_array($result);
if (!$team) {
break;
}
$team['id'] = $i + 1;
showTeam($team);
}
function showMember($member)
{
global $team;
$gender = $member['gender'] ? 'Female' : 'Male';
print "{$team['id']}, {$team['enname']}, {$team['cnname']}, {$member['title']}, {$member['firstname']}, {$member['lastname']}," . " {$member['cnname']}, {$gender}, {$member['email']}, {$member['phone']}, {$member['tshirt']}, {$member['institution']}," . "\"{$member['location']}\", {$member['country']}, {$member['degree']}, {$member['major']}, {$member['majorcn']}," . " {$member['grade']}, {$member['class']}, {$member['admitdate']}, {$member['graduatedate']}, {$member['birthday']}\n";
// <td align="center" nowrap="nowrap"><? echo $member["firstname"].' '.$member["lastname"].'('.$member["cnname"].')'</td>
// <td align="center"><? echo $member["gender"]?"Female":"Male"</td>
// align="center"><? echo $member["email"]</td>
// <td align="center" width="200" nowrap="nowrap"><? echo $member["major"]."<br />(".$member["majorcn"].")"</td>
// <td align="center"><? echo $member["grade"]</td>
// <td align="center"><? echo $member["class"]</td>
}
header("Content-Type: text/plain");
$result = mysql_query("SELECT * FROM team WHERE cid = {$contest['cid']} ORDER BY tid ASC");
$rank = 0;
for ($i = 0;; $i++, $rank++) {
$team = mysql_fetch_array($result);
if ($team == null) {
break;
}
$team["id"] = $rank;
$members = mysql_query("SELECT * FROM contestant WHERE tid = {$team['tid']}");
for ($j = 0; $j < 3; $j++) {
$member[$j] = mysql_fetch_array($members, MYSQL_ASSOC);
}
if ($fullmode) {
showMembers($member);
} else {
showTeam($member);
}
}
