Drupal e-Commerce API

_node_access_join_sql

• Drupal 5.x
• Drupal 6.x

Versions

5 – 6

_node_access_join_sql($node_alias = 'n', $node_access_alias = 'na')

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

Node access rights

The node access system determines who can do what to which nodes.

Code

drupal-5/modules/node/node.module, line 2828

<?php
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';
}
?>