function biblio_update_6015 in Bibliography Module 6.2

Same name and namespace in other branches

1. 6 biblio.install \biblio_update_6015()

Update ...

This update function ...

Return value

array An array of associative arrays with 'success' and 'query' keys.

File

./biblio.install, line 2242

Install, update, and uninstall functions for the biblio module.

Code

function biblio_update_6015() {
  require_once drupal_get_path('module', 'biblio') . '/includes/biblio.keywords.inc';
  $result = array();
  if ($vid = variable_get('biblio_freetagging_vocab', 0)) {
    variable_set('biblio_keyword_vocabulary', $vid);
  }
  variable_del('biblio_freetagging_vocab');
  $result[] = update_sql("ALTER TABLE {biblio_keyword_data} MODIFY COLUMN kid INTEGER UNSIGNED NOT NULL AUTO_INCREMENT");
  $db_result = db_query('SELECT t.nid, t.vid, td.name as biblio_keywords FROM {term_node} t left join {term_data} td on t.tid=td.tid where td.vid=%d', variable_get('biblio_keyword_vocabulary', -1));
  $count = 0;
  while ($node = db_fetch_object($db_result)) {
    biblio_insert_keywords($node, TRUE);
    $count++;
  }
  $result[] = array(
    'success' => TRUE,
    'query' => "Copied {$count} keywords to the new database stucture from taxonomy",
  );
  $count = 0;
  $db_result = db_query('SELECT nid,vid,biblio_keywords FROM {biblio} where biblio_keywords != "" ');
  while ($node = db_fetch_object($db_result)) {
    biblio_insert_keywords($node, TRUE);
    $count++;
  }
  $result[] = array(
    'success' => TRUE,
    'query' => "Moved " . $count . " keywords to the new database stucture",
  );
  db_drop_field($result, 'biblio', 'biblio_keywords');
  return $result;
}