]>
Commit | Line | Data |
---|---|---|
1d3a17c7 | 1 | <?php |
3bac89ad AD |
2 | require_once "config.php"; |
3 | require_once "db.php"; | |
4 | ||
61c1812f | 5 | if (!defined('DISABLE_SESSIONS') && !defined('PREFS_NO_CACHE')) { |
de696427 AD |
6 | if (!$_SESSION["prefs_cache"]) |
7 | $_SESSION["prefs_cache"] = array(); | |
8 | } | |
11de82c3 | 9 | |
0a117b86 AD |
10 | function cache_prefs($link) { |
11 | $profile = false; | |
12 | ||
13 | $user_id = $_SESSION["uid"]; | |
14 | @$profile = $_SESSION["profile"]; | |
15 | ||
16 | if ($profile) { | |
17 | $profile_qpart = "profile = '$profile' AND"; | |
18 | } else { | |
19 | $profile_qpart = "profile IS NULL AND"; | |
20 | } | |
21 | ||
22 | if (get_schema_version($link) < 63) $profile_qpart = ""; | |
23 | ||
24 | $result = db_query($link, "SELECT | |
25 | value,ttrss_prefs_types.type_name as type_name,ttrss_prefs.pref_name AS pref_name | |
26 | FROM | |
27 | ttrss_user_prefs,ttrss_prefs,ttrss_prefs_types | |
28 | WHERE | |
29 | $profile_qpart | |
30 | ttrss_prefs.pref_name NOT LIKE '_MOBILE%' AND | |
31 | ttrss_prefs_types.id = type_id AND | |
32 | owner_uid = '$user_id' AND | |
33 | ttrss_user_prefs.pref_name = ttrss_prefs.pref_name"); | |
34 | ||
35 | while ($line = db_fetch_assoc($result)) { | |
36 | if ($user_id == $_SESSION["uid"]) { | |
37 | $pref_name = $line["pref_name"]; | |
38 | ||
39 | $_SESSION["prefs_cache"][$pref_name]["type"] = $line["type_name"]; | |
40 | $_SESSION["prefs_cache"][$pref_name]["value"] = $line["value"]; | |
41 | } | |
42 | } | |
43 | } | |
44 | ||
b4c27af7 | 45 | function get_pref($link, $pref_name, $user_id = false, $die_on_error = false) { |
3bac89ad AD |
46 | |
47 | $pref_name = db_escape_string($pref_name); | |
70364a42 | 48 | $prefs_cache = true; |
c3fddd05 | 49 | $profile = false; |
3bac89ad | 50 | |
a2770077 AD |
51 | if (!$user_id) { |
52 | $user_id = $_SESSION["uid"]; | |
c3fddd05 | 53 | @$profile = $_SESSION["profile"]; |
a2770077 AD |
54 | } else { |
55 | $user_id = sprintf("%d", $user_id); | |
c648997b | 56 | //$prefs_cache = false; |
11de82c3 | 57 | } |
658e1cc1 | 58 | |
61c1812f | 59 | if ($prefs_cache && !defined('DISABLE_SESSIONS') && !defined('PREFS_NO_CACHE')) { |
7d96bfcd AD |
60 | if ($_SESSION["prefs_cache"] && @$_SESSION["prefs_cache"][$pref_name]) { |
61 | $tuple = $_SESSION["prefs_cache"][$pref_name]; | |
62 | return convert_pref_type($tuple["value"], $tuple["type"]); | |
63 | } | |
64 | } | |
65 | ||
d9084cf2 | 66 | if ($profile) { |
f9aa6a89 | 67 | $profile_qpart = "profile = '$profile' AND"; |
d9084cf2 | 68 | } else { |
f9aa6a89 | 69 | $profile_qpart = "profile IS NULL AND"; |
d9084cf2 AD |
70 | } |
71 | ||
f9aa6a89 | 72 | if (get_schema_version($link) < 63) $profile_qpart = ""; |
d9084cf2 | 73 | |
7d96bfcd AD |
74 | $result = db_query($link, "SELECT |
75 | value,ttrss_prefs_types.type_name as type_name | |
76 | FROM | |
ff485f1d | 77 | ttrss_user_prefs,ttrss_prefs,ttrss_prefs_types |
7d96bfcd | 78 | WHERE |
f9aa6a89 | 79 | $profile_qpart |
7d96bfcd | 80 | ttrss_user_prefs.pref_name = '$pref_name' AND |
ff485f1d | 81 | ttrss_prefs_types.id = type_id AND |
a2770077 | 82 | owner_uid = '$user_id' AND |
ff485f1d | 83 | ttrss_user_prefs.pref_name = ttrss_prefs.pref_name"); |
3bac89ad AD |
84 | |
85 | if (db_num_rows($result) > 0) { | |
86 | $value = db_fetch_result($result, 0, "value"); | |
4062022e AD |
87 | $type_name = db_fetch_result($result, 0, "type_name"); |
88 | ||
afba49c3 AD |
89 | if (!defined('DISABLE_SESSIONS')) { |
90 | if ($user_id == $_SESSION["uid"]) { | |
658e1cc1 AD |
91 | $_SESSION["prefs_cache"][$pref_name]["type"] = $type_name; |
92 | $_SESSION["prefs_cache"][$pref_name]["value"] = $value; | |
93 | } | |
4062022e | 94 | } |
658e1cc1 | 95 | |
dc0c8985 | 96 | return convert_pref_type($value, $type_name); |
7d96bfcd AD |
97 | |
98 | } else { | |
1e107b0f AD |
99 | if ($die_on_error) { |
100 | die("Fatal error, unknown preferences key: $pref_name"); | |
101 | } else { | |
102 | return null; | |
103 | } | |
3bac89ad AD |
104 | } |
105 | } | |
106 | ||
dc0c8985 | 107 | function convert_pref_type($value, $type_name) { |
7d96bfcd AD |
108 | if ($type_name == "bool") { |
109 | return $value == "true"; | |
110 | } else if ($type_name == "integer") { | |
111 | return sprintf("%d", $value); | |
dc0c8985 AD |
112 | } else { |
113 | return $value; | |
114 | } | |
115 | } | |
7f123cda | 116 | |
0380cfa9 | 117 | function set_pref($link, $pref_name, $value, $user_id = false, $strip_tags = true) { |
afba49c3 | 118 | $pref_name = db_escape_string($pref_name); |
0380cfa9 | 119 | $value = db_escape_string($value, $strip_tags); |
7f123cda | 120 | |
d9084cf2 AD |
121 | if (!$user_id) { |
122 | $user_id = $_SESSION["uid"]; | |
c3fddd05 | 123 | @$profile = $_SESSION["profile"]; |
d9084cf2 AD |
124 | } else { |
125 | $user_id = sprintf("%d", $user_id); | |
126 | $prefs_cache = false; | |
127 | } | |
128 | ||
129 | if ($profile) { | |
f9aa6a89 | 130 | $profile_qpart = "AND profile = '$profile'"; |
d9084cf2 | 131 | } else { |
b1242797 | 132 | $profile_qpart = "AND profile IS NULL"; |
d9084cf2 AD |
133 | } |
134 | ||
f9aa6a89 AD |
135 | if (get_schema_version($link) < 63) $profile_qpart = ""; |
136 | ||
afba49c3 AD |
137 | $type_name = ""; |
138 | $current_value = ""; | |
e9105eb5 | 139 | |
61c1812f | 140 | if (!defined('DISABLE_SESSIONS') && !defined('PREFS_NO_CACHE')) { |
afba49c3 AD |
141 | if ($_SESSION["prefs_cache"] && @$_SESSION["prefs_cache"][$pref_name]) { |
142 | $type_name = $_SESSION["prefs_cache"][$pref_name]["type"]; | |
143 | $current_value = $_SESSION["prefs_cache"][$pref_name]["value"]; | |
144 | } | |
145 | } | |
e9105eb5 | 146 | |
afba49c3 AD |
147 | if (!$type_name) { |
148 | $result = db_query($link, "SELECT type_name | |
149 | FROM ttrss_prefs,ttrss_prefs_types | |
150 | WHERE pref_name = '$pref_name' AND type_id = ttrss_prefs_types.id"); | |
151 | ||
152 | if (db_num_rows($result) > 0) | |
153 | $type_name = db_fetch_result($result, 0, "type_name"); | |
154 | } else if ($current_value == $value) { | |
155 | return; | |
156 | } | |
e9105eb5 | 157 | |
afba49c3 | 158 | if ($type_name) { |
e9105eb5 AD |
159 | if ($type_name == "bool") { |
160 | if ($value == "1" || $value == "true") { | |
161 | $value = "true"; | |
162 | } else { | |
163 | $value = "false"; | |
164 | } | |
165 | } else if ($type_name == "integer") { | |
166 | $value = sprintf("%d", $value); | |
167 | } | |
168 | ||
afba49c3 | 169 | if ($pref_name == 'DEFAULT_ARTICLE_LIMIT' && $value == 0) { |
e9105eb5 AD |
170 | $value = 30; |
171 | } | |
172 | ||
afba49c3 | 173 | if ($pref_name == 'USER_TIMEZONE' && $value == '') { |
ec39f07a AD |
174 | $value = 'UTC'; |
175 | } | |
176 | ||
7d96bfcd | 177 | db_query($link, "UPDATE ttrss_user_prefs SET |
afba49c3 | 178 | value = '$value' WHERE pref_name = '$pref_name' |
f9aa6a89 | 179 | $profile_qpart |
e9105eb5 | 180 | AND owner_uid = " . $_SESSION["uid"]); |
7f123cda | 181 | |
afba49c3 AD |
182 | if (!defined('DISABLE_SESSIONS')) { |
183 | if ($user_id == $_SESSION["uid"]) { | |
c648997b AD |
184 | $_SESSION["prefs_cache"][$pref_name]["type"] = $type_name; |
185 | $_SESSION["prefs_cache"][$pref_name]["value"] = $value; | |
186 | } | |
187 | } | |
e9105eb5 | 188 | } |
7f123cda | 189 | } |
3bac89ad | 190 | ?> |