Chat Room

• View documentation
• List references

Definition

_node_access_join_sql($node_alias = 'n', $node_access_alias = 'na')
drupal/modules/node/node.module, line 2769

Description

Generate an SQL join clause for use in fetching a node listing.

Parameters

$node_alias If the node table has been given an SQL alias other than the default "n", that must be passed here.

$node_access_alias If the node_access table has been given an SQL alias other than the default "na", that must be passed here.

Return value

An SQL join clause.

Related topics

Name	Description
Node access rights	The node access system determines who can do what to which nodes.

Code

function _node_access_join_sql($node_alias = 'n', $node_access_alias = 'na') {
  if (user_access('administer nodes')) {
    return '';
  }

  return 'INNER JOIN {node_access} '. $node_access_alias .' ON '. $node_access_alias .'.nid = '. $node_alias .'.nid';
}