diff options
Diffstat (limited to 'extra/svn')
| -rw-r--r-- | extra/svn/Redmine.pm | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/extra/svn/Redmine.pm b/extra/svn/Redmine.pm index a15b482e8..20f795779 100644 --- a/extra/svn/Redmine.pm +++ b/extra/svn/Redmine.pm @@ -149,16 +149,18 @@ sub RedmineDSN { $self->{RedmineDSN} = $arg; my $query = "SELECT hashed_password, auth_source_id, permissions - FROM members, projects, users, roles + FROM members, projects, users, roles, member_roles WHERE - projects.id=members.project_id + projects.id=members.project_id + AND member_roles.member_id=members.id AND users.id=members.user_id - AND roles.id=members.role_id + AND roles.id=member_roles.role_id AND users.status=1 AND login=? AND identifier=? "; $self->{RedmineQuery} = trim($query); } + sub RedmineDbUser { set_val('RedmineDbUser', @_); } sub RedmineDbPass { set_val('RedmineDbPass', @_); } sub RedmineDbWhereClause { |