So far the only way I've found to sync 3rd party apps (dialer one for instance) with your facebook contacts is the following line of code
sqlite3
/data/data/com.android.providers.contacts/database
s/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');"
However, droid x doesn't seem to have sqlite3 in the term emulator? When I try it says:
sqlite3: not found
Any other ways to do this? any help at all?
thanks!
sqlite3
/data/data/com.android.providers.contacts/database
s/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');"
However, droid x doesn't seem to have sqlite3 in the term emulator? When I try it says:
sqlite3: not found
Any other ways to do this? any help at all?
thanks!