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