add ttrss_users.full_name; bump schema

2 files changed, 22 insertions, 9 deletions

diff --git a/modules/popup-dialog.php b/modules/popup-dialog.php
index 61efd4c99..4c8c92b54 100644
--- a/modules/popup-dialog.php
+++ b/modules/popup-dialog.php
@@ -654,11 +654,13 @@
 			print "<input type=\"hidden\" name=\"op\" value=\"rpc\">";
 			print "<input type=\"hidden\" name=\"subop\" value=\"sendEmail\">"; 
 
-			$result = db_query($link, "SELECT email FROM ttrss_users WHERE
+			$result = db_query($link, "SELECT email, full_name FROM ttrss_users WHERE
 				id = " . $_SESSION["uid"]);
 
 			$user_email = htmlspecialchars(db_fetch_result($result, 0, "email"));
-			$user_name = htmlspecialchars($_SESSION["name"]);
+			$user_name = htmlspecialchars(db_fetch_result($result, 0, "full_name"));
+
+			if (!$user_name) $user_name = $_SESSION['name'];
 
 			$_SESSION['email_replyto'] = $user_email;
 			$_SESSION['email_fromname'] = $user_name;
diff --git a/modules/pref-prefs.php b/modules/pref-prefs.php
index dc658956b..5fcb93115 100644
--- a/modules/pref-prefs.php
+++ b/modules/pref-prefs.php
@@ -123,12 +123,14 @@
 		} else if ($subop == "change-email") {
 
 			$email = db_escape_string($_POST["email"]);
+			$full_name = db_escape_string($_POST["full_name"]);
+
 			$active_uid = $_SESSION["uid"];
 
-			db_query($link, "UPDATE ttrss_users SET email = '$email' 
-				WHERE id = '$active_uid'");				
+			db_query($link, "UPDATE ttrss_users SET email = '$email',
+				full_name = '$full_name' WHERE id = '$active_uid'");				
 		
-			print __("E-mail has been changed.");
+			print __("Your personal data has been saved.");
 		
 			return;
 
@@ -197,11 +199,20 @@
 				print "<table width=\"100%\" class=\"prefPrefsList\">";
 	 			print "<tr><td colspan='3'><h3>".__("Personal data")."</h3></tr></td>";
 
-				$result = db_query($link, "SELECT email,access_level FROM ttrss_users
+				$result = db_query($link, "SELECT email,full_name,
+					access_level FROM ttrss_users
 					WHERE id = ".$_SESSION["uid"]);
 					
-				$email = db_fetch_result($result, 0, "email");
-	
+				$email = htmlspecialchars(db_fetch_result($result, 0, "email"));
+				$full_name = htmlspecialchars(db_fetch_result($result, 0, "full_name"));
+
+				print "<tr><td width=\"40%\">".__('Full name')."</td>";
+				print "<td class=\"prefValue\"><input class=\"editbox\" name=\"full_name\" 
+					onfocus=\"javascript:disableHotkeys();\" 
+					onblur=\"javascript:enableHotkeys();\"
+					onkeypress=\"return filterCR(event, changeUserEmail)\"
+					value=\"$full_name\"></td></tr>";
+
 				print "<tr><td width=\"40%\">".__('E-mail')."</td>";
 				print "<td class=\"prefValue\"><input class=\"editbox\" name=\"email\" 
 					onfocus=\"javascript:disableHotkeys();\" 
@@ -226,7 +237,7 @@
 				print "</form>";
 
 				print "<p><button onclick=\"return changeUserEmail()\">".
-					__("Change e-mail")."</button>";
+					__("Save data")."</button>";
 
 				print "<form onsubmit=\"return false\" 
 					name=\"change_pass_form\" id=\"change_pass_form\">";