diff options
| author | David Sommerseth <dazo@users.sourceforge.net> | 2008-12-11 14:51:49 +0100 |
|---|---|---|
| committer | David Sommerseth <dazo@users.sourceforge.net> | 2008-12-11 14:51:49 +0100 |
| commit | f8adb78cf80a8a555581b37be48d4881cfb906e0 (patch) | |
| tree | 68fa1640736e948d26ab593c40d23e03e0a72803 /database/sqlite | |
| parent | 2b65e68f64d00772c1e4765ef9f0510c3edfab48 (diff) | |
| download | eurephia-f8adb78cf80a8a555581b37be48d4881cfb906e0.tar.gz eurephia-f8adb78cf80a8a555581b37be48d4881cfb906e0.tar.xz eurephia-f8adb78cf80a8a555581b37be48d4881cfb906e0.zip | |
Fixed yet another strange SQLite3 parsing issue
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" |
