48 lines
1.6 KiB
PHP
48 lines
1.6 KiB
PHP
<?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', '')"
|
|
);
|
|
}
|
|
|
|
}
|
|
?>
|