diff options
Diffstat (limited to 'database/sqlite')
| -rw-r--r-- | database/sqlite/administration.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/database/sqlite/administration.c b/database/sqlite/administration.c index b1e5c91..14f4194 100644 --- a/database/sqlite/administration.c +++ b/database/sqlite/administration.c @@ -424,7 +424,7 @@ int eDBadminGetUserInfo(eurephiaCTX *ctx, int getInfo, eurephiaUSERINFO *user) { " (at.attempts > 0)" " FROM openvpn_users u" " LEFT JOIN openvpn_blacklist bl USING(username)" - " LEFT JOIN openvpn_attempts at USING(username)" + " LEFT JOIN openvpn_attempts at ON(at.username = u.username)" " LEFT JOIN (SELECT uid, count(*) AS logincount " " FROM openvpn_lastlog" " GROUP BY uid) lc" |