$score = 3; } else { if ($trk["sessions"] >= 4 && $hrs >= 2) { $score = 2; } else { if ($trk["sessions"] >= 2 && $hrs >= 1) { $score = 1; } else { $score = 0; } } } } $stud_part = $score; $sql = "select w1nlc_math, w2nlc_math, w3nlc_math, w1nlc_uw, w2nlc_uw, w3nlc_uw from progress where user_id={$id} limit 1"; $prg = rec_as_array(dbExec($sql)); $n = 0; $n += strlen($prg["w1nlc_math"]); $n += strlen($prg["w2nlc_math"]); $n += strlen($prg["w3nlc_math"]); $prob_solve = round($n / 12 * 100); if ($prob_solve >= 80) { $prob_solve_grade = 4; } else { if ($prob_solve >= 60) { $prob_solve_grade = 3; } else { if ($prob_solve >= 40) { $prob_solve_grade = 2; } else { if ($prob_solve >= 20) {
echo "Compiling scores ...<br>"; while (!$rsid->EOF) { $id = $rsid->fields("id"); $fname = $rsid->fields("first_name"); $lname = $rsid->fields("last_name"); echo $zz + $offset . " - {$fname} {$lname} ({$id}) "; // get user's progress rec $sql = "select * from progress where user_id={$id}"; $rs = dbExec($sql); if ($rs->RecordCount() < 1) { fail("no progress rec for user {$id}"); } if ($rs->RecordCount() > 1) { fail("too many progress recs for user {$id}"); } $progress = rec_as_array($rs); // turn it into associative array // add up score for each category and put into $rslts $rslts = array(); foreach ($mc as $col) { if ($col == "user_id") { continue; } $chrs = $progress[$col]; $n = strlen($chrs); for ($i = 0; $i < $n; $i++) { $c = substr($chrs, $i, 1); $dec = "{$col}{$c}"; $sr = $scores[$dec]; if (count($sr) < 1) { if (substr($dec, 2, 4) != "nlc_") {
function progress_rec($id) { $sql = "select * from progress where user_id={$id} limit 1"; return rec_as_array(dbExec($sql)); }