]>
git.wh0rd.org - tt-rss.git/blob - classes/db/prefs.php
4 private static $instance;
7 function __construct() {
8 $this->pdo
= Db
::pdo();
9 $this->cache
= array();
11 if ($_SESSION["uid"]) $this->cache();
14 private function __clone() {
18 public static function get() {
19 if (self
::$instance == null)
20 self
::$instance = new self();
22 return self
::$instance;
26 $user_id = $_SESSION["uid"];
27 @$profile = $_SESSION["profile"];
29 if (!$profile ||
get_schema_version() < 63) $profile = null;
31 $sth = $this->pdo
->prepare("SELECT
32 value,ttrss_prefs_types.type_name as type_name,ttrss_prefs.pref_name AS pref_name
34 ttrss_user_prefs,ttrss_prefs,ttrss_prefs_types
36 (profile = :profile OR (:profile IS NULL AND profile IS NULL)) AND
37 ttrss_prefs.pref_name NOT LIKE '_MOBILE%' AND
38 ttrss_prefs_types.id = type_id AND
40 ttrss_user_prefs.pref_name = ttrss_prefs.pref_name");
42 $sth->execute([":profile" => $profile, ":uid" => $user_id]);
44 while ($line = $sth->fetch()) {
45 if ($user_id == $_SESSION["uid"]) {
46 $pref_name = $line["pref_name"];
48 $this->cache
[$pref_name]["type"] = $line["type_name"];
49 $this->cache
[$pref_name]["value"] = $line["value"];
54 function read($pref_name, $user_id = false, $die_on_error = false) {
59 $user_id = $_SESSION["uid"];
60 @$profile = $_SESSION["profile"];
62 $user_id = sprintf("%d", $user_id);
65 if (isset($this->cache
[$pref_name]) && !$user_id) {
66 $tuple = $this->cache
[$pref_name];
67 return $this->convert($tuple["value"], $tuple["type"]);
70 if (!$profile ||
get_schema_version() < 63) $profile = null;
72 $sth = $this->pdo
->prepare("SELECT
73 value,ttrss_prefs_types.type_name as type_name
75 ttrss_user_prefs,ttrss_prefs,ttrss_prefs_types
77 (profile = :profile OR (:profile IS NULL AND profile IS NULL)) AND
78 ttrss_user_prefs.pref_name = :pref_name AND
79 ttrss_prefs_types.id = type_id AND
81 ttrss_user_prefs.pref_name = ttrss_prefs.pref_name");
82 $sth->execute([":uid" => $user_id, ":profile" => $profile, ":pref_name" => $pref_name]);
84 if ($row = $sth->fetch()) {
85 $value = $row["value"];
86 $type_name = $row["type_name"];
88 if ($user_id == $_SESSION["uid"]) {
89 $this->cache
[$pref_name]["type"] = $type_name;
90 $this->cache
[$pref_name]["value"] = $value;
93 return $this->convert($value, $type_name);
96 user_error("Fatal error, unknown preferences key: $pref_name (owner: $user_id)", $die_on_error ? E_USER_ERROR
: E_USER_WARNING
);
101 function convert($value, $type_name) {
102 if ($type_name == "bool") {
103 return $value == "true";
104 } else if ($type_name == "integer") {
111 function write($pref_name, $value, $user_id = false, $strip_tags = true) {
112 if ($strip_tags) $value = strip_tags($value);
115 $user_id = $_SESSION["uid"];
116 @$profile = $_SESSION["profile"];
118 $user_id = sprintf("%d", $user_id);
122 $profile_qpart = "AND profile = '$profile'";
124 $profile_qpart = "AND profile IS NULL";
127 if (!$profile ||
get_schema_version() < 63) $profile = null;
132 if (isset($this->cache
[$pref_name])) {
133 $type_name = $this->cache
[$pref_name]["type"];
134 $current_value = $this->cache
[$pref_name]["value"];
138 $sth = $this->pdo
->prepare("SELECT type_name
139 FROM ttrss_prefs,ttrss_prefs_types
140 WHERE pref_name = ? AND type_id = ttrss_prefs_types.id");
141 $sth->execute([$pref_name]);
143 if ($row = $sth->fetch())
144 $type_name = $row["type_name"];
146 } else if ($current_value == $value) {
151 if ($type_name == "bool") {
152 if ($value == "1" ||
$value == "true") {
157 } else if ($type_name == "integer") {
158 $value = sprintf("%d", $value);
161 if ($pref_name == 'USER_TIMEZONE' && $value == '') {
165 $sth = $this->pdo
->prepare("UPDATE ttrss_user_prefs SET
166 value = :value WHERE pref_name = :pref_name
167 AND (profile = :profile OR (:profile IS NULL AND profile IS NULL))
168 AND owner_uid = :uid");
170 $sth->execute([":pref_name" => $pref_name, ":value" => $value, ":uid" => $user_id, ":profile" => $profile]);
172 if ($user_id == $_SESSION["uid"]) {
173 $this->cache
[$pref_name]["type"] = $type_name;
174 $this->cache
[$pref_name]["value"] = $value;