raddb/mods-config/sql/counter/sqlite/expire_on_login.conf


1
2
3
4
5
6

query = "\
	SELECT GREATEST(strftime('%%s', NOW()) - strftime('%%s', acctstarttime), 0) AS expires \
	FROM radacct \
	WHERE username = '%{${key}}' \
	ORDER BY acctstarttime \
	LIMIT 1;"