3.90.3. UpdateQuery Previous topic Parent topic Child topic Next topic

UpdateQuery is an SQL query that updates the TOTP token data in the SQL database. After a successful or failed authentication it will be passed the bad login count in %0, the user name in %1 and last TOTP timestep in %2. The default works with the sample database schema provided in goodies/totp.sql. The default is:
update totpkeys set accessed=now(), bad_logins=%0, last_timestamp=%2
where username=%1