pref_item_map = [ __('General') => [ 'USER_LANGUAGE', 'USER_TIMEZONE', 'BLOCK_SEPARATOR', 'USER_CSS_THEME', 'BLOCK_SEPARATOR', 'ENABLE_API_ACCESS', ], __('Feeds') => [ 'DEFAULT_UPDATE_INTERVAL', 'FRESH_ARTICLE_MAX_AGE', 'DEFAULT_SEARCH_LANGUAGE', 'BLOCK_SEPARATOR', 'ENABLE_FEED_CATS', 'BLOCK_SEPARATOR', 'CONFIRM_FEED_CATCHUP', 'ON_CATCHUP_SHOW_NEXT_FEED', 'BLOCK_SEPARATOR', 'HIDE_READ_FEEDS', 'HIDE_READ_SHOWS_SPECIAL', ], __('Articles') => [ 'PURGE_OLD_DAYS', 'PURGE_UNREAD_ARTICLES', 'BLOCK_SEPARATOR', 'COMBINED_DISPLAY_MODE', 'CDM_EXPANDED', 'BLOCK_SEPARATOR', 'CDM_AUTO_CATCHUP', 'VFEED_GROUP_BY_FEED', 'BLOCK_SEPARATOR', 'SHOW_CONTENT_PREVIEW', 'STRIP_IMAGES', ], __('Digest') => [ 'DIGEST_ENABLE', 'DIGEST_CATCHUP', 'DIGEST_PREFERRED_TIME', ], __('Advanced') => [ 'BLACKLISTED_TAGS', 'BLOCK_SEPARATOR', 'LONG_DATE_FORMAT', 'SHORT_DATE_FORMAT', 'BLOCK_SEPARATOR', 'SSL_CERT_SERIAL', ] ]; $this->pref_help_bottom = [ "BLACKLISTED_TAGS" => __("Never apply these tags automatically (comma-separated list)."), ]; $this->pref_help = [ "ALLOW_DUPLICATE_POSTS" => array(__("Allow duplicate articles"), ""), "BLACKLISTED_TAGS" => array(__("Blacklisted tags"), ""), "DEFAULT_SEARCH_LANGUAGE" => array(__("Default language"), __("Used for full-text search")), "CDM_AUTO_CATCHUP" => array(__("Mark read on scroll"), __("Mark articles as read as you scroll past them")), "CDM_EXPANDED" => array(__("Always expand articles")), "COMBINED_DISPLAY_MODE" => array(__("Combined mode"), __("Show flat list of articles instead of separate panels")), "CONFIRM_FEED_CATCHUP" => array(__("Confirm marking feeds as read")), "DEFAULT_ARTICLE_LIMIT" => array(__("Amount of articles to display at once")), "DEFAULT_UPDATE_INTERVAL" => array(__("Default update interval")), "DIGEST_CATCHUP" => array(__("Mark sent articles as read")), "DIGEST_ENABLE" => array(__("Enable digest"), __("Send daily digest of new (and unread) headlines to your e-mail address")), "DIGEST_PREFERRED_TIME" => array(__("Try to send around this time"), __("Time in UTC")), "ENABLE_API_ACCESS" => array(__("Enable API"), __("Allows accessing this account through the API")), "ENABLE_FEED_CATS" => array(__("Enable categories")), "FEEDS_SORT_BY_UNREAD" => array(__("Sort feeds by unread articles count"), ""), "FRESH_ARTICLE_MAX_AGE" => array(__("Maximum age of fresh articles"), "" . __("hours") . ""), "HIDE_READ_FEEDS" => array(__("Hide read feeds")), "HIDE_READ_SHOWS_SPECIAL" => array(__("Always show special feeds"), __("While hiding read feeds")), "LONG_DATE_FORMAT" => array(__("Long date format"), __("Syntax is identical to PHP date() function.")), "ON_CATCHUP_SHOW_NEXT_FEED" => array(__("Automatically show next feed"), __("After marking one as read")), "PURGE_OLD_DAYS" => array(__("Purge articles older than"), __("days (0 disables)")), "PURGE_UNREAD_ARTICLES" => array(__("Purge unread articles")), "REVERSE_HEADLINES" => array(__("Reverse headline order (oldest first)")), "SHORT_DATE_FORMAT" => array(__("Short date format")), "SHOW_CONTENT_PREVIEW" => array(__("Show content preview in headlines")), "SORT_HEADLINES_BY_FEED_DATE" => array(__("Sort headlines by feed date"), __("Use feed-specified date to sort headlines instead of local import date.")), "SSL_CERT_SERIAL" => array(__("SSL client certificate")), "STRIP_IMAGES" => array(__("Do not embed media")), "STRIP_UNSAFE_TAGS" => array(__("Strip unsafe tags from articles"), __("Strip all but most common HTML tags when reading articles.")), "USER_STYLESHEET" => array(__("Customize stylesheet")), "USER_TIMEZONE" => array(__("Time zone")), "VFEED_GROUP_BY_FEED" => array(__("Group by feed"), __("Group multiple-feed output by originating feed")), "USER_LANGUAGE" => array(__("Language")), "USER_CSS_THEME" => array(__("Theme")) ]; $this->pref_blacklist = ["ALLOW_DUPLICATE_POSTS", "STRIP_UNSAFE_TAGS", "REVERSE_HEADLINES", "SORT_HEADLINES_BY_FEED_DATE", "DEFAULT_ARTICLE_LIMIT", "FEEDS_SORT_BY_UNREAD", "USER_STYLESHEET"]; /* "FEEDS_SORT_BY_UNREAD", "HIDE_READ_FEEDS", "REVERSE_HEADLINES" */ $this->profile_blacklist = ["ALLOW_DUPLICATE_POSTS", "PURGE_OLD_DAYS", "PURGE_UNREAD_ARTICLES", "DIGEST_ENABLE", "DIGEST_CATCHUP", "BLACKLISTED_TAGS", "ENABLE_API_ACCESS", "UPDATE_POST_ON_CHECKSUM_CHANGE", "DEFAULT_UPDATE_INTERVAL", "USER_TIMEZONE", "SORT_HEADLINES_BY_FEED_DATE", "SSL_CERT_SERIAL", "DIGEST_PREFERRED_TIME"]; } function changepassword() { if (defined('_TTRSS_DEMO_INSTANCE')) { print "ERROR: ".format_error("Disabled in demo version."); return; } $old_pw = clean($_POST["old_password"]); $new_pw = clean($_POST["new_password"]); $new_unclean_pw = $_POST["new_password"]; $con_pw = clean($_POST["confirm_password"]); if ($new_unclean_pw != $new_pw) { print "ERROR: ".format_error("New password contains disallowed characters."); return; } if ($old_pw == $new_pw) { print "ERROR: ".format_error("New password must be different from the old one."); return; } if ($old_pw == "") { print "ERROR: ".format_error("Old password cannot be blank."); return; } if ($new_pw == "") { print "ERROR: ".format_error("New password cannot be blank."); return; } if ($new_pw != $con_pw) { print "ERROR: ".format_error("Entered passwords do not match."); return; } $authenticator = PluginHost::getInstance()->get_plugin($_SESSION["auth_module"]); if (method_exists($authenticator, "change_password")) { print format_notice($authenticator->change_password($_SESSION["uid"], $old_pw, $new_pw)); } else { print "ERROR: ".format_error("Function not supported by authentication module."); } } function saveconfig() { $boolean_prefs = explode(",", clean($_POST["boolean_prefs"])); foreach ($boolean_prefs as $pref) { if (!isset($_POST[$pref])) $_POST[$pref] = 'false'; } $need_reload = false; foreach (array_keys($_POST) as $pref_name) { $value = $_POST[$pref_name]; switch ($pref_name) { case 'DIGEST_PREFERRED_TIME': if (get_pref('DIGEST_PREFERRED_TIME') != $value) { $sth = $this->pdo->prepare("UPDATE ttrss_users SET last_digest_sent = NULL WHERE id = ?"); $sth->execute([$_SESSION['uid']]); } break; case 'USER_LANGUAGE': if (!$need_reload) $need_reload = $_SESSION["language"] != $value; break; case 'USER_CSS_THEME': if (!$need_reload) $need_reload = get_pref($pref_name) != $value; break; case 'BLACKLISTED_TAGS': $cats = FeedItem_Common::normalize_categories(explode(",", $value)); asort($cats); $value = implode(", ", $cats); break; } set_pref($pref_name, $value); } if ($need_reload) { print "PREFS_NEED_RELOAD"; } else { print __("The configuration was saved."); } } function changeemail() { $email = clean($_POST["email"]); $full_name = clean($_POST["full_name"]); $active_uid = $_SESSION["uid"]; $sth = $this->pdo->prepare("SELECT email, login, full_name FROM ttrss_users WHERE id = ?"); $sth->execute([$active_uid]); if ($row = $sth->fetch()) { $old_email = $row["email"]; if ($old_email != $email) { $mailer = new Mailer(); $tpl = new Templator(); $tpl->readTemplateFromFile("mail_change_template.txt"); $tpl->setVariable('LOGIN', $row["login"]); $tpl->setVariable('NEWMAIL', $email); $tpl->setVariable('TTRSS_HOST', SELF_URL_PATH); $tpl->addBlock('message'); $tpl->generateOutputToString($message); $mailer->mail(["to_name" => $row["login"], "to_address" => $row["email"], "subject" => "[tt-rss] Mail address change notification", "message" => $message]); } } $sth = $this->pdo->prepare("UPDATE ttrss_users SET email = ?, full_name = ? WHERE id = ?"); $sth->execute([$email, $full_name, $active_uid]); print __("Your personal data has been saved."); return; } function resetconfig() { $_SESSION["prefs_op_result"] = "reset-to-defaults"; $sth = $this->pdo->prepare("DELETE FROM ttrss_user_prefs WHERE (profile = :profile OR (:profile IS NULL AND profile IS NULL)) AND owner_uid = :uid"); $sth->execute([":profile" => $_SESSION['profile'], ":uid" => $_SESSION['uid']]); $this->initialize_user_prefs($_SESSION["uid"], $_SESSION["profile"]); echo __("Your preferences are now set to default values."); } private function index_auth_personal() { $sth = $this->pdo->prepare("SELECT email,full_name,otp_enabled, access_level FROM ttrss_users WHERE id = ?"); $sth->execute([$_SESSION["uid"]]); $row = $sth->fetch(); $email = htmlspecialchars($row["email"]); $full_name = htmlspecialchars($row["full_name"]); $otp_enabled = sql_bool_to_bool($row["otp_enabled"]); ?>

get_plugin($_SESSION["auth_module"]); } else { $authenticator = false; } $otp_enabled = $this->is_otp_enabled(); if ($authenticator && method_exists($authenticator, "change_password")) { ?>

%s) does not provide an ability to set passwords.", $_SESSION["auth_module"])); } } private function index_auth_app_passwords() { print_notice("You can create separate passwords for API clients. Using one is required if you enable OTP."); ?>
appPasswordList() ?>

pdo->prepare("SELECT otp_enabled FROM ttrss_users WHERE id = ?"); $sth->execute([$_SESSION["uid"]]); if ($row = $sth->fetch()) { return sql_bool_to_bool($row["otp_enabled"]); } return false; } private function index_auth_2fa() { $otp_enabled = $this->is_otp_enabled(); if ($_SESSION["auth_module"] == "auth_internal") { if ($otp_enabled) { print_warning("One time passwords are currently enabled. Enter your current password below to disable."); ?>

" . __("Scan the following code by the Authenticator application or copy the key manually") . ""; $csrf_token_hash = sha1($_SESSION["csrf_token"]); print "otp qr-code"; } else { print_error("PHP GD functions are required to generate QR codes."); print "

" . __("Use the following OTP key with a compatible Authenticator application") . "

"; } $otp_secret = $this->otpsecret(); ?>

auth_internal authentication module."); } } private function index_auth() { ?>
index_auth_personal() ?>
index_auth_password() ?>
index_auth_app_passwords() ?>
index_auth_2fa() ?>
initialize_user_prefs($_SESSION["uid"], $profile); } else { $this->initialize_user_prefs($_SESSION["uid"]); } $prefs_available = []; $sth = $this->pdo->prepare("SELECT DISTINCT ttrss_user_prefs.pref_name,value,type_name, ttrss_prefs_sections.order_id, def_value,section_id FROM ttrss_prefs,ttrss_prefs_types,ttrss_prefs_sections,ttrss_user_prefs WHERE type_id = ttrss_prefs_types.id AND (profile = :profile OR (:profile IS NULL AND profile IS NULL)) AND section_id = ttrss_prefs_sections.id AND ttrss_user_prefs.pref_name = ttrss_prefs.pref_name AND owner_uid = :uid ORDER BY ttrss_prefs_sections.order_id,pref_name"); $sth->execute([":uid" => $_SESSION['uid'], ":profile" => $profile]); $listed_boolean_prefs = []; while ($line = $sth->fetch()) { if (in_array($line["pref_name"], $this->pref_blacklist)) { continue; } if ($profile && in_array($line["pref_name"], $this->profile_blacklist)) { continue; } $pref_name = $line["pref_name"]; $short_desc = $this->getShortDesc($pref_name); if (!$short_desc) continue; $prefs_available[$pref_name] = [ 'type_name' => $line["type_name"], 'value' => $line['value'], 'help_text' => $this->getHelpText($pref_name), 'short_desc' => $short_desc ]; } foreach (array_keys($this->pref_item_map) as $section) { print "

$section

"; foreach ($this->pref_item_map[$section] as $pref_name) { if ($pref_name == 'BLOCK_SEPARATOR' && !$profile) { print "
"; continue; } if ($pref_name == "DEFAULT_SEARCH_LANGUAGE" && DB_TYPE != "pgsql") { continue; } if (isset($prefs_available[$pref_name])) { $item = $prefs_available[$pref_name]; print "
"; print ""; $value = $item['value']; $type_name = $item['type_name']; if ($pref_name == "USER_LANGUAGE") { print_select_hash($pref_name, $value, get_translations(), "style='width : 220px; margin : 0px' dojoType='fox.form.Select'"); } else if ($pref_name == "USER_TIMEZONE") { $timezones = explode("\n", file_get_contents("lib/timezones.txt")); print_select($pref_name, $value, $timezones, 'dojoType="dijit.form.FilteringSelect"'); } else if ($pref_name == "BLACKLISTED_TAGS") { # TODO: other possible
"; print "
" . $this->pref_help_bottom[$pref_name] . "
"; print ""; } else if ($pref_name == "USER_CSS_THEME") { $themes = array_merge(glob("themes/*.php"), glob("themes/*.css"), glob("themes.local/*.css")); $themes = array_map("basename", $themes); $themes = array_filter($themes, "theme_exists"); asort($themes); if (!theme_exists($value)) $value = ""; print ""; print " "; print " "; } else if ($pref_name == "DEFAULT_UPDATE_INTERVAL") { global $update_intervals_nodefault; print_select_hash($pref_name, $value, $update_intervals_nodefault, 'dojoType="fox.form.Select"'); } else if ($pref_name == "DEFAULT_SEARCH_LANGUAGE") { print_select($pref_name, $value, Pref_Feeds::get_ts_languages(), 'dojoType="fox.form.Select"'); } else if ($type_name == "bool") { array_push($listed_boolean_prefs, $pref_name); $is_checked = ($value == "true") ? "checked=\"checked\"" : ""; if ($pref_name == "PURGE_UNREAD_ARTICLES" && FORCE_ARTICLE_PURGE != 0) { $is_disabled = "disabled=\"1\""; $is_checked = "checked=\"checked\""; } else { $is_disabled = ""; } print ""; } else if (in_array($pref_name, ['FRESH_ARTICLE_MAX_AGE', 'PURGE_OLD_DAYS', 'LONG_DATE_FORMAT', 'SHORT_DATE_FORMAT'])) { $regexp = ($type_name == 'integer') ? 'regexp="^\d*$"' : ''; if ($pref_name == "PURGE_OLD_DAYS" && FORCE_ARTICLE_PURGE != 0) { $is_disabled = "disabled='1'"; $value = FORCE_ARTICLE_PURGE; } else { $is_disabled = ""; } if ($type_name == 'integer') print ""; else print ""; } else if ($pref_name == "SSL_CERT_SERIAL") { print ""; $cert_serial = htmlspecialchars(get_ssl_certificate_id()); $has_serial = ($cert_serial) ? "false" : "true"; print ""; print ""; print ""; } else if ($pref_name == 'DIGEST_PREFERRED_TIME') { print ""; $item['help_text'] .= ". " . T_sprintf("Current server time: %s", date("H:i")); } else { $regexp = ($type_name == 'integer') ? 'regexp="^\d*$"' : ''; print ""; } if ($item['help_text']) print "
"; print "
"; } } } print_hidden("boolean_prefs", htmlspecialchars(join(",", $listed_boolean_prefs))); } private function index_prefs() { ?>
index_prefs_list() ?> run_hooks(PluginHost::HOOK_PREFS_TAB_SECTION, "prefPrefsPrefsInside") ?>
run_hooks(PluginHost::HOOK_PREFS_TAB_SECTION, "prefPrefsPrefsOutside") ?>
config.php for all users."); $system_enabled = array_map("trim", explode(",", (string)PLUGINS)); $tmppluginhost = new PluginHost(); $tmppluginhost->load_all($tmppluginhost::KIND_ALL, $_SESSION["uid"], true); foreach ($tmppluginhost->get_plugins() as $name => $plugin) { $about = $plugin->about(); if ($about[3] ?? false) { $is_checked = in_array($name, $system_enabled) ? "checked" : ""; ?>
load_all($tmppluginhost::KIND_ALL, $_SESSION["uid"], true); foreach ($tmppluginhost->get_plugins() as $name => $plugin) { $about = $plugin->about(); if (empty($about[3]) || $about[3] == false) { $is_checked = ""; $is_disabled = ""; if (in_array($name, $system_enabled)) { $is_checked = "checked='1'"; $is_disabled = "disabled='1'"; } else if (in_array($name, $user_enabled)) { $is_checked = "checked='1'"; } ?>
get_all($plugin)) > 0) { if (in_array($name, $system_enabled) || in_array($name, $user_enabled)) { ?>
get_hooks(PluginHost::HOOK_FEED_FETCHED), PluginHost::getInstance()->get_hooks(PluginHost::HOOK_FEED_PARSED), PluginHost::getInstance()->get_hooks(PluginHost::HOOK_FETCH_FEED)); $feed_handlers = array_filter($feed_handlers, function($plugin) use ($feed_handler_whitelist) { return in_array(get_class($plugin), $feed_handler_whitelist) === false; }); if (count($feed_handlers) > 0) { print_error( T_sprintf("The following plugins use per-feed content hooks. This may cause excessive data usage and origin server load resulting in a ban of your instance: %s" , implode(", ", array_map(function($plugin) { return get_class($plugin); }, $feed_handlers)) ) . " (".__("More info...").")" ); } ?>

index_plugins_system() ?>

index_plugins_user() ?>
index_auth() ?>
index_prefs() ?>
index_plugins() ?>
run_hooks(PluginHost::HOOK_PREFS_TAB, "prefPrefs") ?>
pdo->prepare("SELECT salt, otp_enabled FROM ttrss_users WHERE id = ?"); $sth->execute([$_SESSION['uid']]); if ($row = $sth->fetch()) { $otp_enabled = sql_bool_to_bool($row["otp_enabled"]); if (!$otp_enabled) { $base32 = new \OTPHP\Base32(); $secret = $base32->encode(mb_substr(sha1($row["salt"]), 0, 12), false); return $secret; } } return false; } function otpqrcode() { $csrf_token_hash = clean($_REQUEST["csrf_token_hash"]); if (sha1($_SESSION["csrf_token"]) === $csrf_token_hash) { require_once "lib/phpqrcode/phpqrcode.php"; $sth = $this->pdo->prepare("SELECT login FROM ttrss_users WHERE id = ?"); $sth->execute([$_SESSION['uid']]); if ($row = $sth->fetch()) { $secret = $this->otpsecret(); $login = $row['login']; if ($secret) { QRcode::png("otpauth://totp/".urlencode($login). "?secret=$secret&issuer=".urlencode("Tiny Tiny RSS")); } } } else { header("Content-Type: text/json"); print error_json(6); } } function otpenable() { $password = clean($_REQUEST["password"]); $otp = clean($_REQUEST["otp"]); $authenticator = PluginHost::getInstance()->get_plugin($_SESSION["auth_module"]); if ($authenticator->check_password($_SESSION["uid"], $password)) { $secret = $this->otpsecret(); if ($secret) { $base32 = new \OTPHP\Base32(); $topt = new \OTPHP\TOTP($secret); $otp_check = $topt->now(); if ($otp == $otp_check) { $sth = $this->pdo->prepare("UPDATE ttrss_users SET otp_enabled = true WHERE id = ?"); $sth->execute([$_SESSION['uid']]); print "OK"; } else { print "ERROR:".__("Incorrect one time password"); } } } else { print "ERROR:".__("Incorrect password"); } } static function isdefaultpassword() { $authenticator = PluginHost::getInstance()->get_plugin($_SESSION["auth_module"]); if ($authenticator && method_exists($authenticator, "check_password") && $authenticator->check_password($_SESSION["uid"], "password")) { return true; } return false; } function otpdisable() { $password = clean($_REQUEST["password"]); $authenticator = PluginHost::getInstance()->get_plugin($_SESSION["auth_module"]); if ($authenticator->check_password($_SESSION["uid"], $password)) { $sth = $this->pdo->prepare("SELECT email, login FROM ttrss_users WHERE id = ?"); $sth->execute([$_SESSION['uid']]); if ($row = $sth->fetch()) { $mailer = new Mailer(); $tpl = new Templator(); $tpl->readTemplateFromFile("otp_disabled_template.txt"); $tpl->setVariable('LOGIN', $row["login"]); $tpl->setVariable('TTRSS_HOST', SELF_URL_PATH); $tpl->addBlock('message'); $tpl->generateOutputToString($message); $mailer->mail(["to_name" => $row["login"], "to_address" => $row["email"], "subject" => "[tt-rss] OTP change notification", "message" => $message]); } $sth = $this->pdo->prepare("UPDATE ttrss_users SET otp_enabled = false WHERE id = ?"); $sth->execute([$_SESSION['uid']]); print "OK"; } else { print "ERROR: ".__("Incorrect password"); } } function setplugins() { if (is_array(clean($_REQUEST["plugins"]))) $plugins = join(",", clean($_REQUEST["plugins"])); else $plugins = ""; set_pref("_ENABLED_PLUGINS", $plugins); } function clearplugindata() { $name = clean($_REQUEST["name"]); PluginHost::getInstance()->clear_data(PluginHost::getInstance()->get_plugin($name)); } function customizeCSS() { $value = get_pref("USER_STYLESHEET"); $value = str_replace("
", "\n", $value); print json_encode(["value" => $value]); } function editPrefProfiles() { print "
"; print "
". "" . __('Select').""; print "
"; print "
".__('All')."
"; print "
".__('None')."
"; print "
"; print "
"; print "
"; print "
"; $sth = $this->pdo->prepare("SELECT title,id FROM ttrss_settings_profiles WHERE owner_uid = ? ORDER BY title"); $sth->execute([$_SESSION['uid']]); print "
"; print "
"; print ""; print ""; # data-row-id='0' <-- no point, shouldn't be removed print ""; if (!isset($_SESSION["profile"])) { $is_active = __("(active)"); } else { $is_active = ""; } print ""; print ""; while ($line = $sth->fetch()) { $profile_id = $line["id"]; print ""; $edit_title = htmlspecialchars($line["title"]); print ""; if (isset($_SESSION["profile"]) && $_SESSION["profile"] == $line["id"]) { $is_active = __("(active)"); } else { $is_active = ""; } print ""; print ""; } print "
" . __("Default profile") . " $is_active
" . $edit_title . " $is_active
"; print "
"; print ""; print "
"; } private function getShortDesc($pref_name) { if (isset($this->pref_help[$pref_name][0])) { return $this->pref_help[$pref_name][0]; } return ""; } private function getHelpText($pref_name) { if (isset($this->pref_help[$pref_name][1])) { return $this->pref_help[$pref_name][1]; } return ""; } private function appPasswordList() { ?>
pdo->prepare("SELECT id, title, created, last_used FROM ttrss_app_passwords WHERE owner_uid = ?"); $sth->execute([$_SESSION['uid']]); while ($row = $sth->fetch()) { ?> '>
pdo->prepare("DELETE FROM ttrss_app_passwords WHERE id IN ($ids_qmarks) AND owner_uid = ?"); $sth->execute(array_merge($ids, [$_SESSION['uid']])); $this->appPasswordList(); } function generateAppPassword() { $title = clean($_REQUEST['title']); $new_password = make_password(16); $new_password_hash = $this->encryptAppPassword($new_password); print_warning(T_sprintf("Generated password %s for %s. Please remember it for future reference.", $new_password, $title)); $sth = $this->pdo->prepare("INSERT INTO ttrss_app_passwords (title, pwd_hash, service, created, owner_uid) VALUES (?, ?, ?, NOW(), ?)"); $sth->execute([$title, $new_password_hash, Auth_Base::AUTH_SERVICE_API, $_SESSION['uid']]); $this->appPasswordList(); } static function initialize_user_prefs($uid, $profile = false) { if (get_schema_version() < 63) $profile_qpart = ""; $pdo = Db::pdo(); $in_nested_tr = false; try { $pdo->beginTransaction(); } catch (Exception $e) { $in_nested_tr = true; } $sth = $pdo->query("SELECT pref_name,def_value FROM ttrss_prefs"); if (!is_numeric($profile) || !$profile || get_schema_version() < 63) $profile = null; $u_sth = $pdo->prepare("SELECT pref_name FROM ttrss_user_prefs WHERE owner_uid = :uid AND (profile = :profile OR (:profile IS NULL AND profile IS NULL))"); $u_sth->execute([':uid' => $uid, ':profile' => $profile]); $active_prefs = array(); while ($line = $u_sth->fetch()) { array_push($active_prefs, $line["pref_name"]); } while ($line = $sth->fetch()) { if (array_search($line["pref_name"], $active_prefs) === false) { // print "adding " . $line["pref_name"] . "
"; if (get_schema_version() < 63) { $i_sth = $pdo->prepare("INSERT INTO ttrss_user_prefs (owner_uid,pref_name,value) VALUES (?, ?, ?)"); $i_sth->execute([$uid, $line["pref_name"], $line["def_value"]]); } else { $i_sth = $pdo->prepare("INSERT INTO ttrss_user_prefs (owner_uid,pref_name,value, profile) VALUES (?, ?, ?, ?)"); $i_sth->execute([$uid, $line["pref_name"], $line["def_value"], $profile]); } } } if (!$in_nested_tr) $pdo->commit(); } }