UpdateQuery
is an SQL query that updates
the HOTP token data in the SQL database. After a successful or failed
authentication it will be passed the new authentication counter high in
%0
, new authentication counter low in
%1
, bad login count in %2
, the user name
in %3
, The default works with the sample database schema
provided in
goodies/hotp.sql
.
%0
and the
other formatters are SQL quoted, if needed, when used in
UpdateQuery
and unmodified when used with
UpdateQueryParam
.
The default
UpdateQuery
is:
update hotpkeys set accessed=now(), counter_high=%0, counter_low=%1,
bad_logins=%2 where username=%3