slork/sqlite.php

<?php

require "settings.php";

$pdo = null;
try {
	$pdo = new PDO("sqlite:" . "${db_path}/slork.sqlite");
} catch (PDOException $e) {
	// handle the exception here
}
if ( !$pdo ) {
	exit( "Cannot connect to database" );
}

// Create maintainer database
$pdo->exec( "DROP TABLE IF EXISTS maintainer;" );
$query = <<<QUERY
CREATE TABLE IF NOT EXISTS maintainer (
		id INTEGER PRIMARY KEY, maintainer INTEGER, api TEXT,
		UNIQUE( maintainer ));
QUERY;
$stmt = $pdo->exec( $query );
//$stmt->execute();

// Create user/player database
$pdo->exec( "DROP TABLE IF EXISTS player;" );
$query = <<<QUERY
CREATE TABLE IF NOT EXISTS player (
		id INTEGER PRIMARY KEY, maintainer INTEGER,
		player INTEGER, property TEXT, value TEXT,
		UNIQUE(maintainer, player),
		FOREIGN KEY (maintainer) REFERENCES maintainer(maintainer));
QUERY;
$stmt = $pdo->exec( $query );
//$stmt->execute();

// Create player preferences table (properties)
$pdo->exec( "DROP TABLE IF EXISTS player_properties;" );
$query = <<<QUERY
	CREATE TABLE player_properties (
	    id INTEGER PRIMARY KEY, 
	    maintainer INTEGER, 
	    player INTEGER, 
	    property TEXT DEFAULT '["name"]',
	    UNIQUE( maintainer, player));
QUERY;
$pdo->exec( $query );

$pdo->exec( "DROP TABLE IF EXISTS discord" );
$query = <<<QUERY
	CREATE TABLE discord (
	    id INTEGER PRIMARY KEY, 
		maintainer INTEGER, 
		discord TEXT, 
		UNIQUE(maintainer));
QUERY;
$pdo->exec( $query );
$query = <<<QUERY
	INSERT OR REPLACE INTO discord (maintainer, discord)
		VALUES (?, ?)
QUERY;
$stmt = $pdo->prepare( $query );
$stmt->execute( [204836, "https://discordapp.com/api/webhooks/706228042124623944/UGEYMQi-2iMUyg8jvGiFSc6CfcThv1dMSBgNhzziPL9aBoNxoNA03fPJZ1iwxQ-_xm7r"] );
$stmt->execute( [1900827, "https://discordapp.com/api/webhooks/706229815166107669/vCNCc7uGe__JI9YHmoUUXozgOMc6FZclbX3SPLSQSy75B7m9AT8_36gExdRRZMYxTrwq"] );
$stmt->execute( [1337627, "https://discordapp.com/api/webhooks/706230061275283478/DCUzGepweoYvufNr2KDXFt06j6cexdfVxhfbjrn1h7r77k9I0FlY0xuzyl3UInZgybGj"] );

// properties.php contains queries for a subsequent
// table properties containing default property names.
require_once "properties.php";