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


1
2
3
4
5
6

query = "\
	SELECT IFNULL( MAX(TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime))),0) \
	FROM radacct \
	WHERE UserName='%{${key}}' \
	ORDER BY acctstarttime \
	LIMIT 1;"