Skip to content

Add query to fetch global topics #1

@MasterMind2k

Description

@MasterMind2k

PhpBB3 now has global topics. Add a query for flask to be able to fetch it.

Use the following query

 fetch_global_topics = ("SELECT" " t.topic_id," " t.forum_id," " t.topic_title," " t.topic_time," " t.topic_first_poster_name," " p.post_subject," " p.post_text " " FROM" " {TABLE_PREFIX}topics t" " INNER JOIN {TABLE_PREFIX}posts p ON" " p.post_id = t.topic_first_post_id" " WHERE" " t.topic_type = 3" " AND t.forum_id = %(forum_id)s"),

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions