libpurple/resources/conversationmanager/statements/query-properties.sql@099e1dfb856b (annotated)
libpurple/resources/conversationmanager/statements/query-properties.sql
Sun, 10 Aug 2025 23:44:08 +0800
- author
- Gong Zhile <gongzl@stu.hebust.edu.cn>
- date
- Sun, 10 Aug 2025 23:44:08 +0800
- branch
- purple_conversation_find_message_by_id
- changeset 43309
- 099e1dfb856b
- parent 43284
- 50c1bcc45576
- permissions
- -rw-r--r--
Add Purple.Conversation.find_message_by_id
The method was added so that a protocol or plugin could easily lookup
for the reference for a message. This will be especially useful when a
protocol received a quoted message but only with an id.
|
43284
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
1 | SELECT |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
2 | account_id, -- construct only |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
3 | age_restricted AS conv_age_restricted, |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
4 | alias AS conv_alias, |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
5 | conversation_id, -- construct only |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
6 | created_on AS conv_created_on, |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
7 | creator_id, |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
8 | description AS conv_description, |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
9 | drafting AS conv_drafting, |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
10 | favorite AS conv_favorite, |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
11 | federated, -- construct only |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
12 | logging AS conv_logging, |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
13 | needs_attention AS conv_needs_attention, |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
14 | title AS conv_title, |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
15 | topic AS conv_topic, |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
16 | topic_author_id, |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
17 | topic_updated AS conv_topic_updated, |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
18 | type, -- construct only |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
19 | url AS conv_url, |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
20 | user_nickname AS conv_nickname |
|
50c1bcc45576
Load conversations back in from the database
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
21 | FROM conversations |
