| @@ -149,16 +149,18 sub RedmineDSN { | |||
|
|
149 | 149 | $self->{RedmineDSN} = $arg; |
|
|
150 | 150 | my $query = "SELECT |
|
|
151 | 151 | hashed_password, auth_source_id, permissions |
|
|
152 | FROM members, projects, users, roles | |
|
|
152 | FROM members, projects, users, roles, member_roles | |
|
|
153 | 153 | WHERE |
|
|
154 |
projects.id=members.project_id |
|
|
|
154 | projects.id=members.project_id | |
|
|
155 | AND member_roles.member_id=members.id | |
|
|
155 | 156 | AND users.id=members.user_id |
|
|
156 | AND roles.id=members.role_id | |
|
|
157 | AND roles.id=member_roles.role_id | |
|
|
157 | 158 | AND users.status=1 |
|
|
158 | 159 | AND login=? |
|
|
159 | 160 | AND identifier=? "; |
|
|
160 | 161 | $self->{RedmineQuery} = trim($query); |
|
|
161 | 162 | } |
|
|
163 | ||
|
|
162 | 164 | sub RedmineDbUser { set_val('RedmineDbUser', @_); } |
|
|
163 | 165 | sub RedmineDbPass { set_val('RedmineDbPass', @_); } |
|
|
164 | 166 | sub RedmineDbWhereClause { |
General Comments 0
You need to be logged in to leave comments.
Login now