+ Reply
Results 1 to 2 of 2

Your favorite Apple, iPhone, iPad, iOS, Jailbreak, and Cydia site.


Thread: Voicemail centre sms problem

is a discussion within the

General iPhone Chat

forums, a part of the

iPhone Modding

section;
Is anyone looking into the problems Iphone has recieving SMSs from non-phone-user addresses. 1.0.2 will not recieve sms from voicemail centres or even Skype. 1.1.1 will accept skype but scramles
...
  1. #1
    What's Jailbreak? nick.newey's Avatar
    Join Date
    Oct 2007
    Posts
    15
    Thanks
    3
    Thanked 1 Time in 1 Post
    Default Voicemail centre sms problem
    Is anyone looking into the problems Iphone has recieving SMSs from non-phone-user addresses. 1.0.2 will not recieve sms from voicemail centres or even Skype. 1.1.1 will accept skype but scramles the text.

    It looks to me as if this is handles by the commcenter. The sql database will curtainly accept and display any address if it is entered via sqlite.

    I am only MS literate and my programming dates back to VB, pascal etc so I am not able to de-compile the commcenter code. But looking at it in Hex there is the following ASCII

    /var/root/Library/SMS/ /var/root/Library/SMS/sms.db SELECT rowid, address, date, text, flags, replace, svc_center FROM message WHERE (flags & (1 << 7)) == 0 AND (flags & (1 << 1)) == 0 AND (flags & (1 << 0) == 1) AND (flags & (1 << 5) == 0) ORDER BY date ASC; SELECT rowid, address, date, text, flags, replace, svc_center FROM message WHERE replace == %d AND address == "%@" ORDER BY date ASC; SELECT message.rowid, message.address, message.date, message.text, message.flags, message.replace, message.svc_center, person.unread_count FROM (SELECT address, max(rowid) AS rowid, SUM(((flags & 2) == 0) AND ((flags & 1) == 0) AND ((flags & 2) == 0)) AS unread_count FROM message GROUP BY normalize_phone_number(address)) AS person JOIN message ON 1 = phone_numbers_equal(person.address, message.address) AND message.rowid = person.rowid ORDER BY message.rowid DESC; DELETE FROM message WHERE 1 == phone_numbers_equal(address, ?); DELETE FROM message; SELECT ROWID, address, date, text, flags, replace, svc_center FROM message WHERE date > ? AND (flags & (1 << 1)) == 0 AND (flags &

    etc etc etc

    Has anyone looked into this SQL statment and worked out why it rejects these sms?

  2. #2
    What's Jailbreak? nick.newey's Avatar
    Join Date
    Oct 2007
    Posts
    15
    Thanks
    3
    Thanked 1 Time in 1 Post
    This is an old post.... but i.unlock.no now have a SMS fix available for 1.1.1!

Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts