nodeaccess.install in Nodeaccess 5

File

nodeaccess.install

<?php

/**
 * Implementation of hook_install().
 */
function nodeaccess_install() {

  // Create tables.
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {nodeaccess} (\n        nid int(10) unsigned NOT NULL default '0',\n        gid int(10) unsigned NOT NULL default '0',\n        realm varchar(255) NOT NULL default '',\n        grant_view tinyint(1) unsigned NOT NULL default '0',\n        grant_update tinyint(1) unsigned NOT NULL default '0',\n        grant_delete tinyint(1) unsigned NOT NULL default '0',\n        PRIMARY KEY (nid,gid,realm)\n      )");

      /*!40100 DEFAULT CHARACTER SET utf8 */
      db_query("CREATE TABLE {nodeaccess_role_alias} (\n        rid int(10) unsigned NOT NULL default '0',\n        name varchar(50) NOT NULL default '',\n        weight int(3) NOT NULL default '0',\n        PRIMARY KEY (rid)\n      )");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {nodeaccess} (\n        nid int_unsigned NOT NULL default '0',\n        gid int_unsigned NOT NULL default '0',\n        realm varchar(255) NOT NULL default '',\n        grant_view smallint_unsigned NOT NULL default '0',\n        grant_update smallint_unsigned NOT NULL default '0',\n        grant_delete smallint_unsigned NOT NULL default '0',\n        PRIMARY KEY (nid,gid,realm)\n      )");
      db_query("CREATE TABLE {nodeaccess_role_alias} (\n        rid int_unsigned NOT NULL default '0',\n        name varchar(50) NOT NULL default '',\n        weight smallint NOT NULL default '0',\n        PRIMARY KEY (rid)\n      )");
      break;
  }

  // Set up default permissions to be view for authenticated and
  // anonymous users, and all permissions for author.
  $grants = array();
  $grants[] = array(
    'gid' => 1,
    'realm' => 'nodeaccess_rid',
    'grant_view' => 1,
    'grant_update' => 0,
    'grant_delete' => 0,
  );
  $grants[] = array(
    'gid' => 2,
    'realm' => 'nodeaccess_rid',
    'grant_view' => 1,
    'grant_update' => 0,
    'grant_delete' => 0,
  );
  $author_prefs = array();
  foreach (node_get_types() as $type => $name) {
    variable_set('nodeaccess_' . $type, $grants);
    $author_prefs[$type] = array(
      'grant_view' => 1,
      'grant_update' => 1,
      'grant_delete' => 1,
    );
  }
  variable_set('nodeaccess_authors', $author_prefs);

  // Set up all permissions to be editable by default.
  $grant_prefs = array(
    'view' => 1,
    'edit' => 1,
    'delete' => 1,
  );
  variable_set('nodeaccess-grants', $grant_prefs);
}

/**
 * Implementations of hook_update_N().
 */
function nodeaccess_update_1() {

  // Create new nodeaccess table.
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {nodeaccess} (\n        nid int(10) unsigned NOT NULL default '0',\n        gid int(10) unsigned NOT NULL default '0',\n        realm varchar(255) NOT NULL default '',\n        grant_view tinyint(1) unsigned NOT NULL default '0',\n        grant_update tinyint(1) unsigned NOT NULL default '0',\n        grant_delete tinyint(1) unsigned NOT NULL default '0',\n        PRIMARY KEY (nid,gid,realm)\n      )");

      /*!40100 DEFAULT CHARACTER SET utf8 */
      break;
    case 'pgsql':
      db_query("CREATE TABLE {nodeaccess} (\n        nid int_unsigned NOT NULL default '0',\n        gid int_unsigned NOT NULL default '0',\n        realm varchar(255) NOT NULL default '',\n        grant_view smallint_unsigned NOT NULL default '0',\n        grant_update smallint_unsigned NOT NULL default '0',\n        grant_delete smallint_unsigned NOT NULL default '0',\n        PRIMARY KEY (nid,gid,realm)\n      )");
      break;
  }

  // Update format of content type specific variables.
  foreach (node_get_types() as $type => $name) {
    $perm = variable_get('nodeaccess_' . $type, array());
    if (count($perm) > 0) {
      foreach ($perm['rid'] as $role => $grants) {
        $new[] = array(
          'gid' => $grants[0],
          'realm' => 'nodeaccess_rid',
          'grant_view' => $grants['grant_view'],
          'grant_update' => $grants['grant_update'],
          'grant_delete' => $grants['grant_delete'],
        );
      }
      variable_set('nodeaccess_' . $type, $new);
    }
  }

  // Populate the new nodeaccess table with data from node_access.
  $result = db_query("SELECT na.nid, na.gid, na.realm, na.grant_view, na.grant_update, na.grant_delete, n.type FROM {node_access} na LEFT JOIN {node} n ON n.nid = na.nid WHERE na.realm = 'nodeaccess_uid' OR na.realm = 'nodeaccess_rid'");
  while ($row = db_fetch_object($result)) {
    $default = variable_get('nodeaccess_' . $row->type, array());
    if ($default['grant_view'] != $row->grant_view && $default['grant_update'] != $row->grant_update && $default['grant_delete'] != $row->grant_delete) {
      db_query("INSERT INTO {nodeaccess} (nid, gid, realm, grant_view, grant_update, grant_delete) VALUES (%d, %d, '%s', %d, %d, %d)", $row->nid, $row->gid, $row->realm, $row->grant_view, $row->grant_update, $row->grant_delete);
    }
  }
}
function nodeaccess_update_2() {

  // Clear menu cache because of changed menu location.
  cache_clear_all(NULL, 'cache_menu');
}
function nodeaccess_update_3() {

  // Create new nodeaccess_role_alias table.
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {nodeaccess_role_alias} (\n        rid int(10) unsigned NOT NULL default '0',\n        name varchar(50) NOT NULL default '',\n        weight int(3) NOT NULL default '0',\n        PRIMARY KEY (rid)\n      )");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {nodeaccess_role_alias} (\n        rid int_unsigned NOT NULL default '0',\n        name varchar(50) NOT NULL default '',\n        weight smallint NOT NULL default '0',\n        PRIMARY KEY (rid)\n      )");
      break;
  }

  // Set up default alias names to match role names and default
  // weights to 0. Do this for allowed roles only.
  $allowedrole = variable_get('nodeaccess-roles', array());
  foreach ($allowedrole as $rid => $value) {
    if ($value) {
      db_query("INSERT INTO {nodeaccess_role_alias} SELECT rid, name, 0 FROM {role} WHERE rid = %d", $rid);
    }
  }

  // Set up all permissions to be editable by default.
  $grant_prefs = array(
    'view' => 1,
    'edit' => 1,
    'delete' => 1,
  );
  variable_set('nodeaccess-grants', $grant_prefs);
}

/**
 * Implementation of hook_uninstall().
 */
function nodeaccess_uninstall() {

  // Remove variables.
  variable_del('nodeaccess-priority');
  variable_del('nodeaccess-preserve');
  variable_del('nodeaccess-grants');
  variable_del('nodeaccess-roles');
  variable_del('nodeaccess-types');
  variable_del('nodeaccess_authors');
  foreach (node_get_types() as $type => $name) {
    variable_del('nodeaccess_' . $type);
  }

  // Remove tables.
  db_query("DROP TABLE {nodeaccess}");
  db_query("DROP TABLE {nodeaccess_role_alias}");
}

Functions

Name	Description
nodeaccess_install	Implementation of hook_install().
nodeaccess_uninstall	Implementation of hook_uninstall().
nodeaccess_update_1	Implementations of hook_update_N().
nodeaccess_update_2
nodeaccess_update_3