Line /data/data/jp.naver.line.android/databases/naver_line select m_id, contact_id, name from contacts groups: select mid where chat_id = ... SELECT name FROM "chat_member" join contacts on chat_member.mid = contacts.m_id where chat_id = ...; select chat_id, from_mid, content, created_time, sent_count from chat_history order by created_time select chat_id, from_mid, content, ch.created_time, sent_count , name from chat_history as ch left join contacts as c on ch.from_mid = c.m_id order by ch.created_time Per trovare il proprio name, se ci sono delle chat gruppo, si trova nel content: select chat_id, content from chat_history where server_id is null and type > 1 Il content e' una sequenza di tre linee (numero, mid, name) Per trovare il proprio id: /data/data/jp.naver.line.android/databases/naver_line_myhome select mid from my_home_status mid u556d5033611710525c1bdd9a7d9a26b7