[MOD] Un-restrict Facebook Contact Data [NOW WITH ZIP FOR XREC!] - XPERIA X10 Android Development

Hello!
For a while now, many users have faced the issue of Facebook Contact Pictures not appearing in some 3rd party applications. For example, ChompSMS, Handcent, GO SMS, 4rd party dialers, etc.
One way around this is to contact each application's developer and ask them to implement a solution, but, we all know, that doesn't always work...
So, I found a way to edit the contacts database, so that Facebook data will no more be restricted.
And it is a permanent solution applying to all previous and all new and updated data.
Thanks to Adolf1994, this can be done by simply flashing the attached zip via xRecovery. It should work for EVERY rom, ANY android version!
Now with the flashable zip, it's easier for ROM cookers to implement it on their ROMS.
For example, erickwill already implemented it in his super-fast optimised 2.1 X10x EWJet V009.5 ROM!
For reference, I am keeping the manual way posted here:
Manual Installation
It can be done via PC (if you have the android SDK properly set up and you are therefore familiar with adb)
or on your phone via a terminal emulator app or GScript.
Step 1: Connect your phone to your PC.
Step 2: Start->Run->cmd
Step 3: Copy and paste this on the terminal window:
adb shell sqlite3 /data/data/com.android.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.facebook.auth.login'); 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.facebook.auth.login'); END; UPDATE raw_contacts SET is_restricted=0 WHERE is_restricted!=0 AND account_type in ('com.facebook.auth.login');"
You won't get any message in return, don't worry about it, it worked.
To make sure, try to run the command again, you will get this:
Error: trigger unrestrict_new_data already exists
That means it worked the first time!
Now, if you are using a terminal on your phone, copy the same command, without the adb shell (after acquiring su access of course).
su
(press Enter and wait for the # to appear, then type the following)
sqlite3 /data/data/com.android.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.facebook.auth.login'); 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.facebook.auth.login'); END; UPDATE raw_contacts SET is_restricted=0 WHERE is_restricted!=0 AND account_type in ('com.facebook.auth.login');"
Or, in GScript, create new script, check "Needs SU" and paste the above command, save and run!
Step 4: Reboot and Enjoy!
FAQ (please read BEFORE posting)
Q: I can't use adb/I get adb is not recognised blah-blah-blah.
A: Check this out, thanks DoomLord!
Q: I get sqlite: permission denied.
A: Try this! Thanks gregbradley!
Q: I get adb: permission denied.
A: There's a chance you don't have shell root. Try this.
Q: Will it work for me?
A: This method works on every 2.2 ROM.
It can work on 2.1 stock too, but you need to edit the file on your PC and push it back to the phone,
because sqlite3 seems to not be included. Here is a tutorial.
Click to expand...
Click to collapse
Remember to hit the Thanks button if you find this useful and/or appreciate the effort of building this tutorial!
Kind regards,
Iris

---

My_Immortal said:
Hello!
For a while now, many users have faced the issue of Facebook Contact Pictures not appearing in some 3rd party applications. For example, ChompSMS, Handcent, GO SMS, 4rd party dialers, etc.
One way around this is to contact each application's developer and ask them to implement a solution, but, we all know, that doesn't always work...
So, I found a way to edit the contacts database, so that Facebook data will no more be restricted.
And it is a permanent solution applying to all previous and all new and updated data.
It is very easy, it can be done via PC or on your phone via a terminal emulator app.
Step 1: Connect your phone to your PC.
Step 2: Start->Run->cmd
Step 3: Copy and paste this on the terminal window:
adb shell sqlite3 /data/data/com.android.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.facebook.auth.login'); 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.facebook.auth.login'); END; UPDATE raw_contacts SET is_restricted=0 WHERE is_restricted!=0 AND account_type in ('com.facebook.auth.login');"
You won't get any message in return, don't worry about it, it worked.
To make sure, try to run the command again, you will get this:
Error: trigger unrestrict_new_data already exists
That means it worked the first time!
Now, if you are using a terminal on your phone, copy the same command, without the adb shell.
sqlite3 /data/data/com.android.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.facebook.auth.login'); 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.facebook.auth.login'); END; UPDATE raw_contacts SET is_restricted=0 WHERE is_restricted!=0 AND account_type in ('com.facebook.auth.login');"
Step 4: Reboot and Enjoy!
NOTE: This method works on every 2.2 ROM.
It can work on 2.1 stock too, but you need to edit the file on your PC and push it back to the phone,
because sqlite3 seems to not be included. If anyone is interested in applying this on 2.1 ROM, I will make a tutorial.
Kind regards,
Iris
Click to expand...
Click to collapse
it comes as " 'adb' is not recognised as internal or external command"
Pls help

---

a2441918 said:
it comes as " 'adb' is not recognised as internal or external command"
Pls help
Click to expand...
Click to collapse
You need to have the androidSDK installed on your PC for this to work.
Try doing it on your phone, via Terminal Emulator.
PS: Please don't quote the first post, it's huge and you posted right underneath it, we all know what you're talking about.

---

As a noob, i hope somebody will do a .zip file ^^
Sent from my toilet using my X10i powered by Wolf's latest CM6 Rom

---

Cool! I'm going to try it out! It works also with the Arc phonebook right?

---

PlayGunsta said:
Cool! I'm going to try it out! It works also with the Arc phonebook right?
Click to expand...
Click to collapse
No matter which phonebook app you are using it will work, as it changes the core contact database!
amus76 said:
As a noob, i hope somebody will do a .zip file ^^
Click to expand...
Click to collapse
It might come to you as a disappointment, but this is not going to happen!
You need to edit your own unique contact database!
It's easy to do though, doesn't hurt to try! Good luck!

---

My_Immortal said:
No matter which phonebook app you are using it will work, as it changes the core contact database!
Click to expand...
Click to collapse
Thanks! Never found those facebook_fix.zip things in WolfBreak his thread! And here it is! Finally a solution

---

sqlite3: permission denied
running wolf's 6.13v6

---

PlayGunsta said:
Thanks! Never found those facebook_fix.zip things in WolfBreak his thread! And here it is! Finally a solution
Click to expand...
Click to collapse
As I said in the OP, this fix solves problems like Facebook pictures not showing up in 3rd party apps. I don't know what the problem was on WB ROM, but since with this command Facebook data is being un-restricted, it could help you.
And, let me say, it can't cause any damage whatsoever, so feel free to try!

---

soblecram said:
sqlite3: permission denied
running wolf's 6.13v6
Click to expand...
Click to collapse
Did you tupe su first?

---

My_Immortal said:
Did you tupe su first?
Click to expand...
Click to collapse
Did it from adb command prompt...
need to find a terminal editor

---

My_Immortal said:
It might come to you as a disappointment, but this is not going to happen!
You need to edit your own unique contact database!
It's easy to do though, doesn't hurt to try! Good luck!
Click to expand...
Click to collapse
Could always make a .sh... seems like something a script could do... just an idea.
Good job on finding this.

---

soblecram said:
Did it from adb command prompt...
need to find a terminal editor
Click to expand...
Click to collapse
Here's one!

---

bleached45 said:
Could always make a .sh... seems like something a script could do... just an idea.
Good job on finding this.
Click to expand...
Click to collapse
Yes, you can make a script with GScript using the command in the OP.

---

all worked perfect for me!
cheers

---

soblecram said:
Did it from adb command prompt...
need to find a terminal editor
Click to expand...
Click to collapse
Actually, just changed permission on sqlite. worked fine.. just rebooting now.

---

Is there a way for me to copy the thing and place it on my phones sd card and then open then copy and paste into terminal emulator?

---

lythanhlong said:
Is there a way for me to copy the thing and place it on my phones sd card and then open then copy and paste into terminal emulator?
Click to expand...
Click to collapse
Yes, of course, make a txt with the command, place it on your SD and then open it in a text editor, copy, paste...

---

Tried on X10 said permisson denied. :/

---

lythanhlong said:
Tried on X10 said permisson denied. :/
Click to expand...
Click to collapse
Did you type su first?
Meaning, on the Terminal Emulator:
su
(press enter and wait for the # to appear)
then paste the command?