function photos_access_update_7301 in Album Photos 7.3
Add collaborate column to {photos_access_user}.
File
- photos_access/
photos_access.install, line 105 - Install, update, and uninstall functions for the Photos Access module.
Code
function photos_access_update_7301() {
// Add collaborate column to {'photos_access_user'}.
$spec = array(
'type' => 'int',
'size' => 'tiny',
'length' => 1,
'default' => 0,
);
db_add_field('photos_access_user', 'collaborate', $spec);
// Update {'photos_access_user'}.collaborate to match {'photos_access_album'}.updateid.
// Attempt to clean up {photos_access_album} duplicate entries.
// Update {photos_access_user}.id to match the correct {photos_access_album}.id for nid.
$new_id = array();
$results = db_query("SELECT * FROM {photos_access_album}");
foreach ($results as $result) {
if (isset($new_id[$result->nid])) {
$id = $new_id[$result->nid];
// Update {photos_access_user}.id
db_update('photos_access_user')
->fields(array(
'id' => $id,
'collaborate' => $result->updateid,
))
->condition('id', $result->id)
->execute();
// Make sure new records are not set to open by default.
if ($result->viewid > 0) {
db_update('photos_access_album')
->fields(array(
'viewid' => $result->viewid,
))
->condition('id', $id)
->execute();
}
// Preserve album passwords.
if ($result->pass != 1) {
db_update('photos_access_album')
->fields(array(
'pass' => $result->pass,
))
->condition('id', $id)
->execute();
}
// Delete duplicate entries in {photos_access_album}.
db_delete('photos_access_album')
->condition('id', $result->id)
->execute();
}
else {
$new_id[$result->nid] = $result->id;
db_update('photos_access_user')
->fields(array(
'collaborate' => $result->updateid,
))
->condition('id', $result->id)
->execute();
}
}
// Remove updateid from {'photos_access_album'}.
db_drop_field('photos_access_album', 'updateid');
// Rebuild permissions.
node_access_rebuild(TRUE);
}