View source
<?php
function book_access_enable() {
node_access_needs_rebuild();
}
function book_access_disable() {
node_access_needs_rebuild();
}
function book_access_schema() {
$schema = array();
$schema['book_access_role'] = array(
'description' => 'Table for tracking book access.',
'fields' => array(
'nid' => array(
'description' => 'Primary key: The node ID of the book.',
'type' => 'int',
'not null' => TRUE,
'default' => 0,
),
'rid' => array(
'description' => 'Primary key: The role ID associated with a book node ID.',
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
'grant_view' => array(
'description' => 'View book pages permission.',
'type' => 'int',
'size' => 'tiny',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
'grant_update' => array(
'description' => 'Edit book pages permission.',
'type' => 'int',
'size' => 'tiny',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
'grant_delete' => array(
'description' => 'Delete book pages permission.',
'type' => 'int',
'size' => 'tiny',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
),
'primary key' => array(
'nid',
'rid',
),
);
$schema['book_access_user'] = array(
'description' => 'Table for tracking book access by user.',
'fields' => array(
'nid' => array(
'description' => 'Primary key: The node ID of the book.',
'type' => 'int',
'not null' => TRUE,
'default' => 0,
),
'uid' => array(
'description' => 'Primary key: The user ID associated with a book node ID.',
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
'grant_view' => array(
'description' => 'View book pages permission.',
'type' => 'int',
'size' => 'tiny',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
'grant_update' => array(
'description' => 'Edit book pages permission.',
'type' => 'int',
'size' => 'tiny',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
'grant_delete' => array(
'description' => 'Delete book pages permission.',
'type' => 'int',
'size' => 'tiny',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
),
'primary key' => array(
'nid',
'uid',
),
);
return $schema;
}
function book_access_install() {
drupal_install_schema('book_access');
db_query("UPDATE {system} SET weight = 2 WHERE name = 'book_access'");
}
function book_access_update_6100() {
$ret[] = update_sql("UPDATE {system} SET weight = 2 WHERE name = 'book_access'");
return $ret;
}
function book_access_update_6101() {
$ret = array();
$schema = array();
$schema['book_access_user'] = array(
'fields' => array(
'nid' => array(
'type' => 'int',
'not null' => TRUE,
'default' => 0,
),
'uid' => array(
'type' => 'int',
'not null' => TRUE,
'default' => 0,
),
'grant_view' => array(
'type' => 'int',
'size' => 'tiny',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
'grant_update' => array(
'type' => 'int',
'size' => 'tiny',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
'grant_delete' => array(
'type' => 'int',
'size' => 'tiny',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
),
'primary key' => array(
'nid',
'uid',
),
);
if (!db_table_exists('book_access_user')) {
db_create_table($ret, 'book_access_user', $schema['book_access_user']);
}
if (!db_table_exists('book_access_role')) {
db_rename_table($ret, 'book_access', 'book_access_role');
}
return $ret;
}
function book_access_update_6103() {
$ret = array();
$ret[] = update_sql("UPDATE {node_access} SET realm = 'book_access_role' WHERE realm = 'book_access'");
return $ret;
}
function book_access_update_6104() {
$ret = array();
db_drop_primary_key($ret, 'book_access_role');
db_change_field($ret, 'book_access_role', 'rid', 'rid', array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
));
db_change_field($ret, 'book_access_role', 'grant_view', 'grant_view', array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
));
db_change_field($ret, 'book_access_role', 'grant_update', 'grant_update', array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
));
db_change_field($ret, 'book_access_role', 'grant_delete', 'grant_delete', array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
));
db_add_primary_key($ret, 'book_access_role', array(
'nid',
'rid',
));
db_drop_primary_key($ret, 'book_access_user');
db_change_field($ret, 'book_access_user', 'uid', 'uid', array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
));
db_change_field($ret, 'book_access_user', 'grant_view', 'grant_view', array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
));
db_change_field($ret, 'book_access_user', 'grant_update', 'grant_update', array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
));
db_change_field($ret, 'book_access_user', 'grant_delete', 'grant_delete', array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
));
db_add_primary_key($ret, 'book_access_user', array(
'nid',
'uid',
));
}
function book_access_update_6105() {
$ret = array();
if (!variable_get('menu_rebuild_needed', FALSE)) {
variable_set('menu_rebuild_needed', TRUE);
$ret[] = array(
'success' => TRUE,
'query' => 'Updated the module menus',
);
}
cache_clear_all('*', 'cache_block', TRUE);
cache_clear_all('*', 'cache_form', TRUE);
cache_clear_all('*', 'cache_page', TRUE);
$ret[] = array(
'success' => TRUE,
'query' => 'Cleared the cache',
);
return $ret;
}
function book_access_update_6106() {
$ret[] = update_sql("DELETE FROM {node_access} WHERE nid = 0");
return $ret;
}
function book_access_uninstall() {
drupal_uninstall_schema('book_access');
variable_del('book_access_default_roles_access');
variable_del('book_access_default_users_access');
}