search

andreas-mausch / whatsapp-viewer

Small tool to display chats from the Android msgstore.db database (crypt12)
https://andreas-mausch.de/whatsapp-viewer/
MIT License
1.28k stars 385 forks source link

Use chat_view instead of chat_list #128

Closed ElDavoo closed 3 years ago

ElDavoo commented 3 years ago

Since the multi-device update, the chat_list table disappeared. The chat_view view is used instead to get the conversation list.

Credits to @ReMiOS for the updated query!

Closes #127 .

andreas-mausch commented 3 years ago

Thanks. I can't test it right now, but if you tell me it works I'm happy to merge and release it. I'd love to have a way to support old and new databases, but that's a topic for itself.

So my question is: Have you compiled and tested it?

gauss-code commented 3 years ago

Dear Andreas,

Thank you for the wonderful tool and your time. @ElDavoo could you confirm if you tested it.

@andreas-mausch could you release it perhaps in a new branch or test it and then release it please

ElDavoo commented 3 years ago

@ElDavoo could you confirm if you tested it.

Yay it works

andreas-mausch commented 3 years ago

Thank you. Could you please tell me the datatype of the chat_view.hidden field?

Also, it would be great if somebody could provide a test database file.

ElDavoo commented 3 years ago

Hi! hidden is an INTEGER , though looks like only the values 0 and 1 are used. For the test DB, is it ok if I create a blank whatsapp account, create some test chats and remove sensitive data?

andreas-mausch commented 3 years ago

That's actually a good idea. I can do it myself.

I've always used my main WhatsApp account for developing, which is on an un-rooted phone and therefore I only did backups like once every two years. That's why it was always a bit of work to setup further development.

Thanks for the quick response, I will merge this today.