Results 1 to 2 of 2
Discuss SQL statements - for SMS/Notes/Contacts at the iPhone Developer Exchange - Hackint0sh.org; Hi all Does any one know SQL STATEMENTS for retrieving SMS (from SMS.db), Notes (from ...
  1. #1
    Moderator Array vikram's Avatar

    Join Date
    Feb 2008
    Posts
    258
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    0

    Default SQL statements - for SMS/Notes/Contacts

    Hi all

    Does any one know SQL STATEMENTS for retrieving
    SMS (from SMS.db), Notes (from Notes.db) and Contacts (from ...sqlitedb).



  2. #2
    Senior Professional Array

    Join Date
    Sep 2007
    Posts
    370
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    29

    Default

    I haven't tried recently but you used to be able to SSH into the phone download the databases and open them with a viewer like SQLite Admin.

    Once open you can see the table structures and column headings. You would need to base your queries on these.

    Also, the date columns are stored in seconds elapsed since 1970 - or something like that.

 

 

Similar Threads

  1. Replies: 8
    Last Post: 04-02-2013, 01:51 PM
  2. MacNN: SaskTel: Next-gen iPhone statements 'not a confirmation'
    By hackint0sh in forum Latest Headlines
    Replies: 0
    Last Post: 04-16-2010, 09:50 PM
  3. MacNN: Apple, AT&T being sued for misleading MMS statements
    By hackint0sh in forum Latest Headlines
    Replies: 0
    Last Post: 08-28-2009, 06:20 AM
  4. Replies: 2
    Last Post: 07-24-2008, 07:31 AM
  5. [1.1.1 -> 1.1.3 ZiPhone] Backing up contacts/SMS/Notes/Everything.
    By kakihara in forum iPhone "2G" (Rev. 1)
    Replies: 3
    Last Post: 02-14-2008, 09:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Powered by vBulletin®
Copyright © 2014 vBulletin Solutions, Inc. All rights reserved.
Search Engine Friendly URLs by vBSEO
(c) 2006-2012 Hackint0sh.org
All times are GMT +2. The time now is 10:06 AM.
twitter, follow us!