View Single Post
  #36 (permalink)  
Old 07-31-2008, 02:51 PM
interstink interstink is offline
Green Apple
 
Join Date: Sep 2007
Posts: 94
Thanks: 0
Thanked 2 Times in 2 Posts

Quote:
Originally Posted by IvanRaide View Post
'killed' is what I would get when I was running playaudio? You have the new Erica Utilities? If you run the 'play' in bin does it give you a 'killed'?

You have the permissions on 'play' set (755 and root:wheel, etc)? Not sure if its needed, but I set execute permission on alarm.aiff as well?
I did install the latest Erica's Util. With the PLAY. I think I have Beta 11 now.

Yes permissions are set on ALL files.

UPDATE: GOT IT WORKING!!! Decided to REinstall sqlite and Erica's using Cydia.

Now... I found the sms.db database structure. Can you point me in the right direction for the select to get the number then see if its equal to 5551515



TABLE message
ROWID (INTEGER PRIMARY KEY AUTOINCREMENT)
Auto-incrementing field/counter

address (TEXT)
International-formatted foreign address
(18005551212)

date (INTEGER)
OSX-epoch based datetime, convertable via date -r
(1187200801)

text (TEXT)
Content of text message
(This is the text message)

flags (INTEGER)
Flags controlling the type of record
2 - Message sent from address to iPhone
3 - Message sent from iPhone to address
129 - Message log erased from iPhone but addressee still in SMS index

replace (INTEGER)
Unknown, always 0 in my case

svc_center (TEXT)
service center, seems null in my case

Last edited by interstink; 07-31-2008 at 02:51 PM.. Reason: Automerged Doublepost
Digg StumbleUpon Delicious Reddit Newsvine Google Yahoo Thanks Reply With Quote