jro_apps/redmine Commit - r7999:f252108f3063

Merged r7834 from trunk (#9566)....

Jean-Philippe Lang -

r7999:f252108f3063

parent child

Context file:

r7999:f252108f3063

extra/svn/Redmine.pm +8 -7

                $self->{RedmineDSN} = $arg;
                my $query = "SELECT
                               hashed_password, salt, auth_source_id, permissions
-                           FROM members, projects, users, roles, member_roles
+                           FROM projects, users, roles
                            WHERE
-                             projects.id=members.project_id
-                             AND member_roles.member_id=members.id
-                             AND users.id=members.user_id
-                             AND roles.id=member_roles.role_id
+                             users.login=?
+                             AND projects.identifier=?
                              AND users.status=1
-                             AND login=?
-                             AND identifier=? ";
+                             AND (
+                               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)
+                               OR
+                               (roles.builtin=1 AND cast(projects.is_public as CHAR) IN ('t', '1'))
+                             ) ";
                $self->{RedmineQuery} = trim($query);
              }

General Comments 0

You need to be logged in to leave comments. Login now

No TODOs yet

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages