Discuss [Release] Outgoing and Received Call Time Reporting Script at the Free Toolchain Software - Hackint0sh.org; 'calls' is a script to show both called out and received minutes
used since the ...
[Release] Outgoing and Received Call Time Reporting Script
'calls' is a script to show both called out and received minutes
used since the last iPhone usage reset. The script uses the
sqlite3 database utility, which is included in the referenced
Latest version: 0.2 Correctly reports minutes since last timer reset. Do not use version 0.1.
124 Minutes called out
178 Minutes received
My phone service provider only charges outgoing calls against my
calling plan minutes. They don't, however, provide a way to check
called out versus received minutes until the end of the billing
This information is stored in the iPhone Call History database, but
is not displayed by the settings->Usage app (at least not on my
I wrote a script to display both called out and received minutes
since the last usage reset. The script relies on the sqlite3
database access program, included in the compressed tar file.
The Call History database includes timestamp information to
differentiate peak versus off-peak call times, and I may impliment
that later. I may also use this as an excuse to compile the toolchain
and provide a graphical UI. If *you* make any enhancements
or have a program with similar function please post it here and
save me the effort.
For now, this assumes you have knowledge of ssh and running shell commands
on your phone. You can run the script 'calls' either from a
vt100 Terminal installed on your phone, or over WiFi via ssh.
I have only tested this on 1.1.1 FW, but I haven't heard of any
changes in the call_history.db from 1.0.0 to 1.1.2.
Downlaod URL: http://www.m-e-d-i-a-f-i-r-e.com/?9wwtdnx5ueq
(Remove dashes in the above URL.)
File Name: calls-0.2.tgz
-rwxr-xr-x 437 2008-01-05 13:59:01 ver0p2/calls
-rwxr-xr-x 422540 2008-01-01 23:14:44 ver0p2/sqlite3
1) Download calls-02.tgz to your computer.
2) Transfer to your iphone using scp:
scp calls-0.2.tgz root@iphone:/tmp
Execute the remaining steps from an installed VT100 shell, or
while ssh'd into your phone.
3) Verify you don't already have sqlite3 or calls:
Each command above should return:
ls: cannot access /usr/bin/<filename>: No such file or directory
If either file exists, back them up (or rename them) before continuing.
4) Uncompress, set permission, and move files into your path:
tar -zxvf calls-01.tgz
chown root:wheel calls
chown root:wheel sqlite3
chmod 755 calls
chmod 755 sqlite3
mv calls /usr/bin
mv sqlite3 /usr/bin
(If you already have sqlite3 on your phone, just cut and past this
script to a file in your path)
iCalled=`$sql $DbPath/call_history.db "select value/60 from _SqliteDatabaseProperties where key == 'timer_outgoing';"`
iReceived=`$sql $DbPath/call_history.db "select value/60 from _SqliteDatabaseProperties where key == 'timer_incoming';"`
echo "Since last timer reset: "
echo "$iCalled Minutes called out"
echo "$iReceived Minutes received"
Last edited by abtf2; 01-05-2008 at 09:25 PM.
Reason: Update to version 0.2
Version 0.2 of the 'calls' script now correctly reports outgoing and incomming
minutes since last timer reset. Don't use version 0.1. I was making the
problem much harder than it was
See post #1 for download and source.
Hi, Im very interested into use your script for the recived and send call time on the iphone, but i do not have too much knowledges into how to do it... can you give me and specific step by step guide of how to install it, which programs do you use, etc... (I prefered to do it on a Macintosh, but it may be on a PC too).
Thanks a Lot!
PD: I send you a PM with my email adress.
could not retrieveplease send the script to my email email@example.com, thank you!
could not retrieve the files, please send the script to my email firstname.lastname@example.org, thank you!
By chrizstone in forum iPhone Developer Exchange
Last Post: 01-08-2013, 05:25 AM
By pargatz in forum Free Toolchain Software
Last Post: 03-01-2008, 12:29 PM
By gibon in forum iPhone "2G" (Rev. 1)
Last Post: 11-05-2007, 05:44 AM
By Sune in forum Free Toolchain Software
Last Post: 09-23-2007, 03:35 PM
By nottm3 in forum General
Last Post: 09-15-2007, 11:16 PM