&$project) { $q = $mysqli->query("SELECT * FROM judging_scores WHERE pid='$pid'"); if($q->num_rows == 0) { $scores[$pid] = array('scientific'=>'', 'originality'=>'', 'communication'=>'', 'total'=>0); } else { $scores[$pid] = $q->fetch_assoc(); filter_int($scores[$pid]['scientific']); filter_int($scores[$pid]['originality']); filter_int($scores[$pid]['communication']); $map = array(0=> '', 1=>'1L', 2=>'1M', 3=>'1H', 4=>'2L', 5=>'2M', 6=>'2H', 7=>'3L', 8=>'3M', 9=>'3H', 10=>'4L', 11=>'4M', 12=>'4H'); $scores[$pid]['scientific'] = $map[$scores[$pid]['scientific']]; $scores[$pid]['originality'] = $map[$scores[$pid]['originality']]; $scores[$pid]['communication'] = $map[$scores[$pid]['communication']]; } } function check_score($score) { $int_score = 0; if(strlen($score) != 2) return NULL; $n = (int)substr($score, 0, 1); $lmh = strtolower(substr($score, 1, 1)); if($n < 1 || $n > 4) return NULL; switch($lmh) { case 'l': $x = 1; break; case 'm': $x = 2; break; case 'h': $x = 3; break; default: return NULL; } /* map to 1L=1, 1M=2, ... 4H=12 */ $int_score = ($n - 1) * 3 + $x; return $int_score; } switch($action) { case 'save': /* Add a project to a prize */ $pid = (int)$_POST['pid']; $sc = ''; $or = ''; $co = ''; post_text($sc, 'scientific'); post_text($or, 'originality'); post_text($co, 'communication'); if($sc == '' && $or == '' && $co == '') { $mysqli->query("DELETE FROM judging_scores WHERE pid='$pid'"); form_ajax_response(array('status'=>0, 'val'=>array('total'=>"--"))); exit(); } /* Error check */ $scientific = check_score($sc); $originality = check_score($or); $communication = check_score($co); if($scientific === NULL || $originality === NULL || $communication === NULL) { form_ajax_response(1); return; } $total = ($scientific * 3) + ($originality * 2) + ($communication * 1); /* Does it exist? */ $q = $mysqli->query("SELECT * FROM judging_scores WHERE pid='$pid'"); if($q->num_rows != 1) { $mysqli->query("DELETE FROM judging_scores WHERE pid='$pid'"); $mysqli->query("INSERT INTO judging_scores (`pid`,`scientific`,`originality`,`communication`,`total`) VALUES('$pid','0','0','0','0')"); } $mysqli->query("UPDATE judging_scores SET `scientific`='$scientific',`originality`='$originality', `communication`='$communication',`total`='$total' WHERE pid='$pid'"); form_ajax_response(array('status'=>0, 'val'=>array('total'=>"$total"))); exit(); } $page_id = 'c_judge_score_entry'; $help = '

Enter Judging Scores'; sfiab_page_begin($u, "Enter Judging Scores", $page_id, $help); ?>

You can search by judging team number using #number. e.g., #6 for judging team 6.

You can reload this page to force a search cache update and search for "missing" to see all the projects with no scores yet