- Product Manual
- Introduction
- SMS technology
- Installation Guide
- User Guide
- Developers Guide
- Examples and Solutions
- Telephone networks
- SMS Pin game
- E-mail to SMS alert
- 2 way SMS to Email gateway
- SMS Order System
- Asterisk PBX SMS
- SQL SMS Gateway
- Service Provider
- SMS PIN code query
- SMS Counter game
- SMS newsgroup
- Distributed SMS
- SMS Menu
- Google maps
- Forwarding
- Birthday greeting - SQL Express
- Birthday greeting - MySQL
- Birthday greeting - Oracle
- Instant brochure - MMS autoreply
- Alphabet letter game
- SMS sport betting service
- E-mail about outgoing SMS messages
- SMS Information Menu
- Email to SMS feature
- Reminder example
- Bulk SMS Client
- Bulk SMS to a given phone number range
- Filtering phone numbers
- Ozeki Phone Sytem PBX SMS
- Autoreply voucher example
- Appendix
- SMS FAQ
- Feature list
- Commercial Information
- Search
Ozeki NG SMS Gateway
An SMS game with Autoreply database
This game was requested by one of our customers.
>What I actually like to do is a game, where every 3000 incoming SMS wins. Every sender
>should receive an answer on which position he he is, like you are on position 2333, you didn't win.
This is very easy. You can use the "Autoreply Database User" in Ozeki NG to create this service.
You should create a database table that stores the incoming messages and put the following SQL commands into the "Autoreply Database Script". Please note that these queries are for MySQL.
n.* INSERT INTO inmsg (phonenum,msg) VALUES ('$sender','$messagedata'); SELECT '$sender',concat('Looser. You are number ',(select count(*) from users)) from inmsg where (select count(*) from users)<>3000 limit 1; SELECT '$sender','Winner. You are number 3000.' from inmsg where (select count(*) from users)=3000 limit 1;
The databse table layout can be:
CREATE TABLE inmsg ( id int not null auto_increment primary key, phonenum varchar(30), msg varchar(255));
More information
- Examples and SMS solutions
- SMS Reminder example
- SMS newsgroup
- How to connect SMS Gateway to the telephone network for voice calls
- Ozeki Phone Sytem PBX SMS
- SMS order
- SMS Pin game
- SMS PIN code query
- Appendix
- Feature list of the Ozeki NG SMS Gateway
- FAQ of the Ozeki NG SMS Gateway