diff options
| author | Brandon Lee <blee@circuitid.com> | 2019-10-31 15:48:55 +0300 |
|---|---|---|
| committer | Brandon Lee <blee@circuitid.com> | 2019-10-31 15:48:55 +0300 |
| commit | a4c9aa98e7757a481277cb0b76675e3b194bb38d (patch) | |
| tree | 9a20cfbaaddd281f42cbedb74290e6a3d2621439 | |
| parent | 9b3a48f06358ed8f900765858a0dfe173782eb40 (diff) | |
update search by GUID column error
| -rw-r--r-- | lib/Query/QueryProvider.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/Query/QueryProvider.php b/lib/Query/QueryProvider.php index c7f38a9..52045ba 100644 --- a/lib/Query/QueryProvider.php +++ b/lib/Query/QueryProvider.php @@ -162,13 +162,13 @@ class QueryProvider implements \ArrayAccess Query::FIND_USER_BY_USERNAME => "SELECT $userColumns, u.$uPassword AS password " . "FROM $user u " . - "WHERE (u.$uUsername = :$usernameParam OR u.$ugUID = :$usernameParam) " . + "WHERE (u.$uUsername = :$usernameParam OR u.$uUID = :$usernameParam) " . (empty($uDisabled) ? "" : "AND NOT u.$uDisabled"), Query::FIND_USER_BY_USERNAME_CASE_INSENSITIVE => "SELECT $userColumns, u.$uPassword AS password " . "FROM $user u " . - "WHERE (lower(u.$uUsername) = lower(:$usernameParam) OR lower(u.$ugGID) = lower(:$usernameParam))" . + "WHERE (lower(u.$uUsername) = lower(:$usernameParam) OR lower(u.$uUID) = lower(:$usernameParam))" . (empty($uDisabled) ? "" : "AND NOT u.$uDisabled"), Query::FIND_USER_GROUPS => |