while test 1
do
n=`$sql /var/mobile/Library/SMS/sms.db 'select count(*) from message where flags=0'`;
if [ "$n" -gt 0 ]
then
$playaudio $audiofile &
fi
sleep 120
done
I'm trying to find away to find NetMage to see if we can get him to write another SCW_Missedcalls binary... or at the least port over the original.. And I hope somone can release the vibrate binary again...
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...