Callcenter developers
If you are working on telephone solutions, please check
out the Ozeki VoIP SIP SDK.
It can be used to create: |
Webphone solutions:
- Adobe Flash video phone
- Silverlight video phone
- Web to web calls
- Web to VoIP calls
Custom SIP clients:
- Silverlight SIP VoIP client
- Flash SIP VoIP client
- C# .net SIP VoIP client
- ASP .net SIP VoIP client
- Web based SIP VoIP client
Custom VoIP solutions:
- VoIP SIP softphones
- VoIP call center clients
- VoIP IVR systems
- VoIP predictive dialer systems
- VoIP auto dialer systems
- VoIP call assistant
- VoIP call recording systems
- VoIP intercom solutions
|
SQL Templates for SQL logging in Ozeki NG SMS Gateway
The following SQL commands are used to log incoming and
outgoing messages into the database. If you are experiencing problems
with SQL logging, please check if the following templates are specified
in the server preferences form:
Template used for incoming messages to save them into the SMS inbox table:
|
INSERT INTO inbox (username,msgtype,msgid,sender,receiver,msgsubject,msgdata,senttime,receivedtime,operator) VALUES ('$username','$msgtype','$msgid','$sender','$receiver','$msgsubject','$msgdata','$senttime','$receivedtime','$operator')
|
Template used to insert a record into the SMS outbox table for messages accepted to be sent:
|
INSERT INTO outbox (username,msgtype,msgid,sender,receiver,msgsubject,msgdata,acceptedfordeliverytime,operator,status) VALUES ('$username','$msgtype','$msgid','$sender','$receiver','$msgsubject','$msgdata','$acceptedfordeliverytime','$operator','accepted') |
Template used to update the SMS outbox table when a message was delivered to
the network.
|
UPDATE outbox SET deliveredtonetworktime='$deliveredtonetworktime', callbackid='$callbackid', status='deliveredtonetwork', cost='$cost' where msgid='$msgid'
|
Template used to update the SMS outbox table when a message was delivered to
the handset.
|
UPDATE outbox SET deliveredtohandsettime='$deliveredtohandsettime', status='deliveredtohandset' where msgid='$msgid' |
Template used to update the SMS outbox table when a message delivery failed.
UPDATE outbox SET errormessage='$errormessage', status='deliveryfailed' where msgid='$msgid'
|
Dig deeper!
People who read this also read...
Next page:
SQL log tracking
|
