query($query) as $data) { $needSetup = "No"; } $db = constant('User::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"'); $dbColor = $file_db->query('SELECT name FROM sqlite_master WHERE type="table" AND name="color"'); $tabSetup = "Yes"; $hasColors = "No"; foreach($dbTab as $row) : if (in_array("tabs", $row)) : $tabSetup = "No"; endif; endforeach; foreach($dbColor as $row) : if (in_array("color", $row)) : $hasColors = "Yes"; endif; endforeach; if($tabSetup == "No") : if($USER->authenticated && $USER->role == "admin") : $result = $file_db->query('SELECT * FROM tabs WHERE active = "true"'); 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; ?>