LLMS_Integration_BBPress::get_forum_course_restrictions( int $forum_id )

Check if a forum is restricted to a course(s)

Parameters Parameters


(int) (Required) WP_Post ID of the forum.

Top ↑

Return Return


Top ↑

Source Source

File: includes/integrations/class.llms.integration.bbpress.php

	public function get_forum_course_restrictions( $forum_id ) {

		global $wpdb;
		$query = $wpdb->get_col( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
				"SELECT metas.post_id
			 FROM {$wpdb->postmeta} AS metas
			 JOIN {$wpdb->posts} AS posts on posts.ID = metas.post_id
			 WHERE metas.meta_key = '_llms_bbp_forum_ids'
			   AND metas.meta_value REGEXP %s
			   AND posts.post_status = 'publish';",
				'a:[0-9][0-9]*:\{(i:[0-9][0-9]*;(i|s:[0-9][0-9]*):"?[0-9][0-9]*"?;)*(i:[0-9][0-9]*;(i|s:[0-9][0-9]*):"?' . sprintf( '%d', absint( $forum_id ) ) . '"?;)'

		$query = array_map( 'absint', $query );

		return $query;


Top ↑

Changelog Changelog

Version Description
4.0.0 Escape { character in SQL query to add MySQL 8.0 support.
3.38.1 Make the query more generic so that it matches forum ids whether they've been saved as integers or strings.
3.12.0 Introduced.

Top ↑

User Contributed Notes User Contributed Notes

You must log in before being able to contribute a note or feedback.