"; endforeach; } $dbfile = DATABASE_LOCATION . constant('User::DATABASE_NAME') . ".db"; $database = new PDO("sqlite:" . $dbfile); $needSetup = "Yes"; $query = "SELECT * FROM users"; foreach($database->query($query) as $data) { $needSetup = "No"; } $db = DATABASE_LOCATION . constant('User::DATABASE_NAME') . ".db"; $file_db = new PDO("sqlite:" . $db); $file_db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $dbTab = $file_db->query('SELECT name FROM sqlite_master WHERE type="table" AND name="tabs"'); $dbOptions = $file_db->query('SELECT name FROM sqlite_master WHERE type="table" AND name="options"'); $tabSetup = "Yes"; $hasOptions = "No"; foreach($dbTab as $row) : if (in_array("tabs", $row)) : $tabSetup = "No"; endif; endforeach; foreach($dbOptions as $row) : if (in_array("options", $row)) : $hasOptions = "Yes"; endif; endforeach; if($tabSetup == "No") : if($USER->authenticated && $USER->role == "admin") : $result = $file_db->query('SELECT * FROM tabs WHERE active = "true"'); $getsettings = $file_db->query('SELECT * FROM tabs WHERE active = "true"'); $settingsicon = "No"; foreach($getsettings as $row) : if($row['iconurl'] && $settingsicon == "No") : $settingsicon = "Yes"; endif; endforeach; elseif($USER->authenticated && $USER->role == "user") : $result = $file_db->query('SELECT * FROM tabs WHERE active = "true" AND user = "true"'); else : $result = $file_db->query('SELECT * FROM tabs WHERE active = "true" AND guest = "true"'); endif; endif; $settingsActive = ""; if($tabSetup == "Yes") : $settingsActive = "active"; endif; if($hasOptions == "Yes") : $resulto = $file_db->query('SELECT * FROM options'); foreach($resulto as $row) : $title = $row['title']; $topbartext = $row['topbartext']; $topbar = $row['topbar']; $bottombar = $row['bottombar']; $sidebar = $row['sidebar']; $hoverbg = $row['hoverbg']; $activetabBG = $row['activetabBG']; $activetabicon = $row['activetabicon']; $activetabtext = $row['activetabtext']; $inactiveicon = $row['inactiveicon']; $inactivetext = $row['inactivetext']; endforeach; elseif($hasOptions == "No") : $title = "Organizr"; $topbar = "#eb6363"; $topbartext = "#FFFFFF"; $bottombar = "#eb6363"; $sidebar = "#000000"; $hoverbg = "#eb6363"; $activetabBG = "#eb6363"; $activetabicon = "#FFFFFF"; $activetabtext = "#FFFFFF"; $inactiveicon = "#FFFFFF"; $inactivetext = "#FFFFFF"; endif; $userpic = md5( strtolower( trim( $USER->email ) ) ); ?> <?=$title;?><?php if($title !== "Organizr") : echo "- Organizr"; endif; ?>
authenticated && $tabSetup == "Yes" && $needSetup == "No") :?>

username); ?> Options


authenticated) : ?>






authenticated) : ?>
authenticated) : ?>