@@ -244,6 +244,7 sub RedmineDSN { | |||||
244 | WHERE |
|
244 | WHERE | |
245 | users.login=? |
|
245 | users.login=? | |
246 | AND projects.identifier=? |
|
246 | AND projects.identifier=? | |
|
247 | AND users.type='User' | |||
247 | AND users.status=1 |
|
248 | AND users.status=1 | |
248 | AND ( |
|
249 | AND ( | |
249 | roles.id IN (SELECT member_roles.role_id FROM members, member_roles WHERE members.user_id = users.id AND members.project_id = projects.id AND members.id = member_roles.member_id) |
|
250 | roles.id IN (SELECT member_roles.role_id FROM members, member_roles WHERE members.user_id = users.id AND members.project_id = projects.id AND members.id = member_roles.member_id) |
General Comments 0
You need to be logged in to leave comments.
Login now