From 79ec0f2f4c48e131972349d5289ee9da526cb2fa Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
Date: Sun, 20 Aug 2006 14:54:54 +0100
Subject: [PATCH] sortable user editor

---
 backend.php | 14 ++++++++++----
 prefs.js    |  5 +++--
 2 files changed, 13 insertions(+), 6 deletions(-)

diff --git a/backend.php b/backend.php
index 5a372586..fc36d2e0 100644
--- a/backend.php
+++ b/backend.php
@@ -3384,6 +3384,12 @@
 			}
 		}
 
+		$sort = db_escape_string($_GET["sort"]);
+
+		if (!$sort || $sort == "undefined") {
+			$sort = "login";
+		}
+
 		print "<div class=\"prefGenericAddBox\">
 			<input id=\"uadd_box\" 			
 				onkeyup=\"toggleSubmitNotEmpty(this, 'user_add_btn')\"
@@ -3398,7 +3404,7 @@
 				SUBSTRING(last_login,1,16) as last_login
 			FROM 
 				ttrss_users
-			ORDER by login");
+			ORDER BY $sort");
 
 //		print "<div id=\"infoBoxShadow\"><div id=\"infoBox\">PLACEHOLDER</div></div>";
 
@@ -3413,9 +3419,9 @@
 
 		print "<tr class=\"title\">
 					<td align='center' width=\"5%\">&nbsp;</td>
-					<td width='40%'>Login</td>
-					<td width='40%'>Access Level</td>
-					<td width='30%'>Last login</td></tr>";
+					<td width='40%'><a href=\"javascript:updateUsersList('login')\">Login</a></td>
+					<td width='40%'><a href=\"javascript:updateUsersList('access_level')\">Access Level</a></td>
+					<td width='30%'><a href=\"javascript:updateUsersList('last_login')\">Last login</a></td></tr>";
 		
 		$lnum = 0;
 		
diff --git a/prefs.js b/prefs.js
index a91d430c..c6daa6b6 100644
--- a/prefs.js
+++ b/prefs.js
@@ -157,7 +157,7 @@ function updateFeedList(sort_key) {
 
 }
 
-function updateUsersList() {
+function updateUsersList(sort_key) {
 
 	if (!xmlhttp_ready(xmlhttp)) {
 		printLockingError();
@@ -168,7 +168,8 @@ function updateUsersList() {
 
 //	p_notify("Loading, please wait...");
 
-	xmlhttp.open("GET", "backend.php?op=pref-users", true);
+	xmlhttp.open("GET", "backend.php?op=pref-users&sort="
+		+ param_escape(sort_key), true);
 	xmlhttp.onreadystatechange=userlist_callback;
 	xmlhttp.send(null);
 
-- 
2.39.5