<?php
    global $c;

    $strDBCSFile    = "dbcs.txt";
    $strDBCS        = "sqlite:sqlite.db";

    if (!file_exists($strDBCSFile))
        file_put_contents($strDBCSFile, $strDBCS);

    $strDBCS = trim(file_get_contents($strDBCSFile));

    $c = new DatabaseConnection($strDBCS);

    $intInitialize = 1;
    if ($intInitialize == 1)
    {
        $c->query([
            "create_users_table.sql",
            "create_sessions_table.sql",
            "create_links_table.sql",
            "create_posts_table.sql",
            "create_settings_table.sql"]);

        $varLinks = $c->query("SELECT * from links");

        if (count($varLinks) < 1)
        {
            $c->query(
                "INSERT into links (label, url, icon, position, visibility)
                values
                    ('Home', '/',       'home', 'navbar', ''),
                    ('Post', '/post',   'edit', 'navbar', 'user'),

                    ('Home',        '/',                'home', 'sidebar', ''),
                    ('Edit Links',  '/edit/links',      'link', 'sidebar', 'admin'),
                    ('Edit CSS',    '/settings/css',    'code', 'sidebar', 'admin'),
                    ('Edit JS',     '/settings/js',     'code', 'sidebar', 'admin'),
                    ('Edit sidebar content',    '/settings/sidebar_content',    'comment', 'sidebar', 'admin'),
                    ('Edit footer content',     '/settings/footer_content',     'comment', 'sidebar', 'admin'),

                    ('Go home',    '/',        'home', 'footer', ''),
                    ('Search',    '/search',        'search', 'footer', '')"
                );
        }

    }
?>