Function __global->get_privacy_where_clause
Definitions
sources/content_privacy.php
- Get the SQL extension clauses for implementing privacy.
- Visibility: public
- Is abstract?: No
- Is static?: No
- Is final?: No
- Returns: array
Parameters
| Name | Type | Passed by reference? | Variadic? | Default | Set | Range | Description |
|---|---|---|---|---|---|---|---|
| $content_type | ID_TEXT | No | No | required parameter | N/A | N/A | The content type |
| $table_alias | ID_TEXT | No | No | required parameter | N/A | N/A | The table alias in the main query |
| $viewing_member_id | ?MEMBER | No | No | Null | N/A | N/A | Viewing member to check privacy against (null: current member) |
| $additional_or | string | No | No | Blank (empty string) | N/A | N/A | Additional OR clause for letting the user through |
| $submitter | ?MEMBER | No | No | Null | N/A | N/A | Member owning the content (null: do dynamically in query via content hook). Usually pass as null |
Returns
- A tuple: extra JOIN clause, extra WHERE clause, table clause (rarely used), direct table WHERE clause (rarely used)
- Type: array
- Set: N/A
- Range: N/A
Preview
Code (PHP)
/**
* Get the SQL extension clauses for implementing privacy.
*
* @param ID_TEXT $content_type The content type
* @param ID_TEXT $table_alias The table alias in the main query
* @param ?MEMBER $viewing_member_id Viewing member to check privacy against (null: current member)
* @param string $additional_or Additional OR clause for letting the user through
* @param ?MEMBER $submitter Member owning the content (null: do dynamically in query via content hook). Usually pass as null
* @return array A tuple: extra JOIN clause, extra WHERE clause, table clause (rarely used), direct table WHERE clause (rarely used)
*/
function get_privacy_where_clause(string $content_type, string $table_alias, ?int $viewing_member_id = null, string $additional_or = '', ?int $submitter = null) : array
* Get the SQL extension clauses for implementing privacy.
*
* @param ID_TEXT $content_type The content type
* @param ID_TEXT $table_alias The table alias in the main query
* @param ?MEMBER $viewing_member_id Viewing member to check privacy against (null: current member)
* @param string $additional_or Additional OR clause for letting the user through
* @param ?MEMBER $submitter Member owning the content (null: do dynamically in query via content hook). Usually pass as null
* @return array A tuple: extra JOIN clause, extra WHERE clause, table clause (rarely used), direct table WHERE clause (rarely used)
*/
function get_privacy_where_clause(string $content_type, string $table_alias, ?int $viewing_member_id = null, string $additional_or = '', ?int $submitter = null) : array
