2011-08-02, 07:37
our server fires emails to <myCell#>@<myCarrier>.com, then they push TXTs to my phone and NP fires it to xbmc. the carrier changed something in may... now NP doesn't work ... as well as it did... these TXTs use to arrived from a 5-digit-short-code & otherwise look normal. NOW, they are from <my.Email@address> & message.text is NULL ... the body is being stored in another table (msg_pieces.data ... not sure why)
would you please fix 2 issues with these automated TXTs
1. IF message.text is NULL SELECT msg_pieces.data WHERE message.ROWID = msg_pieces.message_Id ... that's not SQL but i hope it makes sense
2. also find the contact pix for <Email@address>
i hope that's not too much trouble
NP rocks! thanks for all this awesome sauce !!
i've sent 2 of my friends your way & more soon
would you please fix 2 issues with these automated TXTs
1. IF message.text is NULL SELECT msg_pieces.data WHERE message.ROWID = msg_pieces.message_Id ... that's not SQL but i hope it makes sense
2. also find the contact pix for <Email@address>
i hope that's not too much trouble
NP rocks! thanks for all this awesome sauce !!
i've sent 2 of my friends your way & more soon