257677 Send SMS using clickatell API

We currently have a mysql database which holds our members details in a particular table. In this table, we have fields containing the following: Field 1 = Member name (Text) Field 2 = Unique member ID (number) Field 3 = Phone number (format has been checked and validated before being allowed to be stored) Field 4 = Member group (number) Field 5 = Do they wish to accept text messages (Y or N) We currently use Clickatell to send our sms messages to our members. We have both an API account and a communicator account. We mainly use the communicator account to send the bulk of our messages as it contains its own address book. This is where our problem lies, the address book in Clickatell communicator is not linked to our mysql database and so if a member updates his/her phone number from our website (which updates our MySQL database), this change never gets reflected in the clickatell database/phonebook. We have to manually ensure that the clickatell address book is uptodate and this is tiresome and error prone. What we would like is a partial replication of the clickatell communicator website, but host it on our own servers and use the API features of clickatell to send our messages. What we envision is a webpage running on our servers (linux/apache) where we can type our sms message into a text box, then select the members we wish the text message to go out to. We do not envision having to use any of the advance features of the Clickatell communicator system, eg. Timed sending etc. The receiving members must be able to be selected individually or by member group, which is all stored in our mySQL database. When the submit button is pressed, we would expect the script/webpage to connect with the Clickatell API service (can be any of the API functions, XML, email, ftp etc etc.) and send our message for delivery. The next request is vital for us. The clickatell system has a “reporting mechanism” /status message for each message that it sends. The report codes that get returned for each message should be checked by the script, and if an “error in mobile phone number” error code appears, we would like the script to search for that telephone number that caused the error in our MySQL database and remove it. This will force that user when he next logs in to update/change his mobile phone number to the correct one. As a summary our requests are: 1) A webpage that can serve as our Clickatell interface for sending SMS messages using the Clickatell API. 2) Selecting members, individually and/or by member group using the MySQL database to get the member info. 3) Send sms's using any of Clickatell API functions – preferably XML (as long as the member has said yes to accepting texts) 4) Check status codes of each message that gets returned from Clickatell for errors. 5) Delete phone numbers that cause errors from the database. We can provide a clickatell API account for you to use, with a set number of credits, alternatively you can use your own account and we will refund all testing credits used in the creation of the project (limits apply!). Any more detailing information can be provided on request.