mysql-motp

A function for MySQL which verifies Mobile One Time Passwords and remeber them to make them only valid for one time.

1. Create table otp_history like shown in mysql-motp.func.

2. Paste text from mysql-motp.func into your mysql-session

3. You are ready to start.

The function otpverify returns a bool value, so:
1 := True (is valid)
0 := False (wrong)

mysql> select otpverify('1234','624d4f','0123456789abcdef') as result\G
result: 1

mysql> select otpverify('1234','624d4f','0123456789abcdef') as result\G
result: 0