Re: sqlbox and wap push

Sat, 23 Jan 2010 08:14:17 -0800 

Hi,

Please can some1 help me out here.. Changing the msgdata column to BLOB may
make normal text messages not to work again.

Please what do you advise?


On Wed, Jan 13, 2010 at 10:55 PM, Sam <[email protected]> wrote:

> 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
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>

Reply via email to