3.89.3. UpdateQuery Previous topic Parent topic Child topic Next topic

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