SMS extension

With SMS extension you can send SMS (text messages) to mobile phones. myDBR currently supports sending SMS via Clickatell. Before you can send SMS you need to sign up for an account with Clickatell. See also that the numbers you use comply with the format used with Clickatell.

Other SMS gateways can be used by extending the SMSSender class in extensions/sms/sms_sender.php

Configuration

Make sure that you have created a HTTP API connection from Clickatell central. After that add your access details for the Clickatell SMS gateway in user/extension_init.php.

Commands

dbr.sms - Send SMS
dbr.sms.sender - Provide a sender ID for the outgoing message. Note: Sender ID's need to be requested and approved from Clickatell before they can be used.

Syntax

select 'dbr.sms', {optional simulate flag: 1 for simulating sending}
select 'dbr.sms.sender', sender_id

When simulating the sending, the Clickatell URL is displayed and the actual sending is not done.

Usage

Sending standard SMS

select 'dbr.sms';

select phone_nr, message
from mydbr.sms_recipients;

Sending with specified sender ID

select 'dbr.sms'; 
select 'dbr.sms.sender', 'mydbr.com'; 

select '12345789', 'Hello from myDBR'
union
select '43123454', 'Another message from myDBR';