[Adding User rename facility
tony@tonywhitmore.co.uk**20050922210026] {
addfile ./login/editusername.php
hunk ./CHANGELOG 17
+* Login / SATYR: Added a rename user functionality (editusername.php), with the option to rename all SATYR requests matching the username.
hunk ./TODO 45
-Interal anchors for groups
hunk ./includes/STORM/login/html/nav_admin.inc 37
+echo "<td width='2%'></td>\n";
+echo "<td bgcolor='#33FF33' align='center'>
+     <a href='editusername.php' class='ictnavigation'>Edit a STORM<br>user's username</a>
+     </td>\n";
hunk ./includes/STORM/login/html/nav_admin.inc 48
-     </td>\n";
+     </td>\n";
+     
+echo "</tr></table><br><table align='center' cellpadding='5'><tr>\n";     
+     
hunk ./includes/STORM/login/html/nav_admin.inc 55
-     </td>\n";
-
-echo "</tr></table><br><table align='center' cellpadding='5'><tr>\n";
-
+     </td>\n";
+echo "<td width='2%'></td>\n";
hunk ./login/editusername.php 1
+<?php
+
+/*  Copyright 2003-2005 Tony Whitmore.
+  
+    This file is part of School Tools for On-line Resource Management.
+
+    School Tools for On-line Resource Management is free software; you can redistribute it and/or modify
+    it under the terms of the GNU General Public License as published by
+    the Free Software Foundation; either version 2 of the License, or
+    (at your option) any later version.
+
+    School Tools for On-line Resource Management is distributed in the hope that it will be useful,
+    but WITHOUT ANY WARRANTY; without even the implied warranty of
+    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+    GNU General Public License for more details.
+
+    You should have received a copy of the GNU General Public License
+    along with School Tools for On-line Resource Management; if not, write to the Free Software
+    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+*/
+
+// Page that allows the STORM administrator to change the username of STORM user.
+
+// Start / resume session
+session_start();
+
+// Include the standard HTML headers.
+include ("STORM/common/html/htmlheader.inc");
+
+// Include the STORM and login functions files.
+include ("STORM/common/misc/functions.inc");
+include ("STORM/login/misc/functions.inc");
+
+// Check for a valid session and access level.
+sessionchk();
+$accesslevel = "3";
+accesschk("login",$accesslevel);
+
+// Include the STORM login banner.
+include ("STORM/login/html/banner.inc");
+
+// Include the connection to the database.
+include ("STORM/common/db/connectadmin.inc");
+
+function produce_form() {
+	// Start the form that takes the data.
+	echo "<form action='editusername.php' method='post'>\n";
+	// Produce the table that asks for the username.
	echo "<table border='0' align='center' width='70%'>\n";
+	echo "<tr>\n";
+	echo "<td align='right' width='50%'>\n";
+	echo "Enter the username to change:\n";
+	echo "</td>\n";
+	echo "<td align='left'>\n";
+	echo "<input type='text' name='username' size='20' maxlength='30'>\n";
+	echo "</td>\n";
+	echo "</tr>\n";
+	echo "<tr>\n";
+	echo "<td>\n";
+	echo "</td>\n";
+	echo "<td align='left'>\n";
+	userdropdown("username2");
+	echo "</td>\n";
+	echo "</tr>\n";
+	echo "<tr>\n";
+	echo "<td>\n";
+	echo "</td>\n";
+	echo "<td align='left'>\n";
+	echo "<input type='hidden' name='not_new' value='yes'>\n";
+	echo "<input type='hidden' name='update_SATYR' value='on'>\n";
+	echo "<input type='submit' value='Edit username'>\n";
+	echo "</td>\n";
+
+	echo "</tr>\n";
+	echo "</table>\n";
+	echo "</form>\n";
+
+	// Produce a link back to the main page.
+	echo "<p><a href='menu.php'>Back to the main menu</a></p>\n";
+}
+
+if ( isset($_POST['not_new']) )
+	{
+	// Validate the submitted username(s).
+	$errmsg = checkusernames();
+	if ( $errmsg != "" )
+		{
+		echo $errmsg;
+		produce_form();
+		exit();
+		}
+	// The username has been validated, and can be edited
+	if ( ($_POST['not_new'] == "yes") ){
+		echo "<form action='editusername.php' method='post'>\n";
+		// Produce the table that asks for the username to be deleted
		echo "<table border='0' align='center' width='70%'>\n";
+		echo "<tr>\n";
+		echo "<td align='right' width='50%'>\n";
+		echo "Enter the new username:\n";
+		echo "</td>\n";
+		echo "<td align='left'>\n";
+		echo "<input type='text' name='new_username' size='20' maxlength='30' value='" . $_POST['username'] . "'>\n";
+		echo "</td>\n";
+		echo "</tr>\n";
+		echo "<tr><td align='right'>Update SATYR support requests with new username?</td><td align='left'><input type='checkbox' name='update_SATYR' ";
+		if ( isset($_POST['update_SATYR'])) {
+			if ( $_POST['update_SATYR'] == "on" ) {
+				echo "checked\n";
+				}
+			}
+		echo "></td></tr>\n";
+		echo "<tr>\n";
+		echo "<td>\n";
+		echo "</td>\n";
+		echo "<td align='left'>\n";
+		echo "<input type='hidden' name='not_new' value='edited'>\n";
+		echo "<input type='hidden' name='username' value='" . $_POST['username'] . "'>\n";
+		echo "<input type='submit' value='OK'>\n";
+		echo "</td>\n";
+
+		echo "</tr>\n";
+		echo "</table>\n";
+		echo "</form>\n";
+
+		// Produce a link back to the main page.
+		echo "<p><a href='menu.php'>Back to the main menu</a></p>\n";
+		}		
+
+	if ( ($_POST['not_new'] == "edited") ){
+		// Check the new username doesn't already exist
+		$query = "SELECT username FROM users WHERE username = \"" . $_POST['new_username'] . "\"";
+		$result = $db->query($query);
+		if (DB::isError($db)) {die($db->getMessage());}		
+		$num_rows = $result->numRows();
+		if ( $num_rows == "0" ) {
+			// Rename the user record
+			$query = "UPDATE users SET username=\"" . $_POST['new_username'] . "\" WHERE username=\"" . $_POST['username'] . "\"";
+			$result = $db->query($query);
+			if (DB::isError($db)) {die($db->getMessage());}
+			if ( ($_POST['update_SATYR'] == "on") ) {
+				// Update SATYR records with the new username
+				$query = "UPDATE SATYR SET username=\"" . $_POST['new_username'] . "\" WHERE username=\"" . $_POST['username'] . "\"";
+				$result = $db->query($query);
+				if (DB::isError($db)) {die($db->getMessage());}
+				}
+			// Produce a success message.
+			echo "<h3>The username \"" . $_POST['username'] . "\" has been changed to \"" . $_POST['new_username'] . "\"!</h3>\n";
+			if ( ($_POST['update_SATYR'] == "on") ) {
+				echo "<h4>All SATYR support requests submitted under the old username have been updated with the new username.</h4>\n";
+				}
+			navbutton("menu.php","OK");
+			}
+		else {
+				echo "<h4>Sorry, username \"" . $_POST['new_username'] . "\" already exists. Please choose another.</h4>";
+				echo "<div align='center'>\n";
+				echo "<form action='editusername.php' method='post'>\n";
+				echo "<input type='hidden' name='not_new' value='yes'>\n";
+				echo "<input type='hidden' name='username' value='" . $_POST['username'] . "'>\n";
+				echo "<input type='hidden' name='update_SATYR' value='" . $_POST['update_SATYR'] . "'>\n";
+				echo "<input type='submit' value='OK'>\n";
+				echo "</form>\n";
+				echo "</div>\n";
+				// Produce a link back to the main page.
+				echo "<p><a href='menu.php'>Back to the main menu</a></p>\n";
+				}
+		}
+	}
+else
+	{
+	produce_form();
+	}
+
+?>
hunk ./login/resetpass.php 48
-	// Produce the table that asks for the username to be deleted.
+	// Produce the table that asks for the username.
}