Ozeki NG SMS Gateway logo OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"

OZEKI NG SMS Gateway - Product Guide

SMS PIN code query Contents | SearchSMS newsgroup

Home > Product Manual > Examples and Solutions > SMS Counter game


Contact Us!
If you wish to get further information, do not hesitate to contact us!

E-mail: info@ozekisms.com

If you have a technical question, please submit a support request on-line.

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.

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:

   id int not null auto_increment primary key,
   phonenum varchar(30),
   msg varchar(255));

More information

Next page: SMS newsgroup
Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Product Manual > Examples and Solutions > SMS Counter game
Legal | Privacy | Terms of use | 2465 | | Login