...

diff --git a/admin/blackboard.php b/admin/blackboard.php
index b683221cf84298dcb8426dcc9030c49157004f24..4066f84d4249fb5cdd61cca6e4a341d556d8e62a 100644 (file)
--- a/admin/blackboard.php
+++ b/admin/blackboard.php
@@ -8,6 +8,11 @@
     block("lightgreen", "added blackboard");
   }
 
+  if ($db->query("SELECT COUNT(*) FROM students")->fetch(PDO::FETCH_NUM)[0] == 0) {
+    block("red", "no students registered");
+    break;
+  }
+
   block("black", "add blackboard");
 ?>
 

diff --git a/admin/index.php b/admin/index.php
index 74acd8b7aafeec06ce22cb873fad11f9408da9e7..254993a5db6b04bcec1a5d2260f332366cf5c4d6 120000 (symlink)
--- a/admin/index.php
+++ b/admin/index.php
@@ -1 +1 @@
-blackboard.php
\ No newline at end of file
+nextsession.php
\ No newline at end of file

diff --git a/admin/nextsession.php b/admin/nextsession.php
index ca467fd2708972a00e6fe8af3c2f91df3b942701..f4388228c9b0cf5edef893e40763f86029021dbf 100644 (file)
--- a/admin/nextsession.php
+++ b/admin/nextsession.php
@@ -4,6 +4,11 @@
   require 'include/session.inc';
   require 'include/common.inc';
 
+  if (! isset($SESSIONS_actual)) {
+    block("red", "no next session");
+    break;
+  }
+
   block("black", "summary for session " . $SESSIONS[$SESSIONS_actual]['timestr'] . " (" . $SESSIONS[$SESSIONS_actual]['examples'] . ")");
 
   $result = $db->query("SELECT firstname, lastname, mnumber, blackboard FROM students ORDER BY lastname");

diff --git a/admin/summary.php b/admin/summary.php
index 0cd54671f019ea7e3d981ac5d638990a9ba230d2..33658ef238c911e8fb3e557a5be6df4c050242fa 100644 (file)
--- a/admin/summary.php
+++ b/admin/summary.php
@@ -4,6 +4,11 @@
   require 'include/session.inc';
   require 'include/common.inc';
 
+  if ($db->query("SELECT COUNT(*) FROM students")->fetch(PDO::FETCH_NUM)[0] == 0) {
+    block("red", "no students registered");
+    break;
+  }
+
   block("black", "summary of everything for " . date("d.m.Y H:i"));
 
   $result = $db->query("SELECT firstname, lastname, mnumber, blackboard FROM students ORDER BY lastname");

diff --git a/include/prefs.inc b/include/prefs.inc
index 58aac3e08a00047bf30315002cd323fddc8ad08d..a3e1aaaf9c57857bfc27579de62bf0badf93d564 100644 (file)
--- a/include/prefs.inc
+++ b/include/prefs.inc
@@ -1,9 +1,10 @@
 <?php
   include 'db.inc';
 
-  $result = $db->query("SELECT key, value FROM prefs");
-  while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
-    $PREFS[$row['key']] = $row['value'];
+  if (! isset($PREFS)) {
+    $result = $db->query("SELECT key, value FROM prefs");
+    while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
+      $PREFS[$row['key']] = $row['value'];
+    }
   }  
-
 ?>

diff --git a/include/session.inc b/include/session.inc
index c31441ebf07d2dfae9d591df0091ee8c22ea8e9f..554ac1fc1397a9c93bbbcdeab7d454a77fc16296 100644 (file)
--- a/include/session.inc
+++ b/include/session.inc
@@ -1,28 +1,33 @@
 <?php
-  $result=$db->query("SELECT id,examples,nexamples FROM sessions ORDER BY id");
-  $SESSIONS_next = -1;
-  $SESSIONS_actual = -1;
+  require 'db.inc';
+
+  if ( ! isset($SESSIONS) ) {
+    $result=$db->query("SELECT id,examples,nexamples FROM sessions ORDER BY id");
+    $SESSIONS_next = -1;
+    $SESSIONS_actual = -1;
   
-  while ($session = $result->fetch(PDO::FETCH_ASSOC)) {
-    $SESSIONS[$session['id']] = array("id" => $session['id'], "timestr" => date("d.m.Y H:i", $session['id']),
-      "workdone" => $db->query("SELECT COUNT(*) FROM workdone WHERE session=" . $session['id'])->fetch(PDO::FETCH_NUM)[0],
-      "examples" => $session['examples'], "nexamples" => $session['nexamples']);
-    if ( strtotime("now") < $session['id'] && ( $SESSIONS_next==-1 || $SESSIONS_next > $session['id'] )  ) {
-      $SESSIONS_next = $session['id'];
-    }
-    if ( strtotime("now") < $session['id'] + 3600  && ( $SESSIONS_actual==-1 || $SESSIONS_actual > $session['id'] )  ) {
-      $SESSIONS_actual = $session['id'];
+    while ($session = $result->fetch(PDO::FETCH_ASSOC)) {
+      $SESSIONS[$session['id']] = array("id" => $session['id'], "timestr" => date("d.m.Y H:i", $session['id']),
+        "workdone" => $db->query("SELECT COUNT(*) FROM workdone WHERE session=" . $session['id'])->fetch(PDO::FETCH_NUM)[0],
+        "examples" => $session['examples'], "nexamples" => $session['nexamples']);
+      if ( strtotime("now") < $session['id'] && ( $SESSIONS_next==-1 || $SESSIONS_next > $session['id'] )  ) {
+        $SESSIONS_next = $session['id'];
+      }
+      if ( strtotime("now") < $session['id'] + 3600  && ( $SESSIONS_actual==-1 || $SESSIONS_actual > $session['id'] )  ) {
+        $SESSIONS_actual = $session['id'];
+      }
     }
-  }
-  if($SESSIONS_next == -1) unset($SESSIONS_next);
+    if($SESSIONS_next == -1) unset($SESSIONS_next);
+    if($SESSIONS_actual == -1) unset($SESSIONS_actual);
 
-  $SESSIONS_totex = 0;
-  foreach ($SESSIONS as $session) {
-    if($session['id'] < $SESSIONS_next) { $SESSIONS_totex += $session['nexamples']; }
-  }
+    $SESSIONS_totex = 0;
+    foreach ($SESSIONS as $session) {
+      if($session['id'] < $SESSIONS_next) { $SESSIONS_totex += $session['nexamples']; }
+    }
 
-  $SESSIONS_totex_nextinc = 0;
-  foreach ($SESSIONS as $session) {
-    if($session['id'] <= $SESSIONS_next) { $SESSIONS_totex_nextinc += $session['nexamples']; }
+    $SESSIONS_totex_nextinc = 0;
+    foreach ($SESSIONS as $session) {
+      if($session['id'] <= $SESSIONS_next) { $SESSIONS_totex_nextinc += $session['nexamples']; }
+    }
   }
 ?>

diff --git a/register.php b/register.php
index 0a844ac40794b21dfbeba39c0a2c93260df9abfd..13e2aaba5ceeb5dae2ecaf3c94ed3171d17e5630 100644 (file)
--- a/register.php
+++ b/register.php
@@ -1,5 +1,6 @@
 <?php
 require 'include/head.inc';
+require 'include/prefs.inc';
 
 if(isset($_POST['submit']) && $_POST['firstname']!="" && $_POST['lastname']!="" 
                           && $_POST['mnumber']!="" && $_POST['email']!="" && $_POST['password']!="")
@@ -30,18 +31,13 @@ if(isset($_POST['submit']) && $_POST['firstname']!="" && $_POST['lastname']!=""
   echo "$firstname $lastname was successfully registered.<br>";
 
   // send password-email //
-  $lec_lines = file('var/lecture.txt');
-  foreach ($lec_lines as $line_num => $line) {
-    $lecture[$line_num] = $line;
-  }
-  $nachricht = "Hello $firstname($mnumber)!\nYou registered for " . trim($lecture[0]) . " " . trim($lecture[1]) . ".\nRemember your password: $password\n\nYours,\nBanana.";
-  //$nachricht = wordwrap($nachricht,70);
+  $nachricht = "Hello $firstname($mnumber)!\nYou registered for " . $PREFS['exname'] . " (" . $PREFS['groupname'] . ").\nRemember your password: $password\n\nYours,\nBanana.";
   $empfaenger = 'niemand@example.com';
   $betreff = 'Der Betreff';
   $header = 'From: banana@treefish.org' . "\r\n" .
     'Reply-To: noreply@treefish.org' . "\r\n" .
     'X-Mailer: PHP/' . phpversion();
-  mail($email, "Banana Registration: " . trim($lecture[0]) . " " . trim($lecture[1]), $nachricht, $header);
+  mail($email, "Banana Registration: " . $PREFS['exname'] . " (" . $PREFS['groupname'] . ")", $nachricht, $header);
 
   break;
 }