From 0a117b86b0d5dc4b77d0f13f0fd865fe97693d59 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.volgo-balt.ru>
Date: Wed, 27 Feb 2013 15:47:29 +0400
Subject: [PATCH] cache all db prefs on startup

---
 include/db-prefs.php  | 35 +++++++++++++++++++++++++++++++++++
 include/functions.php |  2 ++
 2 files changed, 37 insertions(+)

diff --git a/include/db-prefs.php b/include/db-prefs.php
index 696aae5d..641e9d1d 100644
--- a/include/db-prefs.php
+++ b/include/db-prefs.php
@@ -7,6 +7,41 @@
 			$_SESSION["prefs_cache"] = array();
 	}
 
+	function cache_prefs($link) {
+		$profile = false;
+
+		$user_id = $_SESSION["uid"];
+		@$profile = $_SESSION["profile"];
+
+		if ($profile) {
+			$profile_qpart = "profile = '$profile' AND";
+		} else {
+			$profile_qpart = "profile IS NULL AND";
+		}
+
+		if (get_schema_version($link) < 63) $profile_qpart = "";
+
+		$result = db_query($link, "SELECT
+			value,ttrss_prefs_types.type_name as type_name,ttrss_prefs.pref_name AS pref_name
+			FROM
+				ttrss_user_prefs,ttrss_prefs,ttrss_prefs_types
+			WHERE
+				$profile_qpart
+				ttrss_prefs.pref_name NOT LIKE '_MOBILE%' AND
+				ttrss_prefs_types.id = type_id AND
+				owner_uid = '$user_id' AND
+				ttrss_user_prefs.pref_name = ttrss_prefs.pref_name");
+
+		while ($line = db_fetch_assoc($result)) {
+			if ($user_id == $_SESSION["uid"]) {
+				$pref_name = $line["pref_name"];
+
+				$_SESSION["prefs_cache"][$pref_name]["type"] = $line["type_name"];
+				$_SESSION["prefs_cache"][$pref_name]["value"] = $line["value"];
+			}
+		}
+	}
+
 	function get_pref($link, $pref_name, $user_id = false, $die_on_error = false) {
 
 		$pref_name = db_escape_string($pref_name);
diff --git a/include/functions.php b/include/functions.php
index d153f9c1..d6c73343 100644
--- a/include/functions.php
+++ b/include/functions.php
@@ -740,6 +740,7 @@
 
 		if (SINGLE_USER_MODE) {
 			authenticate_user($link, "admin", null);
+			cache_prefs($link);
 			load_user_plugins($link, $_SESSION["uid"]);
 		} else {
 			if (!$_SESSION["uid"] || !validate_session($link)) {
@@ -764,6 +765,7 @@
 			}
 
 			if ($_SESSION["uid"]) {
+				cache_prefs($link);
 				load_user_plugins($link, $_SESSION["uid"]);
 			}
 		}
-- 
2.39.5