]>
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) {
57 $user_id = $_SESSION["uid"];
58 @$profile = $_SESSION["profile"];
63 if ($user_id == $_SESSION['uid'] && isset($this->cache
[$pref_name])) {
64 $tuple = $this->cache
[$pref_name];
65 return $this->convert($tuple["value"], $tuple["type"]);
68 if (!$profile ||
get_schema_version() < 63) $profile = null;
70 $sth = $this->pdo
->prepare("SELECT
71 value,ttrss_prefs_types.type_name as type_name
73 ttrss_user_prefs,ttrss_prefs,ttrss_prefs_types
75 (profile = :profile OR (:profile IS NULL AND profile IS NULL)) AND
76 ttrss_user_prefs.pref_name = :pref_name AND
77 ttrss_prefs_types.id = type_id AND
79 ttrss_user_prefs.pref_name = ttrss_prefs.pref_name");
80 $sth->execute([":uid" => $user_id, ":profile" => $profile, ":pref_name" => $pref_name]);
82 if ($row = $sth->fetch()) {
83 $value = $row["value"];
84 $type_name = $row["type_name"];
86 if ($user_id == $_SESSION["uid"]) {
87 $this->cache
[$pref_name]["type"] = $type_name;
88 $this->cache
[$pref_name]["value"] = $value;
91 return $this->convert($value, $type_name);
94 user_error("Fatal error, unknown preferences key: $pref_name (owner: $user_id)", $die_on_error ? E_USER_ERROR
: E_USER_WARNING
);
99 function convert($value, $type_name) {
100 if ($type_name == "bool") {
101 return $value == "true";
102 } else if ($type_name == "integer") {
109 function write($pref_name, $value, $user_id = false, $strip_tags = true) {
110 if ($strip_tags) $value = strip_tags($value);
113 $user_id = $_SESSION["uid"];
114 @$profile = $_SESSION["profile"];
117 if (!$profile ||
get_schema_version() < 63) $profile = null;
122 if (isset($this->cache
[$pref_name])) {
123 $type_name = $this->cache
[$pref_name]["type"];
124 $current_value = $this->cache
[$pref_name]["value"];
128 $sth = $this->pdo
->prepare("SELECT type_name
129 FROM ttrss_prefs,ttrss_prefs_types
130 WHERE pref_name = ? AND type_id = ttrss_prefs_types.id");
131 $sth->execute([$pref_name]);
133 if ($row = $sth->fetch())
134 $type_name = $row["type_name"];
136 } else if ($current_value == $value) {
141 if ($type_name == "bool") {
142 if ($value == "1" ||
$value == "true") {
147 } else if ($type_name == "integer") {
148 $value = (int)$value;
151 if ($pref_name == 'USER_TIMEZONE' && $value == '') {
155 $sth = $this->pdo
->prepare("UPDATE ttrss_user_prefs SET
156 value = :value WHERE pref_name = :pref_name
157 AND (profile = :profile OR (:profile IS NULL AND profile IS NULL))
158 AND owner_uid = :uid");
160 $sth->execute([":pref_name" => $pref_name, ":value" => $value, ":uid" => $user_id, ":profile" => $profile]);
162 if ($user_id == $_SESSION["uid"]) {
163 $this->cache
[$pref_name]["type"] = $type_name;
164 $this->cache
[$pref_name]["value"] = $value;