$db = new DBConnector('palma-test.db'); $db->resetTables(); //~ http://stackoverflow.com/questions/1964233/does-sqlite3-support-a-trigger-to-automatically-update-an-updated-on-datetime //~ https://www.sqlite.org/lang_createtrigger.html // TODO: Test database triggers (can be used in db.php). //~ $db->createFunction('dbModifiedCallback', 'dbModifiedCallback', 0); // {AFTER | BEFORE} {DELETE | INSERT | UPDATE } ON table //~ $db->exec("CREATE TRIGGER dbchange AFTER UPDATE ON user //~ BEGIN //~ dbModifiedCallback(); //~ END"); //~ $db = new DBConnector('palma.db'); echo "Tables=" . $db->querySingle('SELECT count(*) FROM sqlite_master WHERE type="table"') . "\n"; var_dump($db->query("SELECT * from sqlite_master")); $address = $db->ipAddress(); $db->addUser('testuser1', $address); //~ $db->addUser('testuser2', $address); //~ $db->addUser('testuser3', $address); //~ $db->addUser('testuser4', $address); $users = $db->getUsers(); $db->enableUser('testuser1'); var_dump($users); $db->delUser('haenger', $address); $db->delUser('ivwz', $address); $db->delUser('skrieg', $address); $db->delUser('testuser1', $address); $db->delUser('testuser2', $address); $db->delUser('testuser3', $address); $db->delUser('testuser4', $address); echo "Query=" . $db->querySingle('select name from user') . "\n"; echo "Query=" . $db->querySingle('select count(name) from user') . "\n";
} if (CONFIG_PASSWORD && !checkCredentials($username, $password)) { // Invalid username or password. } else { if (CONFIG_PIN && $pin != $posted_pin) { trace("access denied for user '{$username}', wrong pin {$posted_pin}"); $errtext = _('Invalid PIN.'); } else { // Successfully checked username, password and PIN. trace("access granted for user '{$username}'"); $_SESSION['username'] = $username; $_SESSION['address'] = $dbcon->ipAddress(); $_SESSION['pin'] = $pin; $_SESSION['starturl'] = CONFIG_START_URL; $_SESSION['monitor'] = CONFIG_STATIONNAME; $dbcon->addUser($username, $dbcon->ipAddress(), getDevice()); // Weiterleitung zur geschützten Startseite if ($_SERVER['SERVER_PROTOCOL'] == 'HTTP/1.1') { if (php_sapi_name() == 'cgi') { header('Status: 303 See Other'); } else { header('HTTP/1.1 303 See Other'); } } header('Location: ' . CONFIG_START_URL); exit; } } } ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"