$tpl->load("main.tpl");
$bootsWatchStyles = array('Cerulean', 'Cosmo', 'Cyborg', 'Darkly', 'Flatly', 'Journal', 'Lumen', 'Paper', 'Readable', 'Sandstone', 'Simplex', 'Slate', 'Spacelab', 'Superhero', 'United', 'Yeti');

$selectedTheme = $mysqli->query("SELECT value FROM faucet_settings WHERE id = '25' LIMIT 1")->fetch_assoc()['value'];

if($selectedTheme == "")
        $tpl->assign("bootstrapStyle", "css/bootstrap.min.css");
    else
        $tpl->assign("bootstrapStyle", "https://maxcdn.bootstrapcdn.com/bootswatch/3.3.7/".(strtolower($selectedTheme))."/bootstrap.min.css");

$Faucetname = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '1'")->fetch_assoc()['value'];
$tpl->assign("faucetname", $Faucetname);

$Spacetop = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '2'")->fetch_assoc()['value'];
$tpl->assign("spacetop", $Spacetop);

$Spaceleft = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '3'")->fetch_assoc()['value'];
$tpl->assign("spaceleft", $Spaceleft);

$Spaceright = $mysqli->query("SELECT * FROM faucet_settings WHERE id = '4'")->fetch_assoc()['value'];
$tpl->assign("spaceright", $Spaceright);