X-Git-Url: https://git.treefish.org/banana.git/blobdiff_plain/8db41c98817b1b48532dc3cebf4bea166e42bb70..288a7087acaeb011fe8bb828d8d081be2a7fc12e:/admin/blackboard.php diff --git a/admin/blackboard.php b/admin/blackboard.php index b683221..6571f39 100644 --- a/admin/blackboard.php +++ b/admin/blackboard.php @@ -3,27 +3,28 @@ require 'include/db.inc'; require 'include/common.inc'; - if(isset($_POST['submit']) && $_POST['mnumber']!="") { - $db->query("UPDATE students SET blackboard=blackboard+1 WHERE mnumber=" . trim($_POST['mnumber'])); - block("lightgreen", "added blackboard"); + 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("UPDATE students SET blackboard=blackboard+1, lastblackboard=" . $_GET['tstamp'] . " WHERE mnumber=" . trim($_GET['mnumber'])); + } + else { + $db->query("UPDATE students SET blackboard=blackboard-1, lastblackboard=" . $_GET['tstamp'] . " WHERE mnumber=" . trim($_GET['mnumber'])); + } } - block("black", "add blackboard"); -?> + if ($db->query("SELECT COUNT(*) FROM students")->fetch(PDO::FETCH_NUM)[0] == 0) { + block("red", "no students registered"); + exit; + } -
- - - - - -
Matr.nummer:
-
+?> query("SELECT firstname, lastname, mnumber, blackboard FROM students"); + $result=$db->query("SELECT firstname, lastname, mnumber, blackboard FROM students ORDER BY LOWER(lastname)"); print ""; while ($student = $result->fetch(PDO::FETCH_ASSOC)) { @@ -31,7 +32,9 @@ print ""; print ""; print ""; - print ""; + print ""; + print ""; + print ""; print ""; } print "
" . $student['firstname'] . " " . $student['lastname'] . "  " . $student['mnumber'] . "  " . $student['blackboard'] . "" . $student['blackboard'] . "  " . "+1" . "" . "-1" . "
";