boomersmech: I have almost the exact same article over here,
http://www.modmyi.com/forums/3rd-par...larm-wm-2.html
(wish I had seen this first

, would have saved myself some time )
So I also got
play working but the query is not triggering the IF condition. I have 2 SMS's unread and if I run the following command in putty it returns 2...
sqlite3 /private/var/mobile/Library/SMS/sms.db 'select count(*) from message where flags=0'
but when I have the condition if
[ "$n" -gt 0 ] it never triggers, is the condition triggering for you? Can you post your current script, cause I can't figure out why mine isn't working.
I got it to work. The sqlite3 is also incompatible with FW2.0, but Erica has an update for it as well... I have more detail over here...
http://www.modmyi.com/forums/3rd-par...larm-wm-3.html
Now, just to get a vibrate that works