<?php
// Copyright (C) 2014 Universitätsbibliothek Mannheim
// See file LICENSE for license details.
// Datenbankanbindung initialisieren.
require_once 'DBConnector.class.php';
$dbcon = new DBConnector();
session_start();
if (isset($_SESSION['username'])) {
$username = $_SESSION['username'];
$dbcon->delUser($username, $dbcon->ipAddress());
}
session_destroy();
header('Location: index.php');
/*
// Alternate code, currently unused, not working with Apache2 proxy.
$hostname = $_SERVER['HTTP_HOST'];
$path = dirname($_SERVER['PHP_SELF']);
header('Location: http://'.$hostname.($path == '/' ? '' : $path).'/login.php');
*/
//~ $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";
echo "Query=" . $db->querySingle('select value from setting where key="layout"') . "\n";
$db->close();
//~ $db = new DBConnector('palma.db');
//~ $users = $db->getUsers();
//~ var_dump($users);
//~ $db->close();
}