--- /dev/null
+<?php
+ require 'db.inc';
+
+ if ( ! isset($EXAMS) ) {
+ $result=$db->query("SELECT id,score FROM exams ORDER BY id");
+ $EXAMS_next = -1;
+ $EXAMS_actual = -1;
+ $EXAMS_n = 0;
+
+ while ($exam = $result->fetch(PDO::FETCH_ASSOC)) {
+ $totpoints = 0;
+ foreach (explode(',',$exam['score']) as $points) {
+ $totpoints = $totpoints + $points;
+ }
+ $EXAMS[$exam['id']] = array("id" => $exam['id'],
+ "timestr" => date("d.m.Y H:i", $exam['id']),
+ "scorestr" => $exam['score'],
+ "totscore" => $totpoints,
+ "nresults" => $db->query("SELECT COUNT(*) FROM examscore WHERE exam=" . $exam['id'])->fetch(PDO::FETCH_NUM)[0],
+ "nquests" => count(explode(',',$exam['score'])));
+ if ( strtotime("now") < $exam['id'] && ( $EXAMS_next==-1 || $EXAMS_next > $exam['id'] ) ) {
+ $EXAMS_next = $exam['id'];
+ }
+ if ( strtotime("now") < $exam['id'] + 3600 && ( $EXAMS_actual==-1 || $EXAMS_actual > $exam['id'] ) ) {
+ $EXAMS_actual = $exam['id'];
+ }
+ $EXAMS_n++;
+ }
+ if($EXAMS_next == -1) unset($EXAMS_next);
+ if($EXAMS_actual == -1) unset($EXAMS_actual);
+
+ $EXAMS_totscore = 0;
+ $EXAMS_totscore_nextinc = 0;
+ if(isset($EXAMS)) {
+ foreach ($EXAMS as $exam) {
+ if( (! isset($EXAMS_next)) || $exam['id'] < $EXAMS_next ) { $EXAMS_totscore += $exam['totscore']; }
+ if( (! isset($EXAMS_actual)) || $exam['id'] != $EXAMS_actual ) { $EXAMS_last = $exam['id']; }
+ if( (! isset($EXAMS_next)) || $exam['id'] <= $EXAMS_next ) { $EXAMS_totscore_nextinc += $exam['totscore']; }
+ }
+ }
+
+ }
+?>