[Atrix 4G Themes and Apps] erickdraven:
Hi guys,

This is the first time i write for the forum since my first mobile (HTC excalibur)

I was a happy owner of an X10 until 2 weeks ago where i had the luck of getting an Atrix. There was just one thing missing and it was letting Launcher Pro widgets and 3rd part dialer get the contact pics. What's the point in having all those and not being able to use them? Apart from that then you have to use sinc my pics to do the job for you and then deleting the pics becomes a pain ... (Syncmypics rules by the way, i used it a lot of time).

Well then to the point! All credits goes to My_Immortal from X10 forum who showed me the way of getting that done on X10. It seems I'm the first on doing it on Atrix and all the ppl that did that before on other phones.

I'm not responsible if anything happens to your phone I did that on mine because i like to experiment and I'm willing to pay the consequences.

Update*****

1.- After playing a while with this I was not able to link accounts. checking what's wrong

2.- Screen started flashing and i had no contacts on my address book and dialer stopped showing anything.

3.- 2. was caussed because i was playing with the permissions they should be set to Group: read,write,execute Others: read, execute

4.- After updating the contacts2.db I am not able to create or link contacts. I'm looking into that. Still too soon to enjoy this! :S

5.- Please do not use this until i find where the problem is!

6.- The procedure is far from perfect, I'm having a ton of issues. Will check at night what might be the cause and the relationship between databases!

******end of update

What to do:

1.- Get a backup of contacts2.db

2.- Get a backup of contacts2.db

3.- Get a backup of contacts2.db

4.-

If you can use adb shell and your phone can use sqlite3 do:

Connect your phone to your PC and select USB connection to none

adb devices (see if your phone is connected)

adb shell (this should open the command prompt of the phone you will see a $)

$su (change the privileges you will see a #)

#sqlite3 /data/data/com.motorola.blur.providers.contacts/databases/contacts2.db "CREATE TRIGGER unrestrict_new_data AFTER INSERT ON raw_contacts BEGIN UPDATE raw_contacts SET is_restricted=0 WHERE _id=NEW._id and NEW.is_restricted!=0 and NEW.account_type in ('com.motorola.blur.service.bsutils.MOTHER_USER_CREDS_TYPE'); END; CREATE TRIGGER unrestrict_updated_data AFTER UPDATE OF is_restricted ON raw_contacts BEGIN UPDATE raw_contacts SET is_restricted=0 WHERE _id=NEW._id and NEW.is_restricted!=0 and NEW.account_type in ('com.motorola.blur.service.bsutils.MOTHER_USER_CREDS_TYPE'); END; UPDATE raw_contacts SET is_restricted=0 WHERE is_restricted!=0 AND account_type in ('com.motorola.blur.service.bsutils.MOTHER_USER_CREDS_TYPE');"

This should do the trick! Voila you have pics on your contacts

-Personally this didn't work for myself. I got the sqlite3 not found

so i did:

Use root explorer (buy it, it's an awesome app) mount your phone R/W (button on the upper right corner of your screen) go to:

/data/data/com.motorola.blur.providers.contacts/databases

In that folder copy contacts2.db

hit back until you are in the root /

go to /sdcard-ext/

hit paste

now mount your phone on windows (set usb connection to mass storage)

Copy from the phone the contacts2.db to your desktop

Download a windows sqilite browser or editor.

hxxp://sourceforge.net/projects/sqlitebrowser/ -------free one

Open the program and drag contacts2.db to the sqlite database browser

Go to Execute SQL

Paste the following:

CREATE TRIGGER unrestrict_new_data AFTER INSERT ON raw_contacts BEGIN UPDATE raw_contacts SET is_restricted=0 WHERE _id=NEW._id and NEW.is_restricted!=0 and NEW.account_type in ('com.motorola.blur.service.bsutils.MOTHER_USER_CREDS_TYPE'); END; CREATE TRIGGER unrestrict_updated_data AFTER UPDATE OF is_restricted ON raw_contacts BEGIN UPDATE raw_contacts SET is_restricted=0 WHERE _id=NEW._id and NEW.is_restricted!=0 and NEW.account_type in ('com.motorola.blur.service.bsutils.MOTHER_USER_CREDS_TYPE'); END; UPDATE raw_contacts SET is_restricted=0 WHERE is_restricted!=0 AND account_type in ('com.motorola.blur.service.bsutils.MOTHER_USER_CREDS_TYPE');

Hit execute query button

That's it!! after this you should be done! Save the changes on the data base

Now copy it back to your SD card

unmount your sdcard

open root explorer, enable R/W

copy from the sdcard the contacts2.db

paste it in:

/data/data/com.motorola.blur.providers.contacts/databases

Remember to change the original contacts2.db to contacts2.db.bk (anything will do)

Reboot, enjoy!

I got a few FC from a google service 5 to be exact i restarted 2 times and waited a few minutes and they did not appear again.

(com.google.process.gapps) I'm looking into what is happening if someone finds what the problem is I'd apreciate it!

Well i hope you fin it helpfull !

Cheers