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