]>
git.wh0rd.org - tt-rss.git/blob - modules/pref-prefs.php
2 function module_pref_prefs($link) {
3 $subop = $_REQUEST["subop"];
5 if ($subop == "Save configuration") {
8 header("Location: prefs.php");
12 $_SESSION["prefs_op_result"] = "save-config";
14 $_SESSION["prefs_cache"] = false;
16 foreach (array_keys($_POST) as $pref_name) {
18 $pref_name = db_escape_string($pref_name);
19 $value = db_escape_string($_POST[$pref_name]);
21 $result = db_query($link, "SELECT type_name
22 FROM ttrss_prefs,ttrss_prefs_types
23 WHERE pref_name = '$pref_name' AND type_id = ttrss_prefs_types.id");
25 if (db_num_rows($result) > 0) {
27 $type_name = db_fetch_result($result, 0, "type_name");
29 // print "$pref_name : $type_name : $value<br>";
31 if ($type_name == "bool") {
37 } else if ($type_name == "integer") {
38 $value = sprintf("%d", $value);
41 // print "$pref_name : $type_name : $value<br>";
43 db_query($link, "UPDATE ttrss_user_prefs SET value = '$value'
44 WHERE pref_name = '$pref_name' AND owner_uid = ".$_SESSION["uid"]);
48 header("Location: prefs.php");
52 } else if ($subop == "getHelp") {
54 $pref_name = db_escape_string($_GET["pn"]);
56 $result = db_query($link, "SELECT help_text FROM ttrss_prefs
57 WHERE pref_name = '$pref_name'");
59 if (db_num_rows($result) > 0) {
60 $help_text = db_fetch_result($result, 0, "help_text");
63 print "Unknown option: $pref_name";
66 } else if ($subop == "Change e-mail") {
69 header("Location: prefs.php");
73 $email = db_escape_string($_GET["email"]);
74 $active_uid = $_SESSION["uid"];
77 db_query($link, "UPDATE ttrss_users SET email = '$email'
78 WHERE id = '$active_uid'");
81 header("Location: prefs.php");
83 } else if ($subop == "Change password") {
86 header("Location: prefs.php");
90 $old_pw = $_POST["OLD_PASSWORD"];
91 $new_pw = $_POST["OLD_PASSWORD"];
93 $old_pw_hash = 'SHA1:' . sha1($_POST["OLD_PASSWORD"]);
94 $new_pw_hash = 'SHA1:' . sha1($_POST["NEW_PASSWORD"]);
96 $active_uid = $_SESSION["uid"];
98 if ($old_pw && $new_pw) {
100 $login = db_escape_string($_SERVER['PHP_AUTH_USER']);
102 $result = db_query($link, "SELECT id FROM ttrss_users WHERE
103 id = '$active_uid' AND (pwd_hash = '$old_pw' OR
104 pwd_hash = '$old_pw_hash')");
106 if (db_num_rows($result) == 1) {
107 db_query($link, "UPDATE ttrss_users SET pwd_hash = '$new_pw_hash'
108 WHERE id = '$active_uid'");
110 $_SESSION["pwd_change_result"] = "ok";
112 $_SESSION["pwd_change_result"] = "failed";
116 header("Location: prefs.php");
118 } else if ($subop == "Reset to defaults") {
121 header("Location: prefs.php");
125 $_SESSION["prefs_op_result"] = "reset-to-defaults";
127 if (DB_TYPE
== "pgsql") {
128 db_query($link,"UPDATE ttrss_user_prefs
129 SET value = ttrss_prefs.def_value
130 WHERE owner_uid = '".$_SESSION["uid"]."' AND
131 ttrss_prefs.pref_name = ttrss_user_prefs.pref_name");
133 db_query($link, "DELETE FROM ttrss_user_prefs
134 WHERE owner_uid = ".$_SESSION["uid"]);
135 initialize_user_prefs($link, $_SESSION["uid"]);
138 header("Location: prefs.php");
140 } else if ($subop == "Change theme") {
142 $theme = db_escape_string($_POST["theme"]);
144 if ($theme == "Default") {
145 $theme_qpart = 'NULL';
147 $theme_qpart = "'$theme'";
150 $result = db_query($link, "SELECT id,theme_path FROM ttrss_themes
151 WHERE theme_name = '$theme'");
153 if (db_num_rows($result) == 1) {
154 $theme_id = db_fetch_result($result, 0, "id");
155 $theme_path = db_fetch_result($result, 0, "theme_path");
161 db_query($link, "UPDATE ttrss_users SET
162 theme_id = $theme_id WHERE id = " . $_SESSION["uid"]);
164 $_SESSION["theme"] = $theme_path;
166 header("Location: prefs.php");
170 print check_for_update($link);
172 if (!SINGLE_USER_MODE
) {
174 $result = db_query($link, "SELECT id,email FROM ttrss_users
175 WHERE id = ".$_SESSION["uid"]." AND (pwd_hash = 'password' OR
176 pwd_hash = 'SHA1:".sha1("password")."')");
178 if (db_num_rows($result) != 0) {
179 print "<div class=\"warning\">
180 Your password is at default value, please change it.
184 if ($_SESSION["pwd_change_result"] == "failed") {
185 print "<div class=\"warning\">
186 There was an error while changing your password.
190 if ($_SESSION["pwd_change_result"] == "ok") {
191 print "<div class=\"notice\">
192 Password changed successfully.
196 $_SESSION["pwd_change_result"] = "";
198 if ($_SESSION["prefs_op_result"] == "reset-to-defaults") {
199 print "<div class=\"notice\">
200 Your configuration was reset to defaults.
204 if ($_SESSION["prefs_op_result"] == "save-config") {
205 print "<div class=\"notice\">
206 Your configuration was saved successfully.
210 $_SESSION["prefs_op_result"] = "";
212 print "<form action=\"backend.php\" method=\"GET\">";
214 print "<table width=\"100%\" class=\"prefPrefsList\">";
215 print "<tr><td colspan='3'><h3>Personal data</h3></tr></td>";
217 $result = db_query($link, "SELECT email FROM ttrss_users
218 WHERE id = ".$_SESSION["uid"]);
220 $email = db_fetch_result($result, 0, "email");
222 print "<tr><td width=\"40%\">E-mail</td>";
223 print "<td><input class=\"editbox\" name=\"email\"
224 value=\"$email\"></td></tr>";
228 print "<input type=\"hidden\" name=\"op\" value=\"pref-prefs\">";
230 print "<p><input class=\"button\" type=\"submit\"
231 value=\"Change e-mail\" name=\"subop\">";
235 print "<form action=\"backend.php\" method=\"POST\" name=\"changePassForm\">";
237 print "<table width=\"100%\" class=\"prefPrefsList\">";
238 print "<tr><td colspan='3'><h3>Authentication</h3></tr></td>";
240 print "<tr><td width=\"40%\">Old password</td>";
241 print "<td><input class=\"editbox\" type=\"password\"
242 name=\"OLD_PASSWORD\"></td></tr>";
244 print "<tr><td width=\"40%\">New password</td>";
246 print "<td><input class=\"editbox\" type=\"password\"
247 name=\"NEW_PASSWORD\"></td></tr>";
251 print "<input type=\"hidden\" name=\"op\" value=\"pref-prefs\">";
253 print "<p><input class=\"button\" type=\"submit\"
254 onclick=\"return validateNewPassword(this.form)\"
255 value=\"Change password\" name=\"subop\">";
261 $result = db_query($link, "SELECT
262 theme_id FROM ttrss_users WHERE id = " . $_SESSION["uid"]);
264 $user_theme_id = db_fetch_result($result, 0, "theme_id");
266 $result = db_query($link, "SELECT
267 id,theme_name FROM ttrss_themes ORDER BY theme_name");
269 if (db_num_rows($result) > 0) {
271 print "<form action=\"backend.php\" method=\"POST\">";
272 print "<table width=\"100%\" class=\"prefPrefsList\">";
273 print "<tr><td colspan='3'><h3>Themes</h3></tr></td>";
274 print "<tr><td width=\"40%\">Select theme</td>";
275 print "<td><select name=\"theme\">";
276 print "<option>Default</option>";
277 print "<option disabled>--------</option>";
279 while ($line = db_fetch_assoc($result)) {
280 if ($line["id"] == $user_theme_id) {
281 $selected = "selected";
285 print "<option $selected>" . $line["theme_name"] . "</option>";
287 print "</select></td></tr>";
289 print "<input type=\"hidden\" name=\"op\" value=\"pref-prefs\">";
290 print "<p><input class=\"button\" type=\"submit\"
291 value=\"Change theme\" name=\"subop\">";
295 initialize_user_prefs($link, $_SESSION["uid"]);
297 $result = db_query($link, "SELECT
298 ttrss_user_prefs.pref_name,short_desc,help_text,value,type_name,
299 section_name,def_value
300 FROM ttrss_prefs,ttrss_prefs_types,ttrss_prefs_sections,ttrss_user_prefs
301 WHERE type_id = ttrss_prefs_types.id AND
302 section_id = ttrss_prefs_sections.id AND
303 ttrss_user_prefs.pref_name = ttrss_prefs.pref_name AND
304 owner_uid = ".$_SESSION["uid"]."
305 ORDER BY section_id,short_desc");
307 print "<form action=\"backend.php\" method=\"POST\">";
311 $active_section = "";
313 while ($line = db_fetch_assoc($result)) {
315 if ($active_section != $line["section_name"]) {
317 if ($active_section != "") {
321 print "<p><table width=\"100%\" class=\"prefPrefsList\">";
323 $active_section = $line["section_name"];
325 print "<tr><td colspan=\"3\"><h3>$active_section</h3></td></tr>";
326 // print "<tr class=\"title\">
327 // <td width=\"25%\">Option</td><td>Value</td></tr>";
332 // $class = ($lnum % 2) ? "even" : "odd";
336 $type_name = $line["type_name"];
337 $pref_name = $line["pref_name"];
338 $value = $line["value"];
339 $def_value = $line["def_value"];
340 $help_text = $line["help_text"];
342 print "<td width=\"40%\" id=\"$pref_name\">" . $line["short_desc"];
344 if ($help_text) print "<div class=\"prefHelp\">$help_text</div>";
350 if ($type_name == "bool") {
351 // print_select($pref_name, $value, array("true", "false"));
353 if ($value == "true") {
359 print_radio($pref_name, $value, array("Yes", "No"));
362 print "<input class=\"editbox\" name=\"$pref_name\" value=\"$value\">";
374 print "<input type=\"hidden\" name=\"op\" value=\"pref-prefs\">";
376 print "<p><input class=\"button\" type=\"submit\"
377 name=\"subop\" value=\"Save configuration\">";
379 print " <input class=\"button\" type=\"submit\"
380 name=\"subop\" onclick=\"return validatePrefsReset()\"
381 value=\"Reset to defaults\"></p>";