$module, 'name' => $name, 'number' => $number ); drupal_write_record('acl', $acl); return $acl['acl_id']; } /** * Delete an existing ACL. */ function acl_delete_acl($acl_id) { db_delete('acl') ->condition('acl_id', $acl_id) ->execute(); db_delete('acl_user') ->condition('acl_id', $acl_id) ->execute(); db_delete('acl_node') ->condition('acl_id', $acl_id) ->execute(); } /** * Add the specified UID to an ACL. */ function acl_add_user($acl_id, $uid) { $test_uid = db_query("SELECT uid FROM {acl_user} WHERE acl_id = :acl_id AND uid = :uid", array( 'acl_id' => $acl_id, 'uid' => $uid, ))->fetchField(); if (!$test_uid) { db_insert('acl_user') ->fields(array( 'acl_id' => $acl_id, 'uid' => $uid, )) ->execute(); } } /** * Remove the specified UID from an ACL. */ function acl_remove_user($acl_id, $uid) { db_delete('acl_user') ->condition('acl_id', $acl_id) ->condition('uid', $uid) ->execute(); } /** * Provide a form to edit the ACL that can be embedded in other forms. * Pass $new_acl=TRUE if you have no ACL yet, but do supply a string * like 'my_module_new_acl' as $acl_id anyway. */ function acl_edit_form(&$form_state, $acl_id, $label = NULL, $new_acl = FALSE) { $form_state['build_info']['files'][] = _acl_module_load_include('admin.inc'); return _acl_edit_form($acl_id, $label, $new_acl); } /** * Provide access control to all nodes selected by a subquery, based upon an ACL id. */ function acl_add_nodes($subselect, $acl_id, $view, $update, $delete, $priority = 0) { db_delete('acl_node') ->condition('acl_id', $acl_id) ->condition('nid', $subselect, 'IN') ->execute(); $subselect->addExpression($acl_id, 'acl_id'); $subselect->addExpression((int) $view, 'grant_view'); $subselect->addExpression((int) $update, 'grant_update'); $subselect->addExpression((int) $delete, 'grant_delete'); $subselect->addExpression($priority, 'priority'); db_insert('acl_node') ->from($subselect) ->execute(); } /** * Provide access control to a node based upon an ACL id. */ function acl_node_add_acl($nid, $acl_id, $view, $update, $delete, $priority = 0) { db_delete('acl_node') ->condition('acl_id', $acl_id) ->condition('nid', $nid) ->execute(); db_insert('acl_node') ->fields(array( 'acl_id' => $acl_id, 'nid' => $nid, 'grant_view' => (int) $view, 'grant_update' => (int) $update, 'grant_delete' => (int) $delete, 'priority' => $priority, )) ->execute(); } /** * Remove an ACL completely from a node. */ function acl_node_remove_acl($nid, $acl_id) { db_delete('acl_node') ->condition('acl_id', $acl_id) ->condition('nid', $nid) ->execute(); } /** * Clear all of a module's ACL's from a node. */ function acl_node_clear_acls($nid, $module) { $acl_ids = db_query("SELECT acl_id FROM {acl} WHERE module = :module", array( 'module' => $module ))->fetchCol(); if ($acl_ids) { db_delete('acl_node') ->condition('nid', $nid) ->condition('acl_id', $acl_ids, 'IN') ->execute(); } } /** * Gets the id of an ACL by name (+ optionally number). */ function acl_get_id_by_name($module, $name, $number = NULL) { $query = db_select('acl', 'acl') ->addField('acl', 'acl_id') ->condition('module', $module) ->condition('name', $name); if (isset($number)) { $query->condition('number', $number); } return $query->execute()->fetchField(); } /** * Gets the id of an ACL by number. */ function acl_get_id_by_number($module, $number) { return db_query("SELECT acl_id FROM {acl} WHERE module = :module AND number = :number", array( 'module' => $module, 'number' => $number, ))->fetchField(); } /** * Determines if an acl has some assigned users */ function acl_has_users($acl_id) { return db_query("SELECT COUNT(uid) FROM {acl_user} WHERE acl_id = :acl_id", array( 'acl_id' => $acl_id, ))->fetchField(); } /** * Determines if an acl has a specific assigned user */ function acl_has_user($acl_id, $uid) { return db_query("SELECT COUNT(uid) FROM {acl_user} WHERE acl_id = :acl_id AND uid = :uid", array( 'acl_id' => $acl_id, 'uid' => $uid, ))->fetchField(); } /** * Gets an array of acl_ids held by a user */ function acl_get_ids_by_user($module, $uid, $name = NULL, $number = NULL) { $query = db_select('acl', 'a'); $query->join('acl_user', 'au', 'a.acl_id = au.acl_id'); $query ->fields('a', array('acl_id')) ->condition('a.module', $module) ->condition('au.uid', $uid); if (isset($name)) { $query->condition('a.name', $name); } if (isset($number)) { $query->condition('a.number', $number); } $acl_ids = $query->execute()->fetchCol(); return $acl_ids; } /** * Gets the uids of an acl */ function acl_get_uids($acl_id) { $uids = db_query("SELECT uid FROM {acl_user} WHERE acl_id = :acl_id", array( 'acl_id' => $acl_id, ))->fetchCol(); return $uids; } /** * Implementation of hook_node_access_records(). */ function acl_node_access_records($node) { if (!$node->nid) { return; } $result = db_query("SELECT n.*, 'acl' AS realm, n.acl_id AS gid, a.module FROM {acl_node} n INNER JOIN {acl} a ON n.acl_id = a.acl_id WHERE nid = :nid", array( 'nid' => $node->nid, ), array('fetch' => PDO::FETCH_ASSOC)); $grants = array(); foreach ($result as $grant) { if (module_invoke($grant['module'], 'enabled')) { if (acl_has_users($grant['gid'])) { $grants[] = $grant; } else { //just deny access $grants[] = array( 'realm' => 'acl', 'gid' => $grant['gid'], 'grant_view' => 0, 'grant_update' => 0, 'grant_delete' => 0, 'priority' => $grant['priority'], ); } } } return $grants; } /** * Implementation of hook_node_grants(). */ function acl_node_grants($account, $op) { $acl_ids = db_query("SELECT acl_id FROM {acl_user} WHERE uid = :uid", array( 'uid' => $account->uid, ))->fetchCol(); return (!empty($acl_ids) ? array('acl' => $acl_ids) : NULL); } /** * Implementation of hook_node_delete(). */ function acl_node_delete($node) { db_delete('acl_node') ->condition('nid', $node->nid) ->execute(); } /** * Implementation of hook_user_cancel(). */ function acl_user_cancel($edit, $account, $method) { db_delete('acl_user') ->condition('uid', $account->uid) ->execute(); } function _acl_module_load_include($type) { static $loaded = array(); if (!isset($loaded[$type])) { $path = module_load_include($type, 'acl'); $loaded[$type] = drupal_get_path('module', 'acl') . "/acl.$type"; } return $loaded[$type]; } /** * Implementation of hook_node_access_explain(). */ function acl_node_access_explain($row) { static $interpretations = array(); if ($row->realm == 'acl') { if (!isset($interpretations[$row->gid])) { $acl = db_query("SELECT * FROM {acl} WHERE acl_id = :acl_id", array( 'acl_id' => $row->gid, ))->fetchObject(); $acl->tag = '?'; if (!isset($acl->name)) { $acl->tag = $acl->number; } elseif (!isset($acl->number)) { $acl->tag = $acl->name; } else { $acl->tag = $acl->name . '-' . $acl->number; } $result = db_query("SELECT u.name FROM {acl_user} au, {users} u WHERE au.acl_id = :acl_id AND au.uid = u.uid", array( 'acl_id' => $row->gid, )); foreach ($result as $user) { $users[] = $user->name; } if (isset($users)) { $users = implode(', ', $users); $interpretations[$row->gid] = _acl_get_explanation("$acl->module/$acl->tag: $users", $acl->acl_id, $acl->module, $acl->name, $acl->number, $users); } elseif ($row->gid == 0) { $result = db_query("SELECT an.acl_id, a.module, a.name FROM {acl_node} an JOIN {acl} a ON an.acl_id = a.acl_id LEFT JOIN {acl_user} au ON a.acl_id = au.acl_id WHERE an.nid = :nid AND au.uid IS NULL", array( 'nid' => $row->nid, )); foreach ($result as $acl) { $rows[] = _acl_get_explanation("$acl->acl_id: $acl->module/$acl->tag", $acl->acl_id, $acl->module, $acl->name, $acl->number); } if (!empty($rows)) { return implode('
', $rows); } return 'No access via ACL.'; } else { $interpretations[$row->gid] = _acl_get_explanation("$acl->module/$acl->tag: no users!", $acl->acl_id, $acl->module, $acl->name, $acl->number); } } return $interpretations[$row->gid]; } } /** * Asks the client for its interpretation of the given grant record. */ function _acl_get_explanation($text, $acl_id, $module, $name, $number, $users = NULL) { $hook = $module .'_acl_explain'; if (function_exists($hook)) { return ''. $text .''; } return $text; }