X-Git-Url: http://git.treefish.org/banana.git/blobdiff_plain/4678f209fb04682d0981cadb566d63f5726f9e09..8db41c98817b1b48532dc3cebf4bea166e42bb70:/include/session.inc

diff --git a/include/session.inc b/include/session.inc
new file mode 100644
index 0000000..7b5b798
--- /dev/null
+++ b/include/session.inc
@@ -0,0 +1,18 @@
+<?php
+  $result=$db->query("SELECT id,examples,nexamples FROM sessions ORDER BY id");
+  $SESSIONS_next = -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($SESSIONS_next == -1) unset($SESSIONS_next);
+
+  $SESSIONS_totex = 0;
+  foreach ($SESSIONS as $session) {
+    if($session['id'] < $SESSIONS_next) { $SESSIONS_totex += $session['nexamples']; }
+  }
+?>