Re: sqlbox and wap push

Sam Wed, 13 Jan 2010 13:56:36 -0800

hi,

You mean change the type of this column on send and sent tables? I am afraid
this would affect the normal TEXT sms messages that is supposed to go into
this field.


Please advise if changing the column type would not impact other normal sms.

--Sam


On Mon, Jan 11, 2010 at 12:17 AM, Alejandro Guerrieri <
[email protected]> wrote:

> Ah, it's that 0x00 confusing things up... Can you try changing the column
> type to binary?
>
> On Sun, Jan 10, 2010 at 11:24 PM, Sam <[email protected]> wrote:
>
>> Hi Alex,
>>
>> I have done that for msgdata but its not working. It appears msgdata type
>> is TEXT not BLOB.
>>
>> ###################################
>> INSERT INTO send_sms (`momt`, `sender`, `receiver`, `msgdata`, `sms_type`,
>> `dlr_mask`, `udhdata` )
>> VALUES ('MT', 'sender', '0000000000000', CHAR(0x1B, 0x06, 0x01, 0xAE,
>> 0x02, 0x05, 0x6A, 0x00, 0x45, 0xC6, 0x0C, 0x03, 0x68, 0x74, 0x74, 0x70,
>> 0x3A, 0x2F, 0x2F, 0x6E, 0x75, 0x6F, 0x62, 0x6A, 0x65, 0x63, 0x74, 0x73,
>> 0x2E, 0x63, 0x6F, 0x6D, 0x2F, 0x76, 0x6F, 0x69, 0x63, 0x65, 0x2F, 0x65,
>> 0x63, 0x6F, 0x73, 0x73, 0x65, 0x2E, 0x6A, 0x70, 0x67, 0x00, 0x01, 0x03,
>> 0x54, 0x68, 0x65, 0x20, 0x69, 0x6D, 0x61, 0x67, 0x65, 0x20, 0x68, 0x65,
>> 0x72, 0x65, 0x00, 0x01, 0x01), 2, 31, CHAR(0x06, 0x05, 0x04, 0x0B, 0x84,
>> 0x23, 0xf0)  )
>> ###################################
>> 2010-01-10 23:00:38 [32012] [6] DEBUG: SMPP[nuSMSC]: Sending PDU:
>> 2010-01-10 23:00:38 [32012] [6] DEBUG: SMPP PDU 0x926ebc0 dump:
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   type_name: submit_sm
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   command_id: 4 = 0x00000004
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   command_status: 0 = 0x00000000
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   sequence_number: 5498 =
>> 0x0000157a
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   service_type: NULL
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   source_addr_ton: 5 = 0x00000005
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   source_addr_npi: 0 = 0x00000000
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   source_addr: "sender"
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   dest_addr_ton: 2 = 0x00000002
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   dest_addr_npi: 1 = 0x00000001
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   destination_addr: "00000000000"
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   esm_class: 67 = 0x00000043
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   protocol_id: 0 = 0x00000000
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   priority_flag: 0 = 0x00000000
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   schedule_delivery_time: NULL
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   validity_period: NULL
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   registered_delivery: 1 =
>> 0x00000001
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   replace_if_present_flag: 0 =
>> 0x00000000
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   data_coding: 4 = 0x00000004
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   sm_default_msg_id: 0 = 0x00000000
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   sm_length: 14 = 0x0000000e
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:   short_message:
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:    Octet string at 0x9269030:
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:      len:  14
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:      size: 1024
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:      immutable: 0
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:      data: 06 05 04 0b 84 23 f0 1b
>> 06 01 ae 02 05 6a         .....#.......j
>> 2010-01-10 23:00:38 [32012] [6] DEBUG:    Octet string dump ends.
>> 2010-01-10 23:00:38 [32012] [6] DEBUG: SMPP PDU dump ends.
>> ###################################
>>
>> On Sat, Jan 9, 2010 at 1:03 PM, Alejandro Guerrieri <
>> [email protected]> wrote:
>>
>>> Ok, you could try inserting the binary code instead of the "%" encoded
>>> data. Something like CHAR(0x1B, 0x06, 0x01...) etc.
>>>
>>> Regards,
>>>
>>> Alex
>>> --
>>> Alejandro Guerrieri
>>> [email protected]
>>>
>>> On Sat, Jan 9, 2010 at 1:42 AM, Sam <[email protected]> wrote:
>>>
>>>> Thanks Alex .. as you would see below.. the problem is not with the UDH
>>>> but with the "msgtext". Unfortunately i dont have any idea on how to fix
>>>> this. Please advise I have included here my BB log for both cases and the
>>>> SQL statement i am using to insert into SQLBox.
>>>>
>>>> TIA.
>>>>
>>>> #################################### SEND SMS FROM KANNEL URL
>>>> #########################################
>>>> 2010-01-09 01:36:07 [32012] [9] DEBUG: boxc_receiver: sms received
>>>> 2010-01-09 01:36:08 [32012] [9] DEBUG: send_msg: sending msg to boxc:
>>>> <mysmsbox>
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG: SMPP[nuSMSC]: throughput
>>>> (0.00,0.00)
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG: SMPP[nuSMSC]: Sending PDU:
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG: SMPP PDU 0x9252680 dump:
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   type_name: submit_sm
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   command_id: 4 = 0x00000004
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   command_status: 0 = 0x00000000
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   sequence_number: 56 =
>>>> 0x00000038
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   service_type: NULL
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   source_addr_ton: 5 = 0x00000005
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   source_addr_npi: 0 = 0x00000000
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   source_addr: "sender"
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   dest_addr_ton: 2 = 0x00000002
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   dest_addr_npi: 1 = 0x00000001
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   destination_addr:
>>>> "0000000000000"
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   esm_class: 67 = 0x00000043
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   protocol_id: 0 = 0x00000000
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   priority_flag: 0 = 0x00000000
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   schedule_delivery_time: NULL
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   validity_period: NULL
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   registered_delivery: 1 =
>>>> 0x00000001
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   replace_if_present_flag: 0 =
>>>> 0x00000000
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   data_coding: 4 = 0x00000004
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   sm_default_msg_id: 0 =
>>>> 0x00000000
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   sm_length: 76 = 0x0000004c
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:   short_message:
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:    Octet string at 0x9268890:
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:      len:  76
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:      size: 1024
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:      immutable: 0
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:      data: 06 05 04 0b 84 23 f0
>>>> 1b 06 01 ae 02 05 6a 00 45   .....#.......j.E
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:      data: c6 0c 03 68 74 74 70
>>>> 3a 2f 2f 6e 61 6d 65 6e 61   ...http://namena
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:      data: 6d 65 73 2e 63 6f 6d
>>>> 2f 76 6f 69 63 65 2f 65 63   mes.com/voice/ec
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:      data: 6f 73 73 65 2e 6a 70
>>>> 67 00 01 03 54 68 65 20 69   osse.jpg...The i
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:      data: 6d 61 67 65 20 68 65
>>>> 72 65 00 01 01               mage here...
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG:    Octet string dump ends.
>>>> 2010-01-09 01:36:08 [32012] [6] DEBUG: SMPP PDU dump ends.
>>>>
>>>> ##################################################################################
>>>>
>>>>
>>>>
>>>> ######################################### SQLBOX insert
>>>> #########################################
>>>>
>>>> INSERT INTO send_sms (`momt`, `sender`, `receiver`, `msgdata`,
>>>> `sms_type`, `dlr_mask`, `udhdata` )
>>>> VALUES ('MT', 'sender', '0000000000000',
>>>> '%1B%06%01%AE%02%05%6A%00%45%C6%0C%03%68%74%74%70%3A%2F%2F%6E%61%6D%65%6E%61%6D%65%73%2E%63%6F%6D%2F%76%6F%69%63%65%2F%65%63%6F%73%73%65%2E%6A%70%67%00%01%03%54%68%65%20%69%6D%61%67%65%20%68%65%72%65%00%01%01',
>>>> 2, 31, CHAR(0x06, 0x05, 0x04, 0x0B, 0x84, 0x23, 0xf0)  )
>>>>
>>>> ####################################### SEND SMS FROM SQLBOX
>>>> #########################################
>>>> 2010-01-09 01:33:08 [32012] [11] DEBUG: boxc_receiver: sms received
>>>> 2010-01-09 01:33:08 [32012] [11] DEBUG: send_msg: sending msg to box:
>>>> <127.0.0.1>
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG: SMPP[nuSMSC]: throughput
>>>> (0.00,0.00)
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG: SMPP[nuSMSC]: Sending PDU:
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG: SMPP PDU 0x9252680 dump:
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   type_name: submit_sm
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   command_id: 4 = 0x00000004
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   command_status: 0 = 0x00000000
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   sequence_number: 49 =
>>>> 0x00000031
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   service_type: NULL
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   source_addr_ton: 5 = 0x00000005
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   source_addr_npi: 0 = 0x00000000
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   source_addr: "sender"
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   dest_addr_ton: 2 = 0x00000002
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   dest_addr_npi: 1 = 0x00000001
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   destination_addr:
>>>> "0000000000000"
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   esm_class: 67 = 0x00000043
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   protocol_id: 0 = 0x00000000
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   priority_flag: 0 = 0x00000000
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   schedule_delivery_time: NULL
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   validity_period: NULL
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   registered_delivery: 1 =
>>>> 0x00000001
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   replace_if_present_flag: 0 =
>>>> 0x00000000
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   data_coding: 4 = 0x00000004
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   sm_default_msg_id: 0 =
>>>> 0x00000000
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   sm_length: 214 = 0x000000d6
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:   short_message:
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:    Octet string at 0x92523e8:
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:      len:  214
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:      size: 1024
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:      immutable: 0
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:      data: 06 05 04 0b 84 23 f0
>>>> 25 31 42 25 30 36 25 30 31   .....#.%1B%06%01
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:      data: 25 41 45 25 30 32 25
>>>> 30 35 25 36 41 25 30 30 25   %AE%02%05%6A%00%
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:      data: 34 35 25 43 36 25 30
>>>> 43 25 30 33 25 36 38 25 37   45%C6%0C%03%68%7
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:      data: 34 25 37 34 25 37 30
>>>> 25 33 41 25 32 46 25 32 46   4%74%70%3A%2F%2F
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:      data: 25 36 45 25 36 31 25
>>>> 36 44 25 36 35 25 36 45 25   %6E%61%6D%65%6E%
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:      data: 36 31 25 36 44 25 36
>>>> 35 25 37 33 25 32 45 25 36   61%6D%65%73%2E%6
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:      data: 33 25 36 46 25 36 44
>>>> 25 32 46 25 37 36 25 36 46   3%6F%6D%2F%76%6F
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:      data: 25 36 39 25 36 33 25
>>>> 36 35 25 32 46 25 36 35 25   %69%63%65%2F%65%
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:      data: 36 33 25 36 46 25 37
>>>> 33 25 37 33 25 36 35 25 32   63%6F%73%73%65%2
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:      data: 45 25 36 41 25 37 30
>>>> 25 36 37 25 30 30 25 30 31   E%6A%70%67%00%01
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:      data: 25 30 33 25 35 34 25
>>>> 36 38 25 36 35 25 32 30 25   %03%54%68%65%20%
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:      data: 36 39 25 36 44 25 36
>>>> 31 25 36 37 25 36 35 25 32   69%6D%61%67%65%2
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:      data: 30 25 36 38 25 36 35
>>>> 25 37 32 25 36 35 25 30 30   0%68%65%72%65%00
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:      data: 25 30 31 25 30 31
>>>>                                            %01%01
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG:    Octet string dump ends.
>>>> 2010-01-09 01:33:08 [32012] [6] DEBUG: SMPP PDU dump ends.
>>>>
>>>> ##################################################################################
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Mon, Jan 4, 2010 at 11:21 AM, Alejandro Guerrieri <
>>>> [email protected]> wrote:
>>>>
>>>>> Have you checked the logs? You need to put the _binary_ data on the
>>>>> "udh" field, not the %XX stuff, btw.
>>>>>
>>>>> Compare the logs when sending from sendsms and sqlbox, you'll probably
>>>>> find differences.
>>>>>
>>>>> Regards,
>>>>>
>>>>> Alex
>>>>>  --
>>>>> Alejandro Guerrieri
>>>>> [email protected]
>>>>>
>>>>>
>>>>>
>>>>> On 03/01/2010, at 23:23, Sam wrote:
>>>>>
>>>>> Hi,
>>>>>
>>>>> Yes, I have used the full url.
>>>>>
>>>>> $fields[udh]  into `udhdata`
>>>>> $fields[text] into `msgdata`
>>>>>
>>>>> and other relevant fields.
>>>>>
>>>>> Yet message does not come to the phone or phone does not understand it.
>>>>> However, if i past the URL directly on the sendsms http interface, the
>>>>> message get delivered right.
>>>>>
>>>>> Am worried if i was supposed to insert $fields[text] into `msgdata`
>>>>> directly.
>>>>>
>>>>>
>>>>> On Sun, Jan 3, 2010 at 11:15 PM, Alejandro Guerrieri <
>>>>> [email protected]> wrote:
>>>>>
>>>>>> Wap push uses udh data, try using the full url my code generates.
>>>>>>
>>>>>> Regards,
>>>>>>
>>>>>> Alex
>>>>>>
>>>>>>
>>>>>> On Sun, Jan 3, 2010 at 10:45 PM, Sam <[email protected]> wrote:
>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>> I have tried to use Alex php code here http://www.blogalex.com/wp-
>>>>>>> content/uploads/2008/09/send_wap_push.php.txt
>>>>>>>
>>>>>>> by inserting the content of $fields[text] into `msgdata` field of
>>>>>>> the SQLbox table but this is not working.
>>>>>>>
>>>>>>>
>>>>>>> <?php
>>>>>>>   $fields = array (
>>>>>>>     'from' => '9912345678',
>>>>>>>     'to' => '9987654321',
>>>>>>>     'smsc' => 'mysmsc',
>>>>>>>     'link' => 'www.my-funny-link.com/myfile.mid',
>>>>>>>     'title' => 'Hi, look at this'
>>>>>>>   );
>>>>>>>
>>>>>>>   $kannel = array (
>>>>>>>     'host' => 'localhost',
>>>>>>>     'port' => 13013,
>>>>>>>     'user' => 'foo',
>>>>>>>     'pass' => 'bar'
>>>>>>>   );
>>>>>>>
>>>>>>>   $result = sendwappush ( $fields, $kannel );
>>>>>>>   print "SENT<br>$result<br>";
>>>>>>>
>>>>>>>
>>>>>>> /*
>>>>>>>   sendwappush function.
>>>>>>>   Copyleft 2004 by Alejandro Guerrieri
>>>>>>>   This code is open source and GPL licensed
>>>>>>> */
>>>>>>>   function send_wap_push ( $fields, $kannel ) {
>>>>>>>     $fields[udh]  = '%06%05%04%0B%84%23%F0';
>>>>>>>     $fields[text] = '%1B%06%01%AE%02%05%6A%00%45%C6%0C%03'.
>>>>>>>       hex_encode($fields['link'], '%').
>>>>>>>       '%00%01%03'.
>>>>>>>       hex_encode($fields['title'], '%').
>>>>>>>       '%00%01%01';
>>>>>>>     unset ( $fields['title'], $fields['link'] );
>>>>>>>
>>>>>>>     while(list($k,$v) = each($fields)) {
>>>>>>>       if ( $v != "" ) {
>>>>>>>         $string .= "&$k=$v";
>>>>>>>       }
>>>>>>>     }
>>>>>>>     $request = 'http://'.$kannel['host'].':'.$kannel[port].
>>>>>>>       '/cgi-bin/sendsms'.
>>>>>>>       '?user='.$kannel['user'].
>>>>>>>       '&pass='.$kannel['pass'].
>>>>>>>       $string;
>>>>>>>     $result = @file( $request );
>>>>>>>     return 'ok';
>>>>>>>   }
>>>>>>>
>>>>>>>   function hex_encode( $text, $joiner='' ) {
>>>>>>>     for ($l=0; $l<strlen($text); $l++) {
>>>>>>>       $letter = substr($text, $l, 1);
>>>>>>>       $ret .= sprintf("%s%02X", $joiner, ord($letter));
>>>>>>>     }
>>>>>>>     return $ret;
>>>>>>>   }
>>>>>>> ?>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> 2010/1/3 Nikos Balkanas <[email protected]>
>>>>>>>
>>>>>>>  Hi,
>>>>>>>>
>>>>>>>> With SQLbox you'll have to push it like sms. For a php example for
>>>>>>>> simple pushes please search archives for Alejandro Guerrieri's code.
>>>>>>>>
>>>>>>>> BR,
>>>>>>>> Nikos
>>>>>>>>
>>>>>>>> ----- Original Message -----
>>>>>>>> *From:* Sam <[email protected]>
>>>>>>>> *To:* [email protected]
>>>>>>>> *Sent:* Sunday, January 03, 2010 11:23 PM
>>>>>>>> *Subject:* Re: sqlbox and wap push
>>>>>>>>
>>>>>>>> Hi,
>>>>>>>>
>>>>>>>> Please how do i make SQLBOX to handle a simple Service Load Wap push
>>>>>>>> like the following to a mobile?
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>  <?xml version="1.0"?>
>>>>>>>> <!DOCTYPE sl PUBLIC "-//WAPFORUM//DTD SL 1.0//EN"
>>>>>>>>                     "www.wapforum.org/DTD/sl.dtd">
>>>>>>>> <sl href="http://domain.com/images2.jpg"/>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> N.B. Giving that the the appropriate UDH has been defined.
>>>>>>>>
>>>>>>>> TIA
>>>>>>>>
>>>>>>>> --Sam.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> 2009/12/9 Nikos Balkanas <[email protected]>
>>>>>>>>
>>>>>>>>>  I don't have an example. Use Alex's link. And don't spam. 1 email
>>>>>>>>> is plenth.
>>>>>>>>>
>>>>>>>>> BR,
>>>>>>>>> Nikos
>>>>>>>>>
>>>>>>>>>  ----- Original Message -----
>>>>>>>>> *From:* Sam <[email protected]>
>>>>>>>>> *To:* Nikos Balkanas <[email protected]>
>>>>>>>>> *Cc:* [email protected]
>>>>>>>>>   *Sent:* Wednesday, December 09, 2009 11:10 AM
>>>>>>>>> *Subject:* Re: sqlbox and wap push
>>>>>>>>>
>>>>>>>>> The goal is to make it work with sqlbox. Thus i would need to
>>>>>>>>> convert to wbxml. This is where i need your example.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> 2009/12/9 Nikos Balkanas <[email protected]>
>>>>>>>>>
>>>>>>>>>>  Hi,
>>>>>>>>>>
>>>>>>>>>> Use Alex's link. Otherwise it is too lengthy to describe the
>>>>>>>>>> protocol. If you are interested the spec is:
>>>>>>>>>>
>>>>>>>>>> WAP-249-PPGService-20010713-a
>>>>>>>>>> An example would be meaningless. It is different for each message.
>>>>>>>>>> Wapbox will do the same thing for you, but it doesn't work with 
>>>>>>>>>> SQLbox.
>>>>>>>>>>
>>>>>>>>>> BR,
>>>>>>>>>> Nikos
>>>>>>>>>>
>>>>>>>>>> ----- Original Message -----
>>>>>>>>>> *From:* Sam <[email protected]>
>>>>>>>>>> *To:* Nikos Balkanas <[email protected]>
>>>>>>>>>> *Cc:* [email protected]
>>>>>>>>>> *Sent:* Wednesday, December 09, 2009 10:39 AM
>>>>>>>>>> *Subject:* Re: sqlbox and wap push
>>>>>>>>>>
>>>>>>>>>> Thanks Nikos,
>>>>>>>>>>
>>>>>>>>>> I understand the UDH stuff, however how do i convert to wbxml?
>>>>>>>>>> Please could you do me an example?
>>>>>>>>>>
>>>>>>>>>> Also, would this code (
>>>>>>>>>> http://www.blogalex.com/wp-content/uploads/2008/09/send_wap_push.php.txt)
>>>>>>>>>> help in anyway?
>>>>>>>>>>
>>>>>>>>>> Thanks in advance.
>>>>>>>>>>
>>>>>>>>>> --Sam
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> 2009/12/9 Nikos Balkanas <[email protected]>
>>>>>>>>>>
>>>>>>>>>>>  Yes.
>>>>>>>>>>>
>>>>>>>>>>> You will have to do some work, though.
>>>>>>>>>>>
>>>>>>>>>>> 1) Use the appropriate udh for wap-push:
>>>>>>>>>>>
>>>>>>>>>>> &udh=%06%05%04%0B%84%23%F0
>>>>>>>>>>>
>>>>>>>>>>> in your sendsms url (url-encoded)
>>>>>>>>>>>
>>>>>>>>>>> 2) You have to convert your text first to wbxml and then
>>>>>>>>>>> urlencode it as well in your URL.
>>>>>>>>>>>
>>>>>>>>>>> BR,
>>>>>>>>>>> Nikos
>>>>>>>>>>>
>>>>>>>>>>> ----- Original Message -----
>>>>>>>>>>> *From:* Sam <[email protected]>
>>>>>>>>>>> *To:* [email protected]
>>>>>>>>>>> *Sent:* Wednesday, December 09, 2009 9:43 AM
>>>>>>>>>>> *Subject:* sqlbox and wap push
>>>>>>>>>>>
>>>>>>>>>>> Hi,
>>>>>>>>>>>
>>>>>>>>>>> Please can i use sqlbox for wap push?
>>>>>>>>>>>
>>>>>>>>>>> --Sam
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>

Re: sqlbox and wap push

Reply via email to