query("SELECT * FROM 2013_offers2 WHERE fid = '$dfid'"); if ($row = $db->fetch_array($offerquery)) { $programme = $row['programme']; $inst = $row['inst']; $exam="hkdse"; $details ="true"; } } $errors = array(); $isProgrammeExist = false; if ($inst != '' && $programme != '' && $exam == 'hkdse' && preg_match('/^[0-9]+$/', $dfid) && $details == 'true') { $query = $db->query("SELECT fid FROM 2013_offers2 WHERE fid = '$dfid'"); if (!$db->num_rows($query)) { exit('Record not found
'); } $banding_array = array('A1', 'A2', 'A3', 'B4', 'B5', 'B6', 'C7', 'C8', 'C9', 'C10', 'D11', 'D12', 'D13', 'D14', 'E15', 'E16', 'E17', 'E18', 'E19', 'E20'); $grade_array = array('7' => '5**', '6' => '5*', '5' => '5', '4' => '4', '3' => '3', '2' => '2', '1' => '1', '0' => 'U'); $fid = $_exam = ''; $query = $db->query("SELECT o.*, a.result_slip, a.jupas_banding, a.main_round_result, a.showpublic FROM 2013_offers2 o LEFT JOIN 2013_attachments a ON o.fid = a.fid WHERE o.fid = '$dfid'"); $record = $db->fetch_array($query); $__fid = $record['fid']; $record['timestamp'] = date('d/m/Y, H:i a', $record['timestamp']); $record['inst'] = $university[$record['inst']]; $record['programme'] = 'JS' . $record['programme'] . ' / ' . $programmes[$record['programme']]; $record['banding'] = $banding_array[$record['banding']-1]; $record['remarks'] = nl2br(stripslashes($record['remarks'])); $totalPhotos = 0; $photos = array(); $record['result_slip'] != '' && ($photos['result_slip'] = $record['result_slip']); $record['jupas_banding'] != '' && ($photos['jupas_banding'] = $record['jupas_banding']); $record['main_round_result'] != '' && ($photos['main_round_result'] = $record['main_round_result']); $query = $db->query("SELECT g.grade, s.sn, s.fn FROM 2013_grades_dse g, 2013_subj s WHERE g.fid = '$__fid' AND g.subj = s.sn AND s.exam = 'hkdse' ORDER BY g.subj, g.grade ASC"); $emailSql = $db->query("SELECT email FROM 2013_personal_info WHERE fid = '$__fid' AND show_email = 1"); if ($row = $db->fetch_array($emailSql)) { $email = $row['email']; } $grade = array(); while ($fetch = $db->fetch_array($query)) { $grade[] = $fetch; } $ue_array = $clc_array = array(); for ($i = 0; $i < count($grade); $i++) { if ($grade[$i]['sn'] == 'elang') { $elang_array = $grade[$i]; array_splice($grade, $i, 1); break; } } for ($i = 0; $i < count($grade); $i++) { if ($grade[$i]['sn'] == 'clang') { $clang_array = $grade[$i]; array_splice($grade, $i, 1); break; } } for ($i = 0; $i < count($grade); $i++) { if ($grade[$i]['sn'] == 'math') { $math_array = $grade[$i]; array_splice($grade, $i, 1); break; } } for ($i = 0; $i < count($grade); $i++) { if ($grade[$i]['sn'] == 'ls') { $ls_array = $grade[$i]; array_splice($grade, $i, 1); break; } } $elang_array['grade'] = $grade_array[$elang_array['grade']]; $clang_array['grade'] = $grade_array[$clang_array['grade']]; $math_array['grade'] = $grade_array[$math_array['grade']]; $ls_array['grade'] = $grade_array[$ls_array['grade']]; $out = ''; for ($i = 0; $i < count($grade); $i++) { $grade[$i]['grade'] = $grade_array[$grade[$i]['grade']]; $out .= <<