diff options
| author | stuconnolly <stuart02@gmail.com> | 2010-03-08 15:02:25 +0000 |
|---|---|---|
| committer | stuconnolly <stuart02@gmail.com> | 2010-03-08 15:02:25 +0000 |
| commit | 9f94e9947d26dde767d3b1e49f6747d5c55db4d8 (patch) | |
| tree | 5365d68ad6d0d253732d647528a6a3e148875d46 | |
| parent | 256b06622980461740af4774206ca77e534acd21 (diff) | |
| download | sequelpro-9f94e9947d26dde767d3b1e49f6747d5c55db4d8.tar.gz sequelpro-9f94e9947d26dde767d3b1e49f6747d5c55db4d8.tar.bz2 sequelpro-9f94e9947d26dde767d3b1e49f6747d5c55db4d8.zip | |
Remove semi-colons from user manager queries as they're not needed.
| -rw-r--r-- | Source/SPUserManager.m | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/Source/SPUserManager.m b/Source/SPUserManager.m index fe387422..c9f41a21 100644 --- a/Source/SPUserManager.m +++ b/Source/SPUserManager.m @@ -328,7 +328,7 @@ // Assumes that the child has already been initialized with values from the // global user table. // Select rows from the db table that contains schema privs for each user/host - NSString *queryString = [NSString stringWithFormat:@"SELECT * from `mysql`.`db` d WHERE d.user='%@' and d.host='%@'", + NSString *queryString = [NSString stringWithFormat:@"SELECT * from `mysql`.`db` d WHERE d.user = '%@' and d.host = '%@'", [[child parent] valueForKey:@"user"], [child valueForKey:@"host"]]; MCPResult *queryResults = [self.mySqlConnection queryString:queryString]; if ([queryResults numOfRows] > 0) @@ -995,7 +995,7 @@ // Grant privileges if ([grantPrivileges count] > 0) { - NSString *grantStatement = [NSString stringWithFormat:@"GRANT %@ ON %@.* TO %@@%@;", + NSString *grantStatement = [NSString stringWithFormat:@"GRANT %@ ON %@.* TO %@@%@", [grantPrivileges componentsJoinedByCommas], dbName, [[schemaPriv valueForKeyPath:@"user.parent.user"] tickQuotedString], @@ -1008,7 +1008,7 @@ // Revoke privileges if ([revokePrivileges count] > 0) { - NSString *revokeStatement = [NSString stringWithFormat:@"REVOKE %@ ON %@.* FROM %@@%@;", + NSString *revokeStatement = [NSString stringWithFormat:@"REVOKE %@ ON %@.* FROM %@@%@", [revokePrivileges componentsJoinedByCommas], dbName, [[schemaPriv valueForKeyPath:@"user.parent.user"] tickQuotedString], @@ -1050,7 +1050,7 @@ // Grant privileges if ([grantPrivileges count] > 0) { - NSString *grantStatement = [NSString stringWithFormat:@"GRANT %@ ON *.* TO %@@%@;", + NSString *grantStatement = [NSString stringWithFormat:@"GRANT %@ ON *.* TO %@@%@", [grantPrivileges componentsJoinedByCommas], [[[user parent] valueForKey:@"user"] tickQuotedString], [[user valueForKey:@"host"] tickQuotedString]]; @@ -1062,7 +1062,7 @@ // Revoke privileges if ([revokePrivileges count] > 0) { - NSString *revokeStatement = [NSString stringWithFormat:@"REVOKE %@ ON *.* FROM %@@%@;", + NSString *revokeStatement = [NSString stringWithFormat:@"REVOKE %@ ON *.* FROM %@@%@", [revokePrivileges componentsJoinedByCommas], [[[user parent] valueForKey:@"user"] tickQuotedString], [[user valueForKey:@"host"] tickQuotedString]]; |