Results 1 to 4 of 4
Discuss [Release] Outgoing and Received Call Time Reporting Script at the Free Toolchain Software (Cydia App's) - Hackint0sh.org; 'calls' is a script to show both called out and received minutes used since the ...
  1. #1
    Professional Array abtf2's Avatar

    Join Date
    Sep 2007
    Posts
    84
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    11

    Post [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
    download.

    Latest version: 0.2 Correctly reports minutes since last timer reset. Do not use version 0.1.

    Example:

    bash-3.2# calls
    124 Minutes called out
    178 Minutes received

    Details:

    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
    period.

    This information is stored in the iPhone Call History database, but
    is not displayed by the settings->Usage app (at least not on my
    1.1.1 FW).

    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.

    Enjoy,
    Ab

    -----

    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
    Contents:
    -rwxr-xr-x 437 2008-01-05 13:59:01 ver0p2/calls
    -rwxr-xr-x 422540 2008-01-01 23:14:44 ver0p2/sqlite3

    Installation:

    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:

    ls /usr/bin/sqlite3
    ls /usr/bin/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:

    cd /tmp
    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

    Source:

    (If you already have sqlite3 on your phone, just cut and past this
    script to a file in your path)

    PHP Code:
    #!/bin/sh
    AppPath=/usr/bin
    DbPath
    =/private/var/root/Library/CallHistory
    sql
    =$AppPath/sqlite3

    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 08:25 PM. Reason: Update to version 0.2



  2. #2
    Professional Array abtf2's Avatar

    Join Date
    Sep 2007
    Posts
    84
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    11

    Default

    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.

  3. #3
    Newbie Array

    Join Date
    Feb 2008
    Posts
    1
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    0

    Default

    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!

    Luis

    PD: I send you a PM with my email adress.

  4. #4
    Newbie Array

    Join Date
    Dec 2009
    Posts
    1
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    0

    Default could not retrieveplease send the script to my email cclong231@yahoo.com, thank you!

    could not retrieve the files, please send the script to my email cclong231@yahoo.com, thank you!

 

 

Similar Threads

  1. outgoing call Monitor
    By chrizstone in forum iPhone Developer Exchange
    Replies: 2
    Last Post: 01-08-2013, 04:25 AM
  2. Outgoing call without sound and SMS not received
    By pargatz in forum Free Toolchain Software (Cydia App's)
    Replies: 4
    Last Post: 03-01-2008, 11:29 AM
  3. Help: No Outgoing call..
    By gibon in forum iPhone "2G" (Rev. 1)
    Replies: 3
    Last Post: 11-05-2007, 04:44 AM
  4. Request: Outgoing call time and texts counter
    By Sune in forum Free Toolchain Software (Cydia App's)
    Replies: 1
    Last Post: 09-23-2007, 03:35 PM
  5. No Sound on outgoing call..
    By nottm3 in forum General
    Replies: 0
    Last Post: 09-15-2007, 11:16 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Powered by vBulletin®
Copyright © 2014 vBulletin Solutions, Inc. All rights reserved.
Search Engine Friendly URLs by vBSEO
(c) 2006-2012 Hackint0sh.org
All times are GMT +2. The time now is 02:42 PM.
twitter, follow us!