|
2011-02-09
, 11:58
|
|
Posts: 533 |
Thanked: 1,341 times |
Joined on Dec 2010
@ Italy
|
#112
|
|
2011-02-09
, 12:02
|
Posts: 37 |
Thanked: 18 times |
Joined on Apr 2010
|
#113
|
|
2011-02-09
, 12:30
|
Posts: 53 |
Thanked: 20 times |
Joined on Jan 2010
|
#114
|
# $number is like '+447123456789' # the end bit of the number. this seems to be used in the group_uid field -- no idea what for partialnumber=$(echo $number | sed -r 's/.*([0-9]{7})$/\1/') # $message is the message message=${message//\'/\'\'} #replace singlequotes with double-singlequotes for sqlite # build query query="insert into Events (service_id, event_type_id, storage_time, start_time, end_time, is_read, flags, bytes_sent, bytes_received, local_uid, local_name, remote_uid, free_text, group_uid, outgoing, mc_profile) values (3, 7, strftime('%s', 'now'), strftime('%s', 'now'), 0, 1, 0, 0, 0, 'ring/tel/ring', '<SelfHandle>', '$number', '$message', '$partialnumber', 1, 0);" echo "$query" | sqlite3 $HOME/.rtcom-eventlogger/el-v1.db
The Following 3 Users Say Thank You to tremby For This Useful Post: | ||
|
2011-02-09
, 12:40
|
|
Posts: 533 |
Thanked: 1,341 times |
Joined on Dec 2010
@ Italy
|
#115
|
The Following User Says Thank You to sakya For This Useful Post: | ||
|
2011-02-09
, 12:57
|
Posts: 37 |
Thanked: 18 times |
Joined on Apr 2010
|
#116
|
The Following User Says Thank You to hutchinsfairy For This Useful Post: | ||
|
2011-02-09
, 20:48
|
|
Posts: 533 |
Thanked: 1,341 times |
Joined on Dec 2010
@ Italy
|
#117
|
|
2011-02-10
, 00:21
|
Posts: 53 |
Thanked: 20 times |
Joined on Jan 2010
|
#118
|
|
2011-02-10
, 08:33
|
|
Posts: 533 |
Thanked: 1,341 times |
Joined on Dec 2010
@ Italy
|
#119
|
|
2011-02-10
, 08:52
|
Posts: 37 |
Thanked: 18 times |
Joined on Apr 2010
|
#120
|
Last edited by jj0; 2011-02-09 at 11:51.