Ozeki NG SMS Gateway

Service Provider | SMS Counter game

SMS content query with PIN code

This is a sample applications for SMS based content delivery with PIN code authentication. The application works the following way: The mobile users sends in an SMS message with a pin code. The software checks to see if the sender phone number and the pin code is in the database. If they are in the database the software returns the appropriate response message.

This solution can be created with the "SMS Autoreply from Database" solution presented at https://ozekisms.com/p_2392-sms-autoreply-from-database.html

To get this solution working, you need to create this database table in your SQL server:

CREATE TABLE content (
 id int IDENTITY (1,1),
 senderphone varchar(30),
 pincode varchar(16),
 responsemessage varchar(160),
);

And you have to put the following line into your Autoreply database user script.

n.*
SELECT '$sender',responsemessage from content where keyword='$keyword'

More information

• Examples and SMS solutions
• SMS Reminder example
• Autoreply voucher example
• How to connect SMS Gateway to the telephone network for voice calls
• Ozeki Phone Sytem PBX SMS
• Asterisk PBX SMS
• SMS Pin game
• SMS Counter game
• Appendix
• Feature list of the Ozeki NG SMS Gateway
• FAQ of the Ozeki NG SMS Gateway

Service Provider | SMS Counter game