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
Features
- motp
- mysql
Follow mysql-motp
You Might Also Like
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of mysql-motp!