From f8836ec08065f8c9c0d67611aaa0705bfc9edf96 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <noreply@fakecake.org>
Date: Wed, 20 Feb 2019 15:12:37 +0300
Subject: search dialog fixes pgsql: get FTS languages list from the database

---
 classes/pref/feeds.php | 23 ++++++++++++++++++-----
 1 file changed, 18 insertions(+), 5 deletions(-)

(limited to 'classes/pref')

diff --git a/classes/pref/feeds.php b/classes/pref/feeds.php
index 042905c6f..12f7d9f71 100755
--- a/classes/pref/feeds.php
+++ b/classes/pref/feeds.php
@@ -1,8 +1,5 @@
 <?php
 class Pref_Feeds extends Handler_Protected {
-	public static $feed_languages = array("English", "Danish", "Dutch", "Finnish", "French", "German", "Hungarian", "Italian", "Norwegian",
-		"Portuguese", "Russian", "Spanish", "Swedish", "Turkish", "Simple");
-
 	function csrf_ignore($method) {
 		$csrf_ignored = array("index", "getfeedtree", "add", "editcats", "editfeed",
 			"savefeedorder", "uploadicon", "feedswitherrors", "inactivefeeds",
@@ -11,6 +8,22 @@ class Pref_Feeds extends Handler_Protected {
 		return array_search($method, $csrf_ignored) !== false;
 	}
 
+	public static function get_ts_languages() {
+		$rv = [];
+
+		if (DB_TYPE == "pgsql") {
+			$dbh = Db::pdo();
+
+			$res = $dbh->query("SELECT cfgname FROM pg_ts_config");
+
+			while ($row = $res->fetch()) {
+				array_push($rv, ucfirst($row['cfgname']));
+			}
+		}
+
+		return $rv;
+	}
+
 	function batch_edit_cbox($elem, $label = false) {
 		print "<input type=\"checkbox\" title=\"".__("Check to enable field")."\"
 			onchange=\"dijit.byId('feedEditDlg').toggleField(this, '$elem', '$label')\">";
@@ -590,7 +603,7 @@ class Pref_Feeds extends Handler_Protected {
 				print "<fieldset>";
 
 				print "<label>" . __('Language:') . "</label> ";
-				print_select("feed_language", $feed_language, $this::$feed_languages,
+				print_select("feed_language", $feed_language, $this::get_ts_languages(),
 					'dojoType="dijit.form.Select"');
 
 				print "</fieldset>";
@@ -859,7 +872,7 @@ class Pref_Feeds extends Handler_Protected {
 			print "<fieldset>";
 
 			print "<label>" . __('Language:') . "</label> ";
-			print_select("feed_language", "", $this::$feed_languages,
+			print_select("feed_language", "", $this::get_ts_languages(),
 				'disabled="1" dojoType="dijit.form.Select"');
 
 			$this->batch_edit_cbox("feed_language");
-- 
cgit v1.2.3