SMSEagle NXS-9700, Руководство пользователя

Страница: 138 / 163

138
| SMSEagle NXS-9700-3G | User’s Manual
In the above example the message will belong to user with id_user 1 (default 'admin'). You can find id_user
values for other users in table public."user".
Injecting long SMS using SQL
Inserting multipart messages is a bit more tricky, you need to construct also UDH header and store it
hexadecimally written into UDH field. Unless you have a good reason to do this manually, use API.
For long text message, the UDH starts with 050003 followed by byte as a message reference (you can put
any hex value there, but it should be different for each message, D3 in following example), byte for number
of messages (02 in example, it should be unique for each message you send to same phone number) and
byte for number of current message (01 for first message, 02 for second, etc.).
For example long text message of two parts could look like following:
INSERT INTO outbox (
"DestinationNumber",
"CreatorID",
"MultiPart",
"UDH",
"TextDecoded",
"Coding",
"Class",
"SenderID"
) VALUES (
'1234567',
'Program',
'true',
'050003D30201',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do
eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad
minim veniam, qui',
'Default_No_Compression',
-1,
'smseagle1'
)
INSERT INTO outbox_multipart (
"ID",
"SequencePosition",
"UDH",
"TextDecoded",
"Coding",
"Class"
) SELECT
CURRVAL(pg_get_serial_sequence('outbox','ID')),
2,
'050003D30202',
's nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat.',