FROM
ttrss_user_prefs,ttrss_prefs,ttrss_prefs_types
WHERE
- profile = :profile OR (:profile IS NULL AND profile IS NULL) AND
+ (profile = :profile OR (:profile IS NULL AND profile IS NULL)) AND
ttrss_prefs.pref_name NOT LIKE '_MOBILE%' AND
ttrss_prefs_types.id = type_id AND
owner_uid = :uid AND
function read($pref_name, $user_id = false, $die_on_error = false) {
- $profile = false;
-
if (!$user_id) {
$user_id = $_SESSION["uid"];
@$profile = $_SESSION["profile"];
} else {
- $user_id = sprintf("%d", $user_id);
+ $profile = false;
}
- if (isset($this->cache[$pref_name]) && !$user_id) {
+ if ($user_id == $_SESSION['uid'] && isset($this->cache[$pref_name])) {
$tuple = $this->cache[$pref_name];
return $this->convert($tuple["value"], $tuple["type"]);
}
FROM
ttrss_user_prefs,ttrss_prefs,ttrss_prefs_types
WHERE
- profile = :profile OR (:profile IS NULL AND profile IS NULL) AND
+ (profile = :profile OR (:profile IS NULL AND profile IS NULL)) AND
ttrss_user_prefs.pref_name = :pref_name AND
ttrss_prefs_types.id = type_id AND
owner_uid = :uid AND
if (!$user_id) {
$user_id = $_SESSION["uid"];
@$profile = $_SESSION["profile"];
- } else {
- $user_id = sprintf("%d", $user_id);
- }
-
- if ($profile) {
- $profile_qpart = "AND profile = '$profile'";
- } else {
- $profile_qpart = "AND profile IS NULL";
}
if (!$profile || get_schema_version() < 63) $profile = null;
$value = "false";
}
} else if ($type_name == "integer") {
- $value = sprintf("%d", $value);
+ $value = (int)$value;
}
if ($pref_name == 'USER_TIMEZONE' && $value == '') {