vpx_beheer_update_42

Versions

mediamosa-174

vpx_beheer_update_42()

Code

vpx_beheer/vpx_beheer.install, line 610

<?php
function vpx_beheer_update_42() {
  $ret = array();

  // #849 issue NIBG

  $app_id = db_result(db_query("SELECT id FROM client_applications WHERE name = 'NIBG'"));

  db_set_active('data');

  // Get aut id of the group 'ACADEMIA.group'
  $aut_group_id = db_result(db_query("SELECT aut_group_id FROM {aut_group} WHERE app_id = %d AND aut_group_name = 'ACADEMIA.group'", $app_id));

  $aut_group_id_to_add = db_result(db_query("SELECT aut_group_id FROM {aut_group} WHERE app_id = %d AND aut_group_name = '@ACADEMIA.group'", $app_id));

  $offset = 0;
  $limit = 1000;

  while (TRUE) {
    $db_result = db_query("SELECT * FROM {aut_object} WHERE aut_type = 'GROUP' AND aut_id = %d ORDER BY aut_object_id LIMIT %d OFFSET %d", $aut_group_id, $limit, $offset);

    if (!db_affected_rows()) {
      break;
    }

    while ($dbrow = db_fetch_array($db_result)) {
      // Make sure the link does not exits
      if (!db_result(db_query("SELECT COUNT(*) FROM {aut_object} WHERE aut_object_type = '%s' AND aut_object_id = '%s' AND aut_type = '%s' AND aut_id = %d", $dbrow['aut_object_type'], $dbrow['aut_object_id'],  $dbrow['aut_type'], $aut_group_id_to_add))) {
        db_query("INSERT INTO {aut_object} SET aut_object_type = '%s', aut_object_id = '%s', aut_type = '%s', aut_id = %d", $dbrow['aut_object_type'], $dbrow['aut_object_id'],  $dbrow['aut_type'], $aut_group_id_to_add);
      }

      // No need to change 'is_protected' on mediafile, because its already on DOMAIN_REALM.
    }

    $offset += $limit;
  }

  db_set_active();

  return $ret;
}
?>