query("CREATE TABLE IF NOT EXISTS users(
id INTEGER PRIMARY KEY AUTOINCREMENT,
username TEXT,
shadow TEXT,
name TEXT,
bio TEXT,
tw_oauth_token TEXT,
tw_oauth_verify TEXT
)");
$db->exec("CREATE TABLE IF NOT EXISTS questions(
id INTEGER PRIMARY KEY AUTOINCREMENT,
user INTEGER,
by INTEGER,
question TEXT,
q_date INTEGER,
answer TEXT,
a_date INTEGER,
status INTEGER,
private INTEGER
);");
if(!$db->querySingle("SELECT EXISTS(SELECT * FROM users where id = 0);")){
echo "NOTICE: anonymous user created.";
$db->exec("INSERT INTO users(id, username, name) VALUES('0','anonymous','Anonymous');");
}
if($_SESSION["login"] === true){
echo("");
}
else{
echo("");
}
?>