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

Project Activity

See All Activity >

Follow mysql-motp

mysql-motp Web Site

Other Useful Business Software
Get Avast Free Antivirus with 24/7 AI-powered online scam detection Icon
Get Avast Free Antivirus with 24/7 AI-powered online scam detection

Get protection for today’s online threats. Free.

Award-winning antivirus protection, as well as protection against online scams, dangerous Wi-Fi connections, hacked accounts, and ransomware. It includes Avast Assistant, your built-in AI partner, which gives you help with suspicious online messages, offers, and more.
Free Download
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of mysql-motp!

Additional Project Details

Registered

2014-05-16