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


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.


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.


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.


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', ''; 

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