38 lines
1.4 KiB
PHP
38 lines
1.4 KiB
PHP
<?php
|
|
|
|
$query = "SELECT * FROM settings WHERE user_id = :userId";
|
|
$stmt = $db->prepare($query);
|
|
$stmt->bindValue(':userId', $userId, SQLITE3_INTEGER);
|
|
$result = $stmt->execute();
|
|
|
|
$settings = $result->fetchArray(SQLITE3_ASSOC);
|
|
if ($settings) {
|
|
$cookieExpire = time() + (30 * 24 * 60 * 60);
|
|
setcookie('theme', $settings['dark_theme'] ? 'dark': 'light', $cookieExpire);
|
|
$settings['theme'] = $settings['dark_theme'] ? 'dark': 'light';
|
|
$settings['color_theme'] = $settings['color_theme'] ? $settings['color_theme'] : "blue";
|
|
$settings['showMonthlyPrice'] = $settings['monthly_price'] ? 'true': 'false';
|
|
$settings['convertCurrency'] = $settings['convert_currency'] ? 'true': 'false';
|
|
$settings['removeBackground'] = $settings['remove_background'] ? 'true': 'false';
|
|
$settings['hideDisabledSubscriptions'] = $settings['hide_disabled'] ? 'true': 'false';
|
|
}
|
|
|
|
$query = "SELECT * FROM custom_colors WHERE user_id = :userId";
|
|
$stmt = $db->prepare($query);
|
|
$stmt->bindValue(':userId', $userId, SQLITE3_INTEGER);
|
|
$result = $stmt->execute();
|
|
$customColors = $result->fetchArray(SQLITE3_ASSOC);
|
|
|
|
if ($customColors) {
|
|
$settings['customColors'] = $customColors;
|
|
}
|
|
|
|
$query = "SELECT * FROM admin";
|
|
$result = $db->query($query);
|
|
$adminSettings = $result->fetchArray(SQLITE3_ASSOC);
|
|
|
|
if ($adminSettings) {
|
|
$settings['disableLogin'] = $adminSettings['login_disabled'];
|
|
}
|
|
|
|
?>
|