Skip to content

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

What is item_type 4? #19

Closed
ReagentX opened this issue Jul 16, 2022 · 5 comments
Closed

What is item_type 4? #19

ReagentX opened this issue Jul 16, 2022 · 5 comments
Assignees
Labels
question Further information is requested

Comments

@ReagentX
Copy link
Owner

ReagentX commented Jul 16, 2022

There is an int column in the messages table called item_type. Normal messages are 0, channel announcements that update the room name are 2. I have a third item_type in my database, "aptly" named 4, and it seems to be a fully null message (no text or blob data, no associated message, nothing). What does 4 represent? Is there a 1?

@ReagentX ReagentX added the question Further information is requested label Jul 16, 2022
@ReagentX ReagentX self-assigned this Jul 16, 2022
@ReagentX
Copy link
Owner Author

ReagentX commented Jan 13, 2023

item_type 6 is used for SharePlay/FaceTime message balloons. Support for parsing this field was added in #57.

@tneotia
Copy link

tneotia commented Feb 12, 2023

Screenshot_20230211_105617_GitHub.png

Here's some more details on what item type and group action type combinations are

@ReagentX
Copy link
Owner Author

ReagentX commented Feb 12, 2023

This is great, how did the BlueBubbles team figure this out? Some of these I already support because you can deduce the context from other columns.

@tneotia
Copy link

tneotia commented Feb 12, 2023

I'd love to say there's some cool trickery behind it, but honestly it was just a brute force type thing. We sent as many "group event" type messages as we could figure out, then went in the chat.db and saw what item types and group action types they were labeled to.

If we ever get one we haven't added support for, we usually just have the person go into their iMessage app and see what it says there, and then ask them to send us the json message object stored on their app, which is visible to users for debug purposes.

It may be possible to deduce this more accurately from disassembling Messages.app, we have a contributor who has done this and uncovered some really interesting things.

@ReagentX
Copy link
Owner Author

That sounds about like what my experience is like!

Repository owner locked and limited conversation to collaborators Nov 22, 2023
@ReagentX ReagentX converted this issue into discussion #205 Nov 22, 2023

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants