Database Info

How to restore SMS backup from 1.73 builts on new 2.XX Hero builds

I have encountered the same "loading screen" problem when restoring sms from the old builds to the current new hero builds using Backup for Root Users. This is what I did to solve it:
the logcat reveals this missing table field "index_on_sim", thus using a sqlite editor, I compared the old mmssms.db and the new mmssms.db files. The missing field in under the sms table so all one need is to ADD the new field "index_on_sim" with type INTEGER. Upon careful observation, this field is used with value "-1" for incoming sms, not for outgoing ones.
Thus, I used the following sql commands:
1. to check for the correct index_on_sim rows with non-empty service_center info
=> SELECT sms.index_on_sim FROM sms WHERE service_center IS NOT NULL
2. to modify the above index_on_sim rows with '-1'
=> UPDATE sms SET index_on_sim = '-1' WHERE service_center IS NOT NULL
okay once done, verify that the rows are updated correctly and save the db.
push the edited mmssms.db to the Backup for Root Users folder or directly into /data/data/com.android.providers.telephony/databases.
That's it! Your old sms will appear in the new hero build.
Attached is the sqlite program. ( To be used in linux/ubuntu )

Anyone knows how to automate the above process with a script??

nice. i'll have to try this. thanks!
edit:
It worked great! Thanks again!
edit2:
Not sure why but I can't mark any of my new recieved text messages as read and the text messages that I sent have an icon to the right of it (notification? information? something).

I'm having the same problem also after editing the mmssms.db file

This is what worked for me i got it from a post on another forum here is a link to the original post: http://android.modaco.com/content-p...-2-versions-based-on-the-new-update/page/800/
Code:
adb shell
sqlite3 /data/data/com.android.providers.telephony/databases/mmssms.db
ALTER TABLE sms ADD COLUMN index_on_sim INTEGER DEFAULT -1;
(Press Control-D)
exit

[Q] Android App SQLite Database Creation - Where?

Ok, I don't get it.
Porting CM7 and I have an odd one - the stock email application blows up when an account is added. Tracing it down I found the problem - the Sqlite schema is defective. Here's what I have in /data/data under the appropriate directory, examined by Sqlite3
sqlite> .schema account
CREATE TABLE Account (_id integer primary key autoincrement, displayName text, emailAddress text, syncKey text, syncLookback integer, syncInterval text, hostAuthKeyRecv integer, hostAuthKeySend integer, flags integer, isDefault integer, compatibilityUuid text, senderName text, ringtoneUri text, protocolVersion text, newMessageCount integer, securityFlags integer, securitySyncKey text, signature text, accountColorinteger);
Note the last field. There's supposed to be a space there; when the table was created the type statement was obviously keyed next to the field name without the required space. It also appears that SQLite is perfectly happy to create a field in a table without an explicit type declaration, which disturbs me, but it is what it is.
Here's the thing - obviously somewhere there's a declaration of that variable and type in some file somewhere. Right?
Well, where is it then - because I can't find it with a complete pass through the source using find / grep!
Nevermind - found it. The android guys were cute with the defines in the code and it indeed was a missing space in the email provider source.....

[TUTORIAL] unread mail count tasker all mail clients (imap)

No idea where to put this, admin; feel free to move or delete.
There's a lot of really cool custom theming going on with Android and an often important part of that is the visual indication of missed phone calls, new messages, new mail, etc. (unread bubbles next to app icons, in lockscreens, etc.). There's a host of solutions to get this info but for me e-mail counts had always been a bit of a issue. Missed phone calls are tracked by the Android system, and WhatsApp notifications can be counted from the notification bar with Tasker and reset when you open the app because your phone is the only place where you will check your WhatsApp messages. E-mail however is not centralized in Android (yet) so if you use anything else than Gmail the system won't know how many unread mails you have and you could uee a notification counter on your mail app but when a new email arrives it will put the counter on +1, if you then read the e-mail on another device (for example your computer) your notification counter on your phone will still be on +1 even though you read the mail.You then have to open your mail app to get the counter back to 0 again.
That why I made this PHP / Tasker solution for my IMAP mail. This is a PHP script that checks how many unread mails there are in your inbox:
PHP:
<?php
function mailCount($host, $login, $passwd) {
$mbox = imap_open($host, $login, $passwd);
$mail = '';
if($mail = imap_check($mbox)) {
$msgnos = imap_search($mbox, 'UNSEEN');
return $msgnos;
}
}
$hostname = '{imap.yourhost.com:143/imap}INBOX';
$username = 'your_username';
$password = 'your_password';
$count = mailCount($hostname, $username, $password);
if ($count != "") $number = sizeof($count);
else $number = 0;
echo $number;
Change yourhost, your_username and your_password and the port (143). (if you want to, add some extra security by doing IP or Cookie checks), put the PHP file online on your server. The script will then simply show a number of unread mails in your inbox.
Then you can use Tasker to read this number. Add a tasks (for example CheckMailCount) then add the action Net > HTTP Get. For 'Serverort' fill in the url of your script (http://www.yourserver.com/unreadmail.php) and set the Mime Type to 'text/*'. Then in the same task add an action Variables > Variable Set. Give the variable a Name (for example: %MAILCOUNT) and set it To %HTTPD. This will set the %MAILCOUNT variable to the result of the last http Get request ie. the number of unread mails.
You now have a tasker variable with the actual number of unread mails in your inbox.
I use this on my WidgetLocker lockscreen so I trigger the task on Event > Display > On. I added a third action in the CheckMailCount action to set a Zooper Variable (Plugin > Zooper Widget Pro >Edit > ZW Variable = MAILNOTI, ZW Text = %MAILCOUNT) you could also make this %HTTPD straight away if you don't use the variable for anything else. You then have the #TMAILNOTI# variable in Zooper to use to display how many unread mails you have in a widget. I don't use the count but I display a mail icon indicating that I have a new mail if the #TMAILNOTI# is anything but 0. I do this by adding a bitmap in Zooper of a mail icon and then in Avanced Parameters I put
$#TMAILNOTI#=0?/sdcard/icons/nomail.png$
This tells Zooper that if the variable #TMAILNOTI# = 0 it should use the bitmap nomail.png in my icons folder on the sd card. nomail.png in my case is simply an empty transparent png.
Hope this helps somebody!

nielshtc said:
No idea where to put this, admin; feel free to move or delete.
There's a lot of really cool custom theming going on with Android and an often important part of that is the visual indication of missed phone calls, new messages, new mail, etc. (unread bubbles next to app icons, in lockscreens, etc.). There's a host of solutions to get this info but for me e-mail counts had always been a bit of a issue. Missed phone calls are tracked by the Android system, and WhatsApp notifications can be counted from the notification bar with Tasker and reset when you open the app because your phone is the only place where you will check your WhatsApp messages. E-mail however is not centralized in Android (yet) so if you use anything else than Gmail the system won't know how many unread mails you have and you could uee a notification counter on your mail app but when a new email arrives it will put the counter on +1, if you then read the e-mail on another device (for example your computer) your notification counter on your phone will still be on +1 even though you read the mail.You then have to open your mail app to get the counter back to 0 again.
That why I made this PHP / Tasker solution for my IMAP mail. This is a PHP script that checks how many unread mails there are in your inbox:
PHP:
<?php
function mailCount($host, $login, $passwd) {
$mbox = imap_open($host, $login, $passwd);
$mail = '';
if($mail = imap_check($mbox)) {
$msgnos = imap_search($mbox, 'UNSEEN');
return $msgnos;
}
}
$hostname = '{imap.yourhost.com:143/imap}INBOX';
$username = 'your_username';
$password = 'your_password';
$count = mailCount($hostname, $username, $password);
if ($count != "") $number = sizeof($count);
else $number = 0;
echo $number;
Change yourhost, your_username and your_password and the port (143). (if you want to, add some extra security by doing IP or Cookie checks), put the PHP file online on your server. The script will then simply show a number of unread mails in your inbox.
Then you can use Tasker to read this number. Add a tasks (for example CheckMailCount) then add the action Net > HTTP Get. For 'Serverort' fill in the url of your script (http://www.yourserver.com/unreadmail.php) and set the Mime Type to 'text/*'. Then in the same task add an action Variables > Variable Set. Give the variable a Name (for example: %MAILCOUNT) and set it To %HTTPD. This will set the %MAILCOUNT variable to the result of the last http Get request ie. the number of unread mails.
You now have a tasker variable with the actual number of unread mails in your inbox.
I use this on my WidgetLocker lockscreen so I trigger the task on Event > Display > On. I added a third action in the CheckMailCount action to set a Zooper Variable (Plugin > Zooper Widget Pro >Edit > ZW Variable = MAILNOTI, ZW Text = %MAILCOUNT) you could also make this %HTTPD straight away if you don't use the variable for anything else. You then have the #TMAILNOTI# variable in Zooper to use to display how many unread mails you have in a widget. I don't use the count but I display a mail icon indicating that I have a new mail if the #TMAILNOTI# is anything but 0. I do this by adding a bitmap in Zooper of a mail icon and then in Avanced Parameters I put
$#TMAILNOTI#=0?/sdcard/icons/nomail.png$
This tells Zooper that if the variable #TMAILNOTI# = 0 it should use the bitmap nomail.png in my icons folder on the sd card. nomail.png in my case is simply an empty transparent png.
Hope this helps somebody!
Click to expand...
Click to collapse
This looks way to confusing but I get it a little bit... lets say I want to use UCCW tasker variable option to show the counts...:silly:

[APP][2.0+] Search Contacts (Find contacts by their attributes)

Hello,
please check my latest app called 'Search Contacts':
Search Contacts gives you the possbility to easily find the contacts on your device by searching for their attributes.
Just enter the search term and the app will immediately show you all matching contacts and which attribute matched the search. Furthermore you can also directly share the contacts most important information by email or sms.
Search Contacts will search in all those contact attributes:
- Display name
- Phone numbers
- Email addresses
- Structured name (Given name, family name, prefix, middle name, phonetic given name, phonetic middle name, phonetic family name)
- Structured address (City, country, formatted address, neighborhood, pobox, postbox, region, street)
- Organization (Company, department, job description, office_location, phonetic name. symbol)
- Websites
- Note
- Nicknames
- Sip addresses
- Relations
Google Play
Maybe it's useful to someone

[Q] App to read NFC codes and write them to a text file

Hi guys,
I'm looking for an android app to read the value of an NFC chip and write that value to a text file.
What I'm looking for is basically the same functionality as when you would hook up an USB NFC-reader to a PC, and write the scanned values to a notepad file.
The situation in which this would be used is to scan people entering a training session on a company event.
Attendees would have an NFC-enabled name tag, and we have a list of nfc-values to correspond to the attendees already stored in the database.
Do you guys know of any apps that could provide this functionality?