...

diff --git a/admin/blackboard.php b/admin/blackboard.php
index a28d8dc69cb250fbfd8a729c0d519111410b0405..6571f3928b24c2711bf45e49c9af4de8ddd8bcb0 100644 (file)
--- a/admin/blackboard.php
+++ b/admin/blackboard.php
@@ -3,7 +3,7 @@
   require 'include/db.inc';
   require 'include/common.inc';
   
   require 'include/db.inc';
   require 'include/common.inc';
   

-  if($_GET['mnumber']!="" &&
+  if( isset($_GET['mnumber']) &&

      $db->query("SELECT COUNT(*) FROM students WHERE mnumber=" . trim($_GET['mnumber']) . " AND lastblackboard=" . trim($_GET['tstamp']))->fetch(PDO::FETCH_NUM)[0] == 0) {
      
     if( $_GET['sign'] == 0 ) {
      $db->query("SELECT COUNT(*) FROM students WHERE mnumber=" . trim($_GET['mnumber']) . " AND lastblackboard=" . trim($_GET['tstamp']))->fetch(PDO::FETCH_NUM)[0] == 0) {
      
     if( $_GET['sign'] == 0 ) {

diff --git a/admin/sessionoverview.php b/admin/sessionoverview.php
index 570f59bd09ec274c93f3d91a132931ca0caff319..77b29b6a17882e6a833722eeccd4afdd65dbd2e3 100644 (file)
--- a/admin/sessionoverview.php
+++ b/admin/sessionoverview.php
@@ -34,8 +34,8 @@
   print "<select name='sessionselected' onchange='this.form.submit()'>";
   foreach($SESSIONS as $session) {
     $note = "";
   print "<select name='sessionselected' onchange='this.form.submit()'>";
   foreach($SESSIONS as $session) {
     $note = "";

-    if( $session['id'] == $SESSIONS_actual ) { $note = "(next)"; }
-    if( $session['id'] == $SESSIONS_last ) { $note = "(last)"; }
+    if( isset($SESSIONS_actual) && $session['id'] == $SESSIONS_actual ) { $note = "(next)"; }
+    if( isset($SESSIONS_last) && $session['id'] == $SESSIONS_last ) { $note = "(last)"; }

     if( $showsession != $session['id'] ) {
       print "<option value=" . $session['id'] . ">" . $session['timestr'] . " " . $note . "</option>";
     }
     if( $showsession != $session['id'] ) {
       print "<option value=" . $session['id'] . ">" . $session['timestr'] . " " . $note . "</option>";
     }


@@ -53,7 +53,7 @@
   print "<table>";
   print "<td><b>First name&nbsp;</b></td><td><b>Last name&nbsp;</b></td><td><b>Matr.nummer&nbsp;</b></td><td><b>Examples&nbsp;</b></td>";
 
   print "<table>";
   print "<td><b>First name&nbsp;</b></td><td><b>Last name&nbsp;</b></td><td><b>Matr.nummer&nbsp;</b></td><td><b>Examples&nbsp;</b></td>";
 

-  if( $showsession == $SESSIONS_actual ) {
+  if( isset($SESSIONS_actual) && $showsession == $SESSIONS_actual ) {

     print "<td><b>Blackboard&nbsp;</b></td>";
   }
   else {
     print "<td><b>Blackboard&nbsp;</b></td>";
   }
   else {


@@ -74,7 +74,7 @@
     print "<td>" . $student['mnumber'] . "</td>";
     print "<td>" . $thisdone . " (" . $exdone . "/" . $SESSIONS[$showsession]['nexamples'] . ")</td>";
 
     print "<td>" . $student['mnumber'] . "</td>";
     print "<td>" . $thisdone . " (" . $exdone . "/" . $SESSIONS[$showsession]['nexamples'] . ")</td>";
 

-    if( $showsession != $SESSIONS_actual ) {
+    if( (! isset($SESSIONS_actual)) || $showsession != $SESSIONS_actual ) {

       print "<td><form style='margin: 0; padding: 0' action='sessionoverview.php'>";
       if( isset($_GET['sessionselected']) ) { print "<input type='hidden' name='sessionselected' value='" . $_GET['sessionselected'] . "' />"; } 
       print "<input type='hidden' name='sessionid' value='" . $showsession . "' />";
       print "<td><form style='margin: 0; padding: 0' action='sessionoverview.php'>";
       if( isset($_GET['sessionselected']) ) { print "<input type='hidden' name='sessionselected' value='" . $_GET['sessionselected'] . "' />"; } 
       print "<input type='hidden' name='sessionid' value='" . $showsession . "' />";

diff --git a/admin/summary.php b/admin/summary.php
index 68c026fd5dc0e0bbadd3c21680f78e79386b7c51..b4671576f45a7c1e8de89fbe08e368539ab8e85f 100644 (file)
--- a/admin/summary.php
+++ b/admin/summary.php
@@ -16,9 +16,11 @@
   print "<table>";
   print "<td><b>First name&nbsp;</b></td><td><b>Last name&nbsp;</b></td><td><b>Matr.nummer&nbsp;</b></td><td><b>Examples&nbsp;</b></td><td><b>Blackboard&nbsp;</b></td>";
   while ($student = $result->fetch(PDO::FETCH_ASSOC)) {
   print "<table>";
   print "<td><b>First name&nbsp;</b></td><td><b>Last name&nbsp;</b></td><td><b>Matr.nummer&nbsp;</b></td><td><b>Examples&nbsp;</b></td><td><b>Blackboard&nbsp;</b></td>";
   while ($student = $result->fetch(PDO::FETCH_ASSOC)) {

-    $exdone = $db->query("SELECT manydone FROM workdone WHERE mnumber=" . $student['mnumber'])->fetch(PDO::FETCH_NUM);

     $totexdone = 0;
     $totexdone = 0;

-    foreach($exdone as $subdone) { $totexdone += $subdone; }
+    if( $db->query("SELECT COUNT(*) FROM workdone WHERE mnumber=" . $student['mnumber'])->fetch(PDO::FETCH_NUM)[0] > 0 ) {
+      $exdone = $db->query("SELECT manydone FROM workdone WHERE mnumber=" . $student['mnumber'])->fetch(PDO::FETCH_NUM);
+      foreach($exdone as $subdone) { $totexdone += $subdone; }
+    }

     print "<tr>";
     print "<td>" . $student['firstname'] . "</td>";
     print "<td>" . $student['lastname'] . "</td>";
     print "<tr>";
     print "<td>" . $student['firstname'] . "</td>";
     print "<td>" . $student['lastname'] . "</td>";

diff --git a/include/session.inc b/include/session.inc
index 288c7984ecd3cbb0e4208e356f342dd292bc88ef..46802f4ffbb59341dc1298a720b186eb64d86c49 100644 (file)
--- a/include/session.inc
+++ b/include/session.inc
@@ -23,18 +23,14 @@
     if($SESSIONS_actual == -1) unset($SESSIONS_actual);
 
     $SESSIONS_totex = 0;
     if($SESSIONS_actual == -1) unset($SESSIONS_actual);
 
     $SESSIONS_totex = 0;

+    $SESSIONS_totex_nextinc = 0;

     if(isset($SESSIONS)) {
       foreach ($SESSIONS as $session) {
     if(isset($SESSIONS)) {
       foreach ($SESSIONS as $session) {

-        if($session['id'] < $SESSIONS_next || (! isset($SESSIONS_next)) ) { $SESSIONS_totex += $session['nexamples']; }
-       if( $session['id'] != $SESSIONS_actual ) { $SESSIONS_last = $session['id']; }
+        if( (! isset($SESSIONS_next)) || $session['id'] < $SESSIONS_next ) { $SESSIONS_totex += $session['nexamples']; }
+       if( (! isset($SESSIONS_actual)) || $session['id'] != $SESSIONS_actual ) { $SESSIONS_last = $session['id']; }
+       if( (! isset($SESSIONS_next)) || $session['id'] <= $SESSIONS_next ) { $SESSIONS_totex_nextinc += $session['nexamples']; }

       }
     }
 
       }
     }
 

-    $SESSIONS_totex_nextinc = 0;
-    if( isset($SESSIONS) && isset($SESSIONS_next) ) {
-      foreach ($SESSIONS as $session) {
-        if($session['id'] <= $SESSIONS_next) { $SESSIONS_totex_nextinc += $session['nexamples']; }
-      }
-    }

   }
 ?>
   }
 ?>