summaryrefslogtreecommitdiffstats
path: root/database/sqlite
diff options
context:
space:
mode:
authorDavid Sommerseth <dazo@users.sourceforge.net>2008-12-11 14:51:49 +0100
committerDavid Sommerseth <dazo@users.sourceforge.net>2008-12-11 14:51:49 +0100
commitf8adb78cf80a8a555581b37be48d4881cfb906e0 (patch)
tree68fa1640736e948d26ab593c40d23e03e0a72803 /database/sqlite
parent2b65e68f64d00772c1e4765ef9f0510c3edfab48 (diff)
downloadeurephia-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.c2
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"