#!/system/bin/tcsh -f

#location of the database for samsung android 4.2.2
set logdb=/data/data/com.sec.android.provider.logsprovider/databases/logs.db
set misseddb=/data/data/com.sec.android.app.keyguard/databases/MissedEvent.db

setenv TZ Europe/Prague

#echo '.dump' |sqlite3 $logdb 
#echo 'select * from logs;' |sqlite3 $logdb 

echo "select _id,type,logtype,number,name,date,duration,m_content from logs;" |sqlite3 $logdb |\
sort -n -t '|' -k 6 |\
gawk -F'|' '{printf("%4d. %s %s %s (%-20s) DATE %-19s %s\n",$1,($3==300?"SMS ":"CALL"),($2==2?($7==0&&$3==100?"TO-X":"TO  "):($2==1?"FROM":"RJCT")),$4,$5,strftime("%Y %B %d %H:%M:%S",$6/1000),($3==300?"TEXT: "$8:"DURATION="$7));}'