Your favorite Apple, iPhone, iPad, iOS, Jailbreak, and Cydia site.
Thread: Voicemail centre sms problem
11-17-2007, 03:48 AM #1Voicemail 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?
12-04-2007, 10:16 PM #2
This is an old post.... but i.unlock.no now have a SMS fix available for 1.1.1!