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 | Your top-rated shield against malware and online scams Icon
Get Avast Free Antivirus | Your top-rated shield against malware and online scams

Boost your PC's defense against cyberthreats and web-based scams.

Our antivirus software scans for security and performance issues and helps you to fix them instantly. It also protects you in real time by analyzing unknown files before they reach your desktop PC or laptop — all for free.
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