From 73df7b3d9a91bb57319a6fa44e5c01656a4443aa Mon Sep 17 00:00:00 2001
From: mltownsend <mltownsend@gmail.com>
Date: Mon, 7 Dec 2009 21:54:14 +0000
Subject: Added ability to change the users password.  Only does it for all
 hosts at once.  This is the same behavior as other clients.  If it is
 necessary to have a different password for each user/host combination, then
 we could probably do that.  Just makes the UI a little confusing, IMO.

---
 Source/SPUserManager.m | 31 ++++++++++++++++++++++++++-----
 1 file changed, 26 insertions(+), 5 deletions(-)

(limited to 'Source')

diff --git a/Source/SPUserManager.m b/Source/SPUserManager.m
index 37824f47..067508c8 100644
--- a/Source/SPUserManager.m
+++ b/Source/SPUserManager.m
@@ -408,6 +408,7 @@
 	}
 	else {
 		// Close sheet
+		[self.mySqlConnection queryString:@"FLUSH PRIVILEGES"];
 		[NSApp endSheet:[self window] returnCode:0];
 		[[self window] orderOut:self];
 	}
@@ -610,7 +611,25 @@
 - (BOOL)updateUsers:(NSArray *)updatedUsers
 {
 	for (NSManagedObject *user in updatedUsers) {
-		[self grantPrivilegesToUser:user];
+		if (![user host])
+		{
+			// Just the user password was changed.
+			// Change password to be the same on all hosts.
+			NSArray *hosts = [user valueForKey:@"children"];
+			for(NSManagedObject *child in hosts)
+			{
+				NSString *changePasswordStatement = [NSString stringWithFormat:
+													 @"SET PASSWORD FOR %@@%@ = PASSWORD('%@')",
+													 [[user valueForKey:@"user"] tickQuotedString],
+													 [[child host] tickQuotedString],
+													 [user valueForKey:@"password"]];
+				[self.mySqlConnection queryString:changePasswordStatement];	
+				[self checkAndDisplayMySqlError];
+			}
+		} else {
+			[self grantPrivilegesToUser:user];			
+		}
+
 	}
 	
 	return YES;
@@ -642,22 +661,24 @@
 {	
 	for (NSManagedObject *user in insertedUsers)
 	{
+		NSString *createStatement;
+
 		if ([user parent] && [[user parent] valueForKey:@"user"] && [[user parent] valueForKey:@"password"]) {
 			
-			NSString *createStatement = [NSString stringWithFormat:@"CREATE USER %@@%@ IDENTIFIED BY %@;", 
+			createStatement = [NSString stringWithFormat:@"CREATE USER %@@%@ IDENTIFIED BY %@;", 
 										 [[[user parent] valueForKey:@"user"] tickQuotedString], 
 										 [[user valueForKey:@"host"] tickQuotedString],
 										 [[[user parent] valueForKey:@"password"] tickQuotedString]];
-						
+			
 			// Create user in database
 			[self.mySqlConnection queryString:[NSString stringWithFormat:createStatement]];
 			
 			if ([self checkAndDisplayMySqlError]) {
 				[self grantPrivilegesToUser:user];
-			}			
+			}	
 		}
+		
 	}
-	
 	return YES;
 }
 
-- 
cgit v1.2.3